Estimated payment $4,631/month
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.
Listing Agent
Good Neighbor LLC Brokerage Email: hannah@thegoodneighbors.com,207-570-9568 License #100089340
Home Type
Est. Annual Taxes
Year Built
Lot Details
Parking
Home Design
Interior Spaces
Kitchen
Flooring
Bedrooms and Bathrooms
Laundry
Basement
Home Security
Outdoor Features
Schools
Utilities
Community Details
Listing and Financial Details
| 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 |
| Date | Event | Price | Change | Sq Ft Price |
|---|---|---|---|---|
| 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 | +64.6% | $221 / Sq Ft |
| 08/24/2022 08/24/22 | Sold | $395,000 | -12.2% | $154 / Sq Ft |
| 07/27/2022 07/27/22 | Pending | -- | -- | -- |
| 07/26/2022 07/26/22 | Price Changed | $450,000 | -9.3% | $175 / Sq Ft |
| 07/26/2022 07/26/22 | Price Changed | $495,900 | -9.8% | $193 / Sq Ft |
| 07/25/2022 07/25/22 | Price Changed | $550,000 | -1.8% | $214 / Sq Ft |
| 07/23/2022 07/23/22 | Price Changed | $560,000 | -3.4% | $218 / Sq Ft |
| 07/22/2022 07/22/22 | For Sale | $580,000 | -- | $226 / Sq Ft |
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| 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 | $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 |
$685,000
Welcome to Stefan Ridge – Arvada Living at Its Best!Located in the heart of Arvada with easy access to Ralston Creek Trail, this spacious and well-cared-for home offers the perfect blend of comfort and functionality. Step into a grand entrance that flows effortlessly into the vaulted main level, featuring formal living and dining spaces—ideal for gatherings or everyday
Nicki Thompson RE/MAX Alliance - Olde Town
$624,900
*Seller is motivated. Bring an offer! *A recently remodeled and refreshed single-story house in the desirable Woodland Valley neighborhood! This house is perfect for remote workers, home-schoolers, and multigenerational families. *Enjoy one-level living on the main floor with tile flooring in the bathrooms and luxury vinyl plank flooring elsewhere, two bedrooms, and a remodeled full bathroom and
Brad Dunevitz, M.S. Century 21 Prosperity
$729,000
Luxurious and meticulously remodeled, Big lot with great potential in stablished neighborhood. . The heart of the home is the beautiful kitchen, featuring Bosch and GE, appliances. Granite countertops and wooden cabinets. All new light fixtures illuminate the whole house. The main floor showcases wide-plank hardwood flooring, exuding warmth and sophistication. An accent wall with natural stone
Nieves Hulko Right 4 U Realty LLC
$775,000
Welcome to this beautifully reimagined 5-bedroom, 4-bathroom home that strikes the perfect balance between style, space, and functionality. Nestled in a quiet, established neighborhood, this stunning property has been thoughtfully renovated from top to bottom with no detail overlooked. Step inside to discover a bright, open-concept floor plan featuring wide-plank flooring, fresh neutral tones,
Nicki Thompson RE/MAX Alliance - Olde Town
$889,900
Welcome to Rainbow Ridge—a beautifully updated two-story home designed for peace and privacy. The backyard is a dream: circular flagstone patio, fire pit, four-season greenhouse, hot tub, water feature, and vibrant perennial gardens & flowering trees. Inside, enjoy a bright open floor plan with two family/sitting rooms, fireplace, beautiful picture windows throughout, new carpet, paint, upgraded
Nicki Thompson RE/MAX Alliance - Olde Town
$659,000
Stunning Updated Ranch on a Spacious Corner Lot!Welcome to this beautifully updated 5-bedroom, 3-bathroom ranch-style home that blends modern upgrades with timeless charm. From the moment you step inside, you'll notice the quality craftsmanship and custom finishes throughout. The heart of the home features a fully remodeled kitchen boasting stainless steel appliances, gorgeous butcher block
Nicki Thompson RE/MAX Alliance - Olde Town
$588,000
Built in 1962, renovated in 1984 and then re-renovated in 2024. This ranch style home just minutes from Olde Town Arvada will take your breath away! The home features a brand new LARGE owner's retreat, original refinished hard wood flooring, new carpeting, custom cabinets, custom tile work, brand new quartz countertops, new fridge and much much more! The large backyard has a mini deck built
Johnny Lee Signature Real Estate Corp.
$785,000
Step into a beautifully renovated home in Arvada, where every detail has been thoughtfully updated to create a modern haven. As you enter, new LVP flooring welcomes you, leading through rooms filled with natural light from newly installed windows. Fresh paint and contemporary light fixtures set a serene yet stylish atmosphere.The kitchen, the heart of this home, has been completely
Nicole Nelson Resident Realty Colorado
$770,000
Stunning Tri Pointe Home in Sought-After Candelas – Walkout Basement & Mountain Views Discover comfort, elegance, and an unbeatable location in this beautifully maintained Tri Pointe home nestled in the heart of Candelas. Enjoy uninterrupted mountain views with no neighbors behind you and a bright, open floor plan flooded with natural light. This 3-bedroom, 3-bathroom home features a walkout
Julie Leins Keller Williams Advantage Realty LLC
Source: REcolorado®
MLS Number: 4024403
APN: 39-054-12-011
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
The content relating to real estate for sale in this Web site comes in part from the Internet Data eXchange (“IDX”) program of METROLIST, INC., DBA RECOLORADO®. Real estate listings held by brokers other than Ten-X are marked with the IDX Logo. This information is being provided for the consumers’ personal, non-commercial use and may not be used for any other purpose. All information subject to change and should be independently verified.
This publication is designed to provide information with regard to the subject matter covered. It is displayed with the understanding that the publisher and authors are not engaged in rendering real estate, legal, accounting, tax, or other professional services and that the publisher and authors are not offering such advice in this publication. If real estate, legal, or other expert assistance is required, the services of a competent, professional person should be sought.
The information contained in this publication is subject to change without notice. METROLIST, INC., DBA RECOLORADO MAKES NO WARRANTY OF ANY KIND WITH REGARD TO THIS MATERIAL, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. METROLIST, INC., DBA RECOLORADO SHALL NOT BE LIABLE FOR ERRORS CONTAINED HEREIN OR FOR ANY DAMAGES IN CONNECTION WITH THE FURNISHING, PERFORMANCE, OR USE OF THIS MATERIAL.
PUBLISHER’S NOTICE: All real estate advertised herein is subject to the Federal Fair Housing Act and the Colorado Fair Housing Act, which Acts make it illegal to make or publish any advertisement that indicates any preference, limitation, or discrimination based on race, color, religion, sex, handicap, familial status, or national origin.
METROLIST, INC., DBA RECOLORADO will not knowingly accept any advertising for real estate that is in violation of the law. All persons are hereby informed that all dwellings advertised are available on an equal opportunity basis.
© 2025 METROLIST, INC., DBA RECOLORADO® – All Rights Reserved. 6455 S. Yosemite St., Suite 500 Greenwood Village, CO 80111 USA
ALL RIGHTS RESERVED WORLDWIDE. No part of this publication may be reproduced, adapted, translated, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, or otherwise, without the prior written permission of the publisher. The information contained herein including but not limited to all text, photographs, digital images, virtual tours, may be seeded and monitored for protection and tracking.