919845076840 919845076840
Search Property

Search Properties

Where in

Locality

I Want to

Property Type

Budget

Bedroom


2 BHK Flats & Apartments for in Sarai Hakimpur

Find Residential & Commercial Property in Sarai Hakimpur Aligarh. Square Feet Realtors is providing Aligarh Sarai Hakimpur Properties Sell Rent Classifieds database . Contact with us for instant Buy sell Residential Land / Plot, Individual House/Home, Flats & Apartments, Commercial Lands & Plots, Farm Land, Builder Floor, Office Space, Warehouse/Godown, Commercial Shops, Industrial Land / Plot, Showrooms, Factory, Penthouse, Hotel & Restaurant, Studio Apartments, Business Center, Banquet Hall & Guest House.


1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and bedrooms=2 and sub_cat=8 order by pl.property_id desc' at line 1

select * from property_listing as pl, property_listing_trans as plt where pl.property_id = plt.property_id and pl.member_id='12537' and pl.status IN ('0', '1') and (sub_city=19355 or city=19355) and propertyfor= and bedrooms=2 and sub_cat=8 order by pl.property_id desc

[TEP STOP]