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`= 'kadamba-plateau') AND wm1.meta_key = 'sale_type' AND wm1.meta_value like '%Rent%' ) GROUP BY wp.ID ORDER BY wp.post_date DESC limit 0 , 20
4 Properties
For Rent
Kadamba Plateau

3 bhk Residential Apartment for Rent in Milroc,Kadamba-Goa

By: Owner 11 Dec 2015

3 bhk Residential Apartment for Rent in Milroc,Kadamba-Goa with area 150 sqmts on the 4th floor with ...

3 bhk Residential Apartment for Rent in Milroc,Kadamba-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. 45000 / Month

3BHK Apartment
Area: 150 Sq Mt / 1614 Sq Ft
Location: Kadamba Plateau

2 BHK Flat for Rent at Milroc Kadamba Plateau -Goa

By: Owner 20 Jul 2015

2 BHK Flat for Rent with area 115.90 sqmts facing the pool at Milroc Kadamba is a premium residentia ...

2 BHK Flat for Rent at Milroc 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. 30000 / Month

2BHK Apartment
Area: 115.90 Sq Mt / 1247 Sq Ft
Location: Kadamba Plateau

2 BHK Flat for rent in Milroc Kadamba,Goa

By: Owner 07 Jun 2015

2 BHK Flat for rent in Milroc Kadamba,Goa on the 4th floor on Panjim-Old Goa bypass,Families preferr ...

2 BHK Flat for rent in Milroc Kadamba,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. 15000 / Month

2BHK Apartment
Area: Sq Mt / 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