NOT LISTED FOR SALE

3478 N Duquesne Way Aurora, CO 80019

Estimated Value: $539,206

3 Beds
2 Baths
1,775 Sq Ft
$304/Sq Ft Est. Value

Last Sold December 27, 2024

Last sale price $538,990 $304 Per Sq Ft

Current estimated payment $3,111/month

38 Days on Market

Highlights

  • New Construction
  • Bonus Room
  • Quartz Countertops
  • Located in a master-planned community
  • Great Room
  • Private Yard

About This Home

As of December 2024

MLS#2388344 Built by Taylor Morrison, Ready Now! Introducing the Sand Dune floorplan, which includes an unfinished basement (per lot-specific requirement) for an additional 1,338 sq. ft. of space. The Sand Dune paired home design is sure to impress. The kitchen, dining area, and great room are filled with natural light, featuring ample windows that showcase Colorado living at its finest. The spacious primary suite, located at the rear of the home, offers a walk-in closet and a 4-piece bath, while the main-floor laundry room provides the convenience of ranch-style living. Hosting guests? The secluded secondary bedroom and full bath at the front of the home offer both privacy and comfort. Structural options include: A/C unit, bedroom 3 in lieu of flex, 9' unfinished basement, 8'x 12' sliding glass door, and covered outdoor living.

Last Listed By

Tom Ullrich

RE/MAX Professionals Brokerage Phone: 303-799-9898 License #000986635 Listed on: 08/15/2024

RE/MAX Professionals

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $7,825

Year Built

  • Built in 2024 | New Construction

Lot Details

  • 4,800 Sq Ft Lot
  • Southwest Facing Home
  • Front Yard Sprinklers
  • Private Yard

HOA Fees

  • $100 Monthly HOA Fees

Parking

  • 2 Car Attached Garage

Home Design

  • Slab Foundation
  • Frame Construction
  • Composition Roof
  • Vinyl Siding

Interior Spaces

  • 1-Story Property
  • Wired For Data
  • Great Room
  • Dining Room
  • Bonus Room
  • Laundry Room

Kitchen

  • Eat-In Kitchen
  • Oven
  • Cooktop with Range Hood
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Quartz Countertops
  • Disposal

Flooring

  • Carpet
  • Laminate
  • Tile

Bedrooms and Bathrooms

  • 3 Main Level Bedrooms
  • 2 Full Bathrooms

Unfinished Basement

  • Sump Pump
  • Stubbed For A Bathroom

Home Security

  • Carbon Monoxide Detectors
  • Fire and Smoke Detector

Outdoor Features

  • Patio
  • Rain Gutters

Schools

  • Aurora Highlands Elementary And Middle School
  • Vista Peak High School

Utilities

  • Mini Split Air Conditioners
  • Heating System Uses Natural Gas
  • Tankless Water Heater
  • Cable TV Available

Listing and Financial Details

  • Assessor Parcel Number R0217380

Community Details

Overview

  • Association fees include trash
  • Aurora Highlands Community Authority Board Association, Phone Number (303) 779-5710
  • Built by Taylor Morrison
  • Aurora Highlands Subdivision, Sand Dune Floorplan
  • Landmark Collection Community
  • Located in a master-planned community

Recreation

  • Community Pool
  • Park
  • Trails

Home Details

Home Type

Single Family

Est. Annual Taxes

$7,825

Year Built

Built in 2024 | New Construction

Lot Details

0

HOA Fees

$100 per month

Parking

2

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Structure Type: Patio
  • Levels: One
  • Building Name: Landmark Collection
  • Year Built: 2024
  • Above Grade Finished Sq Ft: 1775
  • Exclusions: N/A
  • Living Area: 1775
  • Pets Allowed: Cats OK, Dogs OK
  • Property Condition: New Construction
  • Directions: Come to the Model and Sales Office located at 3402 N. Buchanan Way. Directions to our Sales Office: From the intersection of I-70 and E-470, head north on E-470. Take exit 22 “The Aurora Highlands Parkway” and turn right onto E 38th Place. Turn right on to Main Street. At the stop sign, continue straight ahead and take your second left onto E. 34th Ave. The sales office will be on your left off Buchanan Way.
  • SubdivisionName: Aurora Highlands
  • Ownership: Builder
  • Property Attached Yn: No
  • ResoBuildingAreaSource: Builder
  • REC_BasementLevelBathrooms: 0
  • REC_BasementLevelBedrooms: 0
  • REC_BelowGradeUnfinishedArea: 1386.00
  • REC_RVSpaces: 0
  • REC_UpperLevelBathrooms: 0
  • REC_UpperLevelBedrooms: 0
  • REC_WaterIncludedYN: 1
  • Ratio Close Price By Original Li: 0.96422
  • New Home Community URL: https://www.taylormorrison.com/co/denver/aurora/the-aurora-highlands-landmark-collection
  • Attribution Contact: 303-799-9898
  • Special Features: NewHome

Interior Features

  • Appliances: Cooktop, Dishwasher, Disposal, Microwave, Oven, Range Hood, Sump Pump, Tankless Water Heater
  • Interior Amenities: Eat-in Kitchen, Kitchen Island, Quartz Counters, Wired for Data
  • Flooring: Carpet, Laminate, Tile
  • Full Bathrooms: 2
  • Basement: Bath/Stubbed, Unfinished
  • Basement: Yes
  • Total Bedrooms: 3
  • Main Level Bathrooms: 2
  • Main Level Bedrooms: 3

Exterior Features

  • Direction Faces: Southwest
  • Foundation Details: Slab
  • Roof: Composition
  • Construction Materials: Frame, Vinyl Siding
  • Exterior Features: Private Yard, Rain Gutters
  • Patio and Porch Features: Patio

Garage/Parking

  • Parking Features: Concrete
  • Attached Garage: Yes
  • Garage Spaces: 2
  • Total Parking Spaces: 2
  • REC_ParkingCount: 1

Utilities

  • Utilities: Cable Available, Electricity Available, Natural Gas Available
  • Sewer: Public Sewer
  • Cooling: Air Conditioning-Room
  • Heating: Natural Gas
  • Water Source: Public
  • Laundry Features: In Unit
  • Security: Carbon Monoxide Detector(s), Smoke Detector(s)

Condo/Co-op/Association

  • HOA Fee Includes: Trash
  • Association Name: Aurora Highlands Community Authority Board
  • Association Fee Frequency: Monthly
  • Association Amenities: Park, Pool, Trail(s)
  • Association Fee: 100
  • Phone: 303-779-5710
  • Association: Yes
  • Senior Community: No

Association/Amenities

  • REC_AssociationFee2Annual: 0.00
  • REC_AssociationFee3Annual: 0.00
  • REC_AssociationFeeAnnual: 1200.00
  • REC_AssociationFeeTotalAnnual: 1200.00
  • REC_AssociationManagementType: Professionally Managed
  • REC_MultipleAssociationsYN: 0

Schools

  • Middle Or Junior School: Aurora Highlands

Lot Info

  • Horses: No
  • Parcel Number: R0217380
  • Lot Size Acres: 0.11
  • Building Area Total: 3161
  • Lot Features: Master Planned, Sprinklers In Front
  • Lot Size Sq Ft: 4800
  • ResoLotSizeUnits: SquareFeet

Building Info

  • Builder Name: Taylor Morrison

Tax Info

  • Tax Year: 2023
  • Tax Annual Amount: 7825

MLS Schools

  • Elementary School: Aurora Highlands
  • High School: Vista Peak

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Aug 15, 2024
Closed on
Dec 27, 2024
Sold by
Taylor Morrison Of Colorado Inc
Bought by
Leadon Natasha Neambe and Jeffries Anthony Louis
Seller's Agent
Tom Ullrich
RE/MAX Professionals
Buyer's Agent
Jenny Ford
Coldwell Banker Realty 24
List Price
$558,990
Sold Price
$538,990
Premium/Discount to List
-$20,000
-3.58%
Total Days on Market
38
Views
9
Current Estimated Value
$539,206

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$216
Avg. Annual Appreciation
0.12%
Original Mortgage
$529,227
Outstanding Balance
$527,860
Interest Rate
6.78%
Mortgage Type
FHA
Estimated Equity
$11,346

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
Leadon Natasha Neambe $538,990 None Listed On Document
Leadon Natasha Neambe $538,990 None Listed On Document
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Leadon Natasha Neambe $529,227
Closed Leadon Natasha Neambe $529,227
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
12/27/2024 12/27/24 Sold $538,990 0.0% $304 / Sq Ft
09/22/2024 09/22/24 Pending -- -- --
09/18/2024 09/18/24 Price Changed $538,990 -3.6% $304 / Sq Ft
08/15/2024 08/15/24 For Sale $558,990 -- $315 / 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
2024 $7 $22,380 $5,940 $16,440
2023 $7 $19,430 $19,430 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Similar Homes in Aurora, CO

  • 4072 N Rome St, Aurora, CO 80019

    $480,000

    • 3 Beds
    • 2.5 Baths
    • 2,300 Sq Ft
    • 4072 N Rome St
    • Aurora, CO

    Welcome home to this three bedroom, three bathroom home in Green Valley Ranch East! This charming home is only one year old, feels like new, and offers ample amounts of upgrades including a water softener, an upgraded outdoor patio and open staircases! Enjoy the bright, airy and open floor plan throughout. The gourmet kitchen offers laminate flooring, a large eat-in kitchen island, spacious

    Tatyana Sturm EXIT Realty DTC, Cherry Creek, Pikes Peak.

    Section Image
  • 247 N Coolidge Way, Aurora, CO 80018

    $610,000

    • 4 Beds
    • 3.5 Baths
    • 2,921 Sq Ft
    • 247 N Coolidge Way
    • Aurora, CO

    PREFERRED LENDER GIVING FREE NO FEE REFINANCING FOR LIFE OF THE LOAN - AND - .5% INTEREST RATE REDUCTION - SAVES YOU AROUND $170/MONTH ON A 500K LOAN*...some restrictions do apply.Charming 4-Bedroom Home with Finished Basement – 247 N Coolidge Way, Aurora - check out the 3D tour! ADA accessible home with ramp in garage (can be removed upon request).Welcome to this well maintained 4-bedroom,

    Hunter Deegan Orchard Brokerage LLC

    Section Image
  • 27862 E 9th Dr, Aurora, CO 80018

    $479,900

    • 3 Beds
    • 2 Baths
    • 1,726 Sq Ft
    • 27862 E 9th Dr
    • Aurora, CO

    Skip new construction...This home will far surpass your expectations and shows like a brand new home- without the headache and hassle of building!! Close proximity to I-70, e-470, and DIA! Thoughtfully optioned and upgraded to the 9's, you simply cannot go wrong with this home! A sprawling ranch home with upgrades as far as the eye can see from your solid surface flooring that flows from the

    Anthony Geraty Your Castle Real Estate Inc

    Section Image
  • 27891 E 7th Ave, Aurora, CO 80018

    $519,500

    • 3 Beds
    • 2.5 Baths
    • 2,066 Sq Ft
    • 27891 E 7th Ave
    • Aurora, CO

    NEW CONSTRUCTION CAN'T BEAT THIS INTEREST RATE!Two options to purchase this property with significant savings. OPTION 1: ASSUME THE LOAN ON THIS HOME. 3.75% INTEREST RATE. ASSUMABLE AMOUNT APPOXIMATELY $397,000 Mortgage Payment $3077.00. FROM CONTRACT TO CLOSE IN 45-60 DAYS. OPTION 2: Lender Credit 2/1 Buy Down being offered on this property through Three Point Mortgage. SELLER TO PAY OFF

    Barry Overton eXp Realty, LLC

    Section Image
  • 131 S Vandriver Way, Aurora, CO 80018

    $624,900

    • 5 Beds
    • 3 Baths
    • 2,585 Sq Ft
    • 131 S Vandriver Way
    • Aurora, CO

    VA 4.75% Assumable Loan available!!!!! Take advantage of this fantastic opportunity to pay a 4.75% interest rate! This beautiful property provides its new owners with many different financing options! This well-appointed five-bedroom, three-full-bathroom home is meticulously maintained and simply stunning to behold! Located in the coveted Harmony neighborhood, residents enjoy incredible

    Jane Knauf Metro Home Finders

    Section Image
  • 1066 S Eaton Park Ct, Aurora, CO 80018

    $600,000

    • 3 Beds
    • 2.5 Baths
    • 2,136 Sq Ft
    • 1066 S Eaton Park Ct
    • Aurora, CO

    Welcome to this stunning single-family home located in the desirable Waterstone community of Aurora, Colorado. This spacious residence offers 3 bedrooms, 2 full bathrooms, and 1 half bathroom, all within an impressive 2,136 square feet. With a two-car garage and a beautifully designed layout, this home is perfect for families seeking comfort and style in a suburban setting.As you enter,

    Barry Overton eXp Realty, LLC

    Section Image
  • 1342 S Andes St, Aurora, CO 80017

    $490,000

    • 4 Beds
    • 2 Baths
    • 1,754 Sq Ft
    • 1342 S Andes St
    • Aurora, CO

    Beautifully remodeled home offering a perfect blend of modern upgrades and timeless charm, situated in a prime location near parks, trails, and top-rated amenities.Step inside to discover an open and airy floor plan with luxury vinyl plank flooring, fresh neutral paint, and stylish finishes throughout. The updated kitchen is a chef’s dream, featuring sleek quartz countertops, stainless steel

    Kristina Davis eXp Realty, LLC

    Section Image
  • 891 Ursula St, Aurora, CO 80011

    $539,900

    • 3 Beds
    • 2 Baths
    • 1,857 Sq Ft
    • 891 Ursula St
    • Aurora, CO

    Fantastic brick ranch home with a detached 2.5 car garage as well as a 1 car attached garage! This home has been in the same family for over 50 years, and the attention to detail and upgrades make it stand out from the rest. The brand new roof was installed in 2025, and the kitchen has upgraded cabinets, granite countertops, new luxury flooring, high end stainless steel appliances and more. A

    Mike Hardey Integrity Real Estate Group

    Section Image
  • 2822 S Genoa St, Aurora, CO 80013

    $454,900

    • 3 Beds
    • 2 Baths
    • 1,300 Sq Ft
    • 2822 S Genoa St
    • Aurora, CO

    SHORT SALE Tremendous Potential in Sought After Seven Hills!This traditional tri-level home offers an excellent opportunity for buyers looking to add value with a bit of vision and care. While the property is in a rougher stage and could benefit from some cosmetic updates, the necessary improvements are mostly minor and primarily aesthetic making this an ideal home for someone ready to

    Gustavo Molina Jr. Keller Williams 1st Realty

    Section Image

Source: REcolorado®

MLS Number: 2388344

REcolorado®

APN: 1819-30-2-08-003