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`= 'verna') AND ( wtt11.taxonomy = 'gp4u_type' AND wt11.`name`= 'Commercial' ) ) GROUP BY wp.ID ORDER BY wp.post_date DESC limit 0 , 20
3 Properties
Verna

Industrial Shed in Verna Industrial Estate-Goa

By: Owner 24 Feb 2016

Brand new Industrial Building Shed Warehouse Godown Factory for lease rent available immediately! Pr ...

Industrial Shed in Verna Industrial Estate-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

Price : N/A

Commercial Space , Godown , Industrial Shed
Area: 6320 Sq Mt / 68000 Sq Ft
Location: Verna

Warehouse for rent at Verna Industrial Estate-Goa

By: Owner 24 Feb 2016

Warehouse for rent at Verna Industrial Estate-Goa with area 425 sq mt area full RCC constructed with ...

Warehouse for rent at Verna Industrial Estate-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

Commercial Space , Industrial Shed
Area: 425 Sq Mt / 4573 Sq Ft
Location: Verna

150 sqmt RCC Shed for Rent in Verna Industrial Estate

By: Owner 10 Nov 2014

RCC Shed for Rent in Verna Industrial Estate, 150 sqmt, Ideal for Storage, Godown

150 sqmt RCC Shed for Rent in Verna Industrial Estate

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

Godown
Area: 150 Sq Mt / 1614 Sq Ft
Location: Verna

Sign Up

   
   
   
   

Requirement Form

Please select a Requirement Type

Buy  Rent / Lease  Resources