Skip main navigation
Closed
  • $500,000

    15870 Farnham Ave N, Hugo, MN 55038

    5beds
    3,560sqft
    Single Family Residence
    Built in 2005
    9,583 sqft lot
    $503,100 Zestimate®
    $140/sqft
    $65/mo HOA

    What's special

    Why buy new when you can purchase this gorgeous, move-in ready home with a finished basement! Nestled in the sought after Water's Edge Pool Community of Hugo this custom built home, updated throughout is turn key & ready for you to call your own! Bright & spacious, open concept main level with fresh paint throughout, new carpet & hardwood floors. Kitchen offers large island, ample cabinet space, granite counters, stainless appliances including new range & dishwasher. Sun room is perfect for slow mornings or extra entertaining space & walks out to large cedar deck. 3 Bedrooms, Laundry & Full Bath on main level. Massive private Owner's Suite on upper level boasts new carpet, vaulted ceilings, large walk in closet & ensuite. Lower Level holds Family Room with gas fireplace & custom wet bar, spacious 5th Bedroom & 3/4 Bathroom with walk in, tiled shower. Large patio & private backyard with storage shed. Oversized insulated/heated 2.5 car garage, large concrete driveway with additional parking. All of this within walking distance to schools, many parks, trails and pool!

    Zillow last checked: 7 hours ago

    Listing updated: May 06, 2025 at 07:27pm

    Listed by:

    Kathryn Johnson 651-283-4147,

    eXp Realty,

    Kelsie Lembeck 612-986-2858

    Bought with:

    Joseph P. Torkildson

    eXp Realty

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

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 5
    • Bathrooms: 3
    • Full bathrooms: 2
    • 3/4 bathrooms: 1
    Bedroom 1
    • Level: Upper
    • Area: 384 Square Feet
    • Dimensions: 24x16
    Bedroom 2
    • Level: Main
    • Area: 121 Square Feet
    • Dimensions: 11x11
    Bedroom 3
    • Level: Main
    • Area: 121 Square Feet
    • Dimensions: 11x11
    Bedroom 4
    • Level: Main
    • Area: 100 Square Feet
    • Dimensions: 10x10
    Bedroom 5
    • Level: Lower
    • Area: 180 Square Feet
    • Dimensions: 15x12
    Deck
    • Level: Main
    • Area: 110 Square Feet
    • Dimensions: 11x10
    Dining room
    • Level: Main
    • Area: 120 Square Feet
    • Dimensions: 12x10
    Family room
    • Level: Lower
    • Area: 576 Square Feet
    • Dimensions: 32x18
    Foyer
    • Level: Main
    • Area: 96 Square Feet
    • Dimensions: 12x8
    Kitchen
    • Level: Main
    • Area: 132 Square Feet
    • Dimensions: 12x11
    Laundry
    • Level: Main
    • Area: 54 Square Feet
    • Dimensions: 9x6
    Living room
    • Level: Main
    • Area: 208 Square Feet
    • Dimensions: 16x13
    Patio
    • Level: Main
    • Area: 375 Square Feet
    • Dimensions: 25x15
    Sun room
    • Level: Main
    • Area: 144 Square Feet
    • Dimensions: 12x12
    Heating
    • Forced Air, Fireplace(s)
    Cooling
    • Central Air
    Appliances
    • Included: Air-To-Air Exchanger, Dishwasher, Disposal, Dryer, Exhaust Fan, Humidifier, Gas Water Heater, Microwave, Range, Refrigerator, Stainless Steel Appliance(s), Washer
    Features
    • Basement: Block,Daylight,Drain Tiled,8 ft+ Pour,Egress Window(s),Finished,Full,Storage Space,Sump Pump,Walk-Out Access
    • Number of fireplaces: 1
    • Fireplace features: Family Room, Gas, Stone
    Interior area
    • Total structure area: 3,560
    • Total interior livable area: 3,560 sqft
    • Finished area above ground: 2,242
    • Finished area below ground: 1,246

    Property

    Parking
    • Total spaces: 3
    • Parking features: Attached, Concrete, Electric, Heated Garage, Insulated Garage, Storage
    • Attached garage spaces: 3
    • Details: Garage Dimensions (25x21)
    Accessibility
    • Accessibility features: None
    Features
    • Levels: Three Level Split
    • Patio & porch: Deck, Front Porch, Patio
    • Has private pool: Yes
    • Pool features: In Ground, Outdoor Pool, Shared
    • Fencing: Chain Link,Partial,Wood
    Lot
    • Size: 9,583 sqft
    • Dimensions: 97 x 130 x 51 x 130
    Details
    • Additional structures: Storage Shed
    • Foundation area: 1486
    • Parcel number: 1803121110028
    • Zoning description: Residential-Single Family

    Construction

    Type & style
    • Home type: SingleFamily
    • Property subtype: Single Family Residence
    Materials
    • Brick/Stone, Shake Siding, Vinyl Siding
    • Roof: Age 8 Years or Less,Pitched
    Condition
    • Age of Property: 20
    • New construction: No
    • Year built: 2005

    Utilities & green energy

    • Electric: Circuit Breakers
    • Gas: Natural Gas
    • Sewer: City Sewer/Connected
    • Water: City Water/Connected

    Community & neighborhood

    Location
    • Region: Hugo
    • Subdivision: Waters Edge

    HOA & financial

    HOA
    • Has HOA: Yes
    • HOA fee: $65 monthly
    • Amenities included: Other, Trail(s)
    • Services included: Professional Mgmt, Shared Amenities
    • Association name: HOAliving MN
    • Association phone: 612-234-6464

    Other

    Other facts
    • Road surface type: Paved
    Services availability
    Get pre-qualified for a loan
    At Zillow Home Loans, we can pre-qualify you in as little as 5 minutes with no impact to your credit score.

    An equal housing lender. NMLS #10287.

    Get a cash offer in 3 minutes

    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.

    Estimated market value

    $503,100