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_postmeta` wm2 ON (wm2.`post_id` = wp.`ID`)INNER JOIN `wp_term_relationships` wtr9 ON (wp.`ID` = wtr9.`object_id`) INNER JOIN `wp_term_taxonomy` wtt9 ON (wtr9.`term_taxonomy_id` = wtt9.`term_taxonomy_id`) INNER JOIN `wp_terms` wt9 ON (wt9.`term_id` = wtt9.`term_id`) WHERE wp.post_type = 'properties' AND wp.post_status = 'publish' AND ( ( wmpr.meta_key = 'proprating' ) AND ( wm2.meta_key = 'pbedrooms' AND wm2.meta_value = '4' ) AND ( wtt9.taxonomy = 'housetype' AND wt9.`name` IN ('Apartment') ) 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
3 Properties
For Rent
Apartment
4 BHK

4 BHK Apartment for Rent Miramar, Panaji-Goa

By: Owner 16 Jul 2016

4 BHK Residential Apartment for Rent in CREC Casa Del Sol, 145/155, Miramar, Panaji-Goa with area 40 ...

4 BHK Apartment for Rent Miramar, Panaji-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. 100000 / Month

4BHK Apartment
Area: 371 Sq Mt / 4000 Sq Ft
Location: Miramar, Panaji

4 BHK Apartment for Rent in Mapusa - North Goa

By: Owner 15 Jul 2016

4 Bedroom Apartment for Rent in Mapusa - North Goa with area 1250 sqft on the ground floor having 4 ...

4 BHK Apartment for Rent in Mapusa - North 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: 116 Sq Mt / 1250 Sq Ft
Location: Mapusa

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

Sign Up

   
   
   
   

Requirement Form

Please select a Requirement Type

Buy  Rent / Lease  Resources