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

2 bhk Apartment for Sale in Bicholim-Goa

By: Owner 17 Jun 2015

2 bhk Apartment for Sale in Bicholim-Goa,fully furnished with area 92.5 sqmts with parking on the 2n ...

2 bhk Apartment for Sale in Bicholim-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. 38.75 Lacs

2BHK Apartment
Area: 92.5 Sq Mt / 995.3 Sq Ft
Location: Bicholim

Brand new 2Bhk Apartment for sale at Sanquelim,Bicholim - Goa

By: Agent/Broker 17 Jun 2015

Brand new 2Bhk Apartment for sale at Sanquelim, Bicholim- Goa, with area 85 sqmts on 1st floor, nego ...

Brand new 2Bhk Apartment for sale at Sanquelim,Bicholim - 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. 35 Lacs

2BHK Apartment
Area: 85 Sq Mt / 914 Sq Ft
Location: Bicholim

NA Plot for Sale with House at Velguem,Pale,Bicholim - Goa

By: Owner 04 Jun 2015

NA Plot for Sale at Velguem,Pale,Bicholim - Goa with area 715 sqmts NA Plot having a house built up ...

NA Plot for Sale with House at Velguem,Pale,Bicholim - 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. 32 Lacs

Apartment
Area: 715 Sq Mt / 7694 Sq Ft
Location: Bicholim

2 BHK Flat for Rent in Bicholim

By: Owner 26 Feb 2015

2 BHK Flat for Rent in Bicholim, Area 74 sq mtr. Unfurnished, Near Market circle

2 BHK Flat for Rent in Bicholim

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

2BHK Apartment
Area: 74 Sq Mt / 796.24 Sq Ft
Location: Bicholim

Fully Furnished 3 bhk flat for sale in Bicholim

By: Owner 14 Nov 2014

3 BHK with good interior beautifull location, 92.9 sqmt, 4 balconies kitchen dining hall one attache ...

Fully Furnished 3 bhk flat for sale in Bicholim

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

3BHK Apartment
Area: 92.9 Sq Mt / 1000 Sq Ft
Location: Bicholim

Sign Up

   
   
   
   

Requirement Form

Please select a Requirement Type

Buy  Rent / Lease  Resources