$300,000
PENDING

5130 Farnham Dr N Hugo, MN 55038

Estimated payment $2,273/month

Total Views 34,712
3 Beds
2.5 Baths
1,596 Sq Ft
$188 Price per Sq Ft

Highlights

  • Heated In Ground Pool
  • Living Room
  • Forced Air Heating and Cooling System
  • 2 Car Attached Garage
  • Entrance Foyer
  • Dining Room

About This Home

Welcome to this spacious and updated 3-bedroom, 2.5-bathroom end-unit townhouse nestled in a quiet, sought-after Water’s Edge community in Hugo. This home features new carpet throughout, fresh paint in the upper-level living areas, and newer kitchen appliances, making it move-in ready!
Enjoy the outdoors with a private deck and patio that overlook serene woods—perfect for relaxing or entertaining. Inside, the open-concept layout offers plenty of natural light and comfortable living space.
Community amenities include a clubhouse with a heated pool, fitness center, and conference room, ideal for both leisure and work-from-home needs.
Conveniently located near restaurants, shopping, and major highways, this home offers the perfect blend of tranquility and accessibility.
Don’t miss your chance to own this beautifully maintained home in a prime location!

Listing Agent

Sarah Hartstein

Coldwell Banker Realty Brokerage Phone: 612-245-1773 Listed on: 07/24/2025

Coldwell Banker Realty

Co-Listing Agent

Jason Neuhaus

Coldwell Banker Realty Brokerage Phone: 612-245-1773

Townhouse Details

Home Type

  • Townhome

Est. Annual Taxes

  • $3,216

Year Built

  • Built in 2005

Lot Details

  • 2,614 Sq Ft Lot
  • Lot Dimensions are 36x67

HOA Fees

  • $374 Monthly HOA Fees

Parking

  • 2 Car Attached Garage
  • Insulated Garage
  • Garage Door Opener

Home Design

  • Split Level Home

Interior Spaces

  • Stone Fireplace
  • Entrance Foyer
  • Family Room
  • Living Room
  • Dining Room

Kitchen

  • Cooktop
  • Microwave
  • Dishwasher

Bedrooms and Bathrooms

  • 3 Bedrooms

Laundry

  • Dryer
  • Washer

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Sump Pump
  • Natural lighting in basement

Additional Features

  • Heated In Ground Pool
  • Forced Air Heating and Cooling System

Listing and Financial Details

  • Assessor Parcel Number 1803121140079

Community Details

Overview

  • Association fees include hazard insurance, lawn care, ground maintenance, professional mgmt, trash, shared amenities, snow removal
  • Gaughan Companies Association, Phone Number (651) 407-7047

Recreation

  • Community Pool

Townhouse Details

Home Type

Townhome

Est. Annual Taxes

$3,216

Year Built

Built in 2005

Lot Details

0

HOA Fees

$374 per month

Parking

2

Listing Details

  • Type: Residential
  • Property Subtype 1: Townhouse Side x Side
  • Cooling System: Central Air
  • Garage Spaces: 2
  • Accessibility Features: None
  • Fireplaces: 1
  • Water Source: City Water/Connected
  • Fee Frequency: Monthly
  • Year Built: 2005
  • Above Grade Finished Sq Ft: 1173
  • Unit Levels: Three Level Split
  • New Construction: No
  • FractionalOwnershipYN: No
  • Rental License?: No
  • Attribution Contact: 612-245-1773
  • Attribution Contact: 612-245-1773
  • Special Features: None
  • Property Sub Type: Townhouses

Interior Features

  • Basement: Daylight/Lookout Windows, Finished, Full, Sump Pump, Walkout
  • Appliances: Cooktop, Dishwasher, Dryer, Microwave, Refrigerator, Washer
  • Fireplace Features: Gas, Stone
  • Living Area: 1596
  • Fireplace: Yes
  • Below Grade Finished Sq Ft: 423
  • Basement YN: Yes
  • Dining Room Type: Living Room, Dining Room, Kitchen, Bedroom 1, Bedroom 2, Bedroom 3, Family Room, Foyer
  • Shared Rooms: Amusement/Party Room,Club House,Community Room,Exercise Room,Other

Beds/Baths

  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Total Bedrooms: 3

Exterior Features

  • Roof: Age 8 Years or Less, Asphalt
  • PoolFeatures: Below Ground, Heated, Outdoor Pool, Shared
  • PatioPorchType: Deck,Patio

Garage/Parking

  • Parking Features: Attached Garage, Asphalt, Garage Door Opener, Insulated Garage
  • Garage Square Feet: 418

Utilities

  • Heating: Forced Air
  • Sewer: City Sewer/Connected
  • Fuel: Natural Gas

Condo/Co-op/Association

  • HOA Fee Includes: Hazard Insurance, Lawn Care, Maintenance Grounds, Professional Mgmt, Trash, Shared Amenities, Snow Removal
  • Phone: 651-407-7047
  • Association Fee: 374
  • Association: Yes
  • Amenities Unit: Ceiling Fan(s),Deck,Primary Bedroom Walk-In Closet,In-Ground Sprinkler,Washer/Dryer Hookup,Walk-In Closet

Association/Amenities

  • HOA Management Co: Gaughan Companies

Schools

  • Junior High Dist: White Bear Lake
  • SchoolDistrictNumber: 624
  • SchoolDistrictPhone: 651-407-7500

Lot Info

  • PropertyAttachedYN: Yes
  • Lot Size: 36x67
  • Lot Size Sq Ft: 2613.6
  • Land Lease: No
  • Additional Parcels: No
  • Zoning Description: Residential-Multi-Family
  • AssessmentPending: No
  • Yearly/Seasonal: Yearly

Building Info

  • Construction Materials: Brick/Stone, Vinyl Siding

Tax Info

  • Tax Year: 2025
  • Assessor Parcel Number: 1803121140079
  • Tax Annual Amount: 3216
  • TaxWithAssessments: 3216.0000

Map

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2024 $3,216 $287,000 $60,000 $227,000
2023 $3,216 $300,900 $78,000 $222,900
2022 $2,700 $272,700 $64,900 $207,800
2021 $2,594 $228,800 $54,000 $174,800
2020 $2,940 $219,700 $54,000 $165,700
2019 $2,458 $222,200 $54,000 $168,200
2018 $2,076 $204,300 $49,600 $154,700
2017 $1,952 $176,500 $26,000 $150,500
2016 $1,740 $164,000 $26,000 $138,000
2015 $1,844 $145,800 $21,700 $124,100
2013 -- $104,700 $14,800 $89,900
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/19/2025 08/19/25 Pending -- -- --
07/24/2025 07/24/25 For Sale $300,000 -- $188 / Sq Ft
Source: NorthstarMLS

Purchase History

Date Type Sale Price Title Company
Warranty Deed $240,000 Edina Realty Title Inc
Quit Claim Deed -- First American Title Isn Co
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $199,750 New Conventional
Previous Owner $140,350 New Conventional
Previous Owner $159,776 New Conventional
Previous Owner $39,944 Stand Alone Second
Source: Public Records

About the Listing Agent

Sarah Hartstein

Coldwell Banker Realty

(612) 445-4535

Section Image

With over 15 years of working in customer service, Sarah Hartstein has made a lifelong career out of serving others’ needs. She was raised in the Twin Cities but currently resides in western Wisconsin, giving her extensive knowledge of areas over a broad range. Her allure to real estate derives from her desires to see others reach their life and personal goals within an environment they revel in.

Sarah received Bachelor's degrees in Business Administration and Human Resource Management

Sarah's Other Listings

  • 912 216th Ave, Somerset, WI 54025

    $750,000

    • 3 Beds
    • 2 Baths
    • 1,705 Sq Ft
    • 912 216th Ave
    • Somerset, WI

    Welcome to your dream home nestled in nature! This stunning 3-bedroom, 2-bath Wittstock custom-built home offers the perfect blend of modern comfort and serene privacy. Situated on 5.56 acres of lush, wooded land, the property provides a peaceful escape while still being close to city conveniences.Step inside to an open-concept layout featuring vaulted ceilings, a cozy living room fireplace,

    Sarah Hartstein Coldwell Banker Realty

    Section Image
  • 805 Raymond St, Somerset, WI 54025

    $210,000 Sold May 30, 2025

    • 2 Beds
    • 2 Baths
    • 1,120 Sq Ft
    • 805 Raymond St
    • Somerset, WI

    Welcome to this updated accessible one level living condo. Featuring 2 bedrooms, and 2 bathrooms on opposite sides of the home, this condo offers new paint, new LVP flooring, and SS appliances! Just minutes from downtown Somerset and a quick commute over the border to Stillwater, this location has everything close by! Hurry and schedule your showing!

    Sarah Hartstein Coldwell Banker Realty

  • 1031 Sommers St N, Hudson, WI 54016

    $347,000 Sold Mar 13, 2025

    • 5 Beds
    • 2 Baths
    • 2,007 Sq Ft
    • 1031 Sommers St N
    • Hudson, WI

    Opportunity awaits in this 5 bedroom 2 bath home in the heart of North Hudson. With new carpet and fresh paint throughout, this open concept is the perfect house for anyone! This home has plenty of room inside and out for a growing family. If you're looking for an investment or roommate situation, this house has a great set up with 3 bedrooms up and 2 bedrooms down with a second kitchen and

    Sarah Hartstein Coldwell Banker Realty

  • 1262 Legacy Pkwy, New Richmond, WI 54017

    $383,000 Sold Mar 18, 2025

    • 3 Beds
    • 2 Baths
    • 1,423 Sq Ft
    • 1262 Legacy Pkwy
    • New Richmond, WI

    Welcome to your dream home! This stunning 3-bed, 2-bath home features an open concept design, perfect for modern living. As you enter, you'll appreciate the large foyer with ample space for everyone to enter. Step into the inviting living room, complete with a cozy fireplace, perfect for curling up with a book or watching your favorite shows. The spacious kitchen includes stainless steel

    Sarah Hartstein Coldwell Banker Realty

  • 1722 Windflower St, River Falls, WI 54022

    $367,000 Sold Jul 18, 2025

    • 4 Beds
    • 2 Baths
    • 1,799 Sq Ft
    • 1722 Windflower St
    • River Falls, WI

    Get ready to fall in love with this former model home in River Falls! Perfectly situated near the high school and bypass, this place has it all. With 4 bedrooms (3 on the same level) and 2 bathrooms, including a master bath with walk-through access, you'll be living in comfort. The kitchen is a dream with maple cabinets, stainless steel appliances, new LVP flooring, and a center island. The

    Sarah Hartstein Coldwell Banker Realty

  • 1596 Mallard Ave, Baldwin, WI 54002

    $414,500 Sold Oct 11, 2024

    • 4 Beds
    • 3.5 Baths
    • 2,618 Sq Ft
    • 1596 Mallard Ave
    • Baldwin, WI

    Welcome to your personal oasis in the heart of Baldwin! Beautifully landscaped with mature trees, enjoy peace and tranquility as you relax under the pergola on your private patio that backs up to a 3-acre city park. As you enter the home you’ll love the spacious rooms, large open kitchen and lots of natural light. Want more sun? Make your way into the huge sunroom-you’ll never want to leave! This

    Sarah Hartstein Coldwell Banker Realty

Source: NorthstarMLS

MLS Number: 6749777

NorthstarMLS

APN: 18-031-21-14-0079