Gazon synthétique 85 - Exelgreen

Gazon synthétique : 85

SELECT s.*,sx.points,sx.review_date,cl.name country, st.iso_code state, cl.id_country id_country FROM xgr_store s INNER JOIN xgr_store_shop store_shop ON (store_shop.id_store = s.id_store AND store_shop.id_shop = 1) LEFT JOIN xgr_country_lang cl ON (cl.id_country = s.id_country AND s.id_country=8) LEFT JOIN xgr_state st ON (st.id_state = s.id_state) INNER JOIN xgr_store_extrafields sx ON (sx.id_store= s.id_store) WHERE s.postcode like '85' AND s.active = 1 AND YEAR(sx.review_date) >= YEAR(CURDATE())-1 AND (sx.points between 6 and 8.4) AND s.id_store NOT IN (811,674,196,854,61,708,44,91,732,1134,2356,938,1717,2327,1075,2332,2455,1077,2896,2687,1389,2981,1495,3001,1426,617,3100,768) AND cl.id_lang =1 ORDER BY sx.points DESC SELECT s.*,sx.points,sx.review_date,cl.name country, st.iso_code state, cl.id_country id_country FROM xgr_store s INNER JOIN xgr_store_shop store_shop ON (store_shop.id_store = s.id_store AND store_shop.id_shop = 1) LEFT JOIN xgr_country_lang cl ON (cl.id_country = s.id_country AND s.id_country=8) LEFT JOIN xgr_state st ON (st.id_state = s.id_state) INNER JOIN xgr_store_extrafields sx ON (sx.id_store= s.id_store) WHERE s.postcode like '85%' AND s.active = 1 AND YEAR(sx.review_date) >= YEAR(CURDATE())-1 AND (sx.points between 6 and 8.4) AND s.id_store NOT IN (811,674,196,854,61,708,44,91,732,1134,2356,938,1717,2327,1075,2332,2455,1077,2896,2687,1389,2981,1495,3001,1426,617,3100,768) AND cl.id_lang =1 ORDER BY sx.points DESC SELECT s.*,sx.points,sx.review_date,cl.name country, st.iso_code state, cl.id_country id_country FROM xgr_store s INNER JOIN xgr_store_shop store_shop ON (store_shop.id_store = s.id_store AND store_shop.id_shop = 1) LEFT JOIN xgr_country_lang cl ON (cl.id_country = s.id_country AND s.id_country=8) LEFT JOIN xgr_state st ON (st.id_state = s.id_state) INNER JOIN xgr_store_extrafields sx ON (sx.id_store= s.id_store) WHERE s.postcode like '85' AND s.active = 1 AND YEAR(sx.review_date) >= YEAR(CURDATE())-1 AND (sx.points >= 8.5) AND s.id_store NOT IN (811,674,196,854,61,708,44,91,732,1134,2356,938,1717,2327,1075,2332,2455,1077,2896,2687,1389,2981,1495,3001,1426,617,3100,768) AND cl.id_lang =1 ORDER BY sx.points + 0 DESC SELECT s.*,sx.points,sx.review_date,cl.name country, st.iso_code state, cl.id_country id_country FROM xgr_store s INNER JOIN xgr_store_shop store_shop ON (store_shop.id_store = s.id_store AND store_shop.id_shop = 1) LEFT JOIN xgr_country_lang cl ON (cl.id_country = s.id_country AND s.id_country=8) LEFT JOIN xgr_state st ON (st.id_state = s.id_state) INNER JOIN xgr_store_extrafields sx ON (sx.id_store= s.id_store) WHERE s.postcode like '85%' AND YEAR(sx.review_date) >= YEAR(CURDATE())-1 AND s.active = 1 AND (sx.points >= 8.5) AND s.id_store NOT IN (811,674,196,854,61,708,44,91,732,1134,2356,938,1717,2327,1075,2332,2455,1077,2896,2687,1389,2981,1495,3001,1426,617,3100,768) AND cl.id_lang =1 ORDER BY sx.points + 0 DESC
BRICOMARCHE LE FENOUILLER
BRICOMARCHE LE FENOUILLER

Rue de Nantes 85800 Le Fenouiller

Téléphone: 02 51 60 04 97
MAGASIN VERT DE SAINT HILAIRE DE RIEZ
MAGASIN VERT DE SAINT HILAIRE DE RIEZ

130 avenue de l'Isle de Riez 85270 ST HILAIRE DE RIEZ

Téléphone: 02 51 55 33 33
MAGASIN VERT DE FONTENAY
MAGASIN VERT DE FONTENAY

Zone des 3 Canons 85200 FONTENAY LE COMTE

Téléphone: 02 51 51 18 10
VILLAVERDE OLONNE
VILLAVERDE OLONNE

261 avenue Francois Mitterrand 85340 OLONNE SUR MER

Téléphone: 02 51 95 60 59
JARDILAND LA ROCHE SUR YON
JARDILAND LA ROCHE SUR YON

Zone de Beaupuy 85000 LA ROCHE SUR YON

Téléphone: 02 51 37 41 83
BRICOMARCHE LUCON
BRICOMARCHE LUCON

3 Rue Léon Ballereau 85400 LUCON

Téléphone: 02 51 56 95 15
MAGASIN VERT DE LUCON
MAGASIN VERT DE LUCON

Route de Fontenay 85400 LUCON

Téléphone: 02 51 27 95 39
MAGASIN VERT DE BOUFFERE
MAGASIN VERT DE BOUFFERE

ZA de Bellevue 85600 BOUFFERE

Téléphone: 02 51 07 77 77
MAGASIN VERT DES HERBIERS
MAGASIN VERT DES HERBIERS

ZA de la Tibougere 85500 LES HERBIERS

Téléphone: 02 51 61 07 00
BRICOMARCHE FONTENAY LE COMTE
BRICOMARCHE FONTENAY LE COMTE

12 Rue Henri Aucher 85200 FONTENAY LE COMTE

Téléphone: 02 28 13 06 10
MA CAMPAGNE CHALLANS
MA CAMPAGNE CHALLANS

Rue Albert Camus 85300 Challans

Téléphone: 02 51 93 54 34
BRICO E.LECLERC LES HERBIERS
BRICO E.LECLERC LES HERBIERS

Avenue des Chauvières 85500 LES HERBIERS

Téléphone: 02 51 92 04 95
GAMM VERT SAINT GILLES CROIX DE VIE
GAMM VERT SAINT GILLES CROIX DE VIE

Rue des Potiers 85800 ST GILLES CROIX DE VIE

Téléphone: 02 51 54 91 15
GAMM VERT LA ROCHE SUR YON
GAMM VERT LA ROCHE SUR YON

ZAC Roche Sud 85000 LA ROCHE SUR YON

Téléphone: 02 51 36 54 18
MAGASIN VERT DES OLONNES
MAGASIN VERT DES OLONNES

54 Avenue de Talmont 85180 CHATEAU D'OLONNE

Téléphone: 02 51 22 15 96
FRANCE RURALE TALMONT
FRANCE RURALE TALMONT

373 Avenue des Sables 85440 TALMONT ST HILAIRE

Téléphone: 02 51 90 61 23
JB SERVICES BRICO JARDIN
JB SERVICES BRICO JARDIN

Rue de la Rive 85300 CHALLANS

Téléphone: 02 51 49 31 30
MAGASIN VERT DE CHANTONNAY
MAGASIN VERT DE CHANTONNAY

ZONE POLARIS 85110 CHANTONNAY

Téléphone: 02 51 34 41 61
GAMM VERT FONTENAY LE COMTE
GAMM VERT FONTENAY LE COMTE

Rue Louis Capelle 85200 FONTENAY LE COMTE

Téléphone: 02 51 69 30 94
GAMM VERT CHALLANS
GAMM VERT CHALLANS

100 avenue du Docteur Schwetzer 85300 CHALLANS

Téléphone: 02 51 93 52 00
GAMM VERT LUCON
GAMM VERT LUCON

117 Rue Du Président de Gaulle 85400 Luçon

Téléphone: 02 51 56 38 37
GAMM VERT LES HERBIERS
GAMM VERT LES HERBIERS

4 avenue du Maine 85500 LES HERBIERS

Téléphone: 02 51 66 92 17