Query
Template: /app/cfc/searchproperties.cfc:139
Execution Time: 90.6 ms
Record Count: 14
Cached: No
Lazy: No
SQL:
SELECT SQL_CALC_FOUND_ROWS ctp.id,ctp.price,ctp.old_price,ctp.show_price_lowered,ctp.property_type_id, ctp.reference, ctp.m2_surface, ctp.m2_terrain, ctp.created, ctp.place_depth1_id, ctp.place_depth1_name, ctp.place_depth1_spec_char, ctp.place_depth3_id, ctp.place_depth3_name, ctp.place_depth3_spec_char, ctp.place_depth4_id, ctp.place_depth4_name, ctp.place_depth4_spec_char, ctp.property_type_name, ctp.modified, ctp.name_path, ctp.without_spec_char_path, ctp.rooms, ctp.bedrooms, ctp.bathrooms, ctp.property_promo_top, ctp.property_promo_favorite, ctp.property_promo_jewel, ctp.longitude,ctp.latitude,ctp.place_id,ctp.postal_code, ctp.company, ctp.subscription_type_id, ctp.image_name, ctp.image_width, ctp.image_height, ctp.description_english
,( 6371 * acos( cos( radians(43.799999237061) ) * cos( radians( latitude ) )
* cos( radians( longitude ) - radians(4.666669845581) ) + sin( radians(43.799999237061) ) * sin(radians(latitude)) ) ) AS distance
FROM concat_table_properties_france ctp WHERE 1=1
HAVING distance < 30
AND ctp.price BETWEEN 0 AND 999999999
ORDER BY ctp.position, ctp.id desc
LIMIT 266,14
idpriceold_priceshow_price_loweredproperty_type_idreferencem2_surfacem2_terraincreatedplace_depth1_idplace_depth1_nameplace_depth1_spec_charplace_depth3_idplace_depth3_nameplace_depth3_spec_charplace_depth4_idplace_depth4_nameplace_depth4_spec_charproperty_type_namemodifiedname_pathwithout_spec_char_pathroomsbedroomsbathroomsproperty_promo_topproperty_promo_favoriteproperty_promo_jewellongitudelatitudeplace_idpostal_codecompanysubscription_type_idimage_nameimage_widthimage_heightdescription_englishdistancetotalProperties
1704776022000004HH-157271878945000{ts '2025-04-04 23:06:48'}12Occitanieoccitanie67Gardgard11318Nîmesnimesvilla{ts '2025-06-21 00:00:00'}/France/Occitanie/Languedoc-Roussillon/Gard/Nîmes//france/occitanie/languedoc roussillon/gard/nimes/614004.3543.83331131830000Home Hunts2franimo/images/2025/4/villa_nimes_france_home-hu_7047760_2ayds_1thumb.jpg500333Located Near Nimes, in the charming and dynamic village of Vezenobres, this exceptional property combines elegance, refinement and art of living. It is with great taste and great skill that its current owners have brought this estate back to life. Made up of several buildings, the property is available as follows: - A 270 m2 mansion on 3 levels made up of 4 bedrooms opening onto a 5000 m2 landscaped park with 16x8 swimming pool and pool house. - Several outbuildings converted into 10 modern and completely independent apartments. - A workshop and its exhibition hall - A caretaker's apartment (to be renovated) - Several cellars - A well The 10 apartments have surfaces ranging from 50 to 120 m2, some duplex, some with private terraces or balconies. They are all rented year-round (except one, mainly rented seasonally) and offer excellent rental profitability. An extraordinary property, offering multiple possibilities, ideally located between Nimes and the Cevennes.25.676019824441593
2704755712270001VM476-IMONAH1865000{ts '2025-04-04 02:24:10'}12Occitanieoccitanie67Gardgard11318Nîmesnimeshouse{ts '2025-06-20 00:00:00'}/France/Occitanie/Languedoc-Roussillon/Gard/Nîmes//france/occitanie/languedoc roussillon/gard/nimes/5004.3543.83331131830000Imonah2franimo/images/2025/4/house_nimes_france_imonah_7047557_27702_1thumb.jpg50037525.676019824441
370474914550008830037478857190254{ts '2025-04-03 23:07:26'}14Provence-Alpes-Côte d'Azurprovence alpes cote d azur49Bouches-du-Rhônebouches du rhone4412Paradouparadoubarn{ts '2025-06-20 00:00:00'}/France/Provence-Alpes-Côte d'Azur/Provence-Alpes-Côte d'Azur/Bouches-du-Rhône/Paradou//france/provence alpes cote d azur/provence alpes cote d azur/bouches du rhone/paradou/1004.7833343.7167441213520Optimhome Paradou - El khadri2franimo/images/2025/4/barn_paradou_france_optimho_7047491_26jmg_1thumb.jpg500339A rare opportunity in Maussane-les-Alpilles, in a prime location, right in the heart of the village. This barn of approximately 190 m², declared habitable, is located on a plot of 254 m² with an impressive ceiling height of approximately 4.60 meters, and is 20.59 x 9.19 m. Located in a peaceful environment, in the immediate vicinity of a large parking lot and within walking distance of amenities, this building offers exceptional potential. This site was once used as a warehouse for prestigious classic cars and as a vehicle restoration workshop. An architectural project was submitted and accepted by the town hall, including the creation of numerous openings and the elevation of a loft-type floor. Ideal for any type of project, whether personal or professional (Garage for personal vehicles, Loft, Housing, seeking profitability, investment, restaurant, business project...) it will appeal to renovation lovers looking for a unique place to reinvent. Let yourself be inspired by a visit and bring your project to life! Be visionary, transform this unique place into an exceptional project. Complete file on request. The fees are the responsibility of the seller. Les informations sur les risques auxquels ce bien est exposé sont disponibles sur le site Géorisques : www. georisques. gouv. fr. Contact your local agent, Amina EL KHADRI, PARADOU, Optimhome Associate Estate Agent at 06 16 11 40 77 (ref 580457)13.174719574764
470469602350001immodiffusion-FNM159617120{ts '2025-04-03 00:50:49'}12Occitanieoccitanie67Gardgard11264Généracgenerachouse{ts '2025-06-19 00:00:00'}/France/Occitanie/Languedoc-Roussillon/Gard/Générac//france/occitanie/languedoc roussillon/gard/generac/6004.3543.73331126430510Immodiffusion2franimo/images/2025/4/house_generac_france_immodif_7046960_22lji_1thumb.jpg500375Mandate Id-FNM159617 : House approximately 120 m2 including 6 room(s) - 4 bed-rooms + Cour *. - Equipement annex : Cour *, double vitrage, cellier, and Air conditioning réversible - chauffage : electrique - More information is avaible upon request... 26.488405365369
570469452780001immodiffusion-FNM16402890{ts '2025-04-03 00:50:16'}12Occitanieoccitanie67Gardgard11308Montfrinmontfrinhouse{ts '2025-06-19 00:00:00'}/France/Occitanie/Languedoc-Roussillon/Gard/Montfrin//france/occitanie/languedoc roussillon/gard/montfrin/4004.643.88331130830490Immodiffusion2franimo/images/2025/4/house_montfrin_france_immodif_7046945_22lfc_1thumb.jpg500281Mandate Id-FNM164028 : House approximately 90 m2 including 4 room(s) - 3 bed-rooms. - Equipement annex : Garden, Terrace, Garage, parking, double vitrage, - chauffage : aucun - More information is avaible upon request... 10.695141383052
670468621150001immodiffusion-FNM15860140{ts '2025-04-03 00:48:31'}12Occitanieoccitanie67Gardgard11318Nîmesnimeshouse{ts '2025-06-19 00:00:00'}/France/Occitanie/Languedoc-Roussillon/Gard/Nîmes//france/occitanie/languedoc roussillon/gard/nimes/2004.3543.83331131830000Immodiffusion2franimo/images/2025/4/house_nimes_france_immodif_7046862_22khz_1thumb.jpg500667Mandate Id-FNM158601 : T2 approximately 40 m2 including 2 room(s) - 1 bed-rooms + Loggia : 7 m2, Sight : Garden de la residence. Built in 2014 - Equipement annex : Loggia, Garage, parking, digicode, double vitrage, - chauffage : gaz - FEATURES - More information is avaible upon request... 25.676019824441
77046804985001immodiffusion-FNM166014140{ts '2025-04-03 00:46:34'}14Provence-Alpes-Côte d'Azurprovence alpes cote d azur121Vauclusevaucluse33000Sorguessorgueshouse{ts '2025-06-19 00:00:00'}/France/Provence-Alpes-Côte d'Azur/Provence-Alpes-Côte d'Azur/Vaucluse/Sorgues//france/provence alpes cote d azur/provence alpes cote d azur/vaucluse/sorgues/004.86667443300084700Immodiffusion2franimo/images/2025/4/house_sorgues_france_immodif_7046804_22k5v_1thumb.jpg500225Mandate Id-FNM166014 : House approximately 140 m2 + Garden : 270 m2. - Equipement annex : Garden, Terrace, - chauffage : aucun - Expect some renovation - More information is avaible upon request... 27.41077720746
870467961470002immodiffusion-FNM16289847{ts '2025-04-03 00:46:18'}12Occitanieoccitanie67Gardgard11318Nîmesnimesappartment{ts '2025-06-19 00:00:00'}/France/Occitanie/Languedoc-Roussillon/Gard/Nîmes//france/occitanie/languedoc roussillon/gard/nimes/2004.3543.83331131830000Immodiffusion2franimo/images/2025/4/appartment_nimes_france_immodif_7046796_22k3p_1thumb.jpg500375Mandate Id-FNM162898 : POLYCLINIQUE-7 COLLINES, T2 approximately 47 m2 including 2 room(s) - 1 bed-rooms + Terrace : 13 m2, Sight : Swimming Pool. Built in 2004 - Equipement annex : Terrace, parking, digicode, double vitrage, ascenseur, piscine, - chauffage : electrique - More information is avaible upon request... 25.676019824441
970467902600001immodiffusion-FNM17347584{ts '2025-04-03 00:46:14'}12Occitanieoccitanie67Gardgard11318Nîmesnimeshouse{ts '2025-06-19 00:00:00'}/France/Occitanie/Languedoc-Roussillon/Gard/Nîmes//france/occitanie/languedoc roussillon/gard/nimes/4004.3543.83331131830000Immodiffusion2franimo/images/2025/4/house_nimes_france_immodif_7046790_22k2w_1thumb.jpg500375Mandate Id-FNM173475 : House approximately 84 m2 including 4 room(s) - 3 bed-rooms + Terrace : 84 m2. - Equipement annex : Terrace, Garage, parking, double vitrage, and Air conditioning réversible - chauffage : electrique - More information is avaible upon request... 25.676019824441
1070466175480001750641001-8917610000{ts '2025-04-03 00:29:25'}12Occitanieoccitanie67Gardgard35705Nîmes 30900nimes 30900house{ts '2025-06-19 00:00:00'}/France/Occitanie/Languedoc-Roussillon/Gard/Nîmes 30900//france/occitanie/languedoc roussillon/gard/nimes 30900/5004.3543.83333570530900Re/max properties2franimo/images/2025/4/house_saint-cesair_france_re-max_7046617_22hh5_1thumb.jpg500375House 4 bedroom(s) for sale - 598 000 € Legal Mentions (in French) : Honoraires à la charge du vendeur. Les informations sur les risques auxquels ce bien est exposé sont disponibles sur le site Géorisques : www.georisques.gouv.fr . 25.676019824441
1170466167280001750641008-16448{ts '2025-04-03 00:29:25'}12Occitanieoccitanie67Gardgard11476Saint-Césairesaint cesairehouse{ts '2025-06-19 00:00:00'}/France/Occitanie/Languedoc-Roussillon/Gard/Saint-Césaire//france/occitanie/languedoc roussillon/gard/saint cesaire/12004.3166743.81671147630900Re/max properties2franimo/images/2025/4/house_saint-cesair_france_re-max_7046616_22hh1_1thumb.jpg500375Rentals for sale - 728 000 € Legal Mentions (in French) : Honoraires à la charge du vendeur. Les informations sur les risques auxquels ce bien est exposé sont disponibles sur le site Géorisques : www.georisques.gouv.fr . 28.147005493893
127044663265000483003567522187194{ts '2025-03-27 23:33:01'}12Occitanieoccitanie67Gardgard11318Nîmesnimesvilla{ts '2025-06-20 00:00:00'}/France/Occitanie/Languedoc-Roussillon/Gard/Nîmes//france/occitanie/languedoc roussillon/gard/nimes/4004.3543.833311318300002franimo/images/2025/3/villa_nimes_france_optimho_7044663_1b5rq_1thumb.jpg5003754-ROOM AIR-CONDITIONED VILLA 87M2 WITH GARAGE. Ideally located close to essential amenities. Schools, shops, and major roads are easily accessible, offering a practical and pleasant daily life, the city center is less than 20 minutes away on foot. Upon entering, we discover a functional and bright ground floor. The south-facing living room offers a warm living area, opening onto a fully equipped kitchen, a practical laundry room, a toilet, and a garage with a mezzanine. From the garage, direct access to the terrace combines practicality and comfort. Upstairs, 3 bedrooms, a bathroom with double sinks, and a separate toilet. Outside, a south-facing wooden terrace and a private garden, perfect for enjoying the sunny days. No work required, just put down your suitcases! The fees are the responsibility of the seller. Les informations sur les risques auxquels ce bien est exposé sont disponibles sur le site Géorisques : www. georisques. gouv. fr. Contact your local agent, Michael ANDRÉ, AIGUES MORTES, Optimhome Associate Estate Agent at 06 62 81 77 75 (ref 580836)25.676019824441
1370440072620001immodiffusion-FNM164823103{ts '2025-03-27 01:47:18'}14Provence-Alpes-Côte d'Azurprovence alpes cote d azur121Vauclusevaucluse33000Sorguessorgueshouse{ts '2025-06-19 00:00:00'}/France/Provence-Alpes-Côte d'Azur/Provence-Alpes-Côte d'Azur/Vaucluse/Sorgues//france/provence alpes cote d azur/provence alpes cote d azur/vaucluse/sorgues/4004.86667443300084700Immodiffusion2franimo/images/2025/3/house_sorgues_france_immodif_7044007_180ni_1thumb.jpg500246Mandate Id-FNM164823 : House approximately 103 m2 including 4 room(s) - 2 bed-rooms + Site : 620 m2. Built in 1960 - Equipement annex : Garden, Terrace, Garage, double vitrage, cellier, Cheminee, veranda, and Air conditioning réversible - chauffage : gaz - Expect some renovation - More information is avaible upon request... 27.41077720746
1470437702490001immodiffusion-FNM17309780{ts '2025-03-27 01:41:36'}14Provence-Alpes-Côte d'Azurprovence alpes cote d azur121Vauclusevaucluse32887Avignonavignonhouse{ts '2025-06-19 00:00:00'}/France/Provence-Alpes-Côte d'Azur/Provence-Alpes-Côte d'Azur/Vaucluse/Avignon//france/provence alpes cote d azur/provence alpes cote d azur/vaucluse/avignon/5004.8166743.953288784000Immodiffusion2franimo/images/2025/3/house_avignon_france_immodif_7043770_17yd5_1thumb.jpg500281Mandate Id-FNM173097 : House approximately 80 m2 including 5 room(s) - 3 bed-rooms, Sight : Rue. Built in 1900 - Equipement annex : - chauffage : electrique - More information is avaible upon request... 20.561100775484