CUBA, KS Investment Properties - Happy Home Investor
 

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



CUBA 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 176 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!

Great Profit Potential
Junction City KS
 
 
Overall Profit Summary
Purchase Price: $11,379
Estimated Repairs$15,040
Sales Price After Remodel$40,297
Total Profit Estimate$11,312
View Details

Asking $15,000
 *  Price Reduced by $9,000 on 12/2/2019.
 *  Originally Listed on 3/11/2019.
 *  Deal Rating of 7.5/10

 Reduced By $9,000
 Short Sale!
Great Deal-Score of 7!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 7! 
Great Profit Potential
Junction City KS
 
 
Overall Profit Summary
Purchase Price: $14,894
Estimated Repairs$15,471
Sales Price After Remodel$46,101
Total Profit Estimate$12,850
View Details

Asking $19,900
 *  Price Reduced by $10,100 on 12/2/2019.
 *  Originally Listed on 6/28/2018.
 *  Deal Rating of 6.9/10

 $10,600 Below Appraisal
 Reduced By $10,100
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!
Clay Center KS
 
 
Overall Profit Summary
Purchase Price: $21,834
Estimated Repairs$23,038
Sales Price After Remodel$72,477
Total Profit Estimate$12,099
View Details

Asking $26,400
 *  Listed 26 Days Ago
 *  Originally Listed on 5/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! 
Use the Tabs at the Top of This Page to Navigate the different types of properties!
Motivated Seller
Wamego KS
 
 
Overall Profit Summary
Purchase Price: $23,157
Estimated Repairs$18,657
Sales Price After Remodel$65,314
Total Profit Estimate$10,579
View Details

Asking $28,000
 *  Listed 39 Days Ago
 *  Originally Listed on 4/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! 
Motivated Seller
Beatrice NE
 
 
Overall Profit Summary
Purchase Price: $23,123
Estimated Repairs$10,973
Sales Price After Remodel$48,906
Total Profit Estimate$11,906
View Details

Asking $29,700
 *  Listed 109 Days Ago
 *  Originally Listed on 2/10/2020.
 *  Great Deal Rating of 8.7/10

 $16,400 Below Appraisal
 $5,120 Below Tax Val
Great Deal-Score of 10.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Very High Deal Score of 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 --->





Priced Under Tax-Value!
Junction City KS
 
 
Overall Profit Summary
Purchase Price: $24,942
Estimated Repairs$14,831
Sales Price After Remodel$55,450
Total Profit Estimate$12,316
View Details

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

 $14,900 Below Appraisal
Great Deal-Score of 6.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 6.5! 
Investor-Deal!
Junction City KS
 
 
Overall Profit Summary
Purchase Price: $29,113
Estimated Repairs$15,179
Sales Price After Remodel$61,221
Total Profit Estimate$13,253
View Details

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

 $4,700 Below Appraisal
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
Junction City KS
 
 
Overall Profit Summary
Purchase Price: $29,196
Estimated Repairs$11,031
Sales Price After Remodel$54,514
Total Profit Estimate$11,085
View Details

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

 $5,000 Below Appraisal
 Fix & Flip!
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
Junction City KS
 
 
Overall Profit Summary
Purchase Price: $28,283
Estimated Repairs$10,888
Sales Price After Remodel$55,215
Total Profit Estimate$12,809
View Details

Asking $35,900
 *  Listed 67 Days Ago
 *  Originally Listed on 3/23/2020.
 *  Deal Rating of 7.6/10

 $17,200 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! 
Make Offer. High Profit.
Salina KS
 
 
Overall Profit Summary
Purchase Price: $29,897
Estimated Repairs$28,709
Sales Price After Remodel$94,419
Total Profit Estimate$16,265
View Details

Asking $37,000
 *  Listed 77 Days Ago
 *  Originally Listed on 3/13/2020.
 *  Deal Rating of 7.6/10

 $25,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! 
Use the Tabs at the Top of This Page to Navigate the different types of properties!
Motivated Seller
Beatrice NE
 
 
Overall Profit Summary
Purchase Price: $31,014
Estimated Repairs$18,751
Sales Price After Remodel$75,003
Total Profit Estimate$11,736
View Details

Asking $37,500
 *  Listed 25 Days Ago
 *  Originally Listed on 5/4/2020.
 *  Deal Rating of 7.6/10

 $12,400 Below Appraisal
Great Deal-Score of 7.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 7.5! 
Motivated Seller
Beatrice NE
 
 
Overall Profit Summary
Purchase Price: $32,240
Estimated Repairs$24,494
Sales Price After Remodel$88,887
Total Profit Estimate$15,018
View Details

Asking $39,900
 *  Listed 65 Days Ago
 *  Originally Listed on 3/25/2020.
 *  Deal Rating of 6.9/10

 $11,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! 
Priced Under Tax-Value!
Clay Center KS
 
 
Overall Profit Summary
Purchase Price: $34,223
Estimated Repairs$22,161
Sales Price After Remodel$84,321
Total Profit Estimate$12,220
View Details

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

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

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Very High Deal Score of 11.5! 
Fix & Flip Investor-Deal
Junction City KS
 
 
Overall Profit Summary
Purchase Price: $34,653
Estimated Repairs$14,390
Sales Price After Remodel$70,680
Total Profit Estimate$10,554
View Details

Asking $41,900
 *  Listed 21 Days Ago
 *  Originally Listed on 5/8/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!
Junction City KS
 
 
Overall Profit Summary
Purchase Price: $34,061
Estimated Repairs$12,744
Sales Price After Remodel$70,387
Total Profit Estimate$13,339
View Details

Asking $44,900
 *  Price Reduced by $5,100 on 12/11/2019.
 *  Originally Listed on 10/23/2019.
 *  Deal Rating of 6.9/10

 Reduced By $5,100
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 --->





Fix & Flip Investor-Deal
Junction City KS
 
 
Overall Profit Summary
Purchase Price: $35,854
Estimated Repairs$11,612
Sales Price After Remodel$68,123
Total Profit Estimate$11,105
View Details

Asking $44,900
 *  175 Days on Market
 *  Originally Listed on 12/6/2019.
 *  Deal Rating of 6.9/10

 $10,400 Below Appraisal
Great Deal-Score of 5.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5.5! 
Investor-Deal!
Salina KS
 
 
Overall Profit Summary
Purchase Price: $35,654
Estimated Repairs$18,711
Sales Price After Remodel$84,422
Total Profit Estimate$16,058
View Details

Asking $47,000
 *  Price Reduced by $3,000 on 11/21/2019.
 *  Originally Listed on 11/12/2019.
 *  Great Deal Rating of 8.4/10

 $1,800 Below Appraisal
 Reduced By $3,000
 Flip - Needs Repairs!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 High Deal Score of 9.5! 
Great Profit Potential
Junction City KS
 
 
Overall Profit Summary
Purchase Price: $38,786
Estimated Repairs$47,655
Sales Price After Remodel$143,311
Total Profit Estimate$25,160
View Details

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

 $21,000 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! 
Investor-Deal!
Wamego KS
 
 
Overall Profit Summary
Purchase Price: $40,194
Estimated Repairs$15,261
Sales Price After Remodel$79,123
Total Profit Estimate$11,685
View Details

Asking $48,600
 *  Listed 39 Days Ago
 *  Originally Listed on 4/20/2020.
 *  Deal Rating of 7.6/10

 $16,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
Salina KS
 
 
Overall Profit Summary
Purchase Price: $40,402
Estimated Repairs$23,239
Sales Price After Remodel$96,477
Total Profit Estimate$15,911
View Details

Asking $50,000
 *  Listed 94 Days Ago
 *  Originally Listed on 2/25/2020.
 *  Deal Rating of 7.6/10

 $14,500 Below Appraisal
Great Deal-Score of 7.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 7.5! 
Use the Tabs at the Top of This Page to Navigate the different types of properties!
Motivated Seller
Blue Springs NE
 
 
Overall Profit Summary
Purchase Price: $40,877
Estimated Repairs$24,761
Sales Price After Remodel$99,523
Total Profit Estimate$16,030
View Details

Asking $50,000
 *  Listed 58 Days Ago
 *  Originally Listed on 4/1/2020.
 *  Deal Rating of 6.9/10

 $6,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! 
Fix & Flip Investor-Deal
Salina KS
 
 
Overall Profit Summary
Purchase Price: $44,442
Estimated Repairs$18,118
Sales Price After Remodel$91,236
Total Profit Estimate$14,599
View Details

Asking $55,000
 *  Listed 94 Days Ago
 *  Originally Listed on 2/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! 
Motivated Seller
Junction City KS
 
 
Overall Profit Summary
Purchase Price: $43,164
Estimated Repairs$14,199
Sales Price After Remodel$85,298
Total Profit Estimate$16,144
View Details

Asking $56,900
 *  Price Reduced by $4,000 on 12/13/2018.
 *  Originally Listed on 11/6/2019.
 *  Deal Rating of 7.6/10

 $7,100 Below Appraisal
 Reduced By $4,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!
Junction City KS
 
 
Overall Profit Summary
Purchase Price: $44,139
Estimated Repairs$21,958
Sales Price After Remodel$101,417
Total Profit Estimate$18,763
View Details

Asking $57,500
 *  Price Reduced by $14,500 on 12/2/2019.
 *  Originally Listed on 6/20/2018.
 *  Deal Rating of 7.6/10

 $1,500 Below Appraisal
 Reduced By $14,500
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
Beatrice NE
 
 
Overall Profit Summary
Purchase Price: $47,832
Estimated Repairs$11,550
Sales Price After Remodel$83,000
Total Profit Estimate$13,278
View Details

Asking $59,900
 *  Listed 109 Days Ago
 *  Originally Listed on 2/10/2020.
 *  Deal Rating of 7.6/10

 $41,700 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
Ogden KS
 
 
Overall Profit Summary
Purchase Price: $48,482
Estimated Repairs$6,393
Sales Price After Remodel$72,898
Total Profit Estimate$13,983
View Details

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

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

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5! 
Fix & Flip Investor-Deal
Junction City KS
 
 
Overall Profit Summary
Purchase Price: $51,904
Estimated Repairs$18,981
Sales Price After Remodel$102,961
Total Profit Estimate$16,923
View Details

Asking $65,000
 *  Listed 129 Days Ago
 *  Originally Listed on 1/21/2020.
 *  Deal Rating of 7.3/10

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

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 6.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 --->





Make Offer. High Profit.
Beatrice NE
 
 
Overall Profit Summary
Purchase Price: $53,758
Estimated Repairs$37,899
Sales Price After Remodel$140,799
Total Profit Estimate$22,448
View Details

Asking $65,000
 *  Listed 36 Days Ago
 *  Originally Listed on 4/23/2020.
 *  Deal Rating of 7.6/10

 $22,400 Below Appraisal
 Handyman Special!
Great Deal-Score of 7.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 7.5! 
Investor-Deal!
Salina KS
 
 
Overall Profit Summary
Purchase Price: $51,351
Estimated Repairs$9,068
Sales Price After Remodel$84,135
Total Profit Estimate$14,555
View Details

Asking $66,000
 *  Price Reduced by $5,500 on 2/12/2020.
 *  Originally Listed on 2/12/2020.
 *  Deal Rating of 6.7/10

 $3,300 Below Appraisal
 Reduced By $5,500
Great Deal-Score of 5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5! 
Make Offer. High Profit.
Junction City KS
 
 
Overall Profit Summary
Purchase Price: $53,421
Estimated Repairs$21,622
Sales Price After Remodel$110,143
Total Profit Estimate$18,232
View Details

Asking $66,900
 *  Listed 126 Days Ago
 *  Originally Listed on 1/24/2020.
 *  Deal Rating of 6.9/10

 $11,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
Junction City KS
 
 
Overall Profit Summary
Purchase Price: $55,817
Estimated Repairs$20,775
Sales Price After Remodel$111,449
Total Profit Estimate$18,341
View Details

Asking $69,900
 *  Listed 148 Days Ago
 *  Originally Listed on 1/2/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!
Ogden KS
 
 
Overall Profit Summary
Purchase Price: $56,481
Estimated Repairs$13,552
Sales Price After Remodel$97,004
Total Profit Estimate$14,859
View Details

Asking $69,900
 *  Listed 67 Days Ago
 *  Originally Listed on 3/23/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
Salina KS
 
 
Overall Profit Summary
Purchase Price: $53,734
Estimated Repairs$25,287
Sales Price After Remodel$120,574
Total Profit Estimate$22,278
View Details

Asking $70,000
 *  Price Reduced by $21,500 on 12/1/2019.
 *  Originally Listed on 9/26/2018.
 *  Deal Rating of 6.9/10

 $21,200 Below Appraisal
 Reduced By $21,500
Great Deal-Score of 5.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5.5! 
Motivated Seller
Junction City KS
 
 
Overall Profit Summary
Purchase Price: $58,178
Estimated Repairs$15,665
Sales Price After Remodel$103,330
Total Profit Estimate$15,971
View Details

Asking $72,000
 *  Listed 99 Days Ago
 *  Originally Listed on 2/20/2020.
 *  Deal Rating of 6.7/10

 $31,400 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.
Riley KS
 
 
Overall Profit Summary
Purchase Price: $63,312
Estimated Repairs$9,325
Sales Price After Remodel$92,273
Total Profit Estimate$14,486
View Details

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

Great Deal-Score of 6!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 6! 
Investor-Deal!
Salina KS
 
 
Overall Profit Summary
Purchase Price: $56,136
Estimated Repairs$27,685
Sales Price After Remodel$129,371
Total Profit Estimate$24,591
View Details

Asking $74,000
 *  Price Reduced by $4,500 on 11/21/2019.
 *  Originally Listed on 10/21/2019.
 *  Deal Rating of 7.3/10

 $100 Below Appraisal
 Reduced By $4,500
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
Junction City KS
 
 
Overall Profit Summary
Purchase Price: $61,946
Estimated Repairs$22,478
Sales Price After Remodel$119,856
Total Profit Estimate$17,601
View Details

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

 $29,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! 
Fix & Flip Investor-Deal
Salina KS
 
 
Overall Profit Summary
Purchase Price: $60,602
Estimated Repairs$35,043
Sales Price After Remodel$145,085
Total Profit Estimate$23,939
View Details

Asking $75,000
 *  Listed 65 Days Ago
 *  Originally Listed on 3/25/2020.
 *  Deal Rating of 7.6/10

 $32,800 Below Appraisal
Great Deal-Score of 7.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 7.5! 
Motivated Seller
Ogden KS
 
 
Overall Profit Summary
Purchase Price: $66,032
Estimated Repairs$8,036
Sales Price After Remodel$94,821
Total Profit Estimate$11,521
View Details

Asking $78,750
 *  Listed 44 Days Ago
 *  Originally Listed on 4/15/2020.
 *  Deal Rating of 6.4/10

 $29,350 Below Appraisal
Great Deal-Score of 4!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 4! 

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 --->





Great Profit Potential
Junction City KS
 
 
Overall Profit Summary
Purchase Price: $64,562
Estimated Repairs$13,891
Sales Price After Remodel$107,682
Total Profit Estimate$16,361
View Details

Asking $79,900
 *  Listed 73 Days Ago
 *  Originally Listed on 3/17/2020.
 *  Deal Rating of 6.7/10

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

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5! 
Priced Under Tax-Value!
Salina KS
 
 
Overall Profit Summary
Purchase Price: $66,081
Estimated Repairs$12,819
Sales Price After Remodel$105,538
Total Profit Estimate$14,424
View Details

Asking $79,900
 *  Listed 31 Days Ago
 *  Originally Listed on 4/28/2020.
 *  Deal Rating of 7.3/10

 $3,300 Below Appraisal
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.
Salina KS
 
 
Overall Profit Summary
Purchase Price: $60,688
Estimated Repairs$12,409
Sales Price After Remodel$104,819
Total Profit Estimate$19,752
View Details

Asking $80,000
 *  Price Reduced by $20,000 on 12/5/2019.
 *  Originally Listed on 10/15/2019.
 *  Deal Rating of 6.9/10

 Reduced By $20,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!
Junction City KS
 
 
Overall Profit Summary
Purchase Price: $67,471
Estimated Repairs$27,458
Sales Price After Remodel$138,416
Total Profit Estimate$22,146
View Details

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

 $9,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! 
Great Profit Potential
Junction City KS
 
 
Overall Profit Summary
Purchase Price: $70,216
Estimated Repairs$26,553
Sales Price After Remodel$138,005
Total Profit Estimate$20,370
View Details

Asking $84,900
 *  Listed 37 Days Ago
 *  Originally Listed on 4/22/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! 
Priced Under Tax-Value!
Manhattan KS
 
 
Overall Profit Summary
Purchase Price: $64,481
Estimated Repairs$13,164
Sales Price After Remodel$111,328
Total Profit Estimate$20,978
View Details

Asking $85,000
 *  Price Reduced by $5,000 on 12/1/2019.
 *  Originally Listed on 10/26/2019.
 *  Deal Rating of 6.9/10

 $2,800 Below Appraisal
 Reduced By $5,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
Manhattan KS
 
 
Overall Profit Summary
Purchase Price: $64,481
Estimated Repairs$21,541
Sales Price After Remodel$128,082
Total Profit Estimate$24,245
View Details

Asking $85,000
 *  Price Reduced by $25,000 on 1/23/2020.
 *  Originally Listed on 9/15/2019.
 *  Deal Rating of 7.6/10

 Reduced By $25,000
Great Deal-Score of 7.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 7.5! 
Investor-Deal!
Manhattan KS
 
 
Overall Profit Summary
Purchase Price: $72,101
Estimated Repairs$7,375
Sales Price After Remodel$99,750
Total Profit Estimate$11,100
View Details

Asking $85,000
 *  Listed 37 Days Ago
 *  Originally Listed on 4/22/2020.
 *  Deal Rating of 7.1/10

 $14,100 Below Appraisal
Great Deal-Score of 6!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 6! 
Great Profit Potential
Junction City KS
 
 
Overall Profit Summary
Purchase Price: $71,915
Estimated Repairs$23,260
Sales Price After Remodel$135,520
Total Profit Estimate$21,262
View Details

Asking $89,000
 *  Listed 72 Days Ago
 *  Originally Listed on 3/18/2020.
 *  Deal Rating of 6.7/10

 $38,800 Below Appraisal
Great Deal-Score of 5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5! 
Great Profit Potential
Ayr NE
 
 
Overall Profit Summary
Purchase Price: $72,761
Estimated Repairs$39,826
Sales Price After Remodel$168,653
Total Profit Estimate$26,876
View Details

Asking $89,000
 *  Listed 60 Days Ago
 *  Originally Listed on 3/30/2020.
 *  Deal Rating of 6.9/10

 $32,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! 
Make Offer. High Profit.
Junction City KS
 
 
Overall Profit Summary
Purchase Price: $69,947
Estimated Repairs$9,818
Sales Price After Remodel$109,535
Total Profit Estimate$18,838
View Details

Asking $89,900
 *  Price Reduced by $10,000 on 12/2/2019.
 *  Originally Listed on 4/3/2019.
 *  Deal Rating of 6.4/10

 $8,000 Below Appraisal
 Reduced By $10,000
Great Deal-Score of 4!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 4! 
Great Profit Potential
Manhattan KS
 
 
Overall Profit Summary
Purchase Price: $69,947
Estimated Repairs$18,700
Sales Price After Remodel$127,300
Total Profit Estimate$22,302
View Details

Asking $89,900
 *  Price Reduced by $30,000 on 12/7/2019.
 *  Originally Listed on 11/6/2019.
 *  Deal Rating of 7.5/10

 Reduced By $30,000
 Motivated Seller!
Great Deal-Score of 7!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 7! 
Motivated Seller
Clay Center KS
 
 
Overall Profit Summary
Purchase Price: $76,005
Estimated Repairs$21,098
Sales Price After Remodel$134,096
Total Profit Estimate$19,068
View Details

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

 $15,800 Below Appraisal
 $5,800 Below Tax Val
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
Manhattan KS
 
 
Overall Profit Summary
Purchase Price: $73,464
Estimated Repairs$11,202
Sales Price After Remodel$114,404
Total Profit Estimate$17,844
View Details

Asking $92,000
 *  194 Days on Market
 *  Originally Listed on 11/17/2019.
 *  Deal Rating of 7.3/10

 $800 Below Appraisal
Great Deal-Score of 6.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 6.5! 
Motivated Seller
Manhattan KS
 
 
Overall Profit Summary
Purchase Price: $80,423
Estimated Repairs$11,202
Sales Price After Remodel$116,404
Total Profit Estimate$12,776
View Details

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

 $4,500 Below Appraisal
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.
Junction City KS
 
 
Overall Profit Summary
Purchase Price: $73,205
Estimated Repairs$11,550
Sales Price After Remodel$119,600
Total Profit Estimate$22,492
View Details

Asking $96,500
 *  Price Reduced by $3,400 on 12/2/2019.
 *  Originally Listed on 5/29/2019.
 *  Deal Rating of 7.1/10

 Reduced By $3,400
Great Deal-Score of 6!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 6! 
Great Profit Potential
Salina KS
 
 
Overall Profit Summary
Purchase Price: $74,460
Estimated Repairs$20,005
Sales Price After Remodel$137,009
Total Profit Estimate$25,007
View Details

Asking $97,000
 *  Price Reduced by $2,900 on 12/1/2019.
 *  Originally Listed on 2/20/2020.
 *  Deal Rating of 7.6/10

 Reduced By $2,900
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
Junction City KS
 
 
Overall Profit Summary
Purchase Price: $79,995
Estimated Repairs$15,720
Sales Price After Remodel$130,441
Total Profit Estimate$19,691
View Details

Asking $99,000
 *  Listed 72 Days Ago
 *  Originally Listed on 3/18/2020.
 *  Deal Rating of 6.7/10

 $17,100 Below Appraisal
Great Deal-Score of 5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5! 
Investor-Deal!
Junction City KS
 
 
Overall Profit Summary
Purchase Price: $80,722
Estimated Repairs$18,166
Sales Price After Remodel$136,232
Total Profit Estimate$20,768
View Details

Asking $99,900
 *  Listed 99 Days Ago
 *  Originally Listed on 2/20/2020.
 *  Deal Rating of 6.9/10

 $17,100 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.
Junction City KS
 
 
Overall Profit Summary
Purchase Price: $87,838
Estimated Repairs$34,212
Sales Price After Remodel$178,424
Total Profit Estimate$29,455
View Details

Asking $110,000
 *  178 Days on Market
 *  Originally Listed on 12/3/2019.
 *  Deal Rating of 6.9/10

 $48,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
Salina KS
 
 
Overall Profit Summary
Purchase Price: $92,820
Estimated Repairs$12,137
Sales Price After Remodel$136,274
Total Profit Estimate$17,753
View Details

Asking $112,000
 *  Listed 88 Days Ago
 *  Originally Listed on 3/2/2020.
 *  Deal Rating of 6.7/10

 $55,500 Below Appraisal
Great Deal-Score of 5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5! 
Fix & Flip Investor-Deal
Manhattan KS
 
 
Overall Profit Summary
Purchase Price: $95,004
Estimated Repairs$10,877
Sales Price After Remodel$133,754
Total Profit Estimate$15,078
View Details

Asking $112,000
 *  Listed 24 Days Ago
 *  Originally Listed on 5/5/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! 
Make Offer. High Profit.
Manhattan KS
 
 
Overall Profit Summary
Purchase Price: $87,239
Estimated Repairs$26,543
Sales Price After Remodel$168,086
Total Profit Estimate$31,788
View Details

Asking $115,000
 *  Price Reduced by $7,000 on 12/1/2019.
 *  Originally Listed on 10/8/2019.
 *  Deal Rating of 7.6/10

 $26,100 Below Appraisal
 Reduced By $7,000
Great Deal-Score of 7.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 7.5! 
Motivated Seller
Salina KS
 
 
Overall Profit Summary
Purchase Price: $98,390
Estimated Repairs$20,845
Sales Price After Remodel$156,690
Total Profit Estimate$18,415
View Details

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

 $16,700 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!
Hastings NE
 
 
Overall Profit Summary
Purchase Price: $99,245
Estimated Repairs$16,826
Sales Price After Remodel$153,651
Total Profit Estimate$20,717
View Details

Asking $120,000
 *  Listed 36 Days Ago
 *  Originally Listed on 4/23/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! 
Priced Under Tax-Value!
Salina KS
 
 
Overall Profit Summary
Purchase Price: $95,823
Estimated Repairs$30,210
Sales Price After Remodel$180,421
Total Profit Estimate$29,359
View Details

Asking $120,000
 *  170 Days on Market
 *  Originally Listed on 12/11/2019.
 *  Deal Rating of 6.9/10

 $87,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
Beatrice NE
 
 
Overall Profit Summary
Purchase Price: $96,422
Estimated Repairs$13,200
Sales Price After Remodel$147,150
Total Profit Estimate$22,835
View Details

Asking $120,750
 *  Listed 109 Days Ago
 *  Originally Listed on 2/10/2020.
 *  High Deal Rating of 9.3/10

 $46,950 Below Appraisal
 $25,300 Below Tax Val
 Flip - Needs Repairs!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Very High Deal Score of 12! 
Make Offer. High Profit.
Manhattan KS
 
 
Overall Profit Summary
Purchase Price: $107,011
Estimated Repairs$16,065
Sales Price After Remodel$154,081
Total Profit Estimate$14,497
View Details

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

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

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 7! 
Priced Under Tax-Value!
Wakefield KS
 
 
Overall Profit Summary
Purchase Price: $102,471
Estimated Repairs$18,220
Sales Price After Remodel$160,339
Total Profit Estimate$21,720
View Details

Asking $123,900
 *  Listed 24 Days Ago
 *  Originally Listed on 5/5/2020.
 *  Great Deal Rating of 8.2/10

 $4,600 Below Appraisal
 Motivated Seller!
Great Deal-Score of 9!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Great Deal Score of 9! 
Investor-Deal!
Milford KS
 
 
Overall Profit Summary
Purchase Price: $103,380
Estimated Repairs$30,747
Sales Price After Remodel$186,494
Total Profit Estimate$26,736
View Details

Asking $125,000
 *  Listed 29 Days Ago
 *  Originally Listed on 4/30/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
Manhattan KS
 
 
Overall Profit Summary
Purchase Price: $99,816
Estimated Repairs$35,878
Sales Price After Remodel$196,755
Total Profit Estimate$32,302
View Details

Asking $125,000
 *  Listed 141 Days Ago
 *  Originally Listed on 1/9/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! 

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 --->





Investor-Deal!
Junction City KS
 
 
Overall Profit Summary
Purchase Price: $104,423
Estimated Repairs$12,580
Sales Price After Remodel$152,661
Total Profit Estimate$20,971
View Details

Asking $127,500
 *  189 Days on Market
 *  Originally Listed on 11/22/2019.
 *  Deal Rating of 7.5/10

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

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 7! 
Priced Under Tax-Value!
Manhattan KS
 
 
Overall Profit Summary
Purchase Price: $110,368
Estimated Repairs$23,816
Sales Price After Remodel$176,633
Total Profit Estimate$20,826
View Details

Asking $129,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! 
Great Profit Potential
Manhattan KS
 
 
Overall Profit Summary
Purchase Price: $101,069
Estimated Repairs$26,583
Sales Price After Remodel$183,066
Total Profit Estimate$32,054
View Details

Asking $129,900
 *  Price Reduced by $5,000 on 5/23/2020 4:08:20 AM.
 *  Originally Listed on 11/22/2019.
 *  Deal Rating of 7.1/10

 $1,700 Below Appraisal
 Reduced By $5,000
 Investor-Special!!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 6! 
Great Profit Potential
Manhattan KS
 
 
Overall Profit Summary
Purchase Price: $103,728
Estimated Repairs$17,792
Sales Price After Remodel$165,484
Total Profit Estimate$25,966
View Details

Asking $129,900
 *  Listed 148 Days Ago
 *  Originally Listed on 1/2/2020.
 *  Deal Rating of 7.3/10

 $10,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! 
Motivated Seller
Manhattan KS
 
 
Overall Profit Summary
Purchase Price: $111,223
Estimated Repairs$17,213
Sales Price After Remodel$164,426
Total Profit Estimate$18,340
View Details

Asking $130,000
 *  Listed 17 Days Ago
 *  Originally Listed on 5/12/2020.
 *  Deal Rating of 7.3/10

 $1,300 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!
Junction City KS
 
 
Overall Profit Summary
Purchase Price: $100,514
Estimated Repairs$38,434
Sales Price After Remodel$209,368
Total Profit Estimate$39,687
View Details

Asking $132,500
 *  Price Reduced by $2,500 on 1/30/2020.
 *  Originally Listed on 1/29/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! 
Investor-Deal!
Manhattan KS
 
 
Overall Profit Summary
Purchase Price: $107,801
Estimated Repairs$96,800
Sales Price After Remodel$328,600
Total Profit Estimate$57,526
View Details

Asking $135,000
 *  Listed 119 Days Ago
 *  Originally Listed on 1/31/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! 
Make Offer. High Profit.
Salina KS
 
 
Overall Profit Summary
Purchase Price: $107,084
Estimated Repairs$23,570
Sales Price After Remodel$186,640
Total Profit Estimate$33,935
View Details

Asking $139,500
 *  Price Reduced by $6,500 on 3/12/2020.
 *  Originally Listed on 3/12/2020.
 *  Great Deal Rating of 8.4/10

 $1,200 Below Appraisal
 Reduced By $6,500
 Flip - Needs Repairs!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 High Deal Score of 9.5! 
Make Offer. High Profit.
Junction City KS
 
 
Overall Profit Summary
Purchase Price: $115,942
Estimated Repairs$14,177
Sales Price After Remodel$168,254
Total Profit Estimate$21,792
View Details

Asking $139,900
 *  Listed 66 Days Ago
 *  Originally Listed on 3/24/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!
Hastings NE
 
 
Overall Profit Summary
Purchase Price: $115,745
Estimated Repairs$15,242
Sales Price After Remodel$170,433
Total Profit Estimate$22,452
View Details

Asking $139,950
 *  Listed 24 Days Ago
 *  Originally Listed on 5/5/2020.
 *  Deal Rating of 6.9/10

 $54,750 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
Manhattan KS
 
 
Overall Profit Summary
Purchase Price: $117,440
Estimated Repairs$36,029
Sales Price After Remodel$214,059
Total Profit Estimate$30,801
View Details

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

 $17,100 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
Manhattan KS
 
 
Overall Profit Summary
Purchase Price: $114,988
Estimated Repairs$31,687
Sales Price After Remodel$207,373
Total Profit Estimate$33,450
View Details

Asking $144,000
 *  Listed 147 Days Ago
 *  Originally Listed on 1/3/2020.
 *  Deal Rating of 7.6/10

 $16,700 Below Appraisal
 Investor-Special!!
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
Manhattan KS
 
 
Overall Profit Summary
Purchase Price: $109,996
Estimated Repairs$17,065
Sales Price After Remodel$179,129
Total Profit Estimate$33,683
View Details

Asking $144,999
 *  Price Reduced by $4,001 on 1/15/2020.
 *  Originally Listed on 1/14/2020.
 *  Deal Rating of 7.3/10

 $1,501 Below Appraisal
 Reduced By $4,001
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
Manhattan KS
 
 
Overall Profit Summary
Purchase Price: $120,583
Estimated Repairs$26,083
Sales Price After Remodel$197,966
Total Profit Estimate$27,370
View Details

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

 $33,000 Below Appraisal
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!
Manhattan KS
 
 
Overall Profit Summary
Purchase Price: $118,182
Estimated Repairs$13,200
Sales Price After Remodel$174,400
Total Profit Estimate$26,826
View Details

Asking $148,000
 *  167 Days on Market
 *  Originally Listed on 12/14/2019.
 *  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
Wakefield KS
 
 
Overall Profit Summary
Purchase Price: $127,393
Estimated Repairs$41,705
Sales Price After Remodel$232,310
Total Profit Estimate$29,582
View Details

Asking $148,900
 *  New! Listed 6 Day(s) Ago
 *  Originally Listed on 5/23/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
Manhattan KS
 
 
Overall Profit Summary
Purchase Price: $120,397
Estimated Repairs$26,477
Sales Price After Remodel$201,955
Total Profit Estimate$30,735
View Details

Asking $149,000
 *  Listed 62 Days Ago
 *  Originally Listed on 3/28/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! 
Investor-Deal!
Manhattan KS
 
 
Overall Profit Summary
Purchase Price: $121,205
Estimated Repairs$24,358
Sales Price After Remodel$198,717
Total Profit Estimate$30,045
View Details

Asking $150,000
 *  Listed 98 Days Ago
 *  Originally Listed on 2/21/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! 
Priced Under Tax-Value!
Salina KS
 
 
Overall Profit Summary
Purchase Price: $124,057
Estimated Repairs$49,828
Sales Price After Remodel$249,656
Total Profit Estimate$37,126
View Details

Asking $150,000
 *  Listed 31 Days Ago
 *  Originally Listed on 4/28/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
Manhattan KS
 
 
Overall Profit Summary
Purchase Price: $122,973
Estimated Repairs$32,576
Sales Price After Remodel$219,152
Total Profit Estimate$35,262
View Details

Asking $154,000
 *  Listed 147 Days Ago
 *  Originally Listed on 1/3/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! 
Motivated Seller
Manhattan KS
 
 
Overall Profit Summary
Purchase Price: $122,973
Estimated Repairs$28,892
Sales Price After Remodel$211,784
Total Profit Estimate$33,825
View Details

Asking $154,000
 *  Listed 147 Days Ago
 *  Originally Listed on 1/3/2020.
 *  Deal Rating of 6.9/10

 $17,300 Below Appraisal
 Investor-Special!!
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
Salina KS
 
 
Overall Profit Summary
Purchase Price: $129,129
Estimated Repairs$14,841
Sales Price After Remodel$184,582
Total Profit Estimate$23,040
View Details

Asking $154,900
 *  Price Reduced by $5,000 on 5/28/2020 6:50:47 AM.
 *  Originally Listed on 5/23/2020.
 *  Deal Rating of 6.7/10

 $15,400 Below Appraisal
 Reduced By $5,000
Great Deal-Score of 5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5! 
Great Profit Potential
Manhattan KS
 
 
Overall Profit Summary
Purchase Price: $120,617
Estimated Repairs$33,204
Sales Price After Remodel$225,408
Total Profit Estimate$42,587
View Details

Asking $159,000
 *  Price Reduced by $6,000 on 12/1/2019.
 *  Originally Listed on 9/16/2019.
 *  Deal Rating of 7.3/10

 $10,600 Below Appraisal
 Reduced By $6,000
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
Manhattan KS
 
 
Overall Profit Summary
Purchase Price: $126,965
Estimated Repairs$36,986
Sales Price After Remodel$232,973
Total Profit Estimate$37,714
View Details

Asking $159,000
 *  Listed 134 Days Ago
 *  Originally Listed on 1/16/2020.
 *  Deal Rating of 7.3/10

 $4,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! 
Make Offer. High Profit.
Manhattan KS
 
 
Overall Profit Summary
Purchase Price: $122,053
Estimated Repairs$31,011
Sales Price After Remodel$221,022
Total Profit Estimate$40,296
View Details

Asking $159,000
 *  Price Reduced by $33,500 on 5/20/2020 6:16:59 PM.
 *  Originally Listed on 3/17/2020.
 *  Deal Rating of 7.6/10

 $31,700 Below Appraisal
 Reduced By $33,500
Great Deal-Score of 7.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 7.5! 
Investor-Deal!
Ogden KS
 
 
Overall Profit Summary
Purchase Price: $140,312
Estimated Repairs$15,361
Sales Price After Remodel$190,623
Total Profit Estimate$16,784
View Details

Asking $159,900
 *  Listed 12 Days Ago
 *  Originally Listed on 5/17/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! 
Great Profit Potential
Manhattan KS
 
 
Overall Profit Summary
Purchase Price: $129,285
Estimated Repairs$34,982
Sales Price After Remodel$229,964
Total Profit Estimate$35,558
View Details

Asking $160,000
 *  Listed 72 Days Ago
 *  Originally Listed on 3/18/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! 
Make Offer. High Profit.
Manhattan KS
 
 
Overall Profit Summary
Purchase Price: $121,376
Estimated Repairs$35,798
Sales Price After Remodel$231,597
Total Profit Estimate$43,786
View Details

Asking $160,000
 *  Price Reduced by $30,000 on 4/8/2020.
 *  Originally Listed on 12/5/2019.
 *  Deal Rating of 6.9/10

 $3,000 Below Appraisal
 Reduced By $30,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
Manhattan KS
 
 
Overall Profit Summary
Purchase Price: $136,890
Estimated Repairs$28,776
Sales Price After Remodel$217,552
Total Profit Estimate$25,533
View Details

Asking $160,000
 *  Listed 17 Days Ago
 *  Originally Listed on 5/12/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! 
combined end
** 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!

Ben - Lending $100,000.00

Lender Name : Ben Shoemaker

Lender Type : individual

8% Rate

Lending: Nationwide

Lending at 8%


View Detail

Ed - Lending $50,000.00

Lender Name : Ed Klejdys

Lender Type : individual

5% Rate

Lending: Nationwide

Lending at 5%


View Detail

Andrew - Lending $50,000.00

Lender Name : Andrew Choi

Lender Type : individual

7% Rate

Lending: Nationwide

Lending at 7%


View Detail

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

Ali - Lending $250,000.00

Lender Name : Ali Noubani

Lender Type : individual

3% Rate

Lending: Nationwide

Lending at 3%


View Detail

Henrik - Lending $1,000,000.00

Lender Name : Henrik Khechoom

Lender Type : individual

8% Rate

Lending: Nationwide

Lending at 8%


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 --->





David - Lending $50,000.00

Lender Name : David Mosel

Lender Type : individual

4% Rate

Lending: Nationwide

Lending at 4%


View Detail

Guy - Lending $100,000.00

Lender Name : Guy Bibbs

Lender Type : individual

5% Rate

Lending: Nationwide

Lending at 5%


View Detail

Charlene - Lending $50,000.00

Lender Name : Charlene Clare

Lender Type : individual

8% Rate

Lending: Nationwide

Lending at 8%


View Detail

Rogelio - Lending $100,000.00

Lender Name : Rogelio Dominguez

Lender Type : individual

5% Rate

Lending: Nationwide

Lending at 5%


View Detail

Richard - Lending $250,000.00

Lender Name : Richard Grady

Lender Type : individual

5% Rate

Lending: Nationwide

Lending at 5%


View Detail

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

Asi - Lending $1,000,001.00

Lender Name : Asi Ifrah

Lender Type : individual

7% Rate

Lending: Nationwide

Lending at 7%


View Detail

Okechukwu - Lending $100,000.00

Lender Name : Okechukwu Ugbaja

Lender Type : individual

7% Rate

Lending: Nationwide

Lending at 7%


View Detail

Kenny - Lending $1,000,000.00

Lender Name : Kenny Gant

Lender Type : individual

9% Rate

Lending: Nationwide

Lending at 9%


View Detail

Jessie - Lending $1,000,000.00

Lender Name : Jessie Henton

Lender Type : individual

8% Rate

Lending: Nationwide

Lending at 8%


View Detail

Julio - Lending $50,000.00

Lender Name : Julio Alvarez

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 --->





Maria D Chapa - Lending $50,000.00

Lender Name : Maria D Chapa Chapa

Lender Type : individual

6% Rate

Lending: Nationwide

Lending at 6%


View Detail

Willie - Lending $50,000.00

Lender Name : Willie Mayes

Lender Type : individual

5% Rate

Lending: Nationwide

Lending at 5%


View Detail

Rene - Lending $100,000.00

Lender Name : Rene Guzman

Lender Type : individual

3% Rate

Lending: Nationwide

Lending at 3%


View Detail

Eileen - Lending $50,000.00

Lender Name : Eileen Machida

Lender Type : individual

7% Rate

Lending: Nationwide

Lending at 7%


View Detail

Akeem - Lending $100,000.00

Lender Name : Akeem Elijah-el

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!

Bryant - Lending $100,000.00

Lender Name : Bryant Moore

Lender Type : individual

9% Rate

Lending: Nationwide

Lending at 9%


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

Shavawn - Lending $1,000,001.00

Lender Name : Shavawn Morgan

Lender Type : individual

6% Rate

Lending: Nationwide

Lending at 6%


View Detail

Don - Lending $1,000,000.00

Lender Name : Don Duhadway

Lender Type : individual

8% Rate

Lending: Nationwide

Lending at 8%


View Detail

Kareem - Lending $1,000,001.00

Lender Name : Kareem Broughton

Lender Type : individual

9% Rate

Lending: Nationwide

Lending at 9%


View Detail

Ansel - Lending $100,000.00

Lender Name : Ansel Diaz

Lender Type : individual

8% Rate

Lending: Nationwide

Lending at 8%


View Detail

Jill - Lending $500,000.00

Lender Name : Jill Subes

Lender Type : individual

7% Rate

Lending: Nationwide

Lending at 7%


View Detail

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

Clay Center KS 67432

Asking : $40000

List Date : 5/26/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: 11.5

Salina KS 67401

Asking : $47000

List Date : 11/12/2019

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

Ogden KS 66517

Asking : $60000

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!


Investment Rental Property

View Details!



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

Ogden KS 66517

Asking : $69900

List Date : 3/23/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

Junction City KS 66441

Asking : $69900

List Date : 1/2/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 --->





Wakefield KS 67487

Asking : $123900

List Date : 5/5/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

Manhattan KS 66502

Asking : $129900

List Date : 11/22/2019

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

Salina KS 67401

Asking : $139500

List Date : 3/12/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

Manhattan KS 66502

Asking : $144000

List Date : 1/3/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: 7.5

Manhattan KS 66502

Asking : $154000

List Date : 1/3/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
Use the Tabs at the Top of This Page to Navigate the different types of properties!

Manhattan KS 66502

Asking : $154000

List Date : 1/3/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

Manhattan KS 66502

Asking : $345000

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!


Investment Rental Property

View Details!



Deal Score: 7.5

Manhattan KS 66502

Asking : $375000

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!


Investment Rental Property

View Details!



Deal Score: 6.5

Manhattan KS 66502

Asking : $1200000

List Date : 5/15/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: 8
** 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.

Clifton KS 66937

Bid : 31,350 or Less

Beds/Baths : 2 / 2

Year Built : 1920

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 ='66930' or zipCode = '66935' or zipCode = '66937' or zipCode = '66938' or zipCode = '66939' or zipCode = '66940' or zipCode = '66944' or zipCode = '66953' or zipCode = '66955' or zipCode = '66958' or zipCode = '66959' or zipCode = '66960' or zipCode = '66961' or zipCode = '66962' or zipCode = '66964' or zipCode = '66966' or zipCode = '66968' or zipCode = '68325' or zipCode = '68327' or zipCode = '68350' or zipCode = '68362' or zipCode = '68375' or zipCode = '68429' or zipCode = '68429' or zipCode = '66901' or zipCode = '66930' or zipCode = '66935' or zipCode = '66937' or zipCode = '66938' or zipCode = '66939' or zipCode = '66940' or zipCode = '66944' or zipCode = '66953' or zipCode = '66955' or zipCode = '66958' or zipCode = '66959' or zipCode = '66960' or zipCode = '66961' or zipCode = '66962' or zipCode = '66964' or zipCode = '66966' or zipCode = '66968' or zipCode = '66969' or zipCode = '66998' or zipCode = '68325' or zipCode = '68327' or zipCode = '68362' or zipCode = '68370' or zipCode = '68375' or zipCode = '68429')
select top 45 * from tblREO NOLOCK where priority is null and dateposted >= '4/29/2020' and Len(PhotoURL1) > 10 and 1=1 and state = 'KS' and (1=1) and price >= 0 and price <= 100000000 and 11=11 and (zipCode ='66930' or zipCode = '66935' or zipCode = '66937' or zipCode = '66938' or zipCode = '66939' or zipCode = '66940' or zipCode = '66944' or zipCode = '66953' or zipCode = '66955' or zipCode = '66958' or zipCode = '66959' or zipCode = '66960' or zipCode = '66961' or zipCode = '66962' or zipCode = '66964' or zipCode = '66966' or zipCode = '66968' or zipCode = '68325' or zipCode = '68327' or zipCode = '68350' or zipCode = '68362' or zipCode = '68375' or zipCode = '68429' or zipCode = '68429' or zipCode = '66901' or zipCode = '66930' or zipCode = '66935' or zipCode = '66937' or zipCode = '66938' or zipCode = '66939' or zipCode = '66940' or zipCode = '66944' or zipCode = '66953' or zipCode = '66955' or zipCode = '66958' or zipCode = '66959' or zipCode = '66960' or zipCode = '66961' or zipCode = '66962' or zipCode = '66964' or zipCode = '66966' or zipCode = '66968' or zipCode = '66969' or zipCode = '66998' or zipCode = '68325' or zipCode = '68327' or zipCode = '68362' or zipCode = '68370' or zipCode = '68375' or zipCode = '68429')
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 ='66930' or zipCode = '66935' or zipCode = '66937' or zipCode = '66938' or zipCode = '66939' or zipCode = '66940' or zipCode = '66944' or zipCode = '66953' or zipCode = '66955' or zipCode = '66958' or zipCode = '66959' or zipCode = '66960' or zipCode = '66961' or zipCode = '66962' or zipCode = '66964' or zipCode = '66966' or zipCode = '66968' or zipCode = '68325' or zipCode = '68327' or zipCode = '68350' or zipCode = '68362' or zipCode = '68375' or zipCode = '68429' or zipCode = '68429' or zipCode = '66901' or zipCode = '66930' or zipCode = '66935' or zipCode = '66937' or zipCode = '66938' or zipCode = '66939' or zipCode = '66940' or zipCode = '66944' or zipCode = '66953' or zipCode = '66955' or zipCode = '66958' or zipCode = '66959' or zipCode = '66960' or zipCode = '66961' or zipCode = '66962' or zipCode = '66964' or zipCode = '66966' or zipCode = '66968' or zipCode = '66969' or zipCode = '66998' or zipCode = '68325' or zipCode = '68327' or zipCode = '68362' or zipCode = '68370' or zipCode = '68375' or zipCode = '68429') 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 ='66930' or zipCode = '66935' or zipCode = '66937' or zipCode = '66938' or zipCode = '66939' or zipCode = '66940' or zipCode = '66944' or zipCode = '66953' or zipCode = '66955' or zipCode = '66958' or zipCode = '66959' or zipCode = '66960' or zipCode = '66961' or zipCode = '66962' or zipCode = '66964' or zipCode = '66966' or zipCode = '66968' or zipCode = '68325' or zipCode = '68327' or zipCode = '68350' or zipCode = '68362' or zipCode = '68375' or zipCode = '68429' or zipCode = '68429' or zipCode = '66901' or zipCode = '66930' or zipCode = '66935' or zipCode = '66937' or zipCode = '66938' or zipCode = '66939' or zipCode = '66940' or zipCode = '66944' or zipCode = '66953' or zipCode = '66955' or zipCode = '66958' or zipCode = '66959' or zipCode = '66960' or zipCode = '66961' or zipCode = '66962' or zipCode = '66964' or zipCode = '66966' or zipCode = '66968' or zipCode = '66969' or zipCode = '66998' or zipCode = '68325' or zipCode = '68327' or zipCode = '68362' or zipCode = '68370' or zipCode = '68375' or zipCode = '68429') 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 ='66930' or zipCode = '66935' or zipCode = '66937' or zipCode = '66938' or zipCode = '66939' or zipCode = '66940' or zipCode = '66944' or zipCode = '66953' or zipCode = '66955' or zipCode = '66958' or zipCode = '66959' or zipCode = '66960' or zipCode = '66961' or zipCode = '66962' or zipCode = '66964' or zipCode = '66966' or zipCode = '66968' or zipCode = '68325' or zipCode = '68327' or zipCode = '68350' or zipCode = '68362' or zipCode = '68375' or zipCode = '68429' or zipCode = '68429' or zipCode = '66901' or zipCode = '66930' or zipCode = '66935' or zipCode = '66937' or zipCode = '66938' or zipCode = '66939' or zipCode = '66940' or zipCode = '66944' or zipCode = '66953' or zipCode = '66955' or zipCode = '66958' or zipCode = '66959' or zipCode = '66960' or zipCode = '66961' or zipCode = '66962' or zipCode = '66964' or zipCode = '66966' or zipCode = '66968' or zipCode = '66969' or zipCode = '66998' or zipCode = '68325' or zipCode = '68327' or zipCode = '68362' or zipCode = '68370' or zipCode = '68375' or zipCode = '68429') 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 ='66930' or zipCode = '66935' or zipCode = '66937' or zipCode = '66938' or zipCode = '66939' or zipCode = '66940' or zipCode = '66944' or zipCode = '66953' or zipCode = '66955' or zipCode = '66958' or zipCode = '66959' or zipCode = '66960' or zipCode = '66961' or zipCode = '66962' or zipCode = '66964' or zipCode = '66966' or zipCode = '66968' or zipCode = '68325' or zipCode = '68327' or zipCode = '68350' or zipCode = '68362' or zipCode = '68375' or zipCode = '68429' or zipCode = '68429' or zipCode = '66901' or zipCode = '66930' or zipCode = '66935' or zipCode = '66937' or zipCode = '66938' or zipCode = '66939' or zipCode = '66940' or zipCode = '66944' or zipCode = '66953' or zipCode = '66955' or zipCode = '66958' or zipCode = '66959' or zipCode = '66960' or zipCode = '66961' or zipCode = '66962' or zipCode = '66964' or zipCode = '66966' or zipCode = '66968' or zipCode = '66969' or zipCode = '66998' or zipCode = '68325' or zipCode = '68327' or zipCode = '68362' or zipCode = '68370' or zipCode = '68375' or zipCode = '68429') 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 ='66930' or zipCode = '66935' or zipCode = '66937' or zipCode = '66938' or zipCode = '66939' or zipCode = '66940' or zipCode = '66944' or zipCode = '66953' or zipCode = '66955' or zipCode = '66958' or zipCode = '66959' or zipCode = '66960' or zipCode = '66961' or zipCode = '66962' or zipCode = '66964' or zipCode = '66966' or zipCode = '66968' or zipCode = '68325' or zipCode = '68327' or zipCode = '68350' or zipCode = '68362' or zipCode = '68375' or zipCode = '68429' or zipCode = '68429' or zipCode = '66901' or zipCode = '66930' or zipCode = '66935' or zipCode = '66937' or zipCode = '66938' or zipCode = '66939' or zipCode = '66940' or zipCode = '66944' or zipCode = '66953' or zipCode = '66955' or zipCode = '66958' or zipCode = '66959' or zipCode = '66960' or zipCode = '66961' or zipCode = '66962' or zipCode = '66964' or zipCode = '66966' or zipCode = '66968' or zipCode = '66969' or zipCode = '66998' or zipCode = '68325' or zipCode = '68327' or zipCode = '68362' or zipCode = '68370' or zipCode = '68375' or zipCode = '68429') 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 ='66411' or zipCode = '66412' or zipCode = '66415' or zipCode = '66417' or zipCode = '66426' or zipCode = '66426' or zipCode = '66427' or zipCode = '66427' or zipCode = '66508' or zipCode = '66514' or zipCode = '66517' or zipCode = '66518' or zipCode = '66520' or zipCode = '66521' or zipCode = '66521' or zipCode = '66521' or zipCode = '66531' or zipCode = '66554' or zipCode = '66403' or zipCode = '66404' or zipCode = '66406' or zipCode = '66438' or zipCode = '66441' or zipCode = '66442' or zipCode = '66442' or zipCode = '66442' or zipCode = '66449' or zipCode = '66502' or zipCode = '66503' or zipCode = '66505' or zipCode = '66506' or zipCode = '66508' or zipCode = '66535' or zipCode = '66535' or zipCode = '66541' or zipCode = '66544' or zipCode = '66544' or zipCode = '66547' or zipCode = '66547' or zipCode = '66547' or zipCode = '66547' or zipCode = '66548' or zipCode = '66549' or zipCode = '66549' or zipCode = '66901' or zipCode = '66901' or zipCode = '66901' or zipCode = '66930' or zipCode = '66933' or zipCode = '66935' or zipCode = '66936' or zipCode = '66937' or zipCode = '66938' or zipCode = '66939' or zipCode = '66940' or zipCode = '66941' or zipCode = '66942' or zipCode = '66943' or zipCode = '66944' or zipCode = '66945' or zipCode = '66946' or zipCode = '66948' or zipCode = '66949' or zipCode = '66949' or zipCode = '66952' or zipCode = '66952' or zipCode = '66953' or zipCode = '66955' or zipCode = '66956' or zipCode = '66958' or zipCode = '66959' or zipCode = '66960' or zipCode = '66961' or zipCode = '66962' or zipCode = '66963' or zipCode = '66964' or zipCode = '66966' or zipCode = '66967' or zipCode = '66967' or zipCode = '66968' or zipCode = '66970' or zipCode = '67401' or zipCode = '67401' or zipCode = '67402' or zipCode = '67410' or zipCode = '67410' or zipCode = '67410' or zipCode = '67417' or zipCode = '67418' or zipCode = '67420' or zipCode = '67420' or zipCode = '67422' or zipCode = '67423' or zipCode = '67430' or zipCode = '67431' or zipCode = '67432' or zipCode = '67432' or zipCode = '67436' or zipCode = '67437' or zipCode = '67441' or zipCode = '67466' or zipCode = '67467' or zipCode = '67467' or zipCode = '67467' or zipCode = '67468' or zipCode = '67470' or zipCode = '67473' or zipCode = '67474' or zipCode = '67478' or zipCode = '67480' or zipCode = '67481' or zipCode = '67482' or zipCode = '67484' or zipCode = '67484' or zipCode = '67485' or zipCode = '67487' or zipCode = '67492' or zipCode = '67638' or zipCode = '67445' or zipCode = '67446' or zipCode = '67447' or zipCode = '67452' or zipCode = '67455' or zipCode = '67455' or zipCode = '67458' or zipCode = '68301' or zipCode = '68303' or zipCode = '68309' or zipCode = '68309' or zipCode = '68310' or zipCode = '68310' or zipCode = '68310' or zipCode = '68310' or zipCode = '68310' or zipCode = '68310' or zipCode = '68310' or zipCode = '68310' or zipCode = '68313' or zipCode = '68313' or zipCode = '68315' or zipCode = '68315' or zipCode = '68318' or zipCode = '68322' or zipCode = '68323' or zipCode = '68325' or zipCode = '68326' or zipCode = '68327' or zipCode = '68328' or zipCode = '68350' or zipCode = '68351' or zipCode = '68352' or zipCode = '68352' or zipCode = '68352' or zipCode = '68352' or zipCode = '68354' or zipCode = '68354' or zipCode = '68357' or zipCode = '68358' or zipCode = '68359' or zipCode = '68361' or zipCode = '68362' or zipCode = '68364' or zipCode = '68365' or zipCode = '68368' or zipCode = '68330' or zipCode = '68331' or zipCode = '68331' or zipCode = '68332' or zipCode = '68333' or zipCode = '68333' or zipCode = '68333' or zipCode = '68335' or zipCode = '68338' or zipCode = '68339' or zipCode = '68340' or zipCode = '68341' or zipCode = '68342' or zipCode = '68343' or zipCode = '68343' or zipCode = '68345' or zipCode = '68345' or zipCode = '68370' or zipCode = '68371' or zipCode = '68371' or zipCode = '68372' or zipCode = '68372' or zipCode = '68375' or zipCode = '68377' or zipCode = '68377' or zipCode = '68380' or zipCode = '68380' or zipCode = '68381' or zipCode = '68401' or zipCode = '68401' or zipCode = '68404' or zipCode = '68404' or zipCode = '68404' or zipCode = '68405' or zipCode = '68405' or zipCode = '68406' or zipCode = '68415' or zipCode = '68415' or zipCode = '68416' or zipCode = '68419' or zipCode = '68420' or zipCode = '68422' or zipCode = '68423' or zipCode = '68424' or zipCode = '68429' or zipCode = '68429' or zipCode = '68430' or zipCode = '68430' or zipCode = '68436' or zipCode = '68438' or zipCode = '68440' or zipCode = '68441' or zipCode = '68443' or zipCode = '68443' or zipCode = '68444' or zipCode = '68444' or zipCode = '68444' or zipCode = '68445' or zipCode = '68512' or zipCode = '68523' or zipCode = '68523' or zipCode = '68532' or zipCode = '68450' or zipCode = '68450' or zipCode = '68452' or zipCode = '68453' or zipCode = '68458' or zipCode = '68460' or zipCode = '68460' or zipCode = '68464' or zipCode = '68465' or zipCode = '68466' or zipCode = '68466' or zipCode = '68467' or zipCode = '68901' or zipCode = '68901' or zipCode = '68901' or zipCode = '68901' or zipCode = '68901' or zipCode = '68901' or zipCode = '68901' or zipCode = '68901' or zipCode = '68902' or zipCode = '68935' or zipCode = '68938' or zipCode = '68941' or zipCode = '68941' or zipCode = '68941' or zipCode = '68941' or zipCode = '68942' or zipCode = '68943' or zipCode = '68944' or zipCode = '68952' or zipCode = '68954' or zipCode = '68957' or zipCode = '68957' or zipCode = '68957' or zipCode = '68978' or zipCode = '68978' or zipCode = '68978' or zipCode = '68979' or zipCode = '68979' or zipCode = '68979' or zipCode = '68980' or zipCode = '68980' or zipCode = '68925' or zipCode = '68925' or zipCode = '68928' or zipCode = '68930' or zipCode = '68930' or zipCode = '68930' or zipCode = '68933' or zipCode = '68933' or zipCode = '68933' or zipCode = '68934' or zipCode = '68934' or zipCode = '68935' or zipCode = '68961' or zipCode = '68961' or zipCode = '68964' or zipCode = '68970' or zipCode = '68973' or zipCode = '68973' or zipCode = '68974' or zipCode = '68975' or zipCode = '66145' or zipCode = '66403' or zipCode = '66404' or zipCode = '66406' or zipCode = '66411' or zipCode = '66412' or zipCode = '66415' or zipCode = '66426' or zipCode = '66427' or zipCode = '66438' or zipCode = '66441' or zipCode = '66442' or zipCode = '66449' or zipCode = '66450' or zipCode = '66502' or zipCode = '66503' or zipCode = '66505' or zipCode = '66506' or zipCode = '66508' or zipCode = '66514' or zipCode = '66517' or zipCode = '66518' or zipCode = '66520' or zipCode = '66521' or zipCode = '66531' or zipCode = '66535' or zipCode = '66538' or zipCode = '66541' or zipCode = '66544' or zipCode = '66547' or zipCode = '66548' or zipCode = '66549' or zipCode = '66551' or zipCode = '66554' or zipCode = '66555' or zipCode = '66635' or zipCode = '66901' or zipCode = '66930' or zipCode = '66933' or zipCode = '66935' or zipCode = '66936' or zipCode = '66937' or zipCode = '66938' or zipCode = '66939' or zipCode = '66940' or zipCode = '66941' or zipCode = '66942' or zipCode = '66943' or zipCode = '66944' or zipCode = '66945' or zipCode = '66946' or zipCode = '66948' or zipCode = '66949' or zipCode = '66952' or zipCode = '66953' or zipCode = '66955' or zipCode = '66956' or zipCode = '66958' or zipCode = '66959' or zipCode = '66960' or zipCode = '66961' or zipCode = '66962' or zipCode = '66963' or zipCode = '66964' or zipCode = '66966' or zipCode = '66967' or zipCode = '66968' or zipCode = '66969' or zipCode = '66970' or zipCode = '66998' or zipCode = '67401' or zipCode = '67402' or zipCode = '67410' or zipCode = '67417' or zipCode = '67418' or zipCode = '67420' or zipCode = '67422' or zipCode = '67423' or zipCode = '67425' or zipCode = '67430' or zipCode = '67431' or zipCode = '67432' or zipCode = '67436' or zipCode = '67437' or zipCode = '67441' or zipCode = '67445' or zipCode = '67446' or zipCode = '67447' or zipCode = '67452' or zipCode = '67455' or zipCode = '67458' or zipCode = '67466' or zipCode = '67467' or zipCode = '67468' or zipCode = '67470' or zipCode = '67472' or zipCode = '67473' or zipCode = '67474' or zipCode = '67478' or zipCode = '67480' or zipCode = '67481' or zipCode = '67482' or zipCode = '67484' or zipCode = '67485' or zipCode = '67487' or zipCode = '67488' or zipCode = '67492' or zipCode = '67495' or zipCode = '67845' or zipCode = '67938' or zipCode = '68301' or zipCode = '68303' or zipCode = '68309' or zipCode = '68310' or zipCode = '68313' or zipCode = '68315' or zipCode = '68318' or zipCode = '68322' or zipCode = '68323' or zipCode = '68325' or zipCode = '68326' or zipCode = '68327' or zipCode = '68328' or zipCode = '68330' or zipCode = '68331' or zipCode = '68332' or zipCode = '68333' or zipCode = '68335' or zipCode = '68338' or zipCode = '68339' or zipCode = '68340' or zipCode = '68341' or zipCode = '68342' or zipCode = '68343' or zipCode = '68350' or zipCode = '68351' or zipCode = '68352' or zipCode = '68354' or zipCode = '68357' or zipCode = '68358' or zipCode = '68359' or zipCode = '68361' or zipCode = '68362' or zipCode = '68364' or zipCode = '68365' or zipCode = '68368' or zipCode = '68370' or zipCode = '68371' or zipCode = '68372' or zipCode = '68374' or zipCode = '68375' or zipCode = '68377' or zipCode = '68380' or zipCode = '68381' or zipCode = '68401' or zipCode = '68404' or zipCode = '68405' or zipCode = '68406' or zipCode = '68415' or zipCode = '68416' or zipCode = '68419' or zipCode = '68420' or zipCode = '68422' or zipCode = '68423' or zipCode = '68424' or zipCode = '68429' or zipCode = '68430' or zipCode = '68436' or zipCode = '68438' or zipCode = '68440' or zipCode = '68441' or zipCode = '68443' or zipCode = '68444' or zipCode = '68445' or zipCode = '68452' or zipCode = '68453' or zipCode = '68456' or zipCode = '68458' or zipCode = '68460' or zipCode = '68464' or zipCode = '68465' or zipCode = '68466' or zipCode = '68467' or zipCode = '68523' or zipCode = '68532' or zipCode = '68797' or zipCode = '68901' or zipCode = '68902' or zipCode = '68925' or zipCode = '68928' or zipCode = '68930' or zipCode = '68933' or zipCode = '68934' or zipCode = '68935' or zipCode = '68938' or zipCode = '68941' or zipCode = '68942' or zipCode = '68943' or zipCode = '68944' or zipCode = '68952' or zipCode = '68954' or zipCode = '68957' or zipCode = '68961' or zipCode = '68964' or zipCode = '68970' or zipCode = '68972' or zipCode = '68973' or zipCode = '68974' or zipCode = '68975' or zipCode = '68978' or zipCode = '68979' or zipCode = '68980') 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 ='66411' or zipCode = '66412' or zipCode = '66415' or zipCode = '66417' or zipCode = '66426' or zipCode = '66426' or zipCode = '66427' or zipCode = '66427' or zipCode = '66508' or zipCode = '66514' or zipCode = '66517' or zipCode = '66518' or zipCode = '66520' or zipCode = '66521' or zipCode = '66521' or zipCode = '66521' or zipCode = '66531' or zipCode = '66554' or zipCode = '66403' or zipCode = '66404' or zipCode = '66406' or zipCode = '66438' or zipCode = '66441' or zipCode = '66442' or zipCode = '66442' or zipCode = '66442' or zipCode = '66449' or zipCode = '66502' or zipCode = '66503' or zipCode = '66505' or zipCode = '66506' or zipCode = '66508' or zipCode = '66535' or zipCode = '66535' or zipCode = '66541' or zipCode = '66544' or zipCode = '66544' or zipCode = '66547' or zipCode = '66547' or zipCode = '66547' or zipCode = '66547' or zipCode = '66548' or zipCode = '66549' or zipCode = '66549' or zipCode = '66901' or zipCode = '66901' or zipCode = '66901' or zipCode = '66930' or zipCode = '66933' or zipCode = '66935' or zipCode = '66936' or zipCode = '66937' or zipCode = '66938' or zipCode = '66939' or zipCode = '66940' or zipCode = '66941' or zipCode = '66942' or zipCode = '66943' or zipCode = '66944' or zipCode = '66945' or zipCode = '66946' or zipCode = '66948' or zipCode = '66949' or zipCode = '66949' or zipCode = '66952' or zipCode = '66952' or zipCode = '66953' or zipCode = '66955' or zipCode = '66956' or zipCode = '66958' or zipCode = '66959' or zipCode = '66960' or zipCode = '66961' or zipCode = '66962' or zipCode = '66963' or zipCode = '66964' or zipCode = '66966' or zipCode = '66967' or zipCode = '66967' or zipCode = '66968' or zipCode = '66970' or zipCode = '67401' or zipCode = '67401' or zipCode = '67402' or zipCode = '67410' or zipCode = '67410' or zipCode = '67410' or zipCode = '67417' or zipCode = '67418' or zipCode = '67420' or zipCode = '67420' or zipCode = '67422' or zipCode = '67423' or zipCode = '67430' or zipCode = '67431' or zipCode = '67432' or zipCode = '67432' or zipCode = '67436' or zipCode = '67437' or zipCode = '67441' or zipCode = '67466' or zipCode = '67467' or zipCode = '67467' or zipCode = '67467' or zipCode = '67468' or zipCode = '67470' or zipCode = '67473' or zipCode = '67474' or zipCode = '67478' or zipCode = '67480' or zipCode = '67481' or zipCode = '67482' or zipCode = '67484' or zipCode = '67484' or zipCode = '67485' or zipCode = '67487' or zipCode = '67492' or zipCode = '67638' or zipCode = '67445' or zipCode = '67446' or zipCode = '67447' or zipCode = '67452' or zipCode = '67455' or zipCode = '67455' or zipCode = '67458' or zipCode = '68301' or zipCode = '68303' or zipCode = '68309' or zipCode = '68309' or zipCode = '68310' or zipCode = '68310' or zipCode = '68310' or zipCode = '68310' or zipCode = '68310' or zipCode = '68310' or zipCode = '68310' or zipCode = '68310' or zipCode = '68313' or zipCode = '68313' or zipCode = '68315' or zipCode = '68315' or zipCode = '68318' or zipCode = '68322' or zipCode = '68323' or zipCode = '68325' or zipCode = '68326' or zipCode = '68327' or zipCode = '68328' or zipCode = '68350' or zipCode = '68351' or zipCode = '68352' or zipCode = '68352' or zipCode = '68352' or zipCode = '68352' or zipCode = '68354' or zipCode = '68354' or zipCode = '68357' or zipCode = '68358' or zipCode = '68359' or zipCode = '68361' or zipCode = '68362' or zipCode = '68364' or zipCode = '68365' or zipCode = '68368' or zipCode = '68330' or zipCode = '68331' or zipCode = '68331' or zipCode = '68332' or zipCode = '68333' or zipCode = '68333' or zipCode = '68333' or zipCode = '68335' or zipCode = '68338' or zipCode = '68339' or zipCode = '68340' or zipCode = '68341' or zipCode = '68342' or zipCode = '68343' or zipCode = '68343' or zipCode = '68345' or zipCode = '68345' or zipCode = '68370' or zipCode = '68371' or zipCode = '68371' or zipCode = '68372' or zipCode = '68372' or zipCode = '68375' or zipCode = '68377' or zipCode = '68377' or zipCode = '68380' or zipCode = '68380' or zipCode = '68381' or zipCode = '68401' or zipCode = '68401' or zipCode = '68404' or zipCode = '68404' or zipCode = '68404' or zipCode = '68405' or zipCode = '68405' or zipCode = '68406' or zipCode = '68415' or zipCode = '68415' or zipCode = '68416' or zipCode = '68419' or zipCode = '68420' or zipCode = '68422' or zipCode = '68423' or zipCode = '68424' or zipCode = '68429' or zipCode = '68429' or zipCode = '68430' or zipCode = '68430' or zipCode = '68436' or zipCode = '68438' or zipCode = '68440' or zipCode = '68441' or zipCode = '68443' or zipCode = '68443' or zipCode = '68444' or zipCode = '68444' or zipCode = '68444' or zipCode = '68445' or zipCode = '68512' or zipCode = '68523' or zipCode = '68523' or zipCode = '68532' or zipCode = '68450' or zipCode = '68450' or zipCode = '68452' or zipCode = '68453' or zipCode = '68458' or zipCode = '68460' or zipCode = '68460' or zipCode = '68464' or zipCode = '68465' or zipCode = '68466' or zipCode = '68466' or zipCode = '68467' or zipCode = '68901' or zipCode = '68901' or zipCode = '68901' or zipCode = '68901' or zipCode = '68901' or zipCode = '68901' or zipCode = '68901' or zipCode = '68901' or zipCode = '68902' or zipCode = '68935' or zipCode = '68938' or zipCode = '68941' or zipCode = '68941' or zipCode = '68941' or zipCode = '68941' or zipCode = '68942' or zipCode = '68943' or zipCode = '68944' or zipCode = '68952' or zipCode = '68954' or zipCode = '68957' or zipCode = '68957' or zipCode = '68957' or zipCode = '68978' or zipCode = '68978' or zipCode = '68978' or zipCode = '68979' or zipCode = '68979' or zipCode = '68979' or zipCode = '68980' or zipCode = '68980' or zipCode = '68925' or zipCode = '68925' or zipCode = '68928' or zipCode = '68930' or zipCode = '68930' or zipCode = '68930' or zipCode = '68933' or zipCode = '68933' or zipCode = '68933' or zipCode = '68934' or zipCode = '68934' or zipCode = '68935' or zipCode = '68961' or zipCode = '68961' or zipCode = '68964' or zipCode = '68970' or zipCode = '68973' or zipCode = '68973' or zipCode = '68974' or zipCode = '68975' or zipCode = '66145' or zipCode = '66403' or zipCode = '66404' or zipCode = '66406' or zipCode = '66411' or zipCode = '66412' or zipCode = '66415' or zipCode = '66426' or zipCode = '66427' or zipCode = '66438' or zipCode = '66441' or zipCode = '66442' or zipCode = '66449' or zipCode = '66450' or zipCode = '66502' or zipCode = '66503' or zipCode = '66505' or zipCode = '66506' or zipCode = '66508' or zipCode = '66514' or zipCode = '66517' or zipCode = '66518' or zipCode = '66520' or zipCode = '66521' or zipCode = '66531' or zipCode = '66535' or zipCode = '66538' or zipCode = '66541' or zipCode = '66544' or zipCode = '66547' or zipCode = '66548' or zipCode = '66549' or zipCode = '66551' or zipCode = '66554' or zipCode = '66555' or zipCode = '66635' or zipCode = '66901' or zipCode = '66930' or zipCode = '66933' or zipCode = '66935' or zipCode = '66936' or zipCode = '66937' or zipCode = '66938' or zipCode = '66939' or zipCode = '66940' or zipCode = '66941' or zipCode = '66942' or zipCode = '66943' or zipCode = '66944' or zipCode = '66945' or zipCode = '66946' or zipCode = '66948' or zipCode = '66949' or zipCode = '66952' or zipCode = '66953' or zipCode = '66955' or zipCode = '66956' or zipCode = '66958' or zipCode = '66959' or zipCode = '66960' or zipCode = '66961' or zipCode = '66962' or zipCode = '66963' or zipCode = '66964' or zipCode = '66966' or zipCode = '66967' or zipCode = '66968' or zipCode = '66969' or zipCode = '66970' or zipCode = '66998' or zipCode = '67401' or zipCode = '67402' or zipCode = '67410' or zipCode = '67417' or zipCode = '67418' or zipCode = '67420' or zipCode = '67422' or zipCode = '67423' or zipCode = '67425' or zipCode = '67430' or zipCode = '67431' or zipCode = '67432' or zipCode = '67436' or zipCode = '67437' or zipCode = '67441' or zipCode = '67445' or zipCode = '67446' or zipCode = '67447' or zipCode = '67452' or zipCode = '67455' or zipCode = '67458' or zipCode = '67466' or zipCode = '67467' or zipCode = '67468' or zipCode = '67470' or zipCode = '67472' or zipCode = '67473' or zipCode = '67474' or zipCode = '67478' or zipCode = '67480' or zipCode = '67481' or zipCode = '67482' or zipCode = '67484' or zipCode = '67485' or zipCode = '67487' or zipCode = '67488' or zipCode = '67492' or zipCode = '67495' or zipCode = '67845' or zipCode = '67938' or zipCode = '68301' or zipCode = '68303' or zipCode = '68309' or zipCode = '68310' or zipCode = '68313' or zipCode = '68315' or zipCode = '68318' or zipCode = '68322' or zipCode = '68323' or zipCode = '68325' or zipCode = '68326' or zipCode = '68327' or zipCode = '68328' or zipCode = '68330' or zipCode = '68331' or zipCode = '68332' or zipCode = '68333' or zipCode = '68335' or zipCode = '68338' or zipCode = '68339' or zipCode = '68340' or zipCode = '68341' or zipCode = '68342' or zipCode = '68343' or zipCode = '68350' or zipCode = '68351' or zipCode = '68352' or zipCode = '68354' or zipCode = '68357' or zipCode = '68358' or zipCode = '68359' or zipCode = '68361' or zipCode = '68362' or zipCode = '68364' or zipCode = '68365' or zipCode = '68368' or zipCode = '68370' or zipCode = '68371' or zipCode = '68372' or zipCode = '68374' or zipCode = '68375' or zipCode = '68377' or zipCode = '68380' or zipCode = '68381' or zipCode = '68401' or zipCode = '68404' or zipCode = '68405' or zipCode = '68406' or zipCode = '68415' or zipCode = '68416' or zipCode = '68419' or zipCode = '68420' or zipCode = '68422' or zipCode = '68423' or zipCode = '68424' or zipCode = '68429' or zipCode = '68430' or zipCode = '68436' or zipCode = '68438' or zipCode = '68440' or zipCode = '68441' or zipCode = '68443' or zipCode = '68444' or zipCode = '68445' or zipCode = '68452' or zipCode = '68453' or zipCode = '68456' or zipCode = '68458' or zipCode = '68460' or zipCode = '68464' or zipCode = '68465' or zipCode = '68466' or zipCode = '68467' or zipCode = '68523' or zipCode = '68532' or zipCode = '68797' or zipCode = '68901' or zipCode = '68902' or zipCode = '68925' or zipCode = '68928' or zipCode = '68930' or zipCode = '68933' or zipCode = '68934' or zipCode = '68935' or zipCode = '68938' or zipCode = '68941' or zipCode = '68942' or zipCode = '68943' or zipCode = '68944' or zipCode = '68952' or zipCode = '68954' or zipCode = '68957' or zipCode = '68961' or zipCode = '68964' or zipCode = '68970' or zipCode = '68972' or zipCode = '68973' or zipCode = '68974' or zipCode = '68975' or zipCode = '68978' or zipCode = '68979' or zipCode = '68980') 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 ='66930' or property_zip = '66935' or property_zip = '66937' or property_zip = '66938' or property_zip = '66939' or property_zip = '66940' or property_zip = '66944' or property_zip = '66953' or property_zip = '66955' or property_zip = '66958' or property_zip = '66959' or property_zip = '66960' or property_zip = '66961' or property_zip = '66962' or property_zip = '66964' or property_zip = '66966' or property_zip = '66968' or property_zip = '68325' or property_zip = '68327' or property_zip = '68350' or property_zip = '68362' or property_zip = '68375' or property_zip = '68429' or property_zip = '68429' or property_zip = '66901' or property_zip = '66930' or property_zip = '66935' or property_zip = '66937' or property_zip = '66938' or property_zip = '66939' or property_zip = '66940' or property_zip = '66944' or property_zip = '66953' or property_zip = '66955' or property_zip = '66958' or property_zip = '66959' or property_zip = '66960' or property_zip = '66961' or property_zip = '66962' or property_zip = '66964' or property_zip = '66966' or property_zip = '66968' or property_zip = '66969' or property_zip = '66998' or property_zip = '68325' or property_zip = '68327' or property_zip = '68362' or property_zip = '68370' or property_zip = '68375' or property_zip = '68429') and 11=11 and (property_zip ='66411' or property_zip = '66412' or property_zip = '66415' or property_zip = '66417' or property_zip = '66426' or property_zip = '66426' or property_zip = '66427' or property_zip = '66427' or property_zip = '66508' or property_zip = '66514' or property_zip = '66517' or property_zip = '66518' or property_zip = '66520' or property_zip = '66521' or property_zip = '66521' or property_zip = '66521' or property_zip = '66531' or property_zip = '66554' or property_zip = '66403' or property_zip = '66404' or property_zip = '66406' or property_zip = '66438' or property_zip = '66441' or property_zip = '66442' or property_zip = '66442' or property_zip = '66442' or property_zip = '66449' or property_zip = '66502' or property_zip = '66503' or property_zip = '66505' or property_zip = '66506' or property_zip = '66508' or property_zip = '66535' or property_zip = '66535' or property_zip = '66541' or property_zip = '66544' or property_zip = '66544' or property_zip = '66547' or property_zip = '66547' or property_zip = '66547' or property_zip = '66547' or property_zip = '66548' or property_zip = '66549' or property_zip = '66549' or property_zip = '66901' or property_zip = '66901' or property_zip = '66901' or property_zip = '66930' or property_zip = '66933' or property_zip = '66935' or property_zip = '66936' or property_zip = '66937' or property_zip = '66938' or property_zip = '66939' or property_zip = '66940' or property_zip = '66941' or property_zip = '66942' or property_zip = '66943' or property_zip = '66944' or property_zip = '66945' or property_zip = '66946' or property_zip = '66948' or property_zip = '66949' or property_zip = '66949' or property_zip = '66952' or property_zip = '66952' or property_zip = '66953' or property_zip = '66955' or property_zip = '66956' or property_zip = '66958' or property_zip = '66959' or property_zip = '66960' or property_zip = '66961' or property_zip = '66962' or property_zip = '66963' or property_zip = '66964' or property_zip = '66966' or property_zip = '66967' or property_zip = '66967' or property_zip = '66968' or property_zip = '66970' or property_zip = '67401' or property_zip = '67401' or property_zip = '67402' or property_zip = '67410' or property_zip = '67410' or property_zip = '67410' or property_zip = '67417' or property_zip = '67418' or property_zip = '67420' or property_zip = '67420' or property_zip = '67422' or property_zip = '67423' or property_zip = '67430' or property_zip = '67431' or property_zip = '67432' or property_zip = '67432' or property_zip = '67436' or property_zip = '67437' or property_zip = '67441' or property_zip = '67466' or property_zip = '67467' or property_zip = '67467' or property_zip = '67467' or property_zip = '67468' or property_zip = '67470' or property_zip = '67473' or property_zip = '67474' or property_zip = '67478' or property_zip = '67480' or property_zip = '67481' or property_zip = '67482' or property_zip = '67484' or property_zip = '67484' or property_zip = '67485' or property_zip = '67487' or property_zip = '67492' or property_zip = '67638' or property_zip = '67445' or property_zip = '67446' or property_zip = '67447' or property_zip = '67452' or property_zip = '67455' or property_zip = '67455' or property_zip = '67458' or property_zip = '68301' or property_zip = '68303' or property_zip = '68309' or property_zip = '68309' or property_zip = '68310' or property_zip = '68310' or property_zip = '68310' or property_zip = '68310' or property_zip = '68310' or property_zip = '68310' or property_zip = '68310' or property_zip = '68310' or property_zip = '68313' or property_zip = '68313' or property_zip = '68315' or property_zip = '68315' or property_zip = '68318' or property_zip = '68322' or property_zip = '68323' or property_zip = '68325' or property_zip = '68326' or property_zip = '68327' or property_zip = '68328' or property_zip = '68350' or property_zip = '68351' or property_zip = '68352' or property_zip = '68352' or property_zip = '68352' or property_zip = '68352' or property_zip = '68354' or property_zip = '68354' or property_zip = '68357' or property_zip = '68358' or property_zip = '68359' or property_zip = '68361' or property_zip = '68362' or property_zip = '68364' or property_zip = '68365' or property_zip = '68368' or property_zip = '68330' or property_zip = '68331' or property_zip = '68331' or property_zip = '68332' or property_zip = '68333' or property_zip = '68333' or property_zip = '68333' or property_zip = '68335' or property_zip = '68338' or property_zip = '68339' or property_zip = '68340' or property_zip = '68341' or property_zip = '68342' or property_zip = '68343' or property_zip = '68343' or property_zip = '68345' or property_zip = '68345' or property_zip = '68370' or property_zip = '68371' or property_zip = '68371' or property_zip = '68372' or property_zip = '68372' or property_zip = '68375' or property_zip = '68377' or property_zip = '68377' or property_zip = '68380' or property_zip = '68380' or property_zip = '68381' or property_zip = '68401' or property_zip = '68401' or property_zip = '68404' or property_zip = '68404' or property_zip = '68404' or property_zip = '68405' or property_zip = '68405' or property_zip = '68406' or property_zip = '68415' or property_zip = '68415' or property_zip = '68416' or property_zip = '68419' or property_zip = '68420' or property_zip = '68422' or property_zip = '68423' or property_zip = '68424' or property_zip = '68429' or property_zip = '68429' or property_zip = '68430' or property_zip = '68430' or property_zip = '68436' or property_zip = '68438' or property_zip = '68440' or property_zip = '68441' or property_zip = '68443' or property_zip = '68443' or property_zip = '68444' or property_zip = '68444' or property_zip = '68444' or property_zip = '68445' or property_zip = '68512' or property_zip = '68523' or property_zip = '68523' or property_zip = '68532' or property_zip = '68450' or property_zip = '68450' or property_zip = '68452' or property_zip = '68453' or property_zip = '68458' or property_zip = '68460' or property_zip = '68460' or property_zip = '68464' or property_zip = '68465' or property_zip = '68466' or property_zip = '68466' or property_zip = '68467' or property_zip = '68901' or property_zip = '68901' or property_zip = '68901' or property_zip = '68901' or property_zip = '68901' or property_zip = '68901' or property_zip = '68901' or property_zip = '68901' or property_zip = '68902' or property_zip = '68935' or property_zip = '68938' or property_zip = '68941' or property_zip = '68941' or property_zip = '68941' or property_zip = '68941' or property_zip = '68942' or property_zip = '68943' or property_zip = '68944' or property_zip = '68952' or property_zip = '68954' or property_zip = '68957' or property_zip = '68957' or property_zip = '68957' or property_zip = '68978' or property_zip = '68978' or property_zip = '68978' or property_zip = '68979' or property_zip = '68979' or property_zip = '68979' or property_zip = '68980' or property_zip = '68980' or property_zip = '68925' or property_zip = '68925' or property_zip = '68928' or property_zip = '68930' or property_zip = '68930' or property_zip = '68930' or property_zip = '68933' or property_zip = '68933' or property_zip = '68933' or property_zip = '68934' or property_zip = '68934' or property_zip = '68935' or property_zip = '68961' or property_zip = '68961' or property_zip = '68964' or property_zip = '68970' or property_zip = '68973' or property_zip = '68973' or property_zip = '68974' or property_zip = '68975' or property_zip = '66145' or property_zip = '66403' or property_zip = '66404' or property_zip = '66406' or property_zip = '66411' or property_zip = '66412' or property_zip = '66415' or property_zip = '66426' or property_zip = '66427' or property_zip = '66438' or property_zip = '66441' or property_zip = '66442' or property_zip = '66449' or property_zip = '66450' or property_zip = '66502' or property_zip = '66503' or property_zip = '66505' or property_zip = '66506' or property_zip = '66508' or property_zip = '66514' or property_zip = '66517' or property_zip = '66518' or property_zip = '66520' or property_zip = '66521' or property_zip = '66531' or property_zip = '66535' or property_zip = '66538' or property_zip = '66541' or property_zip = '66544' or property_zip = '66547' or property_zip = '66548' or property_zip = '66549' or property_zip = '66551' or property_zip = '66554' or property_zip = '66555' or property_zip = '66635' or property_zip = '66901' or property_zip = '66930' or property_zip = '66933' or property_zip = '66935' or property_zip = '66936' or property_zip = '66937' or property_zip = '66938' or property_zip = '66939' or property_zip = '66940' or property_zip = '66941' or property_zip = '66942' or property_zip = '66943' or property_zip = '66944' or property_zip = '66945' or property_zip = '66946' or property_zip = '66948' or property_zip = '66949' or property_zip = '66952' or property_zip = '66953' or property_zip = '66955' or property_zip = '66956' or property_zip = '66958' or property_zip = '66959' or property_zip = '66960' or property_zip = '66961' or property_zip = '66962' or property_zip = '66963' or property_zip = '66964' or property_zip = '66966' or property_zip = '66967' or property_zip = '66968' or property_zip = '66969' or property_zip = '66970' or property_zip = '66998' or property_zip = '67401' or property_zip = '67402' or property_zip = '67410' or property_zip = '67417' or property_zip = '67418' or property_zip = '67420' or property_zip = '67422' or property_zip = '67423' or property_zip = '67425' or property_zip = '67430' or property_zip = '67431' or property_zip = '67432' or property_zip = '67436' or property_zip = '67437' or property_zip = '67441' or property_zip = '67445' or property_zip = '67446' or property_zip = '67447' or property_zip = '67452' or property_zip = '67455' or property_zip = '67458' or property_zip = '67466' or property_zip = '67467' or property_zip = '67468' or property_zip = '67470' or property_zip = '67472' or property_zip = '67473' or property_zip = '67474' or property_zip = '67478' or property_zip = '67480' or property_zip = '67481' or property_zip = '67482' or property_zip = '67484' or property_zip = '67485' or property_zip = '67487' or property_zip = '67488' or property_zip = '67492' or property_zip = '67495' or property_zip = '67845' or property_zip = '67938' or property_zip = '68301' or property_zip = '68303' or property_zip = '68309' or property_zip = '68310' or property_zip = '68313' or property_zip = '68315' or property_zip = '68318' or property_zip = '68322' or property_zip = '68323' or property_zip = '68325' or property_zip = '68326' or property_zip = '68327' or property_zip = '68328' or property_zip = '68330' or property_zip = '68331' or property_zip = '68332' or property_zip = '68333' or property_zip = '68335' or property_zip = '68338' or property_zip = '68339' or property_zip = '68340' or property_zip = '68341' or property_zip = '68342' or property_zip = '68343' or property_zip = '68350' or property_zip = '68351' or property_zip = '68352' or property_zip = '68354' or property_zip = '68357' or property_zip = '68358' or property_zip = '68359' or property_zip = '68361' or property_zip = '68362' or property_zip = '68364' or property_zip = '68365' or property_zip = '68368' or property_zip = '68370' or property_zip = '68371' or property_zip = '68372' or property_zip = '68374' or property_zip = '68375' or property_zip = '68377' or property_zip = '68380' or property_zip = '68381' or property_zip = '68401' or property_zip = '68404' or property_zip = '68405' or property_zip = '68406' or property_zip = '68415' or property_zip = '68416' or property_zip = '68419' or property_zip = '68420' or property_zip = '68422' or property_zip = '68423' or property_zip = '68424' or property_zip = '68429' or property_zip = '68430' or property_zip = '68436' or property_zip = '68438' or property_zip = '68440' or property_zip = '68441' or property_zip = '68443' or property_zip = '68444' or property_zip = '68445' or property_zip = '68452' or property_zip = '68453' or property_zip = '68456' or property_zip = '68458' or property_zip = '68460' or property_zip = '68464' or property_zip = '68465' or property_zip = '68466' or property_zip = '68467' or property_zip = '68523' or property_zip = '68532' or property_zip = '68797' or property_zip = '68901' or property_zip = '68902' or property_zip = '68925' or property_zip = '68928' or property_zip = '68930' or property_zip = '68933' or property_zip = '68934' or property_zip = '68935' or property_zip = '68938' or property_zip = '68941' or property_zip = '68942' or property_zip = '68943' or property_zip = '68944' or property_zip = '68952' or property_zip = '68954' or property_zip = '68957' or property_zip = '68961' or property_zip = '68964' or property_zip = '68970' or property_zip = '68972' or property_zip = '68973' or property_zip = '68974' or property_zip = '68975' or property_zip = '68978' or property_zip = '68979' or property_zip = '68980') 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 ='66411' or zip = '66412' or zip = '66415' or zip = '66417' or zip = '66426' or zip = '66426' or zip = '66427' or zip = '66427' or zip = '66508' or zip = '66514' or zip = '66517' or zip = '66518' or zip = '66520' or zip = '66521' or zip = '66521' or zip = '66521' or zip = '66531' or zip = '66554' or zip = '66403' or zip = '66404' or zip = '66406' or zip = '66438' or zip = '66441' or zip = '66442' or zip = '66442' or zip = '66442' or zip = '66449' or zip = '66502' or zip = '66503' or zip = '66505' or zip = '66506' or zip = '66508' or zip = '66535' or zip = '66535' or zip = '66541' or zip = '66544' or zip = '66544' or zip = '66547' or zip = '66547' or zip = '66547' or zip = '66547' or zip = '66548' or zip = '66549' or zip = '66549' or zip = '66901' or zip = '66901' or zip = '66901' or zip = '66930' or zip = '66933' or zip = '66935' or zip = '66936' or zip = '66937' or zip = '66938' or zip = '66939' or zip = '66940' or zip = '66941' or zip = '66942' or zip = '66943' or zip = '66944' or zip = '66945' or zip = '66946' or zip = '66948' or zip = '66949' or zip = '66949' or zip = '66952' or zip = '66952' or zip = '66953' or zip = '66955' or zip = '66956' or zip = '66958' or zip = '66959' or zip = '66960' or zip = '66961' or zip = '66962' or zip = '66963' or zip = '66964' or zip = '66966' or zip = '66967' or zip = '66967' or zip = '66968' or zip = '66970' or zip = '67401' or zip = '67401' or zip = '67402' or zip = '67410' or zip = '67410' or zip = '67410' or zip = '67417' or zip = '67418' or zip = '67420' or zip = '67420' or zip = '67422' or zip = '67423' or zip = '67430' or zip = '67431' or zip = '67432' or zip = '67432' or zip = '67436' or zip = '67437' or zip = '67441' or zip = '67466' or zip = '67467' or zip = '67467' or zip = '67467' or zip = '67468' or zip = '67470' or zip = '67473' or zip = '67474' or zip = '67478' or zip = '67480' or zip = '67481' or zip = '67482' or zip = '67484' or zip = '67484' or zip = '67485' or zip = '67487' or zip = '67492' or zip = '67638' or zip = '67445' or zip = '67446' or zip = '67447' or zip = '67452' or zip = '67455' or zip = '67455' or zip = '67458' or zip = '68301' or zip = '68303' or zip = '68309' or zip = '68309' or zip = '68310' or zip = '68310' or zip = '68310' or zip = '68310' or zip = '68310' or zip = '68310' or zip = '68310' or zip = '68310' or zip = '68313' or zip = '68313' or zip = '68315' or zip = '68315' or zip = '68318' or zip = '68322' or zip = '68323' or zip = '68325' or zip = '68326' or zip = '68327' or zip = '68328' or zip = '68350' or zip = '68351' or zip = '68352' or zip = '68352' or zip = '68352' or zip = '68352' or zip = '68354' or zip = '68354' or zip = '68357' or zip = '68358' or zip = '68359' or zip = '68361' or zip = '68362' or zip = '68364' or zip = '68365' or zip = '68368' or zip = '68330' or zip = '68331' or zip = '68331' or zip = '68332' or zip = '68333' or zip = '68333' or zip = '68333' or zip = '68335' or zip = '68338' or zip = '68339' or zip = '68340' or zip = '68341' or zip = '68342' or zip = '68343' or zip = '68343' or zip = '68345' or zip = '68345' or zip = '68370' or zip = '68371' or zip = '68371' or zip = '68372' or zip = '68372' or zip = '68375' or zip = '68377' or zip = '68377' or zip = '68380' or zip = '68380' or zip = '68381' or zip = '68401' or zip = '68401' or zip = '68404' or zip = '68404' or zip = '68404' or zip = '68405' or zip = '68405' or zip = '68406' or zip = '68415' or zip = '68415' or zip = '68416' or zip = '68419' or zip = '68420' or zip = '68422' or zip = '68423' or zip = '68424' or zip = '68429' or zip = '68429' or zip = '68430' or zip = '68430' or zip = '68436' or zip = '68438' or zip = '68440' or zip = '68441' or zip = '68443' or zip = '68443' or zip = '68444' or zip = '68444' or zip = '68444' or zip = '68445' or zip = '68512' or zip = '68523' or zip = '68523' or zip = '68532' or zip = '68450' or zip = '68450' or zip = '68452' or zip = '68453' or zip = '68458' or zip = '68460' or zip = '68460' or zip = '68464' or zip = '68465' or zip = '68466' or zip = '68466' or zip = '68467' or zip = '68901' or zip = '68901' or zip = '68901' or zip = '68901' or zip = '68901' or zip = '68901' or zip = '68901' or zip = '68901' or zip = '68902' or zip = '68935' or zip = '68938' or zip = '68941' or zip = '68941' or zip = '68941' or zip = '68941' or zip = '68942' or zip = '68943' or zip = '68944' or zip = '68952' or zip = '68954' or zip = '68957' or zip = '68957' or zip = '68957' or zip = '68978' or zip = '68978' or zip = '68978' or zip = '68979' or zip = '68979' or zip = '68979' or zip = '68980' or zip = '68980' or zip = '68925' or zip = '68925' or zip = '68928' or zip = '68930' or zip = '68930' or zip = '68930' or zip = '68933' or zip = '68933' or zip = '68933' or zip = '68934' or zip = '68934' or zip = '68935' or zip = '68961' or zip = '68961' or zip = '68964' or zip = '68970' or zip = '68973' or zip = '68973' or zip = '68974' or zip = '68975' or zip = '66145' or zip = '66403' or zip = '66404' or zip = '66406' or zip = '66411' or zip = '66412' or zip = '66415' or zip = '66426' or zip = '66427' or zip = '66438' or zip = '66441' or zip = '66442' or zip = '66449' or zip = '66450' or zip = '66502' or zip = '66503' or zip = '66505' or zip = '66506' or zip = '66508' or zip = '66514' or zip = '66517' or zip = '66518' or zip = '66520' or zip = '66521' or zip = '66531' or zip = '66535' or zip = '66538' or zip = '66541' or zip = '66544' or zip = '66547' or zip = '66548' or zip = '66549' or zip = '66551' or zip = '66554' or zip = '66555' or zip = '66635' or zip = '66901' or zip = '66930' or zip = '66933' or zip = '66935' or zip = '66936' or zip = '66937' or zip = '66938' or zip = '66939' or zip = '66940' or zip = '66941' or zip = '66942' or zip = '66943' or zip = '66944' or zip = '66945' or zip = '66946' or zip = '66948' or zip = '66949' or zip = '66952' or zip = '66953' or zip = '66955' or zip = '66956' or zip = '66958' or zip = '66959' or zip = '66960' or zip = '66961' or zip = '66962' or zip = '66963' or zip = '66964' or zip = '66966' or zip = '66967' or zip = '66968' or zip = '66969' or zip = '66970' or zip = '66998' or zip = '67401' or zip = '67402' or zip = '67410' or zip = '67417' or zip = '67418' or zip = '67420' or zip = '67422' or zip = '67423' or zip = '67425' or zip = '67430' or zip = '67431' or zip = '67432' or zip = '67436' or zip = '67437' or zip = '67441' or zip = '67445' or zip = '67446' or zip = '67447' or zip = '67452' or zip = '67455' or zip = '67458' or zip = '67466' or zip = '67467' or zip = '67468' or zip = '67470' or zip = '67472' or zip = '67473' or zip = '67474' or zip = '67478' or zip = '67480' or zip = '67481' or zip = '67482' or zip = '67484' or zip = '67485' or zip = '67487' or zip = '67488' or zip = '67492' or zip = '67495' or zip = '67845' or zip = '67938' or zip = '68301' or zip = '68303' or zip = '68309' or zip = '68310' or zip = '68313' or zip = '68315' or zip = '68318' or zip = '68322' or zip = '68323' or zip = '68325' or zip = '68326' or zip = '68327' or zip = '68328' or zip = '68330' or zip = '68331' or zip = '68332' or zip = '68333' or zip = '68335' or zip = '68338' or zip = '68339' or zip = '68340' or zip = '68341' or zip = '68342' or zip = '68343' or zip = '68350' or zip = '68351' or zip = '68352' or zip = '68354' or zip = '68357' or zip = '68358' or zip = '68359' or zip = '68361' or zip = '68362' or zip = '68364' or zip = '68365' or zip = '68368' or zip = '68370' or zip = '68371' or zip = '68372' or zip = '68374' or zip = '68375' or zip = '68377' or zip = '68380' or zip = '68381' or zip = '68401' or zip = '68404' or zip = '68405' or zip = '68406' or zip = '68415' or zip = '68416' or zip = '68419' or zip = '68420' or zip = '68422' or zip = '68423' or zip = '68424' or zip = '68429' or zip = '68430' or zip = '68436' or zip = '68438' or zip = '68440' or zip = '68441' or zip = '68443' or zip = '68444' or zip = '68445' or zip = '68452' or zip = '68453' or zip = '68456' or zip = '68458' or zip = '68460' or zip = '68464' or zip = '68465' or zip = '68466' or zip = '68467' or zip = '68523' or zip = '68532' or zip = '68797' or zip = '68901' or zip = '68902' or zip = '68925' or zip = '68928' or zip = '68930' or zip = '68933' or zip = '68934' or zip = '68935' or zip = '68938' or zip = '68941' or zip = '68942' or zip = '68943' or zip = '68944' or zip = '68952' or zip = '68954' or zip = '68957' or zip = '68961' or zip = '68964' or zip = '68970' or zip = '68972' or zip = '68973' or zip = '68974' or zip = '68975' or zip = '68978' or zip = '68979' or zip = '68980')
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 = 'CUBA ' 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: