Off market feb 2025 for $415K

$422,227

Est. refi paymentEst. refi $2,632/mo

•

—

sq ft

15751 Farnham Ave N, Hugo, MN 55038

About this home

Get ready to fall in love! Beautiful, spacious, detached townhome in sought after Water's Edge Community. Brand new carpet and paint makes this home ready to move in tomorrow. Large, inviting eat-in kitchen is open to dining/living room. Large windows provide plentiful sunlight into the substantial living room with gas fireplace. Living room is adjacent to cozy sun room that walks out to patio which enjoys the privacy and views of a peaceful wetland. Primary bedroom en-suite includes oversized private bath and walk-in closet. Two more bedrooms with guest bath on opposite side of home provide desirable privacy. Water's Edge also gives you full access to community center complete with outdoor pool, kitchen/party room, fitness area, playground and more. This home is worth a look. See it this weekend!

TownhomeProperty Type

2005Year Built

3,963 sq ftLot Size

2 car garageParking

Listed by Erling Olson • LPT Realty, LLC

Redfin checked: 3 minutes ago

•Source:NORTHSTARMLS as Distributed by MLS Grid #6652233

Redfin Estimate

$422,227

$7,227 since sold in February 2025$3,000 since October

Recently sold homes
Estimate history
Homes for sale

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

SOLD JUN 30, 2026
$429,900
A
3 beds2 baths— sq ft
15739 Farnham Ave N, Hugo, MN 55038
SOLD AUG 27, 2026
$425,000
B
2 beds2 baths— sq ft
5149 157th St N, Hugo, MN 55038
SOLD JUL 16, 2026
$373,500
C
2 beds2 baths— sq ft
5101 157th St N, Hugo, MN 55038
SOLD OCT 7, 2026
$390,000
D
3 beds2 baths— sq ft
6339 151st St N, Hugo, MN 55038
SOLD JUL 23, 2026
$425,000
E
3 beds2 baths— sq ft
6218 152nd St N, Hugo, MN 55038
SOLD SEP 4, 2026
$435,000
F
3 beds2 baths— sq ft
4905 Evergreen Dr 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

$73,906

Est. take-home

List your home with Redfin and save $4,222

Refinance

Est. cash available

Get cash now or lower your monthly rate

Rent

$2,687/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

NEW 2 HRS AGO
$285,000
3 beds2 baths1,878 sq ft
14959 Generation Ave N, Hugo, MN 55038
NEW 5 HRS AGO
$340,000
2 beds2 baths1,318 sq ft
1763 Ojibway Dr, Centerville, MN 55038
COMING SOON
$499,900
5 beds4 baths2,700 sq ft
1751 Main St, Centerville, MN 55038
COMING SOON
$670,000
5 beds5 baths3,200 sq ft
7320 Watermark Way, Lino Lakes, MN 55038
NEW 28 HRS AGO
$299,900
3 beds2 baths1,560 sq ft
1977 Robin Ln S, Centerville, MN 55038
COMING SOON
$499,900
4 beds4 baths2,672 sq ft
1816 Partridge Pl, Centerville, MN 55038
OPEN SAT, 12PM TO 1:30PM
$375,000
3 beds2 baths1,611 sq ft
6250 152nd St N, Hugo, MN 55038
$235,000
2 beds2 baths1,450 sq ft
2045 Willow Cir, Centerville, MN 55038
$455,000
5 beds3 baths2,366 sq ft
6608 Tele Ln, Lino Lakes, MN 55038
$575,000
5 beds4 baths3,421 sq ft
2080 Watermark Way, Lino Lakes, MN 55038
See all

Provided by Redfin

Sale history for 15751 Farnham Ave N

Date

Event

Price

NORTHSTARMLS as Distributed by MLS Grid #6652233

Feb 26, 2025

Sold

$415,000

Feb 18, 2025

Pending

—

Jan 31, 2025

Contingent

—

Jan 30, 2025

Listed

$415,000

Jan 29, 2025

Coming Soon

$415,000

NORTHSTARMLS as Distributed by MLS Grid #4706259

Jul 18, 2016

Sold

$289,000

Jul 5, 2016

Pending

—

Jun 8, 2016

Contingent

—

May 19, 2016

Relisted

—

May 8, 2016

Contingent

—

Apr 25, 2016

Listed

$292,900

+17

Outstanding 3BR/2BA 1-LVL detached townhome on premium lot overlooking wetland pond w/ preserve-like setting. Eat-in kitchen w/maple cabinetry, huge pantry & upgraded appliances. Spacious dining/living room w/gas fireplace. Master suite w/walk-in closet, private bath w/soaker tub, separate shower , dual vanity & IN-FLOOR heated tile. 4Seas sun room w/walkout to double-sized patio overlooking wetland. Low assoc fees & great amenities includes shared fitness center, outdoor pool & party room.

NORTHSTARMLS as Distributed by MLS Grid #4672319

Apr 21, 2016

Listing Removed

—

Apr 1, 2016

Price Changed

$292,900

Feb 3, 2016

Price Changed

$299,900

Jan 21, 2016

Price Changed

$305,000

Jan 18, 2016

Listed

$314,900

NORTHSTARMLS as Distributed by MLS Grid #4672246

Jan 18, 2016

Price Changed

$314,900

Jan 18, 2016

Listed

$3,149,000

Jan 18, 2016

Listing Removed

—

NORTHSTARMLS as Distributed by MLS Grid #3168001

Jul 16, 2006

Listing Removed

—

Mar 18, 2006

Listed

$311,325

Year

Property tax

Land + Additions

Assessment*

2026

$4,478 (+6.0%)

$141,500 + $231,400

$372,900

2025

$4,226 (−7.6%)

$131,400 + $220,400

$351,800

2024

$4,576 (+3.2%)

$176,200 + $229,300

$405,500

2023

$4,432 (+12.7%)

$173,300 + $212,900

$386,200

2022

$3,932 (+12.5%)

$136,300 + $175,400

$311,700

2021

$3,494 (−0.1%)

$105,600 + $168,600

$274,200

2020

$3,498 (+9.9%)

$95,500 + $166,800

$262,300

2019

$3,182 (+6.2%)

$105,000 + $157,000

$262,000

2018

$2,996 (+28.6%)

$105,000 + $157,000

$262,000

2017

$2,330 (+0.7%)

$100,700 + $151,700

$252,400

2015

$2,314 (+8.5%)

$45,400 + $139,400

$184,800

2014

$2,132 (+2.2%)

$35,100 + $122,900

$158,000

2013

$2,086 (−8.7%)

$39,000 + $136,400

$175,400

2012

$2,284

$45,100 + $133,700

$178,800

Tax history for 15751 Farnham Ave N

Year

Property tax

Land + Additions

Assessment*

2026

$4,478 (+6.0%)

$141,500 + $231,400

$372,900

2025

$4,226 (−7.6%)

$131,400 + $220,400

$351,800

2024

$4,576 (+3.2%)

$176,200 + $229,300

$405,500

2023

$4,432 (+12.7%)

$173,300 + $212,900

$386,200

2022

$3,932 (+12.5%)

$136,300 + $175,400

$311,700

2021

$3,494 (−0.1%)

$105,600 + $168,600

$274,200

2020

$3,498 (+9.9%)

$95,500 + $166,800

$262,300

2019

$3,182 (+6.2%)

$105,000 + $157,000

$262,000

2018

$2,996 (+28.6%)

$105,000 + $157,000

$262,000

2017

$2,330 (+0.7%)

$100,700 + $151,700

$252,400

2015

$2,314 (+8.5%)

$45,400 + $139,400

$184,800

2014

$2,132 (+2.2%)

$35,100 + $122,900

$158,000

2013

$2,086 (−8.7%)

$39,000 + $136,400

$175,400

2012

$2,284

$45,100 + $133,700

$178,800

*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

3,960 Sq. Ft.

Year renovated

2005

Sq. Ft.

1,869

Year built

2005

Style

Single Family Residential

County

Washington County

APN

18.031.21.11.0054

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, Asphalt, Garage Door Opener, Storage
Garage Spaces: 2
Garage Sq. Ft.: 480

Interior

Bedroom Information
# of Bedrooms: 3

Bathroom Information
# of Full Baths (Total): 2
Description: Double Sink,Full Primary,Private Primary,Main Floor Full Bath,Separate Tub & Shower

Room 1 Information
Room Type: Dining Room
Room Dimensions: 14x10
Room Level: Main

Room 2 Information
Room Type: Bedroom
Room Dimensions: 17x13
Room Level: Main

Room 3 Information
Room Type: Foyer
Room Dimensions: 9x7
Room Level: Main

Room 4 Information
Room Type: Kitchen
Room Dimensions: 21x12
Room Level: Main

Room 5 Information
Room Type: Living Room
Room Dimensions: 16x14
Room Level: Main

Room 6 Information
Room Type: Patio
Room Dimensions: 16x12
Room Level: Main

Room 7 Information
Room Type: Bedroom 2
Room Dimensions: 12x10
Room Level: Main

Room 8 Information
Room Type: Sun Room
Room Dimensions: 11x10
Room Level: Main

Room 9 Information
Room Type: Bedroom 3
Room Dimensions: 12x10
Room Level: Main

Laundry Room Information
Laundry Features: Laundry Room, Main Level, Washer Hookup

Basement Information
Basement Features: None

Dining Room Information
Dining Room Features: Breakfast Area,Eat In Kitchen,Living/Dining Room

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

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

Heating & Cooling
Heating Information: Forced Air
Cooling Information: Central Air

Interior Features
Appliances: Dishwasher, Disposal, Dryer, Gas Water Heater, Microwave, Range, Refrigerator, Washer, Water Softener Owned

Exterior

Building Information
Construction Materials: Frame
Foundation Area: 1,818
Roof: Age 8 Years or Less, Asphalt, Pitched

Exterior Features
Patio Porch Type: Patio
Fencing: None

Pool Information
Pool Features: Shared

Property Information
Above Ground Total Sq. Ft.: 1,818
FractionalOwnershipYN: No
Property Type: Residential
Property Sub Type: Townhouse Detached
Accessibility Features: Grab Bars In Bathroom, No Stairs External, No Stairs Internal
Above Grade Finished Area: 1,818
Amenities: Cable,Ceiling Fan(s),French Doors,Kitchen Window,Primary Bedroom Walk-In Closet,Main Floor Primary Bedroom,Natural Woodwork,Patio,In-Ground Sprinkler,Sun Room,Tile Floors,Washer/Dryer Hookup,Walk-In Closet

Lot Information
Lot Size Area: 0.091
Lot Size Units: Acres
Lot Size Dimensions: 3,960
Road Frontage Type: City Street, Curbs, Paved Streets, Sidewalks, Street Lights
Road Responsibility: Public Maintained Road

Financial

Assessment Information
Other Annual Assessment Amount: $3

Tax Information
Tax Annual Amount: $4,573
Tax Year: 2024
Tax With Assessments: $4,576

Financial Information
Conventional

Utilities

Utility Information
Water Source: City Water/Connected
Electric: Circuit Breakers, 100 Amp Service
Sewer: City Sewer/Connected
Fuel: Natural Gas

Location

HOA Information
Association Name: HOALiving Minnesota
Has HOA
Association Fee: $352
Association Fee Frequency: Monthly
Association Fee Includes: Hazard Insurance, Lawn Care, Maintenance Grounds, Professional Mgmt, Recreation Facility, Shared Amenities, Snow Removal

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

Location Information
Directions: 35E to Cty Rd 14 - East to Oneka Pkwy N, Left to Falcon, Right to 157th, RIGHT to Farnham
Map Coordinate: 67-B1

Public facts

Beds: 3
Baths: 2.0
Sq. Ft.: 1,869
Stories: 1.0
Lot Size: 3,960 square feet
Style: Single Family Residential
Year Built: 2005
Year Renovated: 2005
County: Washington County
APN: 18.031.21.11.0054

Home facts updated by county records on Oct 16, 2026

Other

Home Information
Living Area: 1818
Living Area Units: Square Feet
Main Level Finished Area: 1818
Building Area Total: 1818
Levels: One

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.2mi

6/10

White Bear Lake Area High School

Public 9-12 • Assigned • 5.8mi

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)

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

$402,000 – $486,000

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

Need the cash from your home fast? Sell to .

Nearby similar homes

OPEN SAT, 12PM TO 4PM

$279,900

2 beds1 bath952 sq ft

5328 397th St, North Branch, MN 55056

Modern kitchen • Upgraded cabinets • Breakfast bar

$290,000

3 beds3 baths1,494 sq ft

7858 Marilyn Dr, Lino Lakes, MN 55014

Corner townhome • Cozy gas fireplace • Functional kitchen

$329,900

3 beds3 baths2,525 sq ft

4805 Iris Alcove, White Bear Lake Township, MN 55127

Cozy gas fireplace • Inviting sunroom • Private deck

$255,000

2 beds2 baths1,543 sq ft

6421 Lakota Trl, Lino Lakes, MN 55014

Vaulted living room • Newer granite • Newer tile floor

NEW CONSTRUCTION

$329,990

3 beds3 baths1,722 sq ft

6143 205th Cv N, Forest Lake, MN 55025

Double-height foyer • Great room • Electric fireplace

$229,900

2 beds2 baths1,195 sq ft

109 South Dr Unit D, Circle Pines, MN 55014

Open concept layout • Cozy fireplace • Efficient kitchen

New listings for sale in 55038

NEW 2 HRS AGO

$285,000

3 beds2 baths1,878 sq ft

14959 Generation Ave N, Hugo, MN 55038

Updated home • New cabinets • New countertops

NEW 5 HRS AGOVIDEO TOUR

$340,000

2 beds2 baths1,318 sq ft

1763 Ojibway Dr, Centerville, MN 55038

One level living • Twin home • Quiet cul-de-sac

COMING SOON

$499,900

5 beds4 baths2,700 sq ft

1751 Main St, Centerville, MN 55038

Cozy gas fireplace • Separate entrance • Full bathroom

COMING SOON

$670,000

5 beds5 baths3,200 sq ft

7320 Watermark Way, Lino Lakes, MN 55038

Own kitchen • Serene backyard • Neighborhood trail

NEW 28 HRS AGO

$299,900

3 beds2 baths1,560 sq ft

1977 Robin Ln S, Centerville, MN 55038

Updated home • Oversized garage • Included ev charger

COMING SOON

$499,900

4 beds4 baths2,672 sq ft

1816 Partridge Pl, Centerville, MN 55038

Two story • New carpet • Vaulted ceilings

OPEN SAT, 12PM TO 1:30PM

$375,000

3 beds2 baths1,611 sq ft

6250 152nd St N, Hugo, MN 55038

Corner lot • Elevated deck • Walkout lower level

$235,000

2 beds2 baths1,450 sq ft

2045 Willow Cir, Centerville, MN 55038

Private patio • Versatile loft • Upper level laundry

$455,000

5 beds3 baths2,366 sq ft

6608 Tele Ln, Lino Lakes, MN 55038

Large eat-in kitchen • Private back yard • 0.37 acre lot

Home values near 15751 Farnham Ave N

Data from public records.

Address	Redfin Estimate
15727 Farnham Ave N, Hugo, MN 2 Beds \| 2 Baths \| - Sq. Ft.	$390,923
15701 Farnham Ave N, Hugo, MN 3 Beds \| 2 Baths \| - Sq. Ft.	$416,125
15731 Farnham Ave N, Hugo, MN 3 Beds \| 2 Baths \| - Sq. Ft.	$407,981
15749 Farnham Ave N, Hugo, MN 2 Beds \| 2 Baths \| - Sq. Ft.	$386,151
5208 157th St N, Hugo, MN 3 Beds \| 2 Baths \| 1869 Sq. Ft.	$395,108
5167 158th St N, Hugo, MN 2 Beds \| 2 Baths \| - Sq. Ft.	$390,880
5188 157th St N, Hugo, MN 3 Beds \| 2 Baths \| 1869 Sq. Ft.	$396,270

Address	Redfin Estimate
15830 Farnham Ave N, Hugo, MN 4 Beds \| 3 Baths \| - Sq. Ft.	$470,371
15763 Farnham Ave N, Hugo, MN 2 Beds \| 2 Baths \| - Sq. Ft.	$403,295
15713 Farnham Ave N, Hugo, MN 3 Beds \| 2 Baths \| 1869 Sq. Ft.	$374,278
15840 Farnham Ave N, Hugo, MN 4 Beds \| 4 Baths \| - Sq. Ft.	$517,375
5180 157th St N, Hugo, MN 2 Beds \| 2 Baths \| - Sq. Ft.	$382,234
5176 157th St N, Hugo, MN 3 Beds \| 2 Baths \| - Sq. Ft.	$406,325
5183 158th St N, Hugo, MN 3 Beds \| 2 Baths \| - Sq. Ft.	$400,854

Address	Redfin Estimate
15739 Farnham Ave N, Hugo, MN 3 Beds \| 2 Baths \| - Sq. Ft.	$430,440
15719 Farnham Ave N, Hugo, MN 2 Beds \| 2 Baths \| - Sq. Ft.	$387,727
15771 Farnham Ave N, Hugo, MN 3 Beds \| 2 Baths \| - Sq. Ft.	$404,066
5197 158th St N, Hugo, MN 2 Beds \| 2 Baths \| - Sq. Ft.	$374,335
5150 158th St N, Hugo, MN 3 Beds \| 2 Baths \| 1869 Sq. Ft.	$397,173
5153 158th St N, Hugo, MN 2 Beds \| 2.5 Baths \| 1708 Sq. Ft.	$354,060
5190 158th St N, Hugo, MN 3 Beds \| 2 Baths \| - Sq. Ft.	$396,456

Property information provided by NORTHSTARMLS as Distributed by MLS Grid when last listed in 2025. 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 15751 Farnham Ave N

Tax history for 15751 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 15751 Farnham Ave N

More real estate resources