WEBBER, KS Investment Properties - Happy Home Investor
 

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



WEBBER 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 48 of 48 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!

Make Offer. High Profit.
Clay Center KS
 
 
Overall Profit Summary
Purchase Price: $22,394
Estimated Repairs$23,038
Sales Price After Remodel$72,477
Total Profit Estimate$11,539
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! 
Make Offer. High Profit.
Beatrice NE
 
 
Overall Profit Summary
Purchase Price: $23,716
Estimated Repairs$10,973
Sales Price After Remodel$48,906
Total Profit Estimate$11,313
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! 
Investor-Deal!
Beatrice NE
 
 
Overall Profit Summary
Purchase Price: $31,809
Estimated Repairs$18,751
Sales Price After Remodel$75,003
Total Profit Estimate$10,941
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! 
Use the Tabs at the Top of This Page to Navigate the different types of properties!
Great Profit Potential
Beatrice NE
 
 
Overall Profit Summary
Purchase Price: $33,067
Estimated Repairs$24,494
Sales Price After Remodel$88,887
Total Profit Estimate$14,191
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! 
Great Profit Potential
Clay Center KS
 
 
Overall Profit Summary
Purchase Price: $35,100
Estimated Repairs$22,161
Sales Price After Remodel$84,321
Total Profit Estimate$11,343
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! 

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.
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! 
Motivated Seller
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! 
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! 
Fix & Flip Investor-Deal
Grand Island NE
 
 
Overall Profit Summary
Purchase Price: $59,889
Estimated Repairs$11,550
Sales Price After Remodel$93,100
Total Profit Estimate$10,765
View Details

Asking $70,000
 *  Listed 16 Days Ago
 *  Originally Listed on 5/13/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
Grand Island NE
 
 
Overall Profit Summary
Purchase Price: $65,403
Estimated Repairs$11,550
Sales Price After Remodel$103,100
Total Profit Estimate$14,702
View Details

Asking $80,000
 *  Listed 59 Days Ago
 *  Originally Listed on 3/31/2020.
 *  Deal Rating of 6.9/10

 $10,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! 
Use the Tabs at the Top of This Page to Navigate the different types of properties!
Great Profit Potential
Giltner NE
 
 
Overall Profit Summary
Purchase Price: $67,709
Estimated Repairs$14,722
Sales Price After Remodel$114,445
Total Profit Estimate$18,358
View Details

Asking $85,000
 *  Price Reduced by $5,000 on 4/14/2020.
 *  Originally Listed on 4/14/2020.
 *  Great Deal Rating of 8.2/10

 $1,900 Below Appraisal
 Reduced By $5,000
 Flip - Needs Repairs!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Great Deal Score of 9! 
Priced Under Tax-Value!
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! 
Great Profit Potential
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! 
Fix & Flip Investor-Deal
Grand Island NE
 
 
Overall Profit Summary
Purchase Price: $73,963
Estimated Repairs$11,550
Sales Price After Remodel$120,600
Total Profit Estimate$22,679
View Details

Asking $97,500
 *  Price Reduced by $12,400 on 2/7/2020.
 *  Originally Listed on 2/6/2020.
 *  Deal Rating of 6.9/10

 $9,600 Below Appraisal
 Reduced By $12,400
Great Deal-Score of 5.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5.5! 
Motivated Seller
Grand Island NE
 
 
Overall Profit Summary
Purchase Price: $79,773
Estimated Repairs$12,776
Sales Price After Remodel$125,452
Total Profit Estimate$19,615
View Details

Asking $99,900
 *  203 Days on Market
 *  Originally Listed on 11/8/2019.
 *  Deal Rating of 6.9/10

Great Deal-Score of 5.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5.5! 

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


UNLOCK MORE ACCESS FOR FREE!

  CREATE A FREE ACCOUNT --->





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! 
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.
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! 
Make Offer. High Profit.
Grand Island NE
 
 
Overall Profit Summary
Purchase Price: $99,816
Estimated Repairs$13,200
Sales Price After Remodel$151,400
Total Profit Estimate$23,457
View Details

Asking $125,000
 *  Listed 114 Days Ago
 *  Originally Listed on 2/5/2020.
 *  Deal Rating of 6.9/10

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

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5.5! 
Great Profit Potential
Grand Island NE
 
 
Overall Profit Summary
Purchase Price: $103,630
Estimated Repairs$17,890
Sales Price After Remodel$170,781
Total Profit Estimate$30,922
View Details

Asking $135,000
 *  Price Reduced by $15,000 on 12/1/2019.
 *  Originally Listed on 10/30/2018.
 *  Deal Rating of 6.9/10

 Reduced By $15,000
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!
Investor-Deal!
Grand Island NE
 
 
Overall Profit Summary
Purchase Price: $119,693
Estimated Repairs$13,200
Sales Price After Remodel$166,300
Total Profit Estimate$17,660
View Details

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

 $89,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
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
Grand Island NE
 
 
Overall Profit Summary
Purchase Price: $122,816
Estimated Repairs$13,200
Sales Price After Remodel$174,900
Total Profit Estimate$22,665
View Details

Asking $148,500
 *  Listed 35 Days Ago
 *  Originally Listed on 4/24/2020.
 *  Deal Rating of 6.9/10

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

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5.5! 
Great Profit Potential
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! 
Fix & Flip Investor-Deal
Grand Island NE
 
 
Overall Profit Summary
Purchase Price: $131,671
Estimated Repairs$13,200
Sales Price After Remodel$180,300
Total Profit Estimate$18,912
View Details

Asking $153,900
 *  Listed 14 Days Ago
 *  Originally Listed on 5/15/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.
Clay Center KS
 
 
Overall Profit Summary
Purchase Price: $139,029
Estimated Repairs$6,270
Sales Price After Remodel$179,296
Total Profit Estimate$24,334
View Details

Asking $162,500
 *  New! Listed 9 Day(s) Ago
 *  Originally Listed on 5/20/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
Clay Center KS
 
 
Overall Profit Summary
Purchase Price: $139,029
Estimated Repairs$6,270
Sales Price After Remodel$179,296
Total Profit Estimate$24,334
View Details

Asking $162,500
 *  New! Listed 9 Day(s) Ago
 *  Originally Listed on 5/20/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! 

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!
Beatrice NE
 
 
Overall Profit Summary
Purchase Price: $133,244
Estimated Repairs$29,885
Sales Price After Remodel$224,670
Total Profit Estimate$34,241
View Details

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

 $431,085 Below Tax Val
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!
Grand Island NE
 
 
Overall Profit Summary
Purchase Price: $133,325
Estimated Repairs$13,200
Sales Price After Remodel$191,400
Total Profit Estimate$27,748
View Details

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

 $14,162 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! 
Motivated Seller
Wakefield KS
 
 
Overall Profit Summary
Purchase Price: $136,205
Estimated Repairs$21,578
Sales Price After Remodel$216,155
Total Profit Estimate$35,695
View Details

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

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

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5! 
Motivated Seller
Grand Island NE
 
 
Overall Profit Summary
Purchase Price: $141,405
Estimated Repairs$13,200
Sales Price After Remodel$201,400
Total Profit Estimate$29,118
View Details

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

Great Deal-Score of 5.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5.5! 
Priced Under Tax-Value!
Fairfield NE
 
 
Overall Profit Summary
Purchase Price: $152,303
Estimated Repairs$21,483
Sales Price After Remodel$231,965
Total Profit Estimate$34,680
View Details

Asking $189,000
 *  Price Reduced by $10,900 on 4/28/2020 2:28:46 AM.
 *  Originally Listed on 4/28/2020.
 *  Deal Rating of 6.7/10

 Reduced By $10,900
Great Deal-Score of 5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5! 
Great Profit Potential
Grand Island NE
 
 
Overall Profit Summary
Purchase Price: $161,701
Estimated Repairs$14,352
Sales Price After Remodel$220,127
Total Profit Estimate$32,017
View Details

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

 $25,400 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!
Grand Island NE
 
 
Overall Profit Summary
Purchase Price: $167,105
Estimated Repairs$13,200
Sales Price After Remodel$223,400
Total Profit Estimate$24,208
View Details

Asking $197,000
 *  Listed 21 Days Ago
 *  Originally Listed on 5/8/2020.
 *  Deal Rating of 6.7/10

 $25,700 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
Grand Island NE
 
 
Overall Profit Summary
Purchase Price: $171,093
Estimated Repairs$11,979
Sales Price After Remodel$243,858
Total Profit Estimate$41,384
View Details

Asking $219,900
 *  Price Reduced by $20,000 on 12/1/2019.
 *  Originally Listed on 9/30/2019.
 *  Deal Rating of 6.4/10

 Reduced By $20,000
Great Deal-Score of 4!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 4! 
Fix & Flip Investor-Deal
Grand Island NE
 
 
Overall Profit Summary
Purchase Price: $190,856
Estimated Repairs$7,425
Sales Price After Remodel$239,850
Total Profit Estimate$24,665
View Details

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

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

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 4! 
Investor-Deal!
Grand Island NE
 
 
Overall Profit Summary
Purchase Price: $184,940
Estimated Repairs$14,850
Sales Price After Remodel$264,600
Total Profit Estimate$42,832
View Details

Asking $234,900
 *  Price Reduced by $5,000 on 2/26/2020.
 *  Originally Listed on 2/24/2020.
 *  Great Deal Rating of 8.2/10

 Reduced By $5,000
 Motivated Seller!
Great Deal-Score of 9!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Great Deal Score of 9! 
Motivated Seller
Grand Island NE
 
 
Overall Profit Summary
Purchase Price: $182,764
Estimated Repairs$7,425
Sales Price After Remodel$249,750
Total Profit Estimate$42,112
View Details

Asking $234,900
 *  Price Reduced by $15,000 on 12/1/2019.
 *  Originally Listed on 9/18/2019.
 *  Deal Rating of 6.4/10

 Reduced By $15,000
Great Deal-Score of 4!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 4! 
Great Profit Potential
Hastings NE
 
 
Overall Profit Summary
Purchase Price: $196,151
Estimated Repairs$15,756
Sales Price After Remodel$271,013
Total Profit Estimate$36,322
View Details

Asking $239,500
 *  Listed 122 Days Ago
 *  Originally Listed on 1/28/2020.
 *  Deal Rating of 6.4/10

 $29,800 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 --->





Fix & Flip Investor-Deal
Hastings NE
 
 
Overall Profit Summary
Purchase Price: $255,743
Estimated Repairs$20,961
Sales Price After Remodel$346,921
Total Profit Estimate$40,657
View Details

Asking $305,000
 *  Listed 49 Days Ago
 *  Originally Listed on 4/10/2020.
 *  Deal Rating of 6.4/10

 $75,200 Below Appraisal
 $25,875 Below Tax Val
Great Deal-Score of 4!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 4! 
Investor-Deal!
Beatrice NE
 
 
Overall Profit Summary
Purchase Price: $294,931
Estimated Repairs$60,016
Sales Price After Remodel$485,032
Total Profit Estimate$73,400
View Details

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

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

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5.5! 
Fix & Flip Investor-Deal
Grand Island NE
 
 
Overall Profit Summary
Purchase Price: $295,581
Estimated Repairs$24,250
Sales Price After Remodel$428,399
Total Profit Estimate$72,882
View Details

Asking $379,900
 *  Price Reduced by $20,000 on 12/1/2019.
 *  Originally Listed on 4/25/2019.
 *  Deal Rating of 6.4/10

 Reduced By $20,000
Great Deal-Score of 4!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 4! 
Great Profit Potential
Grand Island NE
 
 
Overall Profit Summary
Purchase Price: $333,584
Estimated Repairs$7,838
Sales Price After Remodel$418,366
Total Profit Estimate$54,593
View Details

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

 $118,200 Below Appraisal
Great Deal-Score of 5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5! 
Motivated Seller
Grand Island NE
 
 
Overall Profit Summary
Purchase Price: $414,292
Estimated Repairs$26,473
Sales Price After Remodel$552,846
Total Profit Estimate$68,438
View Details

Asking $499,900
 *  Listed 78 Days Ago
 *  Originally Listed on 3/12/2020.
 *  Deal Rating of 6.4/10

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

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 4! 
Make Offer. High Profit.
Hastings NE
 
 
Overall Profit Summary
Purchase Price: $479,098
Estimated Repairs$95,554
Sales Price After Remodel$740,107
Total Profit Estimate$76,973
View Details

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

Great Deal-Score of 5.5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 5.5! 
Motivated Seller
Hastings NE
 
 
Overall Profit Summary
Purchase Price: $515,847
Estimated Repairs$44,072
Sales Price After Remodel$738,144
Total Profit Estimate$115,591
View Details

Asking $650,000
 *  Price Reduced by $45,000 on 12/4/2019.
 *  Originally Listed on 10/21/2019.
 *  Deal Rating of 6.4/10

 Reduced By $45,000
Great Deal-Score of 4!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 4! 
Priced Under Tax-Value!
Grand Island NE
 
 
Overall Profit Summary
Purchase Price: $555,448
Estimated Repairs$53,279
Sales Price After Remodel$806,457
Total Profit Estimate$126,736
View Details

Asking $699,900
 *  Price Reduced by $50,000 on 12/1/2019.
 *  Originally Listed on 7/17/2019.
 *  Deal Rating of 6.4/10

 Reduced By $50,000
Great Deal-Score of 4!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 4! 
Motivated Seller
Grand Island NE
 
 
Overall Profit Summary
Purchase Price: $716,836
Estimated Repairs$18,150
Sales Price After Remodel$884,300
Total Profit Estimate$91,603
View Details

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

 $154,400 Below Appraisal
Great Deal-Score of 5!

"Cherry Picked" using 30+ metrics!

View Details!

View in New Window!!

 Deal Score of 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 $250,000.00

Lender Name : Ben Hoff

Lender Type : individual

7% Rate

Lending: Nationwide

Lending at 7%


View Detail

Martha - Lending $500,000.00

Lender Name : Martha Rodriguez

Lender Type : individual

4% Rate

Lending: Nationwide

Lending at 4%


View Detail

Henrik - Lending $1,000,000.00

Lender Name : Henrik Khechoom

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!

Teddy - Lending $1,000,001.00

Lender Name : Teddy Hill

Lender Type : individual

6% Rate

Lending: Nationwide

Lending at 6%


View Detail

Sarah - Lending $250,000.00

Lender Name : Sarah Brown

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





Roberto - Lending $1,000,001.00

Lender Name : Roberto Varela

Lender Type : individual

6% Rate

Lending: Nationwide

Lending at 6%


View Detail

Brian - Lending $100,000.00

Lender Name : Brian Flack

Lender Type : individual

8% Rate

Lending: Nationwide

Lending at 8%


View Detail

Ben - Lending $250,000.00

Lender Name : Ben Silliman

Lender Type : individual

8% Rate

Lending: Nationwide

Lending at 8%


View Detail

Raavinder - Lending $1,000,001.00

Lender Name : Raavinder Sharma

Lender Type : individual

8% Rate

Lending: Nationwide

Lending at 8%


View Detail

Jay - Lending $50,000.00

Lender Name : Jay Kaufman

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!

Greg - Lending $250,000.00

Lender Name : Greg Ellis

Lender Type : individual

5% Rate

Lending: Nationwide

Lending at 5%


View Detail

Rebecca - Lending $100,000.00

Lender Name : Rebecca Kwan

Lender Type : individual

9% Rate

Lending: Nationwide

Lending at 9%


View Detail

Alex - Lending $1,000,001.00

Lender Name : Alex Zand

Lender Type : individual

7% Rate

Lending: Nationwide

Lending at 7%


View Detail

Sarah - Lending $100,000.00

Lender Name : Sarah Ryan

Lender Type : individual

7% Rate

Lending: Nationwide

Lending at 7%


View Detail

James - Lending $250,000.00

Lender Name : James Evans

Lender Type : individual

4% Rate

Lending: Nationwide

Lending at 4%


View Detail


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


UNLOCK MORE ACCESS FOR FREE!

  CREATE A FREE ACCOUNT --->





Shehla - Lending $50,000.00

Lender Name : Shehla Khan

Lender Type : individual

4% Rate

Lending: Nationwide

Lending at 4%


View Detail

Rodney - Lending $1,000,001.00

Lender Name : Rodney Walker

Lender Type : individual

8% Rate

Lending: Nationwide

Lending at 8%


View Detail

Bill - Lending $50,000.00

Lender Name : Bill Herrera

Lender Type : individual

6% Rate

Lending: Nationwide

Lending at 6%


View Detail

Giorgio - Lending $500,000.00

Lender Name : Giorgio Carneade

Lender Type : individual

9% Rate

Lending: Nationwide

Lending at 9%


View Detail

Anne - Lending $50,000.00

Lender Name : Anne Nevin

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!

Mike - Lending $250,000.00

Lender Name : Mike Edwards

Lender Type : individual

6% Rate

Lending: Nationwide

Lending at 6%


View Detail

David - Lending $250,000.00

Lender Name : David Lange

Lender Type : individual

5% Rate

Lending: Nationwide

Lending at 5%


View Detail

Nicko - Lending $50,000.00

Lender Name : Nicko Scot

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

Melanie - Lending $50,000.00

Lender Name : Melanie Gonzales

Lender Type : individual

5% Rate

Lending: Nationwide

Lending at 5%


View Detail

Christina Le - Lending $500,000.00

Lender Name : Christina Le Le

Lender Type : individual

6% Rate

Lending: Nationwide

Lending at 6%


View Detail

Ron - Lending $250,000.00

Lender Name : Ron Cedillo

Lender Type : individual

8% Rate

Lending: Nationwide

Lending at 8%


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

Giltner NE 68841

Asking : $85000

List Date : 4/14/2020

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


Flip - Needs Repairs

View Details!



Deal Score: 9

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
Use the Tabs at the Top of This Page to Navigate the different types of properties!

Grand Island NE 68803

Asking : $234900

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

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 ='66935' or zipCode = '66936' or zipCode = '66939' or zipCode = '66942' or zipCode = '66948' or zipCode = '66949' or zipCode = '66949' or zipCode = '66956' or zipCode = '66961' or zipCode = '66963' or zipCode = '66964' or zipCode = '66966' or zipCode = '66970' or zipCode = '68325' or zipCode = '68327' or zipCode = '68340' or zipCode = '68942' or zipCode = '68943' or zipCode = '68957' or zipCode = '68957' or zipCode = '68957' or zipCode = '68978' or zipCode = '68978' or zipCode = '68978' or zipCode = '68961' or zipCode = '68961' or zipCode = '68964' or zipCode = '68974' or zipCode = '66935' or zipCode = '66936' or zipCode = '66939' or zipCode = '66941' or zipCode = '66942' or zipCode = '66948' or zipCode = '66949' or zipCode = '66956' or zipCode = '66961' or zipCode = '66963' or zipCode = '66964' or zipCode = '66966' or zipCode = '66969' or zipCode = '66970' or zipCode = '68325' or zipCode = '68327' or zipCode = '68340' or zipCode = '68942' or zipCode = '68943' or zipCode = '68961' or zipCode = '68964' or zipCode = '68974' or zipCode = '68978')
select top 45 * from tblREO NOLOCK where priority is null and len(photoURL1) > 2 and dateposted >= '4/29/2020' and state = 'KS' and (1=1) and price >= 0 and price <= 100000000 and 11=11 and (zipCode ='66935' or zipCode = '66936' or zipCode = '66939' or zipCode = '66942' or zipCode = '66948' or zipCode = '66949' or zipCode = '66949' or zipCode = '66956' or zipCode = '66961' or zipCode = '66963' or zipCode = '66964' or zipCode = '66966' or zipCode = '66970' or zipCode = '68325' or zipCode = '68327' or zipCode = '68340' or zipCode = '68942' or zipCode = '68943' or zipCode = '68957' or zipCode = '68957' or zipCode = '68957' or zipCode = '68978' or zipCode = '68978' or zipCode = '68978' or zipCode = '68961' or zipCode = '68961' or zipCode = '68964' or zipCode = '68974' or zipCode = '66935' or zipCode = '66936' or zipCode = '66939' or zipCode = '66941' or zipCode = '66942' or zipCode = '66948' or zipCode = '66949' or zipCode = '66956' or zipCode = '66961' or zipCode = '66963' or zipCode = '66964' or zipCode = '66966' or zipCode = '66969' or zipCode = '66970' or zipCode = '68325' or zipCode = '68327' or zipCode = '68340' or zipCode = '68942' or zipCode = '68943' or zipCode = '68961' or zipCode = '68964' or zipCode = '68974' or zipCode = '68978') order by price
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 ='66935' or zipCode = '66936' or zipCode = '66939' or zipCode = '66942' or zipCode = '66948' or zipCode = '66949' or zipCode = '66949' or zipCode = '66956' or zipCode = '66961' or zipCode = '66963' or zipCode = '66964' or zipCode = '66966' or zipCode = '66970' or zipCode = '68325' or zipCode = '68327' or zipCode = '68340' or zipCode = '68942' or zipCode = '68943' or zipCode = '68957' or zipCode = '68957' or zipCode = '68957' or zipCode = '68978' or zipCode = '68978' or zipCode = '68978' or zipCode = '68961' or zipCode = '68961' or zipCode = '68964' or zipCode = '68974' or zipCode = '66935' or zipCode = '66936' or zipCode = '66939' or zipCode = '66941' or zipCode = '66942' or zipCode = '66948' or zipCode = '66949' or zipCode = '66956' or zipCode = '66961' or zipCode = '66963' or zipCode = '66964' or zipCode = '66966' or zipCode = '66969' or zipCode = '66970' or zipCode = '68325' or zipCode = '68327' or zipCode = '68340' or zipCode = '68942' or zipCode = '68943' or zipCode = '68961' or zipCode = '68964' or zipCode = '68974' or zipCode = '68978')
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 ='66935' or zipCode = '66936' or zipCode = '66939' or zipCode = '66942' or zipCode = '66948' or zipCode = '66949' or zipCode = '66949' or zipCode = '66956' or zipCode = '66961' or zipCode = '66963' or zipCode = '66964' or zipCode = '66966' or zipCode = '66970' or zipCode = '68325' or zipCode = '68327' or zipCode = '68340' or zipCode = '68942' or zipCode = '68943' or zipCode = '68957' or zipCode = '68957' or zipCode = '68957' or zipCode = '68978' or zipCode = '68978' or zipCode = '68978' or zipCode = '68961' or zipCode = '68961' or zipCode = '68964' or zipCode = '68974' or zipCode = '66935' or zipCode = '66936' or zipCode = '66939' or zipCode = '66941' or zipCode = '66942' or zipCode = '66948' or zipCode = '66949' or zipCode = '66956' or zipCode = '66961' or zipCode = '66963' or zipCode = '66964' or zipCode = '66966' or zipCode = '66969' or zipCode = '66970' or zipCode = '68325' or zipCode = '68327' or zipCode = '68340' or zipCode = '68942' or zipCode = '68943' or zipCode = '68961' or zipCode = '68964' or zipCode = '68974' or zipCode = '68978') 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 ='66935' or zipCode = '66936' or zipCode = '66939' or zipCode = '66942' or zipCode = '66948' or zipCode = '66949' or zipCode = '66949' or zipCode = '66956' or zipCode = '66961' or zipCode = '66963' or zipCode = '66964' or zipCode = '66966' or zipCode = '66970' or zipCode = '68325' or zipCode = '68327' or zipCode = '68340' or zipCode = '68942' or zipCode = '68943' or zipCode = '68957' or zipCode = '68957' or zipCode = '68957' or zipCode = '68978' or zipCode = '68978' or zipCode = '68978' or zipCode = '68961' or zipCode = '68961' or zipCode = '68964' or zipCode = '68974' or zipCode = '66935' or zipCode = '66936' or zipCode = '66939' or zipCode = '66941' or zipCode = '66942' or zipCode = '66948' or zipCode = '66949' or zipCode = '66956' or zipCode = '66961' or zipCode = '66963' or zipCode = '66964' or zipCode = '66966' or zipCode = '66969' or zipCode = '66970' or zipCode = '68325' or zipCode = '68327' or zipCode = '68340' or zipCode = '68942' or zipCode = '68943' or zipCode = '68961' or zipCode = '68964' or zipCode = '68974' or zipCode = '68978') 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 ='66935' or zipCode = '66936' or zipCode = '66939' or zipCode = '66942' or zipCode = '66948' or zipCode = '66949' or zipCode = '66949' or zipCode = '66956' or zipCode = '66961' or zipCode = '66963' or zipCode = '66964' or zipCode = '66966' or zipCode = '66970' or zipCode = '68325' or zipCode = '68327' or zipCode = '68340' or zipCode = '68942' or zipCode = '68943' or zipCode = '68957' or zipCode = '68957' or zipCode = '68957' or zipCode = '68978' or zipCode = '68978' or zipCode = '68978' or zipCode = '68961' or zipCode = '68961' or zipCode = '68964' or zipCode = '68974' or zipCode = '66935' or zipCode = '66936' or zipCode = '66939' or zipCode = '66941' or zipCode = '66942' or zipCode = '66948' or zipCode = '66949' or zipCode = '66956' or zipCode = '66961' or zipCode = '66963' or zipCode = '66964' or zipCode = '66966' or zipCode = '66969' or zipCode = '66970' or zipCode = '68325' or zipCode = '68327' or zipCode = '68340' or zipCode = '68942' or zipCode = '68943' or zipCode = '68961' or zipCode = '68964' or zipCode = '68974' or zipCode = '68978') 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 ='66935' or zipCode = '66936' or zipCode = '66939' or zipCode = '66942' or zipCode = '66948' or zipCode = '66949' or zipCode = '66949' or zipCode = '66956' or zipCode = '66961' or zipCode = '66963' or zipCode = '66964' or zipCode = '66966' or zipCode = '66970' or zipCode = '68325' or zipCode = '68327' or zipCode = '68340' or zipCode = '68942' or zipCode = '68943' or zipCode = '68957' or zipCode = '68957' or zipCode = '68957' or zipCode = '68978' or zipCode = '68978' or zipCode = '68978' or zipCode = '68961' or zipCode = '68961' or zipCode = '68964' or zipCode = '68974' or zipCode = '66935' or zipCode = '66936' or zipCode = '66939' or zipCode = '66941' or zipCode = '66942' or zipCode = '66948' or zipCode = '66949' or zipCode = '66956' or zipCode = '66961' or zipCode = '66963' or zipCode = '66964' or zipCode = '66966' or zipCode = '66969' or zipCode = '66970' or zipCode = '68325' or zipCode = '68327' or zipCode = '68340' or zipCode = '68942' or zipCode = '68943' or zipCode = '68961' or zipCode = '68964' or zipCode = '68974' or zipCode = '68978') 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 ='66935' or zipCode = '66936' or zipCode = '66939' or zipCode = '66942' or zipCode = '66948' or zipCode = '66949' or zipCode = '66949' or zipCode = '66956' or zipCode = '66961' or zipCode = '66963' or zipCode = '66964' or zipCode = '66966' or zipCode = '66970' or zipCode = '68325' or zipCode = '68327' or zipCode = '68340' or zipCode = '68942' or zipCode = '68943' or zipCode = '68957' or zipCode = '68957' or zipCode = '68957' or zipCode = '68978' or zipCode = '68978' or zipCode = '68978' or zipCode = '68961' or zipCode = '68961' or zipCode = '68964' or zipCode = '68974' or zipCode = '66935' or zipCode = '66936' or zipCode = '66939' or zipCode = '66941' or zipCode = '66942' or zipCode = '66948' or zipCode = '66949' or zipCode = '66956' or zipCode = '66961' or zipCode = '66963' or zipCode = '66964' or zipCode = '66966' or zipCode = '66969' or zipCode = '66970' or zipCode = '68325' or zipCode = '68327' or zipCode = '68340' or zipCode = '68942' or zipCode = '68943' or zipCode = '68961' or zipCode = '68964' or zipCode = '68974' or zipCode = '68978') 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 ='66412' or zipCode = '66508' or zipCode = '66449' or zipCode = '66508' or zipCode = '66548' or zipCode = '66901' or zipCode = '66901' or zipCode = '66901' or zipCode = '66930' or zipCode = '66932' 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 = '66951' 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 = '67417' or zipCode = '67418' or zipCode = '67420' or zipCode = '67420' or zipCode = '67422' or zipCode = '67423' or zipCode = '67430' or zipCode = '67432' or zipCode = '67432' or zipCode = '67436' or zipCode = '67437' or zipCode = '67466' or zipCode = '67467' or zipCode = '67467' or zipCode = '67467' or zipCode = '67468' or zipCode = '67473' or zipCode = '67474' or zipCode = '67478' or zipCode = '67481' or zipCode = '67484' or zipCode = '67484' or zipCode = '67485' or zipCode = '67487' or zipCode = '67621' or zipCode = '67623' or zipCode = '67628' or zipCode = '67638' or zipCode = '67639' or zipCode = '67644' or zipCode = '67445' or zipCode = '67446' or zipCode = '67447' or zipCode = '67452' or zipCode = '67455' or zipCode = '67455' or zipCode = '67458' or zipCode = '67648' or zipCode = '67649' or zipCode = '67651' or zipCode = '67661' or zipCode = '67661' or zipCode = '67673' or zipCode = '67675' or zipCode = '68303' 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 = '68319' or zipCode = '68322' 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 = '68359' or zipCode = '68361' or zipCode = '68362' or zipCode = '68365' or zipCode = '68330' or zipCode = '68333' or zipCode = '68333' or zipCode = '68333' or zipCode = '68335' or zipCode = '68338' or zipCode = '68340' or zipCode = '68341' or zipCode = '68342' or zipCode = '68343' or zipCode = '68343' or zipCode = '68370' or zipCode = '68371' or zipCode = '68371' or zipCode = '68375' or zipCode = '68377' or zipCode = '68377' or zipCode = '68401' or zipCode = '68401' or zipCode = '68406' or zipCode = '68415' or zipCode = '68415' or zipCode = '68416' or zipCode = '68424' or zipCode = '68429' or zipCode = '68429' or zipCode = '68436' or zipCode = '68440' or zipCode = '68444' or zipCode = '68444' or zipCode = '68444' or zipCode = '68445' or zipCode = '68452' or zipCode = '68453' or zipCode = '68460' or zipCode = '68460' or zipCode = '68464' or zipCode = '68465' or zipCode = '68466' or zipCode = '68466' or zipCode = '68467' or zipCode = '68818' or zipCode = '68818' or zipCode = '68832' or zipCode = '68832' or zipCode = '68840' or zipCode = '68840' or zipCode = '68840' or zipCode = '68841' or zipCode = '68843' or zipCode = '68854' or zipCode = '68854' or zipCode = '68876' or zipCode = '68876' or zipCode = '68801' or zipCode = '68801' or zipCode = '68802' or zipCode = '68803' or zipCode = '68810' or zipCode = '68865' or zipCode = '68883' or zipCode = '68883' or zipCode = '68883' or zipCode = '68883' 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 = '68920' or zipCode = '68920' or zipCode = '68924' or zipCode = '68924' or zipCode = '68935' or zipCode = '68938' or zipCode = '68939' or zipCode = '68939' or zipCode = '68939' or zipCode = '68941' or zipCode = '68941' or zipCode = '68941' or zipCode = '68941' or zipCode = '68942' or zipCode = '68943' or zipCode = '68944' or zipCode = '68945' or zipCode = '68945' or zipCode = '68947' or zipCode = '68950' or zipCode = '68950' or zipCode = '68952' or zipCode = '68954' or zipCode = '68955' or zipCode = '68955' or zipCode = '68955' or zipCode = '68956' or zipCode = '68956' or zipCode = '68956' or zipCode = '68957' or zipCode = '68957' or zipCode = '68957' or zipCode = '68959' or zipCode = '68959' or zipCode = '68959' or zipCode = '68959' or zipCode = '68960' 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 = '68981' or zipCode = '68982' or zipCode = '68982' or zipCode = '68982' or zipCode = '68982' or zipCode = '68924' or zipCode = '68925' or zipCode = '68925' or zipCode = '68928' or zipCode = '68929' or zipCode = '68929' or zipCode = '68929' or zipCode = '68930' or zipCode = '68930' or zipCode = '68930' or zipCode = '68932' or zipCode = '68932' or zipCode = '68932' 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 = '68969' or zipCode = '68969' or zipCode = '68969' or zipCode = '68970' or zipCode = '68971' or zipCode = '68971' or zipCode = '68971' or zipCode = '68971' or zipCode = '68972' or zipCode = '68973' or zipCode = '68973' or zipCode = '68974' or zipCode = '68975' or zipCode = '66412' or zipCode = '66449' or zipCode = '66508' or zipCode = '66548' or zipCode = '66554' or zipCode = '66901' or zipCode = '66930' or zipCode = '66932' 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 = '66951' 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 = '67417' or zipCode = '67418' or zipCode = '67420' or zipCode = '67422' or zipCode = '67423' or zipCode = '67430' or zipCode = '67432' or zipCode = '67436' or zipCode = '67437' 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 = '67472' or zipCode = '67473' or zipCode = '67474' or zipCode = '67478' or zipCode = '67481' or zipCode = '67484' or zipCode = '67485' or zipCode = '67487' or zipCode = '67488' or zipCode = '67495' or zipCode = '67621' or zipCode = '67623' or zipCode = '67628' or zipCode = '67638' or zipCode = '67639' or zipCode = '67644' or zipCode = '67648' or zipCode = '67649' or zipCode = '67651' or zipCode = '67658' or zipCode = '67661' or zipCode = '67673' or zipCode = '67675' or zipCode = '67845' or zipCode = '67938' or zipCode = '68303' or zipCode = '68310' or zipCode = '68313' or zipCode = '68315' or zipCode = '68318' or zipCode = '68319' or zipCode = '68322' or zipCode = '68325' or zipCode = '68326' or zipCode = '68327' or zipCode = '68328' or zipCode = '68330' or zipCode = '68333' or zipCode = '68335' or zipCode = '68338' 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 = '68359' or zipCode = '68361' or zipCode = '68362' or zipCode = '68365' or zipCode = '68370' or zipCode = '68371' or zipCode = '68375' or zipCode = '68377' or zipCode = '68401' or zipCode = '68406' or zipCode = '68415' or zipCode = '68416' or zipCode = '68424' or zipCode = '68429' or zipCode = '68436' or zipCode = '68440' or zipCode = '68444' or zipCode = '68445' or zipCode = '68452' or zipCode = '68453' or zipCode = '68460' or zipCode = '68464' or zipCode = '68465' or zipCode = '68466' or zipCode = '68467' or zipCode = '68797' or zipCode = '68801' or zipCode = '68802' or zipCode = '68803' or zipCode = '68810' or zipCode = '68818' or zipCode = '68832' or zipCode = '68840' or zipCode = '68841' or zipCode = '68843' or zipCode = '68848' or zipCode = '68854' or zipCode = '68865' or zipCode = '68868' or zipCode = '68876' or zipCode = '68883' or zipCode = '68901' or zipCode = '68902' or zipCode = '68920' or zipCode = '68924' or zipCode = '68925' or zipCode = '68928' or zipCode = '68929' or zipCode = '68930' or zipCode = '68932' or zipCode = '68933' or zipCode = '68934' or zipCode = '68935' or zipCode = '68938' or zipCode = '68939' or zipCode = '68941' or zipCode = '68942' or zipCode = '68943' or zipCode = '68944' or zipCode = '68945' or zipCode = '68947' or zipCode = '68950' or zipCode = '68952' or zipCode = '68954' or zipCode = '68955' or zipCode = '68956' or zipCode = '68957' or zipCode = '68959' or zipCode = '68960' or zipCode = '68961' or zipCode = '68963' or zipCode = '68964' or zipCode = '68969' or zipCode = '68970' or zipCode = '68971' or zipCode = '68972' or zipCode = '68973' or zipCode = '68974' or zipCode = '68975' or zipCode = '68978' or zipCode = '68979' or zipCode = '68980' or zipCode = '68981' or zipCode = '68982') 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 ='66412' or zipCode = '66508' or zipCode = '66449' or zipCode = '66508' or zipCode = '66548' or zipCode = '66901' or zipCode = '66901' or zipCode = '66901' or zipCode = '66930' or zipCode = '66932' 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 = '66951' 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 = '67417' or zipCode = '67418' or zipCode = '67420' or zipCode = '67420' or zipCode = '67422' or zipCode = '67423' or zipCode = '67430' or zipCode = '67432' or zipCode = '67432' or zipCode = '67436' or zipCode = '67437' or zipCode = '67466' or zipCode = '67467' or zipCode = '67467' or zipCode = '67467' or zipCode = '67468' or zipCode = '67473' or zipCode = '67474' or zipCode = '67478' or zipCode = '67481' or zipCode = '67484' or zipCode = '67484' or zipCode = '67485' or zipCode = '67487' or zipCode = '67621' or zipCode = '67623' or zipCode = '67628' or zipCode = '67638' or zipCode = '67639' or zipCode = '67644' or zipCode = '67445' or zipCode = '67446' or zipCode = '67447' or zipCode = '67452' or zipCode = '67455' or zipCode = '67455' or zipCode = '67458' or zipCode = '67648' or zipCode = '67649' or zipCode = '67651' or zipCode = '67661' or zipCode = '67661' or zipCode = '67673' or zipCode = '67675' or zipCode = '68303' 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 = '68319' or zipCode = '68322' 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 = '68359' or zipCode = '68361' or zipCode = '68362' or zipCode = '68365' or zipCode = '68330' or zipCode = '68333' or zipCode = '68333' or zipCode = '68333' or zipCode = '68335' or zipCode = '68338' or zipCode = '68340' or zipCode = '68341' or zipCode = '68342' or zipCode = '68343' or zipCode = '68343' or zipCode = '68370' or zipCode = '68371' or zipCode = '68371' or zipCode = '68375' or zipCode = '68377' or zipCode = '68377' or zipCode = '68401' or zipCode = '68401' or zipCode = '68406' or zipCode = '68415' or zipCode = '68415' or zipCode = '68416' or zipCode = '68424' or zipCode = '68429' or zipCode = '68429' or zipCode = '68436' or zipCode = '68440' or zipCode = '68444' or zipCode = '68444' or zipCode = '68444' or zipCode = '68445' or zipCode = '68452' or zipCode = '68453' or zipCode = '68460' or zipCode = '68460' or zipCode = '68464' or zipCode = '68465' or zipCode = '68466' or zipCode = '68466' or zipCode = '68467' or zipCode = '68818' or zipCode = '68818' or zipCode = '68832' or zipCode = '68832' or zipCode = '68840' or zipCode = '68840' or zipCode = '68840' or zipCode = '68841' or zipCode = '68843' or zipCode = '68854' or zipCode = '68854' or zipCode = '68876' or zipCode = '68876' or zipCode = '68801' or zipCode = '68801' or zipCode = '68802' or zipCode = '68803' or zipCode = '68810' or zipCode = '68865' or zipCode = '68883' or zipCode = '68883' or zipCode = '68883' or zipCode = '68883' 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 = '68920' or zipCode = '68920' or zipCode = '68924' or zipCode = '68924' or zipCode = '68935' or zipCode = '68938' or zipCode = '68939' or zipCode = '68939' or zipCode = '68939' or zipCode = '68941' or zipCode = '68941' or zipCode = '68941' or zipCode = '68941' or zipCode = '68942' or zipCode = '68943' or zipCode = '68944' or zipCode = '68945' or zipCode = '68945' or zipCode = '68947' or zipCode = '68950' or zipCode = '68950' or zipCode = '68952' or zipCode = '68954' or zipCode = '68955' or zipCode = '68955' or zipCode = '68955' or zipCode = '68956' or zipCode = '68956' or zipCode = '68956' or zipCode = '68957' or zipCode = '68957' or zipCode = '68957' or zipCode = '68959' or zipCode = '68959' or zipCode = '68959' or zipCode = '68959' or zipCode = '68960' 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 = '68981' or zipCode = '68982' or zipCode = '68982' or zipCode = '68982' or zipCode = '68982' or zipCode = '68924' or zipCode = '68925' or zipCode = '68925' or zipCode = '68928' or zipCode = '68929' or zipCode = '68929' or zipCode = '68929' or zipCode = '68930' or zipCode = '68930' or zipCode = '68930' or zipCode = '68932' or zipCode = '68932' or zipCode = '68932' 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 = '68969' or zipCode = '68969' or zipCode = '68969' or zipCode = '68970' or zipCode = '68971' or zipCode = '68971' or zipCode = '68971' or zipCode = '68971' or zipCode = '68972' or zipCode = '68973' or zipCode = '68973' or zipCode = '68974' or zipCode = '68975' or zipCode = '66412' or zipCode = '66449' or zipCode = '66508' or zipCode = '66548' or zipCode = '66554' or zipCode = '66901' or zipCode = '66930' or zipCode = '66932' 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 = '66951' 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 = '67417' or zipCode = '67418' or zipCode = '67420' or zipCode = '67422' or zipCode = '67423' or zipCode = '67430' or zipCode = '67432' or zipCode = '67436' or zipCode = '67437' 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 = '67472' or zipCode = '67473' or zipCode = '67474' or zipCode = '67478' or zipCode = '67481' or zipCode = '67484' or zipCode = '67485' or zipCode = '67487' or zipCode = '67488' or zipCode = '67495' or zipCode = '67621' or zipCode = '67623' or zipCode = '67628' or zipCode = '67638' or zipCode = '67639' or zipCode = '67644' or zipCode = '67648' or zipCode = '67649' or zipCode = '67651' or zipCode = '67658' or zipCode = '67661' or zipCode = '67673' or zipCode = '67675' or zipCode = '67845' or zipCode = '67938' or zipCode = '68303' or zipCode = '68310' or zipCode = '68313' or zipCode = '68315' or zipCode = '68318' or zipCode = '68319' or zipCode = '68322' or zipCode = '68325' or zipCode = '68326' or zipCode = '68327' or zipCode = '68328' or zipCode = '68330' or zipCode = '68333' or zipCode = '68335' or zipCode = '68338' 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 = '68359' or zipCode = '68361' or zipCode = '68362' or zipCode = '68365' or zipCode = '68370' or zipCode = '68371' or zipCode = '68375' or zipCode = '68377' or zipCode = '68401' or zipCode = '68406' or zipCode = '68415' or zipCode = '68416' or zipCode = '68424' or zipCode = '68429' or zipCode = '68436' or zipCode = '68440' or zipCode = '68444' or zipCode = '68445' or zipCode = '68452' or zipCode = '68453' or zipCode = '68460' or zipCode = '68464' or zipCode = '68465' or zipCode = '68466' or zipCode = '68467' or zipCode = '68797' or zipCode = '68801' or zipCode = '68802' or zipCode = '68803' or zipCode = '68810' or zipCode = '68818' or zipCode = '68832' or zipCode = '68840' or zipCode = '68841' or zipCode = '68843' or zipCode = '68848' or zipCode = '68854' or zipCode = '68865' or zipCode = '68868' or zipCode = '68876' or zipCode = '68883' or zipCode = '68901' or zipCode = '68902' or zipCode = '68920' or zipCode = '68924' or zipCode = '68925' or zipCode = '68928' or zipCode = '68929' or zipCode = '68930' or zipCode = '68932' or zipCode = '68933' or zipCode = '68934' or zipCode = '68935' or zipCode = '68938' or zipCode = '68939' or zipCode = '68941' or zipCode = '68942' or zipCode = '68943' or zipCode = '68944' or zipCode = '68945' or zipCode = '68947' or zipCode = '68950' or zipCode = '68952' or zipCode = '68954' or zipCode = '68955' or zipCode = '68956' or zipCode = '68957' or zipCode = '68959' or zipCode = '68960' or zipCode = '68961' or zipCode = '68963' or zipCode = '68964' or zipCode = '68969' or zipCode = '68970' or zipCode = '68971' or zipCode = '68972' or zipCode = '68973' or zipCode = '68974' or zipCode = '68975' or zipCode = '68978' or zipCode = '68979' or zipCode = '68980' or zipCode = '68981' or zipCode = '68982') 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 ='66935' or property_zip = '66936' or property_zip = '66939' or property_zip = '66942' or property_zip = '66948' or property_zip = '66949' or property_zip = '66949' or property_zip = '66956' or property_zip = '66961' or property_zip = '66963' or property_zip = '66964' or property_zip = '66966' or property_zip = '66970' or property_zip = '68325' or property_zip = '68327' or property_zip = '68340' or property_zip = '68942' or property_zip = '68943' 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 = '68961' or property_zip = '68961' or property_zip = '68964' or property_zip = '68974' or property_zip = '66935' or property_zip = '66936' or property_zip = '66939' or property_zip = '66941' or property_zip = '66942' or property_zip = '66948' or property_zip = '66949' or property_zip = '66956' or property_zip = '66961' or property_zip = '66963' or property_zip = '66964' or property_zip = '66966' or property_zip = '66969' or property_zip = '66970' or property_zip = '68325' or property_zip = '68327' or property_zip = '68340' or property_zip = '68942' or property_zip = '68943' or property_zip = '68961' or property_zip = '68964' or property_zip = '68974' or property_zip = '68978') and 11=11 and (property_zip ='66412' or property_zip = '66508' or property_zip = '66449' or property_zip = '66508' or property_zip = '66548' or property_zip = '66901' or property_zip = '66901' or property_zip = '66901' or property_zip = '66930' or property_zip = '66932' 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 = '66951' 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 = '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 = '67432' or property_zip = '67432' or property_zip = '67436' or property_zip = '67437' or property_zip = '67466' or property_zip = '67467' or property_zip = '67467' or property_zip = '67467' or property_zip = '67468' or property_zip = '67473' or property_zip = '67474' or property_zip = '67478' or property_zip = '67481' or property_zip = '67484' or property_zip = '67484' or property_zip = '67485' or property_zip = '67487' or property_zip = '67621' or property_zip = '67623' or property_zip = '67628' or property_zip = '67638' or property_zip = '67639' or property_zip = '67644' 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 = '67648' or property_zip = '67649' or property_zip = '67651' or property_zip = '67661' or property_zip = '67661' or property_zip = '67673' or property_zip = '67675' or property_zip = '68303' 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 = '68319' or property_zip = '68322' 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 = '68359' or property_zip = '68361' or property_zip = '68362' or property_zip = '68365' or property_zip = '68330' or property_zip = '68333' or property_zip = '68333' or property_zip = '68333' or property_zip = '68335' or property_zip = '68338' or property_zip = '68340' or property_zip = '68341' or property_zip = '68342' or property_zip = '68343' or property_zip = '68343' or property_zip = '68370' or property_zip = '68371' or property_zip = '68371' or property_zip = '68375' or property_zip = '68377' or property_zip = '68377' or property_zip = '68401' or property_zip = '68401' or property_zip = '68406' or property_zip = '68415' or property_zip = '68415' or property_zip = '68416' or property_zip = '68424' or property_zip = '68429' or property_zip = '68429' or property_zip = '68436' or property_zip = '68440' or property_zip = '68444' or property_zip = '68444' or property_zip = '68444' or property_zip = '68445' or property_zip = '68452' or property_zip = '68453' 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 = '68818' or property_zip = '68818' or property_zip = '68832' or property_zip = '68832' or property_zip = '68840' or property_zip = '68840' or property_zip = '68840' or property_zip = '68841' or property_zip = '68843' or property_zip = '68854' or property_zip = '68854' or property_zip = '68876' or property_zip = '68876' or property_zip = '68801' or property_zip = '68801' or property_zip = '68802' or property_zip = '68803' or property_zip = '68810' or property_zip = '68865' or property_zip = '68883' or property_zip = '68883' or property_zip = '68883' or property_zip = '68883' 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 = '68920' or property_zip = '68920' or property_zip = '68924' or property_zip = '68924' or property_zip = '68935' or property_zip = '68938' or property_zip = '68939' or property_zip = '68939' or property_zip = '68939' 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 = '68945' or property_zip = '68945' or property_zip = '68947' or property_zip = '68950' or property_zip = '68950' or property_zip = '68952' or property_zip = '68954' or property_zip = '68955' or property_zip = '68955' or property_zip = '68955' or property_zip = '68956' or property_zip = '68956' or property_zip = '68956' or property_zip = '68957' or property_zip = '68957' or property_zip = '68957' or property_zip = '68959' or property_zip = '68959' or property_zip = '68959' or property_zip = '68959' or property_zip = '68960' 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 = '68981' or property_zip = '68982' or property_zip = '68982' or property_zip = '68982' or property_zip = '68982' or property_zip = '68924' or property_zip = '68925' or property_zip = '68925' or property_zip = '68928' or property_zip = '68929' or property_zip = '68929' or property_zip = '68929' or property_zip = '68930' or property_zip = '68930' or property_zip = '68930' or property_zip = '68932' or property_zip = '68932' or property_zip = '68932' 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 = '68969' or property_zip = '68969' or property_zip = '68969' or property_zip = '68970' or property_zip = '68971' or property_zip = '68971' or property_zip = '68971' or property_zip = '68971' or property_zip = '68972' or property_zip = '68973' or property_zip = '68973' or property_zip = '68974' or property_zip = '68975' or property_zip = '66412' or property_zip = '66449' or property_zip = '66508' or property_zip = '66548' or property_zip = '66554' or property_zip = '66901' or property_zip = '66930' or property_zip = '66932' 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 = '66951' 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 = '67417' or property_zip = '67418' or property_zip = '67420' or property_zip = '67422' or property_zip = '67423' or property_zip = '67430' or property_zip = '67432' or property_zip = '67436' or property_zip = '67437' 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 = '67472' or property_zip = '67473' or property_zip = '67474' or property_zip = '67478' or property_zip = '67481' or property_zip = '67484' or property_zip = '67485' or property_zip = '67487' or property_zip = '67488' or property_zip = '67495' or property_zip = '67621' or property_zip = '67623' or property_zip = '67628' or property_zip = '67638' or property_zip = '67639' or property_zip = '67644' or property_zip = '67648' or property_zip = '67649' or property_zip = '67651' or property_zip = '67658' or property_zip = '67661' or property_zip = '67673' or property_zip = '67675' or property_zip = '67845' or property_zip = '67938' or property_zip = '68303' or property_zip = '68310' or property_zip = '68313' or property_zip = '68315' or property_zip = '68318' or property_zip = '68319' or property_zip = '68322' or property_zip = '68325' or property_zip = '68326' or property_zip = '68327' or property_zip = '68328' or property_zip = '68330' or property_zip = '68333' or property_zip = '68335' or property_zip = '68338' 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 = '68359' or property_zip = '68361' or property_zip = '68362' or property_zip = '68365' or property_zip = '68370' or property_zip = '68371' or property_zip = '68375' or property_zip = '68377' or property_zip = '68401' or property_zip = '68406' or property_zip = '68415' or property_zip = '68416' or property_zip = '68424' or property_zip = '68429' or property_zip = '68436' or property_zip = '68440' or property_zip = '68444' or property_zip = '68445' or property_zip = '68452' or property_zip = '68453' or property_zip = '68460' or property_zip = '68464' or property_zip = '68465' or property_zip = '68466' or property_zip = '68467' or property_zip = '68797' or property_zip = '68801' or property_zip = '68802' or property_zip = '68803' or property_zip = '68810' or property_zip = '68818' or property_zip = '68832' or property_zip = '68840' or property_zip = '68841' or property_zip = '68843' or property_zip = '68848' or property_zip = '68854' or property_zip = '68865' or property_zip = '68868' or property_zip = '68876' or property_zip = '68883' or property_zip = '68901' or property_zip = '68902' or property_zip = '68920' or property_zip = '68924' or property_zip = '68925' or property_zip = '68928' or property_zip = '68929' or property_zip = '68930' or property_zip = '68932' or property_zip = '68933' or property_zip = '68934' or property_zip = '68935' or property_zip = '68938' or property_zip = '68939' or property_zip = '68941' or property_zip = '68942' or property_zip = '68943' or property_zip = '68944' or property_zip = '68945' or property_zip = '68947' or property_zip = '68950' or property_zip = '68952' or property_zip = '68954' or property_zip = '68955' or property_zip = '68956' or property_zip = '68957' or property_zip = '68959' or property_zip = '68960' or property_zip = '68961' or property_zip = '68963' or property_zip = '68964' or property_zip = '68969' or property_zip = '68970' or property_zip = '68971' 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' or property_zip = '68981' or property_zip = '68982') 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 ='66412' or zip = '66508' or zip = '66449' or zip = '66508' or zip = '66548' or zip = '66901' or zip = '66901' or zip = '66901' or zip = '66930' or zip = '66932' 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 = '66951' 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 = '67417' or zip = '67418' or zip = '67420' or zip = '67420' or zip = '67422' or zip = '67423' or zip = '67430' or zip = '67432' or zip = '67432' or zip = '67436' or zip = '67437' or zip = '67466' or zip = '67467' or zip = '67467' or zip = '67467' or zip = '67468' or zip = '67473' or zip = '67474' or zip = '67478' or zip = '67481' or zip = '67484' or zip = '67484' or zip = '67485' or zip = '67487' or zip = '67621' or zip = '67623' or zip = '67628' or zip = '67638' or zip = '67639' or zip = '67644' or zip = '67445' or zip = '67446' or zip = '67447' or zip = '67452' or zip = '67455' or zip = '67455' or zip = '67458' or zip = '67648' or zip = '67649' or zip = '67651' or zip = '67661' or zip = '67661' or zip = '67673' or zip = '67675' or zip = '68303' 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 = '68319' or zip = '68322' 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 = '68359' or zip = '68361' or zip = '68362' or zip = '68365' or zip = '68330' or zip = '68333' or zip = '68333' or zip = '68333' or zip = '68335' or zip = '68338' or zip = '68340' or zip = '68341' or zip = '68342' or zip = '68343' or zip = '68343' or zip = '68370' or zip = '68371' or zip = '68371' or zip = '68375' or zip = '68377' or zip = '68377' or zip = '68401' or zip = '68401' or zip = '68406' or zip = '68415' or zip = '68415' or zip = '68416' or zip = '68424' or zip = '68429' or zip = '68429' or zip = '68436' or zip = '68440' or zip = '68444' or zip = '68444' or zip = '68444' or zip = '68445' or zip = '68452' or zip = '68453' or zip = '68460' or zip = '68460' or zip = '68464' or zip = '68465' or zip = '68466' or zip = '68466' or zip = '68467' or zip = '68818' or zip = '68818' or zip = '68832' or zip = '68832' or zip = '68840' or zip = '68840' or zip = '68840' or zip = '68841' or zip = '68843' or zip = '68854' or zip = '68854' or zip = '68876' or zip = '68876' or zip = '68801' or zip = '68801' or zip = '68802' or zip = '68803' or zip = '68810' or zip = '68865' or zip = '68883' or zip = '68883' or zip = '68883' or zip = '68883' 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 = '68920' or zip = '68920' or zip = '68924' or zip = '68924' or zip = '68935' or zip = '68938' or zip = '68939' or zip = '68939' or zip = '68939' or zip = '68941' or zip = '68941' or zip = '68941' or zip = '68941' or zip = '68942' or zip = '68943' or zip = '68944' or zip = '68945' or zip = '68945' or zip = '68947' or zip = '68950' or zip = '68950' or zip = '68952' or zip = '68954' or zip = '68955' or zip = '68955' or zip = '68955' or zip = '68956' or zip = '68956' or zip = '68956' or zip = '68957' or zip = '68957' or zip = '68957' or zip = '68959' or zip = '68959' or zip = '68959' or zip = '68959' or zip = '68960' 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 = '68981' or zip = '68982' or zip = '68982' or zip = '68982' or zip = '68982' or zip = '68924' or zip = '68925' or zip = '68925' or zip = '68928' or zip = '68929' or zip = '68929' or zip = '68929' or zip = '68930' or zip = '68930' or zip = '68930' or zip = '68932' or zip = '68932' or zip = '68932' 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 = '68969' or zip = '68969' or zip = '68969' or zip = '68970' or zip = '68971' or zip = '68971' or zip = '68971' or zip = '68971' or zip = '68972' or zip = '68973' or zip = '68973' or zip = '68974' or zip = '68975' or zip = '66412' or zip = '66449' or zip = '66508' or zip = '66548' or zip = '66554' or zip = '66901' or zip = '66930' or zip = '66932' 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 = '66951' 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 = '67417' or zip = '67418' or zip = '67420' or zip = '67422' or zip = '67423' or zip = '67430' or zip = '67432' or zip = '67436' or zip = '67437' 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 = '67472' or zip = '67473' or zip = '67474' or zip = '67478' or zip = '67481' or zip = '67484' or zip = '67485' or zip = '67487' or zip = '67488' or zip = '67495' or zip = '67621' or zip = '67623' or zip = '67628' or zip = '67638' or zip = '67639' or zip = '67644' or zip = '67648' or zip = '67649' or zip = '67651' or zip = '67658' or zip = '67661' or zip = '67673' or zip = '67675' or zip = '67845' or zip = '67938' or zip = '68303' or zip = '68310' or zip = '68313' or zip = '68315' or zip = '68318' or zip = '68319' or zip = '68322' or zip = '68325' or zip = '68326' or zip = '68327' or zip = '68328' or zip = '68330' or zip = '68333' or zip = '68335' or zip = '68338' 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 = '68359' or zip = '68361' or zip = '68362' or zip = '68365' or zip = '68370' or zip = '68371' or zip = '68375' or zip = '68377' or zip = '68401' or zip = '68406' or zip = '68415' or zip = '68416' or zip = '68424' or zip = '68429' or zip = '68436' or zip = '68440' or zip = '68444' or zip = '68445' or zip = '68452' or zip = '68453' or zip = '68460' or zip = '68464' or zip = '68465' or zip = '68466' or zip = '68467' or zip = '68797' or zip = '68801' or zip = '68802' or zip = '68803' or zip = '68810' or zip = '68818' or zip = '68832' or zip = '68840' or zip = '68841' or zip = '68843' or zip = '68848' or zip = '68854' or zip = '68865' or zip = '68868' or zip = '68876' or zip = '68883' or zip = '68901' or zip = '68902' or zip = '68920' or zip = '68924' or zip = '68925' or zip = '68928' or zip = '68929' or zip = '68930' or zip = '68932' or zip = '68933' or zip = '68934' or zip = '68935' or zip = '68938' or zip = '68939' or zip = '68941' or zip = '68942' or zip = '68943' or zip = '68944' or zip = '68945' or zip = '68947' or zip = '68950' or zip = '68952' or zip = '68954' or zip = '68955' or zip = '68956' or zip = '68957' or zip = '68959' or zip = '68960' or zip = '68961' or zip = '68963' or zip = '68964' or zip = '68969' or zip = '68970' or zip = '68971' or zip = '68972' or zip = '68973' or zip = '68974' or zip = '68975' or zip = '68978' or zip = '68979' or zip = '68980' or zip = '68981' or zip = '68982')
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 = 'WEBBER ' 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: