
Seller's Agent in 2025
Hannah Taylor
Good Neighbor LLC
(207) 570-9568
1 in this area
64 Total Sales
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
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 |
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 |
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 |
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 |
Seller's Agent in 2025
Hannah Taylor
Good Neighbor LLC
(207) 570-9568
1 in this area
64 Total Sales
V
Buyer's Agent in 2025
Victor Pereira, MBA
SettleWell Realty LLC
(303) 304-9288
1 in this area
52 Total Sales
G
Seller's Agent in 2023
Garrett Jones
JDI Investments
(720) 855-9000
3 in this area
424 Total Sales
Buyer's Agent in 2023
Garrett Newell
Good Neighbor LLC
(425) 443-9743
2 in this area
82 Total Sales
Source: REcolorado®
MLS Number: 4024403
APN: 39-054-12-011