Réserver
Description de l'annonce
Loue bonne terre riche 10€ les 100 m²
Pommera .
A 5mn de Doullens.
#jardin potager
Indiquer un code postal ou une ville
Poster une annonce
Réserver
Loue bonne terre riche 10€ les 100 m²
Pommera .
A 5mn de Doullens.
#jardin potager
Annonces similaires
Tout voirLouer un jardin entre particuliers ou proposer un jardin en location.
Poster une annonceEnvoyer un message
Vous pourrez dialoguer & organiser un rendez-vous.
Réserver maintenant !
Prix estimé
10€
Pour appeler mon voisin & organiser le rendez-vous.
Assistance support Kiwiiz
Comment pouvons-nous vous aider ?
Script : /wiiz-annonce.php
SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt=''
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='429183'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='jardin-potager' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='1173'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'jardin-potager' LIMIT 1
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='88'
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE filtre_dpt='80'
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='227920' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 227920
SELECT fami_id as id, fami_title as title, fami_tutotitle, fami_tutodesc, fami_buttontitle, fami_url as slug FROM `family`
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 = 429183
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=1173 LIMIT 1
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='429183'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='429183' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 227920 AND util_tel != ''
SELECT `stripe_account_id` FROM `util_info` WHERE `util_id` = 227920 AND stripe_account_id IS NOT NULL AND stripe_account_id != ''
SELECT M.match_step FROM `match` as M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 227920 AND W.type_id = 1) OR (W.util_id != 227920 AND W.type_id = 2)) AND (`post_util_id` = 227920 OR `dest_util_id` = 227920) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='227920' AND note_visu IN (1,3,4)
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 = '429183'
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='227920' AND wish_id<>'429183' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='80600'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.2*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.2*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.46667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.750339197041 AND ville_latitude_deg<50.649660802959 AND ville_longitude_deg>1.7641881920031 AND ville_longitude_deg<3.1691518079969 HAVING distance <= 50 ORDER BY distance ASC
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 (80600,62158,62158,80600,62760,62810,62760,62760,62760,62810,62810,62158,62760,62760,62810,62810,62760,62158,80600,80600,62810,62760,62810,62760,62760,62810,62158,62760,62810,62158,62158,62760,62760,62111,62810,62810,62760,62810,62760,80560,62810,62810,62111,80600,62760,80560,62123,80600,80600,62270,62810,62810,62810,80600,62123,80560,62270,62111,80560,80560,62810,62810,80560,62270,62810,62270,80600,62270,62123,80560,62123,80600,62123,62111,80600,62810,62111,80560,62270,62810,62270,62127,62123,62127,62127,62127,62123,62123,62690,80600,80560,62111,80600,62130,80560,62111,62270,62123,80630,80560,80600,80560,62127,62270,62123,80600,62111,62111,80560,62690,62130,62270,62270,62123,62123,80600,62173,80560,62127,62173,80600,62690,62123,80600,62123,62270,62130,62116,80600,62127,62127,80560,62127,62123,80560,62270,62130,80560,62690,62270,80600,80560,62130,62690,62173,62270,62161,80560,80560,62390,62116,62116,80600,80300,80560,62127,62127,62270,80560,62217,62690,62130,62130,62144,62175,80370,62270,62161,80750,62116,80750,62690,62130,62690,80300,80300,62270,62173,62116,80370,62130,62390,62116,62690,80260,62690,80300,62000,62270,80670,62175,80370,62690,62130,62390,80260,80300,62127,80260,62130,62270,62270,62161,62161,80670,62144,80300,62690,80260,62175,62130,62121,80370,80370,62390,62270,62690,62690,80300,80300,62121,80560,80560,62127,62127,62130,80300,62127,62175,62217,62390,62217,80370,80260,62130,62130,80260,62130,62121,62130,62690,62390,62130,80260,80300,80300,80370,62150,80300,62130,62144,80300,62130,62144,80300,62390,62217,62130,80300,62121,62175,80370,62223,62217,62223,80620,80260,80260,62150,80670,80300,62130,62130,62000,62121,80370,80670,62223,62690,62150,80260,62121,62130,80300,80670,62128,80370,80300,62770,62121,62128,80300,80300,62390,62130,62270,80670,62390,62150,80300,80370,62217,62130,80300,80300,62150,80260,80260,62217,62223,62460,80260,62223,80370,80370,80260,80800,62150,62530,62223,80670,80620,62144,62128,62121,80370,62130,62450,62550,62128,62450,62153,62580,80260,62150,80850,62121,62121,62130,80260,80300,80370,62450,62128,80370,62390,62130,62530,80370,80800,80620,62130,80800,62460,62390,62390,62130,62159,80300,80650,80260,62770,62770,62172,80810,62770,80370,62150,62550,80260,62450,80113,62150,62770,80620,62450,80300,62390,62223,62450,62130,80300,80300,62134,80300,62153,80113,62128,62223,62450,62580,62128,80150,62620,80300,80260,80620,80780,80260,62450,62130,62160,62550,80260,62450,80620,62580,62770,62134,62128,80150,80115,80150,62460,62620,80300,80115,80800,62550,62770,80360,80300,62770,62128,80370,80260,62134,80300,80620,62770,62390,62530,62620,62940,62550,80260,80360,62140,62580,80360,62580,62580,80610,62450,80620,62143,62134,62160,80300,62470,62470,80260,80800,80800,80310,62118,80300,62450,62390,62118,62550,62134,62114,62700,62550,62134,62580,62770,62770,80360,62550,80800,80800,62128,62128,62128,62450,80620,62800,62770,62140,80610,62450,62128,62128,62450,62118,62550,80800,80150,62134,62159,80800,62770,62134,62770,62580,62140,80360,80690,62620,80136,80150,62118,62390,62260,80135,80800,80800,62260,62134,80150,62140,80800,80340,62550,80690,80690,62540,62160,62134,62156,80800,62118,62580,62134,62670,62580,62450,80360,80620,80135,80420,80420,80800,62450,62210,62770,80360,62182,80150,62182,80150,62124,62140,62290,62450,80340,80470,80340,62770,62300,62131,62196,80360,62156,62159,80800,62140,62580,62140,62140,62134,80690,80360,80135,80340,62156,80150,62124,80800,80310,62540,80690,80440,62131,62131,62260,80000,80080,80090,62310,62122,62550,80360,62140,80730,80730,80470,80150,62124,80690,80450,62550,62750,80310,80310,62310,80470,62770,62122,62550,80800,62140,62320,62156,80360,80310,80830,80135,62140,62580,62680,62118,80830,62980,62450,62199,62490,80450,62113,62134,80340,62140,62140,62124,62232,62134,62300,62310,62980,62232,62124,80470,62860,80150,80360,62320,62140,62140,80360,62151,62157,62310,80380,62113,62113,62118,62430,62770,80340,80310,62124,80135,80310,80310,80440,62260,62310,80340,62156,80135,80340,80800,62550,62920,62149,62134,62320,62320,62310,62124,62140,62550,80330,80330,62182,80890,80150,80150,62860,62149,62140,80340,62660,80480,62221,62218,62960,62232,62232,62156,62310,62182,80340,62400,62140,80170,80380,80380,80121,80200,80470,80340,62490,62124,62490,80360,62420,62190,62190,62147,80510,80360,80150,62140,80150,62124,80440,80730,62156,80150,62190,80720,62490,62960,62960,62147,80510,62920,62410,62310,62960,80200,80480,80480,80132,62310,80340,62860,62144,80170,62124,80980,62149,62310,62140,62960,80150,62860,80170,80200,80310,80135,62190,62190,62124,80690,62190,62310,62410,62140,80440,62190,62120,62110,62140,59259,62960,80132,62880,62490,62140,62740,62140,80110,80510,80360,62124,80132,62490,80720,62920,62120,62147,62400,80131,80480,62440,62860,80150,62310,62410,80131,62860,80132,80310,80200,62138,62117,62860,80150,62880,62880,62310,62990,62149,80310,62640,62232,80680,62124,62310,80132,80510,62490,80150,80131,80340,80200,80310,62310,62138,80540,80200,80150,80200,80580,80110,62190,80110,80110,62860,80110,62350,80540,62120,62490,80132,80110,80270,80760,62860,62860,62147,80132,62400,80200,62310,62710,59553,80480,62149,80310,62310,62138,80360,80200,62112,62350,62880,80720,62138,80340,80540,62950,62860,62145,80680,59480,62960,62112,62870,80480,80540,59151,80580,80490,80200,80270,62870,62310,80540,80580,62990,80110,80110,62145,62410,80170,80200,80200,59552,80540,62120,80580,59151,62310,80440,62120,62147,62990,62119,80200,80320,62350,62120,62120,80270,80240,80150,59169,62860,62138,62860,62145,62124,80580,59496,62310,62960,62990,80540,62560,80360,62310,62310,62860,80150,62136,62147,62970,59221,59151,59552,62310,80240,62870,62990,62990,80480,80540,80200,80200,62136,80200,62147,59553,59553,80160,80170,80540,80150,80120,62330,62330,80680,62860,62136,80200,80132,80132,80100,59500,62840,62560,62860,62120,80440,80110,59400,80132,59496,80110,80250,62350,59169,62120,62350,80250,62990,62870,62990,80540,80580,59128,80240,80110,80680,80240,80150,62590,62990,80240,59267,62120,80250,80320,62990,62220,62145,80132,80132,80540,59169,59185,62350,80200,59159,80200,80270,80320,80490,62990,62141,59950,59151,80150,80540,80120,80270,62870,80490,80680,59274,62840,80110,80110,80270,80320,80200,80540,80250,59480,80160,80160,80160,80170,62350,62120,80122,80270,62560,62560,62136,80320,80170,80160,80110,59162,80200,59134,80240,80240,62120,59187,80200,80270,80132,59231,59231,80240,80860,80118,62870,59184,59660,80170,62860,59134,59112,80640,80160,59450,62870,80200,59554,59151,59265,80970,62990,62790,59554,62990,59400,59286,59112) AND fami_id='5' AND cate_id='88' AND type_id='1' AND ssrubr_id='1173' AND wish_id<>'429183' AND wish_url='' ORDER BY rand() LIMIT 0,10
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='1173' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=316800 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 316800 AND W.type_id = 1) OR (W.util_id != 316800 AND W.type_id = 2)) AND (`post_util_id` = 316800 OR `dest_util_id` = 316800) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 316800
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='1173' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=270060 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 270060 AND W.type_id = 1) OR (W.util_id != 270060 AND W.type_id = 2)) AND (`post_util_id` = 270060 OR `dest_util_id` = 270060) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 270060
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='1173' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=145958 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 145958 AND W.type_id = 1) OR (W.util_id != 145958 AND W.type_id = 2)) AND (`post_util_id` = 145958 OR `dest_util_id` = 145958) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 145958
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='1173' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=229040 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 229040 AND W.type_id = 1) OR (W.util_id != 229040 AND W.type_id = 2)) AND (`post_util_id` = 229040 OR `dest_util_id` = 229040) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 229040
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 1173
SELECT AVG(note) as note_moy FROM note WHERE note_visu IN (1,2,3,4) AND post_util_id<>7
SELECT count(*) as nbwish FROM wish
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
Contactez-nous