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`) WHERE wp.post_type = 'properties' AND wp.post_status = 'publish' AND ( ( wmpr.meta_key = 'proprating' ) AND ( wtt2.taxonomy = 'city_location' AND wt2.`slug`= 'corlim') 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
2 Properties
For Sale
Corlim

Building with 4 Flats of 2 BHK for sale in Corlim - Goa

By: Owner 08 Aug 2015

Building for Sale in Corlim with Plot area 397 sqm , Build up area 292 , Ground+1 building, each fl ...

Building with 4 Flats of 2 BHK for sale in Corlim - 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. 2.65 Crore

2BHK Apartment
Area: 292 Sq Mt / 3141.92 Sq Ft
Location: Corlim

2 BHK for Sale in Corlim-Old Goa

By: Owner 07 Mar 2015

2 BHK brand new flat for sale on the upper ground floor with parking and area 78 sq.mts

2 BHK for Sale in Corlim-Old 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. 33 Lacs

2BHK Apartment
Area: 78 Sq Mt / 839 Sq Ft
Location: Corlim, Old Goa

Sign Up

   
   
   
   

Requirement Form

Please select a Requirement Type

Buy  Rent / Lease  Resources