NOT LISTED FOR SALE

15022 Farnham Ave N Hugo, MN 55038

Estimated Value: $275,000 - $293,000

2 Beds
1.5 Baths
1,850 Sq Ft
$155/Sq Ft Est. Value

Last Sold May 08, 2023

Last sale price $265,000 $143 Per Sq Ft

Est. 8% increase in value since last sale

Current estimated payment $2,118/month

36 Days on Market

Highlights

  • Loft
  • Forced Air Heating and Cooling System
  • Family Room
  • The kitchen features windows
  • Combination Dining and Living Room

About This Home

As of May 2023

Welcome to easy living! This beautiful townhome has all the space you need with a few wonderful conveniences and shared amenities too! You'll enjoy the large master bedroom, walkthrough bath and the loft up. The open concept main level with the cozy balcony for BBQ's and peaceful relaxation! New floor and freshly painted through whole house, ready to move in. The development offers plenty of walking trails in picturesque surroundings along with a club house, pool and playground. This one won't last, book your showing today!

Last Listed By

Nicole Wang

RE/MAX Results Listed on: 04/01/2023

RE/MAX Results

Townhouse Details

Home Type

  • Townhome

Est. Annual Taxes

  • $3,052

Year Built

  • Built in 2006

Lot Details

  • 1,307

HOA Fees

  • $265 Monthly HOA Fees

Parking

  • 2 Car Garage
  • Tuck Under Garage

Interior Spaces

  • 2-Story Property
  • Family Room
  • Combination Dining and Living Room
  • Loft
  • Finished Basement
  • Natural lighting in basement

Kitchen

  • Range
  • Microwave
  • Dishwasher
  • Disposal
  • The kitchen features windows

Bedrooms and Bathrooms

  • 2 Bedrooms

Laundry

  • Dryer
  • Washer

Utilities

  • 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
  • Guaghan Association Management Association, Phone Number (651) 407-7047
  • Waters Edge South Subdivision

Listing and Financial Details

  • Assessor Parcel Number 1803121440009

Townhouse Details

Home Type

Townhome

Est. Annual Taxes

$3,052

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: 1490
  • 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
  • Appliances: Dishwasher, Disposal, Dryer, Microwave, Range, Refrigerator, Washer
  • Living Area: 1850
  • Fireplace: No
  • Below Grade Finished Sq Ft: 360
  • Basement YN: Yes
  • Dining Room Type: Living Room, Dining Room, Family Room, Kitchen, Bedroom 1, Bedroom 2, Loft
  • SqFtTotal: 1850.00

Beds/Baths

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

Garage/Parking

  • Parking Features: Tuckunder Garage
  • Garage Square Feet: 500

Utilities

  • Heating: Forced Air
  • Sewer: City Sewer/Connected
  • Fuel: Electric,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: 651-407-7047
  • Association Fee: 265
  • Association: Yes
  • Amenities Unit: Balcony,Kitchen Window

Association/Amenities

  • HOA Management Co: Guaghan Association Management

Schools

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

Lot Info

  • PropertyAttachedYN: Yes
  • Lot Size: 0
  • Land Lease: No
  • Additional Parcels: No
  • Zoning Description: Residential-Single Family
  • ResoLotSizeUnits: Acres
  • AssessmentPending: Unknown
  • Yearly/Seasonal: Yearly

Building Info

  • Construction Materials: Brick/Stone, Vinyl Siding

Tax Info

  • Tax Year: 2023
  • Assessor Parcel Number: 1803121440009
  • Tax Annual Amount: 3052
  • TaxWithAssessments: 3052.0000

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Apr 1, 2023
Closed on
May 8, 2023
Sold by
Tseng Carl
Bought by
Ambrose Carolyn
Seller's Agent
Nicole Wang
RE/MAX Results
Buyer's Agent
Ryan Ecklund
Coldwell Banker Realty
List Price
$265,000
Sold Price
$265,000
Total Days on Market
36
Views
125
Current Estimated Value
$286,128

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$21,128
Avg. Annual Appreciation
3.95%
Original Mortgage
$198,750
Outstanding Balance
$194,706
Interest Rate
6.42%
Mortgage Type
New Conventional
Estimated Equity
$91,422

Purchase Details

Listed on
Apr 1, 2023
Closed on
May 2, 2023
Sold by
Tseng Carl
Bought by
Ambrose Carolyn Sue
Seller's Agent
Nicole Wang
RE/MAX Results
Buyer's Agent
Ryan Ecklund
Coldwell Banker Realty
List Price
$265,000
Sold Price
$265,000
Views
125

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$198,750
Outstanding Balance
$194,706
Interest Rate
6.42%
Mortgage Type
New Conventional
Estimated Equity
$91,422

Purchase Details

Closed on
Sep 29, 2006
Sold by
Pulte Homes Of Minnesota Corp
Bought by
Tseng Carl

Home Financials for this Owner

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

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
Ambrose Carolyn $265,000 --
Ambrose Carolyn Sue $265,000 Watermark Title
Tseng Carl $164,990 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Ambrose Carolyn $198,750
Closed Ambrose Carolyn Sue $198,750
Previous Owner Tseng Carl $1,913,800
Previous Owner Tseng Carl $128,275
Previous Owner Tseng Carl $131,992
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
05/09/2023 05/09/23 Pending -- -- --
05/08/2023 05/08/23 Sold $265,000 0.0% $143 / Sq Ft
04/01/2023 04/01/23 For Sale $265,000 -- $143 / 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,104 $290,700 $62,000 $228,700
2022 $2,806 $266,200 $48,100 $218,100
2021 $2,722 $223,300 $40,000 $183,300
2020 $2,786 $214,800 $40,000 $174,800
2019 $2,254 $210,600 $35,000 $175,600
2018 $1,990 $187,200 $30,000 $157,200
2017 $1,904 $169,300 $20,000 $149,300
2016 $1,992 $160,100 $15,000 $145,100
2015 $2,118 $172,600 $20,000 $152,600
2013 -- $140,900 $13,800 $127,100
Source: Public Records

Agents Affiliated with this Home

  • 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: 6347737

NorthstarMLS

APN: 18-031-21-44-0009