Fresno, CA 93704,4175 N Van Ness Boulevard
Fresno, CA 93704,4175 N Van Ness Boulevard
Fresno, CA 93704,4175 N Van Ness Boulevard
60
See all 60 photos
Listed by Angie Hyatt • Hyatt Real Estate
$2,350,000
Est. payment /mo
Save Video Tour
7 Beds
7 Baths
6,734 SqFt
Active

4175 N Van Ness Boulevard Fresno, CA 93704

Save Video Tour
REQUEST A TOUR If you would like to see this home without being there in person, select the "Virtual Tour" option and your agent will contact you to discuss available opportunities.
In-PersonVirtual Tour
Thu
29
Jan
Fri
30
Jan
Sat
31
Jan
Wen Guo

Wen Guo

+1(650) 817-5000

UPDATED:

Key Details

Property Type Single Family Home

Sub Type Detached

Listing Status Active

Purchase Type For Sale

Square Footage 6,734 sqft

Price per Sqft $348

MLS Listing ID CRFR25227017

Bedrooms 7

Full Baths 6

HOA Y/N Yes

Year Built 1928

Lot Size 1.760 Acres

Property Sub-Type Detached

Source Datashare California Regional

Property Description

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

Location

State CA

County Fresno

Interior

Heating Central

Cooling Central Air, Wall/Window Unit(s)

Fireplaces Type Family Room, Living Room

Fireplace Yes

Appliance Dishwasher, Range, Refrigerator

Laundry Dryer, Laundry Room, Washer

Exterior

Garage Spaces 4.0

Amenities Available Other

View None

Private Pool true

Building

Lot Description Corner Lot, Sprinklers In Rear

Story 2

Foundation Combination

Water Public

Architectural Style Mediterranean

Schools

School District Fresno Unified

Bay East Association of Realtors
© 2026 BEAR, CCAR, bridgeMLS. This information is deemed reliable but not verified or guaranteed. This information is being provided by the Bay East MLS or Contra Costa MLS or bridgeMLS. The listings presented here may or may not be listed by the Broker/Agent operating this website.

NEARBY SCHOOL & BUSINESS

SCHOOLSPROPERTIES
Elementary Schools 20
  • 10

    Morris E. Dailey Charter Elementary School

    Public | KG - 5

  • 10

    Manchester Gate

    Public | 2 - 6

  • 7

    Baird Middle School

    Public | 5 - 8

  • 7

    McCardle Elementary School

    Public | KG - 6

  • 6

    Malloch Elementary School

    Public | KG - 6

  • 6

    Starr Elementary School

    Public | KG - 6

  • 6

    Bullard Talent Project

    Public | KG - 8

  • 6

    Webster Elementary School

    Public | KG - 6

  • 6

    Wishon Elementary School

    Public | KG - 6

  • 5

    Valley Preparatory Academy Charter

    Public | KG - 12

  • 5

    Homan Elementary School

    Public | KG - 6

  • 5

    Gibson Elementary School

    Public | KG - 6

  • 5

    Powers-Ginsburg Elementary School

    Public | KG - 6

  • 5

    Kratt Elementary School

    Public | PK - 6

  • 5

    Del Mar Elementary School

    Public | KG - 6

  • 5

    Susan B. Anthony Elementary School

    Public | KG - 6

  • 5

    Birney Elementary School

    Public | KG - 6

  • 5

    Eaton Elementary School

    Public | KG - 6

  • 4

    Slater Elementary School

    Public | KG - 6

  • 4

    Hamilton Elementary School

    Public | KG - 8

Middle Schools 13
  • 5

    Cooper Middle School

    Public | 6 - 8

  • 3

    Tenaya Middle School

    Public | 7 - 8

  • 3

    Ahwahnee Middle School

    Public | 7 - 8

  • 1

    Phoenix Secondary School

    Public | 7 - 12

  • 1

    Fort Miller Middle School

    Public | 7 - 8

  • 1

    Tehipite Middle School

    Public | 6 - 8

  • 1

    Tioga Middle School

    Public | 7 - 8

  • 0

    Dunamis

    Private | 6 - 12

  • 0

    Florence E. Rata

    Public | 8 - 12

  • 0

    Wawona Middle School

    Public | 6 - 8

  • 0

    Dewolf Continuation High School

    Public | 7 - 12

  • 0

    Fresno County Community Day

    Public | 7 - 12

  • 0

    Carter G. Woodson Public Charter

    Public | 7 - 12

High Schools 6
  • 9

    Design Science Early College High School

    Public | 9 - 12

  • 4

    Bullard High School

    Public | 9 - 12

  • 4

    Fresno High School

    Public | 9 - 12

  • 2

    Hoover High School

    Public | 9 - 12

  • 0

    San Joaquin Memorial High School

    Private | 9 - 12

  • 0

    Fresno Regional Occupational Program

    Public | 9 - 12

School and business data provided by Attom Data.

GET MORE INFORMATION

Wen Guo

Wen Guo

Agent | License ID: 02037634

+1(650) 817-5000

Name
Phone*
Message

By checking this box, I agree by electronic signature to the Electronic Disclosure Consent Agreement; to receive recurring marketing communication from or on behalf of Keller Williams Realty, including auto-dialed calls, texts, and artificial/prerecorded voice messages (message frequency varies; data rates may apply; reply "STOP" to opt-out of texts or "HELP" for assistance); and to the Terms of Service and Privacy Policy of this website. Consent not required to make a purchase. I understand that I can call to obtain direct assistance.

Go tour this home

4175 N Van Ness Boulevard