• 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

Request a tour

Select your preferred date and time below. An agent will reach out to confirm your request.

Times are shown in the local time zone of the property.


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

Crmls

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:

Global - Lead Form - Buyer Only
*55places does not provide or maintain community HOA information.
By requesting more information, you agree that 55places placeholder may call, text, or email you about your inquiry, which may be made with automated means (including recorded voice messages, SMS, or text messages). You understand that your consent is not a prerequisite for buying, selling or renting a property. You may revoke your consent at any time by contacting optout@55places.com. Message/data rates may apply. You also agree to 55places.com's Privacy Policy and Terms of Use.

Community Key Facts

Terra Lago

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 Terra Lago

$950,000
4 Beds | 3 Baths | 2726 Sq. Ft.
MLS CV26194948
First Paciific Realty, Alexander Seropian
$899,000
5 Beds | 4 Baths | 2416 Sq. Ft.
MLS 26989963PS
Keller Williams Luxury Homes, Brady Sandahl
$759,000
4 Beds | 3 Baths | 2416 Sq. Ft.
MLS 219152055DA
Keller Williams Luxury Homes, Lori Halleck

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:

Global - Lead Form - Buyer Only
*55places does not provide or maintain community HOA information.
By requesting more information, you agree that 55places placeholder may call, text, or email you about your inquiry, which may be made with automated means (including recorded voice messages, SMS, or text messages). You understand that your consent is not a prerequisite for buying, selling or renting a property. You may revoke your consent at any time by contacting optout@55places.com. Message/data rates may apply. You also agree to 55places.com's Privacy Policy and Terms of Use.

Agent Image
 

Community Expert

Call Us Call Us
Scroll to Top