$2,195,000

4175 N Van Ness Boulevard N, Fresno, CA 93704

  • 7 beds |
  • 7 baths |
  • 6,734 sqft
  • Property Icon Single-Family Home
  • Property Year Built Icon Built in 1928
  • Property Lot Size Icon1.76acre lot
  • Property Parking Icon 4 car garage
  • Property Price Per Square Feet Icon $326/sqft
  • Property List Date Icon Listed 6 months ago

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, Built-in Griddle, Informal Dining Area, and a Pantry. A lovely Studio/Family room is located adjacent to the Kitchen and offers a Fireplace and a wall of Shuttered Windows, which makes it a perfect room for relaxation. The over-sized Laundry Room featuring a Sink, ample Counter Space, Washer/Dryer and a Freezer, plus another Spacious Isolated Bedroom with adjacent Bath complete this section of the home. The Upstairs features the Primary Bedroom with an En-suite Bath, Dressing Area, walk-in Closet and access to a Balcony which views the rear garden. Bedroom # 4 views the front garden, Bedroom #5 features an En-Suite Bath, and Bedroom #6 and #7 which share a Jack-n-Jill Bath complete the Upstairs The Guest House is just steps away from the house and features a Spacious Bedroom, Kitchen with Dining Area, a Shower Bath, plus a storage room, and offers views of the Sparkling Swimming Pool and beautiful Grounds. Other Amenities include a 4+ Car Garage, Tile Roof, on most of the home, Owned Solar, 4 HVAC Units, Potential RV Parking. Completely Fenced Property offering Mature Landscaping. Do not miss the opportunity to make this special property your new home! Call for your private showing.

Listing Status:
Active
Date Added:
September 27, 2025
Data Last Updated:
April 16, 2026 at 6:19AM
Listing Office:
Hyatt Real Estate : 559-229-9961
Listing Agent:
Angie Hyatt : 559-827-9961
MLS ID:
FR25227017
  • General: Multiple StaircasesBedroom on Main LevelEntrance FoyerJack and Jill BathPrimary SuiteWalk-In Pantry
  • Appliances: Built-In RangeDishwasherElectric OvenFreezerDisposalRefrigeratorDryerWasher
  • Laundry: Laundry Room
  • Basement: FinishedUnfinishedUtility
  • A/C: Central AirWall/Window Unit(s)
  • Heating: Central
  • Fireplace: Family RoomLiving RoomFireplace
  • Eco/Green Feature: Solar
  • Style: Mediterranean
  • Other Structures: Concrete
  • Pool: Private
  • Parking: Parking spaces: 4
  • General: 2Combination
  • HOA Amenities: Other0.0
  • Originating MLS: CRMLS_CRM
  • School District: Fresno Unified
  • County: Fresno
  • Zoning: 43406203
  • View: None
  • Water: Public
  • Sewer: Public Sewer
  • Source: CRMLS_CRM
  • Exclusions: 3 pew kneeler/landing.Face mug cabinetwhite iron grid in studioStained glass@patio2 crowns

This listing courtesy of Angie Hyatt , Hyatt Real Estate

Monthly Payment

$Est. Payment
  • Principal & Interest $
  • Property Taxes $
  • Home Insurance $
  • VA Funding Fee $

Ready to Start a VA Loan?

Get Started Veterans United Home LoansNMLS #1907  †
Interest rates used in the VA mortgage calculator are shown for illustrative purposes only. Your rate may differ based on a variety of factors, including your credit score and the current market conditions. To get your personalized interest rate, start your quote online.

Location

Schools Nearby

P

Powers-Ginsburg Elementary School

110 E Swift Ave, Fresno, CA, 93704

Grades PK-6

0.32 miles away

W

Wawona K-8 School

4524 N Thorne Ave, Fresno, CA, 93704

Grades 7-8

0.58 miles away

B

Bullard High School

5445 N Palm Ave, Fresno, CA, 93704

Grades 9-12

1.69 miles away

Disclaimer: School and School District information courtesy of the National Center for Education Statistics (NCES). School boundaries may change. Proximity to listed schools does not guarantee enrollment eligibility. Contact the school district for more information and exact boundaries.