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=8 AND p.iItemType='4' AND iCityID IN (7913,7920,7997,7964,7916,7885,7950,7996,7587,7903,7566,7827,7887,7745,7967,7357,7875,7921,7452,7483,7783,7938,7353,7764,7379,8026,7866,8031,7762,7770,7426,7416,7397,7693,7524,7502,7668,7717,7984,7682,7451,7939,7975,7937,7414,7506,16554,7600,7714,8002,7605,7704,16556,7358,7393,7339,7761,7946,7864,7721,7328,7615,7628,7843,7661,7373,7613,7767,7624,7396,7919,7634,16586,7785,16587,7310,7985,8013,7868,7442,7836,7461,7528,7438,7315,7813,7523,7540,7662,7678,7381,7673,7460,7380,7486,7839,7643,7815,7488,7680,7689,7465,7352,7674,7679,7417,7812,7621,7345,7347,7609,7512,7346,7642,7378,7932,7586,7880,7537,7765,7779,16585,7825,7522,8025,7484,7993,7772,7653,7383,7641,7623,7519,8019,7644,7425,7589,7818,7597,7814,7394,7335,7574,7718,7354,7529,7547,7656,7951,7595,7349,7581,7663,7548,7826,7820,8009,7568,7454,7319,7530,7348,7651,7405,7791,7819,7606,7518,7715,7945,7445,7580,7331,7384,7532,7660,7436,7429,7575,7821,7330,7611,7307,7536,7706,7703,7516,7716,7395,7343,7334,7775,7340,7342,7731,7817,7728,7664,7837,7725,7418,7462,7503,7538,7659,7577,7648,7437,7934,7434,16593,7749,7741,7441,7929,7400,7756,7795,7579,7582,7646,16582,8928,7683,7333,7632,7971,7734,7753,7960,7306,7829,7828,7696,7481,7564,7639,7539,7835,7482,7412,7371,7823,6854,7534,7832,7989,7433,7658,7800,7620,7375,7933,7830,7344,7610,7337,7894,7363,7485,7636,9041,7413,7733,7657,7810,7710,7922,7387,7856,7314,7510,16276,7966,7748,7369,7341,7385,8017,7729,7318,7520,7675,7513,7931,7409,7500,7824,7626) ORDER BY FIELD(iCityID, 7913,7920,7997,7964,7916,7885,7950,7996,7587,7903,7566,7827,7887,7745,7967,7357,7875,7921,7452,7483,7783,7938,7353,7764,7379,8026,7866,8031,7762,7770,7426,7416,7397,7693,7524,7502,7668,7717,7984,7682,7451,7939,7975,7937,7414,7506,16554,7600,7714,8002,7605,7704,16556,7358,7393,7339,7761,7946,7864,7721,7328,7615,7628,7843,7661,7373,7613,7767,7624,7396,7919,7634,16586,7785,16587,7310,7985,8013,7868,7442,7836,7461,7528,7438,7315,7813,7523,7540,7662,7678,7381,7673,7460,7380,7486,7839,7643,7815,7488,7680,7689,7465,7352,7674,7679,7417,7812,7621,7345,7347,7609,7512,7346,7642,7378,7932,7586,7880,7537,7765,7779,16585,7825,7522,8025,7484,7993,7772,7653,7383,7641,7623,7519,8019,7644,7425,7589,7818,7597,7814,7394,7335,7574,7718,7354,7529,7547,7656,7951,7595,7349,7581,7663,7548,7826,7820,8009,7568,7454,7319,7530,7348,7651,7405,7791,7819,7606,7518,7715,7945,7445,7580,7331,7384,7532,7660,7436,7429,7575,7821,7330,7611,7307,7536,7706,7703,7516,7716,7395,7343,7334,7775,7340,7342,7731,7817,7728,7664,7837,7725,7418,7462,7503,7538,7659,7577,7648,7437,7934,7434,16593,7749,7741,7441,7929,7400,7756,7795,7579,7582,7646,16582,8928,7683,7333,7632,7971,7734,7753,7960,7306,7829,7828,7696,7481,7564,7639,7539,7835,7482,7412,7371,7823,6854,7534,7832,7989,7433,7658,7800,7620,7375,7933,7830,7344,7610,7337,7894,7363,7485,7636,9041,7413,7733,7657,7810,7710,7922,7387,7856,7314,7510,16276,7966,7748,7369,7341,7385,8017,7729,7318,7520,7675,7513,7931,7409,7500,7824,7626) ASC, p.tmPosted DESC LIMIT 24 Cabins Vacation Rental in Griffith
logo

Griffith

Vacation Rentals

POST AD
Griffith
Real Estate
Vacation Rentals

Cabins Vacation Rental in Griffith

Property typeCabins
Posted by
Rent
Search
No results found!

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

Similar searches:

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

Post Free Classified Terms of Use Privacy Policy RSS Feeds Submit Feed Email Alerts Mobile App Contact us Sitemap
Free Classifieds United States, ©Classi4U.com 2018-2024
By Using this website, you agree to Terms of Use & Privacy Policy. Got it