---
listing_id: CRFR25227017
status: Active
price: 2195000
beds: 7
baths_full: 6
baths_half: 1
sqft_living: 6734
sqft_lot: 2
lot_acres: 1.76
year_built: 1928
property_type: Residential
property_subtype: Single Family Residence
address: "4175 N Van Ness Bld"
city: Fresno
state: CA
zip: 93704
county: "Fresno County"
lat: 36.7934522
lng: -119.8048025
days_on_market: 208
hoa_fee: 
hoa_frequency: 
garage_spaces: 4
list_agent: "Angie Hyatt"
list_office: "Hyatt Real Estate"
list_agent_phone: "(559) 827-9961"
list_agent_license: 01013098
mls_source: CRMLS
modified: 2026-03-26
transaction_type: buy
---

Home | Fresno County | Fresno | 93704 | 4175 N Van Ness Bld

4175 N Van Ness Bld, Fresno, CA 93704

MLS: CRFR25227017 | Status: Active | Price: $2,195,000
Beds/Baths: 7 / 6 /1
Property Type: Residential

Quick Facts

Beds Baths Sq Ft Acres Lot Yr Built
7 6 /1 6,734 1.76 1928

Remarks

This 1928 Sunset Boulevard Mediterranean Revival residence, situated on a 1.76 acre lot on Christmas Tree Lane in Old Fig Garden, was designed by renowned architect Rafael Lake for the Bernhauer family. As President of the then Fresno Planing Mill Co., Mr. Bernhauer infused his vision and craftsmanship into every detail of this home, which includes Mahogany millwork archways, coffered ceilings and so much more. As you enter thru the Arch Top Mahogany Double Doors, you are greeted by a Grand Foyer and a beautiful curved staircase. To the right is the Spacious Formal Living Room offering a stunning Fireplace, an adjacent elevated sitting space, and to complete this wing of the home, an Isolated Bedroom w/En-Suite Bath. To the left of the Foyer is the grand Formal Dining Room, boasting a Curved Bay Window that floods the room with natural light and can accommodate a large gathering of family and friends. Two Butler Pantries, both with sinks and an abundance of counter space, expand on the spacious Kitchen space for entertaining. A second staircase to the upstairs is situated between the two Butler Pantries, as well as the stairs to the basement which boasts a beautiful Wine Room. The Chef's Kitchen features Exquisite Portuguese Tiles, Wolf Range, Wall Oven, Built-in Refrigerator, Bu

MLS Listing Information

Field Value
MLS # CRFR25227017
MLS Source California Regional MLS
Days on Site 208

Features

Interior Features

Feature Details
Bedrooms Ground Floor Bedroom, Primary Suite/Retreat
Bathrooms Jack and Jill
Kitchen Pantry
Appliances Dishwasher, Freezer, Garbage Disposal, Oven - Electric, Oven Range - Built-In, Refrigerator, Dryer, Washer
Family Room Other
Fireplace Family Room, Living Room
Laundry In Laundry Room
Cooling Central Forced Air, Window/Wall Unit
Heating Central Forced Air

Exterior Features

Feature Details
Foundation Combination
Pool Pool - Yes
Style Mediterranean

Parking, School, and Other Information

Feature Details
Garage/Parking Garage: 4 Car(s)
Elementary District Fresno Unified
High School District Fresno Unified
HOA Fee $0
Complex Amenities Other

Contact Information

Angie Hyatt
Hyatt Real Estate
License #: 01013098
Phone: (559) 827-9961

School Ratings

School data provided by GreatSchools.org

Nearby Schools

School Type Grades Distance Rating
Powers-Ginsburg Elementary School public K-6 0.35 mi 6
Del Mar Elementary School public K-6 0.58 mi 4
Wawona K-8 public K-8 0.61 mi 2
Fort Miller Middle School public 7-8 0.74 mi 2
Deborah A. Williams Elementary School public K-6 0.82 mi 4
Bullard Talent Project School public K-8 0.96 mi 6
Phoenix Elementary Academy Community Day public 1,2,3,4,5,6 1.06 mi 1
Roeding Elementary School public K-6 1.27 mi 5
Manchester-Gate Elementary School public 2,3,4,5,6 1.27 mi 8
Pyle Elementary School public K-6 1.47 mi 3
Holland Elementary School public K-6 1.49 mi 4
Hamilton Elementary School public K-8 1.55 mi 2
Bullard High School public 9-12 1.69 mi 6
Gibson Elementary School public K-6 1.71 mi 6
Wilson Elementary School public K-6 1.71 mi 4
Baird Middle School public 5-8 1.72 mi 9
Design Science Early College High School public 9-12 1.81 mi 10
Fresno High School public 9-12 1.81 mi 3
Cooper Middle public 6-8 1.87 mi 3
Homan Elementary School public K-6 1.90 mi 6

Disclosures

©2026 California Regional MLS. All rights reserved. All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Information provided is for personal, non-commercial use by the viewer and may not be redistributed without explicit authorization from California Regional MLS.

Presently MLSListings.com displays Active, Contingent, Pending, and Recently Sold listings. Recently Sold listings are properties which were sold within the last three years. After that period listings are no longer displayed in MLSListings.com. Pending listings are properties under contract and no longer available for sale. Contingent listings are properties where there is an accepted offer, and seller may be seeking back-up offers. Active listings are available for sale.

This listing information is up-to-date as of March 26, 2026. For the most current information, please contact Angie Hyatt, (559) 827-9961.