Raise your Query

Hi! Simply click below and type your query.

Our experts will reply you very soon.

Need Help? Chat with us
URBAN NEST ASSOCIATE
Search Property

Search Properties

Where in

Locality

I Want to

Property Type

Budget

Bedroom


Flats & Apartments for in Sarai Hakimpur

Find Residential & Commercial Property in Sarai Hakimpur Aligarh. URBAN NEST ASSOCIATE is providing Aligarh Sarai Hakimpur Properties Sell Rent Classifieds database . Contact with us for instant Buy sell Flats & Apartments, Agricultural/Farm Land, Residential Plot, Industrial Land / Plot, Farm House, Office Space, Individual Houses / Villas, Factory / Industrial Building, Commercial Lands /Inst. Land.


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

[TEP STOP]