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


432+ High Potential Investor Deals Near houston [Refine]


********NOTICE: Displaying 99 of over 432 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 ='77008' or zipCode = '77008' or zipCode = '77009' or zipCode = '77010' or zipCode = '77011' or zipCode = '77012' or zipCode = '77013' or zipCode = '77014' or zipCode = '77015' or zipCode = '77015' or zipCode = '77015' or zipCode = '77016' or zipCode = '77017' or zipCode = '77018' or zipCode = '77019' or zipCode = '77020' or zipCode = '77021' or zipCode = '77022' or zipCode = '77023' or zipCode = '77024' or zipCode = '77024' or zipCode = '77024' or zipCode = '77024' or zipCode = '77039' or zipCode = '77040' or zipCode = '77040' or zipCode = '77040' or zipCode = '77040' or zipCode = '77040' or zipCode = '77040' or zipCode = '77041' or zipCode = '77041' or zipCode = '77041' or zipCode = '77042' or zipCode = '77043' or zipCode = '77044' or zipCode = '77045' or zipCode = '77045' or zipCode = '77046' or zipCode = '77046' or zipCode = '77047' or zipCode = '77048' or zipCode = '77049' or zipCode = '77050' or zipCode = '77051' or zipCode = '77052' or zipCode = '77001' or zipCode = '77002' or zipCode = '77002' or zipCode = '77003' or zipCode = '77004' or zipCode = '77005' or zipCode = '77005' or zipCode = '77005' or zipCode = '77005' or zipCode = '77006' or zipCode = '77007' or zipCode = '77008' or zipCode = '77024' or zipCode = '77024' or zipCode = '77024' or zipCode = '77025' or zipCode = '77025' or zipCode = '77025' or zipCode = '77026' or zipCode = '77027' or zipCode = '77028' or zipCode = '77028' or zipCode = '77029' or zipCode = '77030' or zipCode = '77030' or zipCode = '77031' or zipCode = '77032' or zipCode = '77033' or zipCode = '77034' or zipCode = '77035' or zipCode = '77036' or zipCode = '77036' or zipCode = '77037' or zipCode = '77038' or zipCode = '77039' or zipCode = '77053' or zipCode = '77054' or zipCode = '77054' or zipCode = '77055' or zipCode = '77055' or zipCode = '77056' or zipCode = '77057' or zipCode = '77058' or zipCode = '77058' or zipCode = '77058' or zipCode = '77058' or zipCode = '77059' or zipCode = '77060' or zipCode = '77061' or zipCode = '77062' or zipCode = '77063' or zipCode = '77064' or zipCode = '77065' or zipCode = '77065' or zipCode = '77065' or zipCode = '77066' or zipCode = '77067' or zipCode = '77068' or zipCode = '77091' or zipCode = '77092' or zipCode = '77093' or zipCode = '77094' or zipCode = '77095' or zipCode = '77096' or zipCode = '77097' or zipCode = '77098' or zipCode = '77099' or zipCode = '77201' or zipCode = '77201' or zipCode = '77202' or zipCode = '77203' or zipCode = '77204' or zipCode = '77204' or zipCode = '77205' or zipCode = '77206' or zipCode = '77207' or zipCode = '77208' or zipCode = '77209' or zipCode = '77209' or zipCode = '77210' or zipCode = '77212' or zipCode = '77212' or zipCode = '77213' or zipCode = '77215' or zipCode = '77216' or zipCode = '77216' or zipCode = '77217' or zipCode = '77218' or zipCode = '77219' or zipCode = '77220' or zipCode = '77221' or zipCode = '77222' or zipCode = '77223' or zipCode = '77224' or zipCode = '77224' or zipCode = '77225' or zipCode = '77226' or zipCode = '77227' or zipCode = '77228' or zipCode = '77229' or zipCode = '77230' or zipCode = '77230' or zipCode = '77231' or zipCode = '77233' or zipCode = '77234' or zipCode = '77235' or zipCode = '77260' or zipCode = '77261' or zipCode = '77262' or zipCode = '77263' or zipCode = '77265' or zipCode = '77266' or zipCode = '77267' or zipCode = '77268' or zipCode = '77269' or zipCode = '77270' or zipCode = '77271' or zipCode = '77272' or zipCode = '77273' or zipCode = '77274' or zipCode = '77275' or zipCode = '77276' or zipCode = '77277' or zipCode = '77278' or zipCode = '77279' or zipCode = '77279' or zipCode = '77280' or zipCode = '77282' or zipCode = '77284' or zipCode = '77285' or zipCode = '77315' or zipCode = '77325' or zipCode = '77325' or zipCode = '77345' or zipCode = '77345' or zipCode = '77346' or zipCode = '77346' or zipCode = '77346' or zipCode = '77347' or zipCode = '77069' or zipCode = '77070' or zipCode = '77071' or zipCode = '77072' or zipCode = '77073' or zipCode = '77074' or zipCode = '77075' or zipCode = '77076' or zipCode = '77077' or zipCode = '77078' or zipCode = '77079' or zipCode = '77079' or zipCode = '77080' or zipCode = '77081' or zipCode = '77082' or zipCode = '77083' or zipCode = '77084' or zipCode = '77084' or zipCode = '77085' or zipCode = '77086' or zipCode = '77087' or zipCode = '77088' or zipCode = '77089' or zipCode = '77090' or zipCode = '77236' or zipCode = '77237' or zipCode = '77238' or zipCode = '77240' or zipCode = '77241' or zipCode = '77242' or zipCode = '77243' or zipCode = '77244' or zipCode = '77245' or zipCode = '77246' or zipCode = '77247' or zipCode = '77248' or zipCode = '77249' or zipCode = '77250' or zipCode = '77251' or zipCode = '77252' or zipCode = '77253' or zipCode = '77254' or zipCode = '77255' or zipCode = '77256' or zipCode = '77257' or zipCode = '77258' or zipCode = '77258' or zipCode = '77259' or zipCode = '77286' or zipCode = '77287' or zipCode = '77288' or zipCode = '77289' or zipCode = '77290' or zipCode = '77291' or zipCode = '77292' or zipCode = '77293' or zipCode = '77294' or zipCode = '77296' or zipCode = '77297' or zipCode = '77297' or zipCode = '77298' or zipCode = '77298' or zipCode = '77299' or zipCode = '77299' or zipCode = '77336' or zipCode = '77338' or zipCode = '77338' or zipCode = '77339' or zipCode = '77339' or zipCode = '77357' or zipCode = '77357' or zipCode = '77357' or zipCode = '77365' or zipCode = '77365' or zipCode = '77365' or zipCode = '77365' or zipCode = '77365' or zipCode = '77386' or zipCode = '77386' or zipCode = '77387' or zipCode = '77387' or zipCode = '77388' or zipCode = '77389' or zipCode = '77389' or zipCode = '77389' or zipCode = '77391' or zipCode = '77391' or zipCode = '77393' or zipCode = '77393' or zipCode = '77393' or zipCode = '77396' or zipCode = '77401' or zipCode = '77402' or zipCode = '77429' or zipCode = '77373' or zipCode = '77373' or zipCode = '77379' or zipCode = '77379' or zipCode = '77380' or zipCode = '77380' or zipCode = '77380' or zipCode = '77383' or zipCode = '77411' or zipCode = '77411' or zipCode = '77413' or zipCode = '77459' or zipCode = '77459' or zipCode = '77459' or zipCode = '77477' or zipCode = '77477' or zipCode = '77478' or zipCode = '77503' or zipCode = '77504' or zipCode = '77505' or zipCode = '77506' or zipCode = '77507' or zipCode = '77508' or zipCode = '77536' or zipCode = '77545' or zipCode = '77546' or zipCode = '77547' or zipCode = '77549' or zipCode = '77562' or zipCode = '77571' or zipCode = '77571' or zipCode = '77571' or zipCode = '77571' or zipCode = '77571' or zipCode = '77572' or zipCode = '77573' or zipCode = '77574' or zipCode = '77578' or zipCode = '77581' or zipCode = '77581' or zipCode = '77581' or zipCode = '77487' or zipCode = '77489' or zipCode = '77496' or zipCode = '77497' or zipCode = '77501' or zipCode = '77502' or zipCode = '77503' or zipCode = '77521' or zipCode = '77522' or zipCode = '77523' or zipCode = '77523' or zipCode = '77523' or zipCode = '77523' or zipCode = '77523' or zipCode = '77523' or zipCode = '77530' or zipCode = '77532' or zipCode = '77584' or zipCode = '77586' or zipCode = '77586' or zipCode = '77586' or zipCode = '77586' or zipCode = '77586' or zipCode = '77586' or zipCode = '77587' or zipCode = '77588' or zipCode = '77598' or zipCode = '77598' or zipCode = '77000' or zipCode = '77001' or zipCode = '77002' or zipCode = '77003' or zipCode = '77004' or zipCode = '77005' or zipCode = '77006' or zipCode = '77007' or zipCode = '77008' or zipCode = '77009' or zipCode = '77010' or zipCode = '77011' or zipCode = '77012' or zipCode = '77013' or zipCode = '77014' or zipCode = '77015' or zipCode = '77016' or zipCode = '77017' or zipCode = '77018' or zipCode = '77019' or zipCode = '77020' or zipCode = '77021' or zipCode = '77022' or zipCode = '77023' or zipCode = '77024' or zipCode = '77025' or zipCode = '77026' or zipCode = '77027' or zipCode = '77028' or zipCode = '77029' or zipCode = '77030' or zipCode = '77031' or zipCode = '77032' or zipCode = '77033' or zipCode = '77034' or zipCode = '77035' or zipCode = '77036' or zipCode = '77037' or zipCode = '77038' or zipCode = '77039' or zipCode = '77040' or zipCode = '77041' or zipCode = '77042' or zipCode = '77043' or zipCode = '77044' or zipCode = '77045' or zipCode = '77046' or zipCode = '77047' or zipCode = '77048' or zipCode = '77049' or zipCode = '77050' or zipCode = '77051' or zipCode = '77052' or zipCode = '77053' or zipCode = '77054' or zipCode = '77055' or zipCode = '77056' or zipCode = '77057' or zipCode = '77058' or zipCode = '77059' or zipCode = '77060' or zipCode = '77061' or zipCode = '77062' or zipCode = '77063' or zipCode = '77064' or zipCode = '77065' or zipCode = '77066' or zipCode = '77067' or zipCode = '77068' or zipCode = '77069' or zipCode = '77070' or zipCode = '77071' or zipCode = '77072' or zipCode = '77073' or zipCode = '77074' or zipCode = '77075' or zipCode = '77076' or zipCode = '77077' or zipCode = '77078' or zipCode = '77079' or zipCode = '77080' or zipCode = '77081' or zipCode = '77082' or zipCode = '77083' or zipCode = '77084' or zipCode = '77085' or zipCode = '77086' or zipCode = '77087' or zipCode = '77088' or zipCode = '77089' or zipCode = '77090' or zipCode = '77091' or zipCode = '77092' or zipCode = '77093' or zipCode = '77094' or zipCode = '77095' or zipCode = '77096' or zipCode = '77097' or zipCode = '77098' or zipCode = '77099' or zipCode = '77201' or zipCode = '77202' or zipCode = '77203' or zipCode = '77204' or zipCode = '77205' or zipCode = '77206' or zipCode = '77207' or zipCode = '77208' or zipCode = '77209' or zipCode = '77210' or zipCode = '77212' or zipCode = '77213' or zipCode = '77215' or zipCode = '77216' or zipCode = '77217' or zipCode = '77218' or zipCode = '77219' or zipCode = '77220' or zipCode = '77221' or zipCode = '77222' or zipCode = '77223' or zipCode = '77224' or zipCode = '77225' or zipCode = '77226' or zipCode = '77227' or zipCode = '77228' or zipCode = '77229' or zipCode = '77230' or zipCode = '77231' or zipCode = '77233' or zipCode = '77234' or zipCode = '77235' or zipCode = '77236' or zipCode = '77237' or zipCode = '77238' or zipCode = '77240' or zipCode = '77241' or zipCode = '77242' or zipCode = '77243' or zipCode = '77244' or zipCode = '77245' or zipCode = '77248' or zipCode = '77249' or zipCode = '77251' or zipCode = '77252' or zipCode = '77253' or zipCode = '77254' or zipCode = '77255' or zipCode = '77256' or zipCode = '77257' or zipCode = '77258' or zipCode = '77259' or zipCode = '77261' or zipCode = '77262' or zipCode = '77263' or zipCode = '77265' or zipCode = '77266' or zipCode = '77267' or zipCode = '77268' or zipCode = '77269' or zipCode = '77270' or zipCode = '77271' or zipCode = '77272' or zipCode = '77273' or zipCode = '77274' or zipCode = '77275' or zipCode = '77277' or zipCode = '77279' or zipCode = '77280' or zipCode = '77281' or zipCode = '77282' or zipCode = '77284' or zipCode = '77287' or zipCode = '77288' or zipCode = '77289' or zipCode = '77290' or zipCode = '77291' or zipCode = '77292' or zipCode = '77293' or zipCode = '77297' or zipCode = '77298' or zipCode = '77299' or zipCode = '77315' or zipCode = '77325' or zipCode = '77336' or zipCode = '77337' or zipCode = '77338' or zipCode = '77339' or zipCode = '77345' or zipCode = '77346' or zipCode = '77347' or zipCode = '77365' or zipCode = '77373' or zipCode = '77377' or zipCode = '77379' or zipCode = '77380' or zipCode = '77383' or zipCode = '77386' or zipCode = '77388' or zipCode = '77389' or zipCode = '77391' or zipCode = '77396' or zipCode = '77401' or zipCode = '77402' or zipCode = '77410' or zipCode = '77411' or zipCode = '77413' or zipCode = '77429' or zipCode = '77459' or zipCode = '77477' or zipCode = '77478' or zipCode = '77489' or zipCode = '77491' or zipCode = '77492' or zipCode = '77501' or zipCode = '77502' or zipCode = '77503' or zipCode = '77504' or zipCode = '77505' or zipCode = '77506' or zipCode = '77507' or zipCode = '77508' or zipCode = '77520' or zipCode = '77521' or zipCode = '77522' or zipCode = '77530' or zipCode = '77532' or zipCode = '77536' or zipCode = '77545' or zipCode = '77546' or zipCode = '77547' or zipCode = '77562' or zipCode = '77567' or zipCode = '77571' or zipCode = '77572' or zipCode = '77578' or zipCode = '77581' or zipCode = '77584' or zipCode = '77586' or zipCode = '77587' or zipCode = '77588' or zipCode = '77593' or zipCode = '77598')
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 ='77008' or zipCode = '77008' or zipCode = '77009' or zipCode = '77010' or zipCode = '77011' or zipCode = '77012' or zipCode = '77013' or zipCode = '77014' or zipCode = '77015' or zipCode = '77015' or zipCode = '77015' or zipCode = '77016' or zipCode = '77017' or zipCode = '77018' or zipCode = '77019' or zipCode = '77020' or zipCode = '77021' or zipCode = '77022' or zipCode = '77023' or zipCode = '77024' or zipCode = '77024' or zipCode = '77024' or zipCode = '77024' or zipCode = '77039' or zipCode = '77040' or zipCode = '77040' or zipCode = '77040' or zipCode = '77040' or zipCode = '77040' or zipCode = '77040' or zipCode = '77041' or zipCode = '77041' or zipCode = '77041' or zipCode = '77042' or zipCode = '77043' or zipCode = '77044' or zipCode = '77045' or zipCode = '77045' or zipCode = '77046' or zipCode = '77046' or zipCode = '77047' or zipCode = '77048' or zipCode = '77049' or zipCode = '77050' or zipCode = '77051' or zipCode = '77052' or zipCode = '77001' or zipCode = '77002' or zipCode = '77002' or zipCode = '77003' or zipCode = '77004' or zipCode = '77005' or zipCode = '77005' or zipCode = '77005' or zipCode = '77005' or zipCode = '77006' or zipCode = '77007' or zipCode = '77008' or zipCode = '77024' or zipCode = '77024' or zipCode = '77024' or zipCode = '77025' or zipCode = '77025' or zipCode = '77025' or zipCode = '77026' or zipCode = '77027' or zipCode = '77028' or zipCode = '77028' or zipCode = '77029' or zipCode = '77030' or zipCode = '77030' or zipCode = '77031' or zipCode = '77032' or zipCode = '77033' or zipCode = '77034' or zipCode = '77035' or zipCode = '77036' or zipCode = '77036' or zipCode = '77037' or zipCode = '77038' or zipCode = '77039' or zipCode = '77053' or zipCode = '77054' or zipCode = '77054' or zipCode = '77055' or zipCode = '77055' or zipCode = '77056' or zipCode = '77057' or zipCode = '77058' or zipCode = '77058' or zipCode = '77058' or zipCode = '77058' or zipCode = '77059' or zipCode = '77060' or zipCode = '77061' or zipCode = '77062' or zipCode = '77063' or zipCode = '77064' or zipCode = '77065' or zipCode = '77065' or zipCode = '77065' or zipCode = '77066' or zipCode = '77067' or zipCode = '77068' or zipCode = '77091' or zipCode = '77092' or zipCode = '77093' or zipCode = '77094' or zipCode = '77095' or zipCode = '77096' or zipCode = '77097' or zipCode = '77098' or zipCode = '77099' or zipCode = '77201' or zipCode = '77201' or zipCode = '77202' or zipCode = '77203' or zipCode = '77204' or zipCode = '77204' or zipCode = '77205' or zipCode = '77206' or zipCode = '77207' or zipCode = '77208' or zipCode = '77209' or zipCode = '77209' or zipCode = '77210' or zipCode = '77212' or zipCode = '77212' or zipCode = '77213' or zipCode = '77215' or zipCode = '77216' or zipCode = '77216' or zipCode = '77217' or zipCode = '77218' or zipCode = '77219' or zipCode = '77220' or zipCode = '77221' or zipCode = '77222' or zipCode = '77223' or zipCode = '77224' or zipCode = '77224' or zipCode = '77225' or zipCode = '77226' or zipCode = '77227' or zipCode = '77228' or zipCode = '77229' or zipCode = '77230' or zipCode = '77230' or zipCode = '77231' or zipCode = '77233' or zipCode = '77234' or zipCode = '77235' or zipCode = '77260' or zipCode = '77261' or zipCode = '77262' or zipCode = '77263' or zipCode = '77265' or zipCode = '77266' or zipCode = '77267' or zipCode = '77268' or zipCode = '77269' or zipCode = '77270' or zipCode = '77271' or zipCode = '77272' or zipCode = '77273' or zipCode = '77274' or zipCode = '77275' or zipCode = '77276' or zipCode = '77277' or zipCode = '77278' or zipCode = '77279' or zipCode = '77279' or zipCode = '77280' or zipCode = '77282' or zipCode = '77284' or zipCode = '77285' or zipCode = '77315' or zipCode = '77325' or zipCode = '77325' or zipCode = '77345' or zipCode = '77345' or zipCode = '77346' or zipCode = '77346' or zipCode = '77346' or zipCode = '77347' or zipCode = '77069' or zipCode = '77070' or zipCode = '77071' or zipCode = '77072' or zipCode = '77073' or zipCode = '77074' or zipCode = '77075' or zipCode = '77076' or zipCode = '77077' or zipCode = '77078' or zipCode = '77079' or zipCode = '77079' or zipCode = '77080' or zipCode = '77081' or zipCode = '77082' or zipCode = '77083' or zipCode = '77084' or zipCode = '77084' or zipCode = '77085' or zipCode = '77086' or zipCode = '77087' or zipCode = '77088' or zipCode = '77089' or zipCode = '77090' or zipCode = '77236' or zipCode = '77237' or zipCode = '77238' or zipCode = '77240' or zipCode = '77241' or zipCode = '77242' or zipCode = '77243' or zipCode = '77244' or zipCode = '77245' or zipCode = '77246' or zipCode = '77247' or zipCode = '77248' or zipCode = '77249' or zipCode = '77250' or zipCode = '77251' or zipCode = '77252' or zipCode = '77253' or zipCode = '77254' or zipCode = '77255' or zipCode = '77256' or zipCode = '77257' or zipCode = '77258' or zipCode = '77258' or zipCode = '77259' or zipCode = '77286' or zipCode = '77287' or zipCode = '77288' or zipCode = '77289' or zipCode = '77290' or zipCode = '77291' or zipCode = '77292' or zipCode = '77293' or zipCode = '77294' or zipCode = '77296' or zipCode = '77297' or zipCode = '77297' or zipCode = '77298' or zipCode = '77298' or zipCode = '77299' or zipCode = '77299' or zipCode = '77336' or zipCode = '77338' or zipCode = '77338' or zipCode = '77339' or zipCode = '77339' or zipCode = '77357' or zipCode = '77357' or zipCode = '77357' or zipCode = '77365' or zipCode = '77365' or zipCode = '77365' or zipCode = '77365' or zipCode = '77365' or zipCode = '77386' or zipCode = '77386' or zipCode = '77387' or zipCode = '77387' or zipCode = '77388' or zipCode = '77389' or zipCode = '77389' or zipCode = '77389' or zipCode = '77391' or zipCode = '77391' or zipCode = '77393' or zipCode = '77393' or zipCode = '77393' or zipCode = '77396' or zipCode = '77401' or zipCode = '77402' or zipCode = '77429' or zipCode = '77373' or zipCode = '77373' or zipCode = '77379' or zipCode = '77379' or zipCode = '77380' or zipCode = '77380' or zipCode = '77380' or zipCode = '77383' or zipCode = '77411' or zipCode = '77411' or zipCode = '77413' or zipCode = '77459' or zipCode = '77459' or zipCode = '77459' or zipCode = '77477' or zipCode = '77477' or zipCode = '77478' or zipCode = '77503' or zipCode = '77504' or zipCode = '77505' or zipCode = '77506' or zipCode = '77507' or zipCode = '77508' or zipCode = '77536' or zipCode = '77545' or zipCode = '77546' or zipCode = '77547' or zipCode = '77549' or zipCode = '77562' or zipCode = '77571' or zipCode = '77571' or zipCode = '77571' or zipCode = '77571' or zipCode = '77571' or zipCode = '77572' or zipCode = '77573' or zipCode = '77574' or zipCode = '77578' or zipCode = '77581' or zipCode = '77581' or zipCode = '77581' or zipCode = '77487' or zipCode = '77489' or zipCode = '77496' or zipCode = '77497' or zipCode = '77501' or zipCode = '77502' or zipCode = '77503' or zipCode = '77521' or zipCode = '77522' or zipCode = '77523' or zipCode = '77523' or zipCode = '77523' or zipCode = '77523' or zipCode = '77523' or zipCode = '77523' or zipCode = '77530' or zipCode = '77532' or zipCode = '77584' or zipCode = '77586' or zipCode = '77586' or zipCode = '77586' or zipCode = '77586' or zipCode = '77586' or zipCode = '77586' or zipCode = '77587' or zipCode = '77588' or zipCode = '77598' or zipCode = '77598' or zipCode = '77000' or zipCode = '77001' or zipCode = '77002' or zipCode = '77003' or zipCode = '77004' or zipCode = '77005' or zipCode = '77006' or zipCode = '77007' or zipCode = '77008' or zipCode = '77009' or zipCode = '77010' or zipCode = '77011' or zipCode = '77012' or zipCode = '77013' or zipCode = '77014' or zipCode = '77015' or zipCode = '77016' or zipCode = '77017' or zipCode = '77018' or zipCode = '77019' or zipCode = '77020' or zipCode = '77021' or zipCode = '77022' or zipCode = '77023' or zipCode = '77024' or zipCode = '77025' or zipCode = '77026' or zipCode = '77027' or zipCode = '77028' or zipCode = '77029' or zipCode = '77030' or zipCode = '77031' or zipCode = '77032' or zipCode = '77033' or zipCode = '77034' or zipCode = '77035' or zipCode = '77036' or zipCode = '77037' or zipCode = '77038' or zipCode = '77039' or zipCode = '77040' or zipCode = '77041' or zipCode = '77042' or zipCode = '77043' or zipCode = '77044' or zipCode = '77045' or zipCode = '77046' or zipCode = '77047' or zipCode = '77048' or zipCode = '77049' or zipCode = '77050' or zipCode = '77051' or zipCode = '77052' or zipCode = '77053' or zipCode = '77054' or zipCode = '77055' or zipCode = '77056' or zipCode = '77057' or zipCode = '77058' or zipCode = '77059' or zipCode = '77060' or zipCode = '77061' or zipCode = '77062' or zipCode = '77063' or zipCode = '77064' or zipCode = '77065' or zipCode = '77066' or zipCode = '77067' or zipCode = '77068' or zipCode = '77069' or zipCode = '77070' or zipCode = '77071' or zipCode = '77072' or zipCode = '77073' or zipCode = '77074' or zipCode = '77075' or zipCode = '77076' or zipCode = '77077' or zipCode = '77078' or zipCode = '77079' or zipCode = '77080' or zipCode = '77081' or zipCode = '77082' or zipCode = '77083' or zipCode = '77084' or zipCode = '77085' or zipCode = '77086' or zipCode = '77087' or zipCode = '77088' or zipCode = '77089' or zipCode = '77090' or zipCode = '77091' or zipCode = '77092' or zipCode = '77093' or zipCode = '77094' or zipCode = '77095' or zipCode = '77096' or zipCode = '77097' or zipCode = '77098' or zipCode = '77099' or zipCode = '77201' or zipCode = '77202' or zipCode = '77203' or zipCode = '77204' or zipCode = '77205' or zipCode = '77206' or zipCode = '77207' or zipCode = '77208' or zipCode = '77209' or zipCode = '77210' or zipCode = '77212' or zipCode = '77213' or zipCode = '77215' or zipCode = '77216' or zipCode = '77217' or zipCode = '77218' or zipCode = '77219' or zipCode = '77220' or zipCode = '77221' or zipCode = '77222' or zipCode = '77223' or zipCode = '77224' or zipCode = '77225' or zipCode = '77226' or zipCode = '77227' or zipCode = '77228' or zipCode = '77229' or zipCode = '77230' or zipCode = '77231' or zipCode = '77233' or zipCode = '77234' or zipCode = '77235' or zipCode = '77236' or zipCode = '77237' or zipCode = '77238' or zipCode = '77240' or zipCode = '77241' or zipCode = '77242' or zipCode = '77243' or zipCode = '77244' or zipCode = '77245' or zipCode = '77248' or zipCode = '77249' or zipCode = '77251' or zipCode = '77252' or zipCode = '77253' or zipCode = '77254' or zipCode = '77255' or zipCode = '77256' or zipCode = '77257' or zipCode = '77258' or zipCode = '77259' or zipCode = '77261' or zipCode = '77262' or zipCode = '77263' or zipCode = '77265' or zipCode = '77266' or zipCode = '77267' or zipCode = '77268' or zipCode = '77269' or zipCode = '77270' or zipCode = '77271' or zipCode = '77272' or zipCode = '77273' or zipCode = '77274' or zipCode = '77275' or zipCode = '77277' or zipCode = '77279' or zipCode = '77280' or zipCode = '77281' or zipCode = '77282' or zipCode = '77284' or zipCode = '77287' or zipCode = '77288' or zipCode = '77289' or zipCode = '77290' or zipCode = '77291' or zipCode = '77292' or zipCode = '77293' or zipCode = '77297' or zipCode = '77298' or zipCode = '77299' or zipCode = '77315' or zipCode = '77325' or zipCode = '77336' or zipCode = '77337' or zipCode = '77338' or zipCode = '77339' or zipCode = '77345' or zipCode = '77346' or zipCode = '77347' or zipCode = '77365' or zipCode = '77373' or zipCode = '77377' or zipCode = '77379' or zipCode = '77380' or zipCode = '77383' or zipCode = '77386' or zipCode = '77388' or zipCode = '77389' or zipCode = '77391' or zipCode = '77396' or zipCode = '77401' or zipCode = '77402' or zipCode = '77410' or zipCode = '77411' or zipCode = '77413' or zipCode = '77429' or zipCode = '77459' or zipCode = '77477' or zipCode = '77478' or zipCode = '77489' or zipCode = '77491' or zipCode = '77492' or zipCode = '77501' or zipCode = '77502' or zipCode = '77503' or zipCode = '77504' or zipCode = '77505' or zipCode = '77506' or zipCode = '77507' or zipCode = '77508' or zipCode = '77520' or zipCode = '77521' or zipCode = '77522' or zipCode = '77530' or zipCode = '77532' or zipCode = '77536' or zipCode = '77545' or zipCode = '77546' or zipCode = '77547' or zipCode = '77562' or zipCode = '77567' or zipCode = '77571' or zipCode = '77572' or zipCode = '77578' or zipCode = '77581' or zipCode = '77584' or zipCode = '77586' or zipCode = '77587' or zipCode = '77588' or zipCode = '77593' or zipCode = '77598') 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 ='77008' or zipCode = '77008' or zipCode = '77009' or zipCode = '77010' or zipCode = '77011' or zipCode = '77012' or zipCode = '77013' or zipCode = '77014' or zipCode = '77015' or zipCode = '77015' or zipCode = '77015' or zipCode = '77016' or zipCode = '77017' or zipCode = '77018' or zipCode = '77019' or zipCode = '77020' or zipCode = '77021' or zipCode = '77022' or zipCode = '77023' or zipCode = '77024' or zipCode = '77024' or zipCode = '77024' or zipCode = '77024' or zipCode = '77039' or zipCode = '77040' or zipCode = '77040' or zipCode = '77040' or zipCode = '77040' or zipCode = '77040' or zipCode = '77040' or zipCode = '77041' or zipCode = '77041' or zipCode = '77041' or zipCode = '77042' or zipCode = '77043' or zipCode = '77044' or zipCode = '77045' or zipCode = '77045' or zipCode = '77046' or zipCode = '77046' or zipCode = '77047' or zipCode = '77048' or zipCode = '77049' or zipCode = '77050' or zipCode = '77051' or zipCode = '77052' or zipCode = '77001' or zipCode = '77002' or zipCode = '77002' or zipCode = '77003' or zipCode = '77004' or zipCode = '77005' or zipCode = '77005' or zipCode = '77005' or zipCode = '77005' or zipCode = '77006' or zipCode = '77007' or zipCode = '77008' or zipCode = '77024' or zipCode = '77024' or zipCode = '77024' or zipCode = '77025' or zipCode = '77025' or zipCode = '77025' or zipCode = '77026' or zipCode = '77027' or zipCode = '77028' or zipCode = '77028' or zipCode = '77029' or zipCode = '77030' or zipCode = '77030' or zipCode = '77031' or zipCode = '77032' or zipCode = '77033' or zipCode = '77034' or zipCode = '77035' or zipCode = '77036' or zipCode = '77036' or zipCode = '77037' or zipCode = '77038' or zipCode = '77039' or zipCode = '77053' or zipCode = '77054' or zipCode = '77054' or zipCode = '77055' or zipCode = '77055' or zipCode = '77056' or zipCode = '77057' or zipCode = '77058' or zipCode = '77058' or zipCode = '77058' or zipCode = '77058' or zipCode = '77059' or zipCode = '77060' or zipCode = '77061' or zipCode = '77062' or zipCode = '77063' or zipCode = '77064' or zipCode = '77065' or zipCode = '77065' or zipCode = '77065' or zipCode = '77066' or zipCode = '77067' or zipCode = '77068' or zipCode = '77091' or zipCode = '77092' or zipCode = '77093' or zipCode = '77094' or zipCode = '77095' or zipCode = '77096' or zipCode = '77097' or zipCode = '77098' or zipCode = '77099' or zipCode = '77201' or zipCode = '77201' or zipCode = '77202' or zipCode = '77203' or zipCode = '77204' or zipCode = '77204' or zipCode = '77205' or zipCode = '77206' or zipCode = '77207' or zipCode = '77208' or zipCode = '77209' or zipCode = '77209' or zipCode = '77210' or zipCode = '77212' or zipCode = '77212' or zipCode = '77213' or zipCode = '77215' or zipCode = '77216' or zipCode = '77216' or zipCode = '77217' or zipCode = '77218' or zipCode = '77219' or zipCode = '77220' or zipCode = '77221' or zipCode = '77222' or zipCode = '77223' or zipCode = '77224' or zipCode = '77224' or zipCode = '77225' or zipCode = '77226' or zipCode = '77227' or zipCode = '77228' or zipCode = '77229' or zipCode = '77230' or zipCode = '77230' or zipCode = '77231' or zipCode = '77233' or zipCode = '77234' or zipCode = '77235' or zipCode = '77260' or zipCode = '77261' or zipCode = '77262' or zipCode = '77263' or zipCode = '77265' or zipCode = '77266' or zipCode = '77267' or zipCode = '77268' or zipCode = '77269' or zipCode = '77270' or zipCode = '77271' or zipCode = '77272' or zipCode = '77273' or zipCode = '77274' or zipCode = '77275' or zipCode = '77276' or zipCode = '77277' or zipCode = '77278' or zipCode = '77279' or zipCode = '77279' or zipCode = '77280' or zipCode = '77282' or zipCode = '77284' or zipCode = '77285' or zipCode = '77315' or zipCode = '77325' or zipCode = '77325' or zipCode = '77345' or zipCode = '77345' or zipCode = '77346' or zipCode = '77346' or zipCode = '77346' or zipCode = '77347' or zipCode = '77069' or zipCode = '77070' or zipCode = '77071' or zipCode = '77072' or zipCode = '77073' or zipCode = '77074' or zipCode = '77075' or zipCode = '77076' or zipCode = '77077' or zipCode = '77078' or zipCode = '77079' or zipCode = '77079' or zipCode = '77080' or zipCode = '77081' or zipCode = '77082' or zipCode = '77083' or zipCode = '77084' or zipCode = '77084' or zipCode = '77085' or zipCode = '77086' or zipCode = '77087' or zipCode = '77088' or zipCode = '77089' or zipCode = '77090' or zipCode = '77236' or zipCode = '77237' or zipCode = '77238' or zipCode = '77240' or zipCode = '77241' or zipCode = '77242' or zipCode = '77243' or zipCode = '77244' or zipCode = '77245' or zipCode = '77246' or zipCode = '77247' or zipCode = '77248' or zipCode = '77249' or zipCode = '77250' or zipCode = '77251' or zipCode = '77252' or zipCode = '77253' or zipCode = '77254' or zipCode = '77255' or zipCode = '77256' or zipCode = '77257' or zipCode = '77258' or zipCode = '77258' or zipCode = '77259' or zipCode = '77286' or zipCode = '77287' or zipCode = '77288' or zipCode = '77289' or zipCode = '77290' or zipCode = '77291' or zipCode = '77292' or zipCode = '77293' or zipCode = '77294' or zipCode = '77296' or zipCode = '77297' or zipCode = '77297' or zipCode = '77298' or zipCode = '77298' or zipCode = '77299' or zipCode = '77299' or zipCode = '77336' or zipCode = '77338' or zipCode = '77338' or zipCode = '77339' or zipCode = '77339' or zipCode = '77357' or zipCode = '77357' or zipCode = '77357' or zipCode = '77365' or zipCode = '77365' or zipCode = '77365' or zipCode = '77365' or zipCode = '77365' or zipCode = '77386' or zipCode = '77386' or zipCode = '77387' or zipCode = '77387' or zipCode = '77388' or zipCode = '77389' or zipCode = '77389' or zipCode = '77389' or zipCode = '77391' or zipCode = '77391' or zipCode = '77393' or zipCode = '77393' or zipCode = '77393' or zipCode = '77396' or zipCode = '77401' or zipCode = '77402' or zipCode = '77429' or zipCode = '77373' or zipCode = '77373' or zipCode = '77379' or zipCode = '77379' or zipCode = '77380' or zipCode = '77380' or zipCode = '77380' or zipCode = '77383' or zipCode = '77411' or zipCode = '77411' or zipCode = '77413' or zipCode = '77459' or zipCode = '77459' or zipCode = '77459' or zipCode = '77477' or zipCode = '77477' or zipCode = '77478' or zipCode = '77503' or zipCode = '77504' or zipCode = '77505' or zipCode = '77506' or zipCode = '77507' or zipCode = '77508' or zipCode = '77536' or zipCode = '77545' or zipCode = '77546' or zipCode = '77547' or zipCode = '77549' or zipCode = '77562' or zipCode = '77571' or zipCode = '77571' or zipCode = '77571' or zipCode = '77571' or zipCode = '77571' or zipCode = '77572' or zipCode = '77573' or zipCode = '77574' or zipCode = '77578' or zipCode = '77581' or zipCode = '77581' or zipCode = '77581' or zipCode = '77487' or zipCode = '77489' or zipCode = '77496' or zipCode = '77497' or zipCode = '77501' or zipCode = '77502' or zipCode = '77503' or zipCode = '77521' or zipCode = '77522' or zipCode = '77523' or zipCode = '77523' or zipCode = '77523' or zipCode = '77523' or zipCode = '77523' or zipCode = '77523' or zipCode = '77530' or zipCode = '77532' or zipCode = '77584' or zipCode = '77586' or zipCode = '77586' or zipCode = '77586' or zipCode = '77586' or zipCode = '77586' or zipCode = '77586' or zipCode = '77587' or zipCode = '77588' or zipCode = '77598' or zipCode = '77598' or zipCode = '77000' or zipCode = '77001' or zipCode = '77002' or zipCode = '77003' or zipCode = '77004' or zipCode = '77005' or zipCode = '77006' or zipCode = '77007' or zipCode = '77008' or zipCode = '77009' or zipCode = '77010' or zipCode = '77011' or zipCode = '77012' or zipCode = '77013' or zipCode = '77014' or zipCode = '77015' or zipCode = '77016' or zipCode = '77017' or zipCode = '77018' or zipCode = '77019' or zipCode = '77020' or zipCode = '77021' or zipCode = '77022' or zipCode = '77023' or zipCode = '77024' or zipCode = '77025' or zipCode = '77026' or zipCode = '77027' or zipCode = '77028' or zipCode = '77029' or zipCode = '77030' or zipCode = '77031' or zipCode = '77032' or zipCode = '77033' or zipCode = '77034' or zipCode = '77035' or zipCode = '77036' or zipCode = '77037' or zipCode = '77038' or zipCode = '77039' or zipCode = '77040' or zipCode = '77041' or zipCode = '77042' or zipCode = '77043' or zipCode = '77044' or zipCode = '77045' or zipCode = '77046' or zipCode = '77047' or zipCode = '77048' or zipCode = '77049' or zipCode = '77050' or zipCode = '77051' or zipCode = '77052' or zipCode = '77053' or zipCode = '77054' or zipCode = '77055' or zipCode = '77056' or zipCode = '77057' or zipCode = '77058' or zipCode = '77059' or zipCode = '77060' or zipCode = '77061' or zipCode = '77062' or zipCode = '77063' or zipCode = '77064' or zipCode = '77065' or zipCode = '77066' or zipCode = '77067' or zipCode = '77068' or zipCode = '77069' or zipCode = '77070' or zipCode = '77071' or zipCode = '77072' or zipCode = '77073' or zipCode = '77074' or zipCode = '77075' or zipCode = '77076' or zipCode = '77077' or zipCode = '77078' or zipCode = '77079' or zipCode = '77080' or zipCode = '77081' or zipCode = '77082' or zipCode = '77083' or zipCode = '77084' or zipCode = '77085' or zipCode = '77086' or zipCode = '77087' or zipCode = '77088' or zipCode = '77089' or zipCode = '77090' or zipCode = '77091' or zipCode = '77092' or zipCode = '77093' or zipCode = '77094' or zipCode = '77095' or zipCode = '77096' or zipCode = '77097' or zipCode = '77098' or zipCode = '77099' or zipCode = '77201' or zipCode = '77202' or zipCode = '77203' or zipCode = '77204' or zipCode = '77205' or zipCode = '77206' or zipCode = '77207' or zipCode = '77208' or zipCode = '77209' or zipCode = '77210' or zipCode = '77212' or zipCode = '77213' or zipCode = '77215' or zipCode = '77216' or zipCode = '77217' or zipCode = '77218' or zipCode = '77219' or zipCode = '77220' or zipCode = '77221' or zipCode = '77222' or zipCode = '77223' or zipCode = '77224' or zipCode = '77225' or zipCode = '77226' or zipCode = '77227' or zipCode = '77228' or zipCode = '77229' or zipCode = '77230' or zipCode = '77231' or zipCode = '77233' or zipCode = '77234' or zipCode = '77235' or zipCode = '77236' or zipCode = '77237' or zipCode = '77238' or zipCode = '77240' or zipCode = '77241' or zipCode = '77242' or zipCode = '77243' or zipCode = '77244' or zipCode = '77245' or zipCode = '77248' or zipCode = '77249' or zipCode = '77251' or zipCode = '77252' or zipCode = '77253' or zipCode = '77254' or zipCode = '77255' or zipCode = '77256' or zipCode = '77257' or zipCode = '77258' or zipCode = '77259' or zipCode = '77261' or zipCode = '77262' or zipCode = '77263' or zipCode = '77265' or zipCode = '77266' or zipCode = '77267' or zipCode = '77268' or zipCode = '77269' or zipCode = '77270' or zipCode = '77271' or zipCode = '77272' or zipCode = '77273' or zipCode = '77274' or zipCode = '77275' or zipCode = '77277' or zipCode = '77279' or zipCode = '77280' or zipCode = '77281' or zipCode = '77282' or zipCode = '77284' or zipCode = '77287' or zipCode = '77288' or zipCode = '77289' or zipCode = '77290' or zipCode = '77291' or zipCode = '77292' or zipCode = '77293' or zipCode = '77297' or zipCode = '77298' or zipCode = '77299' or zipCode = '77315' or zipCode = '77325' or zipCode = '77336' or zipCode = '77337' or zipCode = '77338' or zipCode = '77339' or zipCode = '77345' or zipCode = '77346' or zipCode = '77347' or zipCode = '77365' or zipCode = '77373' or zipCode = '77377' or zipCode = '77379' or zipCode = '77380' or zipCode = '77383' or zipCode = '77386' or zipCode = '77388' or zipCode = '77389' or zipCode = '77391' or zipCode = '77396' or zipCode = '77401' or zipCode = '77402' or zipCode = '77410' or zipCode = '77411' or zipCode = '77413' or zipCode = '77429' or zipCode = '77459' or zipCode = '77477' or zipCode = '77478' or zipCode = '77489' or zipCode = '77491' or zipCode = '77492' or zipCode = '77501' or zipCode = '77502' or zipCode = '77503' or zipCode = '77504' or zipCode = '77505' or zipCode = '77506' or zipCode = '77507' or zipCode = '77508' or zipCode = '77520' or zipCode = '77521' or zipCode = '77522' or zipCode = '77530' or zipCode = '77532' or zipCode = '77536' or zipCode = '77545' or zipCode = '77546' or zipCode = '77547' or zipCode = '77562' or zipCode = '77567' or zipCode = '77571' or zipCode = '77572' or zipCode = '77578' or zipCode = '77581' or zipCode = '77584' or zipCode = '77586' or zipCode = '77587' or zipCode = '77588' or zipCode = '77593' or zipCode = '77598') 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 ='77008' or zipCode = '77008' or zipCode = '77009' or zipCode = '77010' or zipCode = '77011' or zipCode = '77012' or zipCode = '77013' or zipCode = '77014' or zipCode = '77015' or zipCode = '77015' or zipCode = '77015' or zipCode = '77016' or zipCode = '77017' or zipCode = '77018' or zipCode = '77019' or zipCode = '77020' or zipCode = '77021' or zipCode = '77022' or zipCode = '77023' or zipCode = '77024' or zipCode = '77024' or zipCode = '77024' or zipCode = '77024' or zipCode = '77039' or zipCode = '77040' or zipCode = '77040' or zipCode = '77040' or zipCode = '77040' or zipCode = '77040' or zipCode = '77040' or zipCode = '77041' or zipCode = '77041' or zipCode = '77041' or zipCode = '77042' or zipCode = '77043' or zipCode = '77044' or zipCode = '77045' or zipCode = '77045' or zipCode = '77046' or zipCode = '77046' or zipCode = '77047' or zipCode = '77048' or zipCode = '77049' or zipCode = '77050' or zipCode = '77051' or zipCode = '77052' or zipCode = '77001' or zipCode = '77002' or zipCode = '77002' or zipCode = '77003' or zipCode = '77004' or zipCode = '77005' or zipCode = '77005' or zipCode = '77005' or zipCode = '77005' or zipCode = '77006' or zipCode = '77007' or zipCode = '77008' or zipCode = '77024' or zipCode = '77024' or zipCode = '77024' or zipCode = '77025' or zipCode = '77025' or zipCode = '77025' or zipCode = '77026' or zipCode = '77027' or zipCode = '77028' or zipCode = '77028' or zipCode = '77029' or zipCode = '77030' or zipCode = '77030' or zipCode = '77031' or zipCode = '77032' or zipCode = '77033' or zipCode = '77034' or zipCode = '77035' or zipCode = '77036' or zipCode = '77036' or zipCode = '77037' or zipCode = '77038' or zipCode = '77039' or zipCode = '77053' or zipCode = '77054' or zipCode = '77054' or zipCode = '77055' or zipCode = '77055' or zipCode = '77056' or zipCode = '77057' or zipCode = '77058' or zipCode = '77058' or zipCode = '77058' or zipCode = '77058' or zipCode = '77059' or zipCode = '77060' or zipCode = '77061' or zipCode = '77062' or zipCode = '77063' or zipCode = '77064' or zipCode = '77065' or zipCode = '77065' or zipCode = '77065' or zipCode = '77066' or zipCode = '77067' or zipCode = '77068' or zipCode = '77091' or zipCode = '77092' or zipCode = '77093' or zipCode = '77094' or zipCode = '77095' or zipCode = '77096' or zipCode = '77097' or zipCode = '77098' or zipCode = '77099' or zipCode = '77201' or zipCode = '77201' or zipCode = '77202' or zipCode = '77203' or zipCode = '77204' or zipCode = '77204' or zipCode = '77205' or zipCode = '77206' or zipCode = '77207' or zipCode = '77208' or zipCode = '77209' or zipCode = '77209' or zipCode = '77210' or zipCode = '77212' or zipCode = '77212' or zipCode = '77213' or zipCode = '77215' or zipCode = '77216' or zipCode = '77216' or zipCode = '77217' or zipCode = '77218' or zipCode = '77219' or zipCode = '77220' or zipCode = '77221' or zipCode = '77222' or zipCode = '77223' or zipCode = '77224' or zipCode = '77224' or zipCode = '77225' or zipCode = '77226' or zipCode = '77227' or zipCode = '77228' or zipCode = '77229' or zipCode = '77230' or zipCode = '77230' or zipCode = '77231' or zipCode = '77233' or zipCode = '77234' or zipCode = '77235' or zipCode = '77260' or zipCode = '77261' or zipCode = '77262' or zipCode = '77263' or zipCode = '77265' or zipCode = '77266' or zipCode = '77267' or zipCode = '77268' or zipCode = '77269' or zipCode = '77270' or zipCode = '77271' or zipCode = '77272' or zipCode = '77273' or zipCode = '77274' or zipCode = '77275' or zipCode = '77276' or zipCode = '77277' or zipCode = '77278' or zipCode = '77279' or zipCode = '77279' or zipCode = '77280' or zipCode = '77282' or zipCode = '77284' or zipCode = '77285' or zipCode = '77315' or zipCode = '77325' or zipCode = '77325' or zipCode = '77345' or zipCode = '77345' or zipCode = '77346' or zipCode = '77346' or zipCode = '77346' or zipCode = '77347' or zipCode = '77069' or zipCode = '77070' or zipCode = '77071' or zipCode = '77072' or zipCode = '77073' or zipCode = '77074' or zipCode = '77075' or zipCode = '77076' or zipCode = '77077' or zipCode = '77078' or zipCode = '77079' or zipCode = '77079' or zipCode = '77080' or zipCode = '77081' or zipCode = '77082' or zipCode = '77083' or zipCode = '77084' or zipCode = '77084' or zipCode = '77085' or zipCode = '77086' or zipCode = '77087' or zipCode = '77088' or zipCode = '77089' or zipCode = '77090' or zipCode = '77236' or zipCode = '77237' or zipCode = '77238' or zipCode = '77240' or zipCode = '77241' or zipCode = '77242' or zipCode = '77243' or zipCode = '77244' or zipCode = '77245' or zipCode = '77246' or zipCode = '77247' or zipCode = '77248' or zipCode = '77249' or zipCode = '77250' or zipCode = '77251' or zipCode = '77252' or zipCode = '77253' or zipCode = '77254' or zipCode = '77255' or zipCode = '77256' or zipCode = '77257' or zipCode = '77258' or zipCode = '77258' or zipCode = '77259' or zipCode = '77286' or zipCode = '77287' or zipCode = '77288' or zipCode = '77289' or zipCode = '77290' or zipCode = '77291' or zipCode = '77292' or zipCode = '77293' or zipCode = '77294' or zipCode = '77296' or zipCode = '77297' or zipCode = '77297' or zipCode = '77298' or zipCode = '77298' or zipCode = '77299' or zipCode = '77299' or zipCode = '77336' or zipCode = '77338' or zipCode = '77338' or zipCode = '77339' or zipCode = '77339' or zipCode = '77357' or zipCode = '77357' or zipCode = '77357' or zipCode = '77365' or zipCode = '77365' or zipCode = '77365' or zipCode = '77365' or zipCode = '77365' or zipCode = '77386' or zipCode = '77386' or zipCode = '77387' or zipCode = '77387' or zipCode = '77388' or zipCode = '77389' or zipCode = '77389' or zipCode = '77389' or zipCode = '77391' or zipCode = '77391' or zipCode = '77393' or zipCode = '77393' or zipCode = '77393' or zipCode = '77396' or zipCode = '77401' or zipCode = '77402' or zipCode = '77429' or zipCode = '77373' or zipCode = '77373' or zipCode = '77379' or zipCode = '77379' or zipCode = '77380' or zipCode = '77380' or zipCode = '77380' or zipCode = '77383' or zipCode = '77411' or zipCode = '77411' or zipCode = '77413' or zipCode = '77459' or zipCode = '77459' or zipCode = '77459' or zipCode = '77477' or zipCode = '77477' or zipCode = '77478' or zipCode = '77503' or zipCode = '77504' or zipCode = '77505' or zipCode = '77506' or zipCode = '77507' or zipCode = '77508' or zipCode = '77536' or zipCode = '77545' or zipCode = '77546' or zipCode = '77547' or zipCode = '77549' or zipCode = '77562' or zipCode = '77571' or zipCode = '77571' or zipCode = '77571' or zipCode = '77571' or zipCode = '77571' or zipCode = '77572' or zipCode = '77573' or zipCode = '77574' or zipCode = '77578' or zipCode = '77581' or zipCode = '77581' or zipCode = '77581' or zipCode = '77487' or zipCode = '77489' or zipCode = '77496' or zipCode = '77497' or zipCode = '77501' or zipCode = '77502' or zipCode = '77503' or zipCode = '77521' or zipCode = '77522' or zipCode = '77523' or zipCode = '77523' or zipCode = '77523' or zipCode = '77523' or zipCode = '77523' or zipCode = '77523' or zipCode = '77530' or zipCode = '77532' or zipCode = '77584' or zipCode = '77586' or zipCode = '77586' or zipCode = '77586' or zipCode = '77586' or zipCode = '77586' or zipCode = '77586' or zipCode = '77587' or zipCode = '77588' or zipCode = '77598' or zipCode = '77598' or zipCode = '77000' or zipCode = '77001' or zipCode = '77002' or zipCode = '77003' or zipCode = '77004' or zipCode = '77005' or zipCode = '77006' or zipCode = '77007' or zipCode = '77008' or zipCode = '77009' or zipCode = '77010' or zipCode = '77011' or zipCode = '77012' or zipCode = '77013' or zipCode = '77014' or zipCode = '77015' or zipCode = '77016' or zipCode = '77017' or zipCode = '77018' or zipCode = '77019' or zipCode = '77020' or zipCode = '77021' or zipCode = '77022' or zipCode = '77023' or zipCode = '77024' or zipCode = '77025' or zipCode = '77026' or zipCode = '77027' or zipCode = '77028' or zipCode = '77029' or zipCode = '77030' or zipCode = '77031' or zipCode = '77032' or zipCode = '77033' or zipCode = '77034' or zipCode = '77035' or zipCode = '77036' or zipCode = '77037' or zipCode = '77038' or zipCode = '77039' or zipCode = '77040' or zipCode = '77041' or zipCode = '77042' or zipCode = '77043' or zipCode = '77044' or zipCode = '77045' or zipCode = '77046' or zipCode = '77047' or zipCode = '77048' or zipCode = '77049' or zipCode = '77050' or zipCode = '77051' or zipCode = '77052' or zipCode = '77053' or zipCode = '77054' or zipCode = '77055' or zipCode = '77056' or zipCode = '77057' or zipCode = '77058' or zipCode = '77059' or zipCode = '77060' or zipCode = '77061' or zipCode = '77062' or zipCode = '77063' or zipCode = '77064' or zipCode = '77065' or zipCode = '77066' or zipCode = '77067' or zipCode = '77068' or zipCode = '77069' or zipCode = '77070' or zipCode = '77071' or zipCode = '77072' or zipCode = '77073' or zipCode = '77074' or zipCode = '77075' or zipCode = '77076' or zipCode = '77077' or zipCode = '77078' or zipCode = '77079' or zipCode = '77080' or zipCode = '77081' or zipCode = '77082' or zipCode = '77083' or zipCode = '77084' or zipCode = '77085' or zipCode = '77086' or zipCode = '77087' or zipCode = '77088' or zipCode = '77089' or zipCode = '77090' or zipCode = '77091' or zipCode = '77092' or zipCode = '77093' or zipCode = '77094' or zipCode = '77095' or zipCode = '77096' or zipCode = '77097' or zipCode = '77098' or zipCode = '77099' or zipCode = '77201' or zipCode = '77202' or zipCode = '77203' or zipCode = '77204' or zipCode = '77205' or zipCode = '77206' or zipCode = '77207' or zipCode = '77208' or zipCode = '77209' or zipCode = '77210' or zipCode = '77212' or zipCode = '77213' or zipCode = '77215' or zipCode = '77216' or zipCode = '77217' or zipCode = '77218' or zipCode = '77219' or zipCode = '77220' or zipCode = '77221' or zipCode = '77222' or zipCode = '77223' or zipCode = '77224' or zipCode = '77225' or zipCode = '77226' or zipCode = '77227' or zipCode = '77228' or zipCode = '77229' or zipCode = '77230' or zipCode = '77231' or zipCode = '77233' or zipCode = '77234' or zipCode = '77235' or zipCode = '77236' or zipCode = '77237' or zipCode = '77238' or zipCode = '77240' or zipCode = '77241' or zipCode = '77242' or zipCode = '77243' or zipCode = '77244' or zipCode = '77245' or zipCode = '77248' or zipCode = '77249' or zipCode = '77251' or zipCode = '77252' or zipCode = '77253' or zipCode = '77254' or zipCode = '77255' or zipCode = '77256' or zipCode = '77257' or zipCode = '77258' or zipCode = '77259' or zipCode = '77261' or zipCode = '77262' or zipCode = '77263' or zipCode = '77265' or zipCode = '77266' or zipCode = '77267' or zipCode = '77268' or zipCode = '77269' or zipCode = '77270' or zipCode = '77271' or zipCode = '77272' or zipCode = '77273' or zipCode = '77274' or zipCode = '77275' or zipCode = '77277' or zipCode = '77279' or zipCode = '77280' or zipCode = '77281' or zipCode = '77282' or zipCode = '77284' or zipCode = '77287' or zipCode = '77288' or zipCode = '77289' or zipCode = '77290' or zipCode = '77291' or zipCode = '77292' or zipCode = '77293' or zipCode = '77297' or zipCode = '77298' or zipCode = '77299' or zipCode = '77315' or zipCode = '77325' or zipCode = '77336' or zipCode = '77337' or zipCode = '77338' or zipCode = '77339' or zipCode = '77345' or zipCode = '77346' or zipCode = '77347' or zipCode = '77365' or zipCode = '77373' or zipCode = '77377' or zipCode = '77379' or zipCode = '77380' or zipCode = '77383' or zipCode = '77386' or zipCode = '77388' or zipCode = '77389' or zipCode = '77391' or zipCode = '77396' or zipCode = '77401' or zipCode = '77402' or zipCode = '77410' or zipCode = '77411' or zipCode = '77413' or zipCode = '77429' or zipCode = '77459' or zipCode = '77477' or zipCode = '77478' or zipCode = '77489' or zipCode = '77491' or zipCode = '77492' or zipCode = '77501' or zipCode = '77502' or zipCode = '77503' or zipCode = '77504' or zipCode = '77505' or zipCode = '77506' or zipCode = '77507' or zipCode = '77508' or zipCode = '77520' or zipCode = '77521' or zipCode = '77522' or zipCode = '77530' or zipCode = '77532' or zipCode = '77536' or zipCode = '77545' or zipCode = '77546' or zipCode = '77547' or zipCode = '77562' or zipCode = '77567' or zipCode = '77571' or zipCode = '77572' or zipCode = '77578' or zipCode = '77581' or zipCode = '77584' or zipCode = '77586' or zipCode = '77587' or zipCode = '77588' or zipCode = '77593' or zipCode = '77598') 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 ='77008' or zipCode = '77008' or zipCode = '77009' or zipCode = '77010' or zipCode = '77011' or zipCode = '77012' or zipCode = '77013' or zipCode = '77014' or zipCode = '77015' or zipCode = '77015' or zipCode = '77015' or zipCode = '77016' or zipCode = '77017' or zipCode = '77018' or zipCode = '77019' or zipCode = '77020' or zipCode = '77021' or zipCode = '77022' or zipCode = '77023' or zipCode = '77024' or zipCode = '77024' or zipCode = '77024' or zipCode = '77024' or zipCode = '77039' or zipCode = '77040' or zipCode = '77040' or zipCode = '77040' or zipCode = '77040' or zipCode = '77040' or zipCode = '77040' or zipCode = '77041' or zipCode = '77041' or zipCode = '77041' or zipCode = '77042' or zipCode = '77043' or zipCode = '77044' or zipCode = '77045' or zipCode = '77045' or zipCode = '77046' or zipCode = '77046' or zipCode = '77047' or zipCode = '77048' or zipCode = '77049' or zipCode = '77050' or zipCode = '77051' or zipCode = '77052' or zipCode = '77001' or zipCode = '77002' or zipCode = '77002' or zipCode = '77003' or zipCode = '77004' or zipCode = '77005' or zipCode = '77005' or zipCode = '77005' or zipCode = '77005' or zipCode = '77006' or zipCode = '77007' or zipCode = '77008' or zipCode = '77024' or zipCode = '77024' or zipCode = '77024' or zipCode = '77025' or zipCode = '77025' or zipCode = '77025' or zipCode = '77026' or zipCode = '77027' or zipCode = '77028' or zipCode = '77028' or zipCode = '77029' or zipCode = '77030' or zipCode = '77030' or zipCode = '77031' or zipCode = '77032' or zipCode = '77033' or zipCode = '77034' or zipCode = '77035' or zipCode = '77036' or zipCode = '77036' or zipCode = '77037' or zipCode = '77038' or zipCode = '77039' or zipCode = '77053' or zipCode = '77054' or zipCode = '77054' or zipCode = '77055' or zipCode = '77055' or zipCode = '77056' or zipCode = '77057' or zipCode = '77058' or zipCode = '77058' or zipCode = '77058' or zipCode = '77058' or zipCode = '77059' or zipCode = '77060' or zipCode = '77061' or zipCode = '77062' or zipCode = '77063' or zipCode = '77064' or zipCode = '77065' or zipCode = '77065' or zipCode = '77065' or zipCode = '77066' or zipCode = '77067' or zipCode = '77068' or zipCode = '77091' or zipCode = '77092' or zipCode = '77093' or zipCode = '77094' or zipCode = '77095' or zipCode = '77096' or zipCode = '77097' or zipCode = '77098' or zipCode = '77099' or zipCode = '77201' or zipCode = '77201' or zipCode = '77202' or zipCode = '77203' or zipCode = '77204' or zipCode = '77204' or zipCode = '77205' or zipCode = '77206' or zipCode = '77207' or zipCode = '77208' or zipCode = '77209' or zipCode = '77209' or zipCode = '77210' or zipCode = '77212' or zipCode = '77212' or zipCode = '77213' or zipCode = '77215' or zipCode = '77216' or zipCode = '77216' or zipCode = '77217' or zipCode = '77218' or zipCode = '77219' or zipCode = '77220' or zipCode = '77221' or zipCode = '77222' or zipCode = '77223' or zipCode = '77224' or zipCode = '77224' or zipCode = '77225' or zipCode = '77226' or zipCode = '77227' or zipCode = '77228' or zipCode = '77229' or zipCode = '77230' or zipCode = '77230' or zipCode = '77231' or zipCode = '77233' or zipCode = '77234' or zipCode = '77235' or zipCode = '77260' or zipCode = '77261' or zipCode = '77262' or zipCode = '77263' or zipCode = '77265' or zipCode = '77266' or zipCode = '77267' or zipCode = '77268' or zipCode = '77269' or zipCode = '77270' or zipCode = '77271' or zipCode = '77272' or zipCode = '77273' or zipCode = '77274' or zipCode = '77275' or zipCode = '77276' or zipCode = '77277' or zipCode = '77278' or zipCode = '77279' or zipCode = '77279' or zipCode = '77280' or zipCode = '77282' or zipCode = '77284' or zipCode = '77285' or zipCode = '77315' or zipCode = '77325' or zipCode = '77325' or zipCode = '77345' or zipCode = '77345' or zipCode = '77346' or zipCode = '77346' or zipCode = '77346' or zipCode = '77347' or zipCode = '77069' or zipCode = '77070' or zipCode = '77071' or zipCode = '77072' or zipCode = '77073' or zipCode = '77074' or zipCode = '77075' or zipCode = '77076' or zipCode = '77077' or zipCode = '77078' or zipCode = '77079' or zipCode = '77079' or zipCode = '77080' or zipCode = '77081' or zipCode = '77082' or zipCode = '77083' or zipCode = '77084' or zipCode = '77084' or zipCode = '77085' or zipCode = '77086' or zipCode = '77087' or zipCode = '77088' or zipCode = '77089' or zipCode = '77090' or zipCode = '77236' or zipCode = '77237' or zipCode = '77238' or zipCode = '77240' or zipCode = '77241' or zipCode = '77242' or zipCode = '77243' or zipCode = '77244' or zipCode = '77245' or zipCode = '77246' or zipCode = '77247' or zipCode = '77248' or zipCode = '77249' or zipCode = '77250' or zipCode = '77251' or zipCode = '77252' or zipCode = '77253' or zipCode = '77254' or zipCode = '77255' or zipCode = '77256' or zipCode = '77257' or zipCode = '77258' or zipCode = '77258' or zipCode = '77259' or zipCode = '77286' or zipCode = '77287' or zipCode = '77288' or zipCode = '77289' or zipCode = '77290' or zipCode = '77291' or zipCode = '77292' or zipCode = '77293' or zipCode = '77294' or zipCode = '77296' or zipCode = '77297' or zipCode = '77297' or zipCode = '77298' or zipCode = '77298' or zipCode = '77299' or zipCode = '77299' or zipCode = '77336' or zipCode = '77338' or zipCode = '77338' or zipCode = '77339' or zipCode = '77339' or zipCode = '77357' or zipCode = '77357' or zipCode = '77357' or zipCode = '77365' or zipCode = '77365' or zipCode = '77365' or zipCode = '77365' or zipCode = '77365' or zipCode = '77386' or zipCode = '77386' or zipCode = '77387' or zipCode = '77387' or zipCode = '77388' or zipCode = '77389' or zipCode = '77389' or zipCode = '77389' or zipCode = '77391' or zipCode = '77391' or zipCode = '77393' or zipCode = '77393' or zipCode = '77393' or zipCode = '77396' or zipCode = '77401' or zipCode = '77402' or zipCode = '77429' or zipCode = '77373' or zipCode = '77373' or zipCode = '77379' or zipCode = '77379' or zipCode = '77380' or zipCode = '77380' or zipCode = '77380' or zipCode = '77383' or zipCode = '77411' or zipCode = '77411' or zipCode = '77413' or zipCode = '77459' or zipCode = '77459' or zipCode = '77459' or zipCode = '77477' or zipCode = '77477' or zipCode = '77478' or zipCode = '77503' or zipCode = '77504' or zipCode = '77505' or zipCode = '77506' or zipCode = '77507' or zipCode = '77508' or zipCode = '77536' or zipCode = '77545' or zipCode = '77546' or zipCode = '77547' or zipCode = '77549' or zipCode = '77562' or zipCode = '77571' or zipCode = '77571' or zipCode = '77571' or zipCode = '77571' or zipCode = '77571' or zipCode = '77572' or zipCode = '77573' or zipCode = '77574' or zipCode = '77578' or zipCode = '77581' or zipCode = '77581' or zipCode = '77581' or zipCode = '77487' or zipCode = '77489' or zipCode = '77496' or zipCode = '77497' or zipCode = '77501' or zipCode = '77502' or zipCode = '77503' or zipCode = '77521' or zipCode = '77522' or zipCode = '77523' or zipCode = '77523' or zipCode = '77523' or zipCode = '77523' or zipCode = '77523' or zipCode = '77523' or zipCode = '77530' or zipCode = '77532' or zipCode = '77584' or zipCode = '77586' or zipCode = '77586' or zipCode = '77586' or zipCode = '77586' or zipCode = '77586' or zipCode = '77586' or zipCode = '77587' or zipCode = '77588' or zipCode = '77598' or zipCode = '77598' or zipCode = '77000' or zipCode = '77001' or zipCode = '77002' or zipCode = '77003' or zipCode = '77004' or zipCode = '77005' or zipCode = '77006' or zipCode = '77007' or zipCode = '77008' or zipCode = '77009' or zipCode = '77010' or zipCode = '77011' or zipCode = '77012' or zipCode = '77013' or zipCode = '77014' or zipCode = '77015' or zipCode = '77016' or zipCode = '77017' or zipCode = '77018' or zipCode = '77019' or zipCode = '77020' or zipCode = '77021' or zipCode = '77022' or zipCode = '77023' or zipCode = '77024' or zipCode = '77025' or zipCode = '77026' or zipCode = '77027' or zipCode = '77028' or zipCode = '77029' or zipCode = '77030' or zipCode = '77031' or zipCode = '77032' or zipCode = '77033' or zipCode = '77034' or zipCode = '77035' or zipCode = '77036' or zipCode = '77037' or zipCode = '77038' or zipCode = '77039' or zipCode = '77040' or zipCode = '77041' or zipCode = '77042' or zipCode = '77043' or zipCode = '77044' or zipCode = '77045' or zipCode = '77046' or zipCode = '77047' or zipCode = '77048' or zipCode = '77049' or zipCode = '77050' or zipCode = '77051' or zipCode = '77052' or zipCode = '77053' or zipCode = '77054' or zipCode = '77055' or zipCode = '77056' or zipCode = '77057' or zipCode = '77058' or zipCode = '77059' or zipCode = '77060' or zipCode = '77061' or zipCode = '77062' or zipCode = '77063' or zipCode = '77064' or zipCode = '77065' or zipCode = '77066' or zipCode = '77067' or zipCode = '77068' or zipCode = '77069' or zipCode = '77070' or zipCode = '77071' or zipCode = '77072' or zipCode = '77073' or zipCode = '77074' or zipCode = '77075' or zipCode = '77076' or zipCode = '77077' or zipCode = '77078' or zipCode = '77079' or zipCode = '77080' or zipCode = '77081' or zipCode = '77082' or zipCode = '77083' or zipCode = '77084' or zipCode = '77085' or zipCode = '77086' or zipCode = '77087' or zipCode = '77088' or zipCode = '77089' or zipCode = '77090' or zipCode = '77091' or zipCode = '77092' or zipCode = '77093' or zipCode = '77094' or zipCode = '77095' or zipCode = '77096' or zipCode = '77097' or zipCode = '77098' or zipCode = '77099' or zipCode = '77201' or zipCode = '77202' or zipCode = '77203' or zipCode = '77204' or zipCode = '77205' or zipCode = '77206' or zipCode = '77207' or zipCode = '77208' or zipCode = '77209' or zipCode = '77210' or zipCode = '77212' or zipCode = '77213' or zipCode = '77215' or zipCode = '77216' or zipCode = '77217' or zipCode = '77218' or zipCode = '77219' or zipCode = '77220' or zipCode = '77221' or zipCode = '77222' or zipCode = '77223' or zipCode = '77224' or zipCode = '77225' or zipCode = '77226' or zipCode = '77227' or zipCode = '77228' or zipCode = '77229' or zipCode = '77230' or zipCode = '77231' or zipCode = '77233' or zipCode = '77234' or zipCode = '77235' or zipCode = '77236' or zipCode = '77237' or zipCode = '77238' or zipCode = '77240' or zipCode = '77241' or zipCode = '77242' or zipCode = '77243' or zipCode = '77244' or zipCode = '77245' or zipCode = '77248' or zipCode = '77249' or zipCode = '77251' or zipCode = '77252' or zipCode = '77253' or zipCode = '77254' or zipCode = '77255' or zipCode = '77256' or zipCode = '77257' or zipCode = '77258' or zipCode = '77259' or zipCode = '77261' or zipCode = '77262' or zipCode = '77263' or zipCode = '77265' or zipCode = '77266' or zipCode = '77267' or zipCode = '77268' or zipCode = '77269' or zipCode = '77270' or zipCode = '77271' or zipCode = '77272' or zipCode = '77273' or zipCode = '77274' or zipCode = '77275' or zipCode = '77277' or zipCode = '77279' or zipCode = '77280' or zipCode = '77281' or zipCode = '77282' or zipCode = '77284' or zipCode = '77287' or zipCode = '77288' or zipCode = '77289' or zipCode = '77290' or zipCode = '77291' or zipCode = '77292' or zipCode = '77293' or zipCode = '77297' or zipCode = '77298' or zipCode = '77299' or zipCode = '77315' or zipCode = '77325' or zipCode = '77336' or zipCode = '77337' or zipCode = '77338' or zipCode = '77339' or zipCode = '77345' or zipCode = '77346' or zipCode = '77347' or zipCode = '77365' or zipCode = '77373' or zipCode = '77377' or zipCode = '77379' or zipCode = '77380' or zipCode = '77383' or zipCode = '77386' or zipCode = '77388' or zipCode = '77389' or zipCode = '77391' or zipCode = '77396' or zipCode = '77401' or zipCode = '77402' or zipCode = '77410' or zipCode = '77411' or zipCode = '77413' or zipCode = '77429' or zipCode = '77459' or zipCode = '77477' or zipCode = '77478' or zipCode = '77489' or zipCode = '77491' or zipCode = '77492' or zipCode = '77501' or zipCode = '77502' or zipCode = '77503' or zipCode = '77504' or zipCode = '77505' or zipCode = '77506' or zipCode = '77507' or zipCode = '77508' or zipCode = '77520' or zipCode = '77521' or zipCode = '77522' or zipCode = '77530' or zipCode = '77532' or zipCode = '77536' or zipCode = '77545' or zipCode = '77546' or zipCode = '77547' or zipCode = '77562' or zipCode = '77567' or zipCode = '77571' or zipCode = '77572' or zipCode = '77578' or zipCode = '77581' or zipCode = '77584' or zipCode = '77586' or zipCode = '77587' or zipCode = '77588' or zipCode = '77593' or zipCode = '77598') 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 ='77008' or zipCode = '77008' or zipCode = '77009' or zipCode = '77010' or zipCode = '77011' or zipCode = '77012' or zipCode = '77013' or zipCode = '77014' or zipCode = '77015' or zipCode = '77015' or zipCode = '77015' or zipCode = '77016' or zipCode = '77017' or zipCode = '77018' or zipCode = '77019' or zipCode = '77020' or zipCode = '77021' or zipCode = '77022' or zipCode = '77023' or zipCode = '77024' or zipCode = '77024' or zipCode = '77024' or zipCode = '77024' or zipCode = '77039' or zipCode = '77040' or zipCode = '77040' or zipCode = '77040' or zipCode = '77040' or zipCode = '77040' or zipCode = '77040' or zipCode = '77041' or zipCode = '77041' or zipCode = '77041' or zipCode = '77042' or zipCode = '77043' or zipCode = '77044' or zipCode = '77045' or zipCode = '77045' or zipCode = '77046' or zipCode = '77046' or zipCode = '77047' or zipCode = '77048' or zipCode = '77049' or zipCode = '77050' or zipCode = '77051' or zipCode = '77052' or zipCode = '77001' or zipCode = '77002' or zipCode = '77002' or zipCode = '77003' or zipCode = '77004' or zipCode = '77005' or zipCode = '77005' or zipCode = '77005' or zipCode = '77005' or zipCode = '77006' or zipCode = '77007' or zipCode = '77008' or zipCode = '77024' or zipCode = '77024' or zipCode = '77024' or zipCode = '77025' or zipCode = '77025' or zipCode = '77025' or zipCode = '77026' or zipCode = '77027' or zipCode = '77028' or zipCode = '77028' or zipCode = '77029' or zipCode = '77030' or zipCode = '77030' or zipCode = '77031' or zipCode = '77032' or zipCode = '77033' or zipCode = '77034' or zipCode = '77035' or zipCode = '77036' or zipCode = '77036' or zipCode = '77037' or zipCode = '77038' or zipCode = '77039' or zipCode = '77053' or zipCode = '77054' or zipCode = '77054' or zipCode = '77055' or zipCode = '77055' or zipCode = '77056' or zipCode = '77057' or zipCode = '77058' or zipCode = '77058' or zipCode = '77058' or zipCode = '77058' or zipCode = '77059' or zipCode = '77060' or zipCode = '77061' or zipCode = '77062' or zipCode = '77063' or zipCode = '77064' or zipCode = '77065' or zipCode = '77065' or zipCode = '77065' or zipCode = '77066' or zipCode = '77067' or zipCode = '77068' or zipCode = '77091' or zipCode = '77092' or zipCode = '77093' or zipCode = '77094' or zipCode = '77095' or zipCode = '77096' or zipCode = '77097' or zipCode = '77098' or zipCode = '77099' or zipCode = '77201' or zipCode = '77201' or zipCode = '77202' or zipCode = '77203' or zipCode = '77204' or zipCode = '77204' or zipCode = '77205' or zipCode = '77206' or zipCode = '77207' or zipCode = '77208' or zipCode = '77209' or zipCode = '77209' or zipCode = '77210' or zipCode = '77212' or zipCode = '77212' or zipCode = '77213' or zipCode = '77215' or zipCode = '77216' or zipCode = '77216' or zipCode = '77217' or zipCode = '77218' or zipCode = '77219' or zipCode = '77220' or zipCode = '77221' or zipCode = '77222' or zipCode = '77223' or zipCode = '77224' or zipCode = '77224' or zipCode = '77225' or zipCode = '77226' or zipCode = '77227' or zipCode = '77228' or zipCode = '77229' or zipCode = '77230' or zipCode = '77230' or zipCode = '77231' or zipCode = '77233' or zipCode = '77234' or zipCode = '77235' or zipCode = '77260' or zipCode = '77261' or zipCode = '77262' or zipCode = '77263' or zipCode = '77265' or zipCode = '77266' or zipCode = '77267' or zipCode = '77268' or zipCode = '77269' or zipCode = '77270' or zipCode = '77271' or zipCode = '77272' or zipCode = '77273' or zipCode = '77274' or zipCode = '77275' or zipCode = '77276' or zipCode = '77277' or zipCode = '77278' or zipCode = '77279' or zipCode = '77279' or zipCode = '77280' or zipCode = '77282' or zipCode = '77284' or zipCode = '77285' or zipCode = '77315' or zipCode = '77325' or zipCode = '77325' or zipCode = '77345' or zipCode = '77345' or zipCode = '77346' or zipCode = '77346' or zipCode = '77346' or zipCode = '77347' or zipCode = '77069' or zipCode = '77070' or zipCode = '77071' or zipCode = '77072' or zipCode = '77073' or zipCode = '77074' or zipCode = '77075' or zipCode = '77076' or zipCode = '77077' or zipCode = '77078' or zipCode = '77079' or zipCode = '77079' or zipCode = '77080' or zipCode = '77081' or zipCode = '77082' or zipCode = '77083' or zipCode = '77084' or zipCode = '77084' or zipCode = '77085' or zipCode = '77086' or zipCode = '77087' or zipCode = '77088' or zipCode = '77089' or zipCode = '77090' or zipCode = '77236' or zipCode = '77237' or zipCode = '77238' or zipCode = '77240' or zipCode = '77241' or zipCode = '77242' or zipCode = '77243' or zipCode = '77244' or zipCode = '77245' or zipCode = '77246' or zipCode = '77247' or zipCode = '77248' or zipCode = '77249' or zipCode = '77250' or zipCode = '77251' or zipCode = '77252' or zipCode = '77253' or zipCode = '77254' or zipCode = '77255' or zipCode = '77256' or zipCode = '77257' or zipCode = '77258' or zipCode = '77258' or zipCode = '77259' or zipCode = '77286' or zipCode = '77287' or zipCode = '77288' or zipCode = '77289' or zipCode = '77290' or zipCode = '77291' or zipCode = '77292' or zipCode = '77293' or zipCode = '77294' or zipCode = '77296' or zipCode = '77297' or zipCode = '77297' or zipCode = '77298' or zipCode = '77298' or zipCode = '77299' or zipCode = '77299' or zipCode = '77336' or zipCode = '77338' or zipCode = '77338' or zipCode = '77339' or zipCode = '77339' or zipCode = '77357' or zipCode = '77357' or zipCode = '77357' or zipCode = '77365' or zipCode = '77365' or zipCode = '77365' or zipCode = '77365' or zipCode = '77365' or zipCode = '77386' or zipCode = '77386' or zipCode = '77387' or zipCode = '77387' or zipCode = '77388' or zipCode = '77389' or zipCode = '77389' or zipCode = '77389' or zipCode = '77391' or zipCode = '77391' or zipCode = '77393' or zipCode = '77393' or zipCode = '77393' or zipCode = '77396' or zipCode = '77401' or zipCode = '77402' or zipCode = '77429' or zipCode = '77373' or zipCode = '77373' or zipCode = '77379' or zipCode = '77379' or zipCode = '77380' or zipCode = '77380' or zipCode = '77380' or zipCode = '77383' or zipCode = '77411' or zipCode = '77411' or zipCode = '77413' or zipCode = '77459' or zipCode = '77459' or zipCode = '77459' or zipCode = '77477' or zipCode = '77477' or zipCode = '77478' or zipCode = '77503' or zipCode = '77504' or zipCode = '77505' or zipCode = '77506' or zipCode = '77507' or zipCode = '77508' or zipCode = '77536' or zipCode = '77545' or zipCode = '77546' or zipCode = '77547' or zipCode = '77549' or zipCode = '77562' or zipCode = '77571' or zipCode = '77571' or zipCode = '77571' or zipCode = '77571' or zipCode = '77571' or zipCode = '77572' or zipCode = '77573' or zipCode = '77574' or zipCode = '77578' or zipCode = '77581' or zipCode = '77581' or zipCode = '77581' or zipCode = '77487' or zipCode = '77489' or zipCode = '77496' or zipCode = '77497' or zipCode = '77501' or zipCode = '77502' or zipCode = '77503' or zipCode = '77521' or zipCode = '77522' or zipCode = '77523' or zipCode = '77523' or zipCode = '77523' or zipCode = '77523' or zipCode = '77523' or zipCode = '77523' or zipCode = '77530' or zipCode = '77532' or zipCode = '77584' or zipCode = '77586' or zipCode = '77586' or zipCode = '77586' or zipCode = '77586' or zipCode = '77586' or zipCode = '77586' or zipCode = '77587' or zipCode = '77588' or zipCode = '77598' or zipCode = '77598' or zipCode = '77000' or zipCode = '77001' or zipCode = '77002' or zipCode = '77003' or zipCode = '77004' or zipCode = '77005' or zipCode = '77006' or zipCode = '77007' or zipCode = '77008' or zipCode = '77009' or zipCode = '77010' or zipCode = '77011' or zipCode = '77012' or zipCode = '77013' or zipCode = '77014' or zipCode = '77015' or zipCode = '77016' or zipCode = '77017' or zipCode = '77018' or zipCode = '77019' or zipCode = '77020' or zipCode = '77021' or zipCode = '77022' or zipCode = '77023' or zipCode = '77024' or zipCode = '77025' or zipCode = '77026' or zipCode = '77027' or zipCode = '77028' or zipCode = '77029' or zipCode = '77030' or zipCode = '77031' or zipCode = '77032' or zipCode = '77033' or zipCode = '77034' or zipCode = '77035' or zipCode = '77036' or zipCode = '77037' or zipCode = '77038' or zipCode = '77039' or zipCode = '77040' or zipCode = '77041' or zipCode = '77042' or zipCode = '77043' or zipCode = '77044' or zipCode = '77045' or zipCode = '77046' or zipCode = '77047' or zipCode = '77048' or zipCode = '77049' or zipCode = '77050' or zipCode = '77051' or zipCode = '77052' or zipCode = '77053' or zipCode = '77054' or zipCode = '77055' or zipCode = '77056' or zipCode = '77057' or zipCode = '77058' or zipCode = '77059' or zipCode = '77060' or zipCode = '77061' or zipCode = '77062' or zipCode = '77063' or zipCode = '77064' or zipCode = '77065' or zipCode = '77066' or zipCode = '77067' or zipCode = '77068' or zipCode = '77069' or zipCode = '77070' or zipCode = '77071' or zipCode = '77072' or zipCode = '77073' or zipCode = '77074' or zipCode = '77075' or zipCode = '77076' or zipCode = '77077' or zipCode = '77078' or zipCode = '77079' or zipCode = '77080' or zipCode = '77081' or zipCode = '77082' or zipCode = '77083' or zipCode = '77084' or zipCode = '77085' or zipCode = '77086' or zipCode = '77087' or zipCode = '77088' or zipCode = '77089' or zipCode = '77090' or zipCode = '77091' or zipCode = '77092' or zipCode = '77093' or zipCode = '77094' or zipCode = '77095' or zipCode = '77096' or zipCode = '77097' or zipCode = '77098' or zipCode = '77099' or zipCode = '77201' or zipCode = '77202' or zipCode = '77203' or zipCode = '77204' or zipCode = '77205' or zipCode = '77206' or zipCode = '77207' or zipCode = '77208' or zipCode = '77209' or zipCode = '77210' or zipCode = '77212' or zipCode = '77213' or zipCode = '77215' or zipCode = '77216' or zipCode = '77217' or zipCode = '77218' or zipCode = '77219' or zipCode = '77220' or zipCode = '77221' or zipCode = '77222' or zipCode = '77223' or zipCode = '77224' or zipCode = '77225' or zipCode = '77226' or zipCode = '77227' or zipCode = '77228' or zipCode = '77229' or zipCode = '77230' or zipCode = '77231' or zipCode = '77233' or zipCode = '77234' or zipCode = '77235' or zipCode = '77236' or zipCode = '77237' or zipCode = '77238' or zipCode = '77240' or zipCode = '77241' or zipCode = '77242' or zipCode = '77243' or zipCode = '77244' or zipCode = '77245' or zipCode = '77248' or zipCode = '77249' or zipCode = '77251' or zipCode = '77252' or zipCode = '77253' or zipCode = '77254' or zipCode = '77255' or zipCode = '77256' or zipCode = '77257' or zipCode = '77258' or zipCode = '77259' or zipCode = '77261' or zipCode = '77262' or zipCode = '77263' or zipCode = '77265' or zipCode = '77266' or zipCode = '77267' or zipCode = '77268' or zipCode = '77269' or zipCode = '77270' or zipCode = '77271' or zipCode = '77272' or zipCode = '77273' or zipCode = '77274' or zipCode = '77275' or zipCode = '77277' or zipCode = '77279' or zipCode = '77280' or zipCode = '77281' or zipCode = '77282' or zipCode = '77284' or zipCode = '77287' or zipCode = '77288' or zipCode = '77289' or zipCode = '77290' or zipCode = '77291' or zipCode = '77292' or zipCode = '77293' or zipCode = '77297' or zipCode = '77298' or zipCode = '77299' or zipCode = '77315' or zipCode = '77325' or zipCode = '77336' or zipCode = '77337' or zipCode = '77338' or zipCode = '77339' or zipCode = '77345' or zipCode = '77346' or zipCode = '77347' or zipCode = '77365' or zipCode = '77373' or zipCode = '77377' or zipCode = '77379' or zipCode = '77380' or zipCode = '77383' or zipCode = '77386' or zipCode = '77388' or zipCode = '77389' or zipCode = '77391' or zipCode = '77396' or zipCode = '77401' or zipCode = '77402' or zipCode = '77410' or zipCode = '77411' or zipCode = '77413' or zipCode = '77429' or zipCode = '77459' or zipCode = '77477' or zipCode = '77478' or zipCode = '77489' or zipCode = '77491' or zipCode = '77492' or zipCode = '77501' or zipCode = '77502' or zipCode = '77503' or zipCode = '77504' or zipCode = '77505' or zipCode = '77506' or zipCode = '77507' or zipCode = '77508' or zipCode = '77520' or zipCode = '77521' or zipCode = '77522' or zipCode = '77530' or zipCode = '77532' or zipCode = '77536' or zipCode = '77545' or zipCode = '77546' or zipCode = '77547' or zipCode = '77562' or zipCode = '77567' or zipCode = '77571' or zipCode = '77572' or zipCode = '77578' or zipCode = '77581' or zipCode = '77584' or zipCode = '77586' or zipCode = '77587' or zipCode = '77588' or zipCode = '77593' or zipCode = '77598') 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 ='77008' or zipCode = '77008' or zipCode = '77009' or zipCode = '77010' or zipCode = '77011' or zipCode = '77012' or zipCode = '77013' or zipCode = '77014' or zipCode = '77015' or zipCode = '77015' or zipCode = '77015' or zipCode = '77016' or zipCode = '77017' or zipCode = '77018' or zipCode = '77019' or zipCode = '77020' or zipCode = '77021' or zipCode = '77022' or zipCode = '77023' or zipCode = '77024' or zipCode = '77024' or zipCode = '77024' or zipCode = '77024' or zipCode = '77039' or zipCode = '77040' or zipCode = '77040' or zipCode = '77040' or zipCode = '77040' or zipCode = '77040' or zipCode = '77040' or zipCode = '77041' or zipCode = '77041' or zipCode = '77041' or zipCode = '77042' or zipCode = '77043' or zipCode = '77044' or zipCode = '77045' or zipCode = '77045' or zipCode = '77046' or zipCode = '77046' or zipCode = '77047' or zipCode = '77048' or zipCode = '77049' or zipCode = '77050' or zipCode = '77051' or zipCode = '77052' or zipCode = '77001' or zipCode = '77002' or zipCode = '77002' or zipCode = '77003' or zipCode = '77004' or zipCode = '77005' or zipCode = '77005' or zipCode = '77005' or zipCode = '77005' or zipCode = '77006' or zipCode = '77007' or zipCode = '77008' or zipCode = '77024' or zipCode = '77024' or zipCode = '77024' or zipCode = '77025' or zipCode = '77025' or zipCode = '77025' or zipCode = '77026' or zipCode = '77027' or zipCode = '77028' or zipCode = '77028' or zipCode = '77029' or zipCode = '77030' or zipCode = '77030' or zipCode = '77031' or zipCode = '77032' or zipCode = '77033' or zipCode = '77034' or zipCode = '77035' or zipCode = '77036' or zipCode = '77036' or zipCode = '77037' or zipCode = '77038' or zipCode = '77039' or zipCode = '77053' or zipCode = '77054' or zipCode = '77054' or zipCode = '77055' or zipCode = '77055' or zipCode = '77056' or zipCode = '77057' or zipCode = '77058' or zipCode = '77058' or zipCode = '77058' or zipCode = '77058' or zipCode = '77059' or zipCode = '77060' or zipCode = '77061' or zipCode = '77062' or zipCode = '77063' or zipCode = '77064' or zipCode = '77065' or zipCode = '77065' or zipCode = '77065' or zipCode = '77066' or zipCode = '77067' or zipCode = '77068' or zipCode = '77091' or zipCode = '77092' or zipCode = '77093' or zipCode = '77094' or zipCode = '77095' or zipCode = '77096' or zipCode = '77097' or zipCode = '77098' or zipCode = '77099' or zipCode = '77201' or zipCode = '77201' or zipCode = '77202' or zipCode = '77203' or zipCode = '77204' or zipCode = '77204' or zipCode = '77205' or zipCode = '77206' or zipCode = '77207' or zipCode = '77208' or zipCode = '77209' or zipCode = '77209' or zipCode = '77210' or zipCode = '77212' or zipCode = '77212' or zipCode = '77213' or zipCode = '77215' or zipCode = '77216' or zipCode = '77216' or zipCode = '77217' or zipCode = '77218' or zipCode = '77219' or zipCode = '77220' or zipCode = '77221' or zipCode = '77222' or zipCode = '77223' or zipCode = '77224' or zipCode = '77224' or zipCode = '77225' or zipCode = '77226' or zipCode = '77227' or zipCode = '77228' or zipCode = '77229' or zipCode = '77230' or zipCode = '77230' or zipCode = '77231' or zipCode = '77233' or zipCode = '77234' or zipCode = '77235' or zipCode = '77260' or zipCode = '77261' or zipCode = '77262' or zipCode = '77263' or zipCode = '77265' or zipCode = '77266' or zipCode = '77267' or zipCode = '77268' or zipCode = '77269' or zipCode = '77270' or zipCode = '77271' or zipCode = '77272' or zipCode = '77273' or zipCode = '77274' or zipCode = '77275' or zipCode = '77276' or zipCode = '77277' or zipCode = '77278' or zipCode = '77279' or zipCode = '77279' or zipCode = '77280' or zipCode = '77282' or zipCode = '77284' or zipCode = '77285' or zipCode = '77315' or zipCode = '77325' or zipCode = '77325' or zipCode = '77345' or zipCode = '77345' or zipCode = '77346' or zipCode = '77346' or zipCode = '77346' or zipCode = '77347' or zipCode = '77069' or zipCode = '77070' or zipCode = '77071' or zipCode = '77072' or zipCode = '77073' or zipCode = '77074' or zipCode = '77075' or zipCode = '77076' or zipCode = '77077' or zipCode = '77078' or zipCode = '77079' or zipCode = '77079' or zipCode = '77080' or zipCode = '77081' or zipCode = '77082' or zipCode = '77083' or zipCode = '77084' or zipCode = '77084' or zipCode = '77085' or zipCode = '77086' or zipCode = '77087' or zipCode = '77088' or zipCode = '77089' or zipCode = '77090' or zipCode = '77236' or zipCode = '77237' or zipCode = '77238' or zipCode = '77240' or zipCode = '77241' or zipCode = '77242' or zipCode = '77243' or zipCode = '77244' or zipCode = '77245' or zipCode = '77246' or zipCode = '77247' or zipCode = '77248' or zipCode = '77249' or zipCode = '77250' or zipCode = '77251' or zipCode = '77252' or zipCode = '77253' or zipCode = '77254' or zipCode = '77255' or zipCode = '77256' or zipCode = '77257' or zipCode = '77258' or zipCode = '77258' or zipCode = '77259' or zipCode = '77286' or zipCode = '77287' or zipCode = '77288' or zipCode = '77289' or zipCode = '77290' or zipCode = '77291' or zipCode = '77292' or zipCode = '77293' or zipCode = '77294' or zipCode = '77296' or zipCode = '77297' or zipCode = '77297' or zipCode = '77298' or zipCode = '77298' or zipCode = '77299' or zipCode = '77299' or zipCode = '77336' or zipCode = '77338' or zipCode = '77338' or zipCode = '77339' or zipCode = '77339' or zipCode = '77357' or zipCode = '77357' or zipCode = '77357' or zipCode = '77365' or zipCode = '77365' or zipCode = '77365' or zipCode = '77365' or zipCode = '77365' or zipCode = '77386' or zipCode = '77386' or zipCode = '77387' or zipCode = '77387' or zipCode = '77388' or zipCode = '77389' or zipCode = '77389' or zipCode = '77389' or zipCode = '77391' or zipCode = '77391' or zipCode = '77393' or zipCode = '77393' or zipCode = '77393' or zipCode = '77396' or zipCode = '77401' or zipCode = '77402' or zipCode = '77429' or zipCode = '77373' or zipCode = '77373' or zipCode = '77379' or zipCode = '77379' or zipCode = '77380' or zipCode = '77380' or zipCode = '77380' or zipCode = '77383' or zipCode = '77411' or zipCode = '77411' or zipCode = '77413' or zipCode = '77459' or zipCode = '77459' or zipCode = '77459' or zipCode = '77477' or zipCode = '77477' or zipCode = '77478' or zipCode = '77503' or zipCode = '77504' or zipCode = '77505' or zipCode = '77506' or zipCode = '77507' or zipCode = '77508' or zipCode = '77536' or zipCode = '77545' or zipCode = '77546' or zipCode = '77547' or zipCode = '77549' or zipCode = '77562' or zipCode = '77571' or zipCode = '77571' or zipCode = '77571' or zipCode = '77571' or zipCode = '77571' or zipCode = '77572' or zipCode = '77573' or zipCode = '77574' or zipCode = '77578' or zipCode = '77581' or zipCode = '77581' or zipCode = '77581' or zipCode = '77487' or zipCode = '77489' or zipCode = '77496' or zipCode = '77497' or zipCode = '77501' or zipCode = '77502' or zipCode = '77503' or zipCode = '77521' or zipCode = '77522' or zipCode = '77523' or zipCode = '77523' or zipCode = '77523' or zipCode = '77523' or zipCode = '77523' or zipCode = '77523' or zipCode = '77530' or zipCode = '77532' or zipCode = '77584' or zipCode = '77586' or zipCode = '77586' or zipCode = '77586' or zipCode = '77586' or zipCode = '77586' or zipCode = '77586' or zipCode = '77587' or zipCode = '77588' or zipCode = '77598' or zipCode = '77598' or zipCode = '77000' or zipCode = '77001' or zipCode = '77002' or zipCode = '77003' or zipCode = '77004' or zipCode = '77005' or zipCode = '77006' or zipCode = '77007' or zipCode = '77008' or zipCode = '77009' or zipCode = '77010' or zipCode = '77011' or zipCode = '77012' or zipCode = '77013' or zipCode = '77014' or zipCode = '77015' or zipCode = '77016' or zipCode = '77017' or zipCode = '77018' or zipCode = '77019' or zipCode = '77020' or zipCode = '77021' or zipCode = '77022' or zipCode = '77023' or zipCode = '77024' or zipCode = '77025' or zipCode = '77026' or zipCode = '77027' or zipCode = '77028' or zipCode = '77029' or zipCode = '77030' or zipCode = '77031' or zipCode = '77032' or zipCode = '77033' or zipCode = '77034' or zipCode = '77035' or zipCode = '77036' or zipCode = '77037' or zipCode = '77038' or zipCode = '77039' or zipCode = '77040' or zipCode = '77041' or zipCode = '77042' or zipCode = '77043' or zipCode = '77044' or zipCode = '77045' or zipCode = '77046' or zipCode = '77047' or zipCode = '77048' or zipCode = '77049' or zipCode = '77050' or zipCode = '77051' or zipCode = '77052' or zipCode = '77053' or zipCode = '77054' or zipCode = '77055' or zipCode = '77056' or zipCode = '77057' or zipCode = '77058' or zipCode = '77059' or zipCode = '77060' or zipCode = '77061' or zipCode = '77062' or zipCode = '77063' or zipCode = '77064' or zipCode = '77065' or zipCode = '77066' or zipCode = '77067' or zipCode = '77068' or zipCode = '77069' or zipCode = '77070' or zipCode = '77071' or zipCode = '77072' or zipCode = '77073' or zipCode = '77074' or zipCode = '77075' or zipCode = '77076' or zipCode = '77077' or zipCode = '77078' or zipCode = '77079' or zipCode = '77080' or zipCode = '77081' or zipCode = '77082' or zipCode = '77083' or zipCode = '77084' or zipCode = '77085' or zipCode = '77086' or zipCode = '77087' or zipCode = '77088' or zipCode = '77089' or zipCode = '77090' or zipCode = '77091' or zipCode = '77092' or zipCode = '77093' or zipCode = '77094' or zipCode = '77095' or zipCode = '77096' or zipCode = '77097' or zipCode = '77098' or zipCode = '77099' or zipCode = '77201' or zipCode = '77202' or zipCode = '77203' or zipCode = '77204' or zipCode = '77205' or zipCode = '77206' or zipCode = '77207' or zipCode = '77208' or zipCode = '77209' or zipCode = '77210' or zipCode = '77212' or zipCode = '77213' or zipCode = '77215' or zipCode = '77216' or zipCode = '77217' or zipCode = '77218' or zipCode = '77219' or zipCode = '77220' or zipCode = '77221' or zipCode = '77222' or zipCode = '77223' or zipCode = '77224' or zipCode = '77225' or zipCode = '77226' or zipCode = '77227' or zipCode = '77228' or zipCode = '77229' or zipCode = '77230' or zipCode = '77231' or zipCode = '77233' or zipCode = '77234' or zipCode = '77235' or zipCode = '77236' or zipCode = '77237' or zipCode = '77238' or zipCode = '77240' or zipCode = '77241' or zipCode = '77242' or zipCode = '77243' or zipCode = '77244' or zipCode = '77245' or zipCode = '77248' or zipCode = '77249' or zipCode = '77251' or zipCode = '77252' or zipCode = '77253' or zipCode = '77254' or zipCode = '77255' or zipCode = '77256' or zipCode = '77257' or zipCode = '77258' or zipCode = '77259' or zipCode = '77261' or zipCode = '77262' or zipCode = '77263' or zipCode = '77265' or zipCode = '77266' or zipCode = '77267' or zipCode = '77268' or zipCode = '77269' or zipCode = '77270' or zipCode = '77271' or zipCode = '77272' or zipCode = '77273' or zipCode = '77274' or zipCode = '77275' or zipCode = '77277' or zipCode = '77279' or zipCode = '77280' or zipCode = '77281' or zipCode = '77282' or zipCode = '77284' or zipCode = '77287' or zipCode = '77288' or zipCode = '77289' or zipCode = '77290' or zipCode = '77291' or zipCode = '77292' or zipCode = '77293' or zipCode = '77297' or zipCode = '77298' or zipCode = '77299' or zipCode = '77315' or zipCode = '77325' or zipCode = '77336' or zipCode = '77337' or zipCode = '77338' or zipCode = '77339' or zipCode = '77345' or zipCode = '77346' or zipCode = '77347' or zipCode = '77365' or zipCode = '77373' or zipCode = '77377' or zipCode = '77379' or zipCode = '77380' or zipCode = '77383' or zipCode = '77386' or zipCode = '77388' or zipCode = '77389' or zipCode = '77391' or zipCode = '77396' or zipCode = '77401' or zipCode = '77402' or zipCode = '77410' or zipCode = '77411' or zipCode = '77413' or zipCode = '77429' or zipCode = '77459' or zipCode = '77477' or zipCode = '77478' or zipCode = '77489' or zipCode = '77491' or zipCode = '77492' or zipCode = '77501' or zipCode = '77502' or zipCode = '77503' or zipCode = '77504' or zipCode = '77505' or zipCode = '77506' or zipCode = '77507' or zipCode = '77508' or zipCode = '77520' or zipCode = '77521' or zipCode = '77522' or zipCode = '77530' or zipCode = '77532' or zipCode = '77536' or zipCode = '77545' or zipCode = '77546' or zipCode = '77547' or zipCode = '77562' or zipCode = '77567' or zipCode = '77571' or zipCode = '77572' or zipCode = '77578' or zipCode = '77581' or zipCode = '77584' or zipCode = '77586' or zipCode = '77587' or zipCode = '77588' or zipCode = '77593' or zipCode = '77598') 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 ='77008' or property_zip = '77008' or property_zip = '77009' or property_zip = '77010' or property_zip = '77011' or property_zip = '77012' or property_zip = '77013' or property_zip = '77014' or property_zip = '77015' or property_zip = '77015' or property_zip = '77015' or property_zip = '77016' or property_zip = '77017' or property_zip = '77018' or property_zip = '77019' or property_zip = '77020' or property_zip = '77021' or property_zip = '77022' or property_zip = '77023' or property_zip = '77024' or property_zip = '77024' or property_zip = '77024' or property_zip = '77024' or property_zip = '77039' or property_zip = '77040' or property_zip = '77040' or property_zip = '77040' or property_zip = '77040' or property_zip = '77040' or property_zip = '77040' or property_zip = '77041' or property_zip = '77041' or property_zip = '77041' or property_zip = '77042' or property_zip = '77043' or property_zip = '77044' or property_zip = '77045' or property_zip = '77045' or property_zip = '77046' or property_zip = '77046' or property_zip = '77047' or property_zip = '77048' or property_zip = '77049' or property_zip = '77050' or property_zip = '77051' or property_zip = '77052' or property_zip = '77001' or property_zip = '77002' or property_zip = '77002' or property_zip = '77003' or property_zip = '77004' or property_zip = '77005' or property_zip = '77005' or property_zip = '77005' or property_zip = '77005' or property_zip = '77006' or property_zip = '77007' or property_zip = '77008' or property_zip = '77024' or property_zip = '77024' or property_zip = '77024' or property_zip = '77025' or property_zip = '77025' or property_zip = '77025' or property_zip = '77026' or property_zip = '77027' or property_zip = '77028' or property_zip = '77028' or property_zip = '77029' or property_zip = '77030' or property_zip = '77030' or property_zip = '77031' or property_zip = '77032' or property_zip = '77033' or property_zip = '77034' or property_zip = '77035' or property_zip = '77036' or property_zip = '77036' or property_zip = '77037' or property_zip = '77038' or property_zip = '77039' or property_zip = '77053' or property_zip = '77054' or property_zip = '77054' or property_zip = '77055' or property_zip = '77055' or property_zip = '77056' or property_zip = '77057' or property_zip = '77058' or property_zip = '77058' or property_zip = '77058' or property_zip = '77058' or property_zip = '77059' or property_zip = '77060' or property_zip = '77061' or property_zip = '77062' or property_zip = '77063' or property_zip = '77064' or property_zip = '77065' or property_zip = '77065' or property_zip = '77065' or property_zip = '77066' or property_zip = '77067' or property_zip = '77068' or property_zip = '77091' or property_zip = '77092' or property_zip = '77093' or property_zip = '77094' or property_zip = '77095' or property_zip = '77096' or property_zip = '77097' or property_zip = '77098' or property_zip = '77099' or property_zip = '77201' or property_zip = '77201' or property_zip = '77202' or property_zip = '77203' or property_zip = '77204' or property_zip = '77204' or property_zip = '77205' or property_zip = '77206' or property_zip = '77207' or property_zip = '77208' or property_zip = '77209' or property_zip = '77209' or property_zip = '77210' or property_zip = '77212' or property_zip = '77212' or property_zip = '77213' or property_zip = '77215' or property_zip = '77216' or property_zip = '77216' or property_zip = '77217' or property_zip = '77218' or property_zip = '77219' or property_zip = '77220' or property_zip = '77221' or property_zip = '77222' or property_zip = '77223' or property_zip = '77224' or property_zip = '77224' or property_zip = '77225' or property_zip = '77226' or property_zip = '77227' or property_zip = '77228' or property_zip = '77229' or property_zip = '77230' or property_zip = '77230' or property_zip = '77231' or property_zip = '77233' or property_zip = '77234' or property_zip = '77235' or property_zip = '77260' or property_zip = '77261' or property_zip = '77262' or property_zip = '77263' or property_zip = '77265' or property_zip = '77266' or property_zip = '77267' or property_zip = '77268' or property_zip = '77269' or property_zip = '77270' or property_zip = '77271' or property_zip = '77272' or property_zip = '77273' or property_zip = '77274' or property_zip = '77275' or property_zip = '77276' or property_zip = '77277' or property_zip = '77278' or property_zip = '77279' or property_zip = '77279' or property_zip = '77280' or property_zip = '77282' or property_zip = '77284' or property_zip = '77285' or property_zip = '77315' or property_zip = '77325' or property_zip = '77325' or property_zip = '77345' or property_zip = '77345' or property_zip = '77346' or property_zip = '77346' or property_zip = '77346' or property_zip = '77347' or property_zip = '77069' or property_zip = '77070' or property_zip = '77071' or property_zip = '77072' or property_zip = '77073' or property_zip = '77074' or property_zip = '77075' or property_zip = '77076' or property_zip = '77077' or property_zip = '77078' or property_zip = '77079' or property_zip = '77079' or property_zip = '77080' or property_zip = '77081' or property_zip = '77082' or property_zip = '77083' or property_zip = '77084' or property_zip = '77084' or property_zip = '77085' or property_zip = '77086' or property_zip = '77087' or property_zip = '77088' or property_zip = '77089' or property_zip = '77090' or property_zip = '77236' or property_zip = '77237' or property_zip = '77238' or property_zip = '77240' or property_zip = '77241' or property_zip = '77242' or property_zip = '77243' or property_zip = '77244' or property_zip = '77245' or property_zip = '77246' or property_zip = '77247' or property_zip = '77248' or property_zip = '77249' or property_zip = '77250' or property_zip = '77251' or property_zip = '77252' or property_zip = '77253' or property_zip = '77254' or property_zip = '77255' or property_zip = '77256' or property_zip = '77257' or property_zip = '77258' or property_zip = '77258' or property_zip = '77259' or property_zip = '77286' or property_zip = '77287' or property_zip = '77288' or property_zip = '77289' or property_zip = '77290' or property_zip = '77291' or property_zip = '77292' or property_zip = '77293' or property_zip = '77294' or property_zip = '77296' or property_zip = '77297' or property_zip = '77297' or property_zip = '77298' or property_zip = '77298' or property_zip = '77299' or property_zip = '77299' or property_zip = '77336' or property_zip = '77338' or property_zip = '77338' or property_zip = '77339' or property_zip = '77339' or property_zip = '77357' or property_zip = '77357' or property_zip = '77357' or property_zip = '77365' or property_zip = '77365' or property_zip = '77365' or property_zip = '77365' or property_zip = '77365' or property_zip = '77386' or property_zip = '77386' or property_zip = '77387' or property_zip = '77387' or property_zip = '77388' or property_zip = '77389' or property_zip = '77389' or property_zip = '77389' or property_zip = '77391' or property_zip = '77391' or property_zip = '77393' or property_zip = '77393' or property_zip = '77393' or property_zip = '77396' or property_zip = '77401' or property_zip = '77402' or property_zip = '77429' or property_zip = '77373' or property_zip = '77373' or property_zip = '77379' or property_zip = '77379' or property_zip = '77380' or property_zip = '77380' or property_zip = '77380' or property_zip = '77383' or property_zip = '77411' or property_zip = '77411' or property_zip = '77413' or property_zip = '77459' or property_zip = '77459' or property_zip = '77459' or property_zip = '77477' or property_zip = '77477' or property_zip = '77478' or property_zip = '77503' or property_zip = '77504' or property_zip = '77505' or property_zip = '77506' or property_zip = '77507' or property_zip = '77508' or property_zip = '77536' or property_zip = '77545' or property_zip = '77546' or property_zip = '77547' or property_zip = '77549' or property_zip = '77562' or property_zip = '77571' or property_zip = '77571' or property_zip = '77571' or property_zip = '77571' or property_zip = '77571' or property_zip = '77572' or property_zip = '77573' or property_zip = '77574' or property_zip = '77578' or property_zip = '77581' or property_zip = '77581' or property_zip = '77581' or property_zip = '77487' or property_zip = '77489' or property_zip = '77496' or property_zip = '77497' or property_zip = '77501' or property_zip = '77502' or property_zip = '77503' or property_zip = '77521' or property_zip = '77522' or property_zip = '77523' or property_zip = '77523' or property_zip = '77523' or property_zip = '77523' or property_zip = '77523' or property_zip = '77523' or property_zip = '77530' or property_zip = '77532' or property_zip = '77584' or property_zip = '77586' or property_zip = '77586' or property_zip = '77586' or property_zip = '77586' or property_zip = '77586' or property_zip = '77586' or property_zip = '77587' or property_zip = '77588' or property_zip = '77598' or property_zip = '77598' or property_zip = '77000' or property_zip = '77001' or property_zip = '77002' or property_zip = '77003' or property_zip = '77004' or property_zip = '77005' or property_zip = '77006' or property_zip = '77007' or property_zip = '77008' or property_zip = '77009' or property_zip = '77010' or property_zip = '77011' or property_zip = '77012' or property_zip = '77013' or property_zip = '77014' or property_zip = '77015' or property_zip = '77016' or property_zip = '77017' or property_zip = '77018' or property_zip = '77019' or property_zip = '77020' or property_zip = '77021' or property_zip = '77022' or property_zip = '77023' or property_zip = '77024' or property_zip = '77025' or property_zip = '77026' or property_zip = '77027' or property_zip = '77028' or property_zip = '77029' or property_zip = '77030' or property_zip = '77031' or property_zip = '77032' or property_zip = '77033' or property_zip = '77034' or property_zip = '77035' or property_zip = '77036' or property_zip = '77037' or property_zip = '77038' or property_zip = '77039' or property_zip = '77040' or property_zip = '77041' or property_zip = '77042' or property_zip = '77043' or property_zip = '77044' or property_zip = '77045' or property_zip = '77046' or property_zip = '77047' or property_zip = '77048' or property_zip = '77049' or property_zip = '77050' or property_zip = '77051' or property_zip = '77052' or property_zip = '77053' or property_zip = '77054' or property_zip = '77055' or property_zip = '77056' or property_zip = '77057' or property_zip = '77058' or property_zip = '77059' or property_zip = '77060' or property_zip = '77061' or property_zip = '77062' or property_zip = '77063' or property_zip = '77064' or property_zip = '77065' or property_zip = '77066' or property_zip = '77067' or property_zip = '77068' or property_zip = '77069' or property_zip = '77070' or property_zip = '77071' or property_zip = '77072' or property_zip = '77073' or property_zip = '77074' or property_zip = '77075' or property_zip = '77076' or property_zip = '77077' or property_zip = '77078' or property_zip = '77079' or property_zip = '77080' or property_zip = '77081' or property_zip = '77082' or property_zip = '77083' or property_zip = '77084' or property_zip = '77085' or property_zip = '77086' or property_zip = '77087' or property_zip = '77088' or property_zip = '77089' or property_zip = '77090' or property_zip = '77091' or property_zip = '77092' or property_zip = '77093' or property_zip = '77094' or property_zip = '77095' or property_zip = '77096' or property_zip = '77097' or property_zip = '77098' or property_zip = '77099' or property_zip = '77201' or property_zip = '77202' or property_zip = '77203' or property_zip = '77204' or property_zip = '77205' or property_zip = '77206' or property_zip = '77207' or property_zip = '77208' or property_zip = '77209' or property_zip = '77210' or property_zip = '77212' or property_zip = '77213' or property_zip = '77215' or property_zip = '77216' or property_zip = '77217' or property_zip = '77218' or property_zip = '77219' or property_zip = '77220' or property_zip = '77221' or property_zip = '77222' or property_zip = '77223' or property_zip = '77224' or property_zip = '77225' or property_zip = '77226' or property_zip = '77227' or property_zip = '77228' or property_zip = '77229' or property_zip = '77230' or property_zip = '77231' or property_zip = '77233' or property_zip = '77234' or property_zip = '77235' or property_zip = '77236' or property_zip = '77237' or property_zip = '77238' or property_zip = '77240' or property_zip = '77241' or property_zip = '77242' or property_zip = '77243' or property_zip = '77244' or property_zip = '77245' or property_zip = '77248' or property_zip = '77249' or property_zip = '77251' or property_zip = '77252' or property_zip = '77253' or property_zip = '77254' or property_zip = '77255' or property_zip = '77256' or property_zip = '77257' or property_zip = '77258' or property_zip = '77259' or property_zip = '77261' or property_zip = '77262' or property_zip = '77263' or property_zip = '77265' or property_zip = '77266' or property_zip = '77267' or property_zip = '77268' or property_zip = '77269' or property_zip = '77270' or property_zip = '77271' or property_zip = '77272' or property_zip = '77273' or property_zip = '77274' or property_zip = '77275' or property_zip = '77277' or property_zip = '77279' or property_zip = '77280' or property_zip = '77281' or property_zip = '77282' or property_zip = '77284' or property_zip = '77287' or property_zip = '77288' or property_zip = '77289' or property_zip = '77290' or property_zip = '77291' or property_zip = '77292' or property_zip = '77293' or property_zip = '77297' or property_zip = '77298' or property_zip = '77299' or property_zip = '77315' or property_zip = '77325' or property_zip = '77336' or property_zip = '77337' or property_zip = '77338' or property_zip = '77339' or property_zip = '77345' or property_zip = '77346' or property_zip = '77347' or property_zip = '77365' or property_zip = '77373' or property_zip = '77377' or property_zip = '77379' or property_zip = '77380' or property_zip = '77383' or property_zip = '77386' or property_zip = '77388' or property_zip = '77389' or property_zip = '77391' or property_zip = '77396' or property_zip = '77401' or property_zip = '77402' or property_zip = '77410' or property_zip = '77411' or property_zip = '77413' or property_zip = '77429' or property_zip = '77459' or property_zip = '77477' or property_zip = '77478' or property_zip = '77489' or property_zip = '77491' or property_zip = '77492' or property_zip = '77501' or property_zip = '77502' or property_zip = '77503' or property_zip = '77504' or property_zip = '77505' or property_zip = '77506' or property_zip = '77507' or property_zip = '77508' or property_zip = '77520' or property_zip = '77521' or property_zip = '77522' or property_zip = '77530' or property_zip = '77532' or property_zip = '77536' or property_zip = '77545' or property_zip = '77546' or property_zip = '77547' or property_zip = '77562' or property_zip = '77567' or property_zip = '77571' or property_zip = '77572' or property_zip = '77578' or property_zip = '77581' or property_zip = '77584' or property_zip = '77586' or property_zip = '77587' or property_zip = '77588' or property_zip = '77593' or property_zip = '77598') and convert(date,auction_start_date) >= '9/27/2021';
select top 45 * from currentforeclosures.tblAll NOLOCK where state = 'TX '
select top 4500 * from currentforeclosures.tblAll NOLOCK where 1=2
select top 45 * from currentforeclosures.tblAll NOLOCK where len(PhotoURL1) > 2 and photoURL1 <> 'no_pic2.jpg';
select top 47 * from currentforeclosures.tblWholesaleDeals NOLOCK where len(image_name1) > 2 and image_name1 <> 'no_pic2.jpg' and date_posted >= '8/29/2021' and (1=1) and asking_price >= 0 and asking_price <= 499999 and 11=11 and (zip ='77008' or zip = '77008' or zip = '77009' or zip = '77010' or zip = '77011' or zip = '77012' or zip = '77013' or zip = '77014' or zip = '77015' or zip = '77015' or zip = '77015' or zip = '77016' or zip = '77017' or zip = '77018' or zip = '77019' or zip = '77020' or zip = '77021' or zip = '77022' or zip = '77023' or zip = '77024' or zip = '77024' or zip = '77024' or zip = '77024' or zip = '77039' or zip = '77040' or zip = '77040' or zip = '77040' or zip = '77040' or zip = '77040' or zip = '77040' or zip = '77041' or zip = '77041' or zip = '77041' or zip = '77042' or zip = '77043' or zip = '77044' or zip = '77045' or zip = '77045' or zip = '77046' or zip = '77046' or zip = '77047' or zip = '77048' or zip = '77049' or zip = '77050' or zip = '77051' or zip = '77052' or zip = '77001' or zip = '77002' or zip = '77002' or zip = '77003' or zip = '77004' or zip = '77005' or zip = '77005' or zip = '77005' or zip = '77005' or zip = '77006' or zip = '77007' or zip = '77008' or zip = '77024' or zip = '77024' or zip = '77024' or zip = '77025' or zip = '77025' or zip = '77025' or zip = '77026' or zip = '77027' or zip = '77028' or zip = '77028' or zip = '77029' or zip = '77030' or zip = '77030' or zip = '77031' or zip = '77032' or zip = '77033' or zip = '77034' or zip = '77035' or zip = '77036' or zip = '77036' or zip = '77037' or zip = '77038' or zip = '77039' or zip = '77053' or zip = '77054' or zip = '77054' or zip = '77055' or zip = '77055' or zip = '77056' or zip = '77057' or zip = '77058' or zip = '77058' or zip = '77058' or zip = '77058' or zip = '77059' or zip = '77060' or zip = '77061' or zip = '77062' or zip = '77063' or zip = '77064' or zip = '77065' or zip = '77065' or zip = '77065' or zip = '77066' or zip = '77067' or zip = '77068' or zip = '77091' or zip = '77092' or zip = '77093' or zip = '77094' or zip = '77095' or zip = '77096' or zip = '77097' or zip = '77098' or zip = '77099' or zip = '77201' or zip = '77201' or zip = '77202' or zip = '77203' or zip = '77204' or zip = '77204' or zip = '77205' or zip = '77206' or zip = '77207' or zip = '77208' or zip = '77209' or zip = '77209' or zip = '77210' or zip = '77212' or zip = '77212' or zip = '77213' or zip = '77215' or zip = '77216' or zip = '77216' or zip = '77217' or zip = '77218' or zip = '77219' or zip = '77220' or zip = '77221' or zip = '77222' or zip = '77223' or zip = '77224' or zip = '77224' or zip = '77225' or zip = '77226' or zip = '77227' or zip = '77228' or zip = '77229' or zip = '77230' or zip = '77230' or zip = '77231' or zip = '77233' or zip = '77234' or zip = '77235' or zip = '77260' or zip = '77261' or zip = '77262' or zip = '77263' or zip = '77265' or zip = '77266' or zip = '77267' or zip = '77268' or zip = '77269' or zip = '77270' or zip = '77271' or zip = '77272' or zip = '77273' or zip = '77274' or zip = '77275' or zip = '77276' or zip = '77277' or zip = '77278' or zip = '77279' or zip = '77279' or zip = '77280' or zip = '77282' or zip = '77284' or zip = '77285' or zip = '77315' or zip = '77325' or zip = '77325' or zip = '77345' or zip = '77345' or zip = '77346' or zip = '77346' or zip = '77346' or zip = '77347' or zip = '77069' or zip = '77070' or zip = '77071' or zip = '77072' or zip = '77073' or zip = '77074' or zip = '77075' or zip = '77076' or zip = '77077' or zip = '77078' or zip = '77079' or zip = '77079' or zip = '77080' or zip = '77081' or zip = '77082' or zip = '77083' or zip = '77084' or zip = '77084' or zip = '77085' or zip = '77086' or zip = '77087' or zip = '77088' or zip = '77089' or zip = '77090' or zip = '77236' or zip = '77237' or zip = '77238' or zip = '77240' or zip = '77241' or zip = '77242' or zip = '77243' or zip = '77244' or zip = '77245' or zip = '77246' or zip = '77247' or zip = '77248' or zip = '77249' or zip = '77250' or zip = '77251' or zip = '77252' or zip = '77253' or zip = '77254' or zip = '77255' or zip = '77256' or zip = '77257' or zip = '77258' or zip = '77258' or zip = '77259' or zip = '77286' or zip = '77287' or zip = '77288' or zip = '77289' or zip = '77290' or zip = '77291' or zip = '77292' or zip = '77293' or zip = '77294' or zip = '77296' or zip = '77297' or zip = '77297' or zip = '77298' or zip = '77298' or zip = '77299' or zip = '77299' or zip = '77336' or zip = '77338' or zip = '77338' or zip = '77339' or zip = '77339' or zip = '77357' or zip = '77357' or zip = '77357' or zip = '77365' or zip = '77365' or zip = '77365' or zip = '77365' or zip = '77365' or zip = '77386' or zip = '77386' or zip = '77387' or zip = '77387' or zip = '77388' or zip = '77389' or zip = '77389' or zip = '77389' or zip = '77391' or zip = '77391' or zip = '77393' or zip = '77393' or zip = '77393' or zip = '77396' or zip = '77401' or zip = '77402' or zip = '77429' or zip = '77373' or zip = '77373' or zip = '77379' or zip = '77379' or zip = '77380' or zip = '77380' or zip = '77380' or zip = '77383' or zip = '77411' or zip = '77411' or zip = '77413' or zip = '77459' or zip = '77459' or zip = '77459' or zip = '77477' or zip = '77477' or zip = '77478' or zip = '77503' or zip = '77504' or zip = '77505' or zip = '77506' or zip = '77507' or zip = '77508' or zip = '77536' or zip = '77545' or zip = '77546' or zip = '77547' or zip = '77549' or zip = '77562' or zip = '77571' or zip = '77571' or zip = '77571' or zip = '77571' or zip = '77571' or zip = '77572' or zip = '77573' or zip = '77574' or zip = '77578' or zip = '77581' or zip = '77581' or zip = '77581' or zip = '77487' or zip = '77489' or zip = '77496' or zip = '77497' or zip = '77501' or zip = '77502' or zip = '77503' or zip = '77521' or zip = '77522' or zip = '77523' or zip = '77523' or zip = '77523' or zip = '77523' or zip = '77523' or zip = '77523' or zip = '77530' or zip = '77532' or zip = '77584' or zip = '77586' or zip = '77586' or zip = '77586' or zip = '77586' or zip = '77586' or zip = '77586' or zip = '77587' or zip = '77588' or zip = '77598' or zip = '77598' or zip = '77000' or zip = '77001' or zip = '77002' or zip = '77003' or zip = '77004' or zip = '77005' or zip = '77006' or zip = '77007' or zip = '77008' or zip = '77009' or zip = '77010' or zip = '77011' or zip = '77012' or zip = '77013' or zip = '77014' or zip = '77015' or zip = '77016' or zip = '77017' or zip = '77018' or zip = '77019' or zip = '77020' or zip = '77021' or zip = '77022' or zip = '77023' or zip = '77024' or zip = '77025' or zip = '77026' or zip = '77027' or zip = '77028' or zip = '77029' or zip = '77030' or zip = '77031' or zip = '77032' or zip = '77033' or zip = '77034' or zip = '77035' or zip = '77036' or zip = '77037' or zip = '77038' or zip = '77039' or zip = '77040' or zip = '77041' or zip = '77042' or zip = '77043' or zip = '77044' or zip = '77045' or zip = '77046' or zip = '77047' or zip = '77048' or zip = '77049' or zip = '77050' or zip = '77051' or zip = '77052' or zip = '77053' or zip = '77054' or zip = '77055' or zip = '77056' or zip = '77057' or zip = '77058' or zip = '77059' or zip = '77060' or zip = '77061' or zip = '77062' or zip = '77063' or zip = '77064' or zip = '77065' or zip = '77066' or zip = '77067' or zip = '77068' or zip = '77069' or zip = '77070' or zip = '77071' or zip = '77072' or zip = '77073' or zip = '77074' or zip = '77075' or zip = '77076' or zip = '77077' or zip = '77078' or zip = '77079' or zip = '77080' or zip = '77081' or zip = '77082' or zip = '77083' or zip = '77084' or zip = '77085' or zip = '77086' or zip = '77087' or zip = '77088' or zip = '77089' or zip = '77090' or zip = '77091' or zip = '77092' or zip = '77093' or zip = '77094' or zip = '77095' or zip = '77096' or zip = '77097' or zip = '77098' or zip = '77099' or zip = '77201' or zip = '77202' or zip = '77203' or zip = '77204' or zip = '77205' or zip = '77206' or zip = '77207' or zip = '77208' or zip = '77209' or zip = '77210' or zip = '77212' or zip = '77213' or zip = '77215' or zip = '77216' or zip = '77217' or zip = '77218' or zip = '77219' or zip = '77220' or zip = '77221' or zip = '77222' or zip = '77223' or zip = '77224' or zip = '77225' or zip = '77226' or zip = '77227' or zip = '77228' or zip = '77229' or zip = '77230' or zip = '77231' or zip = '77233' or zip = '77234' or zip = '77235' or zip = '77236' or zip = '77237' or zip = '77238' or zip = '77240' or zip = '77241' or zip = '77242' or zip = '77243' or zip = '77244' or zip = '77245' or zip = '77248' or zip = '77249' or zip = '77251' or zip = '77252' or zip = '77253' or zip = '77254' or zip = '77255' or zip = '77256' or zip = '77257' or zip = '77258' or zip = '77259' or zip = '77261' or zip = '77262' or zip = '77263' or zip = '77265' or zip = '77266' or zip = '77267' or zip = '77268' or zip = '77269' or zip = '77270' or zip = '77271' or zip = '77272' or zip = '77273' or zip = '77274' or zip = '77275' or zip = '77277' or zip = '77279' or zip = '77280' or zip = '77281' or zip = '77282' or zip = '77284' or zip = '77287' or zip = '77288' or zip = '77289' or zip = '77290' or zip = '77291' or zip = '77292' or zip = '77293' or zip = '77297' or zip = '77298' or zip = '77299' or zip = '77315' or zip = '77325' or zip = '77336' or zip = '77337' or zip = '77338' or zip = '77339' or zip = '77345' or zip = '77346' or zip = '77347' or zip = '77365' or zip = '77373' or zip = '77377' or zip = '77379' or zip = '77380' or zip = '77383' or zip = '77386' or zip = '77388' or zip = '77389' or zip = '77391' or zip = '77396' or zip = '77401' or zip = '77402' or zip = '77410' or zip = '77411' or zip = '77413' or zip = '77429' or zip = '77459' or zip = '77477' or zip = '77478' or zip = '77489' or zip = '77491' or zip = '77492' or zip = '77501' or zip = '77502' or zip = '77503' or zip = '77504' or zip = '77505' or zip = '77506' or zip = '77507' or zip = '77508' or zip = '77520' or zip = '77521' or zip = '77522' or zip = '77530' or zip = '77532' or zip = '77536' or zip = '77545' or zip = '77546' or zip = '77547' or zip = '77562' or zip = '77567' or zip = '77571' or zip = '77572' or zip = '77578' or zip = '77581' or zip = '77584' or zip = '77586' or zip = '77587' or zip = '77588' or zip = '77593' or zip = '77598')
select top 45 * from currentforeclosures.tblWholesaleDeals NOLOCK where len(image_name1) > 2 and image_name1 <> 'no_pic2.jpg' and date_posted >= '12/2/2020' and 1=1 and state = 'TX' and city = 'HOUSTON' and state = 'TX ' and asking_price >= 0 and asking_price <= 499999
select top 45 * from currentforeclosures.tblWholesaleDeals NOLOCK where len(image_name1) > 2 and image_name1 <> 'no_pic2.jpg';
select top 45 * from tblLenders where email != '[email protected]' and lendertype = 'individual' and rate < 10 and len(phone) > 3 and budget > 45000 order by newID();