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_postmeta` wm2 ON (wm2.`post_id` = wp.`ID`) WHERE wp.post_type = 'properties' AND wp.post_status = 'publish' AND ( ( wmpr.meta_key = 'proprating' ) AND ( wm2.meta_key = 'pbedrooms' AND wm2.meta_value = '4∝erty-type=Apartment' ) AND wm1.meta_key = 'sale_type' AND wm1.meta_value like '%Buy%' ) GROUP BY wp.ID ORDER BY wp.post_date DESC limit 0 , 20
0 Properties
For Sale
4∝erty-type=Apartment BHK

Sign Up

   
   
   
   

Requirement Form

Please select a Requirement Type

Buy  Rent / Lease  Resources