Freehold Plots available in a single gate colony.

    • Freehold Plots available in a single gate colony.

    • Freehold Plots available in a single gate colony.

    • Freehold Plots available in a single gate colony.

  • Sun City Colony, Behind Greenland Public School, Rohta Road, Meerut
    By Manav Properties And Real Estate

    Location Map


    • Property ID:

      :

      REI702523

    • Property For

      :

      Sale

    • Society Name

      :

      Sun City

    • Land / Plot Area

      :

      112 Sq. Yards ▼
    Send Enquiry

Additional Details
  • Bathrooms : 2



Property Description

Plots available in 90 to 225 sq yard sizes at an attractive location. Single gated community with all basic amenities. 4km far from City Railway Station and 800 meters away from National Highway 58. 2 km far from upcoming outer ring road Meerut.

Mr. Dheeraj Sharma

impdheeraj@gmail.com

+91-9319422225, +91-9350637795

Property by City

Meerut (38)

( ! ) Warning: mysqli::query(): (HY000/1): Can't create/write to file '/tmp/#sql_3ffb_51.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.0024605992{main}( ).../responsive-catalog-property-detail.php:0
22.31642360800rei_db_query( ).../responsive-catalog-property-detail.php:2065
32.31642363192query ( ).../func-mysql.php:124
1 - Can't create/write to file '/tmp/#sql_3ffb_51.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='1167466' and pl.property_id!='702523' and pl.city='4369' and pl.propertyfor='1' and pl.status IN ('0', '1') order by rand() limit 0, 6

[TEP STOP]