NOT LISTED FOR SALE

15028 Farnham Ave N Hugo, MN 55038

Estimated Value: $281,712 - $293,000

3 Beds
1.5 Baths
1,856 Sq Ft
$155/Sq Ft Est. Value

Last Sold June 07, 2022

Last sale price $300,000 $162 Per Sq Ft

Est. 4% decrease in value since last sale

Current estimated payment $2,136/month

Highlights

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

About This Home

As of June 2022

This coveted Waters Edge floorplan & updates will be hard to beat! The main floor boasts an open concept kitchen, dining & living area that is perfect for entertaining. With freshly refinished white cabinets, a center island, ample cabinet storage, stainless appliances & new light fixture, this kitchen is set up to move in & enjoy. Both bathrooms have been completely remodeled: the main floor powder room 2021 & upper floor owners suite bath in 2022. The HUGE (20x12) owners suite is truly a retreat with a walk in
closet & custom shelving, vaulted ceiling & owners walk-thru bath. In addition to 2 bedrooms, the upper floor loft serves as a perfect office or toy area. Carpet & padding completely replaced in 2020. Fresh
paint (walls and ceilings) throughout entire home. Brand new maintenance free decking was installed in 2020! This neighborhood includes a heated in ground pool, clubhouse basketball court, party room & fitness center. Owners enjoy quick access to 35E and highway 61!

Last Listed By

Brooke Boss

Keller Williams Select Realty Listed on: 05/13/2022

Keller Williams Select Realty

Townhouse Details

Home Type

  • Townhome

Est. Annual Taxes

  • $2,439

Year Built

  • Built in 2006

Lot Details

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

HOA Fees

  • $265 Monthly HOA Fees

Parking

  • 2 Car Attached Garage

Interior Spaces

  • 2-Story Property
  • Living Room
  • Loft

Kitchen

  • Range
  • Microwave
  • Dishwasher

Bedrooms and Bathrooms

  • 3 Bedrooms

Laundry

  • Dryer
  • Washer

Finished 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

Community Details

  • Association fees include maintenance structure, hazard insurance, lawn care, ground maintenance, professional mgmt, recreation facility, shared amenities, snow removal
  • Gaughan Companies Association, Phone Number (612) 238-4400
  • Waters Edge South Subdivision

Listing and Financial Details

  • Assessor Parcel Number 1803121440006

Townhouse Details

Home Type

Townhome

Est. Annual Taxes

$2,439

Year Built

Built in 2006

Lot Details

0

HOA Fees

$265 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
  • Water Source: City Water/Connected
  • Fee Frequency: Monthly
  • Year Built: 2006
  • Above Grade Finished Sq Ft: 1496
  • Unit Levels: Two
  • New Construction: No
  • FractionalOwnershipYN: No
  • Rental License?: No
  • Special Features: VirtualTour
  • Property Sub Type: Townhouses

Interior Features

  • Basement: Daylight/Lookout Windows, Finished, Full, Sump Pump
  • Appliances: Dishwasher, Dryer, Gas Water Heater, Microwave, Range, Refrigerator, Washer, Water Softener Owned
  • Living Area: 1856
  • Fireplace: No
  • Below Grade Finished Sq Ft: 360
  • Basement YN: Yes
  • Dining Room Type: Living Room, Dining Room, Kitchen, Bedroom 1, Bedroom 2, Bedroom 3, Loft
  • SqFtTotal: 1856.00

Beds/Baths

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

Exterior Features

  • PoolFeatures: Below Ground, Heated

Garage/Parking

  • Parking Features: Attached Garage
  • Garage Square Feet: 441

Utilities

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

Condo/Co-op/Association

  • HOA Fee Includes: Maintenance Structure, Hazard Insurance, Lawn Care, Maintenance Grounds, Professional Mgmt, Recreation Facility, Shared Amenities, Snow Removal
  • Phone: 612-238-4400
  • Association Fee: 265
  • Association: Yes
  • Amenities Unit: Balcony,Deck,Exercise Room,Kitchen Center Island,Primary Bedroom 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: 21x71
  • Lot Size Sq Ft: 1524.6
  • Land Lease: No
  • Additional Parcels: No
  • Zoning Description: Residential-Single Family
  • ResoLotSizeUnits: Acres
  • AssessmentPending: No
  • Yearly/Seasonal: Yearly

Building Info

  • Construction Materials: Brick/Stone, Vinyl Siding

Tax Info

  • Tax Year: 2021
  • Assessor Parcel Number: 1803121440006
  • Tax Annual Amount: 2439
  • TaxWithAssessments: 2442.0000

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
May 13, 2022
Closed on
Jun 7, 2022
Sold by
Spreeman Krystal
Bought by
Mkts Real Estate Llc
Seller's Agent
Brooke Boss
Keller Williams Select Realty
Buyer's Agent
Nancy Moe
Results Support Services, Inc
List Price
$290,000
Sold Price
$300,000
Premium/Discount to List
$10,000
3.45%
Total Days on Market
0
Current Estimated Value
$287,928

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$12,072
Avg. Annual Appreciation
-1.41%
Original Mortgage
$240,000
Outstanding Balance
$230,850
Interest Rate
5.23%
Mortgage Type
New Conventional
Estimated Equity
$57,078

Purchase Details

Listed on
Apr 7, 2020
Closed on
May 14, 2020
Sold by
Colestock Michaelene Rose and Spence Michaelene
Bought by
Spreeman Krystal
Seller's Agent
Lianna Colestock
LPT Realty, LLC
Buyer's Agent
Brooke Boss
Keller Williams Select Realty
List Price
$215,000
Sold Price
$225,000
Premium/Discount to List
$10,000
4.65%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
14.91%
Original Mortgage
$220,924
Interest Rate
3.3%
Mortgage Type
FHA

Purchase Details

Listed on
Aug 3, 2015
Closed on
Oct 15, 2015
Sold by
Rolon Sandra
Bought by
Spence Michaelene
Seller's Agent
Anthony D'Agostino
RE/MAX Advantage Plus
List Price
$164,900
Sold Price
$160,000
Premium/Discount to List
-$4,900
-2.97%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
7.73%
Original Mortgage
$152,000
Interest Rate
3.74%
Mortgage Type
New Conventional

Purchase Details

Closed on
Sep 29, 2006
Sold by
Pulte Homes Of Minnesota Corp
Bought by
Rolon Sandra

Home Financials for this Owner

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

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 Buyer Sale Price Title Company
Mkts Real Estate Llc $300,000 --
Spreeman Krystal $225,000 Burnet Title
Spence Michaelene $160,000 Trademark Title Services Inc
Rolon Sandra $167,490 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Mkts Real Estate Llc $240,000
Previous Owner Spreeman Krystal $220,924
Previous Owner Spence Michaelene $152,000
Previous Owner Rolon Sandra $154,463
Previous Owner Rolon Sandra $171,091
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
06/07/2022 06/07/22 Sold $300,000 +3.4% $162 / Sq Ft
05/09/2022 05/09/22 Pending -- -- --
05/09/2022 05/09/22 For Sale $290,000 +28.9% $156 / Sq Ft
05/14/2020 05/14/20 Sold $225,000 0.0% $121 / Sq Ft
04/19/2020 04/19/20 Pending -- -- --
04/09/2020 04/09/20 Off Market $225,000 -- --
04/07/2020 04/07/20 For Sale $215,000 +34.4% $116 / Sq Ft
10/15/2015 10/15/15 Sold $160,000 -3.0% $107 / Sq Ft
08/03/2015 08/03/15 For Sale $164,900 -- $110 / 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
2023 $3,206 $282,600 $62,000 $220,600
2022 $2,538 $258,400 $48,100 $210,300
2021 $2,442 $216,800 $40,000 $176,800
2020 $2,498 $208,600 $40,000 $168,600
2019 $1,982 $204,400 $35,000 $169,400
2018 $1,714 $181,500 $30,000 $151,500
2017 $1,620 $163,900 $20,000 $143,900
2016 $1,700 $154,900 $15,000 $139,900
2015 $1,834 $145,000 $17,300 $127,700
2013 -- $111,200 $11,300 $99,900
Source: Public Records

Agents Affiliated with this Home

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

Map

Similar Homes in Hugo, MN

  • 5113 Fairpoint Dr N, Hugo, MN 55038

    $299,900

    • 3 Beds
    • 2.5 Baths
    • 1,909 Sq Ft
    • 5113 Fairpoint Dr N
    • Hugo, MN

    This sunny end unit is in a great neighborhood with awesome amenities—two pools (an adult pool and a kid-friendly water park), a playground, walking paths, a fitness center, and a clubhouse with a game room and party space.The front of the home overlooks a peaceful dry pond, adding a nice touch of nature and extra privacy. Inside, the kitchen has a center island and new backsplash. A cozy

    Scott Bougie RE/MAX Advantage Plus

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

    $285,000

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

    *Welcome Home to 4970 149th Street N #3 in Hugo* This 2-bedroom, 2-bathroom, attached 2-garage, 2-story townhome is located in the desirable Waters Edge community. The main level features a living room and spacious eat-in kitchen with ample counter and cabinet space and 1/2 bath. Upstairs, you'll find two spacious bedrooms, including the vaulted primary suite with a walk-through bath and walk-in

    Brandon Rudenick RE/MAX Results

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

    $289,900

    • 3 Beds
    • 2.5 Baths
    • 1,982 Sq Ft
    • 15126 Fanning Dr N
    • Hugo, MN

    END UNIT!! Sunny home with beautiful sunrise and sunset views! New furnace 4/25! Fresh & clean, trendy/neutral decor, 3 bedrooms on ONE LEVEL, convenient main floor laundry & guest bath. Huge eat-in kitchen with easy access to deck, has a large pantry, tons of maple cabinets. Massive owner's suite with pretty sunset views, vaulted ceiling & ceiling fan, massive walk-in closet, private full bath

    Jeanette DuBay LPT Realty, LLC

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

    $289,900

    • 3 Beds
    • 2.5 Baths
    • 1,822 Sq Ft
    • 15124 French Dr N
    • Hugo, MN

    Move in ready 3 bedroom 3 bath townhouse in the sought after Water's Edge Association! This unit hasbeen meticulously maintained with so may recent updates including new windows on main and upper level in November 2021, new permanent decking in 2023, new washer and dryer in 2024, kitchen appliances in 2016, water heater and water softener in 2015, front storm door and garage door opener in 2021,

    Kim Katzenmeyer Keller Williams Realty Integrity Northwest

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

    $259,900

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

    1 Year Home Warranty is included with the sale of the home! This meticulously maintained end-unit townhome offers an abundance of natural light and privacy. Recent upgrades include a new refrigerator and water heater a few years ago, the furnace was serviced in December of 2024, and a new washer and dryer in January of 2024! Natural light floods the living room and kitchen. A heated and insulated

    Gabriel Gustafson RE/MAX Synergy

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

    $309,900

    • 4 Beds
    • 3 Baths
    • 1,982 Sq Ft
    • 5091 French Dr N
    • Hugo, MN

    One of the nicest units in the desirable Hugo neighborhood of Waters Edge. This large 4 BR/3 bath townhome has been updated nicely and is in one of the best locations: open land with views to the South and West plus guest parking just steps away. There are beautiful sunsets out your front windows! Inside, the floor plan is equally outstanding. You'll love the huge and bright, eat-in kitchen.

    Gregory Yurick RE/MAX Results

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

    $284,000

    • 3 Beds
    • 2.5 Baths
    • 1,942 Sq Ft
    • 5102 French Dr N
    • Hugo, MN

    Great end-unit in Waters Edge. These are the largest town homes that Pulte Homes built in Waters Edge. 3 Bedrooms up w/ a private master bathroom, second full bathroom upstairs, half bath on the main level as well, completely finished home with about 1,900 square feet. Freshly painted newer stainless steel appliances w/ double oven and a finished heated garage making it another room to hangout in

    Bryan Peltier Edina Realty, Inc.

    Section Image
  • 15391 Falk Dr N, Hugo, MN 55038

    $292,500

    • 2 Beds
    • 2.5 Baths
    • 1,596 Sq Ft
    • 15391 Falk Dr N
    • Hugo, MN

    Move-in ready, end unit townhome in prime Hugo neighborhood. Main level living area with vaulted ceilings and an abundance of natural light. Fantastic kitchen with newer stainless steel appliances (2022). Dining area steps out to deck overlooking wetland. Two bedrooms and two bathrooms up, including spacious primary with walk-in closet and ensuite bath. Walkout lower level features family room,

    Jennifer Ulrich Coldwell Banker Realty

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

    $300,000

    • 3 Beds
    • 2 Baths
    • 1,595 Sq Ft
    • 15424 Foster Dr N
    • Hugo, MN

    Here is a wonderful opportunity to live in a highly desired waters edge community. The home offers beautiful finishes throughout and awaits you to come and make it your own. Open main level, gives you great conversational spaces, the lower level has walk-out to patio, gas fireplace in the family room which allows for a cozy space to enjoy. The upper level gives you a couple of bedrooms with ample

    Kevin Folkerts Rocket Realty

    Section Image

Source: NorthstarMLS

MLS Number: 6192835

NorthstarMLS

APN: 18-031-21-44-0006