Team Results | PMZ Real Estate | Modesto & Stanislaus County Realtors

Let's talk about your next real estate move. 

$979,000
4 Beds 3 Baths 2,263 SqFt. 226110790 MLS
Welcome to one of the premier homes in The Lakes, where privacy, comfort, and thoughtful design come together in one exceptional property. Perfectly positioned on a premium lot with no rear neighbors and beautiful open views, this beautifully maintained 4-bedroom, 3-bath residence offers more than 2,200 square feet of light-filled living space designed for both everyday comfort and entertaining. The open-concept floor plan centers around a spacious kitchen featuring granite countertops, stainless steel appliances, a large center island, and walk-in pantry, all flowing seamlessly into the inviting great room. Built-in speakers in the living area create an enhanced home theater experience, perfect for movie nights, sports, and entertaining. A full bedroom and bathroom on the main level offer excellent flexibility for guests, multigenerational living, or a private office. Newer carpeting adds a fresh, move-in-ready feel throughout the home. Upstairs, a versatile loft provides valuable additional living space and can easily function as a second family room, media room, game room, or dedicated home office. Step outside and discover a backyard designed to be enjoyed. The sparkling pool and spa, covered California room, expansive patio, and beautiful open views create a private setting for relaxing and entertaining. The pergola area is already equipped with electrical service, offering an ideal foundation for a future outdoor kitchen, built-in barbecue, or dining and entertainment space. Tucked along the side yard, a separate concrete patio creates another inviting outdoor destination, perfect for a conversation area, lounge seating, or fire pit setup. The generous front landscaping and driveway area also offer exciting potential for additional parking or future custom improvements, including possible RV or boat accommodations, subject to HOA requirements and applicable local approvals. Additional features include a Tesla solar system with TWO Powerwall battery backups, a 3-car tandem garage, plantation shutters, tankless water heater, water softener, professional landscaping, and numerous thoughtful upgrades throughout. With exceptional privacy, flexible living spaces, multiple indoor and outdoor entertainment areas, energy-efficient features, and a premium setting within The Lakes, this home offers a lifestyle that is increasingly difficult to find in Discovery Bay.

9133 Calypso Court, Discovery Bay

Listing courtesy of Coldwell Banker Realty.

$1,300,000
4 Beds 3 Baths 3,199 SqFt. 226115749 MLS
Welcome to 11120 Shadow Court, a private foothill retreat in desirable Shadow Rock Estates, just minutes from I-80. Set on 2.5 acres, this beautifully updated 4-bedroom, 3-bath home offers approximately 3,199 sq. ft. of living space, panoramic mountain views, mature trees, privacy, and an exceptional amount of usable flat land. A wide, curved driveway leads to an expansive level parking and turnaround area with room for multiple vehicles. The detached 750 sq. ft. garage offers excellent flexibility for a workshop, gym, hobbies, storage, or possible future ADU, subject to county approval. A covered front porch framed by arches captures beautiful mountain views and creates the perfect place to sit, unwind, and enjoy the peaceful setting. Step through the glass front door into an inviting lounge with warm cherry wood flooring. Double doors open to a spacious office large enough for two, followed by an open dining area and the heart of the homethe Great Room and remodeled kitchen. The kitchen features Taj Mahal quartzite, Craftsman-style shaker cabinetry, farmhouse sink, and casual dining nook. The Great Room offers a gas fireplace, custom wood mantle, built-in entertainment niche, and French doors leading to the backyard. Outdoor living is exceptional with a large wood deck, expansive flat lawn, dramatic boulder retaining wall, rose garden, tiered garden beds, fruit and fig trees, wood-burning fire pit, and private spa for relaxing under the stars. The main-level primary suite features French doors to the deck, a spacious walk-in closet, and beautifully remodeled bath with Taj Mahal counters, soaking tub, marble shower, brass lighting, and radiant heated floors. Downstairs are three additional bedrooms, including a flexible lounge/playroom with electric fireplace and patio access, plus a hidden bonus room ideal for a theater, gym, playroom, or hobby space. A remodeled bath with dual vanities completes the lower level. Extensively improved with remodeled kitchen and baths, cherry flooring, updated HVAC, generator with transfer switch, hot-water circulation system, new driveway, landscaping, lighting, and more. If you want privacy, views, a mountain feel, and rare usable outdoor space without sacrificing convenience, this is the one.

11120 Shadow Court, Auburn

Listing courtesy of Brenda Brown Luxury Homes, Inc.

$329,900
2 Beds 3 Baths 1,400 SqFt. 226114589 MLS
Discover an exceptional opportunity in Sylvan Meadows, one of Modesto's most desirable and established communities. Tucked away on a private cul de sac, 937 Claremont Court offers a peaceful residential setting surrounded by the conveniences that make this location so sought after. Close to Sylvan Union School District schools, Beyer High School, beautiful parks, shopping, dining, and everyday amenities, this elegant 2 bedroom, 2.5 bathroom, 1,400 sq. ft. condominium combines an exceptional location with effortless living. Residents enjoy access to the community pool and clubhouse, adding to the relaxed Sylvan Meadows lifestyle. Step inside to a light filled, open concept interior enhanced by brand new carpet and designed for both everyday comfort and entertaining. The spacious living room is anchored by a warm fireplace, creating an inviting focal point for quiet evenings or gathering with guests. Natural light enhances the great room design, creating a warm and welcoming atmosphere. The kitchen offers generous cabinetry and storage, complemented by a brand new dishwasher, microwave, and vent hood. A dedicated breakfast area creates an inviting space for casual dining, while the adjoining dining room flows naturally into the great room, providing a beautiful setting for hosting and entertaining. Two private patios create a wonderful extension of the home, offering intimate outdoor settings for morning coffee, al fresco dining, entertaining friends, or simply unwinding at the end of the day. The primary suite feels like a true private sanctuary. A generous sitting area provides exceptional flexibility as a home office, reading retreat, or private lounge, while a spacious closet and ensuite bath complete the suite. The secondary bedroom provides another comfortable retreat for family or guests. An attached two car garage with laundry hookups adds everyday convenience. From its private cul de sac setting and community pool and clubhouse to its proximity to Sylvan Union School District schools, Beyer High School, parks, shopping, and dining, this residence places you at the heart of one of Modesto's most desirable areas. Elegant, inviting, and exceptionally located, 937 Claremont Court offers the opportunity to experience the comfort, convenience, and community that make Sylvan Meadows such a special place to call home.

937 Claremont Court, Modesto

Listing courtesy of PMZ Real Estate.

$499,000
2 Beds 2 Baths 1,140 SqFt. 226115318 MLS
Inviting you to 10006 Wendell Rd. a 10.52 acre turnkey fully furnished residential property poised for immediate occupancy. This residence presents a unique opportunity for sophisticated country living with no HOA. Custom built in 2018 after the Bute Fire with wildfire safety in mind. Features such as partially building into the hillside, fireproof siding and doors, tempered glass windows, an indoor sprinkler system, and a metal roof may help to mitigate fire risk. Thoughtfully designed for comfort, easy living and wildfire safety. This home offers single level living with 2 bedrooms, 2 full bathrooms, an open floorplan and more. The gourmet kitchen features stainless steel appliances and granite counters that provide both durability and a refined aesthetic for meal preparation and entertaining. One of the bathrooms offers a walk-in shower, designed for both convenience and a touch of modern luxury, enhancing the daily routine. The property further distinguishes itself with an inviting outdoor covered dining area, perfect for al fresco meals and entertaining guests. An attached 6 car garage provides secure parking and additional storage for all your vehicles, equipment and toys. There are several additional outbuildings and a cargo container for animals, additional storage or misc. use. This property is offered fully furnished and is ready for its new residents. Is that you?

10006 Wendell Road, Mountain Ranch

Listing courtesy of NextHome Murphys Realty.

Start Your Search

metrolist logo

All measurements and all calculations of area (i.e., Sq Ft and Acreage) are approximate. Broker has represented to MetroList that Broker has a valid listing signed by seller authorizing placement in the MLS. Above information is provided by Seller and/or other sources and has not been verified by Broker. Copyright 2026 MetroList Services, Inc. The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity Program of MetroList® MLS. All information has been provided by seller/other sources and has not been verified by broker. All interested persons should independently verify the accuracy of all information. Last updated .

Terms of Use