• Best location

  • Urban estate 2,Hisar, Hisar Cantt
    By Pooja properties

    Location Map


    80 L
    @ Rs 5.33 K per Sq.ft.
    • Property ID:

      :

      REI847075

    • Property For

      :

      Sale

    • Built Up Area

      :

      1500 Sq.ft. ▼
    • Carpet Area

      :

      1500 Sq.ft. ▼
    Send Enquiry

Additional Details
  • Transaction : Resale Property
  • Bedrooms : 3
  • Bathrooms : 2
  • No. of Floors : 2
  • Property On Floor : Ground


Amenities
  • Power Back Up
  • Reserved Parking
  • Security



Property Description

Park facing +North facing very nice location

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_179.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.0025606024{main}( ).../responsive-catalog-property-detail.php:0
21.52962357208rei_db_query( ).../responsive-catalog-property-detail.php:2065
31.52962359600query ( ).../func-mysql.php:124
1 - Can't create/write to file '/tmp/#sql_3ffb_179.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!='847075' and pl.city='957' and pl.propertyfor='1' and pl.status IN ('0', '1') order by rand() limit 0, 6

[TEP STOP]