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 Price

5beds

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

Single Family

Home type

229.12

Price / sqft

2005

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

Square Feet
  • 2239

Bedrooms
  • 5

Bathrooms
  • 3

Heating
  • Has Heating:

    Yes

  • Heating Type:

    Yes

Cooling
  • Has Cooling:

    Yes

  • Cooling Type:

    N/A

Fuel
  • Has Fuel:

    No

  • Fuel Type:

    N/A

Basement
  • Has Basement:

    No

  • Basement Type:

    Finished

Flooring
  • Has Flooring:

    No

  • Flooring Type:

    Carpet

Fireplace
  • Has Fireplace:

    Yes

  • Fireplace Type:

    N/A

Property Details

Lot Size
  • 9583

Water
  • No

Sewer
  • No

Parking
  • Type:

    Garage, Attached

  • Location:

    N/A

  • Status:

    N/A

  • Number of Spaces:

    2

Deck
  • No

Patio
  • No

Fence
  • No

Pool
  • No

Porch
  • No

Stoop
  • No

Breezeway
  • No

Construction Details

Number of Stories
  • N/A

Style
  • Split Foyer

Exterior
  • Aluminum/vinyl

Foundation
  • N/A

Roof
  • N/A

Roofing Material
  • 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

percent-home-icon

Average Home Price in 55038

Nearby Properties

Zip Code

Price

Bed

Bath

Sqft

Lot

Sold Date

$605,000

5 Beds

4 Baths

2,044 Sqft

31,368 Lot (sqft)

Sold 09/18/2026

$431,085

3 Beds

3 Baths

2,354 Sqft

0 Lot (sqft)

Sold 08/11/2026

$420,900

3 Beds

3 Baths

2,335 Sqft

0 Lot (sqft)

Sold 10/06/2026

$427,900

3 Beds

3 Baths

2,354 Sqft

0 Lot (sqft)

Sold 09/29/2026

$413,900

3 Beds

3 Baths

2,335 Sqft

0 Lot (sqft)

Sold 10/06/2026

$427,900

3 Beds

3 Baths

2,354 Sqft

0 Lot (sqft)

Sold 08/06/2026

$521,389

5 Beds

4 Baths

2,292 Sqft

0 Lot (sqft)

Sold 09/29/2026

$582,929

4 Beds

3 Baths

2,556 Sqft

12,091 Lot (sqft)

Sold 10/05/2026

$545,000

4 Beds

4 Baths

2,381 Sqft

14,985 Lot (sqft)

Sold 09/29/2026

percent-home-icon

Calculators

Mortgage

Mortgage Calculator

Calculate your monthly mortgage payments.
Household Income
70,000
$
Home price
499,995
$
Down payment
99,999
$
Mortgage Rate
6.5
%
Loan Term
Property Tax Rate
1.1
%
Homeowner's Insurance (Annual)
2,999.97
$
HOA (Monthly)
0
$
PMI
0
$
$3,237
Your Payment
Total Monthly Payment:$3,237
Percent of Income:55%
Affordable:No

Details for 15870 FARNHAM AVE N

Property Debt

Foreclosure Contact Details

Similar Homes Nearby