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 Investment Starts From 16 Lacs* Call @9266850850 JMS Marine Square 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.

Investment Starts From 16 Lacs* Call @9266850850 JMS Marine SquareAd id: 13119 | Views : 44
Price : INR 1600000
Date listed : 2018-04-03
Area : New Delhi
close X

JMS Marine Square is a Shopping Mall in Gurgaon Sector 102 on Dwarka Expressway. JMS Marine Square Gurgaon has Retail Shops, Multiplex, Food Court in different sizes on different floors in affordable price range.


                     Multi-Cuisine Restaurants

                     Food Court

                     Outdoor Café

                     Hygienic Street Food Zone

                     24*7 Securities with CCTV Surveillance

                     200 – 2000 sq. ft Shop size

                     12% Assured Return with 12 Months bank guaranteed

                     Just 15 minutes’ drive from IGI Airport & Dwarka

                     High Catchment area of residential projects

                     Located near to diplomatic area & Metro station of Dwarka

                    Easy accessibility to all major business & Retail destinations 

Project Details:

                     Project Name: JMS Marine Square

                     Location: Sector 102 GURGAON

                     Retail Space & Food Court

                     Size: 120-450 sq. ft.

                     Price: 16 lacs*

Contact Details for Booking Now:

                     Call: 9266850850 






images_upload/1522737835.jpg images_upload/1522737820.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