Fresno, CA 93704,4175 N Van Ness BLD
See all 75 photos
Fresno, CA 93704,4175 N Van Ness BLD
Fresno, CA 93704,4175 N Van Ness BLD
Fresno, CA 93704,4175 N Van Ness BLD
Fresno, CA 93704,4175 N Van Ness BLD
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
Maxwell Dukelow

Maxwell Dukelow

+1(408) 508-3200
Listed by Angie Hyatt • Hyatt Real Estate
$ 2,350,000
Est. payment /mo
Save Virtual Tour
Active

4175 N Van Ness BLD Fresno, CA 93704

7 Beds

6.5 Baths

6,734 SqFt

UPDATED:

Key Details

Property Type Single Family Home

Sub Type Single Family Home

Listing Status Active

Purchase Type For Sale

Square Footage 6,734 sqft

Price per Sqft $348

MLS Listing ID CRFR25227017

Style Mediterranean

Bedrooms 7

Full Baths 6

Half Baths 1

Year Built 1928

Lot Size 1 Sqft

Property Sub-Type Single Family Home

Source California Regional MLS

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

Area Fsno - Fresno

Rooms

Family Room Other

Kitchen Dishwasher, Freezer, Garbage Disposal, Pantry, Oven Range - Built-In, Refrigerator, Oven - Electric

Interior

Heating Central Forced Air

Cooling Central AC, Window / Wall Unit

Fireplaces Type Family Room, Living Room

Laundry In Laundry Room, Washer, Dryer

Exterior

Garage Spaces 4.0

Pool Pool - Yes

View None

Building

Foundation Combination

Water District - Public

Architectural Style Mediterranean

Others

Tax ID 43406203

Special Listing Condition Not Applicable

MLS Listing IDX PLUS
Copyright 2026 MLSListings Inc All rights reserved.

Nearby Locations

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.
Maxwell Dukelow

Maxwell Dukelow

Agent | License ID: 02113278

+1(408) 508-3200

GET MORE INFORMATION

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 Coldwell Banker, 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 BLD