Title Page Background
DEBUG FN args: Array ( [0] => 209 [1] => [2] => [3] => agent ) BEFORE: Site: 209 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 209 Igate: njhud LocID: 209 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 209 AND i.igate IN ('cahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 209 [1] => [2] => [3] => lender ) BEFORE: Site: 209 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 209 Igate: njhud LocID: 209 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 209 AND i.igate IN ('cahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 209 [1] => [2] => [3] => other ) BEFORE: Site: 209 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 209 Igate: njhud LocID: 209 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 209 AND i.igate IN ('cahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

2631 Oak Woods Court
Catheys Valley, CA 95306
Lisa Coffman with Mariposa Homes and Land Co., original listing - (209) 777-3100

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $749,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2793 Square Feet
Agency: Mariposa Homes and Land Co.
Agency Phone: (209) 777-3100

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1990
Notes: Spacious Tudor-Style Retreat in Whispering Oaks Estates<br /> Whispering Oaks Estates | 5+ Acres | Privacy Gated Community | Equestrian Trails | Near Yosemite<br /> <br /> Feast your eyes on this exceptional Tudor-style home, tucked away in the prestigious gated community of Whispering Oaks Estates. Set at the end of a quiet cul-de-sac, this private retreat offers 5+ acres of rolling hills, a seasonal creek and park-like landscaping with a full irrigation system—perfect for those who crave tranquility and nature.<br /> <br /> Step onto the expansive back deck, ideal for barbecues, dinner parties, or peaceful evenings by the fire, all set to the soothing soundtrack of the seasonal creek flowing just below.<br /> <br /> Inside, the home boasts a split-layout primary suite with a cozy gas stove, deck access, walk-in closet, and a spa-like ensuite featuring a double vanity, soaking tub, and separate shower.<br /> <br /> The cathedral-ceiling family room invites you in with a charming brick fireplace, wet bar, and wood stove insert—a warm, inviting space for gatherings. The kitchen is designed for culinary creativity and connection, with granite countertops, a large walk-in pantry, built-in desk, high-top breakfast bar, and a picture window with scenic views.<br /> <br /> Other interior highlights include:<br /> <br /> * Tray ceilings in the entry and formal dining room<br /> <br /> * Wood and tile flooring throughout<br /> <br /> * New trim, baseboards, light fixtures, plugs & switches<br /> <br /> * Fresh paint, retextured walls, refinished cabinets, and remodeled bathrooms<br /> <br /> * The home also offers a 3-car attached garage with built-in cabinetry, perfect for storage or projects.<br /> <br /> Enjoy the benefits of a private lake, equestrian trails, and proximity to local gems—just 15 minutes to Mariposa, 30 minutes to Merced, and around 1 hour to Yosemite National Park.<br /> <br /> Don’t miss your chance to own this rare gem in one of the area's most exclusive neighborhoods.
MlsNumber: --
ListingId: MP25104474


Listing Provided By: Mariposa Homes and Land Co., original listing
Phone: (209) 777-3100
Office Phone: (209) 777-3100
Agent Name: Lisa Coffman
Disclaimer: Copyright © 2025 California Regional Multiple Listing Service, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App