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


housing for sale


Shown below are homes and condos for sale and wanted. Click an ad for more details or to reply to it.
Showing 1 - 25 of 134 ads
Begin of c,73,price,housing-for-sale- Previous page of c,73,price,housing-for-sale- 1 - 25 of 134 Next page of c,73,price,housing-for-sale- End of c,73,price,housing-for-sale-

Price Area Posted
PURCHASE / SELL / RENT PROPERTY
PURCHASE / SELL / RENT PROPERTY (unixf182a)We Deal in All Types of Property – Rent / Sale / Purchase / Lease of Apartments, Flats, Villas, Houses, Land and Office Space. We Deal in a Wide Variety of Residential and Commercial Property at Gujarat. For more...
INR 2147483647
268 weeks ago
ATS Picturesque Reprieves @9266850850 |3/4BHK Flats Sector 152 Noida
ATS Picturesque Reprieves @9266850850 |3/4BHK Flats Sector 152 Noida ATS Picturesque Reprieves is a large scale residential housing project launched by ATS Group located at Sector 152 Noida on Noida Expressway. ATS Picturesque Reprieves Sector 152 Noida provides 3/4 BHK marvelous apartments in several sizes that are...
INR 2147483647
3 weeks ago
Book 2/3/4BHK Flats @9278057805 At Godrej Nest Sec 150 Noida
Book 2/3/4BHK Flats @9278057805 At Godrej Nest Sec 150 Noida Godrej Nest Sector 150 Noida new luxurious residential property by Godrej Properties a trustworthy name in Real Estate. A new tower Godrej Nest Solitaire launched in which all facilities are equipped within campus fantastically placed in Noida...
INR 2147483647
New Delhi
2 weeks ago
PURCHASE / SELL / RENT PROPERTY
PURCHASE / SELL / RENT PROPERTY (unixf182a)We Deal in All Types of Property – Rent / Sale / Purchase / Lease of Apartments, Flats, Villas, Houses, Land and Office Space. We Deal in a Wide Variety of Residential and Commercial Property at Gujarat. For more...
INR 111111111
268 weeks ago
Furnished Villa With Swimming Pool For Sale At Ama
Furnished Villa With Swimming Pool For Sale At Ama Exclusively furnished, 3800 sqft 3BHK and 2 servant quarters made in 1 Acre plot with swimming pool and garden is now for sale at Amarja Hills Near Pawana Dam, Lonavala, Pune.
INR 45000000
MadipurVillage
187 weeks ago
BUY SPACIOUS 5 BHK RESIDENCES IN GAURS PLATINUM TOWERS SEC- 79 NOIDA
BUY SPACIOUS 5 BHK RESIDENCES IN GAURS PLATINUM TOWERS SEC- 79 NOIDA Gaursons group is launching an 52 exclusive, private residences at GAURS PLATINUM TOWERS. This project includes twin iconic towers rising like a jewel in the crowning glory of Gaur Sportswood, Sector-79, Noida. Gaur Platinum Towers Noida are...
INR 34400000
East Delhi
30 weeks ago
Godrej Golf Link Evoke Villas @9266850850 in Greater Noida
Godrej properties launched Godrej Golf Links Villas located at Pari Chowk, is a part of new residential project of 100 Acre township Project with their luxury golf view villas in Greater Noida. Godrej Golf Link Evoke has 3BHK and 4BHK incredible...
INR 14000000
6 weeks ago
Book @9266850850 Godrej Golf Link Evoke Premium Villas
Book @9266850850 Godrej Golf Link Evoke Premium Villas Godrej Evoke Villas are classy villas situated in Greater Noida, near Pari Chowk. Godrej Golf Link Evoke has 3/4/5BHK elite and specious villas on awesome greenery environment where you can spend rest of your life as a celebrity class...
INR 14000000
3 weeks ago
Residential House for sale in Koramangala
Residential House for sale in Koramangala Residential individual house cum duplex house for sale in 3rd block koramangala 5 BHK Plot area is 30/40 i.e 1200 sq ft built up area 2 floors covered area is 2000 sqft South facing Fully furnished Good locality Peace ful place BDA property...
INR 12000000
356 weeks ago
Studio Apartment in Gurgaon & Noida
Fully furnished Studio apartments are available in Gurgaon & Noida. A Studio apartment is effectively small & single room apartment. It’s a multipurpose room that contains a kitchen, a bed a living room and a bathroom which is attached....
INR 12000000
352 weeks ago
Studio Apartment in Gurgaon & Noida
Fully furnished Studio apartments are available in Gurgaon & Noida. A Studio apartment is effectively small & single room apartment. It’s a multipurpose room that contains a kitchen, a bed a living room and a bathroom which is attached....
INR 12000000
351 weeks ago
Studio Apartment in Gurgaon & Noida
Fully furnished Studio apartments are available in Gurgaon & Noida. A Studio apartment is effectively small & single room apartment. It’s a multipurpose room that contains a kitchen, a bed a living room and a bathroom which is attached....
INR 12000000
New Delhi
351 weeks ago
Studio Apartment in Gurgaon & Noida
Fully furnished Studio apartments are available in Gurgaon & Noida. A Studio apartment is effectively small & single room apartment. It’s a multipurpose room that contains a kitchen, a bed a living room and a bathroom which is attached....
INR 12000000
DelhiGpo
345 weeks ago
Godrej Solitaire @9278057805 New Tower AT Godrej Nest 150 Noida
Godrej Solitaire @9278057805 New Tower AT Godrej Nest 150 Noida Godrej Solitaire is a new launch luxuries residential tower @Godrej Nest locating in Sector 150 Noida. Godrej Nest Solitaire in Noida has spacious 3 BHK and 4 BHK apartments. Godrej Solitaire flats are located at the greenest location of Noida. ...
INR 10600000
6 weeks ago
ATS Pristine Phase 2 @9278057805 By ATS Group
ATS Pristine Phase 2 @9278057805 By ATS Group ATS Pristine Phase 2 is a premium housing development by the ATS group that offers a life of exceptional fetchers, it offers 3 BHK apartments and villas also, which are situated in Sector 150 Noida. ATS Pristine Sector 150 Noida are launching...
INR 10275000
7 weeks ago
Stunning 3BHK Apartments @9278057805 In ATS Pristine Phase 2 Noida
Stunning 3BHK Apartments @9278057805 In ATS Pristine Phase 2 Noida ATS Pristine Phase 2 available at the flawless destination and modern houses in Sector 150 Noida by ATS Group. The most striking 3BHK apartments at this residential project offer your daily necessities what you require and want for your life as...
INR 10275000
6 weeks ago
ATS Pristine Noida @9250002253 | ATS Pristine Phase 2
ATS Pristine Noida @9250002253 | ATS Pristine Phase 2 Now your time has come and you can enjoy your throughout the life without any tension in the place of ATS Pristine Phase 2, fantastically placed in Noida sector 150, on Noida Expressway. Here, in amazing 3BHK apartments with the best area square...
INR 10275000
4 weeks ago
Book Your Home @9266850850 in ATS Pristine Sector 150 Noida Expressway
Book Your Home @9266850850 in ATS Pristine Sector 150 Noida Expressway For natural and healthy living style on best location offering as ATS Pristine Apartments in Sector 150 Noida Expressway. An ideal habitat to spend your whole life in peaceful environment, the ATS Pristine Phase 2 is the residential project of ATS...
INR 10275000
2 weeks ago
ATS Picturesque Reprieves @9266850850 Sector 152 Noida Expressway
ATS Picturesque Reprieves @9266850850 Sector 152 Noida Expressway ATS Group presents new luxury project ATS Picturesque Reprieves in Sector 152, Noida Expressway. ATS Picturesque Reprieves Noida is the new residential project offering 3/4 BHK luxury apartments with world class amenities in sector 152 Noida on...
INR 10100000
5 weeks ago
Buy,Sell,Rent Property In Netaji Subhash Place
Buy,Sell,Rent Property In Netaji Subhash Place For Sale/Purchase/Renting of Property In Netaji Subhash Place Pitampura Call Us at 09310112377,09310014264 DV Buildwell India Private Limited, a proud member of DV Group, is a vibrant and dynamic real estate company with expanding interests in...
INR 10000000
New Delhi
249 weeks ago
Ajnara Daffodil Noida @9266850850 Ready To Move In Apartments
Ajnara Daffodil Noida @9266850850 Ready To Move In Apartments Ajnara Group has launched Ajnara Daffodil a new residential project in Noida Sector 137 that contain lavish concept of luxury lifestyle. Ajnara Daffodil Sector 137 Noida has been 3BHK Apartment in sizes of 1895 sq. ft and 2095 sq. ft with best...
INR 10000000
7 weeks ago
@9266850850 Shapoorji Pallonji Mumbai Dreams Apartments in Mulund West
@9266850850 Shapoorji Pallonji Mumbai Dreams Apartments in Mulund West Shapoorji Pallonji Mumbai Dreams is new launch residential apartments located in Mumbai developed by Shapoorji Pallonji Real Estate. Shapoorji Mumbai Dreams offers spacious 1BHK, 2BHK and 3BHK apartments is one of the popular housing projects that...
INR 9200000
7 weeks ago
@9278057805 SIGNATURE RESORT TOWERS At ACE GOLFSHIRE SEC 150 Noida
@9278057805 SIGNATURE RESORT TOWERS At ACE GOLFSHIRE SEC 150 Noida Signature Resort Tower a new tower At Ace Golfshire is ready to move in apartments within 24hours situated in Sector 150 Noida. ACE Golfshire sector 150 Noida has been 3BHK apartments with Modular Kitchen, Wardrobe in all bedrooms, Air-conditioning...
INR 8300000
6 weeks ago
DLF Regal Gardens Garden City Gurgaon@09310112377
DLF Regal Gardens Garden City Gurgaon@09310112377 DLF Regal Gardens Garden City Gurgaon,DLF Regal Gardens Sector 90 Gurgaon For Details Call Us @ 09310112377 Or 07838257733,DLF Regal Gardens Price,DLF Regal Gardens Gurgaon - DLF Regal Gardens Sector 90 Gurgaon After The Grand Success of DLF...
INR 8000000
New Delhi
Map
329 weeks ago
ATS Le Grandiose 3/4BHK Premium Apartments @9278057805
ATS Le Grandiose 3/4BHK Premium Apartments @9278057805 ATS Le Grandiose Noida 150 is an integrated residential project developed by renowned developers ATS Group, located in the premium location of Sector-150 Noida Expressway. ATS Le Grandiose flats consisting of 3BHK and 4 BHK flat availabe from 79...
INR 7900000
7 weeks ago
Begin of c,73,price,housing-for-sale- Previous page of c,73,price,housing-for-sale- 1 - 25 of 134 Next page of c,73,price,housing-for-sale- End of c,73,price,housing-for-sale-


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