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


822+ High Potential Investor Deals Near fort lauderdale [Refine]


********NOTICE: Displaying 99 of over 822 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 ='33002' or zipCode = '33004' or zipCode = '33004' or zipCode = '33008' or zipCode = '33008' or zipCode = '33008' or zipCode = '33009' or zipCode = '33009' or zipCode = '33009' or zipCode = '33009' or zipCode = '33009' or zipCode = '33010' or zipCode = '33010' or zipCode = '33010' or zipCode = '33011' or zipCode = '33011' or zipCode = '33012' or zipCode = '33012' or zipCode = '33013' or zipCode = '33013' or zipCode = '33014' or zipCode = '33014' or zipCode = '33014' or zipCode = '33014' or zipCode = '33014' or zipCode = '33014' or zipCode = '33015' or zipCode = '33015' or zipCode = '33015' or zipCode = '33015' or zipCode = '33015' or zipCode = '33015' or zipCode = '33016' or zipCode = '33016' or zipCode = '33016' or zipCode = '33016' or zipCode = '33016' or zipCode = '33017' or zipCode = '33017' or zipCode = '33017' or zipCode = '33018' or zipCode = '33018' or zipCode = '33018' or zipCode = '33018' or zipCode = '33018' or zipCode = '33019' or zipCode = '33019' or zipCode = '33020' or zipCode = '33020' or zipCode = '33021' or zipCode = '33021' or zipCode = '33022' or zipCode = '33022' or zipCode = '33023' or zipCode = '33023' or zipCode = '33023' or zipCode = '33023' or zipCode = '33023' or zipCode = '33023' or zipCode = '33023' or zipCode = '33023' or zipCode = '33024' or zipCode = '33024' or zipCode = '33024' or zipCode = '33024' or zipCode = '33024' or zipCode = '33024' or zipCode = '33025' or zipCode = '33025' or zipCode = '33025' or zipCode = '33025' or zipCode = '33026' or zipCode = '33026' or zipCode = '33026' or zipCode = '33026' or zipCode = '33026' or zipCode = '33027' or zipCode = '33027' or zipCode = '33027' or zipCode = '33027' or zipCode = '33028' or zipCode = '33028' or zipCode = '33028' or zipCode = '33028' or zipCode = '33029' or zipCode = '33029' or zipCode = '33029' or zipCode = '33029' or zipCode = '33029' or zipCode = '33054' or zipCode = '33054' or zipCode = '33054' or zipCode = '33055' or zipCode = '33055' or zipCode = '33055' or zipCode = '33055' or zipCode = '33056' or zipCode = '33056' or zipCode = '33056' or zipCode = '33056' or zipCode = '33060' or zipCode = '33061' or zipCode = '33062' or zipCode = '33068' or zipCode = '33068' or zipCode = '33069' or zipCode = '33069' or zipCode = '33071' or zipCode = '33071' or zipCode = '33072' or zipCode = '33073' or zipCode = '33073' or zipCode = '33073' or zipCode = '33073' or zipCode = '33073' or zipCode = '33073' or zipCode = '33074' or zipCode = '33074' or zipCode = '33074' or zipCode = '33074' or zipCode = '33075' or zipCode = '33075' or zipCode = '33076' or zipCode = '33076' or zipCode = '33076' or zipCode = '33076' or zipCode = '33077' or zipCode = '33077' or zipCode = '33081' or zipCode = '33081' or zipCode = '33081' or zipCode = '33082' or zipCode = '33082' or zipCode = '33082' or zipCode = '33082' or zipCode = '33083' or zipCode = '33083' or zipCode = '33083' or zipCode = '33084' or zipCode = '33084' or zipCode = '33084' or zipCode = '33093' or zipCode = '33093' or zipCode = '33093' or zipCode = '33093' or zipCode = '33097' or zipCode = '33097' or zipCode = '33101' or zipCode = '33102' or zipCode = '33109' or zipCode = '33109' or zipCode = '33109' or zipCode = '33111' or zipCode = '33112' or zipCode = '33112' or zipCode = '33116' or zipCode = '33119' or zipCode = '33119' or zipCode = '33122' or zipCode = '33122' or zipCode = '33122' or zipCode = '33122' or zipCode = '33138' or zipCode = '33139' or zipCode = '33139' or zipCode = '33139' or zipCode = '33139' or zipCode = '33140' or zipCode = '33140' or zipCode = '33140' or zipCode = '33141' or zipCode = '33141' or zipCode = '33141' or zipCode = '33141' or zipCode = '33141' or zipCode = '33141' or zipCode = '33142' or zipCode = '33062' or zipCode = '33062' or zipCode = '33062' or zipCode = '33062' or zipCode = '33063' or zipCode = '33063' or zipCode = '33063' or zipCode = '33064' or zipCode = '33064' or zipCode = '33064' or zipCode = '33064' or zipCode = '33064' or zipCode = '33065' or zipCode = '33065' or zipCode = '33065' or zipCode = '33066' or zipCode = '33066' or zipCode = '33067' or zipCode = '33067' or zipCode = '33067' or zipCode = '33068' or zipCode = '33068' or zipCode = '33125' or zipCode = '33127' or zipCode = '33128' or zipCode = '33130' or zipCode = '33131' or zipCode = '33132' or zipCode = '33132' or zipCode = '33136' or zipCode = '33137' or zipCode = '33138' or zipCode = '33138' or zipCode = '33147' or zipCode = '33147' or zipCode = '33150' or zipCode = '33150' or zipCode = '33150' or zipCode = '33151' or zipCode = '33152' or zipCode = '33153' or zipCode = '33153' or zipCode = '33154' or zipCode = '33154' or zipCode = '33154' or zipCode = '33154' or zipCode = '33154' or zipCode = '33154' or zipCode = '33154' or zipCode = '33154' or zipCode = '33154' or zipCode = '33159' or zipCode = '33160' or zipCode = '33160' or zipCode = '33160' or zipCode = '33160' or zipCode = '33160' or zipCode = '33160' or zipCode = '33160' or zipCode = '33160' or zipCode = '33161' or zipCode = '33161' or zipCode = '33161' or zipCode = '33161' or zipCode = '33161' or zipCode = '33161' or zipCode = '33161' or zipCode = '33162' or zipCode = '33162' or zipCode = '33162' or zipCode = '33162' or zipCode = '33162' or zipCode = '33162' or zipCode = '33162' or zipCode = '33162' or zipCode = '33163' or zipCode = '33163' or zipCode = '33164' or zipCode = '33164' or zipCode = '33166' or zipCode = '33166' or zipCode = '33166' or zipCode = '33166' or zipCode = '33166' or zipCode = '33166' or zipCode = '33166' or zipCode = '33167' or zipCode = '33167' or zipCode = '33167' or zipCode = '33168' or zipCode = '33168' or zipCode = '33168' or zipCode = '33169' or zipCode = '33169' or zipCode = '33169' or zipCode = '33169' or zipCode = '33169' or zipCode = '33188' or zipCode = '33188' or zipCode = '33238' or zipCode = '33239' or zipCode = '33239' or zipCode = '33239' or zipCode = '33242' or zipCode = '33243' or zipCode = '33243' or zipCode = '33245' or zipCode = '33247' or zipCode = '33257' or zipCode = '33257' or zipCode = '33257' or zipCode = '33261' or zipCode = '33261' or zipCode = '33261' or zipCode = '33261' or zipCode = '33261' or zipCode = '33265' or zipCode = '33265' or zipCode = '33265' or zipCode = '33266' or zipCode = '33266' or zipCode = '33269' or zipCode = '33280' or zipCode = '33280' or zipCode = '33280' or zipCode = '33299' or zipCode = '33301' or zipCode = '33301' or zipCode = '33302' or zipCode = '33308' or zipCode = '33308' or zipCode = '33308' or zipCode = '33308' or zipCode = '33309' or zipCode = '33309' or zipCode = '33309' or zipCode = '33309' or zipCode = '33309' or zipCode = '33309' or zipCode = '33309' or zipCode = '33310' or zipCode = '33310' or zipCode = '33310' or zipCode = '33311' or zipCode = '33311' or zipCode = '33311' or zipCode = '33311' or zipCode = '33311' or zipCode = '33311' or zipCode = '33311' or zipCode = '33311' or zipCode = '33314' or zipCode = '33315' or zipCode = '33315' or zipCode = '33316' or zipCode = '33316' or zipCode = '33316' or zipCode = '33316' or zipCode = '33317' or zipCode = '33317' or zipCode = '33317' or zipCode = '33317' or zipCode = '33318' or zipCode = '33318' or zipCode = '33318' or zipCode = '33319' or zipCode = '33319' or zipCode = '33319' or zipCode = '33319' or zipCode = '33319' or zipCode = '33319' or zipCode = '33319' or zipCode = '33319' or zipCode = '33324' or zipCode = '33324' or zipCode = '33324' or zipCode = '33324' or zipCode = '33325' or zipCode = '33325' or zipCode = '33325' or zipCode = '33325' or zipCode = '33325' or zipCode = '33325' or zipCode = '33326' or zipCode = '33326' or zipCode = '33326' or zipCode = '33326' or zipCode = '33326' or zipCode = '33326' or zipCode = '33326' or zipCode = '33326' or zipCode = '33327' or zipCode = '33327' or zipCode = '33327' or zipCode = '33327' or zipCode = '33179' or zipCode = '33179' or zipCode = '33179' or zipCode = '33179' or zipCode = '33180' or zipCode = '33180' or zipCode = '33180' or zipCode = '33180' or zipCode = '33180' or zipCode = '33181' or zipCode = '33181' or zipCode = '33181' or zipCode = '33181' or zipCode = '33181' or zipCode = '33181' or zipCode = '33197' or zipCode = '33197' or zipCode = '33231' or zipCode = '33231' or zipCode = '33302' or zipCode = '33303' or zipCode = '33303' or zipCode = '33304' or zipCode = '33304' or zipCode = '33304' or zipCode = '33304' or zipCode = '33305' or zipCode = '33305' or zipCode = '33305' or zipCode = '33305' or zipCode = '33305' or zipCode = '33306' or zipCode = '33306' or zipCode = '33306' or zipCode = '33306' or zipCode = '33307' or zipCode = '33307' or zipCode = '33307' or zipCode = '33308' or zipCode = '33308' or zipCode = '33308' or zipCode = '33312' or zipCode = '33312' or zipCode = '33312' or zipCode = '33312' or zipCode = '33312' or zipCode = '33312' or zipCode = '33312' or zipCode = '33312' or zipCode = '33312' or zipCode = '33313' or zipCode = '33313' or zipCode = '33313' or zipCode = '33313' or zipCode = '33313' or zipCode = '33313' or zipCode = '33313' or zipCode = '33313' or zipCode = '33313' or zipCode = '33314' or zipCode = '33314' or zipCode = '33314' or zipCode = '33314' or zipCode = '33319' or zipCode = '33319' or zipCode = '33319' or zipCode = '33320' or zipCode = '33320' or zipCode = '33320' or zipCode = '33321' or zipCode = '33321' or zipCode = '33321' or zipCode = '33321' or zipCode = '33321' or zipCode = '33321' or zipCode = '33321' or zipCode = '33322' or zipCode = '33322' or zipCode = '33322' or zipCode = '33322' or zipCode = '33323' or zipCode = '33323' or zipCode = '33323' or zipCode = '33323' or zipCode = '33323' or zipCode = '33328' or zipCode = '33328' or zipCode = '33328' or zipCode = '33328' or zipCode = '33329' or zipCode = '33329' or zipCode = '33329' or zipCode = '33329' or zipCode = '33330' or zipCode = '33330' or zipCode = '33330' or zipCode = '33330' or zipCode = '33330' or zipCode = '33330' or zipCode = '33330' or zipCode = '33330' or zipCode = '33330' or zipCode = '33331' or zipCode = '33331' or zipCode = '33331' or zipCode = '33331' or zipCode = '33331' or zipCode = '33337' or zipCode = '33337' or zipCode = '33337' or zipCode = '33338' or zipCode = '33338' or zipCode = '33338' or zipCode = '33339' or zipCode = '33339' or zipCode = '33340' or zipCode = '33340' or zipCode = '33345' or zipCode = '33345' or zipCode = '33345' or zipCode = '33346' or zipCode = '33346' or zipCode = '33348' or zipCode = '33348' or zipCode = '33349' or zipCode = '33349' or zipCode = '33351' or zipCode = '33351' or zipCode = '33351' or zipCode = '33351' or zipCode = '33351' or zipCode = '33355' or zipCode = '33355' or zipCode = '33355' or zipCode = '33355' or zipCode = '33355' or zipCode = '33359' or zipCode = '33359' or zipCode = '33359' or zipCode = '33359' or zipCode = '33388' or zipCode = '33388' or zipCode = '33388' or zipCode = '33388' or zipCode = '33394' or zipCode = '33394' or zipCode = '33394' or zipCode = '33394' or zipCode = '33331' or zipCode = '33331' or zipCode = '33331' or zipCode = '33332' or zipCode = '33332' or zipCode = '33332' or zipCode = '33332' or zipCode = '33332' or zipCode = '33332' or zipCode = '33332' or zipCode = '33332' or zipCode = '33332' or zipCode = '33334' or zipCode = '33334' or zipCode = '33334' or zipCode = '33334' or zipCode = '33335' or zipCode = '33335' or zipCode = '33336' or zipCode = '33336' or zipCode = '33336' or zipCode = '33337' or zipCode = '33427' or zipCode = '33428' or zipCode = '33429' or zipCode = '33431' or zipCode = '33432' or zipCode = '33433' or zipCode = '33434' or zipCode = '33441' or zipCode = '33441' or zipCode = '33482' or zipCode = '33483' or zipCode = '33483' or zipCode = '33484' or zipCode = '33484' or zipCode = '33484' or zipCode = '33486' or zipCode = '33487' or zipCode = '33487' or zipCode = '33487' or zipCode = '33488' or zipCode = '33496' or zipCode = '33497' or zipCode = '33498' or zipCode = '33499' or zipCode = '33442' or zipCode = '33442' or zipCode = '33443' or zipCode = '33443' or zipCode = '33444' or zipCode = '33445' or zipCode = '33446' or zipCode = '33446' or zipCode = '33446' or zipCode = '33447' or zipCode = '33448' or zipCode = '33448' or zipCode = '33448' or zipCode = '33481' or zipCode = '33004' or zipCode = '33008' or zipCode = '33009' or zipCode = '33010' or zipCode = '33012' or zipCode = '33013' or zipCode = '33014' or zipCode = '33015' or zipCode = '33016' or zipCode = '33018' or zipCode = '33019' or zipCode = '33020' or zipCode = '33021' or zipCode = '33022' or zipCode = '33023' or zipCode = '33024' or zipCode = '33025' or zipCode = '33026' or zipCode = '33027' or zipCode = '33028' or zipCode = '33029' or zipCode = '33047' or zipCode = '33054' or zipCode = '33055' or zipCode = '33056' or zipCode = '33058' or zipCode = '33060' or zipCode = '33061' or zipCode = '33062' or zipCode = '33063' or zipCode = '33064' or zipCode = '33065' or zipCode = '33066' or zipCode = '33067' or zipCode = '33068' or zipCode = '33069' or zipCode = '33071' or zipCode = '33072' or zipCode = '33073' or zipCode = '33074' or zipCode = '33075' or zipCode = '33076' or zipCode = '33077' or zipCode = '33081' or zipCode = '33082' or zipCode = '33083' or zipCode = '33084' or zipCode = '33093' or zipCode = '33097' or zipCode = '33101' or zipCode = '33109' or zipCode = '33110' or zipCode = '33119' or zipCode = '33125' or zipCode = '33127' or zipCode = '33128' or zipCode = '33130' or zipCode = '33131' or zipCode = '33132' or zipCode = '33136' or zipCode = '33137' or zipCode = '33138' or zipCode = '33139' or zipCode = '33140' or zipCode = '33141' or zipCode = '33142' or zipCode = '33147' or zipCode = '33150' or zipCode = '33151' or zipCode = '33153' or zipCode = '33154' or zipCode = '33160' or zipCode = '33161' or zipCode = '33162' or zipCode = '33163' or zipCode = '33166' or zipCode = '33167' or zipCode = '33168' or zipCode = '33169' or zipCode = '33178' or zipCode = '33179' or zipCode = '33180' or zipCode = '33181' or zipCode = '33195' or zipCode = '33201' or zipCode = '33301' or zipCode = '33302' or zipCode = '33303' or zipCode = '33304' or zipCode = '33305' or zipCode = '33306' or zipCode = '33307' or zipCode = '33308' or zipCode = '33309' or zipCode = '33310' or zipCode = '33311' or zipCode = '33312' or zipCode = '33313' or zipCode = '33314' or zipCode = '33315' or zipCode = '33316' or zipCode = '33317' or zipCode = '33318' or zipCode = '33319' or zipCode = '33320' or zipCode = '33321' or zipCode = '33322' or zipCode = '33323' or zipCode = '33324' or zipCode = '33325' or zipCode = '33326' or zipCode = '33327' or zipCode = '33328' or zipCode = '33329' or zipCode = '33330' or zipCode = '33331' or zipCode = '33332' or zipCode = '33334' or zipCode = '33335' or zipCode = '33337' or zipCode = '33338' or zipCode = '33339' or zipCode = '33340' or zipCode = '33345' or zipCode = '33346' or zipCode = '33348' or zipCode = '33349' or zipCode = '33351' or zipCode = '33352' or zipCode = '33355' or zipCode = '33359' or zipCode = '33388' or zipCode = '33394' or zipCode = '33427' or zipCode = '33428' or zipCode = '33431' or zipCode = '33432' or zipCode = '33433' or zipCode = '33434' or zipCode = '33441' or zipCode = '33442' or zipCode = '33443' or zipCode = '33444' or zipCode = '33445' or zipCode = '33446' or zipCode = '33483' or zipCode = '33484' or zipCode = '33486' or zipCode = '33487' or zipCode = '33496' or zipCode = '33498' or zipCode = '33515')
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 ='33002' or zipCode = '33004' or zipCode = '33004' or zipCode = '33008' or zipCode = '33008' or zipCode = '33008' or zipCode = '33009' or zipCode = '33009' or zipCode = '33009' or zipCode = '33009' or zipCode = '33009' or zipCode = '33010' or zipCode = '33010' or zipCode = '33010' or zipCode = '33011' or zipCode = '33011' or zipCode = '33012' or zipCode = '33012' or zipCode = '33013' or zipCode = '33013' or zipCode = '33014' or zipCode = '33014' or zipCode = '33014' or zipCode = '33014' or zipCode = '33014' or zipCode = '33014' or zipCode = '33015' or zipCode = '33015' or zipCode = '33015' or zipCode = '33015' or zipCode = '33015' or zipCode = '33015' or zipCode = '33016' or zipCode = '33016' or zipCode = '33016' or zipCode = '33016' or zipCode = '33016' or zipCode = '33017' or zipCode = '33017' or zipCode = '33017' or zipCode = '33018' or zipCode = '33018' or zipCode = '33018' or zipCode = '33018' or zipCode = '33018' or zipCode = '33019' or zipCode = '33019' or zipCode = '33020' or zipCode = '33020' or zipCode = '33021' or zipCode = '33021' or zipCode = '33022' or zipCode = '33022' or zipCode = '33023' or zipCode = '33023' or zipCode = '33023' or zipCode = '33023' or zipCode = '33023' or zipCode = '33023' or zipCode = '33023' or zipCode = '33023' or zipCode = '33024' or zipCode = '33024' or zipCode = '33024' or zipCode = '33024' or zipCode = '33024' or zipCode = '33024' or zipCode = '33025' or zipCode = '33025' or zipCode = '33025' or zipCode = '33025' or zipCode = '33026' or zipCode = '33026' or zipCode = '33026' or zipCode = '33026' or zipCode = '33026' or zipCode = '33027' or zipCode = '33027' or zipCode = '33027' or zipCode = '33027' or zipCode = '33028' or zipCode = '33028' or zipCode = '33028' or zipCode = '33028' or zipCode = '33029' or zipCode = '33029' or zipCode = '33029' or zipCode = '33029' or zipCode = '33029' or zipCode = '33054' or zipCode = '33054' or zipCode = '33054' or zipCode = '33055' or zipCode = '33055' or zipCode = '33055' or zipCode = '33055' or zipCode = '33056' or zipCode = '33056' or zipCode = '33056' or zipCode = '33056' or zipCode = '33060' or zipCode = '33061' or zipCode = '33062' or zipCode = '33068' or zipCode = '33068' or zipCode = '33069' or zipCode = '33069' or zipCode = '33071' or zipCode = '33071' or zipCode = '33072' or zipCode = '33073' or zipCode = '33073' or zipCode = '33073' or zipCode = '33073' or zipCode = '33073' or zipCode = '33073' or zipCode = '33074' or zipCode = '33074' or zipCode = '33074' or zipCode = '33074' or zipCode = '33075' or zipCode = '33075' or zipCode = '33076' or zipCode = '33076' or zipCode = '33076' or zipCode = '33076' or zipCode = '33077' or zipCode = '33077' or zipCode = '33081' or zipCode = '33081' or zipCode = '33081' or zipCode = '33082' or zipCode = '33082' or zipCode = '33082' or zipCode = '33082' or zipCode = '33083' or zipCode = '33083' or zipCode = '33083' or zipCode = '33084' or zipCode = '33084' or zipCode = '33084' or zipCode = '33093' or zipCode = '33093' or zipCode = '33093' or zipCode = '33093' or zipCode = '33097' or zipCode = '33097' or zipCode = '33101' or zipCode = '33102' or zipCode = '33109' or zipCode = '33109' or zipCode = '33109' or zipCode = '33111' or zipCode = '33112' or zipCode = '33112' or zipCode = '33116' or zipCode = '33119' or zipCode = '33119' or zipCode = '33122' or zipCode = '33122' or zipCode = '33122' or zipCode = '33122' or zipCode = '33138' or zipCode = '33139' or zipCode = '33139' or zipCode = '33139' or zipCode = '33139' or zipCode = '33140' or zipCode = '33140' or zipCode = '33140' or zipCode = '33141' or zipCode = '33141' or zipCode = '33141' or zipCode = '33141' or zipCode = '33141' or zipCode = '33141' or zipCode = '33142' or zipCode = '33062' or zipCode = '33062' or zipCode = '33062' or zipCode = '33062' or zipCode = '33063' or zipCode = '33063' or zipCode = '33063' or zipCode = '33064' or zipCode = '33064' or zipCode = '33064' or zipCode = '33064' or zipCode = '33064' or zipCode = '33065' or zipCode = '33065' or zipCode = '33065' or zipCode = '33066' or zipCode = '33066' or zipCode = '33067' or zipCode = '33067' or zipCode = '33067' or zipCode = '33068' or zipCode = '33068' or zipCode = '33125' or zipCode = '33127' or zipCode = '33128' or zipCode = '33130' or zipCode = '33131' or zipCode = '33132' or zipCode = '33132' or zipCode = '33136' or zipCode = '33137' or zipCode = '33138' or zipCode = '33138' or zipCode = '33147' or zipCode = '33147' or zipCode = '33150' or zipCode = '33150' or zipCode = '33150' or zipCode = '33151' or zipCode = '33152' or zipCode = '33153' or zipCode = '33153' or zipCode = '33154' or zipCode = '33154' or zipCode = '33154' or zipCode = '33154' or zipCode = '33154' or zipCode = '33154' or zipCode = '33154' or zipCode = '33154' or zipCode = '33154' or zipCode = '33159' or zipCode = '33160' or zipCode = '33160' or zipCode = '33160' or zipCode = '33160' or zipCode = '33160' or zipCode = '33160' or zipCode = '33160' or zipCode = '33160' or zipCode = '33161' or zipCode = '33161' or zipCode = '33161' or zipCode = '33161' or zipCode = '33161' or zipCode = '33161' or zipCode = '33161' or zipCode = '33162' or zipCode = '33162' or zipCode = '33162' or zipCode = '33162' or zipCode = '33162' or zipCode = '33162' or zipCode = '33162' or zipCode = '33162' or zipCode = '33163' or zipCode = '33163' or zipCode = '33164' or zipCode = '33164' or zipCode = '33166' or zipCode = '33166' or zipCode = '33166' or zipCode = '33166' or zipCode = '33166' or zipCode = '33166' or zipCode = '33166' or zipCode = '33167' or zipCode = '33167' or zipCode = '33167' or zipCode = '33168' or zipCode = '33168' or zipCode = '33168' or zipCode = '33169' or zipCode = '33169' or zipCode = '33169' or zipCode = '33169' or zipCode = '33169' or zipCode = '33188' or zipCode = '33188' or zipCode = '33238' or zipCode = '33239' or zipCode = '33239' or zipCode = '33239' or zipCode = '33242' or zipCode = '33243' or zipCode = '33243' or zipCode = '33245' or zipCode = '33247' or zipCode = '33257' or zipCode = '33257' or zipCode = '33257' or zipCode = '33261' or zipCode = '33261' or zipCode = '33261' or zipCode = '33261' or zipCode = '33261' or zipCode = '33265' or zipCode = '33265' or zipCode = '33265' or zipCode = '33266' or zipCode = '33266' or zipCode = '33269' or zipCode = '33280' or zipCode = '33280' or zipCode = '33280' or zipCode = '33299' or zipCode = '33301' or zipCode = '33301' or zipCode = '33302' or zipCode = '33308' or zipCode = '33308' or zipCode = '33308' or zipCode = '33308' or zipCode = '33309' or zipCode = '33309' or zipCode = '33309' or zipCode = '33309' or zipCode = '33309' or zipCode = '33309' or zipCode = '33309' or zipCode = '33310' or zipCode = '33310' or zipCode = '33310' or zipCode = '33311' or zipCode = '33311' or zipCode = '33311' or zipCode = '33311' or zipCode = '33311' or zipCode = '33311' or zipCode = '33311' or zipCode = '33311' or zipCode = '33314' or zipCode = '33315' or zipCode = '33315' or zipCode = '33316' or zipCode = '33316' or zipCode = '33316' or zipCode = '33316' or zipCode = '33317' or zipCode = '33317' or zipCode = '33317' or zipCode = '33317' or zipCode = '33318' or zipCode = '33318' or zipCode = '33318' or zipCode = '33319' or zipCode = '33319' or zipCode = '33319' or zipCode = '33319' or zipCode = '33319' or zipCode = '33319' or zipCode = '33319' or zipCode = '33319' or zipCode = '33324' or zipCode = '33324' or zipCode = '33324' or zipCode = '33324' or zipCode = '33325' or zipCode = '33325' or zipCode = '33325' or zipCode = '33325' or zipCode = '33325' or zipCode = '33325' or zipCode = '33326' or zipCode = '33326' or zipCode = '33326' or zipCode = '33326' or zipCode = '33326' or zipCode = '33326' or zipCode = '33326' or zipCode = '33326' or zipCode = '33327' or zipCode = '33327' or zipCode = '33327' or zipCode = '33327' or zipCode = '33179' or zipCode = '33179' or zipCode = '33179' or zipCode = '33179' or zipCode = '33180' or zipCode = '33180' or zipCode = '33180' or zipCode = '33180' or zipCode = '33180' or zipCode = '33181' or zipCode = '33181' or zipCode = '33181' or zipCode = '33181' or zipCode = '33181' or zipCode = '33181' or zipCode = '33197' or zipCode = '33197' or zipCode = '33231' or zipCode = '33231' or zipCode = '33302' or zipCode = '33303' or zipCode = '33303' or zipCode = '33304' or zipCode = '33304' or zipCode = '33304' or zipCode = '33304' or zipCode = '33305' or zipCode = '33305' or zipCode = '33305' or zipCode = '33305' or zipCode = '33305' or zipCode = '33306' or zipCode = '33306' or zipCode = '33306' or zipCode = '33306' or zipCode = '33307' or zipCode = '33307' or zipCode = '33307' or zipCode = '33308' or zipCode = '33308' or zipCode = '33308' or zipCode = '33312' or zipCode = '33312' or zipCode = '33312' or zipCode = '33312' or zipCode = '33312' or zipCode = '33312' or zipCode = '33312' or zipCode = '33312' or zipCode = '33312' or zipCode = '33313' or zipCode = '33313' or zipCode = '33313' or zipCode = '33313' or zipCode = '33313' or zipCode = '33313' or zipCode = '33313' or zipCode = '33313' or zipCode = '33313' or zipCode = '33314' or zipCode = '33314' or zipCode = '33314' or zipCode = '33314' or zipCode = '33319' or zipCode = '33319' or zipCode = '33319' or zipCode = '33320' or zipCode = '33320' or zipCode = '33320' or zipCode = '33321' or zipCode = '33321' or zipCode = '33321' or zipCode = '33321' or zipCode = '33321' or zipCode = '33321' or zipCode = '33321' or zipCode = '33322' or zipCode = '33322' or zipCode = '33322' or zipCode = '33322' or zipCode = '33323' or zipCode = '33323' or zipCode = '33323' or zipCode = '33323' or zipCode = '33323' or zipCode = '33328' or zipCode = '33328' or zipCode = '33328' or zipCode = '33328' or zipCode = '33329' or zipCode = '33329' or zipCode = '33329' or zipCode = '33329' or zipCode = '33330' or zipCode = '33330' or zipCode = '33330' or zipCode = '33330' or zipCode = '33330' or zipCode = '33330' or zipCode = '33330' or zipCode = '33330' or zipCode = '33330' or zipCode = '33331' or zipCode = '33331' or zipCode = '33331' or zipCode = '33331' or zipCode = '33331' or zipCode = '33337' or zipCode = '33337' or zipCode = '33337' or zipCode = '33338' or zipCode = '33338' or zipCode = '33338' or zipCode = '33339' or zipCode = '33339' or zipCode = '33340' or zipCode = '33340' or zipCode = '33345' or zipCode = '33345' or zipCode = '33345' or zipCode = '33346' or zipCode = '33346' or zipCode = '33348' or zipCode = '33348' or zipCode = '33349' or zipCode = '33349' or zipCode = '33351' or zipCode = '33351' or zipCode = '33351' or zipCode = '33351' or zipCode = '33351' or zipCode = '33355' or zipCode = '33355' or zipCode = '33355' or zipCode = '33355' or zipCode = '33355' or zipCode = '33359' or zipCode = '33359' or zipCode = '33359' or zipCode = '33359' or zipCode = '33388' or zipCode = '33388' or zipCode = '33388' or zipCode = '33388' or zipCode = '33394' or zipCode = '33394' or zipCode = '33394' or zipCode = '33394' or zipCode = '33331' or zipCode = '33331' or zipCode = '33331' or zipCode = '33332' or zipCode = '33332' or zipCode = '33332' or zipCode = '33332' or zipCode = '33332' or zipCode = '33332' or zipCode = '33332' or zipCode = '33332' or zipCode = '33332' or zipCode = '33334' or zipCode = '33334' or zipCode = '33334' or zipCode = '33334' or zipCode = '33335' or zipCode = '33335' or zipCode = '33336' or zipCode = '33336' or zipCode = '33336' or zipCode = '33337' or zipCode = '33427' or zipCode = '33428' or zipCode = '33429' or zipCode = '33431' or zipCode = '33432' or zipCode = '33433' or zipCode = '33434' or zipCode = '33441' or zipCode = '33441' or zipCode = '33482' or zipCode = '33483' or zipCode = '33483' or zipCode = '33484' or zipCode = '33484' or zipCode = '33484' or zipCode = '33486' or zipCode = '33487' or zipCode = '33487' or zipCode = '33487' or zipCode = '33488' or zipCode = '33496' or zipCode = '33497' or zipCode = '33498' or zipCode = '33499' or zipCode = '33442' or zipCode = '33442' or zipCode = '33443' or zipCode = '33443' or zipCode = '33444' or zipCode = '33445' or zipCode = '33446' or zipCode = '33446' or zipCode = '33446' or zipCode = '33447' or zipCode = '33448' or zipCode = '33448' or zipCode = '33448' or zipCode = '33481' or zipCode = '33004' or zipCode = '33008' or zipCode = '33009' or zipCode = '33010' or zipCode = '33012' or zipCode = '33013' or zipCode = '33014' or zipCode = '33015' or zipCode = '33016' or zipCode = '33018' or zipCode = '33019' or zipCode = '33020' or zipCode = '33021' or zipCode = '33022' or zipCode = '33023' or zipCode = '33024' or zipCode = '33025' or zipCode = '33026' or zipCode = '33027' or zipCode = '33028' or zipCode = '33029' or zipCode = '33047' or zipCode = '33054' or zipCode = '33055' or zipCode = '33056' or zipCode = '33058' or zipCode = '33060' or zipCode = '33061' or zipCode = '33062' or zipCode = '33063' or zipCode = '33064' or zipCode = '33065' or zipCode = '33066' or zipCode = '33067' or zipCode = '33068' or zipCode = '33069' or zipCode = '33071' or zipCode = '33072' or zipCode = '33073' or zipCode = '33074' or zipCode = '33075' or zipCode = '33076' or zipCode = '33077' or zipCode = '33081' or zipCode = '33082' or zipCode = '33083' or zipCode = '33084' or zipCode = '33093' or zipCode = '33097' or zipCode = '33101' or zipCode = '33109' or zipCode = '33110' or zipCode = '33119' or zipCode = '33125' or zipCode = '33127' or zipCode = '33128' or zipCode = '33130' or zipCode = '33131' or zipCode = '33132' or zipCode = '33136' or zipCode = '33137' or zipCode = '33138' or zipCode = '33139' or zipCode = '33140' or zipCode = '33141' or zipCode = '33142' or zipCode = '33147' or zipCode = '33150' or zipCode = '33151' or zipCode = '33153' or zipCode = '33154' or zipCode = '33160' or zipCode = '33161' or zipCode = '33162' or zipCode = '33163' or zipCode = '33166' or zipCode = '33167' or zipCode = '33168' or zipCode = '33169' or zipCode = '33178' or zipCode = '33179' or zipCode = '33180' or zipCode = '33181' or zipCode = '33195' or zipCode = '33201' or zipCode = '33301' or zipCode = '33302' or zipCode = '33303' or zipCode = '33304' or zipCode = '33305' or zipCode = '33306' or zipCode = '33307' or zipCode = '33308' or zipCode = '33309' or zipCode = '33310' or zipCode = '33311' or zipCode = '33312' or zipCode = '33313' or zipCode = '33314' or zipCode = '33315' or zipCode = '33316' or zipCode = '33317' or zipCode = '33318' or zipCode = '33319' or zipCode = '33320' or zipCode = '33321' or zipCode = '33322' or zipCode = '33323' or zipCode = '33324' or zipCode = '33325' or zipCode = '33326' or zipCode = '33327' or zipCode = '33328' or zipCode = '33329' or zipCode = '33330' or zipCode = '33331' or zipCode = '33332' or zipCode = '33334' or zipCode = '33335' or zipCode = '33337' or zipCode = '33338' or zipCode = '33339' or zipCode = '33340' or zipCode = '33345' or zipCode = '33346' or zipCode = '33348' or zipCode = '33349' or zipCode = '33351' or zipCode = '33352' or zipCode = '33355' or zipCode = '33359' or zipCode = '33388' or zipCode = '33394' or zipCode = '33427' or zipCode = '33428' or zipCode = '33431' or zipCode = '33432' or zipCode = '33433' or zipCode = '33434' or zipCode = '33441' or zipCode = '33442' or zipCode = '33443' or zipCode = '33444' or zipCode = '33445' or zipCode = '33446' or zipCode = '33483' or zipCode = '33484' or zipCode = '33486' or zipCode = '33487' or zipCode = '33496' or zipCode = '33498' or zipCode = '33515') 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 ='33002' or zipCode = '33004' or zipCode = '33004' or zipCode = '33008' or zipCode = '33008' or zipCode = '33008' or zipCode = '33009' or zipCode = '33009' or zipCode = '33009' or zipCode = '33009' or zipCode = '33009' or zipCode = '33010' or zipCode = '33010' or zipCode = '33010' or zipCode = '33011' or zipCode = '33011' or zipCode = '33012' or zipCode = '33012' or zipCode = '33013' or zipCode = '33013' or zipCode = '33014' or zipCode = '33014' or zipCode = '33014' or zipCode = '33014' or zipCode = '33014' or zipCode = '33014' or zipCode = '33015' or zipCode = '33015' or zipCode = '33015' or zipCode = '33015' or zipCode = '33015' or zipCode = '33015' or zipCode = '33016' or zipCode = '33016' or zipCode = '33016' or zipCode = '33016' or zipCode = '33016' or zipCode = '33017' or zipCode = '33017' or zipCode = '33017' or zipCode = '33018' or zipCode = '33018' or zipCode = '33018' or zipCode = '33018' or zipCode = '33018' or zipCode = '33019' or zipCode = '33019' or zipCode = '33020' or zipCode = '33020' or zipCode = '33021' or zipCode = '33021' or zipCode = '33022' or zipCode = '33022' or zipCode = '33023' or zipCode = '33023' or zipCode = '33023' or zipCode = '33023' or zipCode = '33023' or zipCode = '33023' or zipCode = '33023' or zipCode = '33023' or zipCode = '33024' or zipCode = '33024' or zipCode = '33024' or zipCode = '33024' or zipCode = '33024' or zipCode = '33024' or zipCode = '33025' or zipCode = '33025' or zipCode = '33025' or zipCode = '33025' or zipCode = '33026' or zipCode = '33026' or zipCode = '33026' or zipCode = '33026' or zipCode = '33026' or zipCode = '33027' or zipCode = '33027' or zipCode = '33027' or zipCode = '33027' or zipCode = '33028' or zipCode = '33028' or zipCode = '33028' or zipCode = '33028' or zipCode = '33029' or zipCode = '33029' or zipCode = '33029' or zipCode = '33029' or zipCode = '33029' or zipCode = '33054' or zipCode = '33054' or zipCode = '33054' or zipCode = '33055' or zipCode = '33055' or zipCode = '33055' or zipCode = '33055' or zipCode = '33056' or zipCode = '33056' or zipCode = '33056' or zipCode = '33056' or zipCode = '33060' or zipCode = '33061' or zipCode = '33062' or zipCode = '33068' or zipCode = '33068' or zipCode = '33069' or zipCode = '33069' or zipCode = '33071' or zipCode = '33071' or zipCode = '33072' or zipCode = '33073' or zipCode = '33073' or zipCode = '33073' or zipCode = '33073' or zipCode = '33073' or zipCode = '33073' or zipCode = '33074' or zipCode = '33074' or zipCode = '33074' or zipCode = '33074' or zipCode = '33075' or zipCode = '33075' or zipCode = '33076' or zipCode = '33076' or zipCode = '33076' or zipCode = '33076' or zipCode = '33077' or zipCode = '33077' or zipCode = '33081' or zipCode = '33081' or zipCode = '33081' or zipCode = '33082' or zipCode = '33082' or zipCode = '33082' or zipCode = '33082' or zipCode = '33083' or zipCode = '33083' or zipCode = '33083' or zipCode = '33084' or zipCode = '33084' or zipCode = '33084' or zipCode = '33093' or zipCode = '33093' or zipCode = '33093' or zipCode = '33093' or zipCode = '33097' or zipCode = '33097' or zipCode = '33101' or zipCode = '33102' or zipCode = '33109' or zipCode = '33109' or zipCode = '33109' or zipCode = '33111' or zipCode = '33112' or zipCode = '33112' or zipCode = '33116' or zipCode = '33119' or zipCode = '33119' or zipCode = '33122' or zipCode = '33122' or zipCode = '33122' or zipCode = '33122' or zipCode = '33138' or zipCode = '33139' or zipCode = '33139' or zipCode = '33139' or zipCode = '33139' or zipCode = '33140' or zipCode = '33140' or zipCode = '33140' or zipCode = '33141' or zipCode = '33141' or zipCode = '33141' or zipCode = '33141' or zipCode = '33141' or zipCode = '33141' or zipCode = '33142' or zipCode = '33062' or zipCode = '33062' or zipCode = '33062' or zipCode = '33062' or zipCode = '33063' or zipCode = '33063' or zipCode = '33063' or zipCode = '33064' or zipCode = '33064' or zipCode = '33064' or zipCode = '33064' or zipCode = '33064' or zipCode = '33065' or zipCode = '33065' or zipCode = '33065' or zipCode = '33066' or zipCode = '33066' or zipCode = '33067' or zipCode = '33067' or zipCode = '33067' or zipCode = '33068' or zipCode = '33068' or zipCode = '33125' or zipCode = '33127' or zipCode = '33128' or zipCode = '33130' or zipCode = '33131' or zipCode = '33132' or zipCode = '33132' or zipCode = '33136' or zipCode = '33137' or zipCode = '33138' or zipCode = '33138' or zipCode = '33147' or zipCode = '33147' or zipCode = '33150' or zipCode = '33150' or zipCode = '33150' or zipCode = '33151' or zipCode = '33152' or zipCode = '33153' or zipCode = '33153' or zipCode = '33154' or zipCode = '33154' or zipCode = '33154' or zipCode = '33154' or zipCode = '33154' or zipCode = '33154' or zipCode = '33154' or zipCode = '33154' or zipCode = '33154' or zipCode = '33159' or zipCode = '33160' or zipCode = '33160' or zipCode = '33160' or zipCode = '33160' or zipCode = '33160' or zipCode = '33160' or zipCode = '33160' or zipCode = '33160' or zipCode = '33161' or zipCode = '33161' or zipCode = '33161' or zipCode = '33161' or zipCode = '33161' or zipCode = '33161' or zipCode = '33161' or zipCode = '33162' or zipCode = '33162' or zipCode = '33162' or zipCode = '33162' or zipCode = '33162' or zipCode = '33162' or zipCode = '33162' or zipCode = '33162' or zipCode = '33163' or zipCode = '33163' or zipCode = '33164' or zipCode = '33164' or zipCode = '33166' or zipCode = '33166' or zipCode = '33166' or zipCode = '33166' or zipCode = '33166' or zipCode = '33166' or zipCode = '33166' or zipCode = '33167' or zipCode = '33167' or zipCode = '33167' or zipCode = '33168' or zipCode = '33168' or zipCode = '33168' or zipCode = '33169' or zipCode = '33169' or zipCode = '33169' or zipCode = '33169' or zipCode = '33169' or zipCode = '33188' or zipCode = '33188' or zipCode = '33238' or zipCode = '33239' or zipCode = '33239' or zipCode = '33239' or zipCode = '33242' or zipCode = '33243' or zipCode = '33243' or zipCode = '33245' or zipCode = '33247' or zipCode = '33257' or zipCode = '33257' or zipCode = '33257' or zipCode = '33261' or zipCode = '33261' or zipCode = '33261' or zipCode = '33261' or zipCode = '33261' or zipCode = '33265' or zipCode = '33265' or zipCode = '33265' or zipCode = '33266' or zipCode = '33266' or zipCode = '33269' or zipCode = '33280' or zipCode = '33280' or zipCode = '33280' or zipCode = '33299' or zipCode = '33301' or zipCode = '33301' or zipCode = '33302' or zipCode = '33308' or zipCode = '33308' or zipCode = '33308' or zipCode = '33308' or zipCode = '33309' or zipCode = '33309' or zipCode = '33309' or zipCode = '33309' or zipCode = '33309' or zipCode = '33309' or zipCode = '33309' or zipCode = '33310' or zipCode = '33310' or zipCode = '33310' or zipCode = '33311' or zipCode = '33311' or zipCode = '33311' or zipCode = '33311' or zipCode = '33311' or zipCode = '33311' or zipCode = '33311' or zipCode = '33311' or zipCode = '33314' or zipCode = '33315' or zipCode = '33315' or zipCode = '33316' or zipCode = '33316' or zipCode = '33316' or zipCode = '33316' or zipCode = '33317' or zipCode = '33317' or zipCode = '33317' or zipCode = '33317' or zipCode = '33318' or zipCode = '33318' or zipCode = '33318' or zipCode = '33319' or zipCode = '33319' or zipCode = '33319' or zipCode = '33319' or zipCode = '33319' or zipCode = '33319' or zipCode = '33319' or zipCode = '33319' or zipCode = '33324' or zipCode = '33324' or zipCode = '33324' or zipCode = '33324' or zipCode = '33325' or zipCode = '33325' or zipCode = '33325' or zipCode = '33325' or zipCode = '33325' or zipCode = '33325' or zipCode = '33326' or zipCode = '33326' or zipCode = '33326' or zipCode = '33326' or zipCode = '33326' or zipCode = '33326' or zipCode = '33326' or zipCode = '33326' or zipCode = '33327' or zipCode = '33327' or zipCode = '33327' or zipCode = '33327' or zipCode = '33179' or zipCode = '33179' or zipCode = '33179' or zipCode = '33179' or zipCode = '33180' or zipCode = '33180' or zipCode = '33180' or zipCode = '33180' or zipCode = '33180' or zipCode = '33181' or zipCode = '33181' or zipCode = '33181' or zipCode = '33181' or zipCode = '33181' or zipCode = '33181' or zipCode = '33197' or zipCode = '33197' or zipCode = '33231' or zipCode = '33231' or zipCode = '33302' or zipCode = '33303' or zipCode = '33303' or zipCode = '33304' or zipCode = '33304' or zipCode = '33304' or zipCode = '33304' or zipCode = '33305' or zipCode = '33305' or zipCode = '33305' or zipCode = '33305' or zipCode = '33305' or zipCode = '33306' or zipCode = '33306' or zipCode = '33306' or zipCode = '33306' or zipCode = '33307' or zipCode = '33307' or zipCode = '33307' or zipCode = '33308' or zipCode = '33308' or zipCode = '33308' or zipCode = '33312' or zipCode = '33312' or zipCode = '33312' or zipCode = '33312' or zipCode = '33312' or zipCode = '33312' or zipCode = '33312' or zipCode = '33312' or zipCode = '33312' or zipCode = '33313' or zipCode = '33313' or zipCode = '33313' or zipCode = '33313' or zipCode = '33313' or zipCode = '33313' or zipCode = '33313' or zipCode = '33313' or zipCode = '33313' or zipCode = '33314' or zipCode = '33314' or zipCode = '33314' or zipCode = '33314' or zipCode = '33319' or zipCode = '33319' or zipCode = '33319' or zipCode = '33320' or zipCode = '33320' or zipCode = '33320' or zipCode = '33321' or zipCode = '33321' or zipCode = '33321' or zipCode = '33321' or zipCode = '33321' or zipCode = '33321' or zipCode = '33321' or zipCode = '33322' or zipCode = '33322' or zipCode = '33322' or zipCode = '33322' or zipCode = '33323' or zipCode = '33323' or zipCode = '33323' or zipCode = '33323' or zipCode = '33323' or zipCode = '33328' or zipCode = '33328' or zipCode = '33328' or zipCode = '33328' or zipCode = '33329' or zipCode = '33329' or zipCode = '33329' or zipCode = '33329' or zipCode = '33330' or zipCode = '33330' or zipCode = '33330' or zipCode = '33330' or zipCode = '33330' or zipCode = '33330' or zipCode = '33330' or zipCode = '33330' or zipCode = '33330' or zipCode = '33331' or zipCode = '33331' or zipCode = '33331' or zipCode = '33331' or zipCode = '33331' or zipCode = '33337' or zipCode = '33337' or zipCode = '33337' or zipCode = '33338' or zipCode = '33338' or zipCode = '33338' or zipCode = '33339' or zipCode = '33339' or zipCode = '33340' or zipCode = '33340' or zipCode = '33345' or zipCode = '33345' or zipCode = '33345' or zipCode = '33346' or zipCode = '33346' or zipCode = '33348' or zipCode = '33348' or zipCode = '33349' or zipCode = '33349' or zipCode = '33351' or zipCode = '33351' or zipCode = '33351' or zipCode = '33351' or zipCode = '33351' or zipCode = '33355' or zipCode = '33355' or zipCode = '33355' or zipCode = '33355' or zipCode = '33355' or zipCode = '33359' or zipCode = '33359' or zipCode = '33359' or zipCode = '33359' or zipCode = '33388' or zipCode = '33388' or zipCode = '33388' or zipCode = '33388' or zipCode = '33394' or zipCode = '33394' or zipCode = '33394' or zipCode = '33394' or zipCode = '33331' or zipCode = '33331' or zipCode = '33331' or zipCode = '33332' or zipCode = '33332' or zipCode = '33332' or zipCode = '33332' or zipCode = '33332' or zipCode = '33332' or zipCode = '33332' or zipCode = '33332' or zipCode = '33332' or zipCode = '33334' or zipCode = '33334' or zipCode = '33334' or zipCode = '33334' or zipCode = '33335' or zipCode = '33335' or zipCode = '33336' or zipCode = '33336' or zipCode = '33336' or zipCode = '33337' or zipCode = '33427' or zipCode = '33428' or zipCode = '33429' or zipCode = '33431' or zipCode = '33432' or zipCode = '33433' or zipCode = '33434' or zipCode = '33441' or zipCode = '33441' or zipCode = '33482' or zipCode = '33483' or zipCode = '33483' or zipCode = '33484' or zipCode = '33484' or zipCode = '33484' or zipCode = '33486' or zipCode = '33487' or zipCode = '33487' or zipCode = '33487' or zipCode = '33488' or zipCode = '33496' or zipCode = '33497' or zipCode = '33498' or zipCode = '33499' or zipCode = '33442' or zipCode = '33442' or zipCode = '33443' or zipCode = '33443' or zipCode = '33444' or zipCode = '33445' or zipCode = '33446' or zipCode = '33446' or zipCode = '33446' or zipCode = '33447' or zipCode = '33448' or zipCode = '33448' or zipCode = '33448' or zipCode = '33481' or zipCode = '33004' or zipCode = '33008' or zipCode = '33009' or zipCode = '33010' or zipCode = '33012' or zipCode = '33013' or zipCode = '33014' or zipCode = '33015' or zipCode = '33016' or zipCode = '33018' or zipCode = '33019' or zipCode = '33020' or zipCode = '33021' or zipCode = '33022' or zipCode = '33023' or zipCode = '33024' or zipCode = '33025' or zipCode = '33026' or zipCode = '33027' or zipCode = '33028' or zipCode = '33029' or zipCode = '33047' or zipCode = '33054' or zipCode = '33055' or zipCode = '33056' or zipCode = '33058' or zipCode = '33060' or zipCode = '33061' or zipCode = '33062' or zipCode = '33063' or zipCode = '33064' or zipCode = '33065' or zipCode = '33066' or zipCode = '33067' or zipCode = '33068' or zipCode = '33069' or zipCode = '33071' or zipCode = '33072' or zipCode = '33073' or zipCode = '33074' or zipCode = '33075' or zipCode = '33076' or zipCode = '33077' or zipCode = '33081' or zipCode = '33082' or zipCode = '33083' or zipCode = '33084' or zipCode = '33093' or zipCode = '33097' or zipCode = '33101' or zipCode = '33109' or zipCode = '33110' or zipCode = '33119' or zipCode = '33125' or zipCode = '33127' or zipCode = '33128' or zipCode = '33130' or zipCode = '33131' or zipCode = '33132' or zipCode = '33136' or zipCode = '33137' or zipCode = '33138' or zipCode = '33139' or zipCode = '33140' or zipCode = '33141' or zipCode = '33142' or zipCode = '33147' or zipCode = '33150' or zipCode = '33151' or zipCode = '33153' or zipCode = '33154' or zipCode = '33160' or zipCode = '33161' or zipCode = '33162' or zipCode = '33163' or zipCode = '33166' or zipCode = '33167' or zipCode = '33168' or zipCode = '33169' or zipCode = '33178' or zipCode = '33179' or zipCode = '33180' or zipCode = '33181' or zipCode = '33195' or zipCode = '33201' or zipCode = '33301' or zipCode = '33302' or zipCode = '33303' or zipCode = '33304' or zipCode = '33305' or zipCode = '33306' or zipCode = '33307' or zipCode = '33308' or zipCode = '33309' or zipCode = '33310' or zipCode = '33311' or zipCode = '33312' or zipCode = '33313' or zipCode = '33314' or zipCode = '33315' or zipCode = '33316' or zipCode = '33317' or zipCode = '33318' or zipCode = '33319' or zipCode = '33320' or zipCode = '33321' or zipCode = '33322' or zipCode = '33323' or zipCode = '33324' or zipCode = '33325' or zipCode = '33326' or zipCode = '33327' or zipCode = '33328' or zipCode = '33329' or zipCode = '33330' or zipCode = '33331' or zipCode = '33332' or zipCode = '33334' or zipCode = '33335' or zipCode = '33337' or zipCode = '33338' or zipCode = '33339' or zipCode = '33340' or zipCode = '33345' or zipCode = '33346' or zipCode = '33348' or zipCode = '33349' or zipCode = '33351' or zipCode = '33352' or zipCode = '33355' or zipCode = '33359' or zipCode = '33388' or zipCode = '33394' or zipCode = '33427' or zipCode = '33428' or zipCode = '33431' or zipCode = '33432' or zipCode = '33433' or zipCode = '33434' or zipCode = '33441' or zipCode = '33442' or zipCode = '33443' or zipCode = '33444' or zipCode = '33445' or zipCode = '33446' or zipCode = '33483' or zipCode = '33484' or zipCode = '33486' or zipCode = '33487' or zipCode = '33496' or zipCode = '33498' or zipCode = '33515') 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 ='33002' or zipCode = '33004' or zipCode = '33004' or zipCode = '33008' or zipCode = '33008' or zipCode = '33008' or zipCode = '33009' or zipCode = '33009' or zipCode = '33009' or zipCode = '33009' or zipCode = '33009' or zipCode = '33010' or zipCode = '33010' or zipCode = '33010' or zipCode = '33011' or zipCode = '33011' or zipCode = '33012' or zipCode = '33012' or zipCode = '33013' or zipCode = '33013' or zipCode = '33014' or zipCode = '33014' or zipCode = '33014' or zipCode = '33014' or zipCode = '33014' or zipCode = '33014' or zipCode = '33015' or zipCode = '33015' or zipCode = '33015' or zipCode = '33015' or zipCode = '33015' or zipCode = '33015' or zipCode = '33016' or zipCode = '33016' or zipCode = '33016' or zipCode = '33016' or zipCode = '33016' or zipCode = '33017' or zipCode = '33017' or zipCode = '33017' or zipCode = '33018' or zipCode = '33018' or zipCode = '33018' or zipCode = '33018' or zipCode = '33018' or zipCode = '33019' or zipCode = '33019' or zipCode = '33020' or zipCode = '33020' or zipCode = '33021' or zipCode = '33021' or zipCode = '33022' or zipCode = '33022' or zipCode = '33023' or zipCode = '33023' or zipCode = '33023' or zipCode = '33023' or zipCode = '33023' or zipCode = '33023' or zipCode = '33023' or zipCode = '33023' or zipCode = '33024' or zipCode = '33024' or zipCode = '33024' or zipCode = '33024' or zipCode = '33024' or zipCode = '33024' or zipCode = '33025' or zipCode = '33025' or zipCode = '33025' or zipCode = '33025' or zipCode = '33026' or zipCode = '33026' or zipCode = '33026' or zipCode = '33026' or zipCode = '33026' or zipCode = '33027' or zipCode = '33027' or zipCode = '33027' or zipCode = '33027' or zipCode = '33028' or zipCode = '33028' or zipCode = '33028' or zipCode = '33028' or zipCode = '33029' or zipCode = '33029' or zipCode = '33029' or zipCode = '33029' or zipCode = '33029' or zipCode = '33054' or zipCode = '33054' or zipCode = '33054' or zipCode = '33055' or zipCode = '33055' or zipCode = '33055' or zipCode = '33055' or zipCode = '33056' or zipCode = '33056' or zipCode = '33056' or zipCode = '33056' or zipCode = '33060' or zipCode = '33061' or zipCode = '33062' or zipCode = '33068' or zipCode = '33068' or zipCode = '33069' or zipCode = '33069' or zipCode = '33071' or zipCode = '33071' or zipCode = '33072' or zipCode = '33073' or zipCode = '33073' or zipCode = '33073' or zipCode = '33073' or zipCode = '33073' or zipCode = '33073' or zipCode = '33074' or zipCode = '33074' or zipCode = '33074' or zipCode = '33074' or zipCode = '33075' or zipCode = '33075' or zipCode = '33076' or zipCode = '33076' or zipCode = '33076' or zipCode = '33076' or zipCode = '33077' or zipCode = '33077' or zipCode = '33081' or zipCode = '33081' or zipCode = '33081' or zipCode = '33082' or zipCode = '33082' or zipCode = '33082' or zipCode = '33082' or zipCode = '33083' or zipCode = '33083' or zipCode = '33083' or zipCode = '33084' or zipCode = '33084' or zipCode = '33084' or zipCode = '33093' or zipCode = '33093' or zipCode = '33093' or zipCode = '33093' or zipCode = '33097' or zipCode = '33097' or zipCode = '33101' or zipCode = '33102' or zipCode = '33109' or zipCode = '33109' or zipCode = '33109' or zipCode = '33111' or zipCode = '33112' or zipCode = '33112' or zipCode = '33116' or zipCode = '33119' or zipCode = '33119' or zipCode = '33122' or zipCode = '33122' or zipCode = '33122' or zipCode = '33122' or zipCode = '33138' or zipCode = '33139' or zipCode = '33139' or zipCode = '33139' or zipCode = '33139' or zipCode = '33140' or zipCode = '33140' or zipCode = '33140' or zipCode = '33141' or zipCode = '33141' or zipCode = '33141' or zipCode = '33141' or zipCode = '33141' or zipCode = '33141' or zipCode = '33142' or zipCode = '33062' or zipCode = '33062' or zipCode = '33062' or zipCode = '33062' or zipCode = '33063' or zipCode = '33063' or zipCode = '33063' or zipCode = '33064' or zipCode = '33064' or zipCode = '33064' or zipCode = '33064' or zipCode = '33064' or zipCode = '33065' or zipCode = '33065' or zipCode = '33065' or zipCode = '33066' or zipCode = '33066' or zipCode = '33067' or zipCode = '33067' or zipCode = '33067' or zipCode = '33068' or zipCode = '33068' or zipCode = '33125' or zipCode = '33127' or zipCode = '33128' or zipCode = '33130' or zipCode = '33131' or zipCode = '33132' or zipCode = '33132' or zipCode = '33136' or zipCode = '33137' or zipCode = '33138' or zipCode = '33138' or zipCode = '33147' or zipCode = '33147' or zipCode = '33150' or zipCode = '33150' or zipCode = '33150' or zipCode = '33151' or zipCode = '33152' or zipCode = '33153' or zipCode = '33153' or zipCode = '33154' or zipCode = '33154' or zipCode = '33154' or zipCode = '33154' or zipCode = '33154' or zipCode = '33154' or zipCode = '33154' or zipCode = '33154' or zipCode = '33154' or zipCode = '33159' or zipCode = '33160' or zipCode = '33160' or zipCode = '33160' or zipCode = '33160' or zipCode = '33160' or zipCode = '33160' or zipCode = '33160' or zipCode = '33160' or zipCode = '33161' or zipCode = '33161' or zipCode = '33161' or zipCode = '33161' or zipCode = '33161' or zipCode = '33161' or zipCode = '33161' or zipCode = '33162' or zipCode = '33162' or zipCode = '33162' or zipCode = '33162' or zipCode = '33162' or zipCode = '33162' or zipCode = '33162' or zipCode = '33162' or zipCode = '33163' or zipCode = '33163' or zipCode = '33164' or zipCode = '33164' or zipCode = '33166' or zipCode = '33166' or zipCode = '33166' or zipCode = '33166' or zipCode = '33166' or zipCode = '33166' or zipCode = '33166' or zipCode = '33167' or zipCode = '33167' or zipCode = '33167' or zipCode = '33168' or zipCode = '33168' or zipCode = '33168' or zipCode = '33169' or zipCode = '33169' or zipCode = '33169' or zipCode = '33169' or zipCode = '33169' or zipCode = '33188' or zipCode = '33188' or zipCode = '33238' or zipCode = '33239' or zipCode = '33239' or zipCode = '33239' or zipCode = '33242' or zipCode = '33243' or zipCode = '33243' or zipCode = '33245' or zipCode = '33247' or zipCode = '33257' or zipCode = '33257' or zipCode = '33257' or zipCode = '33261' or zipCode = '33261' or zipCode = '33261' or zipCode = '33261' or zipCode = '33261' or zipCode = '33265' or zipCode = '33265' or zipCode = '33265' or zipCode = '33266' or zipCode = '33266' or zipCode = '33269' or zipCode = '33280' or zipCode = '33280' or zipCode = '33280' or zipCode = '33299' or zipCode = '33301' or zipCode = '33301' or zipCode = '33302' or zipCode = '33308' or zipCode = '33308' or zipCode = '33308' or zipCode = '33308' or zipCode = '33309' or zipCode = '33309' or zipCode = '33309' or zipCode = '33309' or zipCode = '33309' or zipCode = '33309' or zipCode = '33309' or zipCode = '33310' or zipCode = '33310' or zipCode = '33310' or zipCode = '33311' or zipCode = '33311' or zipCode = '33311' or zipCode = '33311' or zipCode = '33311' or zipCode = '33311' or zipCode = '33311' or zipCode = '33311' or zipCode = '33314' or zipCode = '33315' or zipCode = '33315' or zipCode = '33316' or zipCode = '33316' or zipCode = '33316' or zipCode = '33316' or zipCode = '33317' or zipCode = '33317' or zipCode = '33317' or zipCode = '33317' or zipCode = '33318' or zipCode = '33318' or zipCode = '33318' or zipCode = '33319' or zipCode = '33319' or zipCode = '33319' or zipCode = '33319' or zipCode = '33319' or zipCode = '33319' or zipCode = '33319' or zipCode = '33319' or zipCode = '33324' or zipCode = '33324' or zipCode = '33324' or zipCode = '33324' or zipCode = '33325' or zipCode = '33325' or zipCode = '33325' or zipCode = '33325' or zipCode = '33325' or zipCode = '33325' or zipCode = '33326' or zipCode = '33326' or zipCode = '33326' or zipCode = '33326' or zipCode = '33326' or zipCode = '33326' or zipCode = '33326' or zipCode = '33326' or zipCode = '33327' or zipCode = '33327' or zipCode = '33327' or zipCode = '33327' or zipCode = '33179' or zipCode = '33179' or zipCode = '33179' or zipCode = '33179' or zipCode = '33180' or zipCode = '33180' or zipCode = '33180' or zipCode = '33180' or zipCode = '33180' or zipCode = '33181' or zipCode = '33181' or zipCode = '33181' or zipCode = '33181' or zipCode = '33181' or zipCode = '33181' or zipCode = '33197' or zipCode = '33197' or zipCode = '33231' or zipCode = '33231' or zipCode = '33302' or zipCode = '33303' or zipCode = '33303' or zipCode = '33304' or zipCode = '33304' or zipCode = '33304' or zipCode = '33304' or zipCode = '33305' or zipCode = '33305' or zipCode = '33305' or zipCode = '33305' or zipCode = '33305' or zipCode = '33306' or zipCode = '33306' or zipCode = '33306' or zipCode = '33306' or zipCode = '33307' or zipCode = '33307' or zipCode = '33307' or zipCode = '33308' or zipCode = '33308' or zipCode = '33308' or zipCode = '33312' or zipCode = '33312' or zipCode = '33312' or zipCode = '33312' or zipCode = '33312' or zipCode = '33312' or zipCode = '33312' or zipCode = '33312' or zipCode = '33312' or zipCode = '33313' or zipCode = '33313' or zipCode = '33313' or zipCode = '33313' or zipCode = '33313' or zipCode = '33313' or zipCode = '33313' or zipCode = '33313' or zipCode = '33313' or zipCode = '33314' or zipCode = '33314' or zipCode = '33314' or zipCode = '33314' or zipCode = '33319' or zipCode = '33319' or zipCode = '33319' or zipCode = '33320' or zipCode = '33320' or zipCode = '33320' or zipCode = '33321' or zipCode = '33321' or zipCode = '33321' or zipCode = '33321' or zipCode = '33321' or zipCode = '33321' or zipCode = '33321' or zipCode = '33322' or zipCode = '33322' or zipCode = '33322' or zipCode = '33322' or zipCode = '33323' or zipCode = '33323' or zipCode = '33323' or zipCode = '33323' or zipCode = '33323' or zipCode = '33328' or zipCode = '33328' or zipCode = '33328' or zipCode = '33328' or zipCode = '33329' or zipCode = '33329' or zipCode = '33329' or zipCode = '33329' or zipCode = '33330' or zipCode = '33330' or zipCode = '33330' or zipCode = '33330' or zipCode = '33330' or zipCode = '33330' or zipCode = '33330' or zipCode = '33330' or zipCode = '33330' or zipCode = '33331' or zipCode = '33331' or zipCode = '33331' or zipCode = '33331' or zipCode = '33331' or zipCode = '33337' or zipCode = '33337' or zipCode = '33337' or zipCode = '33338' or zipCode = '33338' or zipCode = '33338' or zipCode = '33339' or zipCode = '33339' or zipCode = '33340' or zipCode = '33340' or zipCode = '33345' or zipCode = '33345' or zipCode = '33345' or zipCode = '33346' or zipCode = '33346' or zipCode = '33348' or zipCode = '33348' or zipCode = '33349' or zipCode = '33349' or zipCode = '33351' or zipCode = '33351' or zipCode = '33351' or zipCode = '33351' or zipCode = '33351' or zipCode = '33355' or zipCode = '33355' or zipCode = '33355' or zipCode = '33355' or zipCode = '33355' or zipCode = '33359' or zipCode = '33359' or zipCode = '33359' or zipCode = '33359' or zipCode = '33388' or zipCode = '33388' or zipCode = '33388' or zipCode = '33388' or zipCode = '33394' or zipCode = '33394' or zipCode = '33394' or zipCode = '33394' or zipCode = '33331' or zipCode = '33331' or zipCode = '33331' or zipCode = '33332' or zipCode = '33332' or zipCode = '33332' or zipCode = '33332' or zipCode = '33332' or zipCode = '33332' or zipCode = '33332' or zipCode = '33332' or zipCode = '33332' or zipCode = '33334' or zipCode = '33334' or zipCode = '33334' or zipCode = '33334' or zipCode = '33335' or zipCode = '33335' or zipCode = '33336' or zipCode = '33336' or zipCode = '33336' or zipCode = '33337' or zipCode = '33427' or zipCode = '33428' or zipCode = '33429' or zipCode = '33431' or zipCode = '33432' or zipCode = '33433' or zipCode = '33434' or zipCode = '33441' or zipCode = '33441' or zipCode = '33482' or zipCode = '33483' or zipCode = '33483' or zipCode = '33484' or zipCode = '33484' or zipCode = '33484' or zipCode = '33486' or zipCode = '33487' or zipCode = '33487' or zipCode = '33487' or zipCode = '33488' or zipCode = '33496' or zipCode = '33497' or zipCode = '33498' or zipCode = '33499' or zipCode = '33442' or zipCode = '33442' or zipCode = '33443' or zipCode = '33443' or zipCode = '33444' or zipCode = '33445' or zipCode = '33446' or zipCode = '33446' or zipCode = '33446' or zipCode = '33447' or zipCode = '33448' or zipCode = '33448' or zipCode = '33448' or zipCode = '33481' or zipCode = '33004' or zipCode = '33008' or zipCode = '33009' or zipCode = '33010' or zipCode = '33012' or zipCode = '33013' or zipCode = '33014' or zipCode = '33015' or zipCode = '33016' or zipCode = '33018' or zipCode = '33019' or zipCode = '33020' or zipCode = '33021' or zipCode = '33022' or zipCode = '33023' or zipCode = '33024' or zipCode = '33025' or zipCode = '33026' or zipCode = '33027' or zipCode = '33028' or zipCode = '33029' or zipCode = '33047' or zipCode = '33054' or zipCode = '33055' or zipCode = '33056' or zipCode = '33058' or zipCode = '33060' or zipCode = '33061' or zipCode = '33062' or zipCode = '33063' or zipCode = '33064' or zipCode = '33065' or zipCode = '33066' or zipCode = '33067' or zipCode = '33068' or zipCode = '33069' or zipCode = '33071' or zipCode = '33072' or zipCode = '33073' or zipCode = '33074' or zipCode = '33075' or zipCode = '33076' or zipCode = '33077' or zipCode = '33081' or zipCode = '33082' or zipCode = '33083' or zipCode = '33084' or zipCode = '33093' or zipCode = '33097' or zipCode = '33101' or zipCode = '33109' or zipCode = '33110' or zipCode = '33119' or zipCode = '33125' or zipCode = '33127' or zipCode = '33128' or zipCode = '33130' or zipCode = '33131' or zipCode = '33132' or zipCode = '33136' or zipCode = '33137' or zipCode = '33138' or zipCode = '33139' or zipCode = '33140' or zipCode = '33141' or zipCode = '33142' or zipCode = '33147' or zipCode = '33150' or zipCode = '33151' or zipCode = '33153' or zipCode = '33154' or zipCode = '33160' or zipCode = '33161' or zipCode = '33162' or zipCode = '33163' or zipCode = '33166' or zipCode = '33167' or zipCode = '33168' or zipCode = '33169' or zipCode = '33178' or zipCode = '33179' or zipCode = '33180' or zipCode = '33181' or zipCode = '33195' or zipCode = '33201' or zipCode = '33301' or zipCode = '33302' or zipCode = '33303' or zipCode = '33304' or zipCode = '33305' or zipCode = '33306' or zipCode = '33307' or zipCode = '33308' or zipCode = '33309' or zipCode = '33310' or zipCode = '33311' or zipCode = '33312' or zipCode = '33313' or zipCode = '33314' or zipCode = '33315' or zipCode = '33316' or zipCode = '33317' or zipCode = '33318' or zipCode = '33319' or zipCode = '33320' or zipCode = '33321' or zipCode = '33322' or zipCode = '33323' or zipCode = '33324' or zipCode = '33325' or zipCode = '33326' or zipCode = '33327' or zipCode = '33328' or zipCode = '33329' or zipCode = '33330' or zipCode = '33331' or zipCode = '33332' or zipCode = '33334' or zipCode = '33335' or zipCode = '33337' or zipCode = '33338' or zipCode = '33339' or zipCode = '33340' or zipCode = '33345' or zipCode = '33346' or zipCode = '33348' or zipCode = '33349' or zipCode = '33351' or zipCode = '33352' or zipCode = '33355' or zipCode = '33359' or zipCode = '33388' or zipCode = '33394' or zipCode = '33427' or zipCode = '33428' or zipCode = '33431' or zipCode = '33432' or zipCode = '33433' or zipCode = '33434' or zipCode = '33441' or zipCode = '33442' or zipCode = '33443' or zipCode = '33444' or zipCode = '33445' or zipCode = '33446' or zipCode = '33483' or zipCode = '33484' or zipCode = '33486' or zipCode = '33487' or zipCode = '33496' or zipCode = '33498' or zipCode = '33515') 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 ='33002' or zipCode = '33004' or zipCode = '33004' or zipCode = '33008' or zipCode = '33008' or zipCode = '33008' or zipCode = '33009' or zipCode = '33009' or zipCode = '33009' or zipCode = '33009' or zipCode = '33009' or zipCode = '33010' or zipCode = '33010' or zipCode = '33010' or zipCode = '33011' or zipCode = '33011' or zipCode = '33012' or zipCode = '33012' or zipCode = '33013' or zipCode = '33013' or zipCode = '33014' or zipCode = '33014' or zipCode = '33014' or zipCode = '33014' or zipCode = '33014' or zipCode = '33014' or zipCode = '33015' or zipCode = '33015' or zipCode = '33015' or zipCode = '33015' or zipCode = '33015' or zipCode = '33015' or zipCode = '33016' or zipCode = '33016' or zipCode = '33016' or zipCode = '33016' or zipCode = '33016' or zipCode = '33017' or zipCode = '33017' or zipCode = '33017' or zipCode = '33018' or zipCode = '33018' or zipCode = '33018' or zipCode = '33018' or zipCode = '33018' or zipCode = '33019' or zipCode = '33019' or zipCode = '33020' or zipCode = '33020' or zipCode = '33021' or zipCode = '33021' or zipCode = '33022' or zipCode = '33022' or zipCode = '33023' or zipCode = '33023' or zipCode = '33023' or zipCode = '33023' or zipCode = '33023' or zipCode = '33023' or zipCode = '33023' or zipCode = '33023' or zipCode = '33024' or zipCode = '33024' or zipCode = '33024' or zipCode = '33024' or zipCode = '33024' or zipCode = '33024' or zipCode = '33025' or zipCode = '33025' or zipCode = '33025' or zipCode = '33025' or zipCode = '33026' or zipCode = '33026' or zipCode = '33026' or zipCode = '33026' or zipCode = '33026' or zipCode = '33027' or zipCode = '33027' or zipCode = '33027' or zipCode = '33027' or zipCode = '33028' or zipCode = '33028' or zipCode = '33028' or zipCode = '33028' or zipCode = '33029' or zipCode = '33029' or zipCode = '33029' or zipCode = '33029' or zipCode = '33029' or zipCode = '33054' or zipCode = '33054' or zipCode = '33054' or zipCode = '33055' or zipCode = '33055' or zipCode = '33055' or zipCode = '33055' or zipCode = '33056' or zipCode = '33056' or zipCode = '33056' or zipCode = '33056' or zipCode = '33060' or zipCode = '33061' or zipCode = '33062' or zipCode = '33068' or zipCode = '33068' or zipCode = '33069' or zipCode = '33069' or zipCode = '33071' or zipCode = '33071' or zipCode = '33072' or zipCode = '33073' or zipCode = '33073' or zipCode = '33073' or zipCode = '33073' or zipCode = '33073' or zipCode = '33073' or zipCode = '33074' or zipCode = '33074' or zipCode = '33074' or zipCode = '33074' or zipCode = '33075' or zipCode = '33075' or zipCode = '33076' or zipCode = '33076' or zipCode = '33076' or zipCode = '33076' or zipCode = '33077' or zipCode = '33077' or zipCode = '33081' or zipCode = '33081' or zipCode = '33081' or zipCode = '33082' or zipCode = '33082' or zipCode = '33082' or zipCode = '33082' or zipCode = '33083' or zipCode = '33083' or zipCode = '33083' or zipCode = '33084' or zipCode = '33084' or zipCode = '33084' or zipCode = '33093' or zipCode = '33093' or zipCode = '33093' or zipCode = '33093' or zipCode = '33097' or zipCode = '33097' or zipCode = '33101' or zipCode = '33102' or zipCode = '33109' or zipCode = '33109' or zipCode = '33109' or zipCode = '33111' or zipCode = '33112' or zipCode = '33112' or zipCode = '33116' or zipCode = '33119' or zipCode = '33119' or zipCode = '33122' or zipCode = '33122' or zipCode = '33122' or zipCode = '33122' or zipCode = '33138' or zipCode = '33139' or zipCode = '33139' or zipCode = '33139' or zipCode = '33139' or zipCode = '33140' or zipCode = '33140' or zipCode = '33140' or zipCode = '33141' or zipCode = '33141' or zipCode = '33141' or zipCode = '33141' or zipCode = '33141' or zipCode = '33141' or zipCode = '33142' or zipCode = '33062' or zipCode = '33062' or zipCode = '33062' or zipCode = '33062' or zipCode = '33063' or zipCode = '33063' or zipCode = '33063' or zipCode = '33064' or zipCode = '33064' or zipCode = '33064' or zipCode = '33064' or zipCode = '33064' or zipCode = '33065' or zipCode = '33065' or zipCode = '33065' or zipCode = '33066' or zipCode = '33066' or zipCode = '33067' or zipCode = '33067' or zipCode = '33067' or zipCode = '33068' or zipCode = '33068' or zipCode = '33125' or zipCode = '33127' or zipCode = '33128' or zipCode = '33130' or zipCode = '33131' or zipCode = '33132' or zipCode = '33132' or zipCode = '33136' or zipCode = '33137' or zipCode = '33138' or zipCode = '33138' or zipCode = '33147' or zipCode = '33147' or zipCode = '33150' or zipCode = '33150' or zipCode = '33150' or zipCode = '33151' or zipCode = '33152' or zipCode = '33153' or zipCode = '33153' or zipCode = '33154' or zipCode = '33154' or zipCode = '33154' or zipCode = '33154' or zipCode = '33154' or zipCode = '33154' or zipCode = '33154' or zipCode = '33154' or zipCode = '33154' or zipCode = '33159' or zipCode = '33160' or zipCode = '33160' or zipCode = '33160' or zipCode = '33160' or zipCode = '33160' or zipCode = '33160' or zipCode = '33160' or zipCode = '33160' or zipCode = '33161' or zipCode = '33161' or zipCode = '33161' or zipCode = '33161' or zipCode = '33161' or zipCode = '33161' or zipCode = '33161' or zipCode = '33162' or zipCode = '33162' or zipCode = '33162' or zipCode = '33162' or zipCode = '33162' or zipCode = '33162' or zipCode = '33162' or zipCode = '33162' or zipCode = '33163' or zipCode = '33163' or zipCode = '33164' or zipCode = '33164' or zipCode = '33166' or zipCode = '33166' or zipCode = '33166' or zipCode = '33166' or zipCode = '33166' or zipCode = '33166' or zipCode = '33166' or zipCode = '33167' or zipCode = '33167' or zipCode = '33167' or zipCode = '33168' or zipCode = '33168' or zipCode = '33168' or zipCode = '33169' or zipCode = '33169' or zipCode = '33169' or zipCode = '33169' or zipCode = '33169' or zipCode = '33188' or zipCode = '33188' or zipCode = '33238' or zipCode = '33239' or zipCode = '33239' or zipCode = '33239' or zipCode = '33242' or zipCode = '33243' or zipCode = '33243' or zipCode = '33245' or zipCode = '33247' or zipCode = '33257' or zipCode = '33257' or zipCode = '33257' or zipCode = '33261' or zipCode = '33261' or zipCode = '33261' or zipCode = '33261' or zipCode = '33261' or zipCode = '33265' or zipCode = '33265' or zipCode = '33265' or zipCode = '33266' or zipCode = '33266' or zipCode = '33269' or zipCode = '33280' or zipCode = '33280' or zipCode = '33280' or zipCode = '33299' or zipCode = '33301' or zipCode = '33301' or zipCode = '33302' or zipCode = '33308' or zipCode = '33308' or zipCode = '33308' or zipCode = '33308' or zipCode = '33309' or zipCode = '33309' or zipCode = '33309' or zipCode = '33309' or zipCode = '33309' or zipCode = '33309' or zipCode = '33309' or zipCode = '33310' or zipCode = '33310' or zipCode = '33310' or zipCode = '33311' or zipCode = '33311' or zipCode = '33311' or zipCode = '33311' or zipCode = '33311' or zipCode = '33311' or zipCode = '33311' or zipCode = '33311' or zipCode = '33314' or zipCode = '33315' or zipCode = '33315' or zipCode = '33316' or zipCode = '33316' or zipCode = '33316' or zipCode = '33316' or zipCode = '33317' or zipCode = '33317' or zipCode = '33317' or zipCode = '33317' or zipCode = '33318' or zipCode = '33318' or zipCode = '33318' or zipCode = '33319' or zipCode = '33319' or zipCode = '33319' or zipCode = '33319' or zipCode = '33319' or zipCode = '33319' or zipCode = '33319' or zipCode = '33319' or zipCode = '33324' or zipCode = '33324' or zipCode = '33324' or zipCode = '33324' or zipCode = '33325' or zipCode = '33325' or zipCode = '33325' or zipCode = '33325' or zipCode = '33325' or zipCode = '33325' or zipCode = '33326' or zipCode = '33326' or zipCode = '33326' or zipCode = '33326' or zipCode = '33326' or zipCode = '33326' or zipCode = '33326' or zipCode = '33326' or zipCode = '33327' or zipCode = '33327' or zipCode = '33327' or zipCode = '33327' or zipCode = '33179' or zipCode = '33179' or zipCode = '33179' or zipCode = '33179' or zipCode = '33180' or zipCode = '33180' or zipCode = '33180' or zipCode = '33180' or zipCode = '33180' or zipCode = '33181' or zipCode = '33181' or zipCode = '33181' or zipCode = '33181' or zipCode = '33181' or zipCode = '33181' or zipCode = '33197' or zipCode = '33197' or zipCode = '33231' or zipCode = '33231' or zipCode = '33302' or zipCode = '33303' or zipCode = '33303' or zipCode = '33304' or zipCode = '33304' or zipCode = '33304' or zipCode = '33304' or zipCode = '33305' or zipCode = '33305' or zipCode = '33305' or zipCode = '33305' or zipCode = '33305' or zipCode = '33306' or zipCode = '33306' or zipCode = '33306' or zipCode = '33306' or zipCode = '33307' or zipCode = '33307' or zipCode = '33307' or zipCode = '33308' or zipCode = '33308' or zipCode = '33308' or zipCode = '33312' or zipCode = '33312' or zipCode = '33312' or zipCode = '33312' or zipCode = '33312' or zipCode = '33312' or zipCode = '33312' or zipCode = '33312' or zipCode = '33312' or zipCode = '33313' or zipCode = '33313' or zipCode = '33313' or zipCode = '33313' or zipCode = '33313' or zipCode = '33313' or zipCode = '33313' or zipCode = '33313' or zipCode = '33313' or zipCode = '33314' or zipCode = '33314' or zipCode = '33314' or zipCode = '33314' or zipCode = '33319' or zipCode = '33319' or zipCode = '33319' or zipCode = '33320' or zipCode = '33320' or zipCode = '33320' or zipCode = '33321' or zipCode = '33321' or zipCode = '33321' or zipCode = '33321' or zipCode = '33321' or zipCode = '33321' or zipCode = '33321' or zipCode = '33322' or zipCode = '33322' or zipCode = '33322' or zipCode = '33322' or zipCode = '33323' or zipCode = '33323' or zipCode = '33323' or zipCode = '33323' or zipCode = '33323' or zipCode = '33328' or zipCode = '33328' or zipCode = '33328' or zipCode = '33328' or zipCode = '33329' or zipCode = '33329' or zipCode = '33329' or zipCode = '33329' or zipCode = '33330' or zipCode = '33330' or zipCode = '33330' or zipCode = '33330' or zipCode = '33330' or zipCode = '33330' or zipCode = '33330' or zipCode = '33330' or zipCode = '33330' or zipCode = '33331' or zipCode = '33331' or zipCode = '33331' or zipCode = '33331' or zipCode = '33331' or zipCode = '33337' or zipCode = '33337' or zipCode = '33337' or zipCode = '33338' or zipCode = '33338' or zipCode = '33338' or zipCode = '33339' or zipCode = '33339' or zipCode = '33340' or zipCode = '33340' or zipCode = '33345' or zipCode = '33345' or zipCode = '33345' or zipCode = '33346' or zipCode = '33346' or zipCode = '33348' or zipCode = '33348' or zipCode = '33349' or zipCode = '33349' or zipCode = '33351' or zipCode = '33351' or zipCode = '33351' or zipCode = '33351' or zipCode = '33351' or zipCode = '33355' or zipCode = '33355' or zipCode = '33355' or zipCode = '33355' or zipCode = '33355' or zipCode = '33359' or zipCode = '33359' or zipCode = '33359' or zipCode = '33359' or zipCode = '33388' or zipCode = '33388' or zipCode = '33388' or zipCode = '33388' or zipCode = '33394' or zipCode = '33394' or zipCode = '33394' or zipCode = '33394' or zipCode = '33331' or zipCode = '33331' or zipCode = '33331' or zipCode = '33332' or zipCode = '33332' or zipCode = '33332' or zipCode = '33332' or zipCode = '33332' or zipCode = '33332' or zipCode = '33332' or zipCode = '33332' or zipCode = '33332' or zipCode = '33334' or zipCode = '33334' or zipCode = '33334' or zipCode = '33334' or zipCode = '33335' or zipCode = '33335' or zipCode = '33336' or zipCode = '33336' or zipCode = '33336' or zipCode = '33337' or zipCode = '33427' or zipCode = '33428' or zipCode = '33429' or zipCode = '33431' or zipCode = '33432' or zipCode = '33433' or zipCode = '33434' or zipCode = '33441' or zipCode = '33441' or zipCode = '33482' or zipCode = '33483' or zipCode = '33483' or zipCode = '33484' or zipCode = '33484' or zipCode = '33484' or zipCode = '33486' or zipCode = '33487' or zipCode = '33487' or zipCode = '33487' or zipCode = '33488' or zipCode = '33496' or zipCode = '33497' or zipCode = '33498' or zipCode = '33499' or zipCode = '33442' or zipCode = '33442' or zipCode = '33443' or zipCode = '33443' or zipCode = '33444' or zipCode = '33445' or zipCode = '33446' or zipCode = '33446' or zipCode = '33446' or zipCode = '33447' or zipCode = '33448' or zipCode = '33448' or zipCode = '33448' or zipCode = '33481' or zipCode = '33004' or zipCode = '33008' or zipCode = '33009' or zipCode = '33010' or zipCode = '33012' or zipCode = '33013' or zipCode = '33014' or zipCode = '33015' or zipCode = '33016' or zipCode = '33018' or zipCode = '33019' or zipCode = '33020' or zipCode = '33021' or zipCode = '33022' or zipCode = '33023' or zipCode = '33024' or zipCode = '33025' or zipCode = '33026' or zipCode = '33027' or zipCode = '33028' or zipCode = '33029' or zipCode = '33047' or zipCode = '33054' or zipCode = '33055' or zipCode = '33056' or zipCode = '33058' or zipCode = '33060' or zipCode = '33061' or zipCode = '33062' or zipCode = '33063' or zipCode = '33064' or zipCode = '33065' or zipCode = '33066' or zipCode = '33067' or zipCode = '33068' or zipCode = '33069' or zipCode = '33071' or zipCode = '33072' or zipCode = '33073' or zipCode = '33074' or zipCode = '33075' or zipCode = '33076' or zipCode = '33077' or zipCode = '33081' or zipCode = '33082' or zipCode = '33083' or zipCode = '33084' or zipCode = '33093' or zipCode = '33097' or zipCode = '33101' or zipCode = '33109' or zipCode = '33110' or zipCode = '33119' or zipCode = '33125' or zipCode = '33127' or zipCode = '33128' or zipCode = '33130' or zipCode = '33131' or zipCode = '33132' or zipCode = '33136' or zipCode = '33137' or zipCode = '33138' or zipCode = '33139' or zipCode = '33140' or zipCode = '33141' or zipCode = '33142' or zipCode = '33147' or zipCode = '33150' or zipCode = '33151' or zipCode = '33153' or zipCode = '33154' or zipCode = '33160' or zipCode = '33161' or zipCode = '33162' or zipCode = '33163' or zipCode = '33166' or zipCode = '33167' or zipCode = '33168' or zipCode = '33169' or zipCode = '33178' or zipCode = '33179' or zipCode = '33180' or zipCode = '33181' or zipCode = '33195' or zipCode = '33201' or zipCode = '33301' or zipCode = '33302' or zipCode = '33303' or zipCode = '33304' or zipCode = '33305' or zipCode = '33306' or zipCode = '33307' or zipCode = '33308' or zipCode = '33309' or zipCode = '33310' or zipCode = '33311' or zipCode = '33312' or zipCode = '33313' or zipCode = '33314' or zipCode = '33315' or zipCode = '33316' or zipCode = '33317' or zipCode = '33318' or zipCode = '33319' or zipCode = '33320' or zipCode = '33321' or zipCode = '33322' or zipCode = '33323' or zipCode = '33324' or zipCode = '33325' or zipCode = '33326' or zipCode = '33327' or zipCode = '33328' or zipCode = '33329' or zipCode = '33330' or zipCode = '33331' or zipCode = '33332' or zipCode = '33334' or zipCode = '33335' or zipCode = '33337' or zipCode = '33338' or zipCode = '33339' or zipCode = '33340' or zipCode = '33345' or zipCode = '33346' or zipCode = '33348' or zipCode = '33349' or zipCode = '33351' or zipCode = '33352' or zipCode = '33355' or zipCode = '33359' or zipCode = '33388' or zipCode = '33394' or zipCode = '33427' or zipCode = '33428' or zipCode = '33431' or zipCode = '33432' or zipCode = '33433' or zipCode = '33434' or zipCode = '33441' or zipCode = '33442' or zipCode = '33443' or zipCode = '33444' or zipCode = '33445' or zipCode = '33446' or zipCode = '33483' or zipCode = '33484' or zipCode = '33486' or zipCode = '33487' or zipCode = '33496' or zipCode = '33498' or zipCode = '33515') 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 ='33002' or zipCode = '33004' or zipCode = '33004' or zipCode = '33008' or zipCode = '33008' or zipCode = '33008' or zipCode = '33009' or zipCode = '33009' or zipCode = '33009' or zipCode = '33009' or zipCode = '33009' or zipCode = '33010' or zipCode = '33010' or zipCode = '33010' or zipCode = '33011' or zipCode = '33011' or zipCode = '33012' or zipCode = '33012' or zipCode = '33013' or zipCode = '33013' or zipCode = '33014' or zipCode = '33014' or zipCode = '33014' or zipCode = '33014' or zipCode = '33014' or zipCode = '33014' or zipCode = '33015' or zipCode = '33015' or zipCode = '33015' or zipCode = '33015' or zipCode = '33015' or zipCode = '33015' or zipCode = '33016' or zipCode = '33016' or zipCode = '33016' or zipCode = '33016' or zipCode = '33016' or zipCode = '33017' or zipCode = '33017' or zipCode = '33017' or zipCode = '33018' or zipCode = '33018' or zipCode = '33018' or zipCode = '33018' or zipCode = '33018' or zipCode = '33019' or zipCode = '33019' or zipCode = '33020' or zipCode = '33020' or zipCode = '33021' or zipCode = '33021' or zipCode = '33022' or zipCode = '33022' or zipCode = '33023' or zipCode = '33023' or zipCode = '33023' or zipCode = '33023' or zipCode = '33023' or zipCode = '33023' or zipCode = '33023' or zipCode = '33023' or zipCode = '33024' or zipCode = '33024' or zipCode = '33024' or zipCode = '33024' or zipCode = '33024' or zipCode = '33024' or zipCode = '33025' or zipCode = '33025' or zipCode = '33025' or zipCode = '33025' or zipCode = '33026' or zipCode = '33026' or zipCode = '33026' or zipCode = '33026' or zipCode = '33026' or zipCode = '33027' or zipCode = '33027' or zipCode = '33027' or zipCode = '33027' or zipCode = '33028' or zipCode = '33028' or zipCode = '33028' or zipCode = '33028' or zipCode = '33029' or zipCode = '33029' or zipCode = '33029' or zipCode = '33029' or zipCode = '33029' or zipCode = '33054' or zipCode = '33054' or zipCode = '33054' or zipCode = '33055' or zipCode = '33055' or zipCode = '33055' or zipCode = '33055' or zipCode = '33056' or zipCode = '33056' or zipCode = '33056' or zipCode = '33056' or zipCode = '33060' or zipCode = '33061' or zipCode = '33062' or zipCode = '33068' or zipCode = '33068' or zipCode = '33069' or zipCode = '33069' or zipCode = '33071' or zipCode = '33071' or zipCode = '33072' or zipCode = '33073' or zipCode = '33073' or zipCode = '33073' or zipCode = '33073' or zipCode = '33073' or zipCode = '33073' or zipCode = '33074' or zipCode = '33074' or zipCode = '33074' or zipCode = '33074' or zipCode = '33075' or zipCode = '33075' or zipCode = '33076' or zipCode = '33076' or zipCode = '33076' or zipCode = '33076' or zipCode = '33077' or zipCode = '33077' or zipCode = '33081' or zipCode = '33081' or zipCode = '33081' or zipCode = '33082' or zipCode = '33082' or zipCode = '33082' or zipCode = '33082' or zipCode = '33083' or zipCode = '33083' or zipCode = '33083' or zipCode = '33084' or zipCode = '33084' or zipCode = '33084' or zipCode = '33093' or zipCode = '33093' or zipCode = '33093' or zipCode = '33093' or zipCode = '33097' or zipCode = '33097' or zipCode = '33101' or zipCode = '33102' or zipCode = '33109' or zipCode = '33109' or zipCode = '33109' or zipCode = '33111' or zipCode = '33112' or zipCode = '33112' or zipCode = '33116' or zipCode = '33119' or zipCode = '33119' or zipCode = '33122' or zipCode = '33122' or zipCode = '33122' or zipCode = '33122' or zipCode = '33138' or zipCode = '33139' or zipCode = '33139' or zipCode = '33139' or zipCode = '33139' or zipCode = '33140' or zipCode = '33140' or zipCode = '33140' or zipCode = '33141' or zipCode = '33141' or zipCode = '33141' or zipCode = '33141' or zipCode = '33141' or zipCode = '33141' or zipCode = '33142' or zipCode = '33062' or zipCode = '33062' or zipCode = '33062' or zipCode = '33062' or zipCode = '33063' or zipCode = '33063' or zipCode = '33063' or zipCode = '33064' or zipCode = '33064' or zipCode = '33064' or zipCode = '33064' or zipCode = '33064' or zipCode = '33065' or zipCode = '33065' or zipCode = '33065' or zipCode = '33066' or zipCode = '33066' or zipCode = '33067' or zipCode = '33067' or zipCode = '33067' or zipCode = '33068' or zipCode = '33068' or zipCode = '33125' or zipCode = '33127' or zipCode = '33128' or zipCode = '33130' or zipCode = '33131' or zipCode = '33132' or zipCode = '33132' or zipCode = '33136' or zipCode = '33137' or zipCode = '33138' or zipCode = '33138' or zipCode = '33147' or zipCode = '33147' or zipCode = '33150' or zipCode = '33150' or zipCode = '33150' or zipCode = '33151' or zipCode = '33152' or zipCode = '33153' or zipCode = '33153' or zipCode = '33154' or zipCode = '33154' or zipCode = '33154' or zipCode = '33154' or zipCode = '33154' or zipCode = '33154' or zipCode = '33154' or zipCode = '33154' or zipCode = '33154' or zipCode = '33159' or zipCode = '33160' or zipCode = '33160' or zipCode = '33160' or zipCode = '33160' or zipCode = '33160' or zipCode = '33160' or zipCode = '33160' or zipCode = '33160' or zipCode = '33161' or zipCode = '33161' or zipCode = '33161' or zipCode = '33161' or zipCode = '33161' or zipCode = '33161' or zipCode = '33161' or zipCode = '33162' or zipCode = '33162' or zipCode = '33162' or zipCode = '33162' or zipCode = '33162' or zipCode = '33162' or zipCode = '33162' or zipCode = '33162' or zipCode = '33163' or zipCode = '33163' or zipCode = '33164' or zipCode = '33164' or zipCode = '33166' or zipCode = '33166' or zipCode = '33166' or zipCode = '33166' or zipCode = '33166' or zipCode = '33166' or zipCode = '33166' or zipCode = '33167' or zipCode = '33167' or zipCode = '33167' or zipCode = '33168' or zipCode = '33168' or zipCode = '33168' or zipCode = '33169' or zipCode = '33169' or zipCode = '33169' or zipCode = '33169' or zipCode = '33169' or zipCode = '33188' or zipCode = '33188' or zipCode = '33238' or zipCode = '33239' or zipCode = '33239' or zipCode = '33239' or zipCode = '33242' or zipCode = '33243' or zipCode = '33243' or zipCode = '33245' or zipCode = '33247' or zipCode = '33257' or zipCode = '33257' or zipCode = '33257' or zipCode = '33261' or zipCode = '33261' or zipCode = '33261' or zipCode = '33261' or zipCode = '33261' or zipCode = '33265' or zipCode = '33265' or zipCode = '33265' or zipCode = '33266' or zipCode = '33266' or zipCode = '33269' or zipCode = '33280' or zipCode = '33280' or zipCode = '33280' or zipCode = '33299' or zipCode = '33301' or zipCode = '33301' or zipCode = '33302' or zipCode = '33308' or zipCode = '33308' or zipCode = '33308' or zipCode = '33308' or zipCode = '33309' or zipCode = '33309' or zipCode = '33309' or zipCode = '33309' or zipCode = '33309' or zipCode = '33309' or zipCode = '33309' or zipCode = '33310' or zipCode = '33310' or zipCode = '33310' or zipCode = '33311' or zipCode = '33311' or zipCode = '33311' or zipCode = '33311' or zipCode = '33311' or zipCode = '33311' or zipCode = '33311' or zipCode = '33311' or zipCode = '33314' or zipCode = '33315' or zipCode = '33315' or zipCode = '33316' or zipCode = '33316' or zipCode = '33316' or zipCode = '33316' or zipCode = '33317' or zipCode = '33317' or zipCode = '33317' or zipCode = '33317' or zipCode = '33318' or zipCode = '33318' or zipCode = '33318' or zipCode = '33319' or zipCode = '33319' or zipCode = '33319' or zipCode = '33319' or zipCode = '33319' or zipCode = '33319' or zipCode = '33319' or zipCode = '33319' or zipCode = '33324' or zipCode = '33324' or zipCode = '33324' or zipCode = '33324' or zipCode = '33325' or zipCode = '33325' or zipCode = '33325' or zipCode = '33325' or zipCode = '33325' or zipCode = '33325' or zipCode = '33326' or zipCode = '33326' or zipCode = '33326' or zipCode = '33326' or zipCode = '33326' or zipCode = '33326' or zipCode = '33326' or zipCode = '33326' or zipCode = '33327' or zipCode = '33327' or zipCode = '33327' or zipCode = '33327' or zipCode = '33179' or zipCode = '33179' or zipCode = '33179' or zipCode = '33179' or zipCode = '33180' or zipCode = '33180' or zipCode = '33180' or zipCode = '33180' or zipCode = '33180' or zipCode = '33181' or zipCode = '33181' or zipCode = '33181' or zipCode = '33181' or zipCode = '33181' or zipCode = '33181' or zipCode = '33197' or zipCode = '33197' or zipCode = '33231' or zipCode = '33231' or zipCode = '33302' or zipCode = '33303' or zipCode = '33303' or zipCode = '33304' or zipCode = '33304' or zipCode = '33304' or zipCode = '33304' or zipCode = '33305' or zipCode = '33305' or zipCode = '33305' or zipCode = '33305' or zipCode = '33305' or zipCode = '33306' or zipCode = '33306' or zipCode = '33306' or zipCode = '33306' or zipCode = '33307' or zipCode = '33307' or zipCode = '33307' or zipCode = '33308' or zipCode = '33308' or zipCode = '33308' or zipCode = '33312' or zipCode = '33312' or zipCode = '33312' or zipCode = '33312' or zipCode = '33312' or zipCode = '33312' or zipCode = '33312' or zipCode = '33312' or zipCode = '33312' or zipCode = '33313' or zipCode = '33313' or zipCode = '33313' or zipCode = '33313' or zipCode = '33313' or zipCode = '33313' or zipCode = '33313' or zipCode = '33313' or zipCode = '33313' or zipCode = '33314' or zipCode = '33314' or zipCode = '33314' or zipCode = '33314' or zipCode = '33319' or zipCode = '33319' or zipCode = '33319' or zipCode = '33320' or zipCode = '33320' or zipCode = '33320' or zipCode = '33321' or zipCode = '33321' or zipCode = '33321' or zipCode = '33321' or zipCode = '33321' or zipCode = '33321' or zipCode = '33321' or zipCode = '33322' or zipCode = '33322' or zipCode = '33322' or zipCode = '33322' or zipCode = '33323' or zipCode = '33323' or zipCode = '33323' or zipCode = '33323' or zipCode = '33323' or zipCode = '33328' or zipCode = '33328' or zipCode = '33328' or zipCode = '33328' or zipCode = '33329' or zipCode = '33329' or zipCode = '33329' or zipCode = '33329' or zipCode = '33330' or zipCode = '33330' or zipCode = '33330' or zipCode = '33330' or zipCode = '33330' or zipCode = '33330' or zipCode = '33330' or zipCode = '33330' or zipCode = '33330' or zipCode = '33331' or zipCode = '33331' or zipCode = '33331' or zipCode = '33331' or zipCode = '33331' or zipCode = '33337' or zipCode = '33337' or zipCode = '33337' or zipCode = '33338' or zipCode = '33338' or zipCode = '33338' or zipCode = '33339' or zipCode = '33339' or zipCode = '33340' or zipCode = '33340' or zipCode = '33345' or zipCode = '33345' or zipCode = '33345' or zipCode = '33346' or zipCode = '33346' or zipCode = '33348' or zipCode = '33348' or zipCode = '33349' or zipCode = '33349' or zipCode = '33351' or zipCode = '33351' or zipCode = '33351' or zipCode = '33351' or zipCode = '33351' or zipCode = '33355' or zipCode = '33355' or zipCode = '33355' or zipCode = '33355' or zipCode = '33355' or zipCode = '33359' or zipCode = '33359' or zipCode = '33359' or zipCode = '33359' or zipCode = '33388' or zipCode = '33388' or zipCode = '33388' or zipCode = '33388' or zipCode = '33394' or zipCode = '33394' or zipCode = '33394' or zipCode = '33394' or zipCode = '33331' or zipCode = '33331' or zipCode = '33331' or zipCode = '33332' or zipCode = '33332' or zipCode = '33332' or zipCode = '33332' or zipCode = '33332' or zipCode = '33332' or zipCode = '33332' or zipCode = '33332' or zipCode = '33332' or zipCode = '33334' or zipCode = '33334' or zipCode = '33334' or zipCode = '33334' or zipCode = '33335' or zipCode = '33335' or zipCode = '33336' or zipCode = '33336' or zipCode = '33336' or zipCode = '33337' or zipCode = '33427' or zipCode = '33428' or zipCode = '33429' or zipCode = '33431' or zipCode = '33432' or zipCode = '33433' or zipCode = '33434' or zipCode = '33441' or zipCode = '33441' or zipCode = '33482' or zipCode = '33483' or zipCode = '33483' or zipCode = '33484' or zipCode = '33484' or zipCode = '33484' or zipCode = '33486' or zipCode = '33487' or zipCode = '33487' or zipCode = '33487' or zipCode = '33488' or zipCode = '33496' or zipCode = '33497' or zipCode = '33498' or zipCode = '33499' or zipCode = '33442' or zipCode = '33442' or zipCode = '33443' or zipCode = '33443' or zipCode = '33444' or zipCode = '33445' or zipCode = '33446' or zipCode = '33446' or zipCode = '33446' or zipCode = '33447' or zipCode = '33448' or zipCode = '33448' or zipCode = '33448' or zipCode = '33481' or zipCode = '33004' or zipCode = '33008' or zipCode = '33009' or zipCode = '33010' or zipCode = '33012' or zipCode = '33013' or zipCode = '33014' or zipCode = '33015' or zipCode = '33016' or zipCode = '33018' or zipCode = '33019' or zipCode = '33020' or zipCode = '33021' or zipCode = '33022' or zipCode = '33023' or zipCode = '33024' or zipCode = '33025' or zipCode = '33026' or zipCode = '33027' or zipCode = '33028' or zipCode = '33029' or zipCode = '33047' or zipCode = '33054' or zipCode = '33055' or zipCode = '33056' or zipCode = '33058' or zipCode = '33060' or zipCode = '33061' or zipCode = '33062' or zipCode = '33063' or zipCode = '33064' or zipCode = '33065' or zipCode = '33066' or zipCode = '33067' or zipCode = '33068' or zipCode = '33069' or zipCode = '33071' or zipCode = '33072' or zipCode = '33073' or zipCode = '33074' or zipCode = '33075' or zipCode = '33076' or zipCode = '33077' or zipCode = '33081' or zipCode = '33082' or zipCode = '33083' or zipCode = '33084' or zipCode = '33093' or zipCode = '33097' or zipCode = '33101' or zipCode = '33109' or zipCode = '33110' or zipCode = '33119' or zipCode = '33125' or zipCode = '33127' or zipCode = '33128' or zipCode = '33130' or zipCode = '33131' or zipCode = '33132' or zipCode = '33136' or zipCode = '33137' or zipCode = '33138' or zipCode = '33139' or zipCode = '33140' or zipCode = '33141' or zipCode = '33142' or zipCode = '33147' or zipCode = '33150' or zipCode = '33151' or zipCode = '33153' or zipCode = '33154' or zipCode = '33160' or zipCode = '33161' or zipCode = '33162' or zipCode = '33163' or zipCode = '33166' or zipCode = '33167' or zipCode = '33168' or zipCode = '33169' or zipCode = '33178' or zipCode = '33179' or zipCode = '33180' or zipCode = '33181' or zipCode = '33195' or zipCode = '33201' or zipCode = '33301' or zipCode = '33302' or zipCode = '33303' or zipCode = '33304' or zipCode = '33305' or zipCode = '33306' or zipCode = '33307' or zipCode = '33308' or zipCode = '33309' or zipCode = '33310' or zipCode = '33311' or zipCode = '33312' or zipCode = '33313' or zipCode = '33314' or zipCode = '33315' or zipCode = '33316' or zipCode = '33317' or zipCode = '33318' or zipCode = '33319' or zipCode = '33320' or zipCode = '33321' or zipCode = '33322' or zipCode = '33323' or zipCode = '33324' or zipCode = '33325' or zipCode = '33326' or zipCode = '33327' or zipCode = '33328' or zipCode = '33329' or zipCode = '33330' or zipCode = '33331' or zipCode = '33332' or zipCode = '33334' or zipCode = '33335' or zipCode = '33337' or zipCode = '33338' or zipCode = '33339' or zipCode = '33340' or zipCode = '33345' or zipCode = '33346' or zipCode = '33348' or zipCode = '33349' or zipCode = '33351' or zipCode = '33352' or zipCode = '33355' or zipCode = '33359' or zipCode = '33388' or zipCode = '33394' or zipCode = '33427' or zipCode = '33428' or zipCode = '33431' or zipCode = '33432' or zipCode = '33433' or zipCode = '33434' or zipCode = '33441' or zipCode = '33442' or zipCode = '33443' or zipCode = '33444' or zipCode = '33445' or zipCode = '33446' or zipCode = '33483' or zipCode = '33484' or zipCode = '33486' or zipCode = '33487' or zipCode = '33496' or zipCode = '33498' or zipCode = '33515') 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 ='33002' or zipCode = '33004' or zipCode = '33004' or zipCode = '33008' or zipCode = '33008' or zipCode = '33008' or zipCode = '33009' or zipCode = '33009' or zipCode = '33009' or zipCode = '33009' or zipCode = '33009' or zipCode = '33010' or zipCode = '33010' or zipCode = '33010' or zipCode = '33011' or zipCode = '33011' or zipCode = '33012' or zipCode = '33012' or zipCode = '33013' or zipCode = '33013' or zipCode = '33014' or zipCode = '33014' or zipCode = '33014' or zipCode = '33014' or zipCode = '33014' or zipCode = '33014' or zipCode = '33015' or zipCode = '33015' or zipCode = '33015' or zipCode = '33015' or zipCode = '33015' or zipCode = '33015' or zipCode = '33016' or zipCode = '33016' or zipCode = '33016' or zipCode = '33016' or zipCode = '33016' or zipCode = '33017' or zipCode = '33017' or zipCode = '33017' or zipCode = '33018' or zipCode = '33018' or zipCode = '33018' or zipCode = '33018' or zipCode = '33018' or zipCode = '33019' or zipCode = '33019' or zipCode = '33020' or zipCode = '33020' or zipCode = '33021' or zipCode = '33021' or zipCode = '33022' or zipCode = '33022' or zipCode = '33023' or zipCode = '33023' or zipCode = '33023' or zipCode = '33023' or zipCode = '33023' or zipCode = '33023' or zipCode = '33023' or zipCode = '33023' or zipCode = '33024' or zipCode = '33024' or zipCode = '33024' or zipCode = '33024' or zipCode = '33024' or zipCode = '33024' or zipCode = '33025' or zipCode = '33025' or zipCode = '33025' or zipCode = '33025' or zipCode = '33026' or zipCode = '33026' or zipCode = '33026' or zipCode = '33026' or zipCode = '33026' or zipCode = '33027' or zipCode = '33027' or zipCode = '33027' or zipCode = '33027' or zipCode = '33028' or zipCode = '33028' or zipCode = '33028' or zipCode = '33028' or zipCode = '33029' or zipCode = '33029' or zipCode = '33029' or zipCode = '33029' or zipCode = '33029' or zipCode = '33054' or zipCode = '33054' or zipCode = '33054' or zipCode = '33055' or zipCode = '33055' or zipCode = '33055' or zipCode = '33055' or zipCode = '33056' or zipCode = '33056' or zipCode = '33056' or zipCode = '33056' or zipCode = '33060' or zipCode = '33061' or zipCode = '33062' or zipCode = '33068' or zipCode = '33068' or zipCode = '33069' or zipCode = '33069' or zipCode = '33071' or zipCode = '33071' or zipCode = '33072' or zipCode = '33073' or zipCode = '33073' or zipCode = '33073' or zipCode = '33073' or zipCode = '33073' or zipCode = '33073' or zipCode = '33074' or zipCode = '33074' or zipCode = '33074' or zipCode = '33074' or zipCode = '33075' or zipCode = '33075' or zipCode = '33076' or zipCode = '33076' or zipCode = '33076' or zipCode = '33076' or zipCode = '33077' or zipCode = '33077' or zipCode = '33081' or zipCode = '33081' or zipCode = '33081' or zipCode = '33082' or zipCode = '33082' or zipCode = '33082' or zipCode = '33082' or zipCode = '33083' or zipCode = '33083' or zipCode = '33083' or zipCode = '33084' or zipCode = '33084' or zipCode = '33084' or zipCode = '33093' or zipCode = '33093' or zipCode = '33093' or zipCode = '33093' or zipCode = '33097' or zipCode = '33097' or zipCode = '33101' or zipCode = '33102' or zipCode = '33109' or zipCode = '33109' or zipCode = '33109' or zipCode = '33111' or zipCode = '33112' or zipCode = '33112' or zipCode = '33116' or zipCode = '33119' or zipCode = '33119' or zipCode = '33122' or zipCode = '33122' or zipCode = '33122' or zipCode = '33122' or zipCode = '33138' or zipCode = '33139' or zipCode = '33139' or zipCode = '33139' or zipCode = '33139' or zipCode = '33140' or zipCode = '33140' or zipCode = '33140' or zipCode = '33141' or zipCode = '33141' or zipCode = '33141' or zipCode = '33141' or zipCode = '33141' or zipCode = '33141' or zipCode = '33142' or zipCode = '33062' or zipCode = '33062' or zipCode = '33062' or zipCode = '33062' or zipCode = '33063' or zipCode = '33063' or zipCode = '33063' or zipCode = '33064' or zipCode = '33064' or zipCode = '33064' or zipCode = '33064' or zipCode = '33064' or zipCode = '33065' or zipCode = '33065' or zipCode = '33065' or zipCode = '33066' or zipCode = '33066' or zipCode = '33067' or zipCode = '33067' or zipCode = '33067' or zipCode = '33068' or zipCode = '33068' or zipCode = '33125' or zipCode = '33127' or zipCode = '33128' or zipCode = '33130' or zipCode = '33131' or zipCode = '33132' or zipCode = '33132' or zipCode = '33136' or zipCode = '33137' or zipCode = '33138' or zipCode = '33138' or zipCode = '33147' or zipCode = '33147' or zipCode = '33150' or zipCode = '33150' or zipCode = '33150' or zipCode = '33151' or zipCode = '33152' or zipCode = '33153' or zipCode = '33153' or zipCode = '33154' or zipCode = '33154' or zipCode = '33154' or zipCode = '33154' or zipCode = '33154' or zipCode = '33154' or zipCode = '33154' or zipCode = '33154' or zipCode = '33154' or zipCode = '33159' or zipCode = '33160' or zipCode = '33160' or zipCode = '33160' or zipCode = '33160' or zipCode = '33160' or zipCode = '33160' or zipCode = '33160' or zipCode = '33160' or zipCode = '33161' or zipCode = '33161' or zipCode = '33161' or zipCode = '33161' or zipCode = '33161' or zipCode = '33161' or zipCode = '33161' or zipCode = '33162' or zipCode = '33162' or zipCode = '33162' or zipCode = '33162' or zipCode = '33162' or zipCode = '33162' or zipCode = '33162' or zipCode = '33162' or zipCode = '33163' or zipCode = '33163' or zipCode = '33164' or zipCode = '33164' or zipCode = '33166' or zipCode = '33166' or zipCode = '33166' or zipCode = '33166' or zipCode = '33166' or zipCode = '33166' or zipCode = '33166' or zipCode = '33167' or zipCode = '33167' or zipCode = '33167' or zipCode = '33168' or zipCode = '33168' or zipCode = '33168' or zipCode = '33169' or zipCode = '33169' or zipCode = '33169' or zipCode = '33169' or zipCode = '33169' or zipCode = '33188' or zipCode = '33188' or zipCode = '33238' or zipCode = '33239' or zipCode = '33239' or zipCode = '33239' or zipCode = '33242' or zipCode = '33243' or zipCode = '33243' or zipCode = '33245' or zipCode = '33247' or zipCode = '33257' or zipCode = '33257' or zipCode = '33257' or zipCode = '33261' or zipCode = '33261' or zipCode = '33261' or zipCode = '33261' or zipCode = '33261' or zipCode = '33265' or zipCode = '33265' or zipCode = '33265' or zipCode = '33266' or zipCode = '33266' or zipCode = '33269' or zipCode = '33280' or zipCode = '33280' or zipCode = '33280' or zipCode = '33299' or zipCode = '33301' or zipCode = '33301' or zipCode = '33302' or zipCode = '33308' or zipCode = '33308' or zipCode = '33308' or zipCode = '33308' or zipCode = '33309' or zipCode = '33309' or zipCode = '33309' or zipCode = '33309' or zipCode = '33309' or zipCode = '33309' or zipCode = '33309' or zipCode = '33310' or zipCode = '33310' or zipCode = '33310' or zipCode = '33311' or zipCode = '33311' or zipCode = '33311' or zipCode = '33311' or zipCode = '33311' or zipCode = '33311' or zipCode = '33311' or zipCode = '33311' or zipCode = '33314' or zipCode = '33315' or zipCode = '33315' or zipCode = '33316' or zipCode = '33316' or zipCode = '33316' or zipCode = '33316' or zipCode = '33317' or zipCode = '33317' or zipCode = '33317' or zipCode = '33317' or zipCode = '33318' or zipCode = '33318' or zipCode = '33318' or zipCode = '33319' or zipCode = '33319' or zipCode = '33319' or zipCode = '33319' or zipCode = '33319' or zipCode = '33319' or zipCode = '33319' or zipCode = '33319' or zipCode = '33324' or zipCode = '33324' or zipCode = '33324' or zipCode = '33324' or zipCode = '33325' or zipCode = '33325' or zipCode = '33325' or zipCode = '33325' or zipCode = '33325' or zipCode = '33325' or zipCode = '33326' or zipCode = '33326' or zipCode = '33326' or zipCode = '33326' or zipCode = '33326' or zipCode = '33326' or zipCode = '33326' or zipCode = '33326' or zipCode = '33327' or zipCode = '33327' or zipCode = '33327' or zipCode = '33327' or zipCode = '33179' or zipCode = '33179' or zipCode = '33179' or zipCode = '33179' or zipCode = '33180' or zipCode = '33180' or zipCode = '33180' or zipCode = '33180' or zipCode = '33180' or zipCode = '33181' or zipCode = '33181' or zipCode = '33181' or zipCode = '33181' or zipCode = '33181' or zipCode = '33181' or zipCode = '33197' or zipCode = '33197' or zipCode = '33231' or zipCode = '33231' or zipCode = '33302' or zipCode = '33303' or zipCode = '33303' or zipCode = '33304' or zipCode = '33304' or zipCode = '33304' or zipCode = '33304' or zipCode = '33305' or zipCode = '33305' or zipCode = '33305' or zipCode = '33305' or zipCode = '33305' or zipCode = '33306' or zipCode = '33306' or zipCode = '33306' or zipCode = '33306' or zipCode = '33307' or zipCode = '33307' or zipCode = '33307' or zipCode = '33308' or zipCode = '33308' or zipCode = '33308' or zipCode = '33312' or zipCode = '33312' or zipCode = '33312' or zipCode = '33312' or zipCode = '33312' or zipCode = '33312' or zipCode = '33312' or zipCode = '33312' or zipCode = '33312' or zipCode = '33313' or zipCode = '33313' or zipCode = '33313' or zipCode = '33313' or zipCode = '33313' or zipCode = '33313' or zipCode = '33313' or zipCode = '33313' or zipCode = '33313' or zipCode = '33314' or zipCode = '33314' or zipCode = '33314' or zipCode = '33314' or zipCode = '33319' or zipCode = '33319' or zipCode = '33319' or zipCode = '33320' or zipCode = '33320' or zipCode = '33320' or zipCode = '33321' or zipCode = '33321' or zipCode = '33321' or zipCode = '33321' or zipCode = '33321' or zipCode = '33321' or zipCode = '33321' or zipCode = '33322' or zipCode = '33322' or zipCode = '33322' or zipCode = '33322' or zipCode = '33323' or zipCode = '33323' or zipCode = '33323' or zipCode = '33323' or zipCode = '33323' or zipCode = '33328' or zipCode = '33328' or zipCode = '33328' or zipCode = '33328' or zipCode = '33329' or zipCode = '33329' or zipCode = '33329' or zipCode = '33329' or zipCode = '33330' or zipCode = '33330' or zipCode = '33330' or zipCode = '33330' or zipCode = '33330' or zipCode = '33330' or zipCode = '33330' or zipCode = '33330' or zipCode = '33330' or zipCode = '33331' or zipCode = '33331' or zipCode = '33331' or zipCode = '33331' or zipCode = '33331' or zipCode = '33337' or zipCode = '33337' or zipCode = '33337' or zipCode = '33338' or zipCode = '33338' or zipCode = '33338' or zipCode = '33339' or zipCode = '33339' or zipCode = '33340' or zipCode = '33340' or zipCode = '33345' or zipCode = '33345' or zipCode = '33345' or zipCode = '33346' or zipCode = '33346' or zipCode = '33348' or zipCode = '33348' or zipCode = '33349' or zipCode = '33349' or zipCode = '33351' or zipCode = '33351' or zipCode = '33351' or zipCode = '33351' or zipCode = '33351' or zipCode = '33355' or zipCode = '33355' or zipCode = '33355' or zipCode = '33355' or zipCode = '33355' or zipCode = '33359' or zipCode = '33359' or zipCode = '33359' or zipCode = '33359' or zipCode = '33388' or zipCode = '33388' or zipCode = '33388' or zipCode = '33388' or zipCode = '33394' or zipCode = '33394' or zipCode = '33394' or zipCode = '33394' or zipCode = '33331' or zipCode = '33331' or zipCode = '33331' or zipCode = '33332' or zipCode = '33332' or zipCode = '33332' or zipCode = '33332' or zipCode = '33332' or zipCode = '33332' or zipCode = '33332' or zipCode = '33332' or zipCode = '33332' or zipCode = '33334' or zipCode = '33334' or zipCode = '33334' or zipCode = '33334' or zipCode = '33335' or zipCode = '33335' or zipCode = '33336' or zipCode = '33336' or zipCode = '33336' or zipCode = '33337' or zipCode = '33427' or zipCode = '33428' or zipCode = '33429' or zipCode = '33431' or zipCode = '33432' or zipCode = '33433' or zipCode = '33434' or zipCode = '33441' or zipCode = '33441' or zipCode = '33482' or zipCode = '33483' or zipCode = '33483' or zipCode = '33484' or zipCode = '33484' or zipCode = '33484' or zipCode = '33486' or zipCode = '33487' or zipCode = '33487' or zipCode = '33487' or zipCode = '33488' or zipCode = '33496' or zipCode = '33497' or zipCode = '33498' or zipCode = '33499' or zipCode = '33442' or zipCode = '33442' or zipCode = '33443' or zipCode = '33443' or zipCode = '33444' or zipCode = '33445' or zipCode = '33446' or zipCode = '33446' or zipCode = '33446' or zipCode = '33447' or zipCode = '33448' or zipCode = '33448' or zipCode = '33448' or zipCode = '33481' or zipCode = '33004' or zipCode = '33008' or zipCode = '33009' or zipCode = '33010' or zipCode = '33012' or zipCode = '33013' or zipCode = '33014' or zipCode = '33015' or zipCode = '33016' or zipCode = '33018' or zipCode = '33019' or zipCode = '33020' or zipCode = '33021' or zipCode = '33022' or zipCode = '33023' or zipCode = '33024' or zipCode = '33025' or zipCode = '33026' or zipCode = '33027' or zipCode = '33028' or zipCode = '33029' or zipCode = '33047' or zipCode = '33054' or zipCode = '33055' or zipCode = '33056' or zipCode = '33058' or zipCode = '33060' or zipCode = '33061' or zipCode = '33062' or zipCode = '33063' or zipCode = '33064' or zipCode = '33065' or zipCode = '33066' or zipCode = '33067' or zipCode = '33068' or zipCode = '33069' or zipCode = '33071' or zipCode = '33072' or zipCode = '33073' or zipCode = '33074' or zipCode = '33075' or zipCode = '33076' or zipCode = '33077' or zipCode = '33081' or zipCode = '33082' or zipCode = '33083' or zipCode = '33084' or zipCode = '33093' or zipCode = '33097' or zipCode = '33101' or zipCode = '33109' or zipCode = '33110' or zipCode = '33119' or zipCode = '33125' or zipCode = '33127' or zipCode = '33128' or zipCode = '33130' or zipCode = '33131' or zipCode = '33132' or zipCode = '33136' or zipCode = '33137' or zipCode = '33138' or zipCode = '33139' or zipCode = '33140' or zipCode = '33141' or zipCode = '33142' or zipCode = '33147' or zipCode = '33150' or zipCode = '33151' or zipCode = '33153' or zipCode = '33154' or zipCode = '33160' or zipCode = '33161' or zipCode = '33162' or zipCode = '33163' or zipCode = '33166' or zipCode = '33167' or zipCode = '33168' or zipCode = '33169' or zipCode = '33178' or zipCode = '33179' or zipCode = '33180' or zipCode = '33181' or zipCode = '33195' or zipCode = '33201' or zipCode = '33301' or zipCode = '33302' or zipCode = '33303' or zipCode = '33304' or zipCode = '33305' or zipCode = '33306' or zipCode = '33307' or zipCode = '33308' or zipCode = '33309' or zipCode = '33310' or zipCode = '33311' or zipCode = '33312' or zipCode = '33313' or zipCode = '33314' or zipCode = '33315' or zipCode = '33316' or zipCode = '33317' or zipCode = '33318' or zipCode = '33319' or zipCode = '33320' or zipCode = '33321' or zipCode = '33322' or zipCode = '33323' or zipCode = '33324' or zipCode = '33325' or zipCode = '33326' or zipCode = '33327' or zipCode = '33328' or zipCode = '33329' or zipCode = '33330' or zipCode = '33331' or zipCode = '33332' or zipCode = '33334' or zipCode = '33335' or zipCode = '33337' or zipCode = '33338' or zipCode = '33339' or zipCode = '33340' or zipCode = '33345' or zipCode = '33346' or zipCode = '33348' or zipCode = '33349' or zipCode = '33351' or zipCode = '33352' or zipCode = '33355' or zipCode = '33359' or zipCode = '33388' or zipCode = '33394' or zipCode = '33427' or zipCode = '33428' or zipCode = '33431' or zipCode = '33432' or zipCode = '33433' or zipCode = '33434' or zipCode = '33441' or zipCode = '33442' or zipCode = '33443' or zipCode = '33444' or zipCode = '33445' or zipCode = '33446' or zipCode = '33483' or zipCode = '33484' or zipCode = '33486' or zipCode = '33487' or zipCode = '33496' or zipCode = '33498' or zipCode = '33515') 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 ='33002' or property_zip = '33004' or property_zip = '33004' or property_zip = '33008' or property_zip = '33008' or property_zip = '33008' or property_zip = '33009' or property_zip = '33009' or property_zip = '33009' or property_zip = '33009' or property_zip = '33009' or property_zip = '33010' or property_zip = '33010' or property_zip = '33010' or property_zip = '33011' or property_zip = '33011' or property_zip = '33012' or property_zip = '33012' or property_zip = '33013' or property_zip = '33013' or property_zip = '33014' or property_zip = '33014' or property_zip = '33014' or property_zip = '33014' or property_zip = '33014' or property_zip = '33014' or property_zip = '33015' or property_zip = '33015' or property_zip = '33015' or property_zip = '33015' or property_zip = '33015' or property_zip = '33015' or property_zip = '33016' or property_zip = '33016' or property_zip = '33016' or property_zip = '33016' or property_zip = '33016' or property_zip = '33017' or property_zip = '33017' or property_zip = '33017' or property_zip = '33018' or property_zip = '33018' or property_zip = '33018' or property_zip = '33018' or property_zip = '33018' or property_zip = '33019' or property_zip = '33019' or property_zip = '33020' or property_zip = '33020' or property_zip = '33021' or property_zip = '33021' or property_zip = '33022' or property_zip = '33022' or property_zip = '33023' or property_zip = '33023' or property_zip = '33023' or property_zip = '33023' or property_zip = '33023' or property_zip = '33023' or property_zip = '33023' or property_zip = '33023' or property_zip = '33024' or property_zip = '33024' or property_zip = '33024' or property_zip = '33024' or property_zip = '33024' or property_zip = '33024' or property_zip = '33025' or property_zip = '33025' or property_zip = '33025' or property_zip = '33025' or property_zip = '33026' or property_zip = '33026' or property_zip = '33026' or property_zip = '33026' or property_zip = '33026' or property_zip = '33027' or property_zip = '33027' or property_zip = '33027' or property_zip = '33027' or property_zip = '33028' or property_zip = '33028' or property_zip = '33028' or property_zip = '33028' or property_zip = '33029' or property_zip = '33029' or property_zip = '33029' or property_zip = '33029' or property_zip = '33029' or property_zip = '33054' or property_zip = '33054' or property_zip = '33054' or property_zip = '33055' or property_zip = '33055' or property_zip = '33055' or property_zip = '33055' or property_zip = '33056' or property_zip = '33056' or property_zip = '33056' or property_zip = '33056' or property_zip = '33060' or property_zip = '33061' or property_zip = '33062' or property_zip = '33068' or property_zip = '33068' or property_zip = '33069' or property_zip = '33069' or property_zip = '33071' or property_zip = '33071' or property_zip = '33072' or property_zip = '33073' or property_zip = '33073' or property_zip = '33073' or property_zip = '33073' or property_zip = '33073' or property_zip = '33073' or property_zip = '33074' or property_zip = '33074' or property_zip = '33074' or property_zip = '33074' or property_zip = '33075' or property_zip = '33075' or property_zip = '33076' or property_zip = '33076' or property_zip = '33076' or property_zip = '33076' or property_zip = '33077' or property_zip = '33077' or property_zip = '33081' or property_zip = '33081' or property_zip = '33081' or property_zip = '33082' or property_zip = '33082' or property_zip = '33082' or property_zip = '33082' or property_zip = '33083' or property_zip = '33083' or property_zip = '33083' or property_zip = '33084' or property_zip = '33084' or property_zip = '33084' or property_zip = '33093' or property_zip = '33093' or property_zip = '33093' or property_zip = '33093' or property_zip = '33097' or property_zip = '33097' or property_zip = '33101' or property_zip = '33102' or property_zip = '33109' or property_zip = '33109' or property_zip = '33109' or property_zip = '33111' or property_zip = '33112' or property_zip = '33112' or property_zip = '33116' or property_zip = '33119' or property_zip = '33119' or property_zip = '33122' or property_zip = '33122' or property_zip = '33122' or property_zip = '33122' or property_zip = '33138' or property_zip = '33139' or property_zip = '33139' or property_zip = '33139' or property_zip = '33139' or property_zip = '33140' or property_zip = '33140' or property_zip = '33140' or property_zip = '33141' or property_zip = '33141' or property_zip = '33141' or property_zip = '33141' or property_zip = '33141' or property_zip = '33141' or property_zip = '33142' or property_zip = '33062' or property_zip = '33062' or property_zip = '33062' or property_zip = '33062' or property_zip = '33063' or property_zip = '33063' or property_zip = '33063' or property_zip = '33064' or property_zip = '33064' or property_zip = '33064' or property_zip = '33064' or property_zip = '33064' or property_zip = '33065' or property_zip = '33065' or property_zip = '33065' or property_zip = '33066' or property_zip = '33066' or property_zip = '33067' or property_zip = '33067' or property_zip = '33067' or property_zip = '33068' or property_zip = '33068' or property_zip = '33125' or property_zip = '33127' or property_zip = '33128' or property_zip = '33130' or property_zip = '33131' or property_zip = '33132' or property_zip = '33132' or property_zip = '33136' or property_zip = '33137' or property_zip = '33138' or property_zip = '33138' or property_zip = '33147' or property_zip = '33147' or property_zip = '33150' or property_zip = '33150' or property_zip = '33150' or property_zip = '33151' or property_zip = '33152' or property_zip = '33153' or property_zip = '33153' or property_zip = '33154' or property_zip = '33154' or property_zip = '33154' or property_zip = '33154' or property_zip = '33154' or property_zip = '33154' or property_zip = '33154' or property_zip = '33154' or property_zip = '33154' or property_zip = '33159' or property_zip = '33160' or property_zip = '33160' or property_zip = '33160' or property_zip = '33160' or property_zip = '33160' or property_zip = '33160' or property_zip = '33160' or property_zip = '33160' or property_zip = '33161' or property_zip = '33161' or property_zip = '33161' or property_zip = '33161' or property_zip = '33161' or property_zip = '33161' or property_zip = '33161' or property_zip = '33162' or property_zip = '33162' or property_zip = '33162' or property_zip = '33162' or property_zip = '33162' or property_zip = '33162' or property_zip = '33162' or property_zip = '33162' or property_zip = '33163' or property_zip = '33163' or property_zip = '33164' or property_zip = '33164' or property_zip = '33166' or property_zip = '33166' or property_zip = '33166' or property_zip = '33166' or property_zip = '33166' or property_zip = '33166' or property_zip = '33166' or property_zip = '33167' or property_zip = '33167' or property_zip = '33167' or property_zip = '33168' or property_zip = '33168' or property_zip = '33168' or property_zip = '33169' or property_zip = '33169' or property_zip = '33169' or property_zip = '33169' or property_zip = '33169' or property_zip = '33188' or property_zip = '33188' or property_zip = '33238' or property_zip = '33239' or property_zip = '33239' or property_zip = '33239' or property_zip = '33242' or property_zip = '33243' or property_zip = '33243' or property_zip = '33245' or property_zip = '33247' or property_zip = '33257' or property_zip = '33257' or property_zip = '33257' or property_zip = '33261' or property_zip = '33261' or property_zip = '33261' or property_zip = '33261' or property_zip = '33261' or property_zip = '33265' or property_zip = '33265' or property_zip = '33265' or property_zip = '33266' or property_zip = '33266' or property_zip = '33269' or property_zip = '33280' or property_zip = '33280' or property_zip = '33280' or property_zip = '33299' or property_zip = '33301' or property_zip = '33301' or property_zip = '33302' or property_zip = '33308' or property_zip = '33308' or property_zip = '33308' or property_zip = '33308' or property_zip = '33309' or property_zip = '33309' or property_zip = '33309' or property_zip = '33309' or property_zip = '33309' or property_zip = '33309' or property_zip = '33309' or property_zip = '33310' or property_zip = '33310' or property_zip = '33310' or property_zip = '33311' or property_zip = '33311' or property_zip = '33311' or property_zip = '33311' or property_zip = '33311' or property_zip = '33311' or property_zip = '33311' or property_zip = '33311' or property_zip = '33314' or property_zip = '33315' or property_zip = '33315' or property_zip = '33316' or property_zip = '33316' or property_zip = '33316' or property_zip = '33316' or property_zip = '33317' or property_zip = '33317' or property_zip = '33317' or property_zip = '33317' or property_zip = '33318' or property_zip = '33318' or property_zip = '33318' or property_zip = '33319' or property_zip = '33319' or property_zip = '33319' or property_zip = '33319' or property_zip = '33319' or property_zip = '33319' or property_zip = '33319' or property_zip = '33319' or property_zip = '33324' or property_zip = '33324' or property_zip = '33324' or property_zip = '33324' or property_zip = '33325' or property_zip = '33325' or property_zip = '33325' or property_zip = '33325' or property_zip = '33325' or property_zip = '33325' or property_zip = '33326' or property_zip = '33326' or property_zip = '33326' or property_zip = '33326' or property_zip = '33326' or property_zip = '33326' or property_zip = '33326' or property_zip = '33326' or property_zip = '33327' or property_zip = '33327' or property_zip = '33327' or property_zip = '33327' or property_zip = '33179' or property_zip = '33179' or property_zip = '33179' or property_zip = '33179' or property_zip = '33180' or property_zip = '33180' or property_zip = '33180' or property_zip = '33180' or property_zip = '33180' or property_zip = '33181' or property_zip = '33181' or property_zip = '33181' or property_zip = '33181' or property_zip = '33181' or property_zip = '33181' or property_zip = '33197' or property_zip = '33197' or property_zip = '33231' or property_zip = '33231' or property_zip = '33302' or property_zip = '33303' or property_zip = '33303' or property_zip = '33304' or property_zip = '33304' or property_zip = '33304' or property_zip = '33304' or property_zip = '33305' or property_zip = '33305' or property_zip = '33305' or property_zip = '33305' or property_zip = '33305' or property_zip = '33306' or property_zip = '33306' or property_zip = '33306' or property_zip = '33306' or property_zip = '33307' or property_zip = '33307' or property_zip = '33307' or property_zip = '33308' or property_zip = '33308' or property_zip = '33308' or property_zip = '33312' or property_zip = '33312' or property_zip = '33312' or property_zip = '33312' or property_zip = '33312' or property_zip = '33312' or property_zip = '33312' or property_zip = '33312' or property_zip = '33312' or property_zip = '33313' or property_zip = '33313' or property_zip = '33313' or property_zip = '33313' or property_zip = '33313' or property_zip = '33313' or property_zip = '33313' or property_zip = '33313' or property_zip = '33313' or property_zip = '33314' or property_zip = '33314' or property_zip = '33314' or property_zip = '33314' or property_zip = '33319' or property_zip = '33319' or property_zip = '33319' or property_zip = '33320' or property_zip = '33320' or property_zip = '33320' or property_zip = '33321' or property_zip = '33321' or property_zip = '33321' or property_zip = '33321' or property_zip = '33321' or property_zip = '33321' or property_zip = '33321' or property_zip = '33322' or property_zip = '33322' or property_zip = '33322' or property_zip = '33322' or property_zip = '33323' or property_zip = '33323' or property_zip = '33323' or property_zip = '33323' or property_zip = '33323' or property_zip = '33328' or property_zip = '33328' or property_zip = '33328' or property_zip = '33328' or property_zip = '33329' or property_zip = '33329' or property_zip = '33329' or property_zip = '33329' or property_zip = '33330' or property_zip = '33330' or property_zip = '33330' or property_zip = '33330' or property_zip = '33330' or property_zip = '33330' or property_zip = '33330' or property_zip = '33330' or property_zip = '33330' or property_zip = '33331' or property_zip = '33331' or property_zip = '33331' or property_zip = '33331' or property_zip = '33331' or property_zip = '33337' or property_zip = '33337' or property_zip = '33337' or property_zip = '33338' or property_zip = '33338' or property_zip = '33338' or property_zip = '33339' or property_zip = '33339' or property_zip = '33340' or property_zip = '33340' or property_zip = '33345' or property_zip = '33345' or property_zip = '33345' or property_zip = '33346' or property_zip = '33346' or property_zip = '33348' or property_zip = '33348' or property_zip = '33349' or property_zip = '33349' or property_zip = '33351' or property_zip = '33351' or property_zip = '33351' or property_zip = '33351' or property_zip = '33351' or property_zip = '33355' or property_zip = '33355' or property_zip = '33355' or property_zip = '33355' or property_zip = '33355' or property_zip = '33359' or property_zip = '33359' or property_zip = '33359' or property_zip = '33359' or property_zip = '33388' or property_zip = '33388' or property_zip = '33388' or property_zip = '33388' or property_zip = '33394' or property_zip = '33394' or property_zip = '33394' or property_zip = '33394' or property_zip = '33331' or property_zip = '33331' or property_zip = '33331' or property_zip = '33332' or property_zip = '33332' or property_zip = '33332' or property_zip = '33332' or property_zip = '33332' or property_zip = '33332' or property_zip = '33332' or property_zip = '33332' or property_zip = '33332' or property_zip = '33334' or property_zip = '33334' or property_zip = '33334' or property_zip = '33334' or property_zip = '33335' or property_zip = '33335' or property_zip = '33336' or property_zip = '33336' or property_zip = '33336' or property_zip = '33337' or property_zip = '33427' or property_zip = '33428' or property_zip = '33429' or property_zip = '33431' or property_zip = '33432' or property_zip = '33433' or property_zip = '33434' or property_zip = '33441' or property_zip = '33441' or property_zip = '33482' or property_zip = '33483' or property_zip = '33483' or property_zip = '33484' or property_zip = '33484' or property_zip = '33484' or property_zip = '33486' or property_zip = '33487' or property_zip = '33487' or property_zip = '33487' or property_zip = '33488' or property_zip = '33496' or property_zip = '33497' or property_zip = '33498' or property_zip = '33499' or property_zip = '33442' or property_zip = '33442' or property_zip = '33443' or property_zip = '33443' or property_zip = '33444' or property_zip = '33445' or property_zip = '33446' or property_zip = '33446' or property_zip = '33446' or property_zip = '33447' or property_zip = '33448' or property_zip = '33448' or property_zip = '33448' or property_zip = '33481' or property_zip = '33004' or property_zip = '33008' or property_zip = '33009' or property_zip = '33010' or property_zip = '33012' or property_zip = '33013' or property_zip = '33014' or property_zip = '33015' or property_zip = '33016' or property_zip = '33018' or property_zip = '33019' or property_zip = '33020' or property_zip = '33021' or property_zip = '33022' or property_zip = '33023' or property_zip = '33024' or property_zip = '33025' or property_zip = '33026' or property_zip = '33027' or property_zip = '33028' or property_zip = '33029' or property_zip = '33047' or property_zip = '33054' or property_zip = '33055' or property_zip = '33056' or property_zip = '33058' or property_zip = '33060' or property_zip = '33061' or property_zip = '33062' or property_zip = '33063' or property_zip = '33064' or property_zip = '33065' or property_zip = '33066' or property_zip = '33067' or property_zip = '33068' or property_zip = '33069' or property_zip = '33071' or property_zip = '33072' or property_zip = '33073' or property_zip = '33074' or property_zip = '33075' or property_zip = '33076' or property_zip = '33077' or property_zip = '33081' or property_zip = '33082' or property_zip = '33083' or property_zip = '33084' or property_zip = '33093' or property_zip = '33097' or property_zip = '33101' or property_zip = '33109' or property_zip = '33110' or property_zip = '33119' or property_zip = '33125' or property_zip = '33127' or property_zip = '33128' or property_zip = '33130' or property_zip = '33131' or property_zip = '33132' or property_zip = '33136' or property_zip = '33137' or property_zip = '33138' or property_zip = '33139' or property_zip = '33140' or property_zip = '33141' or property_zip = '33142' or property_zip = '33147' or property_zip = '33150' or property_zip = '33151' or property_zip = '33153' or property_zip = '33154' or property_zip = '33160' or property_zip = '33161' or property_zip = '33162' or property_zip = '33163' or property_zip = '33166' or property_zip = '33167' or property_zip = '33168' or property_zip = '33169' or property_zip = '33178' or property_zip = '33179' or property_zip = '33180' or property_zip = '33181' or property_zip = '33195' or property_zip = '33201' or property_zip = '33301' or property_zip = '33302' or property_zip = '33303' or property_zip = '33304' or property_zip = '33305' or property_zip = '33306' or property_zip = '33307' or property_zip = '33308' or property_zip = '33309' or property_zip = '33310' or property_zip = '33311' or property_zip = '33312' or property_zip = '33313' or property_zip = '33314' or property_zip = '33315' or property_zip = '33316' or property_zip = '33317' or property_zip = '33318' or property_zip = '33319' or property_zip = '33320' or property_zip = '33321' or property_zip = '33322' or property_zip = '33323' or property_zip = '33324' or property_zip = '33325' or property_zip = '33326' or property_zip = '33327' or property_zip = '33328' or property_zip = '33329' or property_zip = '33330' or property_zip = '33331' or property_zip = '33332' or property_zip = '33334' or property_zip = '33335' or property_zip = '33337' or property_zip = '33338' or property_zip = '33339' or property_zip = '33340' or property_zip = '33345' or property_zip = '33346' or property_zip = '33348' or property_zip = '33349' or property_zip = '33351' or property_zip = '33352' or property_zip = '33355' or property_zip = '33359' or property_zip = '33388' or property_zip = '33394' or property_zip = '33427' or property_zip = '33428' or property_zip = '33431' or property_zip = '33432' or property_zip = '33433' or property_zip = '33434' or property_zip = '33441' or property_zip = '33442' or property_zip = '33443' or property_zip = '33444' or property_zip = '33445' or property_zip = '33446' or property_zip = '33483' or property_zip = '33484' or property_zip = '33486' or property_zip = '33487' or property_zip = '33496' or property_zip = '33498' or property_zip = '33515') 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 ='33002' or zip = '33004' or zip = '33004' or zip = '33008' or zip = '33008' or zip = '33008' or zip = '33009' or zip = '33009' or zip = '33009' or zip = '33009' or zip = '33009' or zip = '33010' or zip = '33010' or zip = '33010' or zip = '33011' or zip = '33011' or zip = '33012' or zip = '33012' or zip = '33013' or zip = '33013' or zip = '33014' or zip = '33014' or zip = '33014' or zip = '33014' or zip = '33014' or zip = '33014' or zip = '33015' or zip = '33015' or zip = '33015' or zip = '33015' or zip = '33015' or zip = '33015' or zip = '33016' or zip = '33016' or zip = '33016' or zip = '33016' or zip = '33016' or zip = '33017' or zip = '33017' or zip = '33017' or zip = '33018' or zip = '33018' or zip = '33018' or zip = '33018' or zip = '33018' or zip = '33019' or zip = '33019' or zip = '33020' or zip = '33020' or zip = '33021' or zip = '33021' or zip = '33022' or zip = '33022' or zip = '33023' or zip = '33023' or zip = '33023' or zip = '33023' or zip = '33023' or zip = '33023' or zip = '33023' or zip = '33023' or zip = '33024' or zip = '33024' or zip = '33024' or zip = '33024' or zip = '33024' or zip = '33024' or zip = '33025' or zip = '33025' or zip = '33025' or zip = '33025' or zip = '33026' or zip = '33026' or zip = '33026' or zip = '33026' or zip = '33026' or zip = '33027' or zip = '33027' or zip = '33027' or zip = '33027' or zip = '33028' or zip = '33028' or zip = '33028' or zip = '33028' or zip = '33029' or zip = '33029' or zip = '33029' or zip = '33029' or zip = '33029' or zip = '33054' or zip = '33054' or zip = '33054' or zip = '33055' or zip = '33055' or zip = '33055' or zip = '33055' or zip = '33056' or zip = '33056' or zip = '33056' or zip = '33056' or zip = '33060' or zip = '33061' or zip = '33062' or zip = '33068' or zip = '33068' or zip = '33069' or zip = '33069' or zip = '33071' or zip = '33071' or zip = '33072' or zip = '33073' or zip = '33073' or zip = '33073' or zip = '33073' or zip = '33073' or zip = '33073' or zip = '33074' or zip = '33074' or zip = '33074' or zip = '33074' or zip = '33075' or zip = '33075' or zip = '33076' or zip = '33076' or zip = '33076' or zip = '33076' or zip = '33077' or zip = '33077' or zip = '33081' or zip = '33081' or zip = '33081' or zip = '33082' or zip = '33082' or zip = '33082' or zip = '33082' or zip = '33083' or zip = '33083' or zip = '33083' or zip = '33084' or zip = '33084' or zip = '33084' or zip = '33093' or zip = '33093' or zip = '33093' or zip = '33093' or zip = '33097' or zip = '33097' or zip = '33101' or zip = '33102' or zip = '33109' or zip = '33109' or zip = '33109' or zip = '33111' or zip = '33112' or zip = '33112' or zip = '33116' or zip = '33119' or zip = '33119' or zip = '33122' or zip = '33122' or zip = '33122' or zip = '33122' or zip = '33138' or zip = '33139' or zip = '33139' or zip = '33139' or zip = '33139' or zip = '33140' or zip = '33140' or zip = '33140' or zip = '33141' or zip = '33141' or zip = '33141' or zip = '33141' or zip = '33141' or zip = '33141' or zip = '33142' or zip = '33062' or zip = '33062' or zip = '33062' or zip = '33062' or zip = '33063' or zip = '33063' or zip = '33063' or zip = '33064' or zip = '33064' or zip = '33064' or zip = '33064' or zip = '33064' or zip = '33065' or zip = '33065' or zip = '33065' or zip = '33066' or zip = '33066' or zip = '33067' or zip = '33067' or zip = '33067' or zip = '33068' or zip = '33068' or zip = '33125' or zip = '33127' or zip = '33128' or zip = '33130' or zip = '33131' or zip = '33132' or zip = '33132' or zip = '33136' or zip = '33137' or zip = '33138' or zip = '33138' or zip = '33147' or zip = '33147' or zip = '33150' or zip = '33150' or zip = '33150' or zip = '33151' or zip = '33152' or zip = '33153' or zip = '33153' or zip = '33154' or zip = '33154' or zip = '33154' or zip = '33154' or zip = '33154' or zip = '33154' or zip = '33154' or zip = '33154' or zip = '33154' or zip = '33159' or zip = '33160' or zip = '33160' or zip = '33160' or zip = '33160' or zip = '33160' or zip = '33160' or zip = '33160' or zip = '33160' or zip = '33161' or zip = '33161' or zip = '33161' or zip = '33161' or zip = '33161' or zip = '33161' or zip = '33161' or zip = '33162' or zip = '33162' or zip = '33162' or zip = '33162' or zip = '33162' or zip = '33162' or zip = '33162' or zip = '33162' or zip = '33163' or zip = '33163' or zip = '33164' or zip = '33164' or zip = '33166' or zip = '33166' or zip = '33166' or zip = '33166' or zip = '33166' or zip = '33166' or zip = '33166' or zip = '33167' or zip = '33167' or zip = '33167' or zip = '33168' or zip = '33168' or zip = '33168' or zip = '33169' or zip = '33169' or zip = '33169' or zip = '33169' or zip = '33169' or zip = '33188' or zip = '33188' or zip = '33238' or zip = '33239' or zip = '33239' or zip = '33239' or zip = '33242' or zip = '33243' or zip = '33243' or zip = '33245' or zip = '33247' or zip = '33257' or zip = '33257' or zip = '33257' or zip = '33261' or zip = '33261' or zip = '33261' or zip = '33261' or zip = '33261' or zip = '33265' or zip = '33265' or zip = '33265' or zip = '33266' or zip = '33266' or zip = '33269' or zip = '33280' or zip = '33280' or zip = '33280' or zip = '33299' or zip = '33301' or zip = '33301' or zip = '33302' or zip = '33308' or zip = '33308' or zip = '33308' or zip = '33308' or zip = '33309' or zip = '33309' or zip = '33309' or zip = '33309' or zip = '33309' or zip = '33309' or zip = '33309' or zip = '33310' or zip = '33310' or zip = '33310' or zip = '33311' or zip = '33311' or zip = '33311' or zip = '33311' or zip = '33311' or zip = '33311' or zip = '33311' or zip = '33311' or zip = '33314' or zip = '33315' or zip = '33315' or zip = '33316' or zip = '33316' or zip = '33316' or zip = '33316' or zip = '33317' or zip = '33317' or zip = '33317' or zip = '33317' or zip = '33318' or zip = '33318' or zip = '33318' or zip = '33319' or zip = '33319' or zip = '33319' or zip = '33319' or zip = '33319' or zip = '33319' or zip = '33319' or zip = '33319' or zip = '33324' or zip = '33324' or zip = '33324' or zip = '33324' or zip = '33325' or zip = '33325' or zip = '33325' or zip = '33325' or zip = '33325' or zip = '33325' or zip = '33326' or zip = '33326' or zip = '33326' or zip = '33326' or zip = '33326' or zip = '33326' or zip = '33326' or zip = '33326' or zip = '33327' or zip = '33327' or zip = '33327' or zip = '33327' or zip = '33179' or zip = '33179' or zip = '33179' or zip = '33179' or zip = '33180' or zip = '33180' or zip = '33180' or zip = '33180' or zip = '33180' or zip = '33181' or zip = '33181' or zip = '33181' or zip = '33181' or zip = '33181' or zip = '33181' or zip = '33197' or zip = '33197' or zip = '33231' or zip = '33231' or zip = '33302' or zip = '33303' or zip = '33303' or zip = '33304' or zip = '33304' or zip = '33304' or zip = '33304' or zip = '33305' or zip = '33305' or zip = '33305' or zip = '33305' or zip = '33305' or zip = '33306' or zip = '33306' or zip = '33306' or zip = '33306' or zip = '33307' or zip = '33307' or zip = '33307' or zip = '33308' or zip = '33308' or zip = '33308' or zip = '33312' or zip = '33312' or zip = '33312' or zip = '33312' or zip = '33312' or zip = '33312' or zip = '33312' or zip = '33312' or zip = '33312' or zip = '33313' or zip = '33313' or zip = '33313' or zip = '33313' or zip = '33313' or zip = '33313' or zip = '33313' or zip = '33313' or zip = '33313' or zip = '33314' or zip = '33314' or zip = '33314' or zip = '33314' or zip = '33319' or zip = '33319' or zip = '33319' or zip = '33320' or zip = '33320' or zip = '33320' or zip = '33321' or zip = '33321' or zip = '33321' or zip = '33321' or zip = '33321' or zip = '33321' or zip = '33321' or zip = '33322' or zip = '33322' or zip = '33322' or zip = '33322' or zip = '33323' or zip = '33323' or zip = '33323' or zip = '33323' or zip = '33323' or zip = '33328' or zip = '33328' or zip = '33328' or zip = '33328' or zip = '33329' or zip = '33329' or zip = '33329' or zip = '33329' or zip = '33330' or zip = '33330' or zip = '33330' or zip = '33330' or zip = '33330' or zip = '33330' or zip = '33330' or zip = '33330' or zip = '33330' or zip = '33331' or zip = '33331' or zip = '33331' or zip = '33331' or zip = '33331' or zip = '33337' or zip = '33337' or zip = '33337' or zip = '33338' or zip = '33338' or zip = '33338' or zip = '33339' or zip = '33339' or zip = '33340' or zip = '33340' or zip = '33345' or zip = '33345' or zip = '33345' or zip = '33346' or zip = '33346' or zip = '33348' or zip = '33348' or zip = '33349' or zip = '33349' or zip = '33351' or zip = '33351' or zip = '33351' or zip = '33351' or zip = '33351' or zip = '33355' or zip = '33355' or zip = '33355' or zip = '33355' or zip = '33355' or zip = '33359' or zip = '33359' or zip = '33359' or zip = '33359' or zip = '33388' or zip = '33388' or zip = '33388' or zip = '33388' or zip = '33394' or zip = '33394' or zip = '33394' or zip = '33394' or zip = '33331' or zip = '33331' or zip = '33331' or zip = '33332' or zip = '33332' or zip = '33332' or zip = '33332' or zip = '33332' or zip = '33332' or zip = '33332' or zip = '33332' or zip = '33332' or zip = '33334' or zip = '33334' or zip = '33334' or zip = '33334' or zip = '33335' or zip = '33335' or zip = '33336' or zip = '33336' or zip = '33336' or zip = '33337' or zip = '33427' or zip = '33428' or zip = '33429' or zip = '33431' or zip = '33432' or zip = '33433' or zip = '33434' or zip = '33441' or zip = '33441' or zip = '33482' or zip = '33483' or zip = '33483' or zip = '33484' or zip = '33484' or zip = '33484' or zip = '33486' or zip = '33487' or zip = '33487' or zip = '33487' or zip = '33488' or zip = '33496' or zip = '33497' or zip = '33498' or zip = '33499' or zip = '33442' or zip = '33442' or zip = '33443' or zip = '33443' or zip = '33444' or zip = '33445' or zip = '33446' or zip = '33446' or zip = '33446' or zip = '33447' or zip = '33448' or zip = '33448' or zip = '33448' or zip = '33481' or zip = '33004' or zip = '33008' or zip = '33009' or zip = '33010' or zip = '33012' or zip = '33013' or zip = '33014' or zip = '33015' or zip = '33016' or zip = '33018' or zip = '33019' or zip = '33020' or zip = '33021' or zip = '33022' or zip = '33023' or zip = '33024' or zip = '33025' or zip = '33026' or zip = '33027' or zip = '33028' or zip = '33029' or zip = '33047' or zip = '33054' or zip = '33055' or zip = '33056' or zip = '33058' or zip = '33060' or zip = '33061' or zip = '33062' or zip = '33063' or zip = '33064' or zip = '33065' or zip = '33066' or zip = '33067' or zip = '33068' or zip = '33069' or zip = '33071' or zip = '33072' or zip = '33073' or zip = '33074' or zip = '33075' or zip = '33076' or zip = '33077' or zip = '33081' or zip = '33082' or zip = '33083' or zip = '33084' or zip = '33093' or zip = '33097' or zip = '33101' or zip = '33109' or zip = '33110' or zip = '33119' or zip = '33125' or zip = '33127' or zip = '33128' or zip = '33130' or zip = '33131' or zip = '33132' or zip = '33136' or zip = '33137' or zip = '33138' or zip = '33139' or zip = '33140' or zip = '33141' or zip = '33142' or zip = '33147' or zip = '33150' or zip = '33151' or zip = '33153' or zip = '33154' or zip = '33160' or zip = '33161' or zip = '33162' or zip = '33163' or zip = '33166' or zip = '33167' or zip = '33168' or zip = '33169' or zip = '33178' or zip = '33179' or zip = '33180' or zip = '33181' or zip = '33195' or zip = '33201' or zip = '33301' or zip = '33302' or zip = '33303' or zip = '33304' or zip = '33305' or zip = '33306' or zip = '33307' or zip = '33308' or zip = '33309' or zip = '33310' or zip = '33311' or zip = '33312' or zip = '33313' or zip = '33314' or zip = '33315' or zip = '33316' or zip = '33317' or zip = '33318' or zip = '33319' or zip = '33320' or zip = '33321' or zip = '33322' or zip = '33323' or zip = '33324' or zip = '33325' or zip = '33326' or zip = '33327' or zip = '33328' or zip = '33329' or zip = '33330' or zip = '33331' or zip = '33332' or zip = '33334' or zip = '33335' or zip = '33337' or zip = '33338' or zip = '33339' or zip = '33340' or zip = '33345' or zip = '33346' or zip = '33348' or zip = '33349' or zip = '33351' or zip = '33352' or zip = '33355' or zip = '33359' or zip = '33388' or zip = '33394' or zip = '33427' or zip = '33428' or zip = '33431' or zip = '33432' or zip = '33433' or zip = '33434' or zip = '33441' or zip = '33442' or zip = '33443' or zip = '33444' or zip = '33445' or zip = '33446' or zip = '33483' or zip = '33484' or zip = '33486' or zip = '33487' or zip = '33496' or zip = '33498' or zip = '33515')
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 = 'FORT LAUDERDALE' 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();