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` 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 ( wtt2.taxonomy = 'city_location' AND wt2.`slug`= 'verna') AND ( wtt9.taxonomy = 'housetype' AND wt9.`name` IN ('Apartment') ) ) GROUP BY wp.ID ORDER BY wp.post_date DESC limit 0 , 20
5 Properties
Verna
Apartment

2 BHK Apartment for Rent at Verna-Goa

By: Owner 13 Feb 2016

Brandnew 2 BHK Apartment for Rent at Verna-Goa with area 85sqmts with 3 bath rooms, drawing Room, K ...

2 BHK Apartment for Rent at Verna-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

2BHK Apartment
Area: 85 Sq Mt / 1100 Sq Ft
Location: Verna

2 floor Building for sale in Verna-Goa

By: Owner 31 Aug 2015

2 floor Building for sale in Verna-Goa with area 277 sqmts and built up area 238 sqmts, 7 years old ...

2 floor Building for sale in Verna-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.1 Crore

2BHK Apartment , Shop
Area: 238 Sq Mt / 2560.88 Sq Ft
Location: Verna

Brand new 2bhk flat for rent at Verna - Goa - Rented out

By: Owner 28 May 2015

Brand new 2bhk flat for rent at Verna - Goa,unfurnished. Just 5 mins away from Verna Industrial Esta ...

Brand new 2bhk flat for rent at Verna - 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. 9500 / Month

2BHK Apartment
Area: Sq Mt / Sq Ft
Location: Verna

Luxury Apartment for sale at Verna- Goa

By: Owner 17 May 2015

2 BHK Luxury Apartment for sale at Verna- Goa , semi furnished with 24/7 backup generator, parking, ...

Luxury Apartment for sale at Verna- 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. 40 Lacs

2BHK Apartment
Area: Sq Mt / Sq Ft
Location: Verna

1 BHK Flat for Rent in Verna

By: Owner 05 Nov 2014

1 BHK Flat for Rent in Verna, 60 sqmt on the 1st floor of the House, Fully Furnished with Chairs & T ...

1 BHK Flat for Rent in Verna

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

1BHK Apartment
Area: 60 Sq Mt / 645.6 Sq Ft
Location: Verna

Sign Up

   
   
   
   

Requirement Form

Please select a Requirement Type

Buy  Rent / Lease  Resources