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


313+ High Potential Investor Deals Near dallas [Refine]


********NOTICE: Displaying 99 of over 313 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 ='75001' or zipCode = '75002' or zipCode = '75002' or zipCode = '75006' or zipCode = '75007' or zipCode = '75010' or zipCode = '75011' or zipCode = '75013' or zipCode = '75014' or zipCode = '75015' or zipCode = '75016' or zipCode = '75017' or zipCode = '75019' or zipCode = '75023' or zipCode = '75024' or zipCode = '75025' or zipCode = '75026' or zipCode = '75027' or zipCode = '75027' or zipCode = '75027' or zipCode = '75028' or zipCode = '75028' or zipCode = '75028' or zipCode = '75029' or zipCode = '75030' or zipCode = '75032' or zipCode = '75032' or zipCode = '75037' or zipCode = '75037' or zipCode = '75038' or zipCode = '75039' or zipCode = '75040' or zipCode = '75041' or zipCode = '75042' or zipCode = '75043' or zipCode = '75044' or zipCode = '75045' or zipCode = '75046' or zipCode = '75047' or zipCode = '75048' or zipCode = '75048' or zipCode = '75049' or zipCode = '75050' or zipCode = '75051' or zipCode = '75052' or zipCode = '75053' or zipCode = '75054' or zipCode = '75056' or zipCode = '75056' or zipCode = '75057' or zipCode = '75060' or zipCode = '75061' or zipCode = '75062' or zipCode = '75063' or zipCode = '75067' or zipCode = '75067' or zipCode = '75088' or zipCode = '75089' or zipCode = '75093' or zipCode = '75094' or zipCode = '75094' or zipCode = '75098' or zipCode = '75098' or zipCode = '75099' or zipCode = '75099' or zipCode = '75099' or zipCode = '75104' or zipCode = '75106' or zipCode = '75114' or zipCode = '75146' or zipCode = '75149' or zipCode = '75150' or zipCode = '75154' or zipCode = '75154' or zipCode = '75154' or zipCode = '75154' or zipCode = '75202' or zipCode = '75203' or zipCode = '75204' or zipCode = '75205' or zipCode = '75205' or zipCode = '75205' or zipCode = '75205' or zipCode = '75206' or zipCode = '75207' or zipCode = '75208' or zipCode = '75209' or zipCode = '75209' or zipCode = '75210' or zipCode = '75211' or zipCode = '75211' or zipCode = '75212' or zipCode = '75214' or zipCode = '75215' or zipCode = '75216' or zipCode = '75217' or zipCode = '75218' or zipCode = '75219' or zipCode = '75219' or zipCode = '75220' or zipCode = '75244' or zipCode = '75244' or zipCode = '75244' or zipCode = '75244' or zipCode = '75245' or zipCode = '75246' or zipCode = '75247' or zipCode = '75248' or zipCode = '75249' or zipCode = '75250' or zipCode = '75251' or zipCode = '75252' or zipCode = '75252' or zipCode = '75253' or zipCode = '75253' or zipCode = '75254' or zipCode = '75258' or zipCode = '75260' or zipCode = '75261' or zipCode = '75261' or zipCode = '75261' or zipCode = '75262' or zipCode = '75263' or zipCode = '75264' or zipCode = '75074' or zipCode = '75074' or zipCode = '75075' or zipCode = '75080' or zipCode = '75080' or zipCode = '75081' or zipCode = '75082' or zipCode = '75083' or zipCode = '75085' or zipCode = '75086' or zipCode = '75087' or zipCode = '75115' or zipCode = '75116' or zipCode = '75123' or zipCode = '75125' or zipCode = '75126' or zipCode = '75126' or zipCode = '75126' or zipCode = '75134' or zipCode = '75137' or zipCode = '75138' or zipCode = '75141' or zipCode = '75159' or zipCode = '75159' or zipCode = '75172' or zipCode = '75180' or zipCode = '75180' or zipCode = '75181' or zipCode = '75181' or zipCode = '75182' or zipCode = '75182' or zipCode = '75185' or zipCode = '75187' or zipCode = '75201' or zipCode = '75221' or zipCode = '75222' or zipCode = '75223' or zipCode = '75224' or zipCode = '75225' or zipCode = '75226' or zipCode = '75227' or zipCode = '75228' or zipCode = '75229' or zipCode = '75230' or zipCode = '75231' or zipCode = '75232' or zipCode = '75233' or zipCode = '75234' or zipCode = '75234' or zipCode = '75234' or zipCode = '75235' or zipCode = '75236' or zipCode = '75237' or zipCode = '75238' or zipCode = '75240' or zipCode = '75241' or zipCode = '75242' or zipCode = '75243' or zipCode = '75265' or zipCode = '75266' or zipCode = '75267' or zipCode = '75270' or zipCode = '75275' or zipCode = '75275' or zipCode = '75277' or zipCode = '75277' or zipCode = '75283' or zipCode = '75283' or zipCode = '75283' or zipCode = '75284' or zipCode = '75284' or zipCode = '75285' or zipCode = '75285' or zipCode = '75286' or zipCode = '75286' or zipCode = '75287' or zipCode = '75301' or zipCode = '75301' or zipCode = '75303' or zipCode = '75303' or zipCode = '75310' or zipCode = '75310' or zipCode = '75312' or zipCode = '75312' or zipCode = '75313' or zipCode = '75315' or zipCode = '75320' or zipCode = '75320' or zipCode = '75323' or zipCode = '75323' or zipCode = '75326' or zipCode = '75326' or zipCode = '75334' or zipCode = '75336' or zipCode = '75336' or zipCode = '75339' or zipCode = '75340' or zipCode = '75342' or zipCode = '75343' or zipCode = '75344' or zipCode = '75354' or zipCode = '75355' or zipCode = '75356' or zipCode = '75357' or zipCode = '75358' or zipCode = '75358' or zipCode = '75391' or zipCode = '75392' or zipCode = '75392' or zipCode = '75393' or zipCode = '75393' or zipCode = '75394' or zipCode = '75394' or zipCode = '75395' or zipCode = '75395' or zipCode = '75397' or zipCode = '75397' or zipCode = '75398' or zipCode = '75359' or zipCode = '75360' or zipCode = '75367' or zipCode = '75368' or zipCode = '75368' or zipCode = '75370' or zipCode = '75371' or zipCode = '75372' or zipCode = '75373' or zipCode = '75373' or zipCode = '75374' or zipCode = '75376' or zipCode = '75378' or zipCode = '75379' or zipCode = '75380' or zipCode = '75381' or zipCode = '75382' or zipCode = '75387' or zipCode = '75387' or zipCode = '75389' or zipCode = '75389' or zipCode = '75390' or zipCode = '75390' or zipCode = '75391' or zipCode = '76015' or zipCode = '76016' or zipCode = '76016' or zipCode = '76017' or zipCode = '76018' or zipCode = '76019' or zipCode = '76019' or zipCode = '76019' or zipCode = '76021' or zipCode = '76022' or zipCode = '76034' or zipCode = '76039' or zipCode = '76040' or zipCode = '76092' or zipCode = '76092' or zipCode = '76094' or zipCode = '76095' or zipCode = '76096' or zipCode = '76099' or zipCode = '76112' or zipCode = '76001' or zipCode = '76002' or zipCode = '76003' or zipCode = '76004' or zipCode = '76005' or zipCode = '76006' or zipCode = '76007' or zipCode = '76010' or zipCode = '76011' or zipCode = '76012' or zipCode = '76013' or zipCode = '76013' or zipCode = '76014' or zipCode = '76015' or zipCode = '76051' or zipCode = '76053' or zipCode = '76054' or zipCode = '76063' or zipCode = '76118' or zipCode = '76118' or zipCode = '76118' or zipCode = '76118' or zipCode = '76118' or zipCode = '76120' or zipCode = '76155' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '75001' or zipCode = '75002' or zipCode = '75006' or zipCode = '75007' or zipCode = '75010' or zipCode = '75011' or zipCode = '75013' or zipCode = '75014' or zipCode = '75015' or zipCode = '75016' or zipCode = '75017' or zipCode = '75019' or zipCode = '75022' or zipCode = '75023' or zipCode = '75024' or zipCode = '75025' or zipCode = '75028' or zipCode = '75030' or zipCode = '75032' or zipCode = '75034' or zipCode = '75035' or zipCode = '75037' or zipCode = '75038' or zipCode = '75039' or zipCode = '75040' or zipCode = '75041' or zipCode = '75042' or zipCode = '75043' or zipCode = '75044' or zipCode = '75045' or zipCode = '75046' or zipCode = '75047' or zipCode = '75048' or zipCode = '75049' or zipCode = '75050' or zipCode = '75051' or zipCode = '75052' or zipCode = '75053' or zipCode = '75054' or zipCode = '75056' or zipCode = '75057' or zipCode = '75059' or zipCode = '75060' or zipCode = '75061' or zipCode = '75062' or zipCode = '75063' or zipCode = '75066' or zipCode = '75067' or zipCode = '75074' or zipCode = '75075' or zipCode = '75077' or zipCode = '75080' or zipCode = '75081' or zipCode = '75082' or zipCode = '75083' or zipCode = '75085' or zipCode = '75086' or zipCode = '75087' or zipCode = '75088' or zipCode = '75089' or zipCode = '75093' or zipCode = '75094' or zipCode = '75098' or zipCode = '75099' or zipCode = '75104' or zipCode = '75106' or zipCode = '75114' or zipCode = '75115' or zipCode = '75116' or zipCode = '75123' or zipCode = '75125' or zipCode = '75126' or zipCode = '75134' or zipCode = '75137' or zipCode = '75138' or zipCode = '75141' or zipCode = '75146' or zipCode = '75149' or zipCode = '75150' or zipCode = '75154' or zipCode = '75159' or zipCode = '75172' or zipCode = '75180' or zipCode = '75181' or zipCode = '75182' or zipCode = '75185' or zipCode = '75187' or zipCode = '75201' or zipCode = '75202' or zipCode = '75203' or zipCode = '75204' or zipCode = '75205' or zipCode = '75206' or zipCode = '75207' or zipCode = '75208' or zipCode = '75209' or zipCode = '75210' or zipCode = '75211' or zipCode = '75212' or zipCode = '75214' or zipCode = '75215' or zipCode = '75216' or zipCode = '75217' or zipCode = '75218' or zipCode = '75219' or zipCode = '75220' or zipCode = '75221' or zipCode = '75222' or zipCode = '75223' or zipCode = '75224' or zipCode = '75225' or zipCode = '75226' or zipCode = '75227' or zipCode = '75228' or zipCode = '75229' or zipCode = '75230' or zipCode = '75231' or zipCode = '75232' or zipCode = '75233' or zipCode = '75234' or zipCode = '75235' or zipCode = '75236' or zipCode = '75237' or zipCode = '75238' or zipCode = '75239' or zipCode = '75240' or zipCode = '75241' or zipCode = '75242' or zipCode = '75243' or zipCode = '75244' or zipCode = '75245' or zipCode = '75246' or zipCode = '75247' or zipCode = '75248' or zipCode = '75249' or zipCode = '75250' or zipCode = '75251' or zipCode = '75252' or zipCode = '75253' or zipCode = '75254' or zipCode = '75255' or zipCode = '75258' or zipCode = '75260' or zipCode = '75261' or zipCode = '75262' or zipCode = '75263' or zipCode = '75264' or zipCode = '75265' or zipCode = '75266' or zipCode = '75267' or zipCode = '75270' or zipCode = '75275' or zipCode = '75277' or zipCode = '75283' or zipCode = '75284' or zipCode = '75285' or zipCode = '75286' or zipCode = '75287' or zipCode = '75294' or zipCode = '75295' or zipCode = '75301' or zipCode = '75303' or zipCode = '75310' or zipCode = '75312' or zipCode = '75313' or zipCode = '75315' or zipCode = '75320' or zipCode = '75323' or zipCode = '75326' or zipCode = '75336' or zipCode = '75339' or zipCode = '75342' or zipCode = '75346' or zipCode = '75350' or zipCode = '75353' or zipCode = '75354' or zipCode = '75355' or zipCode = '75356' or zipCode = '75357' or zipCode = '75359' or zipCode = '75360' or zipCode = '75363' or zipCode = '75364' or zipCode = '75367' or zipCode = '75368' or zipCode = '75370' or zipCode = '75371' or zipCode = '75372' or zipCode = '75373' or zipCode = '75374' or zipCode = '75376' or zipCode = '75378' or zipCode = '75379' or zipCode = '75380' or zipCode = '75381' or zipCode = '75382' or zipCode = '75386' or zipCode = '75387' or zipCode = '75388' or zipCode = '75389' or zipCode = '75390' or zipCode = '75391' or zipCode = '75392' or zipCode = '75393' or zipCode = '75394' or zipCode = '75395' or zipCode = '75396' or zipCode = '75397' or zipCode = '75398' or zipCode = '76001' or zipCode = '76002' or zipCode = '76003' or zipCode = '76006' or zipCode = '76010' or zipCode = '76011' or zipCode = '76012' or zipCode = '76013' or zipCode = '76014' or zipCode = '76015' or zipCode = '76016' or zipCode = '76017' or zipCode = '76018' or zipCode = '76021' or zipCode = '76022' or zipCode = '76025' or zipCode = '76034' or zipCode = '76039' or zipCode = '76040' or zipCode = '76051' or zipCode = '76053' or zipCode = '76054' or zipCode = '76063' or zipCode = '76065' or zipCode = '76092' or zipCode = '76112' or zipCode = '76118' or zipCode = '76120' or zipCode = '76155' or zipCode = '76180')
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 ='75001' or zipCode = '75002' or zipCode = '75002' or zipCode = '75006' or zipCode = '75007' or zipCode = '75010' or zipCode = '75011' or zipCode = '75013' or zipCode = '75014' or zipCode = '75015' or zipCode = '75016' or zipCode = '75017' or zipCode = '75019' or zipCode = '75023' or zipCode = '75024' or zipCode = '75025' or zipCode = '75026' or zipCode = '75027' or zipCode = '75027' or zipCode = '75027' or zipCode = '75028' or zipCode = '75028' or zipCode = '75028' or zipCode = '75029' or zipCode = '75030' or zipCode = '75032' or zipCode = '75032' or zipCode = '75037' or zipCode = '75037' or zipCode = '75038' or zipCode = '75039' or zipCode = '75040' or zipCode = '75041' or zipCode = '75042' or zipCode = '75043' or zipCode = '75044' or zipCode = '75045' or zipCode = '75046' or zipCode = '75047' or zipCode = '75048' or zipCode = '75048' or zipCode = '75049' or zipCode = '75050' or zipCode = '75051' or zipCode = '75052' or zipCode = '75053' or zipCode = '75054' or zipCode = '75056' or zipCode = '75056' or zipCode = '75057' or zipCode = '75060' or zipCode = '75061' or zipCode = '75062' or zipCode = '75063' or zipCode = '75067' or zipCode = '75067' or zipCode = '75088' or zipCode = '75089' or zipCode = '75093' or zipCode = '75094' or zipCode = '75094' or zipCode = '75098' or zipCode = '75098' or zipCode = '75099' or zipCode = '75099' or zipCode = '75099' or zipCode = '75104' or zipCode = '75106' or zipCode = '75114' or zipCode = '75146' or zipCode = '75149' or zipCode = '75150' or zipCode = '75154' or zipCode = '75154' or zipCode = '75154' or zipCode = '75154' or zipCode = '75202' or zipCode = '75203' or zipCode = '75204' or zipCode = '75205' or zipCode = '75205' or zipCode = '75205' or zipCode = '75205' or zipCode = '75206' or zipCode = '75207' or zipCode = '75208' or zipCode = '75209' or zipCode = '75209' or zipCode = '75210' or zipCode = '75211' or zipCode = '75211' or zipCode = '75212' or zipCode = '75214' or zipCode = '75215' or zipCode = '75216' or zipCode = '75217' or zipCode = '75218' or zipCode = '75219' or zipCode = '75219' or zipCode = '75220' or zipCode = '75244' or zipCode = '75244' or zipCode = '75244' or zipCode = '75244' or zipCode = '75245' or zipCode = '75246' or zipCode = '75247' or zipCode = '75248' or zipCode = '75249' or zipCode = '75250' or zipCode = '75251' or zipCode = '75252' or zipCode = '75252' or zipCode = '75253' or zipCode = '75253' or zipCode = '75254' or zipCode = '75258' or zipCode = '75260' or zipCode = '75261' or zipCode = '75261' or zipCode = '75261' or zipCode = '75262' or zipCode = '75263' or zipCode = '75264' or zipCode = '75074' or zipCode = '75074' or zipCode = '75075' or zipCode = '75080' or zipCode = '75080' or zipCode = '75081' or zipCode = '75082' or zipCode = '75083' or zipCode = '75085' or zipCode = '75086' or zipCode = '75087' or zipCode = '75115' or zipCode = '75116' or zipCode = '75123' or zipCode = '75125' or zipCode = '75126' or zipCode = '75126' or zipCode = '75126' or zipCode = '75134' or zipCode = '75137' or zipCode = '75138' or zipCode = '75141' or zipCode = '75159' or zipCode = '75159' or zipCode = '75172' or zipCode = '75180' or zipCode = '75180' or zipCode = '75181' or zipCode = '75181' or zipCode = '75182' or zipCode = '75182' or zipCode = '75185' or zipCode = '75187' or zipCode = '75201' or zipCode = '75221' or zipCode = '75222' or zipCode = '75223' or zipCode = '75224' or zipCode = '75225' or zipCode = '75226' or zipCode = '75227' or zipCode = '75228' or zipCode = '75229' or zipCode = '75230' or zipCode = '75231' or zipCode = '75232' or zipCode = '75233' or zipCode = '75234' or zipCode = '75234' or zipCode = '75234' or zipCode = '75235' or zipCode = '75236' or zipCode = '75237' or zipCode = '75238' or zipCode = '75240' or zipCode = '75241' or zipCode = '75242' or zipCode = '75243' or zipCode = '75265' or zipCode = '75266' or zipCode = '75267' or zipCode = '75270' or zipCode = '75275' or zipCode = '75275' or zipCode = '75277' or zipCode = '75277' or zipCode = '75283' or zipCode = '75283' or zipCode = '75283' or zipCode = '75284' or zipCode = '75284' or zipCode = '75285' or zipCode = '75285' or zipCode = '75286' or zipCode = '75286' or zipCode = '75287' or zipCode = '75301' or zipCode = '75301' or zipCode = '75303' or zipCode = '75303' or zipCode = '75310' or zipCode = '75310' or zipCode = '75312' or zipCode = '75312' or zipCode = '75313' or zipCode = '75315' or zipCode = '75320' or zipCode = '75320' or zipCode = '75323' or zipCode = '75323' or zipCode = '75326' or zipCode = '75326' or zipCode = '75334' or zipCode = '75336' or zipCode = '75336' or zipCode = '75339' or zipCode = '75340' or zipCode = '75342' or zipCode = '75343' or zipCode = '75344' or zipCode = '75354' or zipCode = '75355' or zipCode = '75356' or zipCode = '75357' or zipCode = '75358' or zipCode = '75358' or zipCode = '75391' or zipCode = '75392' or zipCode = '75392' or zipCode = '75393' or zipCode = '75393' or zipCode = '75394' or zipCode = '75394' or zipCode = '75395' or zipCode = '75395' or zipCode = '75397' or zipCode = '75397' or zipCode = '75398' or zipCode = '75359' or zipCode = '75360' or zipCode = '75367' or zipCode = '75368' or zipCode = '75368' or zipCode = '75370' or zipCode = '75371' or zipCode = '75372' or zipCode = '75373' or zipCode = '75373' or zipCode = '75374' or zipCode = '75376' or zipCode = '75378' or zipCode = '75379' or zipCode = '75380' or zipCode = '75381' or zipCode = '75382' or zipCode = '75387' or zipCode = '75387' or zipCode = '75389' or zipCode = '75389' or zipCode = '75390' or zipCode = '75390' or zipCode = '75391' or zipCode = '76015' or zipCode = '76016' or zipCode = '76016' or zipCode = '76017' or zipCode = '76018' or zipCode = '76019' or zipCode = '76019' or zipCode = '76019' or zipCode = '76021' or zipCode = '76022' or zipCode = '76034' or zipCode = '76039' or zipCode = '76040' or zipCode = '76092' or zipCode = '76092' or zipCode = '76094' or zipCode = '76095' or zipCode = '76096' or zipCode = '76099' or zipCode = '76112' or zipCode = '76001' or zipCode = '76002' or zipCode = '76003' or zipCode = '76004' or zipCode = '76005' or zipCode = '76006' or zipCode = '76007' or zipCode = '76010' or zipCode = '76011' or zipCode = '76012' or zipCode = '76013' or zipCode = '76013' or zipCode = '76014' or zipCode = '76015' or zipCode = '76051' or zipCode = '76053' or zipCode = '76054' or zipCode = '76063' or zipCode = '76118' or zipCode = '76118' or zipCode = '76118' or zipCode = '76118' or zipCode = '76118' or zipCode = '76120' or zipCode = '76155' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '75001' or zipCode = '75002' or zipCode = '75006' or zipCode = '75007' or zipCode = '75010' or zipCode = '75011' or zipCode = '75013' or zipCode = '75014' or zipCode = '75015' or zipCode = '75016' or zipCode = '75017' or zipCode = '75019' or zipCode = '75022' or zipCode = '75023' or zipCode = '75024' or zipCode = '75025' or zipCode = '75028' or zipCode = '75030' or zipCode = '75032' or zipCode = '75034' or zipCode = '75035' or zipCode = '75037' or zipCode = '75038' or zipCode = '75039' or zipCode = '75040' or zipCode = '75041' or zipCode = '75042' or zipCode = '75043' or zipCode = '75044' or zipCode = '75045' or zipCode = '75046' or zipCode = '75047' or zipCode = '75048' or zipCode = '75049' or zipCode = '75050' or zipCode = '75051' or zipCode = '75052' or zipCode = '75053' or zipCode = '75054' or zipCode = '75056' or zipCode = '75057' or zipCode = '75059' or zipCode = '75060' or zipCode = '75061' or zipCode = '75062' or zipCode = '75063' or zipCode = '75066' or zipCode = '75067' or zipCode = '75074' or zipCode = '75075' or zipCode = '75077' or zipCode = '75080' or zipCode = '75081' or zipCode = '75082' or zipCode = '75083' or zipCode = '75085' or zipCode = '75086' or zipCode = '75087' or zipCode = '75088' or zipCode = '75089' or zipCode = '75093' or zipCode = '75094' or zipCode = '75098' or zipCode = '75099' or zipCode = '75104' or zipCode = '75106' or zipCode = '75114' or zipCode = '75115' or zipCode = '75116' or zipCode = '75123' or zipCode = '75125' or zipCode = '75126' or zipCode = '75134' or zipCode = '75137' or zipCode = '75138' or zipCode = '75141' or zipCode = '75146' or zipCode = '75149' or zipCode = '75150' or zipCode = '75154' or zipCode = '75159' or zipCode = '75172' or zipCode = '75180' or zipCode = '75181' or zipCode = '75182' or zipCode = '75185' or zipCode = '75187' or zipCode = '75201' or zipCode = '75202' or zipCode = '75203' or zipCode = '75204' or zipCode = '75205' or zipCode = '75206' or zipCode = '75207' or zipCode = '75208' or zipCode = '75209' or zipCode = '75210' or zipCode = '75211' or zipCode = '75212' or zipCode = '75214' or zipCode = '75215' or zipCode = '75216' or zipCode = '75217' or zipCode = '75218' or zipCode = '75219' or zipCode = '75220' or zipCode = '75221' or zipCode = '75222' or zipCode = '75223' or zipCode = '75224' or zipCode = '75225' or zipCode = '75226' or zipCode = '75227' or zipCode = '75228' or zipCode = '75229' or zipCode = '75230' or zipCode = '75231' or zipCode = '75232' or zipCode = '75233' or zipCode = '75234' or zipCode = '75235' or zipCode = '75236' or zipCode = '75237' or zipCode = '75238' or zipCode = '75239' or zipCode = '75240' or zipCode = '75241' or zipCode = '75242' or zipCode = '75243' or zipCode = '75244' or zipCode = '75245' or zipCode = '75246' or zipCode = '75247' or zipCode = '75248' or zipCode = '75249' or zipCode = '75250' or zipCode = '75251' or zipCode = '75252' or zipCode = '75253' or zipCode = '75254' or zipCode = '75255' or zipCode = '75258' or zipCode = '75260' or zipCode = '75261' or zipCode = '75262' or zipCode = '75263' or zipCode = '75264' or zipCode = '75265' or zipCode = '75266' or zipCode = '75267' or zipCode = '75270' or zipCode = '75275' or zipCode = '75277' or zipCode = '75283' or zipCode = '75284' or zipCode = '75285' or zipCode = '75286' or zipCode = '75287' or zipCode = '75294' or zipCode = '75295' or zipCode = '75301' or zipCode = '75303' or zipCode = '75310' or zipCode = '75312' or zipCode = '75313' or zipCode = '75315' or zipCode = '75320' or zipCode = '75323' or zipCode = '75326' or zipCode = '75336' or zipCode = '75339' or zipCode = '75342' or zipCode = '75346' or zipCode = '75350' or zipCode = '75353' or zipCode = '75354' or zipCode = '75355' or zipCode = '75356' or zipCode = '75357' or zipCode = '75359' or zipCode = '75360' or zipCode = '75363' or zipCode = '75364' or zipCode = '75367' or zipCode = '75368' or zipCode = '75370' or zipCode = '75371' or zipCode = '75372' or zipCode = '75373' or zipCode = '75374' or zipCode = '75376' or zipCode = '75378' or zipCode = '75379' or zipCode = '75380' or zipCode = '75381' or zipCode = '75382' or zipCode = '75386' or zipCode = '75387' or zipCode = '75388' or zipCode = '75389' or zipCode = '75390' or zipCode = '75391' or zipCode = '75392' or zipCode = '75393' or zipCode = '75394' or zipCode = '75395' or zipCode = '75396' or zipCode = '75397' or zipCode = '75398' or zipCode = '76001' or zipCode = '76002' or zipCode = '76003' or zipCode = '76006' or zipCode = '76010' or zipCode = '76011' or zipCode = '76012' or zipCode = '76013' or zipCode = '76014' or zipCode = '76015' or zipCode = '76016' or zipCode = '76017' or zipCode = '76018' or zipCode = '76021' or zipCode = '76022' or zipCode = '76025' or zipCode = '76034' or zipCode = '76039' or zipCode = '76040' or zipCode = '76051' or zipCode = '76053' or zipCode = '76054' or zipCode = '76063' or zipCode = '76065' or zipCode = '76092' or zipCode = '76112' or zipCode = '76118' or zipCode = '76120' or zipCode = '76155' or zipCode = '76180') 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 ='75001' or zipCode = '75002' or zipCode = '75002' or zipCode = '75006' or zipCode = '75007' or zipCode = '75010' or zipCode = '75011' or zipCode = '75013' or zipCode = '75014' or zipCode = '75015' or zipCode = '75016' or zipCode = '75017' or zipCode = '75019' or zipCode = '75023' or zipCode = '75024' or zipCode = '75025' or zipCode = '75026' or zipCode = '75027' or zipCode = '75027' or zipCode = '75027' or zipCode = '75028' or zipCode = '75028' or zipCode = '75028' or zipCode = '75029' or zipCode = '75030' or zipCode = '75032' or zipCode = '75032' or zipCode = '75037' or zipCode = '75037' or zipCode = '75038' or zipCode = '75039' or zipCode = '75040' or zipCode = '75041' or zipCode = '75042' or zipCode = '75043' or zipCode = '75044' or zipCode = '75045' or zipCode = '75046' or zipCode = '75047' or zipCode = '75048' or zipCode = '75048' or zipCode = '75049' or zipCode = '75050' or zipCode = '75051' or zipCode = '75052' or zipCode = '75053' or zipCode = '75054' or zipCode = '75056' or zipCode = '75056' or zipCode = '75057' or zipCode = '75060' or zipCode = '75061' or zipCode = '75062' or zipCode = '75063' or zipCode = '75067' or zipCode = '75067' or zipCode = '75088' or zipCode = '75089' or zipCode = '75093' or zipCode = '75094' or zipCode = '75094' or zipCode = '75098' or zipCode = '75098' or zipCode = '75099' or zipCode = '75099' or zipCode = '75099' or zipCode = '75104' or zipCode = '75106' or zipCode = '75114' or zipCode = '75146' or zipCode = '75149' or zipCode = '75150' or zipCode = '75154' or zipCode = '75154' or zipCode = '75154' or zipCode = '75154' or zipCode = '75202' or zipCode = '75203' or zipCode = '75204' or zipCode = '75205' or zipCode = '75205' or zipCode = '75205' or zipCode = '75205' or zipCode = '75206' or zipCode = '75207' or zipCode = '75208' or zipCode = '75209' or zipCode = '75209' or zipCode = '75210' or zipCode = '75211' or zipCode = '75211' or zipCode = '75212' or zipCode = '75214' or zipCode = '75215' or zipCode = '75216' or zipCode = '75217' or zipCode = '75218' or zipCode = '75219' or zipCode = '75219' or zipCode = '75220' or zipCode = '75244' or zipCode = '75244' or zipCode = '75244' or zipCode = '75244' or zipCode = '75245' or zipCode = '75246' or zipCode = '75247' or zipCode = '75248' or zipCode = '75249' or zipCode = '75250' or zipCode = '75251' or zipCode = '75252' or zipCode = '75252' or zipCode = '75253' or zipCode = '75253' or zipCode = '75254' or zipCode = '75258' or zipCode = '75260' or zipCode = '75261' or zipCode = '75261' or zipCode = '75261' or zipCode = '75262' or zipCode = '75263' or zipCode = '75264' or zipCode = '75074' or zipCode = '75074' or zipCode = '75075' or zipCode = '75080' or zipCode = '75080' or zipCode = '75081' or zipCode = '75082' or zipCode = '75083' or zipCode = '75085' or zipCode = '75086' or zipCode = '75087' or zipCode = '75115' or zipCode = '75116' or zipCode = '75123' or zipCode = '75125' or zipCode = '75126' or zipCode = '75126' or zipCode = '75126' or zipCode = '75134' or zipCode = '75137' or zipCode = '75138' or zipCode = '75141' or zipCode = '75159' or zipCode = '75159' or zipCode = '75172' or zipCode = '75180' or zipCode = '75180' or zipCode = '75181' or zipCode = '75181' or zipCode = '75182' or zipCode = '75182' or zipCode = '75185' or zipCode = '75187' or zipCode = '75201' or zipCode = '75221' or zipCode = '75222' or zipCode = '75223' or zipCode = '75224' or zipCode = '75225' or zipCode = '75226' or zipCode = '75227' or zipCode = '75228' or zipCode = '75229' or zipCode = '75230' or zipCode = '75231' or zipCode = '75232' or zipCode = '75233' or zipCode = '75234' or zipCode = '75234' or zipCode = '75234' or zipCode = '75235' or zipCode = '75236' or zipCode = '75237' or zipCode = '75238' or zipCode = '75240' or zipCode = '75241' or zipCode = '75242' or zipCode = '75243' or zipCode = '75265' or zipCode = '75266' or zipCode = '75267' or zipCode = '75270' or zipCode = '75275' or zipCode = '75275' or zipCode = '75277' or zipCode = '75277' or zipCode = '75283' or zipCode = '75283' or zipCode = '75283' or zipCode = '75284' or zipCode = '75284' or zipCode = '75285' or zipCode = '75285' or zipCode = '75286' or zipCode = '75286' or zipCode = '75287' or zipCode = '75301' or zipCode = '75301' or zipCode = '75303' or zipCode = '75303' or zipCode = '75310' or zipCode = '75310' or zipCode = '75312' or zipCode = '75312' or zipCode = '75313' or zipCode = '75315' or zipCode = '75320' or zipCode = '75320' or zipCode = '75323' or zipCode = '75323' or zipCode = '75326' or zipCode = '75326' or zipCode = '75334' or zipCode = '75336' or zipCode = '75336' or zipCode = '75339' or zipCode = '75340' or zipCode = '75342' or zipCode = '75343' or zipCode = '75344' or zipCode = '75354' or zipCode = '75355' or zipCode = '75356' or zipCode = '75357' or zipCode = '75358' or zipCode = '75358' or zipCode = '75391' or zipCode = '75392' or zipCode = '75392' or zipCode = '75393' or zipCode = '75393' or zipCode = '75394' or zipCode = '75394' or zipCode = '75395' or zipCode = '75395' or zipCode = '75397' or zipCode = '75397' or zipCode = '75398' or zipCode = '75359' or zipCode = '75360' or zipCode = '75367' or zipCode = '75368' or zipCode = '75368' or zipCode = '75370' or zipCode = '75371' or zipCode = '75372' or zipCode = '75373' or zipCode = '75373' or zipCode = '75374' or zipCode = '75376' or zipCode = '75378' or zipCode = '75379' or zipCode = '75380' or zipCode = '75381' or zipCode = '75382' or zipCode = '75387' or zipCode = '75387' or zipCode = '75389' or zipCode = '75389' or zipCode = '75390' or zipCode = '75390' or zipCode = '75391' or zipCode = '76015' or zipCode = '76016' or zipCode = '76016' or zipCode = '76017' or zipCode = '76018' or zipCode = '76019' or zipCode = '76019' or zipCode = '76019' or zipCode = '76021' or zipCode = '76022' or zipCode = '76034' or zipCode = '76039' or zipCode = '76040' or zipCode = '76092' or zipCode = '76092' or zipCode = '76094' or zipCode = '76095' or zipCode = '76096' or zipCode = '76099' or zipCode = '76112' or zipCode = '76001' or zipCode = '76002' or zipCode = '76003' or zipCode = '76004' or zipCode = '76005' or zipCode = '76006' or zipCode = '76007' or zipCode = '76010' or zipCode = '76011' or zipCode = '76012' or zipCode = '76013' or zipCode = '76013' or zipCode = '76014' or zipCode = '76015' or zipCode = '76051' or zipCode = '76053' or zipCode = '76054' or zipCode = '76063' or zipCode = '76118' or zipCode = '76118' or zipCode = '76118' or zipCode = '76118' or zipCode = '76118' or zipCode = '76120' or zipCode = '76155' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '75001' or zipCode = '75002' or zipCode = '75006' or zipCode = '75007' or zipCode = '75010' or zipCode = '75011' or zipCode = '75013' or zipCode = '75014' or zipCode = '75015' or zipCode = '75016' or zipCode = '75017' or zipCode = '75019' or zipCode = '75022' or zipCode = '75023' or zipCode = '75024' or zipCode = '75025' or zipCode = '75028' or zipCode = '75030' or zipCode = '75032' or zipCode = '75034' or zipCode = '75035' or zipCode = '75037' or zipCode = '75038' or zipCode = '75039' or zipCode = '75040' or zipCode = '75041' or zipCode = '75042' or zipCode = '75043' or zipCode = '75044' or zipCode = '75045' or zipCode = '75046' or zipCode = '75047' or zipCode = '75048' or zipCode = '75049' or zipCode = '75050' or zipCode = '75051' or zipCode = '75052' or zipCode = '75053' or zipCode = '75054' or zipCode = '75056' or zipCode = '75057' or zipCode = '75059' or zipCode = '75060' or zipCode = '75061' or zipCode = '75062' or zipCode = '75063' or zipCode = '75066' or zipCode = '75067' or zipCode = '75074' or zipCode = '75075' or zipCode = '75077' or zipCode = '75080' or zipCode = '75081' or zipCode = '75082' or zipCode = '75083' or zipCode = '75085' or zipCode = '75086' or zipCode = '75087' or zipCode = '75088' or zipCode = '75089' or zipCode = '75093' or zipCode = '75094' or zipCode = '75098' or zipCode = '75099' or zipCode = '75104' or zipCode = '75106' or zipCode = '75114' or zipCode = '75115' or zipCode = '75116' or zipCode = '75123' or zipCode = '75125' or zipCode = '75126' or zipCode = '75134' or zipCode = '75137' or zipCode = '75138' or zipCode = '75141' or zipCode = '75146' or zipCode = '75149' or zipCode = '75150' or zipCode = '75154' or zipCode = '75159' or zipCode = '75172' or zipCode = '75180' or zipCode = '75181' or zipCode = '75182' or zipCode = '75185' or zipCode = '75187' or zipCode = '75201' or zipCode = '75202' or zipCode = '75203' or zipCode = '75204' or zipCode = '75205' or zipCode = '75206' or zipCode = '75207' or zipCode = '75208' or zipCode = '75209' or zipCode = '75210' or zipCode = '75211' or zipCode = '75212' or zipCode = '75214' or zipCode = '75215' or zipCode = '75216' or zipCode = '75217' or zipCode = '75218' or zipCode = '75219' or zipCode = '75220' or zipCode = '75221' or zipCode = '75222' or zipCode = '75223' or zipCode = '75224' or zipCode = '75225' or zipCode = '75226' or zipCode = '75227' or zipCode = '75228' or zipCode = '75229' or zipCode = '75230' or zipCode = '75231' or zipCode = '75232' or zipCode = '75233' or zipCode = '75234' or zipCode = '75235' or zipCode = '75236' or zipCode = '75237' or zipCode = '75238' or zipCode = '75239' or zipCode = '75240' or zipCode = '75241' or zipCode = '75242' or zipCode = '75243' or zipCode = '75244' or zipCode = '75245' or zipCode = '75246' or zipCode = '75247' or zipCode = '75248' or zipCode = '75249' or zipCode = '75250' or zipCode = '75251' or zipCode = '75252' or zipCode = '75253' or zipCode = '75254' or zipCode = '75255' or zipCode = '75258' or zipCode = '75260' or zipCode = '75261' or zipCode = '75262' or zipCode = '75263' or zipCode = '75264' or zipCode = '75265' or zipCode = '75266' or zipCode = '75267' or zipCode = '75270' or zipCode = '75275' or zipCode = '75277' or zipCode = '75283' or zipCode = '75284' or zipCode = '75285' or zipCode = '75286' or zipCode = '75287' or zipCode = '75294' or zipCode = '75295' or zipCode = '75301' or zipCode = '75303' or zipCode = '75310' or zipCode = '75312' or zipCode = '75313' or zipCode = '75315' or zipCode = '75320' or zipCode = '75323' or zipCode = '75326' or zipCode = '75336' or zipCode = '75339' or zipCode = '75342' or zipCode = '75346' or zipCode = '75350' or zipCode = '75353' or zipCode = '75354' or zipCode = '75355' or zipCode = '75356' or zipCode = '75357' or zipCode = '75359' or zipCode = '75360' or zipCode = '75363' or zipCode = '75364' or zipCode = '75367' or zipCode = '75368' or zipCode = '75370' or zipCode = '75371' or zipCode = '75372' or zipCode = '75373' or zipCode = '75374' or zipCode = '75376' or zipCode = '75378' or zipCode = '75379' or zipCode = '75380' or zipCode = '75381' or zipCode = '75382' or zipCode = '75386' or zipCode = '75387' or zipCode = '75388' or zipCode = '75389' or zipCode = '75390' or zipCode = '75391' or zipCode = '75392' or zipCode = '75393' or zipCode = '75394' or zipCode = '75395' or zipCode = '75396' or zipCode = '75397' or zipCode = '75398' or zipCode = '76001' or zipCode = '76002' or zipCode = '76003' or zipCode = '76006' or zipCode = '76010' or zipCode = '76011' or zipCode = '76012' or zipCode = '76013' or zipCode = '76014' or zipCode = '76015' or zipCode = '76016' or zipCode = '76017' or zipCode = '76018' or zipCode = '76021' or zipCode = '76022' or zipCode = '76025' or zipCode = '76034' or zipCode = '76039' or zipCode = '76040' or zipCode = '76051' or zipCode = '76053' or zipCode = '76054' or zipCode = '76063' or zipCode = '76065' or zipCode = '76092' or zipCode = '76112' or zipCode = '76118' or zipCode = '76120' or zipCode = '76155' or zipCode = '76180') 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 ='75001' or zipCode = '75002' or zipCode = '75002' or zipCode = '75006' or zipCode = '75007' or zipCode = '75010' or zipCode = '75011' or zipCode = '75013' or zipCode = '75014' or zipCode = '75015' or zipCode = '75016' or zipCode = '75017' or zipCode = '75019' or zipCode = '75023' or zipCode = '75024' or zipCode = '75025' or zipCode = '75026' or zipCode = '75027' or zipCode = '75027' or zipCode = '75027' or zipCode = '75028' or zipCode = '75028' or zipCode = '75028' or zipCode = '75029' or zipCode = '75030' or zipCode = '75032' or zipCode = '75032' or zipCode = '75037' or zipCode = '75037' or zipCode = '75038' or zipCode = '75039' or zipCode = '75040' or zipCode = '75041' or zipCode = '75042' or zipCode = '75043' or zipCode = '75044' or zipCode = '75045' or zipCode = '75046' or zipCode = '75047' or zipCode = '75048' or zipCode = '75048' or zipCode = '75049' or zipCode = '75050' or zipCode = '75051' or zipCode = '75052' or zipCode = '75053' or zipCode = '75054' or zipCode = '75056' or zipCode = '75056' or zipCode = '75057' or zipCode = '75060' or zipCode = '75061' or zipCode = '75062' or zipCode = '75063' or zipCode = '75067' or zipCode = '75067' or zipCode = '75088' or zipCode = '75089' or zipCode = '75093' or zipCode = '75094' or zipCode = '75094' or zipCode = '75098' or zipCode = '75098' or zipCode = '75099' or zipCode = '75099' or zipCode = '75099' or zipCode = '75104' or zipCode = '75106' or zipCode = '75114' or zipCode = '75146' or zipCode = '75149' or zipCode = '75150' or zipCode = '75154' or zipCode = '75154' or zipCode = '75154' or zipCode = '75154' or zipCode = '75202' or zipCode = '75203' or zipCode = '75204' or zipCode = '75205' or zipCode = '75205' or zipCode = '75205' or zipCode = '75205' or zipCode = '75206' or zipCode = '75207' or zipCode = '75208' or zipCode = '75209' or zipCode = '75209' or zipCode = '75210' or zipCode = '75211' or zipCode = '75211' or zipCode = '75212' or zipCode = '75214' or zipCode = '75215' or zipCode = '75216' or zipCode = '75217' or zipCode = '75218' or zipCode = '75219' or zipCode = '75219' or zipCode = '75220' or zipCode = '75244' or zipCode = '75244' or zipCode = '75244' or zipCode = '75244' or zipCode = '75245' or zipCode = '75246' or zipCode = '75247' or zipCode = '75248' or zipCode = '75249' or zipCode = '75250' or zipCode = '75251' or zipCode = '75252' or zipCode = '75252' or zipCode = '75253' or zipCode = '75253' or zipCode = '75254' or zipCode = '75258' or zipCode = '75260' or zipCode = '75261' or zipCode = '75261' or zipCode = '75261' or zipCode = '75262' or zipCode = '75263' or zipCode = '75264' or zipCode = '75074' or zipCode = '75074' or zipCode = '75075' or zipCode = '75080' or zipCode = '75080' or zipCode = '75081' or zipCode = '75082' or zipCode = '75083' or zipCode = '75085' or zipCode = '75086' or zipCode = '75087' or zipCode = '75115' or zipCode = '75116' or zipCode = '75123' or zipCode = '75125' or zipCode = '75126' or zipCode = '75126' or zipCode = '75126' or zipCode = '75134' or zipCode = '75137' or zipCode = '75138' or zipCode = '75141' or zipCode = '75159' or zipCode = '75159' or zipCode = '75172' or zipCode = '75180' or zipCode = '75180' or zipCode = '75181' or zipCode = '75181' or zipCode = '75182' or zipCode = '75182' or zipCode = '75185' or zipCode = '75187' or zipCode = '75201' or zipCode = '75221' or zipCode = '75222' or zipCode = '75223' or zipCode = '75224' or zipCode = '75225' or zipCode = '75226' or zipCode = '75227' or zipCode = '75228' or zipCode = '75229' or zipCode = '75230' or zipCode = '75231' or zipCode = '75232' or zipCode = '75233' or zipCode = '75234' or zipCode = '75234' or zipCode = '75234' or zipCode = '75235' or zipCode = '75236' or zipCode = '75237' or zipCode = '75238' or zipCode = '75240' or zipCode = '75241' or zipCode = '75242' or zipCode = '75243' or zipCode = '75265' or zipCode = '75266' or zipCode = '75267' or zipCode = '75270' or zipCode = '75275' or zipCode = '75275' or zipCode = '75277' or zipCode = '75277' or zipCode = '75283' or zipCode = '75283' or zipCode = '75283' or zipCode = '75284' or zipCode = '75284' or zipCode = '75285' or zipCode = '75285' or zipCode = '75286' or zipCode = '75286' or zipCode = '75287' or zipCode = '75301' or zipCode = '75301' or zipCode = '75303' or zipCode = '75303' or zipCode = '75310' or zipCode = '75310' or zipCode = '75312' or zipCode = '75312' or zipCode = '75313' or zipCode = '75315' or zipCode = '75320' or zipCode = '75320' or zipCode = '75323' or zipCode = '75323' or zipCode = '75326' or zipCode = '75326' or zipCode = '75334' or zipCode = '75336' or zipCode = '75336' or zipCode = '75339' or zipCode = '75340' or zipCode = '75342' or zipCode = '75343' or zipCode = '75344' or zipCode = '75354' or zipCode = '75355' or zipCode = '75356' or zipCode = '75357' or zipCode = '75358' or zipCode = '75358' or zipCode = '75391' or zipCode = '75392' or zipCode = '75392' or zipCode = '75393' or zipCode = '75393' or zipCode = '75394' or zipCode = '75394' or zipCode = '75395' or zipCode = '75395' or zipCode = '75397' or zipCode = '75397' or zipCode = '75398' or zipCode = '75359' or zipCode = '75360' or zipCode = '75367' or zipCode = '75368' or zipCode = '75368' or zipCode = '75370' or zipCode = '75371' or zipCode = '75372' or zipCode = '75373' or zipCode = '75373' or zipCode = '75374' or zipCode = '75376' or zipCode = '75378' or zipCode = '75379' or zipCode = '75380' or zipCode = '75381' or zipCode = '75382' or zipCode = '75387' or zipCode = '75387' or zipCode = '75389' or zipCode = '75389' or zipCode = '75390' or zipCode = '75390' or zipCode = '75391' or zipCode = '76015' or zipCode = '76016' or zipCode = '76016' or zipCode = '76017' or zipCode = '76018' or zipCode = '76019' or zipCode = '76019' or zipCode = '76019' or zipCode = '76021' or zipCode = '76022' or zipCode = '76034' or zipCode = '76039' or zipCode = '76040' or zipCode = '76092' or zipCode = '76092' or zipCode = '76094' or zipCode = '76095' or zipCode = '76096' or zipCode = '76099' or zipCode = '76112' or zipCode = '76001' or zipCode = '76002' or zipCode = '76003' or zipCode = '76004' or zipCode = '76005' or zipCode = '76006' or zipCode = '76007' or zipCode = '76010' or zipCode = '76011' or zipCode = '76012' or zipCode = '76013' or zipCode = '76013' or zipCode = '76014' or zipCode = '76015' or zipCode = '76051' or zipCode = '76053' or zipCode = '76054' or zipCode = '76063' or zipCode = '76118' or zipCode = '76118' or zipCode = '76118' or zipCode = '76118' or zipCode = '76118' or zipCode = '76120' or zipCode = '76155' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '75001' or zipCode = '75002' or zipCode = '75006' or zipCode = '75007' or zipCode = '75010' or zipCode = '75011' or zipCode = '75013' or zipCode = '75014' or zipCode = '75015' or zipCode = '75016' or zipCode = '75017' or zipCode = '75019' or zipCode = '75022' or zipCode = '75023' or zipCode = '75024' or zipCode = '75025' or zipCode = '75028' or zipCode = '75030' or zipCode = '75032' or zipCode = '75034' or zipCode = '75035' or zipCode = '75037' or zipCode = '75038' or zipCode = '75039' or zipCode = '75040' or zipCode = '75041' or zipCode = '75042' or zipCode = '75043' or zipCode = '75044' or zipCode = '75045' or zipCode = '75046' or zipCode = '75047' or zipCode = '75048' or zipCode = '75049' or zipCode = '75050' or zipCode = '75051' or zipCode = '75052' or zipCode = '75053' or zipCode = '75054' or zipCode = '75056' or zipCode = '75057' or zipCode = '75059' or zipCode = '75060' or zipCode = '75061' or zipCode = '75062' or zipCode = '75063' or zipCode = '75066' or zipCode = '75067' or zipCode = '75074' or zipCode = '75075' or zipCode = '75077' or zipCode = '75080' or zipCode = '75081' or zipCode = '75082' or zipCode = '75083' or zipCode = '75085' or zipCode = '75086' or zipCode = '75087' or zipCode = '75088' or zipCode = '75089' or zipCode = '75093' or zipCode = '75094' or zipCode = '75098' or zipCode = '75099' or zipCode = '75104' or zipCode = '75106' or zipCode = '75114' or zipCode = '75115' or zipCode = '75116' or zipCode = '75123' or zipCode = '75125' or zipCode = '75126' or zipCode = '75134' or zipCode = '75137' or zipCode = '75138' or zipCode = '75141' or zipCode = '75146' or zipCode = '75149' or zipCode = '75150' or zipCode = '75154' or zipCode = '75159' or zipCode = '75172' or zipCode = '75180' or zipCode = '75181' or zipCode = '75182' or zipCode = '75185' or zipCode = '75187' or zipCode = '75201' or zipCode = '75202' or zipCode = '75203' or zipCode = '75204' or zipCode = '75205' or zipCode = '75206' or zipCode = '75207' or zipCode = '75208' or zipCode = '75209' or zipCode = '75210' or zipCode = '75211' or zipCode = '75212' or zipCode = '75214' or zipCode = '75215' or zipCode = '75216' or zipCode = '75217' or zipCode = '75218' or zipCode = '75219' or zipCode = '75220' or zipCode = '75221' or zipCode = '75222' or zipCode = '75223' or zipCode = '75224' or zipCode = '75225' or zipCode = '75226' or zipCode = '75227' or zipCode = '75228' or zipCode = '75229' or zipCode = '75230' or zipCode = '75231' or zipCode = '75232' or zipCode = '75233' or zipCode = '75234' or zipCode = '75235' or zipCode = '75236' or zipCode = '75237' or zipCode = '75238' or zipCode = '75239' or zipCode = '75240' or zipCode = '75241' or zipCode = '75242' or zipCode = '75243' or zipCode = '75244' or zipCode = '75245' or zipCode = '75246' or zipCode = '75247' or zipCode = '75248' or zipCode = '75249' or zipCode = '75250' or zipCode = '75251' or zipCode = '75252' or zipCode = '75253' or zipCode = '75254' or zipCode = '75255' or zipCode = '75258' or zipCode = '75260' or zipCode = '75261' or zipCode = '75262' or zipCode = '75263' or zipCode = '75264' or zipCode = '75265' or zipCode = '75266' or zipCode = '75267' or zipCode = '75270' or zipCode = '75275' or zipCode = '75277' or zipCode = '75283' or zipCode = '75284' or zipCode = '75285' or zipCode = '75286' or zipCode = '75287' or zipCode = '75294' or zipCode = '75295' or zipCode = '75301' or zipCode = '75303' or zipCode = '75310' or zipCode = '75312' or zipCode = '75313' or zipCode = '75315' or zipCode = '75320' or zipCode = '75323' or zipCode = '75326' or zipCode = '75336' or zipCode = '75339' or zipCode = '75342' or zipCode = '75346' or zipCode = '75350' or zipCode = '75353' or zipCode = '75354' or zipCode = '75355' or zipCode = '75356' or zipCode = '75357' or zipCode = '75359' or zipCode = '75360' or zipCode = '75363' or zipCode = '75364' or zipCode = '75367' or zipCode = '75368' or zipCode = '75370' or zipCode = '75371' or zipCode = '75372' or zipCode = '75373' or zipCode = '75374' or zipCode = '75376' or zipCode = '75378' or zipCode = '75379' or zipCode = '75380' or zipCode = '75381' or zipCode = '75382' or zipCode = '75386' or zipCode = '75387' or zipCode = '75388' or zipCode = '75389' or zipCode = '75390' or zipCode = '75391' or zipCode = '75392' or zipCode = '75393' or zipCode = '75394' or zipCode = '75395' or zipCode = '75396' or zipCode = '75397' or zipCode = '75398' or zipCode = '76001' or zipCode = '76002' or zipCode = '76003' or zipCode = '76006' or zipCode = '76010' or zipCode = '76011' or zipCode = '76012' or zipCode = '76013' or zipCode = '76014' or zipCode = '76015' or zipCode = '76016' or zipCode = '76017' or zipCode = '76018' or zipCode = '76021' or zipCode = '76022' or zipCode = '76025' or zipCode = '76034' or zipCode = '76039' or zipCode = '76040' or zipCode = '76051' or zipCode = '76053' or zipCode = '76054' or zipCode = '76063' or zipCode = '76065' or zipCode = '76092' or zipCode = '76112' or zipCode = '76118' or zipCode = '76120' or zipCode = '76155' or zipCode = '76180') 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 ='75001' or zipCode = '75002' or zipCode = '75002' or zipCode = '75006' or zipCode = '75007' or zipCode = '75010' or zipCode = '75011' or zipCode = '75013' or zipCode = '75014' or zipCode = '75015' or zipCode = '75016' or zipCode = '75017' or zipCode = '75019' or zipCode = '75023' or zipCode = '75024' or zipCode = '75025' or zipCode = '75026' or zipCode = '75027' or zipCode = '75027' or zipCode = '75027' or zipCode = '75028' or zipCode = '75028' or zipCode = '75028' or zipCode = '75029' or zipCode = '75030' or zipCode = '75032' or zipCode = '75032' or zipCode = '75037' or zipCode = '75037' or zipCode = '75038' or zipCode = '75039' or zipCode = '75040' or zipCode = '75041' or zipCode = '75042' or zipCode = '75043' or zipCode = '75044' or zipCode = '75045' or zipCode = '75046' or zipCode = '75047' or zipCode = '75048' or zipCode = '75048' or zipCode = '75049' or zipCode = '75050' or zipCode = '75051' or zipCode = '75052' or zipCode = '75053' or zipCode = '75054' or zipCode = '75056' or zipCode = '75056' or zipCode = '75057' or zipCode = '75060' or zipCode = '75061' or zipCode = '75062' or zipCode = '75063' or zipCode = '75067' or zipCode = '75067' or zipCode = '75088' or zipCode = '75089' or zipCode = '75093' or zipCode = '75094' or zipCode = '75094' or zipCode = '75098' or zipCode = '75098' or zipCode = '75099' or zipCode = '75099' or zipCode = '75099' or zipCode = '75104' or zipCode = '75106' or zipCode = '75114' or zipCode = '75146' or zipCode = '75149' or zipCode = '75150' or zipCode = '75154' or zipCode = '75154' or zipCode = '75154' or zipCode = '75154' or zipCode = '75202' or zipCode = '75203' or zipCode = '75204' or zipCode = '75205' or zipCode = '75205' or zipCode = '75205' or zipCode = '75205' or zipCode = '75206' or zipCode = '75207' or zipCode = '75208' or zipCode = '75209' or zipCode = '75209' or zipCode = '75210' or zipCode = '75211' or zipCode = '75211' or zipCode = '75212' or zipCode = '75214' or zipCode = '75215' or zipCode = '75216' or zipCode = '75217' or zipCode = '75218' or zipCode = '75219' or zipCode = '75219' or zipCode = '75220' or zipCode = '75244' or zipCode = '75244' or zipCode = '75244' or zipCode = '75244' or zipCode = '75245' or zipCode = '75246' or zipCode = '75247' or zipCode = '75248' or zipCode = '75249' or zipCode = '75250' or zipCode = '75251' or zipCode = '75252' or zipCode = '75252' or zipCode = '75253' or zipCode = '75253' or zipCode = '75254' or zipCode = '75258' or zipCode = '75260' or zipCode = '75261' or zipCode = '75261' or zipCode = '75261' or zipCode = '75262' or zipCode = '75263' or zipCode = '75264' or zipCode = '75074' or zipCode = '75074' or zipCode = '75075' or zipCode = '75080' or zipCode = '75080' or zipCode = '75081' or zipCode = '75082' or zipCode = '75083' or zipCode = '75085' or zipCode = '75086' or zipCode = '75087' or zipCode = '75115' or zipCode = '75116' or zipCode = '75123' or zipCode = '75125' or zipCode = '75126' or zipCode = '75126' or zipCode = '75126' or zipCode = '75134' or zipCode = '75137' or zipCode = '75138' or zipCode = '75141' or zipCode = '75159' or zipCode = '75159' or zipCode = '75172' or zipCode = '75180' or zipCode = '75180' or zipCode = '75181' or zipCode = '75181' or zipCode = '75182' or zipCode = '75182' or zipCode = '75185' or zipCode = '75187' or zipCode = '75201' or zipCode = '75221' or zipCode = '75222' or zipCode = '75223' or zipCode = '75224' or zipCode = '75225' or zipCode = '75226' or zipCode = '75227' or zipCode = '75228' or zipCode = '75229' or zipCode = '75230' or zipCode = '75231' or zipCode = '75232' or zipCode = '75233' or zipCode = '75234' or zipCode = '75234' or zipCode = '75234' or zipCode = '75235' or zipCode = '75236' or zipCode = '75237' or zipCode = '75238' or zipCode = '75240' or zipCode = '75241' or zipCode = '75242' or zipCode = '75243' or zipCode = '75265' or zipCode = '75266' or zipCode = '75267' or zipCode = '75270' or zipCode = '75275' or zipCode = '75275' or zipCode = '75277' or zipCode = '75277' or zipCode = '75283' or zipCode = '75283' or zipCode = '75283' or zipCode = '75284' or zipCode = '75284' or zipCode = '75285' or zipCode = '75285' or zipCode = '75286' or zipCode = '75286' or zipCode = '75287' or zipCode = '75301' or zipCode = '75301' or zipCode = '75303' or zipCode = '75303' or zipCode = '75310' or zipCode = '75310' or zipCode = '75312' or zipCode = '75312' or zipCode = '75313' or zipCode = '75315' or zipCode = '75320' or zipCode = '75320' or zipCode = '75323' or zipCode = '75323' or zipCode = '75326' or zipCode = '75326' or zipCode = '75334' or zipCode = '75336' or zipCode = '75336' or zipCode = '75339' or zipCode = '75340' or zipCode = '75342' or zipCode = '75343' or zipCode = '75344' or zipCode = '75354' or zipCode = '75355' or zipCode = '75356' or zipCode = '75357' or zipCode = '75358' or zipCode = '75358' or zipCode = '75391' or zipCode = '75392' or zipCode = '75392' or zipCode = '75393' or zipCode = '75393' or zipCode = '75394' or zipCode = '75394' or zipCode = '75395' or zipCode = '75395' or zipCode = '75397' or zipCode = '75397' or zipCode = '75398' or zipCode = '75359' or zipCode = '75360' or zipCode = '75367' or zipCode = '75368' or zipCode = '75368' or zipCode = '75370' or zipCode = '75371' or zipCode = '75372' or zipCode = '75373' or zipCode = '75373' or zipCode = '75374' or zipCode = '75376' or zipCode = '75378' or zipCode = '75379' or zipCode = '75380' or zipCode = '75381' or zipCode = '75382' or zipCode = '75387' or zipCode = '75387' or zipCode = '75389' or zipCode = '75389' or zipCode = '75390' or zipCode = '75390' or zipCode = '75391' or zipCode = '76015' or zipCode = '76016' or zipCode = '76016' or zipCode = '76017' or zipCode = '76018' or zipCode = '76019' or zipCode = '76019' or zipCode = '76019' or zipCode = '76021' or zipCode = '76022' or zipCode = '76034' or zipCode = '76039' or zipCode = '76040' or zipCode = '76092' or zipCode = '76092' or zipCode = '76094' or zipCode = '76095' or zipCode = '76096' or zipCode = '76099' or zipCode = '76112' or zipCode = '76001' or zipCode = '76002' or zipCode = '76003' or zipCode = '76004' or zipCode = '76005' or zipCode = '76006' or zipCode = '76007' or zipCode = '76010' or zipCode = '76011' or zipCode = '76012' or zipCode = '76013' or zipCode = '76013' or zipCode = '76014' or zipCode = '76015' or zipCode = '76051' or zipCode = '76053' or zipCode = '76054' or zipCode = '76063' or zipCode = '76118' or zipCode = '76118' or zipCode = '76118' or zipCode = '76118' or zipCode = '76118' or zipCode = '76120' or zipCode = '76155' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '75001' or zipCode = '75002' or zipCode = '75006' or zipCode = '75007' or zipCode = '75010' or zipCode = '75011' or zipCode = '75013' or zipCode = '75014' or zipCode = '75015' or zipCode = '75016' or zipCode = '75017' or zipCode = '75019' or zipCode = '75022' or zipCode = '75023' or zipCode = '75024' or zipCode = '75025' or zipCode = '75028' or zipCode = '75030' or zipCode = '75032' or zipCode = '75034' or zipCode = '75035' or zipCode = '75037' or zipCode = '75038' or zipCode = '75039' or zipCode = '75040' or zipCode = '75041' or zipCode = '75042' or zipCode = '75043' or zipCode = '75044' or zipCode = '75045' or zipCode = '75046' or zipCode = '75047' or zipCode = '75048' or zipCode = '75049' or zipCode = '75050' or zipCode = '75051' or zipCode = '75052' or zipCode = '75053' or zipCode = '75054' or zipCode = '75056' or zipCode = '75057' or zipCode = '75059' or zipCode = '75060' or zipCode = '75061' or zipCode = '75062' or zipCode = '75063' or zipCode = '75066' or zipCode = '75067' or zipCode = '75074' or zipCode = '75075' or zipCode = '75077' or zipCode = '75080' or zipCode = '75081' or zipCode = '75082' or zipCode = '75083' or zipCode = '75085' or zipCode = '75086' or zipCode = '75087' or zipCode = '75088' or zipCode = '75089' or zipCode = '75093' or zipCode = '75094' or zipCode = '75098' or zipCode = '75099' or zipCode = '75104' or zipCode = '75106' or zipCode = '75114' or zipCode = '75115' or zipCode = '75116' or zipCode = '75123' or zipCode = '75125' or zipCode = '75126' or zipCode = '75134' or zipCode = '75137' or zipCode = '75138' or zipCode = '75141' or zipCode = '75146' or zipCode = '75149' or zipCode = '75150' or zipCode = '75154' or zipCode = '75159' or zipCode = '75172' or zipCode = '75180' or zipCode = '75181' or zipCode = '75182' or zipCode = '75185' or zipCode = '75187' or zipCode = '75201' or zipCode = '75202' or zipCode = '75203' or zipCode = '75204' or zipCode = '75205' or zipCode = '75206' or zipCode = '75207' or zipCode = '75208' or zipCode = '75209' or zipCode = '75210' or zipCode = '75211' or zipCode = '75212' or zipCode = '75214' or zipCode = '75215' or zipCode = '75216' or zipCode = '75217' or zipCode = '75218' or zipCode = '75219' or zipCode = '75220' or zipCode = '75221' or zipCode = '75222' or zipCode = '75223' or zipCode = '75224' or zipCode = '75225' or zipCode = '75226' or zipCode = '75227' or zipCode = '75228' or zipCode = '75229' or zipCode = '75230' or zipCode = '75231' or zipCode = '75232' or zipCode = '75233' or zipCode = '75234' or zipCode = '75235' or zipCode = '75236' or zipCode = '75237' or zipCode = '75238' or zipCode = '75239' or zipCode = '75240' or zipCode = '75241' or zipCode = '75242' or zipCode = '75243' or zipCode = '75244' or zipCode = '75245' or zipCode = '75246' or zipCode = '75247' or zipCode = '75248' or zipCode = '75249' or zipCode = '75250' or zipCode = '75251' or zipCode = '75252' or zipCode = '75253' or zipCode = '75254' or zipCode = '75255' or zipCode = '75258' or zipCode = '75260' or zipCode = '75261' or zipCode = '75262' or zipCode = '75263' or zipCode = '75264' or zipCode = '75265' or zipCode = '75266' or zipCode = '75267' or zipCode = '75270' or zipCode = '75275' or zipCode = '75277' or zipCode = '75283' or zipCode = '75284' or zipCode = '75285' or zipCode = '75286' or zipCode = '75287' or zipCode = '75294' or zipCode = '75295' or zipCode = '75301' or zipCode = '75303' or zipCode = '75310' or zipCode = '75312' or zipCode = '75313' or zipCode = '75315' or zipCode = '75320' or zipCode = '75323' or zipCode = '75326' or zipCode = '75336' or zipCode = '75339' or zipCode = '75342' or zipCode = '75346' or zipCode = '75350' or zipCode = '75353' or zipCode = '75354' or zipCode = '75355' or zipCode = '75356' or zipCode = '75357' or zipCode = '75359' or zipCode = '75360' or zipCode = '75363' or zipCode = '75364' or zipCode = '75367' or zipCode = '75368' or zipCode = '75370' or zipCode = '75371' or zipCode = '75372' or zipCode = '75373' or zipCode = '75374' or zipCode = '75376' or zipCode = '75378' or zipCode = '75379' or zipCode = '75380' or zipCode = '75381' or zipCode = '75382' or zipCode = '75386' or zipCode = '75387' or zipCode = '75388' or zipCode = '75389' or zipCode = '75390' or zipCode = '75391' or zipCode = '75392' or zipCode = '75393' or zipCode = '75394' or zipCode = '75395' or zipCode = '75396' or zipCode = '75397' or zipCode = '75398' or zipCode = '76001' or zipCode = '76002' or zipCode = '76003' or zipCode = '76006' or zipCode = '76010' or zipCode = '76011' or zipCode = '76012' or zipCode = '76013' or zipCode = '76014' or zipCode = '76015' or zipCode = '76016' or zipCode = '76017' or zipCode = '76018' or zipCode = '76021' or zipCode = '76022' or zipCode = '76025' or zipCode = '76034' or zipCode = '76039' or zipCode = '76040' or zipCode = '76051' or zipCode = '76053' or zipCode = '76054' or zipCode = '76063' or zipCode = '76065' or zipCode = '76092' or zipCode = '76112' or zipCode = '76118' or zipCode = '76120' or zipCode = '76155' or zipCode = '76180') 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 ='75001' or zipCode = '75002' or zipCode = '75002' or zipCode = '75006' or zipCode = '75007' or zipCode = '75010' or zipCode = '75011' or zipCode = '75013' or zipCode = '75014' or zipCode = '75015' or zipCode = '75016' or zipCode = '75017' or zipCode = '75019' or zipCode = '75023' or zipCode = '75024' or zipCode = '75025' or zipCode = '75026' or zipCode = '75027' or zipCode = '75027' or zipCode = '75027' or zipCode = '75028' or zipCode = '75028' or zipCode = '75028' or zipCode = '75029' or zipCode = '75030' or zipCode = '75032' or zipCode = '75032' or zipCode = '75037' or zipCode = '75037' or zipCode = '75038' or zipCode = '75039' or zipCode = '75040' or zipCode = '75041' or zipCode = '75042' or zipCode = '75043' or zipCode = '75044' or zipCode = '75045' or zipCode = '75046' or zipCode = '75047' or zipCode = '75048' or zipCode = '75048' or zipCode = '75049' or zipCode = '75050' or zipCode = '75051' or zipCode = '75052' or zipCode = '75053' or zipCode = '75054' or zipCode = '75056' or zipCode = '75056' or zipCode = '75057' or zipCode = '75060' or zipCode = '75061' or zipCode = '75062' or zipCode = '75063' or zipCode = '75067' or zipCode = '75067' or zipCode = '75088' or zipCode = '75089' or zipCode = '75093' or zipCode = '75094' or zipCode = '75094' or zipCode = '75098' or zipCode = '75098' or zipCode = '75099' or zipCode = '75099' or zipCode = '75099' or zipCode = '75104' or zipCode = '75106' or zipCode = '75114' or zipCode = '75146' or zipCode = '75149' or zipCode = '75150' or zipCode = '75154' or zipCode = '75154' or zipCode = '75154' or zipCode = '75154' or zipCode = '75202' or zipCode = '75203' or zipCode = '75204' or zipCode = '75205' or zipCode = '75205' or zipCode = '75205' or zipCode = '75205' or zipCode = '75206' or zipCode = '75207' or zipCode = '75208' or zipCode = '75209' or zipCode = '75209' or zipCode = '75210' or zipCode = '75211' or zipCode = '75211' or zipCode = '75212' or zipCode = '75214' or zipCode = '75215' or zipCode = '75216' or zipCode = '75217' or zipCode = '75218' or zipCode = '75219' or zipCode = '75219' or zipCode = '75220' or zipCode = '75244' or zipCode = '75244' or zipCode = '75244' or zipCode = '75244' or zipCode = '75245' or zipCode = '75246' or zipCode = '75247' or zipCode = '75248' or zipCode = '75249' or zipCode = '75250' or zipCode = '75251' or zipCode = '75252' or zipCode = '75252' or zipCode = '75253' or zipCode = '75253' or zipCode = '75254' or zipCode = '75258' or zipCode = '75260' or zipCode = '75261' or zipCode = '75261' or zipCode = '75261' or zipCode = '75262' or zipCode = '75263' or zipCode = '75264' or zipCode = '75074' or zipCode = '75074' or zipCode = '75075' or zipCode = '75080' or zipCode = '75080' or zipCode = '75081' or zipCode = '75082' or zipCode = '75083' or zipCode = '75085' or zipCode = '75086' or zipCode = '75087' or zipCode = '75115' or zipCode = '75116' or zipCode = '75123' or zipCode = '75125' or zipCode = '75126' or zipCode = '75126' or zipCode = '75126' or zipCode = '75134' or zipCode = '75137' or zipCode = '75138' or zipCode = '75141' or zipCode = '75159' or zipCode = '75159' or zipCode = '75172' or zipCode = '75180' or zipCode = '75180' or zipCode = '75181' or zipCode = '75181' or zipCode = '75182' or zipCode = '75182' or zipCode = '75185' or zipCode = '75187' or zipCode = '75201' or zipCode = '75221' or zipCode = '75222' or zipCode = '75223' or zipCode = '75224' or zipCode = '75225' or zipCode = '75226' or zipCode = '75227' or zipCode = '75228' or zipCode = '75229' or zipCode = '75230' or zipCode = '75231' or zipCode = '75232' or zipCode = '75233' or zipCode = '75234' or zipCode = '75234' or zipCode = '75234' or zipCode = '75235' or zipCode = '75236' or zipCode = '75237' or zipCode = '75238' or zipCode = '75240' or zipCode = '75241' or zipCode = '75242' or zipCode = '75243' or zipCode = '75265' or zipCode = '75266' or zipCode = '75267' or zipCode = '75270' or zipCode = '75275' or zipCode = '75275' or zipCode = '75277' or zipCode = '75277' or zipCode = '75283' or zipCode = '75283' or zipCode = '75283' or zipCode = '75284' or zipCode = '75284' or zipCode = '75285' or zipCode = '75285' or zipCode = '75286' or zipCode = '75286' or zipCode = '75287' or zipCode = '75301' or zipCode = '75301' or zipCode = '75303' or zipCode = '75303' or zipCode = '75310' or zipCode = '75310' or zipCode = '75312' or zipCode = '75312' or zipCode = '75313' or zipCode = '75315' or zipCode = '75320' or zipCode = '75320' or zipCode = '75323' or zipCode = '75323' or zipCode = '75326' or zipCode = '75326' or zipCode = '75334' or zipCode = '75336' or zipCode = '75336' or zipCode = '75339' or zipCode = '75340' or zipCode = '75342' or zipCode = '75343' or zipCode = '75344' or zipCode = '75354' or zipCode = '75355' or zipCode = '75356' or zipCode = '75357' or zipCode = '75358' or zipCode = '75358' or zipCode = '75391' or zipCode = '75392' or zipCode = '75392' or zipCode = '75393' or zipCode = '75393' or zipCode = '75394' or zipCode = '75394' or zipCode = '75395' or zipCode = '75395' or zipCode = '75397' or zipCode = '75397' or zipCode = '75398' or zipCode = '75359' or zipCode = '75360' or zipCode = '75367' or zipCode = '75368' or zipCode = '75368' or zipCode = '75370' or zipCode = '75371' or zipCode = '75372' or zipCode = '75373' or zipCode = '75373' or zipCode = '75374' or zipCode = '75376' or zipCode = '75378' or zipCode = '75379' or zipCode = '75380' or zipCode = '75381' or zipCode = '75382' or zipCode = '75387' or zipCode = '75387' or zipCode = '75389' or zipCode = '75389' or zipCode = '75390' or zipCode = '75390' or zipCode = '75391' or zipCode = '76015' or zipCode = '76016' or zipCode = '76016' or zipCode = '76017' or zipCode = '76018' or zipCode = '76019' or zipCode = '76019' or zipCode = '76019' or zipCode = '76021' or zipCode = '76022' or zipCode = '76034' or zipCode = '76039' or zipCode = '76040' or zipCode = '76092' or zipCode = '76092' or zipCode = '76094' or zipCode = '76095' or zipCode = '76096' or zipCode = '76099' or zipCode = '76112' or zipCode = '76001' or zipCode = '76002' or zipCode = '76003' or zipCode = '76004' or zipCode = '76005' or zipCode = '76006' or zipCode = '76007' or zipCode = '76010' or zipCode = '76011' or zipCode = '76012' or zipCode = '76013' or zipCode = '76013' or zipCode = '76014' or zipCode = '76015' or zipCode = '76051' or zipCode = '76053' or zipCode = '76054' or zipCode = '76063' or zipCode = '76118' or zipCode = '76118' or zipCode = '76118' or zipCode = '76118' or zipCode = '76118' or zipCode = '76120' or zipCode = '76155' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '75001' or zipCode = '75002' or zipCode = '75006' or zipCode = '75007' or zipCode = '75010' or zipCode = '75011' or zipCode = '75013' or zipCode = '75014' or zipCode = '75015' or zipCode = '75016' or zipCode = '75017' or zipCode = '75019' or zipCode = '75022' or zipCode = '75023' or zipCode = '75024' or zipCode = '75025' or zipCode = '75028' or zipCode = '75030' or zipCode = '75032' or zipCode = '75034' or zipCode = '75035' or zipCode = '75037' or zipCode = '75038' or zipCode = '75039' or zipCode = '75040' or zipCode = '75041' or zipCode = '75042' or zipCode = '75043' or zipCode = '75044' or zipCode = '75045' or zipCode = '75046' or zipCode = '75047' or zipCode = '75048' or zipCode = '75049' or zipCode = '75050' or zipCode = '75051' or zipCode = '75052' or zipCode = '75053' or zipCode = '75054' or zipCode = '75056' or zipCode = '75057' or zipCode = '75059' or zipCode = '75060' or zipCode = '75061' or zipCode = '75062' or zipCode = '75063' or zipCode = '75066' or zipCode = '75067' or zipCode = '75074' or zipCode = '75075' or zipCode = '75077' or zipCode = '75080' or zipCode = '75081' or zipCode = '75082' or zipCode = '75083' or zipCode = '75085' or zipCode = '75086' or zipCode = '75087' or zipCode = '75088' or zipCode = '75089' or zipCode = '75093' or zipCode = '75094' or zipCode = '75098' or zipCode = '75099' or zipCode = '75104' or zipCode = '75106' or zipCode = '75114' or zipCode = '75115' or zipCode = '75116' or zipCode = '75123' or zipCode = '75125' or zipCode = '75126' or zipCode = '75134' or zipCode = '75137' or zipCode = '75138' or zipCode = '75141' or zipCode = '75146' or zipCode = '75149' or zipCode = '75150' or zipCode = '75154' or zipCode = '75159' or zipCode = '75172' or zipCode = '75180' or zipCode = '75181' or zipCode = '75182' or zipCode = '75185' or zipCode = '75187' or zipCode = '75201' or zipCode = '75202' or zipCode = '75203' or zipCode = '75204' or zipCode = '75205' or zipCode = '75206' or zipCode = '75207' or zipCode = '75208' or zipCode = '75209' or zipCode = '75210' or zipCode = '75211' or zipCode = '75212' or zipCode = '75214' or zipCode = '75215' or zipCode = '75216' or zipCode = '75217' or zipCode = '75218' or zipCode = '75219' or zipCode = '75220' or zipCode = '75221' or zipCode = '75222' or zipCode = '75223' or zipCode = '75224' or zipCode = '75225' or zipCode = '75226' or zipCode = '75227' or zipCode = '75228' or zipCode = '75229' or zipCode = '75230' or zipCode = '75231' or zipCode = '75232' or zipCode = '75233' or zipCode = '75234' or zipCode = '75235' or zipCode = '75236' or zipCode = '75237' or zipCode = '75238' or zipCode = '75239' or zipCode = '75240' or zipCode = '75241' or zipCode = '75242' or zipCode = '75243' or zipCode = '75244' or zipCode = '75245' or zipCode = '75246' or zipCode = '75247' or zipCode = '75248' or zipCode = '75249' or zipCode = '75250' or zipCode = '75251' or zipCode = '75252' or zipCode = '75253' or zipCode = '75254' or zipCode = '75255' or zipCode = '75258' or zipCode = '75260' or zipCode = '75261' or zipCode = '75262' or zipCode = '75263' or zipCode = '75264' or zipCode = '75265' or zipCode = '75266' or zipCode = '75267' or zipCode = '75270' or zipCode = '75275' or zipCode = '75277' or zipCode = '75283' or zipCode = '75284' or zipCode = '75285' or zipCode = '75286' or zipCode = '75287' or zipCode = '75294' or zipCode = '75295' or zipCode = '75301' or zipCode = '75303' or zipCode = '75310' or zipCode = '75312' or zipCode = '75313' or zipCode = '75315' or zipCode = '75320' or zipCode = '75323' or zipCode = '75326' or zipCode = '75336' or zipCode = '75339' or zipCode = '75342' or zipCode = '75346' or zipCode = '75350' or zipCode = '75353' or zipCode = '75354' or zipCode = '75355' or zipCode = '75356' or zipCode = '75357' or zipCode = '75359' or zipCode = '75360' or zipCode = '75363' or zipCode = '75364' or zipCode = '75367' or zipCode = '75368' or zipCode = '75370' or zipCode = '75371' or zipCode = '75372' or zipCode = '75373' or zipCode = '75374' or zipCode = '75376' or zipCode = '75378' or zipCode = '75379' or zipCode = '75380' or zipCode = '75381' or zipCode = '75382' or zipCode = '75386' or zipCode = '75387' or zipCode = '75388' or zipCode = '75389' or zipCode = '75390' or zipCode = '75391' or zipCode = '75392' or zipCode = '75393' or zipCode = '75394' or zipCode = '75395' or zipCode = '75396' or zipCode = '75397' or zipCode = '75398' or zipCode = '76001' or zipCode = '76002' or zipCode = '76003' or zipCode = '76006' or zipCode = '76010' or zipCode = '76011' or zipCode = '76012' or zipCode = '76013' or zipCode = '76014' or zipCode = '76015' or zipCode = '76016' or zipCode = '76017' or zipCode = '76018' or zipCode = '76021' or zipCode = '76022' or zipCode = '76025' or zipCode = '76034' or zipCode = '76039' or zipCode = '76040' or zipCode = '76051' or zipCode = '76053' or zipCode = '76054' or zipCode = '76063' or zipCode = '76065' or zipCode = '76092' or zipCode = '76112' or zipCode = '76118' or zipCode = '76120' or zipCode = '76155' or zipCode = '76180') 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 ='75001' or zipCode = '75002' or zipCode = '75002' or zipCode = '75006' or zipCode = '75007' or zipCode = '75010' or zipCode = '75011' or zipCode = '75013' or zipCode = '75014' or zipCode = '75015' or zipCode = '75016' or zipCode = '75017' or zipCode = '75019' or zipCode = '75023' or zipCode = '75024' or zipCode = '75025' or zipCode = '75026' or zipCode = '75027' or zipCode = '75027' or zipCode = '75027' or zipCode = '75028' or zipCode = '75028' or zipCode = '75028' or zipCode = '75029' or zipCode = '75030' or zipCode = '75032' or zipCode = '75032' or zipCode = '75037' or zipCode = '75037' or zipCode = '75038' or zipCode = '75039' or zipCode = '75040' or zipCode = '75041' or zipCode = '75042' or zipCode = '75043' or zipCode = '75044' or zipCode = '75045' or zipCode = '75046' or zipCode = '75047' or zipCode = '75048' or zipCode = '75048' or zipCode = '75049' or zipCode = '75050' or zipCode = '75051' or zipCode = '75052' or zipCode = '75053' or zipCode = '75054' or zipCode = '75056' or zipCode = '75056' or zipCode = '75057' or zipCode = '75060' or zipCode = '75061' or zipCode = '75062' or zipCode = '75063' or zipCode = '75067' or zipCode = '75067' or zipCode = '75088' or zipCode = '75089' or zipCode = '75093' or zipCode = '75094' or zipCode = '75094' or zipCode = '75098' or zipCode = '75098' or zipCode = '75099' or zipCode = '75099' or zipCode = '75099' or zipCode = '75104' or zipCode = '75106' or zipCode = '75114' or zipCode = '75146' or zipCode = '75149' or zipCode = '75150' or zipCode = '75154' or zipCode = '75154' or zipCode = '75154' or zipCode = '75154' or zipCode = '75202' or zipCode = '75203' or zipCode = '75204' or zipCode = '75205' or zipCode = '75205' or zipCode = '75205' or zipCode = '75205' or zipCode = '75206' or zipCode = '75207' or zipCode = '75208' or zipCode = '75209' or zipCode = '75209' or zipCode = '75210' or zipCode = '75211' or zipCode = '75211' or zipCode = '75212' or zipCode = '75214' or zipCode = '75215' or zipCode = '75216' or zipCode = '75217' or zipCode = '75218' or zipCode = '75219' or zipCode = '75219' or zipCode = '75220' or zipCode = '75244' or zipCode = '75244' or zipCode = '75244' or zipCode = '75244' or zipCode = '75245' or zipCode = '75246' or zipCode = '75247' or zipCode = '75248' or zipCode = '75249' or zipCode = '75250' or zipCode = '75251' or zipCode = '75252' or zipCode = '75252' or zipCode = '75253' or zipCode = '75253' or zipCode = '75254' or zipCode = '75258' or zipCode = '75260' or zipCode = '75261' or zipCode = '75261' or zipCode = '75261' or zipCode = '75262' or zipCode = '75263' or zipCode = '75264' or zipCode = '75074' or zipCode = '75074' or zipCode = '75075' or zipCode = '75080' or zipCode = '75080' or zipCode = '75081' or zipCode = '75082' or zipCode = '75083' or zipCode = '75085' or zipCode = '75086' or zipCode = '75087' or zipCode = '75115' or zipCode = '75116' or zipCode = '75123' or zipCode = '75125' or zipCode = '75126' or zipCode = '75126' or zipCode = '75126' or zipCode = '75134' or zipCode = '75137' or zipCode = '75138' or zipCode = '75141' or zipCode = '75159' or zipCode = '75159' or zipCode = '75172' or zipCode = '75180' or zipCode = '75180' or zipCode = '75181' or zipCode = '75181' or zipCode = '75182' or zipCode = '75182' or zipCode = '75185' or zipCode = '75187' or zipCode = '75201' or zipCode = '75221' or zipCode = '75222' or zipCode = '75223' or zipCode = '75224' or zipCode = '75225' or zipCode = '75226' or zipCode = '75227' or zipCode = '75228' or zipCode = '75229' or zipCode = '75230' or zipCode = '75231' or zipCode = '75232' or zipCode = '75233' or zipCode = '75234' or zipCode = '75234' or zipCode = '75234' or zipCode = '75235' or zipCode = '75236' or zipCode = '75237' or zipCode = '75238' or zipCode = '75240' or zipCode = '75241' or zipCode = '75242' or zipCode = '75243' or zipCode = '75265' or zipCode = '75266' or zipCode = '75267' or zipCode = '75270' or zipCode = '75275' or zipCode = '75275' or zipCode = '75277' or zipCode = '75277' or zipCode = '75283' or zipCode = '75283' or zipCode = '75283' or zipCode = '75284' or zipCode = '75284' or zipCode = '75285' or zipCode = '75285' or zipCode = '75286' or zipCode = '75286' or zipCode = '75287' or zipCode = '75301' or zipCode = '75301' or zipCode = '75303' or zipCode = '75303' or zipCode = '75310' or zipCode = '75310' or zipCode = '75312' or zipCode = '75312' or zipCode = '75313' or zipCode = '75315' or zipCode = '75320' or zipCode = '75320' or zipCode = '75323' or zipCode = '75323' or zipCode = '75326' or zipCode = '75326' or zipCode = '75334' or zipCode = '75336' or zipCode = '75336' or zipCode = '75339' or zipCode = '75340' or zipCode = '75342' or zipCode = '75343' or zipCode = '75344' or zipCode = '75354' or zipCode = '75355' or zipCode = '75356' or zipCode = '75357' or zipCode = '75358' or zipCode = '75358' or zipCode = '75391' or zipCode = '75392' or zipCode = '75392' or zipCode = '75393' or zipCode = '75393' or zipCode = '75394' or zipCode = '75394' or zipCode = '75395' or zipCode = '75395' or zipCode = '75397' or zipCode = '75397' or zipCode = '75398' or zipCode = '75359' or zipCode = '75360' or zipCode = '75367' or zipCode = '75368' or zipCode = '75368' or zipCode = '75370' or zipCode = '75371' or zipCode = '75372' or zipCode = '75373' or zipCode = '75373' or zipCode = '75374' or zipCode = '75376' or zipCode = '75378' or zipCode = '75379' or zipCode = '75380' or zipCode = '75381' or zipCode = '75382' or zipCode = '75387' or zipCode = '75387' or zipCode = '75389' or zipCode = '75389' or zipCode = '75390' or zipCode = '75390' or zipCode = '75391' or zipCode = '76015' or zipCode = '76016' or zipCode = '76016' or zipCode = '76017' or zipCode = '76018' or zipCode = '76019' or zipCode = '76019' or zipCode = '76019' or zipCode = '76021' or zipCode = '76022' or zipCode = '76034' or zipCode = '76039' or zipCode = '76040' or zipCode = '76092' or zipCode = '76092' or zipCode = '76094' or zipCode = '76095' or zipCode = '76096' or zipCode = '76099' or zipCode = '76112' or zipCode = '76001' or zipCode = '76002' or zipCode = '76003' or zipCode = '76004' or zipCode = '76005' or zipCode = '76006' or zipCode = '76007' or zipCode = '76010' or zipCode = '76011' or zipCode = '76012' or zipCode = '76013' or zipCode = '76013' or zipCode = '76014' or zipCode = '76015' or zipCode = '76051' or zipCode = '76053' or zipCode = '76054' or zipCode = '76063' or zipCode = '76118' or zipCode = '76118' or zipCode = '76118' or zipCode = '76118' or zipCode = '76118' or zipCode = '76120' or zipCode = '76155' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '75001' or zipCode = '75002' or zipCode = '75006' or zipCode = '75007' or zipCode = '75010' or zipCode = '75011' or zipCode = '75013' or zipCode = '75014' or zipCode = '75015' or zipCode = '75016' or zipCode = '75017' or zipCode = '75019' or zipCode = '75022' or zipCode = '75023' or zipCode = '75024' or zipCode = '75025' or zipCode = '75028' or zipCode = '75030' or zipCode = '75032' or zipCode = '75034' or zipCode = '75035' or zipCode = '75037' or zipCode = '75038' or zipCode = '75039' or zipCode = '75040' or zipCode = '75041' or zipCode = '75042' or zipCode = '75043' or zipCode = '75044' or zipCode = '75045' or zipCode = '75046' or zipCode = '75047' or zipCode = '75048' or zipCode = '75049' or zipCode = '75050' or zipCode = '75051' or zipCode = '75052' or zipCode = '75053' or zipCode = '75054' or zipCode = '75056' or zipCode = '75057' or zipCode = '75059' or zipCode = '75060' or zipCode = '75061' or zipCode = '75062' or zipCode = '75063' or zipCode = '75066' or zipCode = '75067' or zipCode = '75074' or zipCode = '75075' or zipCode = '75077' or zipCode = '75080' or zipCode = '75081' or zipCode = '75082' or zipCode = '75083' or zipCode = '75085' or zipCode = '75086' or zipCode = '75087' or zipCode = '75088' or zipCode = '75089' or zipCode = '75093' or zipCode = '75094' or zipCode = '75098' or zipCode = '75099' or zipCode = '75104' or zipCode = '75106' or zipCode = '75114' or zipCode = '75115' or zipCode = '75116' or zipCode = '75123' or zipCode = '75125' or zipCode = '75126' or zipCode = '75134' or zipCode = '75137' or zipCode = '75138' or zipCode = '75141' or zipCode = '75146' or zipCode = '75149' or zipCode = '75150' or zipCode = '75154' or zipCode = '75159' or zipCode = '75172' or zipCode = '75180' or zipCode = '75181' or zipCode = '75182' or zipCode = '75185' or zipCode = '75187' or zipCode = '75201' or zipCode = '75202' or zipCode = '75203' or zipCode = '75204' or zipCode = '75205' or zipCode = '75206' or zipCode = '75207' or zipCode = '75208' or zipCode = '75209' or zipCode = '75210' or zipCode = '75211' or zipCode = '75212' or zipCode = '75214' or zipCode = '75215' or zipCode = '75216' or zipCode = '75217' or zipCode = '75218' or zipCode = '75219' or zipCode = '75220' or zipCode = '75221' or zipCode = '75222' or zipCode = '75223' or zipCode = '75224' or zipCode = '75225' or zipCode = '75226' or zipCode = '75227' or zipCode = '75228' or zipCode = '75229' or zipCode = '75230' or zipCode = '75231' or zipCode = '75232' or zipCode = '75233' or zipCode = '75234' or zipCode = '75235' or zipCode = '75236' or zipCode = '75237' or zipCode = '75238' or zipCode = '75239' or zipCode = '75240' or zipCode = '75241' or zipCode = '75242' or zipCode = '75243' or zipCode = '75244' or zipCode = '75245' or zipCode = '75246' or zipCode = '75247' or zipCode = '75248' or zipCode = '75249' or zipCode = '75250' or zipCode = '75251' or zipCode = '75252' or zipCode = '75253' or zipCode = '75254' or zipCode = '75255' or zipCode = '75258' or zipCode = '75260' or zipCode = '75261' or zipCode = '75262' or zipCode = '75263' or zipCode = '75264' or zipCode = '75265' or zipCode = '75266' or zipCode = '75267' or zipCode = '75270' or zipCode = '75275' or zipCode = '75277' or zipCode = '75283' or zipCode = '75284' or zipCode = '75285' or zipCode = '75286' or zipCode = '75287' or zipCode = '75294' or zipCode = '75295' or zipCode = '75301' or zipCode = '75303' or zipCode = '75310' or zipCode = '75312' or zipCode = '75313' or zipCode = '75315' or zipCode = '75320' or zipCode = '75323' or zipCode = '75326' or zipCode = '75336' or zipCode = '75339' or zipCode = '75342' or zipCode = '75346' or zipCode = '75350' or zipCode = '75353' or zipCode = '75354' or zipCode = '75355' or zipCode = '75356' or zipCode = '75357' or zipCode = '75359' or zipCode = '75360' or zipCode = '75363' or zipCode = '75364' or zipCode = '75367' or zipCode = '75368' or zipCode = '75370' or zipCode = '75371' or zipCode = '75372' or zipCode = '75373' or zipCode = '75374' or zipCode = '75376' or zipCode = '75378' or zipCode = '75379' or zipCode = '75380' or zipCode = '75381' or zipCode = '75382' or zipCode = '75386' or zipCode = '75387' or zipCode = '75388' or zipCode = '75389' or zipCode = '75390' or zipCode = '75391' or zipCode = '75392' or zipCode = '75393' or zipCode = '75394' or zipCode = '75395' or zipCode = '75396' or zipCode = '75397' or zipCode = '75398' or zipCode = '76001' or zipCode = '76002' or zipCode = '76003' or zipCode = '76006' or zipCode = '76010' or zipCode = '76011' or zipCode = '76012' or zipCode = '76013' or zipCode = '76014' or zipCode = '76015' or zipCode = '76016' or zipCode = '76017' or zipCode = '76018' or zipCode = '76021' or zipCode = '76022' or zipCode = '76025' or zipCode = '76034' or zipCode = '76039' or zipCode = '76040' or zipCode = '76051' or zipCode = '76053' or zipCode = '76054' or zipCode = '76063' or zipCode = '76065' or zipCode = '76092' or zipCode = '76112' or zipCode = '76118' or zipCode = '76120' or zipCode = '76155' or zipCode = '76180') 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 ='75001' or property_zip = '75002' or property_zip = '75002' or property_zip = '75006' or property_zip = '75007' or property_zip = '75010' or property_zip = '75011' or property_zip = '75013' or property_zip = '75014' or property_zip = '75015' or property_zip = '75016' or property_zip = '75017' or property_zip = '75019' or property_zip = '75023' or property_zip = '75024' or property_zip = '75025' or property_zip = '75026' or property_zip = '75027' or property_zip = '75027' or property_zip = '75027' or property_zip = '75028' or property_zip = '75028' or property_zip = '75028' or property_zip = '75029' or property_zip = '75030' or property_zip = '75032' or property_zip = '75032' or property_zip = '75037' or property_zip = '75037' or property_zip = '75038' or property_zip = '75039' or property_zip = '75040' or property_zip = '75041' or property_zip = '75042' or property_zip = '75043' or property_zip = '75044' or property_zip = '75045' or property_zip = '75046' or property_zip = '75047' or property_zip = '75048' or property_zip = '75048' or property_zip = '75049' or property_zip = '75050' or property_zip = '75051' or property_zip = '75052' or property_zip = '75053' or property_zip = '75054' or property_zip = '75056' or property_zip = '75056' or property_zip = '75057' or property_zip = '75060' or property_zip = '75061' or property_zip = '75062' or property_zip = '75063' or property_zip = '75067' or property_zip = '75067' or property_zip = '75088' or property_zip = '75089' or property_zip = '75093' or property_zip = '75094' or property_zip = '75094' or property_zip = '75098' or property_zip = '75098' or property_zip = '75099' or property_zip = '75099' or property_zip = '75099' or property_zip = '75104' or property_zip = '75106' or property_zip = '75114' or property_zip = '75146' or property_zip = '75149' or property_zip = '75150' or property_zip = '75154' or property_zip = '75154' or property_zip = '75154' or property_zip = '75154' or property_zip = '75202' or property_zip = '75203' or property_zip = '75204' or property_zip = '75205' or property_zip = '75205' or property_zip = '75205' or property_zip = '75205' or property_zip = '75206' or property_zip = '75207' or property_zip = '75208' or property_zip = '75209' or property_zip = '75209' or property_zip = '75210' or property_zip = '75211' or property_zip = '75211' or property_zip = '75212' or property_zip = '75214' or property_zip = '75215' or property_zip = '75216' or property_zip = '75217' or property_zip = '75218' or property_zip = '75219' or property_zip = '75219' or property_zip = '75220' or property_zip = '75244' or property_zip = '75244' or property_zip = '75244' or property_zip = '75244' or property_zip = '75245' or property_zip = '75246' or property_zip = '75247' or property_zip = '75248' or property_zip = '75249' or property_zip = '75250' or property_zip = '75251' or property_zip = '75252' or property_zip = '75252' or property_zip = '75253' or property_zip = '75253' or property_zip = '75254' or property_zip = '75258' or property_zip = '75260' or property_zip = '75261' or property_zip = '75261' or property_zip = '75261' or property_zip = '75262' or property_zip = '75263' or property_zip = '75264' or property_zip = '75074' or property_zip = '75074' or property_zip = '75075' or property_zip = '75080' or property_zip = '75080' or property_zip = '75081' or property_zip = '75082' or property_zip = '75083' or property_zip = '75085' or property_zip = '75086' or property_zip = '75087' or property_zip = '75115' or property_zip = '75116' or property_zip = '75123' or property_zip = '75125' or property_zip = '75126' or property_zip = '75126' or property_zip = '75126' or property_zip = '75134' or property_zip = '75137' or property_zip = '75138' or property_zip = '75141' or property_zip = '75159' or property_zip = '75159' or property_zip = '75172' or property_zip = '75180' or property_zip = '75180' or property_zip = '75181' or property_zip = '75181' or property_zip = '75182' or property_zip = '75182' or property_zip = '75185' or property_zip = '75187' or property_zip = '75201' or property_zip = '75221' or property_zip = '75222' or property_zip = '75223' or property_zip = '75224' or property_zip = '75225' or property_zip = '75226' or property_zip = '75227' or property_zip = '75228' or property_zip = '75229' or property_zip = '75230' or property_zip = '75231' or property_zip = '75232' or property_zip = '75233' or property_zip = '75234' or property_zip = '75234' or property_zip = '75234' or property_zip = '75235' or property_zip = '75236' or property_zip = '75237' or property_zip = '75238' or property_zip = '75240' or property_zip = '75241' or property_zip = '75242' or property_zip = '75243' or property_zip = '75265' or property_zip = '75266' or property_zip = '75267' or property_zip = '75270' or property_zip = '75275' or property_zip = '75275' or property_zip = '75277' or property_zip = '75277' or property_zip = '75283' or property_zip = '75283' or property_zip = '75283' or property_zip = '75284' or property_zip = '75284' or property_zip = '75285' or property_zip = '75285' or property_zip = '75286' or property_zip = '75286' or property_zip = '75287' or property_zip = '75301' or property_zip = '75301' or property_zip = '75303' or property_zip = '75303' or property_zip = '75310' or property_zip = '75310' or property_zip = '75312' or property_zip = '75312' or property_zip = '75313' or property_zip = '75315' or property_zip = '75320' or property_zip = '75320' or property_zip = '75323' or property_zip = '75323' or property_zip = '75326' or property_zip = '75326' or property_zip = '75334' or property_zip = '75336' or property_zip = '75336' or property_zip = '75339' or property_zip = '75340' or property_zip = '75342' or property_zip = '75343' or property_zip = '75344' or property_zip = '75354' or property_zip = '75355' or property_zip = '75356' or property_zip = '75357' or property_zip = '75358' or property_zip = '75358' or property_zip = '75391' or property_zip = '75392' or property_zip = '75392' or property_zip = '75393' or property_zip = '75393' or property_zip = '75394' or property_zip = '75394' or property_zip = '75395' or property_zip = '75395' or property_zip = '75397' or property_zip = '75397' or property_zip = '75398' or property_zip = '75359' or property_zip = '75360' or property_zip = '75367' or property_zip = '75368' or property_zip = '75368' or property_zip = '75370' or property_zip = '75371' or property_zip = '75372' or property_zip = '75373' or property_zip = '75373' or property_zip = '75374' or property_zip = '75376' or property_zip = '75378' or property_zip = '75379' or property_zip = '75380' or property_zip = '75381' or property_zip = '75382' or property_zip = '75387' or property_zip = '75387' or property_zip = '75389' or property_zip = '75389' or property_zip = '75390' or property_zip = '75390' or property_zip = '75391' or property_zip = '76015' or property_zip = '76016' or property_zip = '76016' or property_zip = '76017' or property_zip = '76018' or property_zip = '76019' or property_zip = '76019' or property_zip = '76019' or property_zip = '76021' or property_zip = '76022' or property_zip = '76034' or property_zip = '76039' or property_zip = '76040' or property_zip = '76092' or property_zip = '76092' or property_zip = '76094' or property_zip = '76095' or property_zip = '76096' or property_zip = '76099' or property_zip = '76112' or property_zip = '76001' or property_zip = '76002' or property_zip = '76003' or property_zip = '76004' or property_zip = '76005' or property_zip = '76006' or property_zip = '76007' or property_zip = '76010' or property_zip = '76011' or property_zip = '76012' or property_zip = '76013' or property_zip = '76013' or property_zip = '76014' or property_zip = '76015' or property_zip = '76051' or property_zip = '76053' or property_zip = '76054' or property_zip = '76063' or property_zip = '76118' or property_zip = '76118' or property_zip = '76118' or property_zip = '76118' or property_zip = '76118' or property_zip = '76120' or property_zip = '76155' or property_zip = '76180' or property_zip = '76180' or property_zip = '76180' or property_zip = '76180' or property_zip = '76180' or property_zip = '76180' or property_zip = '76180' or property_zip = '75001' or property_zip = '75002' or property_zip = '75006' or property_zip = '75007' or property_zip = '75010' or property_zip = '75011' or property_zip = '75013' or property_zip = '75014' or property_zip = '75015' or property_zip = '75016' or property_zip = '75017' or property_zip = '75019' or property_zip = '75022' or property_zip = '75023' or property_zip = '75024' or property_zip = '75025' or property_zip = '75028' or property_zip = '75030' or property_zip = '75032' or property_zip = '75034' or property_zip = '75035' or property_zip = '75037' or property_zip = '75038' or property_zip = '75039' or property_zip = '75040' or property_zip = '75041' or property_zip = '75042' or property_zip = '75043' or property_zip = '75044' or property_zip = '75045' or property_zip = '75046' or property_zip = '75047' or property_zip = '75048' or property_zip = '75049' or property_zip = '75050' or property_zip = '75051' or property_zip = '75052' or property_zip = '75053' or property_zip = '75054' or property_zip = '75056' or property_zip = '75057' or property_zip = '75059' or property_zip = '75060' or property_zip = '75061' or property_zip = '75062' or property_zip = '75063' or property_zip = '75066' or property_zip = '75067' or property_zip = '75074' or property_zip = '75075' or property_zip = '75077' or property_zip = '75080' or property_zip = '75081' or property_zip = '75082' or property_zip = '75083' or property_zip = '75085' or property_zip = '75086' or property_zip = '75087' or property_zip = '75088' or property_zip = '75089' or property_zip = '75093' or property_zip = '75094' or property_zip = '75098' or property_zip = '75099' or property_zip = '75104' or property_zip = '75106' or property_zip = '75114' or property_zip = '75115' or property_zip = '75116' or property_zip = '75123' or property_zip = '75125' or property_zip = '75126' or property_zip = '75134' or property_zip = '75137' or property_zip = '75138' or property_zip = '75141' or property_zip = '75146' or property_zip = '75149' or property_zip = '75150' or property_zip = '75154' or property_zip = '75159' or property_zip = '75172' or property_zip = '75180' or property_zip = '75181' or property_zip = '75182' or property_zip = '75185' or property_zip = '75187' or property_zip = '75201' or property_zip = '75202' or property_zip = '75203' or property_zip = '75204' or property_zip = '75205' or property_zip = '75206' or property_zip = '75207' or property_zip = '75208' or property_zip = '75209' or property_zip = '75210' or property_zip = '75211' or property_zip = '75212' or property_zip = '75214' or property_zip = '75215' or property_zip = '75216' or property_zip = '75217' or property_zip = '75218' or property_zip = '75219' or property_zip = '75220' or property_zip = '75221' or property_zip = '75222' or property_zip = '75223' or property_zip = '75224' or property_zip = '75225' or property_zip = '75226' or property_zip = '75227' or property_zip = '75228' or property_zip = '75229' or property_zip = '75230' or property_zip = '75231' or property_zip = '75232' or property_zip = '75233' or property_zip = '75234' or property_zip = '75235' or property_zip = '75236' or property_zip = '75237' or property_zip = '75238' or property_zip = '75239' or property_zip = '75240' or property_zip = '75241' or property_zip = '75242' or property_zip = '75243' or property_zip = '75244' or property_zip = '75245' or property_zip = '75246' or property_zip = '75247' or property_zip = '75248' or property_zip = '75249' or property_zip = '75250' or property_zip = '75251' or property_zip = '75252' or property_zip = '75253' or property_zip = '75254' or property_zip = '75255' or property_zip = '75258' or property_zip = '75260' or property_zip = '75261' or property_zip = '75262' or property_zip = '75263' or property_zip = '75264' or property_zip = '75265' or property_zip = '75266' or property_zip = '75267' or property_zip = '75270' or property_zip = '75275' or property_zip = '75277' or property_zip = '75283' or property_zip = '75284' or property_zip = '75285' or property_zip = '75286' or property_zip = '75287' or property_zip = '75294' or property_zip = '75295' or property_zip = '75301' or property_zip = '75303' or property_zip = '75310' or property_zip = '75312' or property_zip = '75313' or property_zip = '75315' or property_zip = '75320' or property_zip = '75323' or property_zip = '75326' or property_zip = '75336' or property_zip = '75339' or property_zip = '75342' or property_zip = '75346' or property_zip = '75350' or property_zip = '75353' or property_zip = '75354' or property_zip = '75355' or property_zip = '75356' or property_zip = '75357' or property_zip = '75359' or property_zip = '75360' or property_zip = '75363' or property_zip = '75364' or property_zip = '75367' or property_zip = '75368' or property_zip = '75370' or property_zip = '75371' or property_zip = '75372' or property_zip = '75373' or property_zip = '75374' or property_zip = '75376' or property_zip = '75378' or property_zip = '75379' or property_zip = '75380' or property_zip = '75381' or property_zip = '75382' or property_zip = '75386' or property_zip = '75387' or property_zip = '75388' or property_zip = '75389' or property_zip = '75390' or property_zip = '75391' or property_zip = '75392' or property_zip = '75393' or property_zip = '75394' or property_zip = '75395' or property_zip = '75396' or property_zip = '75397' or property_zip = '75398' or property_zip = '76001' or property_zip = '76002' or property_zip = '76003' or property_zip = '76006' or property_zip = '76010' or property_zip = '76011' or property_zip = '76012' or property_zip = '76013' or property_zip = '76014' or property_zip = '76015' or property_zip = '76016' or property_zip = '76017' or property_zip = '76018' or property_zip = '76021' or property_zip = '76022' or property_zip = '76025' or property_zip = '76034' or property_zip = '76039' or property_zip = '76040' or property_zip = '76051' or property_zip = '76053' or property_zip = '76054' or property_zip = '76063' or property_zip = '76065' or property_zip = '76092' or property_zip = '76112' or property_zip = '76118' or property_zip = '76120' or property_zip = '76155' or property_zip = '76180') and convert(date,auction_start_date) >= '9/27/2021';
select top 45 * from currentforeclosures.tblAll NOLOCK where state = 'TX '
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 ='75001' or zip = '75002' or zip = '75002' or zip = '75006' or zip = '75007' or zip = '75010' or zip = '75011' or zip = '75013' or zip = '75014' or zip = '75015' or zip = '75016' or zip = '75017' or zip = '75019' or zip = '75023' or zip = '75024' or zip = '75025' or zip = '75026' or zip = '75027' or zip = '75027' or zip = '75027' or zip = '75028' or zip = '75028' or zip = '75028' or zip = '75029' or zip = '75030' or zip = '75032' or zip = '75032' or zip = '75037' or zip = '75037' or zip = '75038' or zip = '75039' or zip = '75040' or zip = '75041' or zip = '75042' or zip = '75043' or zip = '75044' or zip = '75045' or zip = '75046' or zip = '75047' or zip = '75048' or zip = '75048' or zip = '75049' or zip = '75050' or zip = '75051' or zip = '75052' or zip = '75053' or zip = '75054' or zip = '75056' or zip = '75056' or zip = '75057' or zip = '75060' or zip = '75061' or zip = '75062' or zip = '75063' or zip = '75067' or zip = '75067' or zip = '75088' or zip = '75089' or zip = '75093' or zip = '75094' or zip = '75094' or zip = '75098' or zip = '75098' or zip = '75099' or zip = '75099' or zip = '75099' or zip = '75104' or zip = '75106' or zip = '75114' or zip = '75146' or zip = '75149' or zip = '75150' or zip = '75154' or zip = '75154' or zip = '75154' or zip = '75154' or zip = '75202' or zip = '75203' or zip = '75204' or zip = '75205' or zip = '75205' or zip = '75205' or zip = '75205' or zip = '75206' or zip = '75207' or zip = '75208' or zip = '75209' or zip = '75209' or zip = '75210' or zip = '75211' or zip = '75211' or zip = '75212' or zip = '75214' or zip = '75215' or zip = '75216' or zip = '75217' or zip = '75218' or zip = '75219' or zip = '75219' or zip = '75220' or zip = '75244' or zip = '75244' or zip = '75244' or zip = '75244' or zip = '75245' or zip = '75246' or zip = '75247' or zip = '75248' or zip = '75249' or zip = '75250' or zip = '75251' or zip = '75252' or zip = '75252' or zip = '75253' or zip = '75253' or zip = '75254' or zip = '75258' or zip = '75260' or zip = '75261' or zip = '75261' or zip = '75261' or zip = '75262' or zip = '75263' or zip = '75264' or zip = '75074' or zip = '75074' or zip = '75075' or zip = '75080' or zip = '75080' or zip = '75081' or zip = '75082' or zip = '75083' or zip = '75085' or zip = '75086' or zip = '75087' or zip = '75115' or zip = '75116' or zip = '75123' or zip = '75125' or zip = '75126' or zip = '75126' or zip = '75126' or zip = '75134' or zip = '75137' or zip = '75138' or zip = '75141' or zip = '75159' or zip = '75159' or zip = '75172' or zip = '75180' or zip = '75180' or zip = '75181' or zip = '75181' or zip = '75182' or zip = '75182' or zip = '75185' or zip = '75187' or zip = '75201' or zip = '75221' or zip = '75222' or zip = '75223' or zip = '75224' or zip = '75225' or zip = '75226' or zip = '75227' or zip = '75228' or zip = '75229' or zip = '75230' or zip = '75231' or zip = '75232' or zip = '75233' or zip = '75234' or zip = '75234' or zip = '75234' or zip = '75235' or zip = '75236' or zip = '75237' or zip = '75238' or zip = '75240' or zip = '75241' or zip = '75242' or zip = '75243' or zip = '75265' or zip = '75266' or zip = '75267' or zip = '75270' or zip = '75275' or zip = '75275' or zip = '75277' or zip = '75277' or zip = '75283' or zip = '75283' or zip = '75283' or zip = '75284' or zip = '75284' or zip = '75285' or zip = '75285' or zip = '75286' or zip = '75286' or zip = '75287' or zip = '75301' or zip = '75301' or zip = '75303' or zip = '75303' or zip = '75310' or zip = '75310' or zip = '75312' or zip = '75312' or zip = '75313' or zip = '75315' or zip = '75320' or zip = '75320' or zip = '75323' or zip = '75323' or zip = '75326' or zip = '75326' or zip = '75334' or zip = '75336' or zip = '75336' or zip = '75339' or zip = '75340' or zip = '75342' or zip = '75343' or zip = '75344' or zip = '75354' or zip = '75355' or zip = '75356' or zip = '75357' or zip = '75358' or zip = '75358' or zip = '75391' or zip = '75392' or zip = '75392' or zip = '75393' or zip = '75393' or zip = '75394' or zip = '75394' or zip = '75395' or zip = '75395' or zip = '75397' or zip = '75397' or zip = '75398' or zip = '75359' or zip = '75360' or zip = '75367' or zip = '75368' or zip = '75368' or zip = '75370' or zip = '75371' or zip = '75372' or zip = '75373' or zip = '75373' or zip = '75374' or zip = '75376' or zip = '75378' or zip = '75379' or zip = '75380' or zip = '75381' or zip = '75382' or zip = '75387' or zip = '75387' or zip = '75389' or zip = '75389' or zip = '75390' or zip = '75390' or zip = '75391' or zip = '76015' or zip = '76016' or zip = '76016' or zip = '76017' or zip = '76018' or zip = '76019' or zip = '76019' or zip = '76019' or zip = '76021' or zip = '76022' or zip = '76034' or zip = '76039' or zip = '76040' or zip = '76092' or zip = '76092' or zip = '76094' or zip = '76095' or zip = '76096' or zip = '76099' or zip = '76112' or zip = '76001' or zip = '76002' or zip = '76003' or zip = '76004' or zip = '76005' or zip = '76006' or zip = '76007' or zip = '76010' or zip = '76011' or zip = '76012' or zip = '76013' or zip = '76013' or zip = '76014' or zip = '76015' or zip = '76051' or zip = '76053' or zip = '76054' or zip = '76063' or zip = '76118' or zip = '76118' or zip = '76118' or zip = '76118' or zip = '76118' or zip = '76120' or zip = '76155' or zip = '76180' or zip = '76180' or zip = '76180' or zip = '76180' or zip = '76180' or zip = '76180' or zip = '76180' or zip = '75001' or zip = '75002' or zip = '75006' or zip = '75007' or zip = '75010' or zip = '75011' or zip = '75013' or zip = '75014' or zip = '75015' or zip = '75016' or zip = '75017' or zip = '75019' or zip = '75022' or zip = '75023' or zip = '75024' or zip = '75025' or zip = '75028' or zip = '75030' or zip = '75032' or zip = '75034' or zip = '75035' or zip = '75037' or zip = '75038' or zip = '75039' or zip = '75040' or zip = '75041' or zip = '75042' or zip = '75043' or zip = '75044' or zip = '75045' or zip = '75046' or zip = '75047' or zip = '75048' or zip = '75049' or zip = '75050' or zip = '75051' or zip = '75052' or zip = '75053' or zip = '75054' or zip = '75056' or zip = '75057' or zip = '75059' or zip = '75060' or zip = '75061' or zip = '75062' or zip = '75063' or zip = '75066' or zip = '75067' or zip = '75074' or zip = '75075' or zip = '75077' or zip = '75080' or zip = '75081' or zip = '75082' or zip = '75083' or zip = '75085' or zip = '75086' or zip = '75087' or zip = '75088' or zip = '75089' or zip = '75093' or zip = '75094' or zip = '75098' or zip = '75099' or zip = '75104' or zip = '75106' or zip = '75114' or zip = '75115' or zip = '75116' or zip = '75123' or zip = '75125' or zip = '75126' or zip = '75134' or zip = '75137' or zip = '75138' or zip = '75141' or zip = '75146' or zip = '75149' or zip = '75150' or zip = '75154' or zip = '75159' or zip = '75172' or zip = '75180' or zip = '75181' or zip = '75182' or zip = '75185' or zip = '75187' or zip = '75201' or zip = '75202' or zip = '75203' or zip = '75204' or zip = '75205' or zip = '75206' or zip = '75207' or zip = '75208' or zip = '75209' or zip = '75210' or zip = '75211' or zip = '75212' or zip = '75214' or zip = '75215' or zip = '75216' or zip = '75217' or zip = '75218' or zip = '75219' or zip = '75220' or zip = '75221' or zip = '75222' or zip = '75223' or zip = '75224' or zip = '75225' or zip = '75226' or zip = '75227' or zip = '75228' or zip = '75229' or zip = '75230' or zip = '75231' or zip = '75232' or zip = '75233' or zip = '75234' or zip = '75235' or zip = '75236' or zip = '75237' or zip = '75238' or zip = '75239' or zip = '75240' or zip = '75241' or zip = '75242' or zip = '75243' or zip = '75244' or zip = '75245' or zip = '75246' or zip = '75247' or zip = '75248' or zip = '75249' or zip = '75250' or zip = '75251' or zip = '75252' or zip = '75253' or zip = '75254' or zip = '75255' or zip = '75258' or zip = '75260' or zip = '75261' or zip = '75262' or zip = '75263' or zip = '75264' or zip = '75265' or zip = '75266' or zip = '75267' or zip = '75270' or zip = '75275' or zip = '75277' or zip = '75283' or zip = '75284' or zip = '75285' or zip = '75286' or zip = '75287' or zip = '75294' or zip = '75295' or zip = '75301' or zip = '75303' or zip = '75310' or zip = '75312' or zip = '75313' or zip = '75315' or zip = '75320' or zip = '75323' or zip = '75326' or zip = '75336' or zip = '75339' or zip = '75342' or zip = '75346' or zip = '75350' or zip = '75353' or zip = '75354' or zip = '75355' or zip = '75356' or zip = '75357' or zip = '75359' or zip = '75360' or zip = '75363' or zip = '75364' or zip = '75367' or zip = '75368' or zip = '75370' or zip = '75371' or zip = '75372' or zip = '75373' or zip = '75374' or zip = '75376' or zip = '75378' or zip = '75379' or zip = '75380' or zip = '75381' or zip = '75382' or zip = '75386' or zip = '75387' or zip = '75388' or zip = '75389' or zip = '75390' or zip = '75391' or zip = '75392' or zip = '75393' or zip = '75394' or zip = '75395' or zip = '75396' or zip = '75397' or zip = '75398' or zip = '76001' or zip = '76002' or zip = '76003' or zip = '76006' or zip = '76010' or zip = '76011' or zip = '76012' or zip = '76013' or zip = '76014' or zip = '76015' or zip = '76016' or zip = '76017' or zip = '76018' or zip = '76021' or zip = '76022' or zip = '76025' or zip = '76034' or zip = '76039' or zip = '76040' or zip = '76051' or zip = '76053' or zip = '76054' or zip = '76063' or zip = '76065' or zip = '76092' or zip = '76112' or zip = '76118' or zip = '76120' or zip = '76155' or zip = '76180')
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 = 'TX' and city = 'DALLAS' and state = 'TX ' 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();