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`= 'colva') AND ( wtt11.taxonomy = 'gp4u_type' AND wt11.`name`= 'Commercial' ) ) GROUP BY wp.ID ORDER BY wp.post_date DESC limit 0 , 20
3 Properties
Colva

Residential Plot for Sale in Colva, South Goa

By: Owner 05 Aug 2016

Residential Land for Sale in Colva, South Goa with area 607 sqmts @ Rs 1.09 Cr

Residential Plot for Sale in Colva, South 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. 1.09 Crore

Plot-Land
Area: 607 Sq Mt / 6531 Sq Ft
Location: Colva

Residential Land for Sale in Colva, South Goa

By: Owner 05 Aug 2016

Residential Land for Sale in Colva, South Goa with plot area 600 Sq. Meter @ Price ₹ 1.08 Crore

Residential Land for Sale in Colva, South 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. 1.08 Crore

Plot-Land
Area: 600 Sq Mt / 6456 Sq Ft
Location: Colva

Double height Shop in Colva

By: Owner 13 Oct 2014

Double Height Shop for Sale in Colva. 25 sqmt. Fully Furnished

Double height Shop in Colva

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. 38 Lacs

Shop
Area: 25 Sq Mt / 269 Sq Ft
Location: Colva

Sign Up

   
   
   
   

Requirement Form

Please select a Requirement Type

Buy  Rent / Lease  Resources