Skip main navigation
Pending
  • $299,900

    15485 Farnham Ave N, Hugo, MN 55038

    3beds
    1,567sqft
    : 
    $2,191/mo
    Get pre-qualified
    (TH) Side x Side
    Built in 2005
    2,395 Square Feet Lot
    $-- Zestimate®
    $191/sqft
    $350/mo HOA

    What's special

    Enjoy this multi-level, end-unit townhome offering a wonderful layout with a private owner’s suite (private bath with separate shower/tub and walk-in closet), spacious second bedroom, and full bath on the upper level. The main floor features vaulted ceilings and an open kitchen, dining, and living area that feels connected while still offering comfortable separation between spaces. South and west-facing windows bring in an abundance of natural light, and with no neighboring building to the west, you’ll enjoy peaceful views of the pond, mature trees, and local wildlife. It’s a rare combination of privacy, natural beauty, and maintenance-free living within a community setting. The walk-out lower level adds even more living space with a family room, third bedroom (armoire included) or office, convenient half bath, and laundry area. Step outside to the concrete patio below or relax on the upper deck overlooking the serene surroundings. Just down the road, the community clubhouse offers outstanding amenities included in the affordable HOA dues, including a lap pool, splash pad, fitness center, party room with full kitchen, playground, basketball court, and more. Enjoy the comfort, convenience, and lifestyle this exceptional Waters Edge townhome has to offer.
    44 days
    |
    29
    |
    1
    |

    Likely to sell faster than

    Zillow last checked:

    Listing updated:

    Listed by:

    Kimberly Ann Gillespie 651-402-0514,

    Edina Realty, Inc.

    Source: NorthstarMLS as distributed by MLS GRID,MLS#: 7089242MLS Logo

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 3
      • Bathrooms: 3
      • Full bathrooms: 2
      • 1/2 bathrooms: 1
      Bedroom
      • Level: Upper
      • Area: 182 Square Feet
      • Dimensions: 14x13
      Bedroom 2
      • Level: Upper
      • Area: 132 Square Feet
      • Dimensions: 12x11
      Bedroom 3
      • Level: Lower
      • Area: 110 Square Feet
      • Dimensions: 11x10
      Primary bathroom
      • Level: Upper
      • Area: 72 Square Feet
      • Dimensions: 9x8
      Bathroom
      • Level: Upper
      • Area: 80 Square Feet
      • Dimensions: 10x8
      Deck
      • Level: Main
      • Area: 100 Square Feet
      • Dimensions: 10x10
      Dining room
      • Level: Main
      • Area: 99 Square Feet
      • Dimensions: 11x9
      Family room
      • Level: Lower
      • Area: 238 Square Feet
      • Dimensions: 17x14
      Foyer
      • Level: Main
      • Area: 40 Square Feet
      • Dimensions: 8x5
      Kitchen
      • Level: Main
      • Area: 110 Square Feet
      • Dimensions: 11x10
      Living room
      • Level: Main
      • Area: 224 Square Feet
      • Dimensions: 16x14
      Heating
      • Forced Air
      Cooling
      • Central Air
      Appliances
      • Included: Dishwasher, Disposal, Dryer, Exhaust Fan, Freezer, Microwave, Range, Refrigerator, Stainless Steel Appliance(s), Washer, Water Softener Owned
      • Laundry: Gas Dryer Hookup, Lower Level, In Unit, Washer Hookup
      Features
      • Basement: Daylight,Drain Tiled,Full,Storage Space,Sump Pump,Walk-Out Access
      • Has fireplace: No
      Interior area
      • Total structure area: 1,624
      • Total interior livable area: 1,567 sqft
      • Finished area above ground: 1,087
      • Finished area below ground: 480

      Property

      Parking
      • Total spaces: 2
      • Parking features: Attached, Asphalt, Garage, Garage Door Opener, Heated Garage, Insulated Garage
      • Attached garage spaces: 2
      • Has uncovered spaces: Yes
      Accessibility
      • Accessibility features: None
      Features
      • Levels: Three Level Split
      • Patio & porch: Deck
      • Has private pool: Yes
      • Pool features: Outdoor Pool, Shared
      • Fencing: None
      • Waterfront features: Pond
      Lot
      • Size: 2,395 Square Feet
      • Dimensions: 67 x 36 x 67 x 36
      • Features: Corner Lot, Tree Coverage - Medium
      Details
      • Foundation area: 530
      • Parcel number: 1803121410008
      • Zoning description: Residential-Single Family

      Construction

      Type & style
      • Home type: Townhouse
      • Property subtype: (TH) Side x Side
      • Attached to another structure: Yes
      Materials
      • Roof: Age Over 8 Years,Asphalt
      Condition
      • New construction: No
      • Year built: 2005

      Utilities & green energy

      • Gas: Natural Gas
      • Sewer: City Sewer/Connected
      • Water: City Water/Connected
      • Utilities for property: Underground Utilities

      Community & HOA

      Community
      • Subdivision: Waters Edge South Second Add
      HOA
      • Has HOA: Yes
      • Services included: Maintenance Structure, Hazard Insurance, Lawn Care, Other, Maintenance Grounds, Professional Mgmt, Recreation Facility, Shared Amenities, Snow Removal
      • HOA fee: $350 monthly
      • HOA name: HOALiving
      • HOA phone: 612-234-6464
      Location
      • Region: Hugo

      Financial & listing details

      • Price per square foot: $191/sqft
      • Tax assessed value: $283,200
      • Annual tax amount: $3,230
      • Date on market: 6/9/2026
      • Cumulative days on market: 38 days

        Estimated market value

        Not available

        Estimated sales range

        Not available

        Not available

        Price history

        DateEventPrice
        6/18/2026Pending sale$299,900$191/sqft
        Source: NorthstarMLS as distributed by MLS GRID #7089242 Report a problem
        6/12/2026Listing removed$299,900$191/sqft
        Source: NorthstarMLS as distributed by MLS GRID #7089242 Report a problem
        6/9/2026Listed for sale$299,9000%$191/sqft
        Source: NorthstarMLS as distributed by MLS GRID #7089242 Report a problem
        5/29/2026Listing removed$300,000$191/sqft
        Source: NorthstarMLS as distributed by MLS GRID #7060087 Report a problem
        5/21/2026Listed for sale$300,000+29.3%$191/sqft
        Source: NorthstarMLS as distributed by MLS GRID #7060087 Report a problem
        5/15/2020Sold$232,000+0.9%$148/sqft
        Source: NorthstarMLS as distributed by MLS GRID #5495190 Report a problem
        4/1/2020Pending sale$229,900$147/sqft
        Source: Keller Williams Realty Integrity Lakes #5495190 Report a problem
        3/24/2020Listed for sale$229,900$147/sqft
        Source: Keller Williams Realty Integrity Lakes #5495190 Report a problem
        3/20/2020Pending sale$229,900$147/sqft
        Source: Keller Williams Realty Integrity Lakes #5495190 Report a problem
        3/20/2020Listed for sale$229,900+4.5%$147/sqft
        Source: Keller Williams Realty Integrity Lakes #5495190 Report a problem
        8/24/2018Sold$220,000+2.3%$140/sqft
        Source: NorthstarMLS as distributed by MLS GRID #4966821 Report a problem
        7/14/2018Listed for sale$215,000+10.8%$137/sqft
        Source: Kris Lindahl Real Estate #4966821 Report a problem
        5/26/2006Sold$194,120$124/sqft
        Source: Public Record Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025$3,168 -2.5%$262,100 -8.5%
        2024$3,250 +11.5%$286,400 +13.7%
        2023$2,914 +9.6%$252,000 +20.6%
        2022$2,658 -0.7%$208,900 -7.5%
        2021$2,676 -2.8%$225,800 +1.6%
        2020$2,752 $222,200
        2019$2,752 $222,200 +8.8%
        2018$2,752 +20.9%$204,300 +15.8%
        2017$2,276 +21.6%$176,500 +12.4%
        2016$1,872 +12.2%$157,000 +8.1%
        2015$1,668 $145,200 +39.3%
        2013$1,668 +9.6%$104,200 +21%
        2012$1,522 $86,100 -26.3%
        2011$1,522 -13.5%$116,800 -36.2%
        2010$1,760 -6.6%$183,200
        2009$1,884 +19.4%--
        2008$1,578 +475.9%--
        2007$274 +552.4%--
        2006$42 --
        Find assessor info on the county website

        Monthly payment

        Est. payment

        Payment breakdown

        Explore the cost of this home by adjusting the details. Changes won't be saved.
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
        See how much you could borrow to make a competitive offer.

        Climate risks

        Neighborhood: 55038

        Getting around

        12 / 100
        Car-Dependent
        52 / 100
        Bikeable

        Nearby schools

        GreatSchools rating

        A local agent can set up tours, give advice and negotiate with sellers.

        Browse local experts

        Similar homes