• Coming Soon Property

  • NEAR SEC. 1 & 4, Sector 5 Hisar
    By Pooja properties

    Location Map


    38 L
    @ Rs 23535 per Sq. Yards
    • Property ID:

      :

      REI853186

    • Property For

      :

      Sale

    • Land / Plot Area

      :

      161.46 Sq. Yards ▼
    Send Enquiry

Additional Details
  • Transaction : Resale Property



Property Description

BEST LOCATION BETTER FACILITY

Mr. Bhupender Soni

9416139696

Property by City

Hisar (108) Gurgaon (9) Faridabad (9) Bahadurgarh (5) Mohali (1)

( ! ) Warning: mysqli::query(): (HY000/1): Can't create/write to file '/tmp/#sql_3ffb_75.MYI' (Errcode: 28 - No space left on device) in /home/realestate/realestateindia.com/htdocs/Functions/func-mysql.php on line 124
Call Stack
#TimeMemoryFunctionLocation
10.0023605928{main}( ).../responsive-catalog-property-detail.php:0
20.79732355256rei_db_query( ).../responsive-catalog-property-detail.php:2065
30.79732357648query ( ).../func-mysql.php:124
1 - Can't create/write to file '/tmp/#sql_3ffb_75.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='1213243' and pl.property_id!='853186' and pl.city='957' and pl.propertyfor='1' and pl.status IN ('0', '1') order by rand() limit 0, 6

[TEP STOP]