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


482+ High Potential Investor Deals Near st. louis [Refine]


********NOTICE: Displaying 99 of over 482 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 ='62024' or zipCode = '62024' or zipCode = '62025' or zipCode = '62025' or zipCode = '62025' or zipCode = '62026' or zipCode = '62026' or zipCode = '62028' or zipCode = '62028' or zipCode = '62002' or zipCode = '62010' or zipCode = '62010' or zipCode = '62018' or zipCode = '62034' or zipCode = '62035' or zipCode = '62040' or zipCode = '62040' or zipCode = '62040' or zipCode = '62048' or zipCode = '62059' or zipCode = '62059' or zipCode = '62059' or zipCode = '62060' or zipCode = '62060' or zipCode = '62060' or zipCode = '62060' or zipCode = '62061' or zipCode = '62062' or zipCode = '62084' or zipCode = '62087' or zipCode = '62090' or zipCode = '62095' or zipCode = '62201' or zipCode = '62201' or zipCode = '62201' or zipCode = '62201' or zipCode = '62201' or zipCode = '62201' or zipCode = '62202' or zipCode = '62202' or zipCode = '62202' or zipCode = '62203' or zipCode = '62203' or zipCode = '62203' or zipCode = '62203' or zipCode = '62204' or zipCode = '62204' or zipCode = '62204' or zipCode = '62205' or zipCode = '62205' or zipCode = '62205' or zipCode = '62205' or zipCode = '62205' or zipCode = '62205' or zipCode = '62206' or zipCode = '62206' or zipCode = '62206' or zipCode = '62206' or zipCode = '62207' or zipCode = '62207' or zipCode = '62207' or zipCode = '62207' or zipCode = '62208' or zipCode = '62208' or zipCode = '62208' or zipCode = '62208' or zipCode = '62232' or zipCode = '62232' or zipCode = '62232' or zipCode = '62234' or zipCode = '62234' or zipCode = '62234' or zipCode = '62236' or zipCode = '62239' or zipCode = '62240' or zipCode = '62240' or zipCode = '62240' or zipCode = '62067' or zipCode = '62071' or zipCode = '62071' or zipCode = '62071' or zipCode = '62220' or zipCode = '62220' or zipCode = '62221' or zipCode = '62221' or zipCode = '62221' or zipCode = '62221' or zipCode = '62222' or zipCode = '62223' or zipCode = '62223' or zipCode = '62223' or zipCode = '62225' or zipCode = '62225' or zipCode = '62225' or zipCode = '62226' or zipCode = '62226' or zipCode = '62243' or zipCode = '62254' or zipCode = '62269' or zipCode = '62269' or zipCode = '62269' or zipCode = '62281' or zipCode = '62285' or zipCode = '62289' or zipCode = '62294' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62260' or zipCode = '63006' or zipCode = '63010' or zipCode = '63011' or zipCode = '63011' or zipCode = '63011' or zipCode = '63011' or zipCode = '63011' or zipCode = '63011' or zipCode = '63017' or zipCode = '63017' or zipCode = '63017' or zipCode = '63017' or zipCode = '63021' or zipCode = '63021' or zipCode = '63021' or zipCode = '63021' or zipCode = '63021' or zipCode = '63021' or zipCode = '63021' or zipCode = '63022' or zipCode = '63024' or zipCode = '63025' or zipCode = '63025' or zipCode = '63025' or zipCode = '63040' or zipCode = '63042' or zipCode = '63042' or zipCode = '63042' or zipCode = '63043' or zipCode = '63043' or zipCode = '63043' or zipCode = '63044' or zipCode = '63044' or zipCode = '63044' or zipCode = '63045' or zipCode = '63045' or zipCode = '63045' or zipCode = '63049' or zipCode = '63052' or zipCode = '63052' or zipCode = '63052' or zipCode = '63052' or zipCode = '63074' or zipCode = '63074' or zipCode = '63074' or zipCode = '63074' or zipCode = '63074' or zipCode = '63088' or zipCode = '63088' or zipCode = '63088' or zipCode = '63025' or zipCode = '63025' or zipCode = '63026' or zipCode = '63026' or zipCode = '63031' or zipCode = '63031' or zipCode = '63032' or zipCode = '63033' or zipCode = '63033' or zipCode = '63034' or zipCode = '63040' or zipCode = '63040' or zipCode = '63040' or zipCode = '63052' or zipCode = '63053' or zipCode = '63053' or zipCode = '63057' or zipCode = '63099' or zipCode = '63099' or zipCode = '63101' or zipCode = '63102' or zipCode = '63103' or zipCode = '63104' or zipCode = '63105' or zipCode = '63105' or zipCode = '63105' or zipCode = '63106' or zipCode = '63107' or zipCode = '63108' or zipCode = '63109' or zipCode = '63110' or zipCode = '63111' or zipCode = '63112' or zipCode = '63112' or zipCode = '63113' or zipCode = '63113' or zipCode = '63114' or zipCode = '63114' or zipCode = '63114' or zipCode = '63121' or zipCode = '63121' or zipCode = '63121' or zipCode = '63121' or zipCode = '63121' or zipCode = '63121' or zipCode = '63121' or zipCode = '63122' or zipCode = '63122' or zipCode = '63122' or zipCode = '63122' or zipCode = '63122' or zipCode = '63122' or zipCode = '63123' or zipCode = '63123' or zipCode = '63124' or zipCode = '63124' or zipCode = '63124' or zipCode = '63124' or zipCode = '63125' or zipCode = '63125' or zipCode = '63125' or zipCode = '63125' or zipCode = '63126' or zipCode = '63126' or zipCode = '63126' or zipCode = '63127' or zipCode = '63127' or zipCode = '63127' or zipCode = '63128' or zipCode = '63128' or zipCode = '63129' or zipCode = '63129' or zipCode = '63129' or zipCode = '63130' or zipCode = '63130' or zipCode = '63130' or zipCode = '63130' or zipCode = '63130' or zipCode = '63131' or zipCode = '63131' or zipCode = '63131' or zipCode = '63131' or zipCode = '63131' or zipCode = '63131' or zipCode = '63132' or zipCode = '63132' or zipCode = '63132' or zipCode = '63133' or zipCode = '63133' or zipCode = '63133' or zipCode = '63133' or zipCode = '63133' or zipCode = '63134' or zipCode = '63134' or zipCode = '63134' or zipCode = '63134' or zipCode = '63135' or zipCode = '63135' or zipCode = '63135' or zipCode = '63135' or zipCode = '63135' or zipCode = '63135' or zipCode = '63136' or zipCode = '63136' or zipCode = '63136' or zipCode = '63136' or zipCode = '63136' or zipCode = '63136' or zipCode = '63114' or zipCode = '63114' or zipCode = '63114' or zipCode = '63114' or zipCode = '63115' or zipCode = '63116' or zipCode = '63117' or zipCode = '63117' or zipCode = '63117' or zipCode = '63118' or zipCode = '63119' or zipCode = '63119' or zipCode = '63119' or zipCode = '63119' or zipCode = '63119' or zipCode = '63120' or zipCode = '63120' or zipCode = '63120' or zipCode = '63121' or zipCode = '63121' or zipCode = '63121' or zipCode = '63121' or zipCode = '63136' or zipCode = '63137' or zipCode = '63137' or zipCode = '63137' or zipCode = '63137' or zipCode = '63137' or zipCode = '63138' or zipCode = '63138' or zipCode = '63138' or zipCode = '63139' or zipCode = '63140' or zipCode = '63140' or zipCode = '63140' or zipCode = '63141' or zipCode = '63141' or zipCode = '63143' or zipCode = '63143' or zipCode = '63144' or zipCode = '63144' or zipCode = '63145' or zipCode = '63145' or zipCode = '63145' or zipCode = '63145' or zipCode = '63146' or zipCode = '63146' or zipCode = '63147' or zipCode = '63150' or zipCode = '63150' or zipCode = '63151' or zipCode = '63155' or zipCode = '63156' or zipCode = '63157' or zipCode = '63158' or zipCode = '63160' or zipCode = '63160' or zipCode = '63163' or zipCode = '63164' or zipCode = '63164' or zipCode = '63166' or zipCode = '63167' or zipCode = '63167' or zipCode = '63169' or zipCode = '63171' or zipCode = '63171' or zipCode = '63301' or zipCode = '63301' or zipCode = '63301' or zipCode = '63301' or zipCode = '63302' or zipCode = '63303' or zipCode = '63303' or zipCode = '63303' or zipCode = '63303' or zipCode = '63373' or zipCode = '63177' or zipCode = '63178' or zipCode = '63179' or zipCode = '63180' or zipCode = '63180' or zipCode = '63182' or zipCode = '63182' or zipCode = '63188' or zipCode = '63190' or zipCode = '63190' or zipCode = '63195' or zipCode = '63195' or zipCode = '63195' or zipCode = '63197' or zipCode = '63197' or zipCode = '63198' or zipCode = '63198' or zipCode = '63199' or zipCode = '63199' or zipCode = '63301' or zipCode = '63301' or zipCode = '63301' or zipCode = '63373' or zipCode = '63373' or zipCode = '63373' or zipCode = '63386' or zipCode = '62002' or zipCode = '62010' or zipCode = '62018' or zipCode = '62024' or zipCode = '62025' or zipCode = '62026' or zipCode = '62028' or zipCode = '62034' or zipCode = '62035' or zipCode = '62040' or zipCode = '62048' or zipCode = '62059' or zipCode = '62060' or zipCode = '62062' or zipCode = '62067' or zipCode = '62071' or zipCode = '62084' or zipCode = '62087' or zipCode = '62090' or zipCode = '62095' or zipCode = '62201' or zipCode = '62202' or zipCode = '62203' or zipCode = '62204' or zipCode = '62205' or zipCode = '62206' or zipCode = '62207' or zipCode = '62208' or zipCode = '62220' or zipCode = '62221' or zipCode = '62222' or zipCode = '62223' or zipCode = '62224' or zipCode = '62225' or zipCode = '62226' or zipCode = '62232' or zipCode = '62234' or zipCode = '62236' or zipCode = '62239' or zipCode = '62240' or zipCode = '62243' or zipCode = '62254' or zipCode = '62256' or zipCode = '62258' or zipCode = '62260' or zipCode = '62269' or zipCode = '62281' or zipCode = '62285' or zipCode = '62289' or zipCode = '62294' or zipCode = '62295' or zipCode = '62298' or zipCode = '63001' or zipCode = '63005' or zipCode = '63006' or zipCode = '63010' or zipCode = '63011' or zipCode = '63012' or zipCode = '63017' or zipCode = '63021' or zipCode = '63022' or zipCode = '63024' or zipCode = '63025' or zipCode = '63026' or zipCode = '63031' or zipCode = '63032' or zipCode = '63033' or zipCode = '63034' or zipCode = '63040' or zipCode = '63042' or zipCode = '63043' or zipCode = '63044' or zipCode = '63045' or zipCode = '63049' or zipCode = '63052' or zipCode = '63057' or zipCode = '63074' or zipCode = '63088' or zipCode = '63099' or zipCode = '63101' or zipCode = '63102' or zipCode = '63103' or zipCode = '63104' or zipCode = '63105' or zipCode = '63106' or zipCode = '63107' or zipCode = '63108' or zipCode = '63109' or zipCode = '63110' or zipCode = '63111' or zipCode = '63112' or zipCode = '63113' or zipCode = '63114' or zipCode = '63115' or zipCode = '63116' or zipCode = '63117' or zipCode = '63118' or zipCode = '63119' or zipCode = '63120' or zipCode = '63121' or zipCode = '63122' or zipCode = '63123' or zipCode = '63124' or zipCode = '63125' or zipCode = '63126' or zipCode = '63127' or zipCode = '63128' or zipCode = '63129' or zipCode = '63130' or zipCode = '63131' or zipCode = '63132' or zipCode = '63133' or zipCode = '63134' or zipCode = '63135' or zipCode = '63136' or zipCode = '63137' or zipCode = '63138' or zipCode = '63139' or zipCode = '63140' or zipCode = '63141' or zipCode = '63143' or zipCode = '63144' or zipCode = '63145' or zipCode = '63146' or zipCode = '63147' or zipCode = '63150' or zipCode = '63151' or zipCode = '63153' or zipCode = '63155' or zipCode = '63156' or zipCode = '63157' or zipCode = '63158' or zipCode = '63160' or zipCode = '63163' or zipCode = '63164' or zipCode = '63166' or zipCode = '63167' or zipCode = '63169' or zipCode = '63171' or zipCode = '63177' or zipCode = '63178' or zipCode = '63179' or zipCode = '63180' or zipCode = '63182' or zipCode = '63188' or zipCode = '63195' or zipCode = '63196' or zipCode = '63197' or zipCode = '63198' or zipCode = '63199' or zipCode = '63301' or zipCode = '63303' or zipCode = '63338' or zipCode = '63346' or zipCode = '63373' or zipCode = '63386')
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 ='62024' or zipCode = '62024' or zipCode = '62025' or zipCode = '62025' or zipCode = '62025' or zipCode = '62026' or zipCode = '62026' or zipCode = '62028' or zipCode = '62028' or zipCode = '62002' or zipCode = '62010' or zipCode = '62010' or zipCode = '62018' or zipCode = '62034' or zipCode = '62035' or zipCode = '62040' or zipCode = '62040' or zipCode = '62040' or zipCode = '62048' or zipCode = '62059' or zipCode = '62059' or zipCode = '62059' or zipCode = '62060' or zipCode = '62060' or zipCode = '62060' or zipCode = '62060' or zipCode = '62061' or zipCode = '62062' or zipCode = '62084' or zipCode = '62087' or zipCode = '62090' or zipCode = '62095' or zipCode = '62201' or zipCode = '62201' or zipCode = '62201' or zipCode = '62201' or zipCode = '62201' or zipCode = '62201' or zipCode = '62202' or zipCode = '62202' or zipCode = '62202' or zipCode = '62203' or zipCode = '62203' or zipCode = '62203' or zipCode = '62203' or zipCode = '62204' or zipCode = '62204' or zipCode = '62204' or zipCode = '62205' or zipCode = '62205' or zipCode = '62205' or zipCode = '62205' or zipCode = '62205' or zipCode = '62205' or zipCode = '62206' or zipCode = '62206' or zipCode = '62206' or zipCode = '62206' or zipCode = '62207' or zipCode = '62207' or zipCode = '62207' or zipCode = '62207' or zipCode = '62208' or zipCode = '62208' or zipCode = '62208' or zipCode = '62208' or zipCode = '62232' or zipCode = '62232' or zipCode = '62232' or zipCode = '62234' or zipCode = '62234' or zipCode = '62234' or zipCode = '62236' or zipCode = '62239' or zipCode = '62240' or zipCode = '62240' or zipCode = '62240' or zipCode = '62067' or zipCode = '62071' or zipCode = '62071' or zipCode = '62071' or zipCode = '62220' or zipCode = '62220' or zipCode = '62221' or zipCode = '62221' or zipCode = '62221' or zipCode = '62221' or zipCode = '62222' or zipCode = '62223' or zipCode = '62223' or zipCode = '62223' or zipCode = '62225' or zipCode = '62225' or zipCode = '62225' or zipCode = '62226' or zipCode = '62226' or zipCode = '62243' or zipCode = '62254' or zipCode = '62269' or zipCode = '62269' or zipCode = '62269' or zipCode = '62281' or zipCode = '62285' or zipCode = '62289' or zipCode = '62294' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62260' or zipCode = '63006' or zipCode = '63010' or zipCode = '63011' or zipCode = '63011' or zipCode = '63011' or zipCode = '63011' or zipCode = '63011' or zipCode = '63011' or zipCode = '63017' or zipCode = '63017' or zipCode = '63017' or zipCode = '63017' or zipCode = '63021' or zipCode = '63021' or zipCode = '63021' or zipCode = '63021' or zipCode = '63021' or zipCode = '63021' or zipCode = '63021' or zipCode = '63022' or zipCode = '63024' or zipCode = '63025' or zipCode = '63025' or zipCode = '63025' or zipCode = '63040' or zipCode = '63042' or zipCode = '63042' or zipCode = '63042' or zipCode = '63043' or zipCode = '63043' or zipCode = '63043' or zipCode = '63044' or zipCode = '63044' or zipCode = '63044' or zipCode = '63045' or zipCode = '63045' or zipCode = '63045' or zipCode = '63049' or zipCode = '63052' or zipCode = '63052' or zipCode = '63052' or zipCode = '63052' or zipCode = '63074' or zipCode = '63074' or zipCode = '63074' or zipCode = '63074' or zipCode = '63074' or zipCode = '63088' or zipCode = '63088' or zipCode = '63088' or zipCode = '63025' or zipCode = '63025' or zipCode = '63026' or zipCode = '63026' or zipCode = '63031' or zipCode = '63031' or zipCode = '63032' or zipCode = '63033' or zipCode = '63033' or zipCode = '63034' or zipCode = '63040' or zipCode = '63040' or zipCode = '63040' or zipCode = '63052' or zipCode = '63053' or zipCode = '63053' or zipCode = '63057' or zipCode = '63099' or zipCode = '63099' or zipCode = '63101' or zipCode = '63102' or zipCode = '63103' or zipCode = '63104' or zipCode = '63105' or zipCode = '63105' or zipCode = '63105' or zipCode = '63106' or zipCode = '63107' or zipCode = '63108' or zipCode = '63109' or zipCode = '63110' or zipCode = '63111' or zipCode = '63112' or zipCode = '63112' or zipCode = '63113' or zipCode = '63113' or zipCode = '63114' or zipCode = '63114' or zipCode = '63114' or zipCode = '63121' or zipCode = '63121' or zipCode = '63121' or zipCode = '63121' or zipCode = '63121' or zipCode = '63121' or zipCode = '63121' or zipCode = '63122' or zipCode = '63122' or zipCode = '63122' or zipCode = '63122' or zipCode = '63122' or zipCode = '63122' or zipCode = '63123' or zipCode = '63123' or zipCode = '63124' or zipCode = '63124' or zipCode = '63124' or zipCode = '63124' or zipCode = '63125' or zipCode = '63125' or zipCode = '63125' or zipCode = '63125' or zipCode = '63126' or zipCode = '63126' or zipCode = '63126' or zipCode = '63127' or zipCode = '63127' or zipCode = '63127' or zipCode = '63128' or zipCode = '63128' or zipCode = '63129' or zipCode = '63129' or zipCode = '63129' or zipCode = '63130' or zipCode = '63130' or zipCode = '63130' or zipCode = '63130' or zipCode = '63130' or zipCode = '63131' or zipCode = '63131' or zipCode = '63131' or zipCode = '63131' or zipCode = '63131' or zipCode = '63131' or zipCode = '63132' or zipCode = '63132' or zipCode = '63132' or zipCode = '63133' or zipCode = '63133' or zipCode = '63133' or zipCode = '63133' or zipCode = '63133' or zipCode = '63134' or zipCode = '63134' or zipCode = '63134' or zipCode = '63134' or zipCode = '63135' or zipCode = '63135' or zipCode = '63135' or zipCode = '63135' or zipCode = '63135' or zipCode = '63135' or zipCode = '63136' or zipCode = '63136' or zipCode = '63136' or zipCode = '63136' or zipCode = '63136' or zipCode = '63136' or zipCode = '63114' or zipCode = '63114' or zipCode = '63114' or zipCode = '63114' or zipCode = '63115' or zipCode = '63116' or zipCode = '63117' or zipCode = '63117' or zipCode = '63117' or zipCode = '63118' or zipCode = '63119' or zipCode = '63119' or zipCode = '63119' or zipCode = '63119' or zipCode = '63119' or zipCode = '63120' or zipCode = '63120' or zipCode = '63120' or zipCode = '63121' or zipCode = '63121' or zipCode = '63121' or zipCode = '63121' or zipCode = '63136' or zipCode = '63137' or zipCode = '63137' or zipCode = '63137' or zipCode = '63137' or zipCode = '63137' or zipCode = '63138' or zipCode = '63138' or zipCode = '63138' or zipCode = '63139' or zipCode = '63140' or zipCode = '63140' or zipCode = '63140' or zipCode = '63141' or zipCode = '63141' or zipCode = '63143' or zipCode = '63143' or zipCode = '63144' or zipCode = '63144' or zipCode = '63145' or zipCode = '63145' or zipCode = '63145' or zipCode = '63145' or zipCode = '63146' or zipCode = '63146' or zipCode = '63147' or zipCode = '63150' or zipCode = '63150' or zipCode = '63151' or zipCode = '63155' or zipCode = '63156' or zipCode = '63157' or zipCode = '63158' or zipCode = '63160' or zipCode = '63160' or zipCode = '63163' or zipCode = '63164' or zipCode = '63164' or zipCode = '63166' or zipCode = '63167' or zipCode = '63167' or zipCode = '63169' or zipCode = '63171' or zipCode = '63171' or zipCode = '63301' or zipCode = '63301' or zipCode = '63301' or zipCode = '63301' or zipCode = '63302' or zipCode = '63303' or zipCode = '63303' or zipCode = '63303' or zipCode = '63303' or zipCode = '63373' or zipCode = '63177' or zipCode = '63178' or zipCode = '63179' or zipCode = '63180' or zipCode = '63180' or zipCode = '63182' or zipCode = '63182' or zipCode = '63188' or zipCode = '63190' or zipCode = '63190' or zipCode = '63195' or zipCode = '63195' or zipCode = '63195' or zipCode = '63197' or zipCode = '63197' or zipCode = '63198' or zipCode = '63198' or zipCode = '63199' or zipCode = '63199' or zipCode = '63301' or zipCode = '63301' or zipCode = '63301' or zipCode = '63373' or zipCode = '63373' or zipCode = '63373' or zipCode = '63386' or zipCode = '62002' or zipCode = '62010' or zipCode = '62018' or zipCode = '62024' or zipCode = '62025' or zipCode = '62026' or zipCode = '62028' or zipCode = '62034' or zipCode = '62035' or zipCode = '62040' or zipCode = '62048' or zipCode = '62059' or zipCode = '62060' or zipCode = '62062' or zipCode = '62067' or zipCode = '62071' or zipCode = '62084' or zipCode = '62087' or zipCode = '62090' or zipCode = '62095' or zipCode = '62201' or zipCode = '62202' or zipCode = '62203' or zipCode = '62204' or zipCode = '62205' or zipCode = '62206' or zipCode = '62207' or zipCode = '62208' or zipCode = '62220' or zipCode = '62221' or zipCode = '62222' or zipCode = '62223' or zipCode = '62224' or zipCode = '62225' or zipCode = '62226' or zipCode = '62232' or zipCode = '62234' or zipCode = '62236' or zipCode = '62239' or zipCode = '62240' or zipCode = '62243' or zipCode = '62254' or zipCode = '62256' or zipCode = '62258' or zipCode = '62260' or zipCode = '62269' or zipCode = '62281' or zipCode = '62285' or zipCode = '62289' or zipCode = '62294' or zipCode = '62295' or zipCode = '62298' or zipCode = '63001' or zipCode = '63005' or zipCode = '63006' or zipCode = '63010' or zipCode = '63011' or zipCode = '63012' or zipCode = '63017' or zipCode = '63021' or zipCode = '63022' or zipCode = '63024' or zipCode = '63025' or zipCode = '63026' or zipCode = '63031' or zipCode = '63032' or zipCode = '63033' or zipCode = '63034' or zipCode = '63040' or zipCode = '63042' or zipCode = '63043' or zipCode = '63044' or zipCode = '63045' or zipCode = '63049' or zipCode = '63052' or zipCode = '63057' or zipCode = '63074' or zipCode = '63088' or zipCode = '63099' or zipCode = '63101' or zipCode = '63102' or zipCode = '63103' or zipCode = '63104' or zipCode = '63105' or zipCode = '63106' or zipCode = '63107' or zipCode = '63108' or zipCode = '63109' or zipCode = '63110' or zipCode = '63111' or zipCode = '63112' or zipCode = '63113' or zipCode = '63114' or zipCode = '63115' or zipCode = '63116' or zipCode = '63117' or zipCode = '63118' or zipCode = '63119' or zipCode = '63120' or zipCode = '63121' or zipCode = '63122' or zipCode = '63123' or zipCode = '63124' or zipCode = '63125' or zipCode = '63126' or zipCode = '63127' or zipCode = '63128' or zipCode = '63129' or zipCode = '63130' or zipCode = '63131' or zipCode = '63132' or zipCode = '63133' or zipCode = '63134' or zipCode = '63135' or zipCode = '63136' or zipCode = '63137' or zipCode = '63138' or zipCode = '63139' or zipCode = '63140' or zipCode = '63141' or zipCode = '63143' or zipCode = '63144' or zipCode = '63145' or zipCode = '63146' or zipCode = '63147' or zipCode = '63150' or zipCode = '63151' or zipCode = '63153' or zipCode = '63155' or zipCode = '63156' or zipCode = '63157' or zipCode = '63158' or zipCode = '63160' or zipCode = '63163' or zipCode = '63164' or zipCode = '63166' or zipCode = '63167' or zipCode = '63169' or zipCode = '63171' or zipCode = '63177' or zipCode = '63178' or zipCode = '63179' or zipCode = '63180' or zipCode = '63182' or zipCode = '63188' or zipCode = '63195' or zipCode = '63196' or zipCode = '63197' or zipCode = '63198' or zipCode = '63199' or zipCode = '63301' or zipCode = '63303' or zipCode = '63338' or zipCode = '63346' or zipCode = '63373' or zipCode = '63386') 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 ='62024' or zipCode = '62024' or zipCode = '62025' or zipCode = '62025' or zipCode = '62025' or zipCode = '62026' or zipCode = '62026' or zipCode = '62028' or zipCode = '62028' or zipCode = '62002' or zipCode = '62010' or zipCode = '62010' or zipCode = '62018' or zipCode = '62034' or zipCode = '62035' or zipCode = '62040' or zipCode = '62040' or zipCode = '62040' or zipCode = '62048' or zipCode = '62059' or zipCode = '62059' or zipCode = '62059' or zipCode = '62060' or zipCode = '62060' or zipCode = '62060' or zipCode = '62060' or zipCode = '62061' or zipCode = '62062' or zipCode = '62084' or zipCode = '62087' or zipCode = '62090' or zipCode = '62095' or zipCode = '62201' or zipCode = '62201' or zipCode = '62201' or zipCode = '62201' or zipCode = '62201' or zipCode = '62201' or zipCode = '62202' or zipCode = '62202' or zipCode = '62202' or zipCode = '62203' or zipCode = '62203' or zipCode = '62203' or zipCode = '62203' or zipCode = '62204' or zipCode = '62204' or zipCode = '62204' or zipCode = '62205' or zipCode = '62205' or zipCode = '62205' or zipCode = '62205' or zipCode = '62205' or zipCode = '62205' or zipCode = '62206' or zipCode = '62206' or zipCode = '62206' or zipCode = '62206' or zipCode = '62207' or zipCode = '62207' or zipCode = '62207' or zipCode = '62207' or zipCode = '62208' or zipCode = '62208' or zipCode = '62208' or zipCode = '62208' or zipCode = '62232' or zipCode = '62232' or zipCode = '62232' or zipCode = '62234' or zipCode = '62234' or zipCode = '62234' or zipCode = '62236' or zipCode = '62239' or zipCode = '62240' or zipCode = '62240' or zipCode = '62240' or zipCode = '62067' or zipCode = '62071' or zipCode = '62071' or zipCode = '62071' or zipCode = '62220' or zipCode = '62220' or zipCode = '62221' or zipCode = '62221' or zipCode = '62221' or zipCode = '62221' or zipCode = '62222' or zipCode = '62223' or zipCode = '62223' or zipCode = '62223' or zipCode = '62225' or zipCode = '62225' or zipCode = '62225' or zipCode = '62226' or zipCode = '62226' or zipCode = '62243' or zipCode = '62254' or zipCode = '62269' or zipCode = '62269' or zipCode = '62269' or zipCode = '62281' or zipCode = '62285' or zipCode = '62289' or zipCode = '62294' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62260' or zipCode = '63006' or zipCode = '63010' or zipCode = '63011' or zipCode = '63011' or zipCode = '63011' or zipCode = '63011' or zipCode = '63011' or zipCode = '63011' or zipCode = '63017' or zipCode = '63017' or zipCode = '63017' or zipCode = '63017' or zipCode = '63021' or zipCode = '63021' or zipCode = '63021' or zipCode = '63021' or zipCode = '63021' or zipCode = '63021' or zipCode = '63021' or zipCode = '63022' or zipCode = '63024' or zipCode = '63025' or zipCode = '63025' or zipCode = '63025' or zipCode = '63040' or zipCode = '63042' or zipCode = '63042' or zipCode = '63042' or zipCode = '63043' or zipCode = '63043' or zipCode = '63043' or zipCode = '63044' or zipCode = '63044' or zipCode = '63044' or zipCode = '63045' or zipCode = '63045' or zipCode = '63045' or zipCode = '63049' or zipCode = '63052' or zipCode = '63052' or zipCode = '63052' or zipCode = '63052' or zipCode = '63074' or zipCode = '63074' or zipCode = '63074' or zipCode = '63074' or zipCode = '63074' or zipCode = '63088' or zipCode = '63088' or zipCode = '63088' or zipCode = '63025' or zipCode = '63025' or zipCode = '63026' or zipCode = '63026' or zipCode = '63031' or zipCode = '63031' or zipCode = '63032' or zipCode = '63033' or zipCode = '63033' or zipCode = '63034' or zipCode = '63040' or zipCode = '63040' or zipCode = '63040' or zipCode = '63052' or zipCode = '63053' or zipCode = '63053' or zipCode = '63057' or zipCode = '63099' or zipCode = '63099' or zipCode = '63101' or zipCode = '63102' or zipCode = '63103' or zipCode = '63104' or zipCode = '63105' or zipCode = '63105' or zipCode = '63105' or zipCode = '63106' or zipCode = '63107' or zipCode = '63108' or zipCode = '63109' or zipCode = '63110' or zipCode = '63111' or zipCode = '63112' or zipCode = '63112' or zipCode = '63113' or zipCode = '63113' or zipCode = '63114' or zipCode = '63114' or zipCode = '63114' or zipCode = '63121' or zipCode = '63121' or zipCode = '63121' or zipCode = '63121' or zipCode = '63121' or zipCode = '63121' or zipCode = '63121' or zipCode = '63122' or zipCode = '63122' or zipCode = '63122' or zipCode = '63122' or zipCode = '63122' or zipCode = '63122' or zipCode = '63123' or zipCode = '63123' or zipCode = '63124' or zipCode = '63124' or zipCode = '63124' or zipCode = '63124' or zipCode = '63125' or zipCode = '63125' or zipCode = '63125' or zipCode = '63125' or zipCode = '63126' or zipCode = '63126' or zipCode = '63126' or zipCode = '63127' or zipCode = '63127' or zipCode = '63127' or zipCode = '63128' or zipCode = '63128' or zipCode = '63129' or zipCode = '63129' or zipCode = '63129' or zipCode = '63130' or zipCode = '63130' or zipCode = '63130' or zipCode = '63130' or zipCode = '63130' or zipCode = '63131' or zipCode = '63131' or zipCode = '63131' or zipCode = '63131' or zipCode = '63131' or zipCode = '63131' or zipCode = '63132' or zipCode = '63132' or zipCode = '63132' or zipCode = '63133' or zipCode = '63133' or zipCode = '63133' or zipCode = '63133' or zipCode = '63133' or zipCode = '63134' or zipCode = '63134' or zipCode = '63134' or zipCode = '63134' or zipCode = '63135' or zipCode = '63135' or zipCode = '63135' or zipCode = '63135' or zipCode = '63135' or zipCode = '63135' or zipCode = '63136' or zipCode = '63136' or zipCode = '63136' or zipCode = '63136' or zipCode = '63136' or zipCode = '63136' or zipCode = '63114' or zipCode = '63114' or zipCode = '63114' or zipCode = '63114' or zipCode = '63115' or zipCode = '63116' or zipCode = '63117' or zipCode = '63117' or zipCode = '63117' or zipCode = '63118' or zipCode = '63119' or zipCode = '63119' or zipCode = '63119' or zipCode = '63119' or zipCode = '63119' or zipCode = '63120' or zipCode = '63120' or zipCode = '63120' or zipCode = '63121' or zipCode = '63121' or zipCode = '63121' or zipCode = '63121' or zipCode = '63136' or zipCode = '63137' or zipCode = '63137' or zipCode = '63137' or zipCode = '63137' or zipCode = '63137' or zipCode = '63138' or zipCode = '63138' or zipCode = '63138' or zipCode = '63139' or zipCode = '63140' or zipCode = '63140' or zipCode = '63140' or zipCode = '63141' or zipCode = '63141' or zipCode = '63143' or zipCode = '63143' or zipCode = '63144' or zipCode = '63144' or zipCode = '63145' or zipCode = '63145' or zipCode = '63145' or zipCode = '63145' or zipCode = '63146' or zipCode = '63146' or zipCode = '63147' or zipCode = '63150' or zipCode = '63150' or zipCode = '63151' or zipCode = '63155' or zipCode = '63156' or zipCode = '63157' or zipCode = '63158' or zipCode = '63160' or zipCode = '63160' or zipCode = '63163' or zipCode = '63164' or zipCode = '63164' or zipCode = '63166' or zipCode = '63167' or zipCode = '63167' or zipCode = '63169' or zipCode = '63171' or zipCode = '63171' or zipCode = '63301' or zipCode = '63301' or zipCode = '63301' or zipCode = '63301' or zipCode = '63302' or zipCode = '63303' or zipCode = '63303' or zipCode = '63303' or zipCode = '63303' or zipCode = '63373' or zipCode = '63177' or zipCode = '63178' or zipCode = '63179' or zipCode = '63180' or zipCode = '63180' or zipCode = '63182' or zipCode = '63182' or zipCode = '63188' or zipCode = '63190' or zipCode = '63190' or zipCode = '63195' or zipCode = '63195' or zipCode = '63195' or zipCode = '63197' or zipCode = '63197' or zipCode = '63198' or zipCode = '63198' or zipCode = '63199' or zipCode = '63199' or zipCode = '63301' or zipCode = '63301' or zipCode = '63301' or zipCode = '63373' or zipCode = '63373' or zipCode = '63373' or zipCode = '63386' or zipCode = '62002' or zipCode = '62010' or zipCode = '62018' or zipCode = '62024' or zipCode = '62025' or zipCode = '62026' or zipCode = '62028' or zipCode = '62034' or zipCode = '62035' or zipCode = '62040' or zipCode = '62048' or zipCode = '62059' or zipCode = '62060' or zipCode = '62062' or zipCode = '62067' or zipCode = '62071' or zipCode = '62084' or zipCode = '62087' or zipCode = '62090' or zipCode = '62095' or zipCode = '62201' or zipCode = '62202' or zipCode = '62203' or zipCode = '62204' or zipCode = '62205' or zipCode = '62206' or zipCode = '62207' or zipCode = '62208' or zipCode = '62220' or zipCode = '62221' or zipCode = '62222' or zipCode = '62223' or zipCode = '62224' or zipCode = '62225' or zipCode = '62226' or zipCode = '62232' or zipCode = '62234' or zipCode = '62236' or zipCode = '62239' or zipCode = '62240' or zipCode = '62243' or zipCode = '62254' or zipCode = '62256' or zipCode = '62258' or zipCode = '62260' or zipCode = '62269' or zipCode = '62281' or zipCode = '62285' or zipCode = '62289' or zipCode = '62294' or zipCode = '62295' or zipCode = '62298' or zipCode = '63001' or zipCode = '63005' or zipCode = '63006' or zipCode = '63010' or zipCode = '63011' or zipCode = '63012' or zipCode = '63017' or zipCode = '63021' or zipCode = '63022' or zipCode = '63024' or zipCode = '63025' or zipCode = '63026' or zipCode = '63031' or zipCode = '63032' or zipCode = '63033' or zipCode = '63034' or zipCode = '63040' or zipCode = '63042' or zipCode = '63043' or zipCode = '63044' or zipCode = '63045' or zipCode = '63049' or zipCode = '63052' or zipCode = '63057' or zipCode = '63074' or zipCode = '63088' or zipCode = '63099' or zipCode = '63101' or zipCode = '63102' or zipCode = '63103' or zipCode = '63104' or zipCode = '63105' or zipCode = '63106' or zipCode = '63107' or zipCode = '63108' or zipCode = '63109' or zipCode = '63110' or zipCode = '63111' or zipCode = '63112' or zipCode = '63113' or zipCode = '63114' or zipCode = '63115' or zipCode = '63116' or zipCode = '63117' or zipCode = '63118' or zipCode = '63119' or zipCode = '63120' or zipCode = '63121' or zipCode = '63122' or zipCode = '63123' or zipCode = '63124' or zipCode = '63125' or zipCode = '63126' or zipCode = '63127' or zipCode = '63128' or zipCode = '63129' or zipCode = '63130' or zipCode = '63131' or zipCode = '63132' or zipCode = '63133' or zipCode = '63134' or zipCode = '63135' or zipCode = '63136' or zipCode = '63137' or zipCode = '63138' or zipCode = '63139' or zipCode = '63140' or zipCode = '63141' or zipCode = '63143' or zipCode = '63144' or zipCode = '63145' or zipCode = '63146' or zipCode = '63147' or zipCode = '63150' or zipCode = '63151' or zipCode = '63153' or zipCode = '63155' or zipCode = '63156' or zipCode = '63157' or zipCode = '63158' or zipCode = '63160' or zipCode = '63163' or zipCode = '63164' or zipCode = '63166' or zipCode = '63167' or zipCode = '63169' or zipCode = '63171' or zipCode = '63177' or zipCode = '63178' or zipCode = '63179' or zipCode = '63180' or zipCode = '63182' or zipCode = '63188' or zipCode = '63195' or zipCode = '63196' or zipCode = '63197' or zipCode = '63198' or zipCode = '63199' or zipCode = '63301' or zipCode = '63303' or zipCode = '63338' or zipCode = '63346' or zipCode = '63373' or zipCode = '63386') 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 ='62024' or zipCode = '62024' or zipCode = '62025' or zipCode = '62025' or zipCode = '62025' or zipCode = '62026' or zipCode = '62026' or zipCode = '62028' or zipCode = '62028' or zipCode = '62002' or zipCode = '62010' or zipCode = '62010' or zipCode = '62018' or zipCode = '62034' or zipCode = '62035' or zipCode = '62040' or zipCode = '62040' or zipCode = '62040' or zipCode = '62048' or zipCode = '62059' or zipCode = '62059' or zipCode = '62059' or zipCode = '62060' or zipCode = '62060' or zipCode = '62060' or zipCode = '62060' or zipCode = '62061' or zipCode = '62062' or zipCode = '62084' or zipCode = '62087' or zipCode = '62090' or zipCode = '62095' or zipCode = '62201' or zipCode = '62201' or zipCode = '62201' or zipCode = '62201' or zipCode = '62201' or zipCode = '62201' or zipCode = '62202' or zipCode = '62202' or zipCode = '62202' or zipCode = '62203' or zipCode = '62203' or zipCode = '62203' or zipCode = '62203' or zipCode = '62204' or zipCode = '62204' or zipCode = '62204' or zipCode = '62205' or zipCode = '62205' or zipCode = '62205' or zipCode = '62205' or zipCode = '62205' or zipCode = '62205' or zipCode = '62206' or zipCode = '62206' or zipCode = '62206' or zipCode = '62206' or zipCode = '62207' or zipCode = '62207' or zipCode = '62207' or zipCode = '62207' or zipCode = '62208' or zipCode = '62208' or zipCode = '62208' or zipCode = '62208' or zipCode = '62232' or zipCode = '62232' or zipCode = '62232' or zipCode = '62234' or zipCode = '62234' or zipCode = '62234' or zipCode = '62236' or zipCode = '62239' or zipCode = '62240' or zipCode = '62240' or zipCode = '62240' or zipCode = '62067' or zipCode = '62071' or zipCode = '62071' or zipCode = '62071' or zipCode = '62220' or zipCode = '62220' or zipCode = '62221' or zipCode = '62221' or zipCode = '62221' or zipCode = '62221' or zipCode = '62222' or zipCode = '62223' or zipCode = '62223' or zipCode = '62223' or zipCode = '62225' or zipCode = '62225' or zipCode = '62225' or zipCode = '62226' or zipCode = '62226' or zipCode = '62243' or zipCode = '62254' or zipCode = '62269' or zipCode = '62269' or zipCode = '62269' or zipCode = '62281' or zipCode = '62285' or zipCode = '62289' or zipCode = '62294' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62260' or zipCode = '63006' or zipCode = '63010' or zipCode = '63011' or zipCode = '63011' or zipCode = '63011' or zipCode = '63011' or zipCode = '63011' or zipCode = '63011' or zipCode = '63017' or zipCode = '63017' or zipCode = '63017' or zipCode = '63017' or zipCode = '63021' or zipCode = '63021' or zipCode = '63021' or zipCode = '63021' or zipCode = '63021' or zipCode = '63021' or zipCode = '63021' or zipCode = '63022' or zipCode = '63024' or zipCode = '63025' or zipCode = '63025' or zipCode = '63025' or zipCode = '63040' or zipCode = '63042' or zipCode = '63042' or zipCode = '63042' or zipCode = '63043' or zipCode = '63043' or zipCode = '63043' or zipCode = '63044' or zipCode = '63044' or zipCode = '63044' or zipCode = '63045' or zipCode = '63045' or zipCode = '63045' or zipCode = '63049' or zipCode = '63052' or zipCode = '63052' or zipCode = '63052' or zipCode = '63052' or zipCode = '63074' or zipCode = '63074' or zipCode = '63074' or zipCode = '63074' or zipCode = '63074' or zipCode = '63088' or zipCode = '63088' or zipCode = '63088' or zipCode = '63025' or zipCode = '63025' or zipCode = '63026' or zipCode = '63026' or zipCode = '63031' or zipCode = '63031' or zipCode = '63032' or zipCode = '63033' or zipCode = '63033' or zipCode = '63034' or zipCode = '63040' or zipCode = '63040' or zipCode = '63040' or zipCode = '63052' or zipCode = '63053' or zipCode = '63053' or zipCode = '63057' or zipCode = '63099' or zipCode = '63099' or zipCode = '63101' or zipCode = '63102' or zipCode = '63103' or zipCode = '63104' or zipCode = '63105' or zipCode = '63105' or zipCode = '63105' or zipCode = '63106' or zipCode = '63107' or zipCode = '63108' or zipCode = '63109' or zipCode = '63110' or zipCode = '63111' or zipCode = '63112' or zipCode = '63112' or zipCode = '63113' or zipCode = '63113' or zipCode = '63114' or zipCode = '63114' or zipCode = '63114' or zipCode = '63121' or zipCode = '63121' or zipCode = '63121' or zipCode = '63121' or zipCode = '63121' or zipCode = '63121' or zipCode = '63121' or zipCode = '63122' or zipCode = '63122' or zipCode = '63122' or zipCode = '63122' or zipCode = '63122' or zipCode = '63122' or zipCode = '63123' or zipCode = '63123' or zipCode = '63124' or zipCode = '63124' or zipCode = '63124' or zipCode = '63124' or zipCode = '63125' or zipCode = '63125' or zipCode = '63125' or zipCode = '63125' or zipCode = '63126' or zipCode = '63126' or zipCode = '63126' or zipCode = '63127' or zipCode = '63127' or zipCode = '63127' or zipCode = '63128' or zipCode = '63128' or zipCode = '63129' or zipCode = '63129' or zipCode = '63129' or zipCode = '63130' or zipCode = '63130' or zipCode = '63130' or zipCode = '63130' or zipCode = '63130' or zipCode = '63131' or zipCode = '63131' or zipCode = '63131' or zipCode = '63131' or zipCode = '63131' or zipCode = '63131' or zipCode = '63132' or zipCode = '63132' or zipCode = '63132' or zipCode = '63133' or zipCode = '63133' or zipCode = '63133' or zipCode = '63133' or zipCode = '63133' or zipCode = '63134' or zipCode = '63134' or zipCode = '63134' or zipCode = '63134' or zipCode = '63135' or zipCode = '63135' or zipCode = '63135' or zipCode = '63135' or zipCode = '63135' or zipCode = '63135' or zipCode = '63136' or zipCode = '63136' or zipCode = '63136' or zipCode = '63136' or zipCode = '63136' or zipCode = '63136' or zipCode = '63114' or zipCode = '63114' or zipCode = '63114' or zipCode = '63114' or zipCode = '63115' or zipCode = '63116' or zipCode = '63117' or zipCode = '63117' or zipCode = '63117' or zipCode = '63118' or zipCode = '63119' or zipCode = '63119' or zipCode = '63119' or zipCode = '63119' or zipCode = '63119' or zipCode = '63120' or zipCode = '63120' or zipCode = '63120' or zipCode = '63121' or zipCode = '63121' or zipCode = '63121' or zipCode = '63121' or zipCode = '63136' or zipCode = '63137' or zipCode = '63137' or zipCode = '63137' or zipCode = '63137' or zipCode = '63137' or zipCode = '63138' or zipCode = '63138' or zipCode = '63138' or zipCode = '63139' or zipCode = '63140' or zipCode = '63140' or zipCode = '63140' or zipCode = '63141' or zipCode = '63141' or zipCode = '63143' or zipCode = '63143' or zipCode = '63144' or zipCode = '63144' or zipCode = '63145' or zipCode = '63145' or zipCode = '63145' or zipCode = '63145' or zipCode = '63146' or zipCode = '63146' or zipCode = '63147' or zipCode = '63150' or zipCode = '63150' or zipCode = '63151' or zipCode = '63155' or zipCode = '63156' or zipCode = '63157' or zipCode = '63158' or zipCode = '63160' or zipCode = '63160' or zipCode = '63163' or zipCode = '63164' or zipCode = '63164' or zipCode = '63166' or zipCode = '63167' or zipCode = '63167' or zipCode = '63169' or zipCode = '63171' or zipCode = '63171' or zipCode = '63301' or zipCode = '63301' or zipCode = '63301' or zipCode = '63301' or zipCode = '63302' or zipCode = '63303' or zipCode = '63303' or zipCode = '63303' or zipCode = '63303' or zipCode = '63373' or zipCode = '63177' or zipCode = '63178' or zipCode = '63179' or zipCode = '63180' or zipCode = '63180' or zipCode = '63182' or zipCode = '63182' or zipCode = '63188' or zipCode = '63190' or zipCode = '63190' or zipCode = '63195' or zipCode = '63195' or zipCode = '63195' or zipCode = '63197' or zipCode = '63197' or zipCode = '63198' or zipCode = '63198' or zipCode = '63199' or zipCode = '63199' or zipCode = '63301' or zipCode = '63301' or zipCode = '63301' or zipCode = '63373' or zipCode = '63373' or zipCode = '63373' or zipCode = '63386' or zipCode = '62002' or zipCode = '62010' or zipCode = '62018' or zipCode = '62024' or zipCode = '62025' or zipCode = '62026' or zipCode = '62028' or zipCode = '62034' or zipCode = '62035' or zipCode = '62040' or zipCode = '62048' or zipCode = '62059' or zipCode = '62060' or zipCode = '62062' or zipCode = '62067' or zipCode = '62071' or zipCode = '62084' or zipCode = '62087' or zipCode = '62090' or zipCode = '62095' or zipCode = '62201' or zipCode = '62202' or zipCode = '62203' or zipCode = '62204' or zipCode = '62205' or zipCode = '62206' or zipCode = '62207' or zipCode = '62208' or zipCode = '62220' or zipCode = '62221' or zipCode = '62222' or zipCode = '62223' or zipCode = '62224' or zipCode = '62225' or zipCode = '62226' or zipCode = '62232' or zipCode = '62234' or zipCode = '62236' or zipCode = '62239' or zipCode = '62240' or zipCode = '62243' or zipCode = '62254' or zipCode = '62256' or zipCode = '62258' or zipCode = '62260' or zipCode = '62269' or zipCode = '62281' or zipCode = '62285' or zipCode = '62289' or zipCode = '62294' or zipCode = '62295' or zipCode = '62298' or zipCode = '63001' or zipCode = '63005' or zipCode = '63006' or zipCode = '63010' or zipCode = '63011' or zipCode = '63012' or zipCode = '63017' or zipCode = '63021' or zipCode = '63022' or zipCode = '63024' or zipCode = '63025' or zipCode = '63026' or zipCode = '63031' or zipCode = '63032' or zipCode = '63033' or zipCode = '63034' or zipCode = '63040' or zipCode = '63042' or zipCode = '63043' or zipCode = '63044' or zipCode = '63045' or zipCode = '63049' or zipCode = '63052' or zipCode = '63057' or zipCode = '63074' or zipCode = '63088' or zipCode = '63099' or zipCode = '63101' or zipCode = '63102' or zipCode = '63103' or zipCode = '63104' or zipCode = '63105' or zipCode = '63106' or zipCode = '63107' or zipCode = '63108' or zipCode = '63109' or zipCode = '63110' or zipCode = '63111' or zipCode = '63112' or zipCode = '63113' or zipCode = '63114' or zipCode = '63115' or zipCode = '63116' or zipCode = '63117' or zipCode = '63118' or zipCode = '63119' or zipCode = '63120' or zipCode = '63121' or zipCode = '63122' or zipCode = '63123' or zipCode = '63124' or zipCode = '63125' or zipCode = '63126' or zipCode = '63127' or zipCode = '63128' or zipCode = '63129' or zipCode = '63130' or zipCode = '63131' or zipCode = '63132' or zipCode = '63133' or zipCode = '63134' or zipCode = '63135' or zipCode = '63136' or zipCode = '63137' or zipCode = '63138' or zipCode = '63139' or zipCode = '63140' or zipCode = '63141' or zipCode = '63143' or zipCode = '63144' or zipCode = '63145' or zipCode = '63146' or zipCode = '63147' or zipCode = '63150' or zipCode = '63151' or zipCode = '63153' or zipCode = '63155' or zipCode = '63156' or zipCode = '63157' or zipCode = '63158' or zipCode = '63160' or zipCode = '63163' or zipCode = '63164' or zipCode = '63166' or zipCode = '63167' or zipCode = '63169' or zipCode = '63171' or zipCode = '63177' or zipCode = '63178' or zipCode = '63179' or zipCode = '63180' or zipCode = '63182' or zipCode = '63188' or zipCode = '63195' or zipCode = '63196' or zipCode = '63197' or zipCode = '63198' or zipCode = '63199' or zipCode = '63301' or zipCode = '63303' or zipCode = '63338' or zipCode = '63346' or zipCode = '63373' or zipCode = '63386') 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 ='62024' or zipCode = '62024' or zipCode = '62025' or zipCode = '62025' or zipCode = '62025' or zipCode = '62026' or zipCode = '62026' or zipCode = '62028' or zipCode = '62028' or zipCode = '62002' or zipCode = '62010' or zipCode = '62010' or zipCode = '62018' or zipCode = '62034' or zipCode = '62035' or zipCode = '62040' or zipCode = '62040' or zipCode = '62040' or zipCode = '62048' or zipCode = '62059' or zipCode = '62059' or zipCode = '62059' or zipCode = '62060' or zipCode = '62060' or zipCode = '62060' or zipCode = '62060' or zipCode = '62061' or zipCode = '62062' or zipCode = '62084' or zipCode = '62087' or zipCode = '62090' or zipCode = '62095' or zipCode = '62201' or zipCode = '62201' or zipCode = '62201' or zipCode = '62201' or zipCode = '62201' or zipCode = '62201' or zipCode = '62202' or zipCode = '62202' or zipCode = '62202' or zipCode = '62203' or zipCode = '62203' or zipCode = '62203' or zipCode = '62203' or zipCode = '62204' or zipCode = '62204' or zipCode = '62204' or zipCode = '62205' or zipCode = '62205' or zipCode = '62205' or zipCode = '62205' or zipCode = '62205' or zipCode = '62205' or zipCode = '62206' or zipCode = '62206' or zipCode = '62206' or zipCode = '62206' or zipCode = '62207' or zipCode = '62207' or zipCode = '62207' or zipCode = '62207' or zipCode = '62208' or zipCode = '62208' or zipCode = '62208' or zipCode = '62208' or zipCode = '62232' or zipCode = '62232' or zipCode = '62232' or zipCode = '62234' or zipCode = '62234' or zipCode = '62234' or zipCode = '62236' or zipCode = '62239' or zipCode = '62240' or zipCode = '62240' or zipCode = '62240' or zipCode = '62067' or zipCode = '62071' or zipCode = '62071' or zipCode = '62071' or zipCode = '62220' or zipCode = '62220' or zipCode = '62221' or zipCode = '62221' or zipCode = '62221' or zipCode = '62221' or zipCode = '62222' or zipCode = '62223' or zipCode = '62223' or zipCode = '62223' or zipCode = '62225' or zipCode = '62225' or zipCode = '62225' or zipCode = '62226' or zipCode = '62226' or zipCode = '62243' or zipCode = '62254' or zipCode = '62269' or zipCode = '62269' or zipCode = '62269' or zipCode = '62281' or zipCode = '62285' or zipCode = '62289' or zipCode = '62294' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62260' or zipCode = '63006' or zipCode = '63010' or zipCode = '63011' or zipCode = '63011' or zipCode = '63011' or zipCode = '63011' or zipCode = '63011' or zipCode = '63011' or zipCode = '63017' or zipCode = '63017' or zipCode = '63017' or zipCode = '63017' or zipCode = '63021' or zipCode = '63021' or zipCode = '63021' or zipCode = '63021' or zipCode = '63021' or zipCode = '63021' or zipCode = '63021' or zipCode = '63022' or zipCode = '63024' or zipCode = '63025' or zipCode = '63025' or zipCode = '63025' or zipCode = '63040' or zipCode = '63042' or zipCode = '63042' or zipCode = '63042' or zipCode = '63043' or zipCode = '63043' or zipCode = '63043' or zipCode = '63044' or zipCode = '63044' or zipCode = '63044' or zipCode = '63045' or zipCode = '63045' or zipCode = '63045' or zipCode = '63049' or zipCode = '63052' or zipCode = '63052' or zipCode = '63052' or zipCode = '63052' or zipCode = '63074' or zipCode = '63074' or zipCode = '63074' or zipCode = '63074' or zipCode = '63074' or zipCode = '63088' or zipCode = '63088' or zipCode = '63088' or zipCode = '63025' or zipCode = '63025' or zipCode = '63026' or zipCode = '63026' or zipCode = '63031' or zipCode = '63031' or zipCode = '63032' or zipCode = '63033' or zipCode = '63033' or zipCode = '63034' or zipCode = '63040' or zipCode = '63040' or zipCode = '63040' or zipCode = '63052' or zipCode = '63053' or zipCode = '63053' or zipCode = '63057' or zipCode = '63099' or zipCode = '63099' or zipCode = '63101' or zipCode = '63102' or zipCode = '63103' or zipCode = '63104' or zipCode = '63105' or zipCode = '63105' or zipCode = '63105' or zipCode = '63106' or zipCode = '63107' or zipCode = '63108' or zipCode = '63109' or zipCode = '63110' or zipCode = '63111' or zipCode = '63112' or zipCode = '63112' or zipCode = '63113' or zipCode = '63113' or zipCode = '63114' or zipCode = '63114' or zipCode = '63114' or zipCode = '63121' or zipCode = '63121' or zipCode = '63121' or zipCode = '63121' or zipCode = '63121' or zipCode = '63121' or zipCode = '63121' or zipCode = '63122' or zipCode = '63122' or zipCode = '63122' or zipCode = '63122' or zipCode = '63122' or zipCode = '63122' or zipCode = '63123' or zipCode = '63123' or zipCode = '63124' or zipCode = '63124' or zipCode = '63124' or zipCode = '63124' or zipCode = '63125' or zipCode = '63125' or zipCode = '63125' or zipCode = '63125' or zipCode = '63126' or zipCode = '63126' or zipCode = '63126' or zipCode = '63127' or zipCode = '63127' or zipCode = '63127' or zipCode = '63128' or zipCode = '63128' or zipCode = '63129' or zipCode = '63129' or zipCode = '63129' or zipCode = '63130' or zipCode = '63130' or zipCode = '63130' or zipCode = '63130' or zipCode = '63130' or zipCode = '63131' or zipCode = '63131' or zipCode = '63131' or zipCode = '63131' or zipCode = '63131' or zipCode = '63131' or zipCode = '63132' or zipCode = '63132' or zipCode = '63132' or zipCode = '63133' or zipCode = '63133' or zipCode = '63133' or zipCode = '63133' or zipCode = '63133' or zipCode = '63134' or zipCode = '63134' or zipCode = '63134' or zipCode = '63134' or zipCode = '63135' or zipCode = '63135' or zipCode = '63135' or zipCode = '63135' or zipCode = '63135' or zipCode = '63135' or zipCode = '63136' or zipCode = '63136' or zipCode = '63136' or zipCode = '63136' or zipCode = '63136' or zipCode = '63136' or zipCode = '63114' or zipCode = '63114' or zipCode = '63114' or zipCode = '63114' or zipCode = '63115' or zipCode = '63116' or zipCode = '63117' or zipCode = '63117' or zipCode = '63117' or zipCode = '63118' or zipCode = '63119' or zipCode = '63119' or zipCode = '63119' or zipCode = '63119' or zipCode = '63119' or zipCode = '63120' or zipCode = '63120' or zipCode = '63120' or zipCode = '63121' or zipCode = '63121' or zipCode = '63121' or zipCode = '63121' or zipCode = '63136' or zipCode = '63137' or zipCode = '63137' or zipCode = '63137' or zipCode = '63137' or zipCode = '63137' or zipCode = '63138' or zipCode = '63138' or zipCode = '63138' or zipCode = '63139' or zipCode = '63140' or zipCode = '63140' or zipCode = '63140' or zipCode = '63141' or zipCode = '63141' or zipCode = '63143' or zipCode = '63143' or zipCode = '63144' or zipCode = '63144' or zipCode = '63145' or zipCode = '63145' or zipCode = '63145' or zipCode = '63145' or zipCode = '63146' or zipCode = '63146' or zipCode = '63147' or zipCode = '63150' or zipCode = '63150' or zipCode = '63151' or zipCode = '63155' or zipCode = '63156' or zipCode = '63157' or zipCode = '63158' or zipCode = '63160' or zipCode = '63160' or zipCode = '63163' or zipCode = '63164' or zipCode = '63164' or zipCode = '63166' or zipCode = '63167' or zipCode = '63167' or zipCode = '63169' or zipCode = '63171' or zipCode = '63171' or zipCode = '63301' or zipCode = '63301' or zipCode = '63301' or zipCode = '63301' or zipCode = '63302' or zipCode = '63303' or zipCode = '63303' or zipCode = '63303' or zipCode = '63303' or zipCode = '63373' or zipCode = '63177' or zipCode = '63178' or zipCode = '63179' or zipCode = '63180' or zipCode = '63180' or zipCode = '63182' or zipCode = '63182' or zipCode = '63188' or zipCode = '63190' or zipCode = '63190' or zipCode = '63195' or zipCode = '63195' or zipCode = '63195' or zipCode = '63197' or zipCode = '63197' or zipCode = '63198' or zipCode = '63198' or zipCode = '63199' or zipCode = '63199' or zipCode = '63301' or zipCode = '63301' or zipCode = '63301' or zipCode = '63373' or zipCode = '63373' or zipCode = '63373' or zipCode = '63386' or zipCode = '62002' or zipCode = '62010' or zipCode = '62018' or zipCode = '62024' or zipCode = '62025' or zipCode = '62026' or zipCode = '62028' or zipCode = '62034' or zipCode = '62035' or zipCode = '62040' or zipCode = '62048' or zipCode = '62059' or zipCode = '62060' or zipCode = '62062' or zipCode = '62067' or zipCode = '62071' or zipCode = '62084' or zipCode = '62087' or zipCode = '62090' or zipCode = '62095' or zipCode = '62201' or zipCode = '62202' or zipCode = '62203' or zipCode = '62204' or zipCode = '62205' or zipCode = '62206' or zipCode = '62207' or zipCode = '62208' or zipCode = '62220' or zipCode = '62221' or zipCode = '62222' or zipCode = '62223' or zipCode = '62224' or zipCode = '62225' or zipCode = '62226' or zipCode = '62232' or zipCode = '62234' or zipCode = '62236' or zipCode = '62239' or zipCode = '62240' or zipCode = '62243' or zipCode = '62254' or zipCode = '62256' or zipCode = '62258' or zipCode = '62260' or zipCode = '62269' or zipCode = '62281' or zipCode = '62285' or zipCode = '62289' or zipCode = '62294' or zipCode = '62295' or zipCode = '62298' or zipCode = '63001' or zipCode = '63005' or zipCode = '63006' or zipCode = '63010' or zipCode = '63011' or zipCode = '63012' or zipCode = '63017' or zipCode = '63021' or zipCode = '63022' or zipCode = '63024' or zipCode = '63025' or zipCode = '63026' or zipCode = '63031' or zipCode = '63032' or zipCode = '63033' or zipCode = '63034' or zipCode = '63040' or zipCode = '63042' or zipCode = '63043' or zipCode = '63044' or zipCode = '63045' or zipCode = '63049' or zipCode = '63052' or zipCode = '63057' or zipCode = '63074' or zipCode = '63088' or zipCode = '63099' or zipCode = '63101' or zipCode = '63102' or zipCode = '63103' or zipCode = '63104' or zipCode = '63105' or zipCode = '63106' or zipCode = '63107' or zipCode = '63108' or zipCode = '63109' or zipCode = '63110' or zipCode = '63111' or zipCode = '63112' or zipCode = '63113' or zipCode = '63114' or zipCode = '63115' or zipCode = '63116' or zipCode = '63117' or zipCode = '63118' or zipCode = '63119' or zipCode = '63120' or zipCode = '63121' or zipCode = '63122' or zipCode = '63123' or zipCode = '63124' or zipCode = '63125' or zipCode = '63126' or zipCode = '63127' or zipCode = '63128' or zipCode = '63129' or zipCode = '63130' or zipCode = '63131' or zipCode = '63132' or zipCode = '63133' or zipCode = '63134' or zipCode = '63135' or zipCode = '63136' or zipCode = '63137' or zipCode = '63138' or zipCode = '63139' or zipCode = '63140' or zipCode = '63141' or zipCode = '63143' or zipCode = '63144' or zipCode = '63145' or zipCode = '63146' or zipCode = '63147' or zipCode = '63150' or zipCode = '63151' or zipCode = '63153' or zipCode = '63155' or zipCode = '63156' or zipCode = '63157' or zipCode = '63158' or zipCode = '63160' or zipCode = '63163' or zipCode = '63164' or zipCode = '63166' or zipCode = '63167' or zipCode = '63169' or zipCode = '63171' or zipCode = '63177' or zipCode = '63178' or zipCode = '63179' or zipCode = '63180' or zipCode = '63182' or zipCode = '63188' or zipCode = '63195' or zipCode = '63196' or zipCode = '63197' or zipCode = '63198' or zipCode = '63199' or zipCode = '63301' or zipCode = '63303' or zipCode = '63338' or zipCode = '63346' or zipCode = '63373' or zipCode = '63386') 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 ='62024' or zipCode = '62024' or zipCode = '62025' or zipCode = '62025' or zipCode = '62025' or zipCode = '62026' or zipCode = '62026' or zipCode = '62028' or zipCode = '62028' or zipCode = '62002' or zipCode = '62010' or zipCode = '62010' or zipCode = '62018' or zipCode = '62034' or zipCode = '62035' or zipCode = '62040' or zipCode = '62040' or zipCode = '62040' or zipCode = '62048' or zipCode = '62059' or zipCode = '62059' or zipCode = '62059' or zipCode = '62060' or zipCode = '62060' or zipCode = '62060' or zipCode = '62060' or zipCode = '62061' or zipCode = '62062' or zipCode = '62084' or zipCode = '62087' or zipCode = '62090' or zipCode = '62095' or zipCode = '62201' or zipCode = '62201' or zipCode = '62201' or zipCode = '62201' or zipCode = '62201' or zipCode = '62201' or zipCode = '62202' or zipCode = '62202' or zipCode = '62202' or zipCode = '62203' or zipCode = '62203' or zipCode = '62203' or zipCode = '62203' or zipCode = '62204' or zipCode = '62204' or zipCode = '62204' or zipCode = '62205' or zipCode = '62205' or zipCode = '62205' or zipCode = '62205' or zipCode = '62205' or zipCode = '62205' or zipCode = '62206' or zipCode = '62206' or zipCode = '62206' or zipCode = '62206' or zipCode = '62207' or zipCode = '62207' or zipCode = '62207' or zipCode = '62207' or zipCode = '62208' or zipCode = '62208' or zipCode = '62208' or zipCode = '62208' or zipCode = '62232' or zipCode = '62232' or zipCode = '62232' or zipCode = '62234' or zipCode = '62234' or zipCode = '62234' or zipCode = '62236' or zipCode = '62239' or zipCode = '62240' or zipCode = '62240' or zipCode = '62240' or zipCode = '62067' or zipCode = '62071' or zipCode = '62071' or zipCode = '62071' or zipCode = '62220' or zipCode = '62220' or zipCode = '62221' or zipCode = '62221' or zipCode = '62221' or zipCode = '62221' or zipCode = '62222' or zipCode = '62223' or zipCode = '62223' or zipCode = '62223' or zipCode = '62225' or zipCode = '62225' or zipCode = '62225' or zipCode = '62226' or zipCode = '62226' or zipCode = '62243' or zipCode = '62254' or zipCode = '62269' or zipCode = '62269' or zipCode = '62269' or zipCode = '62281' or zipCode = '62285' or zipCode = '62289' or zipCode = '62294' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62260' or zipCode = '63006' or zipCode = '63010' or zipCode = '63011' or zipCode = '63011' or zipCode = '63011' or zipCode = '63011' or zipCode = '63011' or zipCode = '63011' or zipCode = '63017' or zipCode = '63017' or zipCode = '63017' or zipCode = '63017' or zipCode = '63021' or zipCode = '63021' or zipCode = '63021' or zipCode = '63021' or zipCode = '63021' or zipCode = '63021' or zipCode = '63021' or zipCode = '63022' or zipCode = '63024' or zipCode = '63025' or zipCode = '63025' or zipCode = '63025' or zipCode = '63040' or zipCode = '63042' or zipCode = '63042' or zipCode = '63042' or zipCode = '63043' or zipCode = '63043' or zipCode = '63043' or zipCode = '63044' or zipCode = '63044' or zipCode = '63044' or zipCode = '63045' or zipCode = '63045' or zipCode = '63045' or zipCode = '63049' or zipCode = '63052' or zipCode = '63052' or zipCode = '63052' or zipCode = '63052' or zipCode = '63074' or zipCode = '63074' or zipCode = '63074' or zipCode = '63074' or zipCode = '63074' or zipCode = '63088' or zipCode = '63088' or zipCode = '63088' or zipCode = '63025' or zipCode = '63025' or zipCode = '63026' or zipCode = '63026' or zipCode = '63031' or zipCode = '63031' or zipCode = '63032' or zipCode = '63033' or zipCode = '63033' or zipCode = '63034' or zipCode = '63040' or zipCode = '63040' or zipCode = '63040' or zipCode = '63052' or zipCode = '63053' or zipCode = '63053' or zipCode = '63057' or zipCode = '63099' or zipCode = '63099' or zipCode = '63101' or zipCode = '63102' or zipCode = '63103' or zipCode = '63104' or zipCode = '63105' or zipCode = '63105' or zipCode = '63105' or zipCode = '63106' or zipCode = '63107' or zipCode = '63108' or zipCode = '63109' or zipCode = '63110' or zipCode = '63111' or zipCode = '63112' or zipCode = '63112' or zipCode = '63113' or zipCode = '63113' or zipCode = '63114' or zipCode = '63114' or zipCode = '63114' or zipCode = '63121' or zipCode = '63121' or zipCode = '63121' or zipCode = '63121' or zipCode = '63121' or zipCode = '63121' or zipCode = '63121' or zipCode = '63122' or zipCode = '63122' or zipCode = '63122' or zipCode = '63122' or zipCode = '63122' or zipCode = '63122' or zipCode = '63123' or zipCode = '63123' or zipCode = '63124' or zipCode = '63124' or zipCode = '63124' or zipCode = '63124' or zipCode = '63125' or zipCode = '63125' or zipCode = '63125' or zipCode = '63125' or zipCode = '63126' or zipCode = '63126' or zipCode = '63126' or zipCode = '63127' or zipCode = '63127' or zipCode = '63127' or zipCode = '63128' or zipCode = '63128' or zipCode = '63129' or zipCode = '63129' or zipCode = '63129' or zipCode = '63130' or zipCode = '63130' or zipCode = '63130' or zipCode = '63130' or zipCode = '63130' or zipCode = '63131' or zipCode = '63131' or zipCode = '63131' or zipCode = '63131' or zipCode = '63131' or zipCode = '63131' or zipCode = '63132' or zipCode = '63132' or zipCode = '63132' or zipCode = '63133' or zipCode = '63133' or zipCode = '63133' or zipCode = '63133' or zipCode = '63133' or zipCode = '63134' or zipCode = '63134' or zipCode = '63134' or zipCode = '63134' or zipCode = '63135' or zipCode = '63135' or zipCode = '63135' or zipCode = '63135' or zipCode = '63135' or zipCode = '63135' or zipCode = '63136' or zipCode = '63136' or zipCode = '63136' or zipCode = '63136' or zipCode = '63136' or zipCode = '63136' or zipCode = '63114' or zipCode = '63114' or zipCode = '63114' or zipCode = '63114' or zipCode = '63115' or zipCode = '63116' or zipCode = '63117' or zipCode = '63117' or zipCode = '63117' or zipCode = '63118' or zipCode = '63119' or zipCode = '63119' or zipCode = '63119' or zipCode = '63119' or zipCode = '63119' or zipCode = '63120' or zipCode = '63120' or zipCode = '63120' or zipCode = '63121' or zipCode = '63121' or zipCode = '63121' or zipCode = '63121' or zipCode = '63136' or zipCode = '63137' or zipCode = '63137' or zipCode = '63137' or zipCode = '63137' or zipCode = '63137' or zipCode = '63138' or zipCode = '63138' or zipCode = '63138' or zipCode = '63139' or zipCode = '63140' or zipCode = '63140' or zipCode = '63140' or zipCode = '63141' or zipCode = '63141' or zipCode = '63143' or zipCode = '63143' or zipCode = '63144' or zipCode = '63144' or zipCode = '63145' or zipCode = '63145' or zipCode = '63145' or zipCode = '63145' or zipCode = '63146' or zipCode = '63146' or zipCode = '63147' or zipCode = '63150' or zipCode = '63150' or zipCode = '63151' or zipCode = '63155' or zipCode = '63156' or zipCode = '63157' or zipCode = '63158' or zipCode = '63160' or zipCode = '63160' or zipCode = '63163' or zipCode = '63164' or zipCode = '63164' or zipCode = '63166' or zipCode = '63167' or zipCode = '63167' or zipCode = '63169' or zipCode = '63171' or zipCode = '63171' or zipCode = '63301' or zipCode = '63301' or zipCode = '63301' or zipCode = '63301' or zipCode = '63302' or zipCode = '63303' or zipCode = '63303' or zipCode = '63303' or zipCode = '63303' or zipCode = '63373' or zipCode = '63177' or zipCode = '63178' or zipCode = '63179' or zipCode = '63180' or zipCode = '63180' or zipCode = '63182' or zipCode = '63182' or zipCode = '63188' or zipCode = '63190' or zipCode = '63190' or zipCode = '63195' or zipCode = '63195' or zipCode = '63195' or zipCode = '63197' or zipCode = '63197' or zipCode = '63198' or zipCode = '63198' or zipCode = '63199' or zipCode = '63199' or zipCode = '63301' or zipCode = '63301' or zipCode = '63301' or zipCode = '63373' or zipCode = '63373' or zipCode = '63373' or zipCode = '63386' or zipCode = '62002' or zipCode = '62010' or zipCode = '62018' or zipCode = '62024' or zipCode = '62025' or zipCode = '62026' or zipCode = '62028' or zipCode = '62034' or zipCode = '62035' or zipCode = '62040' or zipCode = '62048' or zipCode = '62059' or zipCode = '62060' or zipCode = '62062' or zipCode = '62067' or zipCode = '62071' or zipCode = '62084' or zipCode = '62087' or zipCode = '62090' or zipCode = '62095' or zipCode = '62201' or zipCode = '62202' or zipCode = '62203' or zipCode = '62204' or zipCode = '62205' or zipCode = '62206' or zipCode = '62207' or zipCode = '62208' or zipCode = '62220' or zipCode = '62221' or zipCode = '62222' or zipCode = '62223' or zipCode = '62224' or zipCode = '62225' or zipCode = '62226' or zipCode = '62232' or zipCode = '62234' or zipCode = '62236' or zipCode = '62239' or zipCode = '62240' or zipCode = '62243' or zipCode = '62254' or zipCode = '62256' or zipCode = '62258' or zipCode = '62260' or zipCode = '62269' or zipCode = '62281' or zipCode = '62285' or zipCode = '62289' or zipCode = '62294' or zipCode = '62295' or zipCode = '62298' or zipCode = '63001' or zipCode = '63005' or zipCode = '63006' or zipCode = '63010' or zipCode = '63011' or zipCode = '63012' or zipCode = '63017' or zipCode = '63021' or zipCode = '63022' or zipCode = '63024' or zipCode = '63025' or zipCode = '63026' or zipCode = '63031' or zipCode = '63032' or zipCode = '63033' or zipCode = '63034' or zipCode = '63040' or zipCode = '63042' or zipCode = '63043' or zipCode = '63044' or zipCode = '63045' or zipCode = '63049' or zipCode = '63052' or zipCode = '63057' or zipCode = '63074' or zipCode = '63088' or zipCode = '63099' or zipCode = '63101' or zipCode = '63102' or zipCode = '63103' or zipCode = '63104' or zipCode = '63105' or zipCode = '63106' or zipCode = '63107' or zipCode = '63108' or zipCode = '63109' or zipCode = '63110' or zipCode = '63111' or zipCode = '63112' or zipCode = '63113' or zipCode = '63114' or zipCode = '63115' or zipCode = '63116' or zipCode = '63117' or zipCode = '63118' or zipCode = '63119' or zipCode = '63120' or zipCode = '63121' or zipCode = '63122' or zipCode = '63123' or zipCode = '63124' or zipCode = '63125' or zipCode = '63126' or zipCode = '63127' or zipCode = '63128' or zipCode = '63129' or zipCode = '63130' or zipCode = '63131' or zipCode = '63132' or zipCode = '63133' or zipCode = '63134' or zipCode = '63135' or zipCode = '63136' or zipCode = '63137' or zipCode = '63138' or zipCode = '63139' or zipCode = '63140' or zipCode = '63141' or zipCode = '63143' or zipCode = '63144' or zipCode = '63145' or zipCode = '63146' or zipCode = '63147' or zipCode = '63150' or zipCode = '63151' or zipCode = '63153' or zipCode = '63155' or zipCode = '63156' or zipCode = '63157' or zipCode = '63158' or zipCode = '63160' or zipCode = '63163' or zipCode = '63164' or zipCode = '63166' or zipCode = '63167' or zipCode = '63169' or zipCode = '63171' or zipCode = '63177' or zipCode = '63178' or zipCode = '63179' or zipCode = '63180' or zipCode = '63182' or zipCode = '63188' or zipCode = '63195' or zipCode = '63196' or zipCode = '63197' or zipCode = '63198' or zipCode = '63199' or zipCode = '63301' or zipCode = '63303' or zipCode = '63338' or zipCode = '63346' or zipCode = '63373' or zipCode = '63386') 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 ='62024' or zipCode = '62024' or zipCode = '62025' or zipCode = '62025' or zipCode = '62025' or zipCode = '62026' or zipCode = '62026' or zipCode = '62028' or zipCode = '62028' or zipCode = '62002' or zipCode = '62010' or zipCode = '62010' or zipCode = '62018' or zipCode = '62034' or zipCode = '62035' or zipCode = '62040' or zipCode = '62040' or zipCode = '62040' or zipCode = '62048' or zipCode = '62059' or zipCode = '62059' or zipCode = '62059' or zipCode = '62060' or zipCode = '62060' or zipCode = '62060' or zipCode = '62060' or zipCode = '62061' or zipCode = '62062' or zipCode = '62084' or zipCode = '62087' or zipCode = '62090' or zipCode = '62095' or zipCode = '62201' or zipCode = '62201' or zipCode = '62201' or zipCode = '62201' or zipCode = '62201' or zipCode = '62201' or zipCode = '62202' or zipCode = '62202' or zipCode = '62202' or zipCode = '62203' or zipCode = '62203' or zipCode = '62203' or zipCode = '62203' or zipCode = '62204' or zipCode = '62204' or zipCode = '62204' or zipCode = '62205' or zipCode = '62205' or zipCode = '62205' or zipCode = '62205' or zipCode = '62205' or zipCode = '62205' or zipCode = '62206' or zipCode = '62206' or zipCode = '62206' or zipCode = '62206' or zipCode = '62207' or zipCode = '62207' or zipCode = '62207' or zipCode = '62207' or zipCode = '62208' or zipCode = '62208' or zipCode = '62208' or zipCode = '62208' or zipCode = '62232' or zipCode = '62232' or zipCode = '62232' or zipCode = '62234' or zipCode = '62234' or zipCode = '62234' or zipCode = '62236' or zipCode = '62239' or zipCode = '62240' or zipCode = '62240' or zipCode = '62240' or zipCode = '62067' or zipCode = '62071' or zipCode = '62071' or zipCode = '62071' or zipCode = '62220' or zipCode = '62220' or zipCode = '62221' or zipCode = '62221' or zipCode = '62221' or zipCode = '62221' or zipCode = '62222' or zipCode = '62223' or zipCode = '62223' or zipCode = '62223' or zipCode = '62225' or zipCode = '62225' or zipCode = '62225' or zipCode = '62226' or zipCode = '62226' or zipCode = '62243' or zipCode = '62254' or zipCode = '62269' or zipCode = '62269' or zipCode = '62269' or zipCode = '62281' or zipCode = '62285' or zipCode = '62289' or zipCode = '62294' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62298' or zipCode = '62260' or zipCode = '63006' or zipCode = '63010' or zipCode = '63011' or zipCode = '63011' or zipCode = '63011' or zipCode = '63011' or zipCode = '63011' or zipCode = '63011' or zipCode = '63017' or zipCode = '63017' or zipCode = '63017' or zipCode = '63017' or zipCode = '63021' or zipCode = '63021' or zipCode = '63021' or zipCode = '63021' or zipCode = '63021' or zipCode = '63021' or zipCode = '63021' or zipCode = '63022' or zipCode = '63024' or zipCode = '63025' or zipCode = '63025' or zipCode = '63025' or zipCode = '63040' or zipCode = '63042' or zipCode = '63042' or zipCode = '63042' or zipCode = '63043' or zipCode = '63043' or zipCode = '63043' or zipCode = '63044' or zipCode = '63044' or zipCode = '63044' or zipCode = '63045' or zipCode = '63045' or zipCode = '63045' or zipCode = '63049' or zipCode = '63052' or zipCode = '63052' or zipCode = '63052' or zipCode = '63052' or zipCode = '63074' or zipCode = '63074' or zipCode = '63074' or zipCode = '63074' or zipCode = '63074' or zipCode = '63088' or zipCode = '63088' or zipCode = '63088' or zipCode = '63025' or zipCode = '63025' or zipCode = '63026' or zipCode = '63026' or zipCode = '63031' or zipCode = '63031' or zipCode = '63032' or zipCode = '63033' or zipCode = '63033' or zipCode = '63034' or zipCode = '63040' or zipCode = '63040' or zipCode = '63040' or zipCode = '63052' or zipCode = '63053' or zipCode = '63053' or zipCode = '63057' or zipCode = '63099' or zipCode = '63099' or zipCode = '63101' or zipCode = '63102' or zipCode = '63103' or zipCode = '63104' or zipCode = '63105' or zipCode = '63105' or zipCode = '63105' or zipCode = '63106' or zipCode = '63107' or zipCode = '63108' or zipCode = '63109' or zipCode = '63110' or zipCode = '63111' or zipCode = '63112' or zipCode = '63112' or zipCode = '63113' or zipCode = '63113' or zipCode = '63114' or zipCode = '63114' or zipCode = '63114' or zipCode = '63121' or zipCode = '63121' or zipCode = '63121' or zipCode = '63121' or zipCode = '63121' or zipCode = '63121' or zipCode = '63121' or zipCode = '63122' or zipCode = '63122' or zipCode = '63122' or zipCode = '63122' or zipCode = '63122' or zipCode = '63122' or zipCode = '63123' or zipCode = '63123' or zipCode = '63124' or zipCode = '63124' or zipCode = '63124' or zipCode = '63124' or zipCode = '63125' or zipCode = '63125' or zipCode = '63125' or zipCode = '63125' or zipCode = '63126' or zipCode = '63126' or zipCode = '63126' or zipCode = '63127' or zipCode = '63127' or zipCode = '63127' or zipCode = '63128' or zipCode = '63128' or zipCode = '63129' or zipCode = '63129' or zipCode = '63129' or zipCode = '63130' or zipCode = '63130' or zipCode = '63130' or zipCode = '63130' or zipCode = '63130' or zipCode = '63131' or zipCode = '63131' or zipCode = '63131' or zipCode = '63131' or zipCode = '63131' or zipCode = '63131' or zipCode = '63132' or zipCode = '63132' or zipCode = '63132' or zipCode = '63133' or zipCode = '63133' or zipCode = '63133' or zipCode = '63133' or zipCode = '63133' or zipCode = '63134' or zipCode = '63134' or zipCode = '63134' or zipCode = '63134' or zipCode = '63135' or zipCode = '63135' or zipCode = '63135' or zipCode = '63135' or zipCode = '63135' or zipCode = '63135' or zipCode = '63136' or zipCode = '63136' or zipCode = '63136' or zipCode = '63136' or zipCode = '63136' or zipCode = '63136' or zipCode = '63114' or zipCode = '63114' or zipCode = '63114' or zipCode = '63114' or zipCode = '63115' or zipCode = '63116' or zipCode = '63117' or zipCode = '63117' or zipCode = '63117' or zipCode = '63118' or zipCode = '63119' or zipCode = '63119' or zipCode = '63119' or zipCode = '63119' or zipCode = '63119' or zipCode = '63120' or zipCode = '63120' or zipCode = '63120' or zipCode = '63121' or zipCode = '63121' or zipCode = '63121' or zipCode = '63121' or zipCode = '63136' or zipCode = '63137' or zipCode = '63137' or zipCode = '63137' or zipCode = '63137' or zipCode = '63137' or zipCode = '63138' or zipCode = '63138' or zipCode = '63138' or zipCode = '63139' or zipCode = '63140' or zipCode = '63140' or zipCode = '63140' or zipCode = '63141' or zipCode = '63141' or zipCode = '63143' or zipCode = '63143' or zipCode = '63144' or zipCode = '63144' or zipCode = '63145' or zipCode = '63145' or zipCode = '63145' or zipCode = '63145' or zipCode = '63146' or zipCode = '63146' or zipCode = '63147' or zipCode = '63150' or zipCode = '63150' or zipCode = '63151' or zipCode = '63155' or zipCode = '63156' or zipCode = '63157' or zipCode = '63158' or zipCode = '63160' or zipCode = '63160' or zipCode = '63163' or zipCode = '63164' or zipCode = '63164' or zipCode = '63166' or zipCode = '63167' or zipCode = '63167' or zipCode = '63169' or zipCode = '63171' or zipCode = '63171' or zipCode = '63301' or zipCode = '63301' or zipCode = '63301' or zipCode = '63301' or zipCode = '63302' or zipCode = '63303' or zipCode = '63303' or zipCode = '63303' or zipCode = '63303' or zipCode = '63373' or zipCode = '63177' or zipCode = '63178' or zipCode = '63179' or zipCode = '63180' or zipCode = '63180' or zipCode = '63182' or zipCode = '63182' or zipCode = '63188' or zipCode = '63190' or zipCode = '63190' or zipCode = '63195' or zipCode = '63195' or zipCode = '63195' or zipCode = '63197' or zipCode = '63197' or zipCode = '63198' or zipCode = '63198' or zipCode = '63199' or zipCode = '63199' or zipCode = '63301' or zipCode = '63301' or zipCode = '63301' or zipCode = '63373' or zipCode = '63373' or zipCode = '63373' or zipCode = '63386' or zipCode = '62002' or zipCode = '62010' or zipCode = '62018' or zipCode = '62024' or zipCode = '62025' or zipCode = '62026' or zipCode = '62028' or zipCode = '62034' or zipCode = '62035' or zipCode = '62040' or zipCode = '62048' or zipCode = '62059' or zipCode = '62060' or zipCode = '62062' or zipCode = '62067' or zipCode = '62071' or zipCode = '62084' or zipCode = '62087' or zipCode = '62090' or zipCode = '62095' or zipCode = '62201' or zipCode = '62202' or zipCode = '62203' or zipCode = '62204' or zipCode = '62205' or zipCode = '62206' or zipCode = '62207' or zipCode = '62208' or zipCode = '62220' or zipCode = '62221' or zipCode = '62222' or zipCode = '62223' or zipCode = '62224' or zipCode = '62225' or zipCode = '62226' or zipCode = '62232' or zipCode = '62234' or zipCode = '62236' or zipCode = '62239' or zipCode = '62240' or zipCode = '62243' or zipCode = '62254' or zipCode = '62256' or zipCode = '62258' or zipCode = '62260' or zipCode = '62269' or zipCode = '62281' or zipCode = '62285' or zipCode = '62289' or zipCode = '62294' or zipCode = '62295' or zipCode = '62298' or zipCode = '63001' or zipCode = '63005' or zipCode = '63006' or zipCode = '63010' or zipCode = '63011' or zipCode = '63012' or zipCode = '63017' or zipCode = '63021' or zipCode = '63022' or zipCode = '63024' or zipCode = '63025' or zipCode = '63026' or zipCode = '63031' or zipCode = '63032' or zipCode = '63033' or zipCode = '63034' or zipCode = '63040' or zipCode = '63042' or zipCode = '63043' or zipCode = '63044' or zipCode = '63045' or zipCode = '63049' or zipCode = '63052' or zipCode = '63057' or zipCode = '63074' or zipCode = '63088' or zipCode = '63099' or zipCode = '63101' or zipCode = '63102' or zipCode = '63103' or zipCode = '63104' or zipCode = '63105' or zipCode = '63106' or zipCode = '63107' or zipCode = '63108' or zipCode = '63109' or zipCode = '63110' or zipCode = '63111' or zipCode = '63112' or zipCode = '63113' or zipCode = '63114' or zipCode = '63115' or zipCode = '63116' or zipCode = '63117' or zipCode = '63118' or zipCode = '63119' or zipCode = '63120' or zipCode = '63121' or zipCode = '63122' or zipCode = '63123' or zipCode = '63124' or zipCode = '63125' or zipCode = '63126' or zipCode = '63127' or zipCode = '63128' or zipCode = '63129' or zipCode = '63130' or zipCode = '63131' or zipCode = '63132' or zipCode = '63133' or zipCode = '63134' or zipCode = '63135' or zipCode = '63136' or zipCode = '63137' or zipCode = '63138' or zipCode = '63139' or zipCode = '63140' or zipCode = '63141' or zipCode = '63143' or zipCode = '63144' or zipCode = '63145' or zipCode = '63146' or zipCode = '63147' or zipCode = '63150' or zipCode = '63151' or zipCode = '63153' or zipCode = '63155' or zipCode = '63156' or zipCode = '63157' or zipCode = '63158' or zipCode = '63160' or zipCode = '63163' or zipCode = '63164' or zipCode = '63166' or zipCode = '63167' or zipCode = '63169' or zipCode = '63171' or zipCode = '63177' or zipCode = '63178' or zipCode = '63179' or zipCode = '63180' or zipCode = '63182' or zipCode = '63188' or zipCode = '63195' or zipCode = '63196' or zipCode = '63197' or zipCode = '63198' or zipCode = '63199' or zipCode = '63301' or zipCode = '63303' or zipCode = '63338' or zipCode = '63346' or zipCode = '63373' or zipCode = '63386') 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 ='62024' or property_zip = '62024' or property_zip = '62025' or property_zip = '62025' or property_zip = '62025' or property_zip = '62026' or property_zip = '62026' or property_zip = '62028' or property_zip = '62028' or property_zip = '62002' or property_zip = '62010' or property_zip = '62010' or property_zip = '62018' or property_zip = '62034' or property_zip = '62035' or property_zip = '62040' or property_zip = '62040' or property_zip = '62040' or property_zip = '62048' or property_zip = '62059' or property_zip = '62059' or property_zip = '62059' or property_zip = '62060' or property_zip = '62060' or property_zip = '62060' or property_zip = '62060' or property_zip = '62061' or property_zip = '62062' or property_zip = '62084' or property_zip = '62087' or property_zip = '62090' or property_zip = '62095' or property_zip = '62201' or property_zip = '62201' or property_zip = '62201' or property_zip = '62201' or property_zip = '62201' or property_zip = '62201' or property_zip = '62202' or property_zip = '62202' or property_zip = '62202' or property_zip = '62203' or property_zip = '62203' or property_zip = '62203' or property_zip = '62203' or property_zip = '62204' or property_zip = '62204' or property_zip = '62204' or property_zip = '62205' or property_zip = '62205' or property_zip = '62205' or property_zip = '62205' or property_zip = '62205' or property_zip = '62205' or property_zip = '62206' or property_zip = '62206' or property_zip = '62206' or property_zip = '62206' or property_zip = '62207' or property_zip = '62207' or property_zip = '62207' or property_zip = '62207' or property_zip = '62208' or property_zip = '62208' or property_zip = '62208' or property_zip = '62208' or property_zip = '62232' or property_zip = '62232' or property_zip = '62232' or property_zip = '62234' or property_zip = '62234' or property_zip = '62234' or property_zip = '62236' or property_zip = '62239' or property_zip = '62240' or property_zip = '62240' or property_zip = '62240' or property_zip = '62067' or property_zip = '62071' or property_zip = '62071' or property_zip = '62071' or property_zip = '62220' or property_zip = '62220' or property_zip = '62221' or property_zip = '62221' or property_zip = '62221' or property_zip = '62221' or property_zip = '62222' or property_zip = '62223' or property_zip = '62223' or property_zip = '62223' or property_zip = '62225' or property_zip = '62225' or property_zip = '62225' or property_zip = '62226' or property_zip = '62226' or property_zip = '62243' or property_zip = '62254' or property_zip = '62269' or property_zip = '62269' or property_zip = '62269' or property_zip = '62281' or property_zip = '62285' or property_zip = '62289' or property_zip = '62294' or property_zip = '62298' or property_zip = '62298' or property_zip = '62298' or property_zip = '62298' or property_zip = '62298' or property_zip = '62298' or property_zip = '62298' or property_zip = '62298' or property_zip = '62298' or property_zip = '62298' or property_zip = '62298' or property_zip = '62298' or property_zip = '62298' or property_zip = '62260' or property_zip = '63006' or property_zip = '63010' or property_zip = '63011' or property_zip = '63011' or property_zip = '63011' or property_zip = '63011' or property_zip = '63011' or property_zip = '63011' or property_zip = '63017' or property_zip = '63017' or property_zip = '63017' or property_zip = '63017' or property_zip = '63021' or property_zip = '63021' or property_zip = '63021' or property_zip = '63021' or property_zip = '63021' or property_zip = '63021' or property_zip = '63021' or property_zip = '63022' or property_zip = '63024' or property_zip = '63025' or property_zip = '63025' or property_zip = '63025' or property_zip = '63040' or property_zip = '63042' or property_zip = '63042' or property_zip = '63042' or property_zip = '63043' or property_zip = '63043' or property_zip = '63043' or property_zip = '63044' or property_zip = '63044' or property_zip = '63044' or property_zip = '63045' or property_zip = '63045' or property_zip = '63045' or property_zip = '63049' or property_zip = '63052' or property_zip = '63052' or property_zip = '63052' or property_zip = '63052' or property_zip = '63074' or property_zip = '63074' or property_zip = '63074' or property_zip = '63074' or property_zip = '63074' or property_zip = '63088' or property_zip = '63088' or property_zip = '63088' or property_zip = '63025' or property_zip = '63025' or property_zip = '63026' or property_zip = '63026' or property_zip = '63031' or property_zip = '63031' or property_zip = '63032' or property_zip = '63033' or property_zip = '63033' or property_zip = '63034' or property_zip = '63040' or property_zip = '63040' or property_zip = '63040' or property_zip = '63052' or property_zip = '63053' or property_zip = '63053' or property_zip = '63057' or property_zip = '63099' or property_zip = '63099' or property_zip = '63101' or property_zip = '63102' or property_zip = '63103' or property_zip = '63104' or property_zip = '63105' or property_zip = '63105' or property_zip = '63105' or property_zip = '63106' or property_zip = '63107' or property_zip = '63108' or property_zip = '63109' or property_zip = '63110' or property_zip = '63111' or property_zip = '63112' or property_zip = '63112' or property_zip = '63113' or property_zip = '63113' or property_zip = '63114' or property_zip = '63114' or property_zip = '63114' or property_zip = '63121' or property_zip = '63121' or property_zip = '63121' or property_zip = '63121' or property_zip = '63121' or property_zip = '63121' or property_zip = '63121' or property_zip = '63122' or property_zip = '63122' or property_zip = '63122' or property_zip = '63122' or property_zip = '63122' or property_zip = '63122' or property_zip = '63123' or property_zip = '63123' or property_zip = '63124' or property_zip = '63124' or property_zip = '63124' or property_zip = '63124' or property_zip = '63125' or property_zip = '63125' or property_zip = '63125' or property_zip = '63125' or property_zip = '63126' or property_zip = '63126' or property_zip = '63126' or property_zip = '63127' or property_zip = '63127' or property_zip = '63127' or property_zip = '63128' or property_zip = '63128' or property_zip = '63129' or property_zip = '63129' or property_zip = '63129' or property_zip = '63130' or property_zip = '63130' or property_zip = '63130' or property_zip = '63130' or property_zip = '63130' or property_zip = '63131' or property_zip = '63131' or property_zip = '63131' or property_zip = '63131' or property_zip = '63131' or property_zip = '63131' or property_zip = '63132' or property_zip = '63132' or property_zip = '63132' or property_zip = '63133' or property_zip = '63133' or property_zip = '63133' or property_zip = '63133' or property_zip = '63133' or property_zip = '63134' or property_zip = '63134' or property_zip = '63134' or property_zip = '63134' or property_zip = '63135' or property_zip = '63135' or property_zip = '63135' or property_zip = '63135' or property_zip = '63135' or property_zip = '63135' or property_zip = '63136' or property_zip = '63136' or property_zip = '63136' or property_zip = '63136' or property_zip = '63136' or property_zip = '63136' or property_zip = '63114' or property_zip = '63114' or property_zip = '63114' or property_zip = '63114' or property_zip = '63115' or property_zip = '63116' or property_zip = '63117' or property_zip = '63117' or property_zip = '63117' or property_zip = '63118' or property_zip = '63119' or property_zip = '63119' or property_zip = '63119' or property_zip = '63119' or property_zip = '63119' or property_zip = '63120' or property_zip = '63120' or property_zip = '63120' or property_zip = '63121' or property_zip = '63121' or property_zip = '63121' or property_zip = '63121' or property_zip = '63136' or property_zip = '63137' or property_zip = '63137' or property_zip = '63137' or property_zip = '63137' or property_zip = '63137' or property_zip = '63138' or property_zip = '63138' or property_zip = '63138' or property_zip = '63139' or property_zip = '63140' or property_zip = '63140' or property_zip = '63140' or property_zip = '63141' or property_zip = '63141' or property_zip = '63143' or property_zip = '63143' or property_zip = '63144' or property_zip = '63144' or property_zip = '63145' or property_zip = '63145' or property_zip = '63145' or property_zip = '63145' or property_zip = '63146' or property_zip = '63146' or property_zip = '63147' or property_zip = '63150' or property_zip = '63150' or property_zip = '63151' or property_zip = '63155' or property_zip = '63156' or property_zip = '63157' or property_zip = '63158' or property_zip = '63160' or property_zip = '63160' or property_zip = '63163' or property_zip = '63164' or property_zip = '63164' or property_zip = '63166' or property_zip = '63167' or property_zip = '63167' or property_zip = '63169' or property_zip = '63171' or property_zip = '63171' or property_zip = '63301' or property_zip = '63301' or property_zip = '63301' or property_zip = '63301' or property_zip = '63302' or property_zip = '63303' or property_zip = '63303' or property_zip = '63303' or property_zip = '63303' or property_zip = '63373' or property_zip = '63177' or property_zip = '63178' or property_zip = '63179' or property_zip = '63180' or property_zip = '63180' or property_zip = '63182' or property_zip = '63182' or property_zip = '63188' or property_zip = '63190' or property_zip = '63190' or property_zip = '63195' or property_zip = '63195' or property_zip = '63195' or property_zip = '63197' or property_zip = '63197' or property_zip = '63198' or property_zip = '63198' or property_zip = '63199' or property_zip = '63199' or property_zip = '63301' or property_zip = '63301' or property_zip = '63301' or property_zip = '63373' or property_zip = '63373' or property_zip = '63373' or property_zip = '63386' or property_zip = '62002' or property_zip = '62010' or property_zip = '62018' or property_zip = '62024' or property_zip = '62025' or property_zip = '62026' or property_zip = '62028' or property_zip = '62034' or property_zip = '62035' or property_zip = '62040' or property_zip = '62048' or property_zip = '62059' or property_zip = '62060' or property_zip = '62062' or property_zip = '62067' or property_zip = '62071' or property_zip = '62084' or property_zip = '62087' or property_zip = '62090' or property_zip = '62095' or property_zip = '62201' or property_zip = '62202' or property_zip = '62203' or property_zip = '62204' or property_zip = '62205' or property_zip = '62206' or property_zip = '62207' or property_zip = '62208' or property_zip = '62220' or property_zip = '62221' or property_zip = '62222' or property_zip = '62223' or property_zip = '62224' or property_zip = '62225' or property_zip = '62226' or property_zip = '62232' or property_zip = '62234' or property_zip = '62236' or property_zip = '62239' or property_zip = '62240' or property_zip = '62243' or property_zip = '62254' or property_zip = '62256' or property_zip = '62258' or property_zip = '62260' or property_zip = '62269' or property_zip = '62281' or property_zip = '62285' or property_zip = '62289' or property_zip = '62294' or property_zip = '62295' or property_zip = '62298' or property_zip = '63001' or property_zip = '63005' or property_zip = '63006' or property_zip = '63010' or property_zip = '63011' or property_zip = '63012' or property_zip = '63017' or property_zip = '63021' or property_zip = '63022' or property_zip = '63024' or property_zip = '63025' or property_zip = '63026' or property_zip = '63031' or property_zip = '63032' or property_zip = '63033' or property_zip = '63034' or property_zip = '63040' or property_zip = '63042' or property_zip = '63043' or property_zip = '63044' or property_zip = '63045' or property_zip = '63049' or property_zip = '63052' or property_zip = '63057' or property_zip = '63074' or property_zip = '63088' or property_zip = '63099' or property_zip = '63101' or property_zip = '63102' or property_zip = '63103' or property_zip = '63104' or property_zip = '63105' or property_zip = '63106' or property_zip = '63107' or property_zip = '63108' or property_zip = '63109' or property_zip = '63110' or property_zip = '63111' or property_zip = '63112' or property_zip = '63113' or property_zip = '63114' or property_zip = '63115' or property_zip = '63116' or property_zip = '63117' or property_zip = '63118' or property_zip = '63119' or property_zip = '63120' or property_zip = '63121' or property_zip = '63122' or property_zip = '63123' or property_zip = '63124' or property_zip = '63125' or property_zip = '63126' or property_zip = '63127' or property_zip = '63128' or property_zip = '63129' or property_zip = '63130' or property_zip = '63131' or property_zip = '63132' or property_zip = '63133' or property_zip = '63134' or property_zip = '63135' or property_zip = '63136' or property_zip = '63137' or property_zip = '63138' or property_zip = '63139' or property_zip = '63140' or property_zip = '63141' or property_zip = '63143' or property_zip = '63144' or property_zip = '63145' or property_zip = '63146' or property_zip = '63147' or property_zip = '63150' or property_zip = '63151' or property_zip = '63153' or property_zip = '63155' or property_zip = '63156' or property_zip = '63157' or property_zip = '63158' or property_zip = '63160' or property_zip = '63163' or property_zip = '63164' or property_zip = '63166' or property_zip = '63167' or property_zip = '63169' or property_zip = '63171' or property_zip = '63177' or property_zip = '63178' or property_zip = '63179' or property_zip = '63180' or property_zip = '63182' or property_zip = '63188' or property_zip = '63195' or property_zip = '63196' or property_zip = '63197' or property_zip = '63198' or property_zip = '63199' or property_zip = '63301' or property_zip = '63303' or property_zip = '63338' or property_zip = '63346' or property_zip = '63373' or property_zip = '63386') and convert(date,auction_start_date) >= '9/27/2021';
select top 45 * from currentforeclosures.tblAll NOLOCK where state = 'MO '
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 ='62024' or zip = '62024' or zip = '62025' or zip = '62025' or zip = '62025' or zip = '62026' or zip = '62026' or zip = '62028' or zip = '62028' or zip = '62002' or zip = '62010' or zip = '62010' or zip = '62018' or zip = '62034' or zip = '62035' or zip = '62040' or zip = '62040' or zip = '62040' or zip = '62048' or zip = '62059' or zip = '62059' or zip = '62059' or zip = '62060' or zip = '62060' or zip = '62060' or zip = '62060' or zip = '62061' or zip = '62062' or zip = '62084' or zip = '62087' or zip = '62090' or zip = '62095' or zip = '62201' or zip = '62201' or zip = '62201' or zip = '62201' or zip = '62201' or zip = '62201' or zip = '62202' or zip = '62202' or zip = '62202' or zip = '62203' or zip = '62203' or zip = '62203' or zip = '62203' or zip = '62204' or zip = '62204' or zip = '62204' or zip = '62205' or zip = '62205' or zip = '62205' or zip = '62205' or zip = '62205' or zip = '62205' or zip = '62206' or zip = '62206' or zip = '62206' or zip = '62206' or zip = '62207' or zip = '62207' or zip = '62207' or zip = '62207' or zip = '62208' or zip = '62208' or zip = '62208' or zip = '62208' or zip = '62232' or zip = '62232' or zip = '62232' or zip = '62234' or zip = '62234' or zip = '62234' or zip = '62236' or zip = '62239' or zip = '62240' or zip = '62240' or zip = '62240' or zip = '62067' or zip = '62071' or zip = '62071' or zip = '62071' or zip = '62220' or zip = '62220' or zip = '62221' or zip = '62221' or zip = '62221' or zip = '62221' or zip = '62222' or zip = '62223' or zip = '62223' or zip = '62223' or zip = '62225' or zip = '62225' or zip = '62225' or zip = '62226' or zip = '62226' or zip = '62243' or zip = '62254' or zip = '62269' or zip = '62269' or zip = '62269' or zip = '62281' or zip = '62285' or zip = '62289' or zip = '62294' or zip = '62298' or zip = '62298' or zip = '62298' or zip = '62298' or zip = '62298' or zip = '62298' or zip = '62298' or zip = '62298' or zip = '62298' or zip = '62298' or zip = '62298' or zip = '62298' or zip = '62298' or zip = '62260' or zip = '63006' or zip = '63010' or zip = '63011' or zip = '63011' or zip = '63011' or zip = '63011' or zip = '63011' or zip = '63011' or zip = '63017' or zip = '63017' or zip = '63017' or zip = '63017' or zip = '63021' or zip = '63021' or zip = '63021' or zip = '63021' or zip = '63021' or zip = '63021' or zip = '63021' or zip = '63022' or zip = '63024' or zip = '63025' or zip = '63025' or zip = '63025' or zip = '63040' or zip = '63042' or zip = '63042' or zip = '63042' or zip = '63043' or zip = '63043' or zip = '63043' or zip = '63044' or zip = '63044' or zip = '63044' or zip = '63045' or zip = '63045' or zip = '63045' or zip = '63049' or zip = '63052' or zip = '63052' or zip = '63052' or zip = '63052' or zip = '63074' or zip = '63074' or zip = '63074' or zip = '63074' or zip = '63074' or zip = '63088' or zip = '63088' or zip = '63088' or zip = '63025' or zip = '63025' or zip = '63026' or zip = '63026' or zip = '63031' or zip = '63031' or zip = '63032' or zip = '63033' or zip = '63033' or zip = '63034' or zip = '63040' or zip = '63040' or zip = '63040' or zip = '63052' or zip = '63053' or zip = '63053' or zip = '63057' or zip = '63099' or zip = '63099' or zip = '63101' or zip = '63102' or zip = '63103' or zip = '63104' or zip = '63105' or zip = '63105' or zip = '63105' or zip = '63106' or zip = '63107' or zip = '63108' or zip = '63109' or zip = '63110' or zip = '63111' or zip = '63112' or zip = '63112' or zip = '63113' or zip = '63113' or zip = '63114' or zip = '63114' or zip = '63114' or zip = '63121' or zip = '63121' or zip = '63121' or zip = '63121' or zip = '63121' or zip = '63121' or zip = '63121' or zip = '63122' or zip = '63122' or zip = '63122' or zip = '63122' or zip = '63122' or zip = '63122' or zip = '63123' or zip = '63123' or zip = '63124' or zip = '63124' or zip = '63124' or zip = '63124' or zip = '63125' or zip = '63125' or zip = '63125' or zip = '63125' or zip = '63126' or zip = '63126' or zip = '63126' or zip = '63127' or zip = '63127' or zip = '63127' or zip = '63128' or zip = '63128' or zip = '63129' or zip = '63129' or zip = '63129' or zip = '63130' or zip = '63130' or zip = '63130' or zip = '63130' or zip = '63130' or zip = '63131' or zip = '63131' or zip = '63131' or zip = '63131' or zip = '63131' or zip = '63131' or zip = '63132' or zip = '63132' or zip = '63132' or zip = '63133' or zip = '63133' or zip = '63133' or zip = '63133' or zip = '63133' or zip = '63134' or zip = '63134' or zip = '63134' or zip = '63134' or zip = '63135' or zip = '63135' or zip = '63135' or zip = '63135' or zip = '63135' or zip = '63135' or zip = '63136' or zip = '63136' or zip = '63136' or zip = '63136' or zip = '63136' or zip = '63136' or zip = '63114' or zip = '63114' or zip = '63114' or zip = '63114' or zip = '63115' or zip = '63116' or zip = '63117' or zip = '63117' or zip = '63117' or zip = '63118' or zip = '63119' or zip = '63119' or zip = '63119' or zip = '63119' or zip = '63119' or zip = '63120' or zip = '63120' or zip = '63120' or zip = '63121' or zip = '63121' or zip = '63121' or zip = '63121' or zip = '63136' or zip = '63137' or zip = '63137' or zip = '63137' or zip = '63137' or zip = '63137' or zip = '63138' or zip = '63138' or zip = '63138' or zip = '63139' or zip = '63140' or zip = '63140' or zip = '63140' or zip = '63141' or zip = '63141' or zip = '63143' or zip = '63143' or zip = '63144' or zip = '63144' or zip = '63145' or zip = '63145' or zip = '63145' or zip = '63145' or zip = '63146' or zip = '63146' or zip = '63147' or zip = '63150' or zip = '63150' or zip = '63151' or zip = '63155' or zip = '63156' or zip = '63157' or zip = '63158' or zip = '63160' or zip = '63160' or zip = '63163' or zip = '63164' or zip = '63164' or zip = '63166' or zip = '63167' or zip = '63167' or zip = '63169' or zip = '63171' or zip = '63171' or zip = '63301' or zip = '63301' or zip = '63301' or zip = '63301' or zip = '63302' or zip = '63303' or zip = '63303' or zip = '63303' or zip = '63303' or zip = '63373' or zip = '63177' or zip = '63178' or zip = '63179' or zip = '63180' or zip = '63180' or zip = '63182' or zip = '63182' or zip = '63188' or zip = '63190' or zip = '63190' or zip = '63195' or zip = '63195' or zip = '63195' or zip = '63197' or zip = '63197' or zip = '63198' or zip = '63198' or zip = '63199' or zip = '63199' or zip = '63301' or zip = '63301' or zip = '63301' or zip = '63373' or zip = '63373' or zip = '63373' or zip = '63386' or zip = '62002' or zip = '62010' or zip = '62018' or zip = '62024' or zip = '62025' or zip = '62026' or zip = '62028' or zip = '62034' or zip = '62035' or zip = '62040' or zip = '62048' or zip = '62059' or zip = '62060' or zip = '62062' or zip = '62067' or zip = '62071' or zip = '62084' or zip = '62087' or zip = '62090' or zip = '62095' or zip = '62201' or zip = '62202' or zip = '62203' or zip = '62204' or zip = '62205' or zip = '62206' or zip = '62207' or zip = '62208' or zip = '62220' or zip = '62221' or zip = '62222' or zip = '62223' or zip = '62224' or zip = '62225' or zip = '62226' or zip = '62232' or zip = '62234' or zip = '62236' or zip = '62239' or zip = '62240' or zip = '62243' or zip = '62254' or zip = '62256' or zip = '62258' or zip = '62260' or zip = '62269' or zip = '62281' or zip = '62285' or zip = '62289' or zip = '62294' or zip = '62295' or zip = '62298' or zip = '63001' or zip = '63005' or zip = '63006' or zip = '63010' or zip = '63011' or zip = '63012' or zip = '63017' or zip = '63021' or zip = '63022' or zip = '63024' or zip = '63025' or zip = '63026' or zip = '63031' or zip = '63032' or zip = '63033' or zip = '63034' or zip = '63040' or zip = '63042' or zip = '63043' or zip = '63044' or zip = '63045' or zip = '63049' or zip = '63052' or zip = '63057' or zip = '63074' or zip = '63088' or zip = '63099' or zip = '63101' or zip = '63102' or zip = '63103' or zip = '63104' or zip = '63105' or zip = '63106' or zip = '63107' or zip = '63108' or zip = '63109' or zip = '63110' or zip = '63111' or zip = '63112' or zip = '63113' or zip = '63114' or zip = '63115' or zip = '63116' or zip = '63117' or zip = '63118' or zip = '63119' or zip = '63120' or zip = '63121' or zip = '63122' or zip = '63123' or zip = '63124' or zip = '63125' or zip = '63126' or zip = '63127' or zip = '63128' or zip = '63129' or zip = '63130' or zip = '63131' or zip = '63132' or zip = '63133' or zip = '63134' or zip = '63135' or zip = '63136' or zip = '63137' or zip = '63138' or zip = '63139' or zip = '63140' or zip = '63141' or zip = '63143' or zip = '63144' or zip = '63145' or zip = '63146' or zip = '63147' or zip = '63150' or zip = '63151' or zip = '63153' or zip = '63155' or zip = '63156' or zip = '63157' or zip = '63158' or zip = '63160' or zip = '63163' or zip = '63164' or zip = '63166' or zip = '63167' or zip = '63169' or zip = '63171' or zip = '63177' or zip = '63178' or zip = '63179' or zip = '63180' or zip = '63182' or zip = '63188' or zip = '63195' or zip = '63196' or zip = '63197' or zip = '63198' or zip = '63199' or zip = '63301' or zip = '63303' or zip = '63338' or zip = '63346' or zip = '63373' or zip = '63386')
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 = 'MO' and city = 'SAINT LOUIS' and state = 'MO ' 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();