$775,000
SOLD MAY 21, 2025
5 Beds
3 Baths
1,469 Sq Ft
10,387 Sq Ft Lot

Recently Sold

$528 Per Sq Ft

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

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

0

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_BasementLevelBathrooms: 1
  • REC_BasementLevelBedrooms: 2
  • REC_RVSpaces: 0
  • REC_UpperLevelBathrooms: 0
  • REC_UpperLevelBedrooms: 0
  • REC_WaterIncludedYN: 1
  • Ratio Close Price By Original Li: 1.00000
  • Attribution Contact: hannah@thegoodneighbors.com,207-570-9568
  • 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
  • REC_ParkingCount: 1

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

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Apr 17, 2025
Closed on
May 21, 2025
Sold by
Fenton Meijhan
Bought by
Reeves Joseph
Seller's Agent
Hannah Taylor
Good Neighbor LLC
Buyer's Agent
Victor Pereira, MBA
SettleWell Realty LLC
List Price
$775,000
Sold Price
$775,000
Views
36
Current Estimated Value
$765,124

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$9,876
Avg. Annual Appreciation
-4.05%
Original Mortgage
$577,500
Outstanding Balance
$576,477
Interest Rate
6.62%
Mortgage Type
New Conventional
Estimated Equity
$188,647

Purchase Details

Listed on
Jan 13, 2023
Closed on
Feb 6, 2023
Sold by
Jdi Llc
Bought by
Fenton Meijhan
Seller's Agent
Garrett Jones
JDI Investments
Buyer's Agent
Garrett Newell
Good Neighbor LLC
List Price
$650,000
Sold Price
$660,000
Premium/Discount to List
$10,000
1.54%
Views
12

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.27%
Original Mortgage
$561,000
Interest Rate
6.09%
Mortgage Type
New Conventional

Purchase Details

Closed on
Aug 25, 2022
Sold by
Equity Hunter Llc
Bought by
Jdi Llc

Purchase Details

Closed on
Aug 24, 2022
Sold by
Linnabary Karen K
Bought by
Equity Hunter Llc

Purchase Details

Closed on
Apr 9, 2004
Sold by
Angerman Charles and Angerman Jacqueline
Bought by
Linnabary Karen K

Purchase Details

Closed on
Mar 30, 2004
Sold by
Angerman Charles and Angerman Jacqueline
Bought by
Linnabary Karen K

Purchase Details

Closed on
Oct 27, 2003
Sold by
Linnabary Karen K
Bought by
Angerman Charles and Angerman Jacqueline

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$180,000
Interest Rate
6.01%
Mortgage Type
Stand Alone First
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 Type Sale Price Title Company
Special Warranty Deed $775,000 None Listed On Document
Warranty Deed $660,000 --
Special Warranty Deed $430,000 Elevated Title
Personal Reps Deed $395,000 None Listed On Document
Quit Claim Deed $35,000 None Listed On Document
Quit Claim Deed -- None Available
Quit Claim Deed -- Title America
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $577,500 New Conventional
Previous Owner $561,000 New Conventional
Previous Owner $642,000 Reverse Mortgage Home Equity Conversion Mortgage
Previous Owner $180,000 Stand Alone First
Previous Owner $170,000 Unknown
Previous Owner $30,000 Credit Line Revolving
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
05/21/2025 05/21/25 Sold $775,000 0.0% $528 / Sq Ft
04/17/2025 04/17/25 For Sale $775,000 +17.4% $528 / Sq Ft
02/06/2023 02/06/23 Sold $660,000 +1.5% $225 / Sq Ft
01/14/2023 01/14/23 Pending -- -- --
01/13/2023 01/13/23 For Sale $650,000 -- $221 / 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 $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
  • Section Image
  • Section Image
See All Agents

Map

Source: REcolorado®

MLS Number: 4024403

REcolorado®

APN: 39-054-12-011