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


292+ High Potential Investor Deals Near tampa [Refine]


********NOTICE: Displaying 99 of over 292 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 ='33503' or zipCode = '33508' or zipCode = '33509' or zipCode = '33510' or zipCode = '33511' or zipCode = '33527' or zipCode = '33534' or zipCode = '33543' or zipCode = '33543' or zipCode = '33544' or zipCode = '33544' or zipCode = '33548' or zipCode = '33549' or zipCode = '33550' or zipCode = '33556' or zipCode = '33558' or zipCode = '33559' or zipCode = '33568' or zipCode = '33569' or zipCode = '33570' or zipCode = '33570' or zipCode = '33571' or zipCode = '33571' or zipCode = '33571' or zipCode = '33572' or zipCode = '33572' or zipCode = '33573' or zipCode = '33573' or zipCode = '33573' or zipCode = '33575' or zipCode = '33575' or zipCode = '33575' or zipCode = '33578' or zipCode = '33579' or zipCode = '33583' or zipCode = '33584' or zipCode = '33586' or zipCode = '33587' or zipCode = '33592' or zipCode = '33594' or zipCode = '33595' or zipCode = '33596' or zipCode = '33601' or zipCode = '33602' or zipCode = '33603' or zipCode = '33604' or zipCode = '33605' or zipCode = '33605' or zipCode = '33606' or zipCode = '33606' or zipCode = '33606' or zipCode = '33607' or zipCode = '33608' or zipCode = '33608' or zipCode = '33609' or zipCode = '33610' or zipCode = '33611' or zipCode = '33612' or zipCode = '33613' or zipCode = '33614' or zipCode = '33615' or zipCode = '33615' or zipCode = '33615' or zipCode = '33616' or zipCode = '33617' or zipCode = '33630' or zipCode = '33631' or zipCode = '33633' or zipCode = '33633' or zipCode = '33633' or zipCode = '33634' or zipCode = '33634' or zipCode = '33635' or zipCode = '33637' or zipCode = '33637' or zipCode = '33637' or zipCode = '33646' or zipCode = '33647' or zipCode = '33647' or zipCode = '33650' or zipCode = '33650' or zipCode = '33655' or zipCode = '33655' or zipCode = '33660' or zipCode = '33660' or zipCode = '33661' or zipCode = '33661' or zipCode = '33662' or zipCode = '33662' or zipCode = '33617' or zipCode = '33617' or zipCode = '33618' or zipCode = '33618' or zipCode = '33619' or zipCode = '33619' or zipCode = '33619' or zipCode = '33620' or zipCode = '33620' or zipCode = '33620' or zipCode = '33620' or zipCode = '33621' or zipCode = '33622' or zipCode = '33623' or zipCode = '33624' or zipCode = '33624' or zipCode = '33625' or zipCode = '33625' or zipCode = '33626' or zipCode = '33626' or zipCode = '33626' or zipCode = '33629' or zipCode = '33629' or zipCode = '33663' or zipCode = '33664' or zipCode = '33664' or zipCode = '33664' or zipCode = '33664' or zipCode = '33672' or zipCode = '33673' or zipCode = '33674' or zipCode = '33675' or zipCode = '33675' or zipCode = '33677' or zipCode = '33679' or zipCode = '33680' or zipCode = '33681' or zipCode = '33682' or zipCode = '33684' or zipCode = '33685' or zipCode = '33686' or zipCode = '33687' or zipCode = '33687' or zipCode = '33687' or zipCode = '33688' or zipCode = '33688' or zipCode = '33689' or zipCode = '33706' or zipCode = '33706' or zipCode = '33707' or zipCode = '33707' or zipCode = '33707' or zipCode = '33707' or zipCode = '33707' or zipCode = '33707' or zipCode = '33707' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33709' or zipCode = '33709' or zipCode = '33709' or zipCode = '33710' or zipCode = '33710' or zipCode = '33711' or zipCode = '33711' or zipCode = '33711' or zipCode = '33712' or zipCode = '33712' or zipCode = '33713' or zipCode = '33713' or zipCode = '33714' or zipCode = '33714' or zipCode = '33716' or zipCode = '33716' or zipCode = '33729' or zipCode = '33729' or zipCode = '33729' or zipCode = '33730' or zipCode = '33730' or zipCode = '33731' or zipCode = '33731' or zipCode = '33732' or zipCode = '33732' or zipCode = '33733' or zipCode = '33733' or zipCode = '33733' or zipCode = '33734' or zipCode = '33734' or zipCode = '33736' or zipCode = '33736' or zipCode = '33736' or zipCode = '33737' or zipCode = '33737' or zipCode = '33738' or zipCode = '33738' or zipCode = '33738' or zipCode = '33740' or zipCode = '33740' or zipCode = '33740' or zipCode = '33764' or zipCode = '33765' or zipCode = '33766' or zipCode = '33767' or zipCode = '33767' or zipCode = '33769' or zipCode = '33770' or zipCode = '33770' or zipCode = '33770' or zipCode = '33771' or zipCode = '33772' or zipCode = '33772' or zipCode = '33773' or zipCode = '33774' or zipCode = '33774' or zipCode = '33775' or zipCode = '33775' or zipCode = '33776' or zipCode = '33776' or zipCode = '33777' or zipCode = '33777' or zipCode = '33778' or zipCode = '33778' or zipCode = '33779' or zipCode = '33780' or zipCode = '33781' or zipCode = '33782' or zipCode = '33784' or zipCode = '33784' or zipCode = '33785' or zipCode = '33785' or zipCode = '33785' or zipCode = '33785' or zipCode = '33785' or zipCode = '33785' or zipCode = '33786' or zipCode = '33786' or zipCode = '33786' or zipCode = '33786' or zipCode = '33786' or zipCode = '33786' or zipCode = '33786' or zipCode = '33690' or zipCode = '33690' or zipCode = '33694' or zipCode = '33701' or zipCode = '33701' or zipCode = '33702' or zipCode = '33702' or zipCode = '33703' or zipCode = '33703' or zipCode = '33704' or zipCode = '33704' or zipCode = '33705' or zipCode = '33705' or zipCode = '33706' or zipCode = '33706' or zipCode = '33706' or zipCode = '33706' or zipCode = '33706' or zipCode = '33706' or zipCode = '33706' or zipCode = '33706' or zipCode = '33740' or zipCode = '33741' or zipCode = '33741' or zipCode = '33741' or zipCode = '33741' or zipCode = '33742' or zipCode = '33742' or zipCode = '33743' or zipCode = '33743' or zipCode = '33744' or zipCode = '33747' or zipCode = '33747' or zipCode = '33755' or zipCode = '33756' or zipCode = '33756' or zipCode = '33757' or zipCode = '33758' or zipCode = '33759' or zipCode = '33760' or zipCode = '33761' or zipCode = '33762' or zipCode = '33763' or zipCode = '34637' or zipCode = '34638' or zipCode = '34639' or zipCode = '34639' or zipCode = '34652' or zipCode = '34652' or zipCode = '34652' or zipCode = '34652' or zipCode = '34653' or zipCode = '34653' or zipCode = '34653' or zipCode = '34654' or zipCode = '34654' or zipCode = '34654' or zipCode = '34655' or zipCode = '34684' or zipCode = '34685' or zipCode = '34688' or zipCode = '34688' or zipCode = '34688' or zipCode = '34689' or zipCode = '34689' or zipCode = '34689' or zipCode = '34690' or zipCode = '34690' or zipCode = '34690' or zipCode = '34690' or zipCode = '34691' or zipCode = '34691' or zipCode = '34691' or zipCode = '34691' or zipCode = '34692' or zipCode = '34692' or zipCode = '34695' or zipCode = '34697' or zipCode = '34698' or zipCode = '34655' or zipCode = '34655' or zipCode = '34655' or zipCode = '34655' or zipCode = '34656' or zipCode = '34656' or zipCode = '34656' or zipCode = '34660' or zipCode = '34668' or zipCode = '34673' or zipCode = '34677' or zipCode = '34680' or zipCode = '34681' or zipCode = '34682' or zipCode = '34683' or zipCode = '33501' or zipCode = '33503' or zipCode = '33509' or zipCode = '33510' or zipCode = '33511' or zipCode = '33527' or zipCode = '33534' or zipCode = '33537' or zipCode = '33543' or zipCode = '33544' or zipCode = '33548' or zipCode = '33549' or zipCode = '33550' or zipCode = '33556' or zipCode = '33558' or zipCode = '33559' or zipCode = '33568' or zipCode = '33569' or zipCode = '33570' or zipCode = '33571' or zipCode = '33572' or zipCode = '33573' or zipCode = '33583' or zipCode = '33584' or zipCode = '33586' or zipCode = '33587' or zipCode = '33592' or zipCode = '33593' or zipCode = '33594' or zipCode = '33595' or zipCode = '33601' or zipCode = '33602' or zipCode = '33603' or zipCode = '33604' or zipCode = '33605' or zipCode = '33606' or zipCode = '33607' or zipCode = '33608' or zipCode = '33609' or zipCode = '33610' or zipCode = '33611' or zipCode = '33612' or zipCode = '33613' or zipCode = '33614' or zipCode = '33615' or zipCode = '33616' or zipCode = '33617' or zipCode = '33618' or zipCode = '33619' or zipCode = '33620' or zipCode = '33621' or zipCode = '33622' or zipCode = '33623' or zipCode = '33624' or zipCode = '33625' or zipCode = '33626' or zipCode = '33629' or zipCode = '33630' or zipCode = '33631' or zipCode = '33633' or zipCode = '33634' or zipCode = '33635' or zipCode = '33637' or zipCode = '33643' or zipCode = '33647' or zipCode = '33650' or zipCode = '33651' or zipCode = '33655' or zipCode = '33659' or zipCode = '33660' or zipCode = '33661' or zipCode = '33662' or zipCode = '33663' or zipCode = '33664' or zipCode = '33672' or zipCode = '33673' or zipCode = '33674' or zipCode = '33675' or zipCode = '33677' or zipCode = '33679' or zipCode = '33680' or zipCode = '33681' or zipCode = '33682' or zipCode = '33684' or zipCode = '33685' or zipCode = '33686' or zipCode = '33687' or zipCode = '33688' or zipCode = '33689' or zipCode = '33690' or zipCode = '33694' or zipCode = '33697' or zipCode = '33701' or zipCode = '33702' or zipCode = '33703' or zipCode = '33704' or zipCode = '33705' or zipCode = '33706' or zipCode = '33707' or zipCode = '33708' or zipCode = '33709' or zipCode = '33710' or zipCode = '33711' or zipCode = '33712' or zipCode = '33713' or zipCode = '33714' or zipCode = '33715' or zipCode = '33716' or zipCode = '33728' or zipCode = '33729' or zipCode = '33730' or zipCode = '33731' or zipCode = '33732' or zipCode = '33733' or zipCode = '33734' or zipCode = '33736' or zipCode = '33737' or zipCode = '33738' or zipCode = '33740' or zipCode = '33741' or zipCode = '33742' or zipCode = '33743' or zipCode = '33744' or zipCode = '33747' or zipCode = '33755' or zipCode = '33756' or zipCode = '33757' or zipCode = '33758' or zipCode = '33759' or zipCode = '33760' or zipCode = '33761' or zipCode = '33762' or zipCode = '33763' or zipCode = '33764' or zipCode = '33765' or zipCode = '33766' or zipCode = '33767' or zipCode = '33769' or zipCode = '33770' or zipCode = '33771' or zipCode = '33772' or zipCode = '33773' or zipCode = '33774' or zipCode = '33775' or zipCode = '33776' or zipCode = '33777' or zipCode = '33778' or zipCode = '33779' or zipCode = '33780' or zipCode = '33781' or zipCode = '33782' or zipCode = '33784' or zipCode = '33785' or zipCode = '33786' or zipCode = '34639' or zipCode = '34652' or zipCode = '34653' or zipCode = '34654' or zipCode = '34655' or zipCode = '34656' or zipCode = '34660' or zipCode = '34668' or zipCode = '34669' or zipCode = '34673' or zipCode = '34674' or zipCode = '34677' or zipCode = '34678' or zipCode = '34680' or zipCode = '34681' or zipCode = '34682' or zipCode = '34683' or zipCode = '34684' or zipCode = '34685' or zipCode = '34688' or zipCode = '34689' or zipCode = '34690' or zipCode = '34691' or zipCode = '34695' or zipCode = '34697' or zipCode = '34698' or zipCode = '34869')
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 ='33503' or zipCode = '33508' or zipCode = '33509' or zipCode = '33510' or zipCode = '33511' or zipCode = '33527' or zipCode = '33534' or zipCode = '33543' or zipCode = '33543' or zipCode = '33544' or zipCode = '33544' or zipCode = '33548' or zipCode = '33549' or zipCode = '33550' or zipCode = '33556' or zipCode = '33558' or zipCode = '33559' or zipCode = '33568' or zipCode = '33569' or zipCode = '33570' or zipCode = '33570' or zipCode = '33571' or zipCode = '33571' or zipCode = '33571' or zipCode = '33572' or zipCode = '33572' or zipCode = '33573' or zipCode = '33573' or zipCode = '33573' or zipCode = '33575' or zipCode = '33575' or zipCode = '33575' or zipCode = '33578' or zipCode = '33579' or zipCode = '33583' or zipCode = '33584' or zipCode = '33586' or zipCode = '33587' or zipCode = '33592' or zipCode = '33594' or zipCode = '33595' or zipCode = '33596' or zipCode = '33601' or zipCode = '33602' or zipCode = '33603' or zipCode = '33604' or zipCode = '33605' or zipCode = '33605' or zipCode = '33606' or zipCode = '33606' or zipCode = '33606' or zipCode = '33607' or zipCode = '33608' or zipCode = '33608' or zipCode = '33609' or zipCode = '33610' or zipCode = '33611' or zipCode = '33612' or zipCode = '33613' or zipCode = '33614' or zipCode = '33615' or zipCode = '33615' or zipCode = '33615' or zipCode = '33616' or zipCode = '33617' or zipCode = '33630' or zipCode = '33631' or zipCode = '33633' or zipCode = '33633' or zipCode = '33633' or zipCode = '33634' or zipCode = '33634' or zipCode = '33635' or zipCode = '33637' or zipCode = '33637' or zipCode = '33637' or zipCode = '33646' or zipCode = '33647' or zipCode = '33647' or zipCode = '33650' or zipCode = '33650' or zipCode = '33655' or zipCode = '33655' or zipCode = '33660' or zipCode = '33660' or zipCode = '33661' or zipCode = '33661' or zipCode = '33662' or zipCode = '33662' or zipCode = '33617' or zipCode = '33617' or zipCode = '33618' or zipCode = '33618' or zipCode = '33619' or zipCode = '33619' or zipCode = '33619' or zipCode = '33620' or zipCode = '33620' or zipCode = '33620' or zipCode = '33620' or zipCode = '33621' or zipCode = '33622' or zipCode = '33623' or zipCode = '33624' or zipCode = '33624' or zipCode = '33625' or zipCode = '33625' or zipCode = '33626' or zipCode = '33626' or zipCode = '33626' or zipCode = '33629' or zipCode = '33629' or zipCode = '33663' or zipCode = '33664' or zipCode = '33664' or zipCode = '33664' or zipCode = '33664' or zipCode = '33672' or zipCode = '33673' or zipCode = '33674' or zipCode = '33675' or zipCode = '33675' or zipCode = '33677' or zipCode = '33679' or zipCode = '33680' or zipCode = '33681' or zipCode = '33682' or zipCode = '33684' or zipCode = '33685' or zipCode = '33686' or zipCode = '33687' or zipCode = '33687' or zipCode = '33687' or zipCode = '33688' or zipCode = '33688' or zipCode = '33689' or zipCode = '33706' or zipCode = '33706' or zipCode = '33707' or zipCode = '33707' or zipCode = '33707' or zipCode = '33707' or zipCode = '33707' or zipCode = '33707' or zipCode = '33707' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33709' or zipCode = '33709' or zipCode = '33709' or zipCode = '33710' or zipCode = '33710' or zipCode = '33711' or zipCode = '33711' or zipCode = '33711' or zipCode = '33712' or zipCode = '33712' or zipCode = '33713' or zipCode = '33713' or zipCode = '33714' or zipCode = '33714' or zipCode = '33716' or zipCode = '33716' or zipCode = '33729' or zipCode = '33729' or zipCode = '33729' or zipCode = '33730' or zipCode = '33730' or zipCode = '33731' or zipCode = '33731' or zipCode = '33732' or zipCode = '33732' or zipCode = '33733' or zipCode = '33733' or zipCode = '33733' or zipCode = '33734' or zipCode = '33734' or zipCode = '33736' or zipCode = '33736' or zipCode = '33736' or zipCode = '33737' or zipCode = '33737' or zipCode = '33738' or zipCode = '33738' or zipCode = '33738' or zipCode = '33740' or zipCode = '33740' or zipCode = '33740' or zipCode = '33764' or zipCode = '33765' or zipCode = '33766' or zipCode = '33767' or zipCode = '33767' or zipCode = '33769' or zipCode = '33770' or zipCode = '33770' or zipCode = '33770' or zipCode = '33771' or zipCode = '33772' or zipCode = '33772' or zipCode = '33773' or zipCode = '33774' or zipCode = '33774' or zipCode = '33775' or zipCode = '33775' or zipCode = '33776' or zipCode = '33776' or zipCode = '33777' or zipCode = '33777' or zipCode = '33778' or zipCode = '33778' or zipCode = '33779' or zipCode = '33780' or zipCode = '33781' or zipCode = '33782' or zipCode = '33784' or zipCode = '33784' or zipCode = '33785' or zipCode = '33785' or zipCode = '33785' or zipCode = '33785' or zipCode = '33785' or zipCode = '33785' or zipCode = '33786' or zipCode = '33786' or zipCode = '33786' or zipCode = '33786' or zipCode = '33786' or zipCode = '33786' or zipCode = '33786' or zipCode = '33690' or zipCode = '33690' or zipCode = '33694' or zipCode = '33701' or zipCode = '33701' or zipCode = '33702' or zipCode = '33702' or zipCode = '33703' or zipCode = '33703' or zipCode = '33704' or zipCode = '33704' or zipCode = '33705' or zipCode = '33705' or zipCode = '33706' or zipCode = '33706' or zipCode = '33706' or zipCode = '33706' or zipCode = '33706' or zipCode = '33706' or zipCode = '33706' or zipCode = '33706' or zipCode = '33740' or zipCode = '33741' or zipCode = '33741' or zipCode = '33741' or zipCode = '33741' or zipCode = '33742' or zipCode = '33742' or zipCode = '33743' or zipCode = '33743' or zipCode = '33744' or zipCode = '33747' or zipCode = '33747' or zipCode = '33755' or zipCode = '33756' or zipCode = '33756' or zipCode = '33757' or zipCode = '33758' or zipCode = '33759' or zipCode = '33760' or zipCode = '33761' or zipCode = '33762' or zipCode = '33763' or zipCode = '34637' or zipCode = '34638' or zipCode = '34639' or zipCode = '34639' or zipCode = '34652' or zipCode = '34652' or zipCode = '34652' or zipCode = '34652' or zipCode = '34653' or zipCode = '34653' or zipCode = '34653' or zipCode = '34654' or zipCode = '34654' or zipCode = '34654' or zipCode = '34655' or zipCode = '34684' or zipCode = '34685' or zipCode = '34688' or zipCode = '34688' or zipCode = '34688' or zipCode = '34689' or zipCode = '34689' or zipCode = '34689' or zipCode = '34690' or zipCode = '34690' or zipCode = '34690' or zipCode = '34690' or zipCode = '34691' or zipCode = '34691' or zipCode = '34691' or zipCode = '34691' or zipCode = '34692' or zipCode = '34692' or zipCode = '34695' or zipCode = '34697' or zipCode = '34698' or zipCode = '34655' or zipCode = '34655' or zipCode = '34655' or zipCode = '34655' or zipCode = '34656' or zipCode = '34656' or zipCode = '34656' or zipCode = '34660' or zipCode = '34668' or zipCode = '34673' or zipCode = '34677' or zipCode = '34680' or zipCode = '34681' or zipCode = '34682' or zipCode = '34683' or zipCode = '33501' or zipCode = '33503' or zipCode = '33509' or zipCode = '33510' or zipCode = '33511' or zipCode = '33527' or zipCode = '33534' or zipCode = '33537' or zipCode = '33543' or zipCode = '33544' or zipCode = '33548' or zipCode = '33549' or zipCode = '33550' or zipCode = '33556' or zipCode = '33558' or zipCode = '33559' or zipCode = '33568' or zipCode = '33569' or zipCode = '33570' or zipCode = '33571' or zipCode = '33572' or zipCode = '33573' or zipCode = '33583' or zipCode = '33584' or zipCode = '33586' or zipCode = '33587' or zipCode = '33592' or zipCode = '33593' or zipCode = '33594' or zipCode = '33595' or zipCode = '33601' or zipCode = '33602' or zipCode = '33603' or zipCode = '33604' or zipCode = '33605' or zipCode = '33606' or zipCode = '33607' or zipCode = '33608' or zipCode = '33609' or zipCode = '33610' or zipCode = '33611' or zipCode = '33612' or zipCode = '33613' or zipCode = '33614' or zipCode = '33615' or zipCode = '33616' or zipCode = '33617' or zipCode = '33618' or zipCode = '33619' or zipCode = '33620' or zipCode = '33621' or zipCode = '33622' or zipCode = '33623' or zipCode = '33624' or zipCode = '33625' or zipCode = '33626' or zipCode = '33629' or zipCode = '33630' or zipCode = '33631' or zipCode = '33633' or zipCode = '33634' or zipCode = '33635' or zipCode = '33637' or zipCode = '33643' or zipCode = '33647' or zipCode = '33650' or zipCode = '33651' or zipCode = '33655' or zipCode = '33659' or zipCode = '33660' or zipCode = '33661' or zipCode = '33662' or zipCode = '33663' or zipCode = '33664' or zipCode = '33672' or zipCode = '33673' or zipCode = '33674' or zipCode = '33675' or zipCode = '33677' or zipCode = '33679' or zipCode = '33680' or zipCode = '33681' or zipCode = '33682' or zipCode = '33684' or zipCode = '33685' or zipCode = '33686' or zipCode = '33687' or zipCode = '33688' or zipCode = '33689' or zipCode = '33690' or zipCode = '33694' or zipCode = '33697' or zipCode = '33701' or zipCode = '33702' or zipCode = '33703' or zipCode = '33704' or zipCode = '33705' or zipCode = '33706' or zipCode = '33707' or zipCode = '33708' or zipCode = '33709' or zipCode = '33710' or zipCode = '33711' or zipCode = '33712' or zipCode = '33713' or zipCode = '33714' or zipCode = '33715' or zipCode = '33716' or zipCode = '33728' or zipCode = '33729' or zipCode = '33730' or zipCode = '33731' or zipCode = '33732' or zipCode = '33733' or zipCode = '33734' or zipCode = '33736' or zipCode = '33737' or zipCode = '33738' or zipCode = '33740' or zipCode = '33741' or zipCode = '33742' or zipCode = '33743' or zipCode = '33744' or zipCode = '33747' or zipCode = '33755' or zipCode = '33756' or zipCode = '33757' or zipCode = '33758' or zipCode = '33759' or zipCode = '33760' or zipCode = '33761' or zipCode = '33762' or zipCode = '33763' or zipCode = '33764' or zipCode = '33765' or zipCode = '33766' or zipCode = '33767' or zipCode = '33769' or zipCode = '33770' or zipCode = '33771' or zipCode = '33772' or zipCode = '33773' or zipCode = '33774' or zipCode = '33775' or zipCode = '33776' or zipCode = '33777' or zipCode = '33778' or zipCode = '33779' or zipCode = '33780' or zipCode = '33781' or zipCode = '33782' or zipCode = '33784' or zipCode = '33785' or zipCode = '33786' or zipCode = '34639' or zipCode = '34652' or zipCode = '34653' or zipCode = '34654' or zipCode = '34655' or zipCode = '34656' or zipCode = '34660' or zipCode = '34668' or zipCode = '34669' or zipCode = '34673' or zipCode = '34674' or zipCode = '34677' or zipCode = '34678' or zipCode = '34680' or zipCode = '34681' or zipCode = '34682' or zipCode = '34683' or zipCode = '34684' or zipCode = '34685' or zipCode = '34688' or zipCode = '34689' or zipCode = '34690' or zipCode = '34691' or zipCode = '34695' or zipCode = '34697' or zipCode = '34698' or zipCode = '34869') 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 ='33503' or zipCode = '33508' or zipCode = '33509' or zipCode = '33510' or zipCode = '33511' or zipCode = '33527' or zipCode = '33534' or zipCode = '33543' or zipCode = '33543' or zipCode = '33544' or zipCode = '33544' or zipCode = '33548' or zipCode = '33549' or zipCode = '33550' or zipCode = '33556' or zipCode = '33558' or zipCode = '33559' or zipCode = '33568' or zipCode = '33569' or zipCode = '33570' or zipCode = '33570' or zipCode = '33571' or zipCode = '33571' or zipCode = '33571' or zipCode = '33572' or zipCode = '33572' or zipCode = '33573' or zipCode = '33573' or zipCode = '33573' or zipCode = '33575' or zipCode = '33575' or zipCode = '33575' or zipCode = '33578' or zipCode = '33579' or zipCode = '33583' or zipCode = '33584' or zipCode = '33586' or zipCode = '33587' or zipCode = '33592' or zipCode = '33594' or zipCode = '33595' or zipCode = '33596' or zipCode = '33601' or zipCode = '33602' or zipCode = '33603' or zipCode = '33604' or zipCode = '33605' or zipCode = '33605' or zipCode = '33606' or zipCode = '33606' or zipCode = '33606' or zipCode = '33607' or zipCode = '33608' or zipCode = '33608' or zipCode = '33609' or zipCode = '33610' or zipCode = '33611' or zipCode = '33612' or zipCode = '33613' or zipCode = '33614' or zipCode = '33615' or zipCode = '33615' or zipCode = '33615' or zipCode = '33616' or zipCode = '33617' or zipCode = '33630' or zipCode = '33631' or zipCode = '33633' or zipCode = '33633' or zipCode = '33633' or zipCode = '33634' or zipCode = '33634' or zipCode = '33635' or zipCode = '33637' or zipCode = '33637' or zipCode = '33637' or zipCode = '33646' or zipCode = '33647' or zipCode = '33647' or zipCode = '33650' or zipCode = '33650' or zipCode = '33655' or zipCode = '33655' or zipCode = '33660' or zipCode = '33660' or zipCode = '33661' or zipCode = '33661' or zipCode = '33662' or zipCode = '33662' or zipCode = '33617' or zipCode = '33617' or zipCode = '33618' or zipCode = '33618' or zipCode = '33619' or zipCode = '33619' or zipCode = '33619' or zipCode = '33620' or zipCode = '33620' or zipCode = '33620' or zipCode = '33620' or zipCode = '33621' or zipCode = '33622' or zipCode = '33623' or zipCode = '33624' or zipCode = '33624' or zipCode = '33625' or zipCode = '33625' or zipCode = '33626' or zipCode = '33626' or zipCode = '33626' or zipCode = '33629' or zipCode = '33629' or zipCode = '33663' or zipCode = '33664' or zipCode = '33664' or zipCode = '33664' or zipCode = '33664' or zipCode = '33672' or zipCode = '33673' or zipCode = '33674' or zipCode = '33675' or zipCode = '33675' or zipCode = '33677' or zipCode = '33679' or zipCode = '33680' or zipCode = '33681' or zipCode = '33682' or zipCode = '33684' or zipCode = '33685' or zipCode = '33686' or zipCode = '33687' or zipCode = '33687' or zipCode = '33687' or zipCode = '33688' or zipCode = '33688' or zipCode = '33689' or zipCode = '33706' or zipCode = '33706' or zipCode = '33707' or zipCode = '33707' or zipCode = '33707' or zipCode = '33707' or zipCode = '33707' or zipCode = '33707' or zipCode = '33707' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33709' or zipCode = '33709' or zipCode = '33709' or zipCode = '33710' or zipCode = '33710' or zipCode = '33711' or zipCode = '33711' or zipCode = '33711' or zipCode = '33712' or zipCode = '33712' or zipCode = '33713' or zipCode = '33713' or zipCode = '33714' or zipCode = '33714' or zipCode = '33716' or zipCode = '33716' or zipCode = '33729' or zipCode = '33729' or zipCode = '33729' or zipCode = '33730' or zipCode = '33730' or zipCode = '33731' or zipCode = '33731' or zipCode = '33732' or zipCode = '33732' or zipCode = '33733' or zipCode = '33733' or zipCode = '33733' or zipCode = '33734' or zipCode = '33734' or zipCode = '33736' or zipCode = '33736' or zipCode = '33736' or zipCode = '33737' or zipCode = '33737' or zipCode = '33738' or zipCode = '33738' or zipCode = '33738' or zipCode = '33740' or zipCode = '33740' or zipCode = '33740' or zipCode = '33764' or zipCode = '33765' or zipCode = '33766' or zipCode = '33767' or zipCode = '33767' or zipCode = '33769' or zipCode = '33770' or zipCode = '33770' or zipCode = '33770' or zipCode = '33771' or zipCode = '33772' or zipCode = '33772' or zipCode = '33773' or zipCode = '33774' or zipCode = '33774' or zipCode = '33775' or zipCode = '33775' or zipCode = '33776' or zipCode = '33776' or zipCode = '33777' or zipCode = '33777' or zipCode = '33778' or zipCode = '33778' or zipCode = '33779' or zipCode = '33780' or zipCode = '33781' or zipCode = '33782' or zipCode = '33784' or zipCode = '33784' or zipCode = '33785' or zipCode = '33785' or zipCode = '33785' or zipCode = '33785' or zipCode = '33785' or zipCode = '33785' or zipCode = '33786' or zipCode = '33786' or zipCode = '33786' or zipCode = '33786' or zipCode = '33786' or zipCode = '33786' or zipCode = '33786' or zipCode = '33690' or zipCode = '33690' or zipCode = '33694' or zipCode = '33701' or zipCode = '33701' or zipCode = '33702' or zipCode = '33702' or zipCode = '33703' or zipCode = '33703' or zipCode = '33704' or zipCode = '33704' or zipCode = '33705' or zipCode = '33705' or zipCode = '33706' or zipCode = '33706' or zipCode = '33706' or zipCode = '33706' or zipCode = '33706' or zipCode = '33706' or zipCode = '33706' or zipCode = '33706' or zipCode = '33740' or zipCode = '33741' or zipCode = '33741' or zipCode = '33741' or zipCode = '33741' or zipCode = '33742' or zipCode = '33742' or zipCode = '33743' or zipCode = '33743' or zipCode = '33744' or zipCode = '33747' or zipCode = '33747' or zipCode = '33755' or zipCode = '33756' or zipCode = '33756' or zipCode = '33757' or zipCode = '33758' or zipCode = '33759' or zipCode = '33760' or zipCode = '33761' or zipCode = '33762' or zipCode = '33763' or zipCode = '34637' or zipCode = '34638' or zipCode = '34639' or zipCode = '34639' or zipCode = '34652' or zipCode = '34652' or zipCode = '34652' or zipCode = '34652' or zipCode = '34653' or zipCode = '34653' or zipCode = '34653' or zipCode = '34654' or zipCode = '34654' or zipCode = '34654' or zipCode = '34655' or zipCode = '34684' or zipCode = '34685' or zipCode = '34688' or zipCode = '34688' or zipCode = '34688' or zipCode = '34689' or zipCode = '34689' or zipCode = '34689' or zipCode = '34690' or zipCode = '34690' or zipCode = '34690' or zipCode = '34690' or zipCode = '34691' or zipCode = '34691' or zipCode = '34691' or zipCode = '34691' or zipCode = '34692' or zipCode = '34692' or zipCode = '34695' or zipCode = '34697' or zipCode = '34698' or zipCode = '34655' or zipCode = '34655' or zipCode = '34655' or zipCode = '34655' or zipCode = '34656' or zipCode = '34656' or zipCode = '34656' or zipCode = '34660' or zipCode = '34668' or zipCode = '34673' or zipCode = '34677' or zipCode = '34680' or zipCode = '34681' or zipCode = '34682' or zipCode = '34683' or zipCode = '33501' or zipCode = '33503' or zipCode = '33509' or zipCode = '33510' or zipCode = '33511' or zipCode = '33527' or zipCode = '33534' or zipCode = '33537' or zipCode = '33543' or zipCode = '33544' or zipCode = '33548' or zipCode = '33549' or zipCode = '33550' or zipCode = '33556' or zipCode = '33558' or zipCode = '33559' or zipCode = '33568' or zipCode = '33569' or zipCode = '33570' or zipCode = '33571' or zipCode = '33572' or zipCode = '33573' or zipCode = '33583' or zipCode = '33584' or zipCode = '33586' or zipCode = '33587' or zipCode = '33592' or zipCode = '33593' or zipCode = '33594' or zipCode = '33595' or zipCode = '33601' or zipCode = '33602' or zipCode = '33603' or zipCode = '33604' or zipCode = '33605' or zipCode = '33606' or zipCode = '33607' or zipCode = '33608' or zipCode = '33609' or zipCode = '33610' or zipCode = '33611' or zipCode = '33612' or zipCode = '33613' or zipCode = '33614' or zipCode = '33615' or zipCode = '33616' or zipCode = '33617' or zipCode = '33618' or zipCode = '33619' or zipCode = '33620' or zipCode = '33621' or zipCode = '33622' or zipCode = '33623' or zipCode = '33624' or zipCode = '33625' or zipCode = '33626' or zipCode = '33629' or zipCode = '33630' or zipCode = '33631' or zipCode = '33633' or zipCode = '33634' or zipCode = '33635' or zipCode = '33637' or zipCode = '33643' or zipCode = '33647' or zipCode = '33650' or zipCode = '33651' or zipCode = '33655' or zipCode = '33659' or zipCode = '33660' or zipCode = '33661' or zipCode = '33662' or zipCode = '33663' or zipCode = '33664' or zipCode = '33672' or zipCode = '33673' or zipCode = '33674' or zipCode = '33675' or zipCode = '33677' or zipCode = '33679' or zipCode = '33680' or zipCode = '33681' or zipCode = '33682' or zipCode = '33684' or zipCode = '33685' or zipCode = '33686' or zipCode = '33687' or zipCode = '33688' or zipCode = '33689' or zipCode = '33690' or zipCode = '33694' or zipCode = '33697' or zipCode = '33701' or zipCode = '33702' or zipCode = '33703' or zipCode = '33704' or zipCode = '33705' or zipCode = '33706' or zipCode = '33707' or zipCode = '33708' or zipCode = '33709' or zipCode = '33710' or zipCode = '33711' or zipCode = '33712' or zipCode = '33713' or zipCode = '33714' or zipCode = '33715' or zipCode = '33716' or zipCode = '33728' or zipCode = '33729' or zipCode = '33730' or zipCode = '33731' or zipCode = '33732' or zipCode = '33733' or zipCode = '33734' or zipCode = '33736' or zipCode = '33737' or zipCode = '33738' or zipCode = '33740' or zipCode = '33741' or zipCode = '33742' or zipCode = '33743' or zipCode = '33744' or zipCode = '33747' or zipCode = '33755' or zipCode = '33756' or zipCode = '33757' or zipCode = '33758' or zipCode = '33759' or zipCode = '33760' or zipCode = '33761' or zipCode = '33762' or zipCode = '33763' or zipCode = '33764' or zipCode = '33765' or zipCode = '33766' or zipCode = '33767' or zipCode = '33769' or zipCode = '33770' or zipCode = '33771' or zipCode = '33772' or zipCode = '33773' or zipCode = '33774' or zipCode = '33775' or zipCode = '33776' or zipCode = '33777' or zipCode = '33778' or zipCode = '33779' or zipCode = '33780' or zipCode = '33781' or zipCode = '33782' or zipCode = '33784' or zipCode = '33785' or zipCode = '33786' or zipCode = '34639' or zipCode = '34652' or zipCode = '34653' or zipCode = '34654' or zipCode = '34655' or zipCode = '34656' or zipCode = '34660' or zipCode = '34668' or zipCode = '34669' or zipCode = '34673' or zipCode = '34674' or zipCode = '34677' or zipCode = '34678' or zipCode = '34680' or zipCode = '34681' or zipCode = '34682' or zipCode = '34683' or zipCode = '34684' or zipCode = '34685' or zipCode = '34688' or zipCode = '34689' or zipCode = '34690' or zipCode = '34691' or zipCode = '34695' or zipCode = '34697' or zipCode = '34698' or zipCode = '34869') 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 ='33503' or zipCode = '33508' or zipCode = '33509' or zipCode = '33510' or zipCode = '33511' or zipCode = '33527' or zipCode = '33534' or zipCode = '33543' or zipCode = '33543' or zipCode = '33544' or zipCode = '33544' or zipCode = '33548' or zipCode = '33549' or zipCode = '33550' or zipCode = '33556' or zipCode = '33558' or zipCode = '33559' or zipCode = '33568' or zipCode = '33569' or zipCode = '33570' or zipCode = '33570' or zipCode = '33571' or zipCode = '33571' or zipCode = '33571' or zipCode = '33572' or zipCode = '33572' or zipCode = '33573' or zipCode = '33573' or zipCode = '33573' or zipCode = '33575' or zipCode = '33575' or zipCode = '33575' or zipCode = '33578' or zipCode = '33579' or zipCode = '33583' or zipCode = '33584' or zipCode = '33586' or zipCode = '33587' or zipCode = '33592' or zipCode = '33594' or zipCode = '33595' or zipCode = '33596' or zipCode = '33601' or zipCode = '33602' or zipCode = '33603' or zipCode = '33604' or zipCode = '33605' or zipCode = '33605' or zipCode = '33606' or zipCode = '33606' or zipCode = '33606' or zipCode = '33607' or zipCode = '33608' or zipCode = '33608' or zipCode = '33609' or zipCode = '33610' or zipCode = '33611' or zipCode = '33612' or zipCode = '33613' or zipCode = '33614' or zipCode = '33615' or zipCode = '33615' or zipCode = '33615' or zipCode = '33616' or zipCode = '33617' or zipCode = '33630' or zipCode = '33631' or zipCode = '33633' or zipCode = '33633' or zipCode = '33633' or zipCode = '33634' or zipCode = '33634' or zipCode = '33635' or zipCode = '33637' or zipCode = '33637' or zipCode = '33637' or zipCode = '33646' or zipCode = '33647' or zipCode = '33647' or zipCode = '33650' or zipCode = '33650' or zipCode = '33655' or zipCode = '33655' or zipCode = '33660' or zipCode = '33660' or zipCode = '33661' or zipCode = '33661' or zipCode = '33662' or zipCode = '33662' or zipCode = '33617' or zipCode = '33617' or zipCode = '33618' or zipCode = '33618' or zipCode = '33619' or zipCode = '33619' or zipCode = '33619' or zipCode = '33620' or zipCode = '33620' or zipCode = '33620' or zipCode = '33620' or zipCode = '33621' or zipCode = '33622' or zipCode = '33623' or zipCode = '33624' or zipCode = '33624' or zipCode = '33625' or zipCode = '33625' or zipCode = '33626' or zipCode = '33626' or zipCode = '33626' or zipCode = '33629' or zipCode = '33629' or zipCode = '33663' or zipCode = '33664' or zipCode = '33664' or zipCode = '33664' or zipCode = '33664' or zipCode = '33672' or zipCode = '33673' or zipCode = '33674' or zipCode = '33675' or zipCode = '33675' or zipCode = '33677' or zipCode = '33679' or zipCode = '33680' or zipCode = '33681' or zipCode = '33682' or zipCode = '33684' or zipCode = '33685' or zipCode = '33686' or zipCode = '33687' or zipCode = '33687' or zipCode = '33687' or zipCode = '33688' or zipCode = '33688' or zipCode = '33689' or zipCode = '33706' or zipCode = '33706' or zipCode = '33707' or zipCode = '33707' or zipCode = '33707' or zipCode = '33707' or zipCode = '33707' or zipCode = '33707' or zipCode = '33707' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33709' or zipCode = '33709' or zipCode = '33709' or zipCode = '33710' or zipCode = '33710' or zipCode = '33711' or zipCode = '33711' or zipCode = '33711' or zipCode = '33712' or zipCode = '33712' or zipCode = '33713' or zipCode = '33713' or zipCode = '33714' or zipCode = '33714' or zipCode = '33716' or zipCode = '33716' or zipCode = '33729' or zipCode = '33729' or zipCode = '33729' or zipCode = '33730' or zipCode = '33730' or zipCode = '33731' or zipCode = '33731' or zipCode = '33732' or zipCode = '33732' or zipCode = '33733' or zipCode = '33733' or zipCode = '33733' or zipCode = '33734' or zipCode = '33734' or zipCode = '33736' or zipCode = '33736' or zipCode = '33736' or zipCode = '33737' or zipCode = '33737' or zipCode = '33738' or zipCode = '33738' or zipCode = '33738' or zipCode = '33740' or zipCode = '33740' or zipCode = '33740' or zipCode = '33764' or zipCode = '33765' or zipCode = '33766' or zipCode = '33767' or zipCode = '33767' or zipCode = '33769' or zipCode = '33770' or zipCode = '33770' or zipCode = '33770' or zipCode = '33771' or zipCode = '33772' or zipCode = '33772' or zipCode = '33773' or zipCode = '33774' or zipCode = '33774' or zipCode = '33775' or zipCode = '33775' or zipCode = '33776' or zipCode = '33776' or zipCode = '33777' or zipCode = '33777' or zipCode = '33778' or zipCode = '33778' or zipCode = '33779' or zipCode = '33780' or zipCode = '33781' or zipCode = '33782' or zipCode = '33784' or zipCode = '33784' or zipCode = '33785' or zipCode = '33785' or zipCode = '33785' or zipCode = '33785' or zipCode = '33785' or zipCode = '33785' or zipCode = '33786' or zipCode = '33786' or zipCode = '33786' or zipCode = '33786' or zipCode = '33786' or zipCode = '33786' or zipCode = '33786' or zipCode = '33690' or zipCode = '33690' or zipCode = '33694' or zipCode = '33701' or zipCode = '33701' or zipCode = '33702' or zipCode = '33702' or zipCode = '33703' or zipCode = '33703' or zipCode = '33704' or zipCode = '33704' or zipCode = '33705' or zipCode = '33705' or zipCode = '33706' or zipCode = '33706' or zipCode = '33706' or zipCode = '33706' or zipCode = '33706' or zipCode = '33706' or zipCode = '33706' or zipCode = '33706' or zipCode = '33740' or zipCode = '33741' or zipCode = '33741' or zipCode = '33741' or zipCode = '33741' or zipCode = '33742' or zipCode = '33742' or zipCode = '33743' or zipCode = '33743' or zipCode = '33744' or zipCode = '33747' or zipCode = '33747' or zipCode = '33755' or zipCode = '33756' or zipCode = '33756' or zipCode = '33757' or zipCode = '33758' or zipCode = '33759' or zipCode = '33760' or zipCode = '33761' or zipCode = '33762' or zipCode = '33763' or zipCode = '34637' or zipCode = '34638' or zipCode = '34639' or zipCode = '34639' or zipCode = '34652' or zipCode = '34652' or zipCode = '34652' or zipCode = '34652' or zipCode = '34653' or zipCode = '34653' or zipCode = '34653' or zipCode = '34654' or zipCode = '34654' or zipCode = '34654' or zipCode = '34655' or zipCode = '34684' or zipCode = '34685' or zipCode = '34688' or zipCode = '34688' or zipCode = '34688' or zipCode = '34689' or zipCode = '34689' or zipCode = '34689' or zipCode = '34690' or zipCode = '34690' or zipCode = '34690' or zipCode = '34690' or zipCode = '34691' or zipCode = '34691' or zipCode = '34691' or zipCode = '34691' or zipCode = '34692' or zipCode = '34692' or zipCode = '34695' or zipCode = '34697' or zipCode = '34698' or zipCode = '34655' or zipCode = '34655' or zipCode = '34655' or zipCode = '34655' or zipCode = '34656' or zipCode = '34656' or zipCode = '34656' or zipCode = '34660' or zipCode = '34668' or zipCode = '34673' or zipCode = '34677' or zipCode = '34680' or zipCode = '34681' or zipCode = '34682' or zipCode = '34683' or zipCode = '33501' or zipCode = '33503' or zipCode = '33509' or zipCode = '33510' or zipCode = '33511' or zipCode = '33527' or zipCode = '33534' or zipCode = '33537' or zipCode = '33543' or zipCode = '33544' or zipCode = '33548' or zipCode = '33549' or zipCode = '33550' or zipCode = '33556' or zipCode = '33558' or zipCode = '33559' or zipCode = '33568' or zipCode = '33569' or zipCode = '33570' or zipCode = '33571' or zipCode = '33572' or zipCode = '33573' or zipCode = '33583' or zipCode = '33584' or zipCode = '33586' or zipCode = '33587' or zipCode = '33592' or zipCode = '33593' or zipCode = '33594' or zipCode = '33595' or zipCode = '33601' or zipCode = '33602' or zipCode = '33603' or zipCode = '33604' or zipCode = '33605' or zipCode = '33606' or zipCode = '33607' or zipCode = '33608' or zipCode = '33609' or zipCode = '33610' or zipCode = '33611' or zipCode = '33612' or zipCode = '33613' or zipCode = '33614' or zipCode = '33615' or zipCode = '33616' or zipCode = '33617' or zipCode = '33618' or zipCode = '33619' or zipCode = '33620' or zipCode = '33621' or zipCode = '33622' or zipCode = '33623' or zipCode = '33624' or zipCode = '33625' or zipCode = '33626' or zipCode = '33629' or zipCode = '33630' or zipCode = '33631' or zipCode = '33633' or zipCode = '33634' or zipCode = '33635' or zipCode = '33637' or zipCode = '33643' or zipCode = '33647' or zipCode = '33650' or zipCode = '33651' or zipCode = '33655' or zipCode = '33659' or zipCode = '33660' or zipCode = '33661' or zipCode = '33662' or zipCode = '33663' or zipCode = '33664' or zipCode = '33672' or zipCode = '33673' or zipCode = '33674' or zipCode = '33675' or zipCode = '33677' or zipCode = '33679' or zipCode = '33680' or zipCode = '33681' or zipCode = '33682' or zipCode = '33684' or zipCode = '33685' or zipCode = '33686' or zipCode = '33687' or zipCode = '33688' or zipCode = '33689' or zipCode = '33690' or zipCode = '33694' or zipCode = '33697' or zipCode = '33701' or zipCode = '33702' or zipCode = '33703' or zipCode = '33704' or zipCode = '33705' or zipCode = '33706' or zipCode = '33707' or zipCode = '33708' or zipCode = '33709' or zipCode = '33710' or zipCode = '33711' or zipCode = '33712' or zipCode = '33713' or zipCode = '33714' or zipCode = '33715' or zipCode = '33716' or zipCode = '33728' or zipCode = '33729' or zipCode = '33730' or zipCode = '33731' or zipCode = '33732' or zipCode = '33733' or zipCode = '33734' or zipCode = '33736' or zipCode = '33737' or zipCode = '33738' or zipCode = '33740' or zipCode = '33741' or zipCode = '33742' or zipCode = '33743' or zipCode = '33744' or zipCode = '33747' or zipCode = '33755' or zipCode = '33756' or zipCode = '33757' or zipCode = '33758' or zipCode = '33759' or zipCode = '33760' or zipCode = '33761' or zipCode = '33762' or zipCode = '33763' or zipCode = '33764' or zipCode = '33765' or zipCode = '33766' or zipCode = '33767' or zipCode = '33769' or zipCode = '33770' or zipCode = '33771' or zipCode = '33772' or zipCode = '33773' or zipCode = '33774' or zipCode = '33775' or zipCode = '33776' or zipCode = '33777' or zipCode = '33778' or zipCode = '33779' or zipCode = '33780' or zipCode = '33781' or zipCode = '33782' or zipCode = '33784' or zipCode = '33785' or zipCode = '33786' or zipCode = '34639' or zipCode = '34652' or zipCode = '34653' or zipCode = '34654' or zipCode = '34655' or zipCode = '34656' or zipCode = '34660' or zipCode = '34668' or zipCode = '34669' or zipCode = '34673' or zipCode = '34674' or zipCode = '34677' or zipCode = '34678' or zipCode = '34680' or zipCode = '34681' or zipCode = '34682' or zipCode = '34683' or zipCode = '34684' or zipCode = '34685' or zipCode = '34688' or zipCode = '34689' or zipCode = '34690' or zipCode = '34691' or zipCode = '34695' or zipCode = '34697' or zipCode = '34698' or zipCode = '34869') 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 ='33503' or zipCode = '33508' or zipCode = '33509' or zipCode = '33510' or zipCode = '33511' or zipCode = '33527' or zipCode = '33534' or zipCode = '33543' or zipCode = '33543' or zipCode = '33544' or zipCode = '33544' or zipCode = '33548' or zipCode = '33549' or zipCode = '33550' or zipCode = '33556' or zipCode = '33558' or zipCode = '33559' or zipCode = '33568' or zipCode = '33569' or zipCode = '33570' or zipCode = '33570' or zipCode = '33571' or zipCode = '33571' or zipCode = '33571' or zipCode = '33572' or zipCode = '33572' or zipCode = '33573' or zipCode = '33573' or zipCode = '33573' or zipCode = '33575' or zipCode = '33575' or zipCode = '33575' or zipCode = '33578' or zipCode = '33579' or zipCode = '33583' or zipCode = '33584' or zipCode = '33586' or zipCode = '33587' or zipCode = '33592' or zipCode = '33594' or zipCode = '33595' or zipCode = '33596' or zipCode = '33601' or zipCode = '33602' or zipCode = '33603' or zipCode = '33604' or zipCode = '33605' or zipCode = '33605' or zipCode = '33606' or zipCode = '33606' or zipCode = '33606' or zipCode = '33607' or zipCode = '33608' or zipCode = '33608' or zipCode = '33609' or zipCode = '33610' or zipCode = '33611' or zipCode = '33612' or zipCode = '33613' or zipCode = '33614' or zipCode = '33615' or zipCode = '33615' or zipCode = '33615' or zipCode = '33616' or zipCode = '33617' or zipCode = '33630' or zipCode = '33631' or zipCode = '33633' or zipCode = '33633' or zipCode = '33633' or zipCode = '33634' or zipCode = '33634' or zipCode = '33635' or zipCode = '33637' or zipCode = '33637' or zipCode = '33637' or zipCode = '33646' or zipCode = '33647' or zipCode = '33647' or zipCode = '33650' or zipCode = '33650' or zipCode = '33655' or zipCode = '33655' or zipCode = '33660' or zipCode = '33660' or zipCode = '33661' or zipCode = '33661' or zipCode = '33662' or zipCode = '33662' or zipCode = '33617' or zipCode = '33617' or zipCode = '33618' or zipCode = '33618' or zipCode = '33619' or zipCode = '33619' or zipCode = '33619' or zipCode = '33620' or zipCode = '33620' or zipCode = '33620' or zipCode = '33620' or zipCode = '33621' or zipCode = '33622' or zipCode = '33623' or zipCode = '33624' or zipCode = '33624' or zipCode = '33625' or zipCode = '33625' or zipCode = '33626' or zipCode = '33626' or zipCode = '33626' or zipCode = '33629' or zipCode = '33629' or zipCode = '33663' or zipCode = '33664' or zipCode = '33664' or zipCode = '33664' or zipCode = '33664' or zipCode = '33672' or zipCode = '33673' or zipCode = '33674' or zipCode = '33675' or zipCode = '33675' or zipCode = '33677' or zipCode = '33679' or zipCode = '33680' or zipCode = '33681' or zipCode = '33682' or zipCode = '33684' or zipCode = '33685' or zipCode = '33686' or zipCode = '33687' or zipCode = '33687' or zipCode = '33687' or zipCode = '33688' or zipCode = '33688' or zipCode = '33689' or zipCode = '33706' or zipCode = '33706' or zipCode = '33707' or zipCode = '33707' or zipCode = '33707' or zipCode = '33707' or zipCode = '33707' or zipCode = '33707' or zipCode = '33707' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33709' or zipCode = '33709' or zipCode = '33709' or zipCode = '33710' or zipCode = '33710' or zipCode = '33711' or zipCode = '33711' or zipCode = '33711' or zipCode = '33712' or zipCode = '33712' or zipCode = '33713' or zipCode = '33713' or zipCode = '33714' or zipCode = '33714' or zipCode = '33716' or zipCode = '33716' or zipCode = '33729' or zipCode = '33729' or zipCode = '33729' or zipCode = '33730' or zipCode = '33730' or zipCode = '33731' or zipCode = '33731' or zipCode = '33732' or zipCode = '33732' or zipCode = '33733' or zipCode = '33733' or zipCode = '33733' or zipCode = '33734' or zipCode = '33734' or zipCode = '33736' or zipCode = '33736' or zipCode = '33736' or zipCode = '33737' or zipCode = '33737' or zipCode = '33738' or zipCode = '33738' or zipCode = '33738' or zipCode = '33740' or zipCode = '33740' or zipCode = '33740' or zipCode = '33764' or zipCode = '33765' or zipCode = '33766' or zipCode = '33767' or zipCode = '33767' or zipCode = '33769' or zipCode = '33770' or zipCode = '33770' or zipCode = '33770' or zipCode = '33771' or zipCode = '33772' or zipCode = '33772' or zipCode = '33773' or zipCode = '33774' or zipCode = '33774' or zipCode = '33775' or zipCode = '33775' or zipCode = '33776' or zipCode = '33776' or zipCode = '33777' or zipCode = '33777' or zipCode = '33778' or zipCode = '33778' or zipCode = '33779' or zipCode = '33780' or zipCode = '33781' or zipCode = '33782' or zipCode = '33784' or zipCode = '33784' or zipCode = '33785' or zipCode = '33785' or zipCode = '33785' or zipCode = '33785' or zipCode = '33785' or zipCode = '33785' or zipCode = '33786' or zipCode = '33786' or zipCode = '33786' or zipCode = '33786' or zipCode = '33786' or zipCode = '33786' or zipCode = '33786' or zipCode = '33690' or zipCode = '33690' or zipCode = '33694' or zipCode = '33701' or zipCode = '33701' or zipCode = '33702' or zipCode = '33702' or zipCode = '33703' or zipCode = '33703' or zipCode = '33704' or zipCode = '33704' or zipCode = '33705' or zipCode = '33705' or zipCode = '33706' or zipCode = '33706' or zipCode = '33706' or zipCode = '33706' or zipCode = '33706' or zipCode = '33706' or zipCode = '33706' or zipCode = '33706' or zipCode = '33740' or zipCode = '33741' or zipCode = '33741' or zipCode = '33741' or zipCode = '33741' or zipCode = '33742' or zipCode = '33742' or zipCode = '33743' or zipCode = '33743' or zipCode = '33744' or zipCode = '33747' or zipCode = '33747' or zipCode = '33755' or zipCode = '33756' or zipCode = '33756' or zipCode = '33757' or zipCode = '33758' or zipCode = '33759' or zipCode = '33760' or zipCode = '33761' or zipCode = '33762' or zipCode = '33763' or zipCode = '34637' or zipCode = '34638' or zipCode = '34639' or zipCode = '34639' or zipCode = '34652' or zipCode = '34652' or zipCode = '34652' or zipCode = '34652' or zipCode = '34653' or zipCode = '34653' or zipCode = '34653' or zipCode = '34654' or zipCode = '34654' or zipCode = '34654' or zipCode = '34655' or zipCode = '34684' or zipCode = '34685' or zipCode = '34688' or zipCode = '34688' or zipCode = '34688' or zipCode = '34689' or zipCode = '34689' or zipCode = '34689' or zipCode = '34690' or zipCode = '34690' or zipCode = '34690' or zipCode = '34690' or zipCode = '34691' or zipCode = '34691' or zipCode = '34691' or zipCode = '34691' or zipCode = '34692' or zipCode = '34692' or zipCode = '34695' or zipCode = '34697' or zipCode = '34698' or zipCode = '34655' or zipCode = '34655' or zipCode = '34655' or zipCode = '34655' or zipCode = '34656' or zipCode = '34656' or zipCode = '34656' or zipCode = '34660' or zipCode = '34668' or zipCode = '34673' or zipCode = '34677' or zipCode = '34680' or zipCode = '34681' or zipCode = '34682' or zipCode = '34683' or zipCode = '33501' or zipCode = '33503' or zipCode = '33509' or zipCode = '33510' or zipCode = '33511' or zipCode = '33527' or zipCode = '33534' or zipCode = '33537' or zipCode = '33543' or zipCode = '33544' or zipCode = '33548' or zipCode = '33549' or zipCode = '33550' or zipCode = '33556' or zipCode = '33558' or zipCode = '33559' or zipCode = '33568' or zipCode = '33569' or zipCode = '33570' or zipCode = '33571' or zipCode = '33572' or zipCode = '33573' or zipCode = '33583' or zipCode = '33584' or zipCode = '33586' or zipCode = '33587' or zipCode = '33592' or zipCode = '33593' or zipCode = '33594' or zipCode = '33595' or zipCode = '33601' or zipCode = '33602' or zipCode = '33603' or zipCode = '33604' or zipCode = '33605' or zipCode = '33606' or zipCode = '33607' or zipCode = '33608' or zipCode = '33609' or zipCode = '33610' or zipCode = '33611' or zipCode = '33612' or zipCode = '33613' or zipCode = '33614' or zipCode = '33615' or zipCode = '33616' or zipCode = '33617' or zipCode = '33618' or zipCode = '33619' or zipCode = '33620' or zipCode = '33621' or zipCode = '33622' or zipCode = '33623' or zipCode = '33624' or zipCode = '33625' or zipCode = '33626' or zipCode = '33629' or zipCode = '33630' or zipCode = '33631' or zipCode = '33633' or zipCode = '33634' or zipCode = '33635' or zipCode = '33637' or zipCode = '33643' or zipCode = '33647' or zipCode = '33650' or zipCode = '33651' or zipCode = '33655' or zipCode = '33659' or zipCode = '33660' or zipCode = '33661' or zipCode = '33662' or zipCode = '33663' or zipCode = '33664' or zipCode = '33672' or zipCode = '33673' or zipCode = '33674' or zipCode = '33675' or zipCode = '33677' or zipCode = '33679' or zipCode = '33680' or zipCode = '33681' or zipCode = '33682' or zipCode = '33684' or zipCode = '33685' or zipCode = '33686' or zipCode = '33687' or zipCode = '33688' or zipCode = '33689' or zipCode = '33690' or zipCode = '33694' or zipCode = '33697' or zipCode = '33701' or zipCode = '33702' or zipCode = '33703' or zipCode = '33704' or zipCode = '33705' or zipCode = '33706' or zipCode = '33707' or zipCode = '33708' or zipCode = '33709' or zipCode = '33710' or zipCode = '33711' or zipCode = '33712' or zipCode = '33713' or zipCode = '33714' or zipCode = '33715' or zipCode = '33716' or zipCode = '33728' or zipCode = '33729' or zipCode = '33730' or zipCode = '33731' or zipCode = '33732' or zipCode = '33733' or zipCode = '33734' or zipCode = '33736' or zipCode = '33737' or zipCode = '33738' or zipCode = '33740' or zipCode = '33741' or zipCode = '33742' or zipCode = '33743' or zipCode = '33744' or zipCode = '33747' or zipCode = '33755' or zipCode = '33756' or zipCode = '33757' or zipCode = '33758' or zipCode = '33759' or zipCode = '33760' or zipCode = '33761' or zipCode = '33762' or zipCode = '33763' or zipCode = '33764' or zipCode = '33765' or zipCode = '33766' or zipCode = '33767' or zipCode = '33769' or zipCode = '33770' or zipCode = '33771' or zipCode = '33772' or zipCode = '33773' or zipCode = '33774' or zipCode = '33775' or zipCode = '33776' or zipCode = '33777' or zipCode = '33778' or zipCode = '33779' or zipCode = '33780' or zipCode = '33781' or zipCode = '33782' or zipCode = '33784' or zipCode = '33785' or zipCode = '33786' or zipCode = '34639' or zipCode = '34652' or zipCode = '34653' or zipCode = '34654' or zipCode = '34655' or zipCode = '34656' or zipCode = '34660' or zipCode = '34668' or zipCode = '34669' or zipCode = '34673' or zipCode = '34674' or zipCode = '34677' or zipCode = '34678' or zipCode = '34680' or zipCode = '34681' or zipCode = '34682' or zipCode = '34683' or zipCode = '34684' or zipCode = '34685' or zipCode = '34688' or zipCode = '34689' or zipCode = '34690' or zipCode = '34691' or zipCode = '34695' or zipCode = '34697' or zipCode = '34698' or zipCode = '34869') 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 ='33503' or zipCode = '33508' or zipCode = '33509' or zipCode = '33510' or zipCode = '33511' or zipCode = '33527' or zipCode = '33534' or zipCode = '33543' or zipCode = '33543' or zipCode = '33544' or zipCode = '33544' or zipCode = '33548' or zipCode = '33549' or zipCode = '33550' or zipCode = '33556' or zipCode = '33558' or zipCode = '33559' or zipCode = '33568' or zipCode = '33569' or zipCode = '33570' or zipCode = '33570' or zipCode = '33571' or zipCode = '33571' or zipCode = '33571' or zipCode = '33572' or zipCode = '33572' or zipCode = '33573' or zipCode = '33573' or zipCode = '33573' or zipCode = '33575' or zipCode = '33575' or zipCode = '33575' or zipCode = '33578' or zipCode = '33579' or zipCode = '33583' or zipCode = '33584' or zipCode = '33586' or zipCode = '33587' or zipCode = '33592' or zipCode = '33594' or zipCode = '33595' or zipCode = '33596' or zipCode = '33601' or zipCode = '33602' or zipCode = '33603' or zipCode = '33604' or zipCode = '33605' or zipCode = '33605' or zipCode = '33606' or zipCode = '33606' or zipCode = '33606' or zipCode = '33607' or zipCode = '33608' or zipCode = '33608' or zipCode = '33609' or zipCode = '33610' or zipCode = '33611' or zipCode = '33612' or zipCode = '33613' or zipCode = '33614' or zipCode = '33615' or zipCode = '33615' or zipCode = '33615' or zipCode = '33616' or zipCode = '33617' or zipCode = '33630' or zipCode = '33631' or zipCode = '33633' or zipCode = '33633' or zipCode = '33633' or zipCode = '33634' or zipCode = '33634' or zipCode = '33635' or zipCode = '33637' or zipCode = '33637' or zipCode = '33637' or zipCode = '33646' or zipCode = '33647' or zipCode = '33647' or zipCode = '33650' or zipCode = '33650' or zipCode = '33655' or zipCode = '33655' or zipCode = '33660' or zipCode = '33660' or zipCode = '33661' or zipCode = '33661' or zipCode = '33662' or zipCode = '33662' or zipCode = '33617' or zipCode = '33617' or zipCode = '33618' or zipCode = '33618' or zipCode = '33619' or zipCode = '33619' or zipCode = '33619' or zipCode = '33620' or zipCode = '33620' or zipCode = '33620' or zipCode = '33620' or zipCode = '33621' or zipCode = '33622' or zipCode = '33623' or zipCode = '33624' or zipCode = '33624' or zipCode = '33625' or zipCode = '33625' or zipCode = '33626' or zipCode = '33626' or zipCode = '33626' or zipCode = '33629' or zipCode = '33629' or zipCode = '33663' or zipCode = '33664' or zipCode = '33664' or zipCode = '33664' or zipCode = '33664' or zipCode = '33672' or zipCode = '33673' or zipCode = '33674' or zipCode = '33675' or zipCode = '33675' or zipCode = '33677' or zipCode = '33679' or zipCode = '33680' or zipCode = '33681' or zipCode = '33682' or zipCode = '33684' or zipCode = '33685' or zipCode = '33686' or zipCode = '33687' or zipCode = '33687' or zipCode = '33687' or zipCode = '33688' or zipCode = '33688' or zipCode = '33689' or zipCode = '33706' or zipCode = '33706' or zipCode = '33707' or zipCode = '33707' or zipCode = '33707' or zipCode = '33707' or zipCode = '33707' or zipCode = '33707' or zipCode = '33707' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33709' or zipCode = '33709' or zipCode = '33709' or zipCode = '33710' or zipCode = '33710' or zipCode = '33711' or zipCode = '33711' or zipCode = '33711' or zipCode = '33712' or zipCode = '33712' or zipCode = '33713' or zipCode = '33713' or zipCode = '33714' or zipCode = '33714' or zipCode = '33716' or zipCode = '33716' or zipCode = '33729' or zipCode = '33729' or zipCode = '33729' or zipCode = '33730' or zipCode = '33730' or zipCode = '33731' or zipCode = '33731' or zipCode = '33732' or zipCode = '33732' or zipCode = '33733' or zipCode = '33733' or zipCode = '33733' or zipCode = '33734' or zipCode = '33734' or zipCode = '33736' or zipCode = '33736' or zipCode = '33736' or zipCode = '33737' or zipCode = '33737' or zipCode = '33738' or zipCode = '33738' or zipCode = '33738' or zipCode = '33740' or zipCode = '33740' or zipCode = '33740' or zipCode = '33764' or zipCode = '33765' or zipCode = '33766' or zipCode = '33767' or zipCode = '33767' or zipCode = '33769' or zipCode = '33770' or zipCode = '33770' or zipCode = '33770' or zipCode = '33771' or zipCode = '33772' or zipCode = '33772' or zipCode = '33773' or zipCode = '33774' or zipCode = '33774' or zipCode = '33775' or zipCode = '33775' or zipCode = '33776' or zipCode = '33776' or zipCode = '33777' or zipCode = '33777' or zipCode = '33778' or zipCode = '33778' or zipCode = '33779' or zipCode = '33780' or zipCode = '33781' or zipCode = '33782' or zipCode = '33784' or zipCode = '33784' or zipCode = '33785' or zipCode = '33785' or zipCode = '33785' or zipCode = '33785' or zipCode = '33785' or zipCode = '33785' or zipCode = '33786' or zipCode = '33786' or zipCode = '33786' or zipCode = '33786' or zipCode = '33786' or zipCode = '33786' or zipCode = '33786' or zipCode = '33690' or zipCode = '33690' or zipCode = '33694' or zipCode = '33701' or zipCode = '33701' or zipCode = '33702' or zipCode = '33702' or zipCode = '33703' or zipCode = '33703' or zipCode = '33704' or zipCode = '33704' or zipCode = '33705' or zipCode = '33705' or zipCode = '33706' or zipCode = '33706' or zipCode = '33706' or zipCode = '33706' or zipCode = '33706' or zipCode = '33706' or zipCode = '33706' or zipCode = '33706' or zipCode = '33740' or zipCode = '33741' or zipCode = '33741' or zipCode = '33741' or zipCode = '33741' or zipCode = '33742' or zipCode = '33742' or zipCode = '33743' or zipCode = '33743' or zipCode = '33744' or zipCode = '33747' or zipCode = '33747' or zipCode = '33755' or zipCode = '33756' or zipCode = '33756' or zipCode = '33757' or zipCode = '33758' or zipCode = '33759' or zipCode = '33760' or zipCode = '33761' or zipCode = '33762' or zipCode = '33763' or zipCode = '34637' or zipCode = '34638' or zipCode = '34639' or zipCode = '34639' or zipCode = '34652' or zipCode = '34652' or zipCode = '34652' or zipCode = '34652' or zipCode = '34653' or zipCode = '34653' or zipCode = '34653' or zipCode = '34654' or zipCode = '34654' or zipCode = '34654' or zipCode = '34655' or zipCode = '34684' or zipCode = '34685' or zipCode = '34688' or zipCode = '34688' or zipCode = '34688' or zipCode = '34689' or zipCode = '34689' or zipCode = '34689' or zipCode = '34690' or zipCode = '34690' or zipCode = '34690' or zipCode = '34690' or zipCode = '34691' or zipCode = '34691' or zipCode = '34691' or zipCode = '34691' or zipCode = '34692' or zipCode = '34692' or zipCode = '34695' or zipCode = '34697' or zipCode = '34698' or zipCode = '34655' or zipCode = '34655' or zipCode = '34655' or zipCode = '34655' or zipCode = '34656' or zipCode = '34656' or zipCode = '34656' or zipCode = '34660' or zipCode = '34668' or zipCode = '34673' or zipCode = '34677' or zipCode = '34680' or zipCode = '34681' or zipCode = '34682' or zipCode = '34683' or zipCode = '33501' or zipCode = '33503' or zipCode = '33509' or zipCode = '33510' or zipCode = '33511' or zipCode = '33527' or zipCode = '33534' or zipCode = '33537' or zipCode = '33543' or zipCode = '33544' or zipCode = '33548' or zipCode = '33549' or zipCode = '33550' or zipCode = '33556' or zipCode = '33558' or zipCode = '33559' or zipCode = '33568' or zipCode = '33569' or zipCode = '33570' or zipCode = '33571' or zipCode = '33572' or zipCode = '33573' or zipCode = '33583' or zipCode = '33584' or zipCode = '33586' or zipCode = '33587' or zipCode = '33592' or zipCode = '33593' or zipCode = '33594' or zipCode = '33595' or zipCode = '33601' or zipCode = '33602' or zipCode = '33603' or zipCode = '33604' or zipCode = '33605' or zipCode = '33606' or zipCode = '33607' or zipCode = '33608' or zipCode = '33609' or zipCode = '33610' or zipCode = '33611' or zipCode = '33612' or zipCode = '33613' or zipCode = '33614' or zipCode = '33615' or zipCode = '33616' or zipCode = '33617' or zipCode = '33618' or zipCode = '33619' or zipCode = '33620' or zipCode = '33621' or zipCode = '33622' or zipCode = '33623' or zipCode = '33624' or zipCode = '33625' or zipCode = '33626' or zipCode = '33629' or zipCode = '33630' or zipCode = '33631' or zipCode = '33633' or zipCode = '33634' or zipCode = '33635' or zipCode = '33637' or zipCode = '33643' or zipCode = '33647' or zipCode = '33650' or zipCode = '33651' or zipCode = '33655' or zipCode = '33659' or zipCode = '33660' or zipCode = '33661' or zipCode = '33662' or zipCode = '33663' or zipCode = '33664' or zipCode = '33672' or zipCode = '33673' or zipCode = '33674' or zipCode = '33675' or zipCode = '33677' or zipCode = '33679' or zipCode = '33680' or zipCode = '33681' or zipCode = '33682' or zipCode = '33684' or zipCode = '33685' or zipCode = '33686' or zipCode = '33687' or zipCode = '33688' or zipCode = '33689' or zipCode = '33690' or zipCode = '33694' or zipCode = '33697' or zipCode = '33701' or zipCode = '33702' or zipCode = '33703' or zipCode = '33704' or zipCode = '33705' or zipCode = '33706' or zipCode = '33707' or zipCode = '33708' or zipCode = '33709' or zipCode = '33710' or zipCode = '33711' or zipCode = '33712' or zipCode = '33713' or zipCode = '33714' or zipCode = '33715' or zipCode = '33716' or zipCode = '33728' or zipCode = '33729' or zipCode = '33730' or zipCode = '33731' or zipCode = '33732' or zipCode = '33733' or zipCode = '33734' or zipCode = '33736' or zipCode = '33737' or zipCode = '33738' or zipCode = '33740' or zipCode = '33741' or zipCode = '33742' or zipCode = '33743' or zipCode = '33744' or zipCode = '33747' or zipCode = '33755' or zipCode = '33756' or zipCode = '33757' or zipCode = '33758' or zipCode = '33759' or zipCode = '33760' or zipCode = '33761' or zipCode = '33762' or zipCode = '33763' or zipCode = '33764' or zipCode = '33765' or zipCode = '33766' or zipCode = '33767' or zipCode = '33769' or zipCode = '33770' or zipCode = '33771' or zipCode = '33772' or zipCode = '33773' or zipCode = '33774' or zipCode = '33775' or zipCode = '33776' or zipCode = '33777' or zipCode = '33778' or zipCode = '33779' or zipCode = '33780' or zipCode = '33781' or zipCode = '33782' or zipCode = '33784' or zipCode = '33785' or zipCode = '33786' or zipCode = '34639' or zipCode = '34652' or zipCode = '34653' or zipCode = '34654' or zipCode = '34655' or zipCode = '34656' or zipCode = '34660' or zipCode = '34668' or zipCode = '34669' or zipCode = '34673' or zipCode = '34674' or zipCode = '34677' or zipCode = '34678' or zipCode = '34680' or zipCode = '34681' or zipCode = '34682' or zipCode = '34683' or zipCode = '34684' or zipCode = '34685' or zipCode = '34688' or zipCode = '34689' or zipCode = '34690' or zipCode = '34691' or zipCode = '34695' or zipCode = '34697' or zipCode = '34698' or zipCode = '34869') 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 ='33503' or zipCode = '33508' or zipCode = '33509' or zipCode = '33510' or zipCode = '33511' or zipCode = '33527' or zipCode = '33534' or zipCode = '33543' or zipCode = '33543' or zipCode = '33544' or zipCode = '33544' or zipCode = '33548' or zipCode = '33549' or zipCode = '33550' or zipCode = '33556' or zipCode = '33558' or zipCode = '33559' or zipCode = '33568' or zipCode = '33569' or zipCode = '33570' or zipCode = '33570' or zipCode = '33571' or zipCode = '33571' or zipCode = '33571' or zipCode = '33572' or zipCode = '33572' or zipCode = '33573' or zipCode = '33573' or zipCode = '33573' or zipCode = '33575' or zipCode = '33575' or zipCode = '33575' or zipCode = '33578' or zipCode = '33579' or zipCode = '33583' or zipCode = '33584' or zipCode = '33586' or zipCode = '33587' or zipCode = '33592' or zipCode = '33594' or zipCode = '33595' or zipCode = '33596' or zipCode = '33601' or zipCode = '33602' or zipCode = '33603' or zipCode = '33604' or zipCode = '33605' or zipCode = '33605' or zipCode = '33606' or zipCode = '33606' or zipCode = '33606' or zipCode = '33607' or zipCode = '33608' or zipCode = '33608' or zipCode = '33609' or zipCode = '33610' or zipCode = '33611' or zipCode = '33612' or zipCode = '33613' or zipCode = '33614' or zipCode = '33615' or zipCode = '33615' or zipCode = '33615' or zipCode = '33616' or zipCode = '33617' or zipCode = '33630' or zipCode = '33631' or zipCode = '33633' or zipCode = '33633' or zipCode = '33633' or zipCode = '33634' or zipCode = '33634' or zipCode = '33635' or zipCode = '33637' or zipCode = '33637' or zipCode = '33637' or zipCode = '33646' or zipCode = '33647' or zipCode = '33647' or zipCode = '33650' or zipCode = '33650' or zipCode = '33655' or zipCode = '33655' or zipCode = '33660' or zipCode = '33660' or zipCode = '33661' or zipCode = '33661' or zipCode = '33662' or zipCode = '33662' or zipCode = '33617' or zipCode = '33617' or zipCode = '33618' or zipCode = '33618' or zipCode = '33619' or zipCode = '33619' or zipCode = '33619' or zipCode = '33620' or zipCode = '33620' or zipCode = '33620' or zipCode = '33620' or zipCode = '33621' or zipCode = '33622' or zipCode = '33623' or zipCode = '33624' or zipCode = '33624' or zipCode = '33625' or zipCode = '33625' or zipCode = '33626' or zipCode = '33626' or zipCode = '33626' or zipCode = '33629' or zipCode = '33629' or zipCode = '33663' or zipCode = '33664' or zipCode = '33664' or zipCode = '33664' or zipCode = '33664' or zipCode = '33672' or zipCode = '33673' or zipCode = '33674' or zipCode = '33675' or zipCode = '33675' or zipCode = '33677' or zipCode = '33679' or zipCode = '33680' or zipCode = '33681' or zipCode = '33682' or zipCode = '33684' or zipCode = '33685' or zipCode = '33686' or zipCode = '33687' or zipCode = '33687' or zipCode = '33687' or zipCode = '33688' or zipCode = '33688' or zipCode = '33689' or zipCode = '33706' or zipCode = '33706' or zipCode = '33707' or zipCode = '33707' or zipCode = '33707' or zipCode = '33707' or zipCode = '33707' or zipCode = '33707' or zipCode = '33707' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33708' or zipCode = '33709' or zipCode = '33709' or zipCode = '33709' or zipCode = '33710' or zipCode = '33710' or zipCode = '33711' or zipCode = '33711' or zipCode = '33711' or zipCode = '33712' or zipCode = '33712' or zipCode = '33713' or zipCode = '33713' or zipCode = '33714' or zipCode = '33714' or zipCode = '33716' or zipCode = '33716' or zipCode = '33729' or zipCode = '33729' or zipCode = '33729' or zipCode = '33730' or zipCode = '33730' or zipCode = '33731' or zipCode = '33731' or zipCode = '33732' or zipCode = '33732' or zipCode = '33733' or zipCode = '33733' or zipCode = '33733' or zipCode = '33734' or zipCode = '33734' or zipCode = '33736' or zipCode = '33736' or zipCode = '33736' or zipCode = '33737' or zipCode = '33737' or zipCode = '33738' or zipCode = '33738' or zipCode = '33738' or zipCode = '33740' or zipCode = '33740' or zipCode = '33740' or zipCode = '33764' or zipCode = '33765' or zipCode = '33766' or zipCode = '33767' or zipCode = '33767' or zipCode = '33769' or zipCode = '33770' or zipCode = '33770' or zipCode = '33770' or zipCode = '33771' or zipCode = '33772' or zipCode = '33772' or zipCode = '33773' or zipCode = '33774' or zipCode = '33774' or zipCode = '33775' or zipCode = '33775' or zipCode = '33776' or zipCode = '33776' or zipCode = '33777' or zipCode = '33777' or zipCode = '33778' or zipCode = '33778' or zipCode = '33779' or zipCode = '33780' or zipCode = '33781' or zipCode = '33782' or zipCode = '33784' or zipCode = '33784' or zipCode = '33785' or zipCode = '33785' or zipCode = '33785' or zipCode = '33785' or zipCode = '33785' or zipCode = '33785' or zipCode = '33786' or zipCode = '33786' or zipCode = '33786' or zipCode = '33786' or zipCode = '33786' or zipCode = '33786' or zipCode = '33786' or zipCode = '33690' or zipCode = '33690' or zipCode = '33694' or zipCode = '33701' or zipCode = '33701' or zipCode = '33702' or zipCode = '33702' or zipCode = '33703' or zipCode = '33703' or zipCode = '33704' or zipCode = '33704' or zipCode = '33705' or zipCode = '33705' or zipCode = '33706' or zipCode = '33706' or zipCode = '33706' or zipCode = '33706' or zipCode = '33706' or zipCode = '33706' or zipCode = '33706' or zipCode = '33706' or zipCode = '33740' or zipCode = '33741' or zipCode = '33741' or zipCode = '33741' or zipCode = '33741' or zipCode = '33742' or zipCode = '33742' or zipCode = '33743' or zipCode = '33743' or zipCode = '33744' or zipCode = '33747' or zipCode = '33747' or zipCode = '33755' or zipCode = '33756' or zipCode = '33756' or zipCode = '33757' or zipCode = '33758' or zipCode = '33759' or zipCode = '33760' or zipCode = '33761' or zipCode = '33762' or zipCode = '33763' or zipCode = '34637' or zipCode = '34638' or zipCode = '34639' or zipCode = '34639' or zipCode = '34652' or zipCode = '34652' or zipCode = '34652' or zipCode = '34652' or zipCode = '34653' or zipCode = '34653' or zipCode = '34653' or zipCode = '34654' or zipCode = '34654' or zipCode = '34654' or zipCode = '34655' or zipCode = '34684' or zipCode = '34685' or zipCode = '34688' or zipCode = '34688' or zipCode = '34688' or zipCode = '34689' or zipCode = '34689' or zipCode = '34689' or zipCode = '34690' or zipCode = '34690' or zipCode = '34690' or zipCode = '34690' or zipCode = '34691' or zipCode = '34691' or zipCode = '34691' or zipCode = '34691' or zipCode = '34692' or zipCode = '34692' or zipCode = '34695' or zipCode = '34697' or zipCode = '34698' or zipCode = '34655' or zipCode = '34655' or zipCode = '34655' or zipCode = '34655' or zipCode = '34656' or zipCode = '34656' or zipCode = '34656' or zipCode = '34660' or zipCode = '34668' or zipCode = '34673' or zipCode = '34677' or zipCode = '34680' or zipCode = '34681' or zipCode = '34682' or zipCode = '34683' or zipCode = '33501' or zipCode = '33503' or zipCode = '33509' or zipCode = '33510' or zipCode = '33511' or zipCode = '33527' or zipCode = '33534' or zipCode = '33537' or zipCode = '33543' or zipCode = '33544' or zipCode = '33548' or zipCode = '33549' or zipCode = '33550' or zipCode = '33556' or zipCode = '33558' or zipCode = '33559' or zipCode = '33568' or zipCode = '33569' or zipCode = '33570' or zipCode = '33571' or zipCode = '33572' or zipCode = '33573' or zipCode = '33583' or zipCode = '33584' or zipCode = '33586' or zipCode = '33587' or zipCode = '33592' or zipCode = '33593' or zipCode = '33594' or zipCode = '33595' or zipCode = '33601' or zipCode = '33602' or zipCode = '33603' or zipCode = '33604' or zipCode = '33605' or zipCode = '33606' or zipCode = '33607' or zipCode = '33608' or zipCode = '33609' or zipCode = '33610' or zipCode = '33611' or zipCode = '33612' or zipCode = '33613' or zipCode = '33614' or zipCode = '33615' or zipCode = '33616' or zipCode = '33617' or zipCode = '33618' or zipCode = '33619' or zipCode = '33620' or zipCode = '33621' or zipCode = '33622' or zipCode = '33623' or zipCode = '33624' or zipCode = '33625' or zipCode = '33626' or zipCode = '33629' or zipCode = '33630' or zipCode = '33631' or zipCode = '33633' or zipCode = '33634' or zipCode = '33635' or zipCode = '33637' or zipCode = '33643' or zipCode = '33647' or zipCode = '33650' or zipCode = '33651' or zipCode = '33655' or zipCode = '33659' or zipCode = '33660' or zipCode = '33661' or zipCode = '33662' or zipCode = '33663' or zipCode = '33664' or zipCode = '33672' or zipCode = '33673' or zipCode = '33674' or zipCode = '33675' or zipCode = '33677' or zipCode = '33679' or zipCode = '33680' or zipCode = '33681' or zipCode = '33682' or zipCode = '33684' or zipCode = '33685' or zipCode = '33686' or zipCode = '33687' or zipCode = '33688' or zipCode = '33689' or zipCode = '33690' or zipCode = '33694' or zipCode = '33697' or zipCode = '33701' or zipCode = '33702' or zipCode = '33703' or zipCode = '33704' or zipCode = '33705' or zipCode = '33706' or zipCode = '33707' or zipCode = '33708' or zipCode = '33709' or zipCode = '33710' or zipCode = '33711' or zipCode = '33712' or zipCode = '33713' or zipCode = '33714' or zipCode = '33715' or zipCode = '33716' or zipCode = '33728' or zipCode = '33729' or zipCode = '33730' or zipCode = '33731' or zipCode = '33732' or zipCode = '33733' or zipCode = '33734' or zipCode = '33736' or zipCode = '33737' or zipCode = '33738' or zipCode = '33740' or zipCode = '33741' or zipCode = '33742' or zipCode = '33743' or zipCode = '33744' or zipCode = '33747' or zipCode = '33755' or zipCode = '33756' or zipCode = '33757' or zipCode = '33758' or zipCode = '33759' or zipCode = '33760' or zipCode = '33761' or zipCode = '33762' or zipCode = '33763' or zipCode = '33764' or zipCode = '33765' or zipCode = '33766' or zipCode = '33767' or zipCode = '33769' or zipCode = '33770' or zipCode = '33771' or zipCode = '33772' or zipCode = '33773' or zipCode = '33774' or zipCode = '33775' or zipCode = '33776' or zipCode = '33777' or zipCode = '33778' or zipCode = '33779' or zipCode = '33780' or zipCode = '33781' or zipCode = '33782' or zipCode = '33784' or zipCode = '33785' or zipCode = '33786' or zipCode = '34639' or zipCode = '34652' or zipCode = '34653' or zipCode = '34654' or zipCode = '34655' or zipCode = '34656' or zipCode = '34660' or zipCode = '34668' or zipCode = '34669' or zipCode = '34673' or zipCode = '34674' or zipCode = '34677' or zipCode = '34678' or zipCode = '34680' or zipCode = '34681' or zipCode = '34682' or zipCode = '34683' or zipCode = '34684' or zipCode = '34685' or zipCode = '34688' or zipCode = '34689' or zipCode = '34690' or zipCode = '34691' or zipCode = '34695' or zipCode = '34697' or zipCode = '34698' or zipCode = '34869') 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 ='33503' or property_zip = '33508' or property_zip = '33509' or property_zip = '33510' or property_zip = '33511' or property_zip = '33527' or property_zip = '33534' or property_zip = '33543' or property_zip = '33543' or property_zip = '33544' or property_zip = '33544' or property_zip = '33548' or property_zip = '33549' or property_zip = '33550' or property_zip = '33556' or property_zip = '33558' or property_zip = '33559' or property_zip = '33568' or property_zip = '33569' or property_zip = '33570' or property_zip = '33570' or property_zip = '33571' or property_zip = '33571' or property_zip = '33571' or property_zip = '33572' or property_zip = '33572' or property_zip = '33573' or property_zip = '33573' or property_zip = '33573' or property_zip = '33575' or property_zip = '33575' or property_zip = '33575' or property_zip = '33578' or property_zip = '33579' or property_zip = '33583' or property_zip = '33584' or property_zip = '33586' or property_zip = '33587' or property_zip = '33592' or property_zip = '33594' or property_zip = '33595' or property_zip = '33596' or property_zip = '33601' or property_zip = '33602' or property_zip = '33603' or property_zip = '33604' or property_zip = '33605' or property_zip = '33605' or property_zip = '33606' or property_zip = '33606' or property_zip = '33606' or property_zip = '33607' or property_zip = '33608' or property_zip = '33608' or property_zip = '33609' or property_zip = '33610' or property_zip = '33611' or property_zip = '33612' or property_zip = '33613' or property_zip = '33614' or property_zip = '33615' or property_zip = '33615' or property_zip = '33615' or property_zip = '33616' or property_zip = '33617' or property_zip = '33630' or property_zip = '33631' or property_zip = '33633' or property_zip = '33633' or property_zip = '33633' or property_zip = '33634' or property_zip = '33634' or property_zip = '33635' or property_zip = '33637' or property_zip = '33637' or property_zip = '33637' or property_zip = '33646' or property_zip = '33647' or property_zip = '33647' or property_zip = '33650' or property_zip = '33650' or property_zip = '33655' or property_zip = '33655' or property_zip = '33660' or property_zip = '33660' or property_zip = '33661' or property_zip = '33661' or property_zip = '33662' or property_zip = '33662' or property_zip = '33617' or property_zip = '33617' or property_zip = '33618' or property_zip = '33618' or property_zip = '33619' or property_zip = '33619' or property_zip = '33619' or property_zip = '33620' or property_zip = '33620' or property_zip = '33620' or property_zip = '33620' or property_zip = '33621' or property_zip = '33622' or property_zip = '33623' or property_zip = '33624' or property_zip = '33624' or property_zip = '33625' or property_zip = '33625' or property_zip = '33626' or property_zip = '33626' or property_zip = '33626' or property_zip = '33629' or property_zip = '33629' or property_zip = '33663' or property_zip = '33664' or property_zip = '33664' or property_zip = '33664' or property_zip = '33664' or property_zip = '33672' or property_zip = '33673' or property_zip = '33674' or property_zip = '33675' or property_zip = '33675' or property_zip = '33677' or property_zip = '33679' or property_zip = '33680' or property_zip = '33681' or property_zip = '33682' or property_zip = '33684' or property_zip = '33685' or property_zip = '33686' or property_zip = '33687' or property_zip = '33687' or property_zip = '33687' or property_zip = '33688' or property_zip = '33688' or property_zip = '33689' or property_zip = '33706' or property_zip = '33706' or property_zip = '33707' or property_zip = '33707' or property_zip = '33707' or property_zip = '33707' or property_zip = '33707' or property_zip = '33707' or property_zip = '33707' or property_zip = '33708' or property_zip = '33708' or property_zip = '33708' or property_zip = '33708' or property_zip = '33708' or property_zip = '33708' or property_zip = '33708' or property_zip = '33708' or property_zip = '33708' or property_zip = '33708' or property_zip = '33709' or property_zip = '33709' or property_zip = '33709' or property_zip = '33710' or property_zip = '33710' or property_zip = '33711' or property_zip = '33711' or property_zip = '33711' or property_zip = '33712' or property_zip = '33712' or property_zip = '33713' or property_zip = '33713' or property_zip = '33714' or property_zip = '33714' or property_zip = '33716' or property_zip = '33716' or property_zip = '33729' or property_zip = '33729' or property_zip = '33729' or property_zip = '33730' or property_zip = '33730' or property_zip = '33731' or property_zip = '33731' or property_zip = '33732' or property_zip = '33732' or property_zip = '33733' or property_zip = '33733' or property_zip = '33733' or property_zip = '33734' or property_zip = '33734' or property_zip = '33736' or property_zip = '33736' or property_zip = '33736' or property_zip = '33737' or property_zip = '33737' or property_zip = '33738' or property_zip = '33738' or property_zip = '33738' or property_zip = '33740' or property_zip = '33740' or property_zip = '33740' or property_zip = '33764' or property_zip = '33765' or property_zip = '33766' or property_zip = '33767' or property_zip = '33767' or property_zip = '33769' or property_zip = '33770' or property_zip = '33770' or property_zip = '33770' or property_zip = '33771' or property_zip = '33772' or property_zip = '33772' or property_zip = '33773' or property_zip = '33774' or property_zip = '33774' or property_zip = '33775' or property_zip = '33775' or property_zip = '33776' or property_zip = '33776' or property_zip = '33777' or property_zip = '33777' or property_zip = '33778' or property_zip = '33778' or property_zip = '33779' or property_zip = '33780' or property_zip = '33781' or property_zip = '33782' or property_zip = '33784' or property_zip = '33784' or property_zip = '33785' or property_zip = '33785' or property_zip = '33785' or property_zip = '33785' or property_zip = '33785' or property_zip = '33785' or property_zip = '33786' or property_zip = '33786' or property_zip = '33786' or property_zip = '33786' or property_zip = '33786' or property_zip = '33786' or property_zip = '33786' or property_zip = '33690' or property_zip = '33690' or property_zip = '33694' or property_zip = '33701' or property_zip = '33701' or property_zip = '33702' or property_zip = '33702' or property_zip = '33703' or property_zip = '33703' or property_zip = '33704' or property_zip = '33704' or property_zip = '33705' or property_zip = '33705' or property_zip = '33706' or property_zip = '33706' or property_zip = '33706' or property_zip = '33706' or property_zip = '33706' or property_zip = '33706' or property_zip = '33706' or property_zip = '33706' or property_zip = '33740' or property_zip = '33741' or property_zip = '33741' or property_zip = '33741' or property_zip = '33741' or property_zip = '33742' or property_zip = '33742' or property_zip = '33743' or property_zip = '33743' or property_zip = '33744' or property_zip = '33747' or property_zip = '33747' or property_zip = '33755' or property_zip = '33756' or property_zip = '33756' or property_zip = '33757' or property_zip = '33758' or property_zip = '33759' or property_zip = '33760' or property_zip = '33761' or property_zip = '33762' or property_zip = '33763' or property_zip = '34637' or property_zip = '34638' or property_zip = '34639' or property_zip = '34639' or property_zip = '34652' or property_zip = '34652' or property_zip = '34652' or property_zip = '34652' or property_zip = '34653' or property_zip = '34653' or property_zip = '34653' or property_zip = '34654' or property_zip = '34654' or property_zip = '34654' or property_zip = '34655' or property_zip = '34684' or property_zip = '34685' or property_zip = '34688' or property_zip = '34688' or property_zip = '34688' or property_zip = '34689' or property_zip = '34689' or property_zip = '34689' or property_zip = '34690' or property_zip = '34690' or property_zip = '34690' or property_zip = '34690' or property_zip = '34691' or property_zip = '34691' or property_zip = '34691' or property_zip = '34691' or property_zip = '34692' or property_zip = '34692' or property_zip = '34695' or property_zip = '34697' or property_zip = '34698' or property_zip = '34655' or property_zip = '34655' or property_zip = '34655' or property_zip = '34655' or property_zip = '34656' or property_zip = '34656' or property_zip = '34656' or property_zip = '34660' or property_zip = '34668' or property_zip = '34673' or property_zip = '34677' or property_zip = '34680' or property_zip = '34681' or property_zip = '34682' or property_zip = '34683' or property_zip = '33501' or property_zip = '33503' or property_zip = '33509' or property_zip = '33510' or property_zip = '33511' or property_zip = '33527' or property_zip = '33534' or property_zip = '33537' or property_zip = '33543' or property_zip = '33544' or property_zip = '33548' or property_zip = '33549' or property_zip = '33550' or property_zip = '33556' or property_zip = '33558' or property_zip = '33559' or property_zip = '33568' or property_zip = '33569' or property_zip = '33570' or property_zip = '33571' or property_zip = '33572' or property_zip = '33573' or property_zip = '33583' or property_zip = '33584' or property_zip = '33586' or property_zip = '33587' or property_zip = '33592' or property_zip = '33593' or property_zip = '33594' or property_zip = '33595' or property_zip = '33601' or property_zip = '33602' or property_zip = '33603' or property_zip = '33604' or property_zip = '33605' or property_zip = '33606' or property_zip = '33607' or property_zip = '33608' or property_zip = '33609' or property_zip = '33610' or property_zip = '33611' or property_zip = '33612' or property_zip = '33613' or property_zip = '33614' or property_zip = '33615' or property_zip = '33616' or property_zip = '33617' or property_zip = '33618' or property_zip = '33619' or property_zip = '33620' or property_zip = '33621' or property_zip = '33622' or property_zip = '33623' or property_zip = '33624' or property_zip = '33625' or property_zip = '33626' or property_zip = '33629' or property_zip = '33630' or property_zip = '33631' or property_zip = '33633' or property_zip = '33634' or property_zip = '33635' or property_zip = '33637' or property_zip = '33643' or property_zip = '33647' or property_zip = '33650' or property_zip = '33651' or property_zip = '33655' or property_zip = '33659' or property_zip = '33660' or property_zip = '33661' or property_zip = '33662' or property_zip = '33663' or property_zip = '33664' or property_zip = '33672' or property_zip = '33673' or property_zip = '33674' or property_zip = '33675' or property_zip = '33677' or property_zip = '33679' or property_zip = '33680' or property_zip = '33681' or property_zip = '33682' or property_zip = '33684' or property_zip = '33685' or property_zip = '33686' or property_zip = '33687' or property_zip = '33688' or property_zip = '33689' or property_zip = '33690' or property_zip = '33694' or property_zip = '33697' or property_zip = '33701' or property_zip = '33702' or property_zip = '33703' or property_zip = '33704' or property_zip = '33705' or property_zip = '33706' or property_zip = '33707' or property_zip = '33708' or property_zip = '33709' or property_zip = '33710' or property_zip = '33711' or property_zip = '33712' or property_zip = '33713' or property_zip = '33714' or property_zip = '33715' or property_zip = '33716' or property_zip = '33728' or property_zip = '33729' or property_zip = '33730' or property_zip = '33731' or property_zip = '33732' or property_zip = '33733' or property_zip = '33734' or property_zip = '33736' or property_zip = '33737' or property_zip = '33738' or property_zip = '33740' or property_zip = '33741' or property_zip = '33742' or property_zip = '33743' or property_zip = '33744' or property_zip = '33747' or property_zip = '33755' or property_zip = '33756' or property_zip = '33757' or property_zip = '33758' or property_zip = '33759' or property_zip = '33760' or property_zip = '33761' or property_zip = '33762' or property_zip = '33763' or property_zip = '33764' or property_zip = '33765' or property_zip = '33766' or property_zip = '33767' or property_zip = '33769' or property_zip = '33770' or property_zip = '33771' or property_zip = '33772' or property_zip = '33773' or property_zip = '33774' or property_zip = '33775' or property_zip = '33776' or property_zip = '33777' or property_zip = '33778' or property_zip = '33779' or property_zip = '33780' or property_zip = '33781' or property_zip = '33782' or property_zip = '33784' or property_zip = '33785' or property_zip = '33786' or property_zip = '34639' or property_zip = '34652' or property_zip = '34653' or property_zip = '34654' or property_zip = '34655' or property_zip = '34656' or property_zip = '34660' or property_zip = '34668' or property_zip = '34669' or property_zip = '34673' or property_zip = '34674' or property_zip = '34677' or property_zip = '34678' or property_zip = '34680' or property_zip = '34681' or property_zip = '34682' or property_zip = '34683' or property_zip = '34684' or property_zip = '34685' or property_zip = '34688' or property_zip = '34689' or property_zip = '34690' or property_zip = '34691' or property_zip = '34695' or property_zip = '34697' or property_zip = '34698' or property_zip = '34869') and convert(date,auction_start_date) >= '9/27/2021';
select top 45 * from currentforeclosures.tblAll NOLOCK where state = 'FL '
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 ='33503' or zip = '33508' or zip = '33509' or zip = '33510' or zip = '33511' or zip = '33527' or zip = '33534' or zip = '33543' or zip = '33543' or zip = '33544' or zip = '33544' or zip = '33548' or zip = '33549' or zip = '33550' or zip = '33556' or zip = '33558' or zip = '33559' or zip = '33568' or zip = '33569' or zip = '33570' or zip = '33570' or zip = '33571' or zip = '33571' or zip = '33571' or zip = '33572' or zip = '33572' or zip = '33573' or zip = '33573' or zip = '33573' or zip = '33575' or zip = '33575' or zip = '33575' or zip = '33578' or zip = '33579' or zip = '33583' or zip = '33584' or zip = '33586' or zip = '33587' or zip = '33592' or zip = '33594' or zip = '33595' or zip = '33596' or zip = '33601' or zip = '33602' or zip = '33603' or zip = '33604' or zip = '33605' or zip = '33605' or zip = '33606' or zip = '33606' or zip = '33606' or zip = '33607' or zip = '33608' or zip = '33608' or zip = '33609' or zip = '33610' or zip = '33611' or zip = '33612' or zip = '33613' or zip = '33614' or zip = '33615' or zip = '33615' or zip = '33615' or zip = '33616' or zip = '33617' or zip = '33630' or zip = '33631' or zip = '33633' or zip = '33633' or zip = '33633' or zip = '33634' or zip = '33634' or zip = '33635' or zip = '33637' or zip = '33637' or zip = '33637' or zip = '33646' or zip = '33647' or zip = '33647' or zip = '33650' or zip = '33650' or zip = '33655' or zip = '33655' or zip = '33660' or zip = '33660' or zip = '33661' or zip = '33661' or zip = '33662' or zip = '33662' or zip = '33617' or zip = '33617' or zip = '33618' or zip = '33618' or zip = '33619' or zip = '33619' or zip = '33619' or zip = '33620' or zip = '33620' or zip = '33620' or zip = '33620' or zip = '33621' or zip = '33622' or zip = '33623' or zip = '33624' or zip = '33624' or zip = '33625' or zip = '33625' or zip = '33626' or zip = '33626' or zip = '33626' or zip = '33629' or zip = '33629' or zip = '33663' or zip = '33664' or zip = '33664' or zip = '33664' or zip = '33664' or zip = '33672' or zip = '33673' or zip = '33674' or zip = '33675' or zip = '33675' or zip = '33677' or zip = '33679' or zip = '33680' or zip = '33681' or zip = '33682' or zip = '33684' or zip = '33685' or zip = '33686' or zip = '33687' or zip = '33687' or zip = '33687' or zip = '33688' or zip = '33688' or zip = '33689' or zip = '33706' or zip = '33706' or zip = '33707' or zip = '33707' or zip = '33707' or zip = '33707' or zip = '33707' or zip = '33707' or zip = '33707' or zip = '33708' or zip = '33708' or zip = '33708' or zip = '33708' or zip = '33708' or zip = '33708' or zip = '33708' or zip = '33708' or zip = '33708' or zip = '33708' or zip = '33709' or zip = '33709' or zip = '33709' or zip = '33710' or zip = '33710' or zip = '33711' or zip = '33711' or zip = '33711' or zip = '33712' or zip = '33712' or zip = '33713' or zip = '33713' or zip = '33714' or zip = '33714' or zip = '33716' or zip = '33716' or zip = '33729' or zip = '33729' or zip = '33729' or zip = '33730' or zip = '33730' or zip = '33731' or zip = '33731' or zip = '33732' or zip = '33732' or zip = '33733' or zip = '33733' or zip = '33733' or zip = '33734' or zip = '33734' or zip = '33736' or zip = '33736' or zip = '33736' or zip = '33737' or zip = '33737' or zip = '33738' or zip = '33738' or zip = '33738' or zip = '33740' or zip = '33740' or zip = '33740' or zip = '33764' or zip = '33765' or zip = '33766' or zip = '33767' or zip = '33767' or zip = '33769' or zip = '33770' or zip = '33770' or zip = '33770' or zip = '33771' or zip = '33772' or zip = '33772' or zip = '33773' or zip = '33774' or zip = '33774' or zip = '33775' or zip = '33775' or zip = '33776' or zip = '33776' or zip = '33777' or zip = '33777' or zip = '33778' or zip = '33778' or zip = '33779' or zip = '33780' or zip = '33781' or zip = '33782' or zip = '33784' or zip = '33784' or zip = '33785' or zip = '33785' or zip = '33785' or zip = '33785' or zip = '33785' or zip = '33785' or zip = '33786' or zip = '33786' or zip = '33786' or zip = '33786' or zip = '33786' or zip = '33786' or zip = '33786' or zip = '33690' or zip = '33690' or zip = '33694' or zip = '33701' or zip = '33701' or zip = '33702' or zip = '33702' or zip = '33703' or zip = '33703' or zip = '33704' or zip = '33704' or zip = '33705' or zip = '33705' or zip = '33706' or zip = '33706' or zip = '33706' or zip = '33706' or zip = '33706' or zip = '33706' or zip = '33706' or zip = '33706' or zip = '33740' or zip = '33741' or zip = '33741' or zip = '33741' or zip = '33741' or zip = '33742' or zip = '33742' or zip = '33743' or zip = '33743' or zip = '33744' or zip = '33747' or zip = '33747' or zip = '33755' or zip = '33756' or zip = '33756' or zip = '33757' or zip = '33758' or zip = '33759' or zip = '33760' or zip = '33761' or zip = '33762' or zip = '33763' or zip = '34637' or zip = '34638' or zip = '34639' or zip = '34639' or zip = '34652' or zip = '34652' or zip = '34652' or zip = '34652' or zip = '34653' or zip = '34653' or zip = '34653' or zip = '34654' or zip = '34654' or zip = '34654' or zip = '34655' or zip = '34684' or zip = '34685' or zip = '34688' or zip = '34688' or zip = '34688' or zip = '34689' or zip = '34689' or zip = '34689' or zip = '34690' or zip = '34690' or zip = '34690' or zip = '34690' or zip = '34691' or zip = '34691' or zip = '34691' or zip = '34691' or zip = '34692' or zip = '34692' or zip = '34695' or zip = '34697' or zip = '34698' or zip = '34655' or zip = '34655' or zip = '34655' or zip = '34655' or zip = '34656' or zip = '34656' or zip = '34656' or zip = '34660' or zip = '34668' or zip = '34673' or zip = '34677' or zip = '34680' or zip = '34681' or zip = '34682' or zip = '34683' or zip = '33501' or zip = '33503' or zip = '33509' or zip = '33510' or zip = '33511' or zip = '33527' or zip = '33534' or zip = '33537' or zip = '33543' or zip = '33544' or zip = '33548' or zip = '33549' or zip = '33550' or zip = '33556' or zip = '33558' or zip = '33559' or zip = '33568' or zip = '33569' or zip = '33570' or zip = '33571' or zip = '33572' or zip = '33573' or zip = '33583' or zip = '33584' or zip = '33586' or zip = '33587' or zip = '33592' or zip = '33593' or zip = '33594' or zip = '33595' or zip = '33601' or zip = '33602' or zip = '33603' or zip = '33604' or zip = '33605' or zip = '33606' or zip = '33607' or zip = '33608' or zip = '33609' or zip = '33610' or zip = '33611' or zip = '33612' or zip = '33613' or zip = '33614' or zip = '33615' or zip = '33616' or zip = '33617' or zip = '33618' or zip = '33619' or zip = '33620' or zip = '33621' or zip = '33622' or zip = '33623' or zip = '33624' or zip = '33625' or zip = '33626' or zip = '33629' or zip = '33630' or zip = '33631' or zip = '33633' or zip = '33634' or zip = '33635' or zip = '33637' or zip = '33643' or zip = '33647' or zip = '33650' or zip = '33651' or zip = '33655' or zip = '33659' or zip = '33660' or zip = '33661' or zip = '33662' or zip = '33663' or zip = '33664' or zip = '33672' or zip = '33673' or zip = '33674' or zip = '33675' or zip = '33677' or zip = '33679' or zip = '33680' or zip = '33681' or zip = '33682' or zip = '33684' or zip = '33685' or zip = '33686' or zip = '33687' or zip = '33688' or zip = '33689' or zip = '33690' or zip = '33694' or zip = '33697' or zip = '33701' or zip = '33702' or zip = '33703' or zip = '33704' or zip = '33705' or zip = '33706' or zip = '33707' or zip = '33708' or zip = '33709' or zip = '33710' or zip = '33711' or zip = '33712' or zip = '33713' or zip = '33714' or zip = '33715' or zip = '33716' or zip = '33728' or zip = '33729' or zip = '33730' or zip = '33731' or zip = '33732' or zip = '33733' or zip = '33734' or zip = '33736' or zip = '33737' or zip = '33738' or zip = '33740' or zip = '33741' or zip = '33742' or zip = '33743' or zip = '33744' or zip = '33747' or zip = '33755' or zip = '33756' or zip = '33757' or zip = '33758' or zip = '33759' or zip = '33760' or zip = '33761' or zip = '33762' or zip = '33763' or zip = '33764' or zip = '33765' or zip = '33766' or zip = '33767' or zip = '33769' or zip = '33770' or zip = '33771' or zip = '33772' or zip = '33773' or zip = '33774' or zip = '33775' or zip = '33776' or zip = '33777' or zip = '33778' or zip = '33779' or zip = '33780' or zip = '33781' or zip = '33782' or zip = '33784' or zip = '33785' or zip = '33786' or zip = '34639' or zip = '34652' or zip = '34653' or zip = '34654' or zip = '34655' or zip = '34656' or zip = '34660' or zip = '34668' or zip = '34669' or zip = '34673' or zip = '34674' or zip = '34677' or zip = '34678' or zip = '34680' or zip = '34681' or zip = '34682' or zip = '34683' or zip = '34684' or zip = '34685' or zip = '34688' or zip = '34689' or zip = '34690' or zip = '34691' or zip = '34695' or zip = '34697' or zip = '34698' or zip = '34869')
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 = 'FL' and city = 'TAMPA' and state = 'FL ' 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();