Water Views
29510 Avenue 5 1/2 Madera, CA
$ 2,259,000
Property Attributes
  • MLS#564276
  • TypeSingle Family
  • CountyMADERA
  • CityMadera
  • Area637
  • Zip93637
  • StyleVictorian
  • Price$ 2,259,000
  • Bedrooms4
  • Full Bathrooms4
  • Half Bathrooms0
  • Sqr Footage3885
  • Lot Size3.3 Acres
Listing Provided Courtesy Of:
Linda M. Koleen with IPS InvestmentPropertyServices.
Data Source:
Fresno MLS - 45 - CA
Property Description

This Property Sale is Contingent upon Neighboring APN's (048-290-004 + 048-290-016) selling first or all-together! MLS #564294 + #564295Custom 2-story 4BR/4BA Victorian Home, blt 1991, with extensive woodwork & decorator details. Gourmet Kitchen - Newly Constructed in year 2014- Thermador Pro Grand Steam Gas Range - The Ultimate Culinary Center + Griddle Range/Oven/Steam/Warming/Rotisserie/Convection- Thermador Range Hood- Thermador Grand Steam Oven & Microwave & Warming Drawer- Thermador Induction 4-Burner Cook Top- Thermador Side by Side Refrigerator / Freezer- Thermador Dishwasher & Fisher/Paykel Double Drawer DW- Thermador 80 Bottle capacity Wine Cooler- Scotsman Nugget Ice Machine- KitchenAid Compactor- 2x Pantry's, one Walk-In with Extensive Shelving, etc. Media Entertainment Sunroom - with flat screens TV/hookup's and remote auto window coverings with built-in surround sound system, including built-in bench & breakfast nook Great room w/elegant woodburning fireplace - detailed woodwork throughout, hardwood floors, mini dry-bar, 2-story ceiling to let in beautiful light Dining Room to fit 14 comfortably & library nook Secret BONUS Room Master Bedroom - with access to Large Covered Balcony, renovated year 2014 New Generator to support household & whole house fan & brand new wrought iron entrance gate with Remotes29518 Avenue 5 1/2 Rental / Caretaker / Farm Manager home = 2BR/1BA + Shower/Sink room, Kitchen, Dining Area, Living Room, 1504sf, Rent Rate could be: $1100/mo

Elementary School Middle School High School
Eastin-Arcola Elementary School Eastin-Arcola Middle School Madera High School
Price History
8/7/2021 Listed $2,259,000

General Features

Architectural Style Victorian
Board Loaded No
Census Tract 0.000
Co-Listing Agent Sullivan Grosz
Exterior Features Vinyl
Fips Code 39
Flooring Carpet, Tile, Hardwood
G.p.m. 0.00
Garage Spaces 3
Gas & Electric Public Utilities
HOA Fee 0.00
Levels Two
Lot Size Square Feet 143748.00
Patio/Porch Features Covered, Uncovered, Wood Deck
Pool Y/N No
Price Per Square Foot 581.47
Private Pool No
Property SubType Single Family Residence
Property Type Residential
REO/Bank Owned No
Roof Composition
School District Madera Unified
Sewer Septic Tank, Private Well
Site Amenities Riverview
Special Features Isolated Bedroom, Isolated Bathroom, Security Gate, Built In Cabinets
Sub Lease Expiration Date 1800-01-01T00:00:00
Year Built 1991

Interior Features

Basement Sq Ft. 0.00
Bath Features Tub/Shower, Roman Tub
Bathrooms Display 4
Dining Room Features Formal
Extra Rooms Loft, Game Room
Fireplace Features Masonry, Gas Insert
Heat/Air Conditioning Central Heat & Cool, Whole House Fan
Kitchen Built In Range/Oven, Gas Appliances, Electric Appliances, Disposal, Dishwasher, Microwave, Trash Compactor, Eating Area, Breakfast Bar, Pantry, Refrigerator, Wine Refrigerator
Laundry Features Inside, Utility Room, Gas Hook Up
Living Area 3885.00
Total Bedrooms 4
Total Fireplaces 1

Exterior Features

Available Date 1800-01-01
Bathrooms 4.00
Parcelnumber 048290017000
Detached Structures Guest House, 2 Homes on Lot
Foundation Wood Sub Floor
Garage Type Attached
Lot Size Acres 3.3000
Lot Size Source (Tax Records)
Parking Features Existing RV Parking, Uncovered, Work/Shop Area, Auto Opener, Circular Driveway
Price Per Acre 684545.45
Solar No
Spa No
Water Level 0.00
Well Depth 0.00
Well Hp 0.00
Yard Sprinklers Front, Sprinklers Back, Sprinklers Auto, Mature Landscape, Drip System


  • Foreclosure
  • Views
  • Short Sale
  • New Construction
  • Adult 55+
  • Lease To Own
  • No HOA Fees
  • Furnished
  • Primary On Main
  • Air Conditioning
  • Seller Finance
  • Green
  • Fixer Upper
  • Horse
  • Golf
  • Fireplace
  • Deck
  • Garage
  • Basement
  • Pool

Property vs Single Family Average in 93637

AVG $560K
AVG 69
Year Built
AVG 1982

Looking for a more comfortable experience?

Download our mobile app for a personalized browsing experience.