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


126+ High Potential Investor Deals Near raleigh [Refine]


********NOTICE: Displaying 99 of over 126 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 ='27501' or zipCode = '27502' or zipCode = '27511' or zipCode = '27512' or zipCode = '27513' or zipCode = '27539' or zipCode = '27540' or zipCode = '27545' or zipCode = '27557' or zipCode = '27591' or zipCode = '27591' or zipCode = '27592' or zipCode = '27592' or zipCode = '27592' or zipCode = '27593' or zipCode = '27593' or zipCode = '27596' or zipCode = '27597' or zipCode = '27601' or zipCode = '27602' or zipCode = '27603' or zipCode = '27603' or zipCode = '27604' or zipCode = '27604' or zipCode = '27604' or zipCode = '27604' or zipCode = '27604' or zipCode = '27605' or zipCode = '27517' or zipCode = '27518' or zipCode = '27519' or zipCode = '27520' or zipCode = '27520' or zipCode = '27520' or zipCode = '27521' or zipCode = '27522' or zipCode = '27522' or zipCode = '27523' or zipCode = '27526' or zipCode = '27526' or zipCode = '27527' or zipCode = '27528' or zipCode = '27529' or zipCode = '27557' or zipCode = '27560' or zipCode = '27562' or zipCode = '27564' or zipCode = '27571' or zipCode = '27576' or zipCode = '27587' or zipCode = '27588' or zipCode = '27605' or zipCode = '27606' or zipCode = '27607' or zipCode = '27607' or zipCode = '27607' or zipCode = '27607' or zipCode = '27608' or zipCode = '27608' or zipCode = '27609' or zipCode = '27609' or zipCode = '27610' or zipCode = '27611' or zipCode = '27612' or zipCode = '27612' or zipCode = '27612' or zipCode = '27613' or zipCode = '27614' or zipCode = '27614' or zipCode = '27615' or zipCode = '27616' or zipCode = '27616' or zipCode = '27617' or zipCode = '27619' or zipCode = '27620' or zipCode = '27621' or zipCode = '27676' or zipCode = '27690' or zipCode = '27690' or zipCode = '27695' or zipCode = '27695' or zipCode = '27697' or zipCode = '27697' or zipCode = '27698' or zipCode = '27698' or zipCode = '27699' or zipCode = '27699' or zipCode = '27701' or zipCode = '27701' or zipCode = '27702' or zipCode = '27703' or zipCode = '27703' or zipCode = '27704' or zipCode = '27706' or zipCode = '27707' or zipCode = '27707' or zipCode = '27708' or zipCode = '27708' or zipCode = '27708' or zipCode = '27709' or zipCode = '27709' or zipCode = '27709' or zipCode = '27710' or zipCode = '27710' or zipCode = '27711' or zipCode = '27711' or zipCode = '27711' or zipCode = '27711' or zipCode = '27711' or zipCode = '27713' or zipCode = '27715' or zipCode = '27717' or zipCode = '27722' or zipCode = '27622' or zipCode = '27623' or zipCode = '27623' or zipCode = '27624' or zipCode = '27625' or zipCode = '27626' or zipCode = '27627' or zipCode = '27628' or zipCode = '27629' or zipCode = '27634' or zipCode = '27634' or zipCode = '27635' or zipCode = '27635' or zipCode = '27636' or zipCode = '27640' or zipCode = '27640' or zipCode = '27650' or zipCode = '27656' or zipCode = '27656' or zipCode = '27658' or zipCode = '27661' or zipCode = '27668' or zipCode = '27668' or zipCode = '27675' or zipCode = '27675' or zipCode = '27501' or zipCode = '27502' or zipCode = '27508' or zipCode = '27511' or zipCode = '27512' or zipCode = '27513' or zipCode = '27514' or zipCode = '27517' or zipCode = '27518' or zipCode = '27519' or zipCode = '27520' or zipCode = '27522' or zipCode = '27523' or zipCode = '27525' or zipCode = '27526' or zipCode = '27529' or zipCode = '27539' or zipCode = '27540' or zipCode = '27545' or zipCode = '27557' or zipCode = '27560' or zipCode = '27561' or zipCode = '27562' or zipCode = '27564' or zipCode = '27571' or zipCode = '27577' or zipCode = '27587' or zipCode = '27588' or zipCode = '27591' or zipCode = '27592' or zipCode = '27593' or zipCode = '27596' or zipCode = '27597' or zipCode = '27601' or zipCode = '27602' or zipCode = '27603' or zipCode = '27604' or zipCode = '27605' or zipCode = '27606' or zipCode = '27607' or zipCode = '27608' or zipCode = '27609' or zipCode = '27610' or zipCode = '27611' or zipCode = '27612' or zipCode = '27613' or zipCode = '27614' or zipCode = '27615' or zipCode = '27616' or zipCode = '27617' or zipCode = '27619' or zipCode = '27620' or zipCode = '27621' or zipCode = '27622' or zipCode = '27623' or zipCode = '27624' or zipCode = '27625' or zipCode = '27626' or zipCode = '27627' or zipCode = '27628' or zipCode = '27629' or zipCode = '27634' or zipCode = '27635' or zipCode = '27636' or zipCode = '27640' or zipCode = '27650' or zipCode = '27656' or zipCode = '27658' or zipCode = '27661' or zipCode = '27668' or zipCode = '27675' or zipCode = '27676' or zipCode = '27690' or zipCode = '27695' or zipCode = '27697' or zipCode = '27698' or zipCode = '27699' or zipCode = '27701' or zipCode = '27702' or zipCode = '27703' or zipCode = '27704' or zipCode = '27705' or zipCode = '27706' or zipCode = '27707' or zipCode = '27708' or zipCode = '27709' or zipCode = '27710' or zipCode = '27711' or zipCode = '27713' or zipCode = '27715' or zipCode = '27717' or zipCode = '27722')
select top 45 *, cast(tax_value as float)/cast(price as float) as tax_ratio from tblBothNew NOLOCK where priority IS NULL and price > 5000 and (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 1=1 and state = 'NC' and photoURL1 IS NOT NULL and theType = 'Tax' and tax_value IS NOT NULL and (bedrooms <> '' AND bedrooms IS NOT NULL) and tax_value/price < 5 and 1=1 and (1=1) and price >= 0 and price <= 499999 and 11=11 and (zipCode ='27501' or zipCode = '27502' or zipCode = '27511' or zipCode = '27512' or zipCode = '27513' or zipCode = '27539' or zipCode = '27540' or zipCode = '27545' or zipCode = '27557' or zipCode = '27591' or zipCode = '27591' or zipCode = '27592' or zipCode = '27592' or zipCode = '27592' or zipCode = '27593' or zipCode = '27593' or zipCode = '27596' or zipCode = '27597' or zipCode = '27601' or zipCode = '27602' or zipCode = '27603' or zipCode = '27603' or zipCode = '27604' or zipCode = '27604' or zipCode = '27604' or zipCode = '27604' or zipCode = '27604' or zipCode = '27605' or zipCode = '27517' or zipCode = '27518' or zipCode = '27519' or zipCode = '27520' or zipCode = '27520' or zipCode = '27520' or zipCode = '27521' or zipCode = '27522' or zipCode = '27522' or zipCode = '27523' or zipCode = '27526' or zipCode = '27526' or zipCode = '27527' or zipCode = '27528' or zipCode = '27529' or zipCode = '27557' or zipCode = '27560' or zipCode = '27562' or zipCode = '27564' or zipCode = '27571' or zipCode = '27576' or zipCode = '27587' or zipCode = '27588' or zipCode = '27605' or zipCode = '27606' or zipCode = '27607' or zipCode = '27607' or zipCode = '27607' or zipCode = '27607' or zipCode = '27608' or zipCode = '27608' or zipCode = '27609' or zipCode = '27609' or zipCode = '27610' or zipCode = '27611' or zipCode = '27612' or zipCode = '27612' or zipCode = '27612' or zipCode = '27613' or zipCode = '27614' or zipCode = '27614' or zipCode = '27615' or zipCode = '27616' or zipCode = '27616' or zipCode = '27617' or zipCode = '27619' or zipCode = '27620' or zipCode = '27621' or zipCode = '27676' or zipCode = '27690' or zipCode = '27690' or zipCode = '27695' or zipCode = '27695' or zipCode = '27697' or zipCode = '27697' or zipCode = '27698' or zipCode = '27698' or zipCode = '27699' or zipCode = '27699' or zipCode = '27701' or zipCode = '27701' or zipCode = '27702' or zipCode = '27703' or zipCode = '27703' or zipCode = '27704' or zipCode = '27706' or zipCode = '27707' or zipCode = '27707' or zipCode = '27708' or zipCode = '27708' or zipCode = '27708' or zipCode = '27709' or zipCode = '27709' or zipCode = '27709' or zipCode = '27710' or zipCode = '27710' or zipCode = '27711' or zipCode = '27711' or zipCode = '27711' or zipCode = '27711' or zipCode = '27711' or zipCode = '27713' or zipCode = '27715' or zipCode = '27717' or zipCode = '27722' or zipCode = '27622' or zipCode = '27623' or zipCode = '27623' or zipCode = '27624' or zipCode = '27625' or zipCode = '27626' or zipCode = '27627' or zipCode = '27628' or zipCode = '27629' or zipCode = '27634' or zipCode = '27634' or zipCode = '27635' or zipCode = '27635' or zipCode = '27636' or zipCode = '27640' or zipCode = '27640' or zipCode = '27650' or zipCode = '27656' or zipCode = '27656' or zipCode = '27658' or zipCode = '27661' or zipCode = '27668' or zipCode = '27668' or zipCode = '27675' or zipCode = '27675' or zipCode = '27501' or zipCode = '27502' or zipCode = '27508' or zipCode = '27511' or zipCode = '27512' or zipCode = '27513' or zipCode = '27514' or zipCode = '27517' or zipCode = '27518' or zipCode = '27519' or zipCode = '27520' or zipCode = '27522' or zipCode = '27523' or zipCode = '27525' or zipCode = '27526' or zipCode = '27529' or zipCode = '27539' or zipCode = '27540' or zipCode = '27545' or zipCode = '27557' or zipCode = '27560' or zipCode = '27561' or zipCode = '27562' or zipCode = '27564' or zipCode = '27571' or zipCode = '27577' or zipCode = '27587' or zipCode = '27588' or zipCode = '27591' or zipCode = '27592' or zipCode = '27593' or zipCode = '27596' or zipCode = '27597' or zipCode = '27601' or zipCode = '27602' or zipCode = '27603' or zipCode = '27604' or zipCode = '27605' or zipCode = '27606' or zipCode = '27607' or zipCode = '27608' or zipCode = '27609' or zipCode = '27610' or zipCode = '27611' or zipCode = '27612' or zipCode = '27613' or zipCode = '27614' or zipCode = '27615' or zipCode = '27616' or zipCode = '27617' or zipCode = '27619' or zipCode = '27620' or zipCode = '27621' or zipCode = '27622' or zipCode = '27623' or zipCode = '27624' or zipCode = '27625' or zipCode = '27626' or zipCode = '27627' or zipCode = '27628' or zipCode = '27629' or zipCode = '27634' or zipCode = '27635' or zipCode = '27636' or zipCode = '27640' or zipCode = '27650' or zipCode = '27656' or zipCode = '27658' or zipCode = '27661' or zipCode = '27668' or zipCode = '27675' or zipCode = '27676' or zipCode = '27690' or zipCode = '27695' or zipCode = '27697' or zipCode = '27698' or zipCode = '27699' or zipCode = '27701' or zipCode = '27702' or zipCode = '27703' or zipCode = '27704' or zipCode = '27705' or zipCode = '27706' or zipCode = '27707' or zipCode = '27708' or zipCode = '27709' or zipCode = '27710' or zipCode = '27711' or zipCode = '27713' or zipCode = '27715' or zipCode = '27717' or zipCode = '27722') order by price;
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 ='27501' or zipCode = '27502' or zipCode = '27511' or zipCode = '27512' or zipCode = '27513' or zipCode = '27539' or zipCode = '27540' or zipCode = '27545' or zipCode = '27557' or zipCode = '27591' or zipCode = '27591' or zipCode = '27592' or zipCode = '27592' or zipCode = '27592' or zipCode = '27593' or zipCode = '27593' or zipCode = '27596' or zipCode = '27597' or zipCode = '27601' or zipCode = '27602' or zipCode = '27603' or zipCode = '27603' or zipCode = '27604' or zipCode = '27604' or zipCode = '27604' or zipCode = '27604' or zipCode = '27604' or zipCode = '27605' or zipCode = '27517' or zipCode = '27518' or zipCode = '27519' or zipCode = '27520' or zipCode = '27520' or zipCode = '27520' or zipCode = '27521' or zipCode = '27522' or zipCode = '27522' or zipCode = '27523' or zipCode = '27526' or zipCode = '27526' or zipCode = '27527' or zipCode = '27528' or zipCode = '27529' or zipCode = '27557' or zipCode = '27560' or zipCode = '27562' or zipCode = '27564' or zipCode = '27571' or zipCode = '27576' or zipCode = '27587' or zipCode = '27588' or zipCode = '27605' or zipCode = '27606' or zipCode = '27607' or zipCode = '27607' or zipCode = '27607' or zipCode = '27607' or zipCode = '27608' or zipCode = '27608' or zipCode = '27609' or zipCode = '27609' or zipCode = '27610' or zipCode = '27611' or zipCode = '27612' or zipCode = '27612' or zipCode = '27612' or zipCode = '27613' or zipCode = '27614' or zipCode = '27614' or zipCode = '27615' or zipCode = '27616' or zipCode = '27616' or zipCode = '27617' or zipCode = '27619' or zipCode = '27620' or zipCode = '27621' or zipCode = '27676' or zipCode = '27690' or zipCode = '27690' or zipCode = '27695' or zipCode = '27695' or zipCode = '27697' or zipCode = '27697' or zipCode = '27698' or zipCode = '27698' or zipCode = '27699' or zipCode = '27699' or zipCode = '27701' or zipCode = '27701' or zipCode = '27702' or zipCode = '27703' or zipCode = '27703' or zipCode = '27704' or zipCode = '27706' or zipCode = '27707' or zipCode = '27707' or zipCode = '27708' or zipCode = '27708' or zipCode = '27708' or zipCode = '27709' or zipCode = '27709' or zipCode = '27709' or zipCode = '27710' or zipCode = '27710' or zipCode = '27711' or zipCode = '27711' or zipCode = '27711' or zipCode = '27711' or zipCode = '27711' or zipCode = '27713' or zipCode = '27715' or zipCode = '27717' or zipCode = '27722' or zipCode = '27622' or zipCode = '27623' or zipCode = '27623' or zipCode = '27624' or zipCode = '27625' or zipCode = '27626' or zipCode = '27627' or zipCode = '27628' or zipCode = '27629' or zipCode = '27634' or zipCode = '27634' or zipCode = '27635' or zipCode = '27635' or zipCode = '27636' or zipCode = '27640' or zipCode = '27640' or zipCode = '27650' or zipCode = '27656' or zipCode = '27656' or zipCode = '27658' or zipCode = '27661' or zipCode = '27668' or zipCode = '27668' or zipCode = '27675' or zipCode = '27675' or zipCode = '27501' or zipCode = '27502' or zipCode = '27508' or zipCode = '27511' or zipCode = '27512' or zipCode = '27513' or zipCode = '27514' or zipCode = '27517' or zipCode = '27518' or zipCode = '27519' or zipCode = '27520' or zipCode = '27522' or zipCode = '27523' or zipCode = '27525' or zipCode = '27526' or zipCode = '27529' or zipCode = '27539' or zipCode = '27540' or zipCode = '27545' or zipCode = '27557' or zipCode = '27560' or zipCode = '27561' or zipCode = '27562' or zipCode = '27564' or zipCode = '27571' or zipCode = '27577' or zipCode = '27587' or zipCode = '27588' or zipCode = '27591' or zipCode = '27592' or zipCode = '27593' or zipCode = '27596' or zipCode = '27597' or zipCode = '27601' or zipCode = '27602' or zipCode = '27603' or zipCode = '27604' or zipCode = '27605' or zipCode = '27606' or zipCode = '27607' or zipCode = '27608' or zipCode = '27609' or zipCode = '27610' or zipCode = '27611' or zipCode = '27612' or zipCode = '27613' or zipCode = '27614' or zipCode = '27615' or zipCode = '27616' or zipCode = '27617' or zipCode = '27619' or zipCode = '27620' or zipCode = '27621' or zipCode = '27622' or zipCode = '27623' or zipCode = '27624' or zipCode = '27625' or zipCode = '27626' or zipCode = '27627' or zipCode = '27628' or zipCode = '27629' or zipCode = '27634' or zipCode = '27635' or zipCode = '27636' or zipCode = '27640' or zipCode = '27650' or zipCode = '27656' or zipCode = '27658' or zipCode = '27661' or zipCode = '27668' or zipCode = '27675' or zipCode = '27676' or zipCode = '27690' or zipCode = '27695' or zipCode = '27697' or zipCode = '27698' or zipCode = '27699' or zipCode = '27701' or zipCode = '27702' or zipCode = '27703' or zipCode = '27704' or zipCode = '27705' or zipCode = '27706' or zipCode = '27707' or zipCode = '27708' or zipCode = '27709' or zipCode = '27710' or zipCode = '27711' or zipCode = '27713' or zipCode = '27715' or zipCode = '27717' or zipCode = '27722') 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 ='27501' or zipCode = '27502' or zipCode = '27511' or zipCode = '27512' or zipCode = '27513' or zipCode = '27539' or zipCode = '27540' or zipCode = '27545' or zipCode = '27557' or zipCode = '27591' or zipCode = '27591' or zipCode = '27592' or zipCode = '27592' or zipCode = '27592' or zipCode = '27593' or zipCode = '27593' or zipCode = '27596' or zipCode = '27597' or zipCode = '27601' or zipCode = '27602' or zipCode = '27603' or zipCode = '27603' or zipCode = '27604' or zipCode = '27604' or zipCode = '27604' or zipCode = '27604' or zipCode = '27604' or zipCode = '27605' or zipCode = '27517' or zipCode = '27518' or zipCode = '27519' or zipCode = '27520' or zipCode = '27520' or zipCode = '27520' or zipCode = '27521' or zipCode = '27522' or zipCode = '27522' or zipCode = '27523' or zipCode = '27526' or zipCode = '27526' or zipCode = '27527' or zipCode = '27528' or zipCode = '27529' or zipCode = '27557' or zipCode = '27560' or zipCode = '27562' or zipCode = '27564' or zipCode = '27571' or zipCode = '27576' or zipCode = '27587' or zipCode = '27588' or zipCode = '27605' or zipCode = '27606' or zipCode = '27607' or zipCode = '27607' or zipCode = '27607' or zipCode = '27607' or zipCode = '27608' or zipCode = '27608' or zipCode = '27609' or zipCode = '27609' or zipCode = '27610' or zipCode = '27611' or zipCode = '27612' or zipCode = '27612' or zipCode = '27612' or zipCode = '27613' or zipCode = '27614' or zipCode = '27614' or zipCode = '27615' or zipCode = '27616' or zipCode = '27616' or zipCode = '27617' or zipCode = '27619' or zipCode = '27620' or zipCode = '27621' or zipCode = '27676' or zipCode = '27690' or zipCode = '27690' or zipCode = '27695' or zipCode = '27695' or zipCode = '27697' or zipCode = '27697' or zipCode = '27698' or zipCode = '27698' or zipCode = '27699' or zipCode = '27699' or zipCode = '27701' or zipCode = '27701' or zipCode = '27702' or zipCode = '27703' or zipCode = '27703' or zipCode = '27704' or zipCode = '27706' or zipCode = '27707' or zipCode = '27707' or zipCode = '27708' or zipCode = '27708' or zipCode = '27708' or zipCode = '27709' or zipCode = '27709' or zipCode = '27709' or zipCode = '27710' or zipCode = '27710' or zipCode = '27711' or zipCode = '27711' or zipCode = '27711' or zipCode = '27711' or zipCode = '27711' or zipCode = '27713' or zipCode = '27715' or zipCode = '27717' or zipCode = '27722' or zipCode = '27622' or zipCode = '27623' or zipCode = '27623' or zipCode = '27624' or zipCode = '27625' or zipCode = '27626' or zipCode = '27627' or zipCode = '27628' or zipCode = '27629' or zipCode = '27634' or zipCode = '27634' or zipCode = '27635' or zipCode = '27635' or zipCode = '27636' or zipCode = '27640' or zipCode = '27640' or zipCode = '27650' or zipCode = '27656' or zipCode = '27656' or zipCode = '27658' or zipCode = '27661' or zipCode = '27668' or zipCode = '27668' or zipCode = '27675' or zipCode = '27675' or zipCode = '27501' or zipCode = '27502' or zipCode = '27508' or zipCode = '27511' or zipCode = '27512' or zipCode = '27513' or zipCode = '27514' or zipCode = '27517' or zipCode = '27518' or zipCode = '27519' or zipCode = '27520' or zipCode = '27522' or zipCode = '27523' or zipCode = '27525' or zipCode = '27526' or zipCode = '27529' or zipCode = '27539' or zipCode = '27540' or zipCode = '27545' or zipCode = '27557' or zipCode = '27560' or zipCode = '27561' or zipCode = '27562' or zipCode = '27564' or zipCode = '27571' or zipCode = '27577' or zipCode = '27587' or zipCode = '27588' or zipCode = '27591' or zipCode = '27592' or zipCode = '27593' or zipCode = '27596' or zipCode = '27597' or zipCode = '27601' or zipCode = '27602' or zipCode = '27603' or zipCode = '27604' or zipCode = '27605' or zipCode = '27606' or zipCode = '27607' or zipCode = '27608' or zipCode = '27609' or zipCode = '27610' or zipCode = '27611' or zipCode = '27612' or zipCode = '27613' or zipCode = '27614' or zipCode = '27615' or zipCode = '27616' or zipCode = '27617' or zipCode = '27619' or zipCode = '27620' or zipCode = '27621' or zipCode = '27622' or zipCode = '27623' or zipCode = '27624' or zipCode = '27625' or zipCode = '27626' or zipCode = '27627' or zipCode = '27628' or zipCode = '27629' or zipCode = '27634' or zipCode = '27635' or zipCode = '27636' or zipCode = '27640' or zipCode = '27650' or zipCode = '27656' or zipCode = '27658' or zipCode = '27661' or zipCode = '27668' or zipCode = '27675' or zipCode = '27676' or zipCode = '27690' or zipCode = '27695' or zipCode = '27697' or zipCode = '27698' or zipCode = '27699' or zipCode = '27701' or zipCode = '27702' or zipCode = '27703' or zipCode = '27704' or zipCode = '27705' or zipCode = '27706' or zipCode = '27707' or zipCode = '27708' or zipCode = '27709' or zipCode = '27710' or zipCode = '27711' or zipCode = '27713' or zipCode = '27715' or zipCode = '27717' or zipCode = '27722') 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 ='27501' or zipCode = '27502' or zipCode = '27511' or zipCode = '27512' or zipCode = '27513' or zipCode = '27539' or zipCode = '27540' or zipCode = '27545' or zipCode = '27557' or zipCode = '27591' or zipCode = '27591' or zipCode = '27592' or zipCode = '27592' or zipCode = '27592' or zipCode = '27593' or zipCode = '27593' or zipCode = '27596' or zipCode = '27597' or zipCode = '27601' or zipCode = '27602' or zipCode = '27603' or zipCode = '27603' or zipCode = '27604' or zipCode = '27604' or zipCode = '27604' or zipCode = '27604' or zipCode = '27604' or zipCode = '27605' or zipCode = '27517' or zipCode = '27518' or zipCode = '27519' or zipCode = '27520' or zipCode = '27520' or zipCode = '27520' or zipCode = '27521' or zipCode = '27522' or zipCode = '27522' or zipCode = '27523' or zipCode = '27526' or zipCode = '27526' or zipCode = '27527' or zipCode = '27528' or zipCode = '27529' or zipCode = '27557' or zipCode = '27560' or zipCode = '27562' or zipCode = '27564' or zipCode = '27571' or zipCode = '27576' or zipCode = '27587' or zipCode = '27588' or zipCode = '27605' or zipCode = '27606' or zipCode = '27607' or zipCode = '27607' or zipCode = '27607' or zipCode = '27607' or zipCode = '27608' or zipCode = '27608' or zipCode = '27609' or zipCode = '27609' or zipCode = '27610' or zipCode = '27611' or zipCode = '27612' or zipCode = '27612' or zipCode = '27612' or zipCode = '27613' or zipCode = '27614' or zipCode = '27614' or zipCode = '27615' or zipCode = '27616' or zipCode = '27616' or zipCode = '27617' or zipCode = '27619' or zipCode = '27620' or zipCode = '27621' or zipCode = '27676' or zipCode = '27690' or zipCode = '27690' or zipCode = '27695' or zipCode = '27695' or zipCode = '27697' or zipCode = '27697' or zipCode = '27698' or zipCode = '27698' or zipCode = '27699' or zipCode = '27699' or zipCode = '27701' or zipCode = '27701' or zipCode = '27702' or zipCode = '27703' or zipCode = '27703' or zipCode = '27704' or zipCode = '27706' or zipCode = '27707' or zipCode = '27707' or zipCode = '27708' or zipCode = '27708' or zipCode = '27708' or zipCode = '27709' or zipCode = '27709' or zipCode = '27709' or zipCode = '27710' or zipCode = '27710' or zipCode = '27711' or zipCode = '27711' or zipCode = '27711' or zipCode = '27711' or zipCode = '27711' or zipCode = '27713' or zipCode = '27715' or zipCode = '27717' or zipCode = '27722' or zipCode = '27622' or zipCode = '27623' or zipCode = '27623' or zipCode = '27624' or zipCode = '27625' or zipCode = '27626' or zipCode = '27627' or zipCode = '27628' or zipCode = '27629' or zipCode = '27634' or zipCode = '27634' or zipCode = '27635' or zipCode = '27635' or zipCode = '27636' or zipCode = '27640' or zipCode = '27640' or zipCode = '27650' or zipCode = '27656' or zipCode = '27656' or zipCode = '27658' or zipCode = '27661' or zipCode = '27668' or zipCode = '27668' or zipCode = '27675' or zipCode = '27675' or zipCode = '27501' or zipCode = '27502' or zipCode = '27508' or zipCode = '27511' or zipCode = '27512' or zipCode = '27513' or zipCode = '27514' or zipCode = '27517' or zipCode = '27518' or zipCode = '27519' or zipCode = '27520' or zipCode = '27522' or zipCode = '27523' or zipCode = '27525' or zipCode = '27526' or zipCode = '27529' or zipCode = '27539' or zipCode = '27540' or zipCode = '27545' or zipCode = '27557' or zipCode = '27560' or zipCode = '27561' or zipCode = '27562' or zipCode = '27564' or zipCode = '27571' or zipCode = '27577' or zipCode = '27587' or zipCode = '27588' or zipCode = '27591' or zipCode = '27592' or zipCode = '27593' or zipCode = '27596' or zipCode = '27597' or zipCode = '27601' or zipCode = '27602' or zipCode = '27603' or zipCode = '27604' or zipCode = '27605' or zipCode = '27606' or zipCode = '27607' or zipCode = '27608' or zipCode = '27609' or zipCode = '27610' or zipCode = '27611' or zipCode = '27612' or zipCode = '27613' or zipCode = '27614' or zipCode = '27615' or zipCode = '27616' or zipCode = '27617' or zipCode = '27619' or zipCode = '27620' or zipCode = '27621' or zipCode = '27622' or zipCode = '27623' or zipCode = '27624' or zipCode = '27625' or zipCode = '27626' or zipCode = '27627' or zipCode = '27628' or zipCode = '27629' or zipCode = '27634' or zipCode = '27635' or zipCode = '27636' or zipCode = '27640' or zipCode = '27650' or zipCode = '27656' or zipCode = '27658' or zipCode = '27661' or zipCode = '27668' or zipCode = '27675' or zipCode = '27676' or zipCode = '27690' or zipCode = '27695' or zipCode = '27697' or zipCode = '27698' or zipCode = '27699' or zipCode = '27701' or zipCode = '27702' or zipCode = '27703' or zipCode = '27704' or zipCode = '27705' or zipCode = '27706' or zipCode = '27707' or zipCode = '27708' or zipCode = '27709' or zipCode = '27710' or zipCode = '27711' or zipCode = '27713' or zipCode = '27715' or zipCode = '27717' or zipCode = '27722') 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 ='27501' or zipCode = '27502' or zipCode = '27511' or zipCode = '27512' or zipCode = '27513' or zipCode = '27539' or zipCode = '27540' or zipCode = '27545' or zipCode = '27557' or zipCode = '27591' or zipCode = '27591' or zipCode = '27592' or zipCode = '27592' or zipCode = '27592' or zipCode = '27593' or zipCode = '27593' or zipCode = '27596' or zipCode = '27597' or zipCode = '27601' or zipCode = '27602' or zipCode = '27603' or zipCode = '27603' or zipCode = '27604' or zipCode = '27604' or zipCode = '27604' or zipCode = '27604' or zipCode = '27604' or zipCode = '27605' or zipCode = '27517' or zipCode = '27518' or zipCode = '27519' or zipCode = '27520' or zipCode = '27520' or zipCode = '27520' or zipCode = '27521' or zipCode = '27522' or zipCode = '27522' or zipCode = '27523' or zipCode = '27526' or zipCode = '27526' or zipCode = '27527' or zipCode = '27528' or zipCode = '27529' or zipCode = '27557' or zipCode = '27560' or zipCode = '27562' or zipCode = '27564' or zipCode = '27571' or zipCode = '27576' or zipCode = '27587' or zipCode = '27588' or zipCode = '27605' or zipCode = '27606' or zipCode = '27607' or zipCode = '27607' or zipCode = '27607' or zipCode = '27607' or zipCode = '27608' or zipCode = '27608' or zipCode = '27609' or zipCode = '27609' or zipCode = '27610' or zipCode = '27611' or zipCode = '27612' or zipCode = '27612' or zipCode = '27612' or zipCode = '27613' or zipCode = '27614' or zipCode = '27614' or zipCode = '27615' or zipCode = '27616' or zipCode = '27616' or zipCode = '27617' or zipCode = '27619' or zipCode = '27620' or zipCode = '27621' or zipCode = '27676' or zipCode = '27690' or zipCode = '27690' or zipCode = '27695' or zipCode = '27695' or zipCode = '27697' or zipCode = '27697' or zipCode = '27698' or zipCode = '27698' or zipCode = '27699' or zipCode = '27699' or zipCode = '27701' or zipCode = '27701' or zipCode = '27702' or zipCode = '27703' or zipCode = '27703' or zipCode = '27704' or zipCode = '27706' or zipCode = '27707' or zipCode = '27707' or zipCode = '27708' or zipCode = '27708' or zipCode = '27708' or zipCode = '27709' or zipCode = '27709' or zipCode = '27709' or zipCode = '27710' or zipCode = '27710' or zipCode = '27711' or zipCode = '27711' or zipCode = '27711' or zipCode = '27711' or zipCode = '27711' or zipCode = '27713' or zipCode = '27715' or zipCode = '27717' or zipCode = '27722' or zipCode = '27622' or zipCode = '27623' or zipCode = '27623' or zipCode = '27624' or zipCode = '27625' or zipCode = '27626' or zipCode = '27627' or zipCode = '27628' or zipCode = '27629' or zipCode = '27634' or zipCode = '27634' or zipCode = '27635' or zipCode = '27635' or zipCode = '27636' or zipCode = '27640' or zipCode = '27640' or zipCode = '27650' or zipCode = '27656' or zipCode = '27656' or zipCode = '27658' or zipCode = '27661' or zipCode = '27668' or zipCode = '27668' or zipCode = '27675' or zipCode = '27675' or zipCode = '27501' or zipCode = '27502' or zipCode = '27508' or zipCode = '27511' or zipCode = '27512' or zipCode = '27513' or zipCode = '27514' or zipCode = '27517' or zipCode = '27518' or zipCode = '27519' or zipCode = '27520' or zipCode = '27522' or zipCode = '27523' or zipCode = '27525' or zipCode = '27526' or zipCode = '27529' or zipCode = '27539' or zipCode = '27540' or zipCode = '27545' or zipCode = '27557' or zipCode = '27560' or zipCode = '27561' or zipCode = '27562' or zipCode = '27564' or zipCode = '27571' or zipCode = '27577' or zipCode = '27587' or zipCode = '27588' or zipCode = '27591' or zipCode = '27592' or zipCode = '27593' or zipCode = '27596' or zipCode = '27597' or zipCode = '27601' or zipCode = '27602' or zipCode = '27603' or zipCode = '27604' or zipCode = '27605' or zipCode = '27606' or zipCode = '27607' or zipCode = '27608' or zipCode = '27609' or zipCode = '27610' or zipCode = '27611' or zipCode = '27612' or zipCode = '27613' or zipCode = '27614' or zipCode = '27615' or zipCode = '27616' or zipCode = '27617' or zipCode = '27619' or zipCode = '27620' or zipCode = '27621' or zipCode = '27622' or zipCode = '27623' or zipCode = '27624' or zipCode = '27625' or zipCode = '27626' or zipCode = '27627' or zipCode = '27628' or zipCode = '27629' or zipCode = '27634' or zipCode = '27635' or zipCode = '27636' or zipCode = '27640' or zipCode = '27650' or zipCode = '27656' or zipCode = '27658' or zipCode = '27661' or zipCode = '27668' or zipCode = '27675' or zipCode = '27676' or zipCode = '27690' or zipCode = '27695' or zipCode = '27697' or zipCode = '27698' or zipCode = '27699' or zipCode = '27701' or zipCode = '27702' or zipCode = '27703' or zipCode = '27704' or zipCode = '27705' or zipCode = '27706' or zipCode = '27707' or zipCode = '27708' or zipCode = '27709' or zipCode = '27710' or zipCode = '27711' or zipCode = '27713' or zipCode = '27715' or zipCode = '27717' or zipCode = '27722') 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 ='27501' or zipCode = '27502' or zipCode = '27511' or zipCode = '27512' or zipCode = '27513' or zipCode = '27539' or zipCode = '27540' or zipCode = '27545' or zipCode = '27557' or zipCode = '27591' or zipCode = '27591' or zipCode = '27592' or zipCode = '27592' or zipCode = '27592' or zipCode = '27593' or zipCode = '27593' or zipCode = '27596' or zipCode = '27597' or zipCode = '27601' or zipCode = '27602' or zipCode = '27603' or zipCode = '27603' or zipCode = '27604' or zipCode = '27604' or zipCode = '27604' or zipCode = '27604' or zipCode = '27604' or zipCode = '27605' or zipCode = '27517' or zipCode = '27518' or zipCode = '27519' or zipCode = '27520' or zipCode = '27520' or zipCode = '27520' or zipCode = '27521' or zipCode = '27522' or zipCode = '27522' or zipCode = '27523' or zipCode = '27526' or zipCode = '27526' or zipCode = '27527' or zipCode = '27528' or zipCode = '27529' or zipCode = '27557' or zipCode = '27560' or zipCode = '27562' or zipCode = '27564' or zipCode = '27571' or zipCode = '27576' or zipCode = '27587' or zipCode = '27588' or zipCode = '27605' or zipCode = '27606' or zipCode = '27607' or zipCode = '27607' or zipCode = '27607' or zipCode = '27607' or zipCode = '27608' or zipCode = '27608' or zipCode = '27609' or zipCode = '27609' or zipCode = '27610' or zipCode = '27611' or zipCode = '27612' or zipCode = '27612' or zipCode = '27612' or zipCode = '27613' or zipCode = '27614' or zipCode = '27614' or zipCode = '27615' or zipCode = '27616' or zipCode = '27616' or zipCode = '27617' or zipCode = '27619' or zipCode = '27620' or zipCode = '27621' or zipCode = '27676' or zipCode = '27690' or zipCode = '27690' or zipCode = '27695' or zipCode = '27695' or zipCode = '27697' or zipCode = '27697' or zipCode = '27698' or zipCode = '27698' or zipCode = '27699' or zipCode = '27699' or zipCode = '27701' or zipCode = '27701' or zipCode = '27702' or zipCode = '27703' or zipCode = '27703' or zipCode = '27704' or zipCode = '27706' or zipCode = '27707' or zipCode = '27707' or zipCode = '27708' or zipCode = '27708' or zipCode = '27708' or zipCode = '27709' or zipCode = '27709' or zipCode = '27709' or zipCode = '27710' or zipCode = '27710' or zipCode = '27711' or zipCode = '27711' or zipCode = '27711' or zipCode = '27711' or zipCode = '27711' or zipCode = '27713' or zipCode = '27715' or zipCode = '27717' or zipCode = '27722' or zipCode = '27622' or zipCode = '27623' or zipCode = '27623' or zipCode = '27624' or zipCode = '27625' or zipCode = '27626' or zipCode = '27627' or zipCode = '27628' or zipCode = '27629' or zipCode = '27634' or zipCode = '27634' or zipCode = '27635' or zipCode = '27635' or zipCode = '27636' or zipCode = '27640' or zipCode = '27640' or zipCode = '27650' or zipCode = '27656' or zipCode = '27656' or zipCode = '27658' or zipCode = '27661' or zipCode = '27668' or zipCode = '27668' or zipCode = '27675' or zipCode = '27675' or zipCode = '27501' or zipCode = '27502' or zipCode = '27508' or zipCode = '27511' or zipCode = '27512' or zipCode = '27513' or zipCode = '27514' or zipCode = '27517' or zipCode = '27518' or zipCode = '27519' or zipCode = '27520' or zipCode = '27522' or zipCode = '27523' or zipCode = '27525' or zipCode = '27526' or zipCode = '27529' or zipCode = '27539' or zipCode = '27540' or zipCode = '27545' or zipCode = '27557' or zipCode = '27560' or zipCode = '27561' or zipCode = '27562' or zipCode = '27564' or zipCode = '27571' or zipCode = '27577' or zipCode = '27587' or zipCode = '27588' or zipCode = '27591' or zipCode = '27592' or zipCode = '27593' or zipCode = '27596' or zipCode = '27597' or zipCode = '27601' or zipCode = '27602' or zipCode = '27603' or zipCode = '27604' or zipCode = '27605' or zipCode = '27606' or zipCode = '27607' or zipCode = '27608' or zipCode = '27609' or zipCode = '27610' or zipCode = '27611' or zipCode = '27612' or zipCode = '27613' or zipCode = '27614' or zipCode = '27615' or zipCode = '27616' or zipCode = '27617' or zipCode = '27619' or zipCode = '27620' or zipCode = '27621' or zipCode = '27622' or zipCode = '27623' or zipCode = '27624' or zipCode = '27625' or zipCode = '27626' or zipCode = '27627' or zipCode = '27628' or zipCode = '27629' or zipCode = '27634' or zipCode = '27635' or zipCode = '27636' or zipCode = '27640' or zipCode = '27650' or zipCode = '27656' or zipCode = '27658' or zipCode = '27661' or zipCode = '27668' or zipCode = '27675' or zipCode = '27676' or zipCode = '27690' or zipCode = '27695' or zipCode = '27697' or zipCode = '27698' or zipCode = '27699' or zipCode = '27701' or zipCode = '27702' or zipCode = '27703' or zipCode = '27704' or zipCode = '27705' or zipCode = '27706' or zipCode = '27707' or zipCode = '27708' or zipCode = '27709' or zipCode = '27710' or zipCode = '27711' or zipCode = '27713' or zipCode = '27715' or zipCode = '27717' or zipCode = '27722') 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 ='27501' or zipCode = '27502' or zipCode = '27511' or zipCode = '27512' or zipCode = '27513' or zipCode = '27539' or zipCode = '27540' or zipCode = '27545' or zipCode = '27557' or zipCode = '27591' or zipCode = '27591' or zipCode = '27592' or zipCode = '27592' or zipCode = '27592' or zipCode = '27593' or zipCode = '27593' or zipCode = '27596' or zipCode = '27597' or zipCode = '27601' or zipCode = '27602' or zipCode = '27603' or zipCode = '27603' or zipCode = '27604' or zipCode = '27604' or zipCode = '27604' or zipCode = '27604' or zipCode = '27604' or zipCode = '27605' or zipCode = '27517' or zipCode = '27518' or zipCode = '27519' or zipCode = '27520' or zipCode = '27520' or zipCode = '27520' or zipCode = '27521' or zipCode = '27522' or zipCode = '27522' or zipCode = '27523' or zipCode = '27526' or zipCode = '27526' or zipCode = '27527' or zipCode = '27528' or zipCode = '27529' or zipCode = '27557' or zipCode = '27560' or zipCode = '27562' or zipCode = '27564' or zipCode = '27571' or zipCode = '27576' or zipCode = '27587' or zipCode = '27588' or zipCode = '27605' or zipCode = '27606' or zipCode = '27607' or zipCode = '27607' or zipCode = '27607' or zipCode = '27607' or zipCode = '27608' or zipCode = '27608' or zipCode = '27609' or zipCode = '27609' or zipCode = '27610' or zipCode = '27611' or zipCode = '27612' or zipCode = '27612' or zipCode = '27612' or zipCode = '27613' or zipCode = '27614' or zipCode = '27614' or zipCode = '27615' or zipCode = '27616' or zipCode = '27616' or zipCode = '27617' or zipCode = '27619' or zipCode = '27620' or zipCode = '27621' or zipCode = '27676' or zipCode = '27690' or zipCode = '27690' or zipCode = '27695' or zipCode = '27695' or zipCode = '27697' or zipCode = '27697' or zipCode = '27698' or zipCode = '27698' or zipCode = '27699' or zipCode = '27699' or zipCode = '27701' or zipCode = '27701' or zipCode = '27702' or zipCode = '27703' or zipCode = '27703' or zipCode = '27704' or zipCode = '27706' or zipCode = '27707' or zipCode = '27707' or zipCode = '27708' or zipCode = '27708' or zipCode = '27708' or zipCode = '27709' or zipCode = '27709' or zipCode = '27709' or zipCode = '27710' or zipCode = '27710' or zipCode = '27711' or zipCode = '27711' or zipCode = '27711' or zipCode = '27711' or zipCode = '27711' or zipCode = '27713' or zipCode = '27715' or zipCode = '27717' or zipCode = '27722' or zipCode = '27622' or zipCode = '27623' or zipCode = '27623' or zipCode = '27624' or zipCode = '27625' or zipCode = '27626' or zipCode = '27627' or zipCode = '27628' or zipCode = '27629' or zipCode = '27634' or zipCode = '27634' or zipCode = '27635' or zipCode = '27635' or zipCode = '27636' or zipCode = '27640' or zipCode = '27640' or zipCode = '27650' or zipCode = '27656' or zipCode = '27656' or zipCode = '27658' or zipCode = '27661' or zipCode = '27668' or zipCode = '27668' or zipCode = '27675' or zipCode = '27675' or zipCode = '27501' or zipCode = '27502' or zipCode = '27508' or zipCode = '27511' or zipCode = '27512' or zipCode = '27513' or zipCode = '27514' or zipCode = '27517' or zipCode = '27518' or zipCode = '27519' or zipCode = '27520' or zipCode = '27522' or zipCode = '27523' or zipCode = '27525' or zipCode = '27526' or zipCode = '27529' or zipCode = '27539' or zipCode = '27540' or zipCode = '27545' or zipCode = '27557' or zipCode = '27560' or zipCode = '27561' or zipCode = '27562' or zipCode = '27564' or zipCode = '27571' or zipCode = '27577' or zipCode = '27587' or zipCode = '27588' or zipCode = '27591' or zipCode = '27592' or zipCode = '27593' or zipCode = '27596' or zipCode = '27597' or zipCode = '27601' or zipCode = '27602' or zipCode = '27603' or zipCode = '27604' or zipCode = '27605' or zipCode = '27606' or zipCode = '27607' or zipCode = '27608' or zipCode = '27609' or zipCode = '27610' or zipCode = '27611' or zipCode = '27612' or zipCode = '27613' or zipCode = '27614' or zipCode = '27615' or zipCode = '27616' or zipCode = '27617' or zipCode = '27619' or zipCode = '27620' or zipCode = '27621' or zipCode = '27622' or zipCode = '27623' or zipCode = '27624' or zipCode = '27625' or zipCode = '27626' or zipCode = '27627' or zipCode = '27628' or zipCode = '27629' or zipCode = '27634' or zipCode = '27635' or zipCode = '27636' or zipCode = '27640' or zipCode = '27650' or zipCode = '27656' or zipCode = '27658' or zipCode = '27661' or zipCode = '27668' or zipCode = '27675' or zipCode = '27676' or zipCode = '27690' or zipCode = '27695' or zipCode = '27697' or zipCode = '27698' or zipCode = '27699' or zipCode = '27701' or zipCode = '27702' or zipCode = '27703' or zipCode = '27704' or zipCode = '27705' or zipCode = '27706' or zipCode = '27707' or zipCode = '27708' or zipCode = '27709' or zipCode = '27710' or zipCode = '27711' or zipCode = '27713' or zipCode = '27715' or zipCode = '27717' or zipCode = '27722') 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 ='27501' or property_zip = '27502' or property_zip = '27511' or property_zip = '27512' or property_zip = '27513' or property_zip = '27539' or property_zip = '27540' or property_zip = '27545' or property_zip = '27557' or property_zip = '27591' or property_zip = '27591' or property_zip = '27592' or property_zip = '27592' or property_zip = '27592' or property_zip = '27593' or property_zip = '27593' or property_zip = '27596' or property_zip = '27597' or property_zip = '27601' or property_zip = '27602' or property_zip = '27603' or property_zip = '27603' or property_zip = '27604' or property_zip = '27604' or property_zip = '27604' or property_zip = '27604' or property_zip = '27604' or property_zip = '27605' or property_zip = '27517' or property_zip = '27518' or property_zip = '27519' or property_zip = '27520' or property_zip = '27520' or property_zip = '27520' or property_zip = '27521' or property_zip = '27522' or property_zip = '27522' or property_zip = '27523' or property_zip = '27526' or property_zip = '27526' or property_zip = '27527' or property_zip = '27528' or property_zip = '27529' or property_zip = '27557' or property_zip = '27560' or property_zip = '27562' or property_zip = '27564' or property_zip = '27571' or property_zip = '27576' or property_zip = '27587' or property_zip = '27588' or property_zip = '27605' or property_zip = '27606' or property_zip = '27607' or property_zip = '27607' or property_zip = '27607' or property_zip = '27607' or property_zip = '27608' or property_zip = '27608' or property_zip = '27609' or property_zip = '27609' or property_zip = '27610' or property_zip = '27611' or property_zip = '27612' or property_zip = '27612' or property_zip = '27612' or property_zip = '27613' or property_zip = '27614' or property_zip = '27614' or property_zip = '27615' or property_zip = '27616' or property_zip = '27616' or property_zip = '27617' or property_zip = '27619' or property_zip = '27620' or property_zip = '27621' or property_zip = '27676' or property_zip = '27690' or property_zip = '27690' or property_zip = '27695' or property_zip = '27695' or property_zip = '27697' or property_zip = '27697' or property_zip = '27698' or property_zip = '27698' or property_zip = '27699' or property_zip = '27699' or property_zip = '27701' or property_zip = '27701' or property_zip = '27702' or property_zip = '27703' or property_zip = '27703' or property_zip = '27704' or property_zip = '27706' or property_zip = '27707' or property_zip = '27707' or property_zip = '27708' or property_zip = '27708' or property_zip = '27708' or property_zip = '27709' or property_zip = '27709' or property_zip = '27709' or property_zip = '27710' or property_zip = '27710' or property_zip = '27711' or property_zip = '27711' or property_zip = '27711' or property_zip = '27711' or property_zip = '27711' or property_zip = '27713' or property_zip = '27715' or property_zip = '27717' or property_zip = '27722' or property_zip = '27622' or property_zip = '27623' or property_zip = '27623' or property_zip = '27624' or property_zip = '27625' or property_zip = '27626' or property_zip = '27627' or property_zip = '27628' or property_zip = '27629' or property_zip = '27634' or property_zip = '27634' or property_zip = '27635' or property_zip = '27635' or property_zip = '27636' or property_zip = '27640' or property_zip = '27640' or property_zip = '27650' or property_zip = '27656' or property_zip = '27656' or property_zip = '27658' or property_zip = '27661' or property_zip = '27668' or property_zip = '27668' or property_zip = '27675' or property_zip = '27675' or property_zip = '27501' or property_zip = '27502' or property_zip = '27508' or property_zip = '27511' or property_zip = '27512' or property_zip = '27513' or property_zip = '27514' or property_zip = '27517' or property_zip = '27518' or property_zip = '27519' or property_zip = '27520' or property_zip = '27522' or property_zip = '27523' or property_zip = '27525' or property_zip = '27526' or property_zip = '27529' or property_zip = '27539' or property_zip = '27540' or property_zip = '27545' or property_zip = '27557' or property_zip = '27560' or property_zip = '27561' or property_zip = '27562' or property_zip = '27564' or property_zip = '27571' or property_zip = '27577' or property_zip = '27587' or property_zip = '27588' or property_zip = '27591' or property_zip = '27592' or property_zip = '27593' or property_zip = '27596' or property_zip = '27597' or property_zip = '27601' or property_zip = '27602' or property_zip = '27603' or property_zip = '27604' or property_zip = '27605' or property_zip = '27606' or property_zip = '27607' or property_zip = '27608' or property_zip = '27609' or property_zip = '27610' or property_zip = '27611' or property_zip = '27612' or property_zip = '27613' or property_zip = '27614' or property_zip = '27615' or property_zip = '27616' or property_zip = '27617' or property_zip = '27619' or property_zip = '27620' or property_zip = '27621' or property_zip = '27622' or property_zip = '27623' or property_zip = '27624' or property_zip = '27625' or property_zip = '27626' or property_zip = '27627' or property_zip = '27628' or property_zip = '27629' or property_zip = '27634' or property_zip = '27635' or property_zip = '27636' or property_zip = '27640' or property_zip = '27650' or property_zip = '27656' or property_zip = '27658' or property_zip = '27661' or property_zip = '27668' or property_zip = '27675' or property_zip = '27676' or property_zip = '27690' or property_zip = '27695' or property_zip = '27697' or property_zip = '27698' or property_zip = '27699' or property_zip = '27701' or property_zip = '27702' or property_zip = '27703' or property_zip = '27704' or property_zip = '27705' or property_zip = '27706' or property_zip = '27707' or property_zip = '27708' or property_zip = '27709' or property_zip = '27710' or property_zip = '27711' or property_zip = '27713' or property_zip = '27715' or property_zip = '27717' or property_zip = '27722') and convert(date,auction_start_date) >= '9/27/2021';
select top 45 * from currentforeclosures.tblAll NOLOCK where state = 'NC '
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 ='27501' or zip = '27502' or zip = '27511' or zip = '27512' or zip = '27513' or zip = '27539' or zip = '27540' or zip = '27545' or zip = '27557' or zip = '27591' or zip = '27591' or zip = '27592' or zip = '27592' or zip = '27592' or zip = '27593' or zip = '27593' or zip = '27596' or zip = '27597' or zip = '27601' or zip = '27602' or zip = '27603' or zip = '27603' or zip = '27604' or zip = '27604' or zip = '27604' or zip = '27604' or zip = '27604' or zip = '27605' or zip = '27517' or zip = '27518' or zip = '27519' or zip = '27520' or zip = '27520' or zip = '27520' or zip = '27521' or zip = '27522' or zip = '27522' or zip = '27523' or zip = '27526' or zip = '27526' or zip = '27527' or zip = '27528' or zip = '27529' or zip = '27557' or zip = '27560' or zip = '27562' or zip = '27564' or zip = '27571' or zip = '27576' or zip = '27587' or zip = '27588' or zip = '27605' or zip = '27606' or zip = '27607' or zip = '27607' or zip = '27607' or zip = '27607' or zip = '27608' or zip = '27608' or zip = '27609' or zip = '27609' or zip = '27610' or zip = '27611' or zip = '27612' or zip = '27612' or zip = '27612' or zip = '27613' or zip = '27614' or zip = '27614' or zip = '27615' or zip = '27616' or zip = '27616' or zip = '27617' or zip = '27619' or zip = '27620' or zip = '27621' or zip = '27676' or zip = '27690' or zip = '27690' or zip = '27695' or zip = '27695' or zip = '27697' or zip = '27697' or zip = '27698' or zip = '27698' or zip = '27699' or zip = '27699' or zip = '27701' or zip = '27701' or zip = '27702' or zip = '27703' or zip = '27703' or zip = '27704' or zip = '27706' or zip = '27707' or zip = '27707' or zip = '27708' or zip = '27708' or zip = '27708' or zip = '27709' or zip = '27709' or zip = '27709' or zip = '27710' or zip = '27710' or zip = '27711' or zip = '27711' or zip = '27711' or zip = '27711' or zip = '27711' or zip = '27713' or zip = '27715' or zip = '27717' or zip = '27722' or zip = '27622' or zip = '27623' or zip = '27623' or zip = '27624' or zip = '27625' or zip = '27626' or zip = '27627' or zip = '27628' or zip = '27629' or zip = '27634' or zip = '27634' or zip = '27635' or zip = '27635' or zip = '27636' or zip = '27640' or zip = '27640' or zip = '27650' or zip = '27656' or zip = '27656' or zip = '27658' or zip = '27661' or zip = '27668' or zip = '27668' or zip = '27675' or zip = '27675' or zip = '27501' or zip = '27502' or zip = '27508' or zip = '27511' or zip = '27512' or zip = '27513' or zip = '27514' or zip = '27517' or zip = '27518' or zip = '27519' or zip = '27520' or zip = '27522' or zip = '27523' or zip = '27525' or zip = '27526' or zip = '27529' or zip = '27539' or zip = '27540' or zip = '27545' or zip = '27557' or zip = '27560' or zip = '27561' or zip = '27562' or zip = '27564' or zip = '27571' or zip = '27577' or zip = '27587' or zip = '27588' or zip = '27591' or zip = '27592' or zip = '27593' or zip = '27596' or zip = '27597' or zip = '27601' or zip = '27602' or zip = '27603' or zip = '27604' or zip = '27605' or zip = '27606' or zip = '27607' or zip = '27608' or zip = '27609' or zip = '27610' or zip = '27611' or zip = '27612' or zip = '27613' or zip = '27614' or zip = '27615' or zip = '27616' or zip = '27617' or zip = '27619' or zip = '27620' or zip = '27621' or zip = '27622' or zip = '27623' or zip = '27624' or zip = '27625' or zip = '27626' or zip = '27627' or zip = '27628' or zip = '27629' or zip = '27634' or zip = '27635' or zip = '27636' or zip = '27640' or zip = '27650' or zip = '27656' or zip = '27658' or zip = '27661' or zip = '27668' or zip = '27675' or zip = '27676' or zip = '27690' or zip = '27695' or zip = '27697' or zip = '27698' or zip = '27699' or zip = '27701' or zip = '27702' or zip = '27703' or zip = '27704' or zip = '27705' or zip = '27706' or zip = '27707' or zip = '27708' or zip = '27709' or zip = '27710' or zip = '27711' or zip = '27713' or zip = '27715' or zip = '27717' or zip = '27722')
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 = 'NC' and city = 'RALEIGH' and state = 'NC ' 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();