NOT LISTED FOR SALE

5501 Mustang Dr Frederick, CO 80504

Estimated Value: $719,414 - $789,000

4 Beds
4 Baths
4,516 Sq Ft
$166/Sq Ft Est. Value

Last Sold June 04, 2024

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

Est. 3% increase in value since last sale

Current estimated payment $4,364/month

13 Days on Market

Highlights

  • Outdoor Pool
  • Open Floorplan
  • Contemporary Architecture
  • Primary Bedroom Suite
  • Deck
  • Great Room with Fireplace

About This Home

As of June 2024

Step into luxury with this expansive 4500 Sq FT Ranch with 620 Sq Ft Finished Garage, New Carpet, Paint & Refinished Hardwood Floors, 2 Primary Suites, 2 Full Kitchens, 2 Laundry Rooms, 2 Fireplaces, 4 Beds & 4 Baths, Office, Great Room, Excercise Room, Media Room, Bar, Dinning Room, Play Room, Extended Lentgh Driveway, Corner Lot, Full Patio, Custom Pergola Gas Rough In For Outdoor Kitchen & More. *NO Metro District* Located Next To Bella Rosa Golf Course & Milavec Lake and community paths just out the door, you will Love The Quick Access To Trails, pool & Lake & Extra Parking On This Corner Lot & The Moore Farms Community & Pool. Ask About The Town Of Frederick Plans For Milavec Lake Receration Expansion.This amazing home, combines modern elegance with family-friendly comfort. The interior features a grand entryway that leads into a bright and open floor plan, connecting a sophisticated living room, formal dining area, with sleek granite countertops, and a large island that makes cooking and entertaining a delight. Outside, the property boasts a meticulously landscaped backyard complete with a charming patio area, ideal for outdoor gatherings and enjoying serene views. The front of the home is equally impressive with its inviting curb appeal. This home is situated in a peaceful, family-oriented neighborhood, with easy access to local parks, hiking trails, and recreational facilities, promoting an active and engaged lifestyle. The community is known for its safety, cleanliness, and friendly atmosphere. Agent Owned for easy sale and close.

Last Agent to Sell the Property

Robert Oakley

HomeSmart Brokerage Email: contracts@yourhomesourceteam.com,720-545-3135 License #100068910 Listed on: 04/26/2024

HomeSmart

Last Buyer's Agent

Linda Nehls

RE/MAX of Boulder License #40043145

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $4,446

Year Built

  • Built in 2015 | Remodeled

Lot Details

  • 8,248 Sq Ft Lot
  • Partially Fenced Property
  • Corner Lot
  • Front and Back Yard Sprinklers

HOA Fees

  • $58 Monthly HOA Fees

Parking

  • 3 Car Attached Garage
  • Insulated Garage
  • Lighted Parking
  • Dry Walled Garage
  • Smart Garage Door

Home Design

  • Contemporary Architecture
  • Frame Construction
  • Composition Roof
  • Cement Siding
  • Stone Siding
  • Radon Mitigation System
  • Concrete Perimeter Foundation

Interior Spaces

  • 1-Story Property
  • Open Floorplan
  • Wet Bar
  • Sound System
  • Wired For Data
  • Built-In Features
  • Bar Fridge
  • Vaulted Ceiling
  • Ceiling Fan
  • Gas Fireplace
  • Double Pane Windows
  • Window Treatments
  • Entrance Foyer
  • Smart Doorbell
  • Great Room with Fireplace
  • Living Room with Fireplace
  • Recreation Room

Kitchen

  • Eat-In Kitchen
  • Double Self-Cleaning Oven
  • Microwave
  • Dishwasher
  • Wine Cooler
  • Kitchen Island
  • Granite Countertops
  • Quartz Countertops
  • Corian Countertops
  • Disposal

Flooring

  • Wood
  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 4 Bedrooms | 3 Main Level Bedrooms
  • Primary Bedroom Suite
  • Walk-In Closet
  • In-Law or Guest Suite

Finished Basement

  • Basement Fills Entire Space Under The House
  • Sump Pump
  • Fireplace in Basement
  • 1 Bedroom in Basement

Home Security

  • Carbon Monoxide Detectors
  • Fire and Smoke Detector

Outdoor Features

  • Outdoor Pool
  • Deck
  • Covered Patio or Porch
  • Rain Gutters

Schools

  • Legacy Elementary School
  • Thunder Valley Middle School
  • Frederick High School

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Gas Water Heater
  • High Speed Internet

Additional Features

  • Garage doors are at least 85 inches wide
  • Smoke Free Home

Listing and Financial Details

  • Exclusions: Washers, Dryers, Wall Mounted TVs, Freezer In Basement Kitchen
  • Assessor Parcel Number R1995303

Community Details

Overview

  • Association fees include ground maintenance
  • Moore Farms Community Associate Association, Phone Number (303) 420-4433
  • Built by D.R. Horton, Inc
  • Moore Farm Subdivision

Recreation

  • Community Playground
  • Community Pool
  • Trails

Home Details

Home Type

Single Family

Est. Annual Taxes

$4,446

Year Built

Built in 2015 | Remodeled

Lot Details

0

HOA Fees

$58 per month

Parking

3

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Architectural Style: Contemporary
  • Structure Type: House
  • Levels: One
  • Year Built: 2015
  • Above Grade Finished Sq Ft: 2288
  • Exclusions: Washers, Dryers, Wall Mounted TVs, Freezer In Basement Kitchen
  • Living Area: 4516
  • Pets Allowed: Yes
  • Property Condition: Updated/Remodeled
  • SubdivisionName: Moore Farm
  • Ownership: Agent Owner
  • Property Attached Yn: No
  • ResoBuildingAreaSource: PublicRecords
  • REC_BasementLevelBedrooms: 1
  • REC_BelowGradeUnfinishedArea: 44.00
  • REC_ExpectedActiveDate: 2024-04-26
  • REC_RVSpaces: 0
  • REC_UpperLevelBathrooms: 0
  • REC_UpperLevelBedrooms: 0
  • REC_WaterIncludedYN: 1
  • Ratio Close Price By Original Li: 0.99055
  • Special Features: VirtualTour

Interior Features

  • Appliances: Bar Fridge, Dishwasher, Disposal, Double Oven, Gas Water Heater, Microwave, Refrigerator, Self Cleaning Oven, Sump Pump, Wine Cooler
  • Interior Amenities: Built-in Features, Ceiling Fan(s), Corian Counters, Eat-in Kitchen, Entrance Foyer, Five Piece Bath, Granite Counters, High Ceilings, High Speed Internet, In-Law Floor Plan, Kitchen Island, Open Floorplan, Pantry, Primary Suite, Quartz Counters, Radon Mitigation System, Smoke Free, Solid Surface Counters, Sound System, Vaulted Ceiling(s), Walk-In Closet(s), Wet Bar, Wired for Data
  • Flooring: Carpet, Tile, Wood
  • Fireplace Features: Basement, Gas, Great Room, Living Room, Recreation Room
  • Full Bathrooms: 3
  • Basement: Finished, Full, Sump Pump
  • Basement: Yes
  • Three Quarter Bathrooms: 1
  • Total Bedrooms: 4
  • Below Grade Sq Ft: 2228
  • Main Level Bathrooms: 2
  • Main Level Bedrooms: 3
  • Window Features: Double Pane Windows, Window Coverings, Window Treatments

Exterior Features

  • Foundation Details: Concrete Perimeter
  • Roof: Composition
  • Construction Materials: Cement Siding, Frame, Stone
  • Exterior Features: Gas Valve, Rain Gutters
  • Patio and Porch Features: Covered, Deck, Front Porch, Patio
  • Pool Features: Outdoor Pool
  • Road Frontage Type: Public

Garage/Parking

  • Parking Features: Concrete, Dry Walled, Finished, Insulated Garage, Lighted, Oversized, Oversized Door, Smart Garage Door
  • Attached Garage: Yes
  • Garage Spaces: 3
  • Total Parking Spaces: 7

Utilities

  • Sewer: Public Sewer
  • Cooling: Central Air
  • Heating: Forced Air, Natural Gas
  • Water Source: Public
  • Security: Carbon Monoxide Detector(s), Smoke Detector(s), Video Doorbell

Condo/Co-op/Association

  • HOA Fee Includes: Maintenance Grounds
  • Association Name: Moore Farms Community Associate
  • Association Fee Frequency: Quarterly
  • Association Amenities: Playground, Pool, Trail(s)
  • Association Fee: 173.25
  • Phone: 303-420-4433
  • Association: Yes
  • Senior Community: No

Association/Amenities

  • REC_AssociationFee2Annual: 0.00
  • REC_AssociationFee3Annual: 0.00
  • REC_AssociationFeeAnnual: 693.00
  • REC_AssociationFeeTotalAnnual: 693.00
  • REC_AssociationManagementType: Professionally Managed
  • REC_AssociationURL: https://app.payhoa.com/

Schools

  • Middle Or Junior School: Thunder Valley

Lot Info

  • Parcel Number: R1995303
  • Lot Size Acres: 0.19
  • Fencing: Partial
  • Building Area Total: 4560
  • Lot Features: Corner Lot, Sprinklers In Front, Sprinklers In Rear
  • Lot Size Sq Ft: 8248
  • ResoLotSizeUnits: SquareFeet

Building Info

  • Builder Name: D.R. Horton, Inc

Tax Info

  • Tax Year: 2023
  • Tax Annual Amount: 4446

MLS Schools

  • Elementary School: Legacy
  • High School: Frederick

Matterport 3D Tour

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Apr 26, 2024
Closed on
Jun 4, 2024
Sold by
Oakley Robert and Oakley Paula F
Bought by
Mackuse Lucy and Mackuse Stephen
Seller's Agent
Robert Oakley
HomeSmart
Buyer's Agent
Linda Nehls
RE/MAX of Boulder
List Price
$739,995
Sold Price
$733,000
Premium/Discount to List
-$6,995
-0.95%
Views
28
Current Estimated Value
$757,241

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$24,241
Avg. Annual Appreciation
1.44%
Original Mortgage
$560,000
Outstanding Balance
$553,056
Interest Rate
7.17%
Mortgage Type
New Conventional
Estimated Equity
$197,048

Purchase Details

Listed on
Apr 26, 2024
Closed on
Apr 24, 2024
Sold by
Burks Allison B
Bought by
Burks Family Trust and Burks
Seller's Agent
Robert Oakley
HomeSmart
Buyer's Agent
Linda Nehls
RE/MAX of Boulder
List Price
$739,995
Sold Price
$733,000
Premium/Discount to List
-$6,995
-0.95%
Views
28

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$560,000
Outstanding Balance
$553,056
Interest Rate
7.17%
Mortgage Type
New Conventional
Estimated Equity
$197,048

Purchase Details

Listed on
Dec 16, 2015
Closed on
Feb 25, 2016
Sold by
Melody Homes Inc
Bought by
Oakley Robert and Oakley Paula F
Seller's Agent
Jodi Bright
DR Horton Realty LLC
Buyer's Agent
Aaron Kassal
Better Homes and Gardens Real Estate - Neuhaus
List Price
$445,041
Sold Price
$413,685
Premium/Discount to List
-$31,356
-7.05%

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.15%
Original Mortgage
$393,000
Interest Rate
3.92%
Mortgage Type
New Conventional
Source: Public Records
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
Mackuse Lucy $733,000 Homestead Title
Burks Family Trust -- None Listed On Document
Oakley Robert $413,685 Heritage Title Co
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Mackuse Lucy $560,000
Previous Owner Oakley Robert $393,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
06/04/2024 06/04/24 Sold $733,000 -0.3% $162 / Sq Ft
05/10/2024 05/10/24 Price Changed $734,995 -0.7% $163 / Sq Ft
04/26/2024 04/26/24 For Sale $739,995 +78.9% $164 / Sq Ft
01/28/2019 01/28/19 Off Market $413,685 -- --
02/25/2016 02/25/16 Sold $413,685 -7.0% $96 / Sq Ft View Prior Sale
01/10/2016 01/10/16 Pending -- -- --
12/16/2015 12/16/15 For Sale $445,041 -- $103 / Sq Ft
Source: REcolorado®

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
2025 $4,636 $47,350 $7,190 $40,160
2024 $4,446 $48,210 $9,050 $39,160
2023 $4,446 $48,670 $9,130 $39,540
2022 $3,762 $36,050 $6,600 $29,450
2021 $3,799 $37,090 $6,790 $30,300
2020 $3,805 $37,450 $6,080 $31,370
2019 $3,861 $37,450 $6,080 $31,370
2018 $3,005 $30,250 $6,120 $24,130
2017 $3,071 $30,250 $6,120 $24,130
2016 $2,963 $28,710 $5,570 $23,140
2015 $2,031 $20,300 $20,300 $0
2014 $816 $8,160 $8,160 $0
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: REcolorado®

MLS Number: 4149269

REcolorado®

APN: R1995303