›

Autres

›

Lancez votre recherche pour voir les annonces.

Se connecter S’inscrire

Trouver près de chez soi

Poster une annonce

Se connecter S'inscrire

Chambre à louer : colocation

Location Chambre en colocation Location chambre en colocation 11 entre particuliers

Discuter

Ce voisin demande à louer à Carcassonne (11000)

300€/mois

Marie-france G.

1 annonce

Prix

300€/mois

Description de l'annonce

Bonjour,
Je vais arrivée sur Carcassonne à partir du 6 septembre pour le travail (formatrice au lycée Agricole Charlemagne) et je recherche une chambre chez l'habitant en co location.
Marie-France G
#chambre en colocation

Annonces similaires

Tout voir

Location chambre en colocation

Demande il y a + de 30j

Il y a + de 30j • 11100

Cherche collocation ou chambre chez l'ha

T. jean michel G

Narbonne 11100

370€/^m

Louer ma chambre

Location chambre en colocation

Demande il y a + de 30j

Il y a + de 30j • 11100

Chambre à louer particulier

Corinne B

Narbonne 11100

350€/^m

Louer ma chambre

Louer une chambre entre particuliers ou proposer une chambre en location.

Poster une annonce

Assistance support Kiwiiz

Comment pouvons-nous vous aider ?

Autre chose ?

Contactez-nous

Script : /wiiz-annonce.php

0.0001
SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt=''
0.0001
SELECT w.*, ui.util_photo, ui.util_prenom, ui.util_nom FROM wish w LEFT JOIN util_info ui ON w.util_id=ui.util_id WHERE wish_id='376713'
0.0001
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='chambre-en-colocation' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='505'
0.0001
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'chambre-en-colocation' LIMIT 1
0.0001
SELECT c.cate_id, cate_title_aff, cate_title_slug, c.fami_id, f.fami_title, f.fami_url FROM category c, family f WHERE c.fami_id=f.fami_id AND c.fami_id='5' AND c.cate_id='193'
0
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE filtre_dpt='11'
0.0001
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='192742' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
0
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 192742
0.0001
SELECT fami_id as id, fami_title as title, fami_tutotitle, fami_tutodesc, fami_buttontitle, fami_url as slug FROM `family`
0.0001
SELECT cate_id as id, cate_title as title, cate_title_slug as slug, fami_id FROM `category` WHERE cate_visu=1 AND fami_id='5' AND cate_cate_id IS NULL ORDER BY cate_order ASC
0.0003
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (87) ORDER BY ssrubr_order ASC
0.0002
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (88) ORDER BY ssrubr_order ASC
0.0001
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (81) ORDER BY ssrubr_order ASC
0.0001
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (110) ORDER BY ssrubr_order ASC
0.0001
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (227) ORDER BY ssrubr_order ASC
0.0002
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (176) ORDER BY ssrubr_order ASC
0.0002
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (79) ORDER BY ssrubr_order ASC
0.0002
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (208) ORDER BY ssrubr_order ASC
0.0002
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (228) ORDER BY ssrubr_order ASC
0.0003
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (207) ORDER BY ssrubr_order ASC
0.0002
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (95) ORDER BY ssrubr_order ASC
0.0001
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (173) ORDER BY ssrubr_order ASC
0.0002
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (83) ORDER BY ssrubr_order ASC
0.0001
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (93) ORDER BY ssrubr_order ASC
0.0001
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (193) ORDER BY ssrubr_order ASC
0.0001
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (91) ORDER BY ssrubr_order ASC
0.0001
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (232) ORDER BY ssrubr_order ASC
0.0002
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (92) ORDER BY ssrubr_order ASC
0.0001
SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id WHERE wish_id = 376713
0.0001
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='376713'
0.0001
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='376713' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
0
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 192742 AND util_tel != ''
0
SELECT `stripe_account_id` FROM `util_info` WHERE `util_id` = 192742 AND stripe_account_id IS NOT NULL AND stripe_account_id != ''
0.0001
SELECT M.match_step FROM `match` as M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 192742 AND W.type_id = 1) OR (W.util_id != 192742 AND W.type_id = 2)) AND (`post_util_id` = 192742 OR `dest_util_id` = 192742) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
0.0001
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='192742' AND note_visu IN (1,3,4)
0.0001
SELECT `empreinte_carbone`,s.prix_leroymerlin, s.prix_loxam, s.prix_kiloutou FROM `ssrubr` as s INNER JOIN wish as w ON w.ssrubr_id = s.ssrubr_id WHERE w.wish_id = '376713'
0.0001
SELECT w.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id FROM wish w INNER JOIN util_info ui ON w.util_id = ui.util_id WHERE wish_visu IN (1,6,10) AND w.util_id='192742' AND wish_id<>'376713' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
0.0001
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='11000'
0.0036
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((43.2167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((43.2167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.35- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>42.767039197041 AND ville_latitude_deg<43.666360802959 AND ville_longitude_deg>1.7329795519866 AND ville_longitude_deg<2.9670204480134 HAVING distance <= 50 ORDER BY distance ASC
0.0025
SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id WHERE wish_visu IN (1,6,10) AND wish_cp IN (11000,11570,11610,11620,11090,11800,11600,11570,11570,11600,11170,11290,11800,11250,11800,11600,11250,11610,11290,11170,11600,11250,11290,11800,11600,11170,11600,11800,11800,11290,11600,11250,11250,11170,11800,11570,11250,11250,11600,11170,11800,11250,11570,11600,11600,11600,11600,11250,11600,11800,11220,11800,11600,11170,11300,11160,11800,11170,11800,11600,11250,11300,11600,11380,11220,11160,11390,11800,11290,11170,11800,11380,11250,11300,11250,11250,11390,11300,11220,11300,11220,11170,11700,11380,11160,11380,11380,11390,11310,11150,11240,11160,11300,11300,11150,11380,11250,11300,11240,11700,11300,11160,11310,11220,11220,11220,11220,11160,11700,11270,11580,11390,11290,11700,11220,11160,11300,11240,11220,11170,11250,11150,11240,11380,11300,11240,11310,11300,11310,11580,11240,11170,11300,11310,11700,11700,11160,11240,11270,11220,11300,11240,11270,11300,11220,34210,11240,11580,11170,11700,11270,11160,11700,11300,11330,11240,11700,11390,11580,11220,34210,11150,11580,11580,11160,11200,11300,11150,11300,11580,11220,11330,11700,11240,11300,11300,11220,11300,11700,11700,11190,11400,11220,11190,34210,11240,11240,81110,11330,11400,11200,11270,34210,11300,11400,11190,11330,11400,11300,11700,11190,11240,11220,81200,81200,11270,11190,11190,11700,11330,11200,81240,11300,11190,11400,11200,11240,11190,11200,11330,11240,11300,11300,34210,11190,11190,11190,81540,11190,11240,11200,11400,11300,11330,34210,81240,11330,11220,11400,81200,81660,11230,11200,11270,81660,11220,11230,81240,81240,11300,11190,34210,11240,11270,11230,11400,11230,81240,81290,11330,11260,81660,11190,81200,81540,11270,81110,11330,11200,11330,11400,11200,11400,11190,11400,11400,11400,34210,11270,11260,81110,81240,11330,34210,11400,11270,11270,81540,81240,81110,09500,11240,34210,11230,11190,11330,34220,11200,11270,11260,11260,34210,09500,81290,81540,11500,09500,11200,09500,09500,11230,81110,11220,11200,11260,11500,11220,81270,11190,31250,09500,11400,11400,34220,11230,11330,81290,11270,11200,11500,11270,11230,11200,11400,34210,81110,11400,11230,81540,11330,34220,11230,09500,11400,11230,81110,81090,11330,11350,11330,34220,81090,11400,11200,11200,11360,11400,81290,11420,09600,11190,11410,31250,11360,11500,11230,81490,11120,34210,34210,11500,11200,11190,81710,11120,11200,81240,09600,11500,11350,11330,11420,81110,09500,11420,11360,11200,11500,11320,81490,11120,11500,11320,11120,81260,11410,81260,11360,81580,34220,09500,11200,11420,81700,11230,11410,11420,09500,11500,11410,81700,34210,11320,11420,11500,81260,81700,81710,11230,09500,11350,66220,11200,34360,11410,11500,81100,11120,11420,11200,11500,31540,09600,11360,09600,11410,11320,09500,81700,66220,11200,11120,11120,11420,81700,11140,81490,31540,11500,09600,31540,11410,11410,34220,09600,11360,81570,81580,09500,11120,81700,09500,11320,09500,81260,11350,11320,09600,11120,66220,11140,31540,11340,11320,11360,09600,34310,81100,66220,11120,11350,11100,11410,31540,34220,11120,11410,11140,81570,81700,11140,81470,34330,81260,11350,11140,09500,11410,34360,81570,81470,11140,34360,09600,09600,34360,09300,11140,09500,81700,31290,81470,31540,11120,11420,66220,66220,09300,66460,11410,11590,31290,11410,31540,09600,66220,11140,31540,11360,09300,11360,09600,31540,09300,09500,09500,09500,09500,81570,81260,81470,81100,11490) AND fami_id='5' AND cate_id='193' AND type_id='2' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='505' AND wish_id<>'376713' AND wish_url='' ORDER BY rand() LIMIT 0,10
0.0001
SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='505' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=433365 AND note_visu IN (1,3,4)
0.0001
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 433365 AND W.type_id = 1) OR (W.util_id != 433365 AND W.type_id = 2)) AND (`post_util_id` = 433365 OR `dest_util_id` = 433365) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
0.0001
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 433365
0.0001
SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='505' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=173438 AND note_visu IN (1,3,4)
0.0001
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 173438 AND W.type_id = 1) OR (W.util_id != 173438 AND W.type_id = 2)) AND (`post_util_id` = 173438 OR `dest_util_id` = 173438) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
0.0001
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 173438
0
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 505
0.0008
SELECT AVG(note) as note_moy FROM note WHERE note_visu IN (1,2,3,4) AND post_util_id<>7
0
SELECT count(*) as nbwish FROM wish
0.0514
SELECT note.*, post.util_prenom as postp, post.util_nom as postn, dest.util_prenom as destp, dest.util_nom as destn, w.wish_id, w.wish_desc, w.fami_id FROM note, util_info dest, util_info post, wish w WHERE note.wish_id=w.wish_id AND note.post_util_id=post.util_id AND note.dest_util_id=dest.util_id AND note_visu IN (1,2,3,4) AND post_util_id<>'7' ORDER BY note_date DESC, note_hour DESC

52 requetes sql en 0.0637

Taille variable Globale : 75.16 KB