Touring Minibus
Precio de Lista:
$ 22.990.000
Bono Marca:
0
Precio Contado:
$ 22.990.000
Bono Financiamiento:
$ 500.000
Otro Bono:
0
SELECT r2_posts.* FROM r2_posts INNER JOIN r2_postmeta ON ( r2_posts.ID = r2_postmeta.post_id ) WHERE 1=1 AND (
( r2_postmeta.meta_key LIKE 'bloque_area_%_bloque_marca_%_marca' AND r2_postmeta.meta_value LIKE '%%%%%%{194a0959d6bf967d82d89eae781c4262c2fc84adb933516aec12a396fd19225a}615{194a0959d6bf967d82d89eae781c4262c2fc84adb933516aec12a396fd19225a}' )
) AND r2_posts.post_type = 'sucursales' AND ((r2_posts.post_status = 'publish')) GROUP BY r2_posts.ID ORDER BY r2_posts.menu_order ASC