NOT LISTED FOR SALE

Estimated Value: $5,094,000 - $5,754,000

5 Beds
5.5 Baths
5,082 Sq Ft
$1,069/Sq Ft Est. Value

Last Sold January 12, 2024

Last sale price $5,175,000 $1,018 Per Sq Ft

Est. 5% increase in value since last sale

Current estimated payment $33,595/month

90 Days on Market

Highlights

  • Lake Front
  • On Golf Course
  • In Ground Pool
  • Guest House
  • Wine Cellar
  • Casita

About This Home

As of January 2024

This stunning, new construction, contemporary home is the perfect Hideaway, overlooking a tranquil private lake, located on the picturesque Clive Clark golf course. This masterpiece offers sleek, clean lines, natural elements and chic designer finishes, with 5 bedrooms, 5.5 baths including a 2-bedroom casita with living room. The bright and airy ambiance of this home is enhanced by the custom glass pivot entrance door, allowing the natural light to flood the interior. The grand dining room offers an uninterrupted outdoor view of the attractive courtyard with water feature. The heart of the home is highlighted with a large center island and top-of the-line appliance package for the most-discerning chef. Breathtaking Northeastern views of the Chocolate Mountains, lakes, and golf course can be enjoyed throughout the home. Sleek glass pocket doors slide all the way into the walls to allow seamless Indoor/Outdoor living at its finest. The backyard oasis is a heaven for relaxation with a shimmering pool with fire feature, raised spa, BBQ island, pass-through bar and double-sided fireplace. Furnished per sellers inventory, includes solar panels for additional energy savings.

Last Agent to Sell the Property

Hideaway Properties - Ravis Group

Hideaway Properties Corporation License #01087347 Listed on: 09/14/2023

Last Buyer's Agent

Hideaway Properties - Ravis Group

Hideaway Properties Corporation License #01087347 Listed on: 09/14/2023

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $48,793

Year Built

  • Built in 2023

Lot Details

  • 0.35 Acre Lot
  • Lake Front
  • On Golf Course
  • Home has East and West Exposure
  • Stucco Fence
  • Level Lot
  • Sprinkler System

HOA Fees

  • $800 Monthly HOA Fees

Property Views

  • Lake
  • Panoramic
  • Golf Course
  • Mountain
  • Pool

Home Design

  • Custom Home
  • Contemporary Architecture
  • Flat Roof Shape
  • Slab Foundation
  • Tile Roof
  • Plaster

Interior Spaces

  • 5,082 Sq Ft Home
  • 3-Story Property
  • Open Floorplan
  • Wet Bar
  • Partially Furnished
  • Bar
  • High Ceiling
  • Ceiling Fan
  • Gas Fireplace
  • Shutters
  • Blinds
  • French Doors
  • Sliding Doors
  • Entryway
  • Wine Cellar
  • Great Room with Fireplace
  • 2 Fireplaces
  • Breakfast Room
  • Formal Dining Room
  • Wood Flooring

Kitchen

  • Gourmet Kitchen
  • Kitchenette
  • Breakfast Bar
  • Walk-In Pantry
  • Gas Range
  • Range Hood
  • Microwave
  • Water Line To Refrigerator
  • Dishwasher
  • Kitchen Island
  • Disposal

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Retreat
  • Primary Bedroom on Main
  • Fireplace in Primary Bedroom Retreat
  • Walk-In Closet
  • Double Vanity
  • Secondary bathroom tub or shower combo

Laundry

  • Laundry Room
  • Dryer
  • Washer
  • 220 Volts In Laundry

Parking

  • 3 Car Direct Access Garage
  • Garage Door Opener
  • Driveway

Pool

  • In Ground Pool
  • Heated Spa
  • In Ground Spa
  • Outdoor Pool

Outdoor Features

  • Balcony
  • Covered Patio or Porch
  • Outdoor Fireplace
  • Casita
  • Built-In Barbecue

Utilities

  • Central Heating and Cooling System
  • Heating System Uses Natural Gas
  • Property is located within a water district
  • Gas Water Heater
  • Cable TV Available

Additional Features

  • Guest House
  • Ground Level

Listing and Financial Details

  • Assessor Parcel Number 777380013

Community Details

Overview

  • Association fees include security
  • The Hideaway Subdivision
  • Planned Unit Development

Amenities

  • Community Mailbox

Recreation

  • Golf Course Community

Security

  • Resident Manager or Management On Site
  • Controlled Access
  • Gated Community

Home Details

Home Type

Single Family

Est. Annual Taxes

$48,793

Year Built

Built in 2023

Lot Details

0

HOA Fees

$800 per month

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Property Attached/Detached: No
  • Property Orientation Faces: Front Door Faces West, Leisure Faces East
  • Levels: Two
  • Building Number Of Stories: 3
  • Building Style: Contemporary
  • Casita Features: Kitchenette
  • Entry Location: Ground Level w/Steps
  • Included In Sale: Furnishing per inventory
  • List Price per Sq Ft: 1082.05
  • Lp Sp Ratio: 0.9400
  • View Type: Golf Course, Pool, Panoramic, Mountain(s), Lake
  • Water District Name: CVWD
  • Year Built: 2023
  • Listing I D: 219099884
  • Listing Member Address: 52050 Meriwether Way, La Quinta, CA 92253
  • Listing Office Address: 53000 Jefferson Street, La Quinta, CA 92253
  • Listing Office Fax: (760) 777-9321
  • Selling Member Address: 52050 Meriwether Way, La Quinta, CA 92253
  • Selling Office Address: 53000 Jefferson Street, La Quinta, CA 92253
  • Selling Office Fax: (760) 777-9321
  • Land Type: Fee
  • Subdivision: The Hideaway
  • Special Features: NewHome

Interior Features

  • Appliances: Dryer, Gas Range, Microwave Oven, Water Line to Refrigerator, Washer, Refrigerator, Gas Dryer Hookup, Disposal, Dishwasher
  • Fireplace: Yes
  • Fireplace Location: Exterior, Dual Fireplace(s), Master Retreat, Great Room
  • Interior Amenities: Bar, Wet Bar, Open Floorplan, High Ceilings (9 Ft+)
  • Range Hood: Yes
  • Fireplace Features: Gas
  • Flooring: Hardwood, Mixed
  • Bedroom Features: Main Floor Master Bedroom, Walk In Closet, Master Retreat
  • Total Bedrooms: 5
  • Bathroom Features: Double Vanity(s), Shower & Tub
  • Half Bathrooms: 1
  • Total Bathrooms: 6.00
  • Full Bathrooms: 5
  • Eating Areas: Breakfast Counter/Bar, Kitchen Island, Formal Dining Room, Breakfast Room
  • Kitchen Features: Gourmet Kitchen, Pantry, Island
  • Laundry: Individual Room
  • Estimated Sq Ft: 5082.00
  • Windows Treatments: Blinds, Shutters

Exterior Features

  • Construction: Plaster
  • Other Features: Barbeque Private, Custom Built
  • Other Structures: Guest House/Casita
  • Roofing: Flat, Tile
  • Built-in BBQ: Gas
  • Fencing: Stucco Wall
  • Foundation: Slab
  • Patio: Covered, Balcony
  • Pool: Yes
  • Pool Construction: In Ground
  • Pool Description: In Ground, Private
  • Pool Location: Private
  • Planned Unit Development: Yes
  • Spa Hot Tub: Yes
  • Spa Hot Tub Construction: In Ground
  • Spa Hot Tub Description: Heated - Gas, Private
  • View: Yes
  • Waterfront: Lake

Garage/Parking

  • Garage: Yes
  • Garage Description: Attached
  • Parking: Direct Entrance, Driveway, Garage Door Opener
  • Total Garage Spaces: 3.00
  • Total Parking Spaces: 5.00
  • Total Uncovered Assigned Spaces: 2.00

Utilities

  • TV Svcs: Cable TV
  • Volt 220: In Laundry
  • Cooling Type: Air Conditioning, Central Air, Ceiling Fan(s)
  • Heating: Central, Fireplace(s)
  • Heating Fuel: Natural Gas
  • Security: 24 Hour Security, Gated Community
  • Sewer: In, Connected and Paid
  • Water: Water District
  • Water Heater Feature: Gas

Association/Amenities

  • Community Features: Community Mailbox, Golf Course Within Development
  • Association #1 Frequency: Monthly
  • Gated Community: Yes
  • Golf Course Within Development: Yes

Condo/Co-op/Association

  • Association Fees Include: Security
  • Association Amenities: Controlled Access, Management
  • HOA Information: Yes
  • HOA Fee 1: 800.00
  • Total Monthly Association Fees: 800.00

Lot Info

  • Sprinklers: Yes
  • Assessor Parcel Number: 777380013
  • Irrigation: Sprinkler System
  • Lot Description: Level
  • Lot Location: Lake Front, On Golf Course
  • Lot Size: 15246.00

Rental Info

  • Furnished: Partially
  • Land Lease Type: Fee Simple

Multi Family

  • Total Fireplaces: 2

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Sep 14, 2023
Closed on
Dec 5, 2023
Sold by
Rosenberg Harold M and Rosenberg Cara
Bought by
Hagelstein Living Trust and Hageistein
Seller's Agent
Hideaway Properties - Ravis Group
Hideaway Properties Corporation
Buyer's Agent
Hideaway Properties - Ravis Group
Hideaway Properties Corporation
List Price
$5,499,000
Sold Price
$5,175,000
Premium/Discount to List
-$324,000
-5.89%
Views
90
Current Estimated Value
$5,434,754

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$259,754
Avg. Annual Appreciation
2.85%

Purchase Details

Listed on
Jun 28, 2019
Closed on
Aug 13, 2020
Sold by
Miller Marjorie L
Bought by
Rosenberg Harold N and Saffro Cara
Seller's Agent
Hideaway Properties - Ravis Group
Hideaway Properties Corporation
Buyer's Agent
Hideaway Properties - Ravis Group
Hideaway Properties Corporation
List Price
$345,000
Sold Price
$265,000
Premium/Discount to List
-$80,000
-23.19%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
140.91%

Purchase Details

Closed on
May 14, 2004
Sold by
Miller Marjorie L
Bought by
Miller Marjorie L

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$348,725
Interest Rate
5.57%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Mar 29, 2004
Sold by
Nd La Quinta Partners Llc
Bought by
Miller Marjorie L

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$348,725
Interest Rate
5.57%
Mortgage Type
Purchase Money Mortgage
Source: Public Records

Range of Values:

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

Purchase History

Date Buyer Sale Price Title Company
Hagelstein Living Trust $5,175,000 Wfg National Title
Rosenberg Harold N $265,000 Wfg Title Company Of Ca
Miller Marjorie L -- --
Miller Marjorie L $436,500 Fidelity National Title Co
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Miller Marjorie L $348,725
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
01/12/2024 01/12/24 Sold $5,175,000 -5.9% $1,018 / Sq Ft
12/13/2023 12/13/23 Pending -- -- --
09/14/2023 09/14/23 For Sale $5,499,000 +1975.1% $1,082 / Sq Ft
08/27/2020 08/27/20 Sold $265,000 -10.2% -- View Prior Sale
08/21/2020 08/21/20 Pending -- -- --
06/27/2020 06/27/20 Price Changed $295,000 -1.7% --
02/26/2020 02/26/20 Price Changed $300,000 -7.7% --
12/27/2019 12/27/19 Price Changed $325,000 -5.8% --
06/28/2019 06/28/19 For Sale $345,000 -- --
Source: California Desert Association of REALTORS®

Tax History Compared to Growth

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 $48,793 $5,278,499 $1,847,476 $3,431,023
2023 $48,793 $2,452,706 $275,706 $2,177,000
2022 $3,803 $270,300 $270,300 $0
2021 $3,462 $572,682 $572,682 $0
2020 $4,355 $334,750 $334,750 $0
2019 $4,241 $325,000 $325,000 $0
2018 $4,244 $325,000 $325,000 $0
2017 $4,989 $375,000 $375,000 $0
2016 $4,234 $325,000 $325,000 $0
2015 $4,125 $325,000 $325,000 $0
2014 $3,870 $300,000 $300,000 $0
Source: Public Records

Agents Affiliated with this Home

See All Agents

Map

Source: California Desert Association of REALTORS®

MLS Number: 219099884

California Desert Association of REALTORS®

APN: 777-380-013