Raise your Query

Hi! Simply click below and type your query.

Our experts will reply you very soon.

WhatsApp Us
Search Property

Search Properties

Where in

I Want to

Property Type

Budget

Bedroom


3 BHK Flats & Apartments for in Sarai Hakimpur

Find Residential & Commercial Property in Sarai Hakimpur Aligarh. Prime Properties is providing Aligarh Sarai Hakimpur Properties Sell Rent Classifieds database . Contact with us for instant Buy sell Showrooms, Hotel & Restaurant, Office Space, Residential Plot, Commercial Lands /Inst. Land, Individual Houses / Villas, Flats & Apartments, Agricultural/Farm Land, Builder Floor, Commercial Shops, Warehouse/Godown, Factory / Industrial Building, Farm House, Banquet Hall & Guest House, Industrial Land / Plot.


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

[TEP STOP]