Single-family home
Listing Agent: Angie Hyatt (DRE #01013098) · Listing Office: Hyatt Real Estate · Contact: 559-229-9961 · Bought with: Brian Domingos · Premier Plus Real Estate Company · MLS #FR25227017 · Source: CRMLS
4175 N Van Ness Boulevard N sold for $2,000,000 in July 2026, 8.9% under its $2,195,000 list price, after 229 days on the market. It was first listed at $2,350,000. That works out to $297 per square foot on 6,734 square feet. Across 14 closed sales in 93704 over the last 12 months, the median sold price is $410,000 and the median is $261 per square foot, 12% below this sale's $297.
| Quarter | Closed sales in 93704 | Median sold price |
|---|---|---|
| Q1 2026 | 1 | $375,000 |
| Q2 2026 | 4 | $422,250 |
| Q3 2026 | 7 | $380,000 |
| Q4 2026 | 2 | $453,500 |
Figures are MLS-reported closed sales (CRMLS); ZIP medians cover the last 12 months. Nalren does not estimate values. Recently sold in Fresno · Homes for sale in 93704
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 description from the July 2026 sale, as reported to CRMLS.
Closed sales reported in 93704, nearest first, last 12 months. All recent sales in Fresno →