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=4 AND p.iUserType='3' AND p.iItemType='6' AND iCityID IN (7748,7520,7733,7500,7610,7759,7776,7729,7337,7534,7323,7677,7531,7433,7314,7835,7636,6854,7306,7322,7710,7363,7321,7408,7333,7542,7809,7432,7412,7350,7734,7423,7824,7481,7364,7583,7795,7763,7811,7582,7559,7823,7402,7434,7810,7757,7453,7749,7650,7830,7659,7683,7505,7553,7444,7462,7719,7459,7448,7775,7334,7794,7648,7576,7664,7309,7788,7516,7742,7646,7657,7367,7330,7716,7611,7503,7472,7482,7632,7409,7800,7478,7701,7320,7807,7418,7660,7579,7436,7658,7560,7606,7819,7638,7348,7715,7666,7694,7703,7325,7821,7639,16122,7454,7384,7331,7533,7518,7802,7513,7548,7756,7820,7485,7514,7577,7663,7571,7832,7532,7399,7828,7349,7656,7307,7539,7718,7705,7547,7563,7335,7826,7837,7556,7527,7491,7649,7817,7545,7441,7319,7405,7394,7589,7529,7575,7796,7814,7572,7581,7554,7562,7772,7383,7354,7728,7651,7495,7490,7519,7429,7779,7736,7425,7431,7653,7739,7318,7466,7791,7608,7818,7765,7340,7825,7497,7737,7584,7537,7574,7652,7781,7738,7681,7351,7346,16611,7347,7812,7586,7641,7626,7494,7512,7568,7609,7793,7535,16585,7487,7607,7378,7457,7341,7465,7815,7808,7352,7345,7458,7578,7778,7558,7642,7731,7695,7380,7643,7838,7679,7523,7315,7417,7813,7381,7834,7662,7675,7598,7839,7486,7680,7797,7438,7696,7588,7484,7442,7678,7326,7540,7768,16587,7528,7634,7336,7674,7836,16586,7313,7580,7599,7310,7522,7372,7555,7780,7613,7842,7373,7473,7628,7767,7392,7396,7400,7712,7841,7445,7395,7721,7339,7673,7833,7358,7615,7761,7517,12723,7661,7704,7697,12649,7543,7407,7536,7507,7414,7785,7530,12961,12929,7753,12914,7717,12636,7600,7621,7725,7644,7416,12874,7502,7393,7693,7706,12868,12882,12864,7506,7501,7461,7353,7744,7764,8026,7426,7460,7524,7544,7451,7805,12761,7783,7594,7357,7620,7605,7758,7668,12630,16610,7483,7361,7332,7887,7371,7595,12774,7714,7566,12933,7645,7682,7379,7916,12967,7437,12712,7964,12992,7700,7452,7762,7587,12666,7770,12963,12643,16554,7624,7745,12642,12920,7752,7920,7377,12692,7397,12947,7885,12685,16597,7903,7913,7827,12906,7629) ORDER BY FIELD(iCityID, 7748,7520,7733,7500,7610,7759,7776,7729,7337,7534,7323,7677,7531,7433,7314,7835,7636,6854,7306,7322,7710,7363,7321,7408,7333,7542,7809,7432,7412,7350,7734,7423,7824,7481,7364,7583,7795,7763,7811,7582,7559,7823,7402,7434,7810,7757,7453,7749,7650,7830,7659,7683,7505,7553,7444,7462,7719,7459,7448,7775,7334,7794,7648,7576,7664,7309,7788,7516,7742,7646,7657,7367,7330,7716,7611,7503,7472,7482,7632,7409,7800,7478,7701,7320,7807,7418,7660,7579,7436,7658,7560,7606,7819,7638,7348,7715,7666,7694,7703,7325,7821,7639,16122,7454,7384,7331,7533,7518,7802,7513,7548,7756,7820,7485,7514,7577,7663,7571,7832,7532,7399,7828,7349,7656,7307,7539,7718,7705,7547,7563,7335,7826,7837,7556,7527,7491,7649,7817,7545,7441,7319,7405,7394,7589,7529,7575,7796,7814,7572,7581,7554,7562,7772,7383,7354,7728,7651,7495,7490,7519,7429,7779,7736,7425,7431,7653,7739,7318,7466,7791,7608,7818,7765,7340,7825,7497,7737,7584,7537,7574,7652,7781,7738,7681,7351,7346,16611,7347,7812,7586,7641,7626,7494,7512,7568,7609,7793,7535,16585,7487,7607,7378,7457,7341,7465,7815,7808,7352,7345,7458,7578,7778,7558,7642,7731,7695,7380,7643,7838,7679,7523,7315,7417,7813,7381,7834,7662,7675,7598,7839,7486,7680,7797,7438,7696,7588,7484,7442,7678,7326,7540,7768,16587,7528,7634,7336,7674,7836,16586,7313,7580,7599,7310,7522,7372,7555,7780,7613,7842,7373,7473,7628,7767,7392,7396,7400,7712,7841,7445,7395,7721,7339,7673,7833,7358,7615,7761,7517,12723,7661,7704,7697,12649,7543,7407,7536,7507,7414,7785,7530,12961,12929,7753,12914,7717,12636,7600,7621,7725,7644,7416,12874,7502,7393,7693,7706,12868,12882,12864,7506,7501,7461,7353,7744,7764,8026,7426,7460,7524,7544,7451,7805,12761,7783,7594,7357,7620,7605,7758,7668,12630,16610,7483,7361,7332,7887,7371,7595,12774,7714,7566,12933,7645,7682,7379,7916,12967,7437,12712,7964,12992,7700,7452,7762,7587,12666,7770,12963,12643,16554,7624,7745,12642,12920,7752,7920,7377,12692,7397,12947,7885,12685,16597,7903,7913,7827,12906,7629) ASC, p.tmPosted DESC LIMIT 24 Restaurants for Rent, Restaurants Rental by Builder in Schaumburg
logo

Schaumburg

Commercial for Rent

Built area
Rent
Features
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