$255,000
SOLD AUG 8, 2025

15040 Farnham Ave N Hugo, MN 55038

3 Beds
1.5 Baths
1,856 Sq Ft
$355/mo HOA Fee

Recently Sold

$137 Per Sq Ft

2% Below List Price

17 Days on Market

Highlights

  • In Ground Pool
  • Stainless Steel Appliances
  • 2 Car Attached Garage
  • Deck
  • The kitchen features windows
  • Walk-In Closet

About This Home

As of August 2025

Welcome home! This updated townhouse features LVP flooring, fresh paint, stainless steel appliances, and a spacious primary bedroom with a walk-in closet. Enjoy your morning coffee in the summer out on the balcony, or on cooler nights inside next to the fireplace. Beyond the home itself, you'll enjoy a vibrant community offering an exercise room, outdoor swimming pool, park, sport court, and a community room with entertainment space. Located close to restaurants, trails, and outdoor recreation, this home blends modern comfort with convenient, active living.

Last Agent to Sell the Property

Joshua Leonhardt

Coldwell Banker Realty Brokerage Phone: 651-769-5329 Listed on: 06/24/2025

Coldwell Banker Realty

Co-Listed By

Mercedies Gilson

Coldwell Banker Realty Brokerage Phone: 651-769-5329

Last Buyer's Agent

Sara Ofstead

LPT Realty, LLC

LPT Realty, LLC

Townhouse Details

Home Type

  • Townhome

Est. Annual Taxes

  • $3,227

Year Built

  • Built in 2006

Lot Details

  • 1,481 Sq Ft Lot
  • Lot Dimensions are 21x71

HOA Fees

  • $355 Monthly HOA Fees

Parking

  • 2 Car Attached Garage
  • Tuck Under Garage
  • Garage Door Opener

Home Design

  • Split Level Home

Interior Spaces

  • Entrance Foyer
  • Living Room with Fireplace
  • Dining Room

Kitchen

  • Range
  • Microwave
  • Dishwasher
  • Stainless Steel Appliances
  • The kitchen features windows

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Walk-In Closet

Laundry

  • Dryer
  • Washer

Finished Basement

  • Sump Pump
  • Drain

Outdoor Features

  • In Ground Pool
  • Deck

Utilities

  • Forced Air Heating and Cooling System

Listing and Financial Details

  • Assessor Parcel Number 1803121440012

Community Details

Overview

  • Association fees include hazard insurance, lawn care, ground maintenance, professional mgmt, recreation facility, trash, shared amenities, snow removal
  • Hoaliving Minnesota Association, Phone Number (612) 234-6464
  • Waters Edge South Subdivision

Recreation

  • Community Pool

Townhouse Details

Home Type

Townhome

Est. Annual Taxes

$3,227

Year Built

Built in 2006

Lot Details

0

HOA Fees

$355 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: 2006
  • Above Grade Finished Sq Ft: 1496
  • Unit Levels: Three Level Split
  • New Construction: No
  • FractionalOwnershipYN: No
  • Rental License?: No
  • Attribution Contact: 651-769-5329
  • Attribution Contact: 651-769-5329
  • Special Features: VirtualTour
  • Property Sub Type: Townhouses

Interior Features

  • Basement: Drain Tiled, Finished, Sump Pump
  • Appliances: Dishwasher, Dryer, Microwave, Range, Refrigerator, Stainless Steel Appliances, Washer
  • Fireplace Features: Living Room
  • Living Area: 1856
  • Fireplace: Yes
  • Below Grade Finished Sq Ft: 360
  • Basement YN: Yes
  • Dining Room Type: Living Room, Kitchen, Bathroom, Laundry, Bedroom 1, Walk In Closet, Bedroom 2, Bedroom 3, Foyer
  • Shared Rooms: Amusement/Party Room,Community Room,Exercise Room

Beds/Baths

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

Exterior Features

  • PoolFeatures: Below Ground, Outdoor Pool, Shared
  • Fencing: None
  • PatioPorchType: Deck

Garage/Parking

  • Parking Features: Attached Garage, Asphalt, Garage Door Opener, Tuckunder Garage
  • Garage Square Feet: 400

Utilities

  • Heating: Forced Air, Fireplace(s)
  • Sewer: City Sewer/Connected
  • Electric: Circuit Breakers
  • Fuel: Natural Gas

Condo/Co-op/Association

  • HOA Fee Includes: Hazard Insurance, Lawn Care, Maintenance Grounds, Professional Mgmt, Recreation Facility, Trash, Shared Amenities, Snow Removal
  • Phone: 612-234-6464
  • Association Fee: 355
  • Association: Yes
  • Amenities Unit: Balcony,Ceiling Fan(s),Deck,Exercise Room,Kitchen Window,Primary Bedroom Walk-In Closet,In-Ground Sprinkler

Association/Amenities

  • HOA Management Co: HOALiving Minnesota

Schools

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

Lot Info

  • PropertyAttachedYN: Yes
  • Lot Size: 21x71
  • Lot Size Sq Ft: 1481.04
  • 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: 2024
  • Assessor Parcel Number: 1803121440012
  • Tax Annual Amount: 3227
  • TaxWithAssessments: 3230.0000

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Aug 5, 2022
Closed on
Sep 23, 2022
Sold by
Nunez Family Trust Dated May 18 2020
Bought by
Fraser Chelsea and Fraser Derek
Seller's Agent
June Wiener
Cardinal Realty Co.
Buyer's Agent
Joshua Leonhardt
Coldwell Banker Realty
List Price
$255,000
Sold Price
$250,000
Premium/Discount to List
-$5,000
-1.96%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
3.43%
Original Mortgage
$212,500
Outstanding Balance
$203,539
Interest Rate
5.22%
Mortgage Type
New Conventional
Estimated Equity
$72,414

Purchase Details

Listed on
Aug 5, 2022
Closed on
Sep 16, 2022
Sold by
Nunez Family Trust
Bought by
Fraser Chelsea and Fraser Derek
Seller's Agent
June Wiener
Cardinal Realty Co.
Buyer's Agent
Joshua Leonhardt
Coldwell Banker Realty
List Price
$255,000
Sold Price
$250,000
Premium/Discount to List
-$5,000
-1.96%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$212,500
Outstanding Balance
$203,539
Interest Rate
5.22%
Mortgage Type
New Conventional
Estimated Equity
$72,414

Purchase Details

Closed on
May 18, 2020
Sold by
Nunez Sondra C and Nunez Christopher P
Bought by
Nunez Christopher P and Nunez Sondra C

Purchase Details

Closed on
Apr 19, 2019
Sold by
Skaj Nicholas and Skaj Lisa
Bought by
Nunez Sondra C and Nunez Christopher P

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$184,500
Interest Rate
4.3%
Mortgage Type
New Conventional

Purchase Details

Closed on
Mar 24, 2016
Sold by
Davids Real Estate Holdings Llc
Bought by
Skaj Nicholas and Skaj Lisa

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$170,550
Interest Rate
3.65%
Mortgage Type
VA

Purchase Details

Closed on
Jan 22, 2016

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$123,000
Interest Rate
3.81%

Purchase Details

Closed on
Jan 20, 2016
Sold by
The Secretary Of Housing & Urban Develop
Bought by
Davids Real Estate Holdings Llc

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$123,000
Interest Rate
3.81%

Purchase Details

Closed on
Jul 22, 2015
Sold by
Jpmorgan Chase Bank National Association
Bought by
The Secretary Of Housing & Urban Develop

Purchase Details

Closed on
Dec 15, 2006
Sold by
Tanka Laszlo and Krzywon Cathie L
Bought by
Jpmorgan Chase Bank National Association

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$171,671
Interest Rate
6.27%
Mortgage Type
FHA
Source: Public Records

Similar Homes in Hugo, MN

  • 5130 Farnham Dr N, Hugo, MN 55038

    $300,000

    • 3 Beds
    • 2.5 Baths
    • 1,596 Sq Ft
    • 5130 Farnham Dr N
    • Hugo, MN

    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

    Sarah Hartstein Coldwell Banker Realty

    Section Image
  • 5150 Fairpoint Dr N, Hugo, MN 55038

    $285,000

    • 3 Beds
    • 1.5 Baths
    • 1,780 Sq Ft
    • 5150 Fairpoint Dr N
    • Hugo, MN

    Welcome to this beautifully updated 3-bedroom townhome in the heart of Hugo, Offering a perfect space to call home. Large main level for gathering. Enjoy your morning coffee on the deck. Upstairs features large primary bedroom with walk-through bath and walk-in closet, 2nd bedroom and loft. Lots of storage throughout. Furnace has just been cleaned and inspected. Waters Edge association has plenty

    Kim Jackson Keller Williams Premier Realty

    Section Image
  • 15105 Fanning Dr N, Hugo, MN 55038

    $289,900

    • 3 Beds
    • 2.5 Baths
    • 1,831 Sq Ft
    • 15105 Fanning Dr N
    • Hugo, MN

    Welcome to this spacious 3 bedroom, 3 bath townhome offering a bright, open-concept layout designed for comfort and functionality. The main level features a welcoming living room centered around a cozy fireplace, an informal dining area, and a well-appointed eat-in kitchen with rich wooden cabinetry, black appliances for a cohesive look, and ample prep and storage space. Step out from the kitchen

    David Noe Realty ONE Group Choice

    Section Image
  • 5085 149th St N Unit 3, Hugo, MN 55038

    $220,000

    • 2 Beds
    • 1.5 Baths
    • 1,296 Sq Ft
    • 5085 149th St N
    • Unit 3
    • Hugo, MN

    Looking for a low-maintenance town home that feels like home the minute you walk in? You’ve found it in this bright, 2-bedroom, 2-bath gem right in the heart of Hugo! Start your mornings on the private front porch, perfect for coffee, quiet time, or chatting with neighbors. Inside, a bright and open floor plan offers modern functionality and inviting warmth. The spacious living room features a

    Jay Fletch Edina Realty, Inc.

    Section Image
  • 5055 149th St N Unit 2, Hugo, MN 55038

    $239,900

    • 2 Beds
    • 1.5 Baths
    • 1,288 Sq Ft
    • 5055 149th St N
    • Unit 2
    • Hugo, MN

    Welcome to this well-maintained end unit townhome nestled in the vibrant Waters Edge community of Hugo—perfectly situated with uninterrupted views of scenic brush and natural land right outside your front door. Featuring 2 bedrooms, 2 bathrooms, a spacious loft, and thoughtful updates throughout, this home combines comfort, privacy, and convenience. Step inside to find an open-concept main level

    Lars Anderson RE/MAX Results

    Section Image
  • 5062 French Dr N, Hugo, MN 55038

    $300,000

    • 4 Beds
    • 2.5 Baths
    • 1,909 Sq Ft
    • 5062 French Dr N
    • Hugo, MN

    STYLISH FOUR BEDROOM TOWNHOME IN WATERS EDGE! PERFECT PET FRIENDLY COMMUNITY!Don’t miss this immaculate 4-bedroom, 3-bath townhome located in the highly sought-afterWaters Edge community in Hugo. Freshly painted and move-in ready, this home stands out with avery rare 4-bedroom layout — perfect for growing households, remote workers, or those needingextra space.Enjoy peace of

    Deborah Hanuman LPT Realty, LLC

    Section Image
  • 15364 Foster Dr N, Hugo, MN 55038

    $300,000

    • 2 Beds
    • 2.5 Baths
    • 1,597 Sq Ft
    • 15364 Foster Dr N
    • Hugo, MN

    Stunning 2-Bedroom, 3-Bath, End Unit Townhouse. This gorgeous home combines comfort, convenience, andmodern design all in one incredible package. Perfect for first-time buyers, growing families, or anyoneseeking a stylish, low-maintenance lifestyle.Abundant windows and 12' ceilings in living room provide excellent natural light and an open feel to themain level. Finished, walk out

    Charles Moberg Bridge Realty, LLC

    Section Image
  • 4964 Emmit Dr N Unit 3, Hugo, MN 55038

    $219,900

    • 2 Beds
    • 1.5 Baths
    • 923 Sq Ft
    • 4964 Emmit Dr N
    • Unit 3
    • Hugo, MN

    Charming 2-Bed, 2-Bath townhome in a Beautifully landscaped Community. Step into comfort and style in this freshly updated home located in a highly desirable, resort-style complex. This move-in ready home features brand new carpeting, freshly painted throughout, and a bright open layout perfect for modern living. Enjoy all the amenities this beautifully maintained community has to offer-including

    Todd Lewandowski Realty ONE Group Choice

    Section Image
  • 4826 Elm Dr N Unit 7, Hugo, MN 55038

    $200,000

    • 2 Beds
    • 1.5 Baths
    • 923 Sq Ft
    • 4826 Elm Dr N
    • Unit 7
    • Hugo, MN

    Welcome to this well-maintained two-bedroom, two-bathroom townhome nestled in a well-established community with easy access to 35E, just 25 miles from the Twin Cities! This inviting multi-level home offers a smart and functional layout with a tile entryway, closet at the top of the stairs, and a main level featuring living space, dining area, and an open-concept kitchen that walks out to a

    Kristen Wuollet Edina Realty, Inc.

    Section Image

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

Purchase History

Date Type Sale Price Title Company
Deed $250,000 --
Deed $250,000 --
Interfamily Deed Transfer -- None Available
Warranty Deed $265,606 Liberty Title Inc
Warranty Deed $167,000 Liberty Title Inc
Deed $124,000 --
Limited Warranty Deed -- Title Specialists Inc
Warranty Deed -- Attorney
Sheriffs Deed $178,048 None Available
Warranty Deed $174,365 --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $212,500 New Conventional
Closed $212,500 New Conventional
Previous Owner $184,500 New Conventional
Previous Owner $170,550 VA
Previous Owner $123,000 No Value Available
Previous Owner $124,000 Purchase Money Mortgage
Previous Owner $171,671 FHA
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/08/2025 08/08/25 Sold $255,000 -1.9% $137 / Sq Ft
07/14/2025 07/14/25 Pending -- -- --
06/29/2025 06/29/25 For Sale $260,000 +2.0% $140 / Sq Ft
06/27/2025 06/27/25 Off Market $255,000 -- --
06/27/2025 06/27/25 For Sale $260,000 +4.0% $140 / Sq Ft
09/23/2022 09/23/22 Sold $250,000 -2.0% $135 / Sq Ft
09/15/2022 09/15/22 Pending -- -- --
08/23/2022 08/23/22 For Sale $255,000 +2.0% $137 / Sq Ft
08/16/2022 08/16/22 Off Market $250,000 -- --
08/12/2022 08/12/22 Price Changed $255,000 -3.8% $137 / Sq Ft
08/05/2022 08/05/22 For Sale $265,000 -- $143 / Sq Ft
08/05/2022 08/05/22 Pending -- -- --
Source: NorthstarMLS

Tax History Compared to Growth

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,248 $271,800 $50,000 $221,800
2023 $3,248 $286,200 $62,000 $224,200
2022 $2,576 $261,800 $48,100 $213,700
2021 $2,482 $219,700 $40,000 $179,700
2020 $2,536 $211,400 $40,000 $171,400
2019 $2,014 $207,100 $35,000 $172,100
2018 $1,744 $184,000 $30,000 $154,000
2017 $1,648 $166,200 $20,000 $146,200
2016 $1,956 $157,100 $15,000 $142,100
2015 $2,082 $169,600 $20,000 $149,600
2013 -- $113,500 $11,300 $102,200
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: NorthstarMLS

MLS Number: 6734778

NorthstarMLS

APN: 18-031-21-44-0012