HappyInvestor.com - Find Homes For Sale Listed By Real Estate Investors


999+ High Potential Investor Deals Near chicago [Refine]


********NOTICE: Displaying 99 of over 999 Search Results.********

We Reccommend Narrowing your Search Filter Criteria to Refine Results!


Discounted properties are homes for sale that are listed well below Trulia, Zillow, or other estimate measures. You will not find a list like this anywhere else. Enjoy!

Below Appraisal properties are homes for sale that are listed on the market at BELOW County Tax Appraised Value. We are able to aggregate this list by matching public tax valuations with sale prices. You will not find a list like this anywhere else. Enjoy!

Reduced/Desperate Seller propeties are homes for sale that have been Reduced by at least 7% of the original sales price. These sellers are typically more desperate to sell their home fast. We are able to aggregate this list by tracking their previous sales prices. You will not find a list like this anywhere else. Enjoy!

select top 45 * from tblREO NOLOCK where priority is null and price > 1000 and dateposted >= '8/29/2021' and Len(PhotoURL1) > 10 and (1=1) and price >= 0 and price <= 499999 and 11=11 and (zipCode ='46312' or zipCode = '46320' or zipCode = '46321' or zipCode = '46321' or zipCode = '46323' or zipCode = '46323' or zipCode = '46324' or zipCode = '46324' or zipCode = '46325' or zipCode = '46327' or zipCode = '46394' or zipCode = '46394' or zipCode = '46401' or zipCode = '46402' or zipCode = '46404' or zipCode = '46406' or zipCode = '46406' or zipCode = '46411' or zipCode = '46411' or zipCode = '60004' or zipCode = '60004' or zipCode = '60005' or zipCode = '60005' or zipCode = '60006' or zipCode = '60006' or zipCode = '60007' or zipCode = '60007' or zipCode = '60008' or zipCode = '60008' or zipCode = '60009' or zipCode = '60009' or zipCode = '60015' or zipCode = '60016' or zipCode = '60017' or zipCode = '60018' or zipCode = '60018' or zipCode = '60019' or zipCode = '60019' or zipCode = '60019' or zipCode = '60022' or zipCode = '60025' or zipCode = '60026' or zipCode = '60029' or zipCode = '60068' or zipCode = '60070' or zipCode = '60070' or zipCode = '60015' or zipCode = '60015' or zipCode = '60035' or zipCode = '60037' or zipCode = '60037' or zipCode = '60040' or zipCode = '60043' or zipCode = '60053' or zipCode = '60056' or zipCode = '60056' or zipCode = '60062' or zipCode = '60065' or zipCode = '60076' or zipCode = '60077' or zipCode = '60082' or zipCode = '60104' or zipCode = '60105' or zipCode = '60105' or zipCode = '60106' or zipCode = '60108' or zipCode = '60117' or zipCode = '60117' or zipCode = '60137' or zipCode = '60137' or zipCode = '60137' or zipCode = '60138' or zipCode = '60139' or zipCode = '60139' or zipCode = '60141' or zipCode = '60143' or zipCode = '60148' or zipCode = '60148' or zipCode = '60153' or zipCode = '60153' or zipCode = '60154' or zipCode = '60155' or zipCode = '60155' or zipCode = '60157' or zipCode = '60160' or zipCode = '60161' or zipCode = '60162' or zipCode = '60163' or zipCode = '60163' or zipCode = '60163' or zipCode = '60164' or zipCode = '60164' or zipCode = '60165' or zipCode = '60165' or zipCode = '60171' or zipCode = '60173' or zipCode = '60173' or zipCode = '60173' or zipCode = '60176' or zipCode = '60090' or zipCode = '60091' or zipCode = '60093' or zipCode = '60093' or zipCode = '60093' or zipCode = '60101' or zipCode = '60126' or zipCode = '60130' or zipCode = '60131' or zipCode = '60131' or zipCode = '60181' or zipCode = '60181' or zipCode = '60181' or zipCode = '60189' or zipCode = '60191' or zipCode = '60399' or zipCode = '60399' or zipCode = '60402' or zipCode = '60402' or zipCode = '60402' or zipCode = '60406' or zipCode = '60406' or zipCode = '60409' or zipCode = '60415' or zipCode = '60419' or zipCode = '60422' or zipCode = '60422' or zipCode = '60425' or zipCode = '60426' or zipCode = '60426' or zipCode = '60445' or zipCode = '60445' or zipCode = '60452' or zipCode = '60453' or zipCode = '60454' or zipCode = '60455' or zipCode = '60455' or zipCode = '60455' or zipCode = '60456' or zipCode = '60456' or zipCode = '60457' or zipCode = '60476' or zipCode = '60477' or zipCode = '60477' or zipCode = '60478' or zipCode = '60478' or zipCode = '60478' or zipCode = '60478' or zipCode = '60480' or zipCode = '60480' or zipCode = '60482' or zipCode = '60487' or zipCode = '60487' or zipCode = '60513' or zipCode = '60514' or zipCode = '60514' or zipCode = '60515' or zipCode = '60516' or zipCode = '60517' or zipCode = '60517' or zipCode = '60521' or zipCode = '60521' or zipCode = '60521' or zipCode = '60521' or zipCode = '60522' or zipCode = '60522' or zipCode = '60523' or zipCode = '60523' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60196' or zipCode = '60196' or zipCode = '60196' or zipCode = '60196' or zipCode = '60199' or zipCode = '60199' or zipCode = '60201' or zipCode = '60202' or zipCode = '60203' or zipCode = '60204' or zipCode = '60208' or zipCode = '60208' or zipCode = '60209' or zipCode = '60209' or zipCode = '60290' or zipCode = '60290' or zipCode = '60301' or zipCode = '60302' or zipCode = '60303' or zipCode = '60304' or zipCode = '60305' or zipCode = '60399' or zipCode = '60426' or zipCode = '60426' or zipCode = '60428' or zipCode = '60428' or zipCode = '60429' or zipCode = '60429' or zipCode = '60430' or zipCode = '60438' or zipCode = '60439' or zipCode = '60439' or zipCode = '60457' or zipCode = '60458' or zipCode = '60458' or zipCode = '60458' or zipCode = '60459' or zipCode = '60459' or zipCode = '60459' or zipCode = '60462' or zipCode = '60463' or zipCode = '60464' or zipCode = '60465' or zipCode = '60467' or zipCode = '60469' or zipCode = '60472' or zipCode = '60473' or zipCode = '60499' or zipCode = '60499' or zipCode = '60499' or zipCode = '60499' or zipCode = '60501' or zipCode = '60501' or zipCode = '60501' or zipCode = '60501' or zipCode = '60501' or zipCode = '60501' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60526' or zipCode = '60526' or zipCode = '60526' or zipCode = '60527' or zipCode = '60527' or zipCode = '60527' or zipCode = '60527' or zipCode = '60532' or zipCode = '60534' or zipCode = '60546' or zipCode = '60546' or zipCode = '60546' or zipCode = '60558' or zipCode = '60558' or zipCode = '60559' or zipCode = '60561' or zipCode = '60561' or zipCode = '60599' or zipCode = '60599' or zipCode = '60599' or zipCode = '60601' or zipCode = '60602' or zipCode = '60603' or zipCode = '60604' or zipCode = '60605' or zipCode = '60606' or zipCode = '60607' or zipCode = '60608' or zipCode = '60608' or zipCode = '60609' or zipCode = '60609' or zipCode = '60610' or zipCode = '60610' or zipCode = '60610' or zipCode = '60611' or zipCode = '60611' or zipCode = '60611' or zipCode = '60612' or zipCode = '60612' or zipCode = '60613' or zipCode = '60613' or zipCode = '60614' or zipCode = '60614' or zipCode = '60615' or zipCode = '60615' or zipCode = '60616' or zipCode = '60616' or zipCode = '60617' or zipCode = '60617' or zipCode = '60618' or zipCode = '60618' or zipCode = '60619' or zipCode = '60619' or zipCode = '60620' or zipCode = '60621' or zipCode = '60621' or zipCode = '60622' or zipCode = '60622' or zipCode = '60633' or zipCode = '60633' or zipCode = '60634' or zipCode = '60634' or zipCode = '60634' or zipCode = '60634' or zipCode = '60636' or zipCode = '60636' or zipCode = '60637' or zipCode = '60637' or zipCode = '60638' or zipCode = '60638' or zipCode = '60638' or zipCode = '60638' or zipCode = '60638' or zipCode = '60639' or zipCode = '60639' or zipCode = '60640' or zipCode = '60641' or zipCode = '60642' or zipCode = '60642' or zipCode = '60643' or zipCode = '60643' or zipCode = '60643' or zipCode = '60655' or zipCode = '60656' or zipCode = '60656' or zipCode = '60656' or zipCode = '60656' or zipCode = '60657' or zipCode = '60657' or zipCode = '60659' or zipCode = '60659' or zipCode = '60659' or zipCode = '60660' or zipCode = '60660' or zipCode = '60661' or zipCode = '60664' or zipCode = '60664' or zipCode = '60666' or zipCode = '60666' or zipCode = '60668' or zipCode = '60668' or zipCode = '60669' or zipCode = '60669' or zipCode = '60670' or zipCode = '60670' or zipCode = '60670' or zipCode = '60688' or zipCode = '60689' or zipCode = '60689' or zipCode = '60690' or zipCode = '60691' or zipCode = '60693' or zipCode = '60693' or zipCode = '60694' or zipCode = '60694' or zipCode = '60695' or zipCode = '60695' or zipCode = '60696' or zipCode = '60696' or zipCode = '60696' or zipCode = '60697' or zipCode = '60697' or zipCode = '60699' or zipCode = '60699' or zipCode = '60701' or zipCode = '60706' or zipCode = '60706' or zipCode = '60706' or zipCode = '60706' or zipCode = '60623' or zipCode = '60623' or zipCode = '60624' or zipCode = '60624' or zipCode = '60625' or zipCode = '60625' or zipCode = '60626' or zipCode = '60626' or zipCode = '60628' or zipCode = '60628' or zipCode = '60629' or zipCode = '60629' or zipCode = '60629' or zipCode = '60629' or zipCode = '60630' or zipCode = '60630' or zipCode = '60630' or zipCode = '60630' or zipCode = '60630' or zipCode = '60631' or zipCode = '60631' or zipCode = '60632' or zipCode = '60632' or zipCode = '60633' or zipCode = '60644' or zipCode = '60644' or zipCode = '60645' or zipCode = '60645' or zipCode = '60645' or zipCode = '60646' or zipCode = '60646' or zipCode = '60647' or zipCode = '60647' or zipCode = '60649' or zipCode = '60649' or zipCode = '60651' or zipCode = '60651' or zipCode = '60652' or zipCode = '60652' or zipCode = '60653' or zipCode = '60653' or zipCode = '60654' or zipCode = '60654' or zipCode = '60655' or zipCode = '60655' or zipCode = '60655' or zipCode = '60655' or zipCode = '60673' or zipCode = '60673' or zipCode = '60673' or zipCode = '60674' or zipCode = '60674' or zipCode = '60675' or zipCode = '60675' or zipCode = '60677' or zipCode = '60677' or zipCode = '60678' or zipCode = '60678' or zipCode = '60680' or zipCode = '60681' or zipCode = '60682' or zipCode = '60682' or zipCode = '60684' or zipCode = '60684' or zipCode = '60685' or zipCode = '60685' or zipCode = '60686' or zipCode = '60686' or zipCode = '60687' or zipCode = '60687' or zipCode = '60688' or zipCode = '60707' or zipCode = '60707' or zipCode = '60712' or zipCode = '60712' or zipCode = '60712' or zipCode = '60712' or zipCode = '60714' or zipCode = '60803' or zipCode = '60803' or zipCode = '60803' or zipCode = '60803' or zipCode = '60804' or zipCode = '60804' or zipCode = '60805' or zipCode = '60805' or zipCode = '60805' or zipCode = '60827' or zipCode = '60827' or zipCode = '60827' or zipCode = '46312' or zipCode = '46320' or zipCode = '46321' or zipCode = '46322' or zipCode = '46323' or zipCode = '46324' or zipCode = '46327' or zipCode = '46394' or zipCode = '46402' or zipCode = '46404' or zipCode = '46406' or zipCode = '60004' or zipCode = '60005' or zipCode = '60006' or zipCode = '60007' or zipCode = '60008' or zipCode = '60009' or zipCode = '60015' or zipCode = '60016' or zipCode = '60017' or zipCode = '60018' or zipCode = '60019' or zipCode = '60022' or zipCode = '60025' or zipCode = '60026' or zipCode = '60029' or zipCode = '60035' or zipCode = '60037' or zipCode = '60038' or zipCode = '60040' or zipCode = '60043' or zipCode = '60053' or zipCode = '60055' or zipCode = '60056' or zipCode = '60062' or zipCode = '60065' or zipCode = '60068' or zipCode = '60070' or zipCode = '60076' or zipCode = '60077' or zipCode = '60078' or zipCode = '60082' or zipCode = '60090' or zipCode = '60091' or zipCode = '60093' or zipCode = '60094' or zipCode = '60095' or zipCode = '60101' or zipCode = '60104' or zipCode = '60105' or zipCode = '60106' or zipCode = '60108' or zipCode = '60114' or zipCode = '60116' or zipCode = '60117' or zipCode = '60125' or zipCode = '60126' or zipCode = '60128' or zipCode = '60130' or zipCode = '60131' or zipCode = '60132' or zipCode = '60137' or zipCode = '60138' or zipCode = '60139' or zipCode = '60141' or zipCode = '60143' or zipCode = '60148' or zipCode = '60153' or zipCode = '60154' or zipCode = '60155' or zipCode = '60157' or zipCode = '60159' or zipCode = '60160' or zipCode = '60161' or zipCode = '60162' or zipCode = '60163' or zipCode = '60164' or zipCode = '60165' or zipCode = '60168' or zipCode = '60171' or zipCode = '60172' or zipCode = '60173' or zipCode = '60176' or zipCode = '60181' or zipCode = '60186' or zipCode = '60189' or zipCode = '60191' or zipCode = '60197' or zipCode = '60198' or zipCode = '60199' or zipCode = '60201' or zipCode = '60202' or zipCode = '60203' or zipCode = '60204' or zipCode = '60208' or zipCode = '60209' or zipCode = '60301' or zipCode = '60302' or zipCode = '60303' or zipCode = '60304' or zipCode = '60305' or zipCode = '60330' or zipCode = '60402' or zipCode = '60406' or zipCode = '60409' or zipCode = '60412' or zipCode = '60415' or zipCode = '60419' or zipCode = '60422' or zipCode = '60425' or zipCode = '60426' or zipCode = '60429' or zipCode = '60430' or zipCode = '60438' or zipCode = '60439' or zipCode = '60445' or zipCode = '60452' or zipCode = '60453' or zipCode = '60454' or zipCode = '60455' or zipCode = '60456' or zipCode = '60457' or zipCode = '60458' or zipCode = '60459' or zipCode = '60462' or zipCode = '60463' or zipCode = '60464' or zipCode = '60465' or zipCode = '60467' or zipCode = '60469' or zipCode = '60472' or zipCode = '60473' or zipCode = '60476' or zipCode = '60477' or zipCode = '60478' or zipCode = '60480' or zipCode = '60482' or zipCode = '60499' or zipCode = '60501' or zipCode = '60513' or zipCode = '60514' or zipCode = '60515' or zipCode = '60516' or zipCode = '60517' or zipCode = '60521' or zipCode = '60522' or zipCode = '60523' or zipCode = '60525' or zipCode = '60526' or zipCode = '60527' or zipCode = '60532' or zipCode = '60534' or zipCode = '60546' or zipCode = '60558' or zipCode = '60559' or zipCode = '60561' or zipCode = '60566' or zipCode = '60567' or zipCode = '60570' or zipCode = '60572' or zipCode = '60597' or zipCode = '60598' or zipCode = '60599' or zipCode = '60601' or zipCode = '60602' or zipCode = '60603' or zipCode = '60604' or zipCode = '60605' or zipCode = '60606' or zipCode = '60607' or zipCode = '60608' or zipCode = '60609' or zipCode = '60610' or zipCode = '60611' or zipCode = '60612' or zipCode = '60613' or zipCode = '60614' or zipCode = '60615' or zipCode = '60616' or zipCode = '60617' or zipCode = '60618' or zipCode = '60619' or zipCode = '60620' or zipCode = '60621' or zipCode = '60622' or zipCode = '60623' or zipCode = '60624' or zipCode = '60625' or zipCode = '60626' or zipCode = '60628' or zipCode = '60629' or zipCode = '60630' or zipCode = '60631' or zipCode = '60632' or zipCode = '60633' or zipCode = '60634' or zipCode = '60636' or zipCode = '60637' or zipCode = '60638' or zipCode = '60639' or zipCode = '60640' or zipCode = '60641' or zipCode = '60643' or zipCode = '60644' or zipCode = '60645' or zipCode = '60646' or zipCode = '60647' or zipCode = '60649' or zipCode = '60650' or zipCode = '60651' or zipCode = '60652' or zipCode = '60653' or zipCode = '60654' or zipCode = '60655' or zipCode = '60656' or zipCode = '60657' or zipCode = '60659' or zipCode = '60660' or zipCode = '60661' or zipCode = '60663' or zipCode = '60664' or zipCode = '60665' or zipCode = '60666' or zipCode = '60667' or zipCode = '60668' or zipCode = '60669' or zipCode = '60670' or zipCode = '60671' or zipCode = '60672' or zipCode = '60673' or zipCode = '60674' or zipCode = '60675' or zipCode = '60677' or zipCode = '60678' or zipCode = '60679' or zipCode = '60680' or zipCode = '60681' or zipCode = '60683' or zipCode = '60684' or zipCode = '60685' or zipCode = '60687' or zipCode = '60690' or zipCode = '60691' or zipCode = '60692' or zipCode = '60693' or zipCode = '60694' or zipCode = '60697' or zipCode = '60699' or zipCode = '60701' or zipCode = '60706' or zipCode = '60707' or zipCode = '60712' or zipCode = '60714' or zipCode = '60803' or zipCode = '60804' or zipCode = '60805' or zipCode = '60827')
select top 45 *, cast(tax_value as float)/cast(price as float) as tax_ratio from tblBothNew NOLOCK where priority IS NULL and price > 5000 and (1=1) and original_price IS NOT NULL and (status='active' or status='for_sale' or status IS NULL) and (propertyType != 'LAND' or propertyType is null) and 1=1 and state = 'IL' and photoURL1 IS NOT NULL and theType = 'Tax' and tax_value IS NOT NULL and (bedrooms <> '' AND bedrooms IS NOT NULL) and tax_value/price < 5 and 1=1 and (1=1) and price >= 0 and price <= 499999 and 11=11 and (zipCode ='46312' or zipCode = '46320' or zipCode = '46321' or zipCode = '46321' or zipCode = '46323' or zipCode = '46323' or zipCode = '46324' or zipCode = '46324' or zipCode = '46325' or zipCode = '46327' or zipCode = '46394' or zipCode = '46394' or zipCode = '46401' or zipCode = '46402' or zipCode = '46404' or zipCode = '46406' or zipCode = '46406' or zipCode = '46411' or zipCode = '46411' or zipCode = '60004' or zipCode = '60004' or zipCode = '60005' or zipCode = '60005' or zipCode = '60006' or zipCode = '60006' or zipCode = '60007' or zipCode = '60007' or zipCode = '60008' or zipCode = '60008' or zipCode = '60009' or zipCode = '60009' or zipCode = '60015' or zipCode = '60016' or zipCode = '60017' or zipCode = '60018' or zipCode = '60018' or zipCode = '60019' or zipCode = '60019' or zipCode = '60019' or zipCode = '60022' or zipCode = '60025' or zipCode = '60026' or zipCode = '60029' or zipCode = '60068' or zipCode = '60070' or zipCode = '60070' or zipCode = '60015' or zipCode = '60015' or zipCode = '60035' or zipCode = '60037' or zipCode = '60037' or zipCode = '60040' or zipCode = '60043' or zipCode = '60053' or zipCode = '60056' or zipCode = '60056' or zipCode = '60062' or zipCode = '60065' or zipCode = '60076' or zipCode = '60077' or zipCode = '60082' or zipCode = '60104' or zipCode = '60105' or zipCode = '60105' or zipCode = '60106' or zipCode = '60108' or zipCode = '60117' or zipCode = '60117' or zipCode = '60137' or zipCode = '60137' or zipCode = '60137' or zipCode = '60138' or zipCode = '60139' or zipCode = '60139' or zipCode = '60141' or zipCode = '60143' or zipCode = '60148' or zipCode = '60148' or zipCode = '60153' or zipCode = '60153' or zipCode = '60154' or zipCode = '60155' or zipCode = '60155' or zipCode = '60157' or zipCode = '60160' or zipCode = '60161' or zipCode = '60162' or zipCode = '60163' or zipCode = '60163' or zipCode = '60163' or zipCode = '60164' or zipCode = '60164' or zipCode = '60165' or zipCode = '60165' or zipCode = '60171' or zipCode = '60173' or zipCode = '60173' or zipCode = '60173' or zipCode = '60176' or zipCode = '60090' or zipCode = '60091' or zipCode = '60093' or zipCode = '60093' or zipCode = '60093' or zipCode = '60101' or zipCode = '60126' or zipCode = '60130' or zipCode = '60131' or zipCode = '60131' or zipCode = '60181' or zipCode = '60181' or zipCode = '60181' or zipCode = '60189' or zipCode = '60191' or zipCode = '60399' or zipCode = '60399' or zipCode = '60402' or zipCode = '60402' or zipCode = '60402' or zipCode = '60406' or zipCode = '60406' or zipCode = '60409' or zipCode = '60415' or zipCode = '60419' or zipCode = '60422' or zipCode = '60422' or zipCode = '60425' or zipCode = '60426' or zipCode = '60426' or zipCode = '60445' or zipCode = '60445' or zipCode = '60452' or zipCode = '60453' or zipCode = '60454' or zipCode = '60455' or zipCode = '60455' or zipCode = '60455' or zipCode = '60456' or zipCode = '60456' or zipCode = '60457' or zipCode = '60476' or zipCode = '60477' or zipCode = '60477' or zipCode = '60478' or zipCode = '60478' or zipCode = '60478' or zipCode = '60478' or zipCode = '60480' or zipCode = '60480' or zipCode = '60482' or zipCode = '60487' or zipCode = '60487' or zipCode = '60513' or zipCode = '60514' or zipCode = '60514' or zipCode = '60515' or zipCode = '60516' or zipCode = '60517' or zipCode = '60517' or zipCode = '60521' or zipCode = '60521' or zipCode = '60521' or zipCode = '60521' or zipCode = '60522' or zipCode = '60522' or zipCode = '60523' or zipCode = '60523' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60196' or zipCode = '60196' or zipCode = '60196' or zipCode = '60196' or zipCode = '60199' or zipCode = '60199' or zipCode = '60201' or zipCode = '60202' or zipCode = '60203' or zipCode = '60204' or zipCode = '60208' or zipCode = '60208' or zipCode = '60209' or zipCode = '60209' or zipCode = '60290' or zipCode = '60290' or zipCode = '60301' or zipCode = '60302' or zipCode = '60303' or zipCode = '60304' or zipCode = '60305' or zipCode = '60399' or zipCode = '60426' or zipCode = '60426' or zipCode = '60428' or zipCode = '60428' or zipCode = '60429' or zipCode = '60429' or zipCode = '60430' or zipCode = '60438' or zipCode = '60439' or zipCode = '60439' or zipCode = '60457' or zipCode = '60458' or zipCode = '60458' or zipCode = '60458' or zipCode = '60459' or zipCode = '60459' or zipCode = '60459' or zipCode = '60462' or zipCode = '60463' or zipCode = '60464' or zipCode = '60465' or zipCode = '60467' or zipCode = '60469' or zipCode = '60472' or zipCode = '60473' or zipCode = '60499' or zipCode = '60499' or zipCode = '60499' or zipCode = '60499' or zipCode = '60501' or zipCode = '60501' or zipCode = '60501' or zipCode = '60501' or zipCode = '60501' or zipCode = '60501' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60526' or zipCode = '60526' or zipCode = '60526' or zipCode = '60527' or zipCode = '60527' or zipCode = '60527' or zipCode = '60527' or zipCode = '60532' or zipCode = '60534' or zipCode = '60546' or zipCode = '60546' or zipCode = '60546' or zipCode = '60558' or zipCode = '60558' or zipCode = '60559' or zipCode = '60561' or zipCode = '60561' or zipCode = '60599' or zipCode = '60599' or zipCode = '60599' or zipCode = '60601' or zipCode = '60602' or zipCode = '60603' or zipCode = '60604' or zipCode = '60605' or zipCode = '60606' or zipCode = '60607' or zipCode = '60608' or zipCode = '60608' or zipCode = '60609' or zipCode = '60609' or zipCode = '60610' or zipCode = '60610' or zipCode = '60610' or zipCode = '60611' or zipCode = '60611' or zipCode = '60611' or zipCode = '60612' or zipCode = '60612' or zipCode = '60613' or zipCode = '60613' or zipCode = '60614' or zipCode = '60614' or zipCode = '60615' or zipCode = '60615' or zipCode = '60616' or zipCode = '60616' or zipCode = '60617' or zipCode = '60617' or zipCode = '60618' or zipCode = '60618' or zipCode = '60619' or zipCode = '60619' or zipCode = '60620' or zipCode = '60621' or zipCode = '60621' or zipCode = '60622' or zipCode = '60622' or zipCode = '60633' or zipCode = '60633' or zipCode = '60634' or zipCode = '60634' or zipCode = '60634' or zipCode = '60634' or zipCode = '60636' or zipCode = '60636' or zipCode = '60637' or zipCode = '60637' or zipCode = '60638' or zipCode = '60638' or zipCode = '60638' or zipCode = '60638' or zipCode = '60638' or zipCode = '60639' or zipCode = '60639' or zipCode = '60640' or zipCode = '60641' or zipCode = '60642' or zipCode = '60642' or zipCode = '60643' or zipCode = '60643' or zipCode = '60643' or zipCode = '60655' or zipCode = '60656' or zipCode = '60656' or zipCode = '60656' or zipCode = '60656' or zipCode = '60657' or zipCode = '60657' or zipCode = '60659' or zipCode = '60659' or zipCode = '60659' or zipCode = '60660' or zipCode = '60660' or zipCode = '60661' or zipCode = '60664' or zipCode = '60664' or zipCode = '60666' or zipCode = '60666' or zipCode = '60668' or zipCode = '60668' or zipCode = '60669' or zipCode = '60669' or zipCode = '60670' or zipCode = '60670' or zipCode = '60670' or zipCode = '60688' or zipCode = '60689' or zipCode = '60689' or zipCode = '60690' or zipCode = '60691' or zipCode = '60693' or zipCode = '60693' or zipCode = '60694' or zipCode = '60694' or zipCode = '60695' or zipCode = '60695' or zipCode = '60696' or zipCode = '60696' or zipCode = '60696' or zipCode = '60697' or zipCode = '60697' or zipCode = '60699' or zipCode = '60699' or zipCode = '60701' or zipCode = '60706' or zipCode = '60706' or zipCode = '60706' or zipCode = '60706' or zipCode = '60623' or zipCode = '60623' or zipCode = '60624' or zipCode = '60624' or zipCode = '60625' or zipCode = '60625' or zipCode = '60626' or zipCode = '60626' or zipCode = '60628' or zipCode = '60628' or zipCode = '60629' or zipCode = '60629' or zipCode = '60629' or zipCode = '60629' or zipCode = '60630' or zipCode = '60630' or zipCode = '60630' or zipCode = '60630' or zipCode = '60630' or zipCode = '60631' or zipCode = '60631' or zipCode = '60632' or zipCode = '60632' or zipCode = '60633' or zipCode = '60644' or zipCode = '60644' or zipCode = '60645' or zipCode = '60645' or zipCode = '60645' or zipCode = '60646' or zipCode = '60646' or zipCode = '60647' or zipCode = '60647' or zipCode = '60649' or zipCode = '60649' or zipCode = '60651' or zipCode = '60651' or zipCode = '60652' or zipCode = '60652' or zipCode = '60653' or zipCode = '60653' or zipCode = '60654' or zipCode = '60654' or zipCode = '60655' or zipCode = '60655' or zipCode = '60655' or zipCode = '60655' or zipCode = '60673' or zipCode = '60673' or zipCode = '60673' or zipCode = '60674' or zipCode = '60674' or zipCode = '60675' or zipCode = '60675' or zipCode = '60677' or zipCode = '60677' or zipCode = '60678' or zipCode = '60678' or zipCode = '60680' or zipCode = '60681' or zipCode = '60682' or zipCode = '60682' or zipCode = '60684' or zipCode = '60684' or zipCode = '60685' or zipCode = '60685' or zipCode = '60686' or zipCode = '60686' or zipCode = '60687' or zipCode = '60687' or zipCode = '60688' or zipCode = '60707' or zipCode = '60707' or zipCode = '60712' or zipCode = '60712' or zipCode = '60712' or zipCode = '60712' or zipCode = '60714' or zipCode = '60803' or zipCode = '60803' or zipCode = '60803' or zipCode = '60803' or zipCode = '60804' or zipCode = '60804' or zipCode = '60805' or zipCode = '60805' or zipCode = '60805' or zipCode = '60827' or zipCode = '60827' or zipCode = '60827' or zipCode = '46312' or zipCode = '46320' or zipCode = '46321' or zipCode = '46322' or zipCode = '46323' or zipCode = '46324' or zipCode = '46327' or zipCode = '46394' or zipCode = '46402' or zipCode = '46404' or zipCode = '46406' or zipCode = '60004' or zipCode = '60005' or zipCode = '60006' or zipCode = '60007' or zipCode = '60008' or zipCode = '60009' or zipCode = '60015' or zipCode = '60016' or zipCode = '60017' or zipCode = '60018' or zipCode = '60019' or zipCode = '60022' or zipCode = '60025' or zipCode = '60026' or zipCode = '60029' or zipCode = '60035' or zipCode = '60037' or zipCode = '60038' or zipCode = '60040' or zipCode = '60043' or zipCode = '60053' or zipCode = '60055' or zipCode = '60056' or zipCode = '60062' or zipCode = '60065' or zipCode = '60068' or zipCode = '60070' or zipCode = '60076' or zipCode = '60077' or zipCode = '60078' or zipCode = '60082' or zipCode = '60090' or zipCode = '60091' or zipCode = '60093' or zipCode = '60094' or zipCode = '60095' or zipCode = '60101' or zipCode = '60104' or zipCode = '60105' or zipCode = '60106' or zipCode = '60108' or zipCode = '60114' or zipCode = '60116' or zipCode = '60117' or zipCode = '60125' or zipCode = '60126' or zipCode = '60128' or zipCode = '60130' or zipCode = '60131' or zipCode = '60132' or zipCode = '60137' or zipCode = '60138' or zipCode = '60139' or zipCode = '60141' or zipCode = '60143' or zipCode = '60148' or zipCode = '60153' or zipCode = '60154' or zipCode = '60155' or zipCode = '60157' or zipCode = '60159' or zipCode = '60160' or zipCode = '60161' or zipCode = '60162' or zipCode = '60163' or zipCode = '60164' or zipCode = '60165' or zipCode = '60168' or zipCode = '60171' or zipCode = '60172' or zipCode = '60173' or zipCode = '60176' or zipCode = '60181' or zipCode = '60186' or zipCode = '60189' or zipCode = '60191' or zipCode = '60197' or zipCode = '60198' or zipCode = '60199' or zipCode = '60201' or zipCode = '60202' or zipCode = '60203' or zipCode = '60204' or zipCode = '60208' or zipCode = '60209' or zipCode = '60301' or zipCode = '60302' or zipCode = '60303' or zipCode = '60304' or zipCode = '60305' or zipCode = '60330' or zipCode = '60402' or zipCode = '60406' or zipCode = '60409' or zipCode = '60412' or zipCode = '60415' or zipCode = '60419' or zipCode = '60422' or zipCode = '60425' or zipCode = '60426' or zipCode = '60429' or zipCode = '60430' or zipCode = '60438' or zipCode = '60439' or zipCode = '60445' or zipCode = '60452' or zipCode = '60453' or zipCode = '60454' or zipCode = '60455' or zipCode = '60456' or zipCode = '60457' or zipCode = '60458' or zipCode = '60459' or zipCode = '60462' or zipCode = '60463' or zipCode = '60464' or zipCode = '60465' or zipCode = '60467' or zipCode = '60469' or zipCode = '60472' or zipCode = '60473' or zipCode = '60476' or zipCode = '60477' or zipCode = '60478' or zipCode = '60480' or zipCode = '60482' or zipCode = '60499' or zipCode = '60501' or zipCode = '60513' or zipCode = '60514' or zipCode = '60515' or zipCode = '60516' or zipCode = '60517' or zipCode = '60521' or zipCode = '60522' or zipCode = '60523' or zipCode = '60525' or zipCode = '60526' or zipCode = '60527' or zipCode = '60532' or zipCode = '60534' or zipCode = '60546' or zipCode = '60558' or zipCode = '60559' or zipCode = '60561' or zipCode = '60566' or zipCode = '60567' or zipCode = '60570' or zipCode = '60572' or zipCode = '60597' or zipCode = '60598' or zipCode = '60599' or zipCode = '60601' or zipCode = '60602' or zipCode = '60603' or zipCode = '60604' or zipCode = '60605' or zipCode = '60606' or zipCode = '60607' or zipCode = '60608' or zipCode = '60609' or zipCode = '60610' or zipCode = '60611' or zipCode = '60612' or zipCode = '60613' or zipCode = '60614' or zipCode = '60615' or zipCode = '60616' or zipCode = '60617' or zipCode = '60618' or zipCode = '60619' or zipCode = '60620' or zipCode = '60621' or zipCode = '60622' or zipCode = '60623' or zipCode = '60624' or zipCode = '60625' or zipCode = '60626' or zipCode = '60628' or zipCode = '60629' or zipCode = '60630' or zipCode = '60631' or zipCode = '60632' or zipCode = '60633' or zipCode = '60634' or zipCode = '60636' or zipCode = '60637' or zipCode = '60638' or zipCode = '60639' or zipCode = '60640' or zipCode = '60641' or zipCode = '60643' or zipCode = '60644' or zipCode = '60645' or zipCode = '60646' or zipCode = '60647' or zipCode = '60649' or zipCode = '60650' or zipCode = '60651' or zipCode = '60652' or zipCode = '60653' or zipCode = '60654' or zipCode = '60655' or zipCode = '60656' or zipCode = '60657' or zipCode = '60659' or zipCode = '60660' or zipCode = '60661' or zipCode = '60663' or zipCode = '60664' or zipCode = '60665' or zipCode = '60666' or zipCode = '60667' or zipCode = '60668' or zipCode = '60669' or zipCode = '60670' or zipCode = '60671' or zipCode = '60672' or zipCode = '60673' or zipCode = '60674' or zipCode = '60675' or zipCode = '60677' or zipCode = '60678' or zipCode = '60679' or zipCode = '60680' or zipCode = '60681' or zipCode = '60683' or zipCode = '60684' or zipCode = '60685' or zipCode = '60687' or zipCode = '60690' or zipCode = '60691' or zipCode = '60692' or zipCode = '60693' or zipCode = '60694' or zipCode = '60697' or zipCode = '60699' or zipCode = '60701' or zipCode = '60706' or zipCode = '60707' or zipCode = '60712' or zipCode = '60714' or zipCode = '60803' or zipCode = '60804' or zipCode = '60805' or zipCode = '60827') order by price;
select top 240 * from tblBothNew NOLOCK where priority IS NULL and price > 5000 and original_price IS NOT NULL and (status='active' or status='for_sale' or status IS NULL) and (propertyType != 'land' or propertyType IS NULL) and len(photoURL1) > 5 and dateposted >= '8/29/2021' and theType = 'Desperate' and (bedrooms <> '' and bedrooms IS NOT NULL) and price > 10000 and original_price > 10000 and (1=1) and price >= 0 and price <= 499999 and 11=11 and (zipCode ='46312' or zipCode = '46320' or zipCode = '46321' or zipCode = '46321' or zipCode = '46323' or zipCode = '46323' or zipCode = '46324' or zipCode = '46324' or zipCode = '46325' or zipCode = '46327' or zipCode = '46394' or zipCode = '46394' or zipCode = '46401' or zipCode = '46402' or zipCode = '46404' or zipCode = '46406' or zipCode = '46406' or zipCode = '46411' or zipCode = '46411' or zipCode = '60004' or zipCode = '60004' or zipCode = '60005' or zipCode = '60005' or zipCode = '60006' or zipCode = '60006' or zipCode = '60007' or zipCode = '60007' or zipCode = '60008' or zipCode = '60008' or zipCode = '60009' or zipCode = '60009' or zipCode = '60015' or zipCode = '60016' or zipCode = '60017' or zipCode = '60018' or zipCode = '60018' or zipCode = '60019' or zipCode = '60019' or zipCode = '60019' or zipCode = '60022' or zipCode = '60025' or zipCode = '60026' or zipCode = '60029' or zipCode = '60068' or zipCode = '60070' or zipCode = '60070' or zipCode = '60015' or zipCode = '60015' or zipCode = '60035' or zipCode = '60037' or zipCode = '60037' or zipCode = '60040' or zipCode = '60043' or zipCode = '60053' or zipCode = '60056' or zipCode = '60056' or zipCode = '60062' or zipCode = '60065' or zipCode = '60076' or zipCode = '60077' or zipCode = '60082' or zipCode = '60104' or zipCode = '60105' or zipCode = '60105' or zipCode = '60106' or zipCode = '60108' or zipCode = '60117' or zipCode = '60117' or zipCode = '60137' or zipCode = '60137' or zipCode = '60137' or zipCode = '60138' or zipCode = '60139' or zipCode = '60139' or zipCode = '60141' or zipCode = '60143' or zipCode = '60148' or zipCode = '60148' or zipCode = '60153' or zipCode = '60153' or zipCode = '60154' or zipCode = '60155' or zipCode = '60155' or zipCode = '60157' or zipCode = '60160' or zipCode = '60161' or zipCode = '60162' or zipCode = '60163' or zipCode = '60163' or zipCode = '60163' or zipCode = '60164' or zipCode = '60164' or zipCode = '60165' or zipCode = '60165' or zipCode = '60171' or zipCode = '60173' or zipCode = '60173' or zipCode = '60173' or zipCode = '60176' or zipCode = '60090' or zipCode = '60091' or zipCode = '60093' or zipCode = '60093' or zipCode = '60093' or zipCode = '60101' or zipCode = '60126' or zipCode = '60130' or zipCode = '60131' or zipCode = '60131' or zipCode = '60181' or zipCode = '60181' or zipCode = '60181' or zipCode = '60189' or zipCode = '60191' or zipCode = '60399' or zipCode = '60399' or zipCode = '60402' or zipCode = '60402' or zipCode = '60402' or zipCode = '60406' or zipCode = '60406' or zipCode = '60409' or zipCode = '60415' or zipCode = '60419' or zipCode = '60422' or zipCode = '60422' or zipCode = '60425' or zipCode = '60426' or zipCode = '60426' or zipCode = '60445' or zipCode = '60445' or zipCode = '60452' or zipCode = '60453' or zipCode = '60454' or zipCode = '60455' or zipCode = '60455' or zipCode = '60455' or zipCode = '60456' or zipCode = '60456' or zipCode = '60457' or zipCode = '60476' or zipCode = '60477' or zipCode = '60477' or zipCode = '60478' or zipCode = '60478' or zipCode = '60478' or zipCode = '60478' or zipCode = '60480' or zipCode = '60480' or zipCode = '60482' or zipCode = '60487' or zipCode = '60487' or zipCode = '60513' or zipCode = '60514' or zipCode = '60514' or zipCode = '60515' or zipCode = '60516' or zipCode = '60517' or zipCode = '60517' or zipCode = '60521' or zipCode = '60521' or zipCode = '60521' or zipCode = '60521' or zipCode = '60522' or zipCode = '60522' or zipCode = '60523' or zipCode = '60523' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60196' or zipCode = '60196' or zipCode = '60196' or zipCode = '60196' or zipCode = '60199' or zipCode = '60199' or zipCode = '60201' or zipCode = '60202' or zipCode = '60203' or zipCode = '60204' or zipCode = '60208' or zipCode = '60208' or zipCode = '60209' or zipCode = '60209' or zipCode = '60290' or zipCode = '60290' or zipCode = '60301' or zipCode = '60302' or zipCode = '60303' or zipCode = '60304' or zipCode = '60305' or zipCode = '60399' or zipCode = '60426' or zipCode = '60426' or zipCode = '60428' or zipCode = '60428' or zipCode = '60429' or zipCode = '60429' or zipCode = '60430' or zipCode = '60438' or zipCode = '60439' or zipCode = '60439' or zipCode = '60457' or zipCode = '60458' or zipCode = '60458' or zipCode = '60458' or zipCode = '60459' or zipCode = '60459' or zipCode = '60459' or zipCode = '60462' or zipCode = '60463' or zipCode = '60464' or zipCode = '60465' or zipCode = '60467' or zipCode = '60469' or zipCode = '60472' or zipCode = '60473' or zipCode = '60499' or zipCode = '60499' or zipCode = '60499' or zipCode = '60499' or zipCode = '60501' or zipCode = '60501' or zipCode = '60501' or zipCode = '60501' or zipCode = '60501' or zipCode = '60501' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60526' or zipCode = '60526' or zipCode = '60526' or zipCode = '60527' or zipCode = '60527' or zipCode = '60527' or zipCode = '60527' or zipCode = '60532' or zipCode = '60534' or zipCode = '60546' or zipCode = '60546' or zipCode = '60546' or zipCode = '60558' or zipCode = '60558' or zipCode = '60559' or zipCode = '60561' or zipCode = '60561' or zipCode = '60599' or zipCode = '60599' or zipCode = '60599' or zipCode = '60601' or zipCode = '60602' or zipCode = '60603' or zipCode = '60604' or zipCode = '60605' or zipCode = '60606' or zipCode = '60607' or zipCode = '60608' or zipCode = '60608' or zipCode = '60609' or zipCode = '60609' or zipCode = '60610' or zipCode = '60610' or zipCode = '60610' or zipCode = '60611' or zipCode = '60611' or zipCode = '60611' or zipCode = '60612' or zipCode = '60612' or zipCode = '60613' or zipCode = '60613' or zipCode = '60614' or zipCode = '60614' or zipCode = '60615' or zipCode = '60615' or zipCode = '60616' or zipCode = '60616' or zipCode = '60617' or zipCode = '60617' or zipCode = '60618' or zipCode = '60618' or zipCode = '60619' or zipCode = '60619' or zipCode = '60620' or zipCode = '60621' or zipCode = '60621' or zipCode = '60622' or zipCode = '60622' or zipCode = '60633' or zipCode = '60633' or zipCode = '60634' or zipCode = '60634' or zipCode = '60634' or zipCode = '60634' or zipCode = '60636' or zipCode = '60636' or zipCode = '60637' or zipCode = '60637' or zipCode = '60638' or zipCode = '60638' or zipCode = '60638' or zipCode = '60638' or zipCode = '60638' or zipCode = '60639' or zipCode = '60639' or zipCode = '60640' or zipCode = '60641' or zipCode = '60642' or zipCode = '60642' or zipCode = '60643' or zipCode = '60643' or zipCode = '60643' or zipCode = '60655' or zipCode = '60656' or zipCode = '60656' or zipCode = '60656' or zipCode = '60656' or zipCode = '60657' or zipCode = '60657' or zipCode = '60659' or zipCode = '60659' or zipCode = '60659' or zipCode = '60660' or zipCode = '60660' or zipCode = '60661' or zipCode = '60664' or zipCode = '60664' or zipCode = '60666' or zipCode = '60666' or zipCode = '60668' or zipCode = '60668' or zipCode = '60669' or zipCode = '60669' or zipCode = '60670' or zipCode = '60670' or zipCode = '60670' or zipCode = '60688' or zipCode = '60689' or zipCode = '60689' or zipCode = '60690' or zipCode = '60691' or zipCode = '60693' or zipCode = '60693' or zipCode = '60694' or zipCode = '60694' or zipCode = '60695' or zipCode = '60695' or zipCode = '60696' or zipCode = '60696' or zipCode = '60696' or zipCode = '60697' or zipCode = '60697' or zipCode = '60699' or zipCode = '60699' or zipCode = '60701' or zipCode = '60706' or zipCode = '60706' or zipCode = '60706' or zipCode = '60706' or zipCode = '60623' or zipCode = '60623' or zipCode = '60624' or zipCode = '60624' or zipCode = '60625' or zipCode = '60625' or zipCode = '60626' or zipCode = '60626' or zipCode = '60628' or zipCode = '60628' or zipCode = '60629' or zipCode = '60629' or zipCode = '60629' or zipCode = '60629' or zipCode = '60630' or zipCode = '60630' or zipCode = '60630' or zipCode = '60630' or zipCode = '60630' or zipCode = '60631' or zipCode = '60631' or zipCode = '60632' or zipCode = '60632' or zipCode = '60633' or zipCode = '60644' or zipCode = '60644' or zipCode = '60645' or zipCode = '60645' or zipCode = '60645' or zipCode = '60646' or zipCode = '60646' or zipCode = '60647' or zipCode = '60647' or zipCode = '60649' or zipCode = '60649' or zipCode = '60651' or zipCode = '60651' or zipCode = '60652' or zipCode = '60652' or zipCode = '60653' or zipCode = '60653' or zipCode = '60654' or zipCode = '60654' or zipCode = '60655' or zipCode = '60655' or zipCode = '60655' or zipCode = '60655' or zipCode = '60673' or zipCode = '60673' or zipCode = '60673' or zipCode = '60674' or zipCode = '60674' or zipCode = '60675' or zipCode = '60675' or zipCode = '60677' or zipCode = '60677' or zipCode = '60678' or zipCode = '60678' or zipCode = '60680' or zipCode = '60681' or zipCode = '60682' or zipCode = '60682' or zipCode = '60684' or zipCode = '60684' or zipCode = '60685' or zipCode = '60685' or zipCode = '60686' or zipCode = '60686' or zipCode = '60687' or zipCode = '60687' or zipCode = '60688' or zipCode = '60707' or zipCode = '60707' or zipCode = '60712' or zipCode = '60712' or zipCode = '60712' or zipCode = '60712' or zipCode = '60714' or zipCode = '60803' or zipCode = '60803' or zipCode = '60803' or zipCode = '60803' or zipCode = '60804' or zipCode = '60804' or zipCode = '60805' or zipCode = '60805' or zipCode = '60805' or zipCode = '60827' or zipCode = '60827' or zipCode = '60827' or zipCode = '46312' or zipCode = '46320' or zipCode = '46321' or zipCode = '46322' or zipCode = '46323' or zipCode = '46324' or zipCode = '46327' or zipCode = '46394' or zipCode = '46402' or zipCode = '46404' or zipCode = '46406' or zipCode = '60004' or zipCode = '60005' or zipCode = '60006' or zipCode = '60007' or zipCode = '60008' or zipCode = '60009' or zipCode = '60015' or zipCode = '60016' or zipCode = '60017' or zipCode = '60018' or zipCode = '60019' or zipCode = '60022' or zipCode = '60025' or zipCode = '60026' or zipCode = '60029' or zipCode = '60035' or zipCode = '60037' or zipCode = '60038' or zipCode = '60040' or zipCode = '60043' or zipCode = '60053' or zipCode = '60055' or zipCode = '60056' or zipCode = '60062' or zipCode = '60065' or zipCode = '60068' or zipCode = '60070' or zipCode = '60076' or zipCode = '60077' or zipCode = '60078' or zipCode = '60082' or zipCode = '60090' or zipCode = '60091' or zipCode = '60093' or zipCode = '60094' or zipCode = '60095' or zipCode = '60101' or zipCode = '60104' or zipCode = '60105' or zipCode = '60106' or zipCode = '60108' or zipCode = '60114' or zipCode = '60116' or zipCode = '60117' or zipCode = '60125' or zipCode = '60126' or zipCode = '60128' or zipCode = '60130' or zipCode = '60131' or zipCode = '60132' or zipCode = '60137' or zipCode = '60138' or zipCode = '60139' or zipCode = '60141' or zipCode = '60143' or zipCode = '60148' or zipCode = '60153' or zipCode = '60154' or zipCode = '60155' or zipCode = '60157' or zipCode = '60159' or zipCode = '60160' or zipCode = '60161' or zipCode = '60162' or zipCode = '60163' or zipCode = '60164' or zipCode = '60165' or zipCode = '60168' or zipCode = '60171' or zipCode = '60172' or zipCode = '60173' or zipCode = '60176' or zipCode = '60181' or zipCode = '60186' or zipCode = '60189' or zipCode = '60191' or zipCode = '60197' or zipCode = '60198' or zipCode = '60199' or zipCode = '60201' or zipCode = '60202' or zipCode = '60203' or zipCode = '60204' or zipCode = '60208' or zipCode = '60209' or zipCode = '60301' or zipCode = '60302' or zipCode = '60303' or zipCode = '60304' or zipCode = '60305' or zipCode = '60330' or zipCode = '60402' or zipCode = '60406' or zipCode = '60409' or zipCode = '60412' or zipCode = '60415' or zipCode = '60419' or zipCode = '60422' or zipCode = '60425' or zipCode = '60426' or zipCode = '60429' or zipCode = '60430' or zipCode = '60438' or zipCode = '60439' or zipCode = '60445' or zipCode = '60452' or zipCode = '60453' or zipCode = '60454' or zipCode = '60455' or zipCode = '60456' or zipCode = '60457' or zipCode = '60458' or zipCode = '60459' or zipCode = '60462' or zipCode = '60463' or zipCode = '60464' or zipCode = '60465' or zipCode = '60467' or zipCode = '60469' or zipCode = '60472' or zipCode = '60473' or zipCode = '60476' or zipCode = '60477' or zipCode = '60478' or zipCode = '60480' or zipCode = '60482' or zipCode = '60499' or zipCode = '60501' or zipCode = '60513' or zipCode = '60514' or zipCode = '60515' or zipCode = '60516' or zipCode = '60517' or zipCode = '60521' or zipCode = '60522' or zipCode = '60523' or zipCode = '60525' or zipCode = '60526' or zipCode = '60527' or zipCode = '60532' or zipCode = '60534' or zipCode = '60546' or zipCode = '60558' or zipCode = '60559' or zipCode = '60561' or zipCode = '60566' or zipCode = '60567' or zipCode = '60570' or zipCode = '60572' or zipCode = '60597' or zipCode = '60598' or zipCode = '60599' or zipCode = '60601' or zipCode = '60602' or zipCode = '60603' or zipCode = '60604' or zipCode = '60605' or zipCode = '60606' or zipCode = '60607' or zipCode = '60608' or zipCode = '60609' or zipCode = '60610' or zipCode = '60611' or zipCode = '60612' or zipCode = '60613' or zipCode = '60614' or zipCode = '60615' or zipCode = '60616' or zipCode = '60617' or zipCode = '60618' or zipCode = '60619' or zipCode = '60620' or zipCode = '60621' or zipCode = '60622' or zipCode = '60623' or zipCode = '60624' or zipCode = '60625' or zipCode = '60626' or zipCode = '60628' or zipCode = '60629' or zipCode = '60630' or zipCode = '60631' or zipCode = '60632' or zipCode = '60633' or zipCode = '60634' or zipCode = '60636' or zipCode = '60637' or zipCode = '60638' or zipCode = '60639' or zipCode = '60640' or zipCode = '60641' or zipCode = '60643' or zipCode = '60644' or zipCode = '60645' or zipCode = '60646' or zipCode = '60647' or zipCode = '60649' or zipCode = '60650' or zipCode = '60651' or zipCode = '60652' or zipCode = '60653' or zipCode = '60654' or zipCode = '60655' or zipCode = '60656' or zipCode = '60657' or zipCode = '60659' or zipCode = '60660' or zipCode = '60661' or zipCode = '60663' or zipCode = '60664' or zipCode = '60665' or zipCode = '60666' or zipCode = '60667' or zipCode = '60668' or zipCode = '60669' or zipCode = '60670' or zipCode = '60671' or zipCode = '60672' or zipCode = '60673' or zipCode = '60674' or zipCode = '60675' or zipCode = '60677' or zipCode = '60678' or zipCode = '60679' or zipCode = '60680' or zipCode = '60681' or zipCode = '60683' or zipCode = '60684' or zipCode = '60685' or zipCode = '60687' or zipCode = '60690' or zipCode = '60691' or zipCode = '60692' or zipCode = '60693' or zipCode = '60694' or zipCode = '60697' or zipCode = '60699' or zipCode = '60701' or zipCode = '60706' or zipCode = '60707' or zipCode = '60712' or zipCode = '60714' or zipCode = '60803' or zipCode = '60804' or zipCode = '60805' or zipCode = '60827') order by price;
select top 240 * from tblBothNew NOLOCK where priority IS NULL and price > 10000 and original_price IS NOT NULL and original_price > 10000 and (status='active' or status='for_sale' or status IS NULL) and (propertyType != 'LAND' or propertyType IS NULL) and len(photoURL1) > 5 and dateposted >= '8/29/2021' and theType = 'RealtorValue' and len(photoURL1) > 3 and photoURL1 IS NOT NULL and (bedrooms <> '' and bedrooms IS NOT NULL) and (1=1) and price >= 0 and price <= 499999 and 11=11 and (zipCode ='46312' or zipCode = '46320' or zipCode = '46321' or zipCode = '46321' or zipCode = '46323' or zipCode = '46323' or zipCode = '46324' or zipCode = '46324' or zipCode = '46325' or zipCode = '46327' or zipCode = '46394' or zipCode = '46394' or zipCode = '46401' or zipCode = '46402' or zipCode = '46404' or zipCode = '46406' or zipCode = '46406' or zipCode = '46411' or zipCode = '46411' or zipCode = '60004' or zipCode = '60004' or zipCode = '60005' or zipCode = '60005' or zipCode = '60006' or zipCode = '60006' or zipCode = '60007' or zipCode = '60007' or zipCode = '60008' or zipCode = '60008' or zipCode = '60009' or zipCode = '60009' or zipCode = '60015' or zipCode = '60016' or zipCode = '60017' or zipCode = '60018' or zipCode = '60018' or zipCode = '60019' or zipCode = '60019' or zipCode = '60019' or zipCode = '60022' or zipCode = '60025' or zipCode = '60026' or zipCode = '60029' or zipCode = '60068' or zipCode = '60070' or zipCode = '60070' or zipCode = '60015' or zipCode = '60015' or zipCode = '60035' or zipCode = '60037' or zipCode = '60037' or zipCode = '60040' or zipCode = '60043' or zipCode = '60053' or zipCode = '60056' or zipCode = '60056' or zipCode = '60062' or zipCode = '60065' or zipCode = '60076' or zipCode = '60077' or zipCode = '60082' or zipCode = '60104' or zipCode = '60105' or zipCode = '60105' or zipCode = '60106' or zipCode = '60108' or zipCode = '60117' or zipCode = '60117' or zipCode = '60137' or zipCode = '60137' or zipCode = '60137' or zipCode = '60138' or zipCode = '60139' or zipCode = '60139' or zipCode = '60141' or zipCode = '60143' or zipCode = '60148' or zipCode = '60148' or zipCode = '60153' or zipCode = '60153' or zipCode = '60154' or zipCode = '60155' or zipCode = '60155' or zipCode = '60157' or zipCode = '60160' or zipCode = '60161' or zipCode = '60162' or zipCode = '60163' or zipCode = '60163' or zipCode = '60163' or zipCode = '60164' or zipCode = '60164' or zipCode = '60165' or zipCode = '60165' or zipCode = '60171' or zipCode = '60173' or zipCode = '60173' or zipCode = '60173' or zipCode = '60176' or zipCode = '60090' or zipCode = '60091' or zipCode = '60093' or zipCode = '60093' or zipCode = '60093' or zipCode = '60101' or zipCode = '60126' or zipCode = '60130' or zipCode = '60131' or zipCode = '60131' or zipCode = '60181' or zipCode = '60181' or zipCode = '60181' or zipCode = '60189' or zipCode = '60191' or zipCode = '60399' or zipCode = '60399' or zipCode = '60402' or zipCode = '60402' or zipCode = '60402' or zipCode = '60406' or zipCode = '60406' or zipCode = '60409' or zipCode = '60415' or zipCode = '60419' or zipCode = '60422' or zipCode = '60422' or zipCode = '60425' or zipCode = '60426' or zipCode = '60426' or zipCode = '60445' or zipCode = '60445' or zipCode = '60452' or zipCode = '60453' or zipCode = '60454' or zipCode = '60455' or zipCode = '60455' or zipCode = '60455' or zipCode = '60456' or zipCode = '60456' or zipCode = '60457' or zipCode = '60476' or zipCode = '60477' or zipCode = '60477' or zipCode = '60478' or zipCode = '60478' or zipCode = '60478' or zipCode = '60478' or zipCode = '60480' or zipCode = '60480' or zipCode = '60482' or zipCode = '60487' or zipCode = '60487' or zipCode = '60513' or zipCode = '60514' or zipCode = '60514' or zipCode = '60515' or zipCode = '60516' or zipCode = '60517' or zipCode = '60517' or zipCode = '60521' or zipCode = '60521' or zipCode = '60521' or zipCode = '60521' or zipCode = '60522' or zipCode = '60522' or zipCode = '60523' or zipCode = '60523' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60196' or zipCode = '60196' or zipCode = '60196' or zipCode = '60196' or zipCode = '60199' or zipCode = '60199' or zipCode = '60201' or zipCode = '60202' or zipCode = '60203' or zipCode = '60204' or zipCode = '60208' or zipCode = '60208' or zipCode = '60209' or zipCode = '60209' or zipCode = '60290' or zipCode = '60290' or zipCode = '60301' or zipCode = '60302' or zipCode = '60303' or zipCode = '60304' or zipCode = '60305' or zipCode = '60399' or zipCode = '60426' or zipCode = '60426' or zipCode = '60428' or zipCode = '60428' or zipCode = '60429' or zipCode = '60429' or zipCode = '60430' or zipCode = '60438' or zipCode = '60439' or zipCode = '60439' or zipCode = '60457' or zipCode = '60458' or zipCode = '60458' or zipCode = '60458' or zipCode = '60459' or zipCode = '60459' or zipCode = '60459' or zipCode = '60462' or zipCode = '60463' or zipCode = '60464' or zipCode = '60465' or zipCode = '60467' or zipCode = '60469' or zipCode = '60472' or zipCode = '60473' or zipCode = '60499' or zipCode = '60499' or zipCode = '60499' or zipCode = '60499' or zipCode = '60501' or zipCode = '60501' or zipCode = '60501' or zipCode = '60501' or zipCode = '60501' or zipCode = '60501' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60526' or zipCode = '60526' or zipCode = '60526' or zipCode = '60527' or zipCode = '60527' or zipCode = '60527' or zipCode = '60527' or zipCode = '60532' or zipCode = '60534' or zipCode = '60546' or zipCode = '60546' or zipCode = '60546' or zipCode = '60558' or zipCode = '60558' or zipCode = '60559' or zipCode = '60561' or zipCode = '60561' or zipCode = '60599' or zipCode = '60599' or zipCode = '60599' or zipCode = '60601' or zipCode = '60602' or zipCode = '60603' or zipCode = '60604' or zipCode = '60605' or zipCode = '60606' or zipCode = '60607' or zipCode = '60608' or zipCode = '60608' or zipCode = '60609' or zipCode = '60609' or zipCode = '60610' or zipCode = '60610' or zipCode = '60610' or zipCode = '60611' or zipCode = '60611' or zipCode = '60611' or zipCode = '60612' or zipCode = '60612' or zipCode = '60613' or zipCode = '60613' or zipCode = '60614' or zipCode = '60614' or zipCode = '60615' or zipCode = '60615' or zipCode = '60616' or zipCode = '60616' or zipCode = '60617' or zipCode = '60617' or zipCode = '60618' or zipCode = '60618' or zipCode = '60619' or zipCode = '60619' or zipCode = '60620' or zipCode = '60621' or zipCode = '60621' or zipCode = '60622' or zipCode = '60622' or zipCode = '60633' or zipCode = '60633' or zipCode = '60634' or zipCode = '60634' or zipCode = '60634' or zipCode = '60634' or zipCode = '60636' or zipCode = '60636' or zipCode = '60637' or zipCode = '60637' or zipCode = '60638' or zipCode = '60638' or zipCode = '60638' or zipCode = '60638' or zipCode = '60638' or zipCode = '60639' or zipCode = '60639' or zipCode = '60640' or zipCode = '60641' or zipCode = '60642' or zipCode = '60642' or zipCode = '60643' or zipCode = '60643' or zipCode = '60643' or zipCode = '60655' or zipCode = '60656' or zipCode = '60656' or zipCode = '60656' or zipCode = '60656' or zipCode = '60657' or zipCode = '60657' or zipCode = '60659' or zipCode = '60659' or zipCode = '60659' or zipCode = '60660' or zipCode = '60660' or zipCode = '60661' or zipCode = '60664' or zipCode = '60664' or zipCode = '60666' or zipCode = '60666' or zipCode = '60668' or zipCode = '60668' or zipCode = '60669' or zipCode = '60669' or zipCode = '60670' or zipCode = '60670' or zipCode = '60670' or zipCode = '60688' or zipCode = '60689' or zipCode = '60689' or zipCode = '60690' or zipCode = '60691' or zipCode = '60693' or zipCode = '60693' or zipCode = '60694' or zipCode = '60694' or zipCode = '60695' or zipCode = '60695' or zipCode = '60696' or zipCode = '60696' or zipCode = '60696' or zipCode = '60697' or zipCode = '60697' or zipCode = '60699' or zipCode = '60699' or zipCode = '60701' or zipCode = '60706' or zipCode = '60706' or zipCode = '60706' or zipCode = '60706' or zipCode = '60623' or zipCode = '60623' or zipCode = '60624' or zipCode = '60624' or zipCode = '60625' or zipCode = '60625' or zipCode = '60626' or zipCode = '60626' or zipCode = '60628' or zipCode = '60628' or zipCode = '60629' or zipCode = '60629' or zipCode = '60629' or zipCode = '60629' or zipCode = '60630' or zipCode = '60630' or zipCode = '60630' or zipCode = '60630' or zipCode = '60630' or zipCode = '60631' or zipCode = '60631' or zipCode = '60632' or zipCode = '60632' or zipCode = '60633' or zipCode = '60644' or zipCode = '60644' or zipCode = '60645' or zipCode = '60645' or zipCode = '60645' or zipCode = '60646' or zipCode = '60646' or zipCode = '60647' or zipCode = '60647' or zipCode = '60649' or zipCode = '60649' or zipCode = '60651' or zipCode = '60651' or zipCode = '60652' or zipCode = '60652' or zipCode = '60653' or zipCode = '60653' or zipCode = '60654' or zipCode = '60654' or zipCode = '60655' or zipCode = '60655' or zipCode = '60655' or zipCode = '60655' or zipCode = '60673' or zipCode = '60673' or zipCode = '60673' or zipCode = '60674' or zipCode = '60674' or zipCode = '60675' or zipCode = '60675' or zipCode = '60677' or zipCode = '60677' or zipCode = '60678' or zipCode = '60678' or zipCode = '60680' or zipCode = '60681' or zipCode = '60682' or zipCode = '60682' or zipCode = '60684' or zipCode = '60684' or zipCode = '60685' or zipCode = '60685' or zipCode = '60686' or zipCode = '60686' or zipCode = '60687' or zipCode = '60687' or zipCode = '60688' or zipCode = '60707' or zipCode = '60707' or zipCode = '60712' or zipCode = '60712' or zipCode = '60712' or zipCode = '60712' or zipCode = '60714' or zipCode = '60803' or zipCode = '60803' or zipCode = '60803' or zipCode = '60803' or zipCode = '60804' or zipCode = '60804' or zipCode = '60805' or zipCode = '60805' or zipCode = '60805' or zipCode = '60827' or zipCode = '60827' or zipCode = '60827' or zipCode = '46312' or zipCode = '46320' or zipCode = '46321' or zipCode = '46322' or zipCode = '46323' or zipCode = '46324' or zipCode = '46327' or zipCode = '46394' or zipCode = '46402' or zipCode = '46404' or zipCode = '46406' or zipCode = '60004' or zipCode = '60005' or zipCode = '60006' or zipCode = '60007' or zipCode = '60008' or zipCode = '60009' or zipCode = '60015' or zipCode = '60016' or zipCode = '60017' or zipCode = '60018' or zipCode = '60019' or zipCode = '60022' or zipCode = '60025' or zipCode = '60026' or zipCode = '60029' or zipCode = '60035' or zipCode = '60037' or zipCode = '60038' or zipCode = '60040' or zipCode = '60043' or zipCode = '60053' or zipCode = '60055' or zipCode = '60056' or zipCode = '60062' or zipCode = '60065' or zipCode = '60068' or zipCode = '60070' or zipCode = '60076' or zipCode = '60077' or zipCode = '60078' or zipCode = '60082' or zipCode = '60090' or zipCode = '60091' or zipCode = '60093' or zipCode = '60094' or zipCode = '60095' or zipCode = '60101' or zipCode = '60104' or zipCode = '60105' or zipCode = '60106' or zipCode = '60108' or zipCode = '60114' or zipCode = '60116' or zipCode = '60117' or zipCode = '60125' or zipCode = '60126' or zipCode = '60128' or zipCode = '60130' or zipCode = '60131' or zipCode = '60132' or zipCode = '60137' or zipCode = '60138' or zipCode = '60139' or zipCode = '60141' or zipCode = '60143' or zipCode = '60148' or zipCode = '60153' or zipCode = '60154' or zipCode = '60155' or zipCode = '60157' or zipCode = '60159' or zipCode = '60160' or zipCode = '60161' or zipCode = '60162' or zipCode = '60163' or zipCode = '60164' or zipCode = '60165' or zipCode = '60168' or zipCode = '60171' or zipCode = '60172' or zipCode = '60173' or zipCode = '60176' or zipCode = '60181' or zipCode = '60186' or zipCode = '60189' or zipCode = '60191' or zipCode = '60197' or zipCode = '60198' or zipCode = '60199' or zipCode = '60201' or zipCode = '60202' or zipCode = '60203' or zipCode = '60204' or zipCode = '60208' or zipCode = '60209' or zipCode = '60301' or zipCode = '60302' or zipCode = '60303' or zipCode = '60304' or zipCode = '60305' or zipCode = '60330' or zipCode = '60402' or zipCode = '60406' or zipCode = '60409' or zipCode = '60412' or zipCode = '60415' or zipCode = '60419' or zipCode = '60422' or zipCode = '60425' or zipCode = '60426' or zipCode = '60429' or zipCode = '60430' or zipCode = '60438' or zipCode = '60439' or zipCode = '60445' or zipCode = '60452' or zipCode = '60453' or zipCode = '60454' or zipCode = '60455' or zipCode = '60456' or zipCode = '60457' or zipCode = '60458' or zipCode = '60459' or zipCode = '60462' or zipCode = '60463' or zipCode = '60464' or zipCode = '60465' or zipCode = '60467' or zipCode = '60469' or zipCode = '60472' or zipCode = '60473' or zipCode = '60476' or zipCode = '60477' or zipCode = '60478' or zipCode = '60480' or zipCode = '60482' or zipCode = '60499' or zipCode = '60501' or zipCode = '60513' or zipCode = '60514' or zipCode = '60515' or zipCode = '60516' or zipCode = '60517' or zipCode = '60521' or zipCode = '60522' or zipCode = '60523' or zipCode = '60525' or zipCode = '60526' or zipCode = '60527' or zipCode = '60532' or zipCode = '60534' or zipCode = '60546' or zipCode = '60558' or zipCode = '60559' or zipCode = '60561' or zipCode = '60566' or zipCode = '60567' or zipCode = '60570' or zipCode = '60572' or zipCode = '60597' or zipCode = '60598' or zipCode = '60599' or zipCode = '60601' or zipCode = '60602' or zipCode = '60603' or zipCode = '60604' or zipCode = '60605' or zipCode = '60606' or zipCode = '60607' or zipCode = '60608' or zipCode = '60609' or zipCode = '60610' or zipCode = '60611' or zipCode = '60612' or zipCode = '60613' or zipCode = '60614' or zipCode = '60615' or zipCode = '60616' or zipCode = '60617' or zipCode = '60618' or zipCode = '60619' or zipCode = '60620' or zipCode = '60621' or zipCode = '60622' or zipCode = '60623' or zipCode = '60624' or zipCode = '60625' or zipCode = '60626' or zipCode = '60628' or zipCode = '60629' or zipCode = '60630' or zipCode = '60631' or zipCode = '60632' or zipCode = '60633' or zipCode = '60634' or zipCode = '60636' or zipCode = '60637' or zipCode = '60638' or zipCode = '60639' or zipCode = '60640' or zipCode = '60641' or zipCode = '60643' or zipCode = '60644' or zipCode = '60645' or zipCode = '60646' or zipCode = '60647' or zipCode = '60649' or zipCode = '60650' or zipCode = '60651' or zipCode = '60652' or zipCode = '60653' or zipCode = '60654' or zipCode = '60655' or zipCode = '60656' or zipCode = '60657' or zipCode = '60659' or zipCode = '60660' or zipCode = '60661' or zipCode = '60663' or zipCode = '60664' or zipCode = '60665' or zipCode = '60666' or zipCode = '60667' or zipCode = '60668' or zipCode = '60669' or zipCode = '60670' or zipCode = '60671' or zipCode = '60672' or zipCode = '60673' or zipCode = '60674' or zipCode = '60675' or zipCode = '60677' or zipCode = '60678' or zipCode = '60679' or zipCode = '60680' or zipCode = '60681' or zipCode = '60683' or zipCode = '60684' or zipCode = '60685' or zipCode = '60687' or zipCode = '60690' or zipCode = '60691' or zipCode = '60692' or zipCode = '60693' or zipCode = '60694' or zipCode = '60697' or zipCode = '60699' or zipCode = '60701' or zipCode = '60706' or zipCode = '60707' or zipCode = '60712' or zipCode = '60714' or zipCode = '60803' or zipCode = '60804' or zipCode = '60805' or zipCode = '60827') order by price;
select top 1002 *, cast(tax_value as float)/cast(price as float) as tax_ratio from tblBothNew NOLOCK where yearBuilt <= 1991 and priority is null and price > 5000 and (1=1) and original_price is not null and 1=1 and (status='active' or status='for_sale' or status is null) and (propertyType !='land' or propertyType is null) and (bedrooms<>'' AND bedrooms IS NOT NULL) and photoURL1 is not null and len(photoURL1) > 3 and 1=1 and 1=1 and 1=1 and (1=1) and price >= 0 and price <= 499999 and 11=11 and (zipCode ='46312' or zipCode = '46320' or zipCode = '46321' or zipCode = '46321' or zipCode = '46323' or zipCode = '46323' or zipCode = '46324' or zipCode = '46324' or zipCode = '46325' or zipCode = '46327' or zipCode = '46394' or zipCode = '46394' or zipCode = '46401' or zipCode = '46402' or zipCode = '46404' or zipCode = '46406' or zipCode = '46406' or zipCode = '46411' or zipCode = '46411' or zipCode = '60004' or zipCode = '60004' or zipCode = '60005' or zipCode = '60005' or zipCode = '60006' or zipCode = '60006' or zipCode = '60007' or zipCode = '60007' or zipCode = '60008' or zipCode = '60008' or zipCode = '60009' or zipCode = '60009' or zipCode = '60015' or zipCode = '60016' or zipCode = '60017' or zipCode = '60018' or zipCode = '60018' or zipCode = '60019' or zipCode = '60019' or zipCode = '60019' or zipCode = '60022' or zipCode = '60025' or zipCode = '60026' or zipCode = '60029' or zipCode = '60068' or zipCode = '60070' or zipCode = '60070' or zipCode = '60015' or zipCode = '60015' or zipCode = '60035' or zipCode = '60037' or zipCode = '60037' or zipCode = '60040' or zipCode = '60043' or zipCode = '60053' or zipCode = '60056' or zipCode = '60056' or zipCode = '60062' or zipCode = '60065' or zipCode = '60076' or zipCode = '60077' or zipCode = '60082' or zipCode = '60104' or zipCode = '60105' or zipCode = '60105' or zipCode = '60106' or zipCode = '60108' or zipCode = '60117' or zipCode = '60117' or zipCode = '60137' or zipCode = '60137' or zipCode = '60137' or zipCode = '60138' or zipCode = '60139' or zipCode = '60139' or zipCode = '60141' or zipCode = '60143' or zipCode = '60148' or zipCode = '60148' or zipCode = '60153' or zipCode = '60153' or zipCode = '60154' or zipCode = '60155' or zipCode = '60155' or zipCode = '60157' or zipCode = '60160' or zipCode = '60161' or zipCode = '60162' or zipCode = '60163' or zipCode = '60163' or zipCode = '60163' or zipCode = '60164' or zipCode = '60164' or zipCode = '60165' or zipCode = '60165' or zipCode = '60171' or zipCode = '60173' or zipCode = '60173' or zipCode = '60173' or zipCode = '60176' or zipCode = '60090' or zipCode = '60091' or zipCode = '60093' or zipCode = '60093' or zipCode = '60093' or zipCode = '60101' or zipCode = '60126' or zipCode = '60130' or zipCode = '60131' or zipCode = '60131' or zipCode = '60181' or zipCode = '60181' or zipCode = '60181' or zipCode = '60189' or zipCode = '60191' or zipCode = '60399' or zipCode = '60399' or zipCode = '60402' or zipCode = '60402' or zipCode = '60402' or zipCode = '60406' or zipCode = '60406' or zipCode = '60409' or zipCode = '60415' or zipCode = '60419' or zipCode = '60422' or zipCode = '60422' or zipCode = '60425' or zipCode = '60426' or zipCode = '60426' or zipCode = '60445' or zipCode = '60445' or zipCode = '60452' or zipCode = '60453' or zipCode = '60454' or zipCode = '60455' or zipCode = '60455' or zipCode = '60455' or zipCode = '60456' or zipCode = '60456' or zipCode = '60457' or zipCode = '60476' or zipCode = '60477' or zipCode = '60477' or zipCode = '60478' or zipCode = '60478' or zipCode = '60478' or zipCode = '60478' or zipCode = '60480' or zipCode = '60480' or zipCode = '60482' or zipCode = '60487' or zipCode = '60487' or zipCode = '60513' or zipCode = '60514' or zipCode = '60514' or zipCode = '60515' or zipCode = '60516' or zipCode = '60517' or zipCode = '60517' or zipCode = '60521' or zipCode = '60521' or zipCode = '60521' or zipCode = '60521' or zipCode = '60522' or zipCode = '60522' or zipCode = '60523' or zipCode = '60523' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60196' or zipCode = '60196' or zipCode = '60196' or zipCode = '60196' or zipCode = '60199' or zipCode = '60199' or zipCode = '60201' or zipCode = '60202' or zipCode = '60203' or zipCode = '60204' or zipCode = '60208' or zipCode = '60208' or zipCode = '60209' or zipCode = '60209' or zipCode = '60290' or zipCode = '60290' or zipCode = '60301' or zipCode = '60302' or zipCode = '60303' or zipCode = '60304' or zipCode = '60305' or zipCode = '60399' or zipCode = '60426' or zipCode = '60426' or zipCode = '60428' or zipCode = '60428' or zipCode = '60429' or zipCode = '60429' or zipCode = '60430' or zipCode = '60438' or zipCode = '60439' or zipCode = '60439' or zipCode = '60457' or zipCode = '60458' or zipCode = '60458' or zipCode = '60458' or zipCode = '60459' or zipCode = '60459' or zipCode = '60459' or zipCode = '60462' or zipCode = '60463' or zipCode = '60464' or zipCode = '60465' or zipCode = '60467' or zipCode = '60469' or zipCode = '60472' or zipCode = '60473' or zipCode = '60499' or zipCode = '60499' or zipCode = '60499' or zipCode = '60499' or zipCode = '60501' or zipCode = '60501' or zipCode = '60501' or zipCode = '60501' or zipCode = '60501' or zipCode = '60501' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60526' or zipCode = '60526' or zipCode = '60526' or zipCode = '60527' or zipCode = '60527' or zipCode = '60527' or zipCode = '60527' or zipCode = '60532' or zipCode = '60534' or zipCode = '60546' or zipCode = '60546' or zipCode = '60546' or zipCode = '60558' or zipCode = '60558' or zipCode = '60559' or zipCode = '60561' or zipCode = '60561' or zipCode = '60599' or zipCode = '60599' or zipCode = '60599' or zipCode = '60601' or zipCode = '60602' or zipCode = '60603' or zipCode = '60604' or zipCode = '60605' or zipCode = '60606' or zipCode = '60607' or zipCode = '60608' or zipCode = '60608' or zipCode = '60609' or zipCode = '60609' or zipCode = '60610' or zipCode = '60610' or zipCode = '60610' or zipCode = '60611' or zipCode = '60611' or zipCode = '60611' or zipCode = '60612' or zipCode = '60612' or zipCode = '60613' or zipCode = '60613' or zipCode = '60614' or zipCode = '60614' or zipCode = '60615' or zipCode = '60615' or zipCode = '60616' or zipCode = '60616' or zipCode = '60617' or zipCode = '60617' or zipCode = '60618' or zipCode = '60618' or zipCode = '60619' or zipCode = '60619' or zipCode = '60620' or zipCode = '60621' or zipCode = '60621' or zipCode = '60622' or zipCode = '60622' or zipCode = '60633' or zipCode = '60633' or zipCode = '60634' or zipCode = '60634' or zipCode = '60634' or zipCode = '60634' or zipCode = '60636' or zipCode = '60636' or zipCode = '60637' or zipCode = '60637' or zipCode = '60638' or zipCode = '60638' or zipCode = '60638' or zipCode = '60638' or zipCode = '60638' or zipCode = '60639' or zipCode = '60639' or zipCode = '60640' or zipCode = '60641' or zipCode = '60642' or zipCode = '60642' or zipCode = '60643' or zipCode = '60643' or zipCode = '60643' or zipCode = '60655' or zipCode = '60656' or zipCode = '60656' or zipCode = '60656' or zipCode = '60656' or zipCode = '60657' or zipCode = '60657' or zipCode = '60659' or zipCode = '60659' or zipCode = '60659' or zipCode = '60660' or zipCode = '60660' or zipCode = '60661' or zipCode = '60664' or zipCode = '60664' or zipCode = '60666' or zipCode = '60666' or zipCode = '60668' or zipCode = '60668' or zipCode = '60669' or zipCode = '60669' or zipCode = '60670' or zipCode = '60670' or zipCode = '60670' or zipCode = '60688' or zipCode = '60689' or zipCode = '60689' or zipCode = '60690' or zipCode = '60691' or zipCode = '60693' or zipCode = '60693' or zipCode = '60694' or zipCode = '60694' or zipCode = '60695' or zipCode = '60695' or zipCode = '60696' or zipCode = '60696' or zipCode = '60696' or zipCode = '60697' or zipCode = '60697' or zipCode = '60699' or zipCode = '60699' or zipCode = '60701' or zipCode = '60706' or zipCode = '60706' or zipCode = '60706' or zipCode = '60706' or zipCode = '60623' or zipCode = '60623' or zipCode = '60624' or zipCode = '60624' or zipCode = '60625' or zipCode = '60625' or zipCode = '60626' or zipCode = '60626' or zipCode = '60628' or zipCode = '60628' or zipCode = '60629' or zipCode = '60629' or zipCode = '60629' or zipCode = '60629' or zipCode = '60630' or zipCode = '60630' or zipCode = '60630' or zipCode = '60630' or zipCode = '60630' or zipCode = '60631' or zipCode = '60631' or zipCode = '60632' or zipCode = '60632' or zipCode = '60633' or zipCode = '60644' or zipCode = '60644' or zipCode = '60645' or zipCode = '60645' or zipCode = '60645' or zipCode = '60646' or zipCode = '60646' or zipCode = '60647' or zipCode = '60647' or zipCode = '60649' or zipCode = '60649' or zipCode = '60651' or zipCode = '60651' or zipCode = '60652' or zipCode = '60652' or zipCode = '60653' or zipCode = '60653' or zipCode = '60654' or zipCode = '60654' or zipCode = '60655' or zipCode = '60655' or zipCode = '60655' or zipCode = '60655' or zipCode = '60673' or zipCode = '60673' or zipCode = '60673' or zipCode = '60674' or zipCode = '60674' or zipCode = '60675' or zipCode = '60675' or zipCode = '60677' or zipCode = '60677' or zipCode = '60678' or zipCode = '60678' or zipCode = '60680' or zipCode = '60681' or zipCode = '60682' or zipCode = '60682' or zipCode = '60684' or zipCode = '60684' or zipCode = '60685' or zipCode = '60685' or zipCode = '60686' or zipCode = '60686' or zipCode = '60687' or zipCode = '60687' or zipCode = '60688' or zipCode = '60707' or zipCode = '60707' or zipCode = '60712' or zipCode = '60712' or zipCode = '60712' or zipCode = '60712' or zipCode = '60714' or zipCode = '60803' or zipCode = '60803' or zipCode = '60803' or zipCode = '60803' or zipCode = '60804' or zipCode = '60804' or zipCode = '60805' or zipCode = '60805' or zipCode = '60805' or zipCode = '60827' or zipCode = '60827' or zipCode = '60827' or zipCode = '46312' or zipCode = '46320' or zipCode = '46321' or zipCode = '46322' or zipCode = '46323' or zipCode = '46324' or zipCode = '46327' or zipCode = '46394' or zipCode = '46402' or zipCode = '46404' or zipCode = '46406' or zipCode = '60004' or zipCode = '60005' or zipCode = '60006' or zipCode = '60007' or zipCode = '60008' or zipCode = '60009' or zipCode = '60015' or zipCode = '60016' or zipCode = '60017' or zipCode = '60018' or zipCode = '60019' or zipCode = '60022' or zipCode = '60025' or zipCode = '60026' or zipCode = '60029' or zipCode = '60035' or zipCode = '60037' or zipCode = '60038' or zipCode = '60040' or zipCode = '60043' or zipCode = '60053' or zipCode = '60055' or zipCode = '60056' or zipCode = '60062' or zipCode = '60065' or zipCode = '60068' or zipCode = '60070' or zipCode = '60076' or zipCode = '60077' or zipCode = '60078' or zipCode = '60082' or zipCode = '60090' or zipCode = '60091' or zipCode = '60093' or zipCode = '60094' or zipCode = '60095' or zipCode = '60101' or zipCode = '60104' or zipCode = '60105' or zipCode = '60106' or zipCode = '60108' or zipCode = '60114' or zipCode = '60116' or zipCode = '60117' or zipCode = '60125' or zipCode = '60126' or zipCode = '60128' or zipCode = '60130' or zipCode = '60131' or zipCode = '60132' or zipCode = '60137' or zipCode = '60138' or zipCode = '60139' or zipCode = '60141' or zipCode = '60143' or zipCode = '60148' or zipCode = '60153' or zipCode = '60154' or zipCode = '60155' or zipCode = '60157' or zipCode = '60159' or zipCode = '60160' or zipCode = '60161' or zipCode = '60162' or zipCode = '60163' or zipCode = '60164' or zipCode = '60165' or zipCode = '60168' or zipCode = '60171' or zipCode = '60172' or zipCode = '60173' or zipCode = '60176' or zipCode = '60181' or zipCode = '60186' or zipCode = '60189' or zipCode = '60191' or zipCode = '60197' or zipCode = '60198' or zipCode = '60199' or zipCode = '60201' or zipCode = '60202' or zipCode = '60203' or zipCode = '60204' or zipCode = '60208' or zipCode = '60209' or zipCode = '60301' or zipCode = '60302' or zipCode = '60303' or zipCode = '60304' or zipCode = '60305' or zipCode = '60330' or zipCode = '60402' or zipCode = '60406' or zipCode = '60409' or zipCode = '60412' or zipCode = '60415' or zipCode = '60419' or zipCode = '60422' or zipCode = '60425' or zipCode = '60426' or zipCode = '60429' or zipCode = '60430' or zipCode = '60438' or zipCode = '60439' or zipCode = '60445' or zipCode = '60452' or zipCode = '60453' or zipCode = '60454' or zipCode = '60455' or zipCode = '60456' or zipCode = '60457' or zipCode = '60458' or zipCode = '60459' or zipCode = '60462' or zipCode = '60463' or zipCode = '60464' or zipCode = '60465' or zipCode = '60467' or zipCode = '60469' or zipCode = '60472' or zipCode = '60473' or zipCode = '60476' or zipCode = '60477' or zipCode = '60478' or zipCode = '60480' or zipCode = '60482' or zipCode = '60499' or zipCode = '60501' or zipCode = '60513' or zipCode = '60514' or zipCode = '60515' or zipCode = '60516' or zipCode = '60517' or zipCode = '60521' or zipCode = '60522' or zipCode = '60523' or zipCode = '60525' or zipCode = '60526' or zipCode = '60527' or zipCode = '60532' or zipCode = '60534' or zipCode = '60546' or zipCode = '60558' or zipCode = '60559' or zipCode = '60561' or zipCode = '60566' or zipCode = '60567' or zipCode = '60570' or zipCode = '60572' or zipCode = '60597' or zipCode = '60598' or zipCode = '60599' or zipCode = '60601' or zipCode = '60602' or zipCode = '60603' or zipCode = '60604' or zipCode = '60605' or zipCode = '60606' or zipCode = '60607' or zipCode = '60608' or zipCode = '60609' or zipCode = '60610' or zipCode = '60611' or zipCode = '60612' or zipCode = '60613' or zipCode = '60614' or zipCode = '60615' or zipCode = '60616' or zipCode = '60617' or zipCode = '60618' or zipCode = '60619' or zipCode = '60620' or zipCode = '60621' or zipCode = '60622' or zipCode = '60623' or zipCode = '60624' or zipCode = '60625' or zipCode = '60626' or zipCode = '60628' or zipCode = '60629' or zipCode = '60630' or zipCode = '60631' or zipCode = '60632' or zipCode = '60633' or zipCode = '60634' or zipCode = '60636' or zipCode = '60637' or zipCode = '60638' or zipCode = '60639' or zipCode = '60640' or zipCode = '60641' or zipCode = '60643' or zipCode = '60644' or zipCode = '60645' or zipCode = '60646' or zipCode = '60647' or zipCode = '60649' or zipCode = '60650' or zipCode = '60651' or zipCode = '60652' or zipCode = '60653' or zipCode = '60654' or zipCode = '60655' or zipCode = '60656' or zipCode = '60657' or zipCode = '60659' or zipCode = '60660' or zipCode = '60661' or zipCode = '60663' or zipCode = '60664' or zipCode = '60665' or zipCode = '60666' or zipCode = '60667' or zipCode = '60668' or zipCode = '60669' or zipCode = '60670' or zipCode = '60671' or zipCode = '60672' or zipCode = '60673' or zipCode = '60674' or zipCode = '60675' or zipCode = '60677' or zipCode = '60678' or zipCode = '60679' or zipCode = '60680' or zipCode = '60681' or zipCode = '60683' or zipCode = '60684' or zipCode = '60685' or zipCode = '60687' or zipCode = '60690' or zipCode = '60691' or zipCode = '60692' or zipCode = '60693' or zipCode = '60694' or zipCode = '60697' or zipCode = '60699' or zipCode = '60701' or zipCode = '60706' or zipCode = '60707' or zipCode = '60712' or zipCode = '60714' or zipCode = '60803' or zipCode = '60804' or zipCode = '60805' or zipCode = '60827') order by smartSort desc;
Favorites:select top 999 *, cast(tax_value as float)/cast(price as float) as tax_ratio from tblBothNew, tblFavHappy where tblFavHappy.propertyid = tblBothNew.propertyid and len(email_id) > 2 and email_id = '' order by tblFavHappy.dateadded desc;: End Fav
Combined:SELECT top 999 '' as mailingState, '' as ownerCellPhone, '' as ownerMainPhone, '' as ownerFirst, '' as ownerLast, '' as mailingAddress, '' as mailingCity, '' as mailingZip, realtor_value as melissa_value, ((5000000/price)/2 + score) as beSmart, cast(tax_value as float)/cast(price as float) as tax_ratio, lat, lat as latitude, lng, lng as longitude, keywordType, PropertyId, DetailsURL,City, State, SquareFeet, Address, Price ,PropertyType, AgentName, AgentAddress, AgentPhone, AgentEmail, PhotoUrl1 ,zipCode, PhotoURL2 , PhotoURL3, Source, DatePosted ,Bedrooms ,Baths ,Type ,YearBuilt ,ListDate ,FHA ,Priority, AsIsValue, Condition, Eligible, Status, Escrow ,deadline ,PhotoURLNo ,DeadlineDate,randomNum ,photoURL4, photoURL5, photoURL6, photoURL8, photoURL9, photoURL10, photoURL11, photoURL12, Original_Price ,Price2 ,zillowThinks, zillowThinks2,A_Value ,statusIs, lastChecked ,Tax_Value ,Avg_Value ,eApp_Value ,theType ,Comments ,yearBuilt2 ,realtor_value ,photoURL13, photoURL14, photoURL15, photoURL16, photoURL17, photoURL18, photoURL19, photoURL20, photoURL22, photoURL24, tbl_source ,price_changed_on ,current_flag ,bigChange ,Realtor_Value_Date,id ,good_view_version ,Quality,Score ,photoURL36, photoURL37, daysOnMarket ,theType2 ,keywordType2 ,smartSort ,tax_value_backup ,realtor_value_backup ,scoreAdjusted ,scoreNew ,scoreOrigBackup ,scoreOrigBackedUp ,coll_value ,core_value ,quant_value ,keywordString ,scoreCount ,phpCrawlDataClean ,trentStateDataClean ,theTypeCorrect ,scoreCorrect ,keywordTypeCorrect ,realtor_value_SOURCE ,bestStrategy ,dataclean FROM tblBothNew NOLOCK where len(theType) > 1 and 1=1 and (1=1) and price >= 0 and price <= 499999 and 11=11 and (zipCode ='46312' or zipCode = '46320' or zipCode = '46321' or zipCode = '46321' or zipCode = '46323' or zipCode = '46323' or zipCode = '46324' or zipCode = '46324' or zipCode = '46325' or zipCode = '46327' or zipCode = '46394' or zipCode = '46394' or zipCode = '46401' or zipCode = '46402' or zipCode = '46404' or zipCode = '46406' or zipCode = '46406' or zipCode = '46411' or zipCode = '46411' or zipCode = '60004' or zipCode = '60004' or zipCode = '60005' or zipCode = '60005' or zipCode = '60006' or zipCode = '60006' or zipCode = '60007' or zipCode = '60007' or zipCode = '60008' or zipCode = '60008' or zipCode = '60009' or zipCode = '60009' or zipCode = '60015' or zipCode = '60016' or zipCode = '60017' or zipCode = '60018' or zipCode = '60018' or zipCode = '60019' or zipCode = '60019' or zipCode = '60019' or zipCode = '60022' or zipCode = '60025' or zipCode = '60026' or zipCode = '60029' or zipCode = '60068' or zipCode = '60070' or zipCode = '60070' or zipCode = '60015' or zipCode = '60015' or zipCode = '60035' or zipCode = '60037' or zipCode = '60037' or zipCode = '60040' or zipCode = '60043' or zipCode = '60053' or zipCode = '60056' or zipCode = '60056' or zipCode = '60062' or zipCode = '60065' or zipCode = '60076' or zipCode = '60077' or zipCode = '60082' or zipCode = '60104' or zipCode = '60105' or zipCode = '60105' or zipCode = '60106' or zipCode = '60108' or zipCode = '60117' or zipCode = '60117' or zipCode = '60137' or zipCode = '60137' or zipCode = '60137' or zipCode = '60138' or zipCode = '60139' or zipCode = '60139' or zipCode = '60141' or zipCode = '60143' or zipCode = '60148' or zipCode = '60148' or zipCode = '60153' or zipCode = '60153' or zipCode = '60154' or zipCode = '60155' or zipCode = '60155' or zipCode = '60157' or zipCode = '60160' or zipCode = '60161' or zipCode = '60162' or zipCode = '60163' or zipCode = '60163' or zipCode = '60163' or zipCode = '60164' or zipCode = '60164' or zipCode = '60165' or zipCode = '60165' or zipCode = '60171' or zipCode = '60173' or zipCode = '60173' or zipCode = '60173' or zipCode = '60176' or zipCode = '60090' or zipCode = '60091' or zipCode = '60093' or zipCode = '60093' or zipCode = '60093' or zipCode = '60101' or zipCode = '60126' or zipCode = '60130' or zipCode = '60131' or zipCode = '60131' or zipCode = '60181' or zipCode = '60181' or zipCode = '60181' or zipCode = '60189' or zipCode = '60191' or zipCode = '60399' or zipCode = '60399' or zipCode = '60402' or zipCode = '60402' or zipCode = '60402' or zipCode = '60406' or zipCode = '60406' or zipCode = '60409' or zipCode = '60415' or zipCode = '60419' or zipCode = '60422' or zipCode = '60422' or zipCode = '60425' or zipCode = '60426' or zipCode = '60426' or zipCode = '60445' or zipCode = '60445' or zipCode = '60452' or zipCode = '60453' or zipCode = '60454' or zipCode = '60455' or zipCode = '60455' or zipCode = '60455' or zipCode = '60456' or zipCode = '60456' or zipCode = '60457' or zipCode = '60476' or zipCode = '60477' or zipCode = '60477' or zipCode = '60478' or zipCode = '60478' or zipCode = '60478' or zipCode = '60478' or zipCode = '60480' or zipCode = '60480' or zipCode = '60482' or zipCode = '60487' or zipCode = '60487' or zipCode = '60513' or zipCode = '60514' or zipCode = '60514' or zipCode = '60515' or zipCode = '60516' or zipCode = '60517' or zipCode = '60517' or zipCode = '60521' or zipCode = '60521' or zipCode = '60521' or zipCode = '60521' or zipCode = '60522' or zipCode = '60522' or zipCode = '60523' or zipCode = '60523' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60196' or zipCode = '60196' or zipCode = '60196' or zipCode = '60196' or zipCode = '60199' or zipCode = '60199' or zipCode = '60201' or zipCode = '60202' or zipCode = '60203' or zipCode = '60204' or zipCode = '60208' or zipCode = '60208' or zipCode = '60209' or zipCode = '60209' or zipCode = '60290' or zipCode = '60290' or zipCode = '60301' or zipCode = '60302' or zipCode = '60303' or zipCode = '60304' or zipCode = '60305' or zipCode = '60399' or zipCode = '60426' or zipCode = '60426' or zipCode = '60428' or zipCode = '60428' or zipCode = '60429' or zipCode = '60429' or zipCode = '60430' or zipCode = '60438' or zipCode = '60439' or zipCode = '60439' or zipCode = '60457' or zipCode = '60458' or zipCode = '60458' or zipCode = '60458' or zipCode = '60459' or zipCode = '60459' or zipCode = '60459' or zipCode = '60462' or zipCode = '60463' or zipCode = '60464' or zipCode = '60465' or zipCode = '60467' or zipCode = '60469' or zipCode = '60472' or zipCode = '60473' or zipCode = '60499' or zipCode = '60499' or zipCode = '60499' or zipCode = '60499' or zipCode = '60501' or zipCode = '60501' or zipCode = '60501' or zipCode = '60501' or zipCode = '60501' or zipCode = '60501' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60526' or zipCode = '60526' or zipCode = '60526' or zipCode = '60527' or zipCode = '60527' or zipCode = '60527' or zipCode = '60527' or zipCode = '60532' or zipCode = '60534' or zipCode = '60546' or zipCode = '60546' or zipCode = '60546' or zipCode = '60558' or zipCode = '60558' or zipCode = '60559' or zipCode = '60561' or zipCode = '60561' or zipCode = '60599' or zipCode = '60599' or zipCode = '60599' or zipCode = '60601' or zipCode = '60602' or zipCode = '60603' or zipCode = '60604' or zipCode = '60605' or zipCode = '60606' or zipCode = '60607' or zipCode = '60608' or zipCode = '60608' or zipCode = '60609' or zipCode = '60609' or zipCode = '60610' or zipCode = '60610' or zipCode = '60610' or zipCode = '60611' or zipCode = '60611' or zipCode = '60611' or zipCode = '60612' or zipCode = '60612' or zipCode = '60613' or zipCode = '60613' or zipCode = '60614' or zipCode = '60614' or zipCode = '60615' or zipCode = '60615' or zipCode = '60616' or zipCode = '60616' or zipCode = '60617' or zipCode = '60617' or zipCode = '60618' or zipCode = '60618' or zipCode = '60619' or zipCode = '60619' or zipCode = '60620' or zipCode = '60621' or zipCode = '60621' or zipCode = '60622' or zipCode = '60622' or zipCode = '60633' or zipCode = '60633' or zipCode = '60634' or zipCode = '60634' or zipCode = '60634' or zipCode = '60634' or zipCode = '60636' or zipCode = '60636' or zipCode = '60637' or zipCode = '60637' or zipCode = '60638' or zipCode = '60638' or zipCode = '60638' or zipCode = '60638' or zipCode = '60638' or zipCode = '60639' or zipCode = '60639' or zipCode = '60640' or zipCode = '60641' or zipCode = '60642' or zipCode = '60642' or zipCode = '60643' or zipCode = '60643' or zipCode = '60643' or zipCode = '60655' or zipCode = '60656' or zipCode = '60656' or zipCode = '60656' or zipCode = '60656' or zipCode = '60657' or zipCode = '60657' or zipCode = '60659' or zipCode = '60659' or zipCode = '60659' or zipCode = '60660' or zipCode = '60660' or zipCode = '60661' or zipCode = '60664' or zipCode = '60664' or zipCode = '60666' or zipCode = '60666' or zipCode = '60668' or zipCode = '60668' or zipCode = '60669' or zipCode = '60669' or zipCode = '60670' or zipCode = '60670' or zipCode = '60670' or zipCode = '60688' or zipCode = '60689' or zipCode = '60689' or zipCode = '60690' or zipCode = '60691' or zipCode = '60693' or zipCode = '60693' or zipCode = '60694' or zipCode = '60694' or zipCode = '60695' or zipCode = '60695' or zipCode = '60696' or zipCode = '60696' or zipCode = '60696' or zipCode = '60697' or zipCode = '60697' or zipCode = '60699' or zipCode = '60699' or zipCode = '60701' or zipCode = '60706' or zipCode = '60706' or zipCode = '60706' or zipCode = '60706' or zipCode = '60623' or zipCode = '60623' or zipCode = '60624' or zipCode = '60624' or zipCode = '60625' or zipCode = '60625' or zipCode = '60626' or zipCode = '60626' or zipCode = '60628' or zipCode = '60628' or zipCode = '60629' or zipCode = '60629' or zipCode = '60629' or zipCode = '60629' or zipCode = '60630' or zipCode = '60630' or zipCode = '60630' or zipCode = '60630' or zipCode = '60630' or zipCode = '60631' or zipCode = '60631' or zipCode = '60632' or zipCode = '60632' or zipCode = '60633' or zipCode = '60644' or zipCode = '60644' or zipCode = '60645' or zipCode = '60645' or zipCode = '60645' or zipCode = '60646' or zipCode = '60646' or zipCode = '60647' or zipCode = '60647' or zipCode = '60649' or zipCode = '60649' or zipCode = '60651' or zipCode = '60651' or zipCode = '60652' or zipCode = '60652' or zipCode = '60653' or zipCode = '60653' or zipCode = '60654' or zipCode = '60654' or zipCode = '60655' or zipCode = '60655' or zipCode = '60655' or zipCode = '60655' or zipCode = '60673' or zipCode = '60673' or zipCode = '60673' or zipCode = '60674' or zipCode = '60674' or zipCode = '60675' or zipCode = '60675' or zipCode = '60677' or zipCode = '60677' or zipCode = '60678' or zipCode = '60678' or zipCode = '60680' or zipCode = '60681' or zipCode = '60682' or zipCode = '60682' or zipCode = '60684' or zipCode = '60684' or zipCode = '60685' or zipCode = '60685' or zipCode = '60686' or zipCode = '60686' or zipCode = '60687' or zipCode = '60687' or zipCode = '60688' or zipCode = '60707' or zipCode = '60707' or zipCode = '60712' or zipCode = '60712' or zipCode = '60712' or zipCode = '60712' or zipCode = '60714' or zipCode = '60803' or zipCode = '60803' or zipCode = '60803' or zipCode = '60803' or zipCode = '60804' or zipCode = '60804' or zipCode = '60805' or zipCode = '60805' or zipCode = '60805' or zipCode = '60827' or zipCode = '60827' or zipCode = '60827' or zipCode = '46312' or zipCode = '46320' or zipCode = '46321' or zipCode = '46322' or zipCode = '46323' or zipCode = '46324' or zipCode = '46327' or zipCode = '46394' or zipCode = '46402' or zipCode = '46404' or zipCode = '46406' or zipCode = '60004' or zipCode = '60005' or zipCode = '60006' or zipCode = '60007' or zipCode = '60008' or zipCode = '60009' or zipCode = '60015' or zipCode = '60016' or zipCode = '60017' or zipCode = '60018' or zipCode = '60019' or zipCode = '60022' or zipCode = '60025' or zipCode = '60026' or zipCode = '60029' or zipCode = '60035' or zipCode = '60037' or zipCode = '60038' or zipCode = '60040' or zipCode = '60043' or zipCode = '60053' or zipCode = '60055' or zipCode = '60056' or zipCode = '60062' or zipCode = '60065' or zipCode = '60068' or zipCode = '60070' or zipCode = '60076' or zipCode = '60077' or zipCode = '60078' or zipCode = '60082' or zipCode = '60090' or zipCode = '60091' or zipCode = '60093' or zipCode = '60094' or zipCode = '60095' or zipCode = '60101' or zipCode = '60104' or zipCode = '60105' or zipCode = '60106' or zipCode = '60108' or zipCode = '60114' or zipCode = '60116' or zipCode = '60117' or zipCode = '60125' or zipCode = '60126' or zipCode = '60128' or zipCode = '60130' or zipCode = '60131' or zipCode = '60132' or zipCode = '60137' or zipCode = '60138' or zipCode = '60139' or zipCode = '60141' or zipCode = '60143' or zipCode = '60148' or zipCode = '60153' or zipCode = '60154' or zipCode = '60155' or zipCode = '60157' or zipCode = '60159' or zipCode = '60160' or zipCode = '60161' or zipCode = '60162' or zipCode = '60163' or zipCode = '60164' or zipCode = '60165' or zipCode = '60168' or zipCode = '60171' or zipCode = '60172' or zipCode = '60173' or zipCode = '60176' or zipCode = '60181' or zipCode = '60186' or zipCode = '60189' or zipCode = '60191' or zipCode = '60197' or zipCode = '60198' or zipCode = '60199' or zipCode = '60201' or zipCode = '60202' or zipCode = '60203' or zipCode = '60204' or zipCode = '60208' or zipCode = '60209' or zipCode = '60301' or zipCode = '60302' or zipCode = '60303' or zipCode = '60304' or zipCode = '60305' or zipCode = '60330' or zipCode = '60402' or zipCode = '60406' or zipCode = '60409' or zipCode = '60412' or zipCode = '60415' or zipCode = '60419' or zipCode = '60422' or zipCode = '60425' or zipCode = '60426' or zipCode = '60429' or zipCode = '60430' or zipCode = '60438' or zipCode = '60439' or zipCode = '60445' or zipCode = '60452' or zipCode = '60453' or zipCode = '60454' or zipCode = '60455' or zipCode = '60456' or zipCode = '60457' or zipCode = '60458' or zipCode = '60459' or zipCode = '60462' or zipCode = '60463' or zipCode = '60464' or zipCode = '60465' or zipCode = '60467' or zipCode = '60469' or zipCode = '60472' or zipCode = '60473' or zipCode = '60476' or zipCode = '60477' or zipCode = '60478' or zipCode = '60480' or zipCode = '60482' or zipCode = '60499' or zipCode = '60501' or zipCode = '60513' or zipCode = '60514' or zipCode = '60515' or zipCode = '60516' or zipCode = '60517' or zipCode = '60521' or zipCode = '60522' or zipCode = '60523' or zipCode = '60525' or zipCode = '60526' or zipCode = '60527' or zipCode = '60532' or zipCode = '60534' or zipCode = '60546' or zipCode = '60558' or zipCode = '60559' or zipCode = '60561' or zipCode = '60566' or zipCode = '60567' or zipCode = '60570' or zipCode = '60572' or zipCode = '60597' or zipCode = '60598' or zipCode = '60599' or zipCode = '60601' or zipCode = '60602' or zipCode = '60603' or zipCode = '60604' or zipCode = '60605' or zipCode = '60606' or zipCode = '60607' or zipCode = '60608' or zipCode = '60609' or zipCode = '60610' or zipCode = '60611' or zipCode = '60612' or zipCode = '60613' or zipCode = '60614' or zipCode = '60615' or zipCode = '60616' or zipCode = '60617' or zipCode = '60618' or zipCode = '60619' or zipCode = '60620' or zipCode = '60621' or zipCode = '60622' or zipCode = '60623' or zipCode = '60624' or zipCode = '60625' or zipCode = '60626' or zipCode = '60628' or zipCode = '60629' or zipCode = '60630' or zipCode = '60631' or zipCode = '60632' or zipCode = '60633' or zipCode = '60634' or zipCode = '60636' or zipCode = '60637' or zipCode = '60638' or zipCode = '60639' or zipCode = '60640' or zipCode = '60641' or zipCode = '60643' or zipCode = '60644' or zipCode = '60645' or zipCode = '60646' or zipCode = '60647' or zipCode = '60649' or zipCode = '60650' or zipCode = '60651' or zipCode = '60652' or zipCode = '60653' or zipCode = '60654' or zipCode = '60655' or zipCode = '60656' or zipCode = '60657' or zipCode = '60659' or zipCode = '60660' or zipCode = '60661' or zipCode = '60663' or zipCode = '60664' or zipCode = '60665' or zipCode = '60666' or zipCode = '60667' or zipCode = '60668' or zipCode = '60669' or zipCode = '60670' or zipCode = '60671' or zipCode = '60672' or zipCode = '60673' or zipCode = '60674' or zipCode = '60675' or zipCode = '60677' or zipCode = '60678' or zipCode = '60679' or zipCode = '60680' or zipCode = '60681' or zipCode = '60683' or zipCode = '60684' or zipCode = '60685' or zipCode = '60687' or zipCode = '60690' or zipCode = '60691' or zipCode = '60692' or zipCode = '60693' or zipCode = '60694' or zipCode = '60697' or zipCode = '60699' or zipCode = '60701' or zipCode = '60706' or zipCode = '60707' or zipCode = '60712' or zipCode = '60714' or zipCode = '60803' or zipCode = '60804' or zipCode = '60805' or zipCode = '60827') UNION ALL SELECT top 999 mailingState, ownerCellPhone, ownerMainPhone, ownerFirst, ownerLast, mailingAddress, mailingCity, mailingZip, melissa_value, ((5000000/price)/2 + score) as beSmart, cast(tax_value as float)/cast(price as float) as tax_ratio, lat, lat as latitude, lng, lng as longitude, keywordType, PropertyId, DetailsURL,City, State, SquareFeet, Address, Price ,PropertyType, AgentName, AgentAddress, AgentPhone, AgentEmail, 'https://www.happyinvestor.com/noImage.jpg' as PhotoUrl1 ,zipCode, PhotoURL2 , PhotoURL3, Source, DatePosted ,Bedrooms ,Baths ,Type ,YearBuilt ,ListDate ,FHA ,Priority, AsIsValue, Condition, Eligible, Status, Escrow ,deadline ,PhotoURLNo ,DeadlineDate,randomNum ,photoURL4, photoURL5, photoURL6, photoURL8, photoURL9, photoURL10, photoURL11, photoURL12, Original_Price ,Price2 ,zillowThinks, zillowThinks2,A_Value ,statusIs, lastChecked ,Tax_Value ,Avg_Value ,eApp_Value ,theType ,Comments ,yearBuilt2 ,realtor_value ,photoURL13, photoURL14, photoURL15, photoURL16, photoURL17, photoURL18, photoURL19, photoURL20, photoURL22, photoURL24, tbl_source ,price_changed_on ,current_flag ,bigChange ,Realtor_Value_Date,id ,good_view_version ,Quality, Round( (((((((((len(ownerCellPhone)*1.3+len(ownerMainPhone)*.8) + (400000-melissa_value)/100000))/30*10 + 1) - 4) / 10 )) *10)+4.5) ,2,1) as score , photoURL36, photoURL37, daysOnMarket ,theType2 ,keywordType2 ,smartSort ,tax_value_backup ,realtor_value_backup ,scoreAdjusted ,scoreNew ,scoreOrigBackup ,scoreOrigBackedUp ,coll_value ,core_value ,quant_value ,keywordString ,scoreCount ,phpCrawlDataClean ,trentStateDataClean ,theTypeCorrect ,scoreCorrect ,keywordTypeCorrect ,realtor_value_SOURCE ,bestStrategy ,dataclean FROM tblBothMel where 1=1 and 1=1 and (1=1) and price >= 0 and price <= 499999 and 11=11 and (zipCode ='46312' or zipCode = '46320' or zipCode = '46321' or zipCode = '46321' or zipCode = '46323' or zipCode = '46323' or zipCode = '46324' or zipCode = '46324' or zipCode = '46325' or zipCode = '46327' or zipCode = '46394' or zipCode = '46394' or zipCode = '46401' or zipCode = '46402' or zipCode = '46404' or zipCode = '46406' or zipCode = '46406' or zipCode = '46411' or zipCode = '46411' or zipCode = '60004' or zipCode = '60004' or zipCode = '60005' or zipCode = '60005' or zipCode = '60006' or zipCode = '60006' or zipCode = '60007' or zipCode = '60007' or zipCode = '60008' or zipCode = '60008' or zipCode = '60009' or zipCode = '60009' or zipCode = '60015' or zipCode = '60016' or zipCode = '60017' or zipCode = '60018' or zipCode = '60018' or zipCode = '60019' or zipCode = '60019' or zipCode = '60019' or zipCode = '60022' or zipCode = '60025' or zipCode = '60026' or zipCode = '60029' or zipCode = '60068' or zipCode = '60070' or zipCode = '60070' or zipCode = '60015' or zipCode = '60015' or zipCode = '60035' or zipCode = '60037' or zipCode = '60037' or zipCode = '60040' or zipCode = '60043' or zipCode = '60053' or zipCode = '60056' or zipCode = '60056' or zipCode = '60062' or zipCode = '60065' or zipCode = '60076' or zipCode = '60077' or zipCode = '60082' or zipCode = '60104' or zipCode = '60105' or zipCode = '60105' or zipCode = '60106' or zipCode = '60108' or zipCode = '60117' or zipCode = '60117' or zipCode = '60137' or zipCode = '60137' or zipCode = '60137' or zipCode = '60138' or zipCode = '60139' or zipCode = '60139' or zipCode = '60141' or zipCode = '60143' or zipCode = '60148' or zipCode = '60148' or zipCode = '60153' or zipCode = '60153' or zipCode = '60154' or zipCode = '60155' or zipCode = '60155' or zipCode = '60157' or zipCode = '60160' or zipCode = '60161' or zipCode = '60162' or zipCode = '60163' or zipCode = '60163' or zipCode = '60163' or zipCode = '60164' or zipCode = '60164' or zipCode = '60165' or zipCode = '60165' or zipCode = '60171' or zipCode = '60173' or zipCode = '60173' or zipCode = '60173' or zipCode = '60176' or zipCode = '60090' or zipCode = '60091' or zipCode = '60093' or zipCode = '60093' or zipCode = '60093' or zipCode = '60101' or zipCode = '60126' or zipCode = '60130' or zipCode = '60131' or zipCode = '60131' or zipCode = '60181' or zipCode = '60181' or zipCode = '60181' or zipCode = '60189' or zipCode = '60191' or zipCode = '60399' or zipCode = '60399' or zipCode = '60402' or zipCode = '60402' or zipCode = '60402' or zipCode = '60406' or zipCode = '60406' or zipCode = '60409' or zipCode = '60415' or zipCode = '60419' or zipCode = '60422' or zipCode = '60422' or zipCode = '60425' or zipCode = '60426' or zipCode = '60426' or zipCode = '60445' or zipCode = '60445' or zipCode = '60452' or zipCode = '60453' or zipCode = '60454' or zipCode = '60455' or zipCode = '60455' or zipCode = '60455' or zipCode = '60456' or zipCode = '60456' or zipCode = '60457' or zipCode = '60476' or zipCode = '60477' or zipCode = '60477' or zipCode = '60478' or zipCode = '60478' or zipCode = '60478' or zipCode = '60478' or zipCode = '60480' or zipCode = '60480' or zipCode = '60482' or zipCode = '60487' or zipCode = '60487' or zipCode = '60513' or zipCode = '60514' or zipCode = '60514' or zipCode = '60515' or zipCode = '60516' or zipCode = '60517' or zipCode = '60517' or zipCode = '60521' or zipCode = '60521' or zipCode = '60521' or zipCode = '60521' or zipCode = '60522' or zipCode = '60522' or zipCode = '60523' or zipCode = '60523' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60196' or zipCode = '60196' or zipCode = '60196' or zipCode = '60196' or zipCode = '60199' or zipCode = '60199' or zipCode = '60201' or zipCode = '60202' or zipCode = '60203' or zipCode = '60204' or zipCode = '60208' or zipCode = '60208' or zipCode = '60209' or zipCode = '60209' or zipCode = '60290' or zipCode = '60290' or zipCode = '60301' or zipCode = '60302' or zipCode = '60303' or zipCode = '60304' or zipCode = '60305' or zipCode = '60399' or zipCode = '60426' or zipCode = '60426' or zipCode = '60428' or zipCode = '60428' or zipCode = '60429' or zipCode = '60429' or zipCode = '60430' or zipCode = '60438' or zipCode = '60439' or zipCode = '60439' or zipCode = '60457' or zipCode = '60458' or zipCode = '60458' or zipCode = '60458' or zipCode = '60459' or zipCode = '60459' or zipCode = '60459' or zipCode = '60462' or zipCode = '60463' or zipCode = '60464' or zipCode = '60465' or zipCode = '60467' or zipCode = '60469' or zipCode = '60472' or zipCode = '60473' or zipCode = '60499' or zipCode = '60499' or zipCode = '60499' or zipCode = '60499' or zipCode = '60501' or zipCode = '60501' or zipCode = '60501' or zipCode = '60501' or zipCode = '60501' or zipCode = '60501' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60526' or zipCode = '60526' or zipCode = '60526' or zipCode = '60527' or zipCode = '60527' or zipCode = '60527' or zipCode = '60527' or zipCode = '60532' or zipCode = '60534' or zipCode = '60546' or zipCode = '60546' or zipCode = '60546' or zipCode = '60558' or zipCode = '60558' or zipCode = '60559' or zipCode = '60561' or zipCode = '60561' or zipCode = '60599' or zipCode = '60599' or zipCode = '60599' or zipCode = '60601' or zipCode = '60602' or zipCode = '60603' or zipCode = '60604' or zipCode = '60605' or zipCode = '60606' or zipCode = '60607' or zipCode = '60608' or zipCode = '60608' or zipCode = '60609' or zipCode = '60609' or zipCode = '60610' or zipCode = '60610' or zipCode = '60610' or zipCode = '60611' or zipCode = '60611' or zipCode = '60611' or zipCode = '60612' or zipCode = '60612' or zipCode = '60613' or zipCode = '60613' or zipCode = '60614' or zipCode = '60614' or zipCode = '60615' or zipCode = '60615' or zipCode = '60616' or zipCode = '60616' or zipCode = '60617' or zipCode = '60617' or zipCode = '60618' or zipCode = '60618' or zipCode = '60619' or zipCode = '60619' or zipCode = '60620' or zipCode = '60621' or zipCode = '60621' or zipCode = '60622' or zipCode = '60622' or zipCode = '60633' or zipCode = '60633' or zipCode = '60634' or zipCode = '60634' or zipCode = '60634' or zipCode = '60634' or zipCode = '60636' or zipCode = '60636' or zipCode = '60637' or zipCode = '60637' or zipCode = '60638' or zipCode = '60638' or zipCode = '60638' or zipCode = '60638' or zipCode = '60638' or zipCode = '60639' or zipCode = '60639' or zipCode = '60640' or zipCode = '60641' or zipCode = '60642' or zipCode = '60642' or zipCode = '60643' or zipCode = '60643' or zipCode = '60643' or zipCode = '60655' or zipCode = '60656' or zipCode = '60656' or zipCode = '60656' or zipCode = '60656' or zipCode = '60657' or zipCode = '60657' or zipCode = '60659' or zipCode = '60659' or zipCode = '60659' or zipCode = '60660' or zipCode = '60660' or zipCode = '60661' or zipCode = '60664' or zipCode = '60664' or zipCode = '60666' or zipCode = '60666' or zipCode = '60668' or zipCode = '60668' or zipCode = '60669' or zipCode = '60669' or zipCode = '60670' or zipCode = '60670' or zipCode = '60670' or zipCode = '60688' or zipCode = '60689' or zipCode = '60689' or zipCode = '60690' or zipCode = '60691' or zipCode = '60693' or zipCode = '60693' or zipCode = '60694' or zipCode = '60694' or zipCode = '60695' or zipCode = '60695' or zipCode = '60696' or zipCode = '60696' or zipCode = '60696' or zipCode = '60697' or zipCode = '60697' or zipCode = '60699' or zipCode = '60699' or zipCode = '60701' or zipCode = '60706' or zipCode = '60706' or zipCode = '60706' or zipCode = '60706' or zipCode = '60623' or zipCode = '60623' or zipCode = '60624' or zipCode = '60624' or zipCode = '60625' or zipCode = '60625' or zipCode = '60626' or zipCode = '60626' or zipCode = '60628' or zipCode = '60628' or zipCode = '60629' or zipCode = '60629' or zipCode = '60629' or zipCode = '60629' or zipCode = '60630' or zipCode = '60630' or zipCode = '60630' or zipCode = '60630' or zipCode = '60630' or zipCode = '60631' or zipCode = '60631' or zipCode = '60632' or zipCode = '60632' or zipCode = '60633' or zipCode = '60644' or zipCode = '60644' or zipCode = '60645' or zipCode = '60645' or zipCode = '60645' or zipCode = '60646' or zipCode = '60646' or zipCode = '60647' or zipCode = '60647' or zipCode = '60649' or zipCode = '60649' or zipCode = '60651' or zipCode = '60651' or zipCode = '60652' or zipCode = '60652' or zipCode = '60653' or zipCode = '60653' or zipCode = '60654' or zipCode = '60654' or zipCode = '60655' or zipCode = '60655' or zipCode = '60655' or zipCode = '60655' or zipCode = '60673' or zipCode = '60673' or zipCode = '60673' or zipCode = '60674' or zipCode = '60674' or zipCode = '60675' or zipCode = '60675' or zipCode = '60677' or zipCode = '60677' or zipCode = '60678' or zipCode = '60678' or zipCode = '60680' or zipCode = '60681' or zipCode = '60682' or zipCode = '60682' or zipCode = '60684' or zipCode = '60684' or zipCode = '60685' or zipCode = '60685' or zipCode = '60686' or zipCode = '60686' or zipCode = '60687' or zipCode = '60687' or zipCode = '60688' or zipCode = '60707' or zipCode = '60707' or zipCode = '60712' or zipCode = '60712' or zipCode = '60712' or zipCode = '60712' or zipCode = '60714' or zipCode = '60803' or zipCode = '60803' or zipCode = '60803' or zipCode = '60803' or zipCode = '60804' or zipCode = '60804' or zipCode = '60805' or zipCode = '60805' or zipCode = '60805' or zipCode = '60827' or zipCode = '60827' or zipCode = '60827' or zipCode = '46312' or zipCode = '46320' or zipCode = '46321' or zipCode = '46322' or zipCode = '46323' or zipCode = '46324' or zipCode = '46327' or zipCode = '46394' or zipCode = '46402' or zipCode = '46404' or zipCode = '46406' or zipCode = '60004' or zipCode = '60005' or zipCode = '60006' or zipCode = '60007' or zipCode = '60008' or zipCode = '60009' or zipCode = '60015' or zipCode = '60016' or zipCode = '60017' or zipCode = '60018' or zipCode = '60019' or zipCode = '60022' or zipCode = '60025' or zipCode = '60026' or zipCode = '60029' or zipCode = '60035' or zipCode = '60037' or zipCode = '60038' or zipCode = '60040' or zipCode = '60043' or zipCode = '60053' or zipCode = '60055' or zipCode = '60056' or zipCode = '60062' or zipCode = '60065' or zipCode = '60068' or zipCode = '60070' or zipCode = '60076' or zipCode = '60077' or zipCode = '60078' or zipCode = '60082' or zipCode = '60090' or zipCode = '60091' or zipCode = '60093' or zipCode = '60094' or zipCode = '60095' or zipCode = '60101' or zipCode = '60104' or zipCode = '60105' or zipCode = '60106' or zipCode = '60108' or zipCode = '60114' or zipCode = '60116' or zipCode = '60117' or zipCode = '60125' or zipCode = '60126' or zipCode = '60128' or zipCode = '60130' or zipCode = '60131' or zipCode = '60132' or zipCode = '60137' or zipCode = '60138' or zipCode = '60139' or zipCode = '60141' or zipCode = '60143' or zipCode = '60148' or zipCode = '60153' or zipCode = '60154' or zipCode = '60155' or zipCode = '60157' or zipCode = '60159' or zipCode = '60160' or zipCode = '60161' or zipCode = '60162' or zipCode = '60163' or zipCode = '60164' or zipCode = '60165' or zipCode = '60168' or zipCode = '60171' or zipCode = '60172' or zipCode = '60173' or zipCode = '60176' or zipCode = '60181' or zipCode = '60186' or zipCode = '60189' or zipCode = '60191' or zipCode = '60197' or zipCode = '60198' or zipCode = '60199' or zipCode = '60201' or zipCode = '60202' or zipCode = '60203' or zipCode = '60204' or zipCode = '60208' or zipCode = '60209' or zipCode = '60301' or zipCode = '60302' or zipCode = '60303' or zipCode = '60304' or zipCode = '60305' or zipCode = '60330' or zipCode = '60402' or zipCode = '60406' or zipCode = '60409' or zipCode = '60412' or zipCode = '60415' or zipCode = '60419' or zipCode = '60422' or zipCode = '60425' or zipCode = '60426' or zipCode = '60429' or zipCode = '60430' or zipCode = '60438' or zipCode = '60439' or zipCode = '60445' or zipCode = '60452' or zipCode = '60453' or zipCode = '60454' or zipCode = '60455' or zipCode = '60456' or zipCode = '60457' or zipCode = '60458' or zipCode = '60459' or zipCode = '60462' or zipCode = '60463' or zipCode = '60464' or zipCode = '60465' or zipCode = '60467' or zipCode = '60469' or zipCode = '60472' or zipCode = '60473' or zipCode = '60476' or zipCode = '60477' or zipCode = '60478' or zipCode = '60480' or zipCode = '60482' or zipCode = '60499' or zipCode = '60501' or zipCode = '60513' or zipCode = '60514' or zipCode = '60515' or zipCode = '60516' or zipCode = '60517' or zipCode = '60521' or zipCode = '60522' or zipCode = '60523' or zipCode = '60525' or zipCode = '60526' or zipCode = '60527' or zipCode = '60532' or zipCode = '60534' or zipCode = '60546' or zipCode = '60558' or zipCode = '60559' or zipCode = '60561' or zipCode = '60566' or zipCode = '60567' or zipCode = '60570' or zipCode = '60572' or zipCode = '60597' or zipCode = '60598' or zipCode = '60599' or zipCode = '60601' or zipCode = '60602' or zipCode = '60603' or zipCode = '60604' or zipCode = '60605' or zipCode = '60606' or zipCode = '60607' or zipCode = '60608' or zipCode = '60609' or zipCode = '60610' or zipCode = '60611' or zipCode = '60612' or zipCode = '60613' or zipCode = '60614' or zipCode = '60615' or zipCode = '60616' or zipCode = '60617' or zipCode = '60618' or zipCode = '60619' or zipCode = '60620' or zipCode = '60621' or zipCode = '60622' or zipCode = '60623' or zipCode = '60624' or zipCode = '60625' or zipCode = '60626' or zipCode = '60628' or zipCode = '60629' or zipCode = '60630' or zipCode = '60631' or zipCode = '60632' or zipCode = '60633' or zipCode = '60634' or zipCode = '60636' or zipCode = '60637' or zipCode = '60638' or zipCode = '60639' or zipCode = '60640' or zipCode = '60641' or zipCode = '60643' or zipCode = '60644' or zipCode = '60645' or zipCode = '60646' or zipCode = '60647' or zipCode = '60649' or zipCode = '60650' or zipCode = '60651' or zipCode = '60652' or zipCode = '60653' or zipCode = '60654' or zipCode = '60655' or zipCode = '60656' or zipCode = '60657' or zipCode = '60659' or zipCode = '60660' or zipCode = '60661' or zipCode = '60663' or zipCode = '60664' or zipCode = '60665' or zipCode = '60666' or zipCode = '60667' or zipCode = '60668' or zipCode = '60669' or zipCode = '60670' or zipCode = '60671' or zipCode = '60672' or zipCode = '60673' or zipCode = '60674' or zipCode = '60675' or zipCode = '60677' or zipCode = '60678' or zipCode = '60679' or zipCode = '60680' or zipCode = '60681' or zipCode = '60683' or zipCode = '60684' or zipCode = '60685' or zipCode = '60687' or zipCode = '60690' or zipCode = '60691' or zipCode = '60692' or zipCode = '60693' or zipCode = '60694' or zipCode = '60697' or zipCode = '60699' or zipCode = '60701' or zipCode = '60706' or zipCode = '60707' or zipCode = '60712' or zipCode = '60714' or zipCode = '60803' or zipCode = '60804' or zipCode = '60805' or zipCode = '60827') ORDER BY score desc;: End Combined
select top 240 * from tblBothNew NOLOCK where priority is null and price > 5000 and (1=1 or 1=1) and original_price is not null and (status='active' or status='for_sale' or status is null) and (propertyType !='land' or propertyType is null) and len(photoURL1) > 5 and dateposted >= '8/29/2021' and 1=1 and 1=1 and theType = 'Keyword' and keywordType != 'Investment Property' and price > 10000 and original_price > 10000 and (1=1) and price >= 0 and price <= 499999 and 11=11 and (zipCode ='46312' or zipCode = '46320' or zipCode = '46321' or zipCode = '46321' or zipCode = '46323' or zipCode = '46323' or zipCode = '46324' or zipCode = '46324' or zipCode = '46325' or zipCode = '46327' or zipCode = '46394' or zipCode = '46394' or zipCode = '46401' or zipCode = '46402' or zipCode = '46404' or zipCode = '46406' or zipCode = '46406' or zipCode = '46411' or zipCode = '46411' or zipCode = '60004' or zipCode = '60004' or zipCode = '60005' or zipCode = '60005' or zipCode = '60006' or zipCode = '60006' or zipCode = '60007' or zipCode = '60007' or zipCode = '60008' or zipCode = '60008' or zipCode = '60009' or zipCode = '60009' or zipCode = '60015' or zipCode = '60016' or zipCode = '60017' or zipCode = '60018' or zipCode = '60018' or zipCode = '60019' or zipCode = '60019' or zipCode = '60019' or zipCode = '60022' or zipCode = '60025' or zipCode = '60026' or zipCode = '60029' or zipCode = '60068' or zipCode = '60070' or zipCode = '60070' or zipCode = '60015' or zipCode = '60015' or zipCode = '60035' or zipCode = '60037' or zipCode = '60037' or zipCode = '60040' or zipCode = '60043' or zipCode = '60053' or zipCode = '60056' or zipCode = '60056' or zipCode = '60062' or zipCode = '60065' or zipCode = '60076' or zipCode = '60077' or zipCode = '60082' or zipCode = '60104' or zipCode = '60105' or zipCode = '60105' or zipCode = '60106' or zipCode = '60108' or zipCode = '60117' or zipCode = '60117' or zipCode = '60137' or zipCode = '60137' or zipCode = '60137' or zipCode = '60138' or zipCode = '60139' or zipCode = '60139' or zipCode = '60141' or zipCode = '60143' or zipCode = '60148' or zipCode = '60148' or zipCode = '60153' or zipCode = '60153' or zipCode = '60154' or zipCode = '60155' or zipCode = '60155' or zipCode = '60157' or zipCode = '60160' or zipCode = '60161' or zipCode = '60162' or zipCode = '60163' or zipCode = '60163' or zipCode = '60163' or zipCode = '60164' or zipCode = '60164' or zipCode = '60165' or zipCode = '60165' or zipCode = '60171' or zipCode = '60173' or zipCode = '60173' or zipCode = '60173' or zipCode = '60176' or zipCode = '60090' or zipCode = '60091' or zipCode = '60093' or zipCode = '60093' or zipCode = '60093' or zipCode = '60101' or zipCode = '60126' or zipCode = '60130' or zipCode = '60131' or zipCode = '60131' or zipCode = '60181' or zipCode = '60181' or zipCode = '60181' or zipCode = '60189' or zipCode = '60191' or zipCode = '60399' or zipCode = '60399' or zipCode = '60402' or zipCode = '60402' or zipCode = '60402' or zipCode = '60406' or zipCode = '60406' or zipCode = '60409' or zipCode = '60415' or zipCode = '60419' or zipCode = '60422' or zipCode = '60422' or zipCode = '60425' or zipCode = '60426' or zipCode = '60426' or zipCode = '60445' or zipCode = '60445' or zipCode = '60452' or zipCode = '60453' or zipCode = '60454' or zipCode = '60455' or zipCode = '60455' or zipCode = '60455' or zipCode = '60456' or zipCode = '60456' or zipCode = '60457' or zipCode = '60476' or zipCode = '60477' or zipCode = '60477' or zipCode = '60478' or zipCode = '60478' or zipCode = '60478' or zipCode = '60478' or zipCode = '60480' or zipCode = '60480' or zipCode = '60482' or zipCode = '60487' or zipCode = '60487' or zipCode = '60513' or zipCode = '60514' or zipCode = '60514' or zipCode = '60515' or zipCode = '60516' or zipCode = '60517' or zipCode = '60517' or zipCode = '60521' or zipCode = '60521' or zipCode = '60521' or zipCode = '60521' or zipCode = '60522' or zipCode = '60522' or zipCode = '60523' or zipCode = '60523' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60196' or zipCode = '60196' or zipCode = '60196' or zipCode = '60196' or zipCode = '60199' or zipCode = '60199' or zipCode = '60201' or zipCode = '60202' or zipCode = '60203' or zipCode = '60204' or zipCode = '60208' or zipCode = '60208' or zipCode = '60209' or zipCode = '60209' or zipCode = '60290' or zipCode = '60290' or zipCode = '60301' or zipCode = '60302' or zipCode = '60303' or zipCode = '60304' or zipCode = '60305' or zipCode = '60399' or zipCode = '60426' or zipCode = '60426' or zipCode = '60428' or zipCode = '60428' or zipCode = '60429' or zipCode = '60429' or zipCode = '60430' or zipCode = '60438' or zipCode = '60439' or zipCode = '60439' or zipCode = '60457' or zipCode = '60458' or zipCode = '60458' or zipCode = '60458' or zipCode = '60459' or zipCode = '60459' or zipCode = '60459' or zipCode = '60462' or zipCode = '60463' or zipCode = '60464' or zipCode = '60465' or zipCode = '60467' or zipCode = '60469' or zipCode = '60472' or zipCode = '60473' or zipCode = '60499' or zipCode = '60499' or zipCode = '60499' or zipCode = '60499' or zipCode = '60501' or zipCode = '60501' or zipCode = '60501' or zipCode = '60501' or zipCode = '60501' or zipCode = '60501' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60525' or zipCode = '60526' or zipCode = '60526' or zipCode = '60526' or zipCode = '60527' or zipCode = '60527' or zipCode = '60527' or zipCode = '60527' or zipCode = '60532' or zipCode = '60534' or zipCode = '60546' or zipCode = '60546' or zipCode = '60546' or zipCode = '60558' or zipCode = '60558' or zipCode = '60559' or zipCode = '60561' or zipCode = '60561' or zipCode = '60599' or zipCode = '60599' or zipCode = '60599' or zipCode = '60601' or zipCode = '60602' or zipCode = '60603' or zipCode = '60604' or zipCode = '60605' or zipCode = '60606' or zipCode = '60607' or zipCode = '60608' or zipCode = '60608' or zipCode = '60609' or zipCode = '60609' or zipCode = '60610' or zipCode = '60610' or zipCode = '60610' or zipCode = '60611' or zipCode = '60611' or zipCode = '60611' or zipCode = '60612' or zipCode = '60612' or zipCode = '60613' or zipCode = '60613' or zipCode = '60614' or zipCode = '60614' or zipCode = '60615' or zipCode = '60615' or zipCode = '60616' or zipCode = '60616' or zipCode = '60617' or zipCode = '60617' or zipCode = '60618' or zipCode = '60618' or zipCode = '60619' or zipCode = '60619' or zipCode = '60620' or zipCode = '60621' or zipCode = '60621' or zipCode = '60622' or zipCode = '60622' or zipCode = '60633' or zipCode = '60633' or zipCode = '60634' or zipCode = '60634' or zipCode = '60634' or zipCode = '60634' or zipCode = '60636' or zipCode = '60636' or zipCode = '60637' or zipCode = '60637' or zipCode = '60638' or zipCode = '60638' or zipCode = '60638' or zipCode = '60638' or zipCode = '60638' or zipCode = '60639' or zipCode = '60639' or zipCode = '60640' or zipCode = '60641' or zipCode = '60642' or zipCode = '60642' or zipCode = '60643' or zipCode = '60643' or zipCode = '60643' or zipCode = '60655' or zipCode = '60656' or zipCode = '60656' or zipCode = '60656' or zipCode = '60656' or zipCode = '60657' or zipCode = '60657' or zipCode = '60659' or zipCode = '60659' or zipCode = '60659' or zipCode = '60660' or zipCode = '60660' or zipCode = '60661' or zipCode = '60664' or zipCode = '60664' or zipCode = '60666' or zipCode = '60666' or zipCode = '60668' or zipCode = '60668' or zipCode = '60669' or zipCode = '60669' or zipCode = '60670' or zipCode = '60670' or zipCode = '60670' or zipCode = '60688' or zipCode = '60689' or zipCode = '60689' or zipCode = '60690' or zipCode = '60691' or zipCode = '60693' or zipCode = '60693' or zipCode = '60694' or zipCode = '60694' or zipCode = '60695' or zipCode = '60695' or zipCode = '60696' or zipCode = '60696' or zipCode = '60696' or zipCode = '60697' or zipCode = '60697' or zipCode = '60699' or zipCode = '60699' or zipCode = '60701' or zipCode = '60706' or zipCode = '60706' or zipCode = '60706' or zipCode = '60706' or zipCode = '60623' or zipCode = '60623' or zipCode = '60624' or zipCode = '60624' or zipCode = '60625' or zipCode = '60625' or zipCode = '60626' or zipCode = '60626' or zipCode = '60628' or zipCode = '60628' or zipCode = '60629' or zipCode = '60629' or zipCode = '60629' or zipCode = '60629' or zipCode = '60630' or zipCode = '60630' or zipCode = '60630' or zipCode = '60630' or zipCode = '60630' or zipCode = '60631' or zipCode = '60631' or zipCode = '60632' or zipCode = '60632' or zipCode = '60633' or zipCode = '60644' or zipCode = '60644' or zipCode = '60645' or zipCode = '60645' or zipCode = '60645' or zipCode = '60646' or zipCode = '60646' or zipCode = '60647' or zipCode = '60647' or zipCode = '60649' or zipCode = '60649' or zipCode = '60651' or zipCode = '60651' or zipCode = '60652' or zipCode = '60652' or zipCode = '60653' or zipCode = '60653' or zipCode = '60654' or zipCode = '60654' or zipCode = '60655' or zipCode = '60655' or zipCode = '60655' or zipCode = '60655' or zipCode = '60673' or zipCode = '60673' or zipCode = '60673' or zipCode = '60674' or zipCode = '60674' or zipCode = '60675' or zipCode = '60675' or zipCode = '60677' or zipCode = '60677' or zipCode = '60678' or zipCode = '60678' or zipCode = '60680' or zipCode = '60681' or zipCode = '60682' or zipCode = '60682' or zipCode = '60684' or zipCode = '60684' or zipCode = '60685' or zipCode = '60685' or zipCode = '60686' or zipCode = '60686' or zipCode = '60687' or zipCode = '60687' or zipCode = '60688' or zipCode = '60707' or zipCode = '60707' or zipCode = '60712' or zipCode = '60712' or zipCode = '60712' or zipCode = '60712' or zipCode = '60714' or zipCode = '60803' or zipCode = '60803' or zipCode = '60803' or zipCode = '60803' or zipCode = '60804' or zipCode = '60804' or zipCode = '60805' or zipCode = '60805' or zipCode = '60805' or zipCode = '60827' or zipCode = '60827' or zipCode = '60827' or zipCode = '46312' or zipCode = '46320' or zipCode = '46321' or zipCode = '46322' or zipCode = '46323' or zipCode = '46324' or zipCode = '46327' or zipCode = '46394' or zipCode = '46402' or zipCode = '46404' or zipCode = '46406' or zipCode = '60004' or zipCode = '60005' or zipCode = '60006' or zipCode = '60007' or zipCode = '60008' or zipCode = '60009' or zipCode = '60015' or zipCode = '60016' or zipCode = '60017' or zipCode = '60018' or zipCode = '60019' or zipCode = '60022' or zipCode = '60025' or zipCode = '60026' or zipCode = '60029' or zipCode = '60035' or zipCode = '60037' or zipCode = '60038' or zipCode = '60040' or zipCode = '60043' or zipCode = '60053' or zipCode = '60055' or zipCode = '60056' or zipCode = '60062' or zipCode = '60065' or zipCode = '60068' or zipCode = '60070' or zipCode = '60076' or zipCode = '60077' or zipCode = '60078' or zipCode = '60082' or zipCode = '60090' or zipCode = '60091' or zipCode = '60093' or zipCode = '60094' or zipCode = '60095' or zipCode = '60101' or zipCode = '60104' or zipCode = '60105' or zipCode = '60106' or zipCode = '60108' or zipCode = '60114' or zipCode = '60116' or zipCode = '60117' or zipCode = '60125' or zipCode = '60126' or zipCode = '60128' or zipCode = '60130' or zipCode = '60131' or zipCode = '60132' or zipCode = '60137' or zipCode = '60138' or zipCode = '60139' or zipCode = '60141' or zipCode = '60143' or zipCode = '60148' or zipCode = '60153' or zipCode = '60154' or zipCode = '60155' or zipCode = '60157' or zipCode = '60159' or zipCode = '60160' or zipCode = '60161' or zipCode = '60162' or zipCode = '60163' or zipCode = '60164' or zipCode = '60165' or zipCode = '60168' or zipCode = '60171' or zipCode = '60172' or zipCode = '60173' or zipCode = '60176' or zipCode = '60181' or zipCode = '60186' or zipCode = '60189' or zipCode = '60191' or zipCode = '60197' or zipCode = '60198' or zipCode = '60199' or zipCode = '60201' or zipCode = '60202' or zipCode = '60203' or zipCode = '60204' or zipCode = '60208' or zipCode = '60209' or zipCode = '60301' or zipCode = '60302' or zipCode = '60303' or zipCode = '60304' or zipCode = '60305' or zipCode = '60330' or zipCode = '60402' or zipCode = '60406' or zipCode = '60409' or zipCode = '60412' or zipCode = '60415' or zipCode = '60419' or zipCode = '60422' or zipCode = '60425' or zipCode = '60426' or zipCode = '60429' or zipCode = '60430' or zipCode = '60438' or zipCode = '60439' or zipCode = '60445' or zipCode = '60452' or zipCode = '60453' or zipCode = '60454' or zipCode = '60455' or zipCode = '60456' or zipCode = '60457' or zipCode = '60458' or zipCode = '60459' or zipCode = '60462' or zipCode = '60463' or zipCode = '60464' or zipCode = '60465' or zipCode = '60467' or zipCode = '60469' or zipCode = '60472' or zipCode = '60473' or zipCode = '60476' or zipCode = '60477' or zipCode = '60478' or zipCode = '60480' or zipCode = '60482' or zipCode = '60499' or zipCode = '60501' or zipCode = '60513' or zipCode = '60514' or zipCode = '60515' or zipCode = '60516' or zipCode = '60517' or zipCode = '60521' or zipCode = '60522' or zipCode = '60523' or zipCode = '60525' or zipCode = '60526' or zipCode = '60527' or zipCode = '60532' or zipCode = '60534' or zipCode = '60546' or zipCode = '60558' or zipCode = '60559' or zipCode = '60561' or zipCode = '60566' or zipCode = '60567' or zipCode = '60570' or zipCode = '60572' or zipCode = '60597' or zipCode = '60598' or zipCode = '60599' or zipCode = '60601' or zipCode = '60602' or zipCode = '60603' or zipCode = '60604' or zipCode = '60605' or zipCode = '60606' or zipCode = '60607' or zipCode = '60608' or zipCode = '60609' or zipCode = '60610' or zipCode = '60611' or zipCode = '60612' or zipCode = '60613' or zipCode = '60614' or zipCode = '60615' or zipCode = '60616' or zipCode = '60617' or zipCode = '60618' or zipCode = '60619' or zipCode = '60620' or zipCode = '60621' or zipCode = '60622' or zipCode = '60623' or zipCode = '60624' or zipCode = '60625' or zipCode = '60626' or zipCode = '60628' or zipCode = '60629' or zipCode = '60630' or zipCode = '60631' or zipCode = '60632' or zipCode = '60633' or zipCode = '60634' or zipCode = '60636' or zipCode = '60637' or zipCode = '60638' or zipCode = '60639' or zipCode = '60640' or zipCode = '60641' or zipCode = '60643' or zipCode = '60644' or zipCode = '60645' or zipCode = '60646' or zipCode = '60647' or zipCode = '60649' or zipCode = '60650' or zipCode = '60651' or zipCode = '60652' or zipCode = '60653' or zipCode = '60654' or zipCode = '60655' or zipCode = '60656' or zipCode = '60657' or zipCode = '60659' or zipCode = '60660' or zipCode = '60661' or zipCode = '60663' or zipCode = '60664' or zipCode = '60665' or zipCode = '60666' or zipCode = '60667' or zipCode = '60668' or zipCode = '60669' or zipCode = '60670' or zipCode = '60671' or zipCode = '60672' or zipCode = '60673' or zipCode = '60674' or zipCode = '60675' or zipCode = '60677' or zipCode = '60678' or zipCode = '60679' or zipCode = '60680' or zipCode = '60681' or zipCode = '60683' or zipCode = '60684' or zipCode = '60685' or zipCode = '60687' or zipCode = '60690' or zipCode = '60691' or zipCode = '60692' or zipCode = '60693' or zipCode = '60694' or zipCode = '60697' or zipCode = '60699' or zipCode = '60701' or zipCode = '60706' or zipCode = '60707' or zipCode = '60712' or zipCode = '60714' or zipCode = '60803' or zipCode = '60804' or zipCode = '60805' or zipCode = '60827') order by price;
select top 45 * from house NOLOCK where 1=1 and (1=1) and 1=1 and 1=1 and 11=11 and (property_zip ='46312' or property_zip = '46320' or property_zip = '46321' or property_zip = '46321' or property_zip = '46323' or property_zip = '46323' or property_zip = '46324' or property_zip = '46324' or property_zip = '46325' or property_zip = '46327' or property_zip = '46394' or property_zip = '46394' or property_zip = '46401' or property_zip = '46402' or property_zip = '46404' or property_zip = '46406' or property_zip = '46406' or property_zip = '46411' or property_zip = '46411' or property_zip = '60004' or property_zip = '60004' or property_zip = '60005' or property_zip = '60005' or property_zip = '60006' or property_zip = '60006' or property_zip = '60007' or property_zip = '60007' or property_zip = '60008' or property_zip = '60008' or property_zip = '60009' or property_zip = '60009' or property_zip = '60015' or property_zip = '60016' or property_zip = '60017' or property_zip = '60018' or property_zip = '60018' or property_zip = '60019' or property_zip = '60019' or property_zip = '60019' or property_zip = '60022' or property_zip = '60025' or property_zip = '60026' or property_zip = '60029' or property_zip = '60068' or property_zip = '60070' or property_zip = '60070' or property_zip = '60015' or property_zip = '60015' or property_zip = '60035' or property_zip = '60037' or property_zip = '60037' or property_zip = '60040' or property_zip = '60043' or property_zip = '60053' or property_zip = '60056' or property_zip = '60056' or property_zip = '60062' or property_zip = '60065' or property_zip = '60076' or property_zip = '60077' or property_zip = '60082' or property_zip = '60104' or property_zip = '60105' or property_zip = '60105' or property_zip = '60106' or property_zip = '60108' or property_zip = '60117' or property_zip = '60117' or property_zip = '60137' or property_zip = '60137' or property_zip = '60137' or property_zip = '60138' or property_zip = '60139' or property_zip = '60139' or property_zip = '60141' or property_zip = '60143' or property_zip = '60148' or property_zip = '60148' or property_zip = '60153' or property_zip = '60153' or property_zip = '60154' or property_zip = '60155' or property_zip = '60155' or property_zip = '60157' or property_zip = '60160' or property_zip = '60161' or property_zip = '60162' or property_zip = '60163' or property_zip = '60163' or property_zip = '60163' or property_zip = '60164' or property_zip = '60164' or property_zip = '60165' or property_zip = '60165' or property_zip = '60171' or property_zip = '60173' or property_zip = '60173' or property_zip = '60173' or property_zip = '60176' or property_zip = '60090' or property_zip = '60091' or property_zip = '60093' or property_zip = '60093' or property_zip = '60093' or property_zip = '60101' or property_zip = '60126' or property_zip = '60130' or property_zip = '60131' or property_zip = '60131' or property_zip = '60181' or property_zip = '60181' or property_zip = '60181' or property_zip = '60189' or property_zip = '60191' or property_zip = '60399' or property_zip = '60399' or property_zip = '60402' or property_zip = '60402' or property_zip = '60402' or property_zip = '60406' or property_zip = '60406' or property_zip = '60409' or property_zip = '60415' or property_zip = '60419' or property_zip = '60422' or property_zip = '60422' or property_zip = '60425' or property_zip = '60426' or property_zip = '60426' or property_zip = '60445' or property_zip = '60445' or property_zip = '60452' or property_zip = '60453' or property_zip = '60454' or property_zip = '60455' or property_zip = '60455' or property_zip = '60455' or property_zip = '60456' or property_zip = '60456' or property_zip = '60457' or property_zip = '60476' or property_zip = '60477' or property_zip = '60477' or property_zip = '60478' or property_zip = '60478' or property_zip = '60478' or property_zip = '60478' or property_zip = '60480' or property_zip = '60480' or property_zip = '60482' or property_zip = '60487' or property_zip = '60487' or property_zip = '60513' or property_zip = '60514' or property_zip = '60514' or property_zip = '60515' or property_zip = '60516' or property_zip = '60517' or property_zip = '60517' or property_zip = '60521' or property_zip = '60521' or property_zip = '60521' or property_zip = '60521' or property_zip = '60522' or property_zip = '60522' or property_zip = '60523' or property_zip = '60523' or property_zip = '60525' or property_zip = '60525' or property_zip = '60525' or property_zip = '60196' or property_zip = '60196' or property_zip = '60196' or property_zip = '60196' or property_zip = '60199' or property_zip = '60199' or property_zip = '60201' or property_zip = '60202' or property_zip = '60203' or property_zip = '60204' or property_zip = '60208' or property_zip = '60208' or property_zip = '60209' or property_zip = '60209' or property_zip = '60290' or property_zip = '60290' or property_zip = '60301' or property_zip = '60302' or property_zip = '60303' or property_zip = '60304' or property_zip = '60305' or property_zip = '60399' or property_zip = '60426' or property_zip = '60426' or property_zip = '60428' or property_zip = '60428' or property_zip = '60429' or property_zip = '60429' or property_zip = '60430' or property_zip = '60438' or property_zip = '60439' or property_zip = '60439' or property_zip = '60457' or property_zip = '60458' or property_zip = '60458' or property_zip = '60458' or property_zip = '60459' or property_zip = '60459' or property_zip = '60459' or property_zip = '60462' or property_zip = '60463' or property_zip = '60464' or property_zip = '60465' or property_zip = '60467' or property_zip = '60469' or property_zip = '60472' or property_zip = '60473' or property_zip = '60499' or property_zip = '60499' or property_zip = '60499' or property_zip = '60499' or property_zip = '60501' or property_zip = '60501' or property_zip = '60501' or property_zip = '60501' or property_zip = '60501' or property_zip = '60501' or property_zip = '60525' or property_zip = '60525' or property_zip = '60525' or property_zip = '60525' or property_zip = '60525' or property_zip = '60525' or property_zip = '60525' or property_zip = '60525' or property_zip = '60525' or property_zip = '60525' or property_zip = '60525' or property_zip = '60526' or property_zip = '60526' or property_zip = '60526' or property_zip = '60527' or property_zip = '60527' or property_zip = '60527' or property_zip = '60527' or property_zip = '60532' or property_zip = '60534' or property_zip = '60546' or property_zip = '60546' or property_zip = '60546' or property_zip = '60558' or property_zip = '60558' or property_zip = '60559' or property_zip = '60561' or property_zip = '60561' or property_zip = '60599' or property_zip = '60599' or property_zip = '60599' or property_zip = '60601' or property_zip = '60602' or property_zip = '60603' or property_zip = '60604' or property_zip = '60605' or property_zip = '60606' or property_zip = '60607' or property_zip = '60608' or property_zip = '60608' or property_zip = '60609' or property_zip = '60609' or property_zip = '60610' or property_zip = '60610' or property_zip = '60610' or property_zip = '60611' or property_zip = '60611' or property_zip = '60611' or property_zip = '60612' or property_zip = '60612' or property_zip = '60613' or property_zip = '60613' or property_zip = '60614' or property_zip = '60614' or property_zip = '60615' or property_zip = '60615' or property_zip = '60616' or property_zip = '60616' or property_zip = '60617' or property_zip = '60617' or property_zip = '60618' or property_zip = '60618' or property_zip = '60619' or property_zip = '60619' or property_zip = '60620' or property_zip = '60621' or property_zip = '60621' or property_zip = '60622' or property_zip = '60622' or property_zip = '60633' or property_zip = '60633' or property_zip = '60634' or property_zip = '60634' or property_zip = '60634' or property_zip = '60634' or property_zip = '60636' or property_zip = '60636' or property_zip = '60637' or property_zip = '60637' or property_zip = '60638' or property_zip = '60638' or property_zip = '60638' or property_zip = '60638' or property_zip = '60638' or property_zip = '60639' or property_zip = '60639' or property_zip = '60640' or property_zip = '60641' or property_zip = '60642' or property_zip = '60642' or property_zip = '60643' or property_zip = '60643' or property_zip = '60643' or property_zip = '60655' or property_zip = '60656' or property_zip = '60656' or property_zip = '60656' or property_zip = '60656' or property_zip = '60657' or property_zip = '60657' or property_zip = '60659' or property_zip = '60659' or property_zip = '60659' or property_zip = '60660' or property_zip = '60660' or property_zip = '60661' or property_zip = '60664' or property_zip = '60664' or property_zip = '60666' or property_zip = '60666' or property_zip = '60668' or property_zip = '60668' or property_zip = '60669' or property_zip = '60669' or property_zip = '60670' or property_zip = '60670' or property_zip = '60670' or property_zip = '60688' or property_zip = '60689' or property_zip = '60689' or property_zip = '60690' or property_zip = '60691' or property_zip = '60693' or property_zip = '60693' or property_zip = '60694' or property_zip = '60694' or property_zip = '60695' or property_zip = '60695' or property_zip = '60696' or property_zip = '60696' or property_zip = '60696' or property_zip = '60697' or property_zip = '60697' or property_zip = '60699' or property_zip = '60699' or property_zip = '60701' or property_zip = '60706' or property_zip = '60706' or property_zip = '60706' or property_zip = '60706' or property_zip = '60623' or property_zip = '60623' or property_zip = '60624' or property_zip = '60624' or property_zip = '60625' or property_zip = '60625' or property_zip = '60626' or property_zip = '60626' or property_zip = '60628' or property_zip = '60628' or property_zip = '60629' or property_zip = '60629' or property_zip = '60629' or property_zip = '60629' or property_zip = '60630' or property_zip = '60630' or property_zip = '60630' or property_zip = '60630' or property_zip = '60630' or property_zip = '60631' or property_zip = '60631' or property_zip = '60632' or property_zip = '60632' or property_zip = '60633' or property_zip = '60644' or property_zip = '60644' or property_zip = '60645' or property_zip = '60645' or property_zip = '60645' or property_zip = '60646' or property_zip = '60646' or property_zip = '60647' or property_zip = '60647' or property_zip = '60649' or property_zip = '60649' or property_zip = '60651' or property_zip = '60651' or property_zip = '60652' or property_zip = '60652' or property_zip = '60653' or property_zip = '60653' or property_zip = '60654' or property_zip = '60654' or property_zip = '60655' or property_zip = '60655' or property_zip = '60655' or property_zip = '60655' or property_zip = '60673' or property_zip = '60673' or property_zip = '60673' or property_zip = '60674' or property_zip = '60674' or property_zip = '60675' or property_zip = '60675' or property_zip = '60677' or property_zip = '60677' or property_zip = '60678' or property_zip = '60678' or property_zip = '60680' or property_zip = '60681' or property_zip = '60682' or property_zip = '60682' or property_zip = '60684' or property_zip = '60684' or property_zip = '60685' or property_zip = '60685' or property_zip = '60686' or property_zip = '60686' or property_zip = '60687' or property_zip = '60687' or property_zip = '60688' or property_zip = '60707' or property_zip = '60707' or property_zip = '60712' or property_zip = '60712' or property_zip = '60712' or property_zip = '60712' or property_zip = '60714' or property_zip = '60803' or property_zip = '60803' or property_zip = '60803' or property_zip = '60803' or property_zip = '60804' or property_zip = '60804' or property_zip = '60805' or property_zip = '60805' or property_zip = '60805' or property_zip = '60827' or property_zip = '60827' or property_zip = '60827' or property_zip = '46312' or property_zip = '46320' or property_zip = '46321' or property_zip = '46322' or property_zip = '46323' or property_zip = '46324' or property_zip = '46327' or property_zip = '46394' or property_zip = '46402' or property_zip = '46404' or property_zip = '46406' or property_zip = '60004' or property_zip = '60005' or property_zip = '60006' or property_zip = '60007' or property_zip = '60008' or property_zip = '60009' or property_zip = '60015' or property_zip = '60016' or property_zip = '60017' or property_zip = '60018' or property_zip = '60019' or property_zip = '60022' or property_zip = '60025' or property_zip = '60026' or property_zip = '60029' or property_zip = '60035' or property_zip = '60037' or property_zip = '60038' or property_zip = '60040' or property_zip = '60043' or property_zip = '60053' or property_zip = '60055' or property_zip = '60056' or property_zip = '60062' or property_zip = '60065' or property_zip = '60068' or property_zip = '60070' or property_zip = '60076' or property_zip = '60077' or property_zip = '60078' or property_zip = '60082' or property_zip = '60090' or property_zip = '60091' or property_zip = '60093' or property_zip = '60094' or property_zip = '60095' or property_zip = '60101' or property_zip = '60104' or property_zip = '60105' or property_zip = '60106' or property_zip = '60108' or property_zip = '60114' or property_zip = '60116' or property_zip = '60117' or property_zip = '60125' or property_zip = '60126' or property_zip = '60128' or property_zip = '60130' or property_zip = '60131' or property_zip = '60132' or property_zip = '60137' or property_zip = '60138' or property_zip = '60139' or property_zip = '60141' or property_zip = '60143' or property_zip = '60148' or property_zip = '60153' or property_zip = '60154' or property_zip = '60155' or property_zip = '60157' or property_zip = '60159' or property_zip = '60160' or property_zip = '60161' or property_zip = '60162' or property_zip = '60163' or property_zip = '60164' or property_zip = '60165' or property_zip = '60168' or property_zip = '60171' or property_zip = '60172' or property_zip = '60173' or property_zip = '60176' or property_zip = '60181' or property_zip = '60186' or property_zip = '60189' or property_zip = '60191' or property_zip = '60197' or property_zip = '60198' or property_zip = '60199' or property_zip = '60201' or property_zip = '60202' or property_zip = '60203' or property_zip = '60204' or property_zip = '60208' or property_zip = '60209' or property_zip = '60301' or property_zip = '60302' or property_zip = '60303' or property_zip = '60304' or property_zip = '60305' or property_zip = '60330' or property_zip = '60402' or property_zip = '60406' or property_zip = '60409' or property_zip = '60412' or property_zip = '60415' or property_zip = '60419' or property_zip = '60422' or property_zip = '60425' or property_zip = '60426' or property_zip = '60429' or property_zip = '60430' or property_zip = '60438' or property_zip = '60439' or property_zip = '60445' or property_zip = '60452' or property_zip = '60453' or property_zip = '60454' or property_zip = '60455' or property_zip = '60456' or property_zip = '60457' or property_zip = '60458' or property_zip = '60459' or property_zip = '60462' or property_zip = '60463' or property_zip = '60464' or property_zip = '60465' or property_zip = '60467' or property_zip = '60469' or property_zip = '60472' or property_zip = '60473' or property_zip = '60476' or property_zip = '60477' or property_zip = '60478' or property_zip = '60480' or property_zip = '60482' or property_zip = '60499' or property_zip = '60501' or property_zip = '60513' or property_zip = '60514' or property_zip = '60515' or property_zip = '60516' or property_zip = '60517' or property_zip = '60521' or property_zip = '60522' or property_zip = '60523' or property_zip = '60525' or property_zip = '60526' or property_zip = '60527' or property_zip = '60532' or property_zip = '60534' or property_zip = '60546' or property_zip = '60558' or property_zip = '60559' or property_zip = '60561' or property_zip = '60566' or property_zip = '60567' or property_zip = '60570' or property_zip = '60572' or property_zip = '60597' or property_zip = '60598' or property_zip = '60599' or property_zip = '60601' or property_zip = '60602' or property_zip = '60603' or property_zip = '60604' or property_zip = '60605' or property_zip = '60606' or property_zip = '60607' or property_zip = '60608' or property_zip = '60609' or property_zip = '60610' or property_zip = '60611' or property_zip = '60612' or property_zip = '60613' or property_zip = '60614' or property_zip = '60615' or property_zip = '60616' or property_zip = '60617' or property_zip = '60618' or property_zip = '60619' or property_zip = '60620' or property_zip = '60621' or property_zip = '60622' or property_zip = '60623' or property_zip = '60624' or property_zip = '60625' or property_zip = '60626' or property_zip = '60628' or property_zip = '60629' or property_zip = '60630' or property_zip = '60631' or property_zip = '60632' or property_zip = '60633' or property_zip = '60634' or property_zip = '60636' or property_zip = '60637' or property_zip = '60638' or property_zip = '60639' or property_zip = '60640' or property_zip = '60641' or property_zip = '60643' or property_zip = '60644' or property_zip = '60645' or property_zip = '60646' or property_zip = '60647' or property_zip = '60649' or property_zip = '60650' or property_zip = '60651' or property_zip = '60652' or property_zip = '60653' or property_zip = '60654' or property_zip = '60655' or property_zip = '60656' or property_zip = '60657' or property_zip = '60659' or property_zip = '60660' or property_zip = '60661' or property_zip = '60663' or property_zip = '60664' or property_zip = '60665' or property_zip = '60666' or property_zip = '60667' or property_zip = '60668' or property_zip = '60669' or property_zip = '60670' or property_zip = '60671' or property_zip = '60672' or property_zip = '60673' or property_zip = '60674' or property_zip = '60675' or property_zip = '60677' or property_zip = '60678' or property_zip = '60679' or property_zip = '60680' or property_zip = '60681' or property_zip = '60683' or property_zip = '60684' or property_zip = '60685' or property_zip = '60687' or property_zip = '60690' or property_zip = '60691' or property_zip = '60692' or property_zip = '60693' or property_zip = '60694' or property_zip = '60697' or property_zip = '60699' or property_zip = '60701' or property_zip = '60706' or property_zip = '60707' or property_zip = '60712' or property_zip = '60714' or property_zip = '60803' or property_zip = '60804' or property_zip = '60805' or property_zip = '60827') and convert(date,auction_start_date) >= '9/27/2021';
select top 45 * from currentforeclosures.tblAll NOLOCK where state = 'IL '
select top 4500 * from currentforeclosures.tblAll NOLOCK where 1=2
select top 45 * from currentforeclosures.tblAll NOLOCK where len(PhotoURL1) > 2 and photoURL1 <> 'no_pic2.jpg';
select top 47 * from currentforeclosures.tblWholesaleDeals NOLOCK where len(image_name1) > 2 and image_name1 <> 'no_pic2.jpg' and date_posted >= '8/29/2021' and (1=1) and asking_price >= 0 and asking_price <= 499999 and 11=11 and (zip ='46312' or zip = '46320' or zip = '46321' or zip = '46321' or zip = '46323' or zip = '46323' or zip = '46324' or zip = '46324' or zip = '46325' or zip = '46327' or zip = '46394' or zip = '46394' or zip = '46401' or zip = '46402' or zip = '46404' or zip = '46406' or zip = '46406' or zip = '46411' or zip = '46411' or zip = '60004' or zip = '60004' or zip = '60005' or zip = '60005' or zip = '60006' or zip = '60006' or zip = '60007' or zip = '60007' or zip = '60008' or zip = '60008' or zip = '60009' or zip = '60009' or zip = '60015' or zip = '60016' or zip = '60017' or zip = '60018' or zip = '60018' or zip = '60019' or zip = '60019' or zip = '60019' or zip = '60022' or zip = '60025' or zip = '60026' or zip = '60029' or zip = '60068' or zip = '60070' or zip = '60070' or zip = '60015' or zip = '60015' or zip = '60035' or zip = '60037' or zip = '60037' or zip = '60040' or zip = '60043' or zip = '60053' or zip = '60056' or zip = '60056' or zip = '60062' or zip = '60065' or zip = '60076' or zip = '60077' or zip = '60082' or zip = '60104' or zip = '60105' or zip = '60105' or zip = '60106' or zip = '60108' or zip = '60117' or zip = '60117' or zip = '60137' or zip = '60137' or zip = '60137' or zip = '60138' or zip = '60139' or zip = '60139' or zip = '60141' or zip = '60143' or zip = '60148' or zip = '60148' or zip = '60153' or zip = '60153' or zip = '60154' or zip = '60155' or zip = '60155' or zip = '60157' or zip = '60160' or zip = '60161' or zip = '60162' or zip = '60163' or zip = '60163' or zip = '60163' or zip = '60164' or zip = '60164' or zip = '60165' or zip = '60165' or zip = '60171' or zip = '60173' or zip = '60173' or zip = '60173' or zip = '60176' or zip = '60090' or zip = '60091' or zip = '60093' or zip = '60093' or zip = '60093' or zip = '60101' or zip = '60126' or zip = '60130' or zip = '60131' or zip = '60131' or zip = '60181' or zip = '60181' or zip = '60181' or zip = '60189' or zip = '60191' or zip = '60399' or zip = '60399' or zip = '60402' or zip = '60402' or zip = '60402' or zip = '60406' or zip = '60406' or zip = '60409' or zip = '60415' or zip = '60419' or zip = '60422' or zip = '60422' or zip = '60425' or zip = '60426' or zip = '60426' or zip = '60445' or zip = '60445' or zip = '60452' or zip = '60453' or zip = '60454' or zip = '60455' or zip = '60455' or zip = '60455' or zip = '60456' or zip = '60456' or zip = '60457' or zip = '60476' or zip = '60477' or zip = '60477' or zip = '60478' or zip = '60478' or zip = '60478' or zip = '60478' or zip = '60480' or zip = '60480' or zip = '60482' or zip = '60487' or zip = '60487' or zip = '60513' or zip = '60514' or zip = '60514' or zip = '60515' or zip = '60516' or zip = '60517' or zip = '60517' or zip = '60521' or zip = '60521' or zip = '60521' or zip = '60521' or zip = '60522' or zip = '60522' or zip = '60523' or zip = '60523' or zip = '60525' or zip = '60525' or zip = '60525' or zip = '60196' or zip = '60196' or zip = '60196' or zip = '60196' or zip = '60199' or zip = '60199' or zip = '60201' or zip = '60202' or zip = '60203' or zip = '60204' or zip = '60208' or zip = '60208' or zip = '60209' or zip = '60209' or zip = '60290' or zip = '60290' or zip = '60301' or zip = '60302' or zip = '60303' or zip = '60304' or zip = '60305' or zip = '60399' or zip = '60426' or zip = '60426' or zip = '60428' or zip = '60428' or zip = '60429' or zip = '60429' or zip = '60430' or zip = '60438' or zip = '60439' or zip = '60439' or zip = '60457' or zip = '60458' or zip = '60458' or zip = '60458' or zip = '60459' or zip = '60459' or zip = '60459' or zip = '60462' or zip = '60463' or zip = '60464' or zip = '60465' or zip = '60467' or zip = '60469' or zip = '60472' or zip = '60473' or zip = '60499' or zip = '60499' or zip = '60499' or zip = '60499' or zip = '60501' or zip = '60501' or zip = '60501' or zip = '60501' or zip = '60501' or zip = '60501' or zip = '60525' or zip = '60525' or zip = '60525' or zip = '60525' or zip = '60525' or zip = '60525' or zip = '60525' or zip = '60525' or zip = '60525' or zip = '60525' or zip = '60525' or zip = '60526' or zip = '60526' or zip = '60526' or zip = '60527' or zip = '60527' or zip = '60527' or zip = '60527' or zip = '60532' or zip = '60534' or zip = '60546' or zip = '60546' or zip = '60546' or zip = '60558' or zip = '60558' or zip = '60559' or zip = '60561' or zip = '60561' or zip = '60599' or zip = '60599' or zip = '60599' or zip = '60601' or zip = '60602' or zip = '60603' or zip = '60604' or zip = '60605' or zip = '60606' or zip = '60607' or zip = '60608' or zip = '60608' or zip = '60609' or zip = '60609' or zip = '60610' or zip = '60610' or zip = '60610' or zip = '60611' or zip = '60611' or zip = '60611' or zip = '60612' or zip = '60612' or zip = '60613' or zip = '60613' or zip = '60614' or zip = '60614' or zip = '60615' or zip = '60615' or zip = '60616' or zip = '60616' or zip = '60617' or zip = '60617' or zip = '60618' or zip = '60618' or zip = '60619' or zip = '60619' or zip = '60620' or zip = '60621' or zip = '60621' or zip = '60622' or zip = '60622' or zip = '60633' or zip = '60633' or zip = '60634' or zip = '60634' or zip = '60634' or zip = '60634' or zip = '60636' or zip = '60636' or zip = '60637' or zip = '60637' or zip = '60638' or zip = '60638' or zip = '60638' or zip = '60638' or zip = '60638' or zip = '60639' or zip = '60639' or zip = '60640' or zip = '60641' or zip = '60642' or zip = '60642' or zip = '60643' or zip = '60643' or zip = '60643' or zip = '60655' or zip = '60656' or zip = '60656' or zip = '60656' or zip = '60656' or zip = '60657' or zip = '60657' or zip = '60659' or zip = '60659' or zip = '60659' or zip = '60660' or zip = '60660' or zip = '60661' or zip = '60664' or zip = '60664' or zip = '60666' or zip = '60666' or zip = '60668' or zip = '60668' or zip = '60669' or zip = '60669' or zip = '60670' or zip = '60670' or zip = '60670' or zip = '60688' or zip = '60689' or zip = '60689' or zip = '60690' or zip = '60691' or zip = '60693' or zip = '60693' or zip = '60694' or zip = '60694' or zip = '60695' or zip = '60695' or zip = '60696' or zip = '60696' or zip = '60696' or zip = '60697' or zip = '60697' or zip = '60699' or zip = '60699' or zip = '60701' or zip = '60706' or zip = '60706' or zip = '60706' or zip = '60706' or zip = '60623' or zip = '60623' or zip = '60624' or zip = '60624' or zip = '60625' or zip = '60625' or zip = '60626' or zip = '60626' or zip = '60628' or zip = '60628' or zip = '60629' or zip = '60629' or zip = '60629' or zip = '60629' or zip = '60630' or zip = '60630' or zip = '60630' or zip = '60630' or zip = '60630' or zip = '60631' or zip = '60631' or zip = '60632' or zip = '60632' or zip = '60633' or zip = '60644' or zip = '60644' or zip = '60645' or zip = '60645' or zip = '60645' or zip = '60646' or zip = '60646' or zip = '60647' or zip = '60647' or zip = '60649' or zip = '60649' or zip = '60651' or zip = '60651' or zip = '60652' or zip = '60652' or zip = '60653' or zip = '60653' or zip = '60654' or zip = '60654' or zip = '60655' or zip = '60655' or zip = '60655' or zip = '60655' or zip = '60673' or zip = '60673' or zip = '60673' or zip = '60674' or zip = '60674' or zip = '60675' or zip = '60675' or zip = '60677' or zip = '60677' or zip = '60678' or zip = '60678' or zip = '60680' or zip = '60681' or zip = '60682' or zip = '60682' or zip = '60684' or zip = '60684' or zip = '60685' or zip = '60685' or zip = '60686' or zip = '60686' or zip = '60687' or zip = '60687' or zip = '60688' or zip = '60707' or zip = '60707' or zip = '60712' or zip = '60712' or zip = '60712' or zip = '60712' or zip = '60714' or zip = '60803' or zip = '60803' or zip = '60803' or zip = '60803' or zip = '60804' or zip = '60804' or zip = '60805' or zip = '60805' or zip = '60805' or zip = '60827' or zip = '60827' or zip = '60827' or zip = '46312' or zip = '46320' or zip = '46321' or zip = '46322' or zip = '46323' or zip = '46324' or zip = '46327' or zip = '46394' or zip = '46402' or zip = '46404' or zip = '46406' or zip = '60004' or zip = '60005' or zip = '60006' or zip = '60007' or zip = '60008' or zip = '60009' or zip = '60015' or zip = '60016' or zip = '60017' or zip = '60018' or zip = '60019' or zip = '60022' or zip = '60025' or zip = '60026' or zip = '60029' or zip = '60035' or zip = '60037' or zip = '60038' or zip = '60040' or zip = '60043' or zip = '60053' or zip = '60055' or zip = '60056' or zip = '60062' or zip = '60065' or zip = '60068' or zip = '60070' or zip = '60076' or zip = '60077' or zip = '60078' or zip = '60082' or zip = '60090' or zip = '60091' or zip = '60093' or zip = '60094' or zip = '60095' or zip = '60101' or zip = '60104' or zip = '60105' or zip = '60106' or zip = '60108' or zip = '60114' or zip = '60116' or zip = '60117' or zip = '60125' or zip = '60126' or zip = '60128' or zip = '60130' or zip = '60131' or zip = '60132' or zip = '60137' or zip = '60138' or zip = '60139' or zip = '60141' or zip = '60143' or zip = '60148' or zip = '60153' or zip = '60154' or zip = '60155' or zip = '60157' or zip = '60159' or zip = '60160' or zip = '60161' or zip = '60162' or zip = '60163' or zip = '60164' or zip = '60165' or zip = '60168' or zip = '60171' or zip = '60172' or zip = '60173' or zip = '60176' or zip = '60181' or zip = '60186' or zip = '60189' or zip = '60191' or zip = '60197' or zip = '60198' or zip = '60199' or zip = '60201' or zip = '60202' or zip = '60203' or zip = '60204' or zip = '60208' or zip = '60209' or zip = '60301' or zip = '60302' or zip = '60303' or zip = '60304' or zip = '60305' or zip = '60330' or zip = '60402' or zip = '60406' or zip = '60409' or zip = '60412' or zip = '60415' or zip = '60419' or zip = '60422' or zip = '60425' or zip = '60426' or zip = '60429' or zip = '60430' or zip = '60438' or zip = '60439' or zip = '60445' or zip = '60452' or zip = '60453' or zip = '60454' or zip = '60455' or zip = '60456' or zip = '60457' or zip = '60458' or zip = '60459' or zip = '60462' or zip = '60463' or zip = '60464' or zip = '60465' or zip = '60467' or zip = '60469' or zip = '60472' or zip = '60473' or zip = '60476' or zip = '60477' or zip = '60478' or zip = '60480' or zip = '60482' or zip = '60499' or zip = '60501' or zip = '60513' or zip = '60514' or zip = '60515' or zip = '60516' or zip = '60517' or zip = '60521' or zip = '60522' or zip = '60523' or zip = '60525' or zip = '60526' or zip = '60527' or zip = '60532' or zip = '60534' or zip = '60546' or zip = '60558' or zip = '60559' or zip = '60561' or zip = '60566' or zip = '60567' or zip = '60570' or zip = '60572' or zip = '60597' or zip = '60598' or zip = '60599' or zip = '60601' or zip = '60602' or zip = '60603' or zip = '60604' or zip = '60605' or zip = '60606' or zip = '60607' or zip = '60608' or zip = '60609' or zip = '60610' or zip = '60611' or zip = '60612' or zip = '60613' or zip = '60614' or zip = '60615' or zip = '60616' or zip = '60617' or zip = '60618' or zip = '60619' or zip = '60620' or zip = '60621' or zip = '60622' or zip = '60623' or zip = '60624' or zip = '60625' or zip = '60626' or zip = '60628' or zip = '60629' or zip = '60630' or zip = '60631' or zip = '60632' or zip = '60633' or zip = '60634' or zip = '60636' or zip = '60637' or zip = '60638' or zip = '60639' or zip = '60640' or zip = '60641' or zip = '60643' or zip = '60644' or zip = '60645' or zip = '60646' or zip = '60647' or zip = '60649' or zip = '60650' or zip = '60651' or zip = '60652' or zip = '60653' or zip = '60654' or zip = '60655' or zip = '60656' or zip = '60657' or zip = '60659' or zip = '60660' or zip = '60661' or zip = '60663' or zip = '60664' or zip = '60665' or zip = '60666' or zip = '60667' or zip = '60668' or zip = '60669' or zip = '60670' or zip = '60671' or zip = '60672' or zip = '60673' or zip = '60674' or zip = '60675' or zip = '60677' or zip = '60678' or zip = '60679' or zip = '60680' or zip = '60681' or zip = '60683' or zip = '60684' or zip = '60685' or zip = '60687' or zip = '60690' or zip = '60691' or zip = '60692' or zip = '60693' or zip = '60694' or zip = '60697' or zip = '60699' or zip = '60701' or zip = '60706' or zip = '60707' or zip = '60712' or zip = '60714' or zip = '60803' or zip = '60804' or zip = '60805' or zip = '60827')
select top 45 * from currentforeclosures.tblWholesaleDeals NOLOCK where len(image_name1) > 2 and image_name1 <> 'no_pic2.jpg' and date_posted >= '12/2/2020' and 1=1 and state = 'IL' and city = 'CHICAGO' and state = 'IL ' and asking_price >= 0 and asking_price <= 499999
select top 45 * from currentforeclosures.tblWholesaleDeals NOLOCK where len(image_name1) > 2 and image_name1 <> 'no_pic2.jpg';
select top 45 * from tblLenders where email != '[email protected]' and lendertype = 'individual' and rate < 10 and len(phone) > 3 and budget > 45000 order by newID();