4175 N Van Ness Boulevard N
Fresno, CA, 93704 $ 2,350,000
Bedrooms7 Baths6.1 Sq 6,734 Monthly Estimate*
$ 14,661
Listed by Hyatt Real Estate
for $2,350,000 with 7 bedrooms and 6 full baths, 1 half bath. This 6,734 square foot home was built in 1928 on a lot size of 1.76.
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.
See more
FeaturesGeneralLiving Area 6734
Sewer Public Sewer
Heating Central
Cooling Central Air Wall/Window Unit(s)
Appliances Built-In Range Dishwasher Electric Oven Freezer Disposal Refrigerator Dryer Washer
HOA Fee 0
Garage Spaces 4
Patio/Porch Features Concrete
Architectural Style Mediterranean
Pool Features Private
Exclusions 3 pew kneeler/landing.Face mug cabinet white iron grid in studioStained glass@patio 2 crowns
Year Built 1928
View None
Stories Count 2
Levels Two
Property Subtype Single Family Residence
Community Features Urban
County Fresno
New Construction 0
Property Type Residential
Association Amenities Other
HOA 1
Attached Garage 0
Garage Y/N 1
Green Energy Generation Solar
Full Baths 6
Special Listing Conditions Standard
Status Active
Directions Corner of Van Ness and Ashlan
City Fresno
Association Name 0
Entry Location main
Senior Community Y/N 0
High School District Fresno Unified
Number Of Units Total 1
MLS Area FSNO - Fresno
Lot Size Units Acres
Lot Size Square Feet 76665.6
Listing Terms Cash Conventional
Property Attached Y/N 0
Land Lease Y/N 0
Additional Parcels Y/N 0
Lease Considered Y/N 0
Virtual Tour https://track.pstmrk.it/3s/mk-fresno-photo.aryeo.com%2Fsites%2Fnxrbrog%2Funbranded/cUpU/lU-AAQ/AQ/375e1ba6-353a-44c8-9cdc-9f8a28087a02/3/top-IO9NQo https://track.pstmrk.it/3s/mk-fresno-photo.aryeo.com%2Fsites%2F4175-n-van-ness-blvd-fresno-ca-93704-19464536%2Fbranded/cUpU/lU-AAQ/AQ/375e1ba6-353a-44c8-9cdc-9f8a28087a02/2/hHMQ03SshZ
Structure Type House
Living Area Units Square Feet
Standard Status Active
Occupancy Type Owner
Year Built Source Owner
Tax Lot 429
Property Sub Type Additional Single Family Residence
See more
InteriorInterior Amenities Multiple Staircases Bedroom on Main Level Entrance Foyer Jack and Jill Bath Primary Suite Walk-In Pantry
Basement Finished Unfinished Utility
Fireplace Features Family Room Living Room
Total Stories 2
Common Walls No Common Walls
Basement (Y/N) 1
Air Conditioning Y/N 1
Heating Y/N 1
Fireplace Y/N 1
Half Baths 1
Laundry Features Laundry Room
Total Bedrooms 7
Entry Level 1
Main Level Bedrooms 2
Main Level Bathrooms 2
Total Baths 7
See more
ExteriorLot Features Corner Lot Sprinklers In Rear Sprinklers In Front Sprinkler System
Water Source Public
Total Parking 4
Lot Size Area 1.76
Foundation Details Combination
Lot Size Acres 1.76
Private Pool 1
Lot Size Source Public Records
See more
* Excluded FeaturesAffordability Calculator
- Monthly Principal & Interest
- $14,661
- Monthly Property Taxes
- --
- Monthly Home Insurance
- --
Default based on a 30-year fixed rate of 6.375% with 20% down. The estimated payment is offered for convenience and is not an offer of credit. Due to market fluctuations, interest rates are subject to change at any time and without notice. Your individual rate may vary. Rates may differ for FHA, VA or jumbo loans.
Learn more about how to save NearbySingle family listings in Fresno, CA
Average List Price $578,055
Percent of Sale Price 75%
About Fresno, CA 519,416 Population
20% Since 2002
$ 43,540 Median Income
32.54 Median Age
37% Households with Children
Trends Information provided by ATTOM Data Solutions.
4827338 Elementary School
4827337 Middle School
Unknown High School High School
Pricing History| Date | Price | Price Change | Description |
|---|
| 11/27/2025 | $2,350,000 | | Listed Price |