Contemporary

78515 Avenida Ultimo

La Quinta , CA 92253

MLS#: 219136566PS

$1,125,000

Status: Active
Listing number: 219136566PS
Listing provided by: Keller Williams Realty
Listing agent phone: None
Last update: 6 hours ago
New on site 1 day ago
Browse Properties
Desert Club Estates - Residential

Property

Beds

3

Full Baths

3

1/2 Baths

None

Year Built

1996

Sq.Footage

2,246

Custom designed gated 3 car garage home!!!Gorgeous remodeled kitchen and Primary Bath! Living Room, Formal Dining Room, Foyer, Great Room, Family Room, Casual Dining Room, Kitchen, Laundry Room, 3 Bedrooms (2 are matching primary suites) and 3 Full Bathrooms! Dramatic waterfall pool and spa! Living room/Dining Room have 12-foot ceilings, all the other rooms have 9-foot ceilings. Washer, Dryer, Counter-depth Frig, Gas Cook-top (w/ down-draft), Dishwasher, built-in Full-size Double Ovens, Built-in Beverage/Wine Frig and Built-in Microwave Oven. Kitchen remodel (2022). Italian Stainless-steel sink. Chrome Faucet. High-end Decorator solid chrome handles in kitchen, all 3 bathrooms, laundry room and closet. This subdivision is private and quiet, no through streets. No HOA! This home is great for entertaining. Living/dining room opens to the great room which opens to the yard/pool. open concept kitchen, family room, casual dining. Outdoor entertaining is ready with built in BBQ, large yard pool and spa, Fireplace (gas) and patio off of primary suite. Great family home or vacation home. Owned and Leased Solar.

Features & Amenities

Interior

  • Other Interior Features

    Breakfast Bar

  • Total Bedrooms

    3

  • Bathrooms

    3

  • Cooling YN

    YES

  • Cooling

    Gas

  • Fireplace YN

    YES

  • Heating YN

    YES

  • Heating

    Central, Natural Gas

  • Pet friendly

    N/A

Exterior

  • Garage

    Yes

  • Garage spaces

    3

  • Construction Materials

    Stucco

  • Parking

    Attached, Garage, Garage Door Opener

  • Pool

    Yes

  • Pool Features

    Private, Electric Heat, Waterfall

  • View

    Pool

Area & Lot

  • Lot Size(acres)

    0.3

  • Property Type

    Residential

  • Property Sub Type

    Single Family Residence

  • Architectural Style

    Contemporary

Price

  • Sales Price

    $1,125,000

  • Sq. Footage

    2, 246

  • Price/SqFt

    $500

HOA

  • Association

    NO

School District

  • Elementary School

    N/A

  • Middle School

    N/A

  • High School

    N/A

Property Features

  • Stories

    1

  • Senior Community YN

    NO

Schedule a Showing

Showing scheduled successfully.

<
>
IN PERSON
VIA CHAT

Change time

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.

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 Pat Bianchi , Keller Williams Realty

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.

Agent LinaMirza

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.
Custom designed gated 3 car garage home!!!Gorgeous remodeled kitchen and Primary Bath! Living Room, Formal Dining Room, Foyer, Great Room, Family Room, Casual Dining Room, Kitchen, Laundry Room, 3 Bedrooms (2 are matching primary suites) and 3 Full Bathrooms! Dramatic waterfall pool and spa! Living room/Dining Room have 12-foot ceilings, all the other rooms have 9-foot ceilings. Washer, Dryer, Counter-depth Frig, Gas Cook-top (w/ down-draft), Dishwasher, built-in Full-size Double Ovens, Built-in Beverage/Wine Frig and Built-in Microwave Oven. Kitchen remodel (2022). Italian Stainless-steel sink. Chrome Faucet. High-end Decorator solid chrome handles in kitchen, all 3 bathrooms, laundry room and closet. This subdivision is private and quiet, no through streets. No HOA! This home is great for entertaining. Living/dining room opens to the great room which opens to the yard/pool. open concept kitchen, family room, casual dining. Outdoor entertaining is ready with built in BBQ, large yard pool and spa, Fireplace (gas) and patio off of primary suite. Great family home or vacation home. Owned and Leased Solar.

78515 Avenida Ultimo

Message successfully sent.

What would you like to know?

Related Properties

New on site 1 day ago
A loaded 2021 Maserati Levante will be included in the sale of the house with favorable offer (photos Included). Welcome to this stunning 4-bedroom, 4-bathroom luxury home located in one of the Coachella Valley's most desirable gated communities, Lake La Quinta, offering 24/7 security, privacy, and resort-style living. Perfectly positioned just minutes from Coachella Festival, Stagecoach, Indian Wells Tennis Garden, world-class golf courses, scenic hiking trails, and premier shopping and dining, this turnkey furnished property is an ideal full-time residence, vacation home, or rental investment. Step inside to discover a bright, open-concept floor plan with travertine flooring throughout and a completely renovated kitchen featuring high-end finishes and modern appliances. The expansive great room is perfect for entertaining, with seamless indoor-outdoor flow. Three of the four spacious bedrooms offer en-suite bathrooms, recently updated with sleek, contemporary design elements. The oversized primary suite is a true retreat with a spa-like bathroom, large walk-in shower, and sliding glass doors that open to a private patio and sparkling pool. Outside, the landscaped backyard offers a peaceful escape with a heated pool, plenty of space to lounge or host guests, and mature greenery that adds privacy and charm. Additional highlights include brand-new Anderson windows and doors throughout, a finished three-car garage with epoxy floors, custom-built-in storage, a mini split system, and a dedicated EV charging. Residents enjoy exclusive access to community amenities including a scenic lake, community pool, and private park. The low monthly HOA fee includes 24-hour guard-gated security, high-speed internet, and a premium cable package. Homes like this rarely come on the market. Schedule your private showing today and experience luxury desert living at its finest.
#25603327PS

La Quinta

47925 Via Livorno

4 Beds

4 Baths

3,059 Sq.Ft.

$1,230,000

MLS#: 25603327PS

New on site 1 day ago
More information to come. Please contact Listing Agent with questions.
#219136562DA

La Quinta

52486 Avenida Mendoza

4 Beds

3 Baths

2,579 Sq.Ft.

$1,150,000

MLS#: 219136562DA

New on site 1 day ago
Elegant & ExclusiveStep into refined desert elegance at 50325 Via Amante, a stunning Palmilla retreat that defines luxury living in La Quinta.This exceptional single-story contemporary home with a detached casita, perfectly blends modern design with the serenity of resort-style surroundings.Step through the grand entryway into a dramatic Great Room with soaring ceilings and floor-to-ceiling pocket glass doors that seamlessly frame breathtaking views and lead to the backyard retreat. The open-concept design connects the living, dining, and chef's kitchen areas, enhanced by custom slate floors and refined designer finishes.The gourmet kitchen is beautifully appointed with granite countertops, a spacious island, double ovens, and premium appliances. A sleek wet bar off the Great Room enhances the home's entertainment appeal, while a private office or study behind double doors provides the perfect space to work or unwind in quiet comfort.The primary suite is a true sanctuary, offering a sitting area overlooking the pool, two walk-in closets, and a luxurious spa-style bath with dual vanities, a soaking tub, and a glass-enclosed stone shower. Two additional guest suites and a detached casita each offer their own ensuite baths--perfect for hosting family or friends with style and privacy.Outside, the home becomes a true desert oasis. Enjoy a saltwater Pebble Tec pool with cascading water features, a stacked-stone spa, multiple lounging and dining areas, and a built-in BBQ/outdoor kitchen. Expansive glass doors allow for effortless indoor-outdoor living, while motorized shades provide easy control over light and privacy.Located within Palmilla's 24-hour guard-gated enclave, residents enjoy both peace of mind and convenience--just minutes from La Quinta's world-class golf courses, hiking trails, fine dining, and resort destinations.With its elegant design, thoughtful floor plan, and exceptional setting, this home stands out as a perfect blend of style, comfort, and desert sophistication. Don't miss your opportunity to own one of Palmilla's finest properties.
#219136571DA

La Quinta

50325 Via Amante

3 Beds

3 Baths

3,278 Sq.Ft.

$1,050,000

MLS#: 219136571DA

New on site 2 days ago
Welcome to the popular Pasadera 1 Floor plan located behind the Legends gate at PGA West! This home offers 3 bedrooms, 3.5 baths including a private casita for your family & friends to enjoy! Great room concept with tile flooring, fireplace for those chilly nights, wet bar for entertaining all overlooking kitchen & dining area. The kitchen offers granite slab countertops, ample warm wood tone cabinetry, island for additional seating, & pantry! Primary suite has direct access to the pool & spa as well as a soaking tub, walk in shower, double vanities and walk in closet with built in storage. Step into the backyard that overlooks the Western mountains and double fairway of the 8th & 9th of Weiskopf Private Course! Enjoy the pool with flowing waterfall or soak in the raised spa that flows into the pool! There is a built in BBQ and plenty of patio area for gatherings or to relax and enjoy the sun! There is a 2 car garage plus a golf cart garage. This home is offered furnished per written inventory!
#219136524DA

La Quinta

57735 Seminole Drive

3 Beds

3 Baths

2,501 Sq.Ft.

$1,199,000

MLS#: 219136524DA

New on site 2 days ago
Experience the pinnacle of desert living in this rare Tamarisk model with detached casita, ideally situated on a private cul-de-sac within Trilogy La Quinta. Set on an expansive .35-acre homesite, this exceptional residence offers a beautifully landscaped front lawn, an inviting courtyard with ornate entry gate, three covered patios, an outdoor fireplace, and a resort-style pool and spa highlighted by a dramatic stone waterfall. Encompassing approximately 2,726 sq. ft. of refined single-level living, the home showcases 4 bedrooms, 4 bathrooms, a formal dining room with bay window, and a spacious great room with custom media niche. Recent upgrades include fresh interior and exterior paint (including the casita), new porcelain tile flooring with 7-inch baseboards, shutters, shades, and a custom-designed TV and electric fireplace wall. The gourmet kitchen is a true showpiece, boasting all-new cabinetry, quartz Gucci stone island, stainless steel sink, Monogram cooktop, built-in double ovens, designer accent walls and wall sconces, and a charming breakfast nook with custom bench seating and dry bar. The primary suite impresses with a tray ceiling, bay-window sitting area, walk-in closet, updated shutters, and a luxurious bathroom with separate shower. Additional enhancements include new toilets and faucets throughout, upgraded ceiling fans, custom built-ins, and a split 3-car garage. A rare offering of style, space, and upgrades, this home is not to be missed.
#219136521DA

La Quinta

81207 Santa Rosa Court

4 Beds

3 Baths

2,726 Sq.Ft.

$1,195,000

MLS#: 219136521DA

New on site 4 days ago
Elegant Lakefront Living in Prestigious Lago La QuintaSituated in the prestigious gated community of Lago La Quinta, this stunning 3-bedroom, 3-bathroom lakefront home offers 2,750 square feet of refined desert living with panoramic views of the Santa Rosa Mountains. Thoughtfully designed with both comfort and style in mind, the open-concept layout flows seamlessly from the spacious living area into the dining room and kitchen, creating the perfect setting for both entertaining and everyday relaxation.From the moment you step through the front door, the stunning lake and mountain views command your attention--a true show-stopper that sets the tone for the rest of the home. Expansive sliding glass doors invite natural light throughout the open-concept floor plan, seamlessly connecting the spacious living room, dining area, and chef-inspired kitchen. Perfect for entertaining or quiet evenings at home, the layout flows with ease and elegance.The gourmet kitchen boasts granite countertops, stainless steel appliances, a breakfast bar, and abundant storage--ideal for both casual dining and hosting. The primary suite offers a peaceful retreat with dual walk-in closets and a luxurious en-suite bathroom featuring dual vanities. Two additional bedrooms provide flexibility, with one thoughtfully transformed into a home theater with a high-definition projector.Outdoors, a covered patio creates the perfect setting for morning coffee or sunset dining, where shimmering lake waters and mountain silhouettes create a breathtaking backdrop. Mature landscaping, hardwood floors, recessed lighting, and fireplace further elevate the property's timeless appeal. Additional highlights include 4 year old sliding doors and A/C units, plus an attached two-car garage.Offering 72 homes as part of the world famous La Quinta Country Club, Lago La Quinta is a quiet, beautifully maintained enclave offering residents access to a scenic private lake, 3 community pools, a sport court with tennis/pickleball/basketball and a peaceful atmosphere. Conveniently located just minutes from world-class golf courses, shopping, dining, and Old Town La Quinta, this property blends luxury, privacy, and a resort-like setting.This rare lakefront opportunity combines timeless architecture with breathtaking surroundings--perfect as a full-time residence, seasonal escape, or investment property.
#219136421DA

La Quinta

77955 Lago Drive

3 Beds

3 Baths

2,750 Sq.Ft.

$1,150,000

MLS#: 219136421DA

New on site 4 days ago
Stunning Desert Resort Style Home with Scenic Mountain Views! This beautiful 4 bedroom and 3 bath home features an indoor-outdoor living space that integrates its natural landscape and mountain views with comfortable living. The home features an open floor plan, a modern chef-inspired kitchen with granite countertops, stainless steel appliances, inviting french doors facing the pool area with mountain views and a gas fireplace. This home has three remodeled bathrooms, three guest rooms, a primary bedroom with ensuite bathroom, a guest room with ensuite bathroom, indoor laundry and a 2 car garage. The outdoor living space has a relaxing salt water pool, large spa with bar area, well equipped outdoor kitchen for cooking and entertainment, a putting green, a fire pit for cozy nights and a tall stucco wall surrounding the property for privacy. There's NO HOA dues and the property is nestled within La Quinta Cove foothills just minutes from Old Town La Quinta, restaurants, shops and the Cove Walking Trails.
#SB25232940

La Quinta

53725 Avenida Villa

4 Beds

1 Baths

1,792 Sq.Ft.

$980,000

MLS#: SB25232940

Stunning single-story home with open-concept design featuring a great room that connects kitchen and living areas with the outdoors through expansive windows and sliders. Enjoy breathtaking Santa Rosa mountain views from the privacy of your thoughtfully configured side yard. Recently upgraded landscaping with beautiful new pavers enhances the outdoor living experience. Ideally located in a golfer's paradise with short-term rental approval (though current owners haven't rented it). This turnkey property comes fully furnished based on a detailed inventory list. Perfect for both personal enjoyment and potential investment opportunity.All details should be independently verified.The information presented here (anywhere) in this listing should be independently verified. We make no guarantee, warranty or representation. It is responsibility of any buyer/buyers agent to independently confirm accuracy and completeness.
#219136395DA

La Quinta

80034 Champions Way

3 Beds

3 Baths

1,901 Sq.Ft.

$1,295,000

MLS#: 219136395DA

A beautiful income producing home built in 2019 in stunning La Quinta. This property is located just a short drive to the famous PGA WEST. It has a spacious 2,236 square feet of luxury living space. The home offers a total of 4 bedrooms and 3 baths and includes a one bedroom attached casita with a full bathroom, walk-in closet and private entrance, The casita is great as a rental unit. A wonderful pool and spa greet you as you enter the front gate. There you find private courtyard, with fabulous views of the Santa Rosa Mountains. This home is a successful seasonal rental and popular with Coachella and Stagecoach festival goers. It has produced up to $15-$20K a month during the months of January through May. The home is just a few blocks from the Polo Grounds and Augustine Casino. You are walking distance to Old Town La Quinta and Civic Center Park. Dinning, shopping, and hiking/biking trails are conveniently located nearby. The open floor plan and well-appointed kitchen makes this home an entertainer's dream.
#219136392PS

La Quinta

51475 Calle Jacumba

4 Beds

3 Baths

2,236 Sq.Ft.

$1,189,000

MLS#: 219136392PS

- property

Send a message

Message successfully sent.

Your message

Reason for contacting?

Sign Out

Virtual Assistant

Would you like to take the next step with this property? We can help you schedule a showing or virtual tour, or send you more details.

Yes, I would like more information.

Thank You for Your Reply, One of Our Agents will contact you as soon as possible

No, maybe later.

Thank you, you can always contact me via email, phone number or through the contact form.

Realhub AI

Lucy - Your AI-Powered Realtor

Update Your Temporary Password

Personalize your search

Enter your email and we'll notify you immediately when new listings match what you're looking for.

or enter email address

Already have an account ? Login here

Continue your home search

Already have an account ? Login here