Query
Template: /app/cfc/searchproperties.cfc:136
Execution Time: 73.8 ms
Record Count: 14
Cached: No
Lazy: No
SQL:
SELECT SQL_CALC_FOUND_ROWS ctp.id,ctp.price, 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.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_german
FROM concat_table_properties_france ctp WHERE 1=1
AND ctp.place_depth1_id IN (2 )
AND ctp.place_depth2_id IN (16 )
AND ctp.place_depth3_id IN (111 )
AND ctp.price BETWEEN 0 AND 999999999
ORDER BY ctp.position, ctp.id desc
LIMIT 196,14
idpriceproperty_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_favoritelongitudelatitudeplace_idpostal_codecompanysubscription_type_idimage_nameimage_widthimage_heightdescription_germantotalProperties
170870285450002VA3158-SELLINGIMMO150500{ts '2025-06-04 02:15:21'}2Auvergne-Rhône-Alpesauvergne rhone alpes111Haute-Savoiehaute savoie29445Annemasseannemasseappartment{ts '2025-06-18 00:00:00'}/France/Auvergne-Rhône-Alpes/Rhône-Alpes/Haute-Savoie/Annemasse//france/auvergne rhone alpes/rhone alpes/haute savoie/annemasse/506.2546.22944574100Sellingimmo-transac2franimo/images/2025/6/appartment_annemasse_france_selling_7087028_33rqo_1thumb.webp5003751206
270864826500001V10000052168{ts '2025-06-02 00:39:43'}2Auvergne-Rhône-Alpesauvergne rhone alpes111Haute-Savoiehaute savoie29550La Frassela frassehouse{ts '2025-06-16 00:00:00'}/France/Auvergne-Rhône-Alpes/Rhône-Alpes/Haute-Savoie/La Frasse//france/auvergne rhone alpes/rhone alpes/haute savoie/la frasse/5306.6333346.05832955074300IDLR Coralie pollien2franimo/images/2025/6/house_araches_france_idlr-co_7086482_32k39_1thumb.webp500333
37069346249000283003179941066{ts '2025-05-22 22:33:42'}2Auvergne-Rhône-Alpesauvergne rhone alpes111Haute-Savoiehaute savoie29572Lullinlullinappartment{ts '2025-06-20 00:00:00'}/France/Auvergne-Rhône-Alpes/Rhône-Alpes/Haute-Savoie/Lullin//france/auvergne rhone alpes/rhone alpes/haute savoie/lullin/306.5333346.28332957274470Optimhome Draillant - Depierre2franimo/images/2025/5/appartment_vailly_france_optimho_7069346_2qsx4_1thumb.jpg500664
470692645350001830033279003121430{ts '2025-05-22 22:31:20'}2Auvergne-Rhône-Alpesauvergne rhone alpes111Haute-Savoiehaute savoie29457La Balme-de-Sillingyla balme de sillingyhouse{ts '2025-06-20 00:00:00'}/France/Auvergne-Rhône-Alpes/Rhône-Alpes/Haute-Savoie/La Balme-de-Sillingy//france/auvergne rhone alpes/rhone alpes/haute savoie/la balme de sillingy/506.0333345.96672945774330Optimhome Annecy - Larroumec2franimo/images/2025/5/house_la-balme-de_france_optimho_7069264_2qrem_1thumb.jpg500333
5706923248000011830031009043116144{ts '2025-05-22 22:30:17'}2Auvergne-Rhône-Alpesauvergne rhone alpes111Haute-Savoiehaute savoie29681Thonon-les-Bainsthonon les bainscity house{ts '2025-06-20 00:00:00'}/France/Auvergne-Rhône-Alpes/Rhône-Alpes/Haute-Savoie/Thonon-les-Bains//france/auvergne rhone alpes/rhone alpes/haute savoie/thonon les bains/506.4833346.36672968174200Optimhome Thonon les bains - Juin de faucal2franimo/images/2025/5/city-house_thonon-les-b_france_optimho_7069232_2qr2m_1thumb.jpg500375
670686911525002immodiffusion-FNM16796967{ts '2025-05-22 00:47:43'}2Auvergne-Rhône-Alpesauvergne rhone alpes111Haute-Savoiehaute savoie29677Talloirestalloiresappartment{ts '2025-06-19 00:00:00'}/France/Auvergne-Rhône-Alpes/Rhône-Alpes/Haute-Savoie/Talloires//france/auvergne rhone alpes/rhone alpes/haute savoie/talloires/306.2166745.852967774290Immodiffusion2franimo/images/2025/5/appartment_talloires_france_immodif_7068691_2omzc_1thumb.jpg500375
770686904100002immodiffusion-FNM175209100{ts '2025-05-22 00:47:39'}2Auvergne-Rhône-Alpesauvergne rhone alpes111Haute-Savoiehaute savoie29677Talloirestalloiresappartment{ts '2025-06-19 00:00:00'}/France/Auvergne-Rhône-Alpes/Rhône-Alpes/Haute-Savoie/Talloires//france/auvergne rhone alpes/rhone alpes/haute savoie/talloires/506.2166745.852967774290Immodiffusion2franimo/images/2025/5/appartment_talloires_france_immodif_7068690_2omyd_1thumb.jpg500353
870686893990002immodiffusion-FNM17508780{ts '2025-05-22 00:47:39'}2Auvergne-Rhône-Alpesauvergne rhone alpes111Haute-Savoiehaute savoie29522Doussarddoussardappartment{ts '2025-06-19 00:00:00'}/France/Auvergne-Rhône-Alpes/Rhône-Alpes/Haute-Savoie/Doussard//france/auvergne rhone alpes/rhone alpes/haute savoie/doussard/306.2166745.76672952274210Immodiffusion2franimo/images/2025/5/appartment_doussard_france_immodif_7068689_2omyc_1thumb.jpg500375
970685823900002immodiffusion-FNM175101105{ts '2025-05-22 00:43:39'}2Auvergne-Rhône-Alpesauvergne rhone alpes111Haute-Savoiehaute savoie29445Annemasseannemasseappartment{ts '2025-06-19 00:00:00'}/France/Auvergne-Rhône-Alpes/Rhône-Alpes/Haute-Savoie/Annemasse//france/auvergne rhone alpes/rhone alpes/haute savoie/annemasse/406.2546.22944574100Immodiffusion2franimo/images/2025/5/appartment_annemasse_france_immodif_7068582_2om1p_1thumb.jpg500375
1070685773279001immodiffusion-FNM17489990{ts '2025-05-22 00:43:27'}2Auvergne-Rhône-Alpesauvergne rhone alpes111Haute-Savoiehaute savoie29479Cervenscervenshouse{ts '2025-06-19 00:00:00'}/France/Auvergne-Rhône-Alpes/Rhône-Alpes/Haute-Savoie/Cervens//france/auvergne rhone alpes/rhone alpes/haute savoie/cervens/506.4333346.28332947974550Immodiffusion2franimo/images/2025/5/house_cervens_france_immodif_7068577_2olzd_1thumb.jpg500281
117067559590000234093307038080{ts '2025-05-17 06:08:26'}2Auvergne-Rhône-Alpesauvergne rhone alpes111Haute-Savoiehaute savoie29664Samoënssamoensappartment{ts '2025-06-21 00:00:00'}/France/Auvergne-Rhône-Alpes/Rhône-Alpes/Haute-Savoie/Samoëns//france/auvergne rhone alpes/rhone alpes/haute savoie/samoens/406.7333346.08332966474340Capifrance Chaluleu2franimo/images/2025/5/appartment_samoens_france_capifra_7067559_2cl9x_1thumb.jpg500375
1270675508500001340938633754150862{ts '2025-05-17 06:08:07'}2Auvergne-Rhône-Alpesauvergne rhone alpes111Haute-Savoiehaute savoie29664Samoënssamoenshouse{ts '2025-06-21 00:00:00'}/France/Auvergne-Rhône-Alpes/Rhône-Alpes/Haute-Savoie/Samoëns//france/auvergne rhone alpes/rhone alpes/haute savoie/samoens/706.7333346.08332966474340Capifrance Chaluleu2franimo/images/2025/5/house_samoens_france_capifra_7067550_2cl2j_1thumb.jpg500281
1370674325490001340935977303177410{ts '2025-05-17 06:05:46'}2Auvergne-Rhône-Alpesauvergne rhone alpes111Haute-Savoiehaute savoie29571Lugrinlugrinhouse{ts '2025-06-21 00:00:00'}/France/Auvergne-Rhône-Alpes/Rhône-Alpes/Haute-Savoie/Lugrin//france/auvergne rhone alpes/rhone alpes/haute savoie/lugrin/606.6833346.42957174500Capifrance Loiseau2franimo/images/2025/5/house_lugrin_france_capifra_7067432_2cjtr_1thumb.jpg500376
147067382259000234093995430141{ts '2025-05-17 06:04:48'}2Auvergne-Rhône-Alpesauvergne rhone alpes111Haute-Savoiehaute savoie29539Excénevexexcenevexappartment{ts '2025-06-21 00:00:00'}/France/Auvergne-Rhône-Alpes/Rhône-Alpes/Haute-Savoie/Excénevex//france/auvergne rhone alpes/rhone alpes/haute savoie/excenevex/206.3546.352953974140Capifrance Barthel2franimo/images/2025/5/appartment_excenevex_france_capifra_7067382_2cj2z_1thumb.jpg500333