NOT LISTED FOR SALE

15413 Farnham Ave N Hugo, MN 55038

Estimated Value: $281,174 - $309,000

3 Beds
2 Baths
1,596 Sq Ft
$183/Sq Ft Est. Value

Last Sold August 28, 2014

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

Est. 80% increase in value since last sale

Current estimated payment $1,990/month

11 Days on Market

Highlights

  • Deck
  • Community Pool
  • 2 Car Attached Garage
  • Vaulted Ceiling
  • Formal Dining Room
  • Side by Side Parking

About This Home

As of August 2014

With one of the best set of amenities thru an assc you can find, this TH has it all! Super clean 3BR/2BA walkout with TONS of privacy in the back. Upstairs laundry, fabulous great room for entertaining, and a prime location. This one will not disappoint!!

Last Agent to Sell the Property

Matthew Lunde

Dwell Realty Partners, LLC Listed on: 07/24/2014

Last Buyer's Agent

James Sanchez

Real Estate by Owner

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $1,414

Year Built

  • Built in 2008

HOA Fees

  • $190 Monthly HOA Fees

Home Design

  • Brick Exterior Construction
  • Asphalt Shingled Roof
  • Vinyl Siding

Interior Spaces

  • Vaulted Ceiling
  • Ceiling Fan
  • Formal Dining Room

Kitchen

  • Range
  • Microwave
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Walk Through Bedroom
  • Walk-In Closet

Laundry

  • Dryer
  • Washer

Finished Basement

  • Walk-Out Basement
  • Partial Basement
  • Sump Pump

Parking

  • 2 Car Attached Garage
  • Side by Side Parking
  • Driveway

Outdoor Features

  • Deck
  • Patio

Utilities

  • Forced Air Heating and Cooling System
  • Water Softener is Owned

Listing and Financial Details

  • Assessor Parcel Number 1803121410121

Community Details

Overview

  • Association fees include exterior maintenance, shared amenities, snow removal, trash

Recreation

  • Community Pool

Home Details

Home Type

Single Family

Est. Annual Taxes

$1,414

Year Built

Built in 2008

Lot Details

0

HOA Fees

$190 per month

Listing Details

  • Type: Single Family
  • Class: SINGLE FAMILY
  • Classification: Homestead
  • Style: Side x Side
  • Amenities: Ceiling Fans, Vaulted Ceilings, Walk-In Closet, Washer/Dryer Hookups
  • Amenities Exterior: Deck, Driveway - Asphalt, Patio
  • Construction: Previously Owned
  • Foundation Size: 423
  • Mechanicals: Water Softener-Owned
  • Parcel Number: 1803121410121
  • Projected Closed Date: 08/28/2014
  • Taxes With Assessments: 1414
  • Comp Dev Subdiv Name: Waters Edge
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Dining Room: Combine with Kitchen, Formal Dining Room
  • Appliances: Dishwasher, Disposal, Dryer, Microwave, Range/Stove, Refrigerator, Washer
  • Total Bedrooms: 3
  • Bathroom Description: 3/4 Basement, Master Walk-Thru
  • Total Bathrooms: 2
  • Three Quarter Bathrooms: 1
  • Full Bathrooms: 1
  • Total Bathrooms: 2
  • Room 1: Living Room, 15x13, On Level: Main
  • Room 2: Dining Room, 10x10, On Level: Main
  • Room 3: Family Room, 14x13, On Level: Basement
  • Room 4: Kitchen, 9x9, On Level: Main
  • Room 5: Bedroom, 14x13, On Level: Upper
  • Room 6: Bedroom, 12x10, On Level: Upper
  • Room 7: 11x10, On Level: Basement
  • Basement Features: Finished, Sump Pump, Walkout
  • Basement Style: Partial, Walk-out
  • Finished Above Grade Sq Ft: 1173
  • Below Grade Finished Sq Ft: 423
  • Total Fin Square Footage: 1596

Exterior Features

  • Frontage Road: City, Paved
  • Exterior: Brick, Vinyl
  • Pool: Shared
  • Roof: Asphalt Shingles

Garage/Parking

  • Garage Type: Attached
  • Garage Capacity: 2

Utilities

  • Cooling: Central
  • Fuel: Natural Gas
  • Heat: Forced Air
  • Sewer: City
  • Water: City

Condo/Co-op/Association

  • HOA Fee Includes: Exterior Maintenance, Shared Amenities, Snow Removal, Trash
  • Association Fee Frequency: Monthly
  • Association Fee: Yes
  • Association Fee: 190

Schools

  • School District: White Bear Lake #624

Building Info

  • Year Built: 2008

Tax Info

  • Year: 2014
  • Tax Value: 1414

MLS Schools

  • School District: White Bear Lake #624

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Mar 28, 2019
Sold by
Celski Paul R and Celski Cynthia J
Bought by
Fallon Richard and Lindeman Sharleen R
Current Estimated Value
$291,544

Home Financials for this Owner

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

Purchase Details

Listed on
Jul 24, 2014
Closed on
Aug 19, 2014
Sold by
Miller Michael S and Miller Tracy I
Bought by
Celski Paul R and Celski Cynthia J
Seller's Agent
Matthew Lunde
Dwell Realty Partners, LLC
Buyer's Agent
James Sanchez
Real Estate by Owner
List Price
$159,900
Sold Price
$162,000
Premium/Discount to List
$2,100
1.31%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
5.25%
Original Mortgage
$129,600
Interest Rate
4.07%
Mortgage Type
New Conventional

Purchase Details

Closed on
Nov 26, 2008
Sold by
Pulte Homes Of Minnesota Llc
Bought by
Miller Michael S and Miller Tracy I

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$145,550
Interest Rate
6.04%
Mortgage Type
FHA
Source: Public Records

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
Fallon Richard $212,000 Titlesmart Inc
Celski Paul R $162,000 Stewart Title
Miller Michael S $146,340 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Fallon Richard $169,600
Previous Owner Celski Paul R $129,600
Previous Owner Miller Michael S $145,550
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/28/2014 08/28/14 Sold $162,000 +1.3% $102 / Sq Ft
08/04/2014 08/04/14 Pending -- -- --
07/24/2014 07/24/14 For Sale $159,900 -- $100 / Sq Ft
Source: REALTOR® Association of Southern Minnesota

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 $3,122 $271,800 $50,000 $221,800
2023 $3,122 $287,000 $65,000 $222,000
2022 $2,508 $255,800 $51,100 $204,700
2021 $2,482 $214,600 $42,500 $172,100
2020 $2,564 $211,500 $50,000 $161,500
2019 $2,130 $209,000 $45,000 $164,000
2018 $1,796 $193,000 $40,000 $153,000
2017 $1,614 $170,400 $20,000 $150,400
2016 $1,626 $154,400 $15,000 $139,400
2015 $1,798 $142,000 $17,300 $124,700
2013 -- $102,200 $11,000 $91,200
Source: Public Records

Agents Affiliated with this Home

See All Agents

Map

Source: REALTOR® Association of Southern Minnesota

MLS Number: 4651839

REALTOR® Association of Southern Minnesota

APN: 18-031-21-41-0121