Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

Location de chambres

Autres annonces du voisin

Tout voir
Location videoprojecteur
Location videoprojecteur

Demande il y a + de 30j

Il y a + de 30j

LOCATION VIDéO PROJECTEUR
Profil du voisin
Christian C

Nemours 77140

40€/j

Louer mon projecteur

Annonces similaires

Tout voir
Location chambre en colocation
Location chambre en colocation

Demande il y a + de 30j

Il y a + de 30j

COLOCATION OU SOUS LOCATION URGENT SVP
Profil du voisin
Cecilia P

Sens 89100

250€/m

Louer ma chambre
Location chambre en colocation
Location chambre en colocation

Demande il y a + de 30j

Il y a + de 30j

ETUDIANTE RECHERCHE COLOCATION (12 MOIS)
Profil du voisin
Melika L

Melun 77000

100€

Louer ma chambre
Location chambre en colocation
Location chambre en colocation

Demande il y a + de 30j

Il y a + de 30j

CHAMBRE CHEZ L'HABITANT
Profil du voisin
Sébastien H

Montargis 45200

250€/m

Louer ma chambre
Location chambre en colocation
Location chambre en colocation

Demande il y a + de 30j

Il y a + de 30j

éTUDIANTE CHERCHE CHAMBRE à LOUER (6 M
Profil du voisin
Trecia N

Evry 91000

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 ?

Script : /wiiz-annonce.php

  1. 0.0001

    SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt=''

  2. 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='304436'

  3. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='chambre-en-colocation' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='505'

  4. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'chambre-en-colocation' LIMIT 1

  5. 0.0001

    SELECT c.cate_id, c.cate_title, 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'

  6. 0

    SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE filtre_dpt='45'

  7. 0.0001

    SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='98642' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  8. 0

    SELECT `util_tel` FROM `util_info` WHERE `util_id` = 98642

  9. 0

    SELECT fami_id as id, fami_title as title, fami_tutotitle, fami_tutodesc, fami_buttontitle, fami_url as slug FROM `family`

  10. 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

  11. 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

  12. 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

  13. 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 (81) ORDER BY ssrubr_order ASC

  14. 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 (110) ORDER BY ssrubr_order ASC

  15. 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 (227) ORDER BY ssrubr_order ASC

  16. 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

  17. 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

  18. 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

  19. 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

  20. 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

  21. 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

  22. 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

  23. 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 (83) ORDER BY ssrubr_order ASC

  24. 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

  25. 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

  26. 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

  27. 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

  28. 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

  29. 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 = 304436

  30. 0

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=505 LIMIT 1

  31. 0.0001

    SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='304436'

  32. 0.0001

    SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='304436' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')

  33. 0

    SELECT `util_tel` FROM `util_info` WHERE `util_id` = 98642 AND util_tel != ''

  34. 0

    SELECT `stripe_account_id` FROM `util_info` WHERE `util_id` = 98642 AND stripe_account_id IS NOT NULL AND stripe_account_id != ''

  35. 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 = 98642 AND W.type_id = 1) OR (W.util_id != 98642 AND W.type_id = 2)) AND (`post_util_id` = 98642 OR `dest_util_id` = 98642) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  36. 0.0001

    SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='98642' AND note_visu IN (1,3,4)

  37. 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 = '304436'

  38. 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='98642' AND wish_id<>'304436' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  39. 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='674' LIMIT 0,1

  40. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=98642 AND note_visu IN (1,3,4)

  41. 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 = 98642 AND W.type_id = 1) OR (W.util_id != 98642 AND W.type_id = 2)) AND (`post_util_id` = 98642 OR `dest_util_id` = 98642) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  42. 0.0002

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 98642

  43. 0.0001

    SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='77140'

  44. 0.005

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.2833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.2833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.78333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>47.833639197041 AND ville_latitude_deg<48.732960802959 AND ville_longitude_deg>2.1075965791112 AND ville_longitude_deg<3.4590634208888 HAVING distance <= 50 ORDER BY distance ASC

  45. 0.0026

    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 (77140,77710,77140,77250,77710,77690,77250,77140,77710,77140,77690,77880,77250,77710,77140,77710,77167,77250,77167,77780,77250,77710,77250,77130,77460,77250,77710,77130,77167,77940,77760,77570,77167,77670,77460,77156,77940,77167,77670,77760,77710,77810,77430,77760,77710,77130,77570,77760,77940,77210,77130,77300,77620,77570,77710,77760,77940,45680,77210,77760,77940,77620,77940,77570,77570,77570,77130,77870,45210,77130,77760,77760,77940,77890,45210,77940,77890,77830,77760,89690,77850,77133,77920,89150,45210,77133,77130,77830,77890,89340,77570,45210,45210,89150,77890,45210,77890,77130,77148,89140,77760,77123,77760,77760,77590,45210,77130,77890,77630,89340,45490,45390,77130,89150,45210,89150,77590,45210,89720,45210,77148,77123,77630,77590,77630,89370,45390,77830,45490,77130,89140,77820,45490,77126,45490,77123,77820,45120,77130,45210,77930,45210,45390,89150,77930,91490,77000,89340,77760,77154,89150,77190,77760,45330,45120,45390,45390,45120,89150,45320,91490,89140,77930,77000,77520,45330,77760,77930,45490,77126,45390,45210,77820,45200,77118,77890,77115,89150,77190,77930,45320,45490,45320,77930,45340,89140,89150,77350,91490,45210,45390,89140,77118,89150,45390,77000,77000,77370,91490,45320,45490,45390,89140,45490,77154,77126,91490,45390,77350,45120,77950,45340,89150,77350,45700,45210,91840,45330,77950,77310,91720,89140,89150,77720,45210,45210,45700,45330,45390,77520,89140,45320,77720,91720,91720,45270,77115,91720,45200,77720,77720,45490,77720,91750,77310,77370,77370,91720,77118,89100,77950,45270,77950,45390,77520,77310,45340,91890,45340,89150,45330,89100,89140,89140,77390,77720,45340,89100,89140,91720,77520,89150,77370,45300,77240,45700,45340,77950,45700,89500,45320,45300,77240,77240,45220,77950,91820,45200,89140,45330,89140,77176,77520,89140,89500,77480,91590,77520,91150,77390,77390,56310,89100,89100,45340,91820,91830,45270,91750,77520,77520,45270,89140,77720,77720,89100,77480,91720,77520,77370,89100,45300,77480,77480,77480,89100,45270,45220,45700,89140,77520,77176,45330,45700,45300,45700,77390,77550,45220,89330,45300,45220,77720,45300,45300,77370,77550,45700,91590,91250,91830,91750,77520,77550,91590,45340,89260,89100,45300,91150,77520,45340,29990,77480,45700,89100,45340,91150,89140,77390,89100,91590,77134,91150,89500,77390,45340,77390,45300,77370,77390,45270,91880,77720,77550,89100,89100,91610,45300,77370,91590,77157,91590,89500,77650,91150,77480,45220,77650,89510,45340,77370,45300,91540,91540,77390,45270,45270,77370,45260,45260,91250,91540,77650,45220,45270,77650,45300,77111,89330,45340,45300,45340,89500,77390,91590,45270,89140,91150,77111,91100,77650,45300,91100,45220,77390,91150,89510,77160,89330,45290,45220,45300,45300,91150,91760,77370,91590,89100,77370,89500,91540,77127,91280,77370,77540,89100,45700,77480,45700,45700,91710,89100,77480,77166,77390,45260,89510,77170,45700,77114,77650,91250,45300,45300,91770,77540,77160,45300,45300,91810,91150,91850,45270,91250,45340,77650,89500,91580,45220,91090,77480,77480,77160,77390,45290,89260,45340,89330,89116,45260,45290,89100,77540,77166,45260,45300,91450,89120,45270,77380,45300,89260,77114,45300,45300,91690,91000,91090,89120,91510,91510,77650,77170,91150,77160,91580,89100,77114,77220,77970,45230,77610,45300,91480,77540,29830,45300,91080,91630,45230,77610,77480,89260,45300,91480,77114,91150,89760,45260,77540,89500,89330,45290,91070,91690,89760,45300,89120,91630,91450,91690,89260,91660,91800,77160,77160,45290,77220,91630,77160,89120,45300,89190,45530,91150,91860,91690,89760,45260,89120,77610,29300,77160,91000,89500,45300,91130,77173,56650,91730,91730,77160,56620,10400,91580,89116,94520,94520,89330,45230,91630,91700,77141,91150,45260,77970,89116,89120) 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<>'304436' AND wish_url='' ORDER BY rand() LIMIT 0,10

  46. 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

  47. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=261990 AND note_visu IN (1,3,4)

  48. 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 = 261990 AND W.type_id = 1) OR (W.util_id != 261990 AND W.type_id = 2)) AND (`post_util_id` = 261990 OR `dest_util_id` = 261990) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  49. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 261990

  50. 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

  51. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=370394 AND note_visu IN (1,3,4)

  52. 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 = 370394 AND W.type_id = 1) OR (W.util_id != 370394 AND W.type_id = 2)) AND (`post_util_id` = 370394 OR `dest_util_id` = 370394) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  53. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 370394

  54. 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

  55. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=162808 AND note_visu IN (1,3,4)

  56. 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 = 162808 AND W.type_id = 1) OR (W.util_id != 162808 AND W.type_id = 2)) AND (`post_util_id` = 162808 OR `dest_util_id` = 162808) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  57. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 162808

  58. 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

  59. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=519722 AND note_visu IN (1,3,4)

  60. 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 = 519722 AND W.type_id = 1) OR (W.util_id != 519722 AND W.type_id = 2)) AND (`post_util_id` = 519722 OR `dest_util_id` = 519722) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  61. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 519722

  62. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 505

  63. 0.0008

    SELECT AVG(note) as note_moy FROM note WHERE note_visu IN (1,2,3,4) AND post_util_id<>7

  64. 0

    SELECT count(*) as nbwish FROM wish

  65. 0.0473

    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

65 requetes sql en 0.0625

Taille variable Globale : 76.55 KB