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 Free classifieds India, buy, sell and rent accomodation
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


real estate services


Shown below are realtors, agents, mortgage brokers & other services. Click an ad for more details or to reply to it.
Showing 1 - 25 of 51 ads
Begin of c,77,price,real-estate-services- Previous page of c,77,price,real-estate-services- 1 - 25 of 51 Next page of c,77,price,real-estate-services- End of c,77,price,real-estate-services-

Price Area Posted
Godrej Golf Links Low Rise 3/4 BHK Apartments @9266850850 at Greater Noida
Godrej Golf Links Low Rise 3/4 BHK Apartments @9266850850 at Greater Noida Godrej Properties newly launched low-rise G+7 Tower with golf facing 3bhk and 4bhk apartment at Godrej Golf Links Greater Noida. Godrej Golf Links apartments are stablishing in area of 1800 sq. ft. to 2000 sq. ft. and price of this awesome property...
INR 12000000
New Delhi
16 weeks ago
Find Grand 3BHK Flats & Villas @9250002253 | ATS Pristine Phase 2
Find Grand 3BHK Flats & Villas @9250002253 | ATS Pristine Phase 2 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. ...
INR 10275000
New Delhi
11 weeks ago
Ajnara Daffodil Residential Apartments @9266850850 in Noida
Ajnara Daffodil Residential Apartments @9266850850 in Noida Ajnara Deffodil is a ready to move residential project of Ajnara Group located in GH-07B, Sector-137, Noida Expressway. Ajnara Daffodil Noida offering ready to shift 3 BHK Apartments on prime location of Noida. This project is spread over 8.5...
INR 10000000
North Delhi
14 weeks ago
Godrej Nature Plus Pre-launched Offer in Sohna Gurgaon. 9266850850
Godrej Nature Plus Pre-launched Offer in Sohna Gurgaon.  9266850850 Godrej Properties have launched new luxury residential project Godrej Nature Plus in Sohna Road Sector 33, Gurgaon. Godrej Nature Pluus Sohna offers 2 and 3 BHK apartments with all luxury facilities and amenities. Those apartments ranging from...
INR 7500000
New Delhi
23 weeks ago
Lotus Broadwalk Commercial Project @9250002253 in Noida
Lotus Broadwalk Commercial Project @9250002253 in Noida 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...
INR 7000000
9 weeks ago
3/4BHK Residential Apartments @Sethi Venice Noida Sector150 With Golf Theme|9250002253
3/4BHK Residential Apartments @Sethi Venice Noida Sector150 With Golf Theme|9250002253 At Sethi Venice Noida you can find totally a different world to live. As newest project Sethi Venice Noida 150 developed by Deepak Mehta & Associates and Satish Khanna & Associates, provides first class 3BHK and 4BHK apartments from 1350...
INR 6200000
New Delhi
19 weeks ago
Ajnara Belvedere 3/4BHK Apartments @9266850850 Sector 79 Noida
Ajnara Belvedere 3/4BHK Apartments @9266850850 Sector 79 Noida Ajnara Group launching the Pinnacle of fine living in Sctor 79 Noida by the name of Ajnara The Belvedere. Ajnara The Belvedere Noida project constructed over 7.5 acers of land and has 3/4BHK luxury apartments. Ajnara Belvedere apartments...
INR 6099000
9 weeks ago
Book @9250001807 | Apex The Kremlin | For Residential Apartments in Ghaziabad
Book @9250001807 | Apex The Kremlin | For Residential Apartments in Ghaziabad Apex The Kremlin Siddharth Vihar is presenting grand 2,3 & 4BHK residential apartments in the prime location of Ghaziabad, next to Indirapuram. The varied sizes of apartments have been started from 998 sq. ft presenting at 42lacs. The Kremlin...
INR 5993000
New Delhi
18 weeks ago
Book @9250002253 ACE Parkway Residential Apartments in Sector 150 Noida
Book @9250002253 ACE Parkway Residential Apartments in Sector 150 Noida ACE Parkway is new housing project launch by ACE Group in Sector-150 Noida on Noida Expressway. ACE Parkway Apartments has been afixed with all type of modern amenities and facilities. ACE Parkway Sector 150 Noida project has been 2BHK, 3BHK and...
INR 4900000
11 weeks ago
Call For Residential Flats in Noida_9278057805 @Sa
Call For Residential Flats in Noida_9278057805 @Sa 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...
INR 4302000
North Delhi
15 weeks ago
Samridhi Luxuriya Avenue Sector-150 Noida Apartments @9278057805
Samridhi Luxuriya Avenue Sector 150 Noida is new upcoming residential project by Samridhi Group, at very peaceful, secured and eco-friendly environment of Noida. Samridhi Luxuriya Avenue a breathtaking residential project available at...
INR 4300000
11 weeks ago
Apex The Kremlin Residential Apartments in Ghaziabad. 9266850850
Apex The Kremlin Residential Apartments in Ghaziabad. 9266850850 Apex The Kremlin Siddharth Vihar Ghaziabad is residential apartments developed by Apex Group. The Kremlin Ghaziabad is launching 2, 3 and 4 BHK luxury flats, sizes starts from 998 sq. ft. to 1830 sq. ft. and the starting price is Rs. 42 lacs....
INR 4238000
New Delhi
23 weeks ago
Call On_9266850850 For Apartments @EXOTICA DREAMVILLE in Noida Extension
Call On_9266850850 For Apartments @EXOTICA DREAMVILLE in Noida Extension Exotica Dreamville Noida is a residential apartment, provide all the modern facilities and amenities in affordable rang. Exotica Dreamville launching 2 and 3BHK spacious Flats located on Plot No.1A, Sector 16-C, Noida Extension a prime location of...
INR 4200000
New Delhi
16 weeks ago
Chance to Book 2/3 BHK homes at HomeKraft by ATS Call_9266850850
Chance to Book 2/3 BHK homes at HomeKraft by ATS Call_9266850850 If you want to enliven your life so, you must choose the Happy Trails, as it is the world class residential project in Noida. Happy Trails Noida has been 2 and 3 BHK apartments and now limited inventories are left, so book now with special offers....
INR 4194000
8 weeks ago
Iridia Noida Horizon Concept Call @9015511222
Welcome to Iridia Presenting - A living concept that is above the ordinary. Inspired by the grandeur of the 325 acre majestic forest. In the magnificent lap of mother nature. Showered with Sun rays. Surrounded by fragrant breeze. Designed for...
INR 3600000
285 weeks ago
CRC Sublimis Apartments @9266850850 Sector 1 Noida Extension
CRC Sublimis Apartments @9266850850 Sector 1 Noida Extension CRC Sublimis is new launch residential project locating in Sector 1 Greater Noida West by CRC Group. CRC Sublimis Noida Extension project is well equipped with all modern amenities. CRC Sublimis Apartments has been 2/3BHK apartments inventory in...
INR 3550000
11 weeks ago
Call @9266850850 For READY TO MOVE FLATS IN NOIDA @PANCHSHEEL GREENS 2
Call @9266850850 For READY TO MOVE FLATS IN NOIDA @PANCHSHEEL GREENS 2 Panchsheel Group Noida launching its latest residential project by the name of Panchsheel Greens II in Noida Extension. Panchsheel Greens 2 Greater Noida West is a housing society spreading over 20-acre landscape presenting high rise structures of...
INR 3200000
New Delhi
12 weeks ago
ACE Platinum Ready to Move Flats @9266850850 in Greater Noida
ACE Platinum Ready to Move Flats @9266850850 in Greater Noida ACE Group presenting ready to move residential apartments at ACE Platinum in Sector Zeta-1, Greater Noida. ACE Platinum Greater Noida offering 2/3/4BHK residential apartments in great green environment where you can live your life peacefully. ACE...
INR 3100000
New Delhi
13 weeks ago
Buy Luxury Apartments On_9266850850 @Shri Radha Aqua Garden
Buy Luxury Apartments On_9266850850 @Shri Radha Aqua Garden Shri Radha Aqua Garden Noida Extension is new launch luxury residential project bt Shri Group Builders. Shri Radha Aqua Gardens Apartments is offering 2BHK and 3BHK luxury apartments with best amenities and features on great location with natural...
INR 3000000
8 weeks ago
Call _9266850850 For Migsun One Central Retail Shops @Raj Nagar Extension
Call _9266850850 For Migsun One Central Retail Shops @Raj Nagar Extension Migsun One Central, is a commercial project @ Migsun Roof by Migsun Group at Raj Nagar Extension, Ghaziabad. Migsun One Central Ghaziabad shopping mall launching Office Space and Retail Shops as well as Retail space also with different floor sizes....
INR 2599000
New Delhi
16 weeks ago
Migsun One Central Retails Shops @9266850850 in Raj Nagar Extension
Migsun One Central Retails Shops @9266850850 in Raj Nagar Extension For growing and booming business strategy you can buy Migsun One Central Retails Shops starts from 190 sq. ft commercial spaces available by Migsun Group. Migsun One Central price starts from 25.99 lacs onwards. A platform to make you successful...
INR 2599000
New Delhi
15 weeks ago
Call @9212305305 for 2/3/4BHK flats of MIGSUN WYNN Greater Noida
Call @9212305305 for 2/3/4BHK flats of MIGSUN WYNN Greater Noida Migsun Wynn is an eco-friendly 2, 3 and 4BHK residential apartments in ETA II, Greater Noida have beautifully extended in 845 sq. ft up to 2663 sq. ft. Migsun Wynn Greater Noida residency has been constructed in 8.5 acres land with 75% greenery in...
INR 2061000
New Delhi
16 weeks ago
Investment Starts From 16 Lacs* Call @9266850850 JMS Marine Square
Investment Starts From 16 Lacs* Call @9266850850 JMS Marine Square 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...
INR 1600000
New Delhi
15 weeks ago
@9266850850 | JMS Marine Square Commercial project in Sector 102 Gurgaon
@9266850850 | JMS Marine Square Commercial project in Sector 102 Gurgaon JMS Marine Square Shopping Mall a commercial project in sector 102 Gurgaon, by JMS Buildtech presents retail shops, multiplex, food court, restaurants and more. You can start your business here in affordable investment of 16 lacs*. JMS Marine...
INR 1600000
New Delhi
15 weeks ago
Land for sale in Trivandrum
10 cent land for sale at Trivandrum.Sreekariyam (near Technopark).10 cent square plot Around 2 km from Technopark, 7 km from Trivandrum Railway Station. 12 lacks for 1 cent.For more details,contact 9249375951 & 9526338799 or...
INR 1200000
355 weeks ago
Begin of c,77,price,real-estate-services- Previous page of c,77,price,real-estate-services- 1 - 25 of 51 Next page of c,77,price,real-estate-services- End of c,77,price,real-estate-services-


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