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
| MLS # | 219153793DA |
|---|---|
| Listing Type | For Sale |
| Style | House |
| HOA Dues | $285 |
| Sub-Type | Resale |
| Status | Active |
| Year | 2006 |
| Days On Site | 26 |
| Listing Provided By | HomeSmart | David Colin |
| Bed(s) | 3 |
|---|---|
| Bath(s) | 3 Total |
| SQ Feet | 2,157 |
| Garage | 2 |
| Pool | Yes |
| Story(s) | 2 |
| Acreage | 0.10 |
| Property View | Yes |
| Heating | Central |
|---|---|
| Heating Yes / No | Yes |
| Cooling Yes / No | Yes |
| Appliances | Dishwasher, Ice Maker, Microwave, Refrigerator |
| Fireplace Yes / No | Yes |
| Security Features | Gated Community, Twenty Four Hour Security |
|---|---|
| Fencing | Block |
| Attached Garage Yes / No | Yes |
|---|---|
| Parking Features | Direct Access, Garage, Garage Door Opener |
| Garage Yes / No | Yes |
| Community Features | Gated |
|---|
| State | CA |
|---|---|
| County | Riverside |
| City | Indio |
| Zip Code | 92203 |
| Area | 309 Indio North of East Valley |
| Community Name | Terra Lago |
| Listing VS Median (in Terra Lago) | |
Price: $999,900 low | high Med: $614,999 sqft: 2,157 low | high Med: 2,371 $ / sqft: $464 low | high Med: $259 On site: 26 low | high Med: 17 | |
| State | CA |
|---|---|
| County | Riverside |
| City | Indio |
| Zip Code | 92203 |
| Area | 309 Indio North of East Valley |
| Community Name | Terra Lago |
| Listing VS Median (in Terra Lago) | |
Price: $999,900 low | high Med: $614,999 sqft: 2,157 low | high Med: 2,371 $ / sqft: $464 low | high Med: $259 On site: 26 low | high Med: 17 | |