-
Home type
Single family
-
Year built
2006
-
Lot size
4,356 sq ft
-
Price per sq ft
$464
-
HOA fees
$285 / Mo
-
Last updated
1 day ago
-
Views
12
Questions? Call us: (442) 256-9088
Overview
A rare opportunity to acquire a proven, high-performing lakefront short-term rental in Terra Lago--positioned for the investor who understands that the best STR acquisitions combine documented revenue, differentiated amenities, a strong depreciation basis, and the ability to perform from day one.This fully established 3-bedroom, 3-bath, 2,157-square-foot lakefront retreat generated $131,000 in verified gross rental revenue in 2025 and is currently on pace to exceed that performance in 2026. Unlike a speculative STR purchase where the buyer must renovate, furnish, build reviews and establish a rental history, this property already has the amenities and proven performance guests are looking for.The outdoor space is the centerpiece: a private saltwater pool and spa, expansive lake and mountain views, commercial-grade misters, lakeside fire pit, built-in BBQ, covered outdoor TV lounge and multiple entertaining areas create a true resort-style guest experience. Inside, the property features an open entertaining layout, custom bar, upgraded finishes, custom TV wall and a private primary-suite balcony overlooking the water. An arcade/game-room component further enhances the property's appeal to vacation-rental guests. The home accommodates up to 10 guests and has been thoughtfully positioned to compete in Indio's event-driven STR market. For investors focused on tax efficiency, the numbers become even more compelling. Public tax records currently allocate approximately $302,757 to land and $706,429 to improvements, meaning roughly 70% of the current assessed value is attributed to improvements rather than non-depreciable land. A buyer should have their CPA and cost-segregation specialist establish the appropriate allocation at acquisition, but the property's substantial building and amenity basis--including the pool, spa, outdoor improvements, furnishings and qualifying components--could make it an attractive candidate for a cost-segregation study and accelerated depreciation, subject to the buyer's individual tax situation.CompassFor a 1031 exchange buyer, this is an opportunity to move equity into an established income-producing vacation rental rather than starting from scratch. For the hybrid buyer, it offers something equally compelling: a lakefront desert residence that can be personally enjoyed while producing meaningful rental income when not in use. And for an investor looking to enter the STR market, the property provides a documented
Interior
Appliances
- Microwave, Refrigerator, Ice Maker, Dishwasher
Bedrooms
- Bedrooms: 3
Bathrooms
- Total bathrooms: 3
- Quarter baths: 1
- Full baths: 2
Heating
- Central
Fireplace
- 1, Gas,Family Room
Features
- Media Room
Levels
- Two
Size
- 2,157 sq ft
Exterior
Private Pool
- Yes
Garage
- Attached
- Garage Spaces: 2
- Direct Garage Access
- Garage Door Opener
Carport
- None
Year Built
- 2006
Lot Size
- 0.1 acres
- 4,356 sq ft
Waterfront
- No
Community Info
HOA Information
- Association Fee: $285
- Association Fee Frequency: Monthly
- Association Fee Includes: Gym, Playground, Lake, Clubhouse, Barbecue, Meeting/Banquet/Party Room, Billiard Room
Senior Community
- No
Location
- City: Indio
- County/Parrish: Riverside
Listing courtesy of: David Colin, HomeSmart
MLS ID: 219153793DA
Based on information from California Regional Multiple Listing Service, Inc. as of Oct 09, 2026 and/or other sources. All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.
Terra Lago Real Estate Agent
Want to learn more about Terra Lago?
Here is the community real estate expert who can answer your questions, take you on a tour, and help you find the perfect home.
Get started today with your personalized 55+ search experience!
Want to learn more about Terra Lago?
Get in touch with a community real estate expert who can answer your questions, take you on a tour, and help you find the perfect home.
Get started today with your personalized 55+ search experience!
Homes Sold:
55+ Homes Sold:
Sold for this Community:
Avg. Response Time:
Community Key Facts
Age Restrictions
- 55+
Amenities & Lifestyle
- See Terra Lago amenities
- See Terra Lago clubs, activities, and classes
Homes in Community
- Total Homes: 639
- Home Types: Single-Family, Attached
Gated
- Yes
Construction
- Construction Dates: 2005 - Present
- Builder: K. Hovnanian, Multiple Builders
Similar homes in this community
Popular cities in California
The following amenities are available to Terra Lago - Indio, CA residents:
- Clubhouse/Amenity Center
- Golf Course
- Restaurant
- Fitness Center
- Outdoor Pool
- Hobby & Game Room
- Card Room
- Arts & Crafts Studio
- Ballroom
- Library
- Billiards
- Walking & Biking Trails
- Lakes - Scenic Lakes & Ponds
- R.V./Boat Parking
- Playground for Grandkids
- Demonstration Kitchen
- Table Tennis
- Outdoor Patio
- Golf Practice Facilities/Putting Green
- On-site Retail
- Multipurpose Room
- Business Center
There are plenty of activities available in Terra Lago. Here is a sample of some of the clubs, activities and classes offered here.
- Arts & Crafts
- Billiards
- Cards
- Golf
- Halloween Party
- Holiday Party
- Spring Eggstravaganza
- Table Tennis
- Western BBQ




