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


157+ High Potential Investor Deals Near You [Refine]


********NOTICE: Displaying 99 of over 157 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 11=11 and (zipCode ='20041' or zipCode = '20041' or zipCode = '20115' or zipCode = '20116' or zipCode = '20117' or zipCode = '20118' or zipCode = '20120' or zipCode = '20120' or zipCode = '20121' or zipCode = '20122' or zipCode = '20129' or zipCode = '20129' or zipCode = '20130' or zipCode = '20131' or zipCode = '20132' or zipCode = '20132' or zipCode = '20134' or zipCode = '20134' or zipCode = '20135' or zipCode = '20155' or zipCode = '20156' or zipCode = '20158' or zipCode = '20159' or zipCode = '20160' or zipCode = '20160' or zipCode = '20163' or zipCode = '20163' or zipCode = '20164' or zipCode = '20165' or zipCode = '20165' or zipCode = '20166' or zipCode = '20166' or zipCode = '20167' or zipCode = '20168' or zipCode = '20169' or zipCode = '20170' or zipCode = '20171' or zipCode = '20171' or zipCode = '20172' or zipCode = '20175' or zipCode = '20176' or zipCode = '20176' or zipCode = '20192' or zipCode = '20192' or zipCode = '20192' or zipCode = '20192' or zipCode = '20194' or zipCode = '20194' or zipCode = '20195' or zipCode = '20195' or zipCode = '20196' or zipCode = '20196' or zipCode = '20196' or zipCode = '20196' or zipCode = '20197' or zipCode = '20198' or zipCode = '20101' or zipCode = '20101' or zipCode = '20102' or zipCode = '20102' or zipCode = '20102' or zipCode = '20103' or zipCode = '20103' or zipCode = '20104' or zipCode = '20104' or zipCode = '20105' or zipCode = '20105' or zipCode = '20107' or zipCode = '20108' or zipCode = '20109' or zipCode = '20109' or zipCode = '20109' or zipCode = '20110' or zipCode = '20135' or zipCode = '20136' or zipCode = '20137' or zipCode = '20140' or zipCode = '20141' or zipCode = '20142' or zipCode = '20143' or zipCode = '20144' or zipCode = '20146' or zipCode = '20147' or zipCode = '20148' or zipCode = '20148' or zipCode = '20148' or zipCode = '20148' or zipCode = '20149' or zipCode = '20149' or zipCode = '20151' or zipCode = '20151' or zipCode = '20152' or zipCode = '20152' or zipCode = '20152' or zipCode = '20176' or zipCode = '20177' or zipCode = '20178' or zipCode = '20180' or zipCode = '20184' or zipCode = '20185' or zipCode = '20189' or zipCode = '20190' or zipCode = '20190' or zipCode = '20191' or zipCode = '20191' or zipCode = '20837' or zipCode = '20838' or zipCode = '20839' or zipCode = '20841' or zipCode = '20842' or zipCode = '20842' or zipCode = '20850' or zipCode = '20854' or zipCode = '20854' or zipCode = '20859' or zipCode = '20859' or zipCode = '20871' or zipCode = '20871' or zipCode = '20874' or zipCode = '20874' or zipCode = '20875' or zipCode = '20876' or zipCode = '20878' or zipCode = '20878' or zipCode = '20878' or zipCode = '20878' or zipCode = '20878' or zipCode = '20884' or zipCode = '20885' or zipCode = '20898' or zipCode = '20898' or zipCode = '20899' or zipCode = '20899' or zipCode = '21703' or zipCode = '21704' or zipCode = '21704' or zipCode = '21710' or zipCode = '21710' or zipCode = '21714' or zipCode = '21714' or zipCode = '21715' or zipCode = '21716' or zipCode = '21716' or zipCode = '21717' or zipCode = '21718' or zipCode = '21758' or zipCode = '21758' or zipCode = '21769' or zipCode = '21777' or zipCode = '21777' or zipCode = '21779' or zipCode = '21779' or zipCode = '21790' or zipCode = '21755' or zipCode = '22030' or zipCode = '22033' or zipCode = '22035' or zipCode = '22035' or zipCode = '22036' or zipCode = '22036' or zipCode = '22038' or zipCode = '22066' or zipCode = '22067' or zipCode = '22067' or zipCode = '22124' or zipCode = '22124' or zipCode = '22180' or zipCode = '22181' or zipCode = '22182' or zipCode = '22183' or zipCode = '22185' or zipCode = '22185' or zipCode = '22095' or zipCode = '22095' or zipCode = '22095' or zipCode = '22096' or zipCode = '22096' or zipCode = '22096' or zipCode = '22102' or zipCode = '22102' or zipCode = '22102' or zipCode = '22102' or zipCode = '22185' or zipCode = '22185' or zipCode = '22611' or zipCode = '22611' or zipCode = '22620' or zipCode = '22643' or zipCode = '22646' or zipCode = '25410' or zipCode = '25414' or zipCode = '25423' or zipCode = '25425' or zipCode = '25429' or zipCode = '25429' or zipCode = '25430' or zipCode = '25430' or zipCode = '25432' or zipCode = '25438' or zipCode = '25441' or zipCode = '25442' or zipCode = '25442' or zipCode = '25446' or zipCode = '20101' or zipCode = '20102' or zipCode = '20103' or zipCode = '20104' or zipCode = '20105' or zipCode = '20107' or zipCode = '20109' or zipCode = '20110' or zipCode = '20111' or zipCode = '20113' or zipCode = '20115' or zipCode = '20116' or zipCode = '20117' or zipCode = '20118' or zipCode = '20120' or zipCode = '20121' or zipCode = '20124' or zipCode = '20129' or zipCode = '20130' or zipCode = '20131' or zipCode = '20132' or zipCode = '20134' or zipCode = '20135' or zipCode = '20136' or zipCode = '20137' or zipCode = '20140' or zipCode = '20141' or zipCode = '20142' or zipCode = '20143' or zipCode = '20144' or zipCode = '20146' or zipCode = '20147' or zipCode = '20148' or zipCode = '20149' or zipCode = '20151' or zipCode = '20152' or zipCode = '20155' or zipCode = '20158' or zipCode = '20159' or zipCode = '20160' or zipCode = '20163' or zipCode = '20164' or zipCode = '20165' or zipCode = '20166' or zipCode = '20167' or zipCode = '20169' or zipCode = '20170' or zipCode = '20171' or zipCode = '20175' or zipCode = '20176' or zipCode = '20177' or zipCode = '20178' or zipCode = '20180' or zipCode = '20184' or zipCode = '20185' or zipCode = '20187' or zipCode = '20188' or zipCode = '20190' or zipCode = '20191' or zipCode = '20194' or zipCode = '20197' or zipCode = '20198' or zipCode = '20199' or zipCode = '20813' or zipCode = '20824' or zipCode = '20825' or zipCode = '20827' or zipCode = '20837' or zipCode = '20838' or zipCode = '20839' or zipCode = '20841' or zipCode = '20842' or zipCode = '20847' or zipCode = '20848' or zipCode = '20849' or zipCode = '20854' or zipCode = '20857' or zipCode = '20859' or zipCode = '20871' or zipCode = '20874' or zipCode = '20875' or zipCode = '20876' or zipCode = '20877' or zipCode = '20878' or zipCode = '20884' or zipCode = '20885' or zipCode = '20886' or zipCode = '20889' or zipCode = '20891' or zipCode = '20894' or zipCode = '20897' or zipCode = '20898' or zipCode = '20899' or zipCode = '20907' or zipCode = '20908' or zipCode = '20911' or zipCode = '20914' or zipCode = '20915' or zipCode = '20916' or zipCode = '20918' or zipCode = '20997' or zipCode = '21703' or zipCode = '21704' or zipCode = '21710' or zipCode = '21714' or zipCode = '21715' or zipCode = '21716' or zipCode = '21717' or zipCode = '21718' or zipCode = '21755' or zipCode = '21758' or zipCode = '21777' or zipCode = '21779' or zipCode = '21790' or zipCode = '22030' or zipCode = '22033' or zipCode = '22035' or zipCode = '22038' or zipCode = '22066' or zipCode = '22067' or zipCode = '22093' or zipCode = '22102' or zipCode = '22121' or zipCode = '22124' or zipCode = '22180' or zipCode = '22181' or zipCode = '22182' or zipCode = '22611' or zipCode = '22620' or zipCode = '22642' or zipCode = '22643' or zipCode = '22646' or zipCode = '25410' or zipCode = '25414' or zipCode = '25423' or zipCode = '25425' or zipCode = '25429' or zipCode = '25430' or zipCode = '25432' or zipCode = '25438' or zipCode = '25441' or zipCode = '25442' or zipCode = '25446')
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 11=11 and (zipCode ='20041' or zipCode = '20041' or zipCode = '20115' or zipCode = '20116' or zipCode = '20117' or zipCode = '20118' or zipCode = '20120' or zipCode = '20120' or zipCode = '20121' or zipCode = '20122' or zipCode = '20129' or zipCode = '20129' or zipCode = '20130' or zipCode = '20131' or zipCode = '20132' or zipCode = '20132' or zipCode = '20134' or zipCode = '20134' or zipCode = '20135' or zipCode = '20155' or zipCode = '20156' or zipCode = '20158' or zipCode = '20159' or zipCode = '20160' or zipCode = '20160' or zipCode = '20163' or zipCode = '20163' or zipCode = '20164' or zipCode = '20165' or zipCode = '20165' or zipCode = '20166' or zipCode = '20166' or zipCode = '20167' or zipCode = '20168' or zipCode = '20169' or zipCode = '20170' or zipCode = '20171' or zipCode = '20171' or zipCode = '20172' or zipCode = '20175' or zipCode = '20176' or zipCode = '20176' or zipCode = '20192' or zipCode = '20192' or zipCode = '20192' or zipCode = '20192' or zipCode = '20194' or zipCode = '20194' or zipCode = '20195' or zipCode = '20195' or zipCode = '20196' or zipCode = '20196' or zipCode = '20196' or zipCode = '20196' or zipCode = '20197' or zipCode = '20198' or zipCode = '20101' or zipCode = '20101' or zipCode = '20102' or zipCode = '20102' or zipCode = '20102' or zipCode = '20103' or zipCode = '20103' or zipCode = '20104' or zipCode = '20104' or zipCode = '20105' or zipCode = '20105' or zipCode = '20107' or zipCode = '20108' or zipCode = '20109' or zipCode = '20109' or zipCode = '20109' or zipCode = '20110' or zipCode = '20135' or zipCode = '20136' or zipCode = '20137' or zipCode = '20140' or zipCode = '20141' or zipCode = '20142' or zipCode = '20143' or zipCode = '20144' or zipCode = '20146' or zipCode = '20147' or zipCode = '20148' or zipCode = '20148' or zipCode = '20148' or zipCode = '20148' or zipCode = '20149' or zipCode = '20149' or zipCode = '20151' or zipCode = '20151' or zipCode = '20152' or zipCode = '20152' or zipCode = '20152' or zipCode = '20176' or zipCode = '20177' or zipCode = '20178' or zipCode = '20180' or zipCode = '20184' or zipCode = '20185' or zipCode = '20189' or zipCode = '20190' or zipCode = '20190' or zipCode = '20191' or zipCode = '20191' or zipCode = '20837' or zipCode = '20838' or zipCode = '20839' or zipCode = '20841' or zipCode = '20842' or zipCode = '20842' or zipCode = '20850' or zipCode = '20854' or zipCode = '20854' or zipCode = '20859' or zipCode = '20859' or zipCode = '20871' or zipCode = '20871' or zipCode = '20874' or zipCode = '20874' or zipCode = '20875' or zipCode = '20876' or zipCode = '20878' or zipCode = '20878' or zipCode = '20878' or zipCode = '20878' or zipCode = '20878' or zipCode = '20884' or zipCode = '20885' or zipCode = '20898' or zipCode = '20898' or zipCode = '20899' or zipCode = '20899' or zipCode = '21703' or zipCode = '21704' or zipCode = '21704' or zipCode = '21710' or zipCode = '21710' or zipCode = '21714' or zipCode = '21714' or zipCode = '21715' or zipCode = '21716' or zipCode = '21716' or zipCode = '21717' or zipCode = '21718' or zipCode = '21758' or zipCode = '21758' or zipCode = '21769' or zipCode = '21777' or zipCode = '21777' or zipCode = '21779' or zipCode = '21779' or zipCode = '21790' or zipCode = '21755' or zipCode = '22030' or zipCode = '22033' or zipCode = '22035' or zipCode = '22035' or zipCode = '22036' or zipCode = '22036' or zipCode = '22038' or zipCode = '22066' or zipCode = '22067' or zipCode = '22067' or zipCode = '22124' or zipCode = '22124' or zipCode = '22180' or zipCode = '22181' or zipCode = '22182' or zipCode = '22183' or zipCode = '22185' or zipCode = '22185' or zipCode = '22095' or zipCode = '22095' or zipCode = '22095' or zipCode = '22096' or zipCode = '22096' or zipCode = '22096' or zipCode = '22102' or zipCode = '22102' or zipCode = '22102' or zipCode = '22102' or zipCode = '22185' or zipCode = '22185' or zipCode = '22611' or zipCode = '22611' or zipCode = '22620' or zipCode = '22643' or zipCode = '22646' or zipCode = '25410' or zipCode = '25414' or zipCode = '25423' or zipCode = '25425' or zipCode = '25429' or zipCode = '25429' or zipCode = '25430' or zipCode = '25430' or zipCode = '25432' or zipCode = '25438' or zipCode = '25441' or zipCode = '25442' or zipCode = '25442' or zipCode = '25446' or zipCode = '20101' or zipCode = '20102' or zipCode = '20103' or zipCode = '20104' or zipCode = '20105' or zipCode = '20107' or zipCode = '20109' or zipCode = '20110' or zipCode = '20111' or zipCode = '20113' or zipCode = '20115' or zipCode = '20116' or zipCode = '20117' or zipCode = '20118' or zipCode = '20120' or zipCode = '20121' or zipCode = '20124' or zipCode = '20129' or zipCode = '20130' or zipCode = '20131' or zipCode = '20132' or zipCode = '20134' or zipCode = '20135' or zipCode = '20136' or zipCode = '20137' or zipCode = '20140' or zipCode = '20141' or zipCode = '20142' or zipCode = '20143' or zipCode = '20144' or zipCode = '20146' or zipCode = '20147' or zipCode = '20148' or zipCode = '20149' or zipCode = '20151' or zipCode = '20152' or zipCode = '20155' or zipCode = '20158' or zipCode = '20159' or zipCode = '20160' or zipCode = '20163' or zipCode = '20164' or zipCode = '20165' or zipCode = '20166' or zipCode = '20167' or zipCode = '20169' or zipCode = '20170' or zipCode = '20171' or zipCode = '20175' or zipCode = '20176' or zipCode = '20177' or zipCode = '20178' or zipCode = '20180' or zipCode = '20184' or zipCode = '20185' or zipCode = '20187' or zipCode = '20188' or zipCode = '20190' or zipCode = '20191' or zipCode = '20194' or zipCode = '20197' or zipCode = '20198' or zipCode = '20199' or zipCode = '20813' or zipCode = '20824' or zipCode = '20825' or zipCode = '20827' or zipCode = '20837' or zipCode = '20838' or zipCode = '20839' or zipCode = '20841' or zipCode = '20842' or zipCode = '20847' or zipCode = '20848' or zipCode = '20849' or zipCode = '20854' or zipCode = '20857' or zipCode = '20859' or zipCode = '20871' or zipCode = '20874' or zipCode = '20875' or zipCode = '20876' or zipCode = '20877' or zipCode = '20878' or zipCode = '20884' or zipCode = '20885' or zipCode = '20886' or zipCode = '20889' or zipCode = '20891' or zipCode = '20894' or zipCode = '20897' or zipCode = '20898' or zipCode = '20899' or zipCode = '20907' or zipCode = '20908' or zipCode = '20911' or zipCode = '20914' or zipCode = '20915' or zipCode = '20916' or zipCode = '20918' or zipCode = '20997' or zipCode = '21703' or zipCode = '21704' or zipCode = '21710' or zipCode = '21714' or zipCode = '21715' or zipCode = '21716' or zipCode = '21717' or zipCode = '21718' or zipCode = '21755' or zipCode = '21758' or zipCode = '21777' or zipCode = '21779' or zipCode = '21790' or zipCode = '22030' or zipCode = '22033' or zipCode = '22035' or zipCode = '22038' or zipCode = '22066' or zipCode = '22067' or zipCode = '22093' or zipCode = '22102' or zipCode = '22121' or zipCode = '22124' or zipCode = '22180' or zipCode = '22181' or zipCode = '22182' or zipCode = '22611' or zipCode = '22620' or zipCode = '22642' or zipCode = '22643' or zipCode = '22646' or zipCode = '25410' or zipCode = '25414' or zipCode = '25423' or zipCode = '25425' or zipCode = '25429' or zipCode = '25430' or zipCode = '25432' or zipCode = '25438' or zipCode = '25441' or zipCode = '25442' or zipCode = '25446') 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 11=11 and (zipCode ='20041' or zipCode = '20041' or zipCode = '20115' or zipCode = '20116' or zipCode = '20117' or zipCode = '20118' or zipCode = '20120' or zipCode = '20120' or zipCode = '20121' or zipCode = '20122' or zipCode = '20129' or zipCode = '20129' or zipCode = '20130' or zipCode = '20131' or zipCode = '20132' or zipCode = '20132' or zipCode = '20134' or zipCode = '20134' or zipCode = '20135' or zipCode = '20155' or zipCode = '20156' or zipCode = '20158' or zipCode = '20159' or zipCode = '20160' or zipCode = '20160' or zipCode = '20163' or zipCode = '20163' or zipCode = '20164' or zipCode = '20165' or zipCode = '20165' or zipCode = '20166' or zipCode = '20166' or zipCode = '20167' or zipCode = '20168' or zipCode = '20169' or zipCode = '20170' or zipCode = '20171' or zipCode = '20171' or zipCode = '20172' or zipCode = '20175' or zipCode = '20176' or zipCode = '20176' or zipCode = '20192' or zipCode = '20192' or zipCode = '20192' or zipCode = '20192' or zipCode = '20194' or zipCode = '20194' or zipCode = '20195' or zipCode = '20195' or zipCode = '20196' or zipCode = '20196' or zipCode = '20196' or zipCode = '20196' or zipCode = '20197' or zipCode = '20198' or zipCode = '20101' or zipCode = '20101' or zipCode = '20102' or zipCode = '20102' or zipCode = '20102' or zipCode = '20103' or zipCode = '20103' or zipCode = '20104' or zipCode = '20104' or zipCode = '20105' or zipCode = '20105' or zipCode = '20107' or zipCode = '20108' or zipCode = '20109' or zipCode = '20109' or zipCode = '20109' or zipCode = '20110' or zipCode = '20135' or zipCode = '20136' or zipCode = '20137' or zipCode = '20140' or zipCode = '20141' or zipCode = '20142' or zipCode = '20143' or zipCode = '20144' or zipCode = '20146' or zipCode = '20147' or zipCode = '20148' or zipCode = '20148' or zipCode = '20148' or zipCode = '20148' or zipCode = '20149' or zipCode = '20149' or zipCode = '20151' or zipCode = '20151' or zipCode = '20152' or zipCode = '20152' or zipCode = '20152' or zipCode = '20176' or zipCode = '20177' or zipCode = '20178' or zipCode = '20180' or zipCode = '20184' or zipCode = '20185' or zipCode = '20189' or zipCode = '20190' or zipCode = '20190' or zipCode = '20191' or zipCode = '20191' or zipCode = '20837' or zipCode = '20838' or zipCode = '20839' or zipCode = '20841' or zipCode = '20842' or zipCode = '20842' or zipCode = '20850' or zipCode = '20854' or zipCode = '20854' or zipCode = '20859' or zipCode = '20859' or zipCode = '20871' or zipCode = '20871' or zipCode = '20874' or zipCode = '20874' or zipCode = '20875' or zipCode = '20876' or zipCode = '20878' or zipCode = '20878' or zipCode = '20878' or zipCode = '20878' or zipCode = '20878' or zipCode = '20884' or zipCode = '20885' or zipCode = '20898' or zipCode = '20898' or zipCode = '20899' or zipCode = '20899' or zipCode = '21703' or zipCode = '21704' or zipCode = '21704' or zipCode = '21710' or zipCode = '21710' or zipCode = '21714' or zipCode = '21714' or zipCode = '21715' or zipCode = '21716' or zipCode = '21716' or zipCode = '21717' or zipCode = '21718' or zipCode = '21758' or zipCode = '21758' or zipCode = '21769' or zipCode = '21777' or zipCode = '21777' or zipCode = '21779' or zipCode = '21779' or zipCode = '21790' or zipCode = '21755' or zipCode = '22030' or zipCode = '22033' or zipCode = '22035' or zipCode = '22035' or zipCode = '22036' or zipCode = '22036' or zipCode = '22038' or zipCode = '22066' or zipCode = '22067' or zipCode = '22067' or zipCode = '22124' or zipCode = '22124' or zipCode = '22180' or zipCode = '22181' or zipCode = '22182' or zipCode = '22183' or zipCode = '22185' or zipCode = '22185' or zipCode = '22095' or zipCode = '22095' or zipCode = '22095' or zipCode = '22096' or zipCode = '22096' or zipCode = '22096' or zipCode = '22102' or zipCode = '22102' or zipCode = '22102' or zipCode = '22102' or zipCode = '22185' or zipCode = '22185' or zipCode = '22611' or zipCode = '22611' or zipCode = '22620' or zipCode = '22643' or zipCode = '22646' or zipCode = '25410' or zipCode = '25414' or zipCode = '25423' or zipCode = '25425' or zipCode = '25429' or zipCode = '25429' or zipCode = '25430' or zipCode = '25430' or zipCode = '25432' or zipCode = '25438' or zipCode = '25441' or zipCode = '25442' or zipCode = '25442' or zipCode = '25446' or zipCode = '20101' or zipCode = '20102' or zipCode = '20103' or zipCode = '20104' or zipCode = '20105' or zipCode = '20107' or zipCode = '20109' or zipCode = '20110' or zipCode = '20111' or zipCode = '20113' or zipCode = '20115' or zipCode = '20116' or zipCode = '20117' or zipCode = '20118' or zipCode = '20120' or zipCode = '20121' or zipCode = '20124' or zipCode = '20129' or zipCode = '20130' or zipCode = '20131' or zipCode = '20132' or zipCode = '20134' or zipCode = '20135' or zipCode = '20136' or zipCode = '20137' or zipCode = '20140' or zipCode = '20141' or zipCode = '20142' or zipCode = '20143' or zipCode = '20144' or zipCode = '20146' or zipCode = '20147' or zipCode = '20148' or zipCode = '20149' or zipCode = '20151' or zipCode = '20152' or zipCode = '20155' or zipCode = '20158' or zipCode = '20159' or zipCode = '20160' or zipCode = '20163' or zipCode = '20164' or zipCode = '20165' or zipCode = '20166' or zipCode = '20167' or zipCode = '20169' or zipCode = '20170' or zipCode = '20171' or zipCode = '20175' or zipCode = '20176' or zipCode = '20177' or zipCode = '20178' or zipCode = '20180' or zipCode = '20184' or zipCode = '20185' or zipCode = '20187' or zipCode = '20188' or zipCode = '20190' or zipCode = '20191' or zipCode = '20194' or zipCode = '20197' or zipCode = '20198' or zipCode = '20199' or zipCode = '20813' or zipCode = '20824' or zipCode = '20825' or zipCode = '20827' or zipCode = '20837' or zipCode = '20838' or zipCode = '20839' or zipCode = '20841' or zipCode = '20842' or zipCode = '20847' or zipCode = '20848' or zipCode = '20849' or zipCode = '20854' or zipCode = '20857' or zipCode = '20859' or zipCode = '20871' or zipCode = '20874' or zipCode = '20875' or zipCode = '20876' or zipCode = '20877' or zipCode = '20878' or zipCode = '20884' or zipCode = '20885' or zipCode = '20886' or zipCode = '20889' or zipCode = '20891' or zipCode = '20894' or zipCode = '20897' or zipCode = '20898' or zipCode = '20899' or zipCode = '20907' or zipCode = '20908' or zipCode = '20911' or zipCode = '20914' or zipCode = '20915' or zipCode = '20916' or zipCode = '20918' or zipCode = '20997' or zipCode = '21703' or zipCode = '21704' or zipCode = '21710' or zipCode = '21714' or zipCode = '21715' or zipCode = '21716' or zipCode = '21717' or zipCode = '21718' or zipCode = '21755' or zipCode = '21758' or zipCode = '21777' or zipCode = '21779' or zipCode = '21790' or zipCode = '22030' or zipCode = '22033' or zipCode = '22035' or zipCode = '22038' or zipCode = '22066' or zipCode = '22067' or zipCode = '22093' or zipCode = '22102' or zipCode = '22121' or zipCode = '22124' or zipCode = '22180' or zipCode = '22181' or zipCode = '22182' or zipCode = '22611' or zipCode = '22620' or zipCode = '22642' or zipCode = '22643' or zipCode = '22646' or zipCode = '25410' or zipCode = '25414' or zipCode = '25423' or zipCode = '25425' or zipCode = '25429' or zipCode = '25430' or zipCode = '25432' or zipCode = '25438' or zipCode = '25441' or zipCode = '25442' or zipCode = '25446') 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 11=11 and (zipCode ='20041' or zipCode = '20041' or zipCode = '20115' or zipCode = '20116' or zipCode = '20117' or zipCode = '20118' or zipCode = '20120' or zipCode = '20120' or zipCode = '20121' or zipCode = '20122' or zipCode = '20129' or zipCode = '20129' or zipCode = '20130' or zipCode = '20131' or zipCode = '20132' or zipCode = '20132' or zipCode = '20134' or zipCode = '20134' or zipCode = '20135' or zipCode = '20155' or zipCode = '20156' or zipCode = '20158' or zipCode = '20159' or zipCode = '20160' or zipCode = '20160' or zipCode = '20163' or zipCode = '20163' or zipCode = '20164' or zipCode = '20165' or zipCode = '20165' or zipCode = '20166' or zipCode = '20166' or zipCode = '20167' or zipCode = '20168' or zipCode = '20169' or zipCode = '20170' or zipCode = '20171' or zipCode = '20171' or zipCode = '20172' or zipCode = '20175' or zipCode = '20176' or zipCode = '20176' or zipCode = '20192' or zipCode = '20192' or zipCode = '20192' or zipCode = '20192' or zipCode = '20194' or zipCode = '20194' or zipCode = '20195' or zipCode = '20195' or zipCode = '20196' or zipCode = '20196' or zipCode = '20196' or zipCode = '20196' or zipCode = '20197' or zipCode = '20198' or zipCode = '20101' or zipCode = '20101' or zipCode = '20102' or zipCode = '20102' or zipCode = '20102' or zipCode = '20103' or zipCode = '20103' or zipCode = '20104' or zipCode = '20104' or zipCode = '20105' or zipCode = '20105' or zipCode = '20107' or zipCode = '20108' or zipCode = '20109' or zipCode = '20109' or zipCode = '20109' or zipCode = '20110' or zipCode = '20135' or zipCode = '20136' or zipCode = '20137' or zipCode = '20140' or zipCode = '20141' or zipCode = '20142' or zipCode = '20143' or zipCode = '20144' or zipCode = '20146' or zipCode = '20147' or zipCode = '20148' or zipCode = '20148' or zipCode = '20148' or zipCode = '20148' or zipCode = '20149' or zipCode = '20149' or zipCode = '20151' or zipCode = '20151' or zipCode = '20152' or zipCode = '20152' or zipCode = '20152' or zipCode = '20176' or zipCode = '20177' or zipCode = '20178' or zipCode = '20180' or zipCode = '20184' or zipCode = '20185' or zipCode = '20189' or zipCode = '20190' or zipCode = '20190' or zipCode = '20191' or zipCode = '20191' or zipCode = '20837' or zipCode = '20838' or zipCode = '20839' or zipCode = '20841' or zipCode = '20842' or zipCode = '20842' or zipCode = '20850' or zipCode = '20854' or zipCode = '20854' or zipCode = '20859' or zipCode = '20859' or zipCode = '20871' or zipCode = '20871' or zipCode = '20874' or zipCode = '20874' or zipCode = '20875' or zipCode = '20876' or zipCode = '20878' or zipCode = '20878' or zipCode = '20878' or zipCode = '20878' or zipCode = '20878' or zipCode = '20884' or zipCode = '20885' or zipCode = '20898' or zipCode = '20898' or zipCode = '20899' or zipCode = '20899' or zipCode = '21703' or zipCode = '21704' or zipCode = '21704' or zipCode = '21710' or zipCode = '21710' or zipCode = '21714' or zipCode = '21714' or zipCode = '21715' or zipCode = '21716' or zipCode = '21716' or zipCode = '21717' or zipCode = '21718' or zipCode = '21758' or zipCode = '21758' or zipCode = '21769' or zipCode = '21777' or zipCode = '21777' or zipCode = '21779' or zipCode = '21779' or zipCode = '21790' or zipCode = '21755' or zipCode = '22030' or zipCode = '22033' or zipCode = '22035' or zipCode = '22035' or zipCode = '22036' or zipCode = '22036' or zipCode = '22038' or zipCode = '22066' or zipCode = '22067' or zipCode = '22067' or zipCode = '22124' or zipCode = '22124' or zipCode = '22180' or zipCode = '22181' or zipCode = '22182' or zipCode = '22183' or zipCode = '22185' or zipCode = '22185' or zipCode = '22095' or zipCode = '22095' or zipCode = '22095' or zipCode = '22096' or zipCode = '22096' or zipCode = '22096' or zipCode = '22102' or zipCode = '22102' or zipCode = '22102' or zipCode = '22102' or zipCode = '22185' or zipCode = '22185' or zipCode = '22611' or zipCode = '22611' or zipCode = '22620' or zipCode = '22643' or zipCode = '22646' or zipCode = '25410' or zipCode = '25414' or zipCode = '25423' or zipCode = '25425' or zipCode = '25429' or zipCode = '25429' or zipCode = '25430' or zipCode = '25430' or zipCode = '25432' or zipCode = '25438' or zipCode = '25441' or zipCode = '25442' or zipCode = '25442' or zipCode = '25446' or zipCode = '20101' or zipCode = '20102' or zipCode = '20103' or zipCode = '20104' or zipCode = '20105' or zipCode = '20107' or zipCode = '20109' or zipCode = '20110' or zipCode = '20111' or zipCode = '20113' or zipCode = '20115' or zipCode = '20116' or zipCode = '20117' or zipCode = '20118' or zipCode = '20120' or zipCode = '20121' or zipCode = '20124' or zipCode = '20129' or zipCode = '20130' or zipCode = '20131' or zipCode = '20132' or zipCode = '20134' or zipCode = '20135' or zipCode = '20136' or zipCode = '20137' or zipCode = '20140' or zipCode = '20141' or zipCode = '20142' or zipCode = '20143' or zipCode = '20144' or zipCode = '20146' or zipCode = '20147' or zipCode = '20148' or zipCode = '20149' or zipCode = '20151' or zipCode = '20152' or zipCode = '20155' or zipCode = '20158' or zipCode = '20159' or zipCode = '20160' or zipCode = '20163' or zipCode = '20164' or zipCode = '20165' or zipCode = '20166' or zipCode = '20167' or zipCode = '20169' or zipCode = '20170' or zipCode = '20171' or zipCode = '20175' or zipCode = '20176' or zipCode = '20177' or zipCode = '20178' or zipCode = '20180' or zipCode = '20184' or zipCode = '20185' or zipCode = '20187' or zipCode = '20188' or zipCode = '20190' or zipCode = '20191' or zipCode = '20194' or zipCode = '20197' or zipCode = '20198' or zipCode = '20199' or zipCode = '20813' or zipCode = '20824' or zipCode = '20825' or zipCode = '20827' or zipCode = '20837' or zipCode = '20838' or zipCode = '20839' or zipCode = '20841' or zipCode = '20842' or zipCode = '20847' or zipCode = '20848' or zipCode = '20849' or zipCode = '20854' or zipCode = '20857' or zipCode = '20859' or zipCode = '20871' or zipCode = '20874' or zipCode = '20875' or zipCode = '20876' or zipCode = '20877' or zipCode = '20878' or zipCode = '20884' or zipCode = '20885' or zipCode = '20886' or zipCode = '20889' or zipCode = '20891' or zipCode = '20894' or zipCode = '20897' or zipCode = '20898' or zipCode = '20899' or zipCode = '20907' or zipCode = '20908' or zipCode = '20911' or zipCode = '20914' or zipCode = '20915' or zipCode = '20916' or zipCode = '20918' or zipCode = '20997' or zipCode = '21703' or zipCode = '21704' or zipCode = '21710' or zipCode = '21714' or zipCode = '21715' or zipCode = '21716' or zipCode = '21717' or zipCode = '21718' or zipCode = '21755' or zipCode = '21758' or zipCode = '21777' or zipCode = '21779' or zipCode = '21790' or zipCode = '22030' or zipCode = '22033' or zipCode = '22035' or zipCode = '22038' or zipCode = '22066' or zipCode = '22067' or zipCode = '22093' or zipCode = '22102' or zipCode = '22121' or zipCode = '22124' or zipCode = '22180' or zipCode = '22181' or zipCode = '22182' or zipCode = '22611' or zipCode = '22620' or zipCode = '22642' or zipCode = '22643' or zipCode = '22646' or zipCode = '25410' or zipCode = '25414' or zipCode = '25423' or zipCode = '25425' or zipCode = '25429' or zipCode = '25430' or zipCode = '25432' or zipCode = '25438' or zipCode = '25441' or zipCode = '25442' or zipCode = '25446') 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 11=11 and (zipCode ='20041' or zipCode = '20041' or zipCode = '20115' or zipCode = '20116' or zipCode = '20117' or zipCode = '20118' or zipCode = '20120' or zipCode = '20120' or zipCode = '20121' or zipCode = '20122' or zipCode = '20129' or zipCode = '20129' or zipCode = '20130' or zipCode = '20131' or zipCode = '20132' or zipCode = '20132' or zipCode = '20134' or zipCode = '20134' or zipCode = '20135' or zipCode = '20155' or zipCode = '20156' or zipCode = '20158' or zipCode = '20159' or zipCode = '20160' or zipCode = '20160' or zipCode = '20163' or zipCode = '20163' or zipCode = '20164' or zipCode = '20165' or zipCode = '20165' or zipCode = '20166' or zipCode = '20166' or zipCode = '20167' or zipCode = '20168' or zipCode = '20169' or zipCode = '20170' or zipCode = '20171' or zipCode = '20171' or zipCode = '20172' or zipCode = '20175' or zipCode = '20176' or zipCode = '20176' or zipCode = '20192' or zipCode = '20192' or zipCode = '20192' or zipCode = '20192' or zipCode = '20194' or zipCode = '20194' or zipCode = '20195' or zipCode = '20195' or zipCode = '20196' or zipCode = '20196' or zipCode = '20196' or zipCode = '20196' or zipCode = '20197' or zipCode = '20198' or zipCode = '20101' or zipCode = '20101' or zipCode = '20102' or zipCode = '20102' or zipCode = '20102' or zipCode = '20103' or zipCode = '20103' or zipCode = '20104' or zipCode = '20104' or zipCode = '20105' or zipCode = '20105' or zipCode = '20107' or zipCode = '20108' or zipCode = '20109' or zipCode = '20109' or zipCode = '20109' or zipCode = '20110' or zipCode = '20135' or zipCode = '20136' or zipCode = '20137' or zipCode = '20140' or zipCode = '20141' or zipCode = '20142' or zipCode = '20143' or zipCode = '20144' or zipCode = '20146' or zipCode = '20147' or zipCode = '20148' or zipCode = '20148' or zipCode = '20148' or zipCode = '20148' or zipCode = '20149' or zipCode = '20149' or zipCode = '20151' or zipCode = '20151' or zipCode = '20152' or zipCode = '20152' or zipCode = '20152' or zipCode = '20176' or zipCode = '20177' or zipCode = '20178' or zipCode = '20180' or zipCode = '20184' or zipCode = '20185' or zipCode = '20189' or zipCode = '20190' or zipCode = '20190' or zipCode = '20191' or zipCode = '20191' or zipCode = '20837' or zipCode = '20838' or zipCode = '20839' or zipCode = '20841' or zipCode = '20842' or zipCode = '20842' or zipCode = '20850' or zipCode = '20854' or zipCode = '20854' or zipCode = '20859' or zipCode = '20859' or zipCode = '20871' or zipCode = '20871' or zipCode = '20874' or zipCode = '20874' or zipCode = '20875' or zipCode = '20876' or zipCode = '20878' or zipCode = '20878' or zipCode = '20878' or zipCode = '20878' or zipCode = '20878' or zipCode = '20884' or zipCode = '20885' or zipCode = '20898' or zipCode = '20898' or zipCode = '20899' or zipCode = '20899' or zipCode = '21703' or zipCode = '21704' or zipCode = '21704' or zipCode = '21710' or zipCode = '21710' or zipCode = '21714' or zipCode = '21714' or zipCode = '21715' or zipCode = '21716' or zipCode = '21716' or zipCode = '21717' or zipCode = '21718' or zipCode = '21758' or zipCode = '21758' or zipCode = '21769' or zipCode = '21777' or zipCode = '21777' or zipCode = '21779' or zipCode = '21779' or zipCode = '21790' or zipCode = '21755' or zipCode = '22030' or zipCode = '22033' or zipCode = '22035' or zipCode = '22035' or zipCode = '22036' or zipCode = '22036' or zipCode = '22038' or zipCode = '22066' or zipCode = '22067' or zipCode = '22067' or zipCode = '22124' or zipCode = '22124' or zipCode = '22180' or zipCode = '22181' or zipCode = '22182' or zipCode = '22183' or zipCode = '22185' or zipCode = '22185' or zipCode = '22095' or zipCode = '22095' or zipCode = '22095' or zipCode = '22096' or zipCode = '22096' or zipCode = '22096' or zipCode = '22102' or zipCode = '22102' or zipCode = '22102' or zipCode = '22102' or zipCode = '22185' or zipCode = '22185' or zipCode = '22611' or zipCode = '22611' or zipCode = '22620' or zipCode = '22643' or zipCode = '22646' or zipCode = '25410' or zipCode = '25414' or zipCode = '25423' or zipCode = '25425' or zipCode = '25429' or zipCode = '25429' or zipCode = '25430' or zipCode = '25430' or zipCode = '25432' or zipCode = '25438' or zipCode = '25441' or zipCode = '25442' or zipCode = '25442' or zipCode = '25446' or zipCode = '20101' or zipCode = '20102' or zipCode = '20103' or zipCode = '20104' or zipCode = '20105' or zipCode = '20107' or zipCode = '20109' or zipCode = '20110' or zipCode = '20111' or zipCode = '20113' or zipCode = '20115' or zipCode = '20116' or zipCode = '20117' or zipCode = '20118' or zipCode = '20120' or zipCode = '20121' or zipCode = '20124' or zipCode = '20129' or zipCode = '20130' or zipCode = '20131' or zipCode = '20132' or zipCode = '20134' or zipCode = '20135' or zipCode = '20136' or zipCode = '20137' or zipCode = '20140' or zipCode = '20141' or zipCode = '20142' or zipCode = '20143' or zipCode = '20144' or zipCode = '20146' or zipCode = '20147' or zipCode = '20148' or zipCode = '20149' or zipCode = '20151' or zipCode = '20152' or zipCode = '20155' or zipCode = '20158' or zipCode = '20159' or zipCode = '20160' or zipCode = '20163' or zipCode = '20164' or zipCode = '20165' or zipCode = '20166' or zipCode = '20167' or zipCode = '20169' or zipCode = '20170' or zipCode = '20171' or zipCode = '20175' or zipCode = '20176' or zipCode = '20177' or zipCode = '20178' or zipCode = '20180' or zipCode = '20184' or zipCode = '20185' or zipCode = '20187' or zipCode = '20188' or zipCode = '20190' or zipCode = '20191' or zipCode = '20194' or zipCode = '20197' or zipCode = '20198' or zipCode = '20199' or zipCode = '20813' or zipCode = '20824' or zipCode = '20825' or zipCode = '20827' or zipCode = '20837' or zipCode = '20838' or zipCode = '20839' or zipCode = '20841' or zipCode = '20842' or zipCode = '20847' or zipCode = '20848' or zipCode = '20849' or zipCode = '20854' or zipCode = '20857' or zipCode = '20859' or zipCode = '20871' or zipCode = '20874' or zipCode = '20875' or zipCode = '20876' or zipCode = '20877' or zipCode = '20878' or zipCode = '20884' or zipCode = '20885' or zipCode = '20886' or zipCode = '20889' or zipCode = '20891' or zipCode = '20894' or zipCode = '20897' or zipCode = '20898' or zipCode = '20899' or zipCode = '20907' or zipCode = '20908' or zipCode = '20911' or zipCode = '20914' or zipCode = '20915' or zipCode = '20916' or zipCode = '20918' or zipCode = '20997' or zipCode = '21703' or zipCode = '21704' or zipCode = '21710' or zipCode = '21714' or zipCode = '21715' or zipCode = '21716' or zipCode = '21717' or zipCode = '21718' or zipCode = '21755' or zipCode = '21758' or zipCode = '21777' or zipCode = '21779' or zipCode = '21790' or zipCode = '22030' or zipCode = '22033' or zipCode = '22035' or zipCode = '22038' or zipCode = '22066' or zipCode = '22067' or zipCode = '22093' or zipCode = '22102' or zipCode = '22121' or zipCode = '22124' or zipCode = '22180' or zipCode = '22181' or zipCode = '22182' or zipCode = '22611' or zipCode = '22620' or zipCode = '22642' or zipCode = '22643' or zipCode = '22646' or zipCode = '25410' or zipCode = '25414' or zipCode = '25423' or zipCode = '25425' or zipCode = '25429' or zipCode = '25430' or zipCode = '25432' or zipCode = '25438' or zipCode = '25441' or zipCode = '25442' or zipCode = '25446') 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 11=11 and (zipCode ='20041' or zipCode = '20041' or zipCode = '20115' or zipCode = '20116' or zipCode = '20117' or zipCode = '20118' or zipCode = '20120' or zipCode = '20120' or zipCode = '20121' or zipCode = '20122' or zipCode = '20129' or zipCode = '20129' or zipCode = '20130' or zipCode = '20131' or zipCode = '20132' or zipCode = '20132' or zipCode = '20134' or zipCode = '20134' or zipCode = '20135' or zipCode = '20155' or zipCode = '20156' or zipCode = '20158' or zipCode = '20159' or zipCode = '20160' or zipCode = '20160' or zipCode = '20163' or zipCode = '20163' or zipCode = '20164' or zipCode = '20165' or zipCode = '20165' or zipCode = '20166' or zipCode = '20166' or zipCode = '20167' or zipCode = '20168' or zipCode = '20169' or zipCode = '20170' or zipCode = '20171' or zipCode = '20171' or zipCode = '20172' or zipCode = '20175' or zipCode = '20176' or zipCode = '20176' or zipCode = '20192' or zipCode = '20192' or zipCode = '20192' or zipCode = '20192' or zipCode = '20194' or zipCode = '20194' or zipCode = '20195' or zipCode = '20195' or zipCode = '20196' or zipCode = '20196' or zipCode = '20196' or zipCode = '20196' or zipCode = '20197' or zipCode = '20198' or zipCode = '20101' or zipCode = '20101' or zipCode = '20102' or zipCode = '20102' or zipCode = '20102' or zipCode = '20103' or zipCode = '20103' or zipCode = '20104' or zipCode = '20104' or zipCode = '20105' or zipCode = '20105' or zipCode = '20107' or zipCode = '20108' or zipCode = '20109' or zipCode = '20109' or zipCode = '20109' or zipCode = '20110' or zipCode = '20135' or zipCode = '20136' or zipCode = '20137' or zipCode = '20140' or zipCode = '20141' or zipCode = '20142' or zipCode = '20143' or zipCode = '20144' or zipCode = '20146' or zipCode = '20147' or zipCode = '20148' or zipCode = '20148' or zipCode = '20148' or zipCode = '20148' or zipCode = '20149' or zipCode = '20149' or zipCode = '20151' or zipCode = '20151' or zipCode = '20152' or zipCode = '20152' or zipCode = '20152' or zipCode = '20176' or zipCode = '20177' or zipCode = '20178' or zipCode = '20180' or zipCode = '20184' or zipCode = '20185' or zipCode = '20189' or zipCode = '20190' or zipCode = '20190' or zipCode = '20191' or zipCode = '20191' or zipCode = '20837' or zipCode = '20838' or zipCode = '20839' or zipCode = '20841' or zipCode = '20842' or zipCode = '20842' or zipCode = '20850' or zipCode = '20854' or zipCode = '20854' or zipCode = '20859' or zipCode = '20859' or zipCode = '20871' or zipCode = '20871' or zipCode = '20874' or zipCode = '20874' or zipCode = '20875' or zipCode = '20876' or zipCode = '20878' or zipCode = '20878' or zipCode = '20878' or zipCode = '20878' or zipCode = '20878' or zipCode = '20884' or zipCode = '20885' or zipCode = '20898' or zipCode = '20898' or zipCode = '20899' or zipCode = '20899' or zipCode = '21703' or zipCode = '21704' or zipCode = '21704' or zipCode = '21710' or zipCode = '21710' or zipCode = '21714' or zipCode = '21714' or zipCode = '21715' or zipCode = '21716' or zipCode = '21716' or zipCode = '21717' or zipCode = '21718' or zipCode = '21758' or zipCode = '21758' or zipCode = '21769' or zipCode = '21777' or zipCode = '21777' or zipCode = '21779' or zipCode = '21779' or zipCode = '21790' or zipCode = '21755' or zipCode = '22030' or zipCode = '22033' or zipCode = '22035' or zipCode = '22035' or zipCode = '22036' or zipCode = '22036' or zipCode = '22038' or zipCode = '22066' or zipCode = '22067' or zipCode = '22067' or zipCode = '22124' or zipCode = '22124' or zipCode = '22180' or zipCode = '22181' or zipCode = '22182' or zipCode = '22183' or zipCode = '22185' or zipCode = '22185' or zipCode = '22095' or zipCode = '22095' or zipCode = '22095' or zipCode = '22096' or zipCode = '22096' or zipCode = '22096' or zipCode = '22102' or zipCode = '22102' or zipCode = '22102' or zipCode = '22102' or zipCode = '22185' or zipCode = '22185' or zipCode = '22611' or zipCode = '22611' or zipCode = '22620' or zipCode = '22643' or zipCode = '22646' or zipCode = '25410' or zipCode = '25414' or zipCode = '25423' or zipCode = '25425' or zipCode = '25429' or zipCode = '25429' or zipCode = '25430' or zipCode = '25430' or zipCode = '25432' or zipCode = '25438' or zipCode = '25441' or zipCode = '25442' or zipCode = '25442' or zipCode = '25446' or zipCode = '20101' or zipCode = '20102' or zipCode = '20103' or zipCode = '20104' or zipCode = '20105' or zipCode = '20107' or zipCode = '20109' or zipCode = '20110' or zipCode = '20111' or zipCode = '20113' or zipCode = '20115' or zipCode = '20116' or zipCode = '20117' or zipCode = '20118' or zipCode = '20120' or zipCode = '20121' or zipCode = '20124' or zipCode = '20129' or zipCode = '20130' or zipCode = '20131' or zipCode = '20132' or zipCode = '20134' or zipCode = '20135' or zipCode = '20136' or zipCode = '20137' or zipCode = '20140' or zipCode = '20141' or zipCode = '20142' or zipCode = '20143' or zipCode = '20144' or zipCode = '20146' or zipCode = '20147' or zipCode = '20148' or zipCode = '20149' or zipCode = '20151' or zipCode = '20152' or zipCode = '20155' or zipCode = '20158' or zipCode = '20159' or zipCode = '20160' or zipCode = '20163' or zipCode = '20164' or zipCode = '20165' or zipCode = '20166' or zipCode = '20167' or zipCode = '20169' or zipCode = '20170' or zipCode = '20171' or zipCode = '20175' or zipCode = '20176' or zipCode = '20177' or zipCode = '20178' or zipCode = '20180' or zipCode = '20184' or zipCode = '20185' or zipCode = '20187' or zipCode = '20188' or zipCode = '20190' or zipCode = '20191' or zipCode = '20194' or zipCode = '20197' or zipCode = '20198' or zipCode = '20199' or zipCode = '20813' or zipCode = '20824' or zipCode = '20825' or zipCode = '20827' or zipCode = '20837' or zipCode = '20838' or zipCode = '20839' or zipCode = '20841' or zipCode = '20842' or zipCode = '20847' or zipCode = '20848' or zipCode = '20849' or zipCode = '20854' or zipCode = '20857' or zipCode = '20859' or zipCode = '20871' or zipCode = '20874' or zipCode = '20875' or zipCode = '20876' or zipCode = '20877' or zipCode = '20878' or zipCode = '20884' or zipCode = '20885' or zipCode = '20886' or zipCode = '20889' or zipCode = '20891' or zipCode = '20894' or zipCode = '20897' or zipCode = '20898' or zipCode = '20899' or zipCode = '20907' or zipCode = '20908' or zipCode = '20911' or zipCode = '20914' or zipCode = '20915' or zipCode = '20916' or zipCode = '20918' or zipCode = '20997' or zipCode = '21703' or zipCode = '21704' or zipCode = '21710' or zipCode = '21714' or zipCode = '21715' or zipCode = '21716' or zipCode = '21717' or zipCode = '21718' or zipCode = '21755' or zipCode = '21758' or zipCode = '21777' or zipCode = '21779' or zipCode = '21790' or zipCode = '22030' or zipCode = '22033' or zipCode = '22035' or zipCode = '22038' or zipCode = '22066' or zipCode = '22067' or zipCode = '22093' or zipCode = '22102' or zipCode = '22121' or zipCode = '22124' or zipCode = '22180' or zipCode = '22181' or zipCode = '22182' or zipCode = '22611' or zipCode = '22620' or zipCode = '22642' or zipCode = '22643' or zipCode = '22646' or zipCode = '25410' or zipCode = '25414' or zipCode = '25423' or zipCode = '25425' or zipCode = '25429' or zipCode = '25430' or zipCode = '25432' or zipCode = '25438' or zipCode = '25441' or zipCode = '25442' or zipCode = '25446') 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 11=11 and (zipCode ='20041' or zipCode = '20041' or zipCode = '20115' or zipCode = '20116' or zipCode = '20117' or zipCode = '20118' or zipCode = '20120' or zipCode = '20120' or zipCode = '20121' or zipCode = '20122' or zipCode = '20129' or zipCode = '20129' or zipCode = '20130' or zipCode = '20131' or zipCode = '20132' or zipCode = '20132' or zipCode = '20134' or zipCode = '20134' or zipCode = '20135' or zipCode = '20155' or zipCode = '20156' or zipCode = '20158' or zipCode = '20159' or zipCode = '20160' or zipCode = '20160' or zipCode = '20163' or zipCode = '20163' or zipCode = '20164' or zipCode = '20165' or zipCode = '20165' or zipCode = '20166' or zipCode = '20166' or zipCode = '20167' or zipCode = '20168' or zipCode = '20169' or zipCode = '20170' or zipCode = '20171' or zipCode = '20171' or zipCode = '20172' or zipCode = '20175' or zipCode = '20176' or zipCode = '20176' or zipCode = '20192' or zipCode = '20192' or zipCode = '20192' or zipCode = '20192' or zipCode = '20194' or zipCode = '20194' or zipCode = '20195' or zipCode = '20195' or zipCode = '20196' or zipCode = '20196' or zipCode = '20196' or zipCode = '20196' or zipCode = '20197' or zipCode = '20198' or zipCode = '20101' or zipCode = '20101' or zipCode = '20102' or zipCode = '20102' or zipCode = '20102' or zipCode = '20103' or zipCode = '20103' or zipCode = '20104' or zipCode = '20104' or zipCode = '20105' or zipCode = '20105' or zipCode = '20107' or zipCode = '20108' or zipCode = '20109' or zipCode = '20109' or zipCode = '20109' or zipCode = '20110' or zipCode = '20135' or zipCode = '20136' or zipCode = '20137' or zipCode = '20140' or zipCode = '20141' or zipCode = '20142' or zipCode = '20143' or zipCode = '20144' or zipCode = '20146' or zipCode = '20147' or zipCode = '20148' or zipCode = '20148' or zipCode = '20148' or zipCode = '20148' or zipCode = '20149' or zipCode = '20149' or zipCode = '20151' or zipCode = '20151' or zipCode = '20152' or zipCode = '20152' or zipCode = '20152' or zipCode = '20176' or zipCode = '20177' or zipCode = '20178' or zipCode = '20180' or zipCode = '20184' or zipCode = '20185' or zipCode = '20189' or zipCode = '20190' or zipCode = '20190' or zipCode = '20191' or zipCode = '20191' or zipCode = '20837' or zipCode = '20838' or zipCode = '20839' or zipCode = '20841' or zipCode = '20842' or zipCode = '20842' or zipCode = '20850' or zipCode = '20854' or zipCode = '20854' or zipCode = '20859' or zipCode = '20859' or zipCode = '20871' or zipCode = '20871' or zipCode = '20874' or zipCode = '20874' or zipCode = '20875' or zipCode = '20876' or zipCode = '20878' or zipCode = '20878' or zipCode = '20878' or zipCode = '20878' or zipCode = '20878' or zipCode = '20884' or zipCode = '20885' or zipCode = '20898' or zipCode = '20898' or zipCode = '20899' or zipCode = '20899' or zipCode = '21703' or zipCode = '21704' or zipCode = '21704' or zipCode = '21710' or zipCode = '21710' or zipCode = '21714' or zipCode = '21714' or zipCode = '21715' or zipCode = '21716' or zipCode = '21716' or zipCode = '21717' or zipCode = '21718' or zipCode = '21758' or zipCode = '21758' or zipCode = '21769' or zipCode = '21777' or zipCode = '21777' or zipCode = '21779' or zipCode = '21779' or zipCode = '21790' or zipCode = '21755' or zipCode = '22030' or zipCode = '22033' or zipCode = '22035' or zipCode = '22035' or zipCode = '22036' or zipCode = '22036' or zipCode = '22038' or zipCode = '22066' or zipCode = '22067' or zipCode = '22067' or zipCode = '22124' or zipCode = '22124' or zipCode = '22180' or zipCode = '22181' or zipCode = '22182' or zipCode = '22183' or zipCode = '22185' or zipCode = '22185' or zipCode = '22095' or zipCode = '22095' or zipCode = '22095' or zipCode = '22096' or zipCode = '22096' or zipCode = '22096' or zipCode = '22102' or zipCode = '22102' or zipCode = '22102' or zipCode = '22102' or zipCode = '22185' or zipCode = '22185' or zipCode = '22611' or zipCode = '22611' or zipCode = '22620' or zipCode = '22643' or zipCode = '22646' or zipCode = '25410' or zipCode = '25414' or zipCode = '25423' or zipCode = '25425' or zipCode = '25429' or zipCode = '25429' or zipCode = '25430' or zipCode = '25430' or zipCode = '25432' or zipCode = '25438' or zipCode = '25441' or zipCode = '25442' or zipCode = '25442' or zipCode = '25446' or zipCode = '20101' or zipCode = '20102' or zipCode = '20103' or zipCode = '20104' or zipCode = '20105' or zipCode = '20107' or zipCode = '20109' or zipCode = '20110' or zipCode = '20111' or zipCode = '20113' or zipCode = '20115' or zipCode = '20116' or zipCode = '20117' or zipCode = '20118' or zipCode = '20120' or zipCode = '20121' or zipCode = '20124' or zipCode = '20129' or zipCode = '20130' or zipCode = '20131' or zipCode = '20132' or zipCode = '20134' or zipCode = '20135' or zipCode = '20136' or zipCode = '20137' or zipCode = '20140' or zipCode = '20141' or zipCode = '20142' or zipCode = '20143' or zipCode = '20144' or zipCode = '20146' or zipCode = '20147' or zipCode = '20148' or zipCode = '20149' or zipCode = '20151' or zipCode = '20152' or zipCode = '20155' or zipCode = '20158' or zipCode = '20159' or zipCode = '20160' or zipCode = '20163' or zipCode = '20164' or zipCode = '20165' or zipCode = '20166' or zipCode = '20167' or zipCode = '20169' or zipCode = '20170' or zipCode = '20171' or zipCode = '20175' or zipCode = '20176' or zipCode = '20177' or zipCode = '20178' or zipCode = '20180' or zipCode = '20184' or zipCode = '20185' or zipCode = '20187' or zipCode = '20188' or zipCode = '20190' or zipCode = '20191' or zipCode = '20194' or zipCode = '20197' or zipCode = '20198' or zipCode = '20199' or zipCode = '20813' or zipCode = '20824' or zipCode = '20825' or zipCode = '20827' or zipCode = '20837' or zipCode = '20838' or zipCode = '20839' or zipCode = '20841' or zipCode = '20842' or zipCode = '20847' or zipCode = '20848' or zipCode = '20849' or zipCode = '20854' or zipCode = '20857' or zipCode = '20859' or zipCode = '20871' or zipCode = '20874' or zipCode = '20875' or zipCode = '20876' or zipCode = '20877' or zipCode = '20878' or zipCode = '20884' or zipCode = '20885' or zipCode = '20886' or zipCode = '20889' or zipCode = '20891' or zipCode = '20894' or zipCode = '20897' or zipCode = '20898' or zipCode = '20899' or zipCode = '20907' or zipCode = '20908' or zipCode = '20911' or zipCode = '20914' or zipCode = '20915' or zipCode = '20916' or zipCode = '20918' or zipCode = '20997' or zipCode = '21703' or zipCode = '21704' or zipCode = '21710' or zipCode = '21714' or zipCode = '21715' or zipCode = '21716' or zipCode = '21717' or zipCode = '21718' or zipCode = '21755' or zipCode = '21758' or zipCode = '21777' or zipCode = '21779' or zipCode = '21790' or zipCode = '22030' or zipCode = '22033' or zipCode = '22035' or zipCode = '22038' or zipCode = '22066' or zipCode = '22067' or zipCode = '22093' or zipCode = '22102' or zipCode = '22121' or zipCode = '22124' or zipCode = '22180' or zipCode = '22181' or zipCode = '22182' or zipCode = '22611' or zipCode = '22620' or zipCode = '22642' or zipCode = '22643' or zipCode = '22646' or zipCode = '25410' or zipCode = '25414' or zipCode = '25423' or zipCode = '25425' or zipCode = '25429' or zipCode = '25430' or zipCode = '25432' or zipCode = '25438' or zipCode = '25441' or zipCode = '25442' or zipCode = '25446') order by price;
select top 45 * from house NOLOCK where 1=1 and (1=1) and 11=11 and (property_zip ='20041' or property_zip = '20041' or property_zip = '20115' or property_zip = '20116' or property_zip = '20117' or property_zip = '20118' or property_zip = '20120' or property_zip = '20120' or property_zip = '20121' or property_zip = '20122' or property_zip = '20129' or property_zip = '20129' or property_zip = '20130' or property_zip = '20131' or property_zip = '20132' or property_zip = '20132' or property_zip = '20134' or property_zip = '20134' or property_zip = '20135' or property_zip = '20155' or property_zip = '20156' or property_zip = '20158' or property_zip = '20159' or property_zip = '20160' or property_zip = '20160' or property_zip = '20163' or property_zip = '20163' or property_zip = '20164' or property_zip = '20165' or property_zip = '20165' or property_zip = '20166' or property_zip = '20166' or property_zip = '20167' or property_zip = '20168' or property_zip = '20169' or property_zip = '20170' or property_zip = '20171' or property_zip = '20171' or property_zip = '20172' or property_zip = '20175' or property_zip = '20176' or property_zip = '20176' or property_zip = '20192' or property_zip = '20192' or property_zip = '20192' or property_zip = '20192' or property_zip = '20194' or property_zip = '20194' or property_zip = '20195' or property_zip = '20195' or property_zip = '20196' or property_zip = '20196' or property_zip = '20196' or property_zip = '20196' or property_zip = '20197' or property_zip = '20198' or property_zip = '20101' or property_zip = '20101' or property_zip = '20102' or property_zip = '20102' or property_zip = '20102' or property_zip = '20103' or property_zip = '20103' or property_zip = '20104' or property_zip = '20104' or property_zip = '20105' or property_zip = '20105' or property_zip = '20107' or property_zip = '20108' or property_zip = '20109' or property_zip = '20109' or property_zip = '20109' or property_zip = '20110' or property_zip = '20135' or property_zip = '20136' or property_zip = '20137' or property_zip = '20140' or property_zip = '20141' or property_zip = '20142' or property_zip = '20143' or property_zip = '20144' or property_zip = '20146' or property_zip = '20147' or property_zip = '20148' or property_zip = '20148' or property_zip = '20148' or property_zip = '20148' or property_zip = '20149' or property_zip = '20149' or property_zip = '20151' or property_zip = '20151' or property_zip = '20152' or property_zip = '20152' or property_zip = '20152' or property_zip = '20176' or property_zip = '20177' or property_zip = '20178' or property_zip = '20180' or property_zip = '20184' or property_zip = '20185' or property_zip = '20189' or property_zip = '20190' or property_zip = '20190' or property_zip = '20191' or property_zip = '20191' or property_zip = '20837' or property_zip = '20838' or property_zip = '20839' or property_zip = '20841' or property_zip = '20842' or property_zip = '20842' or property_zip = '20850' or property_zip = '20854' or property_zip = '20854' or property_zip = '20859' or property_zip = '20859' or property_zip = '20871' or property_zip = '20871' or property_zip = '20874' or property_zip = '20874' or property_zip = '20875' or property_zip = '20876' or property_zip = '20878' or property_zip = '20878' or property_zip = '20878' or property_zip = '20878' or property_zip = '20878' or property_zip = '20884' or property_zip = '20885' or property_zip = '20898' or property_zip = '20898' or property_zip = '20899' or property_zip = '20899' or property_zip = '21703' or property_zip = '21704' or property_zip = '21704' or property_zip = '21710' or property_zip = '21710' or property_zip = '21714' or property_zip = '21714' or property_zip = '21715' or property_zip = '21716' or property_zip = '21716' or property_zip = '21717' or property_zip = '21718' or property_zip = '21758' or property_zip = '21758' or property_zip = '21769' or property_zip = '21777' or property_zip = '21777' or property_zip = '21779' or property_zip = '21779' or property_zip = '21790' or property_zip = '21755' or property_zip = '22030' or property_zip = '22033' or property_zip = '22035' or property_zip = '22035' or property_zip = '22036' or property_zip = '22036' or property_zip = '22038' or property_zip = '22066' or property_zip = '22067' or property_zip = '22067' or property_zip = '22124' or property_zip = '22124' or property_zip = '22180' or property_zip = '22181' or property_zip = '22182' or property_zip = '22183' or property_zip = '22185' or property_zip = '22185' or property_zip = '22095' or property_zip = '22095' or property_zip = '22095' or property_zip = '22096' or property_zip = '22096' or property_zip = '22096' or property_zip = '22102' or property_zip = '22102' or property_zip = '22102' or property_zip = '22102' or property_zip = '22185' or property_zip = '22185' or property_zip = '22611' or property_zip = '22611' or property_zip = '22620' or property_zip = '22643' or property_zip = '22646' or property_zip = '25410' or property_zip = '25414' or property_zip = '25423' or property_zip = '25425' or property_zip = '25429' or property_zip = '25429' or property_zip = '25430' or property_zip = '25430' or property_zip = '25432' or property_zip = '25438' or property_zip = '25441' or property_zip = '25442' or property_zip = '25442' or property_zip = '25446' or property_zip = '20101' or property_zip = '20102' or property_zip = '20103' or property_zip = '20104' or property_zip = '20105' or property_zip = '20107' or property_zip = '20109' or property_zip = '20110' or property_zip = '20111' or property_zip = '20113' or property_zip = '20115' or property_zip = '20116' or property_zip = '20117' or property_zip = '20118' or property_zip = '20120' or property_zip = '20121' or property_zip = '20124' or property_zip = '20129' or property_zip = '20130' or property_zip = '20131' or property_zip = '20132' or property_zip = '20134' or property_zip = '20135' or property_zip = '20136' or property_zip = '20137' or property_zip = '20140' or property_zip = '20141' or property_zip = '20142' or property_zip = '20143' or property_zip = '20144' or property_zip = '20146' or property_zip = '20147' or property_zip = '20148' or property_zip = '20149' or property_zip = '20151' or property_zip = '20152' or property_zip = '20155' or property_zip = '20158' or property_zip = '20159' or property_zip = '20160' or property_zip = '20163' or property_zip = '20164' or property_zip = '20165' or property_zip = '20166' or property_zip = '20167' or property_zip = '20169' or property_zip = '20170' or property_zip = '20171' or property_zip = '20175' or property_zip = '20176' or property_zip = '20177' or property_zip = '20178' or property_zip = '20180' or property_zip = '20184' or property_zip = '20185' or property_zip = '20187' or property_zip = '20188' or property_zip = '20190' or property_zip = '20191' or property_zip = '20194' or property_zip = '20197' or property_zip = '20198' or property_zip = '20199' or property_zip = '20813' or property_zip = '20824' or property_zip = '20825' or property_zip = '20827' or property_zip = '20837' or property_zip = '20838' or property_zip = '20839' or property_zip = '20841' or property_zip = '20842' or property_zip = '20847' or property_zip = '20848' or property_zip = '20849' or property_zip = '20854' or property_zip = '20857' or property_zip = '20859' or property_zip = '20871' or property_zip = '20874' or property_zip = '20875' or property_zip = '20876' or property_zip = '20877' or property_zip = '20878' or property_zip = '20884' or property_zip = '20885' or property_zip = '20886' or property_zip = '20889' or property_zip = '20891' or property_zip = '20894' or property_zip = '20897' or property_zip = '20898' or property_zip = '20899' or property_zip = '20907' or property_zip = '20908' or property_zip = '20911' or property_zip = '20914' or property_zip = '20915' or property_zip = '20916' or property_zip = '20918' or property_zip = '20997' or property_zip = '21703' or property_zip = '21704' or property_zip = '21710' or property_zip = '21714' or property_zip = '21715' or property_zip = '21716' or property_zip = '21717' or property_zip = '21718' or property_zip = '21755' or property_zip = '21758' or property_zip = '21777' or property_zip = '21779' or property_zip = '21790' or property_zip = '22030' or property_zip = '22033' or property_zip = '22035' or property_zip = '22038' or property_zip = '22066' or property_zip = '22067' or property_zip = '22093' or property_zip = '22102' or property_zip = '22121' or property_zip = '22124' or property_zip = '22180' or property_zip = '22181' or property_zip = '22182' or property_zip = '22611' or property_zip = '22620' or property_zip = '22642' or property_zip = '22643' or property_zip = '22646' or property_zip = '25410' or property_zip = '25414' or property_zip = '25423' or property_zip = '25425' or property_zip = '25429' or property_zip = '25430' or property_zip = '25432' or property_zip = '25438' or property_zip = '25441' or property_zip = '25442' or property_zip = '25446') and convert(date,auction_start_date) >= '9/27/2021';
select top 45 * from currentforeclosures.tblAll NOLOCK where state = 'VA '
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 11=11 and (zip ='20041' or zip = '20041' or zip = '20115' or zip = '20116' or zip = '20117' or zip = '20118' or zip = '20120' or zip = '20120' or zip = '20121' or zip = '20122' or zip = '20129' or zip = '20129' or zip = '20130' or zip = '20131' or zip = '20132' or zip = '20132' or zip = '20134' or zip = '20134' or zip = '20135' or zip = '20155' or zip = '20156' or zip = '20158' or zip = '20159' or zip = '20160' or zip = '20160' or zip = '20163' or zip = '20163' or zip = '20164' or zip = '20165' or zip = '20165' or zip = '20166' or zip = '20166' or zip = '20167' or zip = '20168' or zip = '20169' or zip = '20170' or zip = '20171' or zip = '20171' or zip = '20172' or zip = '20175' or zip = '20176' or zip = '20176' or zip = '20192' or zip = '20192' or zip = '20192' or zip = '20192' or zip = '20194' or zip = '20194' or zip = '20195' or zip = '20195' or zip = '20196' or zip = '20196' or zip = '20196' or zip = '20196' or zip = '20197' or zip = '20198' or zip = '20101' or zip = '20101' or zip = '20102' or zip = '20102' or zip = '20102' or zip = '20103' or zip = '20103' or zip = '20104' or zip = '20104' or zip = '20105' or zip = '20105' or zip = '20107' or zip = '20108' or zip = '20109' or zip = '20109' or zip = '20109' or zip = '20110' or zip = '20135' or zip = '20136' or zip = '20137' or zip = '20140' or zip = '20141' or zip = '20142' or zip = '20143' or zip = '20144' or zip = '20146' or zip = '20147' or zip = '20148' or zip = '20148' or zip = '20148' or zip = '20148' or zip = '20149' or zip = '20149' or zip = '20151' or zip = '20151' or zip = '20152' or zip = '20152' or zip = '20152' or zip = '20176' or zip = '20177' or zip = '20178' or zip = '20180' or zip = '20184' or zip = '20185' or zip = '20189' or zip = '20190' or zip = '20190' or zip = '20191' or zip = '20191' or zip = '20837' or zip = '20838' or zip = '20839' or zip = '20841' or zip = '20842' or zip = '20842' or zip = '20850' or zip = '20854' or zip = '20854' or zip = '20859' or zip = '20859' or zip = '20871' or zip = '20871' or zip = '20874' or zip = '20874' or zip = '20875' or zip = '20876' or zip = '20878' or zip = '20878' or zip = '20878' or zip = '20878' or zip = '20878' or zip = '20884' or zip = '20885' or zip = '20898' or zip = '20898' or zip = '20899' or zip = '20899' or zip = '21703' or zip = '21704' or zip = '21704' or zip = '21710' or zip = '21710' or zip = '21714' or zip = '21714' or zip = '21715' or zip = '21716' or zip = '21716' or zip = '21717' or zip = '21718' or zip = '21758' or zip = '21758' or zip = '21769' or zip = '21777' or zip = '21777' or zip = '21779' or zip = '21779' or zip = '21790' or zip = '21755' or zip = '22030' or zip = '22033' or zip = '22035' or zip = '22035' or zip = '22036' or zip = '22036' or zip = '22038' or zip = '22066' or zip = '22067' or zip = '22067' or zip = '22124' or zip = '22124' or zip = '22180' or zip = '22181' or zip = '22182' or zip = '22183' or zip = '22185' or zip = '22185' or zip = '22095' or zip = '22095' or zip = '22095' or zip = '22096' or zip = '22096' or zip = '22096' or zip = '22102' or zip = '22102' or zip = '22102' or zip = '22102' or zip = '22185' or zip = '22185' or zip = '22611' or zip = '22611' or zip = '22620' or zip = '22643' or zip = '22646' or zip = '25410' or zip = '25414' or zip = '25423' or zip = '25425' or zip = '25429' or zip = '25429' or zip = '25430' or zip = '25430' or zip = '25432' or zip = '25438' or zip = '25441' or zip = '25442' or zip = '25442' or zip = '25446' or zip = '20101' or zip = '20102' or zip = '20103' or zip = '20104' or zip = '20105' or zip = '20107' or zip = '20109' or zip = '20110' or zip = '20111' or zip = '20113' or zip = '20115' or zip = '20116' or zip = '20117' or zip = '20118' or zip = '20120' or zip = '20121' or zip = '20124' or zip = '20129' or zip = '20130' or zip = '20131' or zip = '20132' or zip = '20134' or zip = '20135' or zip = '20136' or zip = '20137' or zip = '20140' or zip = '20141' or zip = '20142' or zip = '20143' or zip = '20144' or zip = '20146' or zip = '20147' or zip = '20148' or zip = '20149' or zip = '20151' or zip = '20152' or zip = '20155' or zip = '20158' or zip = '20159' or zip = '20160' or zip = '20163' or zip = '20164' or zip = '20165' or zip = '20166' or zip = '20167' or zip = '20169' or zip = '20170' or zip = '20171' or zip = '20175' or zip = '20176' or zip = '20177' or zip = '20178' or zip = '20180' or zip = '20184' or zip = '20185' or zip = '20187' or zip = '20188' or zip = '20190' or zip = '20191' or zip = '20194' or zip = '20197' or zip = '20198' or zip = '20199' or zip = '20813' or zip = '20824' or zip = '20825' or zip = '20827' or zip = '20837' or zip = '20838' or zip = '20839' or zip = '20841' or zip = '20842' or zip = '20847' or zip = '20848' or zip = '20849' or zip = '20854' or zip = '20857' or zip = '20859' or zip = '20871' or zip = '20874' or zip = '20875' or zip = '20876' or zip = '20877' or zip = '20878' or zip = '20884' or zip = '20885' or zip = '20886' or zip = '20889' or zip = '20891' or zip = '20894' or zip = '20897' or zip = '20898' or zip = '20899' or zip = '20907' or zip = '20908' or zip = '20911' or zip = '20914' or zip = '20915' or zip = '20916' or zip = '20918' or zip = '20997' or zip = '21703' or zip = '21704' or zip = '21710' or zip = '21714' or zip = '21715' or zip = '21716' or zip = '21717' or zip = '21718' or zip = '21755' or zip = '21758' or zip = '21777' or zip = '21779' or zip = '21790' or zip = '22030' or zip = '22033' or zip = '22035' or zip = '22038' or zip = '22066' or zip = '22067' or zip = '22093' or zip = '22102' or zip = '22121' or zip = '22124' or zip = '22180' or zip = '22181' or zip = '22182' or zip = '22611' or zip = '22620' or zip = '22642' or zip = '22643' or zip = '22646' or zip = '25410' or zip = '25414' or zip = '25423' or zip = '25425' or zip = '25429' or zip = '25430' or zip = '25432' or zip = '25438' or zip = '25441' or zip = '25442' or zip = '25446')
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 = 'VA' and city = 'ASHBURN' and state = 'VA '
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();