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` wtr11 ON (wp.`ID` = wtr11.`object_id`) INNER JOIN `wp_term_taxonomy` wtt11 ON (wtr11.`term_taxonomy_id` = wtt11.`term_taxonomy_id`) INNER JOIN `wp_terms` wt11 ON (wt11.`term_id` = wtt11.`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 ( wtt11.taxonomy = 'gp4u_type' AND wt11.`name`= 'Commercial' ) ) GROUP BY wp.ID ORDER BY wp.post_date DESC limit 0 , 20
4 Properties
Bicholim

River Touching plot for sale in Pilgaon,Bicholim-Goa

By: Owner 29 Aug 2015

River Touching property for sale in Pilgaon,Bicholim-Goa with river view,Tar road access, clear titl ...

River Touching plot for sale in Pilgaon,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. 8.4 Crore

Plot-Land
Area: 105000 Sq Mt / 1129800 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

Agriculture Plot for sale in Bicholim - Goa

By: Owner 04 Jun 2015

1000 sq property for sale in Bicholim goa 2km from bus stand and market.. orchid zone price 3500 non ...

Agriculture Plot 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. 35 Lacs

Plot-Land
Area: 1000 Sq Mt / 10760 Sq Ft
Location: Bicholim

Plot for sale in Pilgao,Bicholim-Goa

By: Owner 01 Nov 2014

Plot for sale in Pilgao,Bicholim-Goa with area 400 sqmt,Old Settlement Plot,Near Ideal School @Rate ...

Plot for sale in Pilgao,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. 12 Lacs

Plot-Land
Area: 400 Sq Mt / 4304 Sq Ft
Location: Bicholim

Sign Up

   
   
   
   

Requirement Form

Please select a Requirement Type

Buy  Rent / Lease  Resources