Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'way2ad_indiaclass.p.url' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_byQuery:SELECT c.category,,a.title,a.opt_price,,a.price,a.id_cat,p.url FRoM ann_categories c,ann_photos p left join ann_annonces a on WHERE a.publi=1 and a.id_cat=c.id_cat AND a.`id` IN (SELECT id_ann FROM ann_ad_city WHERE id_city = 1) group by order by desc limit 8Erreur #6006 - Please contact site administrator Stunning 3BHK Apartments @9278057805 In ATS Pristine Phase 2 Noida India Classifieds
Other cities: Delhi, Noida, Pune, Mumbai, Hyderabad, Lucknow, Goa, Shillong, Kolkata, Gurgaon, Dehradun, Guwahati, Surat, Chandigarh, Bhubaneswar, Nashik, Lucknow, Indore, Chennai, Coimbatore, Madurai, Ludhiana, Jaipur, Kochi, Nagpur, Kanpur, Tamil Nadu, Kerala, Karnataka, Jharkhand, Haryana, Gujarat, Himachal Pradesh, Uttaranchal, Manipur

How to avoid scams and fraud

You are about to contact the poster. To avoid scammers please follow these common-sense rules:

1/ Deal locally with people you can meet in person.

2/ Never wire funds via Western union or any other wire service.

3/ India Classifieds is not involved in any transaction, and does not handle payments, guarantee transactions, or offer 'buyer protection' or 'seller certification'.

4/ Never give out financial information (bank account number, social security number, eBay/PayPal info, etc.)

5/ Avoid deals involving shipping or escrow services.

Stunning 3BHK Apartments @9278057805 In ATS Pristine Phase 2 NoidaAd id: 14783 | Views : 20
Price : INR 10275000
Date listed : 2018-06-05

ATS Pristine Phase 2 available at the flawless destination and modern houses in Sector 150 Noida by ATS Group. The most striking 3BHK apartments at this residential project offer your daily necessities what you require and want for your life as well. ATS Group is also launching ATS Pristine Villas in this luxury project. It has been spread in 1750 sq. ft and price available from 1* Cr.


·         100% Power Backup

·         2 Basement Car Parking

·         Low-density development project

·         Surrounded by major corporate, educational hub

·         Nestled in proximity State-of-the-art sports facilities

Project Details:

·         Project Name: ATS Pristine

·         Location: Sector 150 Noida

·         3 BHK Apartments

·         Size: 1750 sq. ft.

·         Price: 1 Cr*

Contact Details for Booking Now:

·         Call: 9278057805



Contact poster
Your email

Your name

Your message (how to avoid scammers?)


advanced search

Search forexact phrase
Price INR to
With Photo

Change city

Help | About | Dubai Classifieds | Privacy Policy | Contact us | Copyright 2008-17 |
web counter
web counter Webutation