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


210+ High Potential Investor Deals Near san antonio [Refine]


********NOTICE: Displaying 99 of over 210 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 ='78002' or zipCode = '78023' or zipCode = '78023' or zipCode = '78039' or zipCode = '78052' or zipCode = '78073' or zipCode = '78101' or zipCode = '78108' or zipCode = '78109' or zipCode = '78112' or zipCode = '78112' or zipCode = '78124' or zipCode = '78009' or zipCode = '78015' or zipCode = '78015' or zipCode = '78015' or zipCode = '78054' or zipCode = '78056' or zipCode = '78056' or zipCode = '78066' or zipCode = '78069' or zipCode = '78148' or zipCode = '78148' or zipCode = '78148' or zipCode = '78148' or zipCode = '78148' or zipCode = '78148' or zipCode = '78150' or zipCode = '78150' or zipCode = '78150' or zipCode = '78150' or zipCode = '78150' or zipCode = '78150' or zipCode = '78152' or zipCode = '78209' or zipCode = '78209' or zipCode = '78209' or zipCode = '78210' or zipCode = '78211' or zipCode = '78212' or zipCode = '78212' or zipCode = '78213' or zipCode = '78213' or zipCode = '78214' or zipCode = '78215' or zipCode = '78216' or zipCode = '78217' or zipCode = '78218' or zipCode = '78219' or zipCode = '78219' or zipCode = '78220' or zipCode = '78221' or zipCode = '78222' or zipCode = '78223' or zipCode = '78224' or zipCode = '78225' or zipCode = '78226' or zipCode = '78226' or zipCode = '78236' or zipCode = '78236' or zipCode = '78236' or zipCode = '78236' or zipCode = '78236' or zipCode = '78236' or zipCode = '78236' or zipCode = '78236' or zipCode = '78237' or zipCode = '78238' or zipCode = '78238' or zipCode = '78239' or zipCode = '78239' or zipCode = '78240' or zipCode = '78241' or zipCode = '78241' or zipCode = '78241' or zipCode = '78242' or zipCode = '78243' or zipCode = '78243' or zipCode = '78244' or zipCode = '78245' or zipCode = '78246' or zipCode = '78265' or zipCode = '78266' or zipCode = '78266' or zipCode = '78266' or zipCode = '78268' or zipCode = '78268' or zipCode = '78269' or zipCode = '78270' or zipCode = '78275' or zipCode = '78275' or zipCode = '78278' or zipCode = '78279' or zipCode = '78280' or zipCode = '78283' or zipCode = '78284' or zipCode = '78285' or zipCode = '78285' or zipCode = '78286' or zipCode = '78286' or zipCode = '78287' or zipCode = '78287' or zipCode = '78288' or zipCode = '78288' or zipCode = '78289' or zipCode = '78289' or zipCode = '78291' or zipCode = '78292' or zipCode = '78293' or zipCode = '78294' or zipCode = '78295' or zipCode = '78296' or zipCode = '78297' or zipCode = '78298' or zipCode = '78299' or zipCode = '78154' or zipCode = '78154' or zipCode = '78154' or zipCode = '78163' or zipCode = '78163' or zipCode = '78201' or zipCode = '78201' or zipCode = '78201' or zipCode = '78202' or zipCode = '78203' or zipCode = '78204' or zipCode = '78205' or zipCode = '78206' or zipCode = '78207' or zipCode = '78208' or zipCode = '78227' or zipCode = '78227' or zipCode = '78228' or zipCode = '78229' or zipCode = '78230' or zipCode = '78230' or zipCode = '78231' or zipCode = '78231' or zipCode = '78232' or zipCode = '78232' or zipCode = '78232' or zipCode = '78232' or zipCode = '78232' or zipCode = '78233' or zipCode = '78233' or zipCode = '78234' or zipCode = '78234' or zipCode = '78234' or zipCode = '78235' or zipCode = '78235' or zipCode = '78235' or zipCode = '78235' or zipCode = '78235' or zipCode = '78247' or zipCode = '78247' or zipCode = '78248' or zipCode = '78249' or zipCode = '78249' or zipCode = '78250' or zipCode = '78251' or zipCode = '78252' or zipCode = '78253' or zipCode = '78254' or zipCode = '78254' or zipCode = '78255' or zipCode = '78256' or zipCode = '78257' or zipCode = '78257' or zipCode = '78258' or zipCode = '78259' or zipCode = '78260' or zipCode = '78261' or zipCode = '78262' or zipCode = '78262' or zipCode = '78263' or zipCode = '78263' or zipCode = '78264' or zipCode = '78002' or zipCode = '78009' or zipCode = '78015' or zipCode = '78023' or zipCode = '78039' or zipCode = '78052' or zipCode = '78054' or zipCode = '78056' or zipCode = '78066' or zipCode = '78069' or zipCode = '78073' or zipCode = '78081' or zipCode = '78101' or zipCode = '78108' or zipCode = '78109' or zipCode = '78112' or zipCode = '78124' or zipCode = '78126' or zipCode = '78148' or zipCode = '78150' or zipCode = '78152' or zipCode = '78154' or zipCode = '78163' or zipCode = '78201' or zipCode = '78202' or zipCode = '78203' or zipCode = '78204' or zipCode = '78205' or zipCode = '78206' or zipCode = '78207' or zipCode = '78208' or zipCode = '78209' or zipCode = '78210' or zipCode = '78211' or zipCode = '78212' or zipCode = '78213' or zipCode = '78214' or zipCode = '78215' or zipCode = '78216' or zipCode = '78217' or zipCode = '78218' or zipCode = '78219' or zipCode = '78220' or zipCode = '78221' or zipCode = '78222' or zipCode = '78223' or zipCode = '78224' or zipCode = '78225' or zipCode = '78226' or zipCode = '78227' or zipCode = '78228' or zipCode = '78229' or zipCode = '78230' or zipCode = '78231' or zipCode = '78232' or zipCode = '78233' or zipCode = '78234' or zipCode = '78235' or zipCode = '78236' or zipCode = '78237' or zipCode = '78238' or zipCode = '78239' or zipCode = '78240' or zipCode = '78241' or zipCode = '78242' or zipCode = '78243' or zipCode = '78244' or zipCode = '78245' or zipCode = '78246' or zipCode = '78247' or zipCode = '78248' or zipCode = '78249' or zipCode = '78250' or zipCode = '78251' or zipCode = '78252' or zipCode = '78253' or zipCode = '78254' or zipCode = '78255' or zipCode = '78256' or zipCode = '78257' or zipCode = '78258' or zipCode = '78259' or zipCode = '78260' or zipCode = '78261' or zipCode = '78262' or zipCode = '78263' or zipCode = '78264' or zipCode = '78265' or zipCode = '78266' or zipCode = '78268' or zipCode = '78269' or zipCode = '78270' or zipCode = '78275' or zipCode = '78278' or zipCode = '78279' or zipCode = '78280' or zipCode = '78283' or zipCode = '78284' or zipCode = '78285' or zipCode = '78286' or zipCode = '78287' or zipCode = '78288' or zipCode = '78289' or zipCode = '78291' or zipCode = '78292' or zipCode = '78293' or zipCode = '78294' or zipCode = '78295' or zipCode = '78296' or zipCode = '78297' or zipCode = '78298' or zipCode = '78299')
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 ='78002' or zipCode = '78023' or zipCode = '78023' or zipCode = '78039' or zipCode = '78052' or zipCode = '78073' or zipCode = '78101' or zipCode = '78108' or zipCode = '78109' or zipCode = '78112' or zipCode = '78112' or zipCode = '78124' or zipCode = '78009' or zipCode = '78015' or zipCode = '78015' or zipCode = '78015' or zipCode = '78054' or zipCode = '78056' or zipCode = '78056' or zipCode = '78066' or zipCode = '78069' or zipCode = '78148' or zipCode = '78148' or zipCode = '78148' or zipCode = '78148' or zipCode = '78148' or zipCode = '78148' or zipCode = '78150' or zipCode = '78150' or zipCode = '78150' or zipCode = '78150' or zipCode = '78150' or zipCode = '78150' or zipCode = '78152' or zipCode = '78209' or zipCode = '78209' or zipCode = '78209' or zipCode = '78210' or zipCode = '78211' or zipCode = '78212' or zipCode = '78212' or zipCode = '78213' or zipCode = '78213' or zipCode = '78214' or zipCode = '78215' or zipCode = '78216' or zipCode = '78217' or zipCode = '78218' or zipCode = '78219' or zipCode = '78219' or zipCode = '78220' or zipCode = '78221' or zipCode = '78222' or zipCode = '78223' or zipCode = '78224' or zipCode = '78225' or zipCode = '78226' or zipCode = '78226' or zipCode = '78236' or zipCode = '78236' or zipCode = '78236' or zipCode = '78236' or zipCode = '78236' or zipCode = '78236' or zipCode = '78236' or zipCode = '78236' or zipCode = '78237' or zipCode = '78238' or zipCode = '78238' or zipCode = '78239' or zipCode = '78239' or zipCode = '78240' or zipCode = '78241' or zipCode = '78241' or zipCode = '78241' or zipCode = '78242' or zipCode = '78243' or zipCode = '78243' or zipCode = '78244' or zipCode = '78245' or zipCode = '78246' or zipCode = '78265' or zipCode = '78266' or zipCode = '78266' or zipCode = '78266' or zipCode = '78268' or zipCode = '78268' or zipCode = '78269' or zipCode = '78270' or zipCode = '78275' or zipCode = '78275' or zipCode = '78278' or zipCode = '78279' or zipCode = '78280' or zipCode = '78283' or zipCode = '78284' or zipCode = '78285' or zipCode = '78285' or zipCode = '78286' or zipCode = '78286' or zipCode = '78287' or zipCode = '78287' or zipCode = '78288' or zipCode = '78288' or zipCode = '78289' or zipCode = '78289' or zipCode = '78291' or zipCode = '78292' or zipCode = '78293' or zipCode = '78294' or zipCode = '78295' or zipCode = '78296' or zipCode = '78297' or zipCode = '78298' or zipCode = '78299' or zipCode = '78154' or zipCode = '78154' or zipCode = '78154' or zipCode = '78163' or zipCode = '78163' or zipCode = '78201' or zipCode = '78201' or zipCode = '78201' or zipCode = '78202' or zipCode = '78203' or zipCode = '78204' or zipCode = '78205' or zipCode = '78206' or zipCode = '78207' or zipCode = '78208' or zipCode = '78227' or zipCode = '78227' or zipCode = '78228' or zipCode = '78229' or zipCode = '78230' or zipCode = '78230' or zipCode = '78231' or zipCode = '78231' or zipCode = '78232' or zipCode = '78232' or zipCode = '78232' or zipCode = '78232' or zipCode = '78232' or zipCode = '78233' or zipCode = '78233' or zipCode = '78234' or zipCode = '78234' or zipCode = '78234' or zipCode = '78235' or zipCode = '78235' or zipCode = '78235' or zipCode = '78235' or zipCode = '78235' or zipCode = '78247' or zipCode = '78247' or zipCode = '78248' or zipCode = '78249' or zipCode = '78249' or zipCode = '78250' or zipCode = '78251' or zipCode = '78252' or zipCode = '78253' or zipCode = '78254' or zipCode = '78254' or zipCode = '78255' or zipCode = '78256' or zipCode = '78257' or zipCode = '78257' or zipCode = '78258' or zipCode = '78259' or zipCode = '78260' or zipCode = '78261' or zipCode = '78262' or zipCode = '78262' or zipCode = '78263' or zipCode = '78263' or zipCode = '78264' or zipCode = '78002' or zipCode = '78009' or zipCode = '78015' or zipCode = '78023' or zipCode = '78039' or zipCode = '78052' or zipCode = '78054' or zipCode = '78056' or zipCode = '78066' or zipCode = '78069' or zipCode = '78073' or zipCode = '78081' or zipCode = '78101' or zipCode = '78108' or zipCode = '78109' or zipCode = '78112' or zipCode = '78124' or zipCode = '78126' or zipCode = '78148' or zipCode = '78150' or zipCode = '78152' or zipCode = '78154' or zipCode = '78163' or zipCode = '78201' or zipCode = '78202' or zipCode = '78203' or zipCode = '78204' or zipCode = '78205' or zipCode = '78206' or zipCode = '78207' or zipCode = '78208' or zipCode = '78209' or zipCode = '78210' or zipCode = '78211' or zipCode = '78212' or zipCode = '78213' or zipCode = '78214' or zipCode = '78215' or zipCode = '78216' or zipCode = '78217' or zipCode = '78218' or zipCode = '78219' or zipCode = '78220' or zipCode = '78221' or zipCode = '78222' or zipCode = '78223' or zipCode = '78224' or zipCode = '78225' or zipCode = '78226' or zipCode = '78227' or zipCode = '78228' or zipCode = '78229' or zipCode = '78230' or zipCode = '78231' or zipCode = '78232' or zipCode = '78233' or zipCode = '78234' or zipCode = '78235' or zipCode = '78236' or zipCode = '78237' or zipCode = '78238' or zipCode = '78239' or zipCode = '78240' or zipCode = '78241' or zipCode = '78242' or zipCode = '78243' or zipCode = '78244' or zipCode = '78245' or zipCode = '78246' or zipCode = '78247' or zipCode = '78248' or zipCode = '78249' or zipCode = '78250' or zipCode = '78251' or zipCode = '78252' or zipCode = '78253' or zipCode = '78254' or zipCode = '78255' or zipCode = '78256' or zipCode = '78257' or zipCode = '78258' or zipCode = '78259' or zipCode = '78260' or zipCode = '78261' or zipCode = '78262' or zipCode = '78263' or zipCode = '78264' or zipCode = '78265' or zipCode = '78266' or zipCode = '78268' or zipCode = '78269' or zipCode = '78270' or zipCode = '78275' or zipCode = '78278' or zipCode = '78279' or zipCode = '78280' or zipCode = '78283' or zipCode = '78284' or zipCode = '78285' or zipCode = '78286' or zipCode = '78287' or zipCode = '78288' or zipCode = '78289' or zipCode = '78291' or zipCode = '78292' or zipCode = '78293' or zipCode = '78294' or zipCode = '78295' or zipCode = '78296' or zipCode = '78297' or zipCode = '78298' or zipCode = '78299') 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 ='78002' or zipCode = '78023' or zipCode = '78023' or zipCode = '78039' or zipCode = '78052' or zipCode = '78073' or zipCode = '78101' or zipCode = '78108' or zipCode = '78109' or zipCode = '78112' or zipCode = '78112' or zipCode = '78124' or zipCode = '78009' or zipCode = '78015' or zipCode = '78015' or zipCode = '78015' or zipCode = '78054' or zipCode = '78056' or zipCode = '78056' or zipCode = '78066' or zipCode = '78069' or zipCode = '78148' or zipCode = '78148' or zipCode = '78148' or zipCode = '78148' or zipCode = '78148' or zipCode = '78148' or zipCode = '78150' or zipCode = '78150' or zipCode = '78150' or zipCode = '78150' or zipCode = '78150' or zipCode = '78150' or zipCode = '78152' or zipCode = '78209' or zipCode = '78209' or zipCode = '78209' or zipCode = '78210' or zipCode = '78211' or zipCode = '78212' or zipCode = '78212' or zipCode = '78213' or zipCode = '78213' or zipCode = '78214' or zipCode = '78215' or zipCode = '78216' or zipCode = '78217' or zipCode = '78218' or zipCode = '78219' or zipCode = '78219' or zipCode = '78220' or zipCode = '78221' or zipCode = '78222' or zipCode = '78223' or zipCode = '78224' or zipCode = '78225' or zipCode = '78226' or zipCode = '78226' or zipCode = '78236' or zipCode = '78236' or zipCode = '78236' or zipCode = '78236' or zipCode = '78236' or zipCode = '78236' or zipCode = '78236' or zipCode = '78236' or zipCode = '78237' or zipCode = '78238' or zipCode = '78238' or zipCode = '78239' or zipCode = '78239' or zipCode = '78240' or zipCode = '78241' or zipCode = '78241' or zipCode = '78241' or zipCode = '78242' or zipCode = '78243' or zipCode = '78243' or zipCode = '78244' or zipCode = '78245' or zipCode = '78246' or zipCode = '78265' or zipCode = '78266' or zipCode = '78266' or zipCode = '78266' or zipCode = '78268' or zipCode = '78268' or zipCode = '78269' or zipCode = '78270' or zipCode = '78275' or zipCode = '78275' or zipCode = '78278' or zipCode = '78279' or zipCode = '78280' or zipCode = '78283' or zipCode = '78284' or zipCode = '78285' or zipCode = '78285' or zipCode = '78286' or zipCode = '78286' or zipCode = '78287' or zipCode = '78287' or zipCode = '78288' or zipCode = '78288' or zipCode = '78289' or zipCode = '78289' or zipCode = '78291' or zipCode = '78292' or zipCode = '78293' or zipCode = '78294' or zipCode = '78295' or zipCode = '78296' or zipCode = '78297' or zipCode = '78298' or zipCode = '78299' or zipCode = '78154' or zipCode = '78154' or zipCode = '78154' or zipCode = '78163' or zipCode = '78163' or zipCode = '78201' or zipCode = '78201' or zipCode = '78201' or zipCode = '78202' or zipCode = '78203' or zipCode = '78204' or zipCode = '78205' or zipCode = '78206' or zipCode = '78207' or zipCode = '78208' or zipCode = '78227' or zipCode = '78227' or zipCode = '78228' or zipCode = '78229' or zipCode = '78230' or zipCode = '78230' or zipCode = '78231' or zipCode = '78231' or zipCode = '78232' or zipCode = '78232' or zipCode = '78232' or zipCode = '78232' or zipCode = '78232' or zipCode = '78233' or zipCode = '78233' or zipCode = '78234' or zipCode = '78234' or zipCode = '78234' or zipCode = '78235' or zipCode = '78235' or zipCode = '78235' or zipCode = '78235' or zipCode = '78235' or zipCode = '78247' or zipCode = '78247' or zipCode = '78248' or zipCode = '78249' or zipCode = '78249' or zipCode = '78250' or zipCode = '78251' or zipCode = '78252' or zipCode = '78253' or zipCode = '78254' or zipCode = '78254' or zipCode = '78255' or zipCode = '78256' or zipCode = '78257' or zipCode = '78257' or zipCode = '78258' or zipCode = '78259' or zipCode = '78260' or zipCode = '78261' or zipCode = '78262' or zipCode = '78262' or zipCode = '78263' or zipCode = '78263' or zipCode = '78264' or zipCode = '78002' or zipCode = '78009' or zipCode = '78015' or zipCode = '78023' or zipCode = '78039' or zipCode = '78052' or zipCode = '78054' or zipCode = '78056' or zipCode = '78066' or zipCode = '78069' or zipCode = '78073' or zipCode = '78081' or zipCode = '78101' or zipCode = '78108' or zipCode = '78109' or zipCode = '78112' or zipCode = '78124' or zipCode = '78126' or zipCode = '78148' or zipCode = '78150' or zipCode = '78152' or zipCode = '78154' or zipCode = '78163' or zipCode = '78201' or zipCode = '78202' or zipCode = '78203' or zipCode = '78204' or zipCode = '78205' or zipCode = '78206' or zipCode = '78207' or zipCode = '78208' or zipCode = '78209' or zipCode = '78210' or zipCode = '78211' or zipCode = '78212' or zipCode = '78213' or zipCode = '78214' or zipCode = '78215' or zipCode = '78216' or zipCode = '78217' or zipCode = '78218' or zipCode = '78219' or zipCode = '78220' or zipCode = '78221' or zipCode = '78222' or zipCode = '78223' or zipCode = '78224' or zipCode = '78225' or zipCode = '78226' or zipCode = '78227' or zipCode = '78228' or zipCode = '78229' or zipCode = '78230' or zipCode = '78231' or zipCode = '78232' or zipCode = '78233' or zipCode = '78234' or zipCode = '78235' or zipCode = '78236' or zipCode = '78237' or zipCode = '78238' or zipCode = '78239' or zipCode = '78240' or zipCode = '78241' or zipCode = '78242' or zipCode = '78243' or zipCode = '78244' or zipCode = '78245' or zipCode = '78246' or zipCode = '78247' or zipCode = '78248' or zipCode = '78249' or zipCode = '78250' or zipCode = '78251' or zipCode = '78252' or zipCode = '78253' or zipCode = '78254' or zipCode = '78255' or zipCode = '78256' or zipCode = '78257' or zipCode = '78258' or zipCode = '78259' or zipCode = '78260' or zipCode = '78261' or zipCode = '78262' or zipCode = '78263' or zipCode = '78264' or zipCode = '78265' or zipCode = '78266' or zipCode = '78268' or zipCode = '78269' or zipCode = '78270' or zipCode = '78275' or zipCode = '78278' or zipCode = '78279' or zipCode = '78280' or zipCode = '78283' or zipCode = '78284' or zipCode = '78285' or zipCode = '78286' or zipCode = '78287' or zipCode = '78288' or zipCode = '78289' or zipCode = '78291' or zipCode = '78292' or zipCode = '78293' or zipCode = '78294' or zipCode = '78295' or zipCode = '78296' or zipCode = '78297' or zipCode = '78298' or zipCode = '78299') 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 ='78002' or zipCode = '78023' or zipCode = '78023' or zipCode = '78039' or zipCode = '78052' or zipCode = '78073' or zipCode = '78101' or zipCode = '78108' or zipCode = '78109' or zipCode = '78112' or zipCode = '78112' or zipCode = '78124' or zipCode = '78009' or zipCode = '78015' or zipCode = '78015' or zipCode = '78015' or zipCode = '78054' or zipCode = '78056' or zipCode = '78056' or zipCode = '78066' or zipCode = '78069' or zipCode = '78148' or zipCode = '78148' or zipCode = '78148' or zipCode = '78148' or zipCode = '78148' or zipCode = '78148' or zipCode = '78150' or zipCode = '78150' or zipCode = '78150' or zipCode = '78150' or zipCode = '78150' or zipCode = '78150' or zipCode = '78152' or zipCode = '78209' or zipCode = '78209' or zipCode = '78209' or zipCode = '78210' or zipCode = '78211' or zipCode = '78212' or zipCode = '78212' or zipCode = '78213' or zipCode = '78213' or zipCode = '78214' or zipCode = '78215' or zipCode = '78216' or zipCode = '78217' or zipCode = '78218' or zipCode = '78219' or zipCode = '78219' or zipCode = '78220' or zipCode = '78221' or zipCode = '78222' or zipCode = '78223' or zipCode = '78224' or zipCode = '78225' or zipCode = '78226' or zipCode = '78226' or zipCode = '78236' or zipCode = '78236' or zipCode = '78236' or zipCode = '78236' or zipCode = '78236' or zipCode = '78236' or zipCode = '78236' or zipCode = '78236' or zipCode = '78237' or zipCode = '78238' or zipCode = '78238' or zipCode = '78239' or zipCode = '78239' or zipCode = '78240' or zipCode = '78241' or zipCode = '78241' or zipCode = '78241' or zipCode = '78242' or zipCode = '78243' or zipCode = '78243' or zipCode = '78244' or zipCode = '78245' or zipCode = '78246' or zipCode = '78265' or zipCode = '78266' or zipCode = '78266' or zipCode = '78266' or zipCode = '78268' or zipCode = '78268' or zipCode = '78269' or zipCode = '78270' or zipCode = '78275' or zipCode = '78275' or zipCode = '78278' or zipCode = '78279' or zipCode = '78280' or zipCode = '78283' or zipCode = '78284' or zipCode = '78285' or zipCode = '78285' or zipCode = '78286' or zipCode = '78286' or zipCode = '78287' or zipCode = '78287' or zipCode = '78288' or zipCode = '78288' or zipCode = '78289' or zipCode = '78289' or zipCode = '78291' or zipCode = '78292' or zipCode = '78293' or zipCode = '78294' or zipCode = '78295' or zipCode = '78296' or zipCode = '78297' or zipCode = '78298' or zipCode = '78299' or zipCode = '78154' or zipCode = '78154' or zipCode = '78154' or zipCode = '78163' or zipCode = '78163' or zipCode = '78201' or zipCode = '78201' or zipCode = '78201' or zipCode = '78202' or zipCode = '78203' or zipCode = '78204' or zipCode = '78205' or zipCode = '78206' or zipCode = '78207' or zipCode = '78208' or zipCode = '78227' or zipCode = '78227' or zipCode = '78228' or zipCode = '78229' or zipCode = '78230' or zipCode = '78230' or zipCode = '78231' or zipCode = '78231' or zipCode = '78232' or zipCode = '78232' or zipCode = '78232' or zipCode = '78232' or zipCode = '78232' or zipCode = '78233' or zipCode = '78233' or zipCode = '78234' or zipCode = '78234' or zipCode = '78234' or zipCode = '78235' or zipCode = '78235' or zipCode = '78235' or zipCode = '78235' or zipCode = '78235' or zipCode = '78247' or zipCode = '78247' or zipCode = '78248' or zipCode = '78249' or zipCode = '78249' or zipCode = '78250' or zipCode = '78251' or zipCode = '78252' or zipCode = '78253' or zipCode = '78254' or zipCode = '78254' or zipCode = '78255' or zipCode = '78256' or zipCode = '78257' or zipCode = '78257' or zipCode = '78258' or zipCode = '78259' or zipCode = '78260' or zipCode = '78261' or zipCode = '78262' or zipCode = '78262' or zipCode = '78263' or zipCode = '78263' or zipCode = '78264' or zipCode = '78002' or zipCode = '78009' or zipCode = '78015' or zipCode = '78023' or zipCode = '78039' or zipCode = '78052' or zipCode = '78054' or zipCode = '78056' or zipCode = '78066' or zipCode = '78069' or zipCode = '78073' or zipCode = '78081' or zipCode = '78101' or zipCode = '78108' or zipCode = '78109' or zipCode = '78112' or zipCode = '78124' or zipCode = '78126' or zipCode = '78148' or zipCode = '78150' or zipCode = '78152' or zipCode = '78154' or zipCode = '78163' or zipCode = '78201' or zipCode = '78202' or zipCode = '78203' or zipCode = '78204' or zipCode = '78205' or zipCode = '78206' or zipCode = '78207' or zipCode = '78208' or zipCode = '78209' or zipCode = '78210' or zipCode = '78211' or zipCode = '78212' or zipCode = '78213' or zipCode = '78214' or zipCode = '78215' or zipCode = '78216' or zipCode = '78217' or zipCode = '78218' or zipCode = '78219' or zipCode = '78220' or zipCode = '78221' or zipCode = '78222' or zipCode = '78223' or zipCode = '78224' or zipCode = '78225' or zipCode = '78226' or zipCode = '78227' or zipCode = '78228' or zipCode = '78229' or zipCode = '78230' or zipCode = '78231' or zipCode = '78232' or zipCode = '78233' or zipCode = '78234' or zipCode = '78235' or zipCode = '78236' or zipCode = '78237' or zipCode = '78238' or zipCode = '78239' or zipCode = '78240' or zipCode = '78241' or zipCode = '78242' or zipCode = '78243' or zipCode = '78244' or zipCode = '78245' or zipCode = '78246' or zipCode = '78247' or zipCode = '78248' or zipCode = '78249' or zipCode = '78250' or zipCode = '78251' or zipCode = '78252' or zipCode = '78253' or zipCode = '78254' or zipCode = '78255' or zipCode = '78256' or zipCode = '78257' or zipCode = '78258' or zipCode = '78259' or zipCode = '78260' or zipCode = '78261' or zipCode = '78262' or zipCode = '78263' or zipCode = '78264' or zipCode = '78265' or zipCode = '78266' or zipCode = '78268' or zipCode = '78269' or zipCode = '78270' or zipCode = '78275' or zipCode = '78278' or zipCode = '78279' or zipCode = '78280' or zipCode = '78283' or zipCode = '78284' or zipCode = '78285' or zipCode = '78286' or zipCode = '78287' or zipCode = '78288' or zipCode = '78289' or zipCode = '78291' or zipCode = '78292' or zipCode = '78293' or zipCode = '78294' or zipCode = '78295' or zipCode = '78296' or zipCode = '78297' or zipCode = '78298' or zipCode = '78299') 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 ='78002' or zipCode = '78023' or zipCode = '78023' or zipCode = '78039' or zipCode = '78052' or zipCode = '78073' or zipCode = '78101' or zipCode = '78108' or zipCode = '78109' or zipCode = '78112' or zipCode = '78112' or zipCode = '78124' or zipCode = '78009' or zipCode = '78015' or zipCode = '78015' or zipCode = '78015' or zipCode = '78054' or zipCode = '78056' or zipCode = '78056' or zipCode = '78066' or zipCode = '78069' or zipCode = '78148' or zipCode = '78148' or zipCode = '78148' or zipCode = '78148' or zipCode = '78148' or zipCode = '78148' or zipCode = '78150' or zipCode = '78150' or zipCode = '78150' or zipCode = '78150' or zipCode = '78150' or zipCode = '78150' or zipCode = '78152' or zipCode = '78209' or zipCode = '78209' or zipCode = '78209' or zipCode = '78210' or zipCode = '78211' or zipCode = '78212' or zipCode = '78212' or zipCode = '78213' or zipCode = '78213' or zipCode = '78214' or zipCode = '78215' or zipCode = '78216' or zipCode = '78217' or zipCode = '78218' or zipCode = '78219' or zipCode = '78219' or zipCode = '78220' or zipCode = '78221' or zipCode = '78222' or zipCode = '78223' or zipCode = '78224' or zipCode = '78225' or zipCode = '78226' or zipCode = '78226' or zipCode = '78236' or zipCode = '78236' or zipCode = '78236' or zipCode = '78236' or zipCode = '78236' or zipCode = '78236' or zipCode = '78236' or zipCode = '78236' or zipCode = '78237' or zipCode = '78238' or zipCode = '78238' or zipCode = '78239' or zipCode = '78239' or zipCode = '78240' or zipCode = '78241' or zipCode = '78241' or zipCode = '78241' or zipCode = '78242' or zipCode = '78243' or zipCode = '78243' or zipCode = '78244' or zipCode = '78245' or zipCode = '78246' or zipCode = '78265' or zipCode = '78266' or zipCode = '78266' or zipCode = '78266' or zipCode = '78268' or zipCode = '78268' or zipCode = '78269' or zipCode = '78270' or zipCode = '78275' or zipCode = '78275' or zipCode = '78278' or zipCode = '78279' or zipCode = '78280' or zipCode = '78283' or zipCode = '78284' or zipCode = '78285' or zipCode = '78285' or zipCode = '78286' or zipCode = '78286' or zipCode = '78287' or zipCode = '78287' or zipCode = '78288' or zipCode = '78288' or zipCode = '78289' or zipCode = '78289' or zipCode = '78291' or zipCode = '78292' or zipCode = '78293' or zipCode = '78294' or zipCode = '78295' or zipCode = '78296' or zipCode = '78297' or zipCode = '78298' or zipCode = '78299' or zipCode = '78154' or zipCode = '78154' or zipCode = '78154' or zipCode = '78163' or zipCode = '78163' or zipCode = '78201' or zipCode = '78201' or zipCode = '78201' or zipCode = '78202' or zipCode = '78203' or zipCode = '78204' or zipCode = '78205' or zipCode = '78206' or zipCode = '78207' or zipCode = '78208' or zipCode = '78227' or zipCode = '78227' or zipCode = '78228' or zipCode = '78229' or zipCode = '78230' or zipCode = '78230' or zipCode = '78231' or zipCode = '78231' or zipCode = '78232' or zipCode = '78232' or zipCode = '78232' or zipCode = '78232' or zipCode = '78232' or zipCode = '78233' or zipCode = '78233' or zipCode = '78234' or zipCode = '78234' or zipCode = '78234' or zipCode = '78235' or zipCode = '78235' or zipCode = '78235' or zipCode = '78235' or zipCode = '78235' or zipCode = '78247' or zipCode = '78247' or zipCode = '78248' or zipCode = '78249' or zipCode = '78249' or zipCode = '78250' or zipCode = '78251' or zipCode = '78252' or zipCode = '78253' or zipCode = '78254' or zipCode = '78254' or zipCode = '78255' or zipCode = '78256' or zipCode = '78257' or zipCode = '78257' or zipCode = '78258' or zipCode = '78259' or zipCode = '78260' or zipCode = '78261' or zipCode = '78262' or zipCode = '78262' or zipCode = '78263' or zipCode = '78263' or zipCode = '78264' or zipCode = '78002' or zipCode = '78009' or zipCode = '78015' or zipCode = '78023' or zipCode = '78039' or zipCode = '78052' or zipCode = '78054' or zipCode = '78056' or zipCode = '78066' or zipCode = '78069' or zipCode = '78073' or zipCode = '78081' or zipCode = '78101' or zipCode = '78108' or zipCode = '78109' or zipCode = '78112' or zipCode = '78124' or zipCode = '78126' or zipCode = '78148' or zipCode = '78150' or zipCode = '78152' or zipCode = '78154' or zipCode = '78163' or zipCode = '78201' or zipCode = '78202' or zipCode = '78203' or zipCode = '78204' or zipCode = '78205' or zipCode = '78206' or zipCode = '78207' or zipCode = '78208' or zipCode = '78209' or zipCode = '78210' or zipCode = '78211' or zipCode = '78212' or zipCode = '78213' or zipCode = '78214' or zipCode = '78215' or zipCode = '78216' or zipCode = '78217' or zipCode = '78218' or zipCode = '78219' or zipCode = '78220' or zipCode = '78221' or zipCode = '78222' or zipCode = '78223' or zipCode = '78224' or zipCode = '78225' or zipCode = '78226' or zipCode = '78227' or zipCode = '78228' or zipCode = '78229' or zipCode = '78230' or zipCode = '78231' or zipCode = '78232' or zipCode = '78233' or zipCode = '78234' or zipCode = '78235' or zipCode = '78236' or zipCode = '78237' or zipCode = '78238' or zipCode = '78239' or zipCode = '78240' or zipCode = '78241' or zipCode = '78242' or zipCode = '78243' or zipCode = '78244' or zipCode = '78245' or zipCode = '78246' or zipCode = '78247' or zipCode = '78248' or zipCode = '78249' or zipCode = '78250' or zipCode = '78251' or zipCode = '78252' or zipCode = '78253' or zipCode = '78254' or zipCode = '78255' or zipCode = '78256' or zipCode = '78257' or zipCode = '78258' or zipCode = '78259' or zipCode = '78260' or zipCode = '78261' or zipCode = '78262' or zipCode = '78263' or zipCode = '78264' or zipCode = '78265' or zipCode = '78266' or zipCode = '78268' or zipCode = '78269' or zipCode = '78270' or zipCode = '78275' or zipCode = '78278' or zipCode = '78279' or zipCode = '78280' or zipCode = '78283' or zipCode = '78284' or zipCode = '78285' or zipCode = '78286' or zipCode = '78287' or zipCode = '78288' or zipCode = '78289' or zipCode = '78291' or zipCode = '78292' or zipCode = '78293' or zipCode = '78294' or zipCode = '78295' or zipCode = '78296' or zipCode = '78297' or zipCode = '78298' or zipCode = '78299') 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 ='78002' or zipCode = '78023' or zipCode = '78023' or zipCode = '78039' or zipCode = '78052' or zipCode = '78073' or zipCode = '78101' or zipCode = '78108' or zipCode = '78109' or zipCode = '78112' or zipCode = '78112' or zipCode = '78124' or zipCode = '78009' or zipCode = '78015' or zipCode = '78015' or zipCode = '78015' or zipCode = '78054' or zipCode = '78056' or zipCode = '78056' or zipCode = '78066' or zipCode = '78069' or zipCode = '78148' or zipCode = '78148' or zipCode = '78148' or zipCode = '78148' or zipCode = '78148' or zipCode = '78148' or zipCode = '78150' or zipCode = '78150' or zipCode = '78150' or zipCode = '78150' or zipCode = '78150' or zipCode = '78150' or zipCode = '78152' or zipCode = '78209' or zipCode = '78209' or zipCode = '78209' or zipCode = '78210' or zipCode = '78211' or zipCode = '78212' or zipCode = '78212' or zipCode = '78213' or zipCode = '78213' or zipCode = '78214' or zipCode = '78215' or zipCode = '78216' or zipCode = '78217' or zipCode = '78218' or zipCode = '78219' or zipCode = '78219' or zipCode = '78220' or zipCode = '78221' or zipCode = '78222' or zipCode = '78223' or zipCode = '78224' or zipCode = '78225' or zipCode = '78226' or zipCode = '78226' or zipCode = '78236' or zipCode = '78236' or zipCode = '78236' or zipCode = '78236' or zipCode = '78236' or zipCode = '78236' or zipCode = '78236' or zipCode = '78236' or zipCode = '78237' or zipCode = '78238' or zipCode = '78238' or zipCode = '78239' or zipCode = '78239' or zipCode = '78240' or zipCode = '78241' or zipCode = '78241' or zipCode = '78241' or zipCode = '78242' or zipCode = '78243' or zipCode = '78243' or zipCode = '78244' or zipCode = '78245' or zipCode = '78246' or zipCode = '78265' or zipCode = '78266' or zipCode = '78266' or zipCode = '78266' or zipCode = '78268' or zipCode = '78268' or zipCode = '78269' or zipCode = '78270' or zipCode = '78275' or zipCode = '78275' or zipCode = '78278' or zipCode = '78279' or zipCode = '78280' or zipCode = '78283' or zipCode = '78284' or zipCode = '78285' or zipCode = '78285' or zipCode = '78286' or zipCode = '78286' or zipCode = '78287' or zipCode = '78287' or zipCode = '78288' or zipCode = '78288' or zipCode = '78289' or zipCode = '78289' or zipCode = '78291' or zipCode = '78292' or zipCode = '78293' or zipCode = '78294' or zipCode = '78295' or zipCode = '78296' or zipCode = '78297' or zipCode = '78298' or zipCode = '78299' or zipCode = '78154' or zipCode = '78154' or zipCode = '78154' or zipCode = '78163' or zipCode = '78163' or zipCode = '78201' or zipCode = '78201' or zipCode = '78201' or zipCode = '78202' or zipCode = '78203' or zipCode = '78204' or zipCode = '78205' or zipCode = '78206' or zipCode = '78207' or zipCode = '78208' or zipCode = '78227' or zipCode = '78227' or zipCode = '78228' or zipCode = '78229' or zipCode = '78230' or zipCode = '78230' or zipCode = '78231' or zipCode = '78231' or zipCode = '78232' or zipCode = '78232' or zipCode = '78232' or zipCode = '78232' or zipCode = '78232' or zipCode = '78233' or zipCode = '78233' or zipCode = '78234' or zipCode = '78234' or zipCode = '78234' or zipCode = '78235' or zipCode = '78235' or zipCode = '78235' or zipCode = '78235' or zipCode = '78235' or zipCode = '78247' or zipCode = '78247' or zipCode = '78248' or zipCode = '78249' or zipCode = '78249' or zipCode = '78250' or zipCode = '78251' or zipCode = '78252' or zipCode = '78253' or zipCode = '78254' or zipCode = '78254' or zipCode = '78255' or zipCode = '78256' or zipCode = '78257' or zipCode = '78257' or zipCode = '78258' or zipCode = '78259' or zipCode = '78260' or zipCode = '78261' or zipCode = '78262' or zipCode = '78262' or zipCode = '78263' or zipCode = '78263' or zipCode = '78264' or zipCode = '78002' or zipCode = '78009' or zipCode = '78015' or zipCode = '78023' or zipCode = '78039' or zipCode = '78052' or zipCode = '78054' or zipCode = '78056' or zipCode = '78066' or zipCode = '78069' or zipCode = '78073' or zipCode = '78081' or zipCode = '78101' or zipCode = '78108' or zipCode = '78109' or zipCode = '78112' or zipCode = '78124' or zipCode = '78126' or zipCode = '78148' or zipCode = '78150' or zipCode = '78152' or zipCode = '78154' or zipCode = '78163' or zipCode = '78201' or zipCode = '78202' or zipCode = '78203' or zipCode = '78204' or zipCode = '78205' or zipCode = '78206' or zipCode = '78207' or zipCode = '78208' or zipCode = '78209' or zipCode = '78210' or zipCode = '78211' or zipCode = '78212' or zipCode = '78213' or zipCode = '78214' or zipCode = '78215' or zipCode = '78216' or zipCode = '78217' or zipCode = '78218' or zipCode = '78219' or zipCode = '78220' or zipCode = '78221' or zipCode = '78222' or zipCode = '78223' or zipCode = '78224' or zipCode = '78225' or zipCode = '78226' or zipCode = '78227' or zipCode = '78228' or zipCode = '78229' or zipCode = '78230' or zipCode = '78231' or zipCode = '78232' or zipCode = '78233' or zipCode = '78234' or zipCode = '78235' or zipCode = '78236' or zipCode = '78237' or zipCode = '78238' or zipCode = '78239' or zipCode = '78240' or zipCode = '78241' or zipCode = '78242' or zipCode = '78243' or zipCode = '78244' or zipCode = '78245' or zipCode = '78246' or zipCode = '78247' or zipCode = '78248' or zipCode = '78249' or zipCode = '78250' or zipCode = '78251' or zipCode = '78252' or zipCode = '78253' or zipCode = '78254' or zipCode = '78255' or zipCode = '78256' or zipCode = '78257' or zipCode = '78258' or zipCode = '78259' or zipCode = '78260' or zipCode = '78261' or zipCode = '78262' or zipCode = '78263' or zipCode = '78264' or zipCode = '78265' or zipCode = '78266' or zipCode = '78268' or zipCode = '78269' or zipCode = '78270' or zipCode = '78275' or zipCode = '78278' or zipCode = '78279' or zipCode = '78280' or zipCode = '78283' or zipCode = '78284' or zipCode = '78285' or zipCode = '78286' or zipCode = '78287' or zipCode = '78288' or zipCode = '78289' or zipCode = '78291' or zipCode = '78292' or zipCode = '78293' or zipCode = '78294' or zipCode = '78295' or zipCode = '78296' or zipCode = '78297' or zipCode = '78298' or zipCode = '78299') 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 ='78002' or zipCode = '78023' or zipCode = '78023' or zipCode = '78039' or zipCode = '78052' or zipCode = '78073' or zipCode = '78101' or zipCode = '78108' or zipCode = '78109' or zipCode = '78112' or zipCode = '78112' or zipCode = '78124' or zipCode = '78009' or zipCode = '78015' or zipCode = '78015' or zipCode = '78015' or zipCode = '78054' or zipCode = '78056' or zipCode = '78056' or zipCode = '78066' or zipCode = '78069' or zipCode = '78148' or zipCode = '78148' or zipCode = '78148' or zipCode = '78148' or zipCode = '78148' or zipCode = '78148' or zipCode = '78150' or zipCode = '78150' or zipCode = '78150' or zipCode = '78150' or zipCode = '78150' or zipCode = '78150' or zipCode = '78152' or zipCode = '78209' or zipCode = '78209' or zipCode = '78209' or zipCode = '78210' or zipCode = '78211' or zipCode = '78212' or zipCode = '78212' or zipCode = '78213' or zipCode = '78213' or zipCode = '78214' or zipCode = '78215' or zipCode = '78216' or zipCode = '78217' or zipCode = '78218' or zipCode = '78219' or zipCode = '78219' or zipCode = '78220' or zipCode = '78221' or zipCode = '78222' or zipCode = '78223' or zipCode = '78224' or zipCode = '78225' or zipCode = '78226' or zipCode = '78226' or zipCode = '78236' or zipCode = '78236' or zipCode = '78236' or zipCode = '78236' or zipCode = '78236' or zipCode = '78236' or zipCode = '78236' or zipCode = '78236' or zipCode = '78237' or zipCode = '78238' or zipCode = '78238' or zipCode = '78239' or zipCode = '78239' or zipCode = '78240' or zipCode = '78241' or zipCode = '78241' or zipCode = '78241' or zipCode = '78242' or zipCode = '78243' or zipCode = '78243' or zipCode = '78244' or zipCode = '78245' or zipCode = '78246' or zipCode = '78265' or zipCode = '78266' or zipCode = '78266' or zipCode = '78266' or zipCode = '78268' or zipCode = '78268' or zipCode = '78269' or zipCode = '78270' or zipCode = '78275' or zipCode = '78275' or zipCode = '78278' or zipCode = '78279' or zipCode = '78280' or zipCode = '78283' or zipCode = '78284' or zipCode = '78285' or zipCode = '78285' or zipCode = '78286' or zipCode = '78286' or zipCode = '78287' or zipCode = '78287' or zipCode = '78288' or zipCode = '78288' or zipCode = '78289' or zipCode = '78289' or zipCode = '78291' or zipCode = '78292' or zipCode = '78293' or zipCode = '78294' or zipCode = '78295' or zipCode = '78296' or zipCode = '78297' or zipCode = '78298' or zipCode = '78299' or zipCode = '78154' or zipCode = '78154' or zipCode = '78154' or zipCode = '78163' or zipCode = '78163' or zipCode = '78201' or zipCode = '78201' or zipCode = '78201' or zipCode = '78202' or zipCode = '78203' or zipCode = '78204' or zipCode = '78205' or zipCode = '78206' or zipCode = '78207' or zipCode = '78208' or zipCode = '78227' or zipCode = '78227' or zipCode = '78228' or zipCode = '78229' or zipCode = '78230' or zipCode = '78230' or zipCode = '78231' or zipCode = '78231' or zipCode = '78232' or zipCode = '78232' or zipCode = '78232' or zipCode = '78232' or zipCode = '78232' or zipCode = '78233' or zipCode = '78233' or zipCode = '78234' or zipCode = '78234' or zipCode = '78234' or zipCode = '78235' or zipCode = '78235' or zipCode = '78235' or zipCode = '78235' or zipCode = '78235' or zipCode = '78247' or zipCode = '78247' or zipCode = '78248' or zipCode = '78249' or zipCode = '78249' or zipCode = '78250' or zipCode = '78251' or zipCode = '78252' or zipCode = '78253' or zipCode = '78254' or zipCode = '78254' or zipCode = '78255' or zipCode = '78256' or zipCode = '78257' or zipCode = '78257' or zipCode = '78258' or zipCode = '78259' or zipCode = '78260' or zipCode = '78261' or zipCode = '78262' or zipCode = '78262' or zipCode = '78263' or zipCode = '78263' or zipCode = '78264' or zipCode = '78002' or zipCode = '78009' or zipCode = '78015' or zipCode = '78023' or zipCode = '78039' or zipCode = '78052' or zipCode = '78054' or zipCode = '78056' or zipCode = '78066' or zipCode = '78069' or zipCode = '78073' or zipCode = '78081' or zipCode = '78101' or zipCode = '78108' or zipCode = '78109' or zipCode = '78112' or zipCode = '78124' or zipCode = '78126' or zipCode = '78148' or zipCode = '78150' or zipCode = '78152' or zipCode = '78154' or zipCode = '78163' or zipCode = '78201' or zipCode = '78202' or zipCode = '78203' or zipCode = '78204' or zipCode = '78205' or zipCode = '78206' or zipCode = '78207' or zipCode = '78208' or zipCode = '78209' or zipCode = '78210' or zipCode = '78211' or zipCode = '78212' or zipCode = '78213' or zipCode = '78214' or zipCode = '78215' or zipCode = '78216' or zipCode = '78217' or zipCode = '78218' or zipCode = '78219' or zipCode = '78220' or zipCode = '78221' or zipCode = '78222' or zipCode = '78223' or zipCode = '78224' or zipCode = '78225' or zipCode = '78226' or zipCode = '78227' or zipCode = '78228' or zipCode = '78229' or zipCode = '78230' or zipCode = '78231' or zipCode = '78232' or zipCode = '78233' or zipCode = '78234' or zipCode = '78235' or zipCode = '78236' or zipCode = '78237' or zipCode = '78238' or zipCode = '78239' or zipCode = '78240' or zipCode = '78241' or zipCode = '78242' or zipCode = '78243' or zipCode = '78244' or zipCode = '78245' or zipCode = '78246' or zipCode = '78247' or zipCode = '78248' or zipCode = '78249' or zipCode = '78250' or zipCode = '78251' or zipCode = '78252' or zipCode = '78253' or zipCode = '78254' or zipCode = '78255' or zipCode = '78256' or zipCode = '78257' or zipCode = '78258' or zipCode = '78259' or zipCode = '78260' or zipCode = '78261' or zipCode = '78262' or zipCode = '78263' or zipCode = '78264' or zipCode = '78265' or zipCode = '78266' or zipCode = '78268' or zipCode = '78269' or zipCode = '78270' or zipCode = '78275' or zipCode = '78278' or zipCode = '78279' or zipCode = '78280' or zipCode = '78283' or zipCode = '78284' or zipCode = '78285' or zipCode = '78286' or zipCode = '78287' or zipCode = '78288' or zipCode = '78289' or zipCode = '78291' or zipCode = '78292' or zipCode = '78293' or zipCode = '78294' or zipCode = '78295' or zipCode = '78296' or zipCode = '78297' or zipCode = '78298' or zipCode = '78299') 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 ='78002' or property_zip = '78023' or property_zip = '78023' or property_zip = '78039' or property_zip = '78052' or property_zip = '78073' or property_zip = '78101' or property_zip = '78108' or property_zip = '78109' or property_zip = '78112' or property_zip = '78112' or property_zip = '78124' or property_zip = '78009' or property_zip = '78015' or property_zip = '78015' or property_zip = '78015' or property_zip = '78054' or property_zip = '78056' or property_zip = '78056' or property_zip = '78066' or property_zip = '78069' or property_zip = '78148' or property_zip = '78148' or property_zip = '78148' or property_zip = '78148' or property_zip = '78148' or property_zip = '78148' or property_zip = '78150' or property_zip = '78150' or property_zip = '78150' or property_zip = '78150' or property_zip = '78150' or property_zip = '78150' or property_zip = '78152' or property_zip = '78209' or property_zip = '78209' or property_zip = '78209' or property_zip = '78210' or property_zip = '78211' or property_zip = '78212' or property_zip = '78212' or property_zip = '78213' or property_zip = '78213' or property_zip = '78214' or property_zip = '78215' or property_zip = '78216' or property_zip = '78217' or property_zip = '78218' or property_zip = '78219' or property_zip = '78219' or property_zip = '78220' or property_zip = '78221' or property_zip = '78222' or property_zip = '78223' or property_zip = '78224' or property_zip = '78225' or property_zip = '78226' or property_zip = '78226' or property_zip = '78236' or property_zip = '78236' or property_zip = '78236' or property_zip = '78236' or property_zip = '78236' or property_zip = '78236' or property_zip = '78236' or property_zip = '78236' or property_zip = '78237' or property_zip = '78238' or property_zip = '78238' or property_zip = '78239' or property_zip = '78239' or property_zip = '78240' or property_zip = '78241' or property_zip = '78241' or property_zip = '78241' or property_zip = '78242' or property_zip = '78243' or property_zip = '78243' or property_zip = '78244' or property_zip = '78245' or property_zip = '78246' or property_zip = '78265' or property_zip = '78266' or property_zip = '78266' or property_zip = '78266' or property_zip = '78268' or property_zip = '78268' or property_zip = '78269' or property_zip = '78270' or property_zip = '78275' or property_zip = '78275' or property_zip = '78278' or property_zip = '78279' or property_zip = '78280' or property_zip = '78283' or property_zip = '78284' or property_zip = '78285' or property_zip = '78285' or property_zip = '78286' or property_zip = '78286' or property_zip = '78287' or property_zip = '78287' or property_zip = '78288' or property_zip = '78288' or property_zip = '78289' or property_zip = '78289' or property_zip = '78291' or property_zip = '78292' or property_zip = '78293' or property_zip = '78294' or property_zip = '78295' or property_zip = '78296' or property_zip = '78297' or property_zip = '78298' or property_zip = '78299' or property_zip = '78154' or property_zip = '78154' or property_zip = '78154' or property_zip = '78163' or property_zip = '78163' or property_zip = '78201' or property_zip = '78201' or property_zip = '78201' or property_zip = '78202' or property_zip = '78203' or property_zip = '78204' or property_zip = '78205' or property_zip = '78206' or property_zip = '78207' or property_zip = '78208' or property_zip = '78227' or property_zip = '78227' or property_zip = '78228' or property_zip = '78229' or property_zip = '78230' or property_zip = '78230' or property_zip = '78231' or property_zip = '78231' or property_zip = '78232' or property_zip = '78232' or property_zip = '78232' or property_zip = '78232' or property_zip = '78232' or property_zip = '78233' or property_zip = '78233' or property_zip = '78234' or property_zip = '78234' or property_zip = '78234' or property_zip = '78235' or property_zip = '78235' or property_zip = '78235' or property_zip = '78235' or property_zip = '78235' or property_zip = '78247' or property_zip = '78247' or property_zip = '78248' or property_zip = '78249' or property_zip = '78249' or property_zip = '78250' or property_zip = '78251' or property_zip = '78252' or property_zip = '78253' or property_zip = '78254' or property_zip = '78254' or property_zip = '78255' or property_zip = '78256' or property_zip = '78257' or property_zip = '78257' or property_zip = '78258' or property_zip = '78259' or property_zip = '78260' or property_zip = '78261' or property_zip = '78262' or property_zip = '78262' or property_zip = '78263' or property_zip = '78263' or property_zip = '78264' or property_zip = '78002' or property_zip = '78009' or property_zip = '78015' or property_zip = '78023' or property_zip = '78039' or property_zip = '78052' or property_zip = '78054' or property_zip = '78056' or property_zip = '78066' or property_zip = '78069' or property_zip = '78073' or property_zip = '78081' or property_zip = '78101' or property_zip = '78108' or property_zip = '78109' or property_zip = '78112' or property_zip = '78124' or property_zip = '78126' or property_zip = '78148' or property_zip = '78150' or property_zip = '78152' or property_zip = '78154' or property_zip = '78163' or property_zip = '78201' or property_zip = '78202' or property_zip = '78203' or property_zip = '78204' or property_zip = '78205' or property_zip = '78206' or property_zip = '78207' or property_zip = '78208' or property_zip = '78209' or property_zip = '78210' or property_zip = '78211' or property_zip = '78212' or property_zip = '78213' or property_zip = '78214' or property_zip = '78215' or property_zip = '78216' or property_zip = '78217' or property_zip = '78218' or property_zip = '78219' or property_zip = '78220' or property_zip = '78221' or property_zip = '78222' or property_zip = '78223' or property_zip = '78224' or property_zip = '78225' or property_zip = '78226' or property_zip = '78227' or property_zip = '78228' or property_zip = '78229' or property_zip = '78230' or property_zip = '78231' or property_zip = '78232' or property_zip = '78233' or property_zip = '78234' or property_zip = '78235' or property_zip = '78236' or property_zip = '78237' or property_zip = '78238' or property_zip = '78239' or property_zip = '78240' or property_zip = '78241' or property_zip = '78242' or property_zip = '78243' or property_zip = '78244' or property_zip = '78245' or property_zip = '78246' or property_zip = '78247' or property_zip = '78248' or property_zip = '78249' or property_zip = '78250' or property_zip = '78251' or property_zip = '78252' or property_zip = '78253' or property_zip = '78254' or property_zip = '78255' or property_zip = '78256' or property_zip = '78257' or property_zip = '78258' or property_zip = '78259' or property_zip = '78260' or property_zip = '78261' or property_zip = '78262' or property_zip = '78263' or property_zip = '78264' or property_zip = '78265' or property_zip = '78266' or property_zip = '78268' or property_zip = '78269' or property_zip = '78270' or property_zip = '78275' or property_zip = '78278' or property_zip = '78279' or property_zip = '78280' or property_zip = '78283' or property_zip = '78284' or property_zip = '78285' or property_zip = '78286' or property_zip = '78287' or property_zip = '78288' or property_zip = '78289' or property_zip = '78291' or property_zip = '78292' or property_zip = '78293' or property_zip = '78294' or property_zip = '78295' or property_zip = '78296' or property_zip = '78297' or property_zip = '78298' or property_zip = '78299') 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 ='78002' or zip = '78023' or zip = '78023' or zip = '78039' or zip = '78052' or zip = '78073' or zip = '78101' or zip = '78108' or zip = '78109' or zip = '78112' or zip = '78112' or zip = '78124' or zip = '78009' or zip = '78015' or zip = '78015' or zip = '78015' or zip = '78054' or zip = '78056' or zip = '78056' or zip = '78066' or zip = '78069' or zip = '78148' or zip = '78148' or zip = '78148' or zip = '78148' or zip = '78148' or zip = '78148' or zip = '78150' or zip = '78150' or zip = '78150' or zip = '78150' or zip = '78150' or zip = '78150' or zip = '78152' or zip = '78209' or zip = '78209' or zip = '78209' or zip = '78210' or zip = '78211' or zip = '78212' or zip = '78212' or zip = '78213' or zip = '78213' or zip = '78214' or zip = '78215' or zip = '78216' or zip = '78217' or zip = '78218' or zip = '78219' or zip = '78219' or zip = '78220' or zip = '78221' or zip = '78222' or zip = '78223' or zip = '78224' or zip = '78225' or zip = '78226' or zip = '78226' or zip = '78236' or zip = '78236' or zip = '78236' or zip = '78236' or zip = '78236' or zip = '78236' or zip = '78236' or zip = '78236' or zip = '78237' or zip = '78238' or zip = '78238' or zip = '78239' or zip = '78239' or zip = '78240' or zip = '78241' or zip = '78241' or zip = '78241' or zip = '78242' or zip = '78243' or zip = '78243' or zip = '78244' or zip = '78245' or zip = '78246' or zip = '78265' or zip = '78266' or zip = '78266' or zip = '78266' or zip = '78268' or zip = '78268' or zip = '78269' or zip = '78270' or zip = '78275' or zip = '78275' or zip = '78278' or zip = '78279' or zip = '78280' or zip = '78283' or zip = '78284' or zip = '78285' or zip = '78285' or zip = '78286' or zip = '78286' or zip = '78287' or zip = '78287' or zip = '78288' or zip = '78288' or zip = '78289' or zip = '78289' or zip = '78291' or zip = '78292' or zip = '78293' or zip = '78294' or zip = '78295' or zip = '78296' or zip = '78297' or zip = '78298' or zip = '78299' or zip = '78154' or zip = '78154' or zip = '78154' or zip = '78163' or zip = '78163' or zip = '78201' or zip = '78201' or zip = '78201' or zip = '78202' or zip = '78203' or zip = '78204' or zip = '78205' or zip = '78206' or zip = '78207' or zip = '78208' or zip = '78227' or zip = '78227' or zip = '78228' or zip = '78229' or zip = '78230' or zip = '78230' or zip = '78231' or zip = '78231' or zip = '78232' or zip = '78232' or zip = '78232' or zip = '78232' or zip = '78232' or zip = '78233' or zip = '78233' or zip = '78234' or zip = '78234' or zip = '78234' or zip = '78235' or zip = '78235' or zip = '78235' or zip = '78235' or zip = '78235' or zip = '78247' or zip = '78247' or zip = '78248' or zip = '78249' or zip = '78249' or zip = '78250' or zip = '78251' or zip = '78252' or zip = '78253' or zip = '78254' or zip = '78254' or zip = '78255' or zip = '78256' or zip = '78257' or zip = '78257' or zip = '78258' or zip = '78259' or zip = '78260' or zip = '78261' or zip = '78262' or zip = '78262' or zip = '78263' or zip = '78263' or zip = '78264' or zip = '78002' or zip = '78009' or zip = '78015' or zip = '78023' or zip = '78039' or zip = '78052' or zip = '78054' or zip = '78056' or zip = '78066' or zip = '78069' or zip = '78073' or zip = '78081' or zip = '78101' or zip = '78108' or zip = '78109' or zip = '78112' or zip = '78124' or zip = '78126' or zip = '78148' or zip = '78150' or zip = '78152' or zip = '78154' or zip = '78163' or zip = '78201' or zip = '78202' or zip = '78203' or zip = '78204' or zip = '78205' or zip = '78206' or zip = '78207' or zip = '78208' or zip = '78209' or zip = '78210' or zip = '78211' or zip = '78212' or zip = '78213' or zip = '78214' or zip = '78215' or zip = '78216' or zip = '78217' or zip = '78218' or zip = '78219' or zip = '78220' or zip = '78221' or zip = '78222' or zip = '78223' or zip = '78224' or zip = '78225' or zip = '78226' or zip = '78227' or zip = '78228' or zip = '78229' or zip = '78230' or zip = '78231' or zip = '78232' or zip = '78233' or zip = '78234' or zip = '78235' or zip = '78236' or zip = '78237' or zip = '78238' or zip = '78239' or zip = '78240' or zip = '78241' or zip = '78242' or zip = '78243' or zip = '78244' or zip = '78245' or zip = '78246' or zip = '78247' or zip = '78248' or zip = '78249' or zip = '78250' or zip = '78251' or zip = '78252' or zip = '78253' or zip = '78254' or zip = '78255' or zip = '78256' or zip = '78257' or zip = '78258' or zip = '78259' or zip = '78260' or zip = '78261' or zip = '78262' or zip = '78263' or zip = '78264' or zip = '78265' or zip = '78266' or zip = '78268' or zip = '78269' or zip = '78270' or zip = '78275' or zip = '78278' or zip = '78279' or zip = '78280' or zip = '78283' or zip = '78284' or zip = '78285' or zip = '78286' or zip = '78287' or zip = '78288' or zip = '78289' or zip = '78291' or zip = '78292' or zip = '78293' or zip = '78294' or zip = '78295' or zip = '78296' or zip = '78297' or zip = '78298' or zip = '78299')
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 = 'SAN ANTONIO' 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();