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


198+ High Potential Investor Deals Near charlotte [Refine]


********NOTICE: Displaying 99 of over 198 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 ='28006' or zipCode = '28012' or zipCode = '28012' or zipCode = '28023' or zipCode = '28025' or zipCode = '28025' or zipCode = '28025' or zipCode = '28025' or zipCode = '28025' or zipCode = '28026' or zipCode = '28027' or zipCode = '28052' or zipCode = '28052' or zipCode = '28052' or zipCode = '28053' or zipCode = '28054' or zipCode = '28054' or zipCode = '28054' or zipCode = '28054' or zipCode = '28055' or zipCode = '28056' or zipCode = '28070' or zipCode = '28075' or zipCode = '28077' or zipCode = '28078' or zipCode = '28078' or zipCode = '28078' or zipCode = '28078' or zipCode = '28097' or zipCode = '28097' or zipCode = '28098' or zipCode = '28101' or zipCode = '28104' or zipCode = '28104' or zipCode = '28104' or zipCode = '28104' or zipCode = '28105' or zipCode = '28106' or zipCode = '28107' or zipCode = '28108' or zipCode = '28108' or zipCode = '28110' or zipCode = '28111' or zipCode = '28115' or zipCode = '28115' or zipCode = '28115' or zipCode = '28115' or zipCode = '28117' or zipCode = '28120' or zipCode = '28120' or zipCode = '28123' or zipCode = '28123' or zipCode = '28124' or zipCode = '28124' or zipCode = '28126' or zipCode = '28163' or zipCode = '28164' or zipCode = '28164' or zipCode = '28173' or zipCode = '28173' or zipCode = '28201' or zipCode = '28202' or zipCode = '28227' or zipCode = '28227' or zipCode = '28228' or zipCode = '28228' or zipCode = '28229' or zipCode = '28230' or zipCode = '28231' or zipCode = '28232' or zipCode = '28233' or zipCode = '28234' or zipCode = '28235' or zipCode = '28236' or zipCode = '28237' or zipCode = '28241' or zipCode = '28242' or zipCode = '28242' or zipCode = '28243' or zipCode = '28243' or zipCode = '28244' or zipCode = '28246' or zipCode = '28247' or zipCode = '28250' or zipCode = '28250' or zipCode = '28031' or zipCode = '28032' or zipCode = '28034' or zipCode = '28035' or zipCode = '28035' or zipCode = '28036' or zipCode = '28037' or zipCode = '28052' or zipCode = '28052' or zipCode = '28052' or zipCode = '28052' or zipCode = '28052' or zipCode = '28052' or zipCode = '28079' or zipCode = '28079' or zipCode = '28079' or zipCode = '28079' or zipCode = '28079' or zipCode = '28080' or zipCode = '28081' or zipCode = '28081' or zipCode = '28081' or zipCode = '28081' or zipCode = '28081' or zipCode = '28081' or zipCode = '28082' or zipCode = '28083' or zipCode = '28088' or zipCode = '28130' or zipCode = '28134' or zipCode = '28203' or zipCode = '28204' or zipCode = '28205' or zipCode = '28206' or zipCode = '28207' or zipCode = '28208' or zipCode = '28209' or zipCode = '28210' or zipCode = '28211' or zipCode = '28212' or zipCode = '28213' or zipCode = '28214' or zipCode = '28215' or zipCode = '28216' or zipCode = '28217' or zipCode = '28218' or zipCode = '28219' or zipCode = '28220' or zipCode = '28221' or zipCode = '28222' or zipCode = '28223' or zipCode = '28224' or zipCode = '28226' or zipCode = '28253' or zipCode = '28253' or zipCode = '28254' or zipCode = '28255' or zipCode = '28255' or zipCode = '28255' or zipCode = '28256' or zipCode = '28258' or zipCode = '28258' or zipCode = '28260' or zipCode = '28262' or zipCode = '28263' or zipCode = '28263' or zipCode = '28265' or zipCode = '28266' or zipCode = '28269' or zipCode = '28270' or zipCode = '28271' or zipCode = '28272' or zipCode = '28273' or zipCode = '28274' or zipCode = '28274' or zipCode = '28275' or zipCode = '28277' or zipCode = '28278' or zipCode = '28280' or zipCode = '28281' or zipCode = '28282' or zipCode = '28284' or zipCode = '28285' or zipCode = '28287' or zipCode = '28288' or zipCode = '28288' or zipCode = '28289' or zipCode = '28289' or zipCode = '28290' or zipCode = '28290' or zipCode = '28296' or zipCode = '28296' or zipCode = '28297' or zipCode = '28299' or zipCode = '28682' or zipCode = '29703' or zipCode = '29707' or zipCode = '29707' or zipCode = '29707' or zipCode = '29708' or zipCode = '29708' or zipCode = '29708' or zipCode = '29715' or zipCode = '29716' or zipCode = '29744' or zipCode = '28006' or zipCode = '28012' or zipCode = '28023' or zipCode = '28025' or zipCode = '28026' or zipCode = '28027' or zipCode = '28031' or zipCode = '28032' or zipCode = '28034' or zipCode = '28036' or zipCode = '28037' or zipCode = '28051' or zipCode = '28052' or zipCode = '28053' or zipCode = '28054' or zipCode = '28055' or zipCode = '28056' or zipCode = '28070' or zipCode = '28075' or zipCode = '28077' or zipCode = '28078' or zipCode = '28079' or zipCode = '28080' or zipCode = '28081' or zipCode = '28082' or zipCode = '28083' or zipCode = '28088' or zipCode = '28097' or zipCode = '28098' or zipCode = '28101' or zipCode = '28104' or zipCode = '28105' or zipCode = '28106' or zipCode = '28107' or zipCode = '28110' or zipCode = '28111' or zipCode = '28115' or zipCode = '28117' or zipCode = '28120' or zipCode = '28123' or zipCode = '28124' or zipCode = '28126' or zipCode = '28130' or zipCode = '28134' or zipCode = '28163' or zipCode = '28164' or zipCode = '28173' or zipCode = '28201' or zipCode = '28202' or zipCode = '28203' or zipCode = '28204' or zipCode = '28205' or zipCode = '28206' or zipCode = '28207' or zipCode = '28208' or zipCode = '28209' or zipCode = '28210' or zipCode = '28211' or zipCode = '28212' or zipCode = '28213' or zipCode = '28214' or zipCode = '28215' or zipCode = '28216' or zipCode = '28217' or zipCode = '28218' or zipCode = '28219' or zipCode = '28220' or zipCode = '28221' or zipCode = '28222' or zipCode = '28223' or zipCode = '28224' or zipCode = '28225' or zipCode = '28226' or zipCode = '28227' or zipCode = '28228' or zipCode = '28229' or zipCode = '28230' or zipCode = '28231' or zipCode = '28232' or zipCode = '28233' or zipCode = '28234' or zipCode = '28235' or zipCode = '28236' or zipCode = '28237' or zipCode = '28240' or zipCode = '28241' or zipCode = '28242' or zipCode = '28243' or zipCode = '28244' or zipCode = '28246' or zipCode = '28247' or zipCode = '28250' or zipCode = '28253' or zipCode = '28254' or zipCode = '28255' or zipCode = '28256' or zipCode = '28258' or zipCode = '28260' or zipCode = '28261' or zipCode = '28262' or zipCode = '28265' or zipCode = '28266' or zipCode = '28269' or zipCode = '28270' or zipCode = '28272' or zipCode = '28273' or zipCode = '28274' or zipCode = '28275' or zipCode = '28277' or zipCode = '28278' or zipCode = '28280' or zipCode = '28281' or zipCode = '28282' or zipCode = '28283' or zipCode = '28284' or zipCode = '28285' or zipCode = '28286' or zipCode = '28287' or zipCode = '28288' or zipCode = '28289' or zipCode = '28290' or zipCode = '28296' or zipCode = '28297' or zipCode = '28299' or zipCode = '28682' or zipCode = '28687' or zipCode = '28688' or zipCode = '29708' or zipCode = '29710' or zipCode = '29715' or zipCode = '29716' or zipCode = '29732' or zipCode = '29744')
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 = 'NC' 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 ='28006' or zipCode = '28012' or zipCode = '28012' or zipCode = '28023' or zipCode = '28025' or zipCode = '28025' or zipCode = '28025' or zipCode = '28025' or zipCode = '28025' or zipCode = '28026' or zipCode = '28027' or zipCode = '28052' or zipCode = '28052' or zipCode = '28052' or zipCode = '28053' or zipCode = '28054' or zipCode = '28054' or zipCode = '28054' or zipCode = '28054' or zipCode = '28055' or zipCode = '28056' or zipCode = '28070' or zipCode = '28075' or zipCode = '28077' or zipCode = '28078' or zipCode = '28078' or zipCode = '28078' or zipCode = '28078' or zipCode = '28097' or zipCode = '28097' or zipCode = '28098' or zipCode = '28101' or zipCode = '28104' or zipCode = '28104' or zipCode = '28104' or zipCode = '28104' or zipCode = '28105' or zipCode = '28106' or zipCode = '28107' or zipCode = '28108' or zipCode = '28108' or zipCode = '28110' or zipCode = '28111' or zipCode = '28115' or zipCode = '28115' or zipCode = '28115' or zipCode = '28115' or zipCode = '28117' or zipCode = '28120' or zipCode = '28120' or zipCode = '28123' or zipCode = '28123' or zipCode = '28124' or zipCode = '28124' or zipCode = '28126' or zipCode = '28163' or zipCode = '28164' or zipCode = '28164' or zipCode = '28173' or zipCode = '28173' or zipCode = '28201' or zipCode = '28202' or zipCode = '28227' or zipCode = '28227' or zipCode = '28228' or zipCode = '28228' or zipCode = '28229' or zipCode = '28230' or zipCode = '28231' or zipCode = '28232' or zipCode = '28233' or zipCode = '28234' or zipCode = '28235' or zipCode = '28236' or zipCode = '28237' or zipCode = '28241' or zipCode = '28242' or zipCode = '28242' or zipCode = '28243' or zipCode = '28243' or zipCode = '28244' or zipCode = '28246' or zipCode = '28247' or zipCode = '28250' or zipCode = '28250' or zipCode = '28031' or zipCode = '28032' or zipCode = '28034' or zipCode = '28035' or zipCode = '28035' or zipCode = '28036' or zipCode = '28037' or zipCode = '28052' or zipCode = '28052' or zipCode = '28052' or zipCode = '28052' or zipCode = '28052' or zipCode = '28052' or zipCode = '28079' or zipCode = '28079' or zipCode = '28079' or zipCode = '28079' or zipCode = '28079' or zipCode = '28080' or zipCode = '28081' or zipCode = '28081' or zipCode = '28081' or zipCode = '28081' or zipCode = '28081' or zipCode = '28081' or zipCode = '28082' or zipCode = '28083' or zipCode = '28088' or zipCode = '28130' or zipCode = '28134' or zipCode = '28203' or zipCode = '28204' or zipCode = '28205' or zipCode = '28206' or zipCode = '28207' or zipCode = '28208' or zipCode = '28209' or zipCode = '28210' or zipCode = '28211' or zipCode = '28212' or zipCode = '28213' or zipCode = '28214' or zipCode = '28215' or zipCode = '28216' or zipCode = '28217' or zipCode = '28218' or zipCode = '28219' or zipCode = '28220' or zipCode = '28221' or zipCode = '28222' or zipCode = '28223' or zipCode = '28224' or zipCode = '28226' or zipCode = '28253' or zipCode = '28253' or zipCode = '28254' or zipCode = '28255' or zipCode = '28255' or zipCode = '28255' or zipCode = '28256' or zipCode = '28258' or zipCode = '28258' or zipCode = '28260' or zipCode = '28262' or zipCode = '28263' or zipCode = '28263' or zipCode = '28265' or zipCode = '28266' or zipCode = '28269' or zipCode = '28270' or zipCode = '28271' or zipCode = '28272' or zipCode = '28273' or zipCode = '28274' or zipCode = '28274' or zipCode = '28275' or zipCode = '28277' or zipCode = '28278' or zipCode = '28280' or zipCode = '28281' or zipCode = '28282' or zipCode = '28284' or zipCode = '28285' or zipCode = '28287' or zipCode = '28288' or zipCode = '28288' or zipCode = '28289' or zipCode = '28289' or zipCode = '28290' or zipCode = '28290' or zipCode = '28296' or zipCode = '28296' or zipCode = '28297' or zipCode = '28299' or zipCode = '28682' or zipCode = '29703' or zipCode = '29707' or zipCode = '29707' or zipCode = '29707' or zipCode = '29708' or zipCode = '29708' or zipCode = '29708' or zipCode = '29715' or zipCode = '29716' or zipCode = '29744' or zipCode = '28006' or zipCode = '28012' or zipCode = '28023' or zipCode = '28025' or zipCode = '28026' or zipCode = '28027' or zipCode = '28031' or zipCode = '28032' or zipCode = '28034' or zipCode = '28036' or zipCode = '28037' or zipCode = '28051' or zipCode = '28052' or zipCode = '28053' or zipCode = '28054' or zipCode = '28055' or zipCode = '28056' or zipCode = '28070' or zipCode = '28075' or zipCode = '28077' or zipCode = '28078' or zipCode = '28079' or zipCode = '28080' or zipCode = '28081' or zipCode = '28082' or zipCode = '28083' or zipCode = '28088' or zipCode = '28097' or zipCode = '28098' or zipCode = '28101' or zipCode = '28104' or zipCode = '28105' or zipCode = '28106' or zipCode = '28107' or zipCode = '28110' or zipCode = '28111' or zipCode = '28115' or zipCode = '28117' or zipCode = '28120' or zipCode = '28123' or zipCode = '28124' or zipCode = '28126' or zipCode = '28130' or zipCode = '28134' or zipCode = '28163' or zipCode = '28164' or zipCode = '28173' or zipCode = '28201' or zipCode = '28202' or zipCode = '28203' or zipCode = '28204' or zipCode = '28205' or zipCode = '28206' or zipCode = '28207' or zipCode = '28208' or zipCode = '28209' or zipCode = '28210' or zipCode = '28211' or zipCode = '28212' or zipCode = '28213' or zipCode = '28214' or zipCode = '28215' or zipCode = '28216' or zipCode = '28217' or zipCode = '28218' or zipCode = '28219' or zipCode = '28220' or zipCode = '28221' or zipCode = '28222' or zipCode = '28223' or zipCode = '28224' or zipCode = '28225' or zipCode = '28226' or zipCode = '28227' or zipCode = '28228' or zipCode = '28229' or zipCode = '28230' or zipCode = '28231' or zipCode = '28232' or zipCode = '28233' or zipCode = '28234' or zipCode = '28235' or zipCode = '28236' or zipCode = '28237' or zipCode = '28240' or zipCode = '28241' or zipCode = '28242' or zipCode = '28243' or zipCode = '28244' or zipCode = '28246' or zipCode = '28247' or zipCode = '28250' or zipCode = '28253' or zipCode = '28254' or zipCode = '28255' or zipCode = '28256' or zipCode = '28258' or zipCode = '28260' or zipCode = '28261' or zipCode = '28262' or zipCode = '28265' or zipCode = '28266' or zipCode = '28269' or zipCode = '28270' or zipCode = '28272' or zipCode = '28273' or zipCode = '28274' or zipCode = '28275' or zipCode = '28277' or zipCode = '28278' or zipCode = '28280' or zipCode = '28281' or zipCode = '28282' or zipCode = '28283' or zipCode = '28284' or zipCode = '28285' or zipCode = '28286' or zipCode = '28287' or zipCode = '28288' or zipCode = '28289' or zipCode = '28290' or zipCode = '28296' or zipCode = '28297' or zipCode = '28299' or zipCode = '28682' or zipCode = '28687' or zipCode = '28688' or zipCode = '29708' or zipCode = '29710' or zipCode = '29715' or zipCode = '29716' or zipCode = '29732' or zipCode = '29744') 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 ='28006' or zipCode = '28012' or zipCode = '28012' or zipCode = '28023' or zipCode = '28025' or zipCode = '28025' or zipCode = '28025' or zipCode = '28025' or zipCode = '28025' or zipCode = '28026' or zipCode = '28027' or zipCode = '28052' or zipCode = '28052' or zipCode = '28052' or zipCode = '28053' or zipCode = '28054' or zipCode = '28054' or zipCode = '28054' or zipCode = '28054' or zipCode = '28055' or zipCode = '28056' or zipCode = '28070' or zipCode = '28075' or zipCode = '28077' or zipCode = '28078' or zipCode = '28078' or zipCode = '28078' or zipCode = '28078' or zipCode = '28097' or zipCode = '28097' or zipCode = '28098' or zipCode = '28101' or zipCode = '28104' or zipCode = '28104' or zipCode = '28104' or zipCode = '28104' or zipCode = '28105' or zipCode = '28106' or zipCode = '28107' or zipCode = '28108' or zipCode = '28108' or zipCode = '28110' or zipCode = '28111' or zipCode = '28115' or zipCode = '28115' or zipCode = '28115' or zipCode = '28115' or zipCode = '28117' or zipCode = '28120' or zipCode = '28120' or zipCode = '28123' or zipCode = '28123' or zipCode = '28124' or zipCode = '28124' or zipCode = '28126' or zipCode = '28163' or zipCode = '28164' or zipCode = '28164' or zipCode = '28173' or zipCode = '28173' or zipCode = '28201' or zipCode = '28202' or zipCode = '28227' or zipCode = '28227' or zipCode = '28228' or zipCode = '28228' or zipCode = '28229' or zipCode = '28230' or zipCode = '28231' or zipCode = '28232' or zipCode = '28233' or zipCode = '28234' or zipCode = '28235' or zipCode = '28236' or zipCode = '28237' or zipCode = '28241' or zipCode = '28242' or zipCode = '28242' or zipCode = '28243' or zipCode = '28243' or zipCode = '28244' or zipCode = '28246' or zipCode = '28247' or zipCode = '28250' or zipCode = '28250' or zipCode = '28031' or zipCode = '28032' or zipCode = '28034' or zipCode = '28035' or zipCode = '28035' or zipCode = '28036' or zipCode = '28037' or zipCode = '28052' or zipCode = '28052' or zipCode = '28052' or zipCode = '28052' or zipCode = '28052' or zipCode = '28052' or zipCode = '28079' or zipCode = '28079' or zipCode = '28079' or zipCode = '28079' or zipCode = '28079' or zipCode = '28080' or zipCode = '28081' or zipCode = '28081' or zipCode = '28081' or zipCode = '28081' or zipCode = '28081' or zipCode = '28081' or zipCode = '28082' or zipCode = '28083' or zipCode = '28088' or zipCode = '28130' or zipCode = '28134' or zipCode = '28203' or zipCode = '28204' or zipCode = '28205' or zipCode = '28206' or zipCode = '28207' or zipCode = '28208' or zipCode = '28209' or zipCode = '28210' or zipCode = '28211' or zipCode = '28212' or zipCode = '28213' or zipCode = '28214' or zipCode = '28215' or zipCode = '28216' or zipCode = '28217' or zipCode = '28218' or zipCode = '28219' or zipCode = '28220' or zipCode = '28221' or zipCode = '28222' or zipCode = '28223' or zipCode = '28224' or zipCode = '28226' or zipCode = '28253' or zipCode = '28253' or zipCode = '28254' or zipCode = '28255' or zipCode = '28255' or zipCode = '28255' or zipCode = '28256' or zipCode = '28258' or zipCode = '28258' or zipCode = '28260' or zipCode = '28262' or zipCode = '28263' or zipCode = '28263' or zipCode = '28265' or zipCode = '28266' or zipCode = '28269' or zipCode = '28270' or zipCode = '28271' or zipCode = '28272' or zipCode = '28273' or zipCode = '28274' or zipCode = '28274' or zipCode = '28275' or zipCode = '28277' or zipCode = '28278' or zipCode = '28280' or zipCode = '28281' or zipCode = '28282' or zipCode = '28284' or zipCode = '28285' or zipCode = '28287' or zipCode = '28288' or zipCode = '28288' or zipCode = '28289' or zipCode = '28289' or zipCode = '28290' or zipCode = '28290' or zipCode = '28296' or zipCode = '28296' or zipCode = '28297' or zipCode = '28299' or zipCode = '28682' or zipCode = '29703' or zipCode = '29707' or zipCode = '29707' or zipCode = '29707' or zipCode = '29708' or zipCode = '29708' or zipCode = '29708' or zipCode = '29715' or zipCode = '29716' or zipCode = '29744' or zipCode = '28006' or zipCode = '28012' or zipCode = '28023' or zipCode = '28025' or zipCode = '28026' or zipCode = '28027' or zipCode = '28031' or zipCode = '28032' or zipCode = '28034' or zipCode = '28036' or zipCode = '28037' or zipCode = '28051' or zipCode = '28052' or zipCode = '28053' or zipCode = '28054' or zipCode = '28055' or zipCode = '28056' or zipCode = '28070' or zipCode = '28075' or zipCode = '28077' or zipCode = '28078' or zipCode = '28079' or zipCode = '28080' or zipCode = '28081' or zipCode = '28082' or zipCode = '28083' or zipCode = '28088' or zipCode = '28097' or zipCode = '28098' or zipCode = '28101' or zipCode = '28104' or zipCode = '28105' or zipCode = '28106' or zipCode = '28107' or zipCode = '28110' or zipCode = '28111' or zipCode = '28115' or zipCode = '28117' or zipCode = '28120' or zipCode = '28123' or zipCode = '28124' or zipCode = '28126' or zipCode = '28130' or zipCode = '28134' or zipCode = '28163' or zipCode = '28164' or zipCode = '28173' or zipCode = '28201' or zipCode = '28202' or zipCode = '28203' or zipCode = '28204' or zipCode = '28205' or zipCode = '28206' or zipCode = '28207' or zipCode = '28208' or zipCode = '28209' or zipCode = '28210' or zipCode = '28211' or zipCode = '28212' or zipCode = '28213' or zipCode = '28214' or zipCode = '28215' or zipCode = '28216' or zipCode = '28217' or zipCode = '28218' or zipCode = '28219' or zipCode = '28220' or zipCode = '28221' or zipCode = '28222' or zipCode = '28223' or zipCode = '28224' or zipCode = '28225' or zipCode = '28226' or zipCode = '28227' or zipCode = '28228' or zipCode = '28229' or zipCode = '28230' or zipCode = '28231' or zipCode = '28232' or zipCode = '28233' or zipCode = '28234' or zipCode = '28235' or zipCode = '28236' or zipCode = '28237' or zipCode = '28240' or zipCode = '28241' or zipCode = '28242' or zipCode = '28243' or zipCode = '28244' or zipCode = '28246' or zipCode = '28247' or zipCode = '28250' or zipCode = '28253' or zipCode = '28254' or zipCode = '28255' or zipCode = '28256' or zipCode = '28258' or zipCode = '28260' or zipCode = '28261' or zipCode = '28262' or zipCode = '28265' or zipCode = '28266' or zipCode = '28269' or zipCode = '28270' or zipCode = '28272' or zipCode = '28273' or zipCode = '28274' or zipCode = '28275' or zipCode = '28277' or zipCode = '28278' or zipCode = '28280' or zipCode = '28281' or zipCode = '28282' or zipCode = '28283' or zipCode = '28284' or zipCode = '28285' or zipCode = '28286' or zipCode = '28287' or zipCode = '28288' or zipCode = '28289' or zipCode = '28290' or zipCode = '28296' or zipCode = '28297' or zipCode = '28299' or zipCode = '28682' or zipCode = '28687' or zipCode = '28688' or zipCode = '29708' or zipCode = '29710' or zipCode = '29715' or zipCode = '29716' or zipCode = '29732' or zipCode = '29744') 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 ='28006' or zipCode = '28012' or zipCode = '28012' or zipCode = '28023' or zipCode = '28025' or zipCode = '28025' or zipCode = '28025' or zipCode = '28025' or zipCode = '28025' or zipCode = '28026' or zipCode = '28027' or zipCode = '28052' or zipCode = '28052' or zipCode = '28052' or zipCode = '28053' or zipCode = '28054' or zipCode = '28054' or zipCode = '28054' or zipCode = '28054' or zipCode = '28055' or zipCode = '28056' or zipCode = '28070' or zipCode = '28075' or zipCode = '28077' or zipCode = '28078' or zipCode = '28078' or zipCode = '28078' or zipCode = '28078' or zipCode = '28097' or zipCode = '28097' or zipCode = '28098' or zipCode = '28101' or zipCode = '28104' or zipCode = '28104' or zipCode = '28104' or zipCode = '28104' or zipCode = '28105' or zipCode = '28106' or zipCode = '28107' or zipCode = '28108' or zipCode = '28108' or zipCode = '28110' or zipCode = '28111' or zipCode = '28115' or zipCode = '28115' or zipCode = '28115' or zipCode = '28115' or zipCode = '28117' or zipCode = '28120' or zipCode = '28120' or zipCode = '28123' or zipCode = '28123' or zipCode = '28124' or zipCode = '28124' or zipCode = '28126' or zipCode = '28163' or zipCode = '28164' or zipCode = '28164' or zipCode = '28173' or zipCode = '28173' or zipCode = '28201' or zipCode = '28202' or zipCode = '28227' or zipCode = '28227' or zipCode = '28228' or zipCode = '28228' or zipCode = '28229' or zipCode = '28230' or zipCode = '28231' or zipCode = '28232' or zipCode = '28233' or zipCode = '28234' or zipCode = '28235' or zipCode = '28236' or zipCode = '28237' or zipCode = '28241' or zipCode = '28242' or zipCode = '28242' or zipCode = '28243' or zipCode = '28243' or zipCode = '28244' or zipCode = '28246' or zipCode = '28247' or zipCode = '28250' or zipCode = '28250' or zipCode = '28031' or zipCode = '28032' or zipCode = '28034' or zipCode = '28035' or zipCode = '28035' or zipCode = '28036' or zipCode = '28037' or zipCode = '28052' or zipCode = '28052' or zipCode = '28052' or zipCode = '28052' or zipCode = '28052' or zipCode = '28052' or zipCode = '28079' or zipCode = '28079' or zipCode = '28079' or zipCode = '28079' or zipCode = '28079' or zipCode = '28080' or zipCode = '28081' or zipCode = '28081' or zipCode = '28081' or zipCode = '28081' or zipCode = '28081' or zipCode = '28081' or zipCode = '28082' or zipCode = '28083' or zipCode = '28088' or zipCode = '28130' or zipCode = '28134' or zipCode = '28203' or zipCode = '28204' or zipCode = '28205' or zipCode = '28206' or zipCode = '28207' or zipCode = '28208' or zipCode = '28209' or zipCode = '28210' or zipCode = '28211' or zipCode = '28212' or zipCode = '28213' or zipCode = '28214' or zipCode = '28215' or zipCode = '28216' or zipCode = '28217' or zipCode = '28218' or zipCode = '28219' or zipCode = '28220' or zipCode = '28221' or zipCode = '28222' or zipCode = '28223' or zipCode = '28224' or zipCode = '28226' or zipCode = '28253' or zipCode = '28253' or zipCode = '28254' or zipCode = '28255' or zipCode = '28255' or zipCode = '28255' or zipCode = '28256' or zipCode = '28258' or zipCode = '28258' or zipCode = '28260' or zipCode = '28262' or zipCode = '28263' or zipCode = '28263' or zipCode = '28265' or zipCode = '28266' or zipCode = '28269' or zipCode = '28270' or zipCode = '28271' or zipCode = '28272' or zipCode = '28273' or zipCode = '28274' or zipCode = '28274' or zipCode = '28275' or zipCode = '28277' or zipCode = '28278' or zipCode = '28280' or zipCode = '28281' or zipCode = '28282' or zipCode = '28284' or zipCode = '28285' or zipCode = '28287' or zipCode = '28288' or zipCode = '28288' or zipCode = '28289' or zipCode = '28289' or zipCode = '28290' or zipCode = '28290' or zipCode = '28296' or zipCode = '28296' or zipCode = '28297' or zipCode = '28299' or zipCode = '28682' or zipCode = '29703' or zipCode = '29707' or zipCode = '29707' or zipCode = '29707' or zipCode = '29708' or zipCode = '29708' or zipCode = '29708' or zipCode = '29715' or zipCode = '29716' or zipCode = '29744' or zipCode = '28006' or zipCode = '28012' or zipCode = '28023' or zipCode = '28025' or zipCode = '28026' or zipCode = '28027' or zipCode = '28031' or zipCode = '28032' or zipCode = '28034' or zipCode = '28036' or zipCode = '28037' or zipCode = '28051' or zipCode = '28052' or zipCode = '28053' or zipCode = '28054' or zipCode = '28055' or zipCode = '28056' or zipCode = '28070' or zipCode = '28075' or zipCode = '28077' or zipCode = '28078' or zipCode = '28079' or zipCode = '28080' or zipCode = '28081' or zipCode = '28082' or zipCode = '28083' or zipCode = '28088' or zipCode = '28097' or zipCode = '28098' or zipCode = '28101' or zipCode = '28104' or zipCode = '28105' or zipCode = '28106' or zipCode = '28107' or zipCode = '28110' or zipCode = '28111' or zipCode = '28115' or zipCode = '28117' or zipCode = '28120' or zipCode = '28123' or zipCode = '28124' or zipCode = '28126' or zipCode = '28130' or zipCode = '28134' or zipCode = '28163' or zipCode = '28164' or zipCode = '28173' or zipCode = '28201' or zipCode = '28202' or zipCode = '28203' or zipCode = '28204' or zipCode = '28205' or zipCode = '28206' or zipCode = '28207' or zipCode = '28208' or zipCode = '28209' or zipCode = '28210' or zipCode = '28211' or zipCode = '28212' or zipCode = '28213' or zipCode = '28214' or zipCode = '28215' or zipCode = '28216' or zipCode = '28217' or zipCode = '28218' or zipCode = '28219' or zipCode = '28220' or zipCode = '28221' or zipCode = '28222' or zipCode = '28223' or zipCode = '28224' or zipCode = '28225' or zipCode = '28226' or zipCode = '28227' or zipCode = '28228' or zipCode = '28229' or zipCode = '28230' or zipCode = '28231' or zipCode = '28232' or zipCode = '28233' or zipCode = '28234' or zipCode = '28235' or zipCode = '28236' or zipCode = '28237' or zipCode = '28240' or zipCode = '28241' or zipCode = '28242' or zipCode = '28243' or zipCode = '28244' or zipCode = '28246' or zipCode = '28247' or zipCode = '28250' or zipCode = '28253' or zipCode = '28254' or zipCode = '28255' or zipCode = '28256' or zipCode = '28258' or zipCode = '28260' or zipCode = '28261' or zipCode = '28262' or zipCode = '28265' or zipCode = '28266' or zipCode = '28269' or zipCode = '28270' or zipCode = '28272' or zipCode = '28273' or zipCode = '28274' or zipCode = '28275' or zipCode = '28277' or zipCode = '28278' or zipCode = '28280' or zipCode = '28281' or zipCode = '28282' or zipCode = '28283' or zipCode = '28284' or zipCode = '28285' or zipCode = '28286' or zipCode = '28287' or zipCode = '28288' or zipCode = '28289' or zipCode = '28290' or zipCode = '28296' or zipCode = '28297' or zipCode = '28299' or zipCode = '28682' or zipCode = '28687' or zipCode = '28688' or zipCode = '29708' or zipCode = '29710' or zipCode = '29715' or zipCode = '29716' or zipCode = '29732' or zipCode = '29744') 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 ='28006' or zipCode = '28012' or zipCode = '28012' or zipCode = '28023' or zipCode = '28025' or zipCode = '28025' or zipCode = '28025' or zipCode = '28025' or zipCode = '28025' or zipCode = '28026' or zipCode = '28027' or zipCode = '28052' or zipCode = '28052' or zipCode = '28052' or zipCode = '28053' or zipCode = '28054' or zipCode = '28054' or zipCode = '28054' or zipCode = '28054' or zipCode = '28055' or zipCode = '28056' or zipCode = '28070' or zipCode = '28075' or zipCode = '28077' or zipCode = '28078' or zipCode = '28078' or zipCode = '28078' or zipCode = '28078' or zipCode = '28097' or zipCode = '28097' or zipCode = '28098' or zipCode = '28101' or zipCode = '28104' or zipCode = '28104' or zipCode = '28104' or zipCode = '28104' or zipCode = '28105' or zipCode = '28106' or zipCode = '28107' or zipCode = '28108' or zipCode = '28108' or zipCode = '28110' or zipCode = '28111' or zipCode = '28115' or zipCode = '28115' or zipCode = '28115' or zipCode = '28115' or zipCode = '28117' or zipCode = '28120' or zipCode = '28120' or zipCode = '28123' or zipCode = '28123' or zipCode = '28124' or zipCode = '28124' or zipCode = '28126' or zipCode = '28163' or zipCode = '28164' or zipCode = '28164' or zipCode = '28173' or zipCode = '28173' or zipCode = '28201' or zipCode = '28202' or zipCode = '28227' or zipCode = '28227' or zipCode = '28228' or zipCode = '28228' or zipCode = '28229' or zipCode = '28230' or zipCode = '28231' or zipCode = '28232' or zipCode = '28233' or zipCode = '28234' or zipCode = '28235' or zipCode = '28236' or zipCode = '28237' or zipCode = '28241' or zipCode = '28242' or zipCode = '28242' or zipCode = '28243' or zipCode = '28243' or zipCode = '28244' or zipCode = '28246' or zipCode = '28247' or zipCode = '28250' or zipCode = '28250' or zipCode = '28031' or zipCode = '28032' or zipCode = '28034' or zipCode = '28035' or zipCode = '28035' or zipCode = '28036' or zipCode = '28037' or zipCode = '28052' or zipCode = '28052' or zipCode = '28052' or zipCode = '28052' or zipCode = '28052' or zipCode = '28052' or zipCode = '28079' or zipCode = '28079' or zipCode = '28079' or zipCode = '28079' or zipCode = '28079' or zipCode = '28080' or zipCode = '28081' or zipCode = '28081' or zipCode = '28081' or zipCode = '28081' or zipCode = '28081' or zipCode = '28081' or zipCode = '28082' or zipCode = '28083' or zipCode = '28088' or zipCode = '28130' or zipCode = '28134' or zipCode = '28203' or zipCode = '28204' or zipCode = '28205' or zipCode = '28206' or zipCode = '28207' or zipCode = '28208' or zipCode = '28209' or zipCode = '28210' or zipCode = '28211' or zipCode = '28212' or zipCode = '28213' or zipCode = '28214' or zipCode = '28215' or zipCode = '28216' or zipCode = '28217' or zipCode = '28218' or zipCode = '28219' or zipCode = '28220' or zipCode = '28221' or zipCode = '28222' or zipCode = '28223' or zipCode = '28224' or zipCode = '28226' or zipCode = '28253' or zipCode = '28253' or zipCode = '28254' or zipCode = '28255' or zipCode = '28255' or zipCode = '28255' or zipCode = '28256' or zipCode = '28258' or zipCode = '28258' or zipCode = '28260' or zipCode = '28262' or zipCode = '28263' or zipCode = '28263' or zipCode = '28265' or zipCode = '28266' or zipCode = '28269' or zipCode = '28270' or zipCode = '28271' or zipCode = '28272' or zipCode = '28273' or zipCode = '28274' or zipCode = '28274' or zipCode = '28275' or zipCode = '28277' or zipCode = '28278' or zipCode = '28280' or zipCode = '28281' or zipCode = '28282' or zipCode = '28284' or zipCode = '28285' or zipCode = '28287' or zipCode = '28288' or zipCode = '28288' or zipCode = '28289' or zipCode = '28289' or zipCode = '28290' or zipCode = '28290' or zipCode = '28296' or zipCode = '28296' or zipCode = '28297' or zipCode = '28299' or zipCode = '28682' or zipCode = '29703' or zipCode = '29707' or zipCode = '29707' or zipCode = '29707' or zipCode = '29708' or zipCode = '29708' or zipCode = '29708' or zipCode = '29715' or zipCode = '29716' or zipCode = '29744' or zipCode = '28006' or zipCode = '28012' or zipCode = '28023' or zipCode = '28025' or zipCode = '28026' or zipCode = '28027' or zipCode = '28031' or zipCode = '28032' or zipCode = '28034' or zipCode = '28036' or zipCode = '28037' or zipCode = '28051' or zipCode = '28052' or zipCode = '28053' or zipCode = '28054' or zipCode = '28055' or zipCode = '28056' or zipCode = '28070' or zipCode = '28075' or zipCode = '28077' or zipCode = '28078' or zipCode = '28079' or zipCode = '28080' or zipCode = '28081' or zipCode = '28082' or zipCode = '28083' or zipCode = '28088' or zipCode = '28097' or zipCode = '28098' or zipCode = '28101' or zipCode = '28104' or zipCode = '28105' or zipCode = '28106' or zipCode = '28107' or zipCode = '28110' or zipCode = '28111' or zipCode = '28115' or zipCode = '28117' or zipCode = '28120' or zipCode = '28123' or zipCode = '28124' or zipCode = '28126' or zipCode = '28130' or zipCode = '28134' or zipCode = '28163' or zipCode = '28164' or zipCode = '28173' or zipCode = '28201' or zipCode = '28202' or zipCode = '28203' or zipCode = '28204' or zipCode = '28205' or zipCode = '28206' or zipCode = '28207' or zipCode = '28208' or zipCode = '28209' or zipCode = '28210' or zipCode = '28211' or zipCode = '28212' or zipCode = '28213' or zipCode = '28214' or zipCode = '28215' or zipCode = '28216' or zipCode = '28217' or zipCode = '28218' or zipCode = '28219' or zipCode = '28220' or zipCode = '28221' or zipCode = '28222' or zipCode = '28223' or zipCode = '28224' or zipCode = '28225' or zipCode = '28226' or zipCode = '28227' or zipCode = '28228' or zipCode = '28229' or zipCode = '28230' or zipCode = '28231' or zipCode = '28232' or zipCode = '28233' or zipCode = '28234' or zipCode = '28235' or zipCode = '28236' or zipCode = '28237' or zipCode = '28240' or zipCode = '28241' or zipCode = '28242' or zipCode = '28243' or zipCode = '28244' or zipCode = '28246' or zipCode = '28247' or zipCode = '28250' or zipCode = '28253' or zipCode = '28254' or zipCode = '28255' or zipCode = '28256' or zipCode = '28258' or zipCode = '28260' or zipCode = '28261' or zipCode = '28262' or zipCode = '28265' or zipCode = '28266' or zipCode = '28269' or zipCode = '28270' or zipCode = '28272' or zipCode = '28273' or zipCode = '28274' or zipCode = '28275' or zipCode = '28277' or zipCode = '28278' or zipCode = '28280' or zipCode = '28281' or zipCode = '28282' or zipCode = '28283' or zipCode = '28284' or zipCode = '28285' or zipCode = '28286' or zipCode = '28287' or zipCode = '28288' or zipCode = '28289' or zipCode = '28290' or zipCode = '28296' or zipCode = '28297' or zipCode = '28299' or zipCode = '28682' or zipCode = '28687' or zipCode = '28688' or zipCode = '29708' or zipCode = '29710' or zipCode = '29715' or zipCode = '29716' or zipCode = '29732' or zipCode = '29744') 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 ='28006' or zipCode = '28012' or zipCode = '28012' or zipCode = '28023' or zipCode = '28025' or zipCode = '28025' or zipCode = '28025' or zipCode = '28025' or zipCode = '28025' or zipCode = '28026' or zipCode = '28027' or zipCode = '28052' or zipCode = '28052' or zipCode = '28052' or zipCode = '28053' or zipCode = '28054' or zipCode = '28054' or zipCode = '28054' or zipCode = '28054' or zipCode = '28055' or zipCode = '28056' or zipCode = '28070' or zipCode = '28075' or zipCode = '28077' or zipCode = '28078' or zipCode = '28078' or zipCode = '28078' or zipCode = '28078' or zipCode = '28097' or zipCode = '28097' or zipCode = '28098' or zipCode = '28101' or zipCode = '28104' or zipCode = '28104' or zipCode = '28104' or zipCode = '28104' or zipCode = '28105' or zipCode = '28106' or zipCode = '28107' or zipCode = '28108' or zipCode = '28108' or zipCode = '28110' or zipCode = '28111' or zipCode = '28115' or zipCode = '28115' or zipCode = '28115' or zipCode = '28115' or zipCode = '28117' or zipCode = '28120' or zipCode = '28120' or zipCode = '28123' or zipCode = '28123' or zipCode = '28124' or zipCode = '28124' or zipCode = '28126' or zipCode = '28163' or zipCode = '28164' or zipCode = '28164' or zipCode = '28173' or zipCode = '28173' or zipCode = '28201' or zipCode = '28202' or zipCode = '28227' or zipCode = '28227' or zipCode = '28228' or zipCode = '28228' or zipCode = '28229' or zipCode = '28230' or zipCode = '28231' or zipCode = '28232' or zipCode = '28233' or zipCode = '28234' or zipCode = '28235' or zipCode = '28236' or zipCode = '28237' or zipCode = '28241' or zipCode = '28242' or zipCode = '28242' or zipCode = '28243' or zipCode = '28243' or zipCode = '28244' or zipCode = '28246' or zipCode = '28247' or zipCode = '28250' or zipCode = '28250' or zipCode = '28031' or zipCode = '28032' or zipCode = '28034' or zipCode = '28035' or zipCode = '28035' or zipCode = '28036' or zipCode = '28037' or zipCode = '28052' or zipCode = '28052' or zipCode = '28052' or zipCode = '28052' or zipCode = '28052' or zipCode = '28052' or zipCode = '28079' or zipCode = '28079' or zipCode = '28079' or zipCode = '28079' or zipCode = '28079' or zipCode = '28080' or zipCode = '28081' or zipCode = '28081' or zipCode = '28081' or zipCode = '28081' or zipCode = '28081' or zipCode = '28081' or zipCode = '28082' or zipCode = '28083' or zipCode = '28088' or zipCode = '28130' or zipCode = '28134' or zipCode = '28203' or zipCode = '28204' or zipCode = '28205' or zipCode = '28206' or zipCode = '28207' or zipCode = '28208' or zipCode = '28209' or zipCode = '28210' or zipCode = '28211' or zipCode = '28212' or zipCode = '28213' or zipCode = '28214' or zipCode = '28215' or zipCode = '28216' or zipCode = '28217' or zipCode = '28218' or zipCode = '28219' or zipCode = '28220' or zipCode = '28221' or zipCode = '28222' or zipCode = '28223' or zipCode = '28224' or zipCode = '28226' or zipCode = '28253' or zipCode = '28253' or zipCode = '28254' or zipCode = '28255' or zipCode = '28255' or zipCode = '28255' or zipCode = '28256' or zipCode = '28258' or zipCode = '28258' or zipCode = '28260' or zipCode = '28262' or zipCode = '28263' or zipCode = '28263' or zipCode = '28265' or zipCode = '28266' or zipCode = '28269' or zipCode = '28270' or zipCode = '28271' or zipCode = '28272' or zipCode = '28273' or zipCode = '28274' or zipCode = '28274' or zipCode = '28275' or zipCode = '28277' or zipCode = '28278' or zipCode = '28280' or zipCode = '28281' or zipCode = '28282' or zipCode = '28284' or zipCode = '28285' or zipCode = '28287' or zipCode = '28288' or zipCode = '28288' or zipCode = '28289' or zipCode = '28289' or zipCode = '28290' or zipCode = '28290' or zipCode = '28296' or zipCode = '28296' or zipCode = '28297' or zipCode = '28299' or zipCode = '28682' or zipCode = '29703' or zipCode = '29707' or zipCode = '29707' or zipCode = '29707' or zipCode = '29708' or zipCode = '29708' or zipCode = '29708' or zipCode = '29715' or zipCode = '29716' or zipCode = '29744' or zipCode = '28006' or zipCode = '28012' or zipCode = '28023' or zipCode = '28025' or zipCode = '28026' or zipCode = '28027' or zipCode = '28031' or zipCode = '28032' or zipCode = '28034' or zipCode = '28036' or zipCode = '28037' or zipCode = '28051' or zipCode = '28052' or zipCode = '28053' or zipCode = '28054' or zipCode = '28055' or zipCode = '28056' or zipCode = '28070' or zipCode = '28075' or zipCode = '28077' or zipCode = '28078' or zipCode = '28079' or zipCode = '28080' or zipCode = '28081' or zipCode = '28082' or zipCode = '28083' or zipCode = '28088' or zipCode = '28097' or zipCode = '28098' or zipCode = '28101' or zipCode = '28104' or zipCode = '28105' or zipCode = '28106' or zipCode = '28107' or zipCode = '28110' or zipCode = '28111' or zipCode = '28115' or zipCode = '28117' or zipCode = '28120' or zipCode = '28123' or zipCode = '28124' or zipCode = '28126' or zipCode = '28130' or zipCode = '28134' or zipCode = '28163' or zipCode = '28164' or zipCode = '28173' or zipCode = '28201' or zipCode = '28202' or zipCode = '28203' or zipCode = '28204' or zipCode = '28205' or zipCode = '28206' or zipCode = '28207' or zipCode = '28208' or zipCode = '28209' or zipCode = '28210' or zipCode = '28211' or zipCode = '28212' or zipCode = '28213' or zipCode = '28214' or zipCode = '28215' or zipCode = '28216' or zipCode = '28217' or zipCode = '28218' or zipCode = '28219' or zipCode = '28220' or zipCode = '28221' or zipCode = '28222' or zipCode = '28223' or zipCode = '28224' or zipCode = '28225' or zipCode = '28226' or zipCode = '28227' or zipCode = '28228' or zipCode = '28229' or zipCode = '28230' or zipCode = '28231' or zipCode = '28232' or zipCode = '28233' or zipCode = '28234' or zipCode = '28235' or zipCode = '28236' or zipCode = '28237' or zipCode = '28240' or zipCode = '28241' or zipCode = '28242' or zipCode = '28243' or zipCode = '28244' or zipCode = '28246' or zipCode = '28247' or zipCode = '28250' or zipCode = '28253' or zipCode = '28254' or zipCode = '28255' or zipCode = '28256' or zipCode = '28258' or zipCode = '28260' or zipCode = '28261' or zipCode = '28262' or zipCode = '28265' or zipCode = '28266' or zipCode = '28269' or zipCode = '28270' or zipCode = '28272' or zipCode = '28273' or zipCode = '28274' or zipCode = '28275' or zipCode = '28277' or zipCode = '28278' or zipCode = '28280' or zipCode = '28281' or zipCode = '28282' or zipCode = '28283' or zipCode = '28284' or zipCode = '28285' or zipCode = '28286' or zipCode = '28287' or zipCode = '28288' or zipCode = '28289' or zipCode = '28290' or zipCode = '28296' or zipCode = '28297' or zipCode = '28299' or zipCode = '28682' or zipCode = '28687' or zipCode = '28688' or zipCode = '29708' or zipCode = '29710' or zipCode = '29715' or zipCode = '29716' or zipCode = '29732' or zipCode = '29744') 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 ='28006' or zipCode = '28012' or zipCode = '28012' or zipCode = '28023' or zipCode = '28025' or zipCode = '28025' or zipCode = '28025' or zipCode = '28025' or zipCode = '28025' or zipCode = '28026' or zipCode = '28027' or zipCode = '28052' or zipCode = '28052' or zipCode = '28052' or zipCode = '28053' or zipCode = '28054' or zipCode = '28054' or zipCode = '28054' or zipCode = '28054' or zipCode = '28055' or zipCode = '28056' or zipCode = '28070' or zipCode = '28075' or zipCode = '28077' or zipCode = '28078' or zipCode = '28078' or zipCode = '28078' or zipCode = '28078' or zipCode = '28097' or zipCode = '28097' or zipCode = '28098' or zipCode = '28101' or zipCode = '28104' or zipCode = '28104' or zipCode = '28104' or zipCode = '28104' or zipCode = '28105' or zipCode = '28106' or zipCode = '28107' or zipCode = '28108' or zipCode = '28108' or zipCode = '28110' or zipCode = '28111' or zipCode = '28115' or zipCode = '28115' or zipCode = '28115' or zipCode = '28115' or zipCode = '28117' or zipCode = '28120' or zipCode = '28120' or zipCode = '28123' or zipCode = '28123' or zipCode = '28124' or zipCode = '28124' or zipCode = '28126' or zipCode = '28163' or zipCode = '28164' or zipCode = '28164' or zipCode = '28173' or zipCode = '28173' or zipCode = '28201' or zipCode = '28202' or zipCode = '28227' or zipCode = '28227' or zipCode = '28228' or zipCode = '28228' or zipCode = '28229' or zipCode = '28230' or zipCode = '28231' or zipCode = '28232' or zipCode = '28233' or zipCode = '28234' or zipCode = '28235' or zipCode = '28236' or zipCode = '28237' or zipCode = '28241' or zipCode = '28242' or zipCode = '28242' or zipCode = '28243' or zipCode = '28243' or zipCode = '28244' or zipCode = '28246' or zipCode = '28247' or zipCode = '28250' or zipCode = '28250' or zipCode = '28031' or zipCode = '28032' or zipCode = '28034' or zipCode = '28035' or zipCode = '28035' or zipCode = '28036' or zipCode = '28037' or zipCode = '28052' or zipCode = '28052' or zipCode = '28052' or zipCode = '28052' or zipCode = '28052' or zipCode = '28052' or zipCode = '28079' or zipCode = '28079' or zipCode = '28079' or zipCode = '28079' or zipCode = '28079' or zipCode = '28080' or zipCode = '28081' or zipCode = '28081' or zipCode = '28081' or zipCode = '28081' or zipCode = '28081' or zipCode = '28081' or zipCode = '28082' or zipCode = '28083' or zipCode = '28088' or zipCode = '28130' or zipCode = '28134' or zipCode = '28203' or zipCode = '28204' or zipCode = '28205' or zipCode = '28206' or zipCode = '28207' or zipCode = '28208' or zipCode = '28209' or zipCode = '28210' or zipCode = '28211' or zipCode = '28212' or zipCode = '28213' or zipCode = '28214' or zipCode = '28215' or zipCode = '28216' or zipCode = '28217' or zipCode = '28218' or zipCode = '28219' or zipCode = '28220' or zipCode = '28221' or zipCode = '28222' or zipCode = '28223' or zipCode = '28224' or zipCode = '28226' or zipCode = '28253' or zipCode = '28253' or zipCode = '28254' or zipCode = '28255' or zipCode = '28255' or zipCode = '28255' or zipCode = '28256' or zipCode = '28258' or zipCode = '28258' or zipCode = '28260' or zipCode = '28262' or zipCode = '28263' or zipCode = '28263' or zipCode = '28265' or zipCode = '28266' or zipCode = '28269' or zipCode = '28270' or zipCode = '28271' or zipCode = '28272' or zipCode = '28273' or zipCode = '28274' or zipCode = '28274' or zipCode = '28275' or zipCode = '28277' or zipCode = '28278' or zipCode = '28280' or zipCode = '28281' or zipCode = '28282' or zipCode = '28284' or zipCode = '28285' or zipCode = '28287' or zipCode = '28288' or zipCode = '28288' or zipCode = '28289' or zipCode = '28289' or zipCode = '28290' or zipCode = '28290' or zipCode = '28296' or zipCode = '28296' or zipCode = '28297' or zipCode = '28299' or zipCode = '28682' or zipCode = '29703' or zipCode = '29707' or zipCode = '29707' or zipCode = '29707' or zipCode = '29708' or zipCode = '29708' or zipCode = '29708' or zipCode = '29715' or zipCode = '29716' or zipCode = '29744' or zipCode = '28006' or zipCode = '28012' or zipCode = '28023' or zipCode = '28025' or zipCode = '28026' or zipCode = '28027' or zipCode = '28031' or zipCode = '28032' or zipCode = '28034' or zipCode = '28036' or zipCode = '28037' or zipCode = '28051' or zipCode = '28052' or zipCode = '28053' or zipCode = '28054' or zipCode = '28055' or zipCode = '28056' or zipCode = '28070' or zipCode = '28075' or zipCode = '28077' or zipCode = '28078' or zipCode = '28079' or zipCode = '28080' or zipCode = '28081' or zipCode = '28082' or zipCode = '28083' or zipCode = '28088' or zipCode = '28097' or zipCode = '28098' or zipCode = '28101' or zipCode = '28104' or zipCode = '28105' or zipCode = '28106' or zipCode = '28107' or zipCode = '28110' or zipCode = '28111' or zipCode = '28115' or zipCode = '28117' or zipCode = '28120' or zipCode = '28123' or zipCode = '28124' or zipCode = '28126' or zipCode = '28130' or zipCode = '28134' or zipCode = '28163' or zipCode = '28164' or zipCode = '28173' or zipCode = '28201' or zipCode = '28202' or zipCode = '28203' or zipCode = '28204' or zipCode = '28205' or zipCode = '28206' or zipCode = '28207' or zipCode = '28208' or zipCode = '28209' or zipCode = '28210' or zipCode = '28211' or zipCode = '28212' or zipCode = '28213' or zipCode = '28214' or zipCode = '28215' or zipCode = '28216' or zipCode = '28217' or zipCode = '28218' or zipCode = '28219' or zipCode = '28220' or zipCode = '28221' or zipCode = '28222' or zipCode = '28223' or zipCode = '28224' or zipCode = '28225' or zipCode = '28226' or zipCode = '28227' or zipCode = '28228' or zipCode = '28229' or zipCode = '28230' or zipCode = '28231' or zipCode = '28232' or zipCode = '28233' or zipCode = '28234' or zipCode = '28235' or zipCode = '28236' or zipCode = '28237' or zipCode = '28240' or zipCode = '28241' or zipCode = '28242' or zipCode = '28243' or zipCode = '28244' or zipCode = '28246' or zipCode = '28247' or zipCode = '28250' or zipCode = '28253' or zipCode = '28254' or zipCode = '28255' or zipCode = '28256' or zipCode = '28258' or zipCode = '28260' or zipCode = '28261' or zipCode = '28262' or zipCode = '28265' or zipCode = '28266' or zipCode = '28269' or zipCode = '28270' or zipCode = '28272' or zipCode = '28273' or zipCode = '28274' or zipCode = '28275' or zipCode = '28277' or zipCode = '28278' or zipCode = '28280' or zipCode = '28281' or zipCode = '28282' or zipCode = '28283' or zipCode = '28284' or zipCode = '28285' or zipCode = '28286' or zipCode = '28287' or zipCode = '28288' or zipCode = '28289' or zipCode = '28290' or zipCode = '28296' or zipCode = '28297' or zipCode = '28299' or zipCode = '28682' or zipCode = '28687' or zipCode = '28688' or zipCode = '29708' or zipCode = '29710' or zipCode = '29715' or zipCode = '29716' or zipCode = '29732' or zipCode = '29744') 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 ='28006' or zipCode = '28012' or zipCode = '28012' or zipCode = '28023' or zipCode = '28025' or zipCode = '28025' or zipCode = '28025' or zipCode = '28025' or zipCode = '28025' or zipCode = '28026' or zipCode = '28027' or zipCode = '28052' or zipCode = '28052' or zipCode = '28052' or zipCode = '28053' or zipCode = '28054' or zipCode = '28054' or zipCode = '28054' or zipCode = '28054' or zipCode = '28055' or zipCode = '28056' or zipCode = '28070' or zipCode = '28075' or zipCode = '28077' or zipCode = '28078' or zipCode = '28078' or zipCode = '28078' or zipCode = '28078' or zipCode = '28097' or zipCode = '28097' or zipCode = '28098' or zipCode = '28101' or zipCode = '28104' or zipCode = '28104' or zipCode = '28104' or zipCode = '28104' or zipCode = '28105' or zipCode = '28106' or zipCode = '28107' or zipCode = '28108' or zipCode = '28108' or zipCode = '28110' or zipCode = '28111' or zipCode = '28115' or zipCode = '28115' or zipCode = '28115' or zipCode = '28115' or zipCode = '28117' or zipCode = '28120' or zipCode = '28120' or zipCode = '28123' or zipCode = '28123' or zipCode = '28124' or zipCode = '28124' or zipCode = '28126' or zipCode = '28163' or zipCode = '28164' or zipCode = '28164' or zipCode = '28173' or zipCode = '28173' or zipCode = '28201' or zipCode = '28202' or zipCode = '28227' or zipCode = '28227' or zipCode = '28228' or zipCode = '28228' or zipCode = '28229' or zipCode = '28230' or zipCode = '28231' or zipCode = '28232' or zipCode = '28233' or zipCode = '28234' or zipCode = '28235' or zipCode = '28236' or zipCode = '28237' or zipCode = '28241' or zipCode = '28242' or zipCode = '28242' or zipCode = '28243' or zipCode = '28243' or zipCode = '28244' or zipCode = '28246' or zipCode = '28247' or zipCode = '28250' or zipCode = '28250' or zipCode = '28031' or zipCode = '28032' or zipCode = '28034' or zipCode = '28035' or zipCode = '28035' or zipCode = '28036' or zipCode = '28037' or zipCode = '28052' or zipCode = '28052' or zipCode = '28052' or zipCode = '28052' or zipCode = '28052' or zipCode = '28052' or zipCode = '28079' or zipCode = '28079' or zipCode = '28079' or zipCode = '28079' or zipCode = '28079' or zipCode = '28080' or zipCode = '28081' or zipCode = '28081' or zipCode = '28081' or zipCode = '28081' or zipCode = '28081' or zipCode = '28081' or zipCode = '28082' or zipCode = '28083' or zipCode = '28088' or zipCode = '28130' or zipCode = '28134' or zipCode = '28203' or zipCode = '28204' or zipCode = '28205' or zipCode = '28206' or zipCode = '28207' or zipCode = '28208' or zipCode = '28209' or zipCode = '28210' or zipCode = '28211' or zipCode = '28212' or zipCode = '28213' or zipCode = '28214' or zipCode = '28215' or zipCode = '28216' or zipCode = '28217' or zipCode = '28218' or zipCode = '28219' or zipCode = '28220' or zipCode = '28221' or zipCode = '28222' or zipCode = '28223' or zipCode = '28224' or zipCode = '28226' or zipCode = '28253' or zipCode = '28253' or zipCode = '28254' or zipCode = '28255' or zipCode = '28255' or zipCode = '28255' or zipCode = '28256' or zipCode = '28258' or zipCode = '28258' or zipCode = '28260' or zipCode = '28262' or zipCode = '28263' or zipCode = '28263' or zipCode = '28265' or zipCode = '28266' or zipCode = '28269' or zipCode = '28270' or zipCode = '28271' or zipCode = '28272' or zipCode = '28273' or zipCode = '28274' or zipCode = '28274' or zipCode = '28275' or zipCode = '28277' or zipCode = '28278' or zipCode = '28280' or zipCode = '28281' or zipCode = '28282' or zipCode = '28284' or zipCode = '28285' or zipCode = '28287' or zipCode = '28288' or zipCode = '28288' or zipCode = '28289' or zipCode = '28289' or zipCode = '28290' or zipCode = '28290' or zipCode = '28296' or zipCode = '28296' or zipCode = '28297' or zipCode = '28299' or zipCode = '28682' or zipCode = '29703' or zipCode = '29707' or zipCode = '29707' or zipCode = '29707' or zipCode = '29708' or zipCode = '29708' or zipCode = '29708' or zipCode = '29715' or zipCode = '29716' or zipCode = '29744' or zipCode = '28006' or zipCode = '28012' or zipCode = '28023' or zipCode = '28025' or zipCode = '28026' or zipCode = '28027' or zipCode = '28031' or zipCode = '28032' or zipCode = '28034' or zipCode = '28036' or zipCode = '28037' or zipCode = '28051' or zipCode = '28052' or zipCode = '28053' or zipCode = '28054' or zipCode = '28055' or zipCode = '28056' or zipCode = '28070' or zipCode = '28075' or zipCode = '28077' or zipCode = '28078' or zipCode = '28079' or zipCode = '28080' or zipCode = '28081' or zipCode = '28082' or zipCode = '28083' or zipCode = '28088' or zipCode = '28097' or zipCode = '28098' or zipCode = '28101' or zipCode = '28104' or zipCode = '28105' or zipCode = '28106' or zipCode = '28107' or zipCode = '28110' or zipCode = '28111' or zipCode = '28115' or zipCode = '28117' or zipCode = '28120' or zipCode = '28123' or zipCode = '28124' or zipCode = '28126' or zipCode = '28130' or zipCode = '28134' or zipCode = '28163' or zipCode = '28164' or zipCode = '28173' or zipCode = '28201' or zipCode = '28202' or zipCode = '28203' or zipCode = '28204' or zipCode = '28205' or zipCode = '28206' or zipCode = '28207' or zipCode = '28208' or zipCode = '28209' or zipCode = '28210' or zipCode = '28211' or zipCode = '28212' or zipCode = '28213' or zipCode = '28214' or zipCode = '28215' or zipCode = '28216' or zipCode = '28217' or zipCode = '28218' or zipCode = '28219' or zipCode = '28220' or zipCode = '28221' or zipCode = '28222' or zipCode = '28223' or zipCode = '28224' or zipCode = '28225' or zipCode = '28226' or zipCode = '28227' or zipCode = '28228' or zipCode = '28229' or zipCode = '28230' or zipCode = '28231' or zipCode = '28232' or zipCode = '28233' or zipCode = '28234' or zipCode = '28235' or zipCode = '28236' or zipCode = '28237' or zipCode = '28240' or zipCode = '28241' or zipCode = '28242' or zipCode = '28243' or zipCode = '28244' or zipCode = '28246' or zipCode = '28247' or zipCode = '28250' or zipCode = '28253' or zipCode = '28254' or zipCode = '28255' or zipCode = '28256' or zipCode = '28258' or zipCode = '28260' or zipCode = '28261' or zipCode = '28262' or zipCode = '28265' or zipCode = '28266' or zipCode = '28269' or zipCode = '28270' or zipCode = '28272' or zipCode = '28273' or zipCode = '28274' or zipCode = '28275' or zipCode = '28277' or zipCode = '28278' or zipCode = '28280' or zipCode = '28281' or zipCode = '28282' or zipCode = '28283' or zipCode = '28284' or zipCode = '28285' or zipCode = '28286' or zipCode = '28287' or zipCode = '28288' or zipCode = '28289' or zipCode = '28290' or zipCode = '28296' or zipCode = '28297' or zipCode = '28299' or zipCode = '28682' or zipCode = '28687' or zipCode = '28688' or zipCode = '29708' or zipCode = '29710' or zipCode = '29715' or zipCode = '29716' or zipCode = '29732' or zipCode = '29744') 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 ='28006' or property_zip = '28012' or property_zip = '28012' or property_zip = '28023' or property_zip = '28025' or property_zip = '28025' or property_zip = '28025' or property_zip = '28025' or property_zip = '28025' or property_zip = '28026' or property_zip = '28027' or property_zip = '28052' or property_zip = '28052' or property_zip = '28052' or property_zip = '28053' or property_zip = '28054' or property_zip = '28054' or property_zip = '28054' or property_zip = '28054' or property_zip = '28055' or property_zip = '28056' or property_zip = '28070' or property_zip = '28075' or property_zip = '28077' or property_zip = '28078' or property_zip = '28078' or property_zip = '28078' or property_zip = '28078' or property_zip = '28097' or property_zip = '28097' or property_zip = '28098' or property_zip = '28101' or property_zip = '28104' or property_zip = '28104' or property_zip = '28104' or property_zip = '28104' or property_zip = '28105' or property_zip = '28106' or property_zip = '28107' or property_zip = '28108' or property_zip = '28108' or property_zip = '28110' or property_zip = '28111' or property_zip = '28115' or property_zip = '28115' or property_zip = '28115' or property_zip = '28115' or property_zip = '28117' or property_zip = '28120' or property_zip = '28120' or property_zip = '28123' or property_zip = '28123' or property_zip = '28124' or property_zip = '28124' or property_zip = '28126' or property_zip = '28163' or property_zip = '28164' or property_zip = '28164' or property_zip = '28173' or property_zip = '28173' or property_zip = '28201' or property_zip = '28202' or property_zip = '28227' or property_zip = '28227' or property_zip = '28228' or property_zip = '28228' or property_zip = '28229' or property_zip = '28230' or property_zip = '28231' or property_zip = '28232' or property_zip = '28233' or property_zip = '28234' or property_zip = '28235' or property_zip = '28236' or property_zip = '28237' or property_zip = '28241' or property_zip = '28242' or property_zip = '28242' or property_zip = '28243' or property_zip = '28243' or property_zip = '28244' or property_zip = '28246' or property_zip = '28247' or property_zip = '28250' or property_zip = '28250' or property_zip = '28031' or property_zip = '28032' or property_zip = '28034' or property_zip = '28035' or property_zip = '28035' or property_zip = '28036' or property_zip = '28037' or property_zip = '28052' or property_zip = '28052' or property_zip = '28052' or property_zip = '28052' or property_zip = '28052' or property_zip = '28052' or property_zip = '28079' or property_zip = '28079' or property_zip = '28079' or property_zip = '28079' or property_zip = '28079' or property_zip = '28080' or property_zip = '28081' or property_zip = '28081' or property_zip = '28081' or property_zip = '28081' or property_zip = '28081' or property_zip = '28081' or property_zip = '28082' or property_zip = '28083' or property_zip = '28088' or property_zip = '28130' or property_zip = '28134' or property_zip = '28203' or property_zip = '28204' or property_zip = '28205' or property_zip = '28206' or property_zip = '28207' or property_zip = '28208' or property_zip = '28209' or property_zip = '28210' or property_zip = '28211' or property_zip = '28212' or property_zip = '28213' or property_zip = '28214' or property_zip = '28215' or property_zip = '28216' or property_zip = '28217' or property_zip = '28218' or property_zip = '28219' or property_zip = '28220' or property_zip = '28221' or property_zip = '28222' or property_zip = '28223' or property_zip = '28224' or property_zip = '28226' or property_zip = '28253' or property_zip = '28253' or property_zip = '28254' or property_zip = '28255' or property_zip = '28255' or property_zip = '28255' or property_zip = '28256' or property_zip = '28258' or property_zip = '28258' or property_zip = '28260' or property_zip = '28262' or property_zip = '28263' or property_zip = '28263' or property_zip = '28265' or property_zip = '28266' or property_zip = '28269' or property_zip = '28270' or property_zip = '28271' or property_zip = '28272' or property_zip = '28273' or property_zip = '28274' or property_zip = '28274' or property_zip = '28275' or property_zip = '28277' or property_zip = '28278' or property_zip = '28280' or property_zip = '28281' or property_zip = '28282' or property_zip = '28284' or property_zip = '28285' or property_zip = '28287' or property_zip = '28288' or property_zip = '28288' or property_zip = '28289' or property_zip = '28289' or property_zip = '28290' or property_zip = '28290' or property_zip = '28296' or property_zip = '28296' or property_zip = '28297' or property_zip = '28299' or property_zip = '28682' or property_zip = '29703' or property_zip = '29707' or property_zip = '29707' or property_zip = '29707' or property_zip = '29708' or property_zip = '29708' or property_zip = '29708' or property_zip = '29715' or property_zip = '29716' or property_zip = '29744' or property_zip = '28006' or property_zip = '28012' or property_zip = '28023' or property_zip = '28025' or property_zip = '28026' or property_zip = '28027' or property_zip = '28031' or property_zip = '28032' or property_zip = '28034' or property_zip = '28036' or property_zip = '28037' or property_zip = '28051' or property_zip = '28052' or property_zip = '28053' or property_zip = '28054' or property_zip = '28055' or property_zip = '28056' or property_zip = '28070' or property_zip = '28075' or property_zip = '28077' or property_zip = '28078' or property_zip = '28079' or property_zip = '28080' or property_zip = '28081' or property_zip = '28082' or property_zip = '28083' or property_zip = '28088' or property_zip = '28097' or property_zip = '28098' or property_zip = '28101' or property_zip = '28104' or property_zip = '28105' or property_zip = '28106' or property_zip = '28107' or property_zip = '28110' or property_zip = '28111' or property_zip = '28115' or property_zip = '28117' or property_zip = '28120' or property_zip = '28123' or property_zip = '28124' or property_zip = '28126' or property_zip = '28130' or property_zip = '28134' or property_zip = '28163' or property_zip = '28164' or property_zip = '28173' or property_zip = '28201' or property_zip = '28202' or property_zip = '28203' or property_zip = '28204' or property_zip = '28205' or property_zip = '28206' or property_zip = '28207' or property_zip = '28208' or property_zip = '28209' or property_zip = '28210' or property_zip = '28211' or property_zip = '28212' or property_zip = '28213' or property_zip = '28214' or property_zip = '28215' or property_zip = '28216' or property_zip = '28217' or property_zip = '28218' or property_zip = '28219' or property_zip = '28220' or property_zip = '28221' or property_zip = '28222' or property_zip = '28223' or property_zip = '28224' or property_zip = '28225' or property_zip = '28226' or property_zip = '28227' or property_zip = '28228' or property_zip = '28229' or property_zip = '28230' or property_zip = '28231' or property_zip = '28232' or property_zip = '28233' or property_zip = '28234' or property_zip = '28235' or property_zip = '28236' or property_zip = '28237' or property_zip = '28240' or property_zip = '28241' or property_zip = '28242' or property_zip = '28243' or property_zip = '28244' or property_zip = '28246' or property_zip = '28247' or property_zip = '28250' or property_zip = '28253' or property_zip = '28254' or property_zip = '28255' or property_zip = '28256' or property_zip = '28258' or property_zip = '28260' or property_zip = '28261' or property_zip = '28262' or property_zip = '28265' or property_zip = '28266' or property_zip = '28269' or property_zip = '28270' or property_zip = '28272' or property_zip = '28273' or property_zip = '28274' or property_zip = '28275' or property_zip = '28277' or property_zip = '28278' or property_zip = '28280' or property_zip = '28281' or property_zip = '28282' or property_zip = '28283' or property_zip = '28284' or property_zip = '28285' or property_zip = '28286' or property_zip = '28287' or property_zip = '28288' or property_zip = '28289' or property_zip = '28290' or property_zip = '28296' or property_zip = '28297' or property_zip = '28299' or property_zip = '28682' or property_zip = '28687' or property_zip = '28688' or property_zip = '29708' or property_zip = '29710' or property_zip = '29715' or property_zip = '29716' or property_zip = '29732' or property_zip = '29744') and convert(date,auction_start_date) >= '9/27/2021';
select top 45 * from currentforeclosures.tblAll NOLOCK where state = 'NC '
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 ='28006' or zip = '28012' or zip = '28012' or zip = '28023' or zip = '28025' or zip = '28025' or zip = '28025' or zip = '28025' or zip = '28025' or zip = '28026' or zip = '28027' or zip = '28052' or zip = '28052' or zip = '28052' or zip = '28053' or zip = '28054' or zip = '28054' or zip = '28054' or zip = '28054' or zip = '28055' or zip = '28056' or zip = '28070' or zip = '28075' or zip = '28077' or zip = '28078' or zip = '28078' or zip = '28078' or zip = '28078' or zip = '28097' or zip = '28097' or zip = '28098' or zip = '28101' or zip = '28104' or zip = '28104' or zip = '28104' or zip = '28104' or zip = '28105' or zip = '28106' or zip = '28107' or zip = '28108' or zip = '28108' or zip = '28110' or zip = '28111' or zip = '28115' or zip = '28115' or zip = '28115' or zip = '28115' or zip = '28117' or zip = '28120' or zip = '28120' or zip = '28123' or zip = '28123' or zip = '28124' or zip = '28124' or zip = '28126' or zip = '28163' or zip = '28164' or zip = '28164' or zip = '28173' or zip = '28173' or zip = '28201' or zip = '28202' or zip = '28227' or zip = '28227' or zip = '28228' or zip = '28228' or zip = '28229' or zip = '28230' or zip = '28231' or zip = '28232' or zip = '28233' or zip = '28234' or zip = '28235' or zip = '28236' or zip = '28237' or zip = '28241' or zip = '28242' or zip = '28242' or zip = '28243' or zip = '28243' or zip = '28244' or zip = '28246' or zip = '28247' or zip = '28250' or zip = '28250' or zip = '28031' or zip = '28032' or zip = '28034' or zip = '28035' or zip = '28035' or zip = '28036' or zip = '28037' or zip = '28052' or zip = '28052' or zip = '28052' or zip = '28052' or zip = '28052' or zip = '28052' or zip = '28079' or zip = '28079' or zip = '28079' or zip = '28079' or zip = '28079' or zip = '28080' or zip = '28081' or zip = '28081' or zip = '28081' or zip = '28081' or zip = '28081' or zip = '28081' or zip = '28082' or zip = '28083' or zip = '28088' or zip = '28130' or zip = '28134' or zip = '28203' or zip = '28204' or zip = '28205' or zip = '28206' or zip = '28207' or zip = '28208' or zip = '28209' or zip = '28210' or zip = '28211' or zip = '28212' or zip = '28213' or zip = '28214' or zip = '28215' or zip = '28216' or zip = '28217' or zip = '28218' or zip = '28219' or zip = '28220' or zip = '28221' or zip = '28222' or zip = '28223' or zip = '28224' or zip = '28226' or zip = '28253' or zip = '28253' or zip = '28254' or zip = '28255' or zip = '28255' or zip = '28255' or zip = '28256' or zip = '28258' or zip = '28258' or zip = '28260' or zip = '28262' or zip = '28263' or zip = '28263' or zip = '28265' or zip = '28266' or zip = '28269' or zip = '28270' or zip = '28271' or zip = '28272' or zip = '28273' or zip = '28274' or zip = '28274' or zip = '28275' or zip = '28277' or zip = '28278' or zip = '28280' or zip = '28281' or zip = '28282' or zip = '28284' or zip = '28285' or zip = '28287' or zip = '28288' or zip = '28288' or zip = '28289' or zip = '28289' or zip = '28290' or zip = '28290' or zip = '28296' or zip = '28296' or zip = '28297' or zip = '28299' or zip = '28682' or zip = '29703' or zip = '29707' or zip = '29707' or zip = '29707' or zip = '29708' or zip = '29708' or zip = '29708' or zip = '29715' or zip = '29716' or zip = '29744' or zip = '28006' or zip = '28012' or zip = '28023' or zip = '28025' or zip = '28026' or zip = '28027' or zip = '28031' or zip = '28032' or zip = '28034' or zip = '28036' or zip = '28037' or zip = '28051' or zip = '28052' or zip = '28053' or zip = '28054' or zip = '28055' or zip = '28056' or zip = '28070' or zip = '28075' or zip = '28077' or zip = '28078' or zip = '28079' or zip = '28080' or zip = '28081' or zip = '28082' or zip = '28083' or zip = '28088' or zip = '28097' or zip = '28098' or zip = '28101' or zip = '28104' or zip = '28105' or zip = '28106' or zip = '28107' or zip = '28110' or zip = '28111' or zip = '28115' or zip = '28117' or zip = '28120' or zip = '28123' or zip = '28124' or zip = '28126' or zip = '28130' or zip = '28134' or zip = '28163' or zip = '28164' or zip = '28173' or zip = '28201' or zip = '28202' or zip = '28203' or zip = '28204' or zip = '28205' or zip = '28206' or zip = '28207' or zip = '28208' or zip = '28209' or zip = '28210' or zip = '28211' or zip = '28212' or zip = '28213' or zip = '28214' or zip = '28215' or zip = '28216' or zip = '28217' or zip = '28218' or zip = '28219' or zip = '28220' or zip = '28221' or zip = '28222' or zip = '28223' or zip = '28224' or zip = '28225' or zip = '28226' or zip = '28227' or zip = '28228' or zip = '28229' or zip = '28230' or zip = '28231' or zip = '28232' or zip = '28233' or zip = '28234' or zip = '28235' or zip = '28236' or zip = '28237' or zip = '28240' or zip = '28241' or zip = '28242' or zip = '28243' or zip = '28244' or zip = '28246' or zip = '28247' or zip = '28250' or zip = '28253' or zip = '28254' or zip = '28255' or zip = '28256' or zip = '28258' or zip = '28260' or zip = '28261' or zip = '28262' or zip = '28265' or zip = '28266' or zip = '28269' or zip = '28270' or zip = '28272' or zip = '28273' or zip = '28274' or zip = '28275' or zip = '28277' or zip = '28278' or zip = '28280' or zip = '28281' or zip = '28282' or zip = '28283' or zip = '28284' or zip = '28285' or zip = '28286' or zip = '28287' or zip = '28288' or zip = '28289' or zip = '28290' or zip = '28296' or zip = '28297' or zip = '28299' or zip = '28682' or zip = '28687' or zip = '28688' or zip = '29708' or zip = '29710' or zip = '29715' or zip = '29716' or zip = '29732' or zip = '29744')
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 = 'NC' and city = 'CHARLOTTE' and state = 'NC ' 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();