Description
Spectacular mccaffrey custom home in the exclusive bellaviera neighborhood, offering panoramic views of the bluff, lake san joaquin river, sierra nevada mountains, and sparkling city lights. enter through olive tree-lined cobblestone paths into a masterpiece of craftsmanship - soaring vaulted ceilings, large porcelain tile with stone inlay, wrought iron stair rails, and dentil style crown molding & other custom features throughout. the gourmet kitchen features custom cabinetry, granite countertops, a convenient island breakfast bar, and a custom crafted range hood. the primary suite opens to a private balcony, the perfect spot to take in the breathtaking scenery. designed for entertaining, the backyard showcases a built-in bbq island, sparkling pool with a waterfall, majestic lion water features, and a charming gazebo dining area. additional highlights include owned solar, two heat pumps, rv/boat parking, electric car charger, surround sound, and a lot size of nearly 1/3 acre. a rare blend of luxury, function, and unforgettable views - truly one of a kind!
Property Type
ResidentialCounty
FresnoStyle
MediterraneanAD ID
49539778
Sell a home like this and save $96,401 Find Out How
Property Details
-
Interior Features
Bedroom Information
- Total Bedrooms : 5
Bathroom Information
- Total Baths: 4
- Full Baths: 3
Water/Sewer
- Water Source : Public
- Sewer : Public Sewer
Interior Features
- Roof : Spanish Tile
- Exterior Property Features : Rain Gutters
- Interior Features: Breakfast Bar,Built-in Features,Balcony,Breakfast Area,Ceiling Fan(s),Crown Molding,Cathedral Ceiling(s),Separate/Formal Dining Room,Eat-in Kitchen,Granite Counters,High Ceilings,Open Floorplan,Pantry,Recessed Lighting,See Remarks,Storage,Two Story Ceilings,Wired for Sound,Bedroom on Main Level,Entrance Foyer,Primary Suite
- Windows: Atrium,Blinds,Bay Window(s),Casement Window(s),Custom Covering(s),Double Pane Windows,Plantation Shutters,Screens
- Property Appliances: Built-In Range,Convection Oven,Dishwasher,ENERGY STAR Qualified Appliances,Disposal,Gas Oven,Gas Range,Microwave,Water Heater
- Fireplace: Family Room,Gas,Gas Starter
- Flooring: Carpet,Concrete,Laminate,Tile,Wood
Cooling Features
- Central Air,Heat Pump
- Air Conditioning
Heating Source
- Central,Heat Pump
- Has Heating
Energy
- Green Energy: Appliances
Fireplace
- Fireplace Features: Family Room,Gas,Gas Starter
- Has Fireplace: 1
-
Exterior Features
Building Information
- Year Built: 2005
- Construction: Concrete,Stone,Stone Veneer,Stucco
- Roof: Spanish Tile
Exterior Features
- Rain Gutters
Foundation
- Concrete Perimeter
Security Features
- Closed Circuit Camera(s),Carbon Monoxide Detector(s),Fire Detection System,Smoke Detector(s)
Pool Features
- Private,Waterfall
Laundry Features
- Inside,Laundry Room
Patio And Porch
- Covered,Enclosed
Fencing
- Block,Wrought Iron
-
Property / Lot Details
Lot Details
- Lot Dimensions Source: Vendor Enhanced
- Lot Size Acres: 0.3329
- Lot Size Source: Assessor
- Lot Size Square Feet: 14500
-
Listing Information
Listing Price Information
- Original List Price: 1,615,000
- Listing Contract Date: 2025-04-28
Lease Information
- Listing Agreement: Exclusive Right To Sell
-
Taxes / Assessments
Tax Information
- Parcel Number: 50234203S
-
Virtual Tour, Parking, Multi-Unit Information & Homeowners Association
Garage and Parking
- Garage Description: Concrete,Door-Multi,Door-Single,Driveway,Driveway Up Slope From Street,Garage Faces Front,Garage,Garage Door Opener,Paved,Public,RV Potential,RV Gated,RV Access/Parking,On Street,Storage
- Attached Garage: Yes
Homeowners Association
Rental Info
- Lease Term: Negotiable
-
School, Utilities & Location Details
Other Property Info
- Source Listing Status: Active
- Source Neighborhood:
- Postal Code Plus 4: 2126
- Directions: Headng West on Herndon from Brawley, north on N Milburn Ave, west on W Alluvial Ave, north on W River Vista Dr, northeast on N Belvedere Ave
- Source Property Type: Residential
- Property SubType: Single Family Residence
Building and Construction
- Property Age: 20
- Common Walls: No Common Walls
- Property Condition: Turnkey
- Structure Type: Single Family Residence
- Year Built Source: Assessor
- Total Square Feet Living: 3601
- Entry Level: 1
- Entry Location: Front Door
- Levels or Stories: Two
- Building Total Stories: 2
- Structure Type: House
Statistics Bottom Ads 2

Sidebar Ads 1

Learn More about this Property
Sidebar Ads 2

Sidebar Ads 2

Copyright © 2025 by the Multiple Listing Service of the California Regional MLS®. This information is believed to be accurate but is not guaranteed. Subject to verification by all parties. This data is copyrighted and may not be transmitted, retransmitted, copied, framed, repurposed, or altered in any way for any other site, individual and/or purpose without the express written permission of the Multiple Listing Service of the California Regional MLS®. Information Deemed Reliable But Not Guaranteed. Any use of search facilities of data on this site, other than by a consumer looking to purchase real estate, is prohibited.
BuyOwner last updated this listing 05/04/2025 @ 02:54
- MLS: FR25093516
- LISTING PROVIDED COURTESY OF: ,
- SOURCE: CRMLS
is a Home, with 5 bedrooms which is for sale, it has 3,601 sqft, 14,500 sized lot, and 3 parking. are nearby neighborhoods.