51245 Charlbury Street

Indio , CA 92201

MLS#: 219133114DA

$1,195,000

Status: Active

Listing number: 219133114DA

Listing provided by: Vine Property Group, Inc.

Listing agent phone: None

Last update: 5 days ago

On site: 21 days ago

Browse Properties

Email
Pinterest
Facebook
X
Print

Property

Beds

Full Baths

1/2 Baths

None

Year Built

2014

Sq.Footage

2,278

RARE OPPORTUNITY...Highly Customized & Meticulously Maintained Showstopper in CLOSE PROXIMITY to the CLUBHOUSE...Pristine SOLAR Powered Incantare Model (3BR/2.5BA + SmartSpace - 2,278 Sq. Ft. ) Featuring Attached 2-Room Casita & Exceptional Outdoor Living Area. Once you step into the formal entry you're met with the stunning sense of QUALITY, CHARACTER, AND CHARM. The open great room layout with high ceilings, built-in speakers, sparkling light fixtures, rolling walls of glass and formal dining room is the ideal centerpiece for hosting and entertaining. Spacious kitchen features upgraded lighting, dramatic island with bar seating, stainless steel appliances and upgraded cabinetry. The primary suite features separate vanities, upgraded stone and tile appointments, customized built-in closet and passthrough access to laundry/SmartSpace. The guest bedroom and adjacent powder bath are located off the entry, while the 2-Room Casita with private entrance features cozy sitting room / den with wet-bar and en-suite bedroom with customized walk-in closet. Thoughtful SmartSpace with built-in cabinetry features two work stations with slab counters. Spacious covered patio with built-in speakers, paver decking, 3 retractable awnings, built-in BBQ with Allumawood Pergola and sparkling pool/spa offers ample outdoor entertaining. Customized and air conditioned garage features built-in cabinetry / work station, overhead storage, epoxy flooring, and whole house water purification system. Sonos sound system included. Don't miss your opportunity to own one of Trilogy Polo's Finest! Membership transfer available.

Features & Amenities

Interior

Other Interior Features

Wet Bar, Breakfast Bar, Built-in Features, High Ceilings, Recessed Lighting, Storage, Wired for Sound, Walk-In Closet(s)
Total Bedrooms

3
Bathrooms

2
Cooling YN

YES
Cooling

Zoned
Fireplace YN

NO
Heating YN

YES
Heating

Forced Air

Exterior

Garage

Yes
Garage spaces

2
Construction Materials

Stucco
Other Exterior Features

Barbecue
Parking

Attached, Direct Access, Driveway, Garage, Garage Door Opener
Patio and Porch Features

Covered, Wrap Around
Pool

Yes
Pool Features

Private, Community, Electric Heat, In Ground, Lap
View

Pool

Area & Lot

Lot Features

Back Yard, Close to Clubhouse, Landscaped
Lot Size(acres)

0.18
Property Type

Residential
Property Sub Type

Single Family Residence

Price

Sales Price

$1,195,000
Sq. Footage

2, 278
Price/SqFt

$524

HOA

Association

YES
Association Fee

$245
Association Fee Frequency

Monthly
Association Fee Includes

N/A

School District

Elementary School

N/A
Middle School

N/A
High School

N/A

Property Features

Stories

1
Association Amenities

Billiard Room, Clubhouse, Fitness Center, Maintenance Grounds, Game Room, Management, Recreation Room, Security, Tennis Court(s)
Foundation Details

Slab
Senior Community YN

YES

Schedule a Showing

Showing scheduled successfully.

IN PERSON

VIA CHAT

Mortgage calculator

Estimate your monthly mortgage payment, including the principal and interest, property taxes, and HOA. Adjust the values to generate a more accurate rate.

Home price($)

Home price

The price of the home you wish to purchase. This can be either the listing price or your offer price.

Down payment(%)

Down payment

The amount that you plan to put down on the home. Increasing the down payment will lower your monthly mortgage.

Interest rate(%)

Interest Rate

The percent interest on your loan. This percentage is typically influenced by the current market, as well as your financial health.

Loan term(years)

Term

The length of the loan program.

Property tax($ per month)

Property Tax

The amount of tax per month on your home.

HOA fees($)

HOA Fees

Homeowners association fees. These fees may be owed in order to maintain and improve properties in the association.

Your payment

Principal and Interest:

Property taxes:

HOA fees:

Total loan payment:

Total interest amount:

Location

County

Riverside

Elementary School

Middle School

High School

Listing Courtesy of Josh Essig , Vine Property Group, Inc.

RealHub Information is provided exclusively for consumers' personal, non-commercial use, and it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. All information deemed reliable but not guaranteed and should be independently verified. All properties are subject to prior sale, change or withdrawal. RealHub website owner shall not be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless.

FOUNDER

LinaMirza

Call Lina today to schedule a private showing.

(818) 321-0175

Lina@theosrealty.com

* Listings on this website come from the FMLS IDX Compilation and may be held by brokerage firms other than the owner of this website. The listing brokerage is identified in any listing details. Information is deemed reliable but is not guaranteed. If you believe any FMLS listing contains material that infringes your copyrighted work please click here to review our DMCA policy and learn how to submit a takedown request.© 2024 FMLS.

RARE OPPORTUNITY...Highly Customized & Meticulously Maintained Showstopper in CLOSE PROXIMITY to the CLUBHOUSE...Pristine SOLAR Powered Incantare Model (3BR/2.5BA + SmartSpace - 2,278 Sq. Ft. ) Featuring Attached 2-Room Casita & Exceptional Outdoor Living Area. Once you step into the formal entry you're met with the stunning sense of QUALITY, CHARACTER, AND CHARM. The open great room layout with high ceilings, built-in speakers, sparkling light fixtures, rolling walls of glass and formal dining room is the ideal centerpiece for hosting and entertaining. Spacious kitchen features upgraded lighting, dramatic island with bar seating, stainless steel appliances and upgraded cabinetry. The primary suite features separate vanities, upgraded stone and tile appointments, customized built-in closet and passthrough access to laundry/SmartSpace. The guest bedroom and adjacent powder bath are located off the entry, while the 2-Room Casita with private entrance features cozy sitting room / den with wet-bar and en-suite bedroom with customized walk-in closet. Thoughtful SmartSpace with built-in cabinetry features two work stations with slab counters. Spacious covered patio with built-in speakers, paver decking, 3 retractable awnings, built-in BBQ with Allumawood Pergola and sparkling pool/spa offers ample outdoor entertaining. Customized and air conditioned garage features built-in cabinetry / work station, overhead storage, epoxy flooring, and whole house water purification system. Sonos sound system included. Don't miss your opportunity to own one of Trilogy Polo's Finest! Membership transfer available.

51245 Charlbury Street

Message successfully sent.

First Name

Last Name

Phone

What would you like to know?

I agree to receive email communication and understand I can unsubscribe at any time.

Related Properties

New on site 1 day ago

Stunning Luxurious Mansion with Breathtaking Views – A Rare Gem!

Experience the pinnacle of elegance in this extraordinary, custom-designed two-story masterpiece that redefines the very essence of luxury living. From the moment you arrive, you are greeted by flawless craftsmanship, striking architectural design, and an unrivaled location that offers both prestige and tranquility. This is one of the very few fully detached residences on the lake, a rarity that not only enhances privacy and exclusivity but also adds exceptional long-term value. The grand first floor unveils a spacious two-car garage and an opulent master bedroom, exquisitely appointed with designer finishes to create the ultimate retreat, accompanied by a tastefully finished half bath that blends convenience with sophistication. Ascend the sweeping staircase to the second floor, where three additional lavish master bedrooms each offer a private sanctuary of comfort and style, complemented by an expansive loft perfect for grand entertaining or intimate gatherings. The primary master suite is a haven of indulgence, boasting a large walk-in closet, a luxurious en-suite with an expansive shower area, and a private balcony that commands awe-inspiring panoramic views—ideal for savoring your morning coffee or evening sunsets. Beyond its beauty, this estate presents an exceptional investment opportunity with no restrictions on short-term rentals, making it perfect for Airbnb, VRBO, or private luxury stays. Its prime location ensures year-round demand with world-class golf, tennis, equestrian, and soccer tournaments nearby, along with the iconic Coachella Valley Music & Arts Festival just ten minutes away. Whether you seek an incomparable personal residence or a high-performing investment, this lakefront jewel delivers unmatched elegance, exclusivity, and potential—an architectural treasure for the most discerning buyer.

Indio

43180 Portuale Court

4 Beds

4 Baths

2,697 Sq.Ft.

$1,200,000

MLS#: BB25182018

Welcome to your desert sanctuary, where designer finishes meet resort-style living in the exclusive community of Trilogy at the Polo Club. This immaculate home is a designer's dream, thoughtfully curated with luxury in every detail. Step inside to soaring ceilings, abundant natural light, an open-concept floor plan that seamlessly blends indoor and outdoor living. The gourmet kitchen stuns with quartz countertops, custom tile backsplash, sleek cabinetry, and top-of- the line stainless steel appliances- a true entertainer's paradise. The expansive great room flow effortlessly to the outdoor covered patio through large format sliding doors, creating the perfect setting entertaining or relaxing desert evenings under the stars. Enjoy privacy and comfort in the spacious primary suite with spa-like bath, walk in closet, and serene backyard views. The main living space drips in luxury as the custom fireplace brings warmth to the space and calls you to cozy up with a book or pour yourself a cocktail and unwind. Whether your full time or just looking for a luxe desert retreat, this home has it all.This home is offered with an optional social club membership transfer fee of $1875.Guard-gated 55+ Community with low HOA. Club amenities include: tennis/pickle ball courts, fitness center, resort/lap pools, poker/billiards room, restaurant/bar and artisan & culinary studios and a wonderful clubhouse. Lots of activities for everyone. This is a must see home.

Indio

82460 W Mccarroll Drive

3 Beds

3 Baths

2,367 Sq.Ft.

$1,275,000

MLS#: 219133792DA

**PASSIVE INCOME** Short Term rental Friendly!Discover this stunning Terra Lago property, built in 2018 and located on a premium lot ON THE WATER with an amazing view. Terra Lago properties on the water are highly sought after and Airbnb guests will pay top dollar to stay here so they produce great passive income!This luxurious home features 3 bedrooms and top-tier upgrades. The airy great room blends the kitchen, living, and dining areas, highlighted by soaring custom wood ceilings and abundant natural light. The kitchen impresses with custom countertops, a sunken wet bar, a spacious island, and stainless steel appliances.Upstairs, the primary suite offers a covered patio with scenic lake and mountain views, a spa-style shower, and a modern soaking tub in the en suite bathroom. Two additional guest bedrooms, and a shared hall bathroom complete the upper level. Step outside to the entertainer's backyard, featuring an infinity-edge swimming pool and breathtaking vistas. Community amenities include a pool, gym, and 24-hour controlled access for peace of mind.

Indio

43157 Armonia Court

3 Beds

2 Baths

2,157 Sq.Ft.

$1,150,000

MLS#: 219133702DA

A Once-in-a-Lifetime Investment Opportunity | Award-Winning Samurai-Themed STR Gem on the Lake in Terra LagoWelcome to the most unique and iconic short-term rental property in the entire Coachella Valley -- a traditional Japanese Samurai-themed masterpiece, perfectly situated on the lake in the prestigious, short-term rental-friendly community of Terra Lago. With no rental restrictions and a reputation for producing some of the area's most profitable Airbnb listings, this home is a rare trophy asset for any investor or 1031 exchange buyer seeking high CAP rate performance and long-term appreciation.This stunning 4-bedroom, 3-bathroom retreat features a spacious upstairs loft (convertible into a 5th bedroom), and has undergone a $200,000+ luxury renovation, including all new high-end furnishings. Designed with attention to cultural detail, this home has won multiple Airbnb People's Choice awards for guest satisfaction and design.The one-of-a-kind outdoor gazebo and lakeside fireplace set the tone for unforgettable guest experiences, making this home a true standout in the short-term rental market.Located just minutes from world-famous attractions like Coachella and Stagecoach Festivals, Indian Wells Tennis Garden, Acrisure Arena, and the upcoming Thermal Surf Wave Park, the home sits in one of the most strategic and desirable investment corridors in the desert.Whether you're looking to expand your real estate portfolio, capitalize on high-yield passive income, or complete a 1031 exchange into a proven cash-flowing asset, this is a rarely seen opportunity that combines location, uniqueness, and performance.Don't miss your chance to own a piece of art, culture, and income -- all in one.

Indio

43220 Portuale Court

4 Beds

3 Baths

2,416 Sq.Ft.

$1,150,000

MLS#: 219133698DA

LAKEFRONT Home with mountain views an Infinity edge pool, designer furniture and more. This highly upgraded and super large floor plan has 4 bedrooms, 4.5 baths with a bonus room/loft upstairs. One bedroom and bath is down stairs on the main level. Glorious light bright kitchen with quartz countertops, a large center island, stainless steel appliances and lots of storage. This is a smart home with OWNED SOLAR and home automation features. Also includes an electric car charging station in the garage. HOA Amenities include Community Pool and Recreation Facility, a gym and billiard room, community pool & spa, and 24 hour controlled access with a guard at the gate. Also included is internet, and cable TV. Golf courses, Casinos and shopping are all very close by. SOLD TURNKEY FURNISHEDThere is some rental history with AirBnB and VRBO.

Indio

84650 Litorale Court

4 Beds

3 Baths

2,697 Sq.Ft.

$1,049,000

MLS#: 219133374DA

Stunning Lakefront Investment Opportunity – No Rental Restrictions!

Welcome to a truly one-of-a-kind investment opportunity located in a community renowned for its short-term rental-friendly policies and NO rental restrictions. This beautifully appointed 4-bedroom, 3-full bathroom waterfront home offers the perfect blend of luxury, comfort, and exceptional income potential—an ideal choice for investors or anyone seeking a premium lakeside retreat.

Perfectly situated in the most desirable location on the lake, this property boasts easy access to top local attractions including Fantasy Springs Resort Casino, the world-famous Coachella and Stagecoach music festivals, and the prestigious annual Indian Wells Tennis Tournament. Whether you're looking for a high-performing income property or a relaxing vacation home, this residence delivers on all fronts.

Comparable homes in the area generate over $130,000+ in annual gross rental income, and this expansive lakefront gem is poised to outperform expectations, thanks to its size, upgrades, and unbeatable location.

This property is One of the largest homes on the lake with 4 spacious bedrooms and 3 full bathrooms

Open-concept living area featuring luxury finishes, a stylish fireplace, and a built-in bar with wine fridge

Chef’s kitchen with high-end appliances, modern countertops, walk-in pantry, and ample cabinetry

Designer-furnished interiors with modern, airy décor curated for guest comfort and style

Step in outside to Resort-style backyard with:

Sparkling pool with water and fire features, Oversized 12-person Jacuzzi (one of the largest in the area) Professional outdoor BBQ station Natural granite pavers and lush palm landscaping, Breathtaking views of the lake and picturesque bridge Property also comes with a Private boat dock and to sweeten the deal included in the sale Electric boat and a trailer.

This turnkey property comes fully furnished and Airbnb-ready—set up for immediate passive income with no additional effort required.

Don’t miss your chance to own a rare lakefront property that combines high-end living with outstanding earning potential. Whether you're an investor or someone looking to enjoy Lakefront luxury living, this home is ready to deliver.

Indio

43196 Bacino Court

4 Beds

3 Baths

2,726 Sq.Ft.

$1,200,000

MLS#: CV25171343

Located in the desirable Terra Lago community, this stunning 4-bedroom, 3-bathroom home offers over 3,100 square feet of luxurious living space on a generous 10,019 sq ft lot. Designed with comfort and style in mind, the home features soaring high ceilings, recessed lighting, and an open floor plan ideal for both everyday living and entertaining. The family room centers around a cozy fireplace, seamlessly flowing into a chef’s kitchen equipped with a center island, stainless steel appliances, and ample cabinet space. The spacious bedrooms provide plenty of room for relaxation, including a luxurious primary suite with a spa-like bathroom featuring a soaking tub and separate shower. Step outside to a true entertainer’s dream backyard—complete with a covered patio, sparkling pool and spa, built-in BBQ area, and a fire pit perfect for gathering under the stars. Terra Lago is a gated community known for its exceptional amenities, including a 20 acre lake, a 10,000 square foot clubhouse with a fitness center, billiards room, and event spaces, access to the Golf Club at Terra Lago, featuring two 18-hole championship courses, walking trails, playgrounds, and a dog park for outdoor enjoyment. This home offers the perfect blend of comfort, function, and resort-style outdoor living in one of the area’s most sought-after communities.

Indio

43875 Spiaggia Place

4 Beds

3 Baths

3,142 Sq.Ft.

$1,099,000

MLS#: SR25170308

Turnkey Furnished and Ready to Cash Flow atop the 9th Green at Terra Lago! This stunning pool home is fabulous SHORT-TERM RENTAL moneymaker. Perfectly positioned to capture panoramic mountain views, this entertainer's paradise is filled with resort-style amenities designed to impress. The saltwater pool and spa, 31-foot putting green, poolside fire pit, misting system, and color-changing pool lights create a five-star outdoor experience. A built-in Blaze grill and multiple lounge areas enhance the vacation atmosphere. Inside, the open-concept floor plan includes a spacious living room, an island-centered kitchen with stylish finishes, a dining area, and a game room that is perfect for hosting large groups. Two guest bedrooms are located on the main level, providing excellent separation and privacy. Upstairs, the Primary Suite features a large private deck with stunning views and a luxurious ensuite bath with soaking tub and separate shower. Two additional guest bedrooms share a full bath, and the second-floor laundry room adds everyday convenience. Low HOA dues include guard-gated security and access to a fitness center. The Golf Club at Terra Lago offers 36 scenic holes, and nearby Badlands Trail is perfect for hiking and outdoor adventure. Located just minutes to the Coachella and Stagecoach festivals as well! Take the Matterport Virtual Tour to experience the layout and flow of this exceptional property.

Indio

42776 Del Lago Court

5 Beds

3 Baths

2,431 Sq.Ft.

$1,095,000

MLS#: 25570465PS

SPECTACULAR NEW TURNKEY WATERFRONT HOME! Luxury resort living with panoramic views of the lake and mountains from your private heated pool & spa. As you step into the opulent kitchen, you are greeted by a culinary paradise featuring sleek quartz countertop and high-end appliances, Kitchen opens up to elegant dining area and a spacious living room with a breathtaking view of the lake. This beautiful home has 5 bedrooms. The luxurious owner's retreat has en-suite bathroom, dual vanities, ceramic tile walk-in shower, walk-in closet and access to a private terrace to relax and enjoy a glass of wine or your morning coffee. Junior suite on second level features an en-suite bathroom. Second junior suite on the first-floor level has an en-suite bathroom, perfect for your guests. Bedrooms 4 and 5 share a hallway bathroom with separate dual vanities. HOA includes free Internet, cable TV and guard, controlled access. It has a garage for 2 cars. This is one of the only homes with no houses across the lake! This home has it all to gather your family and friends to enjoy all of the amazing amenities: Clubhouse, Pool, Playground, Gym, Recreation Room, and Hiking Trails. This Gorgeous home is located within minutes from Palm Springs, Coachella Valley and Joshua Tree National Park. YOUR DREAM LUXURY RENTAL AWAITS AS A SHORT-TERM RENTALS ARE ALLOWED IN TERRA LAGO!

Indio

84657 Litorale Court

5 Beds

4 Baths

2,416 Sq.Ft.

$1,100,000

MLS#: SW25166745

Features & Amenities

Interior

Exterior

Area & Lot

Price

HOA

School District

Property Features

Schedule a Showing

Mortgage calculator

Listing Courtesy of Josh Essig , Vine Property Group, Inc.

Related Properties

Virtual Assistant

Realhub AI

Lucy - Your AI-Powered Realtor

Update Your Temporary Password

Accessibility Menu

Personalize your search

Continue your home search