$1,575,000
PENDING

409 E Overlook Loop Hideout, UT 84036

Estimated payment $8,851/month

Total Views 400
3 Beds
3.5 Baths
2,977 Sq Ft
$529 Price per Sq Ft

Highlights

  • Views of Ski Resort
  • Open Floorplan
  • Deck
  • Midway Elementary School Rated A
  • ENERGY STAR Certified Homes
  • Vaulted Ceiling

About This Home

FULLY FURNISHED WITH UPGRADES GALORE. Positioned above the Jordanelle Reservoir with views toward Deer Valley, this end-unit residence in Deer Waters delivers a refined take on modern mountain living, where architecture, light, and landscape are in constant conversation. As a corner unit, the home captures natural light from multiple exposures, framing blue-water views by day and alpine silhouettes by night. Offering the highly sought-after Modern Solace floor plan--rarely available in Deer Waters--the layout is open yet intentional, anchored by a statement kitchen with an oversized island and sculptural pendant lighting that flows seamlessly into the great room. A tiled fireplace adds warmth and a modern edge, creating a space equally suited for relaxed mornings or elevated entertaining. Above, a loft currently styled as a yoga-meets-pilates studio introduces a dedicated wellness layer--an airy, grounding space ideal for mindful movement, creative focus, or a secondary lounge that adapts effortlessly to your lifestyle. Finishes throughout are timeless and elevated: quartz surfaces, natural stone accents, designer lighting, and a calming contemporary palette that allows the surrounding views to take center stage. The main-level primary suite is a true retreat, featuring a freestanding soaking tub, a spa-inspired bath, and a wood-beam ceiling detail that brings subtle mountain character to a clean, modern frame. Generous storage and a spacious two-car garage support effortless day-to-day living. Located just minutes from Park City, Deer Valley East Village, and the upcoming Mayflower Resort, Deer Waters residents enjoy direct trail access, pickleball courts, and walkable entry to Jordanelle State Park for hiking, biking, and lake days. With the future Jordanelle Parkway connection, this home sits at the center of Utah's most compelling mountain expansion. Offered fully furnished, this modern mountain residence provides true turnkey living--ideal for low-maintenance ownership and lock-and-leave flexibility. Select artwork and personal items excluded.

Listing Agent

Fleming Trainor

Summit Sotheby's International Realty License #12029273-SA00 Listed on: 02/13/2026

Summit Sotheby's International Realty

Property Details

Home Type

  • Condominium

Est. Annual Taxes

  • $6,806

Year Built

  • Built in 2021

Lot Details

  • Landscaped

HOA Fees

  • $280 Monthly HOA Fees

Parking

  • 2 Car Attached Garage
  • Garage Door Opener
  • Guest Parking

Property Views

  • Lake
  • Ski Resort
  • Mountain

Home Design

  • Wood Frame Construction
  • Composition Roof
  • Wood Siding
  • Concrete Perimeter Foundation
  • Stone

Interior Spaces

  • 2,977 Sq Ft Home
  • Open Floorplan
  • Partially Furnished
  • Vaulted Ceiling
  • Ceiling Fan
  • Self Contained Fireplace Unit Or Insert
  • Gas Fireplace
  • Great Room
  • Dining Room
  • Loft
  • Storage

Kitchen

  • Eat-In Kitchen
  • Double Oven
  • Gas Range
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Disposal

Flooring

  • Carpet
  • Tile
  • Vinyl

Bedrooms and Bathrooms

  • 3 Bedrooms | 1 Primary Bedroom on Main
  • Walk-In Closet
  • Double Vanity

Laundry

  • Laundry Room
  • Stacked Washer and Dryer

Home Security

Eco-Friendly Details

  • ENERGY STAR Certified Homes
  • Drip Irrigation

Outdoor Features

  • Deck
  • Patio
  • Outdoor Gas Grill
  • Barbecue Stubbed In

Utilities

  • Humidifier
  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Programmable Thermostat
  • Natural Gas Connected
  • Tankless Water Heater
  • Gas Water Heater
  • Water Purifier
  • Water Softener is Owned
  • High Speed Internet
  • Phone Available
  • Cable TV Available

Listing and Financial Details

  • Assessor Parcel Number 00-0021-5085

Community Details

Overview

  • Association fees include management fees, insurance, ground maintenance, com area taxes, snow removal
  • Visit Association Website
  • Deer Waters Resort Subdivision

Recreation

  • Pickleball Courts

Pet Policy

  • Pets Allowed

Security

  • Fire and Smoke Detector
  • Fire Sprinkler System

Property Details

Home Type

Condominium

Est. Annual Taxes

$6,806

Year Built

Built in 2021

Lot Details

436 Sq Ft Lot

HOA Fees

$280 per month

Parking

2

Listing Details

  • MainLevelTotalsBedroom: 1
  • MainLevelTotalsDiningRoom: 1
  • MainLevelTotalsFullBaths: 1
  • MainLevelTotalsGreatRoom: 1
  • MainLevelTotalsHalfBaths: 1
  • Prop. Type: Residential
  • Road Frontage Type: Public
  • Road Surface Type: Paved
  • Property Sub Type: Condominium
  • Lot Size Acres: 0.01
  • Subdivision Name: Deer Waters Resort
  • Unit Levels: Multi-Level
  • New Construction: No
  • Year Built: 2021
  • Contract Info:Short Sale: No
  • Contract Info:BankLender Owned: No
  • Property Info:Access: Year Round
  • Property Info:Construction Status: Complete
  • Property Info:Accessory Dwelling Unit YN: No
  • Size of HouseLot:Apx SqFt Finished: 2977.0
  • Room Totals:Dining Room7: 1
  • Room Totals:Great Room7: 1
  • Upper Level Totals:Full Baths2: 1
  • Property Info:Mother-in-Law Apartment: No
  • Upper Level Totals:Loft2: 1
  • Room Totals:Loft7: 1
  • Room Totals:Laundry8: 1
  • Lower Level Totals:Laundry4: 1
  • Special Features: VirtualTour

Interior Features

  • Appliances: Humidifier, Tankless Water Heater
  • Flooring: Tile, Vinyl, Carpet
  • Interior Amenities: Walk-In Closet(s), Open Floorplan, Kitchen Island, Double Vanity
  • Furnished: Partially
  • Other Equipment: Appliances, See Remarks
  • Accessibility Features: None
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Total Bedrooms: 3
  • Fireplace Features: Gas, Insert
  • Fireplaces: 1
  • Fireplace: Yes

Exterior Features

  • Construction Type: Stone
  • Foundation Details: Concrete Perimeter
  • Exterior: Stone, Wood Siding
  • Roof: Composition
  • Other Structures: None

Garage/Parking

  • Attached Garage: No
  • Covered Parking Spaces: 2
  • Garage Spaces: 2.0

Utilities

  • Utilities: Electricity Connected, High Speed Internet Available
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Sewer: Public Sewer
  • Water Source: Public
  • Cooling: Central Air
  • Utilities: Cable Available, Electricity Connected, High Speed Internet Available, Natural Gas Connected, Phone Lines/Additional

Association/Amenities

  • MembershipAmenitiesMembershipAvailable: No
  • AssociationOccupant:HOA Contact: Melissa Scott
  • AssociationOccupant:HOA Website: CSSHOA.com
  • AssociationOccupant:Currently Occupied: Call Listing Agent
  • AssociationOccupant:Mgmt Rental Co: No

Condo/Co-op/Association

  • Association Fee: 280.0
  • Association Fee Frequency: Monthly
  • Association: Yes

Fee Information

  • Association Fee Includes: Snow Removal

Lot Info

  • Development Status: Construction Status
  • Lot Size Sq Ft: 1742.0
  • Parcel #: 00-0021-5085

Tax Info

  • Tax Year: 2025
  • Tax Annual Amount: 6806.0

Map

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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

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
2025 $6,806 $1,347,180 $335,000 $1,012,180
2024 $5,792 $1,158,190 $275,000 $883,190
2023 $5,792 $1,253,560 $250,000 $1,003,560
2022 $77 $252,736 $140,000 $112,736
2021 $98 $140,000 $140,000 $0
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
03/02/2026 03/02/26 Pending -- -- --
02/13/2026 02/13/26 For Sale $1,575,000 +21.2% $529 / Sq Ft
09/09/2022 09/09/22 Sold -- -- -- View Prior Sale
09/09/2022 09/09/22 Off Market -- -- --
09/06/2022 09/06/22 Pending -- -- --
08/23/2022 08/23/22 Price Changed $1,300,000 -11.9% $463 / Sq Ft
08/08/2022 08/08/22 Price Changed $1,475,000 -10.6% $525 / Sq Ft
07/18/2022 07/18/22 For Sale $1,650,000 -- $588 / Sq Ft
Source: Park City Board of REALTORS®

Purchase History

Date Type Sale Price Title Company
Warranty Deed -- --
Warranty Deed -- Meridian Title
Special Warranty Deed -- Meridian Title
Warranty Deed -- Meridian Title Company
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Previous Owner $894,907 New Conventional
Previous Owner $1,040,000 Construction
Source: Public Records

Source: Park City Board of REALTORS®

MLS Number: 12600564

Park City Board of REALTORS®

APN: 00-0021-5085

Your Personal Tour Guide

Ask me questions while you tour the home.