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


208+ High Potential Investor Deals Near fort worth [Refine]


********NOTICE: Displaying 99 of over 208 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 ='75014' or zipCode = '75015' or zipCode = '75016' or zipCode = '75017' or zipCode = '75019' or zipCode = '75022' or zipCode = '75022' or zipCode = '75022' or zipCode = '75027' or zipCode = '75027' or zipCode = '75027' or zipCode = '75028' or zipCode = '75028' or zipCode = '75028' or zipCode = '75037' or zipCode = '75037' or zipCode = '75038' or zipCode = '75039' or zipCode = '75050' or zipCode = '75051' or zipCode = '75052' or zipCode = '75053' or zipCode = '75054' or zipCode = '75060' or zipCode = '75061' or zipCode = '75062' or zipCode = '75063' or zipCode = '75067' or zipCode = '75067' or zipCode = '75099' or zipCode = '75099' or zipCode = '75099' or zipCode = '75104' or zipCode = '75106' or zipCode = '75211' or zipCode = '75211' or zipCode = '75212' or zipCode = '75247' or zipCode = '75249' or zipCode = '75261' or zipCode = '75261' or zipCode = '75261' or zipCode = '75077' or zipCode = '75077' or zipCode = '75077' or zipCode = '75077' or zipCode = '75077' or zipCode = '75116' or zipCode = '75137' or zipCode = '75138' or zipCode = '75233' or zipCode = '75236' or zipCode = '75340' or zipCode = '75343' 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 = '76020' or zipCode = '76020' or zipCode = '76021' or zipCode = '76022' or zipCode = '76028' or zipCode = '76034' or zipCode = '76036' or zipCode = '76039' or zipCode = '76040' or zipCode = '76085' or zipCode = '76092' or zipCode = '76092' or zipCode = '76094' or zipCode = '76095' or zipCode = '76096' or zipCode = '76097' or zipCode = '76098' or zipCode = '76099' or zipCode = '76101' or zipCode = '76102' or zipCode = '76103' or zipCode = '76104' or zipCode = '76105' or zipCode = '76106' or zipCode = '76107' or zipCode = '76107' or zipCode = '76108' or zipCode = '76108' or zipCode = '76108' or zipCode = '76108' or zipCode = '76109' or zipCode = '76109' or zipCode = '76110' or zipCode = '76111' or zipCode = '76111' or zipCode = '76112' or zipCode = '76113' or zipCode = '76114' or zipCode = '76114' or zipCode = '76114' or zipCode = '76114' or zipCode = '76114' or zipCode = '76114' or zipCode = '76127' or zipCode = '76129' or zipCode = '76129' or zipCode = '76130' or zipCode = '76130' or zipCode = '76131' or zipCode = '76131' or zipCode = '76131' or zipCode = '76132' or zipCode = '76132' or zipCode = '76133' or zipCode = '76134' or zipCode = '76135' or zipCode = '76135' or zipCode = '76135' or zipCode = '76136' or zipCode = '76136' or zipCode = '76137' or zipCode = '76137' or zipCode = '76137' or zipCode = '76140' or zipCode = '76140' or zipCode = '76140' or zipCode = '76001' or zipCode = '76002' or zipCode = '76003' or zipCode = '76004' or zipCode = '76005' or zipCode = '76006' or zipCode = '76007' or zipCode = '76008' or zipCode = '76008' or zipCode = '76009' 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 = '76052' or zipCode = '76053' or zipCode = '76054' or zipCode = '76058' or zipCode = '76060' or zipCode = '76061' or zipCode = '76063' or zipCode = '76071' or zipCode = '76115' or zipCode = '76115' or zipCode = '76116' or zipCode = '76116' or zipCode = '76117' or zipCode = '76117' or zipCode = '76118' or zipCode = '76118' or zipCode = '76118' or zipCode = '76118' or zipCode = '76118' or zipCode = '76119' or zipCode = '76119' or zipCode = '76120' or zipCode = '76121' or zipCode = '76122' or zipCode = '76122' or zipCode = '76123' or zipCode = '76124' or zipCode = '76126' or zipCode = '76126' or zipCode = '76127' or zipCode = '76127' or zipCode = '76147' or zipCode = '76148' or zipCode = '76148' or zipCode = '76148' or zipCode = '76148' or zipCode = '76150' or zipCode = '76155' or zipCode = '76161' or zipCode = '76162' or zipCode = '76163' or zipCode = '76164' or zipCode = '76166' or zipCode = '76166' or zipCode = '76177' or zipCode = '76177' or zipCode = '76179' or zipCode = '76179' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76181' or zipCode = '76182' or zipCode = '76182' or zipCode = '76182' or zipCode = '76185' or zipCode = '76191' or zipCode = '76191' or zipCode = '76192' or zipCode = '76192' or zipCode = '76193' or zipCode = '76193' or zipCode = '76195' or zipCode = '76195' or zipCode = '76196' or zipCode = '76196' or zipCode = '76197' or zipCode = '76197' or zipCode = '76198' or zipCode = '76198' or zipCode = '76199' or zipCode = '76244' or zipCode = '76247' or zipCode = '76248' or zipCode = '76262' or zipCode = '76262' or zipCode = '76262' or zipCode = '76226' or zipCode = '76226' or zipCode = '76226' or zipCode = '76226' or zipCode = '75019' or zipCode = '75022' or zipCode = '75028' or zipCode = '75038' or zipCode = '75039' or zipCode = '75050' or zipCode = '75051' or zipCode = '75052' or zipCode = '75059' or zipCode = '75060' or zipCode = '75061' or zipCode = '75062' or zipCode = '75063' or zipCode = '75067' or zipCode = '75104' or zipCode = '75116' or zipCode = '75137' or zipCode = '75211' or zipCode = '75212' or zipCode = '75233' or zipCode = '75236' or zipCode = '75247' or zipCode = '75249' or zipCode = '76001' or zipCode = '76002' or zipCode = '76003' or zipCode = '76004' or zipCode = '76005' or zipCode = '76006' or zipCode = '76007' or zipCode = '76008' 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 = '76019' or zipCode = '76020' or zipCode = '76021' or zipCode = '76022' or zipCode = '76028' or zipCode = '76034' or zipCode = '76036' or zipCode = '76039' or zipCode = '76040' or zipCode = '76051' or zipCode = '76052' or zipCode = '76053' or zipCode = '76054' or zipCode = '76058' or zipCode = '76060' or zipCode = '76061' or zipCode = '76063' or zipCode = '76071' or zipCode = '76078' or zipCode = '76085' or zipCode = '76092' or zipCode = '76094' or zipCode = '76095' or zipCode = '76096' or zipCode = '76097' or zipCode = '76098' or zipCode = '76099' or zipCode = '76101' or zipCode = '76102' or zipCode = '76103' or zipCode = '76104' or zipCode = '76105' or zipCode = '76106' or zipCode = '76107' or zipCode = '76108' or zipCode = '76109' or zipCode = '76110' or zipCode = '76111' or zipCode = '76112' or zipCode = '76113' or zipCode = '76114' or zipCode = '76115' or zipCode = '76116' or zipCode = '76117' or zipCode = '76118' or zipCode = '76119' or zipCode = '76120' or zipCode = '76121' or zipCode = '76122' or zipCode = '76123' or zipCode = '76124' or zipCode = '76126' or zipCode = '76127' or zipCode = '76129' or zipCode = '76130' or zipCode = '76131' or zipCode = '76132' or zipCode = '76133' or zipCode = '76134' or zipCode = '76135' or zipCode = '76136' or zipCode = '76137' or zipCode = '76140' or zipCode = '76147' or zipCode = '76148' or zipCode = '76150' or zipCode = '76153' or zipCode = '76155' or zipCode = '76161' or zipCode = '76162' or zipCode = '76163' or zipCode = '76164' or zipCode = '76177' or zipCode = '76178' or zipCode = '76179' or zipCode = '76180' or zipCode = '76181' or zipCode = '76182' or zipCode = '76185' or zipCode = '76191' or zipCode = '76192' or zipCode = '76193' or zipCode = '76195' or zipCode = '76196' or zipCode = '76197' or zipCode = '76198' or zipCode = '76199' or zipCode = '76226' or zipCode = '76244' or zipCode = '76247' or zipCode = '76248' or zipCode = '76262')
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 ='75014' or zipCode = '75015' or zipCode = '75016' or zipCode = '75017' or zipCode = '75019' or zipCode = '75022' or zipCode = '75022' or zipCode = '75022' or zipCode = '75027' or zipCode = '75027' or zipCode = '75027' or zipCode = '75028' or zipCode = '75028' or zipCode = '75028' or zipCode = '75037' or zipCode = '75037' or zipCode = '75038' or zipCode = '75039' or zipCode = '75050' or zipCode = '75051' or zipCode = '75052' or zipCode = '75053' or zipCode = '75054' or zipCode = '75060' or zipCode = '75061' or zipCode = '75062' or zipCode = '75063' or zipCode = '75067' or zipCode = '75067' or zipCode = '75099' or zipCode = '75099' or zipCode = '75099' or zipCode = '75104' or zipCode = '75106' or zipCode = '75211' or zipCode = '75211' or zipCode = '75212' or zipCode = '75247' or zipCode = '75249' or zipCode = '75261' or zipCode = '75261' or zipCode = '75261' or zipCode = '75077' or zipCode = '75077' or zipCode = '75077' or zipCode = '75077' or zipCode = '75077' or zipCode = '75116' or zipCode = '75137' or zipCode = '75138' or zipCode = '75233' or zipCode = '75236' or zipCode = '75340' or zipCode = '75343' 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 = '76020' or zipCode = '76020' or zipCode = '76021' or zipCode = '76022' or zipCode = '76028' or zipCode = '76034' or zipCode = '76036' or zipCode = '76039' or zipCode = '76040' or zipCode = '76085' or zipCode = '76092' or zipCode = '76092' or zipCode = '76094' or zipCode = '76095' or zipCode = '76096' or zipCode = '76097' or zipCode = '76098' or zipCode = '76099' or zipCode = '76101' or zipCode = '76102' or zipCode = '76103' or zipCode = '76104' or zipCode = '76105' or zipCode = '76106' or zipCode = '76107' or zipCode = '76107' or zipCode = '76108' or zipCode = '76108' or zipCode = '76108' or zipCode = '76108' or zipCode = '76109' or zipCode = '76109' or zipCode = '76110' or zipCode = '76111' or zipCode = '76111' or zipCode = '76112' or zipCode = '76113' or zipCode = '76114' or zipCode = '76114' or zipCode = '76114' or zipCode = '76114' or zipCode = '76114' or zipCode = '76114' or zipCode = '76127' or zipCode = '76129' or zipCode = '76129' or zipCode = '76130' or zipCode = '76130' or zipCode = '76131' or zipCode = '76131' or zipCode = '76131' or zipCode = '76132' or zipCode = '76132' or zipCode = '76133' or zipCode = '76134' or zipCode = '76135' or zipCode = '76135' or zipCode = '76135' or zipCode = '76136' or zipCode = '76136' or zipCode = '76137' or zipCode = '76137' or zipCode = '76137' or zipCode = '76140' or zipCode = '76140' or zipCode = '76140' or zipCode = '76001' or zipCode = '76002' or zipCode = '76003' or zipCode = '76004' or zipCode = '76005' or zipCode = '76006' or zipCode = '76007' or zipCode = '76008' or zipCode = '76008' or zipCode = '76009' 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 = '76052' or zipCode = '76053' or zipCode = '76054' or zipCode = '76058' or zipCode = '76060' or zipCode = '76061' or zipCode = '76063' or zipCode = '76071' or zipCode = '76115' or zipCode = '76115' or zipCode = '76116' or zipCode = '76116' or zipCode = '76117' or zipCode = '76117' or zipCode = '76118' or zipCode = '76118' or zipCode = '76118' or zipCode = '76118' or zipCode = '76118' or zipCode = '76119' or zipCode = '76119' or zipCode = '76120' or zipCode = '76121' or zipCode = '76122' or zipCode = '76122' or zipCode = '76123' or zipCode = '76124' or zipCode = '76126' or zipCode = '76126' or zipCode = '76127' or zipCode = '76127' or zipCode = '76147' or zipCode = '76148' or zipCode = '76148' or zipCode = '76148' or zipCode = '76148' or zipCode = '76150' or zipCode = '76155' or zipCode = '76161' or zipCode = '76162' or zipCode = '76163' or zipCode = '76164' or zipCode = '76166' or zipCode = '76166' or zipCode = '76177' or zipCode = '76177' or zipCode = '76179' or zipCode = '76179' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76181' or zipCode = '76182' or zipCode = '76182' or zipCode = '76182' or zipCode = '76185' or zipCode = '76191' or zipCode = '76191' or zipCode = '76192' or zipCode = '76192' or zipCode = '76193' or zipCode = '76193' or zipCode = '76195' or zipCode = '76195' or zipCode = '76196' or zipCode = '76196' or zipCode = '76197' or zipCode = '76197' or zipCode = '76198' or zipCode = '76198' or zipCode = '76199' or zipCode = '76244' or zipCode = '76247' or zipCode = '76248' or zipCode = '76262' or zipCode = '76262' or zipCode = '76262' or zipCode = '76226' or zipCode = '76226' or zipCode = '76226' or zipCode = '76226' or zipCode = '75019' or zipCode = '75022' or zipCode = '75028' or zipCode = '75038' or zipCode = '75039' or zipCode = '75050' or zipCode = '75051' or zipCode = '75052' or zipCode = '75059' or zipCode = '75060' or zipCode = '75061' or zipCode = '75062' or zipCode = '75063' or zipCode = '75067' or zipCode = '75104' or zipCode = '75116' or zipCode = '75137' or zipCode = '75211' or zipCode = '75212' or zipCode = '75233' or zipCode = '75236' or zipCode = '75247' or zipCode = '75249' or zipCode = '76001' or zipCode = '76002' or zipCode = '76003' or zipCode = '76004' or zipCode = '76005' or zipCode = '76006' or zipCode = '76007' or zipCode = '76008' 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 = '76019' or zipCode = '76020' or zipCode = '76021' or zipCode = '76022' or zipCode = '76028' or zipCode = '76034' or zipCode = '76036' or zipCode = '76039' or zipCode = '76040' or zipCode = '76051' or zipCode = '76052' or zipCode = '76053' or zipCode = '76054' or zipCode = '76058' or zipCode = '76060' or zipCode = '76061' or zipCode = '76063' or zipCode = '76071' or zipCode = '76078' or zipCode = '76085' or zipCode = '76092' or zipCode = '76094' or zipCode = '76095' or zipCode = '76096' or zipCode = '76097' or zipCode = '76098' or zipCode = '76099' or zipCode = '76101' or zipCode = '76102' or zipCode = '76103' or zipCode = '76104' or zipCode = '76105' or zipCode = '76106' or zipCode = '76107' or zipCode = '76108' or zipCode = '76109' or zipCode = '76110' or zipCode = '76111' or zipCode = '76112' or zipCode = '76113' or zipCode = '76114' or zipCode = '76115' or zipCode = '76116' or zipCode = '76117' or zipCode = '76118' or zipCode = '76119' or zipCode = '76120' or zipCode = '76121' or zipCode = '76122' or zipCode = '76123' or zipCode = '76124' or zipCode = '76126' or zipCode = '76127' or zipCode = '76129' or zipCode = '76130' or zipCode = '76131' or zipCode = '76132' or zipCode = '76133' or zipCode = '76134' or zipCode = '76135' or zipCode = '76136' or zipCode = '76137' or zipCode = '76140' or zipCode = '76147' or zipCode = '76148' or zipCode = '76150' or zipCode = '76153' or zipCode = '76155' or zipCode = '76161' or zipCode = '76162' or zipCode = '76163' or zipCode = '76164' or zipCode = '76177' or zipCode = '76178' or zipCode = '76179' or zipCode = '76180' or zipCode = '76181' or zipCode = '76182' or zipCode = '76185' or zipCode = '76191' or zipCode = '76192' or zipCode = '76193' or zipCode = '76195' or zipCode = '76196' or zipCode = '76197' or zipCode = '76198' or zipCode = '76199' or zipCode = '76226' or zipCode = '76244' or zipCode = '76247' or zipCode = '76248' or zipCode = '76262') 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 ='75014' or zipCode = '75015' or zipCode = '75016' or zipCode = '75017' or zipCode = '75019' or zipCode = '75022' or zipCode = '75022' or zipCode = '75022' or zipCode = '75027' or zipCode = '75027' or zipCode = '75027' or zipCode = '75028' or zipCode = '75028' or zipCode = '75028' or zipCode = '75037' or zipCode = '75037' or zipCode = '75038' or zipCode = '75039' or zipCode = '75050' or zipCode = '75051' or zipCode = '75052' or zipCode = '75053' or zipCode = '75054' or zipCode = '75060' or zipCode = '75061' or zipCode = '75062' or zipCode = '75063' or zipCode = '75067' or zipCode = '75067' or zipCode = '75099' or zipCode = '75099' or zipCode = '75099' or zipCode = '75104' or zipCode = '75106' or zipCode = '75211' or zipCode = '75211' or zipCode = '75212' or zipCode = '75247' or zipCode = '75249' or zipCode = '75261' or zipCode = '75261' or zipCode = '75261' or zipCode = '75077' or zipCode = '75077' or zipCode = '75077' or zipCode = '75077' or zipCode = '75077' or zipCode = '75116' or zipCode = '75137' or zipCode = '75138' or zipCode = '75233' or zipCode = '75236' or zipCode = '75340' or zipCode = '75343' 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 = '76020' or zipCode = '76020' or zipCode = '76021' or zipCode = '76022' or zipCode = '76028' or zipCode = '76034' or zipCode = '76036' or zipCode = '76039' or zipCode = '76040' or zipCode = '76085' or zipCode = '76092' or zipCode = '76092' or zipCode = '76094' or zipCode = '76095' or zipCode = '76096' or zipCode = '76097' or zipCode = '76098' or zipCode = '76099' or zipCode = '76101' or zipCode = '76102' or zipCode = '76103' or zipCode = '76104' or zipCode = '76105' or zipCode = '76106' or zipCode = '76107' or zipCode = '76107' or zipCode = '76108' or zipCode = '76108' or zipCode = '76108' or zipCode = '76108' or zipCode = '76109' or zipCode = '76109' or zipCode = '76110' or zipCode = '76111' or zipCode = '76111' or zipCode = '76112' or zipCode = '76113' or zipCode = '76114' or zipCode = '76114' or zipCode = '76114' or zipCode = '76114' or zipCode = '76114' or zipCode = '76114' or zipCode = '76127' or zipCode = '76129' or zipCode = '76129' or zipCode = '76130' or zipCode = '76130' or zipCode = '76131' or zipCode = '76131' or zipCode = '76131' or zipCode = '76132' or zipCode = '76132' or zipCode = '76133' or zipCode = '76134' or zipCode = '76135' or zipCode = '76135' or zipCode = '76135' or zipCode = '76136' or zipCode = '76136' or zipCode = '76137' or zipCode = '76137' or zipCode = '76137' or zipCode = '76140' or zipCode = '76140' or zipCode = '76140' or zipCode = '76001' or zipCode = '76002' or zipCode = '76003' or zipCode = '76004' or zipCode = '76005' or zipCode = '76006' or zipCode = '76007' or zipCode = '76008' or zipCode = '76008' or zipCode = '76009' 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 = '76052' or zipCode = '76053' or zipCode = '76054' or zipCode = '76058' or zipCode = '76060' or zipCode = '76061' or zipCode = '76063' or zipCode = '76071' or zipCode = '76115' or zipCode = '76115' or zipCode = '76116' or zipCode = '76116' or zipCode = '76117' or zipCode = '76117' or zipCode = '76118' or zipCode = '76118' or zipCode = '76118' or zipCode = '76118' or zipCode = '76118' or zipCode = '76119' or zipCode = '76119' or zipCode = '76120' or zipCode = '76121' or zipCode = '76122' or zipCode = '76122' or zipCode = '76123' or zipCode = '76124' or zipCode = '76126' or zipCode = '76126' or zipCode = '76127' or zipCode = '76127' or zipCode = '76147' or zipCode = '76148' or zipCode = '76148' or zipCode = '76148' or zipCode = '76148' or zipCode = '76150' or zipCode = '76155' or zipCode = '76161' or zipCode = '76162' or zipCode = '76163' or zipCode = '76164' or zipCode = '76166' or zipCode = '76166' or zipCode = '76177' or zipCode = '76177' or zipCode = '76179' or zipCode = '76179' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76181' or zipCode = '76182' or zipCode = '76182' or zipCode = '76182' or zipCode = '76185' or zipCode = '76191' or zipCode = '76191' or zipCode = '76192' or zipCode = '76192' or zipCode = '76193' or zipCode = '76193' or zipCode = '76195' or zipCode = '76195' or zipCode = '76196' or zipCode = '76196' or zipCode = '76197' or zipCode = '76197' or zipCode = '76198' or zipCode = '76198' or zipCode = '76199' or zipCode = '76244' or zipCode = '76247' or zipCode = '76248' or zipCode = '76262' or zipCode = '76262' or zipCode = '76262' or zipCode = '76226' or zipCode = '76226' or zipCode = '76226' or zipCode = '76226' or zipCode = '75019' or zipCode = '75022' or zipCode = '75028' or zipCode = '75038' or zipCode = '75039' or zipCode = '75050' or zipCode = '75051' or zipCode = '75052' or zipCode = '75059' or zipCode = '75060' or zipCode = '75061' or zipCode = '75062' or zipCode = '75063' or zipCode = '75067' or zipCode = '75104' or zipCode = '75116' or zipCode = '75137' or zipCode = '75211' or zipCode = '75212' or zipCode = '75233' or zipCode = '75236' or zipCode = '75247' or zipCode = '75249' or zipCode = '76001' or zipCode = '76002' or zipCode = '76003' or zipCode = '76004' or zipCode = '76005' or zipCode = '76006' or zipCode = '76007' or zipCode = '76008' 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 = '76019' or zipCode = '76020' or zipCode = '76021' or zipCode = '76022' or zipCode = '76028' or zipCode = '76034' or zipCode = '76036' or zipCode = '76039' or zipCode = '76040' or zipCode = '76051' or zipCode = '76052' or zipCode = '76053' or zipCode = '76054' or zipCode = '76058' or zipCode = '76060' or zipCode = '76061' or zipCode = '76063' or zipCode = '76071' or zipCode = '76078' or zipCode = '76085' or zipCode = '76092' or zipCode = '76094' or zipCode = '76095' or zipCode = '76096' or zipCode = '76097' or zipCode = '76098' or zipCode = '76099' or zipCode = '76101' or zipCode = '76102' or zipCode = '76103' or zipCode = '76104' or zipCode = '76105' or zipCode = '76106' or zipCode = '76107' or zipCode = '76108' or zipCode = '76109' or zipCode = '76110' or zipCode = '76111' or zipCode = '76112' or zipCode = '76113' or zipCode = '76114' or zipCode = '76115' or zipCode = '76116' or zipCode = '76117' or zipCode = '76118' or zipCode = '76119' or zipCode = '76120' or zipCode = '76121' or zipCode = '76122' or zipCode = '76123' or zipCode = '76124' or zipCode = '76126' or zipCode = '76127' or zipCode = '76129' or zipCode = '76130' or zipCode = '76131' or zipCode = '76132' or zipCode = '76133' or zipCode = '76134' or zipCode = '76135' or zipCode = '76136' or zipCode = '76137' or zipCode = '76140' or zipCode = '76147' or zipCode = '76148' or zipCode = '76150' or zipCode = '76153' or zipCode = '76155' or zipCode = '76161' or zipCode = '76162' or zipCode = '76163' or zipCode = '76164' or zipCode = '76177' or zipCode = '76178' or zipCode = '76179' or zipCode = '76180' or zipCode = '76181' or zipCode = '76182' or zipCode = '76185' or zipCode = '76191' or zipCode = '76192' or zipCode = '76193' or zipCode = '76195' or zipCode = '76196' or zipCode = '76197' or zipCode = '76198' or zipCode = '76199' or zipCode = '76226' or zipCode = '76244' or zipCode = '76247' or zipCode = '76248' or zipCode = '76262') 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 ='75014' or zipCode = '75015' or zipCode = '75016' or zipCode = '75017' or zipCode = '75019' or zipCode = '75022' or zipCode = '75022' or zipCode = '75022' or zipCode = '75027' or zipCode = '75027' or zipCode = '75027' or zipCode = '75028' or zipCode = '75028' or zipCode = '75028' or zipCode = '75037' or zipCode = '75037' or zipCode = '75038' or zipCode = '75039' or zipCode = '75050' or zipCode = '75051' or zipCode = '75052' or zipCode = '75053' or zipCode = '75054' or zipCode = '75060' or zipCode = '75061' or zipCode = '75062' or zipCode = '75063' or zipCode = '75067' or zipCode = '75067' or zipCode = '75099' or zipCode = '75099' or zipCode = '75099' or zipCode = '75104' or zipCode = '75106' or zipCode = '75211' or zipCode = '75211' or zipCode = '75212' or zipCode = '75247' or zipCode = '75249' or zipCode = '75261' or zipCode = '75261' or zipCode = '75261' or zipCode = '75077' or zipCode = '75077' or zipCode = '75077' or zipCode = '75077' or zipCode = '75077' or zipCode = '75116' or zipCode = '75137' or zipCode = '75138' or zipCode = '75233' or zipCode = '75236' or zipCode = '75340' or zipCode = '75343' 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 = '76020' or zipCode = '76020' or zipCode = '76021' or zipCode = '76022' or zipCode = '76028' or zipCode = '76034' or zipCode = '76036' or zipCode = '76039' or zipCode = '76040' or zipCode = '76085' or zipCode = '76092' or zipCode = '76092' or zipCode = '76094' or zipCode = '76095' or zipCode = '76096' or zipCode = '76097' or zipCode = '76098' or zipCode = '76099' or zipCode = '76101' or zipCode = '76102' or zipCode = '76103' or zipCode = '76104' or zipCode = '76105' or zipCode = '76106' or zipCode = '76107' or zipCode = '76107' or zipCode = '76108' or zipCode = '76108' or zipCode = '76108' or zipCode = '76108' or zipCode = '76109' or zipCode = '76109' or zipCode = '76110' or zipCode = '76111' or zipCode = '76111' or zipCode = '76112' or zipCode = '76113' or zipCode = '76114' or zipCode = '76114' or zipCode = '76114' or zipCode = '76114' or zipCode = '76114' or zipCode = '76114' or zipCode = '76127' or zipCode = '76129' or zipCode = '76129' or zipCode = '76130' or zipCode = '76130' or zipCode = '76131' or zipCode = '76131' or zipCode = '76131' or zipCode = '76132' or zipCode = '76132' or zipCode = '76133' or zipCode = '76134' or zipCode = '76135' or zipCode = '76135' or zipCode = '76135' or zipCode = '76136' or zipCode = '76136' or zipCode = '76137' or zipCode = '76137' or zipCode = '76137' or zipCode = '76140' or zipCode = '76140' or zipCode = '76140' or zipCode = '76001' or zipCode = '76002' or zipCode = '76003' or zipCode = '76004' or zipCode = '76005' or zipCode = '76006' or zipCode = '76007' or zipCode = '76008' or zipCode = '76008' or zipCode = '76009' 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 = '76052' or zipCode = '76053' or zipCode = '76054' or zipCode = '76058' or zipCode = '76060' or zipCode = '76061' or zipCode = '76063' or zipCode = '76071' or zipCode = '76115' or zipCode = '76115' or zipCode = '76116' or zipCode = '76116' or zipCode = '76117' or zipCode = '76117' or zipCode = '76118' or zipCode = '76118' or zipCode = '76118' or zipCode = '76118' or zipCode = '76118' or zipCode = '76119' or zipCode = '76119' or zipCode = '76120' or zipCode = '76121' or zipCode = '76122' or zipCode = '76122' or zipCode = '76123' or zipCode = '76124' or zipCode = '76126' or zipCode = '76126' or zipCode = '76127' or zipCode = '76127' or zipCode = '76147' or zipCode = '76148' or zipCode = '76148' or zipCode = '76148' or zipCode = '76148' or zipCode = '76150' or zipCode = '76155' or zipCode = '76161' or zipCode = '76162' or zipCode = '76163' or zipCode = '76164' or zipCode = '76166' or zipCode = '76166' or zipCode = '76177' or zipCode = '76177' or zipCode = '76179' or zipCode = '76179' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76181' or zipCode = '76182' or zipCode = '76182' or zipCode = '76182' or zipCode = '76185' or zipCode = '76191' or zipCode = '76191' or zipCode = '76192' or zipCode = '76192' or zipCode = '76193' or zipCode = '76193' or zipCode = '76195' or zipCode = '76195' or zipCode = '76196' or zipCode = '76196' or zipCode = '76197' or zipCode = '76197' or zipCode = '76198' or zipCode = '76198' or zipCode = '76199' or zipCode = '76244' or zipCode = '76247' or zipCode = '76248' or zipCode = '76262' or zipCode = '76262' or zipCode = '76262' or zipCode = '76226' or zipCode = '76226' or zipCode = '76226' or zipCode = '76226' or zipCode = '75019' or zipCode = '75022' or zipCode = '75028' or zipCode = '75038' or zipCode = '75039' or zipCode = '75050' or zipCode = '75051' or zipCode = '75052' or zipCode = '75059' or zipCode = '75060' or zipCode = '75061' or zipCode = '75062' or zipCode = '75063' or zipCode = '75067' or zipCode = '75104' or zipCode = '75116' or zipCode = '75137' or zipCode = '75211' or zipCode = '75212' or zipCode = '75233' or zipCode = '75236' or zipCode = '75247' or zipCode = '75249' or zipCode = '76001' or zipCode = '76002' or zipCode = '76003' or zipCode = '76004' or zipCode = '76005' or zipCode = '76006' or zipCode = '76007' or zipCode = '76008' 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 = '76019' or zipCode = '76020' or zipCode = '76021' or zipCode = '76022' or zipCode = '76028' or zipCode = '76034' or zipCode = '76036' or zipCode = '76039' or zipCode = '76040' or zipCode = '76051' or zipCode = '76052' or zipCode = '76053' or zipCode = '76054' or zipCode = '76058' or zipCode = '76060' or zipCode = '76061' or zipCode = '76063' or zipCode = '76071' or zipCode = '76078' or zipCode = '76085' or zipCode = '76092' or zipCode = '76094' or zipCode = '76095' or zipCode = '76096' or zipCode = '76097' or zipCode = '76098' or zipCode = '76099' or zipCode = '76101' or zipCode = '76102' or zipCode = '76103' or zipCode = '76104' or zipCode = '76105' or zipCode = '76106' or zipCode = '76107' or zipCode = '76108' or zipCode = '76109' or zipCode = '76110' or zipCode = '76111' or zipCode = '76112' or zipCode = '76113' or zipCode = '76114' or zipCode = '76115' or zipCode = '76116' or zipCode = '76117' or zipCode = '76118' or zipCode = '76119' or zipCode = '76120' or zipCode = '76121' or zipCode = '76122' or zipCode = '76123' or zipCode = '76124' or zipCode = '76126' or zipCode = '76127' or zipCode = '76129' or zipCode = '76130' or zipCode = '76131' or zipCode = '76132' or zipCode = '76133' or zipCode = '76134' or zipCode = '76135' or zipCode = '76136' or zipCode = '76137' or zipCode = '76140' or zipCode = '76147' or zipCode = '76148' or zipCode = '76150' or zipCode = '76153' or zipCode = '76155' or zipCode = '76161' or zipCode = '76162' or zipCode = '76163' or zipCode = '76164' or zipCode = '76177' or zipCode = '76178' or zipCode = '76179' or zipCode = '76180' or zipCode = '76181' or zipCode = '76182' or zipCode = '76185' or zipCode = '76191' or zipCode = '76192' or zipCode = '76193' or zipCode = '76195' or zipCode = '76196' or zipCode = '76197' or zipCode = '76198' or zipCode = '76199' or zipCode = '76226' or zipCode = '76244' or zipCode = '76247' or zipCode = '76248' or zipCode = '76262') 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 ='75014' or zipCode = '75015' or zipCode = '75016' or zipCode = '75017' or zipCode = '75019' or zipCode = '75022' or zipCode = '75022' or zipCode = '75022' or zipCode = '75027' or zipCode = '75027' or zipCode = '75027' or zipCode = '75028' or zipCode = '75028' or zipCode = '75028' or zipCode = '75037' or zipCode = '75037' or zipCode = '75038' or zipCode = '75039' or zipCode = '75050' or zipCode = '75051' or zipCode = '75052' or zipCode = '75053' or zipCode = '75054' or zipCode = '75060' or zipCode = '75061' or zipCode = '75062' or zipCode = '75063' or zipCode = '75067' or zipCode = '75067' or zipCode = '75099' or zipCode = '75099' or zipCode = '75099' or zipCode = '75104' or zipCode = '75106' or zipCode = '75211' or zipCode = '75211' or zipCode = '75212' or zipCode = '75247' or zipCode = '75249' or zipCode = '75261' or zipCode = '75261' or zipCode = '75261' or zipCode = '75077' or zipCode = '75077' or zipCode = '75077' or zipCode = '75077' or zipCode = '75077' or zipCode = '75116' or zipCode = '75137' or zipCode = '75138' or zipCode = '75233' or zipCode = '75236' or zipCode = '75340' or zipCode = '75343' 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 = '76020' or zipCode = '76020' or zipCode = '76021' or zipCode = '76022' or zipCode = '76028' or zipCode = '76034' or zipCode = '76036' or zipCode = '76039' or zipCode = '76040' or zipCode = '76085' or zipCode = '76092' or zipCode = '76092' or zipCode = '76094' or zipCode = '76095' or zipCode = '76096' or zipCode = '76097' or zipCode = '76098' or zipCode = '76099' or zipCode = '76101' or zipCode = '76102' or zipCode = '76103' or zipCode = '76104' or zipCode = '76105' or zipCode = '76106' or zipCode = '76107' or zipCode = '76107' or zipCode = '76108' or zipCode = '76108' or zipCode = '76108' or zipCode = '76108' or zipCode = '76109' or zipCode = '76109' or zipCode = '76110' or zipCode = '76111' or zipCode = '76111' or zipCode = '76112' or zipCode = '76113' or zipCode = '76114' or zipCode = '76114' or zipCode = '76114' or zipCode = '76114' or zipCode = '76114' or zipCode = '76114' or zipCode = '76127' or zipCode = '76129' or zipCode = '76129' or zipCode = '76130' or zipCode = '76130' or zipCode = '76131' or zipCode = '76131' or zipCode = '76131' or zipCode = '76132' or zipCode = '76132' or zipCode = '76133' or zipCode = '76134' or zipCode = '76135' or zipCode = '76135' or zipCode = '76135' or zipCode = '76136' or zipCode = '76136' or zipCode = '76137' or zipCode = '76137' or zipCode = '76137' or zipCode = '76140' or zipCode = '76140' or zipCode = '76140' or zipCode = '76001' or zipCode = '76002' or zipCode = '76003' or zipCode = '76004' or zipCode = '76005' or zipCode = '76006' or zipCode = '76007' or zipCode = '76008' or zipCode = '76008' or zipCode = '76009' 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 = '76052' or zipCode = '76053' or zipCode = '76054' or zipCode = '76058' or zipCode = '76060' or zipCode = '76061' or zipCode = '76063' or zipCode = '76071' or zipCode = '76115' or zipCode = '76115' or zipCode = '76116' or zipCode = '76116' or zipCode = '76117' or zipCode = '76117' or zipCode = '76118' or zipCode = '76118' or zipCode = '76118' or zipCode = '76118' or zipCode = '76118' or zipCode = '76119' or zipCode = '76119' or zipCode = '76120' or zipCode = '76121' or zipCode = '76122' or zipCode = '76122' or zipCode = '76123' or zipCode = '76124' or zipCode = '76126' or zipCode = '76126' or zipCode = '76127' or zipCode = '76127' or zipCode = '76147' or zipCode = '76148' or zipCode = '76148' or zipCode = '76148' or zipCode = '76148' or zipCode = '76150' or zipCode = '76155' or zipCode = '76161' or zipCode = '76162' or zipCode = '76163' or zipCode = '76164' or zipCode = '76166' or zipCode = '76166' or zipCode = '76177' or zipCode = '76177' or zipCode = '76179' or zipCode = '76179' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76181' or zipCode = '76182' or zipCode = '76182' or zipCode = '76182' or zipCode = '76185' or zipCode = '76191' or zipCode = '76191' or zipCode = '76192' or zipCode = '76192' or zipCode = '76193' or zipCode = '76193' or zipCode = '76195' or zipCode = '76195' or zipCode = '76196' or zipCode = '76196' or zipCode = '76197' or zipCode = '76197' or zipCode = '76198' or zipCode = '76198' or zipCode = '76199' or zipCode = '76244' or zipCode = '76247' or zipCode = '76248' or zipCode = '76262' or zipCode = '76262' or zipCode = '76262' or zipCode = '76226' or zipCode = '76226' or zipCode = '76226' or zipCode = '76226' or zipCode = '75019' or zipCode = '75022' or zipCode = '75028' or zipCode = '75038' or zipCode = '75039' or zipCode = '75050' or zipCode = '75051' or zipCode = '75052' or zipCode = '75059' or zipCode = '75060' or zipCode = '75061' or zipCode = '75062' or zipCode = '75063' or zipCode = '75067' or zipCode = '75104' or zipCode = '75116' or zipCode = '75137' or zipCode = '75211' or zipCode = '75212' or zipCode = '75233' or zipCode = '75236' or zipCode = '75247' or zipCode = '75249' or zipCode = '76001' or zipCode = '76002' or zipCode = '76003' or zipCode = '76004' or zipCode = '76005' or zipCode = '76006' or zipCode = '76007' or zipCode = '76008' 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 = '76019' or zipCode = '76020' or zipCode = '76021' or zipCode = '76022' or zipCode = '76028' or zipCode = '76034' or zipCode = '76036' or zipCode = '76039' or zipCode = '76040' or zipCode = '76051' or zipCode = '76052' or zipCode = '76053' or zipCode = '76054' or zipCode = '76058' or zipCode = '76060' or zipCode = '76061' or zipCode = '76063' or zipCode = '76071' or zipCode = '76078' or zipCode = '76085' or zipCode = '76092' or zipCode = '76094' or zipCode = '76095' or zipCode = '76096' or zipCode = '76097' or zipCode = '76098' or zipCode = '76099' or zipCode = '76101' or zipCode = '76102' or zipCode = '76103' or zipCode = '76104' or zipCode = '76105' or zipCode = '76106' or zipCode = '76107' or zipCode = '76108' or zipCode = '76109' or zipCode = '76110' or zipCode = '76111' or zipCode = '76112' or zipCode = '76113' or zipCode = '76114' or zipCode = '76115' or zipCode = '76116' or zipCode = '76117' or zipCode = '76118' or zipCode = '76119' or zipCode = '76120' or zipCode = '76121' or zipCode = '76122' or zipCode = '76123' or zipCode = '76124' or zipCode = '76126' or zipCode = '76127' or zipCode = '76129' or zipCode = '76130' or zipCode = '76131' or zipCode = '76132' or zipCode = '76133' or zipCode = '76134' or zipCode = '76135' or zipCode = '76136' or zipCode = '76137' or zipCode = '76140' or zipCode = '76147' or zipCode = '76148' or zipCode = '76150' or zipCode = '76153' or zipCode = '76155' or zipCode = '76161' or zipCode = '76162' or zipCode = '76163' or zipCode = '76164' or zipCode = '76177' or zipCode = '76178' or zipCode = '76179' or zipCode = '76180' or zipCode = '76181' or zipCode = '76182' or zipCode = '76185' or zipCode = '76191' or zipCode = '76192' or zipCode = '76193' or zipCode = '76195' or zipCode = '76196' or zipCode = '76197' or zipCode = '76198' or zipCode = '76199' or zipCode = '76226' or zipCode = '76244' or zipCode = '76247' or zipCode = '76248' or zipCode = '76262') 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 ='75014' or zipCode = '75015' or zipCode = '75016' or zipCode = '75017' or zipCode = '75019' or zipCode = '75022' or zipCode = '75022' or zipCode = '75022' or zipCode = '75027' or zipCode = '75027' or zipCode = '75027' or zipCode = '75028' or zipCode = '75028' or zipCode = '75028' or zipCode = '75037' or zipCode = '75037' or zipCode = '75038' or zipCode = '75039' or zipCode = '75050' or zipCode = '75051' or zipCode = '75052' or zipCode = '75053' or zipCode = '75054' or zipCode = '75060' or zipCode = '75061' or zipCode = '75062' or zipCode = '75063' or zipCode = '75067' or zipCode = '75067' or zipCode = '75099' or zipCode = '75099' or zipCode = '75099' or zipCode = '75104' or zipCode = '75106' or zipCode = '75211' or zipCode = '75211' or zipCode = '75212' or zipCode = '75247' or zipCode = '75249' or zipCode = '75261' or zipCode = '75261' or zipCode = '75261' or zipCode = '75077' or zipCode = '75077' or zipCode = '75077' or zipCode = '75077' or zipCode = '75077' or zipCode = '75116' or zipCode = '75137' or zipCode = '75138' or zipCode = '75233' or zipCode = '75236' or zipCode = '75340' or zipCode = '75343' 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 = '76020' or zipCode = '76020' or zipCode = '76021' or zipCode = '76022' or zipCode = '76028' or zipCode = '76034' or zipCode = '76036' or zipCode = '76039' or zipCode = '76040' or zipCode = '76085' or zipCode = '76092' or zipCode = '76092' or zipCode = '76094' or zipCode = '76095' or zipCode = '76096' or zipCode = '76097' or zipCode = '76098' or zipCode = '76099' or zipCode = '76101' or zipCode = '76102' or zipCode = '76103' or zipCode = '76104' or zipCode = '76105' or zipCode = '76106' or zipCode = '76107' or zipCode = '76107' or zipCode = '76108' or zipCode = '76108' or zipCode = '76108' or zipCode = '76108' or zipCode = '76109' or zipCode = '76109' or zipCode = '76110' or zipCode = '76111' or zipCode = '76111' or zipCode = '76112' or zipCode = '76113' or zipCode = '76114' or zipCode = '76114' or zipCode = '76114' or zipCode = '76114' or zipCode = '76114' or zipCode = '76114' or zipCode = '76127' or zipCode = '76129' or zipCode = '76129' or zipCode = '76130' or zipCode = '76130' or zipCode = '76131' or zipCode = '76131' or zipCode = '76131' or zipCode = '76132' or zipCode = '76132' or zipCode = '76133' or zipCode = '76134' or zipCode = '76135' or zipCode = '76135' or zipCode = '76135' or zipCode = '76136' or zipCode = '76136' or zipCode = '76137' or zipCode = '76137' or zipCode = '76137' or zipCode = '76140' or zipCode = '76140' or zipCode = '76140' or zipCode = '76001' or zipCode = '76002' or zipCode = '76003' or zipCode = '76004' or zipCode = '76005' or zipCode = '76006' or zipCode = '76007' or zipCode = '76008' or zipCode = '76008' or zipCode = '76009' 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 = '76052' or zipCode = '76053' or zipCode = '76054' or zipCode = '76058' or zipCode = '76060' or zipCode = '76061' or zipCode = '76063' or zipCode = '76071' or zipCode = '76115' or zipCode = '76115' or zipCode = '76116' or zipCode = '76116' or zipCode = '76117' or zipCode = '76117' or zipCode = '76118' or zipCode = '76118' or zipCode = '76118' or zipCode = '76118' or zipCode = '76118' or zipCode = '76119' or zipCode = '76119' or zipCode = '76120' or zipCode = '76121' or zipCode = '76122' or zipCode = '76122' or zipCode = '76123' or zipCode = '76124' or zipCode = '76126' or zipCode = '76126' or zipCode = '76127' or zipCode = '76127' or zipCode = '76147' or zipCode = '76148' or zipCode = '76148' or zipCode = '76148' or zipCode = '76148' or zipCode = '76150' or zipCode = '76155' or zipCode = '76161' or zipCode = '76162' or zipCode = '76163' or zipCode = '76164' or zipCode = '76166' or zipCode = '76166' or zipCode = '76177' or zipCode = '76177' or zipCode = '76179' or zipCode = '76179' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76181' or zipCode = '76182' or zipCode = '76182' or zipCode = '76182' or zipCode = '76185' or zipCode = '76191' or zipCode = '76191' or zipCode = '76192' or zipCode = '76192' or zipCode = '76193' or zipCode = '76193' or zipCode = '76195' or zipCode = '76195' or zipCode = '76196' or zipCode = '76196' or zipCode = '76197' or zipCode = '76197' or zipCode = '76198' or zipCode = '76198' or zipCode = '76199' or zipCode = '76244' or zipCode = '76247' or zipCode = '76248' or zipCode = '76262' or zipCode = '76262' or zipCode = '76262' or zipCode = '76226' or zipCode = '76226' or zipCode = '76226' or zipCode = '76226' or zipCode = '75019' or zipCode = '75022' or zipCode = '75028' or zipCode = '75038' or zipCode = '75039' or zipCode = '75050' or zipCode = '75051' or zipCode = '75052' or zipCode = '75059' or zipCode = '75060' or zipCode = '75061' or zipCode = '75062' or zipCode = '75063' or zipCode = '75067' or zipCode = '75104' or zipCode = '75116' or zipCode = '75137' or zipCode = '75211' or zipCode = '75212' or zipCode = '75233' or zipCode = '75236' or zipCode = '75247' or zipCode = '75249' or zipCode = '76001' or zipCode = '76002' or zipCode = '76003' or zipCode = '76004' or zipCode = '76005' or zipCode = '76006' or zipCode = '76007' or zipCode = '76008' 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 = '76019' or zipCode = '76020' or zipCode = '76021' or zipCode = '76022' or zipCode = '76028' or zipCode = '76034' or zipCode = '76036' or zipCode = '76039' or zipCode = '76040' or zipCode = '76051' or zipCode = '76052' or zipCode = '76053' or zipCode = '76054' or zipCode = '76058' or zipCode = '76060' or zipCode = '76061' or zipCode = '76063' or zipCode = '76071' or zipCode = '76078' or zipCode = '76085' or zipCode = '76092' or zipCode = '76094' or zipCode = '76095' or zipCode = '76096' or zipCode = '76097' or zipCode = '76098' or zipCode = '76099' or zipCode = '76101' or zipCode = '76102' or zipCode = '76103' or zipCode = '76104' or zipCode = '76105' or zipCode = '76106' or zipCode = '76107' or zipCode = '76108' or zipCode = '76109' or zipCode = '76110' or zipCode = '76111' or zipCode = '76112' or zipCode = '76113' or zipCode = '76114' or zipCode = '76115' or zipCode = '76116' or zipCode = '76117' or zipCode = '76118' or zipCode = '76119' or zipCode = '76120' or zipCode = '76121' or zipCode = '76122' or zipCode = '76123' or zipCode = '76124' or zipCode = '76126' or zipCode = '76127' or zipCode = '76129' or zipCode = '76130' or zipCode = '76131' or zipCode = '76132' or zipCode = '76133' or zipCode = '76134' or zipCode = '76135' or zipCode = '76136' or zipCode = '76137' or zipCode = '76140' or zipCode = '76147' or zipCode = '76148' or zipCode = '76150' or zipCode = '76153' or zipCode = '76155' or zipCode = '76161' or zipCode = '76162' or zipCode = '76163' or zipCode = '76164' or zipCode = '76177' or zipCode = '76178' or zipCode = '76179' or zipCode = '76180' or zipCode = '76181' or zipCode = '76182' or zipCode = '76185' or zipCode = '76191' or zipCode = '76192' or zipCode = '76193' or zipCode = '76195' or zipCode = '76196' or zipCode = '76197' or zipCode = '76198' or zipCode = '76199' or zipCode = '76226' or zipCode = '76244' or zipCode = '76247' or zipCode = '76248' or zipCode = '76262') 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 ='75014' or zipCode = '75015' or zipCode = '75016' or zipCode = '75017' or zipCode = '75019' or zipCode = '75022' or zipCode = '75022' or zipCode = '75022' or zipCode = '75027' or zipCode = '75027' or zipCode = '75027' or zipCode = '75028' or zipCode = '75028' or zipCode = '75028' or zipCode = '75037' or zipCode = '75037' or zipCode = '75038' or zipCode = '75039' or zipCode = '75050' or zipCode = '75051' or zipCode = '75052' or zipCode = '75053' or zipCode = '75054' or zipCode = '75060' or zipCode = '75061' or zipCode = '75062' or zipCode = '75063' or zipCode = '75067' or zipCode = '75067' or zipCode = '75099' or zipCode = '75099' or zipCode = '75099' or zipCode = '75104' or zipCode = '75106' or zipCode = '75211' or zipCode = '75211' or zipCode = '75212' or zipCode = '75247' or zipCode = '75249' or zipCode = '75261' or zipCode = '75261' or zipCode = '75261' or zipCode = '75077' or zipCode = '75077' or zipCode = '75077' or zipCode = '75077' or zipCode = '75077' or zipCode = '75116' or zipCode = '75137' or zipCode = '75138' or zipCode = '75233' or zipCode = '75236' or zipCode = '75340' or zipCode = '75343' 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 = '76020' or zipCode = '76020' or zipCode = '76021' or zipCode = '76022' or zipCode = '76028' or zipCode = '76034' or zipCode = '76036' or zipCode = '76039' or zipCode = '76040' or zipCode = '76085' or zipCode = '76092' or zipCode = '76092' or zipCode = '76094' or zipCode = '76095' or zipCode = '76096' or zipCode = '76097' or zipCode = '76098' or zipCode = '76099' or zipCode = '76101' or zipCode = '76102' or zipCode = '76103' or zipCode = '76104' or zipCode = '76105' or zipCode = '76106' or zipCode = '76107' or zipCode = '76107' or zipCode = '76108' or zipCode = '76108' or zipCode = '76108' or zipCode = '76108' or zipCode = '76109' or zipCode = '76109' or zipCode = '76110' or zipCode = '76111' or zipCode = '76111' or zipCode = '76112' or zipCode = '76113' or zipCode = '76114' or zipCode = '76114' or zipCode = '76114' or zipCode = '76114' or zipCode = '76114' or zipCode = '76114' or zipCode = '76127' or zipCode = '76129' or zipCode = '76129' or zipCode = '76130' or zipCode = '76130' or zipCode = '76131' or zipCode = '76131' or zipCode = '76131' or zipCode = '76132' or zipCode = '76132' or zipCode = '76133' or zipCode = '76134' or zipCode = '76135' or zipCode = '76135' or zipCode = '76135' or zipCode = '76136' or zipCode = '76136' or zipCode = '76137' or zipCode = '76137' or zipCode = '76137' or zipCode = '76140' or zipCode = '76140' or zipCode = '76140' or zipCode = '76001' or zipCode = '76002' or zipCode = '76003' or zipCode = '76004' or zipCode = '76005' or zipCode = '76006' or zipCode = '76007' or zipCode = '76008' or zipCode = '76008' or zipCode = '76009' 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 = '76052' or zipCode = '76053' or zipCode = '76054' or zipCode = '76058' or zipCode = '76060' or zipCode = '76061' or zipCode = '76063' or zipCode = '76071' or zipCode = '76115' or zipCode = '76115' or zipCode = '76116' or zipCode = '76116' or zipCode = '76117' or zipCode = '76117' or zipCode = '76118' or zipCode = '76118' or zipCode = '76118' or zipCode = '76118' or zipCode = '76118' or zipCode = '76119' or zipCode = '76119' or zipCode = '76120' or zipCode = '76121' or zipCode = '76122' or zipCode = '76122' or zipCode = '76123' or zipCode = '76124' or zipCode = '76126' or zipCode = '76126' or zipCode = '76127' or zipCode = '76127' or zipCode = '76147' or zipCode = '76148' or zipCode = '76148' or zipCode = '76148' or zipCode = '76148' or zipCode = '76150' or zipCode = '76155' or zipCode = '76161' or zipCode = '76162' or zipCode = '76163' or zipCode = '76164' or zipCode = '76166' or zipCode = '76166' or zipCode = '76177' or zipCode = '76177' or zipCode = '76179' or zipCode = '76179' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76180' or zipCode = '76181' or zipCode = '76182' or zipCode = '76182' or zipCode = '76182' or zipCode = '76185' or zipCode = '76191' or zipCode = '76191' or zipCode = '76192' or zipCode = '76192' or zipCode = '76193' or zipCode = '76193' or zipCode = '76195' or zipCode = '76195' or zipCode = '76196' or zipCode = '76196' or zipCode = '76197' or zipCode = '76197' or zipCode = '76198' or zipCode = '76198' or zipCode = '76199' or zipCode = '76244' or zipCode = '76247' or zipCode = '76248' or zipCode = '76262' or zipCode = '76262' or zipCode = '76262' or zipCode = '76226' or zipCode = '76226' or zipCode = '76226' or zipCode = '76226' or zipCode = '75019' or zipCode = '75022' or zipCode = '75028' or zipCode = '75038' or zipCode = '75039' or zipCode = '75050' or zipCode = '75051' or zipCode = '75052' or zipCode = '75059' or zipCode = '75060' or zipCode = '75061' or zipCode = '75062' or zipCode = '75063' or zipCode = '75067' or zipCode = '75104' or zipCode = '75116' or zipCode = '75137' or zipCode = '75211' or zipCode = '75212' or zipCode = '75233' or zipCode = '75236' or zipCode = '75247' or zipCode = '75249' or zipCode = '76001' or zipCode = '76002' or zipCode = '76003' or zipCode = '76004' or zipCode = '76005' or zipCode = '76006' or zipCode = '76007' or zipCode = '76008' 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 = '76019' or zipCode = '76020' or zipCode = '76021' or zipCode = '76022' or zipCode = '76028' or zipCode = '76034' or zipCode = '76036' or zipCode = '76039' or zipCode = '76040' or zipCode = '76051' or zipCode = '76052' or zipCode = '76053' or zipCode = '76054' or zipCode = '76058' or zipCode = '76060' or zipCode = '76061' or zipCode = '76063' or zipCode = '76071' or zipCode = '76078' or zipCode = '76085' or zipCode = '76092' or zipCode = '76094' or zipCode = '76095' or zipCode = '76096' or zipCode = '76097' or zipCode = '76098' or zipCode = '76099' or zipCode = '76101' or zipCode = '76102' or zipCode = '76103' or zipCode = '76104' or zipCode = '76105' or zipCode = '76106' or zipCode = '76107' or zipCode = '76108' or zipCode = '76109' or zipCode = '76110' or zipCode = '76111' or zipCode = '76112' or zipCode = '76113' or zipCode = '76114' or zipCode = '76115' or zipCode = '76116' or zipCode = '76117' or zipCode = '76118' or zipCode = '76119' or zipCode = '76120' or zipCode = '76121' or zipCode = '76122' or zipCode = '76123' or zipCode = '76124' or zipCode = '76126' or zipCode = '76127' or zipCode = '76129' or zipCode = '76130' or zipCode = '76131' or zipCode = '76132' or zipCode = '76133' or zipCode = '76134' or zipCode = '76135' or zipCode = '76136' or zipCode = '76137' or zipCode = '76140' or zipCode = '76147' or zipCode = '76148' or zipCode = '76150' or zipCode = '76153' or zipCode = '76155' or zipCode = '76161' or zipCode = '76162' or zipCode = '76163' or zipCode = '76164' or zipCode = '76177' or zipCode = '76178' or zipCode = '76179' or zipCode = '76180' or zipCode = '76181' or zipCode = '76182' or zipCode = '76185' or zipCode = '76191' or zipCode = '76192' or zipCode = '76193' or zipCode = '76195' or zipCode = '76196' or zipCode = '76197' or zipCode = '76198' or zipCode = '76199' or zipCode = '76226' or zipCode = '76244' or zipCode = '76247' or zipCode = '76248' or zipCode = '76262') 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 ='75014' or property_zip = '75015' or property_zip = '75016' or property_zip = '75017' or property_zip = '75019' or property_zip = '75022' or property_zip = '75022' or property_zip = '75022' 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 = '75037' or property_zip = '75037' or property_zip = '75038' or property_zip = '75039' or property_zip = '75050' or property_zip = '75051' or property_zip = '75052' or property_zip = '75053' or property_zip = '75054' 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 = '75099' or property_zip = '75099' or property_zip = '75099' or property_zip = '75104' or property_zip = '75106' or property_zip = '75211' or property_zip = '75211' or property_zip = '75212' or property_zip = '75247' or property_zip = '75249' or property_zip = '75261' or property_zip = '75261' or property_zip = '75261' or property_zip = '75077' or property_zip = '75077' or property_zip = '75077' or property_zip = '75077' or property_zip = '75077' or property_zip = '75116' or property_zip = '75137' or property_zip = '75138' or property_zip = '75233' or property_zip = '75236' or property_zip = '75340' or property_zip = '75343' 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 = '76020' or property_zip = '76020' or property_zip = '76021' or property_zip = '76022' or property_zip = '76028' or property_zip = '76034' or property_zip = '76036' or property_zip = '76039' or property_zip = '76040' or property_zip = '76085' or property_zip = '76092' or property_zip = '76092' or property_zip = '76094' or property_zip = '76095' or property_zip = '76096' or property_zip = '76097' or property_zip = '76098' or property_zip = '76099' or property_zip = '76101' or property_zip = '76102' or property_zip = '76103' or property_zip = '76104' or property_zip = '76105' or property_zip = '76106' or property_zip = '76107' or property_zip = '76107' or property_zip = '76108' or property_zip = '76108' or property_zip = '76108' or property_zip = '76108' or property_zip = '76109' or property_zip = '76109' or property_zip = '76110' or property_zip = '76111' or property_zip = '76111' or property_zip = '76112' or property_zip = '76113' or property_zip = '76114' or property_zip = '76114' or property_zip = '76114' or property_zip = '76114' or property_zip = '76114' or property_zip = '76114' or property_zip = '76127' or property_zip = '76129' or property_zip = '76129' or property_zip = '76130' or property_zip = '76130' or property_zip = '76131' or property_zip = '76131' or property_zip = '76131' or property_zip = '76132' or property_zip = '76132' or property_zip = '76133' or property_zip = '76134' or property_zip = '76135' or property_zip = '76135' or property_zip = '76135' or property_zip = '76136' or property_zip = '76136' or property_zip = '76137' or property_zip = '76137' or property_zip = '76137' or property_zip = '76140' or property_zip = '76140' or property_zip = '76140' 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 = '76008' or property_zip = '76008' or property_zip = '76009' 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 = '76052' or property_zip = '76053' or property_zip = '76054' or property_zip = '76058' or property_zip = '76060' or property_zip = '76061' or property_zip = '76063' or property_zip = '76071' or property_zip = '76115' or property_zip = '76115' or property_zip = '76116' or property_zip = '76116' or property_zip = '76117' or property_zip = '76117' or property_zip = '76118' or property_zip = '76118' or property_zip = '76118' or property_zip = '76118' or property_zip = '76118' or property_zip = '76119' or property_zip = '76119' or property_zip = '76120' or property_zip = '76121' or property_zip = '76122' or property_zip = '76122' or property_zip = '76123' or property_zip = '76124' or property_zip = '76126' or property_zip = '76126' or property_zip = '76127' or property_zip = '76127' or property_zip = '76147' or property_zip = '76148' or property_zip = '76148' or property_zip = '76148' or property_zip = '76148' or property_zip = '76150' or property_zip = '76155' or property_zip = '76161' or property_zip = '76162' or property_zip = '76163' or property_zip = '76164' or property_zip = '76166' or property_zip = '76166' or property_zip = '76177' or property_zip = '76177' or property_zip = '76179' or property_zip = '76179' 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 = '76181' or property_zip = '76182' or property_zip = '76182' or property_zip = '76182' or property_zip = '76185' or property_zip = '76191' or property_zip = '76191' or property_zip = '76192' or property_zip = '76192' or property_zip = '76193' or property_zip = '76193' or property_zip = '76195' or property_zip = '76195' or property_zip = '76196' or property_zip = '76196' or property_zip = '76197' or property_zip = '76197' or property_zip = '76198' or property_zip = '76198' or property_zip = '76199' or property_zip = '76244' or property_zip = '76247' or property_zip = '76248' or property_zip = '76262' or property_zip = '76262' or property_zip = '76262' or property_zip = '76226' or property_zip = '76226' or property_zip = '76226' or property_zip = '76226' or property_zip = '75019' or property_zip = '75022' or property_zip = '75028' or property_zip = '75038' or property_zip = '75039' or property_zip = '75050' or property_zip = '75051' or property_zip = '75052' or property_zip = '75059' or property_zip = '75060' or property_zip = '75061' or property_zip = '75062' or property_zip = '75063' or property_zip = '75067' or property_zip = '75104' or property_zip = '75116' or property_zip = '75137' or property_zip = '75211' or property_zip = '75212' or property_zip = '75233' or property_zip = '75236' or property_zip = '75247' or property_zip = '75249' 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 = '76008' 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 = '76019' or property_zip = '76020' or property_zip = '76021' or property_zip = '76022' or property_zip = '76028' or property_zip = '76034' or property_zip = '76036' or property_zip = '76039' or property_zip = '76040' or property_zip = '76051' or property_zip = '76052' or property_zip = '76053' or property_zip = '76054' or property_zip = '76058' or property_zip = '76060' or property_zip = '76061' or property_zip = '76063' or property_zip = '76071' or property_zip = '76078' or property_zip = '76085' or property_zip = '76092' or property_zip = '76094' or property_zip = '76095' or property_zip = '76096' or property_zip = '76097' or property_zip = '76098' or property_zip = '76099' or property_zip = '76101' or property_zip = '76102' or property_zip = '76103' or property_zip = '76104' or property_zip = '76105' or property_zip = '76106' or property_zip = '76107' or property_zip = '76108' or property_zip = '76109' or property_zip = '76110' or property_zip = '76111' or property_zip = '76112' or property_zip = '76113' or property_zip = '76114' or property_zip = '76115' or property_zip = '76116' or property_zip = '76117' or property_zip = '76118' or property_zip = '76119' or property_zip = '76120' or property_zip = '76121' or property_zip = '76122' or property_zip = '76123' or property_zip = '76124' or property_zip = '76126' or property_zip = '76127' or property_zip = '76129' or property_zip = '76130' or property_zip = '76131' or property_zip = '76132' or property_zip = '76133' or property_zip = '76134' or property_zip = '76135' or property_zip = '76136' or property_zip = '76137' or property_zip = '76140' or property_zip = '76147' or property_zip = '76148' or property_zip = '76150' or property_zip = '76153' or property_zip = '76155' or property_zip = '76161' or property_zip = '76162' or property_zip = '76163' or property_zip = '76164' or property_zip = '76177' or property_zip = '76178' or property_zip = '76179' or property_zip = '76180' or property_zip = '76181' or property_zip = '76182' or property_zip = '76185' or property_zip = '76191' or property_zip = '76192' or property_zip = '76193' or property_zip = '76195' or property_zip = '76196' or property_zip = '76197' or property_zip = '76198' or property_zip = '76199' or property_zip = '76226' or property_zip = '76244' or property_zip = '76247' or property_zip = '76248' or property_zip = '76262') 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 ='75014' or zip = '75015' or zip = '75016' or zip = '75017' or zip = '75019' or zip = '75022' or zip = '75022' or zip = '75022' or zip = '75027' or zip = '75027' or zip = '75027' or zip = '75028' or zip = '75028' or zip = '75028' or zip = '75037' or zip = '75037' or zip = '75038' or zip = '75039' or zip = '75050' or zip = '75051' or zip = '75052' or zip = '75053' or zip = '75054' or zip = '75060' or zip = '75061' or zip = '75062' or zip = '75063' or zip = '75067' or zip = '75067' or zip = '75099' or zip = '75099' or zip = '75099' or zip = '75104' or zip = '75106' or zip = '75211' or zip = '75211' or zip = '75212' or zip = '75247' or zip = '75249' or zip = '75261' or zip = '75261' or zip = '75261' or zip = '75077' or zip = '75077' or zip = '75077' or zip = '75077' or zip = '75077' or zip = '75116' or zip = '75137' or zip = '75138' or zip = '75233' or zip = '75236' or zip = '75340' or zip = '75343' 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 = '76020' or zip = '76020' or zip = '76021' or zip = '76022' or zip = '76028' or zip = '76034' or zip = '76036' or zip = '76039' or zip = '76040' or zip = '76085' or zip = '76092' or zip = '76092' or zip = '76094' or zip = '76095' or zip = '76096' or zip = '76097' or zip = '76098' or zip = '76099' or zip = '76101' or zip = '76102' or zip = '76103' or zip = '76104' or zip = '76105' or zip = '76106' or zip = '76107' or zip = '76107' or zip = '76108' or zip = '76108' or zip = '76108' or zip = '76108' or zip = '76109' or zip = '76109' or zip = '76110' or zip = '76111' or zip = '76111' or zip = '76112' or zip = '76113' or zip = '76114' or zip = '76114' or zip = '76114' or zip = '76114' or zip = '76114' or zip = '76114' or zip = '76127' or zip = '76129' or zip = '76129' or zip = '76130' or zip = '76130' or zip = '76131' or zip = '76131' or zip = '76131' or zip = '76132' or zip = '76132' or zip = '76133' or zip = '76134' or zip = '76135' or zip = '76135' or zip = '76135' or zip = '76136' or zip = '76136' or zip = '76137' or zip = '76137' or zip = '76137' or zip = '76140' or zip = '76140' or zip = '76140' or zip = '76001' or zip = '76002' or zip = '76003' or zip = '76004' or zip = '76005' or zip = '76006' or zip = '76007' or zip = '76008' or zip = '76008' or zip = '76009' 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 = '76052' or zip = '76053' or zip = '76054' or zip = '76058' or zip = '76060' or zip = '76061' or zip = '76063' or zip = '76071' or zip = '76115' or zip = '76115' or zip = '76116' or zip = '76116' or zip = '76117' or zip = '76117' or zip = '76118' or zip = '76118' or zip = '76118' or zip = '76118' or zip = '76118' or zip = '76119' or zip = '76119' or zip = '76120' or zip = '76121' or zip = '76122' or zip = '76122' or zip = '76123' or zip = '76124' or zip = '76126' or zip = '76126' or zip = '76127' or zip = '76127' or zip = '76147' or zip = '76148' or zip = '76148' or zip = '76148' or zip = '76148' or zip = '76150' or zip = '76155' or zip = '76161' or zip = '76162' or zip = '76163' or zip = '76164' or zip = '76166' or zip = '76166' or zip = '76177' or zip = '76177' or zip = '76179' or zip = '76179' or zip = '76180' or zip = '76180' or zip = '76180' or zip = '76180' or zip = '76180' or zip = '76180' or zip = '76180' or zip = '76181' or zip = '76182' or zip = '76182' or zip = '76182' or zip = '76185' or zip = '76191' or zip = '76191' or zip = '76192' or zip = '76192' or zip = '76193' or zip = '76193' or zip = '76195' or zip = '76195' or zip = '76196' or zip = '76196' or zip = '76197' or zip = '76197' or zip = '76198' or zip = '76198' or zip = '76199' or zip = '76244' or zip = '76247' or zip = '76248' or zip = '76262' or zip = '76262' or zip = '76262' or zip = '76226' or zip = '76226' or zip = '76226' or zip = '76226' or zip = '75019' or zip = '75022' or zip = '75028' or zip = '75038' or zip = '75039' or zip = '75050' or zip = '75051' or zip = '75052' or zip = '75059' or zip = '75060' or zip = '75061' or zip = '75062' or zip = '75063' or zip = '75067' or zip = '75104' or zip = '75116' or zip = '75137' or zip = '75211' or zip = '75212' or zip = '75233' or zip = '75236' or zip = '75247' or zip = '75249' or zip = '76001' or zip = '76002' or zip = '76003' or zip = '76004' or zip = '76005' or zip = '76006' or zip = '76007' or zip = '76008' 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 = '76019' or zip = '76020' or zip = '76021' or zip = '76022' or zip = '76028' or zip = '76034' or zip = '76036' or zip = '76039' or zip = '76040' or zip = '76051' or zip = '76052' or zip = '76053' or zip = '76054' or zip = '76058' or zip = '76060' or zip = '76061' or zip = '76063' or zip = '76071' or zip = '76078' or zip = '76085' or zip = '76092' or zip = '76094' or zip = '76095' or zip = '76096' or zip = '76097' or zip = '76098' or zip = '76099' or zip = '76101' or zip = '76102' or zip = '76103' or zip = '76104' or zip = '76105' or zip = '76106' or zip = '76107' or zip = '76108' or zip = '76109' or zip = '76110' or zip = '76111' or zip = '76112' or zip = '76113' or zip = '76114' or zip = '76115' or zip = '76116' or zip = '76117' or zip = '76118' or zip = '76119' or zip = '76120' or zip = '76121' or zip = '76122' or zip = '76123' or zip = '76124' or zip = '76126' or zip = '76127' or zip = '76129' or zip = '76130' or zip = '76131' or zip = '76132' or zip = '76133' or zip = '76134' or zip = '76135' or zip = '76136' or zip = '76137' or zip = '76140' or zip = '76147' or zip = '76148' or zip = '76150' or zip = '76153' or zip = '76155' or zip = '76161' or zip = '76162' or zip = '76163' or zip = '76164' or zip = '76177' or zip = '76178' or zip = '76179' or zip = '76180' or zip = '76181' or zip = '76182' or zip = '76185' or zip = '76191' or zip = '76192' or zip = '76193' or zip = '76195' or zip = '76196' or zip = '76197' or zip = '76198' or zip = '76199' or zip = '76226' or zip = '76244' or zip = '76247' or zip = '76248' or zip = '76262')
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 = 'FORT WORTH' 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();