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.id,a.title,a.opt_price,a.video,a.price,a.id_cat,p.url FRoM ann_categories c,ann_photos p left join ann_annonces a on a.id=p.id_ann 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 a.id order by p.date desc limit 8Erreur #6006 - Please contact site administrator Find Grand 3BHK Flats & Villas @9250002253 | ATS Pristine Phase 2 India Way2ad.net 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 Way2ad.net 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.


Close
Find Grand 3BHK Flats & Villas @9250002253 | ATS Pristine Phase 2Ad id: 14150 | Views : 15
Price : INR 10275000
Date listed : 2018-05-01
Area : New Delhi
close X

A breathtaking 3BHK in 1750 sq.ft residential project of ATS Pristine Phase 2 in Noida provides always fantastic natural panorama all over the residential location. ATS Pristine Sector 150 Noida launching villas also as well as luxury apartments.

Amenities: 

·         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: 9250002253

Visit: http://www.atspristine.org.in/

 

 


images_upload/1525170786.jpg
images_upload/1525170786.jpg images_upload/1525170793.jpg




Contact poster
Your email


Your name


Your message (how to avoid scammers?)


Verification







advanced search


Search forexact phrase
Category
Area
Price INR to
With Photo

Change city


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