Mariam Rodriguez Rivera

Searching for a highly desirable investment prospect or an immaculate abode to call your own? Whether it's to offer you an ideal indoor-outdoor lifestyle or an income-generating opportunity, this stunning Indio residence allows short-term leasing. Explore the elegant interior that tastefully combines gleaming tile flooring, warm color tones, and decorative baseboards. Relish in the breathtaking mountain and lake views as you gather around the stately living room fireplace or host chandelier-lit dinners in the dining room. Delight the home chef with the impressive eat-in kitchen's granite countertops, stainless steel appliances, and island bar seating. Idyllic nature panoramas make the primary suite stand out from the rest of the bedrooms. Discover a soaking tub, an oversized, glass-enclosed shower, and twin vanities in its ensuite. Making every avid entertainer's dream come true, the backyard displays beautifully landscaped gardens surrounding the covered patio and shimmering pool. As a premium perk, enjoy access to top-notch amenities, including a clubhouse, gym, picnic areas, playground, and more. Terra Lago's The Golf Club with a 36-hole course is also moments away. Come grab the chance to experience all this yourself! Show more

Price reduced! Popular Sun City Shadow Hills Castellano open floor plan with salt water pool/jacuzzi that was built in 2022. The over sized covered patio allows maximum use of poolside patio. Mature landscaping including a lemon tree make for a peaceful, serene setting that begs to be enjoyed. The primary and guest bedrooms are on opposite sides of the home offering privacy and space. The den/bonus room can be used as a third bedroom and easily converted or used as an office. There is a fabulous large granite kitchen with stainless steel appliances and wrap around bar seating in addition to the breakfast nook. The great room has a stacked stone fire place perfect for cozy nights. Newer A/C- it was replaced in 2020. Come check out this wonderful home and all the amenities Sun City Shadow Hills has to offer.

This architecturally striking 5,667 square foot estate represents one of the best overall values in South La Quinta. Nestled behind the gates of the exclusive 24-hour guard-gated community of Griffin Ranch - one of La Quinta's most coveted communities. And situated on the largest lot Griffin Ranch offers, this private 38,768 square foot parcel (. 89 acre) captures breathtaking views of the surrounding mountains and is bordered by only one neighbor. Enter through custom forged iron gates into the private courtyard which escorts you into the magnificent residence, reminiscent of a prestigious resort. Once inside, you'll find quality every step of the way. Boasting spacious living areas, walls of glass, clerestory windows, dramatic soaring wood-beamed ceilings, handcrafted hardwood floors, built in cabinetry and custom wall-to-wall bookshelves in the library. The gourmet kitchen is a chef's dream. Equipped with a stunning island, custom cabinetry, striking slab-granite counter-tops, and top-of-the line stainless appliances, which overlook an expansive great room making it ideal for entertaining both family and friends. A grand scale primary suite embraces a marvelous separate retreat with two-sided fireplace, mitered windows, his & her vanities, dual showers, jetted tub and oversized walk-in custom closet. Additionally, there are three more ensuite bedrooms, one of which is currently used as an office with a private entrance, ideal for use as a casita. Floor to ceiling glass pocket sliding doors provides a flawless transition to the sprawling outdoor living area that features; a spectacular black-bottom, pebble-tec salt water pool & spa that are flanked by three fire cauldron bowls and a tranquil fountain, dramatic landscape lighting, mature & colorful water-efficient landscaping, a putting green and bocce ball, further enhancing this Desert Paradise. Bonus, there are two separate 2-car garages each with their own driveway. The community amenities include; a clubhouse, banquet facilities, junior Olympic pool, kids splash pool, tennis & sports courts, cabanas, spa, fire pits, Pilates, billiards and fitness center, along with HOA sponsored events year around. Close to world-class golf, tennis, fine dining and shopping. Show more

Introducing this stunning 3-bedroom, 2-bath condo located in the popular, gated, Hidden Palms, which is in a prime location in South Palm Desert. As you enter, the beautiful Saltillo flooring, crisp white tones, wood trim, and floor-to-ceiling fireplace will welcome you, and create a warm and inviting atmosphere. The kitchen boasts sleek stainless steel appliances, abundant white cabinetry, gorgeous granite countertops, and a cozy breakfast nook. Nice separation of the primary with an en-suite bath with dual vanities and a shower/tub combo and walk-in closet. The sunlit atrium provides a serene and light-filled space for relaxation. Step outside to the wraparound patio, which is surrounded by energy-efficient landscaping and plenty of space for relaxation. The condo also features a newer A/C and heating system, an attached 2-car garage, and energy-efficient windows, making it both stylish and eco-friendly. Comfortable furnishings included per inventory list. The community has top-notch amenities including 3 lakes, 4 community pools/ spas, and tennis/pickleball courts. Close to El Paseo, coffee shops, art galleries, boutique shopping, grocery stores, and restaurants. Perfect for a primary, second, or investment property. Your desert oasis awaits!

Beautifully landscaped courtyard welcomes you to this immaculate Indian Wells abode, ideally located on the green in the exclusive Toscana Country Club! High ceilings and polished porcelain floors highlight an open layout that offers spectacular views at every turn. A linear fireplace with a dramatic black surround defines your living room where glass pocket doors slide from sight to seamlessly blend your indoor/outdoor spaces. Enjoy the bar on the view and pamper your inner chef in kitchen featuring a large center island, Wolf appliances and plenty of cabinetry. Your elegant primary bedroom is an oasis that offers an ensuite bath with a soothing tub, dual vanities and a walk in closet. Enjoy the extra space for the overnight guests with an additional three guest suites which includes a private casita with kitchenette and seating area has all you need for overnight visitors. Relax by the pool and spa, cook in the outdoor kitchen or enjoy mountain vistas from the warmth of your fire table. Among other benefits are a tankless water heater, remote controlled patio screen, laundry room, media room, and an attached 3-car garage. Take advantage of 36 holes of Jack Nicklaus Signature Golf, a sports club and spa, plus many other world class amenities. Come take a tour while it's still available!

Absolutely gorgeous home in the La Quinta Country Club Estates. High ceilings, exposed wood beams, custom flooring and designer touches make this a very special home. Center island in the open kitchen with granite counters, breakfast nook and stainless appliances. The living room, family room and kitchen are open to the back yard complete with pool and spa. The rock waterfall, swim up bar and tanning bed is perfect for relaxing and enjoying the desert's fine weather. The high counters in the bathrooms making bending over easy on the back. The owners have made this home a very special property. Come See for Yourself. Show more

PRICE REDUCED! Idyllic living awaits in this delightful and upscale Rancho Mirage home, inspiring the serene indoor/outdoor living of your dreams! Discover a vibrant, open floor plan interior through the artisan double-door entry defined by brilliant sunlight streaming through multiple skylights. Mirrored walls add depth to your entertaining areas, accentuating a neutral palette, striking fireplace, detailed crown molding, and a combination of tile and wood-like flooring. Elevate your parties with craft cocktails freshly shaken at the bar with a wine refrigerator. In the kitchen, you'll find a full complement of appliances, gorgeous cabinetry, and gleaming countertops extending to the breakfast bar. With three bedrooms originally, one guest bedroom is currently being used as a sitting area to make the kitchen area more spacious for entertaining. If desired, this sitting area could be easily converted back. The main bedroom offers garden access and an ensuite with a walk-in shower and soaking tub. For your convenience you'll find a large laundry room with sink, spacious garage parking for two cars and golf cart, and a grand pavered drive-through driveway. Within close proximity to the Clubhouse and community pool. The HOA fee covers your social membership to The Springs Country Club. World-class amenities abound including a championship 18-hole golf course (separate membership), pool and tennis courts. Come take a tour today!

Great development opportunity that'll allow you to speed up the process to build your new home in the heart of Joshua Tree, CA! This property is located right off of a paved road, has a paid water meter, as well as electrical poles running adjacent to the property, it's already been surveyed, acquired an established address, and passed a percolation test for septic. (buyer to verify) Basically, most of the upfront work to start the process to build a new home has been done for you! Seller is also willing to 'seller finance' at a purchase price of $40k. Terms to be negotiated. The shed will also convey with the property. Located in the Sunfair area of Joshua Tree known for it's private/quiet setting, panoramic mountain views and so many other attractions. Just up the street from the well known art installation ''Transmission'' designed by Daniel Popper, as well as the Joshua Tree Music Festival and Bhakti Fest. Only minutes to town and 15 minutes to Joshua Tree National Park. This area of Joshua Tree is continuing to develop out with beautiful designer/modern homes and established short term rentals. This really isn't your average land for sale with all of these perks to put you ahead of the game. Here's your chance to get a piece of the pie! Go take a look to see for yourself and give us a call today! Lot lines in the photos are approximate. Apn: 0605-062-04-0000. Gps: 34.15646° n, 116.27616° w

This sensational lakeside home with Northwestern Mountain views offers style and contemporary elegance at its finest. Living area shows with Ledgestone wall, fireplace and built-in cabinets. The home features spacious living areas, Travertine flooring, recessed lighting and designer color schemes. Floor to ceiling doors and windows frame your magnificent views. The modern kitchen has Thermador cooking appliances, granite countertops and island with prep sink. A step-down bar complements the entertaining features. Retire to the primary bedroom that treats you to an outdoor private seating area. The ensuite bath comes with a soaking tub generous shower and two walk in closets. There are three bedrooms, one is being used as an office. Fleetwood Doors from the living and primary bedroom areas lead you to the terrace, stepping down to the Grecian-like pool. Savor meals prepared on the built-in BBQ island or have conversations around a fire pit ending your evenings under the desert sky. Currently used as owner's second residence, offset with seasonal vacation rental income. Upgraded features include new pool surfacing, saline conversion, iAqualink, Control Panel and App, new Hot Water Heater, dishwasher & Washer/Dryer. Secured with 24-hour gate. Close to great shopping, dining, Polo & festival grounds, and entertainment options. This home provides the option of social and golf memberships at The Citrus. Truly a wonderful place for living your dream desert life, so come take a tour!

Single Family Residence, Modern - Joshua Tree, CA

CASH BUYERS ONLY! Welcome to your dream home! This charming 3-bedroom, 2-bathroom home is situated on a spacious lot, just under 1/4 acre, in a desirable neighborhood in the city of Victorville. Enjoy the privacy and serenity of having no houses behi

Enjoy Resort Style living in this elegant condo on the third floor. With stress-free living at one of the best-kept secrets in the desert. This gated community is surrounded by 25 acres of landscaped grounds and lakes. The 2-bedroom 2-bathroom condo has been remodeled in a dramatic flair. Fabulous views day and night. Entertain your friends on a massive balcony with ambient lighting from the trees below. Enjoy year-round swimming in the heated pool and spa. Tennis, Pickleball, Paddle Boats and Gym. Located between El Paseo and Palm Springs convenient to great restaurants, casinos, theater, and shopping. 95% of your AC bill is covered in your HOA fees. New York Style in Sunny California!!!

The Broker and eldest daughter of The Hardy Group family does not mess around. She is a fierce negotiator and protects her clients like a mama bear! She is a no-nonsense leader with immense knowledge of the Temecula Valley and surrounding area after growing up here. She holds her Executive MBA from Pepperdine University and as such, has an expertise for understanding market conditions. She is a softie at heart which allows her clients to stay long-time friends. Paige is always learning new avenues to help us grow as a team.

Mariam Rodriguez Rivera

About Mariam Rodriguez Rivera

Contact Agent

Recent property sales & transaction history

12 properties

La Quinta

Family Home, Condo

$800,000 to $1,500,000

1,500 ft² to 4,100 ft²

Properties for sale by listing agent Mariam Rodriguez Rivera

$819,900

Similar real estate agents nearby

Mariam Rodriguez Rivera

Ready to take full control of your agent profile?