4175 N Van Ness Boulevard N, Fresno, California 93704, Fresno, 93704 - 7 bed, 7 bath

4175 N Van Ness Boulevard N, Fresno, California 93704 home-pic-0

4175 N Van Ness Boulevard N

Fresno, California 93704

ACTIVE
CONDITION: GOOD
7Beds
7Baths
6,734Sq Ft
76,665.602Lot Size

Property Price

LIST PRICE$2,350,000

SUMMARY

Analysis of 4175 N Van Ness Boulevard N, Fresno, California 93704 is currently available with a list price of $2,350,000. The property maintains a Good Condition Rating (78/100), reflecting solid structural condition with well-maintained systems. The property presents an attractive opportunity for buyers seeking a move-in ready home. Located in a high-demand neighborhood within the Fresno Unified School District, this asset is categorized as a low-risk, high-reward acquisition suitable for both Buy-and-Hold Investors and Owner-Occupants willing to undertake light renovation work.

Condition Analysis

OVERALL CONDITION SCORE

Good
TeardownExcellent

Property is move-in ready.

This 1928 Mediterranean Revival residence is exceptionally well-maintained and has undergone significant updates, making it move-in ready. Major systems like the 4 HVAC units and owned solar are modern. The kitchen features high-end appliances (Wolf Range, built-in refrigerator) but the Portuguese tiles and ceiling light panel suggest a renovation that is likely 10-20 years old, offering a classic rather than ultra-modern aesthetic. The bathrooms are updated with modern fixtures and finishes, clean, and functional. While not 'newly built' or 'extensively renovated within 5 years' in a contemporary style, the property's overall condition, updated systems, and functional, well-appointed interiors align perfectly with the 'Good' rating.

PROSSTRENGTHS & OPPORTUNITIES

  • High Available Lot Utilization

    The property has a large lot size, which is more than 4 times of its living area. lot size in square feet = 76665, living area = 6734.

  • Historic Architectural Significance

    A 1928 Mediterranean Revival residence designed by renowned architect Rafael Lake, featuring exquisite original details like Mahogany millwork and coffered ceilings, offering unique historical value.

  • Expansive & Prestigious Estate

    Situated on a substantial 1.76-acre lot in the highly desirable 'Christmas Tree Lane in Old Fig Garden,' providing exceptional privacy and a prime location.

CONSRISKS & DEFICIENCIES

  • Age-Related Maintenance

    As a 1928-built property, despite updates, it may require specialized and ongoing maintenance typical of historic homes, potentially incurring higher costs and effort.

  • Absence of Scenic Views

    The property description explicitly states 'None' for views, which might be a significant detractor for luxury buyers seeking panoramic or picturesque outlooks.

  • High Operational Costs

    The large 1.76-acre lot, extensive landscaping, swimming pool, and substantial square footage imply considerable ongoing expenses for utilities, maintenance, and upkeep.

About 4175 N Van Ness Boulevard N

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.

Property Details

Public Facts

Property Type
Single Family Residence
Year Built
1928
Lot Size
76,665.602 Sq. Ft.

Interior

Total Bedrooms
7
Total Bathrooms
7 (7 Full, 0 Half)

Exterior & Parking

No exterior & parking available.

Utilities & Misc

HOA Fee
$0 / Month

Neighborhood Insights

Sensitive Facilities

No sensitive facilities data found.

Neighborhood Comparison

FeatureSubjectAverage HomeNeighborhood Ranking (50 Listings)
Beds7.03.0
92%
Baths7.02.5
92%
Square foot6,7341,749.5
92%
Lot Size76,665.60210,260
92%
Price$2.35M$447.0K
92%
Price per sq ft$349$263
83%
Built year19281951
8%
HOA$0$0
50%
Days on market161173
33%

Pricing History

Listed for Sale

Sep 27, 2025

$2,350,000

Initial Listing

Browse Properties by State Browse housing market trends by state