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

Plot for sale at Kadamba Plateau-Goa

By: Builder 24 Oct 2015

Plot for sale at Kadamba Plateau,Bainguinim Village-North Goa with area 3600 sqmts (this is area a ...

Plot for sale at Kadamba Plateau-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

Price : N/A

Plot-Land
Area: 3600 Sq Mt / 38736 Sq Ft
Location: Kadamba Plateau

Plot for sale at Kadamba Plateau-Goa

By: Builder 24 Oct 2015

Plot for sale at Kadamba Plateau,Bainguinim Village-North Goa with area 4000 sqmts adjacent to Sun ...

Plot for sale at Kadamba Plateau-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

Price : N/A

Plot-Land
Area: 4000 Sq Mt / 43040 Sq Ft
Location: Kadamba Plateau

Commercial premises at Kadamba Plateau Goa

By: Owner 25 Oct 2014

Commercial premises at Kadamba Plateau, Panaji. 180 sqmt + Mezanine, 3 Big Shops ( Ideal for Showroo ...

Commercial premises at Kadamba Plateau 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. 110000 / Month

Shop
Area: 180 Sq Mt / 1936.8 Sq Ft
Location: Kadamba Plateau

Sign Up

   
   
   
   

Requirement Form

Please select a Requirement Type

Buy  Rent / Lease  Resources