NOT LISTED FOR SALE

Estimated Value: $628,000 - $749,469

5 Beds
3 Baths
1,469 Sq Ft
$461/Sq Ft Est. Value

Sale Details

Date Sold: May 21, 2025

Last sale price $775,000 $528 Per Sq Ft

Est. 12% decrease in value since last sale

Current estimated payment $4,108 / mo

9 Days on Market

Highlights

  • Spa
  • Furnished
  • No HOA
  • Wood Flooring
  • Private Yard
  • Covered Patio or Porch

About This Home

As of May 2025

Turnkey STR with Storybook Charm & Serious Income - Welcome to Mid Summer Night’s Dream, a fully operational and beautifully curated short-term rental that blends effortless ownership with enchanting guest appeal. This 5-bedroom, 3-bathroom home sleeps up to 16 and has consistently delivered outstanding returns — grossing over $120,000/year with a 4.85 Airbnb rating and 72 glowing reviews.

Located just 14 miles from Downtown Denver, 12 miles from Red Rocks, and 19 miles from Boulder, this home draws a steady stream of vacationers, concertgoers, and family groups year-round. Every inch has been thoughtfully upgraded to support high-volume bookings and smooth management — including a new AC, furnace, water heater, and fully fenced yard, low-maintenance landscaping. The current owner has invested in systems and design that cater specifically to short-term rental success, including a partitioned owners closet, dual stackable washer and dryers in the laundry area, plus an additional dryer in the garage for fast and efficient turnover. Smart home features include a security system, smart lock, noise monitoring devices, and WiFi-enabled thermostats for remote management.

Guests return again and again for the home's immersive experience — including a dreamy backyard with a bubbling hot tub, gas fire pit, swinging chairs, hammock, bistro lights, and a spacious outdoor dining area perfect for evening gatherings. Inside, they’ll find a fully stocked kitchen, cozy spaces, a dedicated game room, and a basement theater with an 85” TV for movie nights.

Professionally decorated and well maintained, this home comes fully furnished with a cohesive, storybook theme that sets it apart from cookie-cutter rentals. Whether you're looking for a high-performing investment or a dual-purpose second home, Mid Summer Night’s Dream is ready to deliver.

Financials available upon request. Step into instant cash flow and a brand that’s already winning hearts — no extra setup required.

Last Agent to Sell the Property

Hannah Taylor

Good Neighbor LLC Brokerage Email: hannah@thegoodneighbors.com,207-570-9568 License #100089340 Listed on: 04/17/2025

Last Buyer's Agent

Victor Pereira, MBA

SettleWell Realty LLC License #100085829

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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 Details

Home Type

  • Single Family

Est. Annual Taxes

  • $3,671

Year Built

  • Built in 1967 | Remodeled

Lot Details

  • 10,387 Sq Ft Lot
  • Partially Fenced Property
  • Level Lot
  • Private Yard

Parking

  • 2 Car Attached Garage

Home Design

  • Brick Exterior Construction
  • Composition Roof

Interior Spaces

  • 1-Story Property
  • Furnished
  • Double Pane Windows
  • Smart Doorbell
  • Living Room

Kitchen

  • Oven
  • Microwave
  • Dishwasher
  • Disposal

Flooring

  • Wood
  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 5 Bedrooms | 3 Main Level Bedrooms

Laundry

  • Laundry in unit
  • Dryer
  • Washer

Basement

  • Basement Fills Entire Space Under The House
  • 2 Bedrooms in Basement

Home Security

  • Smart Locks
  • Smart Thermostat
  • Outdoor Smart Camera
  • Carbon Monoxide Detectors
  • Fire and Smoke Detector

Outdoor Features

  • Spa
  • Covered Patio or Porch
  • Fire Pit
  • Outdoor Gas Grill

Schools

  • Fremont Elementary School
  • Oberon Middle School
  • Arvada West High School

Utilities

  • Forced Air Heating and Cooling System

Community Details

  • No Home Owners Association
  • Woodland Hills Subdivision

Listing and Financial Details

  • Assessor Parcel Number 067969

Home Details

Home Type

Single Family

Est. Annual Taxes

$3,671

Year Built

Built in 1967 | Remodeled

Lot Details

10,387 Sq Ft Lot

Parking

2

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Structure Type: House
  • Levels: One
  • Year Built: 1967
  • Above Grade Finished Sq Ft: 1469
  • Below Grade Sq Ft: 1469
  • Exclusions: N/A
  • Living Area: 1469
  • Property Condition: Updated/Remodeled
  • SubdivisionName: Woodland Hills
  • Ownership: Individual
  • Property Attached Yn: No
  • ResoBuildingAreaSource: PublicRecords
  • REC_BasementLevelBedrooms: 2
  • REC_RVSpaces: 0
  • REC_UpperLevelBathrooms: 0
  • REC_UpperLevelBedrooms: 0
  • REC_WaterIncludedYN: 1
  • Ratio Close Price By Original Li: 1.00000
  • Special Features: None

Interior Features

  • Appliances: Dishwasher, Disposal, Dryer, Microwave, Oven, Refrigerator, Washer
  • Interior Amenities: Smart Thermostat
  • Flooring: Carpet, Tile, Wood
  • Full Bathrooms: 1
  • Basement: Full
  • Basement: Yes
  • Three Quarter Bathrooms: 2
  • Total Bedrooms: 5
  • Main Level Bathrooms: 2
  • Main Level Bedrooms: 3
  • Window Features: Double Pane Windows

Exterior Features

  • Roof: Composition
  • Construction Materials: Brick
  • Exterior Features: Fire Pit, Gas Grill, Private Yard, Spa/Hot Tub
  • Patio and Porch Features: Covered
  • Road Frontage Type: Public
  • Road Surface Type: Paved

Garage/Parking

  • Attached Garage: Yes
  • Garage Spaces: 2
  • Total Parking Spaces: 2

Utilities

  • Sewer: Public Sewer
  • Cooling: Central Air
  • Heating: Forced Air
  • Water Source: Public
  • Laundry Features: In Unit
  • Security: Carbon Monoxide Detector(s), Smart Cameras, Smart Locks, Smoke Detector(s), Video Doorbell

Condo/Co-op/Association

  • Association: No
  • Senior Community: No

Association/Amenities

  • REC_AssociationFee2Annual: 0.00
  • REC_AssociationFee3Annual: 0.00
  • REC_AssociationFeeAnnual: 0.00
  • REC_AssociationFeeTotalAnnual: 0.00

Schools

  • Middle Or Junior School: Oberon

Lot Info

  • Parcel Number: 067969
  • Lot Size Acres: 0.24
  • Fencing: Partial
  • Building Area Total: 2938
  • Lot Features: Level
  • Lot Size Sq Ft: 10387
  • ResoLotSizeUnits: SquareFeet

Rental Info

  • Furnished: Furnished

Tax Info

  • Tax Year: 2024
  • Tax Annual Amount: 3671

MLS Schools

  • Elementary School: Fremont
  • High School: Arvada West

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Agents Specializing in Northwest Arvada, CO

See All Agents

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft
05/21/2025 05/21/25 Sold $775,000 0.0% $528 / Sq Ft
04/17/2025 04/17/25 For Sale $775,000 -- $528 / Sq Ft
Source: REcolorado®

Tax History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

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,194 $40,668 $12,608 $28,060
2024 $3,675 $37,893 $14,614 $23,279
2023 $3,675 $37,893 $14,614 $23,279
2022 $3,101 $29,983 $11,519 $18,464
2021 $2,293 $30,846 $11,851 $18,995
2020 $2,921 $30,274 $11,182 $19,092
2019 $2,882 $30,274 $11,182 $19,092
2018 $2,676 $27,328 $6,001 $21,327
2017 $2,449 $27,328 $6,001 $21,327
2016 $2,278 $23,937 $6,250 $17,687
2015 $1,923 $23,937 $6,250 $17,687
2014 $1,923 $18,997 $4,900 $14,097
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: REcolorado®

MLS Number: 4024403

REcolorado®

APN: 39-054-12-011

Your Personal Tour Guide

Ask me questions while you tour the home.