Find Your Dream Home: Search 10,000+ Homes for Sale

15162 Farnham Avenue N, Hugo, MN 55038

New Listing

$310,000

Property Type: Residential Bedrooms: 4 Baths: 3 Square Footage: 2,445 Lot Size (sq. ft.): 2,178 Status: Active

Current Price: $310,000 List Date: 6/04/2026 Last Modified: 6/08/2026

Overview

Description

This end-unit townhome stands out with rare privacy, abundant natural light, and a setting that faces peaceful nature views—something few homes in the neighborhood offer. The main level is built for entertaining, featuring an open layout with upgraded flooring, a huge kitchen with pantry, and generously sized living spaces. A gas fireplace with stone surround adds a high-end focal point, while the kitchen flows seamlessly to a private deck—perfect for relaxing or hosting. A dedicated home office adds flexibility for work or daily life. Upstairs, you’ll find three bedrooms, including a spacious primary suite with a large walk-in closet and a beautifully upgraded bathroom featuring a double vanity, ceramic tile, and a walk-in shower with a custom glass door. Just two blocks away, you’ll find one of the best community centers in the north metro, featuring a private pool, playground, splash pad, basketball court, clubhouse, and fitness center — bringing standout amenities right i ... (Read more)

Listing Details MLS# 7054129

General Property Information

Assoc Mgmt Co. Phone #: 612-234-6464
Association Fee Frequency: Monthly
Association Mgmt Co. Name: HOA Living
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: Yes
Bath Three Quarters: Yes
Bath Half: Yes
Main Floor Total SqFt: 779
Above Grd Total SqFt: 1612
Below Grd Total SqFt: 833
Total SqFt: 2445
Total Finished Sqft: 1914.00
FireplaceYN: Yes
Style: (TH) Side x Side
Foundation Size: 833
Association Fee: 375
Garage Stalls: 2
Lot Dimensions: 71x31
Acres: 0.05
Assessment Pending: Unknown
Bath Quarter: 0

Property Features

Accessible: None Air Conditioning: Central Air Amenities Shared: In-Ground Sprinkler System Amenities Unit: Ceiling Fan(s); Deck; French Doors; In-Ground Sprinkler; Kitchen Window; Natural Woodwork; Primary Bedroom Walk-In Closet; Tile Floors; Vaulted Ceiling(s); Walk-In Closet; Washer/Dryer Hookup Appliances: Dishwasher; Dryer; Microwave; Range; Refrigerator; Washer Association Fee Includes: Hazard Insurance; Lawn Care; Outside Maintenance; Professional Mgmt; Recreation Facility; Shared Amenities; Snow Removal Basement: Full Bath Description: Double Sink; Main Floor 1/2 Bath; Upper Level Full Bath; 3/4 Primary; Private Primary; Bathroom Ensuite; Walk-In Shower Stall Construction Status: Previously Owned Exterior: Brick/Stone; Vinyl Fencing: None Fireplace Characteristics: Gas Burning; Living Room Foundation: Other Fuel: Natural Gas Heating: Forced Air Laundry: Main Level Lot Description: Tree Coverage - Light Parking Characteristics: Finished Garage; Storage; Tuckunder Garage Pool Description: Below Ground; Heated; Shared Road Frontage: Paved Streets; Sidewalks Roof: Age Over 8 Years Sellers Terms: Cash; Conventional; FHA; VA Sewer: City Sewer/Connected Shared Rooms: Amusement/Party Room; Club House; Exercise Room; Play Area Special Search: 3 BR on One Level; Main Floor Laundry Stories: Two Townhouse Characteristics: End Unit Water: City Water/Connected

Contract Information

Contingency: Inspection
Original List Price: 310000
ListPrice: 310000
Owner is an Agent?: No
Auction?: No

Location Tax and Other Information

House Number: 15162
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 South Fourth Add

Assessments

Tax With Assessments: 3370
Assessment Balance: 0

Building Information

Finished SqFt Above Ground: 1612
Finished SqFt Below Ground: 302

More Information

Lease Details

Land Leased: Not Applicable

Miscellaneous Information

DP Resource: Yes
Homestead: Yes

Ownership

Fractional Ownership: No

Parking Characteristics

Garage Dimensions: 20x20
Garage Square Feet: 400
Finished Garage: Yes
Storage: Yes
Tuckunder Garage: Yes

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 63 BLOCK 1 SUBDIVISIONCD 02263 (CIC #258 26TH SUPL CREATED 02/26/2008 REC'D PLAT #02466)
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: 1803121440181
Tax Year: 2026
Tax Amount: 3370
In Foreclosure?: No
Potential Short Sale?: No
Lender Owned?: No

Directions & Remarks

Public Remarks: This end-unit townhome stands out with rare privacy, abundant natural light, and a setting that faces peaceful nature views—something few homes in the neighborhood offer. The main level is built for entertaining, featuring an open layout with upgraded flooring, a huge kitchen with pantry, and generously sized living spaces. A gas fireplace with stone surround adds a high-end focal point, while the kitchen flows seamlessly to a private deck—perfect for relaxing or hosting. A dedicated home office adds flexibility for work or daily life. Upstairs, you’ll find three bedrooms, including a spacious primary suite with a large walk-in closet and a beautifully upgraded bathroom featuring a double vanity, ceramic tile, and a walk-in shower with a custom glass door. Just two blocks away, you’ll find one of the best community centers in the north metro, featuring a private pool, playground, splash pad, basketball court, clubhouse, and fitness center — bringing standout amenities right into your everyday routine.
Directions: Hwy 61 N, W onto Frenchman Rd, N onto Oneka Pkwy N, W onto 149th St N, NW onto Farnham Ave N.

Accessible

None: Yes

Air Conditioning

Central Air: Yes

Amenities Shared

In-Ground Sprinkler System: Yes

Amenities Unit

Ceiling Fan(s): Yes
Deck: Yes
French Doors: Yes
In-Ground Sprinkler: Yes
Kitchen Window: Yes
Natural Woodwork: Yes
Primary Bedroom Walk-In Closet: Yes
Tile Floors: Yes
Vaulted Ceiling(s): Yes
Walk-In Closet: Yes
Washer/Dryer Hookup: Yes

Appliances

Dishwasher: Yes
Dryer: Yes
Microwave: Yes
Range: Yes
Refrigerator: Yes
Washer: Yes

Association Fee Includes

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

Basement

Full: Yes

Bath Description

Double Sink: Yes
Main Floor 1/2 Bath: Yes
Upper Level Full Bath: Yes
3/4 Primary: Yes
Private Primary: Yes
Bathroom Ensuite: Yes
Walk-In Shower Stall: Yes

Construction Status

Previously Owned: Yes

Exterior

Brick/Stone: Yes
Vinyl: Yes

Fencing

None: Yes

Fireplace Characteristics

Gas Burning: Yes
Living Room: Yes

Foundation

Other: Yes

Fuel

Natural Gas: Yes

Heating

Forced Air: Yes

Insurance Fee

Insurance Fee: 0

Laundry

Main Level: Yes

Lot Description

Tree Coverage - Light: Yes

Patio, Porch and Deck Features

Deck: Yes

Pool Description

Below Ground: Yes
Heated: Yes
Shared: Yes

Restriction/Covenants

Mandatory Owners Assoc: Yes

Road Frontage

Paved Streets: Yes
Sidewalks: Yes

Roof

Age Over 8 Years: Yes

Sellers Terms

Cash: Yes
Conventional: Yes
FHA: Yes
VA: Yes

Sewer

City Sewer/Connected: Yes

Shared Rooms

Amusement/Party Room: Yes
Club House: Yes
Exercise Room: Yes
Play Area: Yes

Special Search

3 BR on One Level: Yes
Main Floor Laundry: Yes

Stories

Two: Yes

Townhouse Characteristics

End Unit: Yes

Water

City Water/Connected: Yes

Room Information

Room Name	Dimensions	Level
Deck	9.4x7.8	Main
Dining Room	16.7x15.10	Main
First (1st) Bedroom	20.2x12	Upper
Fourth (4th) Bedroom	17.5x12.5	Lower
Foyer	10.9x7.5	Main
Laundry	6.7x5.3	Main
Living Room	12.5x10.9	Main
Second (2nd) Bedroom	12.2x10.1	Upper
Third (3rd) Bedroom	9.11x9.8	Upper

Listing Office: Keller Williams Classic Realty

Last Updated: June - 08 - 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.