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


96+ High Potential Investor Deals Near little rock [Refine]


********NOTICE: Displaying 96 of over 96 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 ='72002' or zipCode = '72007' or zipCode = '72011' or zipCode = '72015' or zipCode = '72015' or zipCode = '72015' or zipCode = '72015' or zipCode = '72018' or zipCode = '72019' or zipCode = '72019' or zipCode = '72022' or zipCode = '72022' or zipCode = '72023' or zipCode = '72032' or zipCode = '72046' or zipCode = '72053' or zipCode = '72053' or zipCode = '72053' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72034' or zipCode = '72035' or zipCode = '72035' or zipCode = '72035' or zipCode = '72035' or zipCode = '72065' or zipCode = '72065' or zipCode = '72076' or zipCode = '72076' or zipCode = '72076' or zipCode = '72086' or zipCode = '72086' or zipCode = '72086' or zipCode = '72086' or zipCode = '72089' or zipCode = '72099' or zipCode = '72099' or zipCode = '72099' or zipCode = '72099' or zipCode = '72099' or zipCode = '72099' or zipCode = '72103' or zipCode = '72103' or zipCode = '72103' or zipCode = '72106' or zipCode = '72106' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72132' or zipCode = '72132' or zipCode = '72132' or zipCode = '72135' or zipCode = '72135' or zipCode = '72135' or zipCode = '72135' or zipCode = '72142' or zipCode = '72142' or zipCode = '72142' or zipCode = '72142' or zipCode = '72076' or zipCode = '72076' or zipCode = '72076' or zipCode = '72076' or zipCode = '72076' or zipCode = '72076' or zipCode = '72078' or zipCode = '72083' or zipCode = '72086' or zipCode = '72113' or zipCode = '72113' or zipCode = '72113' or zipCode = '72113' or zipCode = '72113' or zipCode = '72114' or zipCode = '72114' or zipCode = '72114' or zipCode = '72114' or zipCode = '72114' or zipCode = '72114' or zipCode = '72114' or zipCode = '72114' or zipCode = '72115' or zipCode = '72115' or zipCode = '72115' or zipCode = '72116' or zipCode = '72116' or zipCode = '72116' or zipCode = '72116' or zipCode = '72116' or zipCode = '72116' or zipCode = '72118' or zipCode = '72119' or zipCode = '72119' or zipCode = '72119' or zipCode = '72119' or zipCode = '72120' or zipCode = '72120' or zipCode = '72120' or zipCode = '72120' or zipCode = '72120' or zipCode = '72124' or zipCode = '72124' or zipCode = '72124' or zipCode = '72124' or zipCode = '72124' or zipCode = '72158' or zipCode = '72164' or zipCode = '72173' or zipCode = '72173' or zipCode = '72173' or zipCode = '72173' or zipCode = '72180' or zipCode = '72182' or zipCode = '72182' or zipCode = '72207' or zipCode = '72207' or zipCode = '72209' or zipCode = '72210' or zipCode = '72211' or zipCode = '72212' or zipCode = '72214' or zipCode = '72215' or zipCode = '72216' or zipCode = '72217' or zipCode = '72219' or zipCode = '72221' or zipCode = '72222' or zipCode = '72223' or zipCode = '72225' or zipCode = '72227' or zipCode = '72231' or zipCode = '72231' or zipCode = '72231' or zipCode = '72231' or zipCode = '72260' or zipCode = '72295' or zipCode = '72183' or zipCode = '72183' or zipCode = '72183' or zipCode = '72190' or zipCode = '72190' or zipCode = '72190' or zipCode = '72190' or zipCode = '72198' or zipCode = '72198' or zipCode = '72198' or zipCode = '72199' or zipCode = '72199' or zipCode = '72199' or zipCode = '72199' or zipCode = '72199' or zipCode = '72201' or zipCode = '72202' or zipCode = '72203' or zipCode = '72204' or zipCode = '72205' or zipCode = '72206' or zipCode = '72207' or zipCode = '72002' or zipCode = '72007' or zipCode = '72011' or zipCode = '72015' or zipCode = '72018' or zipCode = '72019' or zipCode = '72022' or zipCode = '72023' or zipCode = '72032' or zipCode = '72034' or zipCode = '72046' or zipCode = '72053' or zipCode = '72065' or zipCode = '72076' or zipCode = '72078' or zipCode = '72079' or zipCode = '72083' or zipCode = '72086' or zipCode = '72089' or zipCode = '72098' or zipCode = '72099' or zipCode = '72103' or zipCode = '72106' or zipCode = '72113' or zipCode = '72114' or zipCode = '72115' or zipCode = '72116' or zipCode = '72117' or zipCode = '72118' or zipCode = '72119' or zipCode = '72120' or zipCode = '72124' or zipCode = '72132' or zipCode = '72135' or zipCode = '72142' or zipCode = '72158' or zipCode = '72164' or zipCode = '72173' or zipCode = '72180' or zipCode = '72183' or zipCode = '72190' or zipCode = '72199' or zipCode = '72201' or zipCode = '72202' or zipCode = '72203' or zipCode = '72204' or zipCode = '72205' or zipCode = '72206' or zipCode = '72207' or zipCode = '72209' or zipCode = '72210' or zipCode = '72211' or zipCode = '72212' or zipCode = '72214' or zipCode = '72215' or zipCode = '72216' or zipCode = '72217' or zipCode = '72219' or zipCode = '72221' or zipCode = '72222' or zipCode = '72223' or zipCode = '72225' or zipCode = '72227' or zipCode = '72231' or zipCode = '72259' or zipCode = '72295' or zipCode = '72559')
select top 45 *, cast(tax_value as float)/cast(price as float) as tax_ratio from tblBothNew NOLOCK where priority IS NULL and price > 5000 and (1=1) and original_price IS NOT NULL and (status='active' or status='for_sale' or status IS NULL) and (propertyType != 'LAND' or propertyType is null) and 1=1 and state = 'AR' and photoURL1 IS NOT NULL and theType = 'Tax' and tax_value IS NOT NULL and (bedrooms <> '' AND bedrooms IS NOT NULL) and tax_value/price < 5 and 1=1 and (1=1) and price >= 0 and price <= 499999 and 11=11 and (zipCode ='72002' or zipCode = '72007' or zipCode = '72011' or zipCode = '72015' or zipCode = '72015' or zipCode = '72015' or zipCode = '72015' or zipCode = '72018' or zipCode = '72019' or zipCode = '72019' or zipCode = '72022' or zipCode = '72022' or zipCode = '72023' or zipCode = '72032' or zipCode = '72046' or zipCode = '72053' or zipCode = '72053' or zipCode = '72053' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72034' or zipCode = '72035' or zipCode = '72035' or zipCode = '72035' or zipCode = '72035' or zipCode = '72065' or zipCode = '72065' or zipCode = '72076' or zipCode = '72076' or zipCode = '72076' or zipCode = '72086' or zipCode = '72086' or zipCode = '72086' or zipCode = '72086' or zipCode = '72089' or zipCode = '72099' or zipCode = '72099' or zipCode = '72099' or zipCode = '72099' or zipCode = '72099' or zipCode = '72099' or zipCode = '72103' or zipCode = '72103' or zipCode = '72103' or zipCode = '72106' or zipCode = '72106' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72132' or zipCode = '72132' or zipCode = '72132' or zipCode = '72135' or zipCode = '72135' or zipCode = '72135' or zipCode = '72135' or zipCode = '72142' or zipCode = '72142' or zipCode = '72142' or zipCode = '72142' or zipCode = '72076' or zipCode = '72076' or zipCode = '72076' or zipCode = '72076' or zipCode = '72076' or zipCode = '72076' or zipCode = '72078' or zipCode = '72083' or zipCode = '72086' or zipCode = '72113' or zipCode = '72113' or zipCode = '72113' or zipCode = '72113' or zipCode = '72113' or zipCode = '72114' or zipCode = '72114' or zipCode = '72114' or zipCode = '72114' or zipCode = '72114' or zipCode = '72114' or zipCode = '72114' or zipCode = '72114' or zipCode = '72115' or zipCode = '72115' or zipCode = '72115' or zipCode = '72116' or zipCode = '72116' or zipCode = '72116' or zipCode = '72116' or zipCode = '72116' or zipCode = '72116' or zipCode = '72118' or zipCode = '72119' or zipCode = '72119' or zipCode = '72119' or zipCode = '72119' or zipCode = '72120' or zipCode = '72120' or zipCode = '72120' or zipCode = '72120' or zipCode = '72120' or zipCode = '72124' or zipCode = '72124' or zipCode = '72124' or zipCode = '72124' or zipCode = '72124' or zipCode = '72158' or zipCode = '72164' or zipCode = '72173' or zipCode = '72173' or zipCode = '72173' or zipCode = '72173' or zipCode = '72180' or zipCode = '72182' or zipCode = '72182' or zipCode = '72207' or zipCode = '72207' or zipCode = '72209' or zipCode = '72210' or zipCode = '72211' or zipCode = '72212' or zipCode = '72214' or zipCode = '72215' or zipCode = '72216' or zipCode = '72217' or zipCode = '72219' or zipCode = '72221' or zipCode = '72222' or zipCode = '72223' or zipCode = '72225' or zipCode = '72227' or zipCode = '72231' or zipCode = '72231' or zipCode = '72231' or zipCode = '72231' or zipCode = '72260' or zipCode = '72295' or zipCode = '72183' or zipCode = '72183' or zipCode = '72183' or zipCode = '72190' or zipCode = '72190' or zipCode = '72190' or zipCode = '72190' or zipCode = '72198' or zipCode = '72198' or zipCode = '72198' or zipCode = '72199' or zipCode = '72199' or zipCode = '72199' or zipCode = '72199' or zipCode = '72199' or zipCode = '72201' or zipCode = '72202' or zipCode = '72203' or zipCode = '72204' or zipCode = '72205' or zipCode = '72206' or zipCode = '72207' or zipCode = '72002' or zipCode = '72007' or zipCode = '72011' or zipCode = '72015' or zipCode = '72018' or zipCode = '72019' or zipCode = '72022' or zipCode = '72023' or zipCode = '72032' or zipCode = '72034' or zipCode = '72046' or zipCode = '72053' or zipCode = '72065' or zipCode = '72076' or zipCode = '72078' or zipCode = '72079' or zipCode = '72083' or zipCode = '72086' or zipCode = '72089' or zipCode = '72098' or zipCode = '72099' or zipCode = '72103' or zipCode = '72106' or zipCode = '72113' or zipCode = '72114' or zipCode = '72115' or zipCode = '72116' or zipCode = '72117' or zipCode = '72118' or zipCode = '72119' or zipCode = '72120' or zipCode = '72124' or zipCode = '72132' or zipCode = '72135' or zipCode = '72142' or zipCode = '72158' or zipCode = '72164' or zipCode = '72173' or zipCode = '72180' or zipCode = '72183' or zipCode = '72190' or zipCode = '72199' or zipCode = '72201' or zipCode = '72202' or zipCode = '72203' or zipCode = '72204' or zipCode = '72205' or zipCode = '72206' or zipCode = '72207' or zipCode = '72209' or zipCode = '72210' or zipCode = '72211' or zipCode = '72212' or zipCode = '72214' or zipCode = '72215' or zipCode = '72216' or zipCode = '72217' or zipCode = '72219' or zipCode = '72221' or zipCode = '72222' or zipCode = '72223' or zipCode = '72225' or zipCode = '72227' or zipCode = '72231' or zipCode = '72259' or zipCode = '72295' or zipCode = '72559') order by price;
select top 240 * from tblBothNew NOLOCK where priority IS NULL and price > 5000 and original_price IS NOT NULL and (status='active' or status='for_sale' or status IS NULL) and (propertyType != 'land' or propertyType IS NULL) and len(photoURL1) > 5 and dateposted >= '8/29/2021' and theType = 'Desperate' and (bedrooms <> '' and bedrooms IS NOT NULL) and price > 10000 and original_price > 10000 and (1=1) and price >= 0 and price <= 499999 and 11=11 and (zipCode ='72002' or zipCode = '72007' or zipCode = '72011' or zipCode = '72015' or zipCode = '72015' or zipCode = '72015' or zipCode = '72015' or zipCode = '72018' or zipCode = '72019' or zipCode = '72019' or zipCode = '72022' or zipCode = '72022' or zipCode = '72023' or zipCode = '72032' or zipCode = '72046' or zipCode = '72053' or zipCode = '72053' or zipCode = '72053' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72034' or zipCode = '72035' or zipCode = '72035' or zipCode = '72035' or zipCode = '72035' or zipCode = '72065' or zipCode = '72065' or zipCode = '72076' or zipCode = '72076' or zipCode = '72076' or zipCode = '72086' or zipCode = '72086' or zipCode = '72086' or zipCode = '72086' or zipCode = '72089' or zipCode = '72099' or zipCode = '72099' or zipCode = '72099' or zipCode = '72099' or zipCode = '72099' or zipCode = '72099' or zipCode = '72103' or zipCode = '72103' or zipCode = '72103' or zipCode = '72106' or zipCode = '72106' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72132' or zipCode = '72132' or zipCode = '72132' or zipCode = '72135' or zipCode = '72135' or zipCode = '72135' or zipCode = '72135' or zipCode = '72142' or zipCode = '72142' or zipCode = '72142' or zipCode = '72142' or zipCode = '72076' or zipCode = '72076' or zipCode = '72076' or zipCode = '72076' or zipCode = '72076' or zipCode = '72076' or zipCode = '72078' or zipCode = '72083' or zipCode = '72086' or zipCode = '72113' or zipCode = '72113' or zipCode = '72113' or zipCode = '72113' or zipCode = '72113' or zipCode = '72114' or zipCode = '72114' or zipCode = '72114' or zipCode = '72114' or zipCode = '72114' or zipCode = '72114' or zipCode = '72114' or zipCode = '72114' or zipCode = '72115' or zipCode = '72115' or zipCode = '72115' or zipCode = '72116' or zipCode = '72116' or zipCode = '72116' or zipCode = '72116' or zipCode = '72116' or zipCode = '72116' or zipCode = '72118' or zipCode = '72119' or zipCode = '72119' or zipCode = '72119' or zipCode = '72119' or zipCode = '72120' or zipCode = '72120' or zipCode = '72120' or zipCode = '72120' or zipCode = '72120' or zipCode = '72124' or zipCode = '72124' or zipCode = '72124' or zipCode = '72124' or zipCode = '72124' or zipCode = '72158' or zipCode = '72164' or zipCode = '72173' or zipCode = '72173' or zipCode = '72173' or zipCode = '72173' or zipCode = '72180' or zipCode = '72182' or zipCode = '72182' or zipCode = '72207' or zipCode = '72207' or zipCode = '72209' or zipCode = '72210' or zipCode = '72211' or zipCode = '72212' or zipCode = '72214' or zipCode = '72215' or zipCode = '72216' or zipCode = '72217' or zipCode = '72219' or zipCode = '72221' or zipCode = '72222' or zipCode = '72223' or zipCode = '72225' or zipCode = '72227' or zipCode = '72231' or zipCode = '72231' or zipCode = '72231' or zipCode = '72231' or zipCode = '72260' or zipCode = '72295' or zipCode = '72183' or zipCode = '72183' or zipCode = '72183' or zipCode = '72190' or zipCode = '72190' or zipCode = '72190' or zipCode = '72190' or zipCode = '72198' or zipCode = '72198' or zipCode = '72198' or zipCode = '72199' or zipCode = '72199' or zipCode = '72199' or zipCode = '72199' or zipCode = '72199' or zipCode = '72201' or zipCode = '72202' or zipCode = '72203' or zipCode = '72204' or zipCode = '72205' or zipCode = '72206' or zipCode = '72207' or zipCode = '72002' or zipCode = '72007' or zipCode = '72011' or zipCode = '72015' or zipCode = '72018' or zipCode = '72019' or zipCode = '72022' or zipCode = '72023' or zipCode = '72032' or zipCode = '72034' or zipCode = '72046' or zipCode = '72053' or zipCode = '72065' or zipCode = '72076' or zipCode = '72078' or zipCode = '72079' or zipCode = '72083' or zipCode = '72086' or zipCode = '72089' or zipCode = '72098' or zipCode = '72099' or zipCode = '72103' or zipCode = '72106' or zipCode = '72113' or zipCode = '72114' or zipCode = '72115' or zipCode = '72116' or zipCode = '72117' or zipCode = '72118' or zipCode = '72119' or zipCode = '72120' or zipCode = '72124' or zipCode = '72132' or zipCode = '72135' or zipCode = '72142' or zipCode = '72158' or zipCode = '72164' or zipCode = '72173' or zipCode = '72180' or zipCode = '72183' or zipCode = '72190' or zipCode = '72199' or zipCode = '72201' or zipCode = '72202' or zipCode = '72203' or zipCode = '72204' or zipCode = '72205' or zipCode = '72206' or zipCode = '72207' or zipCode = '72209' or zipCode = '72210' or zipCode = '72211' or zipCode = '72212' or zipCode = '72214' or zipCode = '72215' or zipCode = '72216' or zipCode = '72217' or zipCode = '72219' or zipCode = '72221' or zipCode = '72222' or zipCode = '72223' or zipCode = '72225' or zipCode = '72227' or zipCode = '72231' or zipCode = '72259' or zipCode = '72295' or zipCode = '72559') 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 ='72002' or zipCode = '72007' or zipCode = '72011' or zipCode = '72015' or zipCode = '72015' or zipCode = '72015' or zipCode = '72015' or zipCode = '72018' or zipCode = '72019' or zipCode = '72019' or zipCode = '72022' or zipCode = '72022' or zipCode = '72023' or zipCode = '72032' or zipCode = '72046' or zipCode = '72053' or zipCode = '72053' or zipCode = '72053' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72034' or zipCode = '72035' or zipCode = '72035' or zipCode = '72035' or zipCode = '72035' or zipCode = '72065' or zipCode = '72065' or zipCode = '72076' or zipCode = '72076' or zipCode = '72076' or zipCode = '72086' or zipCode = '72086' or zipCode = '72086' or zipCode = '72086' or zipCode = '72089' or zipCode = '72099' or zipCode = '72099' or zipCode = '72099' or zipCode = '72099' or zipCode = '72099' or zipCode = '72099' or zipCode = '72103' or zipCode = '72103' or zipCode = '72103' or zipCode = '72106' or zipCode = '72106' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72132' or zipCode = '72132' or zipCode = '72132' or zipCode = '72135' or zipCode = '72135' or zipCode = '72135' or zipCode = '72135' or zipCode = '72142' or zipCode = '72142' or zipCode = '72142' or zipCode = '72142' or zipCode = '72076' or zipCode = '72076' or zipCode = '72076' or zipCode = '72076' or zipCode = '72076' or zipCode = '72076' or zipCode = '72078' or zipCode = '72083' or zipCode = '72086' or zipCode = '72113' or zipCode = '72113' or zipCode = '72113' or zipCode = '72113' or zipCode = '72113' or zipCode = '72114' or zipCode = '72114' or zipCode = '72114' or zipCode = '72114' or zipCode = '72114' or zipCode = '72114' or zipCode = '72114' or zipCode = '72114' or zipCode = '72115' or zipCode = '72115' or zipCode = '72115' or zipCode = '72116' or zipCode = '72116' or zipCode = '72116' or zipCode = '72116' or zipCode = '72116' or zipCode = '72116' or zipCode = '72118' or zipCode = '72119' or zipCode = '72119' or zipCode = '72119' or zipCode = '72119' or zipCode = '72120' or zipCode = '72120' or zipCode = '72120' or zipCode = '72120' or zipCode = '72120' or zipCode = '72124' or zipCode = '72124' or zipCode = '72124' or zipCode = '72124' or zipCode = '72124' or zipCode = '72158' or zipCode = '72164' or zipCode = '72173' or zipCode = '72173' or zipCode = '72173' or zipCode = '72173' or zipCode = '72180' or zipCode = '72182' or zipCode = '72182' or zipCode = '72207' or zipCode = '72207' or zipCode = '72209' or zipCode = '72210' or zipCode = '72211' or zipCode = '72212' or zipCode = '72214' or zipCode = '72215' or zipCode = '72216' or zipCode = '72217' or zipCode = '72219' or zipCode = '72221' or zipCode = '72222' or zipCode = '72223' or zipCode = '72225' or zipCode = '72227' or zipCode = '72231' or zipCode = '72231' or zipCode = '72231' or zipCode = '72231' or zipCode = '72260' or zipCode = '72295' or zipCode = '72183' or zipCode = '72183' or zipCode = '72183' or zipCode = '72190' or zipCode = '72190' or zipCode = '72190' or zipCode = '72190' or zipCode = '72198' or zipCode = '72198' or zipCode = '72198' or zipCode = '72199' or zipCode = '72199' or zipCode = '72199' or zipCode = '72199' or zipCode = '72199' or zipCode = '72201' or zipCode = '72202' or zipCode = '72203' or zipCode = '72204' or zipCode = '72205' or zipCode = '72206' or zipCode = '72207' or zipCode = '72002' or zipCode = '72007' or zipCode = '72011' or zipCode = '72015' or zipCode = '72018' or zipCode = '72019' or zipCode = '72022' or zipCode = '72023' or zipCode = '72032' or zipCode = '72034' or zipCode = '72046' or zipCode = '72053' or zipCode = '72065' or zipCode = '72076' or zipCode = '72078' or zipCode = '72079' or zipCode = '72083' or zipCode = '72086' or zipCode = '72089' or zipCode = '72098' or zipCode = '72099' or zipCode = '72103' or zipCode = '72106' or zipCode = '72113' or zipCode = '72114' or zipCode = '72115' or zipCode = '72116' or zipCode = '72117' or zipCode = '72118' or zipCode = '72119' or zipCode = '72120' or zipCode = '72124' or zipCode = '72132' or zipCode = '72135' or zipCode = '72142' or zipCode = '72158' or zipCode = '72164' or zipCode = '72173' or zipCode = '72180' or zipCode = '72183' or zipCode = '72190' or zipCode = '72199' or zipCode = '72201' or zipCode = '72202' or zipCode = '72203' or zipCode = '72204' or zipCode = '72205' or zipCode = '72206' or zipCode = '72207' or zipCode = '72209' or zipCode = '72210' or zipCode = '72211' or zipCode = '72212' or zipCode = '72214' or zipCode = '72215' or zipCode = '72216' or zipCode = '72217' or zipCode = '72219' or zipCode = '72221' or zipCode = '72222' or zipCode = '72223' or zipCode = '72225' or zipCode = '72227' or zipCode = '72231' or zipCode = '72259' or zipCode = '72295' or zipCode = '72559') 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 ='72002' or zipCode = '72007' or zipCode = '72011' or zipCode = '72015' or zipCode = '72015' or zipCode = '72015' or zipCode = '72015' or zipCode = '72018' or zipCode = '72019' or zipCode = '72019' or zipCode = '72022' or zipCode = '72022' or zipCode = '72023' or zipCode = '72032' or zipCode = '72046' or zipCode = '72053' or zipCode = '72053' or zipCode = '72053' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72034' or zipCode = '72035' or zipCode = '72035' or zipCode = '72035' or zipCode = '72035' or zipCode = '72065' or zipCode = '72065' or zipCode = '72076' or zipCode = '72076' or zipCode = '72076' or zipCode = '72086' or zipCode = '72086' or zipCode = '72086' or zipCode = '72086' or zipCode = '72089' or zipCode = '72099' or zipCode = '72099' or zipCode = '72099' or zipCode = '72099' or zipCode = '72099' or zipCode = '72099' or zipCode = '72103' or zipCode = '72103' or zipCode = '72103' or zipCode = '72106' or zipCode = '72106' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72132' or zipCode = '72132' or zipCode = '72132' or zipCode = '72135' or zipCode = '72135' or zipCode = '72135' or zipCode = '72135' or zipCode = '72142' or zipCode = '72142' or zipCode = '72142' or zipCode = '72142' or zipCode = '72076' or zipCode = '72076' or zipCode = '72076' or zipCode = '72076' or zipCode = '72076' or zipCode = '72076' or zipCode = '72078' or zipCode = '72083' or zipCode = '72086' or zipCode = '72113' or zipCode = '72113' or zipCode = '72113' or zipCode = '72113' or zipCode = '72113' or zipCode = '72114' or zipCode = '72114' or zipCode = '72114' or zipCode = '72114' or zipCode = '72114' or zipCode = '72114' or zipCode = '72114' or zipCode = '72114' or zipCode = '72115' or zipCode = '72115' or zipCode = '72115' or zipCode = '72116' or zipCode = '72116' or zipCode = '72116' or zipCode = '72116' or zipCode = '72116' or zipCode = '72116' or zipCode = '72118' or zipCode = '72119' or zipCode = '72119' or zipCode = '72119' or zipCode = '72119' or zipCode = '72120' or zipCode = '72120' or zipCode = '72120' or zipCode = '72120' or zipCode = '72120' or zipCode = '72124' or zipCode = '72124' or zipCode = '72124' or zipCode = '72124' or zipCode = '72124' or zipCode = '72158' or zipCode = '72164' or zipCode = '72173' or zipCode = '72173' or zipCode = '72173' or zipCode = '72173' or zipCode = '72180' or zipCode = '72182' or zipCode = '72182' or zipCode = '72207' or zipCode = '72207' or zipCode = '72209' or zipCode = '72210' or zipCode = '72211' or zipCode = '72212' or zipCode = '72214' or zipCode = '72215' or zipCode = '72216' or zipCode = '72217' or zipCode = '72219' or zipCode = '72221' or zipCode = '72222' or zipCode = '72223' or zipCode = '72225' or zipCode = '72227' or zipCode = '72231' or zipCode = '72231' or zipCode = '72231' or zipCode = '72231' or zipCode = '72260' or zipCode = '72295' or zipCode = '72183' or zipCode = '72183' or zipCode = '72183' or zipCode = '72190' or zipCode = '72190' or zipCode = '72190' or zipCode = '72190' or zipCode = '72198' or zipCode = '72198' or zipCode = '72198' or zipCode = '72199' or zipCode = '72199' or zipCode = '72199' or zipCode = '72199' or zipCode = '72199' or zipCode = '72201' or zipCode = '72202' or zipCode = '72203' or zipCode = '72204' or zipCode = '72205' or zipCode = '72206' or zipCode = '72207' or zipCode = '72002' or zipCode = '72007' or zipCode = '72011' or zipCode = '72015' or zipCode = '72018' or zipCode = '72019' or zipCode = '72022' or zipCode = '72023' or zipCode = '72032' or zipCode = '72034' or zipCode = '72046' or zipCode = '72053' or zipCode = '72065' or zipCode = '72076' or zipCode = '72078' or zipCode = '72079' or zipCode = '72083' or zipCode = '72086' or zipCode = '72089' or zipCode = '72098' or zipCode = '72099' or zipCode = '72103' or zipCode = '72106' or zipCode = '72113' or zipCode = '72114' or zipCode = '72115' or zipCode = '72116' or zipCode = '72117' or zipCode = '72118' or zipCode = '72119' or zipCode = '72120' or zipCode = '72124' or zipCode = '72132' or zipCode = '72135' or zipCode = '72142' or zipCode = '72158' or zipCode = '72164' or zipCode = '72173' or zipCode = '72180' or zipCode = '72183' or zipCode = '72190' or zipCode = '72199' or zipCode = '72201' or zipCode = '72202' or zipCode = '72203' or zipCode = '72204' or zipCode = '72205' or zipCode = '72206' or zipCode = '72207' or zipCode = '72209' or zipCode = '72210' or zipCode = '72211' or zipCode = '72212' or zipCode = '72214' or zipCode = '72215' or zipCode = '72216' or zipCode = '72217' or zipCode = '72219' or zipCode = '72221' or zipCode = '72222' or zipCode = '72223' or zipCode = '72225' or zipCode = '72227' or zipCode = '72231' or zipCode = '72259' or zipCode = '72295' or zipCode = '72559') 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 ='72002' or zipCode = '72007' or zipCode = '72011' or zipCode = '72015' or zipCode = '72015' or zipCode = '72015' or zipCode = '72015' or zipCode = '72018' or zipCode = '72019' or zipCode = '72019' or zipCode = '72022' or zipCode = '72022' or zipCode = '72023' or zipCode = '72032' or zipCode = '72046' or zipCode = '72053' or zipCode = '72053' or zipCode = '72053' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72034' or zipCode = '72035' or zipCode = '72035' or zipCode = '72035' or zipCode = '72035' or zipCode = '72065' or zipCode = '72065' or zipCode = '72076' or zipCode = '72076' or zipCode = '72076' or zipCode = '72086' or zipCode = '72086' or zipCode = '72086' or zipCode = '72086' or zipCode = '72089' or zipCode = '72099' or zipCode = '72099' or zipCode = '72099' or zipCode = '72099' or zipCode = '72099' or zipCode = '72099' or zipCode = '72103' or zipCode = '72103' or zipCode = '72103' or zipCode = '72106' or zipCode = '72106' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72132' or zipCode = '72132' or zipCode = '72132' or zipCode = '72135' or zipCode = '72135' or zipCode = '72135' or zipCode = '72135' or zipCode = '72142' or zipCode = '72142' or zipCode = '72142' or zipCode = '72142' or zipCode = '72076' or zipCode = '72076' or zipCode = '72076' or zipCode = '72076' or zipCode = '72076' or zipCode = '72076' or zipCode = '72078' or zipCode = '72083' or zipCode = '72086' or zipCode = '72113' or zipCode = '72113' or zipCode = '72113' or zipCode = '72113' or zipCode = '72113' or zipCode = '72114' or zipCode = '72114' or zipCode = '72114' or zipCode = '72114' or zipCode = '72114' or zipCode = '72114' or zipCode = '72114' or zipCode = '72114' or zipCode = '72115' or zipCode = '72115' or zipCode = '72115' or zipCode = '72116' or zipCode = '72116' or zipCode = '72116' or zipCode = '72116' or zipCode = '72116' or zipCode = '72116' or zipCode = '72118' or zipCode = '72119' or zipCode = '72119' or zipCode = '72119' or zipCode = '72119' or zipCode = '72120' or zipCode = '72120' or zipCode = '72120' or zipCode = '72120' or zipCode = '72120' or zipCode = '72124' or zipCode = '72124' or zipCode = '72124' or zipCode = '72124' or zipCode = '72124' or zipCode = '72158' or zipCode = '72164' or zipCode = '72173' or zipCode = '72173' or zipCode = '72173' or zipCode = '72173' or zipCode = '72180' or zipCode = '72182' or zipCode = '72182' or zipCode = '72207' or zipCode = '72207' or zipCode = '72209' or zipCode = '72210' or zipCode = '72211' or zipCode = '72212' or zipCode = '72214' or zipCode = '72215' or zipCode = '72216' or zipCode = '72217' or zipCode = '72219' or zipCode = '72221' or zipCode = '72222' or zipCode = '72223' or zipCode = '72225' or zipCode = '72227' or zipCode = '72231' or zipCode = '72231' or zipCode = '72231' or zipCode = '72231' or zipCode = '72260' or zipCode = '72295' or zipCode = '72183' or zipCode = '72183' or zipCode = '72183' or zipCode = '72190' or zipCode = '72190' or zipCode = '72190' or zipCode = '72190' or zipCode = '72198' or zipCode = '72198' or zipCode = '72198' or zipCode = '72199' or zipCode = '72199' or zipCode = '72199' or zipCode = '72199' or zipCode = '72199' or zipCode = '72201' or zipCode = '72202' or zipCode = '72203' or zipCode = '72204' or zipCode = '72205' or zipCode = '72206' or zipCode = '72207' or zipCode = '72002' or zipCode = '72007' or zipCode = '72011' or zipCode = '72015' or zipCode = '72018' or zipCode = '72019' or zipCode = '72022' or zipCode = '72023' or zipCode = '72032' or zipCode = '72034' or zipCode = '72046' or zipCode = '72053' or zipCode = '72065' or zipCode = '72076' or zipCode = '72078' or zipCode = '72079' or zipCode = '72083' or zipCode = '72086' or zipCode = '72089' or zipCode = '72098' or zipCode = '72099' or zipCode = '72103' or zipCode = '72106' or zipCode = '72113' or zipCode = '72114' or zipCode = '72115' or zipCode = '72116' or zipCode = '72117' or zipCode = '72118' or zipCode = '72119' or zipCode = '72120' or zipCode = '72124' or zipCode = '72132' or zipCode = '72135' or zipCode = '72142' or zipCode = '72158' or zipCode = '72164' or zipCode = '72173' or zipCode = '72180' or zipCode = '72183' or zipCode = '72190' or zipCode = '72199' or zipCode = '72201' or zipCode = '72202' or zipCode = '72203' or zipCode = '72204' or zipCode = '72205' or zipCode = '72206' or zipCode = '72207' or zipCode = '72209' or zipCode = '72210' or zipCode = '72211' or zipCode = '72212' or zipCode = '72214' or zipCode = '72215' or zipCode = '72216' or zipCode = '72217' or zipCode = '72219' or zipCode = '72221' or zipCode = '72222' or zipCode = '72223' or zipCode = '72225' or zipCode = '72227' or zipCode = '72231' or zipCode = '72259' or zipCode = '72295' or zipCode = '72559') 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 ='72002' or zipCode = '72007' or zipCode = '72011' or zipCode = '72015' or zipCode = '72015' or zipCode = '72015' or zipCode = '72015' or zipCode = '72018' or zipCode = '72019' or zipCode = '72019' or zipCode = '72022' or zipCode = '72022' or zipCode = '72023' or zipCode = '72032' or zipCode = '72046' or zipCode = '72053' or zipCode = '72053' or zipCode = '72053' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72034' or zipCode = '72035' or zipCode = '72035' or zipCode = '72035' or zipCode = '72035' or zipCode = '72065' or zipCode = '72065' or zipCode = '72076' or zipCode = '72076' or zipCode = '72076' or zipCode = '72086' or zipCode = '72086' or zipCode = '72086' or zipCode = '72086' or zipCode = '72089' or zipCode = '72099' or zipCode = '72099' or zipCode = '72099' or zipCode = '72099' or zipCode = '72099' or zipCode = '72099' or zipCode = '72103' or zipCode = '72103' or zipCode = '72103' or zipCode = '72106' or zipCode = '72106' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72132' or zipCode = '72132' or zipCode = '72132' or zipCode = '72135' or zipCode = '72135' or zipCode = '72135' or zipCode = '72135' or zipCode = '72142' or zipCode = '72142' or zipCode = '72142' or zipCode = '72142' or zipCode = '72076' or zipCode = '72076' or zipCode = '72076' or zipCode = '72076' or zipCode = '72076' or zipCode = '72076' or zipCode = '72078' or zipCode = '72083' or zipCode = '72086' or zipCode = '72113' or zipCode = '72113' or zipCode = '72113' or zipCode = '72113' or zipCode = '72113' or zipCode = '72114' or zipCode = '72114' or zipCode = '72114' or zipCode = '72114' or zipCode = '72114' or zipCode = '72114' or zipCode = '72114' or zipCode = '72114' or zipCode = '72115' or zipCode = '72115' or zipCode = '72115' or zipCode = '72116' or zipCode = '72116' or zipCode = '72116' or zipCode = '72116' or zipCode = '72116' or zipCode = '72116' or zipCode = '72118' or zipCode = '72119' or zipCode = '72119' or zipCode = '72119' or zipCode = '72119' or zipCode = '72120' or zipCode = '72120' or zipCode = '72120' or zipCode = '72120' or zipCode = '72120' or zipCode = '72124' or zipCode = '72124' or zipCode = '72124' or zipCode = '72124' or zipCode = '72124' or zipCode = '72158' or zipCode = '72164' or zipCode = '72173' or zipCode = '72173' or zipCode = '72173' or zipCode = '72173' or zipCode = '72180' or zipCode = '72182' or zipCode = '72182' or zipCode = '72207' or zipCode = '72207' or zipCode = '72209' or zipCode = '72210' or zipCode = '72211' or zipCode = '72212' or zipCode = '72214' or zipCode = '72215' or zipCode = '72216' or zipCode = '72217' or zipCode = '72219' or zipCode = '72221' or zipCode = '72222' or zipCode = '72223' or zipCode = '72225' or zipCode = '72227' or zipCode = '72231' or zipCode = '72231' or zipCode = '72231' or zipCode = '72231' or zipCode = '72260' or zipCode = '72295' or zipCode = '72183' or zipCode = '72183' or zipCode = '72183' or zipCode = '72190' or zipCode = '72190' or zipCode = '72190' or zipCode = '72190' or zipCode = '72198' or zipCode = '72198' or zipCode = '72198' or zipCode = '72199' or zipCode = '72199' or zipCode = '72199' or zipCode = '72199' or zipCode = '72199' or zipCode = '72201' or zipCode = '72202' or zipCode = '72203' or zipCode = '72204' or zipCode = '72205' or zipCode = '72206' or zipCode = '72207' or zipCode = '72002' or zipCode = '72007' or zipCode = '72011' or zipCode = '72015' or zipCode = '72018' or zipCode = '72019' or zipCode = '72022' or zipCode = '72023' or zipCode = '72032' or zipCode = '72034' or zipCode = '72046' or zipCode = '72053' or zipCode = '72065' or zipCode = '72076' or zipCode = '72078' or zipCode = '72079' or zipCode = '72083' or zipCode = '72086' or zipCode = '72089' or zipCode = '72098' or zipCode = '72099' or zipCode = '72103' or zipCode = '72106' or zipCode = '72113' or zipCode = '72114' or zipCode = '72115' or zipCode = '72116' or zipCode = '72117' or zipCode = '72118' or zipCode = '72119' or zipCode = '72120' or zipCode = '72124' or zipCode = '72132' or zipCode = '72135' or zipCode = '72142' or zipCode = '72158' or zipCode = '72164' or zipCode = '72173' or zipCode = '72180' or zipCode = '72183' or zipCode = '72190' or zipCode = '72199' or zipCode = '72201' or zipCode = '72202' or zipCode = '72203' or zipCode = '72204' or zipCode = '72205' or zipCode = '72206' or zipCode = '72207' or zipCode = '72209' or zipCode = '72210' or zipCode = '72211' or zipCode = '72212' or zipCode = '72214' or zipCode = '72215' or zipCode = '72216' or zipCode = '72217' or zipCode = '72219' or zipCode = '72221' or zipCode = '72222' or zipCode = '72223' or zipCode = '72225' or zipCode = '72227' or zipCode = '72231' or zipCode = '72259' or zipCode = '72295' or zipCode = '72559') 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 ='72002' or zipCode = '72007' or zipCode = '72011' or zipCode = '72015' or zipCode = '72015' or zipCode = '72015' or zipCode = '72015' or zipCode = '72018' or zipCode = '72019' or zipCode = '72019' or zipCode = '72022' or zipCode = '72022' or zipCode = '72023' or zipCode = '72032' or zipCode = '72046' or zipCode = '72053' or zipCode = '72053' or zipCode = '72053' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72032' or zipCode = '72034' or zipCode = '72035' or zipCode = '72035' or zipCode = '72035' or zipCode = '72035' or zipCode = '72065' or zipCode = '72065' or zipCode = '72076' or zipCode = '72076' or zipCode = '72076' or zipCode = '72086' or zipCode = '72086' or zipCode = '72086' or zipCode = '72086' or zipCode = '72089' or zipCode = '72099' or zipCode = '72099' or zipCode = '72099' or zipCode = '72099' or zipCode = '72099' or zipCode = '72099' or zipCode = '72103' or zipCode = '72103' or zipCode = '72103' or zipCode = '72106' or zipCode = '72106' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72117' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72118' or zipCode = '72132' or zipCode = '72132' or zipCode = '72132' or zipCode = '72135' or zipCode = '72135' or zipCode = '72135' or zipCode = '72135' or zipCode = '72142' or zipCode = '72142' or zipCode = '72142' or zipCode = '72142' or zipCode = '72076' or zipCode = '72076' or zipCode = '72076' or zipCode = '72076' or zipCode = '72076' or zipCode = '72076' or zipCode = '72078' or zipCode = '72083' or zipCode = '72086' or zipCode = '72113' or zipCode = '72113' or zipCode = '72113' or zipCode = '72113' or zipCode = '72113' or zipCode = '72114' or zipCode = '72114' or zipCode = '72114' or zipCode = '72114' or zipCode = '72114' or zipCode = '72114' or zipCode = '72114' or zipCode = '72114' or zipCode = '72115' or zipCode = '72115' or zipCode = '72115' or zipCode = '72116' or zipCode = '72116' or zipCode = '72116' or zipCode = '72116' or zipCode = '72116' or zipCode = '72116' or zipCode = '72118' or zipCode = '72119' or zipCode = '72119' or zipCode = '72119' or zipCode = '72119' or zipCode = '72120' or zipCode = '72120' or zipCode = '72120' or zipCode = '72120' or zipCode = '72120' or zipCode = '72124' or zipCode = '72124' or zipCode = '72124' or zipCode = '72124' or zipCode = '72124' or zipCode = '72158' or zipCode = '72164' or zipCode = '72173' or zipCode = '72173' or zipCode = '72173' or zipCode = '72173' or zipCode = '72180' or zipCode = '72182' or zipCode = '72182' or zipCode = '72207' or zipCode = '72207' or zipCode = '72209' or zipCode = '72210' or zipCode = '72211' or zipCode = '72212' or zipCode = '72214' or zipCode = '72215' or zipCode = '72216' or zipCode = '72217' or zipCode = '72219' or zipCode = '72221' or zipCode = '72222' or zipCode = '72223' or zipCode = '72225' or zipCode = '72227' or zipCode = '72231' or zipCode = '72231' or zipCode = '72231' or zipCode = '72231' or zipCode = '72260' or zipCode = '72295' or zipCode = '72183' or zipCode = '72183' or zipCode = '72183' or zipCode = '72190' or zipCode = '72190' or zipCode = '72190' or zipCode = '72190' or zipCode = '72198' or zipCode = '72198' or zipCode = '72198' or zipCode = '72199' or zipCode = '72199' or zipCode = '72199' or zipCode = '72199' or zipCode = '72199' or zipCode = '72201' or zipCode = '72202' or zipCode = '72203' or zipCode = '72204' or zipCode = '72205' or zipCode = '72206' or zipCode = '72207' or zipCode = '72002' or zipCode = '72007' or zipCode = '72011' or zipCode = '72015' or zipCode = '72018' or zipCode = '72019' or zipCode = '72022' or zipCode = '72023' or zipCode = '72032' or zipCode = '72034' or zipCode = '72046' or zipCode = '72053' or zipCode = '72065' or zipCode = '72076' or zipCode = '72078' or zipCode = '72079' or zipCode = '72083' or zipCode = '72086' or zipCode = '72089' or zipCode = '72098' or zipCode = '72099' or zipCode = '72103' or zipCode = '72106' or zipCode = '72113' or zipCode = '72114' or zipCode = '72115' or zipCode = '72116' or zipCode = '72117' or zipCode = '72118' or zipCode = '72119' or zipCode = '72120' or zipCode = '72124' or zipCode = '72132' or zipCode = '72135' or zipCode = '72142' or zipCode = '72158' or zipCode = '72164' or zipCode = '72173' or zipCode = '72180' or zipCode = '72183' or zipCode = '72190' or zipCode = '72199' or zipCode = '72201' or zipCode = '72202' or zipCode = '72203' or zipCode = '72204' or zipCode = '72205' or zipCode = '72206' or zipCode = '72207' or zipCode = '72209' or zipCode = '72210' or zipCode = '72211' or zipCode = '72212' or zipCode = '72214' or zipCode = '72215' or zipCode = '72216' or zipCode = '72217' or zipCode = '72219' or zipCode = '72221' or zipCode = '72222' or zipCode = '72223' or zipCode = '72225' or zipCode = '72227' or zipCode = '72231' or zipCode = '72259' or zipCode = '72295' or zipCode = '72559') 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 ='72002' or property_zip = '72007' or property_zip = '72011' or property_zip = '72015' or property_zip = '72015' or property_zip = '72015' or property_zip = '72015' or property_zip = '72018' or property_zip = '72019' or property_zip = '72019' or property_zip = '72022' or property_zip = '72022' or property_zip = '72023' or property_zip = '72032' or property_zip = '72046' or property_zip = '72053' or property_zip = '72053' or property_zip = '72053' or property_zip = '72032' or property_zip = '72032' or property_zip = '72032' or property_zip = '72032' or property_zip = '72032' or property_zip = '72032' or property_zip = '72032' or property_zip = '72032' or property_zip = '72032' or property_zip = '72034' or property_zip = '72035' or property_zip = '72035' or property_zip = '72035' or property_zip = '72035' or property_zip = '72065' or property_zip = '72065' or property_zip = '72076' or property_zip = '72076' or property_zip = '72076' or property_zip = '72086' or property_zip = '72086' or property_zip = '72086' or property_zip = '72086' or property_zip = '72089' or property_zip = '72099' or property_zip = '72099' or property_zip = '72099' or property_zip = '72099' or property_zip = '72099' or property_zip = '72099' or property_zip = '72103' or property_zip = '72103' or property_zip = '72103' or property_zip = '72106' or property_zip = '72106' or property_zip = '72117' or property_zip = '72117' or property_zip = '72117' or property_zip = '72117' or property_zip = '72117' or property_zip = '72117' or property_zip = '72117' or property_zip = '72117' or property_zip = '72117' or property_zip = '72117' or property_zip = '72117' or property_zip = '72117' or property_zip = '72118' or property_zip = '72118' or property_zip = '72118' or property_zip = '72118' or property_zip = '72118' or property_zip = '72118' or property_zip = '72118' or property_zip = '72118' or property_zip = '72118' or property_zip = '72118' or property_zip = '72132' or property_zip = '72132' or property_zip = '72132' or property_zip = '72135' or property_zip = '72135' or property_zip = '72135' or property_zip = '72135' or property_zip = '72142' or property_zip = '72142' or property_zip = '72142' or property_zip = '72142' or property_zip = '72076' or property_zip = '72076' or property_zip = '72076' or property_zip = '72076' or property_zip = '72076' or property_zip = '72076' or property_zip = '72078' or property_zip = '72083' or property_zip = '72086' or property_zip = '72113' or property_zip = '72113' or property_zip = '72113' or property_zip = '72113' or property_zip = '72113' or property_zip = '72114' or property_zip = '72114' or property_zip = '72114' or property_zip = '72114' or property_zip = '72114' or property_zip = '72114' or property_zip = '72114' or property_zip = '72114' or property_zip = '72115' or property_zip = '72115' or property_zip = '72115' or property_zip = '72116' or property_zip = '72116' or property_zip = '72116' or property_zip = '72116' or property_zip = '72116' or property_zip = '72116' or property_zip = '72118' or property_zip = '72119' or property_zip = '72119' or property_zip = '72119' or property_zip = '72119' or property_zip = '72120' or property_zip = '72120' or property_zip = '72120' or property_zip = '72120' or property_zip = '72120' or property_zip = '72124' or property_zip = '72124' or property_zip = '72124' or property_zip = '72124' or property_zip = '72124' or property_zip = '72158' or property_zip = '72164' or property_zip = '72173' or property_zip = '72173' or property_zip = '72173' or property_zip = '72173' or property_zip = '72180' or property_zip = '72182' or property_zip = '72182' or property_zip = '72207' or property_zip = '72207' or property_zip = '72209' or property_zip = '72210' or property_zip = '72211' or property_zip = '72212' or property_zip = '72214' or property_zip = '72215' or property_zip = '72216' or property_zip = '72217' or property_zip = '72219' or property_zip = '72221' or property_zip = '72222' or property_zip = '72223' or property_zip = '72225' or property_zip = '72227' or property_zip = '72231' or property_zip = '72231' or property_zip = '72231' or property_zip = '72231' or property_zip = '72260' or property_zip = '72295' or property_zip = '72183' or property_zip = '72183' or property_zip = '72183' or property_zip = '72190' or property_zip = '72190' or property_zip = '72190' or property_zip = '72190' or property_zip = '72198' or property_zip = '72198' or property_zip = '72198' or property_zip = '72199' or property_zip = '72199' or property_zip = '72199' or property_zip = '72199' or property_zip = '72199' or property_zip = '72201' or property_zip = '72202' or property_zip = '72203' or property_zip = '72204' or property_zip = '72205' or property_zip = '72206' or property_zip = '72207' or property_zip = '72002' or property_zip = '72007' or property_zip = '72011' or property_zip = '72015' or property_zip = '72018' or property_zip = '72019' or property_zip = '72022' or property_zip = '72023' or property_zip = '72032' or property_zip = '72034' or property_zip = '72046' or property_zip = '72053' or property_zip = '72065' or property_zip = '72076' or property_zip = '72078' or property_zip = '72079' or property_zip = '72083' or property_zip = '72086' or property_zip = '72089' or property_zip = '72098' or property_zip = '72099' or property_zip = '72103' or property_zip = '72106' or property_zip = '72113' or property_zip = '72114' or property_zip = '72115' or property_zip = '72116' or property_zip = '72117' or property_zip = '72118' or property_zip = '72119' or property_zip = '72120' or property_zip = '72124' or property_zip = '72132' or property_zip = '72135' or property_zip = '72142' or property_zip = '72158' or property_zip = '72164' or property_zip = '72173' or property_zip = '72180' or property_zip = '72183' or property_zip = '72190' or property_zip = '72199' or property_zip = '72201' or property_zip = '72202' or property_zip = '72203' or property_zip = '72204' or property_zip = '72205' or property_zip = '72206' or property_zip = '72207' or property_zip = '72209' or property_zip = '72210' or property_zip = '72211' or property_zip = '72212' or property_zip = '72214' or property_zip = '72215' or property_zip = '72216' or property_zip = '72217' or property_zip = '72219' or property_zip = '72221' or property_zip = '72222' or property_zip = '72223' or property_zip = '72225' or property_zip = '72227' or property_zip = '72231' or property_zip = '72259' or property_zip = '72295' or property_zip = '72559') and convert(date,auction_start_date) >= '9/27/2021';
select top 45 * from currentforeclosures.tblAll NOLOCK where state = 'AR '
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 ='72002' or zip = '72007' or zip = '72011' or zip = '72015' or zip = '72015' or zip = '72015' or zip = '72015' or zip = '72018' or zip = '72019' or zip = '72019' or zip = '72022' or zip = '72022' or zip = '72023' or zip = '72032' or zip = '72046' or zip = '72053' or zip = '72053' or zip = '72053' or zip = '72032' or zip = '72032' or zip = '72032' or zip = '72032' or zip = '72032' or zip = '72032' or zip = '72032' or zip = '72032' or zip = '72032' or zip = '72034' or zip = '72035' or zip = '72035' or zip = '72035' or zip = '72035' or zip = '72065' or zip = '72065' or zip = '72076' or zip = '72076' or zip = '72076' or zip = '72086' or zip = '72086' or zip = '72086' or zip = '72086' or zip = '72089' or zip = '72099' or zip = '72099' or zip = '72099' or zip = '72099' or zip = '72099' or zip = '72099' or zip = '72103' or zip = '72103' or zip = '72103' or zip = '72106' or zip = '72106' or zip = '72117' or zip = '72117' or zip = '72117' or zip = '72117' or zip = '72117' or zip = '72117' or zip = '72117' or zip = '72117' or zip = '72117' or zip = '72117' or zip = '72117' or zip = '72117' or zip = '72118' or zip = '72118' or zip = '72118' or zip = '72118' or zip = '72118' or zip = '72118' or zip = '72118' or zip = '72118' or zip = '72118' or zip = '72118' or zip = '72132' or zip = '72132' or zip = '72132' or zip = '72135' or zip = '72135' or zip = '72135' or zip = '72135' or zip = '72142' or zip = '72142' or zip = '72142' or zip = '72142' or zip = '72076' or zip = '72076' or zip = '72076' or zip = '72076' or zip = '72076' or zip = '72076' or zip = '72078' or zip = '72083' or zip = '72086' or zip = '72113' or zip = '72113' or zip = '72113' or zip = '72113' or zip = '72113' or zip = '72114' or zip = '72114' or zip = '72114' or zip = '72114' or zip = '72114' or zip = '72114' or zip = '72114' or zip = '72114' or zip = '72115' or zip = '72115' or zip = '72115' or zip = '72116' or zip = '72116' or zip = '72116' or zip = '72116' or zip = '72116' or zip = '72116' or zip = '72118' or zip = '72119' or zip = '72119' or zip = '72119' or zip = '72119' or zip = '72120' or zip = '72120' or zip = '72120' or zip = '72120' or zip = '72120' or zip = '72124' or zip = '72124' or zip = '72124' or zip = '72124' or zip = '72124' or zip = '72158' or zip = '72164' or zip = '72173' or zip = '72173' or zip = '72173' or zip = '72173' or zip = '72180' or zip = '72182' or zip = '72182' or zip = '72207' or zip = '72207' or zip = '72209' or zip = '72210' or zip = '72211' or zip = '72212' or zip = '72214' or zip = '72215' or zip = '72216' or zip = '72217' or zip = '72219' or zip = '72221' or zip = '72222' or zip = '72223' or zip = '72225' or zip = '72227' or zip = '72231' or zip = '72231' or zip = '72231' or zip = '72231' or zip = '72260' or zip = '72295' or zip = '72183' or zip = '72183' or zip = '72183' or zip = '72190' or zip = '72190' or zip = '72190' or zip = '72190' or zip = '72198' or zip = '72198' or zip = '72198' or zip = '72199' or zip = '72199' or zip = '72199' or zip = '72199' or zip = '72199' or zip = '72201' or zip = '72202' or zip = '72203' or zip = '72204' or zip = '72205' or zip = '72206' or zip = '72207' or zip = '72002' or zip = '72007' or zip = '72011' or zip = '72015' or zip = '72018' or zip = '72019' or zip = '72022' or zip = '72023' or zip = '72032' or zip = '72034' or zip = '72046' or zip = '72053' or zip = '72065' or zip = '72076' or zip = '72078' or zip = '72079' or zip = '72083' or zip = '72086' or zip = '72089' or zip = '72098' or zip = '72099' or zip = '72103' or zip = '72106' or zip = '72113' or zip = '72114' or zip = '72115' or zip = '72116' or zip = '72117' or zip = '72118' or zip = '72119' or zip = '72120' or zip = '72124' or zip = '72132' or zip = '72135' or zip = '72142' or zip = '72158' or zip = '72164' or zip = '72173' or zip = '72180' or zip = '72183' or zip = '72190' or zip = '72199' or zip = '72201' or zip = '72202' or zip = '72203' or zip = '72204' or zip = '72205' or zip = '72206' or zip = '72207' or zip = '72209' or zip = '72210' or zip = '72211' or zip = '72212' or zip = '72214' or zip = '72215' or zip = '72216' or zip = '72217' or zip = '72219' or zip = '72221' or zip = '72222' or zip = '72223' or zip = '72225' or zip = '72227' or zip = '72231' or zip = '72259' or zip = '72295' or zip = '72559')
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 = 'AR' and city = 'LITTLE ROCK' and state = 'AR ' 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();