Query
Template: /app/cfc/searchproperties.cfc:139
Execution Time: 78.4 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_dutch
FROM concat_table_properties_france ctp WHERE 1=1
AND ctp.place_depth1_id IN (7 )
AND ctp.place_depth2_id IN (19 )
AND ctp.price BETWEEN 0 AND 999999999
ORDER BY ctp.position, ctp.id desc
LIMIT 154,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_dutchtotalProperties
170689631799001749661002-2499030{ts '2025-05-22 03:26:11'}7Grand Estgrand est105Haut-Rhinhaut rhin27311Orbeyorbeyhouse{ts '2025-06-19 00:00:00'}/France/Grand Est/Alsace/Haut-Rhin/Orbey//france/grand est/alsace/haut rhin/orbey/5007.1666748.13332731168370Re/max aim ymo2franimo/images/2025/5/house_orbey_france_re-max_7068963_2p1us_1thumb.jpg500375710
270689621849002749661010-11972{ts '2025-05-22 03:26:11'}7Grand Estgrand est105Haut-Rhinhaut rhin27137Colmarcolmarappartment{ts '2025-06-19 00:00:00'}/France/Grand Est/Alsace/Haut-Rhin/Colmar//france/grand est/alsace/haut rhin/colmar/3007.3666748.08332713768000Re/max aim ymo2franimo/images/2025/5/appartment_colmar_france_re-max_7068962_2p1uq_1thumb.jpg500375
370689591308002749661209-968{ts '2025-05-22 03:26:11'}7Grand Estgrand est105Haut-Rhinhaut rhin27137Colmarcolmarappartment{ts '2025-06-19 00:00:00'}/France/Grand Est/Alsace/Haut-Rhin/Colmar//france/grand est/alsace/haut rhin/colmar/3007.3666748.08332713768000Re/max aim ymo2franimo/images/2025/5/appartment_colmar_france_re-max_7068959_2p1uo_1thumb.jpg500375
470689583727501749661002-252133558{ts '2025-05-22 03:26:11'}7Grand Estgrand est105Haut-Rhinhaut rhin27288Munstermunsterhouse{ts '2025-06-19 00:00:00'}/France/Grand Est/Alsace/Haut-Rhin/Munster//france/grand est/alsace/haut rhin/munster/6007.1333348.052728868140Re/max aim ymo2franimo/images/2025/5/house_munster_france_re-max_7068958_2p1um_1thumb.jpg500375
570689573899001749661043-141100397{ts '2025-05-22 03:26:10'}7Grand Estgrand est105Haut-Rhinhaut rhin27439Zaessinguezaessinguehouse{ts '2025-06-19 00:00:00'}/France/Grand Est/Alsace/Haut-Rhin/Zaessingue//france/grand est/alsace/haut rhin/zaessingue/5007.3666747.61672743968130Re/max aim ymo2franimo/images/2025/5/house_zaessingue_france_re-max_7068957_2p1uk_1thumb.jpg500375
670689502150001750331026-59130213{ts '2025-05-22 03:22:06'}7Grand Estgrand est105Haut-Rhinhaut rhin27115Bollwillerbollwillerhouse{ts '2025-06-19 00:00:00'}/France/Grand Est/Alsace/Haut-Rhin/Bollwiller//france/grand est/alsace/haut rhin/bollwiller/5007.2547.86672711568540Re/max authentic trois frontières2franimo/images/2025/5/house_bollwiller_france_re-max_7068950_2p1np_1thumb.jpg500333
77068682990005immodiffusion-FNM175163{ts '2025-05-22 00:47:21'}7Grand Estgrand est104Bas-Rhinbas rhin26561Bernolsheimbernolsheimterrain{ts '2025-06-19 00:00:00'}/France/Grand Est/Alsace/Bas-Rhin/Bernolsheim//france/grand est/alsace/bas rhin/bernolsheim/007.6833348.752656167170Immodiffusion2franimo/images/2025/5/terrain_bernolsheim_france_immodif_7068682_2omwq_1thumb.jpg500375
870684363811001278_14032408000{ts '2025-05-21 23:28:59'}7Grand Estgrand est104Bas-Rhinbas rhin26758Kirrbergkirrberghouse{ts '2025-06-19 00:00:00'}/France/Grand Est/Alsace/Bas-Rhin/Kirrberg//france/grand est/alsace/bas rhin/kirrberg/8007.0666748.816726758673203 pourcent2franimo/images/2025/5/house_kirrberg_france_3-pourc_7068436_2ofgf_1thumb.jpg500333
97068433359900156_V1020057961185514{ts '2025-05-21 23:28:58'}7Grand Estgrand est104Bas-Rhinbas rhin26942Savernesavernehouse{ts '2025-06-19 00:00:00'}/France/Grand Est/Alsace/Bas-Rhin/Saverne//france/grand est/alsace/bas rhin/saverne/7007.3666748.733326942677003 pourcent2franimo/images/2025/5/house_saverne_france_3-pourc_7068433_2ofg9_1thumb.jpg500375
1070684322884001264_V3480060575190806{ts '2025-05-21 23:28:58'}7Grand Estgrand est104Bas-Rhinbas rhin26692Griesbach-le-Bastberggriesbach le bastberghouse{ts '2025-06-19 00:00:00'}/France/Grand Est/Alsace/Bas-Rhin/Griesbach-le-Bastberg//france/grand est/alsace/bas rhin/griesbach le bastberg/7007.4333348.816726692673303 pourcent2franimo/images/2025/5/house_griesbach-le_france_3-pourc_7068432_2ofg8_1thumb.jpg500375
117068417298700156_V1020050858229530{ts '2025-05-21 23:28:44'}7Grand Estgrand est104Bas-Rhinbas rhin26799Marmoutiermarmoutierhouse{ts '2025-06-19 00:00:00'}/France/Grand Est/Alsace/Bas-Rhin/Marmoutier//france/grand est/alsace/bas rhin/marmoutier/8007.3833348.683326799674403 pourcent2franimo/images/2025/5/house_marmoutier_france_3-pourc_7068417_2ofdo_1thumb.jpg500375
1270684091399001264_V348006064447{ts '2025-05-21 23:28:36'}7Grand Estgrand est104Bas-Rhinbas rhin26984Strasbourgstrasbourghouse{ts '2025-06-19 00:00:00'}/France/Grand Est/Alsace/Bas-Rhin/Strasbourg//france/grand est/alsace/bas rhin/strasbourg/2007.7548.583326984670003 pourcent2franimo/images/2025/5/house_strasbourg_france_3-pourc_7068409_2ofbq_1thumb.jpg500375
137068393278100156_V1020060662143316{ts '2025-05-21 23:28:09'}7Grand Estgrand est104Bas-Rhinbas rhin26699Haguenauhaguenauhouse{ts '2025-06-19 00:00:00'}/France/Grand Est/Alsace/Bas-Rhin/Haguenau//france/grand est/alsace/bas rhin/haguenau/6007.7833348.816726699675003 pourcent2franimo/images/2025/5/house_haguenau_france_3-pourc_7068393_2of9e_1thumb.jpg500375
147068384259800156_V102005794595545{ts '2025-05-21 23:28:02'}7Grand Estgrand est104Bas-Rhinbas rhin26866Ohlungenohlungenhouse{ts '2025-06-19 00:00:00'}/France/Grand Est/Alsace/Bas-Rhin/Ohlungen//france/grand est/alsace/bas rhin/ohlungen/4007.748.816726866675903 pourcent2franimo/images/2025/5/house_ohlungen_france_3-pourc_7068384_2of88_1thumb.jpg500375