15751 Farnham Avenue N
Hugo, MN 55038
- 3 beds
- 2 baths
- 1,818 sqft
- 3,963 sqft lot
- $228 per sqft
- 2005 build
- – on site
More homes
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!
Last checked:
As a licensed real estate brokerage, Estately has access to the same database professional Realtors use: the Multiple Listing Service (or MLS). That means we can display all the properties listed by other member brokerages of the local Association of Realtors—unless the seller has requested that the listing not be published or marketed online.
The MLS is widely considered to be the most authoritative, up-to-date, accurate, and complete source of real estate for-sale in the USA.
Estately updates this data as quickly as possible and shares as much information with our users as allowed by local rules. Estately can also email you updates when new homes come on the market that match your search, change price, or go under contract.
Checking…
•
Last updated Feb 27, 2025
•
MLS# 6652233 —
The Building
-
Year Built:2005
-
New Construction:false
-
Age Of Property:20
-
Construction Materials:Brick/Stone, Vinyl Siding
-
Construction Materials Desc:Frame
-
Roof:Age 8 Years or Less, Asphalt, Pitched
-
Accessibility Features:Grab Bars In Bathroom, No Stairs External, No Stairs Internal
-
Levels:One
-
Main Level Finished Area:1818.0000
-
Basement:None
-
Basement:false
-
Foundation Area:1818
-
Manufactured Home:No
-
Building Area Total:1818
-
Above Grade Finished Area:1818
Interior
-
Dining Room Description:Breakfast Area,Eat In Kitchen,Living/Dining Room
-
Fireplace:true
-
Fireplaces Total:1
-
Fireplace Features:Gas, Living Room
-
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
Room Dimensions
-
Living Area:1818
Location
-
Directions:35E to Cty Rd 14 - East to Oneka Pkwy N, Left to Falcon, Right to 157th, RIGHT to Farnham
-
Latitude:45.1781241889
-
Longitude:-93.0007977805
The Property
-
Parcel Number:1803121110054
-
Zoning Description:Residential-Single Family
-
Property Type:Residential
-
Property Subtype:Townhouse Detached
-
Property Attached:false
-
Additional Parcels:false
-
Lot Size Area:0.09
-
Lot Size Dimensions:3,960
-
Lot Size SqFt:3963.96
-
Lot Size Units:Acres
-
Road Frontage Type:City Street, Curbs, Paved Streets, Sidewalks, Street Lights
-
Road Responsibility:Public Maintained Road
-
Fencing:None
-
Water Source:City Water/Connected
-
Land Lease:false
Listing Agent
- Contact info:
- Agent phone:
- (651) 214-8810
- Office phone:
- (877) 366-2213
Taxes
-
Tax Year:2024
-
Tax Annual Amount:4573
-
Tax With Assessments:4576.0000
Beds
-
Bedrooms Total:3
Baths
-
Total Baths:2
-
Bath Description:Double Sink,Full Primary,Private Primary,Main Floor Full Bath,Separate Tub & Shower
-
Full Baths:2
Heating & Cooling
-
Heating:Forced Air
-
Cooling:Central Air
Utilities
-
Electric:Circuit Breakers, 100 Amp Service
-
Sewer:City Sewer/Connected
Appliances
-
Appliances:Dishwasher, Disposal, Dryer, Gas Water Heater, Microwave, Range, Refrigerator, Washer, Water Softener Owned
Schools
-
High School District:White Bear Lake
The Community
-
Pool Features:Shared
-
Association:true
-
Association Name:HOALiving Minnesota
-
Association Fee:352
-
Association Fee Includes:Maintenance Structure, Hazard Insurance, Lawn Care, Maintenance Grounds, Professional Mgmt, Recreation Facility, Trash, Shared Amenities, Snow Removal
-
Association Fee Frequency:Monthly
-
Assessment Pending:Yes
Parking
-
Parking Features:Attached Garage, Asphalt, Garage Door Opener, Storage
-
Garage Spaces:2
-
Garage SqFt:480
Walk Score®
Provided by WalkScore® Inc.
Walk Score is the most well-known measure of walkability for any address. It is based on the distance to a variety of nearby services and pedestrian friendliness. Walk Scores range from 0 (Car-Dependent) to 100 (Walker’s Paradise).
Bike Score®
Provided by WalkScore® Inc.
Bike Score evaluates a location's bikeability. It is calculated by measuring bike infrastructure, hills, destinations and road connectivity, and the number of bike commuters. Bike Scores range from 0 (Somewhat Bikeable) to 100 (Biker’s Paradise).
Soundscore™
Provided by HowLoud
Soundscore is an overall score that accounts for traffic, airport activity, and local sources. A Soundscore rating is a number between 50 (very loud) and 100 (very quiet).
Air Pollution Index
Provided by ClearlyEnergy
The air pollution index is calculated by county or urban area using the past three years data. The index ranks the county or urban area on a scale of 0 (best) - 100 (worst) across the United Sates.
Sale history
Date | Event | Source | Price | % Change |
---|---|---|---|---|
2/26/25
Feb 26, 2025
|
Sold | NORTHSTAR | $415,000 | |
2/18/25
Feb 18, 2025
|
Pending | NORTHSTAR | $415,000 | |
1/29/25
Jan 29, 2025
|
Listed / Active | NORTHSTAR | $415,000 |