Jill Samuels
Compass - Denver
(720) 573-0286
323 Total Sales
1 in Northwest Arvada
$547,500 Price
Estimated Value: $628,000 - $749,469
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
Good Neighbor LLC Brokerage Email: hannah@thegoodneighbors.com,207-570-9568 License #100089340 Listed on: 04/17/2025
Jill Samuels
Compass - Denver
(720) 573-0286
323 Total Sales
1 in Northwest Arvada
$547,500 Price
LaDawn Sperling
Coldwell Banker Realty 24
(720) 802-6692
160 Total Sales
4 in Northwest Arvada
$445K - $763K Price Range
Rene Sheridan
Demis Realty Inc
(720) 807-8959
31 Total Sales
2 in Northwest Arvada
$585,000 Price Range
Mark Kinslow II
Key Real Estate Group LLC
(720) 807-9389
84 Total Sales
1 in Northwest Arvada
$495,000 Price
Hunter Deegan
Orchard Brokerage LLC
(720) 706-9642
96 Total Sales
2 in Northwest Arvada
$390,000 Price Range
Adam Mayfield
Jade Real Estate
(720) 706-2940
65 Total Sales
2 in Northwest Arvada
$550,000 Price Range
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 |
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 |
Seller's Agent in 2025
Hannah Taylor
Good Neighbor LLC
(207) 570-9568
2 in this area
85 Total Sales
VP
Buyer's Agent in 2025
Victor Pereira, MBA
SettleWell Realty LLC
(303) 304-9288
1 in this area
43 Total Sales
Source: REcolorado®
MLS Number: 4024403
APN: 39-054-12-011
Ask me questions while you tour the home.