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` wtr9 ON (wp.`ID` = wtr9.`object_id`) INNER JOIN `wp_term_taxonomy` wtt9 ON (wtr9.`term_taxonomy_id` = wtt9.`term_taxonomy_id`) INNER JOIN `wp_terms` wt9 ON (wt9.`term_id` = wtt9.`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`= 'saligao-calangute') AND ( wtt9.taxonomy = 'housetype' AND wt9.`name` IN ('Apartment') ) ) GROUP BY wp.ID ORDER BY wp.post_date DESC limit 0 , 20
1 Properties
Saligao
Apartment

1BHK Flat for Sale in Saligao Goa

By: Agent/Broker 16 Oct 2014

1 Bhk 79sqmt. flat for Sale in Saligao on the 2nd floor (2-3yrs old), Semi-furnished,with toilet-ba ...

1BHK Flat for Sale in Saligao 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. 45 Lacs

1BHK Apartment
Area: 79 Sq Mt / 850 Sq Ft
Location: Saligao

Sign Up

   
   
   
   

Requirement Form

Please select a Requirement Type

Buy  Rent / Lease  Resources