Incredible 11,681 square foot French Provincial estate located on the bluff above hole 10 at San Joaquin Country Club. This 5 bedroom, 8.5 bathroom home is situated on 3/4 of an acre on a quiet, no outlet street. No expense spared construction with impeccable craftsmanship. Highlights include museum like hallways with walls of glass & custom cabinetry, Lutron home automation system, whole house audio system, gated motor court with conditioned 4 car garage, conditioned workshop with full bath, 5 fireplaces, elevator, hand scraped hardwood floors with limestone inlays, imported European mantels, soaring ceilings, wine storage, media room, exquisite master suite with two bathrooms and two closets, interior courtyard with swimming machine & fountain, a cantilevered balcony that floats above the bluff all set in a beautiful Robert Boro designed landscape. This home is quite possibly the finest home in the region!
Single-familyProperty Type
1997Year Built
0.76 acresLot Size
$519Est. Price/Sq.Ft.
1 car garageParking
Listed by Nader Assemi•DRE #DRE #01962277• Fresno Modern Real Estate
Bought with Angie Hyatt•DRE #DRE #01013098• Hyatt Real Estate
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Public record
Zoning
Beds
3
Baths
8
Stories
2
Lot width
140 ft.
Lot depth
235 ft.
Lot size
0.76 Acres
Year renovated
1997
Sq. Ft.
11,681
Year built
1997
Style
Single Family Residential
County
Fresno County
APN
50007114S
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Aug 13, 2026.
R1B
M
UGM
Single Family, Low Density Residential Zone
The R-1-B zone identifies areas appropriate for large lot single-family uses with urban standards, with not more than one primary dwelling unit per parcel. The R-1-B zone is consistent with the Low-Density Residential land use designation of the General Plan.
Zone overlays
Mining Overlay District
Urban Growth Management Area Overlay
Permitted uses
Include but are not limited to:
Day care facility
Housing-Single unit
Infrastructure
Property details
Parking
Parking Information
Parking Features: Work/Shop Area, Garage Door Opener
Interior
Bathroom Information
Bathroom Features: Tub/Shower,Shower
Heating & Cooling
Has Heating
Has Cooling
Cooling: 13+ SEER A/C, Central Heat & Cool
Interior Features
Interior Features: Studio, Built-in Features, Den/Study, Game Room
Appliances: F/S Range/Oven, Gas Appliances, Disposal, Dishwasher, Microwave, Trash Compactor, Refrigerator, Wine Refrigerator, Water Filter
Flooring: Carpet, Tile, Hardwood
Window Features: Double Pane Windows, Skylight(s)
Laundry Features: Inside
Exterior
Exterior Features
Levels: Two
Fencing: Fenced
Roof: Other
Construction Materials: Stucco
Foundation Details: Wood Subfloor
Patio And Porch Features: Covered, Concrete
Pool Information
Has Private Pool
Pool Features: Heated, Pebble, Water Feature, In Ground, Private
Spa Features: Bath
Living Area
Living Area Source: Public Records
Lot Information
Lot Features: Urban, Near Golf Course, Sprinklers In Front, Sprinklers In Rear, Sprinklers Auto, Mature Landscape
Property Information
Property Sub Type: Single Family Residence
Location
HOA Information
Has Association
Association Amenities: Security
Association Fee: $251
Association Fee Frequency: Quarterly
School Information
Elementary School: Forkner
Middle Or Junior School: Tenaya
High School: Bullard
High School District: Fresno Unified
Location Information
Directions: From Herndon take Marks north. Left on alluvial. Right on Lead. Right on Charles.
County Or Parish: Fresno
Utility Information
Sewer: Public Sewer
Utilities: Public Utilities
Public facts
Beds: 3
Baths: 8.0
Sq. Ft.: 11,681
Stories: 2.0
Lot Size: 0.76 acres
Style: Single Family Residential
Year Built: 1997
Year Renovated: 1997
County: Fresno County
APN: 50007114S
Home facts updated by county records on Aug 13, 2026
Around this home
Schools
Forkner Elementary School
Public K-6 • Assigned • 0.6mi
8/10
Tenaya Middle School
Public 7-8 • Assigned • 2.9mi
3/10
Bullard High School
Public 9-12 • Assigned • 3.3mi
6/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
6/10 Fire Factor
9% chance of being in a wildfire in next 30 years
7/10 Heat Factor
6 days above 105° expected this year, 13 days in 30 years
1/10 Wind Factor
Minimal risk of severe winds over next 30 years
10/10 Air Factor
37 unhealthy days expected this year, 42 days in 30 years
Provided by First Street
Historical weather
Fresno, CA • 93711
Average low and high temperatures (°F)
60
41
66
46
73
50
76
51
85
57
94
63
97
66
98
67
91
65
80
56
64
48
56
44
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 13.4 hours in
June and 4.2 hours in December, placing it above the
U.S. average for solar exposure.
13.4 hrs
4.2 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$5.76M – $6.98M
Reach more buyers when you sell with Redfin. Save up to $60,670 in fees.3 minutes to get started.
Get a free, detailed breakdown of how we calculated your estimate.