15194 Farnham Avenue N, Hugo, MN 55038

New Listing
$309,900
Property Type: Residential Bedrooms: 3 Baths: 3 Square Footage: 1,969 Lot Size (sq. ft.): 1,307 Status: Coming Soon
Current Price: $309,900 List Date: 5/06/2026 Last Modified: 5/06/2026

Overview

Description

Welcome to this beautifully updated townhome. Featuring 3 bedrooms, 3 bathrooms, and a 2-car garage, this home blends comfort and style. The main level showcases rich hardwood floors, a cozy gas fireplace and an open-concept layout perfect for everyday living and entertaining. This dream kitchen includes stainless steel appliances and granite countertops. Upstairs, you’ll find a luxurious primary suite complete with a custom walk-in closet and an updated custom bathroom with a large walk-in shower, with over head rain shower, granite counter and dual sinks. Laundry room includes custom cabinetry, storage, front-loading washer and dryer. Garage includes plenty of shelving for storage, and the electrical is already set up for an electric vehicle charger. Enjoy outdoor living on your private patio, just off the kitchen. This home is part of the Waters Edge association, and access to fantastic amenities. Including a clubhouse, party room, fitness center, large in-ground pool, kiddie pool, playground and miles of walking paths. This home truly has it all—modern upgrades, ample space, and access to fantastic community features. Don’t miss your opportunity to make it yours!

Open Houses

Listing Details MLS# 7068862

General Property Information

Assoc Mgmt Co. Phone #
612-234-6464
Association Fee Frequency
Monthly
Association Mgmt Co. Name
HOA Living MN
Common Wall
Yes
Lot Measurement
Acres
Manufactured Home?
No
Multiple PIDs?
No
New Development
No
Number of Fireplaces
Yes
Waterfront Present
No
Year Built
2008
Yearly/Seasonal
Yearly
Zoning
Residential-Single Family
Bath Full
2
Bath Half
Yes
Main Floor Total SqFt
805
Above Grd Total SqFt
1609
Below Grd Total SqFt
360
Total SqFt
1969
Total Finished Sqft
1909.00
FireplaceYN
Yes
Style
(TH) Quad/4 Corners
Foundation Size
360
Association Fee
375
Garage Stalls
2
Lot Dimensions
71x21
Acres
0.03
Assessment Pending
Unknown
Bath Three Quarters
0
Bath Quarter
0

Property Features

Accessible: None Air Conditioning: Central Air Amenities Shared: In-Ground Sprinkler System; Lobby; Trail(s); Other Amenities Unit: Deck; Hardwood Floors; Kitchen Window; Primary Bedroom Walk-In Closet; Vaulted Ceiling(s); Walk-In Closet Appliances: Dishwasher; Disposal; Dryer; Microwave; Refrigerator; Washer Approved Financing: FHA; VA Association Fee Includes: Hazard Insurance; Lawn Care; Outside Maintenance; Professional Mgmt; Recreation Facility; Sanitation; Shared Amenities; Snow Removal Assumable Loan: Yes w/ Qualifying Basement: Drain Tiled; Sump Pump Bath Description: Double Sink; Main Floor 1/2 Bath; Upper Level Full Bath; Private Primary; Walk-In Shower Stall Construction Materials: Concrete Construction Status: Previously Owned Dining Room Description: Informal Dining Room; Living/Dining Room Existing Financing: FHA Exterior: Brick/Stone; Vinyl Family Room Characteristics: Family Room; Lower Level Fireplace Characteristics: Gas Burning; Living Room Foundation: Poured Concrete Fuel: Natural Gas Heating: Forced Air Internet Options: Cable; DSL; Satellite Laundry: In Unit; Laundry Room; Main Level Lock Box Type: Supra Parking Characteristics: Garage Door Opener; Insulated Garage; Tuckunder Garage; Other Pool Description: Below Ground; Shared Road Frontage: Paved Streets; Sidewalks Road Responsibility: Association Maintained Road; Public Maintained Road Roof: Age Over 8 Years Sellers Terms: Adj. Rate/Gr Payment; Assumable; Cash; Conventional; FHA; MHFA/WHEDA; Special Funding; VA; Other Sewer: City Sewer - In Street Shared Rooms: Amusement/Party Room; Club House; Community Room; Exercise Room Special Search: 3 BR on One Level; Main Floor Laundry; Primary Bdr Suite Stories: Two Townhouse Characteristics: Multi-Level Water: City Water - In Street

Contract Information

Contingency
None
Original List Price
309900
ListPrice
309900
Owner is an Agent?
No
Auction?
No

Location Tax and Other Information

House Number
15194
Street Name
Farnham
Street Suffix
Avenue
Street Direction Suffix
N
Postal City
Hugo
County
Washington
State
MN
Zip Code
55038
Complex/Dev/Subdivision
Waters Edge

Assessments

Tax With Assessments
3228
Assessment Balance
0

Building Information

Finished SqFt Above Ground
1609
Finished SqFt Below Ground
300

More Information

Lease Details

Land Leased
Not Applicable

Miscellaneous Information

Homestead
Yes

Ownership

Fractional Ownership
No

Public Survey Info

Range#
21
Section#
18
Township#
31

Office/Member Info

Association
SPAAR

Location, Tax and Other Information

AssocFeeYN
Yes
Legal Description
SUBDIVISIONNAME WATERS EDGE SOUTH FOURTH ADD LOT 61 BLOCK 1 SUBDIVISIONCD 02263 (CIC #258 33RD SUPL CREATED 4/9/2009 REC'D PLAT 02540)
Listing City
Hugo
Map Page
67
Municipality
Hugo
School District
White Bear Lake
School District Phone
651-407-7500
Zip Plus 4
6306
Property ID Number
1803121440179
Tax Year
2026
Tax Amount
3228
In Foreclosure?
No
Potential Short Sale?
No
Lender Owned?
No

Directions & Remarks

Public Remarks
Welcome to this beautifully updated townhome. Featuring 3 bedrooms, 3 bathrooms, and a 2-car garage, this home blends comfort and style. The main level showcases rich hardwood floors, a cozy gas fireplace and an open-concept layout perfect for everyday living and entertaining. This dream kitchen includes stainless steel appliances and granite countertops. Upstairs, you’ll find a luxurious primary suite complete with a custom walk-in closet and an updated custom bathroom with a large walk-in shower, with over head rain shower, granite counter and dual sinks. Laundry room includes custom cabinetry, storage, front-loading washer and dryer. Garage includes plenty of shelving for storage, and the electrical is already set up for an electric vehicle charger. Enjoy outdoor living on your private patio, just off the kitchen. This home is part of the Waters Edge association, and access to fantastic amenities. Including a clubhouse, party room, fitness center, large in-ground pool, kiddie pool, playground and miles of walking paths. This home truly has it all—modern upgrades, ample space, and access to fantastic community features. Don’t miss your opportunity to make it yours!
Directions
35E to County Rd 14 East to Oneka Pkw North to Farnham Ave left to home on the right. 2nd unit in

Accessible

None
Yes

Air Conditioning

Central Air
Yes

Amenities Shared

In-Ground Sprinkler System
Yes
Lobby
Yes
Trail(s)
Yes
Other
Yes

Amenities Unit

Deck
Yes
Hardwood Floors
Yes
Kitchen Window
Yes
Primary Bedroom Walk-In Closet
Yes
Vaulted Ceiling(s)
Yes
Walk-In Closet
Yes

Appliances

Dishwasher
Yes
Disposal
Yes
Dryer
Yes
Microwave
Yes
Refrigerator
Yes
Washer
Yes

Approved Financing

FHA
Yes
VA
Yes

Association Fee Includes

Hazard Insurance
Yes
Lawn Care
Yes
Outside Maintenance
Yes
Professional Mgmt
Yes
Recreation Facility
Yes
Sanitation
Yes
Shared Amenities
Yes
Snow Removal
Yes

Assumable Loan

Yes w/ Qualifying
Yes

Basement

Drain Tiled
Yes
Sump Pump
Yes

Bath Description

Double Sink
Yes
Main Floor 1/2 Bath
Yes
Upper Level Full Bath
Yes
Private Primary
Yes
Walk-In Shower Stall
Yes

Construction Materials

Concrete
Yes

Construction Status

Previously Owned
Yes

Dining Room Description

Informal Dining Room
Yes
Living/Dining Room
Yes

Existing Financing

FHA
Yes

Exterior

Brick/Stone
Yes
Vinyl
Yes

Family Room Characteristics

Family Room
Yes
Lower Level
Yes

Fireplace Characteristics

Gas Burning
Yes
Living Room
Yes

Foundation

Poured Concrete
Yes

Fuel

Natural Gas
Yes

Heating

Forced Air
Yes

Insurance Fee

Insurance Fee
0

Internet Options

Cable
Yes
DSL
Yes
Satellite
Yes

Laundry

In Unit
Yes
Laundry Room
Yes
Main Level
Yes

Lock Box Type

Supra
Yes

Parking Characteristics

Garage Door Opener
Yes
Insulated Garage
Yes
Tuckunder Garage
Yes
Other
Yes

Patio, Porch and Deck Features

Covered
Yes
Deck
Yes

Pool Description

Below Ground
Yes
Shared
Yes

Restriction/Covenants

Mandatory Owners Assoc
Yes
Pets - Cats Allowed
Yes
Pets - Dogs Allowed
Yes

Road Frontage

Paved Streets
Yes
Sidewalks
Yes

Road Responsibility

Association Maintained Road
Yes
Public Maintained Road
Yes

Roof

Age Over 8 Years
Yes

Sellers Terms

Adj. Rate/Gr Payment
Yes
Assumable
Yes
Cash
Yes
Conventional
Yes
FHA
Yes
MHFA/WHEDA
Yes
Other
Yes
Special Funding
Yes
VA
Yes

Sewer

City Sewer - In Street
Yes

Shared Rooms

Amusement/Party Room
Yes
Club House
Yes
Community Room
Yes
Exercise Room
Yes

Special Search

3 BR on One Level
Yes
Main Floor Laundry
Yes
Primary Bdr Suite
Yes

Stories

Two
Yes

Townhouse Characteristics

Multi-Level
Yes

Water

City Water - In Street
Yes
Listing Office: Coldwell Banker Realty
IDX
Last Updated: May - 06 - 2026
The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity SM Program of the Regional Multiple Listing Service of Minnesota, Inc. The information provided is deemed reliable but not guaranteed. Properties subject to prior sale, change or withdrawal. ©2024 Regional Multiple Listing Service of Minnesota, Inc All rights reserved.