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`= 'merces') 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
5 Properties
For Rent
Merces

4 BHK Apartment for Rent in Merces - Goa

By: Owner 10 Jul 2016

4 Bedroom Residential Apartment for Rent in Milroc Temple Towers, Merces Chimbel Road, Near Shantaba ...

4 BHK Apartment for Rent in Merces - 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. 25000 / Month

4BHK Apartment
Area: 202 Sq Mt / 2173 Sq Ft
Location: Merces

1 BHK for Rent in Curca,Merces-Goa - Rented Out

By: Owner 07 Feb 2016

1 BHK for Rent in Curca,Merces-Goa on the 1st floor @ Rs.5,000/- monthly near the bridge

1 BHK for Rent in Curca,Merces-Goa - Rented Out

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. 5000 / Month

1BHK Apartment
Area: Sq Mt / Sq Ft
Location: Merces

2 BHK Flat for rent in Chimbel,Merces-Goa

By: Owner 07 Feb 2016

2 BHK Flat for rent in Chimbel,Merces-Goa fully furnished with 2 bathrooms near Kinara Bar and Restu ...

2 BHK Flat for rent in Chimbel,Merces-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. 12000 / Month

2BHK Apartment
Area: Sq Mt / Sq Ft
Location: Chimbel, Merces

Shop on Rent in Curca,Merces-Goa

By: Owner 21 Sep 2015

Shop on Rent in Curca, Merces-Goa with area 24 sqmts In Traveller's Inn, fully furnished ,facing th ...

Shop on Rent in Curca,Merces-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. 7000 / Month

Shop
Area: 24 Sq Mt / 258.24 Sq Ft
Location: Merces

Shop on Rent in Curca,Merces-Goa (Rented out )

By: Owner 18 Oct 2014

Shop on Rent in Curca, Merces-Goa with area 24 sqmts In Traveller's Inn,Unfurnished and unused

Shop on Rent in Curca,Merces-Goa (Rented out )

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. 7000 / Month

Shop
Area: 24 Sq Mt / 258.24 Sq Ft
Location: Merces

Sign Up

   
   
   
   

Requirement Form

Please select a Requirement Type

Buy  Rent / Lease  Resources