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.
For sale
$775,000
12292 W 65th Avenue, Arvada, CO 80004
5beds
2,938sqft
Est.:
Single Family Residence
Built in 1967
10,387 Square Feet Lot
$766,600 Zestimate®
$264/sqft
$-- HOA
What's special
Fully fenced yardBasement theaterDreamy backyardLow-maintenance landscapingBubbling hot tubGas fire pitDedicated game room
- 8 days
- on Zillow |
- 1,241 |
- 69 |
Zillow last checked: 7 hours ago
Listing updated: April 17, 2025 at 09:40am
Listed by:
Hannah Taylor 207-570-9568 hannah@thegoodneighbors.com,
Good Neighbor LLC
Source: REcolorado,MLS#: 4024403

Travel times
Tour with a buyer’s agent
Tour with a buyer’s agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 3
- Full bathrooms: 1
- 3/4 bathrooms: 2
- Main level bathrooms: 2
- Main level bedrooms: 3
Primary bedroom
- Level: Main
Bedroom
- Level: Main
Bedroom
- Level: Basement
Bedroom
- Level: Basement
Bedroom
- Level: Main
Primary bathroom
- Level: Main
Bathroom
- Level: Main
Bathroom
- Level: Basement
Kitchen
- Level: Main
Living room
- Level: Main
Heating
- Forced Air
Cooling
- Central Air
Appliances
- Included: Dishwasher, Disposal, Dryer, Microwave, Oven, Refrigerator, Washer
- Laundry: In Unit
Features
- Smart Thermostat
- Flooring: Carpet, Tile, Wood
- Windows: Double Pane Windows
- Basement: Full
- Furnished: Yes
Interior area
- Total structure area: 2,938
- Total interior livable area: 2,938 sqft
- Finished area above ground: 1,469
- Finished area below ground: 0
Property
Parking
- Total spaces: 2
- Parking features: Garage - Attached
- Attached garage spaces: 2
Features
- Levels: One
- Stories: 1
- Patio & porch: Covered
- Exterior features: Fire Pit, Gas Grill, Private Yard
- Has spa: Yes
- Spa features: Spa/Hot Tub
- Fencing: Partial
Lot
- Size: 10,387 Square Feet
- Features: Level
Details
- Parcel number: 067969
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence
Materials
- Brick
- Roof: Composition
Condition
- Updated/Remodeled
- Year built: 1967
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
Community & HOA
Community
- Security: Carbon Monoxide Detector(s), Smart Cameras, Smart Locks, Smoke Detector(s), Video Doorbell
- Subdivision: Woodland Hills
HOA
- Has HOA: No
Location
- Region: Arvada
Financial & listing details
- Price per square foot: $264/sqft
- Tax assessed value: $565,556
- Annual tax amount: $3,671
- Date on market: 4/17/2025
- Listing terms: Cash,Conventional,FHA,VA Loan
- Ownership: Individual
- Road surface type: Paved
- Loading
- Loading