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 Lotus Broadwalk Commercial Project @9250002253 in 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.

Lotus Broadwalk Commercial Project @9250002253 in NoidaAd id: 14753 | Views : 42
Price : INR 7000000
Date listed : 2018-05-19

Lotus Broadwalk is pre-launch commercial project in Sector 150 Noida by Lotus Green Group. Lotus Broadwalk commercial project is spread over more then 6 acres of land on Noida Expressway. Lotus Broadwalk Sector 150 Noida is offering retail shops on ground floor and first floor with the size of 565 sq. ft to 1500 sq. ft and price stars from 70 lakhs onwards.

Project Heighlights:

·         Total Towers –3

·         Total Shops – 52

·         parking spaces for visitors

·         Hyper City on Lower Ground floor

·         Restaurant on Ground floor

·         Multiplex – Leased to PVR

·         Hotel – 4&5-star hotel proposed

·         Premium residential projects in vicinity

·         Space for commercial retail shops, restaurants, food court, Hypermarket

Project Details:

·         Project Name: Lotus Broadwalk

·         Location: Sector 150 Noida

·         Sizes: 565-1500 sq. ft

·         Price: 70 lacs*

Contact Details:

·         Call On: 9250002253

·         Visit Us:



images_upload/1526734228.jpg images_upload/1526734234.jpg

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