NOT LISTED FOR SALE

15974 Ethan Trail N Hugo, MN 55038

Estimated Value: $699,000 - $856,000

4 Beds
5 Baths
4,165 Sq Ft
$189/Sq Ft Est. Value

Last Sold July 24, 2023

Last sale price $850,000 $204 Per Sq Ft

Est. 7% decrease in value since last sale

Current estimated payment $5,163/month

12 Days on Market

Highlights

  • Home Theater
  • Family Room with Fireplace
  • Home Office
  • Heated In Ground Pool
  • Screened Porch
  • Stainless Steel Appliances

About This Home

As of July 2023

Welcome to your dream home! This exquisite 4-bedroom, 5-bathroom residence boasts an array of desirable features that will make every day a delight. Step inside and be greeted by the grandeur of vaulted ceilings, creating an open and airy ambiance throughout the house. Sunlight pours in through large windows, showcasing the spacious rooms and highlighting the beautiful architectural details. Entertain guests in style with a well-appointed wet bar, perfect for serving refreshing beverages and hosting memorable gatherings. Step outside to discover a haven of relaxation in your own backyard oasis, complete with an inviting in-ground heated pool. The meticulously manicured landscaping enhances the natural beauty of the property, providing a picturesque backdrop for outdoor activities and peaceful moments of serenity, or fun in the sun with a built in sound system. This home is nestled in a charming small town, offering a sense of community while still providing easy access to main roads.

Last Listed By

Jason Gorman

Keller Williams Premier Realty Listed on: 06/20/2023

Keller Williams Premier Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $8,756

Year Built

  • Built in 2017

Lot Details

  • 10,629 Sq Ft Lot
  • Lot Dimensions are 82x130x82x130
  • Property has an invisible fence for dogs
  • Property is Fully Fenced
  • Few Trees

HOA Fees

  • $15 Monthly HOA Fees

Parking

  • 3 Car Attached Garage
  • Insulated Garage
  • Garage Door Opener

Interior Spaces

  • 2-Story Property
  • Stone Fireplace
  • Brick Fireplace
  • Family Room with Fireplace
  • 2 Fireplaces
  • Living Room with Fireplace
  • Home Theater
  • Home Office
  • Screened Porch
  • Utility Room Floor Drain

Kitchen

  • Built-In Oven
  • Cooktop
  • Microwave
  • Dishwasher
  • Stainless Steel Appliances
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms

Laundry

  • Dryer
  • Washer

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Drain
  • Natural lighting in basement

Utilities

  • Forced Air Zoned Cooling and Heating System
  • Humidifier

Additional Features

  • Air Exchanger
  • Heated In Ground Pool

Community Details

  • Prairie Village HOA, Phone Number (651) 735-7653
  • Prairie Village 4Th Add Subdivision

Listing and Financial Details

  • Assessor Parcel Number 1803121210067

Home Details

Home Type

Single Family

Est. Annual Taxes

$8,756

Year Built

Built in 2017

Lot Details

0

HOA Fees

$15 per month

Parking

3

Listing Details

  • Type: Residential
  • Property Subtype 1: Single Family Residence
  • Cooling System: Central Air, Zoned
  • Garage Spaces: 3
  • Accessibility Features: None
  • Fireplaces: 2
  • Water Source: City Water/Connected
  • Fee Frequency: Annually
  • Year Built: 2017
  • Above Grade Finished Sq Ft: 2967
  • Unit Levels: Two
  • New Construction: No
  • FractionalOwnershipYN: No
  • Rental License?: No
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Basement: Daylight/Lookout Windows, Drain Tiled, Finished, Full, Concrete, Walkout
  • Appliances: Air-To-Air Exchanger, Cooktop, Dishwasher, Disposal, Dryer, Exhaust Fan, Humidifier, Microwave, Refrigerator, Stainless Steel Appliances, Wall Oven, Washer, Water Softener Owned
  • Fireplace Features: Brick, Family Room, Gas, Living Room, Stone
  • Living Area: 4165
  • Below Grade Finished Sq Ft: 1198
  • Basement YN: Yes
  • Dining Room Type: Living Room, Dining Room, Family Room, Kitchen, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4, Media Room, Den, Office, Mud Room, Screened Porch, Laundry
  • SqFtTotal: 4165.00

Beds/Baths

  • Half Bathrooms: 1
  • Total Bedrooms: 4
  • One Quarter Bathrooms: 1
  • Three Quarter Bathrooms: 3

Exterior Features

  • Roof: Age 8 Years or Less, Asphalt
  • PoolFeatures: Below Ground, Heated, Outdoor Pool
  • Fencing: Full, Invisible
  • Other Structures: Gazebo, Storage Shed

Garage/Parking

  • Parking Features: Attached Garage, Asphalt, Floor Drain, Garage Door Opener, Insulated Garage
  • Garage Square Feet: 500

Utilities

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

Condo/Co-op/Association

  • HOA Fee Includes: Other
  • Phone: 651-735-7653
  • Association Fee: 180
  • Association: Yes
  • Amenities Unit: Ceiling Fan(s),French Doors,Kitchen Center Island,Primary Bedroom Walk-In Closet,Patio,Porch,In-Ground Sprinkler,Tile Floors,Vaulted Ceiling(s),Washer/Dryer Hookup,Wet Bar,Walk-In Closet

Association/Amenities

  • HOA Management Co: Prairie Village HOA

Schools

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

Lot Info

  • PropertyAttachedYN: No
  • Lot Size: 82x130x82x130
  • Lot Size Sq Ft: 10628.64
  • Land Lease: No
  • Lot Features: Tree Coverage - Light
  • Additional Parcels: No
  • Zoning Description: Residential-Single Family
  • ResoLotSizeUnits: Acres
  • AssessmentPending: Unknown
  • Yearly/Seasonal: Yearly

Building Info

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

Tax Info

  • Tax Year: 2023
  • Assessor Parcel Number: 1803121210067
  • Tax Annual Amount: 8756
  • TaxWithAssessments: 8756.0000

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jun 20, 2023
Closed on
Jul 24, 2023
Sold by
Rosewell Todd and Rosewell Rebecca
Bought by
Backus David
Seller's Agent
Jason Gorman
Keller Williams Premier Realty
Buyer's Agent
David Fry
eXp Realty
List Price
$850,000
Sold Price
$850,000
Total Days on Market
12
Views
51
Current Estimated Value
$786,705

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$63,295
Avg. Annual Appreciation
-4.14%
Original Mortgage
$680,000
Outstanding Balance
$667,550
Interest Rate
6.71%
Mortgage Type
New Conventional
Estimated Equity
$119,155

Purchase Details

Closed on
Apr 28, 2017
Sold by
Sharper Homes Inc
Bought by
Rosewell Todd J and Rosewell Rebecca R

Home Financials for this Owner

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

Purchase Details

Closed on
May 12, 2016

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$658,000
Interest Rate
3.57%

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

Similar Homes in the area

  • 16123 Europa Ave N, Hugo, MN 55038

    $749,900

    • 5 Beds
    • 4.5 Baths
    • 4,026 Sq Ft
    • 16123 Europa Ave N
    • Hugo, MN

    Our popular Cape Cod two story plan features a main floor office/den, family room with cozy stone front gas fireplace and built ins, dining room w/door leading to a future deck, gourmet kitchen w/tech center & walk in pantry, center island w/ breakfast bar, quartz & granite tops, built in oven, gas cooktop, mud room with walk-in closet and custom lockers. Upper level w/ four bedrooms & loft, 1

    Andrew Prasky RE/MAX Advantage Plus

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

    $644,900

    • 6 Beds
    • 5 Baths
    • 4,722 Sq Ft
    • 4918 162nd St N
    • Hugo, MN

    Welcome to the popular Water Stone floor plan with Capstone Homes in Hugo! Quick move-in available! This 4,722 sq.ft. home is placed on an east facing cul-de-sac homesite with sunsets to enjoy each evening out the back windows of the home! Some of the many desired features of this home include: gourmet kitchen, main level bedroom and full bathroom, extremely spacious floor plan, owner’s suite

    Ryan Fleck Capstone Realty, LLC

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

    $599,900

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

    Welcome to YOUR 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 every back

    Kathryn Johnson eXp Realty

    Section Image
  • 5910 Freeland Alcove N, Hugo, MN 55038

    $928,013

    • 5 Beds
    • 5 Baths
    • 4,345 Sq Ft
    • 5910 Freeland Alcove N
    • Hugo, MN

    Amazing opportunity featuring award winning Mahtomedi schools. Home under construction with estimated completion Summer 2025. The Walton floor plan is a spacious 2-story home offering a finished lower level perfect for entertaining with a oversized rec room, game area, guest bedroom plus a bonus bath and exercise room. The spacious upper level is sure to please featuring 4 large bedrooms,

    Cameron Monson RE/MAX Results

    Section Image
  • 5927 131st Ct N, Hugo, MN 55038

    $825,000

    • 5 Beds
    • 4.5 Baths
    • 4,229 Sq Ft
    • 5927 131st Ct N
    • Hugo, MN

    This 5BR/5BA home with a state of the art, two story indoor sport court behind the 3 car garage. The upper level has 4 BR's. Owner's suite with tiled luxury bath tub/shower with glass doors. Spacious walk in closet with custom closet built ins, with double undermount sinks quartz counter tops. Laundry is adjacent to the owner's suite for convenience & has extra space for hang drying or other

    Jim Ertz DF & Company, Inc

    Section Image
  • 6073 131st St N, Hugo, MN 55110

    $857,520

    • 5 Beds
    • 4.5 Baths
    • 4,361 Sq Ft
    • 6073 131st St N
    • Hugo, MN

    **LAST OPPORTUNITY to Join the Award Winning Community of Adelaide Landing.** This quick move in home has a scheduled completion date of June 20th and is the last available Robert Thomas Homes new build in the community. A Gorgeous 5BR/4.5BA “St Croix” includes the high-quality finishes incorporated into all Robert Thomas homes plus our most popular options like a Gourmet Kitchen with hand

    Allison Jensen Robert Thomas Homes, Inc.

    Section Image
  • 1546 Meadowview Ct, Hugo, MN 55038

    $819,900

    • 6 Beds
    • 4.5 Baths
    • 5,476 Sq Ft
    • 1546 Meadowview Ct
    • Hugo, MN

    Welcome to this stunning, meticulously cared-for home, ideally located at the end of a peaceful cul-de-sac, offering unmatched privacy with no neighbors behind and picturesque pond views. This exceptional residence has every feature you could desire! Upon entering, you're welcomed by impressive two-story ceilings in the foyer and living room, highlighted by expansive floor-to-ceiling windows that

    Shawn Wilson POP Realty MN

    Section Image
  • 8013 Glenwood Dr, Lino Lakes, MN 55014

    $909,007

    • 5 Beds
    • 4.5 Baths
    • 3,917 Sq Ft
    • 8013 Glenwood Dr
    • Lino Lakes, MN

    Welcome to the Alexander model in Nature's Refuge. This home features 5 bedrooms, 4.5 bathrooms with tons of charm, and 3,917 square feet of living space. The exterior of this home has a covered patio with stone veneer accents, James Hardie® siding in different shades of blue, and white trim around the windows.Enter the home through the front door and you will notice the expansive

    Section Image

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
Backus David $850,000 --
Rosewell Todd J $571,781 Land Title Inc
-- $770,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Backus David $680,000
Previous Owner Rosewell Todd J $55,000
Previous Owner Rosewell Todd J $457,427
Previous Owner -- $658,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
07/24/2023 07/24/23 Sold $850,000 0.0% $204 / Sq Ft
07/03/2023 07/03/23 Pending -- -- --
06/20/2023 06/20/23 For Sale $850,000 -- $204 / 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 $9,438 $761,600 $121,500 $640,100
2022 $6,892 $718,300 $126,200 $592,100
2021 $6,950 $540,200 $100,000 $440,200
2020 $7,360 $540,200 $100,000 $440,200
2019 $6,216 $547,000 $96,000 $451,000
2018 $1,354 $514,100 $96,000 $418,100
2017 $586 $96,000 $96,000 $0
2016 $318 $79,800 $79,800 $0
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: NorthstarMLS

MLS Number: 6390136

NorthstarMLS

APN: 18-031-21-21-0067