GREELEY, KS Investment Properties - Happy Home Investor
 

CREATE A FREE ACCOUNT To View 10 Times as Much Information! Enjoy!



GREELEY Search Properties

What makes HappyInvestor.com unique?

HappyInvestor.com takes the busy work out of sifting through the massive lists of properties for sale by "cherry-picking" the properties for sale with the highest profit potential. No more browsing public property websites for hours comparing asking price to appraised value, researching much a seller has reduced the price by, or manually estimating profit potential with a calculator. Our algorithms scan the current for-sale properties to find the properties with the most potential, saving you hours of time and delivering the best deals right to you!

Min Price

Max Price

City or Zip

State

Miles

Sort Deals By:



   Showing 99 of 999 Results in the "Top Deals" tab. View specific tabs or Refine your search to show fewer or more deals.

Use the Tabs Above to Navigate!

Use the Tabs Above to Navigate
** These Educational Videos are meant to help you along the way. Enjoy! For access to all the videos, UPGRADE to Full Access.



VIDEO



How to Improve your Credit Score by 100 Points



VIDEO



How to "Wholesale" Properties with no cash


You Have Limited Access!
You are Currently Viewing Limited Data and Number of Homes. CREATE A FREE ACCOUNT HERE to View More Homes!


UNLOCK MORE ACCESS FOR FREE!

  CREATE A FREE ACCOUNT --->





Use the Tabs at the Top of This Page to Navigate the different types of properties!
BUYING BELOW-TAX-APPRAISAL HOMES

Call HappyInvestor.com at 1-888-310-0041
to get help doing below-tax-appraisal deals.

HOW TO BUY DESPERATE SELLER HOMES

Call HappyInvestor.com at 1-888-310-0041
to get help doing desperate seller deals.

HOW TO BUY PRE-FORECLOSURES!

Call HappyInvestor.com at 1-888-310-0041
to get help buying preforeclosures.

Quick Property Flip Video

Call HappyInvestor.com at 1-888-310-0041
to get help doing these types of deals

SUPER-CHARGE YOUR CREDIT SCORE!

Call HappyInvestor.com at 1-888-310-0041
to get help doing below-tax-appraisal deals.

Recent Change in Price or Listing List Date Last Scanned / Date Posted Price Change Address Zip Year Built Original List DateTypePriceOriginal PriceRealtor AppraisalTax Value**Smart Appraisal (5% more than tax-value) Estimated After Repairs ValueEstimated repairsClosing FeesOffer PriceEstimated ProfitProperty Details
  Use the Black tabs above to navigate the properties! You are currently viewing the Popular "Top-Deals!" Section!

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!

Investor-Deal!
Fort Scott KS
 
 
Overall Profit Summary
Purchase Price: $10,530
Estimated Repairs$24,357
Sales Price After Remodel$60,714
Total Profit Estimate$10,309
View Details

Asking $12,000
 *  Listed 13 Days Ago
 *  Originally Listed on 5/16/2020.
 *  Deal Rating of 7.6/10

 $8,700 Below Appraisal
 Fix & Flip!
Great Deal-Score of 7.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 7.5! 
Priced Under Tax-Value!
Kansas City MO
 
 
Overall Profit Summary
Purchase Price: $12,513
Estimated Repairs$20,745
Sales Price After Remodel$49,666
Total Profit Estimate$13,181
View Details

Asking $15,000
 *  New! Listed 2 Day(s) Ago
 *  Originally Listed on 5/27/2020.
 *  High Deal Rating of 9.1/10

 Fix & Flip!
Great Deal-Score of 11.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Very High Deal Score of 11.5! 
Motivated Seller
Pittsburg KS
 
 
Overall Profit Summary
Purchase Price: $12,408
Estimated Repairs$13,321
Sales Price After Remodel$38,254
Total Profit Estimate$10,116
View Details

Asking $15,750
 *  Listed 85 Days Ago
 *  Originally Listed on 3/5/2020.
 *  Deal Rating of 6.9/10

 $3,250 Below Appraisal
Great Deal-Score of 5.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5.5! 
Use the Tabs at the Top of This Page to Navigate the different types of properties!
Great Profit Potential
Kansas City MO
 
 
Overall Profit Summary
Purchase Price: $14,181
Estimated Repairs$18,697
Sales Price After Remodel$48,383
Total Profit Estimate$12,405
View Details

Asking $17,000
 *  New! Listed 7 Day(s) Ago
 *  Originally Listed on 5/22/2020.
 *  Deal Rating of 7.3/10

Great Deal-Score of 6.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 6.5! 
Great Profit Potential
Kansas City MO
 
 
Overall Profit Summary
Purchase Price: $14,634
Estimated Repairs$25,556
Sales Price After Remodel$69,013
Total Profit Estimate$12,249
View Details

Asking $17,900
 *  Listed 57 Days Ago
 *  Originally Listed on 4/2/2020.
 *  Deal Rating of 6.9/10

Great Deal-Score of 5.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5.5! 

You Have Limited Access!
You are Currently Viewing Limited Data and Number of Homes. CREATE A FREE ACCOUNT HERE to View More Homes!


UNLOCK MORE ACCESS FOR FREE!

  CREATE A FREE ACCOUNT --->





Motivated Seller
Topeka KS
 
 
Overall Profit Summary
Purchase Price: $14,754
Estimated Repairs$13,489
Sales Price After Remodel$41,858
Total Profit Estimate$11,011
View Details

Asking $18,950
 *  Listed 134 Days Ago
 *  Originally Listed on 1/16/2020.
 *  Deal Rating of 7.6/10

 $2,950 Below Appraisal
Great Deal-Score of 7.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 7.5! 
Great Profit Potential
Americus KS
 
 
Overall Profit Summary
Purchase Price: $15,276
Estimated Repairs$25,139
Sales Price After Remodel$70,177
Total Profit Estimate$13,334
View Details

Asking $19,900
 *  Price Reduced by $10,000 on 2/28/2020.
 *  Originally Listed on 2/27/2020.
 *  Deal Rating of 6.9/10

 Reduced By $10,000
Great Deal-Score of 5.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5.5! 
Investor-Deal!
Topeka KS
 
 
Overall Profit Summary
Purchase Price: $15,222
Estimated Repairs$9,172
Sales Price After Remodel$38,420
Total Profit Estimate$11,749
View Details

Asking $19,950
 *  432 Days on Market
 *  Originally Listed on 3/24/2019.
 *  Deal Rating of 7.6/10

 Sold As-Is!
Great Deal-Score of 7.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 7.5! 
Priced Under Tax-Value!
Kansas City MO
 
 
Overall Profit Summary
Purchase Price: $15,757
Estimated Repairs$14,554
Sales Price After Remodel$44,699
Total Profit Estimate$11,603
View Details

Asking $20,000
 *  Listed 92 Days Ago
 *  Originally Listed on 2/27/2020.
 *  Great Deal Rating of 8.4/10

 Motivated Seller!
Great Deal-Score of 9.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 High Deal Score of 9.5! 
Motivated Seller
Kansas City MO
 
 
Overall Profit Summary
Purchase Price: $16,350
Estimated Repairs$10,960
Sales Price After Remodel$41,818
Total Profit Estimate$11,997
View Details

Asking $20,000
 *  Listed 13 Days Ago
 *  Originally Listed on 5/16/2020.
 *  Great Deal Rating of 8.4/10

 Rehab-Fixer!
Great Deal-Score of 9.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 High Deal Score of 9.5! 
Use the Tabs at the Top of This Page to Navigate the different types of properties!
Investor-Deal!
Kansas City MO
 
 
Overall Profit Summary
Purchase Price: $15,717
Estimated Repairs$11,031
Sales Price After Remodel$39,954
Total Profit Estimate$10,774
View Details

Asking $21,000
 *  Price Reduced by $4,000 on 3/13/2020.
 *  Originally Listed on 3/13/2020.
 *  Deal Rating of 7.6/10

 Reduced By $4,000
 Flip - Needs Repairs!
Great Deal-Score of 7.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 7.5! 
Investor-Deal!
Kansas City MO
 
 
Overall Profit Summary
Purchase Price: $18,446
Estimated Repairs$9,779
Sales Price After Remodel$41,741
Total Profit Estimate$11,047
View Details

Asking $22,000
 *  Listed 10 Days Ago
 *  Originally Listed on 5/19/2020.
 *  Deal Rating of 7.8/10

 $7,600 Below Appraisal
Great Deal-Score of 8!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 8! 
Priced Under Tax-Value!
Topeka KS
 
 
Overall Profit Summary
Purchase Price: $18,120
Estimated Repairs$13,151
Sales Price After Remodel$45,515
Total Profit Estimate$11,456
View Details

Asking $23,000
 *  Listed 70 Days Ago
 *  Originally Listed on 3/20/2020.
 *  Great Deal Rating of 8.4/10

 Flip - Needs Repairs!
Great Deal-Score of 9.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 High Deal Score of 9.5! 
Priced Under Tax-Value!
Topeka KS
 
 
Overall Profit Summary
Purchase Price: $18,989
Estimated Repairs$26,500
Sales Price After Remodel$76,499
Total Profit Estimate$13,554
View Details

Asking $23,500
 *  Listed 65 Days Ago
 *  Originally Listed on 3/25/2020.
 *  Deal Rating of 7.3/10

Great Deal-Score of 6.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 6.5! 
Great Profit Potential
Topeka KS
 
 
Overall Profit Summary
Purchase Price: $19,999
Estimated Repairs$27,322
Sales Price After Remodel$79,393
Total Profit Estimate$14,045
View Details

Asking $24,750
 *  Listed 98 Days Ago
 *  Originally Listed on 2/21/2020.
 *  Deal Rating of 7.6/10

 $9,150 Below Appraisal
Great Deal-Score of 7.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 7.5! 

You Have Limited Access!
You are Currently Viewing Limited Data and Number of Homes. CREATE A FREE ACCOUNT HERE to View More Homes!


UNLOCK MORE ACCESS FOR FREE!

  CREATE A FREE ACCOUNT --->





Fix & Flip Investor-Deal
Kansas City MO
 
 
Overall Profit Summary
Purchase Price: $20,437
Estimated Repairs$9,744
Sales Price After Remodel$44,872
Total Profit Estimate$12,063
View Details

Asking $25,000
 *  New! Listed 3 Day(s) Ago
 *  Originally Listed on 5/26/2020.
 *  Deal Rating of 7.6/10

Great Deal-Score of 7.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 7.5! 
Motivated Seller
Kansas City MO
 
 
Overall Profit Summary
Purchase Price: $20,854
Estimated Repairs$15,497
Sales Price After Remodel$51,447
Total Profit Estimate$11,927
View Details

Asking $25,000
 *  New! Listed 4 Day(s) Ago
 *  Originally Listed on 5/25/2020.
 *  Great Deal Rating of 8.7/10

 Rehab-Fixer!
Great Deal-Score of 10.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Very High Deal Score of 10.5! 
Motivated Seller
Parsons KS
 
 
Overall Profit Summary
Purchase Price: $21,605
Estimated Repairs$16,751
Sales Price After Remodel$54,443
Total Profit Estimate$12,723
View Details

Asking $25,900
 *  Listed 11 Days Ago
 *  Originally Listed on 5/18/2020.
 *  Deal Rating of 7.3/10

Great Deal-Score of 6.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 6.5! 
Motivated Seller
Kansas City KS
 
 
Overall Profit Summary
Purchase Price: $21,503
Estimated Repairs$29,491
Sales Price After Remodel$84,982
Total Profit Estimate$14,568
View Details

Asking $26,000
 *  Listed 35 Days Ago
 *  Originally Listed on 4/24/2020.
 *  Great Deal Rating of 8.4/10

 Sold As-Is!
Great Deal-Score of 9.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 High Deal Score of 9.5! 
Make Offer. High Profit.
Kansas City KS
 
 
Overall Profit Summary
Purchase Price: $21,917
Estimated Repairs$36,916
Sales Price After Remodel$100,331
Total Profit Estimate$17,523
View Details

Asking $26,500
 *  Listed 21 Days Ago
 *  Originally Listed on 5/8/2020.
 *  Great Deal Rating of 8.4/10

 Fix & Flip!
Great Deal-Score of 9.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 High Deal Score of 9.5! 
Use the Tabs at the Top of This Page to Navigate the different types of properties!
Great Profit Potential
Kansas City MO
 
 
Overall Profit Summary
Purchase Price: $22,523
Estimated Repairs$14,226
Sales Price After Remodel$51,441
Total Profit Estimate$11,560
View Details

Asking $27,000
 *  Listed 16 Days Ago
 *  Originally Listed on 5/13/2020.
 *  Great Deal Rating of 8.4/10

 Foreclosure!
Great Deal-Score of 9.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 High Deal Score of 9.5! 
Great Profit Potential
Kansas City MO
 
 
Overall Profit Summary
Purchase Price: $21,877
Estimated Repairs$16,312
Sales Price After Remodel$61,125
Total Profit Estimate$11,417
View Details

Asking $28,500
 *  Price Reduced by $6,500 on 3/13/2020.
 *  Originally Listed on 3/13/2020.
 *  Deal Rating of 7.6/10

 $5,500 Below Appraisal
 Reduced By $6,500
Great Deal-Score of 7.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 7.5! 
Great Profit Potential
Kansas City MO
 
 
Overall Profit Summary
Purchase Price: $25,239
Estimated Repairs$21,945
Sales Price After Remodel$73,390
Total Profit Estimate$11,197
View Details

Asking $29,500
 *  New! Listed 1 Day(s) Ago
 *  Originally Listed on 5/28/2020.
 *  Great Deal Rating of 8.4/10

 Fix & Flip!
Great Deal-Score of 9.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 High Deal Score of 9.5! 
Investor-Deal!
Independence MO
 
 
Overall Profit Summary
Purchase Price: $24,729
Estimated Repairs$17,444
Sales Price After Remodel$64,789
Total Profit Estimate$10,330
View Details

Asking $29,900
 *  Listed 22 Days Ago
 *  Originally Listed on 5/7/2020.
 *  Deal Rating of 6.9/10

Great Deal-Score of 5.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5.5! 
Great Profit Potential
Madison KS
 
 
Overall Profit Summary
Purchase Price: $25,581
Estimated Repairs$19,735
Sales Price After Remodel$69,370
Total Profit Estimate$10,371
View Details

Asking $29,900
 *  Listed 11 Days Ago
 *  Originally Listed on 5/18/2020.
 *  Deal Rating of 6.9/10

 $13,000 Below Appraisal
Great Deal-Score of 5.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5.5! 
Great Profit Potential
Topeka KS
 
 
Overall Profit Summary
Purchase Price: $24,110
Estimated Repairs$15,414
Sales Price After Remodel$56,408
Total Profit Estimate$13,454
View Details

Asking $29,900
 *  Listed 21 Days Ago
 *  Originally Listed on 5/8/2020.
 *  Deal Rating of 6.9/10

Great Deal-Score of 5.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5.5! 
Great Profit Potential
Girard KS
 
 
Overall Profit Summary
Purchase Price: $24,160
Estimated Repairs$19,196
Sales Price After Remodel$68,292
Total Profit Estimate$11,582
View Details

Asking $29,900
 *  Listed 79 Days Ago
 *  Originally Listed on 3/11/2020.
 *  Deal Rating of 7.6/10

 $14,200 Below Appraisal
 Sold As-Is!
Great Deal-Score of 7.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 7.5! 

You Have Limited Access!
You are Currently Viewing Limited Data and Number of Homes. CREATE A FREE ACCOUNT HERE to View More Homes!


UNLOCK MORE ACCESS FOR FREE!

  CREATE A FREE ACCOUNT --->





Fix & Flip Investor-Deal
Emporia KS
 
 
Overall Profit Summary
Purchase Price: $24,160
Estimated Repairs$15,625
Sales Price After Remodel$61,150
Total Profit Estimate$10,189
View Details

Asking $29,900
 *  Listed 77 Days Ago
 *  Originally Listed on 3/13/2020.
 *  Deal Rating of 6.9/10

 $18,700 Below Appraisal
Great Deal-Score of 5.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5.5! 
Motivated Seller
Leavenworth KS
 
 
Overall Profit Summary
Purchase Price: $23,876
Estimated Repairs$15,208
Sales Price After Remodel$60,315
Total Profit Estimate$10,311
View Details

Asking $29,900
 *  Listed 101 Days Ago
 *  Originally Listed on 2/18/2020.
 *  Deal Rating of 7.6/10

 $15,300 Below Appraisal
 Fix & Flip!
Great Deal-Score of 7.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 7.5! 
Great Profit Potential
Topeka KS
 
 
Overall Profit Summary
Purchase Price: $24,770
Estimated Repairs$18,994
Sales Price After Remodel$67,938
Total Profit Estimate$10,940
View Details

Asking $29,950
 *  Listed 21 Days Ago
 *  Originally Listed on 5/8/2020.
 *  Deal Rating of 6.9/10

Great Deal-Score of 5.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5.5! 
Motivated Seller
Kansas City MO
 
 
Overall Profit Summary
Purchase Price: $24,983
Estimated Repairs$16,162
Sales Price After Remodel$57,689
Total Profit Estimate$13,024
View Details

Asking $29,950
 *  Listed 15 Days Ago
 *  Originally Listed on 5/14/2020.
 *  Deal Rating of 7.3/10

 Investor-Special!!
Great Deal-Score of 6.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 6.5! 
Great Profit Potential
Kansas City MO
 
 
Overall Profit Summary
Purchase Price: $24,191
Estimated Repairs$12,178
Sales Price After Remodel$51,198
Total Profit Estimate$11,768
View Details

Asking $30,000
 *  Listed 23 Days Ago
 *  Originally Listed on 5/6/2020.
 *  Deal Rating of 6.9/10

 $5,600 Below Appraisal
Great Deal-Score of 5.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5.5! 
Motivated Seller
Girard KS
 
 
Overall Profit Summary
Purchase Price: $24,710
Estimated Repairs$11,353
Sales Price After Remodel$50,883
Total Profit Estimate$11,800
View Details

Asking $31,000
 *  Listed 43 Days Ago
 *  Originally Listed on 4/16/2020.
 *  Deal Rating of 6.7/10

Great Deal-Score of 5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5! 
Priced Under Tax-Value!
Kansas City MO
 
 
Overall Profit Summary
Purchase Price: $27,378
Estimated Repairs$26,527
Sales Price After Remodel$85,053
Total Profit Estimate$13,207
View Details

Asking $32,000
 *  New! Listed 8 Day(s) Ago
 *  Originally Listed on 5/21/2020.
 *  Deal Rating of 7.6/10

Great Deal-Score of 7.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 7.5! 
Great Profit Potential
Kansas City MO
 
 
Overall Profit Summary
Purchase Price: $24,275
Estimated Repairs$14,884
Sales Price After Remodel$61,768
Total Profit Estimate$11,770
View Details

Asking $32,000
 *  Price Reduced by $13,000 on 2/12/2020.
 *  Originally Listed on 2/12/2020.
 *  Deal Rating of 7.6/10

 $11,700 Below Appraisal
 Reduced By $13,000
 Sold As-Is!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 7.5! 
Great Profit Potential
Topeka KS
 
 
Overall Profit Summary
Purchase Price: $25,553
Estimated Repairs$15,922
Sales Price After Remodel$63,843
Total Profit Estimate$10,897
View Details

Asking $32,000
 *  Listed 113 Days Ago
 *  Originally Listed on 2/6/2020.
 *  Deal Rating of 7.6/10

 $12,800 Below Appraisal
 Fix & Flip!
Great Deal-Score of 7.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 7.5! 
Priced Under Tax-Value!
Parsons KS
 
 
Overall Profit Summary
Purchase Price: $24,948
Estimated Repairs$24,936
Sales Price After Remodel$82,373
Total Profit Estimate$15,490
View Details

Asking $32,500
 *  Price Reduced by $7,450 on 5/31/2019.
 *  Originally Listed on 5/8/2017.
 *  Deal Rating of 6.9/10

 Reduced By $7,450
Great Deal-Score of 5.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5.5! 
Priced Under Tax-Value!
Kansas City MO
 
 
Overall Profit Summary
Purchase Price: $26,938
Estimated Repairs$31,647
Sales Price After Remodel$96,244
Total Profit Estimate$16,542
View Details

Asking $32,950
 *  Listed 51 Days Ago
 *  Originally Listed on 4/8/2020.
 *  Deal Rating of 7.3/10

Great Deal-Score of 6.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 6.5! 
Great Profit Potential
Kansas City MO
 
 
Overall Profit Summary
Purchase Price: $27,528
Estimated Repairs$16,611
Sales Price After Remodel$61,596
Total Profit Estimate$13,720
View Details

Asking $33,000
 *  New! Listed 9 Day(s) Ago
 *  Originally Listed on 5/20/2020.
 *  Deal Rating of 8/10

Great Deal-Score of 8.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Great Deal Score of 8.5! 

You Have Limited Access!
You are Currently Viewing Limited Data and Number of Homes. CREATE A FREE ACCOUNT HERE to View More Homes!


UNLOCK MORE ACCESS FOR FREE!

  CREATE A FREE ACCOUNT --->





Fix & Flip Investor-Deal
Parsons KS
 
 
Overall Profit Summary
Purchase Price: $25,716
Estimated Repairs$25,395
Sales Price After Remodel$84,689
Total Profit Estimate$16,223
View Details

Asking $33,900
 *  Price Reduced by $6,000 on 11/28/2019.
 *  Originally Listed on 9/5/2019.
 *  Deal Rating of 6.9/10

 $16,300 Below Appraisal
 Reduced By $6,000
Great Deal-Score of 5.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5.5! 
Motivated Seller
Kansas City MO
 
 
Overall Profit Summary
Purchase Price: $28,471
Estimated Repairs$20,688
Sales Price After Remodel$75,802
Total Profit Estimate$12,129
View Details

Asking $34,425
 *  Listed 22 Days Ago
 *  Originally Listed on 5/7/2020.
 *  Deal Rating of 7.3/10

Great Deal-Score of 6.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 6.5! 
Make Offer. High Profit.
Parsons KS
 
 
Overall Profit Summary
Purchase Price: $28,532
Estimated Repairs$29,976
Sales Price After Remodel$94,852
Total Profit Estimate$16,139
View Details

Asking $34,900
 *  Listed 58 Days Ago
 *  Originally Listed on 4/1/2020.
 *  Deal Rating of 7.6/10

 $11,300 Below Appraisal
 Flip - Needs Repairs!
Great Deal-Score of 7.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 7.5! 
Motivated Seller
Emporia KS
 
 
Overall Profit Summary
Purchase Price: $28,947
Estimated Repairs$23,764
Sales Price After Remodel$82,528
Total Profit Estimate$13,396
View Details

Asking $35,000
 *  Listed 30 Days Ago
 *  Originally Listed on 4/29/2020.
 *  Deal Rating of 7.6/10

 $19,100 Below Appraisal
 Sold As-Is!
Great Deal-Score of 7.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 7.5! 
Investor-Deal!
Topeka KS
 
 
Overall Profit Summary
Purchase Price: $27,250
Estimated Repairs$9,802
Sales Price After Remodel$52,496
Total Profit Estimate$12,384
View Details

Asking $35,000
 *  466 Days on Market
 *  Originally Listed on 2/18/2019.
 *  Great Deal Rating of 8.4/10

 Sold As-Is!
Great Deal-Score of 9.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 High Deal Score of 9.5! 
Motivated Seller
Topeka KS
 
 
Overall Profit Summary
Purchase Price: $29,346
Estimated Repairs$6,905
Sales Price After Remodel$50,223
Total Profit Estimate$11,159
View Details

Asking $35,000
 *  New! Listed 7 Day(s) Ago
 *  Originally Listed on 5/22/2020.
 *  Deal Rating of 6.7/10

 $4,000 Below Appraisal
Great Deal-Score of 5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5! 
Make Offer. High Profit.
Kansas City MO
 
 
Overall Profit Summary
Purchase Price: $26,551
Estimated Repairs$15,137
Sales Price After Remodel$65,273
Total Profit Estimate$12,427
View Details

Asking $35,000
 *  Price Reduced by $5,000 on 2/2/2020.
 *  Originally Listed on 1/31/2020.
 *  Deal Rating of 7.6/10

 $3,900 Below Appraisal
 Reduced By $5,000
Great Deal-Score of 7.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 7.5! 
Priced Under Tax-Value!
Kansas City MO
 
 
Overall Profit Summary
Purchase Price: $29,945
Estimated Repairs$36,390
Sales Price After Remodel$107,780
Total Profit Estimate$17,322
View Details

Asking $35,000
 *  New! Listed 2 Day(s) Ago
 *  Originally Listed on 5/27/2020.
 *  Great Deal Rating of 8.4/10

 Investor-Special!!
Great Deal-Score of 9.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 High Deal Score of 9.5! 
Investor-Deal!
Kansas City MO
 
 
Overall Profit Summary
Purchase Price: $29,196
Estimated Repairs$15,906
Sales Price After Remodel$62,520
Total Profit Estimate$13,651
View Details

Asking $35,000
 *  New! Listed 2 Day(s) Ago
 *  Originally Listed on 5/27/2020.
 *  Deal Rating of 8/10

 Investor-Special!!
Great Deal-Score of 8.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Great Deal Score of 8.5! 
Great Profit Potential
Topeka KS
 
 
Overall Profit Summary
Purchase Price: $28,281
Estimated Repairs$18,632
Sales Price After Remodel$72,264
Total Profit Estimate$12,060
View Details

Asking $35,000
 *  Listed 100 Days Ago
 *  Originally Listed on 2/19/2020.
 *  Deal Rating of 6.9/10

 $17,900 Below Appraisal
Great Deal-Score of 5.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5.5! 
Great Profit Potential
Kansas City MO
 
 
Overall Profit Summary
Purchase Price: $29,947
Estimated Repairs$10,867
Sales Price After Remodel$55,181
Total Profit Estimate$11,134
View Details

Asking $35,900
 *  Listed 14 Days Ago
 *  Originally Listed on 5/15/2020.
 *  Deal Rating of 7.6/10

 $7,300 Below Appraisal
 Fix & Flip!
Great Deal-Score of 7.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 7.5! 
Priced Under Tax-Value!
Kansas City MO
 
 
Overall Profit Summary
Purchase Price: $30,864
Estimated Repairs$16,214
Sales Price After Remodel$65,105
Total Profit Estimate$14,114
View Details

Asking $37,000
 *  New! Listed 9 Day(s) Ago
 *  Originally Listed on 5/20/2020.
 *  Deal Rating of 8/10

 $6,800 Below Appraisal
 Rehab-Fixer!
Great Deal-Score of 8.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Great Deal Score of 8.5! 
Great Profit Potential
Pittsburg KS
 
 
Overall Profit Summary
Purchase Price: $28,068
Estimated Repairs$22,673
Sales Price After Remodel$82,345
Total Profit Estimate$15,739
View Details

Asking $37,000
 *  Price Reduced by $2,500 on 12/2/2019.
 *  Originally Listed on 8/6/2019.
 *  Deal Rating of 7.3/10

 Reduced By $2,500
Great Deal-Score of 6.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 6.5! 
Great Profit Potential
Kansas City MO
 
 
Overall Profit Summary
Purchase Price: $28,709
Estimated Repairs$29,949
Sales Price After Remodel$97,298
Total Profit Estimate$18,314
View Details

Asking $37,400
 *  Price Reduced by $2,500 on 3/28/2020.
 *  Originally Listed on 3/27/2020.
 *  Deal Rating of 7.3/10

 Reduced By $2,500
Great Deal-Score of 6.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 6.5! 
Priced Under Tax-Value!
Independence MO
 
 
Overall Profit Summary
Purchase Price: $31,014
Estimated Repairs$28,413
Sales Price After Remodel$94,326
Total Profit Estimate$15,504
View Details

Asking $37,500
 *  Listed 28 Days Ago
 *  Originally Listed on 5/1/2020.
 *  Great Deal Rating of 8.4/10

 Fix & Flip!
Great Deal-Score of 9.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 High Deal Score of 9.5! 
Motivated Seller
Topeka KS
 
 
Overall Profit Summary
Purchase Price: $30,301
Estimated Repairs$23,885
Sales Price After Remodel$85,271
Total Profit Estimate$14,452
View Details

Asking $37,500
 *  Listed 73 Days Ago
 *  Originally Listed on 3/17/2020.
 *  Deal Rating of 7.3/10

Great Deal-Score of 6.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 6.5! 
Great Profit Potential
Parsons KS
 
 
Overall Profit Summary
Purchase Price: $31,615
Estimated Repairs$10,973
Sales Price After Remodel$57,434
Total Profit Estimate$11,491
View Details

Asking $37,900
 *  Listed 14 Days Ago
 *  Originally Listed on 5/15/2020.
 *  Deal Rating of 6.9/10

 $25,200 Below Appraisal
Great Deal-Score of 5.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5.5! 
Motivated Seller
Kansas City KS
 
 
Overall Profit Summary
Purchase Price: $30,985
Estimated Repairs$22,996
Sales Price After Remodel$83,892
Total Profit Estimate$13,799
View Details

Asking $37,900
 *  Listed 52 Days Ago
 *  Originally Listed on 4/7/2020.
 *  Deal Rating of 6.9/10

Great Deal-Score of 5.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5.5! 
Motivated Seller
Topeka KS
 
 
Overall Profit Summary
Purchase Price: $31,699
Estimated Repairs$11,768
Sales Price After Remodel$58,845
Total Profit Estimate$11,925
View Details

Asking $38,000
 *  New! Listed 8 Day(s) Ago
 *  Originally Listed on 5/21/2020.
 *  Deal Rating of 7.3/10

 $6,000 Below Appraisal
Great Deal-Score of 6.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 6.5! 
Great Profit Potential
Topeka KS
 
 
Overall Profit Summary
Purchase Price: $30,705
Estimated Repairs$13,854
Sales Price After Remodel$65,708
Total Profit Estimate$10,608
View Details

Asking $38,000
 *  Listed 100 Days Ago
 *  Originally Listed on 2/19/2020.
 *  Deal Rating of 6.9/10

 $9,200 Below Appraisal
Great Deal-Score of 5.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5.5! 
Make Offer. High Profit.
Kansas City MO
 
 
Overall Profit Summary
Purchase Price: $31,109
Estimated Repairs$13,164
Sales Price After Remodel$64,828
Total Profit Estimate$10,407
View Details

Asking $38,500
 *  Listed 85 Days Ago
 *  Originally Listed on 3/5/2020.
 *  Great Deal Rating of 8.4/10

 Fix & Flip!
Great Deal-Score of 9.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 High Deal Score of 9.5! 
Great Profit Potential
Topeka KS
 
 
Overall Profit Summary
Purchase Price: $31,884
Estimated Repairs$15,962
Sales Price After Remodel$70,924
Total Profit Estimate$11,196
View Details

Asking $39,000
 *  Listed 48 Days Ago
 *  Originally Listed on 4/11/2020.
 *  Deal Rating of 6.9/10

 $4,500 Below Appraisal
Great Deal-Score of 5.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5.5! 
Great Profit Potential
Topeka KS
 
 
Overall Profit Summary
Purchase Price: $31,142
Estimated Repairs$13,099
Sales Price After Remodel$65,198
Total Profit Estimate$10,821
View Details

Asking $39,000
 *  Listed 112 Days Ago
 *  Originally Listed on 2/7/2020.
 *  Deal Rating of 6.9/10

 $11,000 Below Appraisal
Great Deal-Score of 5.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5.5! 
Great Profit Potential
Pittsburg KS
 
 
Overall Profit Summary
Purchase Price: $32,240
Estimated Repairs$19,843
Sales Price After Remodel$79,586
Total Profit Estimate$13,204
View Details

Asking $39,900
 *  Listed 85 Days Ago
 *  Originally Listed on 3/5/2020.
 *  Deal Rating of 7.6/10

 $6,100 Below Appraisal
 Motivated Seller!
Great Deal-Score of 7.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 7.5! 
Fix & Flip Investor-Deal
Kansas City MO
 
 
Overall Profit Summary
Purchase Price: $34,137
Estimated Repairs$39,004
Sales Price After Remodel$117,909
Total Profit Estimate$18,780
View Details

Asking $39,900
 *  Listed 18 Days Ago
 *  Originally Listed on 5/11/2020.
 *  Deal Rating of 6.9/10

 $26,800 Below Appraisal
Great Deal-Score of 5.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5.5! 
Great Profit Potential
Topeka KS
 
 
Overall Profit Summary
Purchase Price: $34,180
Estimated Repairs$19,034
Sales Price After Remodel$78,019
Total Profit Estimate$10,996
View Details

Asking $39,950
 *  Listed 10 Days Ago
 *  Originally Listed on 5/19/2020.
 *  Deal Rating of 7.3/10

 $20,050 Below Appraisal
Great Deal-Score of 6.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 6.5! 
Great Profit Potential
Topeka KS
 
 
Overall Profit Summary
Purchase Price: $34,180
Estimated Repairs$17,417
Sales Price After Remodel$74,785
Total Profit Estimate$10,366
View Details

Asking $39,950
 *  New! Listed 9 Day(s) Ago
 *  Originally Listed on 5/20/2020.
 *  Deal Rating of 7.3/10

Great Deal-Score of 6.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 6.5! 
Great Profit Potential
Topeka KS
 
 
Overall Profit Summary
Purchase Price: $33,367
Estimated Repairs$10,973
Sales Price After Remodel$59,618
Total Profit Estimate$11,808
View Details

Asking $40,000
 *  Listed 11 Days Ago
 *  Originally Listed on 5/18/2020.
 *  Deal Rating of 7.3/10

 $2,400 Below Appraisal
Great Deal-Score of 6.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 6.5! 
Fix & Flip Investor-Deal
Topeka KS
 
 
Overall Profit Summary
Purchase Price: $32,321
Estimated Repairs$13,423
Sales Price After Remodel$66,845
Total Profit Estimate$10,714
View Details

Asking $40,000
 *  Listed 66 Days Ago
 *  Originally Listed on 3/24/2020.
 *  Deal Rating of 6.9/10

Great Deal-Score of 5.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5.5! 
Great Profit Potential
Kansas City KS
 
 
Overall Profit Summary
Purchase Price: $30,344
Estimated Repairs$19,412
Sales Price After Remodel$78,823
Total Profit Estimate$15,027
View Details

Asking $40,000
 *  Price Reduced by $5,000 on 8/30/2019.
 *  Originally Listed on 6/12/2019.
 *  Deal Rating of 7.6/10

 $4,100 Below Appraisal
 Reduced By $5,000
Great Deal-Score of 7.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 7.5! 
Great Profit Potential
Kansas City MO
 
 
Overall Profit Summary
Purchase Price: $30,344
Estimated Repairs$21,137
Sales Price After Remodel$82,273
Total Profit Estimate$15,699
View Details

Asking $40,000
 *  Price Reduced by $20,000 on 1/23/2020.
 *  Originally Listed on 1/23/2020.
 *  Deal Rating of 7.6/10

 $18,500 Below Appraisal
 Reduced By $20,000
Great Deal-Score of 7.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 7.5! 

You Have Limited Access!
You are Currently Viewing Limited Data and Number of Homes. CREATE A FREE ACCOUNT HERE to View More Homes!


UNLOCK MORE ACCESS FOR FREE!

  CREATE A FREE ACCOUNT --->





Fix & Flip Investor-Deal
Lane KS
 
 
Overall Profit Summary
Purchase Price: $33,082
Estimated Repairs$26,796
Sales Price After Remodel$93,592
Total Profit Estimate$15,169
View Details

Asking $40,000
 *  Listed 25 Days Ago
 *  Originally Listed on 5/4/2020.
 *  Great Deal Rating of 8.4/10

 Flip - Needs Repairs!
Great Deal-Score of 9.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 High Deal Score of 9.5! 
Make Offer. High Profit.
Pittsburg KS
 
 
Overall Profit Summary
Purchase Price: $35,078
Estimated Repairs$17,094
Sales Price After Remodel$75,188
Total Profit Estimate$10,334
View Details

Asking $41,000
 *  New! Listed 3 Day(s) Ago
 *  Originally Listed on 5/26/2020.
 *  Deal Rating of 7.6/10

Great Deal-Score of 7.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 7.5! 
Great Profit Potential
Topeka KS
 
 
Overall Profit Summary
Purchase Price: $31,785
Estimated Repairs$23,346
Sales Price After Remodel$88,593
Total Profit Estimate$16,915
View Details

Asking $41,900
 *  Price Reduced by $2,100 on 2/14/2020.
 *  Originally Listed on 11/23/2019.
 *  Deal Rating of 7.6/10

 $4,700 Below Appraisal
 Reduced By $2,100
 Motivated Seller!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 7.5! 
Great Profit Potential
Kansas City MO
 
 
Overall Profit Summary
Purchase Price: $33,857
Estimated Repairs$14,889
Sales Price After Remodel$71,677
Total Profit Estimate$11,546
View Details

Asking $41,900
 *  Listed 87 Days Ago
 *  Originally Listed on 3/3/2020.
 *  Deal Rating of 6.9/10

Great Deal-Score of 5.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5.5! 
Great Profit Potential
Kansas City MO
 
 
Overall Profit Summary
Purchase Price: $34,745
Estimated Repairs$22,176
Sales Price After Remodel$86,852
Total Profit Estimate$14,066
View Details

Asking $42,500
 *  Listed 45 Days Ago
 *  Originally Listed on 4/14/2020.
 *  Great Deal Rating of 8.4/10

 Fix & Flip!
Great Deal-Score of 9.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 High Deal Score of 9.5! 
Make Offer. High Profit.
Parsons KS
 
 
Overall Profit Summary
Purchase Price: $33,937
Estimated Repairs$22,376
Sales Price After Remodel$87,252
Total Profit Estimate$14,952
View Details

Asking $42,500
 *  326 Days on Market
 *  Originally Listed on 7/8/2019.
 *  Deal Rating of 7.6/10

 $11,900 Below Appraisal
Great Deal-Score of 7.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 7.5! 
Great Profit Potential
Topeka KS
 
 
Overall Profit Summary
Purchase Price: $35,113
Estimated Repairs$12,021
Sales Price After Remodel$66,992
Total Profit Estimate$10,163
View Details

Asking $42,950
 *  Listed 60 Days Ago
 *  Originally Listed on 3/30/2020.
 *  Great Deal Rating of 8.4/10

 Sold As-Is!
Great Deal-Score of 9.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 High Deal Score of 9.5! 
Great Profit Potential
Pittsburg KS
 
 
Overall Profit Summary
Purchase Price: $36,789
Estimated Repairs$17,849
Sales Price After Remodel$78,697
Total Profit Estimate$10,807
View Details

Asking $43,000
 *  New! Listed 3 Day(s) Ago
 *  Originally Listed on 5/26/2020.
 *  Deal Rating of 7.6/10

Great Deal-Score of 7.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 7.5! 
Great Profit Potential
Topeka KS
 
 
Overall Profit Summary
Purchase Price: $35,890
Estimated Repairs$14,199
Sales Price After Remodel$72,298
Total Profit Estimate$11,133
View Details

Asking $43,900
 *  Listed 43 Days Ago
 *  Originally Listed on 4/16/2020.
 *  Deal Rating of 6.9/10

 $11,700 Below Appraisal
Great Deal-Score of 5.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5.5! 
Priced Under Tax-Value!
Parsons KS
 
 
Overall Profit Summary
Purchase Price: $37,134
Estimated Repairs$36,754
Sales Price After Remodel$118,408
Total Profit Estimate$19,630
View Details

Asking $44,900
 *  Listed 28 Days Ago
 *  Originally Listed on 5/1/2020.
 *  Deal Rating of 6.9/10

Great Deal-Score of 5.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5.5! 
Fix & Flip Investor-Deal
Kansas City MO
 
 
Overall Profit Summary
Purchase Price: $35,854
Estimated Repairs$24,101
Sales Price After Remodel$93,102
Total Profit Estimate$15,976
View Details

Asking $44,900
 *  185 Days on Market
 *  Originally Listed on 11/26/2019.
 *  Great Deal Rating of 8.4/10

 Sold As-Is!
Great Deal-Score of 9.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 High Deal Score of 9.5! 
Great Profit Potential
Kansas City MO
 
 
Overall Profit Summary
Purchase Price: $36,361
Estimated Repairs$22,268
Sales Price After Remodel$89,537
Total Profit Estimate$14,848
View Details

Asking $45,000
 *  Listed 79 Days Ago
 *  Originally Listed on 3/11/2020.
 *  Great Deal Rating of 8.4/10

 Motivated Seller!
Great Deal-Score of 9.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 High Deal Score of 9.5! 
Great Profit Potential
Kansas City MO
 
 
Overall Profit Summary
Purchase Price: $34,137
Estimated Repairs$25,449
Sales Price After Remodel$95,897
Total Profit Estimate$18,313
View Details

Asking $45,000
 *  Price Reduced by $4,900 on 12/8/2019.
 *  Originally Listed on 9/19/2019.
 *  Deal Rating of 7.6/10

 $3,700 Below Appraisal
 Reduced By $4,900
 Sold As-Is!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 7.5! 
Make Offer. High Profit.
Kansas City MO
 
 
Overall Profit Summary
Purchase Price: $35,934
Estimated Repairs$15,261
Sales Price After Remodel$75,523
Total Profit Estimate$12,543
View Details

Asking $45,000
 *  Listed 112 Days Ago
 *  Originally Listed on 2/7/2020.
 *  Deal Rating of 7.3/10

 $4,000 Below Appraisal
Great Deal-Score of 6.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 6.5! 
Great Profit Potential
Topeka KS
 
 
Overall Profit Summary
Purchase Price: $35,934
Estimated Repairs$23,697
Sales Price After Remodel$92,394
Total Profit Estimate$15,833
View Details

Asking $45,000
 *  Listed 107 Days Ago
 *  Originally Listed on 2/12/2020.
 *  Deal Rating of 6.9/10

 $17,700 Below Appraisal
Great Deal-Score of 5.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5.5! 
Great Profit Potential
Kansas City MO
 
 
Overall Profit Summary
Purchase Price: $36,789
Estimated Repairs$14,630
Sales Price After Remodel$74,260
Total Profit Estimate$11,442
View Details

Asking $45,000
 *  Listed 44 Days Ago
 *  Originally Listed on 4/15/2020.
 *  Great Deal Rating of 8.2/10

 Rehab-Fixer!
Great Deal-Score of 9!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Great Deal Score of 9! 
Investor-Deal!
Kansas City KS
 
 
Overall Profit Summary
Purchase Price: $37,538
Estimated Repairs$12,629
Sales Price After Remodel$67,538
Total Profit Estimate$13,434
View Details

Asking $45,000
 *  New! Listed 2 Day(s) Ago
 *  Originally Listed on 5/27/2020.
 *  Deal Rating of 7.6/10

Great Deal-Score of 7.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 7.5! 
Make Offer. High Profit.
Topeka KS
 
 
Overall Profit Summary
Purchase Price: $36,361
Estimated Repairs$12,646
Sales Price After Remodel$70,293
Total Profit Estimate$11,096
View Details

Asking $45,000
 *  Listed 86 Days Ago
 *  Originally Listed on 3/4/2020.
 *  Great Deal Rating of 8.4/10

 $1,800 Below Appraisal
 Handyman Special!
Great Deal-Score of 9.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 High Deal Score of 9.5! 
Great Profit Potential
Spring Hill KS
 
 
Overall Profit Summary
Purchase Price: $35,119
Estimated Repairs$17,795
Sales Price After Remodel$81,339
Total Profit Estimate$15,055
View Details

Asking $45,750
 *  Price Reduced by $3,050 on 3/31/2020.
 *  Originally Listed on 3/25/2020.
 *  Great Deal Rating of 8.4/10

 Reduced By $3,050
 Sold As-Is!
Great Deal-Score of 9.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 High Deal Score of 9.5! 
Investor-Deal!
Emporia KS
 
 
Overall Profit Summary
Purchase Price: $35,578
Estimated Repairs$22,713
Sales Price After Remodel$92,326
Total Profit Estimate$17,600
View Details

Asking $46,900
 *  Price Reduced by $1,000 on 1/30/2020.
 *  Originally Listed on 1/29/2020.
 *  Deal Rating of 7.3/10

 Reduced By $1,000
Great Deal-Score of 6.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 6.5! 
Make Offer. High Profit.
Pittsburg KS
 
 
Overall Profit Summary
Purchase Price: $38,833
Estimated Repairs$17,687
Sales Price After Remodel$82,874
Total Profit Estimate$12,952
View Details

Asking $47,500
 *  Listed 54 Days Ago
 *  Originally Listed on 4/5/2020.
 *  Deal Rating of 7.3/10

 $1,200 Below Appraisal
Great Deal-Score of 6.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 6.5! 
Priced Under Tax-Value!
Pittsburg KS
 
 
Overall Profit Summary
Purchase Price: $40,112
Estimated Repairs$21,541
Sales Price After Remodel$91,582
Total Profit Estimate$14,122
View Details

Asking $48,500
 *  Listed 31 Days Ago
 *  Originally Listed on 4/28/2020.
 *  Deal Rating of 6.9/10

 $19,200 Below Appraisal
Great Deal-Score of 5.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5.5! 
Great Profit Potential
Kansas City MO
 
 
Overall Profit Summary
Purchase Price: $38,728
Estimated Repairs$19,309
Sales Price After Remodel$87,117
Total Profit Estimate$14,634
View Details

Asking $48,500
 *  Listed 106 Days Ago
 *  Originally Listed on 2/13/2020.
 *  Deal Rating of 7.6/10

 $20,100 Below Appraisal
Great Deal-Score of 7.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 7.5! 
Great Profit Potential
Kansas City MO
 
 
Overall Profit Summary
Purchase Price: $39,128
Estimated Repairs$19,250
Sales Price After Remodel$87,500
Total Profit Estimate$14,685
View Details

Asking $49,000
 *  152 Days on Market
 *  Originally Listed on 12/29/2019.
 *  Deal Rating of 7.6/10

 $18,300 Below Appraisal
 Motivated Seller!
Great Deal-Score of 7.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 7.5! 
Great Profit Potential
Kansas City MO
 
 
Overall Profit Summary
Purchase Price: $40,525
Estimated Repairs$16,555
Sales Price After Remodel$82,110
Total Profit Estimate$12,236
View Details

Asking $49,000
 *  Listed 30 Days Ago
 *  Originally Listed on 4/29/2020.
 *  Deal Rating of 6.9/10

 $17,300 Below Appraisal
Great Deal-Score of 5.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5.5! 
Fix & Flip Investor-Deal
Pittsburg KS
 
 
Overall Profit Summary
Purchase Price: $37,171
Estimated Repairs$15,598
Sales Price After Remodel$80,197
Total Profit Estimate$15,217
View Details

Asking $49,000
 *  Price Reduced by $13,000 on 12/20/2019.
 *  Originally Listed on 12/19/2019.
 *  Deal Rating of 6.9/10

 Reduced By $13,000
Great Deal-Score of 5.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5.5! 
Great Profit Potential
Parsons KS
 
 
Overall Profit Summary
Purchase Price: $39,998
Estimated Repairs$11,698
Sales Price After Remodel$72,896
Total Profit Estimate$11,342
View Details

Asking $49,500
 *  Listed 66 Days Ago
 *  Originally Listed on 3/24/2020.
 *  Great Deal Rating of 8.4/10

 Motivated Seller!
Great Deal-Score of 9.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 High Deal Score of 9.5! 
Make Offer. High Profit.
Topeka KS
 
 
Overall Profit Summary
Purchase Price: $39,998
Estimated Repairs$31,054
Sales Price After Remodel$111,608
Total Profit Estimate$18,891
View Details

Asking $49,500
 *  Listed 100 Days Ago
 *  Originally Listed on 2/19/2020.
 *  Great Deal Rating of 8.4/10

 Flip - Needs Repairs!
Great Deal-Score of 9.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 High Deal Score of 9.5! 
Great Profit Potential
Topeka KS
 
 
Overall Profit Summary
Purchase Price: $41,625
Estimated Repairs$13,328
Sales Price After Remodel$73,782
Total Profit Estimate$14,541
View Details

Asking $49,900
 *  New! Listed 7 Day(s) Ago
 *  Originally Listed on 5/22/2020.
 *  Deal Rating of 7.8/10

 $9,600 Below Appraisal
 Flip - Needs Repairs!
Great Deal-Score of 8!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 8! 
combined end
  Use the Black tabs above to navigate the properties!

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!

Ottawa KS 66067

Asking : $65,000.00

Researched Value : $106,100.00

$41,100.00 Below Researched Value

HappyInvestor.com saved you hours of time by "Cherry Picking" this excellent deal for you from the For Sale records!

Below Researched Value

$41,100.00 Below Researched Value *****


View Details

Ottawa KS 66067

Asking : $79,950.00

Researched Value : $111,600.00

$31,650.00 Below Researched Value

HappyInvestor.com saved you hours of time by "Cherry Picking" this excellent deal for you from the For Sale records!

Below Researched Value

$31,650.00 Below Researched Value *****


View Details

Mound City KS 66056

Asking : $82,000.00

Researched Value : $94,700.00

$12,700.00 Below Researched Value

HappyInvestor.com saved you hours of time by "Cherry Picking" this excellent deal for you from the For Sale records!

Below Researched Value

$12,700.00 Below Researched Value *****


View Details

Use the Tabs at the Top of This Page to Navigate the different types of properties!

Mound City KS 66056

Asking : $99,500.00

Researched Value : $114,500.00

$15,000.00 Below Researched Value

HappyInvestor.com saved you hours of time by "Cherry Picking" this excellent deal for you from the For Sale records!

Below Researched Value

$15,000.00 Below Researched Value *****


View Details

Paola KS 66071

Asking : $105,000.00

Researched Value : $122,600.00

$17,600.00 Below Researched Value

HappyInvestor.com saved you hours of time by "Cherry Picking" this excellent deal for you from the For Sale records!

Below Researched Value

$17,600.00 Below Researched Value *****


View Details


You Have Limited Access!
You are Currently Viewing Limited Data and Number of Homes. CREATE A FREE ACCOUNT HERE to View More Homes!


UNLOCK MORE ACCESS FOR FREE!

  CREATE A FREE ACCOUNT --->





Ottawa KS 66067

Asking : $240,000.00

Researched Value : $390,000.00

$150,000.00 Below Researched Value

HappyInvestor.com saved you hours of time by "Cherry Picking" this excellent deal for you from the For Sale records!

Below Researched Value

$150,000.00 Below Researched Value *****


View Details

Garnett KS 66032

Asking : $295,000.00

Researched Value : $494,300.00

$199,300.00 Below Researched Value

HappyInvestor.com saved you hours of time by "Cherry Picking" this excellent deal for you from the For Sale records!

Below Researched Value

$199,300.00 Below Researched Value *****


View Details

Wellsville KS 66092

Asking : $337,500.00

Researched Value : $478,100.00

$140,600.00 Below Researched Value

HappyInvestor.com saved you hours of time by "Cherry Picking" this excellent deal for you from the For Sale records!

Below Researched Value

$140,600.00 Below Researched Value *****


View Details

Paola KS 66071

Asking : $339,000.00

Researched Value : $511,600.00

$172,600.00 Below Researched Value

HappyInvestor.com saved you hours of time by "Cherry Picking" this excellent deal for you from the For Sale records!

Below Researched Value

$172,600.00 Below Researched Value *****


View Details

** Lenders are individuals that have come to us and filled out a form saying they would like to lend on real estate. Most of them prefer a collateral-backed real estate loan over investing in an unsecure stock market. If you're tired of paying high hard-money rates or filling out too many forms for a rental property loan and have a property you would like to buy? We reccommend letting one of these Lenders know about your flip or rental property. Negotiate the rate, years, and your down payment with them and have a local real estate attorney close the deal for you. Enjoy!

Ron - Lending $250,000.00

Lender Name : Ron Cedillo

Lender Type : individual

8% Rate

Lending: Nationwide

Lending at 8%


View Detail

Jon - Lending $50,000.00

Lender Name : Jon Lee

Lender Type : individual

8% Rate

Lending: Nationwide

Lending at 8%


View Detail

Chester - Lending $1,000,000.00

Lender Name : Chester Murape

Lender Type : individual

6% Rate

Lending: Nationwide

Lending at 6%


View Detail

Use the Tabs at the Top of This Page to Navigate the different types of properties!

Rogelio - Lending $100,000.00

Lender Name : Rogelio Dominguez

Lender Type : individual

5% Rate

Lending: Nationwide

Lending at 5%


View Detail

Myke - Lending $1,000,000.00

Lender Name : Myke Van Ness

Lender Type : individual

4% Rate

Lending: Nationwide

Lending at 4%


View Detail


You Have Limited Access!
You are Currently Viewing Limited Data and Number of Homes. CREATE A FREE ACCOUNT HERE to View More Homes!


UNLOCK MORE ACCESS FOR FREE!

  CREATE A FREE ACCOUNT --->





Will - Lending $100,000.00

Lender Name : Will Shaban

Lender Type : individual

8% Rate

Lending: Nationwide

Lending at 8%


View Detail

John - Lending $1,000,001.00

Lender Name : John Inman

Lender Type : individual

8% Rate

Lending: Nationwide

Lending at 8%


View Detail

Neil Brown - Lending $500,000.00

Lender Name : Neil Brown Brown

Lender Type : individual

8% Rate

Lending: Nationwide

Lending at 8%


View Detail

Geordan - Lending $1,000,001.00

Lender Name : Geordan Reisner

Lender Type : individual

9% Rate

Lending: Nationwide

Lending at 9%


View Detail

Charles - Lending $50,000.00

Lender Name : Charles Coppock

Lender Type : individual

8% Rate

Lending: Nationwide

Lending at 8%


View Detail

Use the Tabs at the Top of This Page to Navigate the different types of properties!

James - Lending $100,000.00

Lender Name : James Gill

Lender Type : individual

7% Rate

Lending: Nationwide

Lending at 7%


View Detail

Bruce - Lending $250,000.00

Lender Name : Bruce Gruetzmacher

Lender Type : individual

5% Rate

Lending: Nationwide

Lending at 5%


View Detail

Bill - Lending $50,000.00

Lender Name : Bill Herrera

Lender Type : individual

6% Rate

Lending: Nationwide

Lending at 6%


View Detail

Raphael - Lending $100,000.00

Lender Name : Raphael Coto

Lender Type : individual

8% Rate

Lending: Nationwide

Lending at 8%


View Detail

Corey - Lending $50,000.00

Lender Name : Corey Bell

Lender Type : individual

5% Rate

Lending: Nationwide

Lending at 5%


View Detail


You Have Limited Access!
You are Currently Viewing Limited Data and Number of Homes. CREATE A FREE ACCOUNT HERE to View More Homes!


UNLOCK MORE ACCESS FOR FREE!

  CREATE A FREE ACCOUNT --->





Ken - Lending $250,000.00

Lender Name : Ken Levasseur

Lender Type : individual

9% Rate

Lending: Nationwide

Lending at 9%


View Detail

Kathleen - Lending $50,000.00

Lender Name : Kathleen Alvarez

Lender Type : individual

8% Rate

Lending: Nationwide

Lending at 8%


View Detail

Manika - Lending $100,000.00

Lender Name : Manika Sethia

Lender Type : individual

7% Rate

Lending: Nationwide

Lending at 7%


View Detail

Sheldon - Lending $1,000,001.00

Lender Name : Sheldon Sontag

Lender Type : individual

8% Rate

Lending: Nationwide

Lending at 8%


View Detail

Khaled - Lending $250,000.00

Lender Name : Khaled Radwan

Lender Type : individual

3% Rate

Lending: Nationwide

Lending at 3%


View Detail

Use the Tabs at the Top of This Page to Navigate the different types of properties!

Sarah - Lending $100,000.00

Lender Name : Sarah Ryan

Lender Type : individual

7% Rate

Lending: Nationwide

Lending at 7%


View Detail

Rajeev - Lending $100,000.00

Lender Name : Rajeev Jain

Lender Type : individual

8% Rate

Lending: Nationwide

Lending at 8%


View Detail

Ravi - Lending $500,000.00

Lender Name : Ravi Jain

Lender Type : individual

3% Rate

Lending: Nationwide

Lending at 3%


View Detail

Jose Ruben - Lending $50,000.00

Lender Name : Jose Ruben Vivanco

Lender Type : individual

8% Rate

Lending: Nationwide

Lending at 8%


View Detail

Frances - Lending $50,000.00

Lender Name : Frances Prizzia

Lender Type : individual

9% Rate

Lending: Nationwide

Lending at 9%


View Detail

Rodney - Lending $1,000,001.00

Lender Name : Rodney Walker

Lender Type : individual

8% Rate

Lending: Nationwide

Lending at 8%


View Detail

Darren - Lending $250,000.00

Lender Name : Darren Keen

Lender Type : individual

3% Rate

Lending: Nationwide

Lending at 3%


View Detail

Reduced/Desperate Seller propeties are homes for sale that have been Reduced by at least 10% 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!

Ottawa KS 66067

Asking : $60,000.00

Original Price : $75,000.00

List Date : 5/20/2020

Reduced Price by $15,000.00

HappyInvestor.com saved you hours of time by "Cherry Picking" this excellent deal for you from the For Sale records!

Seller Has Reduced Price by $15,000.00 So Far. Make An Offer!

DOM: 9

These are properties that are flagged as "Investment" or "Fixer-Upper" deals. Enjoy!

Kansas City MO 64128

Asking : $15000

List Date : 5/27/2020

HappyInvestor.com saved you hours of time by "Cherry Picking" this excellent deal for you from the For Sale records!


Fix & Flip

View Details!



Deal Score: 11.5

Kansas City MO 64129

Asking : $20000

List Date : 2/27/2020

HappyInvestor.com saved you hours of time by "Cherry Picking" this excellent deal for you from the For Sale records!


Motivated Seller

View Details!



Deal Score: 9.5

Kansas City MO 64130

Asking : $20000

List Date : 5/16/2020

HappyInvestor.com saved you hours of time by "Cherry Picking" this excellent deal for you from the For Sale records!


Rehab-Fixer

View Details!



Deal Score: 9.5
Use the Tabs at the Top of This Page to Navigate the different types of properties!

Topeka KS 66608

Asking : $23000

List Date : 3/20/2020

HappyInvestor.com saved you hours of time by "Cherry Picking" this excellent deal for you from the For Sale records!


Flip - Needs Repairs

View Details!



Deal Score: 9.5

Kansas City MO 64132

Asking : $25000

List Date : 5/25/2020

HappyInvestor.com saved you hours of time by "Cherry Picking" this excellent deal for you from the For Sale records!


Rehab-Fixer

View Details!



Deal Score: 10.5

You Have Limited Access!
You are Currently Viewing Limited Data and Number of Homes. CREATE A FREE ACCOUNT HERE to View More Homes!


UNLOCK MORE ACCESS FOR FREE!

  CREATE A FREE ACCOUNT --->





Kansas City KS 66101

Asking : $26000

List Date : 4/24/2020

HappyInvestor.com saved you hours of time by "Cherry Picking" this excellent deal for you from the For Sale records!


Sold As-Is

View Details!



Deal Score: 9.5

Kansas City KS 66104

Asking : $26500

List Date : 5/8/2020

HappyInvestor.com saved you hours of time by "Cherry Picking" this excellent deal for you from the For Sale records!


Fix & Flip

View Details!



Deal Score: 9.5

Kansas City MO 64134

Asking : $27000

List Date : 5/13/2020

HappyInvestor.com saved you hours of time by "Cherry Picking" this excellent deal for you from the For Sale records!


Foreclosure

View Details!



Deal Score: 9.5

Kansas City MO 64123

Asking : $29950

List Date : 5/14/2020

HappyInvestor.com saved you hours of time by "Cherry Picking" this excellent deal for you from the For Sale records!


Investment Rental Property

View Details!



Deal Score: 6.5

Kansas City MO 64130

Asking : $35000

List Date : 5/27/2020

HappyInvestor.com saved you hours of time by "Cherry Picking" this excellent deal for you from the For Sale records!


Investment Rental Property

View Details!



Deal Score: 9.5
Use the Tabs at the Top of This Page to Navigate the different types of properties!

Kansas City MO 64130

Asking : $35000

List Date : 5/27/2020

HappyInvestor.com saved you hours of time by "Cherry Picking" this excellent deal for you from the For Sale records!


Investment Rental Property

View Details!



Deal Score: 8.5

Topeka KS 66616

Asking : $35000

List Date : 2/18/2019

HappyInvestor.com saved you hours of time by "Cherry Picking" this excellent deal for you from the For Sale records!


Sold As-Is

View Details!



Deal Score: 9.5

Independence MO 64053

Asking : $37500

List Date : 5/1/2020

HappyInvestor.com saved you hours of time by "Cherry Picking" this excellent deal for you from the For Sale records!


Fix & Flip

View Details!



Deal Score: 9.5

Kansas City MO 64128

Asking : $38500

List Date : 3/5/2020

HappyInvestor.com saved you hours of time by "Cherry Picking" this excellent deal for you from the For Sale records!


Fix & Flip

View Details!



Deal Score: 9.5

Lane KS 66042

Asking : $40000

List Date : 5/4/2020

HappyInvestor.com saved you hours of time by "Cherry Picking" this excellent deal for you from the For Sale records!


Flip - Needs Repairs

View Details!



Deal Score: 9.5

You Have Limited Access!
You are Currently Viewing Limited Data and Number of Homes. CREATE A FREE ACCOUNT HERE to View More Homes!


UNLOCK MORE ACCESS FOR FREE!

  CREATE A FREE ACCOUNT --->





Kansas City MO 64130

Asking : $42500

List Date : 4/14/2020

HappyInvestor.com saved you hours of time by "Cherry Picking" this excellent deal for you from the For Sale records!


Fix & Flip

View Details!



Deal Score: 9.5

Topeka KS 66616

Asking : $42950

List Date : 3/30/2020

HappyInvestor.com saved you hours of time by "Cherry Picking" this excellent deal for you from the For Sale records!


Sold As-Is

View Details!



Deal Score: 9.5

Kansas City MO 64125

Asking : $44900

List Date : 11/26/2019

HappyInvestor.com saved you hours of time by "Cherry Picking" this excellent deal for you from the For Sale records!


Sold As-Is

View Details!



Deal Score: 9.5

Kansas City MO 64117

Asking : $45000

List Date : 4/15/2020

HappyInvestor.com saved you hours of time by "Cherry Picking" this excellent deal for you from the For Sale records!


Rehab-Fixer

View Details!



Deal Score: 9

Kansas City MO 64126

Asking : $45000

List Date : 3/11/2020

HappyInvestor.com saved you hours of time by "Cherry Picking" this excellent deal for you from the For Sale records!


Motivated Seller

View Details!



Deal Score: 9.5
Use the Tabs at the Top of This Page to Navigate the different types of properties!

Topeka KS 66611

Asking : $45000

List Date : 3/4/2020

HappyInvestor.com saved you hours of time by "Cherry Picking" this excellent deal for you from the For Sale records!


Handyman Special

View Details!



Deal Score: 9.5

Spring Hill KS 66083

Asking : $45750

List Date : 3/25/2020

HappyInvestor.com saved you hours of time by "Cherry Picking" this excellent deal for you from the For Sale records!


Sold As-Is

View Details!



Deal Score: 9.5

Topeka KS 66606

Asking : $49500

List Date : 2/19/2020

HappyInvestor.com saved you hours of time by "Cherry Picking" this excellent deal for you from the For Sale records!


Flip - Needs Repairs

View Details!



Deal Score: 9.5

Parsons KS 67357

Asking : $49500

List Date : 3/24/2020

HappyInvestor.com saved you hours of time by "Cherry Picking" this excellent deal for you from the For Sale records!


Motivated Seller

View Details!



Deal Score: 9.5

Topeka KS 66617

Asking : $49900

List Date : 5/14/2020

HappyInvestor.com saved you hours of time by "Cherry Picking" this excellent deal for you from the For Sale records!


Sold As-Is

View Details!



Deal Score: 9.5

Kansas City MO 64130

Asking : $50000

List Date : 2/16/2020

HappyInvestor.com saved you hours of time by "Cherry Picking" this excellent deal for you from the For Sale records!


Investment Rental Property

View Details!



Deal Score: 5.5

Kansas City MO 64132

Asking : $51000

List Date : 11/18/2019

HappyInvestor.com saved you hours of time by "Cherry Picking" this excellent deal for you from the For Sale records!


Fix & Flip

View Details!



Deal Score: 9.5
** REO Foreclosures are propeties sale that have gone through the foreclosure process and are now for sale by the banks. Banks are not legally allowed to profit from the sale of a repossessed asset and are therefore much more likely to price the home and take offers at far below actual value.

Greeley KS 66033

Bid : 19,900 or Less

Beds/Baths : 2 / 1

Year Built :

REO Foreclosure

REO Auction

LANE KS 66042

Bid : 235,000 or Less

Beds/Baths : 3 / 4

Year Built : 2003

REO Foreclosure

REO Auction

Paola KS 66071

Bid : 80,000 or Less

Beds/Baths : 3 / 2.00

Year Built : 1930

REO Foreclosure

REO Auction

Use the Tabs at the Top of This Page to Navigate the different types of properties!

POMONA KS 66076

Bid : 49,900 or Less

Beds/Baths : 3 / 2

Year Built : 1995

REO Foreclosure

REO Auction

Contact Happy
Home Investor!

6836 Bee Cave RD Suite 259
Austin, TX 78746

Phone:
1-512-672-8723



Discount Foreclosure Network, LP d.b.a. HappyInvestor.com | 3267 Bee Cave Road Suite #107-245 | Austin, TX 78746 | Privacy Policy | Cancellation Policy & Guarantee select top 45 * from tblREO NOLOCK where priority is null and price > 1000 and dateposted >= '4/29/2020' and Len(PhotoURL1) > 10 and (1=1) and price >= 0 and price <= 100000000 and 11=11 and (zipCode ='66010' or zipCode = '66014' or zipCode = '66015' or zipCode = '66056' or zipCode = '66026' or zipCode = '66032' or zipCode = '66033' or zipCode = '66039' or zipCode = '66040' or zipCode = '66040' or zipCode = '66042' or zipCode = '66064' or zipCode = '66067' or zipCode = '66067' or zipCode = '66071' or zipCode = '66072' or zipCode = '66076' or zipCode = '66078' or zipCode = '66079' or zipCode = '66080' or zipCode = '66091' or zipCode = '66092' or zipCode = '66093' or zipCode = '66095' or zipCode = '66010' or zipCode = '66014' or zipCode = '66026' or zipCode = '66032' or zipCode = '66033' or zipCode = '66039' or zipCode = '66040' or zipCode = '66042' or zipCode = '66056' or zipCode = '66064' or zipCode = '66067' or zipCode = '66071' or zipCode = '66072' or zipCode = '66076' or zipCode = '66078' or zipCode = '66079' or zipCode = '66080' or zipCode = '66091' or zipCode = '66092' or zipCode = '66093' or zipCode = '66095')
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 (photoURL1<>'' AND photoURL1 IS NOT NULL) and 1=1 and theType='Tax' and (bedrooms<>'' AND bedrooms IS NOT NULL) and tax_value/price < 5 and (1=1) and price >= 0 and price <= 100000000 and 11=11 and (zipCode ='66010' or zipCode = '66014' or zipCode = '66015' or zipCode = '66056' or zipCode = '66026' or zipCode = '66032' or zipCode = '66033' or zipCode = '66039' or zipCode = '66040' or zipCode = '66040' or zipCode = '66042' or zipCode = '66064' or zipCode = '66067' or zipCode = '66067' or zipCode = '66071' or zipCode = '66072' or zipCode = '66076' or zipCode = '66078' or zipCode = '66079' or zipCode = '66080' or zipCode = '66091' or zipCode = '66092' or zipCode = '66093' or zipCode = '66095' or zipCode = '66010' or zipCode = '66014' or zipCode = '66026' or zipCode = '66032' or zipCode = '66033' or zipCode = '66039' or zipCode = '66040' or zipCode = '66042' or zipCode = '66056' or zipCode = '66064' or zipCode = '66067' or zipCode = '66071' or zipCode = '66072' or zipCode = '66076' or zipCode = '66078' or zipCode = '66079' or zipCode = '66080' or zipCode = '66091' or zipCode = '66092' or zipCode = '66093' or zipCode = '66095') order by price;
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 = 'KS' and photoURL1 is not null and theType='Tax' and (bedrooms<>'' AND bedrooms IS NOT NULL) and tax_value/price < 5 and 1=1 and (1=1) and price >= 0 and price <= 100000000 and 11=11 and (zipCode ='66010' or zipCode = '66014' or zipCode = '66015' or zipCode = '66056' or zipCode = '66026' or zipCode = '66032' or zipCode = '66033' or zipCode = '66039' or zipCode = '66040' or zipCode = '66040' or zipCode = '66042' or zipCode = '66064' or zipCode = '66067' or zipCode = '66067' or zipCode = '66071' or zipCode = '66072' or zipCode = '66076' or zipCode = '66078' or zipCode = '66079' or zipCode = '66080' or zipCode = '66091' or zipCode = '66092' or zipCode = '66093' or zipCode = '66095' or zipCode = '66010' or zipCode = '66014' or zipCode = '66026' or zipCode = '66032' or zipCode = '66033' or zipCode = '66039' or zipCode = '66040' or zipCode = '66042' or zipCode = '66056' or zipCode = '66064' or zipCode = '66067' or zipCode = '66071' or zipCode = '66072' or zipCode = '66076' or zipCode = '66078' or zipCode = '66079' or zipCode = '66080' or zipCode = '66091' or zipCode = '66092' or zipCode = '66093' or zipCode = '66095') order by price;
select top 240 * 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 len(photoURL1) > 5 and dateposted >= '4/29/2020' and 1=1 and 1=1 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 <= 100000000 and 11=11 and (zipCode ='66010' or zipCode = '66014' or zipCode = '66015' or zipCode = '66056' or zipCode = '66026' or zipCode = '66032' or zipCode = '66033' or zipCode = '66039' or zipCode = '66040' or zipCode = '66040' or zipCode = '66042' or zipCode = '66064' or zipCode = '66067' or zipCode = '66067' or zipCode = '66071' or zipCode = '66072' or zipCode = '66076' or zipCode = '66078' or zipCode = '66079' or zipCode = '66080' or zipCode = '66091' or zipCode = '66092' or zipCode = '66093' or zipCode = '66095' or zipCode = '66010' or zipCode = '66014' or zipCode = '66026' or zipCode = '66032' or zipCode = '66033' or zipCode = '66039' or zipCode = '66040' or zipCode = '66042' or zipCode = '66056' or zipCode = '66064' or zipCode = '66067' or zipCode = '66071' or zipCode = '66072' or zipCode = '66076' or zipCode = '66078' or zipCode = '66079' or zipCode = '66080' or zipCode = '66091' or zipCode = '66092' or zipCode = '66093' or zipCode = '66095') order by price;
select top 240 * 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 len(photoURL1) > 5 and dateposted >= '4/29/2020' and 1=1 and 1=1 and theType = 'RealtorValue' and len(photoURL1) > 3 and photoURL1 is not null and (bedrooms<>'' AND bedrooms IS NOT NULL) and price > 10000 and original_price > 10000 and (1=1) and price >= 0 and price <= 100000000 and 11=11 and (zipCode ='66010' or zipCode = '66014' or zipCode = '66015' or zipCode = '66056' or zipCode = '66026' or zipCode = '66032' or zipCode = '66033' or zipCode = '66039' or zipCode = '66040' or zipCode = '66040' or zipCode = '66042' or zipCode = '66064' or zipCode = '66067' or zipCode = '66067' or zipCode = '66071' or zipCode = '66072' or zipCode = '66076' or zipCode = '66078' or zipCode = '66079' or zipCode = '66080' or zipCode = '66091' or zipCode = '66092' or zipCode = '66093' or zipCode = '66095' or zipCode = '66010' or zipCode = '66014' or zipCode = '66026' or zipCode = '66032' or zipCode = '66033' or zipCode = '66039' or zipCode = '66040' or zipCode = '66042' or zipCode = '66056' or zipCode = '66064' or zipCode = '66067' or zipCode = '66071' or zipCode = '66072' or zipCode = '66076' or zipCode = '66078' or zipCode = '66079' or zipCode = '66080' or zipCode = '66091' or zipCode = '66092' or zipCode = '66093' or zipCode = '66095') 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 <= 100000000 and 11=11 and (zipCode ='66010' or zipCode = '66014' or zipCode = '66015' or zipCode = '66056' or zipCode = '66026' or zipCode = '66032' or zipCode = '66033' or zipCode = '66039' or zipCode = '66040' or zipCode = '66040' or zipCode = '66042' or zipCode = '66064' or zipCode = '66067' or zipCode = '66067' or zipCode = '66071' or zipCode = '66072' or zipCode = '66076' or zipCode = '66078' or zipCode = '66079' or zipCode = '66080' or zipCode = '66091' or zipCode = '66092' or zipCode = '66093' or zipCode = '66095' or zipCode = '66010' or zipCode = '66014' or zipCode = '66026' or zipCode = '66032' or zipCode = '66033' or zipCode = '66039' or zipCode = '66040' or zipCode = '66042' or zipCode = '66056' or zipCode = '66064' or zipCode = '66067' or zipCode = '66071' or zipCode = '66072' or zipCode = '66076' or zipCode = '66078' or zipCode = '66079' or zipCode = '66080' or zipCode = '66091' or zipCode = '66092' or zipCode = '66093' or zipCode = '66095') order by price asc;
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 = '': End Fav
Combined:select top 999 *, ((5000000/price)/2 + score) as beSmart, cast(tax_value as float)/cast(price as float) as tax_ratio from tblBothNew NOLOCK where len(photoURL1) > 1 and 1=1 and 1=1 and yearBuilt <= 2005 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 (zipCode ='64012' or zipCode = '64012' or zipCode = '64012' or zipCode = '64013' or zipCode = '64014' or zipCode = '64015' or zipCode = '64015' or zipCode = '64015' or zipCode = '64016' or zipCode = '64019' or zipCode = '64002' or zipCode = '64002' or zipCode = '64011' or zipCode = '64028' or zipCode = '64029' or zipCode = '64029' or zipCode = '64030' or zipCode = '64034' or zipCode = '64034' or zipCode = '64034' or zipCode = '64040' or zipCode = '64050' or zipCode = '64050' or zipCode = '64051' or zipCode = '64052' or zipCode = '64053' or zipCode = '64053' or zipCode = '64054' or zipCode = '64054' or zipCode = '64055' or zipCode = '64056' or zipCode = '64056' or zipCode = '64057' or zipCode = '64058' or zipCode = '64058' or zipCode = '64061' or zipCode = '64063' or zipCode = '64063' or zipCode = '64063' or zipCode = '64063' or zipCode = '64063' or zipCode = '64063' or zipCode = '64064' or zipCode = '64064' or zipCode = '64064' or zipCode = '64064' or zipCode = '64065' or zipCode = '64082' or zipCode = '64082' or zipCode = '64083' or zipCode = '64083' or zipCode = '64086' or zipCode = '64086' or zipCode = '64086' or zipCode = '64088' or zipCode = '64088' or zipCode = '64090' or zipCode = '64092' or zipCode = '64101' or zipCode = '64102' or zipCode = '64105' or zipCode = '64106' or zipCode = '64108' or zipCode = '64117' or zipCode = '64117' or zipCode = '64117' or zipCode = '64118' or zipCode = '64118' or zipCode = '64118' or zipCode = '64118' or zipCode = '64118' or zipCode = '64119' or zipCode = '64119' or zipCode = '64119' or zipCode = '64120' or zipCode = '64121' or zipCode = '64121' or zipCode = '64121' or zipCode = '64123' or zipCode = '64124' or zipCode = '64125' or zipCode = '64126' or zipCode = '64127' or zipCode = '64128' or zipCode = '64129' or zipCode = '64129' or zipCode = '64130' or zipCode = '64065' or zipCode = '64065' or zipCode = '64065' or zipCode = '64068' or zipCode = '64068' or zipCode = '64068' or zipCode = '64069' or zipCode = '64070' or zipCode = '64072' or zipCode = '64075' or zipCode = '64078' or zipCode = '64079' or zipCode = '64079' or zipCode = '64080' or zipCode = '64081' or zipCode = '64081' or zipCode = '64109' or zipCode = '64110' or zipCode = '64111' or zipCode = '64112' or zipCode = '64113' or zipCode = '64114' or zipCode = '64116' or zipCode = '64116' or zipCode = '64116' or zipCode = '64116' or zipCode = '64116' or zipCode = '64116' or zipCode = '64116' or zipCode = '64116' or zipCode = '64116' or zipCode = '64116' or zipCode = '64116' or zipCode = '64116' or zipCode = '64116' or zipCode = '64116' or zipCode = '64116' or zipCode = '64116' or zipCode = '64117' or zipCode = '64117' or zipCode = '64131' or zipCode = '64132' or zipCode = '64133' or zipCode = '64133' or zipCode = '64134' or zipCode = '64136' or zipCode = '64137' or zipCode = '64138' or zipCode = '64138' or zipCode = '64139' or zipCode = '64141' or zipCode = '64144' or zipCode = '64144' or zipCode = '64145' or zipCode = '64146' or zipCode = '64147' or zipCode = '64147' or zipCode = '64148' or zipCode = '64148' or zipCode = '64149' or zipCode = '64150' or zipCode = '64150' or zipCode = '64150' or zipCode = '64163' or zipCode = '64163' or zipCode = '64164' or zipCode = '64165' or zipCode = '64165' or zipCode = '64166' or zipCode = '64166' or zipCode = '64167' or zipCode = '64168' or zipCode = '64168' or zipCode = '64170' or zipCode = '64170' or zipCode = '64170' or zipCode = '64171' or zipCode = '64171' or zipCode = '64171' or zipCode = '64172' or zipCode = '64179' or zipCode = '64180' or zipCode = '64180' or zipCode = '64183' or zipCode = '64183' or zipCode = '64184' or zipCode = '64184' or zipCode = '64187' or zipCode = '64187' or zipCode = '64188' or zipCode = '64188' or zipCode = '64188' or zipCode = '64188' or zipCode = '64190' or zipCode = '64191' or zipCode = '64192' or zipCode = '64193' or zipCode = '64193' or zipCode = '64193' or zipCode = '64195' or zipCode = '64196' or zipCode = '64197' or zipCode = '64197' or zipCode = '64198' or zipCode = '64198' or zipCode = '64199' or zipCode = '64151' or zipCode = '64151' or zipCode = '64151' or zipCode = '64151' or zipCode = '64151' or zipCode = '64151' or zipCode = '64151' or zipCode = '64152' or zipCode = '64152' or zipCode = '64152' or zipCode = '64152' or zipCode = '64153' or zipCode = '64153' or zipCode = '64153' or zipCode = '64154' or zipCode = '64155' or zipCode = '64155' or zipCode = '64156' or zipCode = '64156' or zipCode = '64157' or zipCode = '64158' or zipCode = '64161' or zipCode = '64161' or zipCode = '64161' or zipCode = '64701' or zipCode = '64720' or zipCode = '64722' or zipCode = '64723' or zipCode = '64724' or zipCode = '64725' or zipCode = '64725' or zipCode = '64726' or zipCode = '64728' or zipCode = '64730' or zipCode = '64730' or zipCode = '64733' or zipCode = '64734' or zipCode = '64734' or zipCode = '64735' or zipCode = '64739' or zipCode = '64741' or zipCode = '64742' or zipCode = '64743' or zipCode = '64744' or zipCode = '64744' or zipCode = '64744' or zipCode = '64745' or zipCode = '64746' or zipCode = '64746' or zipCode = '64747' or zipCode = '64747' or zipCode = '64747' or zipCode = '64750' or zipCode = '64752' or zipCode = '64752' or zipCode = '64779' or zipCode = '64780' or zipCode = '64780' or zipCode = '64780' or zipCode = '64783' or zipCode = '64784' or zipCode = '64788' or zipCode = '64788' or zipCode = '64790' or zipCode = '64762' or zipCode = '64765' or zipCode = '64767' or zipCode = '64769' or zipCode = '64770' or zipCode = '64771' or zipCode = '64772' or zipCode = '64772' or zipCode = '64778' or zipCode = '64778' or zipCode = '64999' or zipCode = '64999' or zipCode = '64999' or zipCode = '64999' or zipCode = '66006' or zipCode = '66006' or zipCode = '66007' or zipCode = '66010' or zipCode = '66012' or zipCode = '66012' or zipCode = '66012' or zipCode = '66012' or zipCode = '66012' or zipCode = '66013' or zipCode = '66014' or zipCode = '66015' or zipCode = '66018' or zipCode = '66019' or zipCode = '66019' or zipCode = '66019' or zipCode = '66020' or zipCode = '66021' or zipCode = '66045' or zipCode = '66045' or zipCode = '66046' or zipCode = '66046' or zipCode = '66047' or zipCode = '66047' or zipCode = '66047' or zipCode = '66048' or zipCode = '66049' or zipCode = '66049' or zipCode = '66049' or zipCode = '66050' or zipCode = '66051' or zipCode = '66052' or zipCode = '66053' or zipCode = '66054' or zipCode = '66056' or zipCode = '66060' or zipCode = '66061' or zipCode = '66062' or zipCode = '66062' or zipCode = '66062' or zipCode = '66063' or zipCode = '66025' or zipCode = '66026' or zipCode = '66027' or zipCode = '66027' or zipCode = '66027' or zipCode = '66030' or zipCode = '66031' or zipCode = '66032' or zipCode = '66033' or zipCode = '66036' or zipCode = '66039' or zipCode = '66040' or zipCode = '66040' or zipCode = '66042' or zipCode = '66043' or zipCode = '66043' or zipCode = '66044' or zipCode = '66044' or zipCode = '66045' or zipCode = '66045' or zipCode = '66064' or zipCode = '66066' or zipCode = '66067' or zipCode = '66067' or zipCode = '66070' or zipCode = '66071' or zipCode = '66072' or zipCode = '66073' or zipCode = '66075' or zipCode = '66076' or zipCode = '66077' or zipCode = '66078' or zipCode = '66079' or zipCode = '66080' or zipCode = '66083' or zipCode = '66085' or zipCode = '66085' or zipCode = '66086' or zipCode = '66088' or zipCode = '66091' or zipCode = '66092' or zipCode = '66160' or zipCode = '66160' or zipCode = '66201' or zipCode = '66201' or zipCode = '66201' or zipCode = '66201' or zipCode = '66201' or zipCode = '66202' or zipCode = '66202' or zipCode = '66202' or zipCode = '66202' or zipCode = '66202' or zipCode = '66202' or zipCode = '66202' or zipCode = '66202' or zipCode = '66202' or zipCode = '66202' or zipCode = '66203' or zipCode = '66203' or zipCode = '66203' or zipCode = '66203' or zipCode = '66203' or zipCode = '66203' or zipCode = '66203' or zipCode = '66203' or zipCode = '66204' or zipCode = '66204' or zipCode = '66204' or zipCode = '66204' or zipCode = '66204' or zipCode = '66204' or zipCode = '66204' or zipCode = '66204' or zipCode = '66205' or zipCode = '66205' or zipCode = '66205' or zipCode = '66205' or zipCode = '66205' or zipCode = '66205' or zipCode = '66205' or zipCode = '66205' or zipCode = '66205' or zipCode = '66205' or zipCode = '66206' or zipCode = '66206' or zipCode = '66206' or zipCode = '66206' or zipCode = '66206' or zipCode = '66206' or zipCode = '66206' or zipCode = '66206' or zipCode = '66207' or zipCode = '66207' or zipCode = '66207' or zipCode = '66207' or zipCode = '66207' or zipCode = '66207' or zipCode = '66207' or zipCode = '66207' or zipCode = '66208' or zipCode = '66208' or zipCode = '66208' or zipCode = '66208' or zipCode = '66208' or zipCode = '66208' or zipCode = '66208' or zipCode = '66208' or zipCode = '66209' or zipCode = '66209' or zipCode = '66209' or zipCode = '66209' or zipCode = '66209' or zipCode = '66209' or zipCode = '66210' or zipCode = '66210' or zipCode = '66210' or zipCode = '66210' or zipCode = '66210' or zipCode = '66210' or zipCode = '66211' or zipCode = '66211' or zipCode = '66211' or zipCode = '66211' or zipCode = '66211' or zipCode = '66211' or zipCode = '66212' or zipCode = '66212' or zipCode = '66212' or zipCode = '66212' or zipCode = '66213' or zipCode = '66213' or zipCode = '66213' or zipCode = '66213' or zipCode = '66213' or zipCode = '66213' or zipCode = '66214' or zipCode = '66214' or zipCode = '66214' or zipCode = '66214' or zipCode = '66214' or zipCode = '66214' or zipCode = '66214' or zipCode = '66215' or zipCode = '66215' or zipCode = '66215' or zipCode = '66215' or zipCode = '66215' or zipCode = '66215' or zipCode = '66216' or zipCode = '66216' or zipCode = '66216' or zipCode = '66216' or zipCode = '66216' or zipCode = '66217' or zipCode = '66217' or zipCode = '66217' or zipCode = '66093' or zipCode = '66095' or zipCode = '66097' or zipCode = '66101' or zipCode = '66102' or zipCode = '66103' or zipCode = '66103' or zipCode = '66104' or zipCode = '66105' or zipCode = '66106' or zipCode = '66109' or zipCode = '66110' or zipCode = '66111' or zipCode = '66111' or zipCode = '66112' or zipCode = '66113' or zipCode = '66113' or zipCode = '66115' or zipCode = '66117' or zipCode = '66118' or zipCode = '66119' or zipCode = '66160' or zipCode = '66217' or zipCode = '66217' or zipCode = '66217' or zipCode = '66217' or zipCode = '66218' or zipCode = '66218' or zipCode = '66218' or zipCode = '66218' or zipCode = '66219' or zipCode = '66219' or zipCode = '66219' or zipCode = '66219' or zipCode = '66219' or zipCode = '66220' or zipCode = '66220' or zipCode = '66220' or zipCode = '66220' or zipCode = '66220' or zipCode = '66221' or zipCode = '66221' or zipCode = '66221' or zipCode = '66221' or zipCode = '66221' or zipCode = '66226' or zipCode = '66226' or zipCode = '66226' or zipCode = '66226' or zipCode = '66227' or zipCode = '66227' or zipCode = '66227' or zipCode = '66227' or zipCode = '66227' or zipCode = '66250' or zipCode = '66250' or zipCode = '66250' or zipCode = '66250' or zipCode = '66251' or zipCode = '66251' or zipCode = '66251' or zipCode = '66251' or zipCode = '66251' or zipCode = '66251' or zipCode = '66276' or zipCode = '66276' or zipCode = '66276' or zipCode = '66276' or zipCode = '66409' or zipCode = '66413' or zipCode = '66414' or zipCode = '66419' or zipCode = '66420' or zipCode = '66423' or zipCode = '66429' or zipCode = '66431' or zipCode = '66509' or zipCode = '66510' or zipCode = '66512' or zipCode = '66523' or zipCode = '66524' or zipCode = '66528' or zipCode = '66533' or zipCode = '66601' or zipCode = '66603' or zipCode = '66604' or zipCode = '66605' or zipCode = '66606' or zipCode = '66607' or zipCode = '66608' or zipCode = '66609' or zipCode = '66610' or zipCode = '66611' or zipCode = '66612' or zipCode = '66614' or zipCode = '66615' or zipCode = '66616' or zipCode = '66617' or zipCode = '66618' or zipCode = '66619' or zipCode = '66620' or zipCode = '66620' or zipCode = '66621' or zipCode = '66622' or zipCode = '66622' or zipCode = '66711' or zipCode = '66711' or zipCode = '66711' or zipCode = '66711' or zipCode = '66712' or zipCode = '66714' or zipCode = '66714' or zipCode = '66716' or zipCode = '66716' or zipCode = '66717' or zipCode = '66720' or zipCode = '66720' or zipCode = '66720' or zipCode = '66720' or zipCode = '66724' or zipCode = '66743' or zipCode = '66743' or zipCode = '66743' or zipCode = '66743' or zipCode = '66743' or zipCode = '66746' or zipCode = '66748' or zipCode = '66749' or zipCode = '66749' or zipCode = '66749' or zipCode = '66751' or zipCode = '66753' or zipCode = '66753' or zipCode = '66753' or zipCode = '66753' or zipCode = '66754' or zipCode = '66754' or zipCode = '66755' or zipCode = '66756' or zipCode = '66756' or zipCode = '66756' or zipCode = '66756' or zipCode = '66756' or zipCode = '66757' or zipCode = '66221' or zipCode = '66222' or zipCode = '66222' or zipCode = '66222' or zipCode = '66222' or zipCode = '66223' or zipCode = '66223' or zipCode = '66223' or zipCode = '66223' or zipCode = '66223' or zipCode = '66223' or zipCode = '66224' or zipCode = '66224' or zipCode = '66224' or zipCode = '66224' or zipCode = '66224' or zipCode = '66224' or zipCode = '66224' or zipCode = '66225' or zipCode = '66225' or zipCode = '66225' or zipCode = '66225' or zipCode = '66225' or zipCode = '66282' or zipCode = '66282' or zipCode = '66282' or zipCode = '66282' or zipCode = '66282' or zipCode = '66283' or zipCode = '66283' or zipCode = '66283' or zipCode = '66283' or zipCode = '66283' or zipCode = '66285' or zipCode = '66285' or zipCode = '66285' or zipCode = '66285' or zipCode = '66286' or zipCode = '66286' or zipCode = '66286' or zipCode = '66286' or zipCode = '66402' or zipCode = '66440' or zipCode = '66451' or zipCode = '66507' or zipCode = '66537' or zipCode = '66539' or zipCode = '66542' or zipCode = '66543' or zipCode = '66546' or zipCode = '66624' or zipCode = '66624' or zipCode = '66625' or zipCode = '66625' or zipCode = '66626' or zipCode = '66626' or zipCode = '66628' or zipCode = '66628' or zipCode = '66629' or zipCode = '66629' or zipCode = '66636' or zipCode = '66636' or zipCode = '66647' or zipCode = '66667' or zipCode = '66675' or zipCode = '66683' or zipCode = '66699' or zipCode = '66699' or zipCode = '66701' or zipCode = '66701' or zipCode = '66701' or zipCode = '66710' or zipCode = '66710' or zipCode = '66711' or zipCode = '66732' or zipCode = '66733' or zipCode = '66734' or zipCode = '66735' or zipCode = '66736' or zipCode = '66736' or zipCode = '66736' or zipCode = '66736' or zipCode = '66738' or zipCode = '66738' or zipCode = '66740' or zipCode = '66741' or zipCode = '66741' or zipCode = '66742' or zipCode = '66743' or zipCode = '66743' or zipCode = '66757' or zipCode = '66757' or zipCode = '66758' or zipCode = '66758' or zipCode = '66759' or zipCode = '66761' or zipCode = '66762' or zipCode = '66762' or zipCode = '66762' or zipCode = '66763' or zipCode = '66763' or zipCode = '66767' or zipCode = '66767' or zipCode = '66769' or zipCode = '66771' or zipCode = '66771' or zipCode = '66772' or zipCode = '66775' or zipCode = '66776' or zipCode = '66776' or zipCode = '66777' or zipCode = '66779' or zipCode = '66780' or zipCode = '66780' or zipCode = '66783' or zipCode = '66783' or zipCode = '66783' or zipCode = '66783' or zipCode = '66801' or zipCode = '66830' or zipCode = '66833' or zipCode = '66833' or zipCode = '66835' or zipCode = '66839' or zipCode = '66839' or zipCode = '66845' or zipCode = '66845' or zipCode = '66852' or zipCode = '66853' or zipCode = '66854' or zipCode = '66855' or zipCode = '66855' or zipCode = '66856' or zipCode = '66857' or zipCode = '66860' or zipCode = '66863' or zipCode = '66864' or zipCode = '66865' or zipCode = '66868' or zipCode = '66870' or zipCode = '66871' or zipCode = '67045' or zipCode = '67045' or zipCode = '67047' or zipCode = '67341' or zipCode = '67357' or zipCode = '64011' or zipCode = '64012' or zipCode = '64013' or zipCode = '64014' or zipCode = '64015' or zipCode = '64016' or zipCode = '64019' or zipCode = '64028' or zipCode = '64029' or zipCode = '64030' or zipCode = '64034' or zipCode = '64040' or zipCode = '64050' or zipCode = '64051' or zipCode = '64052' or zipCode = '64053' or zipCode = '64054' or zipCode = '64055' or zipCode = '64056' or zipCode = '64057' or zipCode = '64058' or zipCode = '64061' or zipCode = '64063' or zipCode = '64064' or zipCode = '64065' or zipCode = '64068' or zipCode = '64069' or zipCode = '64070' or zipCode = '64072' or zipCode = '64075' or zipCode = '64078' or zipCode = '64079' or zipCode = '64080' or zipCode = '64081' or zipCode = '64082' or zipCode = '64083' or zipCode = '64086' or zipCode = '64087' or zipCode = '64088' or zipCode = '64090' or zipCode = '64092' or zipCode = '64101' or zipCode = '64102' or zipCode = '64105' or zipCode = '64106' or zipCode = '64108' or zipCode = '64109' or zipCode = '64110' or zipCode = '64111' or zipCode = '64112' or zipCode = '64113' or zipCode = '64114' or zipCode = '64116' or zipCode = '64117' or zipCode = '64118' or zipCode = '64119' or zipCode = '64120' or zipCode = '64121' or zipCode = '64123' or zipCode = '64124' or zipCode = '64125' or zipCode = '64126' or zipCode = '64127' or zipCode = '64128' or zipCode = '64129' or zipCode = '64130' or zipCode = '64131' or zipCode = '64132' or zipCode = '64133' or zipCode = '64134' or zipCode = '64136' or zipCode = '64137' or zipCode = '64138' or zipCode = '64139' or zipCode = '64141' or zipCode = '64142' or zipCode = '64144' or zipCode = '64145' or zipCode = '64146' or zipCode = '64147' or zipCode = '64148' or zipCode = '64149' or zipCode = '64150' or zipCode = '64151' or zipCode = '64152' or zipCode = '64153' or zipCode = '64154' or zipCode = '64155' or zipCode = '64156' or zipCode = '64157' or zipCode = '64158' or zipCode = '64160' or zipCode = '64161' or zipCode = '64163' or zipCode = '64164' or zipCode = '64165' or zipCode = '64166' or zipCode = '64167' or zipCode = '64168' or zipCode = '64170' or zipCode = '64171' or zipCode = '64172' or zipCode = '64173' or zipCode = '64179' or zipCode = '64180' or zipCode = '64183' or zipCode = '64184' or zipCode = '64185' or zipCode = '64187' or zipCode = '64188' or zipCode = '64189' or zipCode = '64190' or zipCode = '64191' or zipCode = '64192' or zipCode = '64193' or zipCode = '64194' or zipCode = '64195' or zipCode = '64196' or zipCode = '64197' or zipCode = '64198' or zipCode = '64199' or zipCode = '64701' or zipCode = '64720' or zipCode = '64722' or zipCode = '64723' or zipCode = '64724' or zipCode = '64725' or zipCode = '64726' or zipCode = '64728' or zipCode = '64730' or zipCode = '64733' or zipCode = '64734' or zipCode = '64735' or zipCode = '64739' or zipCode = '64741' or zipCode = '64742' or zipCode = '64743' or zipCode = '64744' or zipCode = '64745' or zipCode = '64746' or zipCode = '64747' or zipCode = '64750' or zipCode = '64751' or zipCode = '64752' or zipCode = '64762' or zipCode = '64765' or zipCode = '64766' or zipCode = '64767' or zipCode = '64769' or zipCode = '64770' or zipCode = '64771' or zipCode = '64772' or zipCode = '64777' or zipCode = '64778' or zipCode = '64779' or zipCode = '64780' or zipCode = '64783' or zipCode = '64784' or zipCode = '64788' or zipCode = '64790' or zipCode = '64944' or zipCode = '64999' or zipCode = '66006' or zipCode = '66007' or zipCode = '66010' or zipCode = '66012' or zipCode = '66013' or zipCode = '66014' or zipCode = '66015' or zipCode = '66018' or zipCode = '66019' or zipCode = '66020' or zipCode = '66021' or zipCode = '66025' or zipCode = '66026' or zipCode = '66027' or zipCode = '66030' or zipCode = '66031' or zipCode = '66032' or zipCode = '66033' or zipCode = '66036' or zipCode = '66039' or zipCode = '66040' or zipCode = '66042' or zipCode = '66043' or zipCode = '66044' or zipCode = '66045' or zipCode = '66046' or zipCode = '66047' or zipCode = '66048' or zipCode = '66049' or zipCode = '66050' or zipCode = '66051' or zipCode = '66052' or zipCode = '66053' or zipCode = '66054' or zipCode = '66056' or zipCode = '66060' or zipCode = '66061' or zipCode = '66062' or zipCode = '66063' or zipCode = '66064' or zipCode = '66066' or zipCode = '66067' or zipCode = '66070' or zipCode = '66071' or zipCode = '66072' or zipCode = '66073' or zipCode = '66075' or zipCode = '66076' or zipCode = '66077' or zipCode = '66078' or zipCode = '66079' or zipCode = '66080' or zipCode = '66083' or zipCode = '66085' or zipCode = '66086' or zipCode = '66088' or zipCode = '66091' or zipCode = '66092' or zipCode = '66093' or zipCode = '66095' or zipCode = '66097' or zipCode = '66101' or zipCode = '66102' or zipCode = '66103' or zipCode = '66104' or zipCode = '66105' or zipCode = '66106' or zipCode = '66109' or zipCode = '66110' or zipCode = '66111' or zipCode = '66112' or zipCode = '66113' or zipCode = '66115' or zipCode = '66117' or zipCode = '66118' or zipCode = '66119' or zipCode = '66160' or zipCode = '66201' or zipCode = '66202' or zipCode = '66203' or zipCode = '66204' or zipCode = '66205' or zipCode = '66206' or zipCode = '66207' or zipCode = '66208' or zipCode = '66209' or zipCode = '66210' or zipCode = '66211' or zipCode = '66212' or zipCode = '66213' or zipCode = '66214' or zipCode = '66215' or zipCode = '66216' or zipCode = '66217' or zipCode = '66218' or zipCode = '66219' or zipCode = '66220' or zipCode = '66221' or zipCode = '66222' or zipCode = '66223' or zipCode = '66224' or zipCode = '66225' or zipCode = '66226' or zipCode = '66227' or zipCode = '66250' or zipCode = '66251' or zipCode = '66276' or zipCode = '66279' or zipCode = '66282' or zipCode = '66283' or zipCode = '66285' or zipCode = '66286' or zipCode = '66356' or zipCode = '66402' or zipCode = '66409' or zipCode = '66413' or zipCode = '66414' or zipCode = '66419' or zipCode = '66420' or zipCode = '66423' or zipCode = '66429' or zipCode = '66431' or zipCode = '66440' or zipCode = '66451' or zipCode = '66507' or zipCode = '66509' or zipCode = '66510' or zipCode = '66512' or zipCode = '66523' or zipCode = '66524' or zipCode = '66526' or zipCode = '66528' or zipCode = '66533' or zipCode = '66537' or zipCode = '66539' or zipCode = '66542' or zipCode = '66543' or zipCode = '66546' or zipCode = '66601' or zipCode = '66603' or zipCode = '66604' or zipCode = '66605' or zipCode = '66606' or zipCode = '66607' or zipCode = '66608' or zipCode = '66609' or zipCode = '66610' or zipCode = '66611' or zipCode = '66612' or zipCode = '66614' or zipCode = '66615' or zipCode = '66616' or zipCode = '66617' or zipCode = '66618' or zipCode = '66619' or zipCode = '66620' or zipCode = '66621' or zipCode = '66622' or zipCode = '66624' or zipCode = '66625' or zipCode = '66626' or zipCode = '66628' or zipCode = '66629' or zipCode = '66634' or zipCode = '66636' or zipCode = '66637' or zipCode = '66638' or zipCode = '66642' or zipCode = '66647' or zipCode = '66652' or zipCode = '66653' or zipCode = '66658' or zipCode = '66667' or zipCode = '66675' or zipCode = '66683' or zipCode = '66686' or zipCode = '66692' or zipCode = '66699' or zipCode = '66701' or zipCode = '66710' or zipCode = '66711' or zipCode = '66712' or zipCode = '66714' or zipCode = '66716' or zipCode = '66717' or zipCode = '66720' or zipCode = '66721' or zipCode = '66724' or zipCode = '66727' or zipCode = '66732' or zipCode = '66733' or zipCode = '66734' or zipCode = '66735' or zipCode = '66736' or zipCode = '66738' or zipCode = '66740' or zipCode = '66741' or zipCode = '66742' or zipCode = '66743' or zipCode = '66746' or zipCode = '66747' or zipCode = '66748' or zipCode = '66749' or zipCode = '66751' or zipCode = '66752' or zipCode = '66753' or zipCode = '66754' or zipCode = '66755' or zipCode = '66756' or zipCode = '66757' or zipCode = '66758' or zipCode = '66759' or zipCode = '66761' or zipCode = '66762' or zipCode = '66763' or zipCode = '66767' or zipCode = '66769' or zipCode = '66771' or zipCode = '66772' or zipCode = '66775' or zipCode = '66776' or zipCode = '66777' or zipCode = '66779' or zipCode = '66780' or zipCode = '66783' or zipCode = '66801' or zipCode = '66830' or zipCode = '66833' or zipCode = '66835' or zipCode = '66839' or zipCode = '66852' or zipCode = '66853' or zipCode = '66854' or zipCode = '66855' or zipCode = '66856' or zipCode = '66857' or zipCode = '66860' or zipCode = '66863' or zipCode = '66864' or zipCode = '66865' or zipCode = '66868' or zipCode = '66869' or zipCode = '66870' or zipCode = '66871' or zipCode = '67045' or zipCode = '67047' or zipCode = '67341' or zipCode = '67357') order by price asc;: 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 >= '4/29/2020' and 1=1 and 1=1 and theType = 'Keyword' and keywordType != 'Investment Property' and price > 10000 and original_price > 10000 and (zipCode ='64012' or zipCode = '64012' or zipCode = '64012' or zipCode = '64013' or zipCode = '64014' or zipCode = '64015' or zipCode = '64015' or zipCode = '64015' or zipCode = '64016' or zipCode = '64019' or zipCode = '64002' or zipCode = '64002' or zipCode = '64011' or zipCode = '64028' or zipCode = '64029' or zipCode = '64029' or zipCode = '64030' or zipCode = '64034' or zipCode = '64034' or zipCode = '64034' or zipCode = '64040' or zipCode = '64050' or zipCode = '64050' or zipCode = '64051' or zipCode = '64052' or zipCode = '64053' or zipCode = '64053' or zipCode = '64054' or zipCode = '64054' or zipCode = '64055' or zipCode = '64056' or zipCode = '64056' or zipCode = '64057' or zipCode = '64058' or zipCode = '64058' or zipCode = '64061' or zipCode = '64063' or zipCode = '64063' or zipCode = '64063' or zipCode = '64063' or zipCode = '64063' or zipCode = '64063' or zipCode = '64064' or zipCode = '64064' or zipCode = '64064' or zipCode = '64064' or zipCode = '64065' or zipCode = '64082' or zipCode = '64082' or zipCode = '64083' or zipCode = '64083' or zipCode = '64086' or zipCode = '64086' or zipCode = '64086' or zipCode = '64088' or zipCode = '64088' or zipCode = '64090' or zipCode = '64092' or zipCode = '64101' or zipCode = '64102' or zipCode = '64105' or zipCode = '64106' or zipCode = '64108' or zipCode = '64117' or zipCode = '64117' or zipCode = '64117' or zipCode = '64118' or zipCode = '64118' or zipCode = '64118' or zipCode = '64118' or zipCode = '64118' or zipCode = '64119' or zipCode = '64119' or zipCode = '64119' or zipCode = '64120' or zipCode = '64121' or zipCode = '64121' or zipCode = '64121' or zipCode = '64123' or zipCode = '64124' or zipCode = '64125' or zipCode = '64126' or zipCode = '64127' or zipCode = '64128' or zipCode = '64129' or zipCode = '64129' or zipCode = '64130' or zipCode = '64065' or zipCode = '64065' or zipCode = '64065' or zipCode = '64068' or zipCode = '64068' or zipCode = '64068' or zipCode = '64069' or zipCode = '64070' or zipCode = '64072' or zipCode = '64075' or zipCode = '64078' or zipCode = '64079' or zipCode = '64079' or zipCode = '64080' or zipCode = '64081' or zipCode = '64081' or zipCode = '64109' or zipCode = '64110' or zipCode = '64111' or zipCode = '64112' or zipCode = '64113' or zipCode = '64114' or zipCode = '64116' or zipCode = '64116' or zipCode = '64116' or zipCode = '64116' or zipCode = '64116' or zipCode = '64116' or zipCode = '64116' or zipCode = '64116' or zipCode = '64116' or zipCode = '64116' or zipCode = '64116' or zipCode = '64116' or zipCode = '64116' or zipCode = '64116' or zipCode = '64116' or zipCode = '64116' or zipCode = '64117' or zipCode = '64117' or zipCode = '64131' or zipCode = '64132' or zipCode = '64133' or zipCode = '64133' or zipCode = '64134' or zipCode = '64136' or zipCode = '64137' or zipCode = '64138' or zipCode = '64138' or zipCode = '64139' or zipCode = '64141' or zipCode = '64144' or zipCode = '64144' or zipCode = '64145' or zipCode = '64146' or zipCode = '64147' or zipCode = '64147' or zipCode = '64148' or zipCode = '64148' or zipCode = '64149' or zipCode = '64150' or zipCode = '64150' or zipCode = '64150' or zipCode = '64163' or zipCode = '64163' or zipCode = '64164' or zipCode = '64165' or zipCode = '64165' or zipCode = '64166' or zipCode = '64166' or zipCode = '64167' or zipCode = '64168' or zipCode = '64168' or zipCode = '64170' or zipCode = '64170' or zipCode = '64170' or zipCode = '64171' or zipCode = '64171' or zipCode = '64171' or zipCode = '64172' or zipCode = '64179' or zipCode = '64180' or zipCode = '64180' or zipCode = '64183' or zipCode = '64183' or zipCode = '64184' or zipCode = '64184' or zipCode = '64187' or zipCode = '64187' or zipCode = '64188' or zipCode = '64188' or zipCode = '64188' or zipCode = '64188' or zipCode = '64190' or zipCode = '64191' or zipCode = '64192' or zipCode = '64193' or zipCode = '64193' or zipCode = '64193' or zipCode = '64195' or zipCode = '64196' or zipCode = '64197' or zipCode = '64197' or zipCode = '64198' or zipCode = '64198' or zipCode = '64199' or zipCode = '64151' or zipCode = '64151' or zipCode = '64151' or zipCode = '64151' or zipCode = '64151' or zipCode = '64151' or zipCode = '64151' or zipCode = '64152' or zipCode = '64152' or zipCode = '64152' or zipCode = '64152' or zipCode = '64153' or zipCode = '64153' or zipCode = '64153' or zipCode = '64154' or zipCode = '64155' or zipCode = '64155' or zipCode = '64156' or zipCode = '64156' or zipCode = '64157' or zipCode = '64158' or zipCode = '64161' or zipCode = '64161' or zipCode = '64161' or zipCode = '64701' or zipCode = '64720' or zipCode = '64722' or zipCode = '64723' or zipCode = '64724' or zipCode = '64725' or zipCode = '64725' or zipCode = '64726' or zipCode = '64728' or zipCode = '64730' or zipCode = '64730' or zipCode = '64733' or zipCode = '64734' or zipCode = '64734' or zipCode = '64735' or zipCode = '64739' or zipCode = '64741' or zipCode = '64742' or zipCode = '64743' or zipCode = '64744' or zipCode = '64744' or zipCode = '64744' or zipCode = '64745' or zipCode = '64746' or zipCode = '64746' or zipCode = '64747' or zipCode = '64747' or zipCode = '64747' or zipCode = '64750' or zipCode = '64752' or zipCode = '64752' or zipCode = '64779' or zipCode = '64780' or zipCode = '64780' or zipCode = '64780' or zipCode = '64783' or zipCode = '64784' or zipCode = '64788' or zipCode = '64788' or zipCode = '64790' or zipCode = '64762' or zipCode = '64765' or zipCode = '64767' or zipCode = '64769' or zipCode = '64770' or zipCode = '64771' or zipCode = '64772' or zipCode = '64772' or zipCode = '64778' or zipCode = '64778' or zipCode = '64999' or zipCode = '64999' or zipCode = '64999' or zipCode = '64999' or zipCode = '66006' or zipCode = '66006' or zipCode = '66007' or zipCode = '66010' or zipCode = '66012' or zipCode = '66012' or zipCode = '66012' or zipCode = '66012' or zipCode = '66012' or zipCode = '66013' or zipCode = '66014' or zipCode = '66015' or zipCode = '66018' or zipCode = '66019' or zipCode = '66019' or zipCode = '66019' or zipCode = '66020' or zipCode = '66021' or zipCode = '66045' or zipCode = '66045' or zipCode = '66046' or zipCode = '66046' or zipCode = '66047' or zipCode = '66047' or zipCode = '66047' or zipCode = '66048' or zipCode = '66049' or zipCode = '66049' or zipCode = '66049' or zipCode = '66050' or zipCode = '66051' or zipCode = '66052' or zipCode = '66053' or zipCode = '66054' or zipCode = '66056' or zipCode = '66060' or zipCode = '66061' or zipCode = '66062' or zipCode = '66062' or zipCode = '66062' or zipCode = '66063' or zipCode = '66025' or zipCode = '66026' or zipCode = '66027' or zipCode = '66027' or zipCode = '66027' or zipCode = '66030' or zipCode = '66031' or zipCode = '66032' or zipCode = '66033' or zipCode = '66036' or zipCode = '66039' or zipCode = '66040' or zipCode = '66040' or zipCode = '66042' or zipCode = '66043' or zipCode = '66043' or zipCode = '66044' or zipCode = '66044' or zipCode = '66045' or zipCode = '66045' or zipCode = '66064' or zipCode = '66066' or zipCode = '66067' or zipCode = '66067' or zipCode = '66070' or zipCode = '66071' or zipCode = '66072' or zipCode = '66073' or zipCode = '66075' or zipCode = '66076' or zipCode = '66077' or zipCode = '66078' or zipCode = '66079' or zipCode = '66080' or zipCode = '66083' or zipCode = '66085' or zipCode = '66085' or zipCode = '66086' or zipCode = '66088' or zipCode = '66091' or zipCode = '66092' or zipCode = '66160' or zipCode = '66160' or zipCode = '66201' or zipCode = '66201' or zipCode = '66201' or zipCode = '66201' or zipCode = '66201' or zipCode = '66202' or zipCode = '66202' or zipCode = '66202' or zipCode = '66202' or zipCode = '66202' or zipCode = '66202' or zipCode = '66202' or zipCode = '66202' or zipCode = '66202' or zipCode = '66202' or zipCode = '66203' or zipCode = '66203' or zipCode = '66203' or zipCode = '66203' or zipCode = '66203' or zipCode = '66203' or zipCode = '66203' or zipCode = '66203' or zipCode = '66204' or zipCode = '66204' or zipCode = '66204' or zipCode = '66204' or zipCode = '66204' or zipCode = '66204' or zipCode = '66204' or zipCode = '66204' or zipCode = '66205' or zipCode = '66205' or zipCode = '66205' or zipCode = '66205' or zipCode = '66205' or zipCode = '66205' or zipCode = '66205' or zipCode = '66205' or zipCode = '66205' or zipCode = '66205' or zipCode = '66206' or zipCode = '66206' or zipCode = '66206' or zipCode = '66206' or zipCode = '66206' or zipCode = '66206' or zipCode = '66206' or zipCode = '66206' or zipCode = '66207' or zipCode = '66207' or zipCode = '66207' or zipCode = '66207' or zipCode = '66207' or zipCode = '66207' or zipCode = '66207' or zipCode = '66207' or zipCode = '66208' or zipCode = '66208' or zipCode = '66208' or zipCode = '66208' or zipCode = '66208' or zipCode = '66208' or zipCode = '66208' or zipCode = '66208' or zipCode = '66209' or zipCode = '66209' or zipCode = '66209' or zipCode = '66209' or zipCode = '66209' or zipCode = '66209' or zipCode = '66210' or zipCode = '66210' or zipCode = '66210' or zipCode = '66210' or zipCode = '66210' or zipCode = '66210' or zipCode = '66211' or zipCode = '66211' or zipCode = '66211' or zipCode = '66211' or zipCode = '66211' or zipCode = '66211' or zipCode = '66212' or zipCode = '66212' or zipCode = '66212' or zipCode = '66212' or zipCode = '66213' or zipCode = '66213' or zipCode = '66213' or zipCode = '66213' or zipCode = '66213' or zipCode = '66213' or zipCode = '66214' or zipCode = '66214' or zipCode = '66214' or zipCode = '66214' or zipCode = '66214' or zipCode = '66214' or zipCode = '66214' or zipCode = '66215' or zipCode = '66215' or zipCode = '66215' or zipCode = '66215' or zipCode = '66215' or zipCode = '66215' or zipCode = '66216' or zipCode = '66216' or zipCode = '66216' or zipCode = '66216' or zipCode = '66216' or zipCode = '66217' or zipCode = '66217' or zipCode = '66217' or zipCode = '66093' or zipCode = '66095' or zipCode = '66097' or zipCode = '66101' or zipCode = '66102' or zipCode = '66103' or zipCode = '66103' or zipCode = '66104' or zipCode = '66105' or zipCode = '66106' or zipCode = '66109' or zipCode = '66110' or zipCode = '66111' or zipCode = '66111' or zipCode = '66112' or zipCode = '66113' or zipCode = '66113' or zipCode = '66115' or zipCode = '66117' or zipCode = '66118' or zipCode = '66119' or zipCode = '66160' or zipCode = '66217' or zipCode = '66217' or zipCode = '66217' or zipCode = '66217' or zipCode = '66218' or zipCode = '66218' or zipCode = '66218' or zipCode = '66218' or zipCode = '66219' or zipCode = '66219' or zipCode = '66219' or zipCode = '66219' or zipCode = '66219' or zipCode = '66220' or zipCode = '66220' or zipCode = '66220' or zipCode = '66220' or zipCode = '66220' or zipCode = '66221' or zipCode = '66221' or zipCode = '66221' or zipCode = '66221' or zipCode = '66221' or zipCode = '66226' or zipCode = '66226' or zipCode = '66226' or zipCode = '66226' or zipCode = '66227' or zipCode = '66227' or zipCode = '66227' or zipCode = '66227' or zipCode = '66227' or zipCode = '66250' or zipCode = '66250' or zipCode = '66250' or zipCode = '66250' or zipCode = '66251' or zipCode = '66251' or zipCode = '66251' or zipCode = '66251' or zipCode = '66251' or zipCode = '66251' or zipCode = '66276' or zipCode = '66276' or zipCode = '66276' or zipCode = '66276' or zipCode = '66409' or zipCode = '66413' or zipCode = '66414' or zipCode = '66419' or zipCode = '66420' or zipCode = '66423' or zipCode = '66429' or zipCode = '66431' or zipCode = '66509' or zipCode = '66510' or zipCode = '66512' or zipCode = '66523' or zipCode = '66524' or zipCode = '66528' or zipCode = '66533' or zipCode = '66601' or zipCode = '66603' or zipCode = '66604' or zipCode = '66605' or zipCode = '66606' or zipCode = '66607' or zipCode = '66608' or zipCode = '66609' or zipCode = '66610' or zipCode = '66611' or zipCode = '66612' or zipCode = '66614' or zipCode = '66615' or zipCode = '66616' or zipCode = '66617' or zipCode = '66618' or zipCode = '66619' or zipCode = '66620' or zipCode = '66620' or zipCode = '66621' or zipCode = '66622' or zipCode = '66622' or zipCode = '66711' or zipCode = '66711' or zipCode = '66711' or zipCode = '66711' or zipCode = '66712' or zipCode = '66714' or zipCode = '66714' or zipCode = '66716' or zipCode = '66716' or zipCode = '66717' or zipCode = '66720' or zipCode = '66720' or zipCode = '66720' or zipCode = '66720' or zipCode = '66724' or zipCode = '66743' or zipCode = '66743' or zipCode = '66743' or zipCode = '66743' or zipCode = '66743' or zipCode = '66746' or zipCode = '66748' or zipCode = '66749' or zipCode = '66749' or zipCode = '66749' or zipCode = '66751' or zipCode = '66753' or zipCode = '66753' or zipCode = '66753' or zipCode = '66753' or zipCode = '66754' or zipCode = '66754' or zipCode = '66755' or zipCode = '66756' or zipCode = '66756' or zipCode = '66756' or zipCode = '66756' or zipCode = '66756' or zipCode = '66757' or zipCode = '66221' or zipCode = '66222' or zipCode = '66222' or zipCode = '66222' or zipCode = '66222' or zipCode = '66223' or zipCode = '66223' or zipCode = '66223' or zipCode = '66223' or zipCode = '66223' or zipCode = '66223' or zipCode = '66224' or zipCode = '66224' or zipCode = '66224' or zipCode = '66224' or zipCode = '66224' or zipCode = '66224' or zipCode = '66224' or zipCode = '66225' or zipCode = '66225' or zipCode = '66225' or zipCode = '66225' or zipCode = '66225' or zipCode = '66282' or zipCode = '66282' or zipCode = '66282' or zipCode = '66282' or zipCode = '66282' or zipCode = '66283' or zipCode = '66283' or zipCode = '66283' or zipCode = '66283' or zipCode = '66283' or zipCode = '66285' or zipCode = '66285' or zipCode = '66285' or zipCode = '66285' or zipCode = '66286' or zipCode = '66286' or zipCode = '66286' or zipCode = '66286' or zipCode = '66402' or zipCode = '66440' or zipCode = '66451' or zipCode = '66507' or zipCode = '66537' or zipCode = '66539' or zipCode = '66542' or zipCode = '66543' or zipCode = '66546' or zipCode = '66624' or zipCode = '66624' or zipCode = '66625' or zipCode = '66625' or zipCode = '66626' or zipCode = '66626' or zipCode = '66628' or zipCode = '66628' or zipCode = '66629' or zipCode = '66629' or zipCode = '66636' or zipCode = '66636' or zipCode = '66647' or zipCode = '66667' or zipCode = '66675' or zipCode = '66683' or zipCode = '66699' or zipCode = '66699' or zipCode = '66701' or zipCode = '66701' or zipCode = '66701' or zipCode = '66710' or zipCode = '66710' or zipCode = '66711' or zipCode = '66732' or zipCode = '66733' or zipCode = '66734' or zipCode = '66735' or zipCode = '66736' or zipCode = '66736' or zipCode = '66736' or zipCode = '66736' or zipCode = '66738' or zipCode = '66738' or zipCode = '66740' or zipCode = '66741' or zipCode = '66741' or zipCode = '66742' or zipCode = '66743' or zipCode = '66743' or zipCode = '66757' or zipCode = '66757' or zipCode = '66758' or zipCode = '66758' or zipCode = '66759' or zipCode = '66761' or zipCode = '66762' or zipCode = '66762' or zipCode = '66762' or zipCode = '66763' or zipCode = '66763' or zipCode = '66767' or zipCode = '66767' or zipCode = '66769' or zipCode = '66771' or zipCode = '66771' or zipCode = '66772' or zipCode = '66775' or zipCode = '66776' or zipCode = '66776' or zipCode = '66777' or zipCode = '66779' or zipCode = '66780' or zipCode = '66780' or zipCode = '66783' or zipCode = '66783' or zipCode = '66783' or zipCode = '66783' or zipCode = '66801' or zipCode = '66830' or zipCode = '66833' or zipCode = '66833' or zipCode = '66835' or zipCode = '66839' or zipCode = '66839' or zipCode = '66845' or zipCode = '66845' or zipCode = '66852' or zipCode = '66853' or zipCode = '66854' or zipCode = '66855' or zipCode = '66855' or zipCode = '66856' or zipCode = '66857' or zipCode = '66860' or zipCode = '66863' or zipCode = '66864' or zipCode = '66865' or zipCode = '66868' or zipCode = '66870' or zipCode = '66871' or zipCode = '67045' or zipCode = '67045' or zipCode = '67047' or zipCode = '67341' or zipCode = '67357' or zipCode = '64011' or zipCode = '64012' or zipCode = '64013' or zipCode = '64014' or zipCode = '64015' or zipCode = '64016' or zipCode = '64019' or zipCode = '64028' or zipCode = '64029' or zipCode = '64030' or zipCode = '64034' or zipCode = '64040' or zipCode = '64050' or zipCode = '64051' or zipCode = '64052' or zipCode = '64053' or zipCode = '64054' or zipCode = '64055' or zipCode = '64056' or zipCode = '64057' or zipCode = '64058' or zipCode = '64061' or zipCode = '64063' or zipCode = '64064' or zipCode = '64065' or zipCode = '64068' or zipCode = '64069' or zipCode = '64070' or zipCode = '64072' or zipCode = '64075' or zipCode = '64078' or zipCode = '64079' or zipCode = '64080' or zipCode = '64081' or zipCode = '64082' or zipCode = '64083' or zipCode = '64086' or zipCode = '64087' or zipCode = '64088' or zipCode = '64090' or zipCode = '64092' or zipCode = '64101' or zipCode = '64102' or zipCode = '64105' or zipCode = '64106' or zipCode = '64108' or zipCode = '64109' or zipCode = '64110' or zipCode = '64111' or zipCode = '64112' or zipCode = '64113' or zipCode = '64114' or zipCode = '64116' or zipCode = '64117' or zipCode = '64118' or zipCode = '64119' or zipCode = '64120' or zipCode = '64121' or zipCode = '64123' or zipCode = '64124' or zipCode = '64125' or zipCode = '64126' or zipCode = '64127' or zipCode = '64128' or zipCode = '64129' or zipCode = '64130' or zipCode = '64131' or zipCode = '64132' or zipCode = '64133' or zipCode = '64134' or zipCode = '64136' or zipCode = '64137' or zipCode = '64138' or zipCode = '64139' or zipCode = '64141' or zipCode = '64142' or zipCode = '64144' or zipCode = '64145' or zipCode = '64146' or zipCode = '64147' or zipCode = '64148' or zipCode = '64149' or zipCode = '64150' or zipCode = '64151' or zipCode = '64152' or zipCode = '64153' or zipCode = '64154' or zipCode = '64155' or zipCode = '64156' or zipCode = '64157' or zipCode = '64158' or zipCode = '64160' or zipCode = '64161' or zipCode = '64163' or zipCode = '64164' or zipCode = '64165' or zipCode = '64166' or zipCode = '64167' or zipCode = '64168' or zipCode = '64170' or zipCode = '64171' or zipCode = '64172' or zipCode = '64173' or zipCode = '64179' or zipCode = '64180' or zipCode = '64183' or zipCode = '64184' or zipCode = '64185' or zipCode = '64187' or zipCode = '64188' or zipCode = '64189' or zipCode = '64190' or zipCode = '64191' or zipCode = '64192' or zipCode = '64193' or zipCode = '64194' or zipCode = '64195' or zipCode = '64196' or zipCode = '64197' or zipCode = '64198' or zipCode = '64199' or zipCode = '64701' or zipCode = '64720' or zipCode = '64722' or zipCode = '64723' or zipCode = '64724' or zipCode = '64725' or zipCode = '64726' or zipCode = '64728' or zipCode = '64730' or zipCode = '64733' or zipCode = '64734' or zipCode = '64735' or zipCode = '64739' or zipCode = '64741' or zipCode = '64742' or zipCode = '64743' or zipCode = '64744' or zipCode = '64745' or zipCode = '64746' or zipCode = '64747' or zipCode = '64750' or zipCode = '64751' or zipCode = '64752' or zipCode = '64762' or zipCode = '64765' or zipCode = '64766' or zipCode = '64767' or zipCode = '64769' or zipCode = '64770' or zipCode = '64771' or zipCode = '64772' or zipCode = '64777' or zipCode = '64778' or zipCode = '64779' or zipCode = '64780' or zipCode = '64783' or zipCode = '64784' or zipCode = '64788' or zipCode = '64790' or zipCode = '64944' or zipCode = '64999' or zipCode = '66006' or zipCode = '66007' or zipCode = '66010' or zipCode = '66012' or zipCode = '66013' or zipCode = '66014' or zipCode = '66015' or zipCode = '66018' or zipCode = '66019' or zipCode = '66020' or zipCode = '66021' or zipCode = '66025' or zipCode = '66026' or zipCode = '66027' or zipCode = '66030' or zipCode = '66031' or zipCode = '66032' or zipCode = '66033' or zipCode = '66036' or zipCode = '66039' or zipCode = '66040' or zipCode = '66042' or zipCode = '66043' or zipCode = '66044' or zipCode = '66045' or zipCode = '66046' or zipCode = '66047' or zipCode = '66048' or zipCode = '66049' or zipCode = '66050' or zipCode = '66051' or zipCode = '66052' or zipCode = '66053' or zipCode = '66054' or zipCode = '66056' or zipCode = '66060' or zipCode = '66061' or zipCode = '66062' or zipCode = '66063' or zipCode = '66064' or zipCode = '66066' or zipCode = '66067' or zipCode = '66070' or zipCode = '66071' or zipCode = '66072' or zipCode = '66073' or zipCode = '66075' or zipCode = '66076' or zipCode = '66077' or zipCode = '66078' or zipCode = '66079' or zipCode = '66080' or zipCode = '66083' or zipCode = '66085' or zipCode = '66086' or zipCode = '66088' or zipCode = '66091' or zipCode = '66092' or zipCode = '66093' or zipCode = '66095' or zipCode = '66097' or zipCode = '66101' or zipCode = '66102' or zipCode = '66103' or zipCode = '66104' or zipCode = '66105' or zipCode = '66106' or zipCode = '66109' or zipCode = '66110' or zipCode = '66111' or zipCode = '66112' or zipCode = '66113' or zipCode = '66115' or zipCode = '66117' or zipCode = '66118' or zipCode = '66119' or zipCode = '66160' or zipCode = '66201' or zipCode = '66202' or zipCode = '66203' or zipCode = '66204' or zipCode = '66205' or zipCode = '66206' or zipCode = '66207' or zipCode = '66208' or zipCode = '66209' or zipCode = '66210' or zipCode = '66211' or zipCode = '66212' or zipCode = '66213' or zipCode = '66214' or zipCode = '66215' or zipCode = '66216' or zipCode = '66217' or zipCode = '66218' or zipCode = '66219' or zipCode = '66220' or zipCode = '66221' or zipCode = '66222' or zipCode = '66223' or zipCode = '66224' or zipCode = '66225' or zipCode = '66226' or zipCode = '66227' or zipCode = '66250' or zipCode = '66251' or zipCode = '66276' or zipCode = '66279' or zipCode = '66282' or zipCode = '66283' or zipCode = '66285' or zipCode = '66286' or zipCode = '66356' or zipCode = '66402' or zipCode = '66409' or zipCode = '66413' or zipCode = '66414' or zipCode = '66419' or zipCode = '66420' or zipCode = '66423' or zipCode = '66429' or zipCode = '66431' or zipCode = '66440' or zipCode = '66451' or zipCode = '66507' or zipCode = '66509' or zipCode = '66510' or zipCode = '66512' or zipCode = '66523' or zipCode = '66524' or zipCode = '66526' or zipCode = '66528' or zipCode = '66533' or zipCode = '66537' or zipCode = '66539' or zipCode = '66542' or zipCode = '66543' or zipCode = '66546' or zipCode = '66601' or zipCode = '66603' or zipCode = '66604' or zipCode = '66605' or zipCode = '66606' or zipCode = '66607' or zipCode = '66608' or zipCode = '66609' or zipCode = '66610' or zipCode = '66611' or zipCode = '66612' or zipCode = '66614' or zipCode = '66615' or zipCode = '66616' or zipCode = '66617' or zipCode = '66618' or zipCode = '66619' or zipCode = '66620' or zipCode = '66621' or zipCode = '66622' or zipCode = '66624' or zipCode = '66625' or zipCode = '66626' or zipCode = '66628' or zipCode = '66629' or zipCode = '66634' or zipCode = '66636' or zipCode = '66637' or zipCode = '66638' or zipCode = '66642' or zipCode = '66647' or zipCode = '66652' or zipCode = '66653' or zipCode = '66658' or zipCode = '66667' or zipCode = '66675' or zipCode = '66683' or zipCode = '66686' or zipCode = '66692' or zipCode = '66699' or zipCode = '66701' or zipCode = '66710' or zipCode = '66711' or zipCode = '66712' or zipCode = '66714' or zipCode = '66716' or zipCode = '66717' or zipCode = '66720' or zipCode = '66721' or zipCode = '66724' or zipCode = '66727' or zipCode = '66732' or zipCode = '66733' or zipCode = '66734' or zipCode = '66735' or zipCode = '66736' or zipCode = '66738' or zipCode = '66740' or zipCode = '66741' or zipCode = '66742' or zipCode = '66743' or zipCode = '66746' or zipCode = '66747' or zipCode = '66748' or zipCode = '66749' or zipCode = '66751' or zipCode = '66752' or zipCode = '66753' or zipCode = '66754' or zipCode = '66755' or zipCode = '66756' or zipCode = '66757' or zipCode = '66758' or zipCode = '66759' or zipCode = '66761' or zipCode = '66762' or zipCode = '66763' or zipCode = '66767' or zipCode = '66769' or zipCode = '66771' or zipCode = '66772' or zipCode = '66775' or zipCode = '66776' or zipCode = '66777' or zipCode = '66779' or zipCode = '66780' or zipCode = '66783' or zipCode = '66801' or zipCode = '66830' or zipCode = '66833' or zipCode = '66835' or zipCode = '66839' or zipCode = '66852' or zipCode = '66853' or zipCode = '66854' or zipCode = '66855' or zipCode = '66856' or zipCode = '66857' or zipCode = '66860' or zipCode = '66863' or zipCode = '66864' or zipCode = '66865' or zipCode = '66868' or zipCode = '66869' or zipCode = '66870' or zipCode = '66871' or zipCode = '67045' or zipCode = '67047' or zipCode = '67341' or zipCode = '67357') 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 ='66010' or property_zip = '66014' or property_zip = '66015' or property_zip = '66056' or property_zip = '66026' or property_zip = '66032' or property_zip = '66033' or property_zip = '66039' or property_zip = '66040' or property_zip = '66040' or property_zip = '66042' or property_zip = '66064' or property_zip = '66067' or property_zip = '66067' or property_zip = '66071' or property_zip = '66072' or property_zip = '66076' or property_zip = '66078' or property_zip = '66079' or property_zip = '66080' or property_zip = '66091' or property_zip = '66092' or property_zip = '66093' or property_zip = '66095' or property_zip = '66010' or property_zip = '66014' or property_zip = '66026' or property_zip = '66032' or property_zip = '66033' or property_zip = '66039' or property_zip = '66040' or property_zip = '66042' or property_zip = '66056' or property_zip = '66064' or property_zip = '66067' or property_zip = '66071' or property_zip = '66072' or property_zip = '66076' or property_zip = '66078' or property_zip = '66079' or property_zip = '66080' or property_zip = '66091' or property_zip = '66092' or property_zip = '66093' or property_zip = '66095') and 11=11 and (property_zip ='64012' or property_zip = '64012' or property_zip = '64012' or property_zip = '64013' or property_zip = '64014' or property_zip = '64015' or property_zip = '64015' or property_zip = '64015' or property_zip = '64016' or property_zip = '64019' or property_zip = '64002' or property_zip = '64002' or property_zip = '64011' or property_zip = '64028' or property_zip = '64029' or property_zip = '64029' or property_zip = '64030' or property_zip = '64034' or property_zip = '64034' or property_zip = '64034' or property_zip = '64040' or property_zip = '64050' or property_zip = '64050' or property_zip = '64051' or property_zip = '64052' or property_zip = '64053' or property_zip = '64053' or property_zip = '64054' or property_zip = '64054' or property_zip = '64055' or property_zip = '64056' or property_zip = '64056' or property_zip = '64057' or property_zip = '64058' or property_zip = '64058' or property_zip = '64061' or property_zip = '64063' or property_zip = '64063' or property_zip = '64063' or property_zip = '64063' or property_zip = '64063' or property_zip = '64063' or property_zip = '64064' or property_zip = '64064' or property_zip = '64064' or property_zip = '64064' or property_zip = '64065' or property_zip = '64082' or property_zip = '64082' or property_zip = '64083' or property_zip = '64083' or property_zip = '64086' or property_zip = '64086' or property_zip = '64086' or property_zip = '64088' or property_zip = '64088' or property_zip = '64090' or property_zip = '64092' or property_zip = '64101' or property_zip = '64102' or property_zip = '64105' or property_zip = '64106' or property_zip = '64108' or property_zip = '64117' or property_zip = '64117' or property_zip = '64117' or property_zip = '64118' or property_zip = '64118' or property_zip = '64118' or property_zip = '64118' or property_zip = '64118' or property_zip = '64119' or property_zip = '64119' or property_zip = '64119' or property_zip = '64120' or property_zip = '64121' or property_zip = '64121' or property_zip = '64121' or property_zip = '64123' or property_zip = '64124' or property_zip = '64125' or property_zip = '64126' or property_zip = '64127' or property_zip = '64128' or property_zip = '64129' or property_zip = '64129' or property_zip = '64130' or property_zip = '64065' or property_zip = '64065' or property_zip = '64065' or property_zip = '64068' or property_zip = '64068' or property_zip = '64068' or property_zip = '64069' or property_zip = '64070' or property_zip = '64072' or property_zip = '64075' or property_zip = '64078' or property_zip = '64079' or property_zip = '64079' or property_zip = '64080' or property_zip = '64081' or property_zip = '64081' or property_zip = '64109' or property_zip = '64110' or property_zip = '64111' or property_zip = '64112' or property_zip = '64113' or property_zip = '64114' or property_zip = '64116' or property_zip = '64116' or property_zip = '64116' or property_zip = '64116' or property_zip = '64116' or property_zip = '64116' or property_zip = '64116' or property_zip = '64116' or property_zip = '64116' or property_zip = '64116' or property_zip = '64116' or property_zip = '64116' or property_zip = '64116' or property_zip = '64116' or property_zip = '64116' or property_zip = '64116' or property_zip = '64117' or property_zip = '64117' or property_zip = '64131' or property_zip = '64132' or property_zip = '64133' or property_zip = '64133' or property_zip = '64134' or property_zip = '64136' or property_zip = '64137' or property_zip = '64138' or property_zip = '64138' or property_zip = '64139' or property_zip = '64141' or property_zip = '64144' or property_zip = '64144' or property_zip = '64145' or property_zip = '64146' or property_zip = '64147' or property_zip = '64147' or property_zip = '64148' or property_zip = '64148' or property_zip = '64149' or property_zip = '64150' or property_zip = '64150' or property_zip = '64150' or property_zip = '64163' or property_zip = '64163' or property_zip = '64164' or property_zip = '64165' or property_zip = '64165' or property_zip = '64166' or property_zip = '64166' or property_zip = '64167' or property_zip = '64168' or property_zip = '64168' or property_zip = '64170' or property_zip = '64170' or property_zip = '64170' or property_zip = '64171' or property_zip = '64171' or property_zip = '64171' or property_zip = '64172' or property_zip = '64179' or property_zip = '64180' or property_zip = '64180' or property_zip = '64183' or property_zip = '64183' or property_zip = '64184' or property_zip = '64184' or property_zip = '64187' or property_zip = '64187' or property_zip = '64188' or property_zip = '64188' or property_zip = '64188' or property_zip = '64188' or property_zip = '64190' or property_zip = '64191' or property_zip = '64192' or property_zip = '64193' or property_zip = '64193' or property_zip = '64193' or property_zip = '64195' or property_zip = '64196' or property_zip = '64197' or property_zip = '64197' or property_zip = '64198' or property_zip = '64198' or property_zip = '64199' or property_zip = '64151' or property_zip = '64151' or property_zip = '64151' or property_zip = '64151' or property_zip = '64151' or property_zip = '64151' or property_zip = '64151' or property_zip = '64152' or property_zip = '64152' or property_zip = '64152' or property_zip = '64152' or property_zip = '64153' or property_zip = '64153' or property_zip = '64153' or property_zip = '64154' or property_zip = '64155' or property_zip = '64155' or property_zip = '64156' or property_zip = '64156' or property_zip = '64157' or property_zip = '64158' or property_zip = '64161' or property_zip = '64161' or property_zip = '64161' or property_zip = '64701' or property_zip = '64720' or property_zip = '64722' or property_zip = '64723' or property_zip = '64724' or property_zip = '64725' or property_zip = '64725' or property_zip = '64726' or property_zip = '64728' or property_zip = '64730' or property_zip = '64730' or property_zip = '64733' or property_zip = '64734' or property_zip = '64734' or property_zip = '64735' or property_zip = '64739' or property_zip = '64741' or property_zip = '64742' or property_zip = '64743' or property_zip = '64744' or property_zip = '64744' or property_zip = '64744' or property_zip = '64745' or property_zip = '64746' or property_zip = '64746' or property_zip = '64747' or property_zip = '64747' or property_zip = '64747' or property_zip = '64750' or property_zip = '64752' or property_zip = '64752' or property_zip = '64779' or property_zip = '64780' or property_zip = '64780' or property_zip = '64780' or property_zip = '64783' or property_zip = '64784' or property_zip = '64788' or property_zip = '64788' or property_zip = '64790' or property_zip = '64762' or property_zip = '64765' or property_zip = '64767' or property_zip = '64769' or property_zip = '64770' or property_zip = '64771' or property_zip = '64772' or property_zip = '64772' or property_zip = '64778' or property_zip = '64778' or property_zip = '64999' or property_zip = '64999' or property_zip = '64999' or property_zip = '64999' or property_zip = '66006' or property_zip = '66006' or property_zip = '66007' or property_zip = '66010' or property_zip = '66012' or property_zip = '66012' or property_zip = '66012' or property_zip = '66012' or property_zip = '66012' or property_zip = '66013' or property_zip = '66014' or property_zip = '66015' or property_zip = '66018' or property_zip = '66019' or property_zip = '66019' or property_zip = '66019' or property_zip = '66020' or property_zip = '66021' or property_zip = '66045' or property_zip = '66045' or property_zip = '66046' or property_zip = '66046' or property_zip = '66047' or property_zip = '66047' or property_zip = '66047' or property_zip = '66048' or property_zip = '66049' or property_zip = '66049' or property_zip = '66049' or property_zip = '66050' or property_zip = '66051' or property_zip = '66052' or property_zip = '66053' or property_zip = '66054' or property_zip = '66056' or property_zip = '66060' or property_zip = '66061' or property_zip = '66062' or property_zip = '66062' or property_zip = '66062' or property_zip = '66063' or property_zip = '66025' or property_zip = '66026' or property_zip = '66027' or property_zip = '66027' or property_zip = '66027' or property_zip = '66030' or property_zip = '66031' or property_zip = '66032' or property_zip = '66033' or property_zip = '66036' or property_zip = '66039' or property_zip = '66040' or property_zip = '66040' or property_zip = '66042' or property_zip = '66043' or property_zip = '66043' or property_zip = '66044' or property_zip = '66044' or property_zip = '66045' or property_zip = '66045' or property_zip = '66064' or property_zip = '66066' or property_zip = '66067' or property_zip = '66067' or property_zip = '66070' or property_zip = '66071' or property_zip = '66072' or property_zip = '66073' or property_zip = '66075' or property_zip = '66076' or property_zip = '66077' or property_zip = '66078' or property_zip = '66079' or property_zip = '66080' or property_zip = '66083' or property_zip = '66085' or property_zip = '66085' or property_zip = '66086' or property_zip = '66088' or property_zip = '66091' or property_zip = '66092' or property_zip = '66160' or property_zip = '66160' or property_zip = '66201' or property_zip = '66201' or property_zip = '66201' or property_zip = '66201' or property_zip = '66201' or property_zip = '66202' or property_zip = '66202' or property_zip = '66202' or property_zip = '66202' or property_zip = '66202' or property_zip = '66202' or property_zip = '66202' or property_zip = '66202' or property_zip = '66202' or property_zip = '66202' or property_zip = '66203' or property_zip = '66203' or property_zip = '66203' or property_zip = '66203' or property_zip = '66203' or property_zip = '66203' or property_zip = '66203' or property_zip = '66203' or property_zip = '66204' or property_zip = '66204' or property_zip = '66204' or property_zip = '66204' or property_zip = '66204' or property_zip = '66204' or property_zip = '66204' or property_zip = '66204' or property_zip = '66205' or property_zip = '66205' or property_zip = '66205' or property_zip = '66205' or property_zip = '66205' or property_zip = '66205' or property_zip = '66205' or property_zip = '66205' or property_zip = '66205' or property_zip = '66205' or property_zip = '66206' or property_zip = '66206' or property_zip = '66206' or property_zip = '66206' or property_zip = '66206' or property_zip = '66206' or property_zip = '66206' or property_zip = '66206' or property_zip = '66207' or property_zip = '66207' or property_zip = '66207' or property_zip = '66207' or property_zip = '66207' or property_zip = '66207' or property_zip = '66207' or property_zip = '66207' or property_zip = '66208' or property_zip = '66208' or property_zip = '66208' or property_zip = '66208' or property_zip = '66208' or property_zip = '66208' or property_zip = '66208' or property_zip = '66208' or property_zip = '66209' or property_zip = '66209' or property_zip = '66209' or property_zip = '66209' or property_zip = '66209' or property_zip = '66209' or property_zip = '66210' or property_zip = '66210' or property_zip = '66210' or property_zip = '66210' or property_zip = '66210' or property_zip = '66210' or property_zip = '66211' or property_zip = '66211' or property_zip = '66211' or property_zip = '66211' or property_zip = '66211' or property_zip = '66211' or property_zip = '66212' or property_zip = '66212' or property_zip = '66212' or property_zip = '66212' or property_zip = '66213' or property_zip = '66213' or property_zip = '66213' or property_zip = '66213' or property_zip = '66213' or property_zip = '66213' or property_zip = '66214' or property_zip = '66214' or property_zip = '66214' or property_zip = '66214' or property_zip = '66214' or property_zip = '66214' or property_zip = '66214' or property_zip = '66215' or property_zip = '66215' or property_zip = '66215' or property_zip = '66215' or property_zip = '66215' or property_zip = '66215' or property_zip = '66216' or property_zip = '66216' or property_zip = '66216' or property_zip = '66216' or property_zip = '66216' or property_zip = '66217' or property_zip = '66217' or property_zip = '66217' or property_zip = '66093' or property_zip = '66095' or property_zip = '66097' or property_zip = '66101' or property_zip = '66102' or property_zip = '66103' or property_zip = '66103' or property_zip = '66104' or property_zip = '66105' or property_zip = '66106' or property_zip = '66109' or property_zip = '66110' or property_zip = '66111' or property_zip = '66111' or property_zip = '66112' or property_zip = '66113' or property_zip = '66113' or property_zip = '66115' or property_zip = '66117' or property_zip = '66118' or property_zip = '66119' or property_zip = '66160' or property_zip = '66217' or property_zip = '66217' or property_zip = '66217' or property_zip = '66217' or property_zip = '66218' or property_zip = '66218' or property_zip = '66218' or property_zip = '66218' or property_zip = '66219' or property_zip = '66219' or property_zip = '66219' or property_zip = '66219' or property_zip = '66219' or property_zip = '66220' or property_zip = '66220' or property_zip = '66220' or property_zip = '66220' or property_zip = '66220' or property_zip = '66221' or property_zip = '66221' or property_zip = '66221' or property_zip = '66221' or property_zip = '66221' or property_zip = '66226' or property_zip = '66226' or property_zip = '66226' or property_zip = '66226' or property_zip = '66227' or property_zip = '66227' or property_zip = '66227' or property_zip = '66227' or property_zip = '66227' or property_zip = '66250' or property_zip = '66250' or property_zip = '66250' or property_zip = '66250' or property_zip = '66251' or property_zip = '66251' or property_zip = '66251' or property_zip = '66251' or property_zip = '66251' or property_zip = '66251' or property_zip = '66276' or property_zip = '66276' or property_zip = '66276' or property_zip = '66276' or property_zip = '66409' or property_zip = '66413' or property_zip = '66414' or property_zip = '66419' or property_zip = '66420' or property_zip = '66423' or property_zip = '66429' or property_zip = '66431' or property_zip = '66509' or property_zip = '66510' or property_zip = '66512' or property_zip = '66523' or property_zip = '66524' or property_zip = '66528' or property_zip = '66533' or property_zip = '66601' or property_zip = '66603' or property_zip = '66604' or property_zip = '66605' or property_zip = '66606' or property_zip = '66607' or property_zip = '66608' or property_zip = '66609' or property_zip = '66610' or property_zip = '66611' or property_zip = '66612' or property_zip = '66614' or property_zip = '66615' or property_zip = '66616' or property_zip = '66617' or property_zip = '66618' or property_zip = '66619' or property_zip = '66620' or property_zip = '66620' or property_zip = '66621' or property_zip = '66622' or property_zip = '66622' or property_zip = '66711' or property_zip = '66711' or property_zip = '66711' or property_zip = '66711' or property_zip = '66712' or property_zip = '66714' or property_zip = '66714' or property_zip = '66716' or property_zip = '66716' or property_zip = '66717' or property_zip = '66720' or property_zip = '66720' or property_zip = '66720' or property_zip = '66720' or property_zip = '66724' or property_zip = '66743' or property_zip = '66743' or property_zip = '66743' or property_zip = '66743' or property_zip = '66743' or property_zip = '66746' or property_zip = '66748' or property_zip = '66749' or property_zip = '66749' or property_zip = '66749' or property_zip = '66751' or property_zip = '66753' or property_zip = '66753' or property_zip = '66753' or property_zip = '66753' or property_zip = '66754' or property_zip = '66754' or property_zip = '66755' or property_zip = '66756' or property_zip = '66756' or property_zip = '66756' or property_zip = '66756' or property_zip = '66756' or property_zip = '66757' or property_zip = '66221' or property_zip = '66222' or property_zip = '66222' or property_zip = '66222' or property_zip = '66222' or property_zip = '66223' or property_zip = '66223' or property_zip = '66223' or property_zip = '66223' or property_zip = '66223' or property_zip = '66223' or property_zip = '66224' or property_zip = '66224' or property_zip = '66224' or property_zip = '66224' or property_zip = '66224' or property_zip = '66224' or property_zip = '66224' or property_zip = '66225' or property_zip = '66225' or property_zip = '66225' or property_zip = '66225' or property_zip = '66225' or property_zip = '66282' or property_zip = '66282' or property_zip = '66282' or property_zip = '66282' or property_zip = '66282' or property_zip = '66283' or property_zip = '66283' or property_zip = '66283' or property_zip = '66283' or property_zip = '66283' or property_zip = '66285' or property_zip = '66285' or property_zip = '66285' or property_zip = '66285' or property_zip = '66286' or property_zip = '66286' or property_zip = '66286' or property_zip = '66286' or property_zip = '66402' or property_zip = '66440' or property_zip = '66451' or property_zip = '66507' or property_zip = '66537' or property_zip = '66539' or property_zip = '66542' or property_zip = '66543' or property_zip = '66546' or property_zip = '66624' or property_zip = '66624' or property_zip = '66625' or property_zip = '66625' or property_zip = '66626' or property_zip = '66626' or property_zip = '66628' or property_zip = '66628' or property_zip = '66629' or property_zip = '66629' or property_zip = '66636' or property_zip = '66636' or property_zip = '66647' or property_zip = '66667' or property_zip = '66675' or property_zip = '66683' or property_zip = '66699' or property_zip = '66699' or property_zip = '66701' or property_zip = '66701' or property_zip = '66701' or property_zip = '66710' or property_zip = '66710' or property_zip = '66711' or property_zip = '66732' or property_zip = '66733' or property_zip = '66734' or property_zip = '66735' or property_zip = '66736' or property_zip = '66736' or property_zip = '66736' or property_zip = '66736' or property_zip = '66738' or property_zip = '66738' or property_zip = '66740' or property_zip = '66741' or property_zip = '66741' or property_zip = '66742' or property_zip = '66743' or property_zip = '66743' or property_zip = '66757' or property_zip = '66757' or property_zip = '66758' or property_zip = '66758' or property_zip = '66759' or property_zip = '66761' or property_zip = '66762' or property_zip = '66762' or property_zip = '66762' or property_zip = '66763' or property_zip = '66763' or property_zip = '66767' or property_zip = '66767' or property_zip = '66769' or property_zip = '66771' or property_zip = '66771' or property_zip = '66772' or property_zip = '66775' or property_zip = '66776' or property_zip = '66776' or property_zip = '66777' or property_zip = '66779' or property_zip = '66780' or property_zip = '66780' or property_zip = '66783' or property_zip = '66783' or property_zip = '66783' or property_zip = '66783' or property_zip = '66801' or property_zip = '66830' or property_zip = '66833' or property_zip = '66833' or property_zip = '66835' or property_zip = '66839' or property_zip = '66839' or property_zip = '66845' or property_zip = '66845' or property_zip = '66852' or property_zip = '66853' or property_zip = '66854' or property_zip = '66855' or property_zip = '66855' or property_zip = '66856' or property_zip = '66857' or property_zip = '66860' or property_zip = '66863' or property_zip = '66864' or property_zip = '66865' or property_zip = '66868' or property_zip = '66870' or property_zip = '66871' or property_zip = '67045' or property_zip = '67045' or property_zip = '67047' or property_zip = '67341' or property_zip = '67357' or property_zip = '64011' or property_zip = '64012' or property_zip = '64013' or property_zip = '64014' or property_zip = '64015' or property_zip = '64016' or property_zip = '64019' or property_zip = '64028' or property_zip = '64029' or property_zip = '64030' or property_zip = '64034' or property_zip = '64040' or property_zip = '64050' or property_zip = '64051' or property_zip = '64052' or property_zip = '64053' or property_zip = '64054' or property_zip = '64055' or property_zip = '64056' or property_zip = '64057' or property_zip = '64058' or property_zip = '64061' or property_zip = '64063' or property_zip = '64064' or property_zip = '64065' or property_zip = '64068' or property_zip = '64069' or property_zip = '64070' or property_zip = '64072' or property_zip = '64075' or property_zip = '64078' or property_zip = '64079' or property_zip = '64080' or property_zip = '64081' or property_zip = '64082' or property_zip = '64083' or property_zip = '64086' or property_zip = '64087' or property_zip = '64088' or property_zip = '64090' or property_zip = '64092' or property_zip = '64101' or property_zip = '64102' or property_zip = '64105' or property_zip = '64106' or property_zip = '64108' or property_zip = '64109' or property_zip = '64110' or property_zip = '64111' or property_zip = '64112' or property_zip = '64113' or property_zip = '64114' or property_zip = '64116' or property_zip = '64117' or property_zip = '64118' or property_zip = '64119' or property_zip = '64120' or property_zip = '64121' or property_zip = '64123' or property_zip = '64124' or property_zip = '64125' or property_zip = '64126' or property_zip = '64127' or property_zip = '64128' or property_zip = '64129' or property_zip = '64130' or property_zip = '64131' or property_zip = '64132' or property_zip = '64133' or property_zip = '64134' or property_zip = '64136' or property_zip = '64137' or property_zip = '64138' or property_zip = '64139' or property_zip = '64141' or property_zip = '64142' or property_zip = '64144' or property_zip = '64145' or property_zip = '64146' or property_zip = '64147' or property_zip = '64148' or property_zip = '64149' or property_zip = '64150' or property_zip = '64151' or property_zip = '64152' or property_zip = '64153' or property_zip = '64154' or property_zip = '64155' or property_zip = '64156' or property_zip = '64157' or property_zip = '64158' or property_zip = '64160' or property_zip = '64161' or property_zip = '64163' or property_zip = '64164' or property_zip = '64165' or property_zip = '64166' or property_zip = '64167' or property_zip = '64168' or property_zip = '64170' or property_zip = '64171' or property_zip = '64172' or property_zip = '64173' or property_zip = '64179' or property_zip = '64180' or property_zip = '64183' or property_zip = '64184' or property_zip = '64185' or property_zip = '64187' or property_zip = '64188' or property_zip = '64189' or property_zip = '64190' or property_zip = '64191' or property_zip = '64192' or property_zip = '64193' or property_zip = '64194' or property_zip = '64195' or property_zip = '64196' or property_zip = '64197' or property_zip = '64198' or property_zip = '64199' or property_zip = '64701' or property_zip = '64720' or property_zip = '64722' or property_zip = '64723' or property_zip = '64724' or property_zip = '64725' or property_zip = '64726' or property_zip = '64728' or property_zip = '64730' or property_zip = '64733' or property_zip = '64734' or property_zip = '64735' or property_zip = '64739' or property_zip = '64741' or property_zip = '64742' or property_zip = '64743' or property_zip = '64744' or property_zip = '64745' or property_zip = '64746' or property_zip = '64747' or property_zip = '64750' or property_zip = '64751' or property_zip = '64752' or property_zip = '64762' or property_zip = '64765' or property_zip = '64766' or property_zip = '64767' or property_zip = '64769' or property_zip = '64770' or property_zip = '64771' or property_zip = '64772' or property_zip = '64777' or property_zip = '64778' or property_zip = '64779' or property_zip = '64780' or property_zip = '64783' or property_zip = '64784' or property_zip = '64788' or property_zip = '64790' or property_zip = '64944' or property_zip = '64999' or property_zip = '66006' or property_zip = '66007' or property_zip = '66010' or property_zip = '66012' or property_zip = '66013' or property_zip = '66014' or property_zip = '66015' or property_zip = '66018' or property_zip = '66019' or property_zip = '66020' or property_zip = '66021' or property_zip = '66025' or property_zip = '66026' or property_zip = '66027' or property_zip = '66030' or property_zip = '66031' or property_zip = '66032' or property_zip = '66033' or property_zip = '66036' or property_zip = '66039' or property_zip = '66040' or property_zip = '66042' or property_zip = '66043' or property_zip = '66044' or property_zip = '66045' or property_zip = '66046' or property_zip = '66047' or property_zip = '66048' or property_zip = '66049' or property_zip = '66050' or property_zip = '66051' or property_zip = '66052' or property_zip = '66053' or property_zip = '66054' or property_zip = '66056' or property_zip = '66060' or property_zip = '66061' or property_zip = '66062' or property_zip = '66063' or property_zip = '66064' or property_zip = '66066' or property_zip = '66067' or property_zip = '66070' or property_zip = '66071' or property_zip = '66072' or property_zip = '66073' or property_zip = '66075' or property_zip = '66076' or property_zip = '66077' or property_zip = '66078' or property_zip = '66079' or property_zip = '66080' or property_zip = '66083' or property_zip = '66085' or property_zip = '66086' or property_zip = '66088' or property_zip = '66091' or property_zip = '66092' or property_zip = '66093' or property_zip = '66095' or property_zip = '66097' or property_zip = '66101' or property_zip = '66102' or property_zip = '66103' or property_zip = '66104' or property_zip = '66105' or property_zip = '66106' or property_zip = '66109' or property_zip = '66110' or property_zip = '66111' or property_zip = '66112' or property_zip = '66113' or property_zip = '66115' or property_zip = '66117' or property_zip = '66118' or property_zip = '66119' or property_zip = '66160' or property_zip = '66201' or property_zip = '66202' or property_zip = '66203' or property_zip = '66204' or property_zip = '66205' or property_zip = '66206' or property_zip = '66207' or property_zip = '66208' or property_zip = '66209' or property_zip = '66210' or property_zip = '66211' or property_zip = '66212' or property_zip = '66213' or property_zip = '66214' or property_zip = '66215' or property_zip = '66216' or property_zip = '66217' or property_zip = '66218' or property_zip = '66219' or property_zip = '66220' or property_zip = '66221' or property_zip = '66222' or property_zip = '66223' or property_zip = '66224' or property_zip = '66225' or property_zip = '66226' or property_zip = '66227' or property_zip = '66250' or property_zip = '66251' or property_zip = '66276' or property_zip = '66279' or property_zip = '66282' or property_zip = '66283' or property_zip = '66285' or property_zip = '66286' or property_zip = '66356' or property_zip = '66402' or property_zip = '66409' or property_zip = '66413' or property_zip = '66414' or property_zip = '66419' or property_zip = '66420' or property_zip = '66423' or property_zip = '66429' or property_zip = '66431' or property_zip = '66440' or property_zip = '66451' or property_zip = '66507' or property_zip = '66509' or property_zip = '66510' or property_zip = '66512' or property_zip = '66523' or property_zip = '66524' or property_zip = '66526' or property_zip = '66528' or property_zip = '66533' or property_zip = '66537' or property_zip = '66539' or property_zip = '66542' or property_zip = '66543' or property_zip = '66546' or property_zip = '66601' or property_zip = '66603' or property_zip = '66604' or property_zip = '66605' or property_zip = '66606' or property_zip = '66607' or property_zip = '66608' or property_zip = '66609' or property_zip = '66610' or property_zip = '66611' or property_zip = '66612' or property_zip = '66614' or property_zip = '66615' or property_zip = '66616' or property_zip = '66617' or property_zip = '66618' or property_zip = '66619' or property_zip = '66620' or property_zip = '66621' or property_zip = '66622' or property_zip = '66624' or property_zip = '66625' or property_zip = '66626' or property_zip = '66628' or property_zip = '66629' or property_zip = '66634' or property_zip = '66636' or property_zip = '66637' or property_zip = '66638' or property_zip = '66642' or property_zip = '66647' or property_zip = '66652' or property_zip = '66653' or property_zip = '66658' or property_zip = '66667' or property_zip = '66675' or property_zip = '66683' or property_zip = '66686' or property_zip = '66692' or property_zip = '66699' or property_zip = '66701' or property_zip = '66710' or property_zip = '66711' or property_zip = '66712' or property_zip = '66714' or property_zip = '66716' or property_zip = '66717' or property_zip = '66720' or property_zip = '66721' or property_zip = '66724' or property_zip = '66727' or property_zip = '66732' or property_zip = '66733' or property_zip = '66734' or property_zip = '66735' or property_zip = '66736' or property_zip = '66738' or property_zip = '66740' or property_zip = '66741' or property_zip = '66742' or property_zip = '66743' or property_zip = '66746' or property_zip = '66747' or property_zip = '66748' or property_zip = '66749' or property_zip = '66751' or property_zip = '66752' or property_zip = '66753' or property_zip = '66754' or property_zip = '66755' or property_zip = '66756' or property_zip = '66757' or property_zip = '66758' or property_zip = '66759' or property_zip = '66761' or property_zip = '66762' or property_zip = '66763' or property_zip = '66767' or property_zip = '66769' or property_zip = '66771' or property_zip = '66772' or property_zip = '66775' or property_zip = '66776' or property_zip = '66777' or property_zip = '66779' or property_zip = '66780' or property_zip = '66783' or property_zip = '66801' or property_zip = '66830' or property_zip = '66833' or property_zip = '66835' or property_zip = '66839' or property_zip = '66852' or property_zip = '66853' or property_zip = '66854' or property_zip = '66855' or property_zip = '66856' or property_zip = '66857' or property_zip = '66860' or property_zip = '66863' or property_zip = '66864' or property_zip = '66865' or property_zip = '66868' or property_zip = '66869' or property_zip = '66870' or property_zip = '66871' or property_zip = '67045' or property_zip = '67047' or property_zip = '67341' or property_zip = '67357') and convert(date,auction_start_date) >= '5/28/2020';
select top 45 * from currentforeclosures.tblAll NOLOCK where state = 'KS '
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 >= '4/29/2020' and (zip ='64012' or zip = '64012' or zip = '64012' or zip = '64013' or zip = '64014' or zip = '64015' or zip = '64015' or zip = '64015' or zip = '64016' or zip = '64019' or zip = '64002' or zip = '64002' or zip = '64011' or zip = '64028' or zip = '64029' or zip = '64029' or zip = '64030' or zip = '64034' or zip = '64034' or zip = '64034' or zip = '64040' or zip = '64050' or zip = '64050' or zip = '64051' or zip = '64052' or zip = '64053' or zip = '64053' or zip = '64054' or zip = '64054' or zip = '64055' or zip = '64056' or zip = '64056' or zip = '64057' or zip = '64058' or zip = '64058' or zip = '64061' or zip = '64063' or zip = '64063' or zip = '64063' or zip = '64063' or zip = '64063' or zip = '64063' or zip = '64064' or zip = '64064' or zip = '64064' or zip = '64064' or zip = '64065' or zip = '64082' or zip = '64082' or zip = '64083' or zip = '64083' or zip = '64086' or zip = '64086' or zip = '64086' or zip = '64088' or zip = '64088' or zip = '64090' or zip = '64092' or zip = '64101' or zip = '64102' or zip = '64105' or zip = '64106' or zip = '64108' or zip = '64117' or zip = '64117' or zip = '64117' or zip = '64118' or zip = '64118' or zip = '64118' or zip = '64118' or zip = '64118' or zip = '64119' or zip = '64119' or zip = '64119' or zip = '64120' or zip = '64121' or zip = '64121' or zip = '64121' or zip = '64123' or zip = '64124' or zip = '64125' or zip = '64126' or zip = '64127' or zip = '64128' or zip = '64129' or zip = '64129' or zip = '64130' or zip = '64065' or zip = '64065' or zip = '64065' or zip = '64068' or zip = '64068' or zip = '64068' or zip = '64069' or zip = '64070' or zip = '64072' or zip = '64075' or zip = '64078' or zip = '64079' or zip = '64079' or zip = '64080' or zip = '64081' or zip = '64081' or zip = '64109' or zip = '64110' or zip = '64111' or zip = '64112' or zip = '64113' or zip = '64114' or zip = '64116' or zip = '64116' or zip = '64116' or zip = '64116' or zip = '64116' or zip = '64116' or zip = '64116' or zip = '64116' or zip = '64116' or zip = '64116' or zip = '64116' or zip = '64116' or zip = '64116' or zip = '64116' or zip = '64116' or zip = '64116' or zip = '64117' or zip = '64117' or zip = '64131' or zip = '64132' or zip = '64133' or zip = '64133' or zip = '64134' or zip = '64136' or zip = '64137' or zip = '64138' or zip = '64138' or zip = '64139' or zip = '64141' or zip = '64144' or zip = '64144' or zip = '64145' or zip = '64146' or zip = '64147' or zip = '64147' or zip = '64148' or zip = '64148' or zip = '64149' or zip = '64150' or zip = '64150' or zip = '64150' or zip = '64163' or zip = '64163' or zip = '64164' or zip = '64165' or zip = '64165' or zip = '64166' or zip = '64166' or zip = '64167' or zip = '64168' or zip = '64168' or zip = '64170' or zip = '64170' or zip = '64170' or zip = '64171' or zip = '64171' or zip = '64171' or zip = '64172' or zip = '64179' or zip = '64180' or zip = '64180' or zip = '64183' or zip = '64183' or zip = '64184' or zip = '64184' or zip = '64187' or zip = '64187' or zip = '64188' or zip = '64188' or zip = '64188' or zip = '64188' or zip = '64190' or zip = '64191' or zip = '64192' or zip = '64193' or zip = '64193' or zip = '64193' or zip = '64195' or zip = '64196' or zip = '64197' or zip = '64197' or zip = '64198' or zip = '64198' or zip = '64199' or zip = '64151' or zip = '64151' or zip = '64151' or zip = '64151' or zip = '64151' or zip = '64151' or zip = '64151' or zip = '64152' or zip = '64152' or zip = '64152' or zip = '64152' or zip = '64153' or zip = '64153' or zip = '64153' or zip = '64154' or zip = '64155' or zip = '64155' or zip = '64156' or zip = '64156' or zip = '64157' or zip = '64158' or zip = '64161' or zip = '64161' or zip = '64161' or zip = '64701' or zip = '64720' or zip = '64722' or zip = '64723' or zip = '64724' or zip = '64725' or zip = '64725' or zip = '64726' or zip = '64728' or zip = '64730' or zip = '64730' or zip = '64733' or zip = '64734' or zip = '64734' or zip = '64735' or zip = '64739' or zip = '64741' or zip = '64742' or zip = '64743' or zip = '64744' or zip = '64744' or zip = '64744' or zip = '64745' or zip = '64746' or zip = '64746' or zip = '64747' or zip = '64747' or zip = '64747' or zip = '64750' or zip = '64752' or zip = '64752' or zip = '64779' or zip = '64780' or zip = '64780' or zip = '64780' or zip = '64783' or zip = '64784' or zip = '64788' or zip = '64788' or zip = '64790' or zip = '64762' or zip = '64765' or zip = '64767' or zip = '64769' or zip = '64770' or zip = '64771' or zip = '64772' or zip = '64772' or zip = '64778' or zip = '64778' or zip = '64999' or zip = '64999' or zip = '64999' or zip = '64999' or zip = '66006' or zip = '66006' or zip = '66007' or zip = '66010' or zip = '66012' or zip = '66012' or zip = '66012' or zip = '66012' or zip = '66012' or zip = '66013' or zip = '66014' or zip = '66015' or zip = '66018' or zip = '66019' or zip = '66019' or zip = '66019' or zip = '66020' or zip = '66021' or zip = '66045' or zip = '66045' or zip = '66046' or zip = '66046' or zip = '66047' or zip = '66047' or zip = '66047' or zip = '66048' or zip = '66049' or zip = '66049' or zip = '66049' or zip = '66050' or zip = '66051' or zip = '66052' or zip = '66053' or zip = '66054' or zip = '66056' or zip = '66060' or zip = '66061' or zip = '66062' or zip = '66062' or zip = '66062' or zip = '66063' or zip = '66025' or zip = '66026' or zip = '66027' or zip = '66027' or zip = '66027' or zip = '66030' or zip = '66031' or zip = '66032' or zip = '66033' or zip = '66036' or zip = '66039' or zip = '66040' or zip = '66040' or zip = '66042' or zip = '66043' or zip = '66043' or zip = '66044' or zip = '66044' or zip = '66045' or zip = '66045' or zip = '66064' or zip = '66066' or zip = '66067' or zip = '66067' or zip = '66070' or zip = '66071' or zip = '66072' or zip = '66073' or zip = '66075' or zip = '66076' or zip = '66077' or zip = '66078' or zip = '66079' or zip = '66080' or zip = '66083' or zip = '66085' or zip = '66085' or zip = '66086' or zip = '66088' or zip = '66091' or zip = '66092' or zip = '66160' or zip = '66160' or zip = '66201' or zip = '66201' or zip = '66201' or zip = '66201' or zip = '66201' or zip = '66202' or zip = '66202' or zip = '66202' or zip = '66202' or zip = '66202' or zip = '66202' or zip = '66202' or zip = '66202' or zip = '66202' or zip = '66202' or zip = '66203' or zip = '66203' or zip = '66203' or zip = '66203' or zip = '66203' or zip = '66203' or zip = '66203' or zip = '66203' or zip = '66204' or zip = '66204' or zip = '66204' or zip = '66204' or zip = '66204' or zip = '66204' or zip = '66204' or zip = '66204' or zip = '66205' or zip = '66205' or zip = '66205' or zip = '66205' or zip = '66205' or zip = '66205' or zip = '66205' or zip = '66205' or zip = '66205' or zip = '66205' or zip = '66206' or zip = '66206' or zip = '66206' or zip = '66206' or zip = '66206' or zip = '66206' or zip = '66206' or zip = '66206' or zip = '66207' or zip = '66207' or zip = '66207' or zip = '66207' or zip = '66207' or zip = '66207' or zip = '66207' or zip = '66207' or zip = '66208' or zip = '66208' or zip = '66208' or zip = '66208' or zip = '66208' or zip = '66208' or zip = '66208' or zip = '66208' or zip = '66209' or zip = '66209' or zip = '66209' or zip = '66209' or zip = '66209' or zip = '66209' or zip = '66210' or zip = '66210' or zip = '66210' or zip = '66210' or zip = '66210' or zip = '66210' or zip = '66211' or zip = '66211' or zip = '66211' or zip = '66211' or zip = '66211' or zip = '66211' or zip = '66212' or zip = '66212' or zip = '66212' or zip = '66212' or zip = '66213' or zip = '66213' or zip = '66213' or zip = '66213' or zip = '66213' or zip = '66213' or zip = '66214' or zip = '66214' or zip = '66214' or zip = '66214' or zip = '66214' or zip = '66214' or zip = '66214' or zip = '66215' or zip = '66215' or zip = '66215' or zip = '66215' or zip = '66215' or zip = '66215' or zip = '66216' or zip = '66216' or zip = '66216' or zip = '66216' or zip = '66216' or zip = '66217' or zip = '66217' or zip = '66217' or zip = '66093' or zip = '66095' or zip = '66097' or zip = '66101' or zip = '66102' or zip = '66103' or zip = '66103' or zip = '66104' or zip = '66105' or zip = '66106' or zip = '66109' or zip = '66110' or zip = '66111' or zip = '66111' or zip = '66112' or zip = '66113' or zip = '66113' or zip = '66115' or zip = '66117' or zip = '66118' or zip = '66119' or zip = '66160' or zip = '66217' or zip = '66217' or zip = '66217' or zip = '66217' or zip = '66218' or zip = '66218' or zip = '66218' or zip = '66218' or zip = '66219' or zip = '66219' or zip = '66219' or zip = '66219' or zip = '66219' or zip = '66220' or zip = '66220' or zip = '66220' or zip = '66220' or zip = '66220' or zip = '66221' or zip = '66221' or zip = '66221' or zip = '66221' or zip = '66221' or zip = '66226' or zip = '66226' or zip = '66226' or zip = '66226' or zip = '66227' or zip = '66227' or zip = '66227' or zip = '66227' or zip = '66227' or zip = '66250' or zip = '66250' or zip = '66250' or zip = '66250' or zip = '66251' or zip = '66251' or zip = '66251' or zip = '66251' or zip = '66251' or zip = '66251' or zip = '66276' or zip = '66276' or zip = '66276' or zip = '66276' or zip = '66409' or zip = '66413' or zip = '66414' or zip = '66419' or zip = '66420' or zip = '66423' or zip = '66429' or zip = '66431' or zip = '66509' or zip = '66510' or zip = '66512' or zip = '66523' or zip = '66524' or zip = '66528' or zip = '66533' or zip = '66601' or zip = '66603' or zip = '66604' or zip = '66605' or zip = '66606' or zip = '66607' or zip = '66608' or zip = '66609' or zip = '66610' or zip = '66611' or zip = '66612' or zip = '66614' or zip = '66615' or zip = '66616' or zip = '66617' or zip = '66618' or zip = '66619' or zip = '66620' or zip = '66620' or zip = '66621' or zip = '66622' or zip = '66622' or zip = '66711' or zip = '66711' or zip = '66711' or zip = '66711' or zip = '66712' or zip = '66714' or zip = '66714' or zip = '66716' or zip = '66716' or zip = '66717' or zip = '66720' or zip = '66720' or zip = '66720' or zip = '66720' or zip = '66724' or zip = '66743' or zip = '66743' or zip = '66743' or zip = '66743' or zip = '66743' or zip = '66746' or zip = '66748' or zip = '66749' or zip = '66749' or zip = '66749' or zip = '66751' or zip = '66753' or zip = '66753' or zip = '66753' or zip = '66753' or zip = '66754' or zip = '66754' or zip = '66755' or zip = '66756' or zip = '66756' or zip = '66756' or zip = '66756' or zip = '66756' or zip = '66757' or zip = '66221' or zip = '66222' or zip = '66222' or zip = '66222' or zip = '66222' or zip = '66223' or zip = '66223' or zip = '66223' or zip = '66223' or zip = '66223' or zip = '66223' or zip = '66224' or zip = '66224' or zip = '66224' or zip = '66224' or zip = '66224' or zip = '66224' or zip = '66224' or zip = '66225' or zip = '66225' or zip = '66225' or zip = '66225' or zip = '66225' or zip = '66282' or zip = '66282' or zip = '66282' or zip = '66282' or zip = '66282' or zip = '66283' or zip = '66283' or zip = '66283' or zip = '66283' or zip = '66283' or zip = '66285' or zip = '66285' or zip = '66285' or zip = '66285' or zip = '66286' or zip = '66286' or zip = '66286' or zip = '66286' or zip = '66402' or zip = '66440' or zip = '66451' or zip = '66507' or zip = '66537' or zip = '66539' or zip = '66542' or zip = '66543' or zip = '66546' or zip = '66624' or zip = '66624' or zip = '66625' or zip = '66625' or zip = '66626' or zip = '66626' or zip = '66628' or zip = '66628' or zip = '66629' or zip = '66629' or zip = '66636' or zip = '66636' or zip = '66647' or zip = '66667' or zip = '66675' or zip = '66683' or zip = '66699' or zip = '66699' or zip = '66701' or zip = '66701' or zip = '66701' or zip = '66710' or zip = '66710' or zip = '66711' or zip = '66732' or zip = '66733' or zip = '66734' or zip = '66735' or zip = '66736' or zip = '66736' or zip = '66736' or zip = '66736' or zip = '66738' or zip = '66738' or zip = '66740' or zip = '66741' or zip = '66741' or zip = '66742' or zip = '66743' or zip = '66743' or zip = '66757' or zip = '66757' or zip = '66758' or zip = '66758' or zip = '66759' or zip = '66761' or zip = '66762' or zip = '66762' or zip = '66762' or zip = '66763' or zip = '66763' or zip = '66767' or zip = '66767' or zip = '66769' or zip = '66771' or zip = '66771' or zip = '66772' or zip = '66775' or zip = '66776' or zip = '66776' or zip = '66777' or zip = '66779' or zip = '66780' or zip = '66780' or zip = '66783' or zip = '66783' or zip = '66783' or zip = '66783' or zip = '66801' or zip = '66830' or zip = '66833' or zip = '66833' or zip = '66835' or zip = '66839' or zip = '66839' or zip = '66845' or zip = '66845' or zip = '66852' or zip = '66853' or zip = '66854' or zip = '66855' or zip = '66855' or zip = '66856' or zip = '66857' or zip = '66860' or zip = '66863' or zip = '66864' or zip = '66865' or zip = '66868' or zip = '66870' or zip = '66871' or zip = '67045' or zip = '67045' or zip = '67047' or zip = '67341' or zip = '67357' or zip = '64011' or zip = '64012' or zip = '64013' or zip = '64014' or zip = '64015' or zip = '64016' or zip = '64019' or zip = '64028' or zip = '64029' or zip = '64030' or zip = '64034' or zip = '64040' or zip = '64050' or zip = '64051' or zip = '64052' or zip = '64053' or zip = '64054' or zip = '64055' or zip = '64056' or zip = '64057' or zip = '64058' or zip = '64061' or zip = '64063' or zip = '64064' or zip = '64065' or zip = '64068' or zip = '64069' or zip = '64070' or zip = '64072' or zip = '64075' or zip = '64078' or zip = '64079' or zip = '64080' or zip = '64081' or zip = '64082' or zip = '64083' or zip = '64086' or zip = '64087' or zip = '64088' or zip = '64090' or zip = '64092' or zip = '64101' or zip = '64102' or zip = '64105' or zip = '64106' or zip = '64108' or zip = '64109' or zip = '64110' or zip = '64111' or zip = '64112' or zip = '64113' or zip = '64114' or zip = '64116' or zip = '64117' or zip = '64118' or zip = '64119' or zip = '64120' or zip = '64121' or zip = '64123' or zip = '64124' or zip = '64125' or zip = '64126' or zip = '64127' or zip = '64128' or zip = '64129' or zip = '64130' or zip = '64131' or zip = '64132' or zip = '64133' or zip = '64134' or zip = '64136' or zip = '64137' or zip = '64138' or zip = '64139' or zip = '64141' or zip = '64142' or zip = '64144' or zip = '64145' or zip = '64146' or zip = '64147' or zip = '64148' or zip = '64149' or zip = '64150' or zip = '64151' or zip = '64152' or zip = '64153' or zip = '64154' or zip = '64155' or zip = '64156' or zip = '64157' or zip = '64158' or zip = '64160' or zip = '64161' or zip = '64163' or zip = '64164' or zip = '64165' or zip = '64166' or zip = '64167' or zip = '64168' or zip = '64170' or zip = '64171' or zip = '64172' or zip = '64173' or zip = '64179' or zip = '64180' or zip = '64183' or zip = '64184' or zip = '64185' or zip = '64187' or zip = '64188' or zip = '64189' or zip = '64190' or zip = '64191' or zip = '64192' or zip = '64193' or zip = '64194' or zip = '64195' or zip = '64196' or zip = '64197' or zip = '64198' or zip = '64199' or zip = '64701' or zip = '64720' or zip = '64722' or zip = '64723' or zip = '64724' or zip = '64725' or zip = '64726' or zip = '64728' or zip = '64730' or zip = '64733' or zip = '64734' or zip = '64735' or zip = '64739' or zip = '64741' or zip = '64742' or zip = '64743' or zip = '64744' or zip = '64745' or zip = '64746' or zip = '64747' or zip = '64750' or zip = '64751' or zip = '64752' or zip = '64762' or zip = '64765' or zip = '64766' or zip = '64767' or zip = '64769' or zip = '64770' or zip = '64771' or zip = '64772' or zip = '64777' or zip = '64778' or zip = '64779' or zip = '64780' or zip = '64783' or zip = '64784' or zip = '64788' or zip = '64790' or zip = '64944' or zip = '64999' or zip = '66006' or zip = '66007' or zip = '66010' or zip = '66012' or zip = '66013' or zip = '66014' or zip = '66015' or zip = '66018' or zip = '66019' or zip = '66020' or zip = '66021' or zip = '66025' or zip = '66026' or zip = '66027' or zip = '66030' or zip = '66031' or zip = '66032' or zip = '66033' or zip = '66036' or zip = '66039' or zip = '66040' or zip = '66042' or zip = '66043' or zip = '66044' or zip = '66045' or zip = '66046' or zip = '66047' or zip = '66048' or zip = '66049' or zip = '66050' or zip = '66051' or zip = '66052' or zip = '66053' or zip = '66054' or zip = '66056' or zip = '66060' or zip = '66061' or zip = '66062' or zip = '66063' or zip = '66064' or zip = '66066' or zip = '66067' or zip = '66070' or zip = '66071' or zip = '66072' or zip = '66073' or zip = '66075' or zip = '66076' or zip = '66077' or zip = '66078' or zip = '66079' or zip = '66080' or zip = '66083' or zip = '66085' or zip = '66086' or zip = '66088' or zip = '66091' or zip = '66092' or zip = '66093' or zip = '66095' or zip = '66097' or zip = '66101' or zip = '66102' or zip = '66103' or zip = '66104' or zip = '66105' or zip = '66106' or zip = '66109' or zip = '66110' or zip = '66111' or zip = '66112' or zip = '66113' or zip = '66115' or zip = '66117' or zip = '66118' or zip = '66119' or zip = '66160' or zip = '66201' or zip = '66202' or zip = '66203' or zip = '66204' or zip = '66205' or zip = '66206' or zip = '66207' or zip = '66208' or zip = '66209' or zip = '66210' or zip = '66211' or zip = '66212' or zip = '66213' or zip = '66214' or zip = '66215' or zip = '66216' or zip = '66217' or zip = '66218' or zip = '66219' or zip = '66220' or zip = '66221' or zip = '66222' or zip = '66223' or zip = '66224' or zip = '66225' or zip = '66226' or zip = '66227' or zip = '66250' or zip = '66251' or zip = '66276' or zip = '66279' or zip = '66282' or zip = '66283' or zip = '66285' or zip = '66286' or zip = '66356' or zip = '66402' or zip = '66409' or zip = '66413' or zip = '66414' or zip = '66419' or zip = '66420' or zip = '66423' or zip = '66429' or zip = '66431' or zip = '66440' or zip = '66451' or zip = '66507' or zip = '66509' or zip = '66510' or zip = '66512' or zip = '66523' or zip = '66524' or zip = '66526' or zip = '66528' or zip = '66533' or zip = '66537' or zip = '66539' or zip = '66542' or zip = '66543' or zip = '66546' or zip = '66601' or zip = '66603' or zip = '66604' or zip = '66605' or zip = '66606' or zip = '66607' or zip = '66608' or zip = '66609' or zip = '66610' or zip = '66611' or zip = '66612' or zip = '66614' or zip = '66615' or zip = '66616' or zip = '66617' or zip = '66618' or zip = '66619' or zip = '66620' or zip = '66621' or zip = '66622' or zip = '66624' or zip = '66625' or zip = '66626' or zip = '66628' or zip = '66629' or zip = '66634' or zip = '66636' or zip = '66637' or zip = '66638' or zip = '66642' or zip = '66647' or zip = '66652' or zip = '66653' or zip = '66658' or zip = '66667' or zip = '66675' or zip = '66683' or zip = '66686' or zip = '66692' or zip = '66699' or zip = '66701' or zip = '66710' or zip = '66711' or zip = '66712' or zip = '66714' or zip = '66716' or zip = '66717' or zip = '66720' or zip = '66721' or zip = '66724' or zip = '66727' or zip = '66732' or zip = '66733' or zip = '66734' or zip = '66735' or zip = '66736' or zip = '66738' or zip = '66740' or zip = '66741' or zip = '66742' or zip = '66743' or zip = '66746' or zip = '66747' or zip = '66748' or zip = '66749' or zip = '66751' or zip = '66752' or zip = '66753' or zip = '66754' or zip = '66755' or zip = '66756' or zip = '66757' or zip = '66758' or zip = '66759' or zip = '66761' or zip = '66762' or zip = '66763' or zip = '66767' or zip = '66769' or zip = '66771' or zip = '66772' or zip = '66775' or zip = '66776' or zip = '66777' or zip = '66779' or zip = '66780' or zip = '66783' or zip = '66801' or zip = '66830' or zip = '66833' or zip = '66835' or zip = '66839' or zip = '66852' or zip = '66853' or zip = '66854' or zip = '66855' or zip = '66856' or zip = '66857' or zip = '66860' or zip = '66863' or zip = '66864' or zip = '66865' or zip = '66868' or zip = '66869' or zip = '66870' or zip = '66871' or zip = '67045' or zip = '67047' or zip = '67341' or zip = '67357')
select top 45 * from currentforeclosures.tblWholesaleDeals NOLOCK where len(image_name1) > 2 and image_name1 <> 'no_pic2.jpg' and date_posted >= '8/3/2019' and 1=1 and state = 'KS' and city = 'GREELEY ' and state = 'KS ' and asking_price >= 0 and asking_price <= 100000000
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();
nwProcess: