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


85+ High Potential Investor Deals Near oklahoma city [Refine]

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 ='73003' or zipCode = '73007' or zipCode = '73008' or zipCode = '73012' or zipCode = '73013' or zipCode = '73016' or zipCode = '73019' or zipCode = '73019' or zipCode = '73020' or zipCode = '73025' or zipCode = '73026' or zipCode = '73034' or zipCode = '73036' or zipCode = '73045' or zipCode = '73049' or zipCode = '73083' or zipCode = '73084' or zipCode = '73085' or zipCode = '73089' or zipCode = '73090' or zipCode = '73097' or zipCode = '73099' or zipCode = '73101' or zipCode = '73101' or zipCode = '73102' or zipCode = '73102' or zipCode = '73103' or zipCode = '73103' or zipCode = '73115' or zipCode = '73115' or zipCode = '73115' or zipCode = '73116' or zipCode = '73116' or zipCode = '73116' or zipCode = '73117' or zipCode = '73117' or zipCode = '73118' or zipCode = '73118' or zipCode = '73119' or zipCode = '73119' or zipCode = '73120' or zipCode = '73120' or zipCode = '73120' or zipCode = '73120' or zipCode = '73120' or zipCode = '73120' or zipCode = '73121' or zipCode = '73121' or zipCode = '73122' or zipCode = '73122' or zipCode = '73122' or zipCode = '73054' or zipCode = '73064' or zipCode = '73065' or zipCode = '73066' or zipCode = '73069' or zipCode = '73070' or zipCode = '73071' or zipCode = '73072' or zipCode = '73078' or zipCode = '73104' or zipCode = '73104' or zipCode = '73105' or zipCode = '73105' or zipCode = '73106' or zipCode = '73106' or zipCode = '73107' or zipCode = '73107' or zipCode = '73108' or zipCode = '73108' or zipCode = '73109' or zipCode = '73109' or zipCode = '73110' or zipCode = '73110' or zipCode = '73110' or zipCode = '73111' or zipCode = '73111' or zipCode = '73112' or zipCode = '73112' or zipCode = '73113' or zipCode = '73113' or zipCode = '73114' or zipCode = '73114' or zipCode = '73123' or zipCode = '73123' or zipCode = '73123' or zipCode = '73124' or zipCode = '73124' or zipCode = '73125' or zipCode = '73125' or zipCode = '73126' or zipCode = '73126' or zipCode = '73127' or zipCode = '73127' or zipCode = '73128' or zipCode = '73128' or zipCode = '73129' or zipCode = '73129' or zipCode = '73130' or zipCode = '73130' or zipCode = '73130' or zipCode = '73131' or zipCode = '73131' or zipCode = '73132' or zipCode = '73132' or zipCode = '73132' or zipCode = '73134' or zipCode = '73134' or zipCode = '73135' or zipCode = '73135' or zipCode = '73135' or zipCode = '73136' or zipCode = '73136' or zipCode = '73137' or zipCode = '73137' or zipCode = '73139' or zipCode = '73139' or zipCode = '73140' or zipCode = '73140' or zipCode = '73140' or zipCode = '73141' or zipCode = '73141' or zipCode = '73142' or zipCode = '73142' or zipCode = '73143' or zipCode = '73143' or zipCode = '73144' or zipCode = '73144' or zipCode = '73145' or zipCode = '73155' or zipCode = '73155' or zipCode = '73156' or zipCode = '73156' or zipCode = '73157' or zipCode = '73157' or zipCode = '73159' or zipCode = '73159' or zipCode = '73160' or zipCode = '73160' or zipCode = '73160' or zipCode = '73162' or zipCode = '73162' or zipCode = '73163' or zipCode = '73163' or zipCode = '73164' or zipCode = '73164' or zipCode = '73165' or zipCode = '73165' or zipCode = '73165' or zipCode = '73167' or zipCode = '73167' or zipCode = '73169' or zipCode = '73169' or zipCode = '73170' or zipCode = '73170' or zipCode = '73170' or zipCode = '73172' or zipCode = '73172' or zipCode = '73173' or zipCode = '73173' or zipCode = '73178' or zipCode = '73178' or zipCode = '73179' or zipCode = '73179' or zipCode = '73184' or zipCode = '73184' or zipCode = '73184' or zipCode = '73185' or zipCode = '73185' or zipCode = '73185' or zipCode = '73189' or zipCode = '73189' or zipCode = '73190' or zipCode = '73190' or zipCode = '73190' or zipCode = '73145' or zipCode = '73145' or zipCode = '73145' or zipCode = '73145' or zipCode = '73146' or zipCode = '73146' or zipCode = '73147' or zipCode = '73147' or zipCode = '73148' or zipCode = '73148' or zipCode = '73149' or zipCode = '73149' or zipCode = '73150' or zipCode = '73150' or zipCode = '73151' or zipCode = '73151' or zipCode = '73152' or zipCode = '73152' or zipCode = '73153' or zipCode = '73153' or zipCode = '73153' or zipCode = '73154' or zipCode = '73154' or zipCode = '73194' or zipCode = '73194' or zipCode = '73194' or zipCode = '73195' or zipCode = '73196' or zipCode = '73196' or zipCode = '73196' or zipCode = '73198' or zipCode = '73198' or zipCode = '73198' or zipCode = '73199' or zipCode = '73199' or zipCode = '73199' or zipCode = '74857' or zipCode = '73003' or zipCode = '73007' or zipCode = '73008' or zipCode = '73013' or zipCode = '73016' or zipCode = '73019' or zipCode = '73020' or zipCode = '73026' or zipCode = '73034' or zipCode = '73036' or zipCode = '73045' or zipCode = '73049' or zipCode = '73054' or zipCode = '73064' or zipCode = '73065' or zipCode = '73066' or zipCode = '73069' or zipCode = '73070' or zipCode = '73071' or zipCode = '73072' or zipCode = '73078' or zipCode = '73083' or zipCode = '73084' or zipCode = '73085' or zipCode = '73089' or zipCode = '73090' or zipCode = '73097' or zipCode = '73099' or zipCode = '73101' or zipCode = '73102' or zipCode = '73103' or zipCode = '73104' or zipCode = '73105' or zipCode = '73106' or zipCode = '73107' or zipCode = '73108' or zipCode = '73109' or zipCode = '73110' or zipCode = '73111' or zipCode = '73112' or zipCode = '73113' or zipCode = '73114' or zipCode = '73115' or zipCode = '73116' or zipCode = '73117' or zipCode = '73118' or zipCode = '73119' or zipCode = '73120' or zipCode = '73121' or zipCode = '73122' or zipCode = '73123' or zipCode = '73124' or zipCode = '73125' or zipCode = '73126' or zipCode = '73127' or zipCode = '73128' or zipCode = '73129' or zipCode = '73130' or zipCode = '73131' or zipCode = '73132' or zipCode = '73134' or zipCode = '73135' or zipCode = '73136' or zipCode = '73137' or zipCode = '73139' or zipCode = '73140' or zipCode = '73141' or zipCode = '73142' or zipCode = '73143' or zipCode = '73144' or zipCode = '73145' or zipCode = '73146' or zipCode = '73147' or zipCode = '73148' or zipCode = '73149' or zipCode = '73150' or zipCode = '73151' or zipCode = '73152' or zipCode = '73153' or zipCode = '73154' or zipCode = '73155' or zipCode = '73156' or zipCode = '73157' or zipCode = '73159' or zipCode = '73160' or zipCode = '73162' or zipCode = '73163' or zipCode = '73164' or zipCode = '73165' or zipCode = '73167' or zipCode = '73169' or zipCode = '73170' or zipCode = '73172' or zipCode = '73173' or zipCode = '73177' or zipCode = '73178' or zipCode = '73179' or zipCode = '73180' or zipCode = '73184' or zipCode = '73185' or zipCode = '73189' or zipCode = '73190' or zipCode = '73193' or zipCode = '73194' or zipCode = '73196' or zipCode = '73197' or zipCode = '73198' or zipCode = '73199' or zipCode = '74857')
select top 45 *, cast(tax_value as float)/cast(price as float) as tax_ratio from tblBothNew NOLOCK where priority IS NULL and price > 5000 and (1=1) and original_price IS NOT NULL and (status='active' or status='for_sale' or status IS NULL) and (propertyType != 'LAND' or propertyType is null) and 1=1 and state = 'OK' and photoURL1 IS NOT NULL and theType = 'Tax' and tax_value IS NOT NULL and (bedrooms <> '' AND bedrooms IS NOT NULL) and tax_value/price < 5 and 1=1 and (1=1) and price >= 0 and price <= 499999 and 11=11 and (zipCode ='73003' or zipCode = '73007' or zipCode = '73008' or zipCode = '73012' or zipCode = '73013' or zipCode = '73016' or zipCode = '73019' or zipCode = '73019' or zipCode = '73020' or zipCode = '73025' or zipCode = '73026' or zipCode = '73034' or zipCode = '73036' or zipCode = '73045' or zipCode = '73049' or zipCode = '73083' or zipCode = '73084' or zipCode = '73085' or zipCode = '73089' or zipCode = '73090' or zipCode = '73097' or zipCode = '73099' or zipCode = '73101' or zipCode = '73101' or zipCode = '73102' or zipCode = '73102' or zipCode = '73103' or zipCode = '73103' or zipCode = '73115' or zipCode = '73115' or zipCode = '73115' or zipCode = '73116' or zipCode = '73116' or zipCode = '73116' or zipCode = '73117' or zipCode = '73117' or zipCode = '73118' or zipCode = '73118' or zipCode = '73119' or zipCode = '73119' or zipCode = '73120' or zipCode = '73120' or zipCode = '73120' or zipCode = '73120' or zipCode = '73120' or zipCode = '73120' or zipCode = '73121' or zipCode = '73121' or zipCode = '73122' or zipCode = '73122' or zipCode = '73122' or zipCode = '73054' or zipCode = '73064' or zipCode = '73065' or zipCode = '73066' or zipCode = '73069' or zipCode = '73070' or zipCode = '73071' or zipCode = '73072' or zipCode = '73078' or zipCode = '73104' or zipCode = '73104' or zipCode = '73105' or zipCode = '73105' or zipCode = '73106' or zipCode = '73106' or zipCode = '73107' or zipCode = '73107' or zipCode = '73108' or zipCode = '73108' or zipCode = '73109' or zipCode = '73109' or zipCode = '73110' or zipCode = '73110' or zipCode = '73110' or zipCode = '73111' or zipCode = '73111' or zipCode = '73112' or zipCode = '73112' or zipCode = '73113' or zipCode = '73113' or zipCode = '73114' or zipCode = '73114' or zipCode = '73123' or zipCode = '73123' or zipCode = '73123' or zipCode = '73124' or zipCode = '73124' or zipCode = '73125' or zipCode = '73125' or zipCode = '73126' or zipCode = '73126' or zipCode = '73127' or zipCode = '73127' or zipCode = '73128' or zipCode = '73128' or zipCode = '73129' or zipCode = '73129' or zipCode = '73130' or zipCode = '73130' or zipCode = '73130' or zipCode = '73131' or zipCode = '73131' or zipCode = '73132' or zipCode = '73132' or zipCode = '73132' or zipCode = '73134' or zipCode = '73134' or zipCode = '73135' or zipCode = '73135' or zipCode = '73135' or zipCode = '73136' or zipCode = '73136' or zipCode = '73137' or zipCode = '73137' or zipCode = '73139' or zipCode = '73139' or zipCode = '73140' or zipCode = '73140' or zipCode = '73140' or zipCode = '73141' or zipCode = '73141' or zipCode = '73142' or zipCode = '73142' or zipCode = '73143' or zipCode = '73143' or zipCode = '73144' or zipCode = '73144' or zipCode = '73145' or zipCode = '73155' or zipCode = '73155' or zipCode = '73156' or zipCode = '73156' or zipCode = '73157' or zipCode = '73157' or zipCode = '73159' or zipCode = '73159' or zipCode = '73160' or zipCode = '73160' or zipCode = '73160' or zipCode = '73162' or zipCode = '73162' or zipCode = '73163' or zipCode = '73163' or zipCode = '73164' or zipCode = '73164' or zipCode = '73165' or zipCode = '73165' or zipCode = '73165' or zipCode = '73167' or zipCode = '73167' or zipCode = '73169' or zipCode = '73169' or zipCode = '73170' or zipCode = '73170' or zipCode = '73170' or zipCode = '73172' or zipCode = '73172' or zipCode = '73173' or zipCode = '73173' or zipCode = '73178' or zipCode = '73178' or zipCode = '73179' or zipCode = '73179' or zipCode = '73184' or zipCode = '73184' or zipCode = '73184' or zipCode = '73185' or zipCode = '73185' or zipCode = '73185' or zipCode = '73189' or zipCode = '73189' or zipCode = '73190' or zipCode = '73190' or zipCode = '73190' or zipCode = '73145' or zipCode = '73145' or zipCode = '73145' or zipCode = '73145' or zipCode = '73146' or zipCode = '73146' or zipCode = '73147' or zipCode = '73147' or zipCode = '73148' or zipCode = '73148' or zipCode = '73149' or zipCode = '73149' or zipCode = '73150' or zipCode = '73150' or zipCode = '73151' or zipCode = '73151' or zipCode = '73152' or zipCode = '73152' or zipCode = '73153' or zipCode = '73153' or zipCode = '73153' or zipCode = '73154' or zipCode = '73154' or zipCode = '73194' or zipCode = '73194' or zipCode = '73194' or zipCode = '73195' or zipCode = '73196' or zipCode = '73196' or zipCode = '73196' or zipCode = '73198' or zipCode = '73198' or zipCode = '73198' or zipCode = '73199' or zipCode = '73199' or zipCode = '73199' or zipCode = '74857' or zipCode = '73003' or zipCode = '73007' or zipCode = '73008' or zipCode = '73013' or zipCode = '73016' or zipCode = '73019' or zipCode = '73020' or zipCode = '73026' or zipCode = '73034' or zipCode = '73036' or zipCode = '73045' or zipCode = '73049' or zipCode = '73054' or zipCode = '73064' or zipCode = '73065' or zipCode = '73066' or zipCode = '73069' or zipCode = '73070' or zipCode = '73071' or zipCode = '73072' or zipCode = '73078' or zipCode = '73083' or zipCode = '73084' or zipCode = '73085' or zipCode = '73089' or zipCode = '73090' or zipCode = '73097' or zipCode = '73099' or zipCode = '73101' or zipCode = '73102' or zipCode = '73103' or zipCode = '73104' or zipCode = '73105' or zipCode = '73106' or zipCode = '73107' or zipCode = '73108' or zipCode = '73109' or zipCode = '73110' or zipCode = '73111' or zipCode = '73112' or zipCode = '73113' or zipCode = '73114' or zipCode = '73115' or zipCode = '73116' or zipCode = '73117' or zipCode = '73118' or zipCode = '73119' or zipCode = '73120' or zipCode = '73121' or zipCode = '73122' or zipCode = '73123' or zipCode = '73124' or zipCode = '73125' or zipCode = '73126' or zipCode = '73127' or zipCode = '73128' or zipCode = '73129' or zipCode = '73130' or zipCode = '73131' or zipCode = '73132' or zipCode = '73134' or zipCode = '73135' or zipCode = '73136' or zipCode = '73137' or zipCode = '73139' or zipCode = '73140' or zipCode = '73141' or zipCode = '73142' or zipCode = '73143' or zipCode = '73144' or zipCode = '73145' or zipCode = '73146' or zipCode = '73147' or zipCode = '73148' or zipCode = '73149' or zipCode = '73150' or zipCode = '73151' or zipCode = '73152' or zipCode = '73153' or zipCode = '73154' or zipCode = '73155' or zipCode = '73156' or zipCode = '73157' or zipCode = '73159' or zipCode = '73160' or zipCode = '73162' or zipCode = '73163' or zipCode = '73164' or zipCode = '73165' or zipCode = '73167' or zipCode = '73169' or zipCode = '73170' or zipCode = '73172' or zipCode = '73173' or zipCode = '73177' or zipCode = '73178' or zipCode = '73179' or zipCode = '73180' or zipCode = '73184' or zipCode = '73185' or zipCode = '73189' or zipCode = '73190' or zipCode = '73193' or zipCode = '73194' or zipCode = '73196' or zipCode = '73197' or zipCode = '73198' or zipCode = '73199' or zipCode = '74857') order by price;
select top 240 * from tblBothNew NOLOCK where priority IS NULL and price > 5000 and original_price IS NOT NULL and (status='active' or status='for_sale' or status IS NULL) and (propertyType != 'land' or propertyType IS NULL) and len(photoURL1) > 5 and dateposted >= '8/29/2021' and theType = 'Desperate' and (bedrooms <> '' and bedrooms IS NOT NULL) and price > 10000 and original_price > 10000 and (1=1) and price >= 0 and price <= 499999 and 11=11 and (zipCode ='73003' or zipCode = '73007' or zipCode = '73008' or zipCode = '73012' or zipCode = '73013' or zipCode = '73016' or zipCode = '73019' or zipCode = '73019' or zipCode = '73020' or zipCode = '73025' or zipCode = '73026' or zipCode = '73034' or zipCode = '73036' or zipCode = '73045' or zipCode = '73049' or zipCode = '73083' or zipCode = '73084' or zipCode = '73085' or zipCode = '73089' or zipCode = '73090' or zipCode = '73097' or zipCode = '73099' or zipCode = '73101' or zipCode = '73101' or zipCode = '73102' or zipCode = '73102' or zipCode = '73103' or zipCode = '73103' or zipCode = '73115' or zipCode = '73115' or zipCode = '73115' or zipCode = '73116' or zipCode = '73116' or zipCode = '73116' or zipCode = '73117' or zipCode = '73117' or zipCode = '73118' or zipCode = '73118' or zipCode = '73119' or zipCode = '73119' or zipCode = '73120' or zipCode = '73120' or zipCode = '73120' or zipCode = '73120' or zipCode = '73120' or zipCode = '73120' or zipCode = '73121' or zipCode = '73121' or zipCode = '73122' or zipCode = '73122' or zipCode = '73122' or zipCode = '73054' or zipCode = '73064' or zipCode = '73065' or zipCode = '73066' or zipCode = '73069' or zipCode = '73070' or zipCode = '73071' or zipCode = '73072' or zipCode = '73078' or zipCode = '73104' or zipCode = '73104' or zipCode = '73105' or zipCode = '73105' or zipCode = '73106' or zipCode = '73106' or zipCode = '73107' or zipCode = '73107' or zipCode = '73108' or zipCode = '73108' or zipCode = '73109' or zipCode = '73109' or zipCode = '73110' or zipCode = '73110' or zipCode = '73110' or zipCode = '73111' or zipCode = '73111' or zipCode = '73112' or zipCode = '73112' or zipCode = '73113' or zipCode = '73113' or zipCode = '73114' or zipCode = '73114' or zipCode = '73123' or zipCode = '73123' or zipCode = '73123' or zipCode = '73124' or zipCode = '73124' or zipCode = '73125' or zipCode = '73125' or zipCode = '73126' or zipCode = '73126' or zipCode = '73127' or zipCode = '73127' or zipCode = '73128' or zipCode = '73128' or zipCode = '73129' or zipCode = '73129' or zipCode = '73130' or zipCode = '73130' or zipCode = '73130' or zipCode = '73131' or zipCode = '73131' or zipCode = '73132' or zipCode = '73132' or zipCode = '73132' or zipCode = '73134' or zipCode = '73134' or zipCode = '73135' or zipCode = '73135' or zipCode = '73135' or zipCode = '73136' or zipCode = '73136' or zipCode = '73137' or zipCode = '73137' or zipCode = '73139' or zipCode = '73139' or zipCode = '73140' or zipCode = '73140' or zipCode = '73140' or zipCode = '73141' or zipCode = '73141' or zipCode = '73142' or zipCode = '73142' or zipCode = '73143' or zipCode = '73143' or zipCode = '73144' or zipCode = '73144' or zipCode = '73145' or zipCode = '73155' or zipCode = '73155' or zipCode = '73156' or zipCode = '73156' or zipCode = '73157' or zipCode = '73157' or zipCode = '73159' or zipCode = '73159' or zipCode = '73160' or zipCode = '73160' or zipCode = '73160' or zipCode = '73162' or zipCode = '73162' or zipCode = '73163' or zipCode = '73163' or zipCode = '73164' or zipCode = '73164' or zipCode = '73165' or zipCode = '73165' or zipCode = '73165' or zipCode = '73167' or zipCode = '73167' or zipCode = '73169' or zipCode = '73169' or zipCode = '73170' or zipCode = '73170' or zipCode = '73170' or zipCode = '73172' or zipCode = '73172' or zipCode = '73173' or zipCode = '73173' or zipCode = '73178' or zipCode = '73178' or zipCode = '73179' or zipCode = '73179' or zipCode = '73184' or zipCode = '73184' or zipCode = '73184' or zipCode = '73185' or zipCode = '73185' or zipCode = '73185' or zipCode = '73189' or zipCode = '73189' or zipCode = '73190' or zipCode = '73190' or zipCode = '73190' or zipCode = '73145' or zipCode = '73145' or zipCode = '73145' or zipCode = '73145' or zipCode = '73146' or zipCode = '73146' or zipCode = '73147' or zipCode = '73147' or zipCode = '73148' or zipCode = '73148' or zipCode = '73149' or zipCode = '73149' or zipCode = '73150' or zipCode = '73150' or zipCode = '73151' or zipCode = '73151' or zipCode = '73152' or zipCode = '73152' or zipCode = '73153' or zipCode = '73153' or zipCode = '73153' or zipCode = '73154' or zipCode = '73154' or zipCode = '73194' or zipCode = '73194' or zipCode = '73194' or zipCode = '73195' or zipCode = '73196' or zipCode = '73196' or zipCode = '73196' or zipCode = '73198' or zipCode = '73198' or zipCode = '73198' or zipCode = '73199' or zipCode = '73199' or zipCode = '73199' or zipCode = '74857' or zipCode = '73003' or zipCode = '73007' or zipCode = '73008' or zipCode = '73013' or zipCode = '73016' or zipCode = '73019' or zipCode = '73020' or zipCode = '73026' or zipCode = '73034' or zipCode = '73036' or zipCode = '73045' or zipCode = '73049' or zipCode = '73054' or zipCode = '73064' or zipCode = '73065' or zipCode = '73066' or zipCode = '73069' or zipCode = '73070' or zipCode = '73071' or zipCode = '73072' or zipCode = '73078' or zipCode = '73083' or zipCode = '73084' or zipCode = '73085' or zipCode = '73089' or zipCode = '73090' or zipCode = '73097' or zipCode = '73099' or zipCode = '73101' or zipCode = '73102' or zipCode = '73103' or zipCode = '73104' or zipCode = '73105' or zipCode = '73106' or zipCode = '73107' or zipCode = '73108' or zipCode = '73109' or zipCode = '73110' or zipCode = '73111' or zipCode = '73112' or zipCode = '73113' or zipCode = '73114' or zipCode = '73115' or zipCode = '73116' or zipCode = '73117' or zipCode = '73118' or zipCode = '73119' or zipCode = '73120' or zipCode = '73121' or zipCode = '73122' or zipCode = '73123' or zipCode = '73124' or zipCode = '73125' or zipCode = '73126' or zipCode = '73127' or zipCode = '73128' or zipCode = '73129' or zipCode = '73130' or zipCode = '73131' or zipCode = '73132' or zipCode = '73134' or zipCode = '73135' or zipCode = '73136' or zipCode = '73137' or zipCode = '73139' or zipCode = '73140' or zipCode = '73141' or zipCode = '73142' or zipCode = '73143' or zipCode = '73144' or zipCode = '73145' or zipCode = '73146' or zipCode = '73147' or zipCode = '73148' or zipCode = '73149' or zipCode = '73150' or zipCode = '73151' or zipCode = '73152' or zipCode = '73153' or zipCode = '73154' or zipCode = '73155' or zipCode = '73156' or zipCode = '73157' or zipCode = '73159' or zipCode = '73160' or zipCode = '73162' or zipCode = '73163' or zipCode = '73164' or zipCode = '73165' or zipCode = '73167' or zipCode = '73169' or zipCode = '73170' or zipCode = '73172' or zipCode = '73173' or zipCode = '73177' or zipCode = '73178' or zipCode = '73179' or zipCode = '73180' or zipCode = '73184' or zipCode = '73185' or zipCode = '73189' or zipCode = '73190' or zipCode = '73193' or zipCode = '73194' or zipCode = '73196' or zipCode = '73197' or zipCode = '73198' or zipCode = '73199' or zipCode = '74857') 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 ='73003' or zipCode = '73007' or zipCode = '73008' or zipCode = '73012' or zipCode = '73013' or zipCode = '73016' or zipCode = '73019' or zipCode = '73019' or zipCode = '73020' or zipCode = '73025' or zipCode = '73026' or zipCode = '73034' or zipCode = '73036' or zipCode = '73045' or zipCode = '73049' or zipCode = '73083' or zipCode = '73084' or zipCode = '73085' or zipCode = '73089' or zipCode = '73090' or zipCode = '73097' or zipCode = '73099' or zipCode = '73101' or zipCode = '73101' or zipCode = '73102' or zipCode = '73102' or zipCode = '73103' or zipCode = '73103' or zipCode = '73115' or zipCode = '73115' or zipCode = '73115' or zipCode = '73116' or zipCode = '73116' or zipCode = '73116' or zipCode = '73117' or zipCode = '73117' or zipCode = '73118' or zipCode = '73118' or zipCode = '73119' or zipCode = '73119' or zipCode = '73120' or zipCode = '73120' or zipCode = '73120' or zipCode = '73120' or zipCode = '73120' or zipCode = '73120' or zipCode = '73121' or zipCode = '73121' or zipCode = '73122' or zipCode = '73122' or zipCode = '73122' or zipCode = '73054' or zipCode = '73064' or zipCode = '73065' or zipCode = '73066' or zipCode = '73069' or zipCode = '73070' or zipCode = '73071' or zipCode = '73072' or zipCode = '73078' or zipCode = '73104' or zipCode = '73104' or zipCode = '73105' or zipCode = '73105' or zipCode = '73106' or zipCode = '73106' or zipCode = '73107' or zipCode = '73107' or zipCode = '73108' or zipCode = '73108' or zipCode = '73109' or zipCode = '73109' or zipCode = '73110' or zipCode = '73110' or zipCode = '73110' or zipCode = '73111' or zipCode = '73111' or zipCode = '73112' or zipCode = '73112' or zipCode = '73113' or zipCode = '73113' or zipCode = '73114' or zipCode = '73114' or zipCode = '73123' or zipCode = '73123' or zipCode = '73123' or zipCode = '73124' or zipCode = '73124' or zipCode = '73125' or zipCode = '73125' or zipCode = '73126' or zipCode = '73126' or zipCode = '73127' or zipCode = '73127' or zipCode = '73128' or zipCode = '73128' or zipCode = '73129' or zipCode = '73129' or zipCode = '73130' or zipCode = '73130' or zipCode = '73130' or zipCode = '73131' or zipCode = '73131' or zipCode = '73132' or zipCode = '73132' or zipCode = '73132' or zipCode = '73134' or zipCode = '73134' or zipCode = '73135' or zipCode = '73135' or zipCode = '73135' or zipCode = '73136' or zipCode = '73136' or zipCode = '73137' or zipCode = '73137' or zipCode = '73139' or zipCode = '73139' or zipCode = '73140' or zipCode = '73140' or zipCode = '73140' or zipCode = '73141' or zipCode = '73141' or zipCode = '73142' or zipCode = '73142' or zipCode = '73143' or zipCode = '73143' or zipCode = '73144' or zipCode = '73144' or zipCode = '73145' or zipCode = '73155' or zipCode = '73155' or zipCode = '73156' or zipCode = '73156' or zipCode = '73157' or zipCode = '73157' or zipCode = '73159' or zipCode = '73159' or zipCode = '73160' or zipCode = '73160' or zipCode = '73160' or zipCode = '73162' or zipCode = '73162' or zipCode = '73163' or zipCode = '73163' or zipCode = '73164' or zipCode = '73164' or zipCode = '73165' or zipCode = '73165' or zipCode = '73165' or zipCode = '73167' or zipCode = '73167' or zipCode = '73169' or zipCode = '73169' or zipCode = '73170' or zipCode = '73170' or zipCode = '73170' or zipCode = '73172' or zipCode = '73172' or zipCode = '73173' or zipCode = '73173' or zipCode = '73178' or zipCode = '73178' or zipCode = '73179' or zipCode = '73179' or zipCode = '73184' or zipCode = '73184' or zipCode = '73184' or zipCode = '73185' or zipCode = '73185' or zipCode = '73185' or zipCode = '73189' or zipCode = '73189' or zipCode = '73190' or zipCode = '73190' or zipCode = '73190' or zipCode = '73145' or zipCode = '73145' or zipCode = '73145' or zipCode = '73145' or zipCode = '73146' or zipCode = '73146' or zipCode = '73147' or zipCode = '73147' or zipCode = '73148' or zipCode = '73148' or zipCode = '73149' or zipCode = '73149' or zipCode = '73150' or zipCode = '73150' or zipCode = '73151' or zipCode = '73151' or zipCode = '73152' or zipCode = '73152' or zipCode = '73153' or zipCode = '73153' or zipCode = '73153' or zipCode = '73154' or zipCode = '73154' or zipCode = '73194' or zipCode = '73194' or zipCode = '73194' or zipCode = '73195' or zipCode = '73196' or zipCode = '73196' or zipCode = '73196' or zipCode = '73198' or zipCode = '73198' or zipCode = '73198' or zipCode = '73199' or zipCode = '73199' or zipCode = '73199' or zipCode = '74857' or zipCode = '73003' or zipCode = '73007' or zipCode = '73008' or zipCode = '73013' or zipCode = '73016' or zipCode = '73019' or zipCode = '73020' or zipCode = '73026' or zipCode = '73034' or zipCode = '73036' or zipCode = '73045' or zipCode = '73049' or zipCode = '73054' or zipCode = '73064' or zipCode = '73065' or zipCode = '73066' or zipCode = '73069' or zipCode = '73070' or zipCode = '73071' or zipCode = '73072' or zipCode = '73078' or zipCode = '73083' or zipCode = '73084' or zipCode = '73085' or zipCode = '73089' or zipCode = '73090' or zipCode = '73097' or zipCode = '73099' or zipCode = '73101' or zipCode = '73102' or zipCode = '73103' or zipCode = '73104' or zipCode = '73105' or zipCode = '73106' or zipCode = '73107' or zipCode = '73108' or zipCode = '73109' or zipCode = '73110' or zipCode = '73111' or zipCode = '73112' or zipCode = '73113' or zipCode = '73114' or zipCode = '73115' or zipCode = '73116' or zipCode = '73117' or zipCode = '73118' or zipCode = '73119' or zipCode = '73120' or zipCode = '73121' or zipCode = '73122' or zipCode = '73123' or zipCode = '73124' or zipCode = '73125' or zipCode = '73126' or zipCode = '73127' or zipCode = '73128' or zipCode = '73129' or zipCode = '73130' or zipCode = '73131' or zipCode = '73132' or zipCode = '73134' or zipCode = '73135' or zipCode = '73136' or zipCode = '73137' or zipCode = '73139' or zipCode = '73140' or zipCode = '73141' or zipCode = '73142' or zipCode = '73143' or zipCode = '73144' or zipCode = '73145' or zipCode = '73146' or zipCode = '73147' or zipCode = '73148' or zipCode = '73149' or zipCode = '73150' or zipCode = '73151' or zipCode = '73152' or zipCode = '73153' or zipCode = '73154' or zipCode = '73155' or zipCode = '73156' or zipCode = '73157' or zipCode = '73159' or zipCode = '73160' or zipCode = '73162' or zipCode = '73163' or zipCode = '73164' or zipCode = '73165' or zipCode = '73167' or zipCode = '73169' or zipCode = '73170' or zipCode = '73172' or zipCode = '73173' or zipCode = '73177' or zipCode = '73178' or zipCode = '73179' or zipCode = '73180' or zipCode = '73184' or zipCode = '73185' or zipCode = '73189' or zipCode = '73190' or zipCode = '73193' or zipCode = '73194' or zipCode = '73196' or zipCode = '73197' or zipCode = '73198' or zipCode = '73199' or zipCode = '74857') 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 ='73003' or zipCode = '73007' or zipCode = '73008' or zipCode = '73012' or zipCode = '73013' or zipCode = '73016' or zipCode = '73019' or zipCode = '73019' or zipCode = '73020' or zipCode = '73025' or zipCode = '73026' or zipCode = '73034' or zipCode = '73036' or zipCode = '73045' or zipCode = '73049' or zipCode = '73083' or zipCode = '73084' or zipCode = '73085' or zipCode = '73089' or zipCode = '73090' or zipCode = '73097' or zipCode = '73099' or zipCode = '73101' or zipCode = '73101' or zipCode = '73102' or zipCode = '73102' or zipCode = '73103' or zipCode = '73103' or zipCode = '73115' or zipCode = '73115' or zipCode = '73115' or zipCode = '73116' or zipCode = '73116' or zipCode = '73116' or zipCode = '73117' or zipCode = '73117' or zipCode = '73118' or zipCode = '73118' or zipCode = '73119' or zipCode = '73119' or zipCode = '73120' or zipCode = '73120' or zipCode = '73120' or zipCode = '73120' or zipCode = '73120' or zipCode = '73120' or zipCode = '73121' or zipCode = '73121' or zipCode = '73122' or zipCode = '73122' or zipCode = '73122' or zipCode = '73054' or zipCode = '73064' or zipCode = '73065' or zipCode = '73066' or zipCode = '73069' or zipCode = '73070' or zipCode = '73071' or zipCode = '73072' or zipCode = '73078' or zipCode = '73104' or zipCode = '73104' or zipCode = '73105' or zipCode = '73105' or zipCode = '73106' or zipCode = '73106' or zipCode = '73107' or zipCode = '73107' or zipCode = '73108' or zipCode = '73108' or zipCode = '73109' or zipCode = '73109' or zipCode = '73110' or zipCode = '73110' or zipCode = '73110' or zipCode = '73111' or zipCode = '73111' or zipCode = '73112' or zipCode = '73112' or zipCode = '73113' or zipCode = '73113' or zipCode = '73114' or zipCode = '73114' or zipCode = '73123' or zipCode = '73123' or zipCode = '73123' or zipCode = '73124' or zipCode = '73124' or zipCode = '73125' or zipCode = '73125' or zipCode = '73126' or zipCode = '73126' or zipCode = '73127' or zipCode = '73127' or zipCode = '73128' or zipCode = '73128' or zipCode = '73129' or zipCode = '73129' or zipCode = '73130' or zipCode = '73130' or zipCode = '73130' or zipCode = '73131' or zipCode = '73131' or zipCode = '73132' or zipCode = '73132' or zipCode = '73132' or zipCode = '73134' or zipCode = '73134' or zipCode = '73135' or zipCode = '73135' or zipCode = '73135' or zipCode = '73136' or zipCode = '73136' or zipCode = '73137' or zipCode = '73137' or zipCode = '73139' or zipCode = '73139' or zipCode = '73140' or zipCode = '73140' or zipCode = '73140' or zipCode = '73141' or zipCode = '73141' or zipCode = '73142' or zipCode = '73142' or zipCode = '73143' or zipCode = '73143' or zipCode = '73144' or zipCode = '73144' or zipCode = '73145' or zipCode = '73155' or zipCode = '73155' or zipCode = '73156' or zipCode = '73156' or zipCode = '73157' or zipCode = '73157' or zipCode = '73159' or zipCode = '73159' or zipCode = '73160' or zipCode = '73160' or zipCode = '73160' or zipCode = '73162' or zipCode = '73162' or zipCode = '73163' or zipCode = '73163' or zipCode = '73164' or zipCode = '73164' or zipCode = '73165' or zipCode = '73165' or zipCode = '73165' or zipCode = '73167' or zipCode = '73167' or zipCode = '73169' or zipCode = '73169' or zipCode = '73170' or zipCode = '73170' or zipCode = '73170' or zipCode = '73172' or zipCode = '73172' or zipCode = '73173' or zipCode = '73173' or zipCode = '73178' or zipCode = '73178' or zipCode = '73179' or zipCode = '73179' or zipCode = '73184' or zipCode = '73184' or zipCode = '73184' or zipCode = '73185' or zipCode = '73185' or zipCode = '73185' or zipCode = '73189' or zipCode = '73189' or zipCode = '73190' or zipCode = '73190' or zipCode = '73190' or zipCode = '73145' or zipCode = '73145' or zipCode = '73145' or zipCode = '73145' or zipCode = '73146' or zipCode = '73146' or zipCode = '73147' or zipCode = '73147' or zipCode = '73148' or zipCode = '73148' or zipCode = '73149' or zipCode = '73149' or zipCode = '73150' or zipCode = '73150' or zipCode = '73151' or zipCode = '73151' or zipCode = '73152' or zipCode = '73152' or zipCode = '73153' or zipCode = '73153' or zipCode = '73153' or zipCode = '73154' or zipCode = '73154' or zipCode = '73194' or zipCode = '73194' or zipCode = '73194' or zipCode = '73195' or zipCode = '73196' or zipCode = '73196' or zipCode = '73196' or zipCode = '73198' or zipCode = '73198' or zipCode = '73198' or zipCode = '73199' or zipCode = '73199' or zipCode = '73199' or zipCode = '74857' or zipCode = '73003' or zipCode = '73007' or zipCode = '73008' or zipCode = '73013' or zipCode = '73016' or zipCode = '73019' or zipCode = '73020' or zipCode = '73026' or zipCode = '73034' or zipCode = '73036' or zipCode = '73045' or zipCode = '73049' or zipCode = '73054' or zipCode = '73064' or zipCode = '73065' or zipCode = '73066' or zipCode = '73069' or zipCode = '73070' or zipCode = '73071' or zipCode = '73072' or zipCode = '73078' or zipCode = '73083' or zipCode = '73084' or zipCode = '73085' or zipCode = '73089' or zipCode = '73090' or zipCode = '73097' or zipCode = '73099' or zipCode = '73101' or zipCode = '73102' or zipCode = '73103' or zipCode = '73104' or zipCode = '73105' or zipCode = '73106' or zipCode = '73107' or zipCode = '73108' or zipCode = '73109' or zipCode = '73110' or zipCode = '73111' or zipCode = '73112' or zipCode = '73113' or zipCode = '73114' or zipCode = '73115' or zipCode = '73116' or zipCode = '73117' or zipCode = '73118' or zipCode = '73119' or zipCode = '73120' or zipCode = '73121' or zipCode = '73122' or zipCode = '73123' or zipCode = '73124' or zipCode = '73125' or zipCode = '73126' or zipCode = '73127' or zipCode = '73128' or zipCode = '73129' or zipCode = '73130' or zipCode = '73131' or zipCode = '73132' or zipCode = '73134' or zipCode = '73135' or zipCode = '73136' or zipCode = '73137' or zipCode = '73139' or zipCode = '73140' or zipCode = '73141' or zipCode = '73142' or zipCode = '73143' or zipCode = '73144' or zipCode = '73145' or zipCode = '73146' or zipCode = '73147' or zipCode = '73148' or zipCode = '73149' or zipCode = '73150' or zipCode = '73151' or zipCode = '73152' or zipCode = '73153' or zipCode = '73154' or zipCode = '73155' or zipCode = '73156' or zipCode = '73157' or zipCode = '73159' or zipCode = '73160' or zipCode = '73162' or zipCode = '73163' or zipCode = '73164' or zipCode = '73165' or zipCode = '73167' or zipCode = '73169' or zipCode = '73170' or zipCode = '73172' or zipCode = '73173' or zipCode = '73177' or zipCode = '73178' or zipCode = '73179' or zipCode = '73180' or zipCode = '73184' or zipCode = '73185' or zipCode = '73189' or zipCode = '73190' or zipCode = '73193' or zipCode = '73194' or zipCode = '73196' or zipCode = '73197' or zipCode = '73198' or zipCode = '73199' or zipCode = '74857') 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 ='73003' or zipCode = '73007' or zipCode = '73008' or zipCode = '73012' or zipCode = '73013' or zipCode = '73016' or zipCode = '73019' or zipCode = '73019' or zipCode = '73020' or zipCode = '73025' or zipCode = '73026' or zipCode = '73034' or zipCode = '73036' or zipCode = '73045' or zipCode = '73049' or zipCode = '73083' or zipCode = '73084' or zipCode = '73085' or zipCode = '73089' or zipCode = '73090' or zipCode = '73097' or zipCode = '73099' or zipCode = '73101' or zipCode = '73101' or zipCode = '73102' or zipCode = '73102' or zipCode = '73103' or zipCode = '73103' or zipCode = '73115' or zipCode = '73115' or zipCode = '73115' or zipCode = '73116' or zipCode = '73116' or zipCode = '73116' or zipCode = '73117' or zipCode = '73117' or zipCode = '73118' or zipCode = '73118' or zipCode = '73119' or zipCode = '73119' or zipCode = '73120' or zipCode = '73120' or zipCode = '73120' or zipCode = '73120' or zipCode = '73120' or zipCode = '73120' or zipCode = '73121' or zipCode = '73121' or zipCode = '73122' or zipCode = '73122' or zipCode = '73122' or zipCode = '73054' or zipCode = '73064' or zipCode = '73065' or zipCode = '73066' or zipCode = '73069' or zipCode = '73070' or zipCode = '73071' or zipCode = '73072' or zipCode = '73078' or zipCode = '73104' or zipCode = '73104' or zipCode = '73105' or zipCode = '73105' or zipCode = '73106' or zipCode = '73106' or zipCode = '73107' or zipCode = '73107' or zipCode = '73108' or zipCode = '73108' or zipCode = '73109' or zipCode = '73109' or zipCode = '73110' or zipCode = '73110' or zipCode = '73110' or zipCode = '73111' or zipCode = '73111' or zipCode = '73112' or zipCode = '73112' or zipCode = '73113' or zipCode = '73113' or zipCode = '73114' or zipCode = '73114' or zipCode = '73123' or zipCode = '73123' or zipCode = '73123' or zipCode = '73124' or zipCode = '73124' or zipCode = '73125' or zipCode = '73125' or zipCode = '73126' or zipCode = '73126' or zipCode = '73127' or zipCode = '73127' or zipCode = '73128' or zipCode = '73128' or zipCode = '73129' or zipCode = '73129' or zipCode = '73130' or zipCode = '73130' or zipCode = '73130' or zipCode = '73131' or zipCode = '73131' or zipCode = '73132' or zipCode = '73132' or zipCode = '73132' or zipCode = '73134' or zipCode = '73134' or zipCode = '73135' or zipCode = '73135' or zipCode = '73135' or zipCode = '73136' or zipCode = '73136' or zipCode = '73137' or zipCode = '73137' or zipCode = '73139' or zipCode = '73139' or zipCode = '73140' or zipCode = '73140' or zipCode = '73140' or zipCode = '73141' or zipCode = '73141' or zipCode = '73142' or zipCode = '73142' or zipCode = '73143' or zipCode = '73143' or zipCode = '73144' or zipCode = '73144' or zipCode = '73145' or zipCode = '73155' or zipCode = '73155' or zipCode = '73156' or zipCode = '73156' or zipCode = '73157' or zipCode = '73157' or zipCode = '73159' or zipCode = '73159' or zipCode = '73160' or zipCode = '73160' or zipCode = '73160' or zipCode = '73162' or zipCode = '73162' or zipCode = '73163' or zipCode = '73163' or zipCode = '73164' or zipCode = '73164' or zipCode = '73165' or zipCode = '73165' or zipCode = '73165' or zipCode = '73167' or zipCode = '73167' or zipCode = '73169' or zipCode = '73169' or zipCode = '73170' or zipCode = '73170' or zipCode = '73170' or zipCode = '73172' or zipCode = '73172' or zipCode = '73173' or zipCode = '73173' or zipCode = '73178' or zipCode = '73178' or zipCode = '73179' or zipCode = '73179' or zipCode = '73184' or zipCode = '73184' or zipCode = '73184' or zipCode = '73185' or zipCode = '73185' or zipCode = '73185' or zipCode = '73189' or zipCode = '73189' or zipCode = '73190' or zipCode = '73190' or zipCode = '73190' or zipCode = '73145' or zipCode = '73145' or zipCode = '73145' or zipCode = '73145' or zipCode = '73146' or zipCode = '73146' or zipCode = '73147' or zipCode = '73147' or zipCode = '73148' or zipCode = '73148' or zipCode = '73149' or zipCode = '73149' or zipCode = '73150' or zipCode = '73150' or zipCode = '73151' or zipCode = '73151' or zipCode = '73152' or zipCode = '73152' or zipCode = '73153' or zipCode = '73153' or zipCode = '73153' or zipCode = '73154' or zipCode = '73154' or zipCode = '73194' or zipCode = '73194' or zipCode = '73194' or zipCode = '73195' or zipCode = '73196' or zipCode = '73196' or zipCode = '73196' or zipCode = '73198' or zipCode = '73198' or zipCode = '73198' or zipCode = '73199' or zipCode = '73199' or zipCode = '73199' or zipCode = '74857' or zipCode = '73003' or zipCode = '73007' or zipCode = '73008' or zipCode = '73013' or zipCode = '73016' or zipCode = '73019' or zipCode = '73020' or zipCode = '73026' or zipCode = '73034' or zipCode = '73036' or zipCode = '73045' or zipCode = '73049' or zipCode = '73054' or zipCode = '73064' or zipCode = '73065' or zipCode = '73066' or zipCode = '73069' or zipCode = '73070' or zipCode = '73071' or zipCode = '73072' or zipCode = '73078' or zipCode = '73083' or zipCode = '73084' or zipCode = '73085' or zipCode = '73089' or zipCode = '73090' or zipCode = '73097' or zipCode = '73099' or zipCode = '73101' or zipCode = '73102' or zipCode = '73103' or zipCode = '73104' or zipCode = '73105' or zipCode = '73106' or zipCode = '73107' or zipCode = '73108' or zipCode = '73109' or zipCode = '73110' or zipCode = '73111' or zipCode = '73112' or zipCode = '73113' or zipCode = '73114' or zipCode = '73115' or zipCode = '73116' or zipCode = '73117' or zipCode = '73118' or zipCode = '73119' or zipCode = '73120' or zipCode = '73121' or zipCode = '73122' or zipCode = '73123' or zipCode = '73124' or zipCode = '73125' or zipCode = '73126' or zipCode = '73127' or zipCode = '73128' or zipCode = '73129' or zipCode = '73130' or zipCode = '73131' or zipCode = '73132' or zipCode = '73134' or zipCode = '73135' or zipCode = '73136' or zipCode = '73137' or zipCode = '73139' or zipCode = '73140' or zipCode = '73141' or zipCode = '73142' or zipCode = '73143' or zipCode = '73144' or zipCode = '73145' or zipCode = '73146' or zipCode = '73147' or zipCode = '73148' or zipCode = '73149' or zipCode = '73150' or zipCode = '73151' or zipCode = '73152' or zipCode = '73153' or zipCode = '73154' or zipCode = '73155' or zipCode = '73156' or zipCode = '73157' or zipCode = '73159' or zipCode = '73160' or zipCode = '73162' or zipCode = '73163' or zipCode = '73164' or zipCode = '73165' or zipCode = '73167' or zipCode = '73169' or zipCode = '73170' or zipCode = '73172' or zipCode = '73173' or zipCode = '73177' or zipCode = '73178' or zipCode = '73179' or zipCode = '73180' or zipCode = '73184' or zipCode = '73185' or zipCode = '73189' or zipCode = '73190' or zipCode = '73193' or zipCode = '73194' or zipCode = '73196' or zipCode = '73197' or zipCode = '73198' or zipCode = '73199' or zipCode = '74857') 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 ='73003' or zipCode = '73007' or zipCode = '73008' or zipCode = '73012' or zipCode = '73013' or zipCode = '73016' or zipCode = '73019' or zipCode = '73019' or zipCode = '73020' or zipCode = '73025' or zipCode = '73026' or zipCode = '73034' or zipCode = '73036' or zipCode = '73045' or zipCode = '73049' or zipCode = '73083' or zipCode = '73084' or zipCode = '73085' or zipCode = '73089' or zipCode = '73090' or zipCode = '73097' or zipCode = '73099' or zipCode = '73101' or zipCode = '73101' or zipCode = '73102' or zipCode = '73102' or zipCode = '73103' or zipCode = '73103' or zipCode = '73115' or zipCode = '73115' or zipCode = '73115' or zipCode = '73116' or zipCode = '73116' or zipCode = '73116' or zipCode = '73117' or zipCode = '73117' or zipCode = '73118' or zipCode = '73118' or zipCode = '73119' or zipCode = '73119' or zipCode = '73120' or zipCode = '73120' or zipCode = '73120' or zipCode = '73120' or zipCode = '73120' or zipCode = '73120' or zipCode = '73121' or zipCode = '73121' or zipCode = '73122' or zipCode = '73122' or zipCode = '73122' or zipCode = '73054' or zipCode = '73064' or zipCode = '73065' or zipCode = '73066' or zipCode = '73069' or zipCode = '73070' or zipCode = '73071' or zipCode = '73072' or zipCode = '73078' or zipCode = '73104' or zipCode = '73104' or zipCode = '73105' or zipCode = '73105' or zipCode = '73106' or zipCode = '73106' or zipCode = '73107' or zipCode = '73107' or zipCode = '73108' or zipCode = '73108' or zipCode = '73109' or zipCode = '73109' or zipCode = '73110' or zipCode = '73110' or zipCode = '73110' or zipCode = '73111' or zipCode = '73111' or zipCode = '73112' or zipCode = '73112' or zipCode = '73113' or zipCode = '73113' or zipCode = '73114' or zipCode = '73114' or zipCode = '73123' or zipCode = '73123' or zipCode = '73123' or zipCode = '73124' or zipCode = '73124' or zipCode = '73125' or zipCode = '73125' or zipCode = '73126' or zipCode = '73126' or zipCode = '73127' or zipCode = '73127' or zipCode = '73128' or zipCode = '73128' or zipCode = '73129' or zipCode = '73129' or zipCode = '73130' or zipCode = '73130' or zipCode = '73130' or zipCode = '73131' or zipCode = '73131' or zipCode = '73132' or zipCode = '73132' or zipCode = '73132' or zipCode = '73134' or zipCode = '73134' or zipCode = '73135' or zipCode = '73135' or zipCode = '73135' or zipCode = '73136' or zipCode = '73136' or zipCode = '73137' or zipCode = '73137' or zipCode = '73139' or zipCode = '73139' or zipCode = '73140' or zipCode = '73140' or zipCode = '73140' or zipCode = '73141' or zipCode = '73141' or zipCode = '73142' or zipCode = '73142' or zipCode = '73143' or zipCode = '73143' or zipCode = '73144' or zipCode = '73144' or zipCode = '73145' or zipCode = '73155' or zipCode = '73155' or zipCode = '73156' or zipCode = '73156' or zipCode = '73157' or zipCode = '73157' or zipCode = '73159' or zipCode = '73159' or zipCode = '73160' or zipCode = '73160' or zipCode = '73160' or zipCode = '73162' or zipCode = '73162' or zipCode = '73163' or zipCode = '73163' or zipCode = '73164' or zipCode = '73164' or zipCode = '73165' or zipCode = '73165' or zipCode = '73165' or zipCode = '73167' or zipCode = '73167' or zipCode = '73169' or zipCode = '73169' or zipCode = '73170' or zipCode = '73170' or zipCode = '73170' or zipCode = '73172' or zipCode = '73172' or zipCode = '73173' or zipCode = '73173' or zipCode = '73178' or zipCode = '73178' or zipCode = '73179' or zipCode = '73179' or zipCode = '73184' or zipCode = '73184' or zipCode = '73184' or zipCode = '73185' or zipCode = '73185' or zipCode = '73185' or zipCode = '73189' or zipCode = '73189' or zipCode = '73190' or zipCode = '73190' or zipCode = '73190' or zipCode = '73145' or zipCode = '73145' or zipCode = '73145' or zipCode = '73145' or zipCode = '73146' or zipCode = '73146' or zipCode = '73147' or zipCode = '73147' or zipCode = '73148' or zipCode = '73148' or zipCode = '73149' or zipCode = '73149' or zipCode = '73150' or zipCode = '73150' or zipCode = '73151' or zipCode = '73151' or zipCode = '73152' or zipCode = '73152' or zipCode = '73153' or zipCode = '73153' or zipCode = '73153' or zipCode = '73154' or zipCode = '73154' or zipCode = '73194' or zipCode = '73194' or zipCode = '73194' or zipCode = '73195' or zipCode = '73196' or zipCode = '73196' or zipCode = '73196' or zipCode = '73198' or zipCode = '73198' or zipCode = '73198' or zipCode = '73199' or zipCode = '73199' or zipCode = '73199' or zipCode = '74857' or zipCode = '73003' or zipCode = '73007' or zipCode = '73008' or zipCode = '73013' or zipCode = '73016' or zipCode = '73019' or zipCode = '73020' or zipCode = '73026' or zipCode = '73034' or zipCode = '73036' or zipCode = '73045' or zipCode = '73049' or zipCode = '73054' or zipCode = '73064' or zipCode = '73065' or zipCode = '73066' or zipCode = '73069' or zipCode = '73070' or zipCode = '73071' or zipCode = '73072' or zipCode = '73078' or zipCode = '73083' or zipCode = '73084' or zipCode = '73085' or zipCode = '73089' or zipCode = '73090' or zipCode = '73097' or zipCode = '73099' or zipCode = '73101' or zipCode = '73102' or zipCode = '73103' or zipCode = '73104' or zipCode = '73105' or zipCode = '73106' or zipCode = '73107' or zipCode = '73108' or zipCode = '73109' or zipCode = '73110' or zipCode = '73111' or zipCode = '73112' or zipCode = '73113' or zipCode = '73114' or zipCode = '73115' or zipCode = '73116' or zipCode = '73117' or zipCode = '73118' or zipCode = '73119' or zipCode = '73120' or zipCode = '73121' or zipCode = '73122' or zipCode = '73123' or zipCode = '73124' or zipCode = '73125' or zipCode = '73126' or zipCode = '73127' or zipCode = '73128' or zipCode = '73129' or zipCode = '73130' or zipCode = '73131' or zipCode = '73132' or zipCode = '73134' or zipCode = '73135' or zipCode = '73136' or zipCode = '73137' or zipCode = '73139' or zipCode = '73140' or zipCode = '73141' or zipCode = '73142' or zipCode = '73143' or zipCode = '73144' or zipCode = '73145' or zipCode = '73146' or zipCode = '73147' or zipCode = '73148' or zipCode = '73149' or zipCode = '73150' or zipCode = '73151' or zipCode = '73152' or zipCode = '73153' or zipCode = '73154' or zipCode = '73155' or zipCode = '73156' or zipCode = '73157' or zipCode = '73159' or zipCode = '73160' or zipCode = '73162' or zipCode = '73163' or zipCode = '73164' or zipCode = '73165' or zipCode = '73167' or zipCode = '73169' or zipCode = '73170' or zipCode = '73172' or zipCode = '73173' or zipCode = '73177' or zipCode = '73178' or zipCode = '73179' or zipCode = '73180' or zipCode = '73184' or zipCode = '73185' or zipCode = '73189' or zipCode = '73190' or zipCode = '73193' or zipCode = '73194' or zipCode = '73196' or zipCode = '73197' or zipCode = '73198' or zipCode = '73199' or zipCode = '74857') 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 ='73003' or zipCode = '73007' or zipCode = '73008' or zipCode = '73012' or zipCode = '73013' or zipCode = '73016' or zipCode = '73019' or zipCode = '73019' or zipCode = '73020' or zipCode = '73025' or zipCode = '73026' or zipCode = '73034' or zipCode = '73036' or zipCode = '73045' or zipCode = '73049' or zipCode = '73083' or zipCode = '73084' or zipCode = '73085' or zipCode = '73089' or zipCode = '73090' or zipCode = '73097' or zipCode = '73099' or zipCode = '73101' or zipCode = '73101' or zipCode = '73102' or zipCode = '73102' or zipCode = '73103' or zipCode = '73103' or zipCode = '73115' or zipCode = '73115' or zipCode = '73115' or zipCode = '73116' or zipCode = '73116' or zipCode = '73116' or zipCode = '73117' or zipCode = '73117' or zipCode = '73118' or zipCode = '73118' or zipCode = '73119' or zipCode = '73119' or zipCode = '73120' or zipCode = '73120' or zipCode = '73120' or zipCode = '73120' or zipCode = '73120' or zipCode = '73120' or zipCode = '73121' or zipCode = '73121' or zipCode = '73122' or zipCode = '73122' or zipCode = '73122' or zipCode = '73054' or zipCode = '73064' or zipCode = '73065' or zipCode = '73066' or zipCode = '73069' or zipCode = '73070' or zipCode = '73071' or zipCode = '73072' or zipCode = '73078' or zipCode = '73104' or zipCode = '73104' or zipCode = '73105' or zipCode = '73105' or zipCode = '73106' or zipCode = '73106' or zipCode = '73107' or zipCode = '73107' or zipCode = '73108' or zipCode = '73108' or zipCode = '73109' or zipCode = '73109' or zipCode = '73110' or zipCode = '73110' or zipCode = '73110' or zipCode = '73111' or zipCode = '73111' or zipCode = '73112' or zipCode = '73112' or zipCode = '73113' or zipCode = '73113' or zipCode = '73114' or zipCode = '73114' or zipCode = '73123' or zipCode = '73123' or zipCode = '73123' or zipCode = '73124' or zipCode = '73124' or zipCode = '73125' or zipCode = '73125' or zipCode = '73126' or zipCode = '73126' or zipCode = '73127' or zipCode = '73127' or zipCode = '73128' or zipCode = '73128' or zipCode = '73129' or zipCode = '73129' or zipCode = '73130' or zipCode = '73130' or zipCode = '73130' or zipCode = '73131' or zipCode = '73131' or zipCode = '73132' or zipCode = '73132' or zipCode = '73132' or zipCode = '73134' or zipCode = '73134' or zipCode = '73135' or zipCode = '73135' or zipCode = '73135' or zipCode = '73136' or zipCode = '73136' or zipCode = '73137' or zipCode = '73137' or zipCode = '73139' or zipCode = '73139' or zipCode = '73140' or zipCode = '73140' or zipCode = '73140' or zipCode = '73141' or zipCode = '73141' or zipCode = '73142' or zipCode = '73142' or zipCode = '73143' or zipCode = '73143' or zipCode = '73144' or zipCode = '73144' or zipCode = '73145' or zipCode = '73155' or zipCode = '73155' or zipCode = '73156' or zipCode = '73156' or zipCode = '73157' or zipCode = '73157' or zipCode = '73159' or zipCode = '73159' or zipCode = '73160' or zipCode = '73160' or zipCode = '73160' or zipCode = '73162' or zipCode = '73162' or zipCode = '73163' or zipCode = '73163' or zipCode = '73164' or zipCode = '73164' or zipCode = '73165' or zipCode = '73165' or zipCode = '73165' or zipCode = '73167' or zipCode = '73167' or zipCode = '73169' or zipCode = '73169' or zipCode = '73170' or zipCode = '73170' or zipCode = '73170' or zipCode = '73172' or zipCode = '73172' or zipCode = '73173' or zipCode = '73173' or zipCode = '73178' or zipCode = '73178' or zipCode = '73179' or zipCode = '73179' or zipCode = '73184' or zipCode = '73184' or zipCode = '73184' or zipCode = '73185' or zipCode = '73185' or zipCode = '73185' or zipCode = '73189' or zipCode = '73189' or zipCode = '73190' or zipCode = '73190' or zipCode = '73190' or zipCode = '73145' or zipCode = '73145' or zipCode = '73145' or zipCode = '73145' or zipCode = '73146' or zipCode = '73146' or zipCode = '73147' or zipCode = '73147' or zipCode = '73148' or zipCode = '73148' or zipCode = '73149' or zipCode = '73149' or zipCode = '73150' or zipCode = '73150' or zipCode = '73151' or zipCode = '73151' or zipCode = '73152' or zipCode = '73152' or zipCode = '73153' or zipCode = '73153' or zipCode = '73153' or zipCode = '73154' or zipCode = '73154' or zipCode = '73194' or zipCode = '73194' or zipCode = '73194' or zipCode = '73195' or zipCode = '73196' or zipCode = '73196' or zipCode = '73196' or zipCode = '73198' or zipCode = '73198' or zipCode = '73198' or zipCode = '73199' or zipCode = '73199' or zipCode = '73199' or zipCode = '74857' or zipCode = '73003' or zipCode = '73007' or zipCode = '73008' or zipCode = '73013' or zipCode = '73016' or zipCode = '73019' or zipCode = '73020' or zipCode = '73026' or zipCode = '73034' or zipCode = '73036' or zipCode = '73045' or zipCode = '73049' or zipCode = '73054' or zipCode = '73064' or zipCode = '73065' or zipCode = '73066' or zipCode = '73069' or zipCode = '73070' or zipCode = '73071' or zipCode = '73072' or zipCode = '73078' or zipCode = '73083' or zipCode = '73084' or zipCode = '73085' or zipCode = '73089' or zipCode = '73090' or zipCode = '73097' or zipCode = '73099' or zipCode = '73101' or zipCode = '73102' or zipCode = '73103' or zipCode = '73104' or zipCode = '73105' or zipCode = '73106' or zipCode = '73107' or zipCode = '73108' or zipCode = '73109' or zipCode = '73110' or zipCode = '73111' or zipCode = '73112' or zipCode = '73113' or zipCode = '73114' or zipCode = '73115' or zipCode = '73116' or zipCode = '73117' or zipCode = '73118' or zipCode = '73119' or zipCode = '73120' or zipCode = '73121' or zipCode = '73122' or zipCode = '73123' or zipCode = '73124' or zipCode = '73125' or zipCode = '73126' or zipCode = '73127' or zipCode = '73128' or zipCode = '73129' or zipCode = '73130' or zipCode = '73131' or zipCode = '73132' or zipCode = '73134' or zipCode = '73135' or zipCode = '73136' or zipCode = '73137' or zipCode = '73139' or zipCode = '73140' or zipCode = '73141' or zipCode = '73142' or zipCode = '73143' or zipCode = '73144' or zipCode = '73145' or zipCode = '73146' or zipCode = '73147' or zipCode = '73148' or zipCode = '73149' or zipCode = '73150' or zipCode = '73151' or zipCode = '73152' or zipCode = '73153' or zipCode = '73154' or zipCode = '73155' or zipCode = '73156' or zipCode = '73157' or zipCode = '73159' or zipCode = '73160' or zipCode = '73162' or zipCode = '73163' or zipCode = '73164' or zipCode = '73165' or zipCode = '73167' or zipCode = '73169' or zipCode = '73170' or zipCode = '73172' or zipCode = '73173' or zipCode = '73177' or zipCode = '73178' or zipCode = '73179' or zipCode = '73180' or zipCode = '73184' or zipCode = '73185' or zipCode = '73189' or zipCode = '73190' or zipCode = '73193' or zipCode = '73194' or zipCode = '73196' or zipCode = '73197' or zipCode = '73198' or zipCode = '73199' or zipCode = '74857') 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 ='73003' or property_zip = '73007' or property_zip = '73008' or property_zip = '73012' or property_zip = '73013' or property_zip = '73016' or property_zip = '73019' or property_zip = '73019' or property_zip = '73020' or property_zip = '73025' or property_zip = '73026' or property_zip = '73034' or property_zip = '73036' or property_zip = '73045' or property_zip = '73049' or property_zip = '73083' or property_zip = '73084' or property_zip = '73085' or property_zip = '73089' or property_zip = '73090' or property_zip = '73097' or property_zip = '73099' or property_zip = '73101' or property_zip = '73101' or property_zip = '73102' or property_zip = '73102' or property_zip = '73103' or property_zip = '73103' or property_zip = '73115' or property_zip = '73115' or property_zip = '73115' or property_zip = '73116' or property_zip = '73116' or property_zip = '73116' or property_zip = '73117' or property_zip = '73117' or property_zip = '73118' or property_zip = '73118' or property_zip = '73119' or property_zip = '73119' or property_zip = '73120' or property_zip = '73120' or property_zip = '73120' or property_zip = '73120' or property_zip = '73120' or property_zip = '73120' or property_zip = '73121' or property_zip = '73121' or property_zip = '73122' or property_zip = '73122' or property_zip = '73122' or property_zip = '73054' or property_zip = '73064' or property_zip = '73065' or property_zip = '73066' or property_zip = '73069' or property_zip = '73070' or property_zip = '73071' or property_zip = '73072' or property_zip = '73078' or property_zip = '73104' or property_zip = '73104' or property_zip = '73105' or property_zip = '73105' or property_zip = '73106' or property_zip = '73106' or property_zip = '73107' or property_zip = '73107' or property_zip = '73108' or property_zip = '73108' or property_zip = '73109' or property_zip = '73109' or property_zip = '73110' or property_zip = '73110' or property_zip = '73110' or property_zip = '73111' or property_zip = '73111' or property_zip = '73112' or property_zip = '73112' or property_zip = '73113' or property_zip = '73113' or property_zip = '73114' or property_zip = '73114' or property_zip = '73123' or property_zip = '73123' or property_zip = '73123' or property_zip = '73124' or property_zip = '73124' or property_zip = '73125' or property_zip = '73125' or property_zip = '73126' or property_zip = '73126' or property_zip = '73127' or property_zip = '73127' or property_zip = '73128' or property_zip = '73128' or property_zip = '73129' or property_zip = '73129' or property_zip = '73130' or property_zip = '73130' or property_zip = '73130' or property_zip = '73131' or property_zip = '73131' or property_zip = '73132' or property_zip = '73132' or property_zip = '73132' or property_zip = '73134' or property_zip = '73134' or property_zip = '73135' or property_zip = '73135' or property_zip = '73135' or property_zip = '73136' or property_zip = '73136' or property_zip = '73137' or property_zip = '73137' or property_zip = '73139' or property_zip = '73139' or property_zip = '73140' or property_zip = '73140' or property_zip = '73140' or property_zip = '73141' or property_zip = '73141' or property_zip = '73142' or property_zip = '73142' or property_zip = '73143' or property_zip = '73143' or property_zip = '73144' or property_zip = '73144' or property_zip = '73145' or property_zip = '73155' or property_zip = '73155' or property_zip = '73156' or property_zip = '73156' or property_zip = '73157' or property_zip = '73157' or property_zip = '73159' or property_zip = '73159' or property_zip = '73160' or property_zip = '73160' or property_zip = '73160' or property_zip = '73162' or property_zip = '73162' or property_zip = '73163' or property_zip = '73163' or property_zip = '73164' or property_zip = '73164' or property_zip = '73165' or property_zip = '73165' or property_zip = '73165' or property_zip = '73167' or property_zip = '73167' or property_zip = '73169' or property_zip = '73169' or property_zip = '73170' or property_zip = '73170' or property_zip = '73170' or property_zip = '73172' or property_zip = '73172' or property_zip = '73173' or property_zip = '73173' or property_zip = '73178' or property_zip = '73178' or property_zip = '73179' or property_zip = '73179' or property_zip = '73184' or property_zip = '73184' or property_zip = '73184' or property_zip = '73185' or property_zip = '73185' or property_zip = '73185' or property_zip = '73189' or property_zip = '73189' or property_zip = '73190' or property_zip = '73190' or property_zip = '73190' or property_zip = '73145' or property_zip = '73145' or property_zip = '73145' or property_zip = '73145' or property_zip = '73146' or property_zip = '73146' or property_zip = '73147' or property_zip = '73147' or property_zip = '73148' or property_zip = '73148' or property_zip = '73149' or property_zip = '73149' or property_zip = '73150' or property_zip = '73150' or property_zip = '73151' or property_zip = '73151' or property_zip = '73152' or property_zip = '73152' or property_zip = '73153' or property_zip = '73153' or property_zip = '73153' or property_zip = '73154' or property_zip = '73154' or property_zip = '73194' or property_zip = '73194' or property_zip = '73194' or property_zip = '73195' or property_zip = '73196' or property_zip = '73196' or property_zip = '73196' or property_zip = '73198' or property_zip = '73198' or property_zip = '73198' or property_zip = '73199' or property_zip = '73199' or property_zip = '73199' or property_zip = '74857' or property_zip = '73003' or property_zip = '73007' or property_zip = '73008' or property_zip = '73013' or property_zip = '73016' or property_zip = '73019' or property_zip = '73020' or property_zip = '73026' or property_zip = '73034' or property_zip = '73036' or property_zip = '73045' or property_zip = '73049' or property_zip = '73054' or property_zip = '73064' or property_zip = '73065' or property_zip = '73066' or property_zip = '73069' or property_zip = '73070' or property_zip = '73071' or property_zip = '73072' or property_zip = '73078' or property_zip = '73083' or property_zip = '73084' or property_zip = '73085' or property_zip = '73089' or property_zip = '73090' or property_zip = '73097' or property_zip = '73099' or property_zip = '73101' or property_zip = '73102' or property_zip = '73103' or property_zip = '73104' or property_zip = '73105' or property_zip = '73106' or property_zip = '73107' or property_zip = '73108' or property_zip = '73109' or property_zip = '73110' or property_zip = '73111' or property_zip = '73112' or property_zip = '73113' or property_zip = '73114' or property_zip = '73115' or property_zip = '73116' or property_zip = '73117' or property_zip = '73118' or property_zip = '73119' or property_zip = '73120' or property_zip = '73121' or property_zip = '73122' or property_zip = '73123' or property_zip = '73124' or property_zip = '73125' or property_zip = '73126' or property_zip = '73127' or property_zip = '73128' or property_zip = '73129' or property_zip = '73130' or property_zip = '73131' or property_zip = '73132' or property_zip = '73134' or property_zip = '73135' or property_zip = '73136' or property_zip = '73137' or property_zip = '73139' or property_zip = '73140' or property_zip = '73141' or property_zip = '73142' or property_zip = '73143' or property_zip = '73144' or property_zip = '73145' or property_zip = '73146' or property_zip = '73147' or property_zip = '73148' or property_zip = '73149' or property_zip = '73150' or property_zip = '73151' or property_zip = '73152' or property_zip = '73153' or property_zip = '73154' or property_zip = '73155' or property_zip = '73156' or property_zip = '73157' or property_zip = '73159' or property_zip = '73160' or property_zip = '73162' or property_zip = '73163' or property_zip = '73164' or property_zip = '73165' or property_zip = '73167' or property_zip = '73169' or property_zip = '73170' or property_zip = '73172' or property_zip = '73173' or property_zip = '73177' or property_zip = '73178' or property_zip = '73179' or property_zip = '73180' or property_zip = '73184' or property_zip = '73185' or property_zip = '73189' or property_zip = '73190' or property_zip = '73193' or property_zip = '73194' or property_zip = '73196' or property_zip = '73197' or property_zip = '73198' or property_zip = '73199' or property_zip = '74857') and convert(date,auction_start_date) >= '9/27/2021';
select top 45 * from currentforeclosures.tblAll NOLOCK where state = 'OK '
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 ='73003' or zip = '73007' or zip = '73008' or zip = '73012' or zip = '73013' or zip = '73016' or zip = '73019' or zip = '73019' or zip = '73020' or zip = '73025' or zip = '73026' or zip = '73034' or zip = '73036' or zip = '73045' or zip = '73049' or zip = '73083' or zip = '73084' or zip = '73085' or zip = '73089' or zip = '73090' or zip = '73097' or zip = '73099' or zip = '73101' or zip = '73101' or zip = '73102' or zip = '73102' or zip = '73103' or zip = '73103' or zip = '73115' or zip = '73115' or zip = '73115' or zip = '73116' or zip = '73116' or zip = '73116' or zip = '73117' or zip = '73117' or zip = '73118' or zip = '73118' or zip = '73119' or zip = '73119' or zip = '73120' or zip = '73120' or zip = '73120' or zip = '73120' or zip = '73120' or zip = '73120' or zip = '73121' or zip = '73121' or zip = '73122' or zip = '73122' or zip = '73122' or zip = '73054' or zip = '73064' or zip = '73065' or zip = '73066' or zip = '73069' or zip = '73070' or zip = '73071' or zip = '73072' or zip = '73078' or zip = '73104' or zip = '73104' or zip = '73105' or zip = '73105' or zip = '73106' or zip = '73106' or zip = '73107' or zip = '73107' or zip = '73108' or zip = '73108' or zip = '73109' or zip = '73109' or zip = '73110' or zip = '73110' or zip = '73110' or zip = '73111' or zip = '73111' or zip = '73112' or zip = '73112' or zip = '73113' or zip = '73113' or zip = '73114' or zip = '73114' or zip = '73123' or zip = '73123' or zip = '73123' or zip = '73124' or zip = '73124' or zip = '73125' or zip = '73125' or zip = '73126' or zip = '73126' or zip = '73127' or zip = '73127' or zip = '73128' or zip = '73128' or zip = '73129' or zip = '73129' or zip = '73130' or zip = '73130' or zip = '73130' or zip = '73131' or zip = '73131' or zip = '73132' or zip = '73132' or zip = '73132' or zip = '73134' or zip = '73134' or zip = '73135' or zip = '73135' or zip = '73135' or zip = '73136' or zip = '73136' or zip = '73137' or zip = '73137' or zip = '73139' or zip = '73139' or zip = '73140' or zip = '73140' or zip = '73140' or zip = '73141' or zip = '73141' or zip = '73142' or zip = '73142' or zip = '73143' or zip = '73143' or zip = '73144' or zip = '73144' or zip = '73145' or zip = '73155' or zip = '73155' or zip = '73156' or zip = '73156' or zip = '73157' or zip = '73157' or zip = '73159' or zip = '73159' or zip = '73160' or zip = '73160' or zip = '73160' or zip = '73162' or zip = '73162' or zip = '73163' or zip = '73163' or zip = '73164' or zip = '73164' or zip = '73165' or zip = '73165' or zip = '73165' or zip = '73167' or zip = '73167' or zip = '73169' or zip = '73169' or zip = '73170' or zip = '73170' or zip = '73170' or zip = '73172' or zip = '73172' or zip = '73173' or zip = '73173' or zip = '73178' or zip = '73178' or zip = '73179' or zip = '73179' or zip = '73184' or zip = '73184' or zip = '73184' or zip = '73185' or zip = '73185' or zip = '73185' or zip = '73189' or zip = '73189' or zip = '73190' or zip = '73190' or zip = '73190' or zip = '73145' or zip = '73145' or zip = '73145' or zip = '73145' or zip = '73146' or zip = '73146' or zip = '73147' or zip = '73147' or zip = '73148' or zip = '73148' or zip = '73149' or zip = '73149' or zip = '73150' or zip = '73150' or zip = '73151' or zip = '73151' or zip = '73152' or zip = '73152' or zip = '73153' or zip = '73153' or zip = '73153' or zip = '73154' or zip = '73154' or zip = '73194' or zip = '73194' or zip = '73194' or zip = '73195' or zip = '73196' or zip = '73196' or zip = '73196' or zip = '73198' or zip = '73198' or zip = '73198' or zip = '73199' or zip = '73199' or zip = '73199' or zip = '74857' or zip = '73003' or zip = '73007' or zip = '73008' or zip = '73013' or zip = '73016' or zip = '73019' or zip = '73020' or zip = '73026' or zip = '73034' or zip = '73036' or zip = '73045' or zip = '73049' or zip = '73054' or zip = '73064' or zip = '73065' or zip = '73066' or zip = '73069' or zip = '73070' or zip = '73071' or zip = '73072' or zip = '73078' or zip = '73083' or zip = '73084' or zip = '73085' or zip = '73089' or zip = '73090' or zip = '73097' or zip = '73099' or zip = '73101' or zip = '73102' or zip = '73103' or zip = '73104' or zip = '73105' or zip = '73106' or zip = '73107' or zip = '73108' or zip = '73109' or zip = '73110' or zip = '73111' or zip = '73112' or zip = '73113' or zip = '73114' or zip = '73115' or zip = '73116' or zip = '73117' or zip = '73118' or zip = '73119' or zip = '73120' or zip = '73121' or zip = '73122' or zip = '73123' or zip = '73124' or zip = '73125' or zip = '73126' or zip = '73127' or zip = '73128' or zip = '73129' or zip = '73130' or zip = '73131' or zip = '73132' or zip = '73134' or zip = '73135' or zip = '73136' or zip = '73137' or zip = '73139' or zip = '73140' or zip = '73141' or zip = '73142' or zip = '73143' or zip = '73144' or zip = '73145' or zip = '73146' or zip = '73147' or zip = '73148' or zip = '73149' or zip = '73150' or zip = '73151' or zip = '73152' or zip = '73153' or zip = '73154' or zip = '73155' or zip = '73156' or zip = '73157' or zip = '73159' or zip = '73160' or zip = '73162' or zip = '73163' or zip = '73164' or zip = '73165' or zip = '73167' or zip = '73169' or zip = '73170' or zip = '73172' or zip = '73173' or zip = '73177' or zip = '73178' or zip = '73179' or zip = '73180' or zip = '73184' or zip = '73185' or zip = '73189' or zip = '73190' or zip = '73193' or zip = '73194' or zip = '73196' or zip = '73197' or zip = '73198' or zip = '73199' or zip = '74857')
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 = 'OK' and city = 'OKLAHOMA CITY' and state = 'OK ' 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();