54474 Avenida Herrera

La Quinta , CA 92253

MLS#: 219134521DA

$795,000

Status: Active
Listing number: 219134521DA
Listing provided by: Cool Digs
Listing agent phone: None
Last update: 7 hours ago
On site: 14 days ago
Browse Properties
La Quinta Cove - Residential

Property

Beds

3

Full Baths

3

1/2 Baths

None

Year Built

1967

Sq.Footage

1,904

Location, Location, Vacation! Welcome to Casabella, a SEXY Mid-Century Home w/Modern Flair Perched on a DOUBLE CORNER Lot with a Fully Equipped Detached GUEST HOUSE. Move-in Ready, HIGH in the Cove with Jaw Dropping Views of the Santa Rosa Mountains, the Floor Plan is Everything Today's Buyers Covet: BRIGHT and OPEN w/an Abundance of Natural Light. You'll Appreciate the Functional Floor Plan, the Neutral Color Schematic, a Generous Kitchen with a Quartz Island, a Versatile Room w/Murphy Bed, and Spacious Grounds w/a Private SPOOL. The Attached Guest House has a Bedroom, a Full Bath, Living Room, Functional Kitchen and a Separate Entrance, a Rare Feature for the LQ Cove. Other Notable Features are an Outdoor Shower and Numerous Conversation Areas Throughout, for Outdoor Enjoyment Amongst the Views. TURNKEY FURNISHED and Truly a Triple Option of Opportunity; a Primary Residence, a Vacation Getaway -or- a Fantastic Rental Opportunity that could be Ready for Revenue! BONUS: No HOA's, Close to Hiking/Biking Trails & Minutes from Shopping and Dining in Old Town, Golfing, the Polo/Concert Grounds and all that the Desert has to Offer!

Features & Amenities

Interior

  • Other Interior Features

    Breakfast Bar, Walk-In Closet(s), Master Downstairs

  • Total Bedrooms

    3

  • Bathrooms

    3

  • Cooling YN

    YES

  • Cooling

    Central Air

  • Fireplace YN

    NO

  • Heating YN

    YES

  • Heating

    Central, Forced Air, Propane, Natural Gas

  • Pet friendly

    N/A

Exterior

  • Garage

    Yes

  • Garage spaces

    2

  • Construction Materials

    Stucco

  • Parking

    Attached, Driveway, Garage, Garage Door Opener, Side By Side

  • Patio and Porch Features

    Covered

  • Pool

    Yes

  • Pool Features

    Private, Gunite, Electric Heat, In Ground, Tile, Waterfall

  • View

    Mountain(s), Panoramic

Area & Lot

  • Lot Features

    Back Yard, Corner Lot, Landscaped, Rectangular Lot

  • Lot Size(acres)

    0.23

  • Property Type

    Residential

  • Property Sub Type

    Single Family Residence

Price

  • Sales Price

    $795,000

  • Sq. Footage

    1, 904

  • Price/SqFt

    $417

HOA

  • Association

    NO

School District

  • Elementary School

    Truman

  • Middle School

    La Quinta

  • High School

    La Quinta

Property Features

  • Stories

    1

  • Foundation Details

    Slab

  • 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

Truman

Middle School

La Quinta

High School

La Quinta

Listing Courtesy of T.J. McCaa , Cool Digs

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.
Location, Location, Vacation! Welcome to Casabella, a SEXY Mid-Century Home w/Modern Flair Perched on a DOUBLE CORNER Lot with a Fully Equipped Detached GUEST HOUSE. Move-in Ready, HIGH in the Cove with Jaw Dropping Views of the Santa Rosa Mountains, the Floor Plan is Everything Today's Buyers Covet: BRIGHT and OPEN w/an Abundance of Natural Light. You'll Appreciate the Functional Floor Plan, the Neutral Color Schematic, a Generous Kitchen with a Quartz Island, a Versatile Room w/Murphy Bed, and Spacious Grounds w/a Private SPOOL. The Attached Guest House has a Bedroom, a Full Bath, Living Room, Functional Kitchen and a Separate Entrance, a Rare Feature for the LQ Cove. Other Notable Features are an Outdoor Shower and Numerous Conversation Areas Throughout, for Outdoor Enjoyment Amongst the Views. TURNKEY FURNISHED and Truly a Triple Option of Opportunity; a Primary Residence, a Vacation Getaway -or- a Fantastic Rental Opportunity that could be Ready for Revenue! BONUS: No HOA's, Close to Hiking/Biking Trails & Minutes from Shopping and Dining in Old Town, Golfing, the Polo/Concert Grounds and all that the Desert has to Offer!

54474 Avenida Herrera

Message successfully sent.

What would you like to know?

Related Properties

New on site 1 day ago
Stunning 3 Bedroom, 2 Bathroom Oasis in La Quinta Cove! Welcome to your dream home nestled in the serene La Quinta Cove! This beautifully updated property offers three spacious bedrooms and two modern bathrooms perfect for families, seasonal living, or anyone seeking a refined desert retreat. What sets this home apart is the incredible investment in recent updates , making it a truly move-in ready opportunity. The pool has been resurfaced and outfitted with a new pump (just 1 year old), ensuring a refreshing private oasis at your fingertips. The A/C unit upgrade, repaired water heater, and brand-new whole house water softener all provide lasting comfort and peace of mind. Step inside and you'll fall in love with the freshly remodeled kitchen , featuring brand new appliances, a walk-in electric pantry, and a modern island with electrical connections'perfect for both everyday living and entertaining. The open concept living space is anchored by a stylish fireplace wall and built-in TV drop, creating a warm and inviting atmosphere for gatherings. The primary suite is designed for relaxation, complete with a remodeled en-suite bathroom and a spacious walk-in closet. Both bathrooms have been thoughtfully renovated with modern finishes, while the entire home shines with new flooring, fresh interior and exterior paint, and luxurious custom window blinds. Step outside to enjoy a private yard with lush grass, a sliding door that opens directly to your sparkling pool, and plenty of space for lounging under the desert sun. Sitting proudly on a corner lot with quiet, welcoming neighbors, the home is just minutes away from the shopping, dining, and charm of Old Town La Quinta. Additional upgrades; including a brand-new roof, updated door hardware throughout, and a new garbage disposal round out the long list of improvements that make this home such a fantastic find. With so many recent updates already completed for you, this is not just a beautiful property it's an amazing opportunity. Don't miss your chance to make this stunning La Quinta Cove residence your home! Schedule a viewing today!
#219135104DA

La Quinta

52200 Avenida Velasco

3 Beds

2 Baths

1,405 Sq.Ft.

$675,000

MLS#: 219135104DA

New on site 2 days ago
Located on the 2nd hole of the Palmer Private course at PGA West, this light, open and airy home offers 2 bedrooms, 2 baths + an office in a spacious 2,026 square feet! There is a large, well appointed kitchen with breakfast bar, and the great room features a cozy fireplace. The generous primary suite has a large bath with dual vanity and separate tub and shower, and an ample walk-in closet. Step outside to an oversized covered patio featuring a firepit and lovely views! And lastly there is a two car plus golf cart garage. This is a sought after floorplan, that rarely comes on the market. Come and experience resort living at its finest!
#219135038DA

La Quinta

55156 Tanglewood

2 Beds

1 Baths

2,026 Sq.Ft.

$810,000

MLS#: 219135038DA

New on site 3 days ago
Discover the epitome of modern living in La Quinta with The Enclave at Capistrano. This remarkable new residence boasts 3bd/2.5 ba encompass 2,679 square ft of thoughtfully planned space tailored for the quintessential desert lifestyle and entertaining. As you approach, a charming courtyard invites you to enjoy serene moments of stargazing, savoring morning coffee, or immersing yourself in a captivating book. This home has been professionally decorated with over $120K in landscaping including palm trees, putting green, firepit, and more. The grand entrance flows seamlessly into a dem and an inviting formal Dining Room, leading into a spacious great room and a California Room--ideal for extending your gatherings into the south facing backyard. The gourmet Kitchen stands out with its upgraded cabinetry, sleek quartz countertops, stainless-steel appliances, and a generous island, complemented by a Butler's Pantry and a cozy dining nook. The expansive Primary Suite offers a luxurious retreat, featuring a stunning bathroom with a standalone soaking tub, a walk-in shower, dual vanity sinks with elegant stone counters, and spacious walk-in closets. Additionally, two well-appointed bedrooms share a stylish bathroom equipped with dual sinks. Enhanced by cutting-edge ''Americas Smart Home Technology,'' LED recessed lighting, and a tankless water heater, this home is designed for modern comfort and convenience. Furthermore, homes comes equipped with solar panels for substantial energy savings! Experience the lifestyle you deserve where elegance meets innovation!
#219134999PS

La Quinta

81797 Via San Clemente

3 Beds

3 Baths

2,679 Sq.Ft.

$690,000

MLS#: 219134999PS

New on site 4 days ago
Single Story Beauty in the Heart of La Quinta. Price reduced to sell!! Close to great golf courses and clubs along with local dining areas. Great neighborhood. This stunning home offers 2682 sq ft of spacious living space on a generous 13,939 sq ft leveled lot. Home sits in the middle of the lot which allows a large wide driveway and lovely fenced front yard. Perfect for the kids or pets. The interior offers 4 bedrooms and 3 bathrooms. Nice kitchen that opens to the family room which allows plenty of space for your guest to be entertained. Good size formal dining room. Plenty of windows that allow plenty of natural light. Higher ceilings in family room, kitchen area and dining areas. Large master suite with it's own master bathroom with separate shower and soaking tub along with a double vanity and walk in closet. The other bedrooms offer plenty of space for family and guest. Step into the backyard with a grass area with citrus trees, pool with and relaxing spa and concrete patio area with plenty of room to entertain and dine or BBQ. Great view of the mountain nearby. Ready for your personal touch, this home can really shine with a little TLC. Make it your own and build great equity. Price to sell!! Plenty of space for an ADU, buyers to do their own due diligence. NO HOA
#IG25201009

La Quinta

51425 Calle Paloma

4 Beds

3 Baths

2,682 Sq.Ft.

$949,000

MLS#: IG25201009

NEW CONSTRUCTION - SINGLE-FAMILY HOMES – NEW COMMUNITY! Welcome to The Enclave at Capistrano, a gated community showcasing spacious single-level floor plans designed for elevated indoor/outdoor living in beautiful La Quinta. This exquisite Residence 2,529 home welcomes you as you enter a beautiful courtyard perfect for stargazing, morning coffee or reading a good book. Open the front door to a large entry that flows into a formal dining room, gracious Great Room and amazing California Room. Open the doors, let the breeze in and extend the soiree and entertaining outside. The amazing, large backyard space offers endless possibilities. As you proceed through to the grand kitchen you will be amazed at the appointments, such as beautiful, upgraded cabinetry, gorgeous quartz counter tops, stainless-steel appliances and large kitchen island, and an ample dining nook. The spacious and private Primary Suite offers a peaceful retreat and includes a stunning bathroom complete with dual sink vanity, large shower and two, walk-in closets. This home also offers two additional bedrooms with another bathroom featuring dual sinks, and a large study, perfect for a home office or extra space for guests. There are more amazing features such as "Americas Smart Home Technology" LED recessed lighting, tank-less water heater and much more.
#SW25200488

La Quinta

81849 Mission Palms Drive

3 Beds

2 Baths

2,529 Sq.Ft.

$691,990

MLS#: SW25200488

Spectacular Lake Front Property - A Rare Gem! This beautiful lake front property in Laguna De la Paz has everything you have been looking for! Featuring breath-taking lake front and mountain views this well-appointed and updated three bedroom, two bathroom home has all the amenities to help you live your dream. The open and spacious floor plan offers approximately 1,950 square feet of livable space, coupled with the best in outdoor relaxing venues. The living room includes a gas fireplace, custom built-in storage and patio access, while the dining room is a plus for formal dining and entertaining or everyday meals. The kitchen is a chef's dream with granite counter tops, upgraded appliances. Retire to the primary retreat that boasts a walk-in closet, patio access and a spectacular and luxurious en suite with both tub and seamless glass shower. Guest bedrooms are bright and offer additional living and sleeping space. The real treat is the amazing South facing outdoor space that includes a large patio area with private Spa which looks out on the lake as well as offering a stunning view of the Santa Rosa Mountains.. Laguna De La Paz offers a gated community with amenities that include a fitness center, clubhouse, lake, walking paths, tennis and pickleball courts, pools and spas and more. Fine dining, golf courses and shopping are just minutes away. Professional photography with more interior photos will be available 9/9/25.
#219134912DA

La Quinta

48511 Via Encanto

3 Beds

2 Baths

1,950 Sq.Ft.

$925,000

MLS#: 219134912DA

This modern retreat is designed to impress at every turn. With a seamless open floor plan, it blends indoor comfort with outdoor living, ideal for both everyday enjoyment and elegant entertaining. Striking details include a custom fireplace, subway tile backsplash, stainless steel appliances, soaring 12-foot ceilings, and 8-foot doors throughout. The chef's kitchen is the centerpiece, anchored by a dramatic quartz waterfall island perfect for hosting gatherings of any size.The primary suite offers a true escape, showcasing panoramic mountain views, direct access to the private hot tub, and a spa-inspired bath with dual quartz vanities and a custom-tiled walk-in shower. Outdoors, the resort-style pool area provides abundant space for dining and lounge seating, all framed by breathtaking sunset views.After a day exploring nearby hiking trails, dining, shopping, and local art fairs, return home to unwind beneath the stars from your patio or soak in the serenity of your spa. A rare opportunity to own a contemporary desert sanctuary awaits--schedule your private showing today.
#219134938DA

La Quinta

53700 Eisenhower Drive

3 Beds

2 Baths

1,658 Sq.Ft.

$689,500

MLS#: 219134938DA

NEW CONSTRUCTION - SINGLE-FAMILY HOMES – NEW COMMUNITY! Welcome to The Enclave at Capistrano, a brand, new, gated community showcasing spacious single-level floor plans designed for elevated indoor/outdoor living in beautiful La Quinta. This Residence 2,348 home features 3 bedrooms, 3.5 baths and wows from the minute you enter the large entry that flows into a gracious Great Room and California Room. As you proceed through to the grand kitchen you will be amazed at the appointments, such as beautiful upgraded cabinetry, quartz counter tops, stainless-steel appliances and large kitchen island, an ample dining nook and Butler's Pantry, which leads to a gorgeous Dining Room space for more formal gatherings. The spacious Primary Suite contains a stunning bathroom complete with dual sink vanity, large, walk-in shower and walk-in closet. This home also offers one additional bedroom and the other is a Junior Suite, complete with en-suite bathroom and walk-in closet. The large backyard space sets the stage for an amazing oasis and endless days of outdoor entertaining! There are more amazing features such as "Americas Smart Home Technology" LED recessed lighting, tank-less water heater and much more.
#SW25200064

La Quinta

81863 Mission Palms Drive

3 Beds

3 Baths

2,348 Sq.Ft.

$668,090

MLS#: SW25200064

Located at the very top of La Quinta Cove, this delightful two-bedroom, two-bath residence is surrounded by dramatic mountain views and just steps from premier hiking trails. Set on an expansive 10,000+ sq. ft. lot, the property offers exceptional potential--ample room for a private pool, spa, or custom garage.Recently remodeled, the home showcases thoughtful upgrades throughout, including a new HVAC system, plumbing, electrical, insulation, dual-pane windows, and flooring. Every detail has been carefully considered, creating a comfortable and stylish living environment that blends modern updates with the natural beauty of its surroundings.With its oversized lot, serene setting, and extensive improvements, this is an ideal opportunity to enjoy desert living at its finest.
#219134833DA

La Quinta

54677 Avenida Diaz

2 Beds

None Baths

1,465 Sq.Ft.

$650,000

MLS#: 219134833DA

Unbeatable VALUE! This 3 bedroom, 3 bathroom, PLUS A LOFT home boasts the LOWEST price per square foot in the area! Corner property, GORGEOUS Interior and Upgrades, Prime Location! A MUST SEE! Welcome to the iconic Signature at PGA West... a highly sought-after community where luxury, comfort, and the ultimate desert lifestyle come together seamlessly!Ideally situated on a premium corner lot, this beautifully furnished 3 bedroom, 3 bathroom home features one of the most desirable and spacious floor plans, offering just under 2,000 sq ft of thoughtfully designed living space.The primary suite is conveniently located on the first level, with separated guest rooms providing privacy and comfort for visitors. Upstairs, a generous loft area offers flexible space... whether you're working from home, relaxing, or hosting extra guests!Inside, the home has been tastefully updated with quartz countertops, a custom tile backsplash, and modern vanities in both guest bathrooms. The kitchen boasts stainless steel appliances and upgraded cabinetry, flowing into a bright, open-concept great room that's ideal for entertaining. Additional features include a private attached garage, in-home laundry, and stylish designer furnishings... turnkey and ready for your next vacation escape- PLUS it is STR approved to start earning short-term rental income right after closing!Step outside to your semi-private patio, a serene space to enjoy your morning coffee or unwind under the glow of a breathtaking desert sunset!Enjoy access to the exclusive Signature Clubhouse, complete with an Olympic-style pool, fitness center, outdoor kitchen with BBQs, bocce ball courts, and reservable social spaces. All just a short walk to Ernie's Bar & Grill, golf at the legendary Stadium Course, and only minutes from the Empire Polo Grounds, world-famous festivals, dining, shopping, and the AMEX Golf Tournament.Whether you're seeking a full-time residence, seasonal getaway, or an income-generating STR investment, this property offers an unbeatable combination of luxury, location, and lifestyle!
#219134879DA

La Quinta

80495 Whisper Rock Way

3 Beds

3 Baths

1,983 Sq.Ft.

$800,000

MLS#: 219134879DA

- property

Send a message

Message successfully sent.

Your message

Reason for contacting?

Sign Out

Virtual Assistant

Would you like to receive some additional information on this specific property or similar properties?

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