Property Attributes
- MLS#219140824
- TypeSingle Family
- Listing Status Active Under Contract
- CountyRiverside
- CityIndio
- AreaIndio North of I-10
- NeighborhoodTerra Lago
- Zip92203
- StyleSingle Family Residence
- Year Built2022
- Price$ 1,149,000
- Bedrooms4
- Full Bathrooms4
- Half Bathrooms0
- Sqr Footage2697
Data Source:
California Desert Association of REALTORS® (CDAR)
Property Description
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. 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 with four queen-size bunk beds significantly increases sleeping capacity and rental flexibility. Additional highlights include a massive movie-theater-style room with reclining chairs and surround sound, a game room with commercial-grade arcade games, built-in BBQ, firepit, 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 is fully stabilized, professionally operated, and 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 43199 Portuale Court, 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.
| Price History | |
|---|---|
| 3/16/2026 | Listed $1,150,000 |
| 8/5/2026 | Listed $1,149,000 |
General Features
| Living Area | 2697 |
|---|---|
| Sewer | In, Connected and Paid |
| Heating | Central |
| Cooling | Ceiling Fan(s),Central Air |
| HOA Fee | 325 |
| Garage Spaces | 2 |
| Pool Features | Heated,In Ground,Private |
| Security Features | 24 Hour Security,Fire Sprinkler System,Gated Community |
| Year Built | 2022 |
| View | Lake,Mountain(s),Panoramic |
| Levels | Two |
| Property Subtype | Single Family Residence |
| Assoc Fee Paid Per | Monthly |
| County | Riverside |
| Property Type | Residential |
| Association Amenities | Banquet Facilities,Billiard Room,Clubhouse,Controlled Access,Fitness Center,Lake or Pond,Playground |
| HOA | true |
| Attached Garage | true |
| Subdivision Name | Terra Lago |
| Status | Active Under Contract |
| City | Indio |
| Senior Community Y/N | false |
| MLS Area | 309 - Indio North of I-10 |
| Listing Terms | Cash to New Loan |
| Spa Features | Private,In Ground |
| Standard Status | Active Under Contract |
| Year Built Source | Assessor |
Interior Features
| Flooring | Ceramic Tile,Laminate |
|---|---|
| Furnished Y/N | Turnkey |
| Total Stories | 2 |
| Air Conditioning Y/N | true |
| Heating Y/N | true |
| Fireplace Y/N | false |
| 1/4 Baths | 1 |
| Total Baths | 4 |
Exterior Features
| Parking Features | Driveway |
|---|---|
| Total Parking | 2 |
| Lot Size Area | 4356 |
| Spa | true |
| Building Area Total | 2697 |
| Lot Size Source | Assessor |
Amenities
- Foreclosure
- Views
- Short Sale
- New Construction
- Adult 55+
- Lease To Own
- No HOA Fees
- Furnished
- Primary On Main
- Air Conditioning
- Seller Finance
- Green
- Fixer Upper
- Horse
- Golf
- Fireplace
- Deck
- Garage
- Basement
- Pool
Copyright © MFRMLS.com All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information on this site was last updated Last updated on September 24, 2026 4:32 PM UTC The listing information on this page last changed on Last updated on September 24, 2026 4:32 PM UTCd. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of MFR MLS.
All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Updated on September 24, 2026 4:32 PM UTC
Midwest Real Estate Data (MRED) All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of the Multiple Listing Service. Real estate listings held by brokerage firms other than eXp Realty in Illinois may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. Copyright ©2026 All rights reserved.Based on information submitted to the MLS GRID as of September 24, 2026 4:05 PM UTC All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice.
Data is updated as of September 24, 2026 4:05 PM UTC
Based on information from California Desert Association of Realtors as of September 24, 2026 4:04 PM UTC The information being provided by California Desert Association of Realtors, SoCalMLS, CRISNet MLS, and CARETS is for the consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumer may be interested in purchasing. Any information relating to real estate for sale referenced on this web site comes from the Internet Data Exchange