Member Features
Find Real Estate Bargain!
Full foreclosure details
Home value, equity and ownership info
Find homes priced below market
Get full access with a FREE Account
Already a member?
$499,995
Listing Price5beds
3baths
2,239sqft
9,583sqft lot
15870 Farnham Ave N, Hugo, MN 55038
Member Features
Find Real Estate Bargain!
Full foreclosure details
Home value, equity and ownership info
Find homes priced below market
Get full access with a FREE Account
Already a member?
For Sale
Off Market
Home type
Price / sqft
Year built
Home Details
Why buy new when you can purchase this gorgeous, move-in ready home with a finished basement! Nestled in the sought after Water's Edge Pool Community of Hugo this custom built home, updated throughout is turn key & ready for you to call your own! Bright & spacious, open concept main level with fresh paint throughout, new carpet & hardwood floors. Kitchen offers large island, ample cabinet space, granite counters, stainless appliances including new range & dishwasher. Sun room is perfect for slow mornings or extra entertaining space & walks out to large cedar deck. 3 Bedrooms, Laundry & Full Bath on main level. Massive private Owner's Suite on upper level boasts new carpet, vaulted ceilings, large walk in closet & ensuite. Lower Level holds Family Room with gas fireplace & custom wet bar, spacious 5th Bedroom & 3/4 Bathroom with walk in, tiled shower. Large patio & private backyard with storage shed. Oversized insulated/heated 2.5 car garage, large concrete driveway with additional parking. All of this within walking distance to schools, many parks, trails and pool!
Interior Details
2239
5
3
Has Heating:
Yes
Heating Type:
Yes
Has Cooling:
Yes
Cooling Type:
N/A
Has Fuel:
No
Fuel Type:
N/A
Has Basement:
No
Basement Type:
Finished
Has Flooring:
No
Flooring Type:
Carpet
Has Fireplace:
Yes
Fireplace Type:
N/A
Property Details
9583
No
No
Type:
Garage, Attached
Location:
N/A
Status:
N/A
Number of Spaces:
2
No
No
No
No
No
No
No
Construction Details
Split Foyer
Aluminum/vinyl
N/A
N/A
Asphalt
Tax History
Year
Amount
Land
Improvement
Percent Change
Assessment
2020
$5,024
$99,300
$280,100
--%
$379,400
2019
$4,272
$98,600
$255,500
--%
$354,100
2018
$4,414
$93,300
$244,300
--%
$337,600
2017
$4,098
$74,800
$231,400
--%
$306,200
2016
$3,756
$64,700
$225,100
--%
$289,800
2014
$3,498
$51,000
$213,000
--%
$264,000
2011
$3,114
$58,900
$165,400
--%
$224,300
Average Home Price in 55038
Nearby Properties
Zip Code
Price
Bed
Bath
Sqft
Lot
Sold Date
$605,000
$605,000
5 Beds
4 Baths
2,044 Sqft
31,368 Lot (sqft)
Sold 09/18/2026
$431,085
$431,085
3 Beds
3 Baths
2,354 Sqft
0 Lot (sqft)
Sold 08/11/2026
$420,900
$420,900
3 Beds
3 Baths
2,335 Sqft
0 Lot (sqft)
Sold 10/06/2026
$427,900
$427,900
3 Beds
3 Baths
2,354 Sqft
0 Lot (sqft)
Sold 09/29/2026
$413,900
$413,900
3 Beds
3 Baths
2,335 Sqft
0 Lot (sqft)
Sold 10/06/2026
$427,900
$427,900
3 Beds
3 Baths
2,354 Sqft
0 Lot (sqft)
Sold 08/06/2026
$521,389
$521,389
5 Beds
4 Baths
2,292 Sqft
0 Lot (sqft)
Sold 09/29/2026
$582,929
$582,929
4 Beds
3 Baths
2,556 Sqft
12,091 Lot (sqft)
Sold 10/05/2026
$545,000
$545,000
4 Beds
4 Baths
2,381 Sqft
14,985 Lot (sqft)
Sold 09/29/2026



