Dramatic waterfall islandFirst-floor suiteHigh-quality finishes throughoutSmart tvs throughoutCustom quartz countertopsSleeper sofaBright open living spaces
This upgraded, professionally managed lakefront short-term rental is ideally positioned on the water in Terra Lago, offering breathtaking lake and mountain views along with a private infinity-edge pool and spa. Designed for both comfort and performance, the home features bright, open living spaces and high-quality finishes throughout--purpose-built to maximize rental demand and guest satisfaction.The upgraded kitchen is fully equipped with stainless-steel appliances, custom quartz countertops, a dramatic waterfall island, designer backsplash, and a dedicated coffee bar--ideal for entertaining and extended guest stays.The spacious living room provides generous seating, an 86'' smart TV, and a sleeper sofa for flexible use. Expansive windows and sliding glass doors flood the home with natural light and create a seamless indoor-outdoor living experience centered around the stunning waterfront setting.The well-designed floor plan includes four bedrooms, including a first-floor suite, with ensuite bathrooms for every bedroom--a highly desirable feature for short-term rental guests. The upstairs primary suite offers a private balcony overlooking the lake and a spa-inspired bathroom with soaking tub. A bonus room adjacent to the primary suite functions as a dedicated kids' room with bunk beds, maximizing sleeping capacity and rental flexibility.Additional highlights include a movie-theater-style room with eight reclining chairs, a climate-controlled game room with commercial-grade arcade games (including air hockey and basketball), built-in BBQ, firepits, smart TVs throughout, and a layout ideally suited for short-term rental or second-home use. This is not just an STR--it is a destination property, offering resort-style amenities that keep guests on-site and drive repeat bookings.Located in the highly desirable Terra Lago community, this turnkey, high-performing lakefront asset delivers a proven two-plus-year short-term rental history with approximately $120,000 in annual gross income. All capital improvements and guest-driven upgrades are complete--this property will be generating income from day one.Zero setup. Zero downtime. Immediate cash flow.Investors also have the rare opportunity to scale instantly by acquiring the sister property at 43250 Pietra Ct, also in Terra Lago--creating a ready-made, multi-property short-term rental portfolio in one of the Coachella Valley's most sought-after resort communities.
Room types: Bedroom, Great Room, Primary Bedroom, Media Room, Pantry, Dining Room
Primary bedroom
Features: Primary Suite
Bedroom
Features: Bedroom on Main Level
Bathroom
Features: Bathtub, Separate Shower, Tub Shower
Kitchen
Features: Kitchen Island
Pantry
Features: Walk-In Pantry
Heating
Central, Natural Gas
Cooling
Central Air
Appliances
Included: Dishwasher, Gas Range, Ice Maker, Microwave, Refrigerator, Vented Exhaust Fan, Water To Refrigerator
Laundry: Laundry Room
Features
Breakfast Bar, Separate/Formal Dining Room, Furnished, Bedroom on Main Level, Primary Suite, Walk-In Pantry
Flooring: Laminate, Tile
Windows: Blinds
Has fireplace: No
Furnished: Yes
Interior area
Total interior livable area: 2,697 sqft
Property
Parking
Total spaces: 2
Parking features: Driveway
Attached garage spaces: 2
Features
Levels: Two
Stories: 2
Patio & porch: Covered
Has private pool: Yes
Pool features: In Ground, Waterfall
Spa features: Heated, In Ground
Fencing: Block,Wrought Iron
Has view: Yes
View description: Lake, Mountain(s)
Has water view: Yes
Water view: Lake
Waterfront features: Waterfront
Lot
Size: 3,485 Square Feet
Features: Close to Clubhouse, Landscaped, Level, Sprinklers Timer, Sprinkler System, Waterfront
Details
Parcel number: 696090018
Special conditions: Standard
Construction
Type & style
Home type: SingleFamily
Property subtype: Single Family Residence
Attached to another structure: Yes
Materials
Stucco
Condition
New construction: No
Year built: 2022
Community & HOA
Community
Features: Gated
Security: Fire Sprinkler System, Gated Community, 24 Hour Security
Subdivision: Terra Lago
HOA
Has HOA: Yes
Amenities included: Billiard Room, Clubhouse, Controlled Access, Fitness Center, Lake or Pond, Management, Meeting/Banquet/Party Room, Playground, Cable TV
HOA fee: $325 monthly
HOA name: Desert Resort Management
Location
Region: Indio
Financial & listing details
Price per square foot: $426/sqft
Tax assessed value: $820,399
Annual tax amount: $14,150
Date on market: 1/6/2026
Listing terms: Cash,Cash to New Loan
Estimated market value
Zestimate®
$1,112,200
Estimated sales range
$1.06M - $1.17M
Rent Zestimate®
$3,635/mo
Price history
Date
Event
Price
7/18/2026
Contingent
$1,150,000$426/sqft
Source: Greater Palm Springs Realtors #219140822Report a problem
1/6/2026
Listed for sale
$1,150,000+45.8%$426/sqft
Source: Greater Palm Springs Realtors #219140822Report a problem
Explore the cost of this home by adjusting the details. Changes won't be saved.
Principal & interest
$1,547
Mortgage insurance
$0
Property taxes
$170
Home insurance
$105
HOA fees
$0
Utilities
Not included
All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.