• Coming Soon Property

  • Location Map

    • Property ID:



    • Property For



    • Location



    • Land / Plot Area


      416 Sq. Meter ▼
    Send Enquiry

Property Description

Its a Industrial Land Avilable for Sale Size 416 Sqr Mtr in Hand Gud Option for Self Use N Investment .or More Details Get2 Contacts Us.

Manish Kurra and Rajan Khurana


+91-9711004349, +91-9811588484

Property by City

( ! ) Warning: mysqli::query(): (HY000/1): Can't create/write to file '/tmp/#sql_3ffb_635.MYI' (Errcode: 28 - No space left on device) in /home/realestate/realestateindia.com/htdocs/Functions/func-mysql.php on line 124
Call Stack
10.0021606376{main}( ).../responsive-catalog-property-detail.php:0
22.19972340360rei_db_query( ).../responsive-catalog-property-detail.php:2065
32.19972342752query ( ).../func-mysql.php:124
1 - Can't create/write to file '/tmp/#sql_3ffb_635.MYI' (Errcode: 28 - No space left on device)

select plt.cat_property_title, plt.title, pl.sub_city, pl.city, pl.state_id, pl.area, pl.areaunit, pl.landarea, pl.landunit, pl.catpetarea, pl.carpetunits, pl.bedrooms, pl.bathrooms, pl.price, pl.property_id, pl.member_id, pl.sub_cat, pl.cat_id, plt.floor, plt.catalog_file_nm, plt.prop_desc from property_listing as pl, property_listing_trans as plt where pl.property_id = plt.property_id and pl.member_id='186015' and pl.property_id!='599037' and pl.city='4422' and pl.propertyfor='1' and pl.status IN ('0', '1') order by rand() limit 0, 6