SELECT p.iPostID, p.iPostType, p.iAdType, p.iUserType, p.strTitle, p.iSubType, p.iItemType, p.iPrice, p.iPriceUnit, json_unquote(p.jsonLocation->"$.city") AS city, p.jsonExtra, p.tmPosted, p.iShowImg, p.strImages, p.strVideos, p.strPostURL FROM posts p WHERE p.iActive=1 AND iSubType=102 AND p.jsonExtra->'$.strMake'='Volkswagen' AND iCityID IN (7518,7384,7820,7821,7826,7660,7529,7394,7547,7664,7354,7418,7405,7819,7548,7519,7349,7516,7825,7348,7589,7330,7334,7718,7537,7656,7582,7779,7795,7434,7837,7579,7606,7346,7775,7512,7611,7772,7335,7659,7454,7481,7715,7352,7568,7306,7679,7663,7340,7823,7383,7462,7716,6854,7839,7436,7381,7333,7680,7639,7812,7662,7815,7749,7835,7523,7678,7484,7765,7653,7814,7315,7800,7830,7347,7465,7331,7380,7674,7534,7648,7363,7337,7731,7425,7503,7442,7310,7734,7609,7634,7610,7522,7703,7813,7433,7586,7643,7613,7733,7532,7396,7581,7810,7818,7345,7319,7438,7378,16587,7683,7673,7580,7628,7307,7721,7412,7486,7642,7339,7646,7417,7615,16585,16586,7661,7651,7641,7574,7358,7373,7500,7836,7540,7575,7785,7704,7577,7528,7748,7445,7520,7696,7636,7632,7414,7323,7791,7817,7767,7809,7429,7395,7600,7621,7756,7717,7393,7400,7325,7776,7472,7318,7502,7729,7728,7314,7530,7644,7482,7649,7761,7506,7710,7416,7693,7536,7742,7461,7441,7341,7460,7626,7426,7828,7448,7524,7764,7677,7451,7658,7759,7725,7353,7706,7763,7539,7675,7657,7824,7783,7531,7605,7832,7753,7668,7432,7350,8026,7357,16611,7483,7485,7588,7714,7682,7719,16122,7379,7802,7408,7409,7542,7566,7778,7595,7583,7322,7321,7423,7576,7762,7452,7916,7811,7513,7887,7964,7320,7364,7770,7757,7587,16554,7624,7431,7514,7559,7841,7453,7745,7437,7794,7620,7397,7505,7402,7444,7572,7371,7650,7885,7920,7553,7478,7694,7459,7309,7827,7336,7788,7556,7638,7367,7697,7913,7560,7807,7689,7571,7997,7701,7554,7545,7903,7491,7996,7666,7598,7533,7328,7829,7527,7399,7517,7563,7652,7497,7744,7705,7564,7681,7490,7645,7967,7466,7950,7796,7495,7597,7562,7413,7736,7739,7808,7938,7494,7392,7866,7629,7344,7875,7387,7781,7921,16610,7758,7737,7975,7608,7584,7780,7738,7487,7488,7793,7351,7984,7578,7752,7407,7369,7937,7535,7457,7458,7326,7558,7805,7864,7607,7797,8031,7473,7838,7946,7695,7342,7842,8002,7834,7343,7623,7939,16582,7985,7599,7470,7868,7768,7543,16556,7538,7833,7313,7555,7372,7594,7750,7843) ORDER BY FIELD(iCityID, 7518,7384,7820,7821,7826,7660,7529,7394,7547,7664,7354,7418,7405,7819,7548,7519,7349,7516,7825,7348,7589,7330,7334,7718,7537,7656,7582,7779,7795,7434,7837,7579,7606,7346,7775,7512,7611,7772,7335,7659,7454,7481,7715,7352,7568,7306,7679,7663,7340,7823,7383,7462,7716,6854,7839,7436,7381,7333,7680,7639,7812,7662,7815,7749,7835,7523,7678,7484,7765,7653,7814,7315,7800,7830,7347,7465,7331,7380,7674,7534,7648,7363,7337,7731,7425,7503,7442,7310,7734,7609,7634,7610,7522,7703,7813,7433,7586,7643,7613,7733,7532,7396,7581,7810,7818,7345,7319,7438,7378,16587,7683,7673,7580,7628,7307,7721,7412,7486,7642,7339,7646,7417,7615,16585,16586,7661,7651,7641,7574,7358,7373,7500,7836,7540,7575,7785,7704,7577,7528,7748,7445,7520,7696,7636,7632,7414,7323,7791,7817,7767,7809,7429,7395,7600,7621,7756,7717,7393,7400,7325,7776,7472,7318,7502,7729,7728,7314,7530,7644,7482,7649,7761,7506,7710,7416,7693,7536,7742,7461,7441,7341,7460,7626,7426,7828,7448,7524,7764,7677,7451,7658,7759,7725,7353,7706,7763,7539,7675,7657,7824,7783,7531,7605,7832,7753,7668,7432,7350,8026,7357,16611,7483,7485,7588,7714,7682,7719,16122,7379,7802,7408,7409,7542,7566,7778,7595,7583,7322,7321,7423,7576,7762,7452,7916,7811,7513,7887,7964,7320,7364,7770,7757,7587,16554,7624,7431,7514,7559,7841,7453,7745,7437,7794,7620,7397,7505,7402,7444,7572,7371,7650,7885,7920,7553,7478,7694,7459,7309,7827,7336,7788,7556,7638,7367,7697,7913,7560,7807,7689,7571,7997,7701,7554,7545,7903,7491,7996,7666,7598,7533,7328,7829,7527,7399,7517,7563,7652,7497,7744,7705,7564,7681,7490,7645,7967,7466,7950,7796,7495,7597,7562,7413,7736,7739,7808,7938,7494,7392,7866,7629,7344,7875,7387,7781,7921,16610,7758,7737,7975,7608,7584,7780,7738,7487,7488,7793,7351,7984,7578,7752,7407,7369,7937,7535,7457,7458,7326,7558,7805,7864,7607,7797,8031,7473,7838,7946,7695,7342,7842,8002,7834,7343,7623,7939,16582,7985,7599,7470,7868,7768,7543,16556,7538,7833,7313,7555,7372,7594,7750,7843) ASC, p.tmPosted DESC LIMIT 24 Volkswagen for Sale, Rent & Lease in Hinsdale
logo

Hinsdale

Commercial Vehicles

Condition
Price
MakeVolkswagen
Year
Fuel
Mileage
No results found!

Looking for something? Get notified when it's posted. Setup an Email Alert now!

See if any of the following ads are interesting to you . . .

By Using this website, you agree to Terms of Use & Privacy Policy. Got it