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 Call For Residential Flats in Noida_9278057805 @Sa 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
Call For Residential Flats in Noida_9278057805 @SaAd id: 13311 | Views : 33
Price : INR 4302000
Date listed : 2018-04-09
Area : North Delhi
close X

Samridhi Group launched luxury residential apartments in Noida by the name Smaridhi Luxuriya Avenue. Samridhi Luxuriya Avenue Noida has offering 2&3BHK residential apartments on unmatches location of Noida. Samridhi Luxuriya Avenue Price List starts from 40.25 lacs* and land area starts from 1165 sq. ft.

Amenities:

·         Under RERA Guidelines

·         24/7 Power Supply

·         24/7 Water Supply

·         24/7 Security

·         Party Lawn

·         Fitness Club

·         Sports grounds

·         Community Club

·         Swimming Pools

·         Jogging Trail

Project Details:

·         Project Name: Samridhi Luxuriya Avenue

·         Location: Sector 150 Noida

·         Apartment Size: 1165-1690 sq. ft.

·         Price: 40.25-58.40 lacs*

Contact Detail:

·         Call: 9278057805

Visit: http://www.samridhiluxuriyaave...

 

 


images_upload/1523259571.jpg
images_upload/1523259571.jpg images_upload/1523259579.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