email phone translateTranslate
homeOpen Houses

4175 N VAN NESS BLVD, FRESNO, CA, 93704

  • $1,599,000 -$76,000
  • 6Beds
  • 6Baths
  • 6,235Sqft
  • Style
  • Single Family
  • Listed Date 05/18/2016
  • Open House
  • NEWLY PRICED -$76,000
  • Luxury
  • Pending
  • New Listing 05/18/2016
  • Coming Soon
  • Sold
  • Rental
Thank you

Interested in this property

Rare opportunity to own a classic masterpiece in the heart of Christmas Tree Lane. Old World Mediterranean style home on 2+ acres on prestigious Van Ness Blvd in Old Fig Garden. Built in 1928 for the Bernhauer family, this is a historically registered (only) 3 owner home. Unparalleled craftsmanship throughout offering custom windows, luxurious arches, gorgeous staircase, custom ceilings, stunningly beautiful hardwood floors. Living room boasts a handsome stone fireplace, and the cozy family room also with fireplace has lots of built-in storage. Formal dining too! The master suite is upstairs, as well as 3 more bedrooms, (2 with Jack & Jill bath) in the children's wing. Full curved bay window in dining room. There is a guest house, abundant parking, and pool in very private setting surrounded by picturesque trees, serene peaceful patios, and breathtaking landscape. Also offered is a detached 4 car garage. This lovely home has what a sophisticated buyer will appreciate and much more.

Listing courtesy of: Stacey P. Simons, London Properties, Ltd.
  • Property type: Single Family
  • Status: Active
  • List Price: $1,599,000
  • MLS# 463926
  • Beds: 6
  • Baths: 6
  • Listed: 05/18/2016
  • Sqft: 6,235
  • Lot Size Acres: 2.16
  • Age: 89
  • Association: Fresno MLS
  • Basement: Partial, Unfinished
  • Basement Sq Ft: 0.00
  • Bath Features: Shower, Tub
  • Carport Spaces: 0
  • County: Fresno
  • Dining Room Features: Formal
  • Directions: Southwest corner of Ashlan and Van Ness.
  • Exterior: Stucco
  • Fireplace Type: Masonry
  • Floor: Carpet, Hardwood, Other, Tile
  • Foundation: Concrete
  • Garage Type: Detached
  • Garage Space: 4
  • Gas and Electric: Public Utilities
  • Heating and Cooling: Central Cooling, Central Heat & Cool, Central Heating
  • Fireplace YN: Yes
  • New Construction YN: No
  • Pool YN: Yes
  • REO or Bank Owned YN: No
  • Short Sales YN: No
  • Kitchen Area: 0
  • Kitchen_x0020_Desc: Breakfast Bar, Dishwasher, Disposal, Eating Area, Refrigerator, Gas Appliances, Microwave, Pantry, F/S Range/Oven, Trash Compactor
  • Kitchen Dim: 0 x 0
  • Kitchen Len: 0
  • Kitchen Wid: 0
  • Laundry: Inside, Utility Room
  • Living Room Area: 0
  • LivingRoom Dim: 0 x 0
  • LivingRoom Len: 0
  • LivingRoom Wid: 0
  • Lot Measurement: Square Feet
  • Lot Size Source: Tax Records
  • Lot Square Footage: 94050.00
  • Number of Fireplaces: 2
  • Number of Stories: 2
  • Parking Features: Uncovered
  • Patio Features: Concrete, Covered, Stone
  • Pool: Y
  • Pool Type: In Ground
  • Roof: Tile
  • Solar: No
  • Special Features: Wet/Dry Bar, Built In Cabinets, High Tech Cable, Isolated Bedroom, Isolated Bathroom, Security Gate, Security System
  • Stories: Two Story
  • Style: Mediterranean
  • Yard: Fruit/Nut Trees, Garden Area, Mature Landscape, Sprinklers Auto, Sprinklers Back, Sprinklers Front, Sprinklers Manual
  • Year Built: 1928

YOUR MORTAGE PROVIDERS

Your mortage providers plays a significant role in the success of your home purchase. To start the pre-qualification process we invite you to visit one of our preferred providers:

Mortgage Calculator

Find out your monthly payments for this listing
888-702-4297

Find out how much you can save on insurance!

Quote Type


Enter Your Zip Code

Area Map


 

radio_button_unchecked
location_on

Area Overview


Nearby Schools

pyle elementary school (k-5)
4140 n augusta st
fresno, CA 93726
place1.43 miles from listing, web Website 22 students per teacher Educational climate index: below average
32 staff members 730 total students Poverty level:30 percent or more percent Enrollment change: -1% to -5%
design science early college high school (k-5)
2004 e cambridge ave
fresno, CA 93703
place1.93 miles from listing, web Website 26 students per teacher Educational climate index: low
10 staff members 266 total students Poverty level:30 percent or more percent Enrollment change: +15% to +20%
bullard high school (k-5)
5445 n palm ave
fresno, CA 93704
place1.60 miles from listing, web Website 22 students per teacher Educational climate index: average
120 staff members 2730 total students Poverty level:30 percent or more percent Enrollment change: +1% to +5%
baird middle school (k-5)
5500 n maroa ave
fresno, CA 93704
place1.68 miles from listing, web Website 17 students per teacher Educational climate index: average
35 staff members 600 total students Poverty level:30 percent or more percent Enrollment change: -1% to -5%
bullard talent project school (k-5)
4950 n harrison ave
fresno, CA 93704
place1.01 miles from listing, web Website 20 students per teacher Educational climate index: average
40 staff members 800 total students Poverty level:30 percent or more percent Enrollment change: +5% to +10%
powers-ginsburg elementary school (k-5)
110 e swift ave
fresno, CA 93704
place0.31 miles from listing, web Website 19 students per teacher Educational climate index: average
42 staff members 800 total students Poverty level:30 percent or more percent Enrollment change: More than -50%/+50%
wawona middle school (k-5)
4524 n thorne ave
fresno, CA 93704
place0.62 miles from listing, web Website 18 students per teacher Educational climate index: average
40 staff members 740 total students Poverty level:30 percent or more percent Enrollment change: -20% to -50%
del mar elementary school (k-5)
4122 n del mar ave
fresno, CA 93704
place0.55 miles from listing, web Website 17 students per teacher Educational climate index: average
36 staff members 628 total students Poverty level:30 percent or more percent Enrollment change: -1% to -5%
fort miller middle school (k-5)
1302 e dakota ave
fresno, CA 93704
place0.72 miles from listing, web Website 21 students per teacher Educational climate index: average
40 staff members 864 total students Poverty level:30 percent or more percent Enrollment change: +1% to +5%
hamilton elementary school (k-5)
102 e clinton ave
fresno, CA 93704
place1.52 miles from listing, web Website 21 students per teacher Educational climate index: average
38 staff members 827 total students Poverty level:30 percent or more percent Enrollment change: -1% to -5%
fresno high school (k-5)
1839 n echo ave
fresno, CA 93704
place1.90 miles from listing, web Website 17 students per teacher Educational climate index: average
120 staff members 2105 total students Poverty level:30 percent or more percent Enrollment change: -20% to -50%
deborah a. williams elementary school (k-5)
525 w saginaw way
fresno, CA 93705
place0.80 miles from listing, web Website Not Reported students per teacher Educational climate index: low
staff members 638 total students Poverty level:30 percent or more percent Enrollment change: -1% to -5%
our lady of victory school (k-5)
1626 w princeton ave
fresno, CA 93705
place1.87 miles from listing, web Website 18 students per teacher Educational climate index: low
9 staff members 150 total students Poverty level:30 percent or more percent Enrollment change: No Change
first church christian academy (k-5)
3920 n 1st st
fresno, CA 93726
place1.84 miles from listing, web Website 9 students per teacher Educational climate index: below average
15 staff members 188 total students Poverty level:30 percent or more percent Enrollment change:
crescent view south charter school (k-5)
1901 e shields ave
fresno, CA 93726
place1.29 miles from listing, web Website 27 students per teacher Educational climate index: below average
17 staff members 467 total students Poverty level:30 percent or more percent Enrollment change: -1% to -5%
fairmont private school of fresno (k-5)
435 w fairmont ave
fresno, CA 93705
place1.11 miles from listing, web Website 28 students per teacher Educational climate index: low
2 staff members 57 total students Poverty level:not reported percent Enrollment change:
truth tabernacle christian school (k-5)
4411 n 1st st
fresno, CA 93726
place1.81 miles from listing, web Website 13 students per teacher Educational climate index: unclassified
7 staff members 93 total students Poverty level:30 percent or more percent Enrollment change:
morris e. dailey charter elementary school (k-5)
3135 n harrison ave
fresno, CA 93704
place1.07 miles from listing, web Website 22 students per teacher Educational climate index: low
16 staff members 367 total students Poverty level:30 percent or more percent Enrollment change: No Change
Fresno Multiple Listing Service™ system The real estate listing data marked with this icon comes from the IDX program of the Fresno Multiple Listing Service™ system.
SegmetPixel
keyboard_arrow_up