OFF MARKET

Off market dec 2024 for $500K

$529,275

Est. refi paymentEst. refi $3,602/mo

•

—

sq ft

15870 Farnham Ave N, Hugo, MN 55038

About this home

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!

Single-familyProperty Type

2005Year Built

9,583 sq ftLot Size

2 car garageParking

Listed by Kathryn Johnson • eXp Realty

Listed by Kelsie Lembeck

Redfin checked: 2 minutes ago

•Source:NORTHSTARMLS as Distributed by MLS Grid #6582873

Redfin Estimate

$529,275

$29K since sold in December 2024$5,000 since October

Recently sold homes
Estimate history
Homes for sale

This home's estimate is 3% higher than the average sale price ($514K) of 6 comparable homes.

SOLD SEP 22, 2026
$555,000
A
4 beds3 baths— sq ft
15602 Enfield Ave N, Hugo, MN 55038
SOLD AUG 21, 2026
$430,000
B
5 beds3 baths— sq ft
4928 159th St N, Hugo, MN 55038
SOLD AUG 10, 2026
$590,000
C
4 beds4 baths— sq ft
15692 Enfield Ave N, Hugo, MN 55038
SOLD MAY 22, 2026
$498,000
D
5 beds3 baths— sq ft
4920 159th St N, Hugo, MN 55038
SOLD OCT 9, 2026
$490,000
E
5 beds3 baths— sq ft
4813 162nd Way N, Hugo, MN 55038
SOLD SEP 4, 2026
$519,900
F
5 beds3 baths— sq ft
6624 145th Cir N, Hugo, MN 55038

Claim this home to receive a free report every month with insights on the changing estimate.

Earn from this home

Sell

$109,810

Est. take-home

List your home with Redfin and save $5,293

Refinance

Est. cash available

Get cash now or lower your monthly rate

Rent

$3,152/mo

Redfin rental estimate

List your home for rent

Market trends in 55038, MN

Last updated October 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-list price

99.0%

0.6% MoM

Median sale price

$470K

$40K MoM

Avg. days on market

33d

1 days MoM

Recently sold homes

132

13 MoM

New listings for sale

$670,000
5 beds5 baths3,200 sq ft
7320 Watermark Way, Lino Lakes, MN 55038
$319,000
4 beds2 baths1,638 sq ft
15035 Glenbrook Ave N, Hugo, MN 55038
$425,000
4 beds4 baths3,196 sq ft
6799 177th St N, Hugo, MN 55038
3D WALKTHROUGH
$499,900
5 beds4 baths2,700 sq ft
1751 Main St, Centerville, MN 55038
$509,900
3 beds3 baths2,250 sq ft
4828 Ethan Trl N, Hugo, MN 55038
3D WALKTHROUGH
$499,900
4 beds4 baths2,672 sq ft
1816 Partridge Pl, Centerville, MN 55038
$794,947
4 beds3 baths2,590 sq ft
4520 Cosette Ln N, Hugo, MN 55038
$539,900
5 beds4 baths2,811 sq ft
4952 Fairoaks Cir N, Hugo, MN 55038
$525,000
4 beds4 baths3,084 sq ft
1853 Revoir St, Centerville, MN 55038
$285,000
3 beds2 baths1,878 sq ft
14959 Generation Ave N, Hugo, MN 55038
See all

Provided by Redfin

Sale history for 15870 Farnham Ave N

Date

Event

Price

NORTHSTARMLS as Distributed by MLS Grid #6582873

Dec 16, 2024

Sold

$500,000

Dec 8, 2024

Pending

—

Nov 15, 2024

Contingent

—

Oct 21, 2024

Relisted

—

Oct 14, 2024

Contingent

—

Sep 27, 2024

Price Changed

$499,995

Sep 5, 2024

Price Changed

$519,900

Aug 15, 2024

Listed

$549,900

Aug 12, 2024

Coming Soon

$549,900

NORTHSTARMLS as Distributed by MLS Grid #6538302

Aug 6, 2024

Listing Removed

—

Aug 1, 2024

Price Changed

$549,500

Jul 10, 2024

Price Changed

$559,900

Jun 6, 2024

Price Changed

$575,500

May 16, 2024

Listed

$599,995

NORTHSTARMLS as Distributed by MLS Grid #3356845

Apr 30, 2007

Listing Removed

—

Apr 10, 2007

Listed

$319,900

NORTHSTARMLS as Distributed by MLS Grid #3215589

Sep 22, 2006

Listing Removed

—

Jun 8, 2006

Listed

$350,000

NORTHSTARMLS as Distributed by MLS Grid #3125734

Jun 7, 2006

Listing Removed

—

Dec 7, 2005

Listed

$359,900

Public Records

Feb 8, 2005

Sold

$98,765

Public Records

Nov 30, 2004

Sold

$80,000

Join or sign in to view all info

Year

Property tax

Land + Additions

Assessment*

2026

$5,774 (+10.6%)

$117,300 + $363,300

$480,600

2025

$5,220 (−17.5%)

$83,700 + $352,500

$436,200

2024

$6,328 (+16.0%)

$120,000 + $378,900

$498,900

2023

$5,454 (+10.1%)

$126,200 + $349,600

$475,800

2022

$4,954 (+0.6%)

$104,600 + $289,600

$394,200

2021

$4,926 (−2.0%)

$109,400 + $279,200

$388,600

2020

$5,024 (+17.6%)

$99,300 + $280,100

$379,400

2019

$4,272 (−3.2%)

$98,600 + $255,500

$354,100

2018

$4,414 (+7.7%)

$98,600 + $255,500

$354,100

2017

$4,098 (+5.0%)

$93,300 + $244,300

$337,600

2015

$3,902 (+11.5%)

$65,000 + $235,300

$300,300

2014

$3,498 (+2.0%)

$51,000 + $213,000

$264,000

2013

$3,430 (+10.1%)

$52,300 + $218,300

$270,600

2012

$3,114

$58,900 + $165,400

$224,300

Tax history for 15870 Farnham Ave N

Year

Property tax

Land + Additions

Assessment*

2026

$5,774 (+10.6%)

$117,300 + $363,300

$480,600

2025

$5,220 (−17.5%)

$83,700 + $352,500

$436,200

2024

$6,328 (+16.0%)

$120,000 + $378,900

$498,900

2023

$5,454 (+10.1%)

$126,200 + $349,600

$475,800

2022

$4,954 (+0.6%)

$104,600 + $289,600

$394,200

2021

$4,926 (−2.0%)

$109,400 + $279,200

$388,600

2020

$5,024 (+17.6%)

$99,300 + $280,100

$379,400

2019

$4,272 (−3.2%)

$98,600 + $255,500

$354,100

2018

$4,414 (+7.7%)

$98,600 + $255,500

$354,100

2017

$4,098 (+5.0%)

$93,300 + $244,300

$337,600

2015

$3,902 (+11.5%)

$65,000 + $235,300

$300,300

2014

$3,498 (+2.0%)

$51,000 + $213,000

$264,000

2013

$3,430 (+10.1%)

$52,300 + $218,300

$270,600

2012

$3,114

$58,900 + $165,400

$224,300

*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.

Public record

Beds

Baths

Stories

—

Lot width

—

Lot depth

—

Lot size

9,595 Sq. Ft.

Year renovated

2005

Sq. Ft.

3,485

Year built

2005

Style

Single Family Residential

County

Washington County

APN

18.031.21.11.0028

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Oct 16, 2026.

Property details

Parking

Parking Information
Parking Features: Attached Garage, Concrete, Electric, Heated Garage, Insulated Garage, Storage
Garage Spaces: 2.5
Garage Dimensions: 25x21
Garage Sq. Ft.: 525

Interior

Bedroom Information
# of Bedrooms: 5

Bathroom Information
# of Full Baths (Total): 2
# of Three Quarter Baths (Total): 1
Description: 3/4 Basement,Double Sink,Full Primary,Private Primary,Main Floor Full Bath,Separate Tub & Shower,Jetted Tub,Walk-In Shower Stall

Room 1 Information
Room Type: Deck
Room Dimensions: 11x10
Room Level: Main

Room 2 Information
Room Type: Dining Room
Room Dimensions: 12x10
Room Level: Main

Room 3 Information
Room Type: Family Room
Room Dimensions: 32x18
Room Level: Lower

Room 4 Information
Room Type: Bedroom 5
Room Dimensions: 15x12
Room Level: Lower

Room 5 Information
Room Type: Bedroom
Room Dimensions: 24x16
Room Level: Upper

Room 6 Information
Room Type: Bedroom 4
Room Dimensions: 10x10
Room Level: Main

Room 7 Information
Room Type: Foyer
Room Dimensions: 12x8
Room Level: Main

Room 8 Information
Room Type: Kitchen
Room Dimensions: 12x11
Room Level: Main

Room 9 Information
Room Type: Laundry
Room Dimensions: 9x6
Room Level: Main

Room 10 Information
Room Type: Living Room
Room Dimensions: 16x13
Room Level: Main

Room 11 Information
Room Type: Patio
Room Dimensions: 25x15
Room Level: Main

Room 12 Information
Room Type: Bedroom 2
Room Dimensions: 11x11
Room Level: Main

Room 13 Information
Room Type: Sun Room
Room Dimensions: 12x12
Room Level: Main

Room 14 Information
Room Type: Bedroom 3
Room Dimensions: 11x11
Room Level: Main

Laundry Room Information
Laundry Features: Gas Dryer Hookup, Laundry Room, Main Level, Sink, Washer Hookup

Basement Information
Has Basement
Basement Features: Block, Daylight/Lookout Windows, Drain Tiled, 8 ft+ Pour, Egress Window(s), Finished, Full, Storage Space, Sump Pump, Walkout

Dining Room Information
Dining Room Features: Eat In Kitchen,Informal Dining Room,Kitchen/Dining Room

Other Rooms Information
3 BR on One Level,All Living Facilities on One Level,Main Floor Laundry,Primary Bdr Suite

Fireplace Information
Has Fireplace
# of Fireplaces: 1
Fireplace Features: Family Room, Gas, Stone

Heating & Cooling
Heating Information: Forced Air, Fireplace(s)
Cooling Information: Central Air

Interior Features
Appliances: Air-To-Air Exchanger, Dishwasher, Disposal, Dryer, Exhaust Fan, Humidifier, Gas Water Heater, Microwave, Range, Refrigerator, Stainless Steel Appliances, Washer

Exterior

Building Information
Foundation Area: 1,486
Roof: Age 8 Years or Less, Pitched

Exterior Features
Patio Porch Type: Deck,Front Porch,Patio
Fencing: Chain Link, Partial, Wood

Pool Information
Pool Features: Below Ground, Shared

Property Information
Above Ground Total Sq. Ft.: 2,242
Below Ground Total Sq. Ft.: 1,318
FractionalOwnershipYN: No
Property Type: Residential
Property Sub Type: Single Family Residence
Other Structures: Storage Shed
Above Grade Finished Area: 2,242
Below Grade Finished Area: 1,246
Amenities: Ceiling Fan(s),Deck,Hardwood Floors,Kitchen Center Island,Kitchen Window,Primary Bedroom Walk-In Closet,Patio,Porch,Security System,Boat Slip,Sun Room,Tile Floors,Vaulted Ceiling(s),Washer/Dryer Hookup,Wet Bar,Walk-In Closet

Lot Information
Lot Size Area: 0.22
Lot Size Units: Acres
Lot Size Dimensions: 97x130x51x130
Road Frontage Type: City Street, Curbs, Paved Streets, Sidewalks, Street Lights
Road Responsibility: Public Maintained Road

Financial

Assessment Information
Other Annual Assessment Amount: $701.86

Tax Information
Tax Annual Amount: $5,626.14
Tax Year: 2024
Tax With Assessments: $6,328

Utilities

Utility Information
Water Source: City Water/Connected
Electric: Circuit Breakers
Sewer: City Sewer/Connected
Fuel: Natural Gas

Location

Multi-Unit Information
Shared Rooms: Amusement/Party Room,Community Room,Exercise Room,Other

HOA Information
Association Name: HOAliving MN
Has HOA
Association Amenities: Other, Trail(s)
Association Fee: $65
Association Fee Frequency: Monthly
Association Fee Includes: Professional Mgmt, Shared Amenities

School Information
High School District: White Bear Lake
School District Number: 2099
School District Phone: 6514077500

Location Information
Directions: 35E to Cty 14 (Main St), Go east; Left on Oneka Pkwy; Right on Falcon Cir; Right on 158th St; Left on Farnham Ave and North to property on right.
Map Coordinate: 67-B1

Public facts

Beds: 5
Baths: 2.0
Sq. Ft.: 3,485
Stories: —
Lot Size: 9,595 square feet
Style: Single Family Residential
Year Built: 2005
Year Renovated: 2005
County: Washington County
APN: 18.031.21.11.0028

Home facts updated by county records on Oct 16, 2026

Other

Home Information
Living Area: 3488
Living Area Units: Square Feet
Main Level Finished Area: 1630
Levels: Three Level Split

Around this home

Schools

K - 12
Preschool & daycare

Oneka Elementary School

Public PreK-5 • Assigned • 0.4mi

7/10

Central Middle School

Public 6-8 • Assigned • 6.3mi

6/10

White Bear Lake Area High School

Public 9-12 • Assigned • 6.0mi

Provided by GreatSchools

Lifestyle

Provided by Walk Score and Local Logic

Climate risks

1/10 Flood Factor

Minimal risk of a flood reaching the building in the next 30 years

4/10 Fire Factor

0.93% chance of being in a wildfire in next 30 years

2/10 Heat Factor

7 days above 99° expected this year, 14 days in 30 years

2/10 Wind Factor

Minor risk of severe winds over next 30 years

2/10 Air Factor

1 unhealthy days expected this year, 2 days in 30 years

Provided by First Street

Historical weather

Hugo, MN • 55038

Average low and high temperatures (°F)

22°

5°

29°

12°

48°

27°

56°

37°

69°

49°

77°

59°

85°

66°

78°

61°

75°

57°

61°

45°

44°

30°

28°

13°

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Sun exposure

In this area, properties receive around 10.3 hours in June and 3.5 hours in December, which is comparable to the U.S. average for solar exposure.

10.3 hrs

3.5 hrs

JuneDecember

Provided by Shadowmap

Estimated sale price

$503,000 – $609,000

Reach more buyers when you sell with Redfin. Save up to $5,293 in fees. 3 minutes to get started.

Need the cash from your home fast? Sell to .

Nearby similar homes

$615,000

4 beds4 baths2,941 sq ft

14118 Jardin Ave N, Hugo, MN 55038

Private backyard • Custom walnut inlay • Fireplace mantel

$352,500

4 beds2 baths1,647 sq ft

1785 Center St, Centerville, MN 55038

Bike trail access • Private backyard • Updated kitchen

3D WALKTHROUGH

$649,900

5 beds4 baths3,400 sq ft

16206 Europa Ave N, Hugo, MN 55038

Open floor plan • Butler's pantry • Gas fireplace

$615,000

4 beds3 baths2,692 sq ft

2105 Itasca Cir, Lino Lakes, MN 55038

Spacious kitchen • Stainless appliances • Corner gas fireplace

$350,000

3 beds2 baths1,566 sq ft

7236 Clear Rdg, Centerville, MN 55038

Private cul-de-sac • Walking trails • Large family room

$149,900

Land— sq ft

16121 Empress Ave N, Hugo, MN 55038

Listed 10 days

New listings for sale in 55038

$670,000

5 beds5 baths3,200 sq ft

7320 Watermark Way, Lino Lakes, MN 55038

Own kitchen • Serene backyard • Neighborhood trail

$319,000

4 beds2 baths1,638 sq ft

15035 Glenbrook Ave N, Hugo, MN 55038

Privacy wall • 6,011 sq ft lot • 2 garage spots

$425,000

4 beds4 baths3,196 sq ft

6799 177th St N, Hugo, MN 55038

Detached garage • Pole building • Large sunroom

3D WALKTHROUGH

$499,900

5 beds4 baths2,700 sq ft

1751 Main St, Centerville, MN 55038

Cozy gas fireplace • Separate entrance • Full bathroom

$509,900

3 beds3 baths2,250 sq ft

4828 Ethan Trl N, Hugo, MN 55038

Modern kitchen • Granite countertops • Soft-close hinges

3D WALKTHROUGH

$499,900

4 beds4 baths2,672 sq ft

1816 Partridge Pl, Centerville, MN 55038

Two story • New carpet • Vaulted ceilings

$794,947

4 beds3 baths2,590 sq ft

4520 Cosette Ln N, Hugo, MN 55038

Box vaulted ceiling • 9,801 sq ft lot • 3 garage spots

$539,900

5 beds4 baths2,811 sq ft

4952 Fairoaks Cir N, Hugo, MN 55038

Walk-in closet • Separate jacuzzi tub • Finished lower level

$525,000

4 beds4 baths3,084 sq ft

1853 Revoir St, Centerville, MN 55038

Modified two-story • Newer appliances • 0.4 acre lot

Home values near 15870 Farnham Ave N

Data from public records.

Address	Redfin Estimate
15860 Farnham Avenue North, Hugo, MN 3 Beds \| 2 Baths \| - Sq. Ft.	$422,775
15922 Farnham Avenue North, Hugo, MN 5 Beds \| 3 Baths \| - Sq. Ft.	$442,138
5260 159th Street North, Hugo, MN 4 Beds \| 3 Baths \| - Sq. Ft.	$414,785
5285 Fenson Court North, Hugo, MN 4 Beds \| 2.5 Baths \| 2428 Sq. Ft.	$464,835
5261 Fenson Court North, Hugo, MN 3 Beds \| 3 Baths \| - Sq. Ft.	$487,441
5240 159th Street North, Hugo, MN 4 Beds \| 3 Baths \| - Sq. Ft.	$482,645
5265 Fenson Court North, Hugo, MN 4 Beds \| 4 Baths \| - Sq. Ft.	$531,297

Address	Redfin Estimate
15830 Farnham Avenue North, Hugo, MN 4 Beds \| 3 Baths \| - Sq. Ft.	$471,739
15906 Farnham Avenue North, Hugo, MN 3 Beds \| 2 Baths \| 1500 Sq. Ft.	$405,625
5099 159th Street North, Hugo, MN 4 Beds \| 3 Baths \| - Sq. Ft.	$468,922
5107 159th Street North, Hugo, MN 4 Beds \| 3 Baths \| - Sq. Ft.	$518,433
5257 Fenson Court North, Hugo, MN 5 Beds \| 3 Baths \| - Sq. Ft.	$499,829
5269 Fenson Court North, Hugo, MN 6 Beds \| 4 Baths \| - Sq. Ft.	$604,619
5273 Fenson Court North, Hugo, MN 4 Beds \| 3 Baths \| - Sq. Ft.	$489,881

Address	Redfin Estimate
15880 Farnham Avenue North, Hugo, MN 4 Beds \| 3 Baths \| - Sq. Ft.	$455,604
15840 Farnham Avenue North, Hugo, MN 4 Beds \| 4 Baths \| - Sq. Ft.	$511,745
5259 Fenson Court North, Hugo, MN 3 Beds \| 3 Baths \| - Sq. Ft.	$491,322
5277 Fenson Court North, Hugo, MN 5 Beds \| 2 Baths \| - Sq. Ft.	$437,505
5085 159th Street North, Hugo, MN 4 Beds \| 3 Baths \| - Sq. Ft.	$433,733
5281 Fenson Court North, Hugo, MN 4 Beds \| 2 Baths \| 2220 Sq. Ft.	$412,133
5255 Fenson Court North, Hugo, MN 5 Beds \| 3 Baths \| - Sq. Ft.	$461,322

Property information provided by NORTHSTARMLS as Distributed by MLS Grid when last listed in 2024. This data may not match . Learn more.

Download the Redfin App on the Apple App Store

Download the Redfin App from the Google Play Store

Join us

Become an Agent

Get referrals

Careers

Find homes faster

About us

Find us

Subsidiaries

Affiliated Business

Countries

United States

Canada

Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.

Do not sell or share my personal information.

REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.

Redfin Brokerage Licenses

California DRE #01521930

Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures

New Mexico Real Estate Licenses

TREC: Info About Brokerage Services, Consumer Protection Notice

All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.

Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.

If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.

REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.

GreatSchools Ratings provided by GreatSchools.org.

55110 homes for sale
55025 homes for sale
55038 homes for sale
55082 homes for sale

Houses for rent in Hugo	Agents near me	Woodbury, MN homes for sale	Hugo Housing Market
Houses for sale near me	Minneapolis, MN homes for sale	Eagan, MN homes for sale
Land for sale near me	St. Paul, MN homes for sale	Minnetonka, MN homes for sale
Open Houses near me	Edina, MN homes for sale	Hugo Property Records
Condos for sale near me	Plymouth, MN homes for sale	MN New Listings

Woodbury homes for sale
St. Paul homes for sale
Minneapolis homes for sale

About this home

Redfin Estimate

Earn from this home

Market trends in 55038, MN

Sale history for 15870 Farnham Ave N

Tax history for 15870 Farnham Ave N

Public record

Property details

Around this home

Schools

Lifestyle

Climate risks

Historical weather

Sun exposure

Nearby similar homes

New listings for sale in 55038

Home values near 15870 Farnham Ave N

More real estate resources