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


96+ High Potential Investor Deals Near austin [Refine]


********NOTICE: Displaying 96 of over 96 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 ='73301' or zipCode = '73301' or zipCode = '73344' or zipCode = '73344' or zipCode = '78610' or zipCode = '78610' or zipCode = '78610' or zipCode = '78612' or zipCode = '78612' or zipCode = '78613' or zipCode = '78617' or zipCode = '78617' or zipCode = '78617' or zipCode = '78619' or zipCode = '78620' or zipCode = '78620' or zipCode = '78620' or zipCode = '78620' or zipCode = '78627' or zipCode = '78628' or zipCode = '78628' or zipCode = '78628' or zipCode = '78630' or zipCode = '78634' or zipCode = '78634' or zipCode = '78640' or zipCode = '78640' or zipCode = '78640' or zipCode = '78641' or zipCode = '78641' or zipCode = '78641' or zipCode = '78645' or zipCode = '78645' or zipCode = '78645' or zipCode = '78645' or zipCode = '78646' or zipCode = '78660' or zipCode = '78664' or zipCode = '78664' or zipCode = '78664' or zipCode = '78665' or zipCode = '78669' or zipCode = '78669' or zipCode = '78711' or zipCode = '78712' or zipCode = '78712' or zipCode = '78712' or zipCode = '78712' or zipCode = '78713' or zipCode = '78714' or zipCode = '78715' or zipCode = '78716' or zipCode = '78717' or zipCode = '78717' or zipCode = '78718' or zipCode = '78719' or zipCode = '78719' or zipCode = '78720' or zipCode = '78721' or zipCode = '78722' or zipCode = '78723' or zipCode = '78724' or zipCode = '78725' or zipCode = '78725' or zipCode = '78726' or zipCode = '78727' or zipCode = '78728' or zipCode = '78729' or zipCode = '78651' or zipCode = '78651' or zipCode = '78652' or zipCode = '78653' or zipCode = '78653' or zipCode = '78653' or zipCode = '78653' or zipCode = '78653' or zipCode = '78653' or zipCode = '78653' or zipCode = '78653' or zipCode = '78680' or zipCode = '78681' or zipCode = '78682' or zipCode = '78682' or zipCode = '78683' or zipCode = '78691' or zipCode = '78701' or zipCode = '78702' or zipCode = '78703' or zipCode = '78703' or zipCode = '78704' or zipCode = '78704' or zipCode = '78705' or zipCode = '78708' or zipCode = '78709' or zipCode = '78710' or zipCode = '78729' or zipCode = '78730' or zipCode = '78731' or zipCode = '78731' or zipCode = '78732' or zipCode = '78732' or zipCode = '78732' or zipCode = '78733' or zipCode = '78733' or zipCode = '78733' or zipCode = '78734' or zipCode = '78734' or zipCode = '78734' or zipCode = '78734' or zipCode = '78734' or zipCode = '78735' or zipCode = '78735' or zipCode = '78735' or zipCode = '78736' or zipCode = '78736' or zipCode = '78736' or zipCode = '78736' or zipCode = '78736' or zipCode = '78737' or zipCode = '78738' or zipCode = '78738' or zipCode = '78738' or zipCode = '78738' or zipCode = '78738' or zipCode = '78738' or zipCode = '78738' or zipCode = '78739' or zipCode = '78741' or zipCode = '78741' or zipCode = '78742' or zipCode = '78744' or zipCode = '78744' or zipCode = '78744' or zipCode = '78744' or zipCode = '78745' or zipCode = '78745' or zipCode = '78746' or zipCode = '78746' or zipCode = '78746' or zipCode = '78746' or zipCode = '78747' or zipCode = '78748' or zipCode = '78748' or zipCode = '78769' or zipCode = '78772' or zipCode = '78772' or zipCode = '78773' or zipCode = '78773' or zipCode = '78774' or zipCode = '78774' or zipCode = '78778' or zipCode = '78778' or zipCode = '78779' or zipCode = '78779' or zipCode = '78780' or zipCode = '78780' or zipCode = '78781' or zipCode = '78781' or zipCode = '78783' or zipCode = '78783' or zipCode = '78785' or zipCode = '78785' or zipCode = '78789' or zipCode = '78789' or zipCode = '78799' or zipCode = '78799' or zipCode = '78749' or zipCode = '78749' or zipCode = '78750' or zipCode = '78751' or zipCode = '78752' or zipCode = '78753' or zipCode = '78753' or zipCode = '78754' or zipCode = '78754' or zipCode = '78754' or zipCode = '78755' or zipCode = '78756' or zipCode = '78757' or zipCode = '78758' or zipCode = '78759' or zipCode = '78759' or zipCode = '78760' or zipCode = '78761' or zipCode = '78762' or zipCode = '78763' or zipCode = '78764' or zipCode = '78765' or zipCode = '78766' or zipCode = '78767' or zipCode = '78768' or zipCode = '73301' or zipCode = '73344' or zipCode = '78610' or zipCode = '78612' or zipCode = '78613' or zipCode = '78615' or zipCode = '78617' or zipCode = '78619' or zipCode = '78620' or zipCode = '78621' or zipCode = '78626' or zipCode = '78628' or zipCode = '78630' or zipCode = '78634' or zipCode = '78640' or zipCode = '78641' or zipCode = '78645' or zipCode = '78646' or zipCode = '78651' or zipCode = '78652' or zipCode = '78653' or zipCode = '78660' or zipCode = '78664' or zipCode = '78667' or zipCode = '78669' or zipCode = '78680' or zipCode = '78681' or zipCode = '78682' or zipCode = '78683' or zipCode = '78691' or zipCode = '78701' or zipCode = '78702' or zipCode = '78703' or zipCode = '78704' or zipCode = '78705' or zipCode = '78708' or zipCode = '78709' or zipCode = '78710' or zipCode = '78711' or zipCode = '78712' or zipCode = '78713' or zipCode = '78714' or zipCode = '78715' or zipCode = '78716' or zipCode = '78717' or zipCode = '78718' or zipCode = '78719' or zipCode = '78720' or zipCode = '78721' or zipCode = '78722' or zipCode = '78723' or zipCode = '78724' or zipCode = '78725' or zipCode = '78726' or zipCode = '78727' or zipCode = '78728' or zipCode = '78729' or zipCode = '78730' or zipCode = '78731' or zipCode = '78732' or zipCode = '78733' or zipCode = '78734' or zipCode = '78735' or zipCode = '78736' or zipCode = '78737' or zipCode = '78738' or zipCode = '78739' or zipCode = '78741' or zipCode = '78742' or zipCode = '78744' or zipCode = '78745' or zipCode = '78746' or zipCode = '78747' or zipCode = '78748' or zipCode = '78749' or zipCode = '78750' or zipCode = '78751' or zipCode = '78752' or zipCode = '78753' or zipCode = '78754' or zipCode = '78755' or zipCode = '78756' or zipCode = '78757' or zipCode = '78758' or zipCode = '78759' or zipCode = '78760' or zipCode = '78761' or zipCode = '78762' or zipCode = '78763' or zipCode = '78764' or zipCode = '78765' or zipCode = '78766' or zipCode = '78767' or zipCode = '78768' or zipCode = '78769' or zipCode = '78771' or zipCode = '78772' or zipCode = '78773' or zipCode = '78774' or zipCode = '78778' or zipCode = '78779' or zipCode = '78780' or zipCode = '78781' or zipCode = '78782' or zipCode = '78783' or zipCode = '78785' or zipCode = '78786' or zipCode = '78787' or zipCode = '78788' or zipCode = '78789' or zipCode = '78972')
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 ='73301' or zipCode = '73301' or zipCode = '73344' or zipCode = '73344' or zipCode = '78610' or zipCode = '78610' or zipCode = '78610' or zipCode = '78612' or zipCode = '78612' or zipCode = '78613' or zipCode = '78617' or zipCode = '78617' or zipCode = '78617' or zipCode = '78619' or zipCode = '78620' or zipCode = '78620' or zipCode = '78620' or zipCode = '78620' or zipCode = '78627' or zipCode = '78628' or zipCode = '78628' or zipCode = '78628' or zipCode = '78630' or zipCode = '78634' or zipCode = '78634' or zipCode = '78640' or zipCode = '78640' or zipCode = '78640' or zipCode = '78641' or zipCode = '78641' or zipCode = '78641' or zipCode = '78645' or zipCode = '78645' or zipCode = '78645' or zipCode = '78645' or zipCode = '78646' or zipCode = '78660' or zipCode = '78664' or zipCode = '78664' or zipCode = '78664' or zipCode = '78665' or zipCode = '78669' or zipCode = '78669' or zipCode = '78711' or zipCode = '78712' or zipCode = '78712' or zipCode = '78712' or zipCode = '78712' or zipCode = '78713' or zipCode = '78714' or zipCode = '78715' or zipCode = '78716' or zipCode = '78717' or zipCode = '78717' or zipCode = '78718' or zipCode = '78719' or zipCode = '78719' or zipCode = '78720' or zipCode = '78721' or zipCode = '78722' or zipCode = '78723' or zipCode = '78724' or zipCode = '78725' or zipCode = '78725' or zipCode = '78726' or zipCode = '78727' or zipCode = '78728' or zipCode = '78729' or zipCode = '78651' or zipCode = '78651' or zipCode = '78652' or zipCode = '78653' or zipCode = '78653' or zipCode = '78653' or zipCode = '78653' or zipCode = '78653' or zipCode = '78653' or zipCode = '78653' or zipCode = '78653' or zipCode = '78680' or zipCode = '78681' or zipCode = '78682' or zipCode = '78682' or zipCode = '78683' or zipCode = '78691' or zipCode = '78701' or zipCode = '78702' or zipCode = '78703' or zipCode = '78703' or zipCode = '78704' or zipCode = '78704' or zipCode = '78705' or zipCode = '78708' or zipCode = '78709' or zipCode = '78710' or zipCode = '78729' or zipCode = '78730' or zipCode = '78731' or zipCode = '78731' or zipCode = '78732' or zipCode = '78732' or zipCode = '78732' or zipCode = '78733' or zipCode = '78733' or zipCode = '78733' or zipCode = '78734' or zipCode = '78734' or zipCode = '78734' or zipCode = '78734' or zipCode = '78734' or zipCode = '78735' or zipCode = '78735' or zipCode = '78735' or zipCode = '78736' or zipCode = '78736' or zipCode = '78736' or zipCode = '78736' or zipCode = '78736' or zipCode = '78737' or zipCode = '78738' or zipCode = '78738' or zipCode = '78738' or zipCode = '78738' or zipCode = '78738' or zipCode = '78738' or zipCode = '78738' or zipCode = '78739' or zipCode = '78741' or zipCode = '78741' or zipCode = '78742' or zipCode = '78744' or zipCode = '78744' or zipCode = '78744' or zipCode = '78744' or zipCode = '78745' or zipCode = '78745' or zipCode = '78746' or zipCode = '78746' or zipCode = '78746' or zipCode = '78746' or zipCode = '78747' or zipCode = '78748' or zipCode = '78748' or zipCode = '78769' or zipCode = '78772' or zipCode = '78772' or zipCode = '78773' or zipCode = '78773' or zipCode = '78774' or zipCode = '78774' or zipCode = '78778' or zipCode = '78778' or zipCode = '78779' or zipCode = '78779' or zipCode = '78780' or zipCode = '78780' or zipCode = '78781' or zipCode = '78781' or zipCode = '78783' or zipCode = '78783' or zipCode = '78785' or zipCode = '78785' or zipCode = '78789' or zipCode = '78789' or zipCode = '78799' or zipCode = '78799' or zipCode = '78749' or zipCode = '78749' or zipCode = '78750' or zipCode = '78751' or zipCode = '78752' or zipCode = '78753' or zipCode = '78753' or zipCode = '78754' or zipCode = '78754' or zipCode = '78754' or zipCode = '78755' or zipCode = '78756' or zipCode = '78757' or zipCode = '78758' or zipCode = '78759' or zipCode = '78759' or zipCode = '78760' or zipCode = '78761' or zipCode = '78762' or zipCode = '78763' or zipCode = '78764' or zipCode = '78765' or zipCode = '78766' or zipCode = '78767' or zipCode = '78768' or zipCode = '73301' or zipCode = '73344' or zipCode = '78610' or zipCode = '78612' or zipCode = '78613' or zipCode = '78615' or zipCode = '78617' or zipCode = '78619' or zipCode = '78620' or zipCode = '78621' or zipCode = '78626' or zipCode = '78628' or zipCode = '78630' or zipCode = '78634' or zipCode = '78640' or zipCode = '78641' or zipCode = '78645' or zipCode = '78646' or zipCode = '78651' or zipCode = '78652' or zipCode = '78653' or zipCode = '78660' or zipCode = '78664' or zipCode = '78667' or zipCode = '78669' or zipCode = '78680' or zipCode = '78681' or zipCode = '78682' or zipCode = '78683' or zipCode = '78691' or zipCode = '78701' or zipCode = '78702' or zipCode = '78703' or zipCode = '78704' or zipCode = '78705' or zipCode = '78708' or zipCode = '78709' or zipCode = '78710' or zipCode = '78711' or zipCode = '78712' or zipCode = '78713' or zipCode = '78714' or zipCode = '78715' or zipCode = '78716' or zipCode = '78717' or zipCode = '78718' or zipCode = '78719' or zipCode = '78720' or zipCode = '78721' or zipCode = '78722' or zipCode = '78723' or zipCode = '78724' or zipCode = '78725' or zipCode = '78726' or zipCode = '78727' or zipCode = '78728' or zipCode = '78729' or zipCode = '78730' or zipCode = '78731' or zipCode = '78732' or zipCode = '78733' or zipCode = '78734' or zipCode = '78735' or zipCode = '78736' or zipCode = '78737' or zipCode = '78738' or zipCode = '78739' or zipCode = '78741' or zipCode = '78742' or zipCode = '78744' or zipCode = '78745' or zipCode = '78746' or zipCode = '78747' or zipCode = '78748' or zipCode = '78749' or zipCode = '78750' or zipCode = '78751' or zipCode = '78752' or zipCode = '78753' or zipCode = '78754' or zipCode = '78755' or zipCode = '78756' or zipCode = '78757' or zipCode = '78758' or zipCode = '78759' or zipCode = '78760' or zipCode = '78761' or zipCode = '78762' or zipCode = '78763' or zipCode = '78764' or zipCode = '78765' or zipCode = '78766' or zipCode = '78767' or zipCode = '78768' or zipCode = '78769' or zipCode = '78771' or zipCode = '78772' or zipCode = '78773' or zipCode = '78774' or zipCode = '78778' or zipCode = '78779' or zipCode = '78780' or zipCode = '78781' or zipCode = '78782' or zipCode = '78783' or zipCode = '78785' or zipCode = '78786' or zipCode = '78787' or zipCode = '78788' or zipCode = '78789' or zipCode = '78972') 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 ='73301' or zipCode = '73301' or zipCode = '73344' or zipCode = '73344' or zipCode = '78610' or zipCode = '78610' or zipCode = '78610' or zipCode = '78612' or zipCode = '78612' or zipCode = '78613' or zipCode = '78617' or zipCode = '78617' or zipCode = '78617' or zipCode = '78619' or zipCode = '78620' or zipCode = '78620' or zipCode = '78620' or zipCode = '78620' or zipCode = '78627' or zipCode = '78628' or zipCode = '78628' or zipCode = '78628' or zipCode = '78630' or zipCode = '78634' or zipCode = '78634' or zipCode = '78640' or zipCode = '78640' or zipCode = '78640' or zipCode = '78641' or zipCode = '78641' or zipCode = '78641' or zipCode = '78645' or zipCode = '78645' or zipCode = '78645' or zipCode = '78645' or zipCode = '78646' or zipCode = '78660' or zipCode = '78664' or zipCode = '78664' or zipCode = '78664' or zipCode = '78665' or zipCode = '78669' or zipCode = '78669' or zipCode = '78711' or zipCode = '78712' or zipCode = '78712' or zipCode = '78712' or zipCode = '78712' or zipCode = '78713' or zipCode = '78714' or zipCode = '78715' or zipCode = '78716' or zipCode = '78717' or zipCode = '78717' or zipCode = '78718' or zipCode = '78719' or zipCode = '78719' or zipCode = '78720' or zipCode = '78721' or zipCode = '78722' or zipCode = '78723' or zipCode = '78724' or zipCode = '78725' or zipCode = '78725' or zipCode = '78726' or zipCode = '78727' or zipCode = '78728' or zipCode = '78729' or zipCode = '78651' or zipCode = '78651' or zipCode = '78652' or zipCode = '78653' or zipCode = '78653' or zipCode = '78653' or zipCode = '78653' or zipCode = '78653' or zipCode = '78653' or zipCode = '78653' or zipCode = '78653' or zipCode = '78680' or zipCode = '78681' or zipCode = '78682' or zipCode = '78682' or zipCode = '78683' or zipCode = '78691' or zipCode = '78701' or zipCode = '78702' or zipCode = '78703' or zipCode = '78703' or zipCode = '78704' or zipCode = '78704' or zipCode = '78705' or zipCode = '78708' or zipCode = '78709' or zipCode = '78710' or zipCode = '78729' or zipCode = '78730' or zipCode = '78731' or zipCode = '78731' or zipCode = '78732' or zipCode = '78732' or zipCode = '78732' or zipCode = '78733' or zipCode = '78733' or zipCode = '78733' or zipCode = '78734' or zipCode = '78734' or zipCode = '78734' or zipCode = '78734' or zipCode = '78734' or zipCode = '78735' or zipCode = '78735' or zipCode = '78735' or zipCode = '78736' or zipCode = '78736' or zipCode = '78736' or zipCode = '78736' or zipCode = '78736' or zipCode = '78737' or zipCode = '78738' or zipCode = '78738' or zipCode = '78738' or zipCode = '78738' or zipCode = '78738' or zipCode = '78738' or zipCode = '78738' or zipCode = '78739' or zipCode = '78741' or zipCode = '78741' or zipCode = '78742' or zipCode = '78744' or zipCode = '78744' or zipCode = '78744' or zipCode = '78744' or zipCode = '78745' or zipCode = '78745' or zipCode = '78746' or zipCode = '78746' or zipCode = '78746' or zipCode = '78746' or zipCode = '78747' or zipCode = '78748' or zipCode = '78748' or zipCode = '78769' or zipCode = '78772' or zipCode = '78772' or zipCode = '78773' or zipCode = '78773' or zipCode = '78774' or zipCode = '78774' or zipCode = '78778' or zipCode = '78778' or zipCode = '78779' or zipCode = '78779' or zipCode = '78780' or zipCode = '78780' or zipCode = '78781' or zipCode = '78781' or zipCode = '78783' or zipCode = '78783' or zipCode = '78785' or zipCode = '78785' or zipCode = '78789' or zipCode = '78789' or zipCode = '78799' or zipCode = '78799' or zipCode = '78749' or zipCode = '78749' or zipCode = '78750' or zipCode = '78751' or zipCode = '78752' or zipCode = '78753' or zipCode = '78753' or zipCode = '78754' or zipCode = '78754' or zipCode = '78754' or zipCode = '78755' or zipCode = '78756' or zipCode = '78757' or zipCode = '78758' or zipCode = '78759' or zipCode = '78759' or zipCode = '78760' or zipCode = '78761' or zipCode = '78762' or zipCode = '78763' or zipCode = '78764' or zipCode = '78765' or zipCode = '78766' or zipCode = '78767' or zipCode = '78768' or zipCode = '73301' or zipCode = '73344' or zipCode = '78610' or zipCode = '78612' or zipCode = '78613' or zipCode = '78615' or zipCode = '78617' or zipCode = '78619' or zipCode = '78620' or zipCode = '78621' or zipCode = '78626' or zipCode = '78628' or zipCode = '78630' or zipCode = '78634' or zipCode = '78640' or zipCode = '78641' or zipCode = '78645' or zipCode = '78646' or zipCode = '78651' or zipCode = '78652' or zipCode = '78653' or zipCode = '78660' or zipCode = '78664' or zipCode = '78667' or zipCode = '78669' or zipCode = '78680' or zipCode = '78681' or zipCode = '78682' or zipCode = '78683' or zipCode = '78691' or zipCode = '78701' or zipCode = '78702' or zipCode = '78703' or zipCode = '78704' or zipCode = '78705' or zipCode = '78708' or zipCode = '78709' or zipCode = '78710' or zipCode = '78711' or zipCode = '78712' or zipCode = '78713' or zipCode = '78714' or zipCode = '78715' or zipCode = '78716' or zipCode = '78717' or zipCode = '78718' or zipCode = '78719' or zipCode = '78720' or zipCode = '78721' or zipCode = '78722' or zipCode = '78723' or zipCode = '78724' or zipCode = '78725' or zipCode = '78726' or zipCode = '78727' or zipCode = '78728' or zipCode = '78729' or zipCode = '78730' or zipCode = '78731' or zipCode = '78732' or zipCode = '78733' or zipCode = '78734' or zipCode = '78735' or zipCode = '78736' or zipCode = '78737' or zipCode = '78738' or zipCode = '78739' or zipCode = '78741' or zipCode = '78742' or zipCode = '78744' or zipCode = '78745' or zipCode = '78746' or zipCode = '78747' or zipCode = '78748' or zipCode = '78749' or zipCode = '78750' or zipCode = '78751' or zipCode = '78752' or zipCode = '78753' or zipCode = '78754' or zipCode = '78755' or zipCode = '78756' or zipCode = '78757' or zipCode = '78758' or zipCode = '78759' or zipCode = '78760' or zipCode = '78761' or zipCode = '78762' or zipCode = '78763' or zipCode = '78764' or zipCode = '78765' or zipCode = '78766' or zipCode = '78767' or zipCode = '78768' or zipCode = '78769' or zipCode = '78771' or zipCode = '78772' or zipCode = '78773' or zipCode = '78774' or zipCode = '78778' or zipCode = '78779' or zipCode = '78780' or zipCode = '78781' or zipCode = '78782' or zipCode = '78783' or zipCode = '78785' or zipCode = '78786' or zipCode = '78787' or zipCode = '78788' or zipCode = '78789' or zipCode = '78972') 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 ='73301' or zipCode = '73301' or zipCode = '73344' or zipCode = '73344' or zipCode = '78610' or zipCode = '78610' or zipCode = '78610' or zipCode = '78612' or zipCode = '78612' or zipCode = '78613' or zipCode = '78617' or zipCode = '78617' or zipCode = '78617' or zipCode = '78619' or zipCode = '78620' or zipCode = '78620' or zipCode = '78620' or zipCode = '78620' or zipCode = '78627' or zipCode = '78628' or zipCode = '78628' or zipCode = '78628' or zipCode = '78630' or zipCode = '78634' or zipCode = '78634' or zipCode = '78640' or zipCode = '78640' or zipCode = '78640' or zipCode = '78641' or zipCode = '78641' or zipCode = '78641' or zipCode = '78645' or zipCode = '78645' or zipCode = '78645' or zipCode = '78645' or zipCode = '78646' or zipCode = '78660' or zipCode = '78664' or zipCode = '78664' or zipCode = '78664' or zipCode = '78665' or zipCode = '78669' or zipCode = '78669' or zipCode = '78711' or zipCode = '78712' or zipCode = '78712' or zipCode = '78712' or zipCode = '78712' or zipCode = '78713' or zipCode = '78714' or zipCode = '78715' or zipCode = '78716' or zipCode = '78717' or zipCode = '78717' or zipCode = '78718' or zipCode = '78719' or zipCode = '78719' or zipCode = '78720' or zipCode = '78721' or zipCode = '78722' or zipCode = '78723' or zipCode = '78724' or zipCode = '78725' or zipCode = '78725' or zipCode = '78726' or zipCode = '78727' or zipCode = '78728' or zipCode = '78729' or zipCode = '78651' or zipCode = '78651' or zipCode = '78652' or zipCode = '78653' or zipCode = '78653' or zipCode = '78653' or zipCode = '78653' or zipCode = '78653' or zipCode = '78653' or zipCode = '78653' or zipCode = '78653' or zipCode = '78680' or zipCode = '78681' or zipCode = '78682' or zipCode = '78682' or zipCode = '78683' or zipCode = '78691' or zipCode = '78701' or zipCode = '78702' or zipCode = '78703' or zipCode = '78703' or zipCode = '78704' or zipCode = '78704' or zipCode = '78705' or zipCode = '78708' or zipCode = '78709' or zipCode = '78710' or zipCode = '78729' or zipCode = '78730' or zipCode = '78731' or zipCode = '78731' or zipCode = '78732' or zipCode = '78732' or zipCode = '78732' or zipCode = '78733' or zipCode = '78733' or zipCode = '78733' or zipCode = '78734' or zipCode = '78734' or zipCode = '78734' or zipCode = '78734' or zipCode = '78734' or zipCode = '78735' or zipCode = '78735' or zipCode = '78735' or zipCode = '78736' or zipCode = '78736' or zipCode = '78736' or zipCode = '78736' or zipCode = '78736' or zipCode = '78737' or zipCode = '78738' or zipCode = '78738' or zipCode = '78738' or zipCode = '78738' or zipCode = '78738' or zipCode = '78738' or zipCode = '78738' or zipCode = '78739' or zipCode = '78741' or zipCode = '78741' or zipCode = '78742' or zipCode = '78744' or zipCode = '78744' or zipCode = '78744' or zipCode = '78744' or zipCode = '78745' or zipCode = '78745' or zipCode = '78746' or zipCode = '78746' or zipCode = '78746' or zipCode = '78746' or zipCode = '78747' or zipCode = '78748' or zipCode = '78748' or zipCode = '78769' or zipCode = '78772' or zipCode = '78772' or zipCode = '78773' or zipCode = '78773' or zipCode = '78774' or zipCode = '78774' or zipCode = '78778' or zipCode = '78778' or zipCode = '78779' or zipCode = '78779' or zipCode = '78780' or zipCode = '78780' or zipCode = '78781' or zipCode = '78781' or zipCode = '78783' or zipCode = '78783' or zipCode = '78785' or zipCode = '78785' or zipCode = '78789' or zipCode = '78789' or zipCode = '78799' or zipCode = '78799' or zipCode = '78749' or zipCode = '78749' or zipCode = '78750' or zipCode = '78751' or zipCode = '78752' or zipCode = '78753' or zipCode = '78753' or zipCode = '78754' or zipCode = '78754' or zipCode = '78754' or zipCode = '78755' or zipCode = '78756' or zipCode = '78757' or zipCode = '78758' or zipCode = '78759' or zipCode = '78759' or zipCode = '78760' or zipCode = '78761' or zipCode = '78762' or zipCode = '78763' or zipCode = '78764' or zipCode = '78765' or zipCode = '78766' or zipCode = '78767' or zipCode = '78768' or zipCode = '73301' or zipCode = '73344' or zipCode = '78610' or zipCode = '78612' or zipCode = '78613' or zipCode = '78615' or zipCode = '78617' or zipCode = '78619' or zipCode = '78620' or zipCode = '78621' or zipCode = '78626' or zipCode = '78628' or zipCode = '78630' or zipCode = '78634' or zipCode = '78640' or zipCode = '78641' or zipCode = '78645' or zipCode = '78646' or zipCode = '78651' or zipCode = '78652' or zipCode = '78653' or zipCode = '78660' or zipCode = '78664' or zipCode = '78667' or zipCode = '78669' or zipCode = '78680' or zipCode = '78681' or zipCode = '78682' or zipCode = '78683' or zipCode = '78691' or zipCode = '78701' or zipCode = '78702' or zipCode = '78703' or zipCode = '78704' or zipCode = '78705' or zipCode = '78708' or zipCode = '78709' or zipCode = '78710' or zipCode = '78711' or zipCode = '78712' or zipCode = '78713' or zipCode = '78714' or zipCode = '78715' or zipCode = '78716' or zipCode = '78717' or zipCode = '78718' or zipCode = '78719' or zipCode = '78720' or zipCode = '78721' or zipCode = '78722' or zipCode = '78723' or zipCode = '78724' or zipCode = '78725' or zipCode = '78726' or zipCode = '78727' or zipCode = '78728' or zipCode = '78729' or zipCode = '78730' or zipCode = '78731' or zipCode = '78732' or zipCode = '78733' or zipCode = '78734' or zipCode = '78735' or zipCode = '78736' or zipCode = '78737' or zipCode = '78738' or zipCode = '78739' or zipCode = '78741' or zipCode = '78742' or zipCode = '78744' or zipCode = '78745' or zipCode = '78746' or zipCode = '78747' or zipCode = '78748' or zipCode = '78749' or zipCode = '78750' or zipCode = '78751' or zipCode = '78752' or zipCode = '78753' or zipCode = '78754' or zipCode = '78755' or zipCode = '78756' or zipCode = '78757' or zipCode = '78758' or zipCode = '78759' or zipCode = '78760' or zipCode = '78761' or zipCode = '78762' or zipCode = '78763' or zipCode = '78764' or zipCode = '78765' or zipCode = '78766' or zipCode = '78767' or zipCode = '78768' or zipCode = '78769' or zipCode = '78771' or zipCode = '78772' or zipCode = '78773' or zipCode = '78774' or zipCode = '78778' or zipCode = '78779' or zipCode = '78780' or zipCode = '78781' or zipCode = '78782' or zipCode = '78783' or zipCode = '78785' or zipCode = '78786' or zipCode = '78787' or zipCode = '78788' or zipCode = '78789' or zipCode = '78972') 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 ='73301' or zipCode = '73301' or zipCode = '73344' or zipCode = '73344' or zipCode = '78610' or zipCode = '78610' or zipCode = '78610' or zipCode = '78612' or zipCode = '78612' or zipCode = '78613' or zipCode = '78617' or zipCode = '78617' or zipCode = '78617' or zipCode = '78619' or zipCode = '78620' or zipCode = '78620' or zipCode = '78620' or zipCode = '78620' or zipCode = '78627' or zipCode = '78628' or zipCode = '78628' or zipCode = '78628' or zipCode = '78630' or zipCode = '78634' or zipCode = '78634' or zipCode = '78640' or zipCode = '78640' or zipCode = '78640' or zipCode = '78641' or zipCode = '78641' or zipCode = '78641' or zipCode = '78645' or zipCode = '78645' or zipCode = '78645' or zipCode = '78645' or zipCode = '78646' or zipCode = '78660' or zipCode = '78664' or zipCode = '78664' or zipCode = '78664' or zipCode = '78665' or zipCode = '78669' or zipCode = '78669' or zipCode = '78711' or zipCode = '78712' or zipCode = '78712' or zipCode = '78712' or zipCode = '78712' or zipCode = '78713' or zipCode = '78714' or zipCode = '78715' or zipCode = '78716' or zipCode = '78717' or zipCode = '78717' or zipCode = '78718' or zipCode = '78719' or zipCode = '78719' or zipCode = '78720' or zipCode = '78721' or zipCode = '78722' or zipCode = '78723' or zipCode = '78724' or zipCode = '78725' or zipCode = '78725' or zipCode = '78726' or zipCode = '78727' or zipCode = '78728' or zipCode = '78729' or zipCode = '78651' or zipCode = '78651' or zipCode = '78652' or zipCode = '78653' or zipCode = '78653' or zipCode = '78653' or zipCode = '78653' or zipCode = '78653' or zipCode = '78653' or zipCode = '78653' or zipCode = '78653' or zipCode = '78680' or zipCode = '78681' or zipCode = '78682' or zipCode = '78682' or zipCode = '78683' or zipCode = '78691' or zipCode = '78701' or zipCode = '78702' or zipCode = '78703' or zipCode = '78703' or zipCode = '78704' or zipCode = '78704' or zipCode = '78705' or zipCode = '78708' or zipCode = '78709' or zipCode = '78710' or zipCode = '78729' or zipCode = '78730' or zipCode = '78731' or zipCode = '78731' or zipCode = '78732' or zipCode = '78732' or zipCode = '78732' or zipCode = '78733' or zipCode = '78733' or zipCode = '78733' or zipCode = '78734' or zipCode = '78734' or zipCode = '78734' or zipCode = '78734' or zipCode = '78734' or zipCode = '78735' or zipCode = '78735' or zipCode = '78735' or zipCode = '78736' or zipCode = '78736' or zipCode = '78736' or zipCode = '78736' or zipCode = '78736' or zipCode = '78737' or zipCode = '78738' or zipCode = '78738' or zipCode = '78738' or zipCode = '78738' or zipCode = '78738' or zipCode = '78738' or zipCode = '78738' or zipCode = '78739' or zipCode = '78741' or zipCode = '78741' or zipCode = '78742' or zipCode = '78744' or zipCode = '78744' or zipCode = '78744' or zipCode = '78744' or zipCode = '78745' or zipCode = '78745' or zipCode = '78746' or zipCode = '78746' or zipCode = '78746' or zipCode = '78746' or zipCode = '78747' or zipCode = '78748' or zipCode = '78748' or zipCode = '78769' or zipCode = '78772' or zipCode = '78772' or zipCode = '78773' or zipCode = '78773' or zipCode = '78774' or zipCode = '78774' or zipCode = '78778' or zipCode = '78778' or zipCode = '78779' or zipCode = '78779' or zipCode = '78780' or zipCode = '78780' or zipCode = '78781' or zipCode = '78781' or zipCode = '78783' or zipCode = '78783' or zipCode = '78785' or zipCode = '78785' or zipCode = '78789' or zipCode = '78789' or zipCode = '78799' or zipCode = '78799' or zipCode = '78749' or zipCode = '78749' or zipCode = '78750' or zipCode = '78751' or zipCode = '78752' or zipCode = '78753' or zipCode = '78753' or zipCode = '78754' or zipCode = '78754' or zipCode = '78754' or zipCode = '78755' or zipCode = '78756' or zipCode = '78757' or zipCode = '78758' or zipCode = '78759' or zipCode = '78759' or zipCode = '78760' or zipCode = '78761' or zipCode = '78762' or zipCode = '78763' or zipCode = '78764' or zipCode = '78765' or zipCode = '78766' or zipCode = '78767' or zipCode = '78768' or zipCode = '73301' or zipCode = '73344' or zipCode = '78610' or zipCode = '78612' or zipCode = '78613' or zipCode = '78615' or zipCode = '78617' or zipCode = '78619' or zipCode = '78620' or zipCode = '78621' or zipCode = '78626' or zipCode = '78628' or zipCode = '78630' or zipCode = '78634' or zipCode = '78640' or zipCode = '78641' or zipCode = '78645' or zipCode = '78646' or zipCode = '78651' or zipCode = '78652' or zipCode = '78653' or zipCode = '78660' or zipCode = '78664' or zipCode = '78667' or zipCode = '78669' or zipCode = '78680' or zipCode = '78681' or zipCode = '78682' or zipCode = '78683' or zipCode = '78691' or zipCode = '78701' or zipCode = '78702' or zipCode = '78703' or zipCode = '78704' or zipCode = '78705' or zipCode = '78708' or zipCode = '78709' or zipCode = '78710' or zipCode = '78711' or zipCode = '78712' or zipCode = '78713' or zipCode = '78714' or zipCode = '78715' or zipCode = '78716' or zipCode = '78717' or zipCode = '78718' or zipCode = '78719' or zipCode = '78720' or zipCode = '78721' or zipCode = '78722' or zipCode = '78723' or zipCode = '78724' or zipCode = '78725' or zipCode = '78726' or zipCode = '78727' or zipCode = '78728' or zipCode = '78729' or zipCode = '78730' or zipCode = '78731' or zipCode = '78732' or zipCode = '78733' or zipCode = '78734' or zipCode = '78735' or zipCode = '78736' or zipCode = '78737' or zipCode = '78738' or zipCode = '78739' or zipCode = '78741' or zipCode = '78742' or zipCode = '78744' or zipCode = '78745' or zipCode = '78746' or zipCode = '78747' or zipCode = '78748' or zipCode = '78749' or zipCode = '78750' or zipCode = '78751' or zipCode = '78752' or zipCode = '78753' or zipCode = '78754' or zipCode = '78755' or zipCode = '78756' or zipCode = '78757' or zipCode = '78758' or zipCode = '78759' or zipCode = '78760' or zipCode = '78761' or zipCode = '78762' or zipCode = '78763' or zipCode = '78764' or zipCode = '78765' or zipCode = '78766' or zipCode = '78767' or zipCode = '78768' or zipCode = '78769' or zipCode = '78771' or zipCode = '78772' or zipCode = '78773' or zipCode = '78774' or zipCode = '78778' or zipCode = '78779' or zipCode = '78780' or zipCode = '78781' or zipCode = '78782' or zipCode = '78783' or zipCode = '78785' or zipCode = '78786' or zipCode = '78787' or zipCode = '78788' or zipCode = '78789' or zipCode = '78972') 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 ='73301' or zipCode = '73301' or zipCode = '73344' or zipCode = '73344' or zipCode = '78610' or zipCode = '78610' or zipCode = '78610' or zipCode = '78612' or zipCode = '78612' or zipCode = '78613' or zipCode = '78617' or zipCode = '78617' or zipCode = '78617' or zipCode = '78619' or zipCode = '78620' or zipCode = '78620' or zipCode = '78620' or zipCode = '78620' or zipCode = '78627' or zipCode = '78628' or zipCode = '78628' or zipCode = '78628' or zipCode = '78630' or zipCode = '78634' or zipCode = '78634' or zipCode = '78640' or zipCode = '78640' or zipCode = '78640' or zipCode = '78641' or zipCode = '78641' or zipCode = '78641' or zipCode = '78645' or zipCode = '78645' or zipCode = '78645' or zipCode = '78645' or zipCode = '78646' or zipCode = '78660' or zipCode = '78664' or zipCode = '78664' or zipCode = '78664' or zipCode = '78665' or zipCode = '78669' or zipCode = '78669' or zipCode = '78711' or zipCode = '78712' or zipCode = '78712' or zipCode = '78712' or zipCode = '78712' or zipCode = '78713' or zipCode = '78714' or zipCode = '78715' or zipCode = '78716' or zipCode = '78717' or zipCode = '78717' or zipCode = '78718' or zipCode = '78719' or zipCode = '78719' or zipCode = '78720' or zipCode = '78721' or zipCode = '78722' or zipCode = '78723' or zipCode = '78724' or zipCode = '78725' or zipCode = '78725' or zipCode = '78726' or zipCode = '78727' or zipCode = '78728' or zipCode = '78729' or zipCode = '78651' or zipCode = '78651' or zipCode = '78652' or zipCode = '78653' or zipCode = '78653' or zipCode = '78653' or zipCode = '78653' or zipCode = '78653' or zipCode = '78653' or zipCode = '78653' or zipCode = '78653' or zipCode = '78680' or zipCode = '78681' or zipCode = '78682' or zipCode = '78682' or zipCode = '78683' or zipCode = '78691' or zipCode = '78701' or zipCode = '78702' or zipCode = '78703' or zipCode = '78703' or zipCode = '78704' or zipCode = '78704' or zipCode = '78705' or zipCode = '78708' or zipCode = '78709' or zipCode = '78710' or zipCode = '78729' or zipCode = '78730' or zipCode = '78731' or zipCode = '78731' or zipCode = '78732' or zipCode = '78732' or zipCode = '78732' or zipCode = '78733' or zipCode = '78733' or zipCode = '78733' or zipCode = '78734' or zipCode = '78734' or zipCode = '78734' or zipCode = '78734' or zipCode = '78734' or zipCode = '78735' or zipCode = '78735' or zipCode = '78735' or zipCode = '78736' or zipCode = '78736' or zipCode = '78736' or zipCode = '78736' or zipCode = '78736' or zipCode = '78737' or zipCode = '78738' or zipCode = '78738' or zipCode = '78738' or zipCode = '78738' or zipCode = '78738' or zipCode = '78738' or zipCode = '78738' or zipCode = '78739' or zipCode = '78741' or zipCode = '78741' or zipCode = '78742' or zipCode = '78744' or zipCode = '78744' or zipCode = '78744' or zipCode = '78744' or zipCode = '78745' or zipCode = '78745' or zipCode = '78746' or zipCode = '78746' or zipCode = '78746' or zipCode = '78746' or zipCode = '78747' or zipCode = '78748' or zipCode = '78748' or zipCode = '78769' or zipCode = '78772' or zipCode = '78772' or zipCode = '78773' or zipCode = '78773' or zipCode = '78774' or zipCode = '78774' or zipCode = '78778' or zipCode = '78778' or zipCode = '78779' or zipCode = '78779' or zipCode = '78780' or zipCode = '78780' or zipCode = '78781' or zipCode = '78781' or zipCode = '78783' or zipCode = '78783' or zipCode = '78785' or zipCode = '78785' or zipCode = '78789' or zipCode = '78789' or zipCode = '78799' or zipCode = '78799' or zipCode = '78749' or zipCode = '78749' or zipCode = '78750' or zipCode = '78751' or zipCode = '78752' or zipCode = '78753' or zipCode = '78753' or zipCode = '78754' or zipCode = '78754' or zipCode = '78754' or zipCode = '78755' or zipCode = '78756' or zipCode = '78757' or zipCode = '78758' or zipCode = '78759' or zipCode = '78759' or zipCode = '78760' or zipCode = '78761' or zipCode = '78762' or zipCode = '78763' or zipCode = '78764' or zipCode = '78765' or zipCode = '78766' or zipCode = '78767' or zipCode = '78768' or zipCode = '73301' or zipCode = '73344' or zipCode = '78610' or zipCode = '78612' or zipCode = '78613' or zipCode = '78615' or zipCode = '78617' or zipCode = '78619' or zipCode = '78620' or zipCode = '78621' or zipCode = '78626' or zipCode = '78628' or zipCode = '78630' or zipCode = '78634' or zipCode = '78640' or zipCode = '78641' or zipCode = '78645' or zipCode = '78646' or zipCode = '78651' or zipCode = '78652' or zipCode = '78653' or zipCode = '78660' or zipCode = '78664' or zipCode = '78667' or zipCode = '78669' or zipCode = '78680' or zipCode = '78681' or zipCode = '78682' or zipCode = '78683' or zipCode = '78691' or zipCode = '78701' or zipCode = '78702' or zipCode = '78703' or zipCode = '78704' or zipCode = '78705' or zipCode = '78708' or zipCode = '78709' or zipCode = '78710' or zipCode = '78711' or zipCode = '78712' or zipCode = '78713' or zipCode = '78714' or zipCode = '78715' or zipCode = '78716' or zipCode = '78717' or zipCode = '78718' or zipCode = '78719' or zipCode = '78720' or zipCode = '78721' or zipCode = '78722' or zipCode = '78723' or zipCode = '78724' or zipCode = '78725' or zipCode = '78726' or zipCode = '78727' or zipCode = '78728' or zipCode = '78729' or zipCode = '78730' or zipCode = '78731' or zipCode = '78732' or zipCode = '78733' or zipCode = '78734' or zipCode = '78735' or zipCode = '78736' or zipCode = '78737' or zipCode = '78738' or zipCode = '78739' or zipCode = '78741' or zipCode = '78742' or zipCode = '78744' or zipCode = '78745' or zipCode = '78746' or zipCode = '78747' or zipCode = '78748' or zipCode = '78749' or zipCode = '78750' or zipCode = '78751' or zipCode = '78752' or zipCode = '78753' or zipCode = '78754' or zipCode = '78755' or zipCode = '78756' or zipCode = '78757' or zipCode = '78758' or zipCode = '78759' or zipCode = '78760' or zipCode = '78761' or zipCode = '78762' or zipCode = '78763' or zipCode = '78764' or zipCode = '78765' or zipCode = '78766' or zipCode = '78767' or zipCode = '78768' or zipCode = '78769' or zipCode = '78771' or zipCode = '78772' or zipCode = '78773' or zipCode = '78774' or zipCode = '78778' or zipCode = '78779' or zipCode = '78780' or zipCode = '78781' or zipCode = '78782' or zipCode = '78783' or zipCode = '78785' or zipCode = '78786' or zipCode = '78787' or zipCode = '78788' or zipCode = '78789' or zipCode = '78972') 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 ='73301' or zipCode = '73301' or zipCode = '73344' or zipCode = '73344' or zipCode = '78610' or zipCode = '78610' or zipCode = '78610' or zipCode = '78612' or zipCode = '78612' or zipCode = '78613' or zipCode = '78617' or zipCode = '78617' or zipCode = '78617' or zipCode = '78619' or zipCode = '78620' or zipCode = '78620' or zipCode = '78620' or zipCode = '78620' or zipCode = '78627' or zipCode = '78628' or zipCode = '78628' or zipCode = '78628' or zipCode = '78630' or zipCode = '78634' or zipCode = '78634' or zipCode = '78640' or zipCode = '78640' or zipCode = '78640' or zipCode = '78641' or zipCode = '78641' or zipCode = '78641' or zipCode = '78645' or zipCode = '78645' or zipCode = '78645' or zipCode = '78645' or zipCode = '78646' or zipCode = '78660' or zipCode = '78664' or zipCode = '78664' or zipCode = '78664' or zipCode = '78665' or zipCode = '78669' or zipCode = '78669' or zipCode = '78711' or zipCode = '78712' or zipCode = '78712' or zipCode = '78712' or zipCode = '78712' or zipCode = '78713' or zipCode = '78714' or zipCode = '78715' or zipCode = '78716' or zipCode = '78717' or zipCode = '78717' or zipCode = '78718' or zipCode = '78719' or zipCode = '78719' or zipCode = '78720' or zipCode = '78721' or zipCode = '78722' or zipCode = '78723' or zipCode = '78724' or zipCode = '78725' or zipCode = '78725' or zipCode = '78726' or zipCode = '78727' or zipCode = '78728' or zipCode = '78729' or zipCode = '78651' or zipCode = '78651' or zipCode = '78652' or zipCode = '78653' or zipCode = '78653' or zipCode = '78653' or zipCode = '78653' or zipCode = '78653' or zipCode = '78653' or zipCode = '78653' or zipCode = '78653' or zipCode = '78680' or zipCode = '78681' or zipCode = '78682' or zipCode = '78682' or zipCode = '78683' or zipCode = '78691' or zipCode = '78701' or zipCode = '78702' or zipCode = '78703' or zipCode = '78703' or zipCode = '78704' or zipCode = '78704' or zipCode = '78705' or zipCode = '78708' or zipCode = '78709' or zipCode = '78710' or zipCode = '78729' or zipCode = '78730' or zipCode = '78731' or zipCode = '78731' or zipCode = '78732' or zipCode = '78732' or zipCode = '78732' or zipCode = '78733' or zipCode = '78733' or zipCode = '78733' or zipCode = '78734' or zipCode = '78734' or zipCode = '78734' or zipCode = '78734' or zipCode = '78734' or zipCode = '78735' or zipCode = '78735' or zipCode = '78735' or zipCode = '78736' or zipCode = '78736' or zipCode = '78736' or zipCode = '78736' or zipCode = '78736' or zipCode = '78737' or zipCode = '78738' or zipCode = '78738' or zipCode = '78738' or zipCode = '78738' or zipCode = '78738' or zipCode = '78738' or zipCode = '78738' or zipCode = '78739' or zipCode = '78741' or zipCode = '78741' or zipCode = '78742' or zipCode = '78744' or zipCode = '78744' or zipCode = '78744' or zipCode = '78744' or zipCode = '78745' or zipCode = '78745' or zipCode = '78746' or zipCode = '78746' or zipCode = '78746' or zipCode = '78746' or zipCode = '78747' or zipCode = '78748' or zipCode = '78748' or zipCode = '78769' or zipCode = '78772' or zipCode = '78772' or zipCode = '78773' or zipCode = '78773' or zipCode = '78774' or zipCode = '78774' or zipCode = '78778' or zipCode = '78778' or zipCode = '78779' or zipCode = '78779' or zipCode = '78780' or zipCode = '78780' or zipCode = '78781' or zipCode = '78781' or zipCode = '78783' or zipCode = '78783' or zipCode = '78785' or zipCode = '78785' or zipCode = '78789' or zipCode = '78789' or zipCode = '78799' or zipCode = '78799' or zipCode = '78749' or zipCode = '78749' or zipCode = '78750' or zipCode = '78751' or zipCode = '78752' or zipCode = '78753' or zipCode = '78753' or zipCode = '78754' or zipCode = '78754' or zipCode = '78754' or zipCode = '78755' or zipCode = '78756' or zipCode = '78757' or zipCode = '78758' or zipCode = '78759' or zipCode = '78759' or zipCode = '78760' or zipCode = '78761' or zipCode = '78762' or zipCode = '78763' or zipCode = '78764' or zipCode = '78765' or zipCode = '78766' or zipCode = '78767' or zipCode = '78768' or zipCode = '73301' or zipCode = '73344' or zipCode = '78610' or zipCode = '78612' or zipCode = '78613' or zipCode = '78615' or zipCode = '78617' or zipCode = '78619' or zipCode = '78620' or zipCode = '78621' or zipCode = '78626' or zipCode = '78628' or zipCode = '78630' or zipCode = '78634' or zipCode = '78640' or zipCode = '78641' or zipCode = '78645' or zipCode = '78646' or zipCode = '78651' or zipCode = '78652' or zipCode = '78653' or zipCode = '78660' or zipCode = '78664' or zipCode = '78667' or zipCode = '78669' or zipCode = '78680' or zipCode = '78681' or zipCode = '78682' or zipCode = '78683' or zipCode = '78691' or zipCode = '78701' or zipCode = '78702' or zipCode = '78703' or zipCode = '78704' or zipCode = '78705' or zipCode = '78708' or zipCode = '78709' or zipCode = '78710' or zipCode = '78711' or zipCode = '78712' or zipCode = '78713' or zipCode = '78714' or zipCode = '78715' or zipCode = '78716' or zipCode = '78717' or zipCode = '78718' or zipCode = '78719' or zipCode = '78720' or zipCode = '78721' or zipCode = '78722' or zipCode = '78723' or zipCode = '78724' or zipCode = '78725' or zipCode = '78726' or zipCode = '78727' or zipCode = '78728' or zipCode = '78729' or zipCode = '78730' or zipCode = '78731' or zipCode = '78732' or zipCode = '78733' or zipCode = '78734' or zipCode = '78735' or zipCode = '78736' or zipCode = '78737' or zipCode = '78738' or zipCode = '78739' or zipCode = '78741' or zipCode = '78742' or zipCode = '78744' or zipCode = '78745' or zipCode = '78746' or zipCode = '78747' or zipCode = '78748' or zipCode = '78749' or zipCode = '78750' or zipCode = '78751' or zipCode = '78752' or zipCode = '78753' or zipCode = '78754' or zipCode = '78755' or zipCode = '78756' or zipCode = '78757' or zipCode = '78758' or zipCode = '78759' or zipCode = '78760' or zipCode = '78761' or zipCode = '78762' or zipCode = '78763' or zipCode = '78764' or zipCode = '78765' or zipCode = '78766' or zipCode = '78767' or zipCode = '78768' or zipCode = '78769' or zipCode = '78771' or zipCode = '78772' or zipCode = '78773' or zipCode = '78774' or zipCode = '78778' or zipCode = '78779' or zipCode = '78780' or zipCode = '78781' or zipCode = '78782' or zipCode = '78783' or zipCode = '78785' or zipCode = '78786' or zipCode = '78787' or zipCode = '78788' or zipCode = '78789' or zipCode = '78972') 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 ='73301' or property_zip = '73301' or property_zip = '73344' or property_zip = '73344' or property_zip = '78610' or property_zip = '78610' or property_zip = '78610' or property_zip = '78612' or property_zip = '78612' or property_zip = '78613' or property_zip = '78617' or property_zip = '78617' or property_zip = '78617' or property_zip = '78619' or property_zip = '78620' or property_zip = '78620' or property_zip = '78620' or property_zip = '78620' or property_zip = '78627' or property_zip = '78628' or property_zip = '78628' or property_zip = '78628' or property_zip = '78630' or property_zip = '78634' or property_zip = '78634' or property_zip = '78640' or property_zip = '78640' or property_zip = '78640' or property_zip = '78641' or property_zip = '78641' or property_zip = '78641' or property_zip = '78645' or property_zip = '78645' or property_zip = '78645' or property_zip = '78645' or property_zip = '78646' or property_zip = '78660' or property_zip = '78664' or property_zip = '78664' or property_zip = '78664' or property_zip = '78665' or property_zip = '78669' or property_zip = '78669' or property_zip = '78711' or property_zip = '78712' or property_zip = '78712' or property_zip = '78712' or property_zip = '78712' or property_zip = '78713' or property_zip = '78714' or property_zip = '78715' or property_zip = '78716' or property_zip = '78717' or property_zip = '78717' or property_zip = '78718' or property_zip = '78719' or property_zip = '78719' or property_zip = '78720' or property_zip = '78721' or property_zip = '78722' or property_zip = '78723' or property_zip = '78724' or property_zip = '78725' or property_zip = '78725' or property_zip = '78726' or property_zip = '78727' or property_zip = '78728' or property_zip = '78729' or property_zip = '78651' or property_zip = '78651' or property_zip = '78652' or property_zip = '78653' or property_zip = '78653' or property_zip = '78653' or property_zip = '78653' or property_zip = '78653' or property_zip = '78653' or property_zip = '78653' or property_zip = '78653' or property_zip = '78680' or property_zip = '78681' or property_zip = '78682' or property_zip = '78682' or property_zip = '78683' or property_zip = '78691' or property_zip = '78701' or property_zip = '78702' or property_zip = '78703' or property_zip = '78703' or property_zip = '78704' or property_zip = '78704' or property_zip = '78705' or property_zip = '78708' or property_zip = '78709' or property_zip = '78710' or property_zip = '78729' or property_zip = '78730' or property_zip = '78731' or property_zip = '78731' or property_zip = '78732' or property_zip = '78732' or property_zip = '78732' or property_zip = '78733' or property_zip = '78733' or property_zip = '78733' or property_zip = '78734' or property_zip = '78734' or property_zip = '78734' or property_zip = '78734' or property_zip = '78734' or property_zip = '78735' or property_zip = '78735' or property_zip = '78735' or property_zip = '78736' or property_zip = '78736' or property_zip = '78736' or property_zip = '78736' or property_zip = '78736' or property_zip = '78737' or property_zip = '78738' or property_zip = '78738' or property_zip = '78738' or property_zip = '78738' or property_zip = '78738' or property_zip = '78738' or property_zip = '78738' or property_zip = '78739' or property_zip = '78741' or property_zip = '78741' or property_zip = '78742' or property_zip = '78744' or property_zip = '78744' or property_zip = '78744' or property_zip = '78744' or property_zip = '78745' or property_zip = '78745' or property_zip = '78746' or property_zip = '78746' or property_zip = '78746' or property_zip = '78746' or property_zip = '78747' or property_zip = '78748' or property_zip = '78748' or property_zip = '78769' or property_zip = '78772' or property_zip = '78772' or property_zip = '78773' or property_zip = '78773' or property_zip = '78774' or property_zip = '78774' or property_zip = '78778' or property_zip = '78778' or property_zip = '78779' or property_zip = '78779' or property_zip = '78780' or property_zip = '78780' or property_zip = '78781' or property_zip = '78781' or property_zip = '78783' or property_zip = '78783' or property_zip = '78785' or property_zip = '78785' or property_zip = '78789' or property_zip = '78789' or property_zip = '78799' or property_zip = '78799' or property_zip = '78749' or property_zip = '78749' or property_zip = '78750' or property_zip = '78751' or property_zip = '78752' or property_zip = '78753' or property_zip = '78753' or property_zip = '78754' or property_zip = '78754' or property_zip = '78754' or property_zip = '78755' or property_zip = '78756' or property_zip = '78757' or property_zip = '78758' or property_zip = '78759' or property_zip = '78759' or property_zip = '78760' or property_zip = '78761' or property_zip = '78762' or property_zip = '78763' or property_zip = '78764' or property_zip = '78765' or property_zip = '78766' or property_zip = '78767' or property_zip = '78768' or property_zip = '73301' or property_zip = '73344' or property_zip = '78610' or property_zip = '78612' or property_zip = '78613' or property_zip = '78615' or property_zip = '78617' or property_zip = '78619' or property_zip = '78620' or property_zip = '78621' or property_zip = '78626' or property_zip = '78628' or property_zip = '78630' or property_zip = '78634' or property_zip = '78640' or property_zip = '78641' or property_zip = '78645' or property_zip = '78646' or property_zip = '78651' or property_zip = '78652' or property_zip = '78653' or property_zip = '78660' or property_zip = '78664' or property_zip = '78667' or property_zip = '78669' or property_zip = '78680' or property_zip = '78681' or property_zip = '78682' or property_zip = '78683' or property_zip = '78691' or property_zip = '78701' or property_zip = '78702' or property_zip = '78703' or property_zip = '78704' or property_zip = '78705' or property_zip = '78708' or property_zip = '78709' or property_zip = '78710' or property_zip = '78711' or property_zip = '78712' or property_zip = '78713' or property_zip = '78714' or property_zip = '78715' or property_zip = '78716' or property_zip = '78717' or property_zip = '78718' or property_zip = '78719' or property_zip = '78720' or property_zip = '78721' or property_zip = '78722' or property_zip = '78723' or property_zip = '78724' or property_zip = '78725' or property_zip = '78726' or property_zip = '78727' or property_zip = '78728' or property_zip = '78729' or property_zip = '78730' or property_zip = '78731' or property_zip = '78732' or property_zip = '78733' or property_zip = '78734' or property_zip = '78735' or property_zip = '78736' or property_zip = '78737' or property_zip = '78738' or property_zip = '78739' or property_zip = '78741' or property_zip = '78742' or property_zip = '78744' or property_zip = '78745' or property_zip = '78746' or property_zip = '78747' or property_zip = '78748' or property_zip = '78749' or property_zip = '78750' or property_zip = '78751' or property_zip = '78752' or property_zip = '78753' or property_zip = '78754' or property_zip = '78755' or property_zip = '78756' or property_zip = '78757' or property_zip = '78758' or property_zip = '78759' or property_zip = '78760' or property_zip = '78761' or property_zip = '78762' or property_zip = '78763' or property_zip = '78764' or property_zip = '78765' or property_zip = '78766' or property_zip = '78767' or property_zip = '78768' or property_zip = '78769' or property_zip = '78771' or property_zip = '78772' or property_zip = '78773' or property_zip = '78774' or property_zip = '78778' or property_zip = '78779' or property_zip = '78780' or property_zip = '78781' or property_zip = '78782' or property_zip = '78783' or property_zip = '78785' or property_zip = '78786' or property_zip = '78787' or property_zip = '78788' or property_zip = '78789' or property_zip = '78972') and convert(date,auction_start_date) >= '9/27/2021';
select top 45 * from currentforeclosures.tblAll NOLOCK where state = 'TX '
select top 4500 * from currentforeclosures.tblAll NOLOCK where 1=2
select top 45 * from currentforeclosures.tblAll NOLOCK where len(PhotoURL1) > 2 and photoURL1 <> 'no_pic2.jpg';
select top 47 * from currentforeclosures.tblWholesaleDeals NOLOCK where len(image_name1) > 2 and image_name1 <> 'no_pic2.jpg' and date_posted >= '8/29/2021' and (1=1) and asking_price >= 0 and asking_price <= 499999 and 11=11 and (zip ='73301' or zip = '73301' or zip = '73344' or zip = '73344' or zip = '78610' or zip = '78610' or zip = '78610' or zip = '78612' or zip = '78612' or zip = '78613' or zip = '78617' or zip = '78617' or zip = '78617' or zip = '78619' or zip = '78620' or zip = '78620' or zip = '78620' or zip = '78620' or zip = '78627' or zip = '78628' or zip = '78628' or zip = '78628' or zip = '78630' or zip = '78634' or zip = '78634' or zip = '78640' or zip = '78640' or zip = '78640' or zip = '78641' or zip = '78641' or zip = '78641' or zip = '78645' or zip = '78645' or zip = '78645' or zip = '78645' or zip = '78646' or zip = '78660' or zip = '78664' or zip = '78664' or zip = '78664' or zip = '78665' or zip = '78669' or zip = '78669' or zip = '78711' or zip = '78712' or zip = '78712' or zip = '78712' or zip = '78712' or zip = '78713' or zip = '78714' or zip = '78715' or zip = '78716' or zip = '78717' or zip = '78717' or zip = '78718' or zip = '78719' or zip = '78719' or zip = '78720' or zip = '78721' or zip = '78722' or zip = '78723' or zip = '78724' or zip = '78725' or zip = '78725' or zip = '78726' or zip = '78727' or zip = '78728' or zip = '78729' or zip = '78651' or zip = '78651' or zip = '78652' or zip = '78653' or zip = '78653' or zip = '78653' or zip = '78653' or zip = '78653' or zip = '78653' or zip = '78653' or zip = '78653' or zip = '78680' or zip = '78681' or zip = '78682' or zip = '78682' or zip = '78683' or zip = '78691' or zip = '78701' or zip = '78702' or zip = '78703' or zip = '78703' or zip = '78704' or zip = '78704' or zip = '78705' or zip = '78708' or zip = '78709' or zip = '78710' or zip = '78729' or zip = '78730' or zip = '78731' or zip = '78731' or zip = '78732' or zip = '78732' or zip = '78732' or zip = '78733' or zip = '78733' or zip = '78733' or zip = '78734' or zip = '78734' or zip = '78734' or zip = '78734' or zip = '78734' or zip = '78735' or zip = '78735' or zip = '78735' or zip = '78736' or zip = '78736' or zip = '78736' or zip = '78736' or zip = '78736' or zip = '78737' or zip = '78738' or zip = '78738' or zip = '78738' or zip = '78738' or zip = '78738' or zip = '78738' or zip = '78738' or zip = '78739' or zip = '78741' or zip = '78741' or zip = '78742' or zip = '78744' or zip = '78744' or zip = '78744' or zip = '78744' or zip = '78745' or zip = '78745' or zip = '78746' or zip = '78746' or zip = '78746' or zip = '78746' or zip = '78747' or zip = '78748' or zip = '78748' or zip = '78769' or zip = '78772' or zip = '78772' or zip = '78773' or zip = '78773' or zip = '78774' or zip = '78774' or zip = '78778' or zip = '78778' or zip = '78779' or zip = '78779' or zip = '78780' or zip = '78780' or zip = '78781' or zip = '78781' or zip = '78783' or zip = '78783' or zip = '78785' or zip = '78785' or zip = '78789' or zip = '78789' or zip = '78799' or zip = '78799' or zip = '78749' or zip = '78749' or zip = '78750' or zip = '78751' or zip = '78752' or zip = '78753' or zip = '78753' or zip = '78754' or zip = '78754' or zip = '78754' or zip = '78755' or zip = '78756' or zip = '78757' or zip = '78758' or zip = '78759' or zip = '78759' or zip = '78760' or zip = '78761' or zip = '78762' or zip = '78763' or zip = '78764' or zip = '78765' or zip = '78766' or zip = '78767' or zip = '78768' or zip = '73301' or zip = '73344' or zip = '78610' or zip = '78612' or zip = '78613' or zip = '78615' or zip = '78617' or zip = '78619' or zip = '78620' or zip = '78621' or zip = '78626' or zip = '78628' or zip = '78630' or zip = '78634' or zip = '78640' or zip = '78641' or zip = '78645' or zip = '78646' or zip = '78651' or zip = '78652' or zip = '78653' or zip = '78660' or zip = '78664' or zip = '78667' or zip = '78669' or zip = '78680' or zip = '78681' or zip = '78682' or zip = '78683' or zip = '78691' or zip = '78701' or zip = '78702' or zip = '78703' or zip = '78704' or zip = '78705' or zip = '78708' or zip = '78709' or zip = '78710' or zip = '78711' or zip = '78712' or zip = '78713' or zip = '78714' or zip = '78715' or zip = '78716' or zip = '78717' or zip = '78718' or zip = '78719' or zip = '78720' or zip = '78721' or zip = '78722' or zip = '78723' or zip = '78724' or zip = '78725' or zip = '78726' or zip = '78727' or zip = '78728' or zip = '78729' or zip = '78730' or zip = '78731' or zip = '78732' or zip = '78733' or zip = '78734' or zip = '78735' or zip = '78736' or zip = '78737' or zip = '78738' or zip = '78739' or zip = '78741' or zip = '78742' or zip = '78744' or zip = '78745' or zip = '78746' or zip = '78747' or zip = '78748' or zip = '78749' or zip = '78750' or zip = '78751' or zip = '78752' or zip = '78753' or zip = '78754' or zip = '78755' or zip = '78756' or zip = '78757' or zip = '78758' or zip = '78759' or zip = '78760' or zip = '78761' or zip = '78762' or zip = '78763' or zip = '78764' or zip = '78765' or zip = '78766' or zip = '78767' or zip = '78768' or zip = '78769' or zip = '78771' or zip = '78772' or zip = '78773' or zip = '78774' or zip = '78778' or zip = '78779' or zip = '78780' or zip = '78781' or zip = '78782' or zip = '78783' or zip = '78785' or zip = '78786' or zip = '78787' or zip = '78788' or zip = '78789' or zip = '78972')
select top 45 * from currentforeclosures.tblWholesaleDeals NOLOCK where len(image_name1) > 2 and image_name1 <> 'no_pic2.jpg' and date_posted >= '12/2/2020' and 1=1 and state = 'TX' and city = 'AUSTIN' and state = 'TX ' and asking_price >= 0 and asking_price <= 499999
select top 45 * from currentforeclosures.tblWholesaleDeals NOLOCK where len(image_name1) > 2 and image_name1 <> 'no_pic2.jpg';
select top 45 * from tblLenders where email != '[email protected]' and lendertype = 'individual' and rate < 10 and len(phone) > 3 and budget > 45000 order by newID();