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

Amenities:

                     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 

Visit: www.jmsmarinesquare.net.in

 

 

 

 


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