Properties In Goa

Searching for real estate properties in goa to buy, sale or rent - Choose from wide range of properties at goaproperty4u.com - Goa's read more
SELECT *, CAST(wmpr.meta_value AS SIGNED) as proprating FROM `wp_posts` wp INNER JOIN `wp_postmeta` wmpr ON (wmpr.`post_id` = wp.`ID`) INNER JOIN `wp_postmeta` wm1 ON (wm1.`post_id` = wp.`ID`) INNER JOIN `wp_term_relationships` wtr2 ON (wp.`ID` = wtr2.`object_id`) INNER JOIN `wp_term_taxonomy` wtt2 ON (wtr2.`term_taxonomy_id` = wtt2.`term_taxonomy_id`) INNER JOIN `wp_terms` wt2 ON (wt2.`term_id` = wtt2.`term_id`)INNER JOIN `wp_term_relationships` wtr11 ON (wp.`ID` = wtr11.`object_id`) INNER JOIN `wp_term_taxonomy` wtt11 ON (wtr11.`term_taxonomy_id` = wtt11.`term_taxonomy_id`) INNER JOIN `wp_terms` wt11 ON (wt11.`term_id` = wtt11.`term_id`) WHERE wp.post_type = 'properties' AND wp.post_status = 'publish' AND ( ( wmpr.meta_key = 'proprating' ) AND ( wtt2.taxonomy = 'city_location' AND wt2.`slug`= 'quepem') AND ( wtt11.taxonomy = 'gp4u_type' AND wt11.`name`= 'Commercial' ) ) GROUP BY wp.ID ORDER BY wp.post_date DESC limit 0 , 20
1 Properties
Quepem

Plot for sale in Shirvoi, Quepem-Goa

By: Agent/Broker 09 Oct 2014

Plot for Sale in Shirvoi, Quepem-Goa with area: 355 sqmt.,Fully Compounded @ Price Rs. 20 Lakhs

Plot for sale in Shirvoi, Quepem-Goa

Interested? Get owner details. We hide the owner details in the interest of their privacy. Please fill the form below to view their contact info

Rs. 20 Lacs

Plot-Land
Area: 355 Sq Mt / 3819.8 Sq Ft
Location: Quepem

Sign Up

   
   
   
   

Requirement Form

Please select a Requirement Type

Buy  Rent / Lease  Resources