****************
SELECT P.id,P.modelo,P.pvp,P.descuento_tienda,I.img_pr,( P.pvp - (P.pvp * (P.descuento_tienda / 100) ) + ( P.pvp - (P.pvp * (P.descuento_tienda / 100) ) ) * 0.21 ) as precio_filtro ,P.activo FROM productos AS P ,pr_site2prod as S2P ,pr_imagenes AS I ,pr_categorias as C WHERE P.id > 0 AND P.activo = 1 AND S2P.idprod = P.id AND S2P.idsite = 1 AND I.idimg = P.portada AND P.idcat = C.idcat AND P.idcat IN (303, 414, 428, 429, 430, 431, 432, 433, 434, 448, 415, 435, 436, 437, 438, 439, 440, 441, 442, 443, 444) AND P.portada = I.idimg ORDER BY C.orden ASC LIMIT 500 OFFSET 0
****************


Sitio oficial de Varlion
Inicio > OUTLET > Pádel > Textil
67,46%

Padel Gris

91,90€29,90€
61,03%

Aniversary Blanco

63,90€24,90€
61,03%

Aniversary Azul Marino

63,90€24,90€
67,46%

Padel Azul

91,90€29,90€
67,46%

Padel Blanco

91,90€29,90€
56,64%

Performance Celeste

45,90€19,90€
55,68%

Tech Magenta

44,90€19,90€
89,11%

Original Rosa

45,90€5,00€
89,11%

Original Azul

45,90€5,00€
51,34%

Dynamic Turquesa

40,90€19,90€
54,67%

Original Blanco

43,90€19,90€
55,68%

Premium Verde

44,90€19,90€
46,93%

Aniversary Blanco

37,50€19,90€
51,34%

Dynamic Gris

40,90€19,90€
51,34%

Dynamic Negro

40,90€19,90€
55,68%

Premium Azul

44,90€19,90€
46,93%

Aniversary Celeste

37,50€19,90€
46,93%

Aniversary Rojo

37,50€19,90€
54,67%

Original Rosa

43,90€19,90€
54,67%

Original Amarillo

43,90€19,90€
55,68%

Tech Turquesa

44,90€19,90€
55,68%

Tech Negro

44,90€19,90€
56,64%

Performance Verde

45,90€19,90€
56,64%

Performance Granate

45,90€19,90€
51,34%

Tech Turquesa

40,90€19,90€
54,67%

Performance Naranja

43,90€19,90€
55,78%

Dynamic Naranja

45,00€19,90€
52,51%

Original Blanco

41,90€19,90€
53,17%

Premium Blanco

42,50€19,90€
51,34%

Aniversary Blanco

40,90€19,90€
53,17%

Premium Verde

42,50€19,90€
55,78%

Dynamic Celeste

45,00€19,90€
55,78%

Dynamic Rosa

45,00€19,90€
51,34%

Aniversary Azul Marino

40,90€19,90€
52,51%

Original Azul

41,90€19,90€
52,51%

Original Gris

41,90€19,90€
51,34%

Tech Magenta

40,90€19,90€
51,34%

Tech Negro

40,90€19,90€
77,45%

Original Gris Claro

43,90€9,90€
77,45%

Original Gris

43,90€9,90€
52,55%

Active Azul

41,94€19,90€
55,79%

Impulse Azul

45,01€19,90€
55,79%

Impulse Negro

45,01€19,90€
55,79%

Impulse Rosa

45,01€19,90€
42,76%

Deluxe Morado

34,76€19,90€
62,78%

Dynamic Rosa

66,90€24,90€
65,63%

Premium Azul

57,90€19,90€
65,63%

Premium Verde

57,90€19,90€
62,78%

Dynamic Negro

66,90€24,90€
62,78%

Dynamic Turquesa

66,90€24,90€
53,61%

Tech Blanco

42,90€19,90€
56,64%

Original Gris Claro

45,90€19,90€
55,46%

Elegance Granate

55,90€24,90€
55,28%

Dynamic Naranja

44,50€19,90€
54,67%

Original Azul

43,90€19,90€
55,68%

Premium Azul

44,90€19,90€
47,49%

Aniversary Rojo

37,90€19,90€
54,67%

Aniversary Tablas Blanco

43,90€19,90€
54,67%

Aniversary Tablas Azul Marino

43,90€19,90€
55,28%

Dynamic Rosa

44,50€19,90€
55,28%

Dynamic Turquesa

44,50€19,90€
55,68%

Premium Verde

44,90€19,90€
47,49%

Aniversary Azul Marino

37,90€19,90€
47,49%

Aniversary Celeste

37,90€19,90€
54,67%

Original Rosa

43,90€19,90€
54,67%

Original Gris

43,90€19,90€
53,61%

Tech Magenta

42,90€19,90€
53,61%

Tech Negro

42,90€19,90€
56,64%

Original Blanco

45,90€19,90€
56,64%

Original Gris

45,90€19,90€
55,46%

Elegance Azul

55,90€24,90€
55,46%

Elegance Gris

55,90€24,90€
55,28%

Active Coral

44,50€19,90€
55,28%

Active Azul

44,50€19,90€
55,28%

Active Morado

44,50€19,90€
47,49%

Deluxe Rosa

37,90€19,90€
47,49%

Deluxe Gris

37,90€19,90€
53,69%

Impulse Azul

42,97€19,90€
53,69%

Impulse Negro

42,97€19,90€
53,69%

Impulse Rosa

42,97€19,90€
47,41%

Multifunctional Morado

37,84€19,90€
63,57%

Tech Magenta

40,90€14,90€
67,54%

Original Azul

45,90€14,90€
63,57%

Tech Turquesa

40,90€14,90€
63,57%

Tech Negro

40,90€14,90€
56,64%

Original Gris

45,90€19,90€
56,64%

Original Gris Claro

45,90€19,90€
55,46%

Elegance Gris

55,90€24,90€
55,46%

Elegance Azul

55,90€24,90€
55,46%

Elegance Granate

55,90€24,90€
70,65%

Deluxe Blanco

33,73€9,90€
70,65%

Deluxe Morado

33,73€9,90€
76,31%

Original Azul

62,90€14,90€
66,78%

Aniversary Blanco

59,90€19,90€
66,78%

Aniversary Azul Marino

59,90€19,90€
76,31%

Original Gris

62,90€14,90€
52,30%

Multifunctional Negro

52,20€24,90€
52,30%

Multifunctional Morado

52,20€24,90€
57,72%

Multifunctional Amarillo

47,07€19,90€
57,72%

Multifunctional Negro

47,07€19,90€
40,36%

Aniversary Blanco

66,90€39,90€
55,31%

Aniversary Celeste

66,90€29,90€
52,46%

Performance Naranja

62,90€29,90€
52,46%

Performance Azul

62,90€29,90€
52,46%

Performance Negro

62,90€29,90€
70,66%

Original Blanco

101,90€29,90€
78,43%

Original Blanco

45,90€9,90€
65,72%

V-Pro Azul

49,30€16,90€
63,18%

Original Rojo

45,90€16,90€
66,60%

Revival Blanco

50,60€16,90€
66,06%

Aniversary Blanco

43,90€14,90€
66,06%

Aniversary Celeste

43,90€14,90€
66,06%

Aniversary Azul

43,90€14,90€
66,60%

Revival Marron

50,60€16,90€
66,60%

Revival Azul

50,60€16,90€
63,18%

Original Blanco

45,90€16,90€
65,72%

V-Pro Celeste

49,30€16,90€
78,50%

Fusion Azul

46,04€9,90€
78,50%

Fusion Rojo

46,04€9,90€
78,43%

Tech Aguamarina

45,90€9,90€
78,43%

Tech Rojo

45,90€9,90€
78,43%

Original Gris

45,90€9,90€
72,77%

Original Azul

45,90€12,50€
80,26%

Performance Gris/Amarillo

50,14€9,90€
80,26%

Performance Blanco/Azul

50,14€9,90€
80,26%

Performance Blanco/Naranja

50,14€9,90€
80,26%

Original Line Gris

50,14€9,90€
80,26%

Original Line Azul

50,14€9,90€
80,26%

Original Line Blanco

50,14€9,90€
60,31%

70s Sport Line Blanco

50,14€19,90€
60,31%

70s Sport Line Gris

50,14€19,90€
60,31%

70s Sport Line Gris claro

50,14€19,90€
79,42%

80s Cheto Gris

48,10€9,90€
80,26%

80s Cheto Blanco

48,10€9,50€
79,84%

Multifunctional Negro

49,11€9,90€
79,84%

Multifunctional Azul

49,11€9,90€
72,07%

Aniversary Azul

71,25€19,90€
72,07%

Aniversary Blanco

71,25€19,90€
74,12%

Brand Gris

76,90€19,90€
72,24%

Original Blanco

71,68€19,90€
71,29%

V-Pro Turquesa

51,90€14,90€
60,91%

Revival Naranja

50,90€19,90€
77,45%

Aniversary Blanco

43,90€9,90€
60,91%

Revival Celeste

50,90€19,90€
80,55%

Revival Azul

50,90€9,90€
71,29%

V-Pro Blanco

51,90€14,90€
71,29%

V-Pro Celeste

51,90€14,90€
77,45%

Aniversary Azul

43,90€9,90€
81,97%

Revival Blanco/Naranja

54,90€9,90€
82,19%

V-Pro Azul

55,60€9,90€
55,04%

Brand

66,49€29,90€
75,77%

Original Negro

61,50€14,90€
68,16%

Original Azul

62,50€19,90€
68,71%

Aniversary

63,60€19,90€
68,16%

Original Gris

62,50€19,90€
68,16%

Original Blanco

62,50€19,90€
51,39%

Original Beige

61,50€29,90€
47,84%

Multifunctional Negro

57,32€29,90€
47,84%

Multifunctional Gris

57,32€29,90€
77,33%

Original Gris Claro

131,90€29,90€