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

Locality

I Want to

Property Type

Budget

Bedroom


6 BHK Individual Houses / Villas for in Sarai Hakimpur

Find Residential & Commercial Property in Sarai Hakimpur Aligarh. Pranav Properties is providing Aligarh Sarai Hakimpur Properties Sell Rent Classifieds database . Contact with us for instant Buy sell Individual Houses / Villas, Office Space, Flats & Apartments, Residential Plot, Farm House, Commercial Shops, Factory / Industrial Building, Penthouse, Hotel & Restaurant, Commercial Lands /Inst. Land, Builder Floor, Showrooms, 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 bedrooms=6 and sub_cat=9 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='702143' and pl.status IN ('0', '1') and (sub_city=19355 or city=19355) and propertyfor= and bedrooms=6 and sub_cat=9 order by pl.property_id desc

[TEP STOP]