WALNUT, KS Investment Properties - Happy Home Investor
 

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



WALNUT 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 38 of 38 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
11/28/2019 9/5/2019 5/28/2020 4:35:30 PM 11/28/2019 Access for Free 67357 1930 9/5/2019 - 267 Days Ago RealtorValue 33900 39900 50200 0 50200 13104 2237.4 $28,815.00 $6,043.60 View Details
5/16/2020 9:30:04 AM 5/15/2020 5/28/2020 3:59:34 AM 5/16/2020 9:30:04 AM Access for Free 67357 1940 5/15/2020 - 14 Days Ago RealtorValue 37900 37900 63100 0 63100 15000 2501.4 $34,110.00 $11,488.60 View Details
11/28/2019 7/8/2019 5/28/2020 4:35:30 PM 11/28/2019 Access for Free 67357 1900 7/8/2019 - 326 Days Ago RealtorValue 42500 42500 54400 0 54400 11088 2805 $36,125.00 $4,382.00 View Details
3/4/2020 3/15/2020 5/28/2020 4:00:00 AM 3/4/2020 Access for Free 67357 1900 3/15/2020 - 75 Days Ago RealtorValue 75000 75000 96800 0 96800 15210 4950 $63,750.00 $12,890.00 View 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
Fort Scott KS
 
 
Overall Profit Summary
Purchase Price: $10,530
Estimated Repairs$24,357
Sales Price After Remodel$60,714
Total Profit Estimate$10,309
View Details

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

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

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 7.5! 
Investor-Deal!
Pittsburg KS
 
 
Overall Profit Summary
Purchase Price: $12,408
Estimated Repairs$13,321
Sales Price After Remodel$38,254
Total Profit Estimate$10,116
View Details

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

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

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5.5! 
Great Profit Potential
Parsons KS
 
 
Overall Profit Summary
Purchase Price: $21,605
Estimated Repairs$16,751
Sales Price After Remodel$54,443
Total Profit Estimate$12,723
View Details

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

Great Deal-Score of 6.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 6.5! 
Use the Tabs at the Top of This Page to Navigate the different types of properties!
Motivated Seller
Girard KS
 
 
Overall Profit Summary
Purchase Price: $24,160
Estimated Repairs$19,196
Sales Price After Remodel$68,292
Total Profit Estimate$11,582
View Details

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

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

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 7.5! 
Motivated Seller
Parsons KS
 
 
Overall Profit Summary
Purchase Price: $25,716
Estimated Repairs$25,395
Sales Price After Remodel$84,689
Total Profit Estimate$16,223
View Details

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

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

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5.5! 

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


UNLOCK MORE ACCESS FOR FREE!

  CREATE A FREE ACCOUNT --->





Motivated Seller
Parsons KS
 
 
Overall Profit Summary
Purchase Price: $28,532
Estimated Repairs$29,976
Sales Price After Remodel$94,852
Total Profit Estimate$16,139
View Details

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

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

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 7.5! 
Make Offer. High Profit.
Pittsburg KS
 
 
Overall Profit Summary
Purchase Price: $28,068
Estimated Repairs$22,673
Sales Price After Remodel$82,345
Total Profit Estimate$15,739
View Details

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

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

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

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

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

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

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

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

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

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

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 7.5! 
Motivated Seller
Pittsburg KS
 
 
Overall Profit Summary
Purchase Price: $35,078
Estimated Repairs$17,094
Sales Price After Remodel$75,188
Total Profit Estimate$10,334
View Details

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

Great Deal-Score of 7.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 7.5! 
Use the Tabs at the Top of This Page to Navigate the different types of properties!
Motivated Seller
Parsons KS
 
 
Overall Profit Summary
Purchase Price: $33,937
Estimated Repairs$22,376
Sales Price After Remodel$87,252
Total Profit Estimate$14,952
View Details

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

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

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

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

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

Great Deal-Score of 7.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 7.5! 
Investor-Deal!
Pittsburg KS
 
 
Overall Profit Summary
Purchase Price: $38,833
Estimated Repairs$17,687
Sales Price After Remodel$82,874
Total Profit Estimate$12,952
View Details

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

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

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

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

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

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

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

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

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

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

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5.5! 

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!
Parsons KS
 
 
Overall Profit Summary
Purchase Price: $39,998
Estimated Repairs$11,698
Sales Price After Remodel$72,896
Total Profit Estimate$11,342
View Details

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

 Motivated Seller!
Great Deal-Score of 9.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 High Deal Score of 9.5! 
Investor-Deal!
Parsons KS
 
 
Overall Profit Summary
Purchase Price: $44,247
Estimated Repairs$24,168
Sales Price After Remodel$101,837
Total Profit Estimate$15,736
View Details

Asking $53,500
 *  Listed 37 Days Ago
 *  Originally Listed on 4/22/2020.
 *  Deal Rating of 7.3/10

Great Deal-Score of 6.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 6.5! 
Great Profit Potential
Frontenac KS
 
 
Overall Profit Summary
Purchase Price: $48,339
Estimated Repairs$19,048
Sales Price After Remodel$94,596
Total Profit Estimate$12,482
View Details

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

 $1,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! 
Fix & Flip Investor-Deal
Fort Scott KS
 
 
Overall Profit Summary
Purchase Price: $50,450
Estimated Repairs$13,226
Sales Price After Remodel$87,451
Total Profit Estimate$12,353
View Details

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

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

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Great Deal Score of 9! 
Investor-Deal!
McCune KS
 
 
Overall Profit Summary
Purchase Price: $64,082
Estimated Repairs$15,234
Sales Price After Remodel$105,367
Total Profit Estimate$12,640
View Details

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

 $1,500 Below Appraisal
Great Deal-Score of 7!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 7! 
Use the Tabs at the Top of This Page to Navigate the different types of properties!
Priced Under Tax-Value!
Pittsburg KS
 
 
Overall Profit Summary
Purchase Price: $64,167
Estimated Repairs$15,794
Sales Price After Remodel$106,588
Total Profit Estimate$12,868
View Details

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

 $30,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! 
Fix & Flip Investor-Deal
Parsons KS
 
 
Overall Profit Summary
Purchase Price: $60,602
Estimated Repairs$28,548
Sales Price After Remodel$132,096
Total Profit Estimate$21,406
View Details

Asking $75,000
 *  Listed 75 Days Ago
 *  Originally Listed on 3/15/2020.
 *  Deal Rating of 6.9/10

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

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5.5! 
Great Profit Potential
Girard KS
 
 
Overall Profit Summary
Purchase Price: $63,768
Estimated Repairs$12,269
Sales Price After Remodel$102,538
Total Profit Estimate$14,727
View Details

Asking $78,000
 *  Listed 45 Days Ago
 *  Originally Listed on 4/14/2020.
 *  Deal Rating of 6.7/10

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

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5! 
Investor-Deal!
Girard KS
 
 
Overall Profit Summary
Purchase Price: $69,981
Estimated Repairs$12,200
Sales Price After Remodel$106,900
Total Profit Estimate$12,740
View Details

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

 $30,600 Below Appraisal
Great Deal-Score of 4!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 4! 
Fix & Flip Investor-Deal
Girard KS
 
 
Overall Profit Summary
Purchase Price: $80,601
Estimated Repairs$48,965
Sales Price After Remodel$202,931
Total Profit Estimate$37,720
View Details

Asking $105,000
 *  Price Reduced by $35,000 on 5/13/2020 8:53:56 PM.
 *  Originally Listed on 7/11/2018.
 *  Deal Rating of 6.9/10

 Reduced By $35,000
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!
Uniontown KS
 
 
Overall Profit Summary
Purchase Price: $97,534
Estimated Repairs$8,573
Sales Price After Remodel$132,638
Total Profit Estimate$19,268
View Details

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

 $11,500 Below Appraisal
Great Deal-Score of 6!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 6! 
Motivated Seller
Girard KS
 
 
Overall Profit Summary
Purchase Price: $100,913
Estimated Repairs$14,671
Sales Price After Remodel$144,343
Total Profit Estimate$13,484
View Details

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

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

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5! 

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


UNLOCK MORE ACCESS FOR FREE!

  CREATE A FREE ACCOUNT --->





Motivated Seller
Girard KS
 
 
Overall Profit Summary
Purchase Price: $109,688
Estimated Repairs$11,380
Sales Price After Remodel$147,760
Total Profit Estimate$12,876
View Details

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

 Fix & Flip!
Great Deal-Score of 8!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 8! 
Great Profit Potential
Pittsburg KS
 
 
Overall Profit Summary
Purchase Price: $107,516
Estimated Repairs$129,122
Sales Price After Remodel$388,245
Total Profit Estimate$65,692
View Details

Asking $130,000
 *  Listed 34 Days Ago
 *  Originally Listed on 4/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! 
Priced Under Tax-Value!
Pittsburg KS
 
 
Overall Profit Summary
Purchase Price: $107,801
Estimated Repairs$24,063
Sales Price After Remodel$183,125
Total Profit Estimate$29,159
View Details

Asking $135,000
 *  Listed 142 Days Ago
 *  Originally Listed on 1/8/2020.
 *  Deal Rating of 7.3/10

Great Deal-Score of 6.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 6.5! 
Fix & Flip Investor-Deal
Pittsburg KS
 
 
Overall Profit Summary
Purchase Price: $114,928
Estimated Repairs$22,843
Sales Price After Remodel$197,186
Total Profit Estimate$37,149
View Details

Asking $151,500
 *  Price Reduced by $18,000 on 12/2/2019.
 *  Originally Listed on 8/14/2019.
 *  Deal Rating of 6.9/10

 Reduced By $18,000
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.
Fort Scott KS
 
 
Overall Profit Summary
Purchase Price: $130,420
Estimated Repairs$27,562
Sales Price After Remodel$225,023
Total Profit Estimate$40,884
View Details

Asking $169,900
 *  Price Reduced by $5,000 on 3/11/2020.
 *  Originally Listed on 3/11/2020.
 *  Deal Rating of 6.9/10

 $60,200 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! 
Great Profit Potential
Pittsburg KS
 
 
Overall Profit Summary
Purchase Price: $139,385
Estimated Repairs$60,515
Sales Price After Remodel$293,531
Total Profit Estimate$47,228
View Details

Asking $172,500
 *  Listed 88 Days Ago
 *  Originally Listed on 3/2/2020.
 *  Deal Rating of 6.9/10

 $30,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! 
Investor-Deal!
Redfield KS
 
 
Overall Profit Summary
Purchase Price: $190,856
Estimated Repairs$24,070
Sales Price After Remodel$273,140
Total Profit Estimate$31,156
View Details

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

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

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 6! 
Motivated Seller
Fort Scott KS
 
 
Overall Profit Summary
Purchase Price: $272,513
Estimated Repairs$42,921
Sales Price After Remodel$410,842
Total Profit Estimate$51,352
View Details

Asking $325,000
 *  Listed 57 Days Ago
 *  Originally Listed on 4/2/2020.
 *  Deal Rating of 6.7/10

 $127,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
Parsons KS
 
 
Overall Profit Summary
Purchase Price: $274,365
Estimated Repairs$29,040
Sales Price After Remodel$393,080
Total Profit Estimate$53,536
View Details

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

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

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 4! 
Great Profit Potential
Pittsburg KS
 
 
Overall Profit Summary
Purchase Price: $285,831
Estimated Repairs$29,705
Sales Price After Remodel$408,410
Total Profit Estimate$55,559
View Details

Asking $349,000
 *  226 Days on Market
 *  Originally Listed on 10/16/2019.
 *  Deal Rating of 6.4/10

 $131,200 Below Appraisal
Great Deal-Score of 4!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 4! 
Fix & Flip Investor-Deal
Pittsburg KS
 
 
Overall Profit Summary
Purchase Price: $294,881
Estimated Repairs$24,864
Sales Price After Remodel$428,729
Total Profit Estimate$72,971
View Details

Asking $379,000
 *  Price Reduced by $20,000 on 1/10/2020.
 *  Originally Listed on 1/9/2020.
 *  Deal Rating of 6.4/10

 $42,300 Below Appraisal
 Reduced By $20,000
Great Deal-Score of 4!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

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

Discounted properties are homes for sale that are listed well below Trulia, Zillow, or other estimate measures. You will not find a list like this anywhere else. Enjoy!

Fort Scott KS 66701

Asking : $12,000.00

Researched Value : $20,700.00

$8,700.00 Below Researched Value

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

Below Researched Value

$8,700.00 Below Researched Value *****


View Details

Pittsburg KS 66762

Asking : $15,750.00

Researched Value : $19,000.00

$3,250.00 Below Researched Value

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

Below Researched Value

$3,250.00 Below Researched Value *****


View Details

Girard KS 66743

Asking : $29,900.00

Researched Value : $44,100.00

$14,200.00 Below Researched Value

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

Below Researched Value

$14,200.00 Below Researched Value *****


View Details

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

Parsons KS 67357

Asking : $33,900.00

Researched Value : $50,200.00

$16,300.00 Below Researched Value

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

Below Researched Value

$16,300.00 Below Researched Value *****


View Details

Parsons KS 67357

Asking : $34,900.00

Researched Value : $46,200.00

$11,300.00 Below Researched Value

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

Below Researched Value

$11,300.00 Below Researched Value *****


View Details


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


UNLOCK MORE ACCESS FOR FREE!

  CREATE A FREE ACCOUNT --->





Parsons KS 67357

Asking : $37,900.00

Researched Value : $63,100.00

$25,200.00 Below Researched Value

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

Below Researched Value

$25,200.00 Below Researched Value *****


View Details

Pittsburg KS 66762

Asking : $39,900.00

Researched Value : $46,000.00

$6,100.00 Below Researched Value

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

Below Researched Value

$6,100.00 Below Researched Value *****


View Details

Parsons KS 67357

Asking : $42,500.00

Researched Value : $54,400.00

$11,900.00 Below Researched Value

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

Below Researched Value

$11,900.00 Below Researched Value *****


View Details

Pittsburg KS 66762

Asking : $48,500.00

Researched Value : $67,700.00

$19,200.00 Below Researched Value

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

Below Researched Value

$19,200.00 Below Researched Value *****


View Details

Pittsburg KS 66762

Asking : $75,000.00

Researched Value : $105,500.00

$30,500.00 Below Researched Value

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

Below Researched Value

$30,500.00 Below Researched Value *****


View Details

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

Parsons KS 67357

Asking : $75,000.00

Researched Value : $96,800.00

$21,800.00 Below Researched Value

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

Below Researched Value

$21,800.00 Below Researched Value *****


View Details

Girard KS 66743

Asking : $78,000.00

Researched Value : $87,500.00

$9,500.00 Below Researched Value

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

Below Researched Value

$9,500.00 Below Researched Value *****


View Details

Girard KS 66743

Asking : $82,500.00

Researched Value : $113,100.00

$30,600.00 Below Researched Value

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

Below Researched Value

$30,600.00 Below Researched Value *****


View Details

Uniontown KS 66779

Asking : $114,000.00

Researched Value : $125,500.00

$11,500.00 Below Researched Value

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

Below Researched Value

$11,500.00 Below Researched Value *****


View Details

Girard KS 66743

Asking : $115,000.00

Researched Value : $132,800.00

$17,800.00 Below Researched Value

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

Below Researched Value

$17,800.00 Below Researched Value *****


View Details


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


UNLOCK MORE ACCESS FOR FREE!

  CREATE A FREE ACCOUNT --->





Fort Scott KS 66701

Asking : $169,900.00

Researched Value : $230,100.00

$60,200.00 Below Researched Value

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

Below Researched Value

$60,200.00 Below Researched Value *****


View Details

Pittsburg KS 66762

Asking : $172,500.00

Researched Value : $202,700.00

$30,200.00 Below Researched Value

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

Below Researched Value

$30,200.00 Below Researched Value *****


View Details

Fort Scott KS 66701

Asking : $325,000.00

Researched Value : $452,800.00

$127,800.00 Below Researched Value

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

Below Researched Value

$127,800.00 Below Researched Value *****


View Details

Parsons KS 67357

Asking : $335,000.00

Researched Value : $375,000.00

$40,000.00 Below Researched Value

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

Below Researched Value

$40,000.00 Below Researched Value *****


View Details

Pittsburg KS 66762

Asking : $349,000.00

Researched Value : $480,200.00

$131,200.00 Below Researched Value

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

Below Researched Value

$131,200.00 Below Researched Value *****


View Details

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

Pittsburg KS 66762

Asking : $379,000.00

Researched Value : $421,300.00

$42,300.00 Below Researched Value

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

Below Researched Value

$42,300.00 Below Researched Value *****


View Details

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

Jay - Lending $100,000.00

Lender Name : Jay Gee

Lender Type : individual

8% Rate

Lending: Nationwide

Lending at 8%


View Detail

Joseph - Lending $750,000.00

Lender Name : Joseph Amar

Lender Type : individual

8% Rate

Lending: Nationwide

Lending at 8%


View Detail

Mickey - Lending $250,000.00

Lender Name : Mickey Parson

Lender Type : individual

8% Rate

Lending: Nationwide

Lending at 8%


View Detail

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

Himendu - Lending $500,000.00

Lender Name : Himendu Chaudhuri

Lender Type : individual

7% Rate

Lending: Nationwide

Lending at 7%


View Detail

Alex - Lending $100,000.00

Lender Name : Alex Lugovoy

Lender Type : individual

7% Rate

Lending: Nationwide

Lending at 7%


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





Kurt - Lending $250,000.00

Lender Name : Kurt Elkins

Lender Type : individual

6% Rate

Lending: Nationwide

Lending at 6%


View Detail

Shavawn - Lending $1,000,001.00

Lender Name : Shavawn Morgan

Lender Type : individual

6% Rate

Lending: Nationwide

Lending at 6%


View Detail

Andrew - Lending $50,000.00

Lender Name : Andrew Choi

Lender Type : individual

7% Rate

Lending: Nationwide

Lending at 7%


View Detail

Sam - Lending $500,000.00

Lender Name : Sam Yousef

Lender Type : individual

9% Rate

Lending: Nationwide

Lending at 9%


View Detail

Brandon - Lending $100,000.00

Lender Name : Brandon Taylor

Lender Type : individual

4% Rate

Lending: Nationwide

Lending at 4%


View Detail

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

Khaled - Lending $250,000.00

Lender Name : Khaled Radwan

Lender Type : individual

3% Rate

Lending: Nationwide

Lending at 3%


View Detail

Deborah - Lending $100,000.00

Lender Name : Deborah Barnes

Lender Type : individual

9% Rate

Lending: Nationwide

Lending at 9%


View Detail

Kareem - Lending $1,000,001.00

Lender Name : Kareem Broughton

Lender Type : individual

9% Rate

Lending: Nationwide

Lending at 9%


View Detail

Mark - Lending $1,000,001.00

Lender Name : Mark Voelker

Lender Type : individual

7% Rate

Lending: Nationwide

Lending at 7%


View Detail

John - Lending $100,000.00

Lender Name : John Mitchell

Lender Type : individual

7% Rate

Lending: Nationwide

Lending at 7%


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





Charl - Lending $50,000.00

Lender Name : Charl Van Wyk

Lender Type : individual

6% Rate

Lending: Nationwide

Lending at 6%


View Detail

Paul - Lending $1,000,000.00

Lender Name : Paul Wells

Lender Type : individual

8% Rate

Lending: Nationwide

Lending at 8%


View Detail

Leonidas - Lending $250,000.00

Lender Name : Leonidas Vezos

Lender Type : individual

8% Rate

Lending: Nationwide

Lending at 8%


View Detail

Jason - Lending $50,000.00

Lender Name : Jason May

Lender Type : individual

9% Rate

Lending: Nationwide

Lending at 9%


View Detail

Moui - Lending $250,000.00

Lender Name : Moui Kata

Lender Type : individual

3% Rate

Lending: Nationwide

Lending at 3%


View Detail

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

Sam - Lending $1,000,000.00

Lender Name : Sam Vasi

Lender Type : individual

8% Rate

Lending: Nationwide

Lending at 8%


View Detail

Teddy - Lending $50,000.00

Lender Name : Teddy Verdecia

Lender Type : individual

3% Rate

Lending: Nationwide

Lending at 3%


View Detail

William - Lending $1,000,000.00

Lender Name : William Kubofcik

Lender Type : individual

6% Rate

Lending: Nationwide

Lending at 6%


View Detail

Andrey - Lending $50,000.00

Lender Name : Andrey Andrey

Lender Type : individual

5% Rate

Lending: Nationwide

Lending at 5%


View Detail

Joseph H - Lending $250,000.00

Lender Name : Joseph H Tran

Lender Type : individual

6% Rate

Lending: Nationwide

Lending at 6%


View Detail

Devica - Lending $100,000.00

Lender Name : Devica Seecharran

Lender Type : individual

6% Rate

Lending: Nationwide

Lending at 6%


View Detail

Robert - Lending $100,000.00

Lender Name : Robert Koehler

Lender Type : individual

5% Rate

Lending: Nationwide

Lending at 5%


View Detail

Reduced/Desperate Seller propeties are homes for sale that have been Reduced by at least 10% of the original sales price. These sellers are typically more desperate to sell their home fast. We are able to aggregate this list by tracking their previous sales prices. You will not find a list like this anywhere else. Enjoy!

Pittsburg KS 66762

Asking : $49,000.00

Original Price : $62,000.00

List Date : 12/19/2019

Reduced Price by $13,000.00

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

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

DOM: 162

Girard KS 66743

Asking : $105,000.00

Original Price : $140,000.00

List Date : 7/11/2018

Reduced Price by $35,000.00

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

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

DOM: 688

Pittsburg KS 66762

Asking : $151,500.00

Original Price : $169,500.00

List Date : 8/14/2019

Reduced Price by $18,000.00

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

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

DOM: 289

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

Parsons KS 67357

Asking : $49500

List Date : 3/24/2020

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


Motivated Seller

View Details!



Deal Score: 9.5

Fort Scott KS 66701

Asking : $61000

List Date : 5/6/2020

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


Sold As-Is

View Details!



Deal Score: 9

Girard KS 66743

Asking : $125000

List Date : 5/13/2020

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


Fix & Flip

View Details!



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

Redfield KS 66769

Asking : $225000

List Date : 4/24/2020

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


Investment Rental Property

View Details!



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

MULBERRY KS 66756

Bid : 22,000 or Less

Beds/Baths : 4 / 1

Year Built : 1928

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 ='66711' or zipCode = '66711' or zipCode = '66711' or zipCode = '66711' or zipCode = '66712' or zipCode = '66716' or zipCode = '66716' or zipCode = '66720' or zipCode = '66720' or zipCode = '66720' or zipCode = '66720' or zipCode = '66724' or zipCode = '66743' or zipCode = '66743' or zipCode = '66743' or zipCode = '66743' or zipCode = '66743' or zipCode = '66746' or zipCode = '66748' or zipCode = '66753' or zipCode = '66753' or zipCode = '66753' or zipCode = '66753' or zipCode = '66755' or zipCode = '66756' or zipCode = '66756' or zipCode = '66756' or zipCode = '66756' or zipCode = '66756' or zipCode = '66701' or zipCode = '66701' or zipCode = '66701' or zipCode = '66711' or zipCode = '66732' or zipCode = '66733' or zipCode = '66734' or zipCode = '66735' or zipCode = '66740' or zipCode = '66741' or zipCode = '66741' or zipCode = '66743' or zipCode = '66743' or zipCode = '66762' or zipCode = '66762' or zipCode = '66762' or zipCode = '66763' or zipCode = '66763' or zipCode = '66769' or zipCode = '66771' or zipCode = '66771' or zipCode = '66772' or zipCode = '66775' or zipCode = '66779' or zipCode = '66780' or zipCode = '66780' or zipCode = '66782' or zipCode = '66782' or zipCode = '67357' or zipCode = '66356' or zipCode = '66701' or zipCode = '66711' or zipCode = '66712' or zipCode = '66716' or zipCode = '66720' or zipCode = '66721' or zipCode = '66724' or zipCode = '66732' or zipCode = '66733' or zipCode = '66734' or zipCode = '66735' or zipCode = '66740' or zipCode = '66741' or zipCode = '66743' or zipCode = '66746' or zipCode = '66748' or zipCode = '66752' or zipCode = '66753' or zipCode = '66755' or zipCode = '66756' or zipCode = '66762' or zipCode = '66763' or zipCode = '66769' or zipCode = '66771' or zipCode = '66772' or zipCode = '66775' or zipCode = '66776' or zipCode = '66779' or zipCode = '66780' or zipCode = '66782' or zipCode = '67357')
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 ='66711' or zipCode = '66711' or zipCode = '66711' or zipCode = '66711' or zipCode = '66712' or zipCode = '66716' or zipCode = '66716' or zipCode = '66720' or zipCode = '66720' or zipCode = '66720' or zipCode = '66720' or zipCode = '66724' or zipCode = '66743' or zipCode = '66743' or zipCode = '66743' or zipCode = '66743' or zipCode = '66743' or zipCode = '66746' or zipCode = '66748' or zipCode = '66753' or zipCode = '66753' or zipCode = '66753' or zipCode = '66753' or zipCode = '66755' or zipCode = '66756' or zipCode = '66756' or zipCode = '66756' or zipCode = '66756' or zipCode = '66756' or zipCode = '66701' or zipCode = '66701' or zipCode = '66701' or zipCode = '66711' or zipCode = '66732' or zipCode = '66733' or zipCode = '66734' or zipCode = '66735' or zipCode = '66740' or zipCode = '66741' or zipCode = '66741' or zipCode = '66743' or zipCode = '66743' or zipCode = '66762' or zipCode = '66762' or zipCode = '66762' or zipCode = '66763' or zipCode = '66763' or zipCode = '66769' or zipCode = '66771' or zipCode = '66771' or zipCode = '66772' or zipCode = '66775' or zipCode = '66779' or zipCode = '66780' or zipCode = '66780' or zipCode = '66782' or zipCode = '66782' or zipCode = '67357' or zipCode = '66356' or zipCode = '66701' or zipCode = '66711' or zipCode = '66712' or zipCode = '66716' or zipCode = '66720' or zipCode = '66721' or zipCode = '66724' or zipCode = '66732' or zipCode = '66733' or zipCode = '66734' or zipCode = '66735' or zipCode = '66740' or zipCode = '66741' or zipCode = '66743' or zipCode = '66746' or zipCode = '66748' or zipCode = '66752' or zipCode = '66753' or zipCode = '66755' or zipCode = '66756' or zipCode = '66762' or zipCode = '66763' or zipCode = '66769' or zipCode = '66771' or zipCode = '66772' or zipCode = '66775' or zipCode = '66776' or zipCode = '66779' or zipCode = '66780' or zipCode = '66782' or zipCode = '67357')
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 ='66711' or zipCode = '66711' or zipCode = '66711' or zipCode = '66711' or zipCode = '66712' or zipCode = '66716' or zipCode = '66716' or zipCode = '66720' or zipCode = '66720' or zipCode = '66720' or zipCode = '66720' or zipCode = '66724' or zipCode = '66743' or zipCode = '66743' or zipCode = '66743' or zipCode = '66743' or zipCode = '66743' or zipCode = '66746' or zipCode = '66748' or zipCode = '66753' or zipCode = '66753' or zipCode = '66753' or zipCode = '66753' or zipCode = '66755' or zipCode = '66756' or zipCode = '66756' or zipCode = '66756' or zipCode = '66756' or zipCode = '66756' or zipCode = '66701' or zipCode = '66701' or zipCode = '66701' or zipCode = '66711' or zipCode = '66732' or zipCode = '66733' or zipCode = '66734' or zipCode = '66735' or zipCode = '66740' or zipCode = '66741' or zipCode = '66741' or zipCode = '66743' or zipCode = '66743' or zipCode = '66762' or zipCode = '66762' or zipCode = '66762' or zipCode = '66763' or zipCode = '66763' or zipCode = '66769' or zipCode = '66771' or zipCode = '66771' or zipCode = '66772' or zipCode = '66775' or zipCode = '66779' or zipCode = '66780' or zipCode = '66780' or zipCode = '66782' or zipCode = '66782' or zipCode = '67357' or zipCode = '66356' or zipCode = '66701' or zipCode = '66711' or zipCode = '66712' or zipCode = '66716' or zipCode = '66720' or zipCode = '66721' or zipCode = '66724' or zipCode = '66732' or zipCode = '66733' or zipCode = '66734' or zipCode = '66735' or zipCode = '66740' or zipCode = '66741' or zipCode = '66743' or zipCode = '66746' or zipCode = '66748' or zipCode = '66752' or zipCode = '66753' or zipCode = '66755' or zipCode = '66756' or zipCode = '66762' or zipCode = '66763' or zipCode = '66769' or zipCode = '66771' or zipCode = '66772' or zipCode = '66775' or zipCode = '66776' or zipCode = '66779' or zipCode = '66780' or zipCode = '66782' or zipCode = '67357') 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 ='66711' or zipCode = '66711' or zipCode = '66711' or zipCode = '66711' or zipCode = '66712' or zipCode = '66716' or zipCode = '66716' or zipCode = '66720' or zipCode = '66720' or zipCode = '66720' or zipCode = '66720' or zipCode = '66724' or zipCode = '66743' or zipCode = '66743' or zipCode = '66743' or zipCode = '66743' or zipCode = '66743' or zipCode = '66746' or zipCode = '66748' or zipCode = '66753' or zipCode = '66753' or zipCode = '66753' or zipCode = '66753' or zipCode = '66755' or zipCode = '66756' or zipCode = '66756' or zipCode = '66756' or zipCode = '66756' or zipCode = '66756' or zipCode = '66701' or zipCode = '66701' or zipCode = '66701' or zipCode = '66711' or zipCode = '66732' or zipCode = '66733' or zipCode = '66734' or zipCode = '66735' or zipCode = '66740' or zipCode = '66741' or zipCode = '66741' or zipCode = '66743' or zipCode = '66743' or zipCode = '66762' or zipCode = '66762' or zipCode = '66762' or zipCode = '66763' or zipCode = '66763' or zipCode = '66769' or zipCode = '66771' or zipCode = '66771' or zipCode = '66772' or zipCode = '66775' or zipCode = '66779' or zipCode = '66780' or zipCode = '66780' or zipCode = '66782' or zipCode = '66782' or zipCode = '67357' or zipCode = '66356' or zipCode = '66701' or zipCode = '66711' or zipCode = '66712' or zipCode = '66716' or zipCode = '66720' or zipCode = '66721' or zipCode = '66724' or zipCode = '66732' or zipCode = '66733' or zipCode = '66734' or zipCode = '66735' or zipCode = '66740' or zipCode = '66741' or zipCode = '66743' or zipCode = '66746' or zipCode = '66748' or zipCode = '66752' or zipCode = '66753' or zipCode = '66755' or zipCode = '66756' or zipCode = '66762' or zipCode = '66763' or zipCode = '66769' or zipCode = '66771' or zipCode = '66772' or zipCode = '66775' or zipCode = '66776' or zipCode = '66779' or zipCode = '66780' or zipCode = '66782' or zipCode = '67357') 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 ='66711' or zipCode = '66711' or zipCode = '66711' or zipCode = '66711' or zipCode = '66712' or zipCode = '66716' or zipCode = '66716' or zipCode = '66720' or zipCode = '66720' or zipCode = '66720' or zipCode = '66720' or zipCode = '66724' or zipCode = '66743' or zipCode = '66743' or zipCode = '66743' or zipCode = '66743' or zipCode = '66743' or zipCode = '66746' or zipCode = '66748' or zipCode = '66753' or zipCode = '66753' or zipCode = '66753' or zipCode = '66753' or zipCode = '66755' or zipCode = '66756' or zipCode = '66756' or zipCode = '66756' or zipCode = '66756' or zipCode = '66756' or zipCode = '66701' or zipCode = '66701' or zipCode = '66701' or zipCode = '66711' or zipCode = '66732' or zipCode = '66733' or zipCode = '66734' or zipCode = '66735' or zipCode = '66740' or zipCode = '66741' or zipCode = '66741' or zipCode = '66743' or zipCode = '66743' or zipCode = '66762' or zipCode = '66762' or zipCode = '66762' or zipCode = '66763' or zipCode = '66763' or zipCode = '66769' or zipCode = '66771' or zipCode = '66771' or zipCode = '66772' or zipCode = '66775' or zipCode = '66779' or zipCode = '66780' or zipCode = '66780' or zipCode = '66782' or zipCode = '66782' or zipCode = '67357' or zipCode = '66356' or zipCode = '66701' or zipCode = '66711' or zipCode = '66712' or zipCode = '66716' or zipCode = '66720' or zipCode = '66721' or zipCode = '66724' or zipCode = '66732' or zipCode = '66733' or zipCode = '66734' or zipCode = '66735' or zipCode = '66740' or zipCode = '66741' or zipCode = '66743' or zipCode = '66746' or zipCode = '66748' or zipCode = '66752' or zipCode = '66753' or zipCode = '66755' or zipCode = '66756' or zipCode = '66762' or zipCode = '66763' or zipCode = '66769' or zipCode = '66771' or zipCode = '66772' or zipCode = '66775' or zipCode = '66776' or zipCode = '66779' or zipCode = '66780' or zipCode = '66782' or zipCode = '67357') 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 ='66711' or zipCode = '66711' or zipCode = '66711' or zipCode = '66711' or zipCode = '66712' or zipCode = '66716' or zipCode = '66716' or zipCode = '66720' or zipCode = '66720' or zipCode = '66720' or zipCode = '66720' or zipCode = '66724' or zipCode = '66743' or zipCode = '66743' or zipCode = '66743' or zipCode = '66743' or zipCode = '66743' or zipCode = '66746' or zipCode = '66748' or zipCode = '66753' or zipCode = '66753' or zipCode = '66753' or zipCode = '66753' or zipCode = '66755' or zipCode = '66756' or zipCode = '66756' or zipCode = '66756' or zipCode = '66756' or zipCode = '66756' or zipCode = '66701' or zipCode = '66701' or zipCode = '66701' or zipCode = '66711' or zipCode = '66732' or zipCode = '66733' or zipCode = '66734' or zipCode = '66735' or zipCode = '66740' or zipCode = '66741' or zipCode = '66741' or zipCode = '66743' or zipCode = '66743' or zipCode = '66762' or zipCode = '66762' or zipCode = '66762' or zipCode = '66763' or zipCode = '66763' or zipCode = '66769' or zipCode = '66771' or zipCode = '66771' or zipCode = '66772' or zipCode = '66775' or zipCode = '66779' or zipCode = '66780' or zipCode = '66780' or zipCode = '66782' or zipCode = '66782' or zipCode = '67357' or zipCode = '66356' or zipCode = '66701' or zipCode = '66711' or zipCode = '66712' or zipCode = '66716' or zipCode = '66720' or zipCode = '66721' or zipCode = '66724' or zipCode = '66732' or zipCode = '66733' or zipCode = '66734' or zipCode = '66735' or zipCode = '66740' or zipCode = '66741' or zipCode = '66743' or zipCode = '66746' or zipCode = '66748' or zipCode = '66752' or zipCode = '66753' or zipCode = '66755' or zipCode = '66756' or zipCode = '66762' or zipCode = '66763' or zipCode = '66769' or zipCode = '66771' or zipCode = '66772' or zipCode = '66775' or zipCode = '66776' or zipCode = '66779' or zipCode = '66780' or zipCode = '66782' or zipCode = '67357') 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 ='66711' or zipCode = '66711' or zipCode = '66711' or zipCode = '66711' or zipCode = '66712' or zipCode = '66716' or zipCode = '66716' or zipCode = '66720' or zipCode = '66720' or zipCode = '66720' or zipCode = '66720' or zipCode = '66724' or zipCode = '66743' or zipCode = '66743' or zipCode = '66743' or zipCode = '66743' or zipCode = '66743' or zipCode = '66746' or zipCode = '66748' or zipCode = '66753' or zipCode = '66753' or zipCode = '66753' or zipCode = '66753' or zipCode = '66755' or zipCode = '66756' or zipCode = '66756' or zipCode = '66756' or zipCode = '66756' or zipCode = '66756' or zipCode = '66701' or zipCode = '66701' or zipCode = '66701' or zipCode = '66711' or zipCode = '66732' or zipCode = '66733' or zipCode = '66734' or zipCode = '66735' or zipCode = '66740' or zipCode = '66741' or zipCode = '66741' or zipCode = '66743' or zipCode = '66743' or zipCode = '66762' or zipCode = '66762' or zipCode = '66762' or zipCode = '66763' or zipCode = '66763' or zipCode = '66769' or zipCode = '66771' or zipCode = '66771' or zipCode = '66772' or zipCode = '66775' or zipCode = '66779' or zipCode = '66780' or zipCode = '66780' or zipCode = '66782' or zipCode = '66782' or zipCode = '67357' or zipCode = '66356' or zipCode = '66701' or zipCode = '66711' or zipCode = '66712' or zipCode = '66716' or zipCode = '66720' or zipCode = '66721' or zipCode = '66724' or zipCode = '66732' or zipCode = '66733' or zipCode = '66734' or zipCode = '66735' or zipCode = '66740' or zipCode = '66741' or zipCode = '66743' or zipCode = '66746' or zipCode = '66748' or zipCode = '66752' or zipCode = '66753' or zipCode = '66755' or zipCode = '66756' or zipCode = '66762' or zipCode = '66763' or zipCode = '66769' or zipCode = '66771' or zipCode = '66772' or zipCode = '66775' or zipCode = '66776' or zipCode = '66779' or zipCode = '66780' or zipCode = '66782' or zipCode = '67357') 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 theType is not null and theType != 'Foreclosure' and theType != 'Expiring' and theType != 'Foreclosures' 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 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 ='66711' or zipCode = '66711' or zipCode = '66711' or zipCode = '66711' or zipCode = '66712' or zipCode = '66716' or zipCode = '66716' or zipCode = '66720' or zipCode = '66720' or zipCode = '66720' or zipCode = '66720' or zipCode = '66724' or zipCode = '66743' or zipCode = '66743' or zipCode = '66743' or zipCode = '66743' or zipCode = '66743' or zipCode = '66746' or zipCode = '66748' or zipCode = '66753' or zipCode = '66753' or zipCode = '66753' or zipCode = '66753' or zipCode = '66755' or zipCode = '66756' or zipCode = '66756' or zipCode = '66756' or zipCode = '66756' or zipCode = '66756' or zipCode = '66701' or zipCode = '66701' or zipCode = '66701' or zipCode = '66711' or zipCode = '66732' or zipCode = '66733' or zipCode = '66734' or zipCode = '66735' or zipCode = '66740' or zipCode = '66741' or zipCode = '66741' or zipCode = '66743' or zipCode = '66743' or zipCode = '66762' or zipCode = '66762' or zipCode = '66762' or zipCode = '66763' or zipCode = '66763' or zipCode = '66769' or zipCode = '66771' or zipCode = '66771' or zipCode = '66772' or zipCode = '66775' or zipCode = '66779' or zipCode = '66780' or zipCode = '66780' or zipCode = '66782' or zipCode = '66782' or zipCode = '67357' or zipCode = '66356' or zipCode = '66701' or zipCode = '66711' or zipCode = '66712' or zipCode = '66716' or zipCode = '66720' or zipCode = '66721' or zipCode = '66724' or zipCode = '66732' or zipCode = '66733' or zipCode = '66734' or zipCode = '66735' or zipCode = '66740' or zipCode = '66741' or zipCode = '66743' or zipCode = '66746' or zipCode = '66748' or zipCode = '66752' or zipCode = '66753' or zipCode = '66755' or zipCode = '66756' or zipCode = '66762' or zipCode = '66763' or zipCode = '66769' or zipCode = '66771' or zipCode = '66772' or zipCode = '66775' or zipCode = '66776' or zipCode = '66779' or zipCode = '66780' or zipCode = '66782' or zipCode = '67357') order by price asc;: End Combined
select top 240 * from tblBothNew NOLOCK where priority is null and price > 5000 and (1=1 or 1=1) and original_price is not null and (status='active' or status='for_sale' or status is null) and (propertyType !='land' or propertyType is null) and len(photoURL1) > 5 and dateposted >= '4/29/2020' and 1=1 and 1=1 and theType = 'Keyword' and keywordType != 'Investment Property' and price > 10000 and original_price > 10000 and (1=1) and price >= 0 and price <= 100000000 and 11=11 and (zipCode ='66711' or zipCode = '66711' or zipCode = '66711' or zipCode = '66711' or zipCode = '66712' or zipCode = '66716' or zipCode = '66716' or zipCode = '66720' or zipCode = '66720' or zipCode = '66720' or zipCode = '66720' or zipCode = '66724' or zipCode = '66743' or zipCode = '66743' or zipCode = '66743' or zipCode = '66743' or zipCode = '66743' or zipCode = '66746' or zipCode = '66748' or zipCode = '66753' or zipCode = '66753' or zipCode = '66753' or zipCode = '66753' or zipCode = '66755' or zipCode = '66756' or zipCode = '66756' or zipCode = '66756' or zipCode = '66756' or zipCode = '66756' or zipCode = '66701' or zipCode = '66701' or zipCode = '66701' or zipCode = '66711' or zipCode = '66732' or zipCode = '66733' or zipCode = '66734' or zipCode = '66735' or zipCode = '66740' or zipCode = '66741' or zipCode = '66741' or zipCode = '66743' or zipCode = '66743' or zipCode = '66762' or zipCode = '66762' or zipCode = '66762' or zipCode = '66763' or zipCode = '66763' or zipCode = '66769' or zipCode = '66771' or zipCode = '66771' or zipCode = '66772' or zipCode = '66775' or zipCode = '66779' or zipCode = '66780' or zipCode = '66780' or zipCode = '66782' or zipCode = '66782' or zipCode = '67357' or zipCode = '66356' or zipCode = '66701' or zipCode = '66711' or zipCode = '66712' or zipCode = '66716' or zipCode = '66720' or zipCode = '66721' or zipCode = '66724' or zipCode = '66732' or zipCode = '66733' or zipCode = '66734' or zipCode = '66735' or zipCode = '66740' or zipCode = '66741' or zipCode = '66743' or zipCode = '66746' or zipCode = '66748' or zipCode = '66752' or zipCode = '66753' or zipCode = '66755' or zipCode = '66756' or zipCode = '66762' or zipCode = '66763' or zipCode = '66769' or zipCode = '66771' or zipCode = '66772' or zipCode = '66775' or zipCode = '66776' or zipCode = '66779' or zipCode = '66780' or zipCode = '66782' or zipCode = '67357') order by price;
select top 45 * from house NOLOCK where 1=1 and (1=1) and 1=1 and 1=1 and 11=11 and (property_zip ='66711' or property_zip = '66711' or property_zip = '66711' or property_zip = '66711' or property_zip = '66712' or property_zip = '66716' or property_zip = '66716' or property_zip = '66720' or property_zip = '66720' or property_zip = '66720' or property_zip = '66720' or property_zip = '66724' or property_zip = '66743' or property_zip = '66743' or property_zip = '66743' or property_zip = '66743' or property_zip = '66743' or property_zip = '66746' or property_zip = '66748' or property_zip = '66753' or property_zip = '66753' or property_zip = '66753' or property_zip = '66753' or property_zip = '66755' or property_zip = '66756' or property_zip = '66756' or property_zip = '66756' or property_zip = '66756' or property_zip = '66756' or property_zip = '66701' or property_zip = '66701' or property_zip = '66701' or property_zip = '66711' or property_zip = '66732' or property_zip = '66733' or property_zip = '66734' or property_zip = '66735' or property_zip = '66740' or property_zip = '66741' or property_zip = '66741' or property_zip = '66743' or property_zip = '66743' or property_zip = '66762' or property_zip = '66762' or property_zip = '66762' or property_zip = '66763' or property_zip = '66763' or property_zip = '66769' or property_zip = '66771' or property_zip = '66771' or property_zip = '66772' or property_zip = '66775' or property_zip = '66779' or property_zip = '66780' or property_zip = '66780' or property_zip = '66782' or property_zip = '66782' or property_zip = '67357' or property_zip = '66356' or property_zip = '66701' or property_zip = '66711' or property_zip = '66712' or property_zip = '66716' or property_zip = '66720' or property_zip = '66721' or property_zip = '66724' or property_zip = '66732' or property_zip = '66733' or property_zip = '66734' or property_zip = '66735' or property_zip = '66740' or property_zip = '66741' or property_zip = '66743' or property_zip = '66746' or property_zip = '66748' or property_zip = '66752' or property_zip = '66753' or property_zip = '66755' or property_zip = '66756' or property_zip = '66762' or property_zip = '66763' or property_zip = '66769' or property_zip = '66771' or property_zip = '66772' or property_zip = '66775' or property_zip = '66776' or property_zip = '66779' or property_zip = '66780' or property_zip = '66782' or property_zip = '67357') and convert(date,auction_start_date) >= '5/28/2020';
select top 45 * from currentforeclosures.tblAll NOLOCK where state = 'KS '
select top 4500 * from currentforeclosures.tblAll NOLOCK where 1=2
select top 45 * from currentforeclosures.tblAll NOLOCK where len(PhotoURL1) > 2 and photoURL1 <> 'no_pic2.jpg';
select top 47 * from currentforeclosures.tblWholesaleDeals NOLOCK where len(image_name1) > 2 and image_name1 <> 'no_pic2.jpg' and date_posted >= '4/29/2020' and (1=1) and asking_price >= 0 and asking_price <= 100000000 and 11=11 and (zip ='66711' or zip = '66711' or zip = '66711' or zip = '66711' or zip = '66712' or zip = '66716' or zip = '66716' or zip = '66720' or zip = '66720' or zip = '66720' or zip = '66720' or zip = '66724' or zip = '66743' or zip = '66743' or zip = '66743' or zip = '66743' or zip = '66743' or zip = '66746' or zip = '66748' or zip = '66753' or zip = '66753' or zip = '66753' or zip = '66753' or zip = '66755' or zip = '66756' or zip = '66756' or zip = '66756' or zip = '66756' or zip = '66756' or zip = '66701' or zip = '66701' or zip = '66701' or zip = '66711' or zip = '66732' or zip = '66733' or zip = '66734' or zip = '66735' or zip = '66740' or zip = '66741' or zip = '66741' or zip = '66743' or zip = '66743' or zip = '66762' or zip = '66762' or zip = '66762' or zip = '66763' or zip = '66763' or zip = '66769' or zip = '66771' or zip = '66771' or zip = '66772' or zip = '66775' or zip = '66779' or zip = '66780' or zip = '66780' or zip = '66782' or zip = '66782' or zip = '67357' or zip = '66356' or zip = '66701' or zip = '66711' or zip = '66712' or zip = '66716' or zip = '66720' or zip = '66721' or zip = '66724' or zip = '66732' or zip = '66733' or zip = '66734' or zip = '66735' or zip = '66740' or zip = '66741' or zip = '66743' or zip = '66746' or zip = '66748' or zip = '66752' or zip = '66753' or zip = '66755' or zip = '66756' or zip = '66762' or zip = '66763' or zip = '66769' or zip = '66771' or zip = '66772' or zip = '66775' or zip = '66776' or zip = '66779' or zip = '66780' or zip = '66782' or zip = '67357')
select top 45 * from currentforeclosures.tblWholesaleDeals NOLOCK where len(image_name1) > 2 and image_name1 <> 'no_pic2.jpg' and date_posted >= '8/3/2019' and 1=1 and state = 'KS' and city = 'WALNUT ' 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: