$500,000
SOLD DEC 16, 2024

15870 Farnham Ave N Hugo, MN 55038

5 Beds
3 Baths
3,488 Sq Ft
9,583 Sq Ft Lot

Recently Sold

$143 Per Sq Ft

9% Below List Price

115 Days on Market

Highlights

  • In Ground Pool
  • Stainless Steel Appliances
  • 3 Car Attached Garage
  • Deck
  • The kitchen features windows
  • Patio

About This Home

As of December 2024

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!

Last Agent to Sell the Property

Kathryn Johnson

eXp Realty Listed on: 08/12/2024

eXp Realty

Co-Listed By

Kelsie Lembeck

eXp Realty

Last Buyer's Agent

Voila It's That Easy

eXp Realty

eXp Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,626

Year Built

  • Built in 2005

Lot Details

  • 9,583 Sq Ft Lot
  • Lot Dimensions are 97x130x51x130
  • Partially Fenced Property
  • Wood Fence
  • Chain Link Fence

HOA Fees

  • $65 Monthly HOA Fees

Parking

  • 3 Car Attached Garage
  • Parking Storage or Cabinetry
  • Heated Garage
  • Insulated Garage

Home Design

  • Split Level Home
  • Pitched Roof
  • Architectural Shingle Roof
  • Shake Siding

Interior Spaces

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

Kitchen

  • Range<<rangeHoodToken>>
  • <<microwave>>
  • Dishwasher
  • Stainless Steel Appliances
  • Disposal
  • The kitchen features windows

Bedrooms and Bathrooms

  • 5 Bedrooms

Laundry

  • Dryer
  • Washer

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Sump Pump
  • Drain
  • Basement Storage
  • Basement Window Egress

Eco-Friendly Details

  • Air Exchanger

Outdoor Features

  • In Ground Pool
  • Deck
  • Patio

Utilities

  • Forced Air Heating and Cooling System
  • Humidifier

Listing and Financial Details

  • Assessor Parcel Number 1803121110028

Community Details

Overview

  • Association fees include professional mgmt, shared amenities
  • Hoaliving Mn Association, Phone Number (612) 234-6464
  • Waters Edge Subdivision

Recreation

  • Community Pool
  • Trails

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,626

Year Built

Built in 2005

Lot Details

0

HOA Fees

$65 per month

Parking

3

Listing Details

  • Type: Residential
  • Property Subtype 1: Single Family Residence
  • Cooling System: Central Air
  • Garage Spaces: 3
  • Accessibility Features: None
  • Fireplaces: 1
  • Water Source: City Water/Connected
  • Association Amenities: Other, Trail(s)
  • Fee Frequency: Monthly
  • Year Built: 2005
  • Above Grade Finished Sq Ft: 2242
  • Unit Levels: Three Level Split
  • New Construction: No
  • FractionalOwnershipYN: No
  • Rental License?: No
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Basement: Block, Daylight/Lookout Windows, Drain Tiled, 8 ft+ Pour, Egress Window(s), Finished, Full, Storage Space, Sump Pump, Walkout
  • Appliances: Air-To-Air Exchanger, Dishwasher, Disposal, Dryer, Exhaust Fan, Humidifier, Gas Water Heater, Microwave, Range, Refrigerator, Stainless Steel Appliances, Washer
  • Fireplace Features: Family Room, Gas, Stone
  • Living Area: 3488
  • Fireplace: Yes
  • Below Grade Finished Sq Ft: 1246
  • Basement YN: Yes
  • Dining Room Type: Foyer, Living Room, Dining Room, Kitchen, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4, Laundry, Sun Room, Deck, Family Room, Bedroom 5, Patio
  • Shared Rooms: Amusement/Party Room,Community Room,Exercise Room,Other

Beds/Baths

  • Full Bathrooms: 2
  • Total Bedrooms: 5
  • Three Quarter Bathrooms: 1

Exterior Features

  • Roof: Age 8 Years or Less, Architectural Shingle, Pitched
  • PoolFeatures: Below Ground, Outdoor Pool, Shared
  • Fencing: Chain Link, Partial, Wood
  • Other Structures: Storage Shed
  • PatioPorchType: Deck,Front Porch,Patio

Garage/Parking

  • Parking Features: Attached Garage, Concrete, Electric, Heated Garage, Insulated Garage, Storage
  • Garage Square Feet: 525

Utilities

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

Condo/Co-op/Association

  • HOA Fee Includes: Professional Mgmt, Shared Amenities
  • Phone: 612-234-6464
  • Association Fee: 65
  • Association: Yes
  • Amenities Unit: Ceiling Fan(s),Deck,Hardwood Floors,Kitchen Center Island,Kitchen Window,Primary Bedroom Walk-In Closet,Patio,Porch,Security System,Boat Slip,Sun Room,Tile Floors,Vaulted Ceiling(s),Washer/Dryer Hookup,Wet Bar,Walk-In Closet

Association/Amenities

  • HOA Management Co: HOAliving MN

Schools

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

Lot Info

  • PropertyAttachedYN: No
  • Lot Size: 97x130x51x130
  • Lot Size Sq Ft: 9583.2
  • Land Lease: No
  • Additional Parcels: No
  • Zoning Description: Residential-Single Family
  • ResoLotSizeUnits: Acres
  • AssessmentPending: No
  • Yearly/Seasonal: Yearly

Building Info

  • Construction Materials: Brick/Stone, Shake Siding, Vinyl Siding

Tax Info

  • Tax Year: 2024
  • Assessor Parcel Number: 1803121110028
  • Tax Annual Amount: 5626
  • TaxWithAssessments: 6328.0000

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Aug 12, 2024
Closed on
Dec 16, 2024
Sold by
Sheridan Chad and Sheridan Kari A
Bought by
Bergstedt Allen and Bergstedt Alysha
Seller's Agent
Kathryn Johnson
eXp Realty
Buyer's Agent
Voila It's That Easy
eXp Realty
List Price
$549,900
Sold Price
$500,000
Premium/Discount to List
-$49,900
-9.07%
Views
107
Current Estimated Value
$516,010

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$16,010
Avg. Annual Appreciation
5.46%
Original Mortgage
$425,000
Outstanding Balance
$423,489
Interest Rate
6.63%
Mortgage Type
New Conventional
Estimated Equity
$92,175

Purchase Details

Closed on
Feb 8, 2005
Sold by
Waters Edge North Sf Llc
Bought by
Robert Trent Homes Inc
Source: Public Records

Similar Homes in Hugo, MN

  • 5261 Fenson Ct N, Hugo, MN 55038

    $475,000

    • 3 Beds
    • 2.5 Baths
    • 1,887 Sq Ft
    • 5261 Fenson Ct N
    • Hugo, MN

    Welcome to this wonderful 3-bedroom, 3-bathroom home perfectly nestled on a quiet cul-de-sac in the heart of Hugo! This beautifully maintained property offers the perfect blend of comfort, style, and functionality, making it an ideal choice for families or anyone seeking a peaceful suburban retreat.Step inside to discover a bright and open floor plan on the main level, featuring gleaming

    Joseph Walsh POP Realty MN

    Section Image
  • 5265 Fenson Ct N, Hugo, MN 55038

    $549,900

    • 5 Beds
    • 3.5 Baths
    • 2,870 Sq Ft
    • 5265 Fenson Ct N
    • Hugo, MN

    Tucked away on a quiet cul-de-sac, this beautifully designed home offers warmth, space, and refined finishes. Step into the vaulted living room, where soaring ceilings, a cozy gas fireplace, and sun-filled windows frame tranquil views of ponds and 11+ acres of city-owned nature space. The open kitchen features custom cabinetry, granite counters, stainless appliances, and a pantry, flowing

    Justin Fox RE/MAX Professionals

    Section Image
  • 5080 159th St N, Hugo, MN 55038

    $480,000

    • 5 Beds
    • 3 Baths
    • 2,508 Sq Ft
    • 5080 159th St N
    • Hugo, MN

    Buyer's financing fell through, so this beautiful home is back on the market and ready for its next chance to impress!Beautiful Hugo area home now available! The home features 5 bedrooms, 3 baths, a fenced backyard for the pets and kids, a heated 3 stall garage, several new stainless steel kitchen appliances, along with many other gorgeous updates throughout. The association shared

    Jeffrey Pluff Brick & Banister Real Estate

    Section Image
  • 5390 157th St N, Hugo, MN 55038

    $559,900

    • 4 Beds
    • 3.5 Baths
    • 3,443 Sq Ft
    • 5390 157th St N
    • Hugo, MN

    Welcome to YOUR beautiful new home with the best curb appeal in the neighborhood! Your guests will be greeted by lovely landscaping, flowering trees, peaceful water features and incredible pond views! A fenced in backyard to keep everyone safe and a doggy door for the pup to let themself in and out. Upon entering you will be welcomed by a large living area with vaulted ceiling and pond views out

    Kathryn Johnson eXp Realty

    Section Image
  • 15702 Fairoaks Ave N, Hugo, MN 55038

    $375,000

    • 4 Beds
    • 2.5 Baths
    • 1,978 Sq Ft
    • 15702 Fairoaks Ave N
    • Hugo, MN

    Homeownership or investment opportunity! Whether you’re a homeowner eager to personalize your space or an investor seeking a project or rental, this home has incredible potential. Located in a desirable neighborhood with association shared amenities including pool, gym, playground, and meeting room. This 2 story home features all 4 bedrooms on the upper level, primary suite with a private bath

    Melissa Genereux Gener8 Group LLC

    Section Image
  • 15931 Finale Ct N, Hugo, MN 55038

    $385,900

    • 3 Beds
    • 2 Baths
    • 1,374 Sq Ft
    • 15931 Finale Ct N
    • Hugo, MN

    Split Level Single Family home currently under construction with an estimated September completion! NO HOMEOWNERS ASSOCIATION! The Newberry floor plan features an Open Concept Main Living Area, 3 Bedrooms, 2 Bathrooms, and a 2 Car Garage! Beautiful Two Story Foyer! Unfinished Walkout Lower Level offers space for future Family Room, 4th Bedroom, and 3rd Bathroom. The Primary Suite includes a

    Kristine Pierson Centra Homes, LLC

    Section Image
  • 15951 Finale Ct N, Hugo, MN 55038

    $383,900

    • 3 Beds
    • 2 Baths
    • 1,374 Sq Ft
    • 15951 Finale Ct N
    • Hugo, MN

    Split Level Single Family home currently under construction with an estimated August completion! NO HOMEOWNERS ASSOCIATION! The Newberry floor plan features an Open Concept Main Living Area, 3 Bedrooms, 2 Bathrooms, and a 2 Car Garage! Beautiful Two Story Foyer! Unfinished Walkout Lower Level offers space for future Family Room, 4th Bedroom, and 3rd Bathroom. The Primary Suite includes a Private

    Kristine Pierson Centra Homes, LLC

    Section Image
  • 4935 162nd St N, Hugo, MN 55038

    $489,900

    • 5 Beds
    • 3 Baths
    • 2,578 Sq Ft
    • 4935 162nd St N
    • Hugo, MN

    Amazing NEW CONSTRUCTION rambler home in Hugo! Cul-de-sac location! Capstone Homes welcomes you to our sought after Ashton floor plan! Main level living! Home highlights include: open concept floor plan, towering ceilings, three stall garage, FINSHED walk out basement, beautiful basement living room fireplace, stone kitchen & vanity countertops, expanded luxury vinyl plank flooring, sod,

    Ryan Fleck Capstone Realty, LLC

    Section Image
  • 16112 Finale Ave N, Hugo, MN 55038

    $376,900

    • 3 Beds
    • 2 Baths
    • 1,374 Sq Ft
    • 16112 Finale Ave N
    • Hugo, MN

    Split Level Single Family home currently under construction with an estimated August completion! NO HOMEOWNERS ASSOCIATION! The Newberry floor plan features an Open Concept Main Living Area, 3 Bedrooms, 2 Bathrooms, and a 2 Car Garage! Beautiful Two Story Foyer! Unfinished Walkout Lower Level offers space for future Family Room, 4th Bedroom, and 3rd Bathroom. The Primary Suite includes a Private

    Kristine Pierson Centra Homes, LLC

    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
Warranty Deed $500,000 Titlesmart
Warranty Deed $493,815 --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $425,000 New Conventional
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
12/16/2024 12/16/24 Sold $500,000 0.0% $143 / Sq Ft
12/08/2024 12/08/24 Pending -- -- --
09/27/2024 09/27/24 Price Changed $499,995 -3.8% $143 / Sq Ft
09/06/2024 09/06/24 Price Changed $519,900 -5.5% $149 / Sq Ft
08/15/2024 08/15/24 For Sale $549,900 -- $158 / Sq Ft
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 $5,220 $442,900 $85,000 $357,900
2023 $6,328 $498,900 $120,000 $378,900
2022 $4,954 $475,800 $126,200 $349,600
2021 $4,926 $395,800 $105,000 $290,800
2020 $5,024 $390,700 $110,000 $280,700
2019 $4,272 $382,200 $100,000 $282,200
2018 $4,414 $359,000 $100,000 $259,000
2017 $4,098 $343,900 $95,000 $248,900
2016 $3,756 $315,100 $77,000 $238,100
2015 $3,902 $300,300 $65,000 $235,300
2013 -- $264,000 $51,000 $213,000
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: NorthstarMLS

MLS Number: 6582873

NorthstarMLS

APN: 18-031-21-11-0028