Search Properties

Where in

Locality

I Want to

Property Type

Budget

Bedroom

1 BHK

2 BHK

3 BHK

4 BHK

5 BHK

6 BHK

1 RK

Commercial Lands & Plots for in Sarai Hakimpur

Find Residential & Commercial Property in Sarai Hakimpur Aligarh. Taneja Realtors Pvt. Ltd. is providing Aligarh Sarai Hakimpur Properties Sell Rent Classifieds database . Contact with us for instant Buy sell Flats & Apartments, Commercial Shops, Residential Land / Plot, Builder Floor, Farm House, Hotel & Restaurant, Bungalows / Villas, Serviced Apartments, Business Center, Showrooms, Industrial Land / Plot, Office Space, Commercial Lands & Plots, Individual House/Home, Warehouse/Godown.

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 sub_cat=27 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='342230' and pl.status IN ('0', '1') and (sub_city=19355 or city=19355) and propertyfor= and sub_cat=27 order by pl.property_id desc

[TEP STOP]