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
4 Properties
Verna
Apartment

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 ...

Property Contact

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

By: Owner 28 May 2015

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

Property Contact

Brand new 2bhk flat 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. 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, ...

Property Contact

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 ...

Property Contact

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

Filter
New
Projects
Reading List View Requirements Get a QuoteNew Home ValuationNew

Requirement Form

Please select a Requirement Type

Buy  Rent / Lease  Resources

Area Convertor











Stamp Duty



Advice

Contact Us

Name

Email

Mobile

Message

Sign Up

   
   
   
   

Requirement Form

Please select a Requirement Type

Buy  Rent / Lease  Resources