Skip to main content

Lineage Properties - A Tradition of Trust. A Reputation For Excellence. Welcome To Our Family.

4266 N College Avenue Fresno, CA 93704
6 beds
5 baths
7,109 sq ft

Courtesy of Real Broker, Bambi Wright.

Contact Me to Learn More

Sasha Lupercio

Sasha Lupercio



Property Description

Come and enjoy living in your own private resort. This home makes you feel like you are on vacation every day. From the time you enter the gate to this magnificentColonialStyle home with an Italian flare to walking into your own water park you will be in awe. The kitchen is a chefs dream, with gas appliances, huge center island, ample counter space, walk in pantry, subzero fridge and freezer, warming drawer and double convection ovens. The downstairs master suite is in its own class of luxury. It boasts heated floors in the bathroom, infinity tub, a shower with water coming out at least 8 locations and a secluded outdoor waterfall spa with it’s own private entrance. Upstairs includes a private bar for all your hosting needs, a poker table that has linked cameras to the THEATER ROOM! You can host your very own poker tournaments! Each bedroom even has it’s own climate control! Next! Walk into a backyard waterpark. The walk in pool has a grotto lounge surrounded by water falls, swim up bar, and a water slide. Other amenities include custom gazebo with built in BBQ and sink, in ground BBQ pit, 2,700 sqft metal building, and a 450 sqft pool house with its own bathroom. This home has too many luxuries to list!

Property Details & Features

Property Type

  • Single Family Residence

Year Built

  • 2007


  • Spa type: {In Ground}
  • Isolated Bedroom
  • Isolated Bathroom
  • Security System
  • Security Gate
  • Built In Cabinets
  • Wet/Dry Bar
  • Intercom
  • High Tech Cable
  • Other/See Remarks

Appliances and Equipment

  • Security System
  • Solar Panels


  • 5 bathrooms
  • Tub/Shower
  • Shower
  • Tub
  • Other
  • Jetted Tub


  • 6 bedrooms


  • Building style: {Colonial}
  • Built in 2007
  • {Two}

Dining Room

  • Formal

Disability Features

  • Wide Doors

Exterior Features

  • Other
  • Covered
  • Concrete


  • 1 fireplace
  • Gas Insert


  • Floor: Concrete
  • Tile
  • Hardwood
  • Other


  • Garage type: Attached
  • 6 garage spaces

Heating & Cooling

  • Central Heat & Cool


  • Built In Range/Oven
  • Gas Appliances
  • Disposal
  • Dishwasher
  • Eating Area
  • Breakfast Bar
  • Pantry
  • Refrigerator
  • Wine Refrigerator
  • Other


  • Inside
  • Utility Room
  • On Lower Level
  • Electric Hook Up


  • Listed on 2022-02-22 00:00:00
  • $1,476,923 acre
  • $270 per sqft


  • County: Fresno
  • Directions: GPS is accurate for this property. From Ashland go north on College, house is like the third property on the right.


  • 56,628 sqft
  • 1 acres

Energy Saving

  • Dual Pane Windows
  • 13+ SEER A/C


  • Existing RV Parking
  • Potential RV Parking
  • Circular Driveway
  • Tandem Garage


  • In Ground


  • Shop
  • Sprinklers Front
  • Sprinklers Back
  • Sprinklers Auto
  • Fenced
  • Mature Landscape


  • Roofing: {Tile}

Additional Rooms

  • Great Room
  • Den/Study
  • Game Room
  • Wine Room


  • High School: Bullard
  • Junior High School: Wawona
  • Grade School: Powers Ginsburg


  • Public Utilities
  • Public Water
  • Public Sewer

Mortgage Calculator

Let’s Talk

You’ve got questions and we can’t wait to answer them.

We use cookies and tracking technology in connection with your activities on our website. By viewing and using our website, you consent to our use of cookies and tracking technology in accordance with our Privacy Policy.