Stunning Modern Farmhouse in Prestigious Riverstone Community!This move-in ready home features an open-concept layout with vaulted ceiling features a elegant kitchen with stainless appliances, and luxury finishes throughout including wood-look tile floors throughout, plantation shutters, and spa-like owners suite with marble look shower. But the real showstopper? Incredible outdoor living spaces including multiple entertainment zones, private gazebo with fire table, hanging egg chair, and lush landscaping - perfect for California entertaining!Located in the acclaimed Riverstone Community which offers community pool, fitness center, parks, and elementary school within walking distance. Look forward to Food Truck Friday's at the lodge, monthly events, concerts, movie nights, pickleball tournaments and more!Oh by the way, ask your realtor about the assumable loan under 3%!
For sale
$405,000
287 Huntington Ave S, Madera, CA 93636
2beds
2baths
1,460sqft
Est.:
Residential, Single Family Residence
Built in 2021
3,920.4 Square Feet Lot
$404,300 Zestimate®
$277/sqft
$150/mo HOA
What's special
Luxury finishesMultiple entertainment zonesOpen-concept layoutWood-look tile floorsMarble look showerVaulted ceilingIncredible outdoor living spaces
- 2 days
- on Zillow |
- 244 |
- 14 |
Zillow last checked: 7 hours ago
Listing updated: 19 hours ago
Listed by:
David Tucci DRE #01938839 559-824-8904,
Real Broker
Source: Fresno MLS,MLS#: 634706Originating MLS: Fresno MLS
Travel times
Tour with a buyer's agent
Tour with a buyer's agent
Open house
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 2
- Bathrooms: 2
Primary bedroom
- Area: 0
- Dimensions: 0 x 0
Bedroom 1
- Area: 0
- Dimensions: 0 x 0
Bedroom 2
- Area: 0
- Dimensions: 0 x 0
Bedroom 3
- Area: 0
- Dimensions: 0 x 0
Bedroom 4
- Area: 0
- Dimensions: 0 x 0
Dining room
- Area: 0
- Dimensions: 0 x 0
Family room
- Area: 0
- Dimensions: 0 x 0
Kitchen
- Area: 0
- Dimensions: 0 x 0
Living room
- Area: 0
- Dimensions: 0 x 0
Basement
- Area: 0
Heating
- Has Heating (Unspecified Type)
Cooling
- Central Air
Appliances
- Laundry: Inside
Features
- Flooring: Tile
- Has fireplace: No
Interior area
- Total structure area: 1,460
- Total interior livable area: 1,460 sqft
Property
Parking
- Total spaces: 2
- Parking features: Garage - Attached
- Attached garage spaces: 2
Features
- Levels: One
- Stories: 1
Lot
- Size: 3,920.4 Square Feet
- Features: Urban
Details
- Parcel number: 080242027000
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Residential, Single Family Residence
Materials
- Stucco
- Foundation: Concrete
- Roof: Tile
Condition
- Year built: 2021
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Public Utilities
Community & HOA
HOA
- Has HOA: Yes
- Amenities included: Pool, Spa/Hot Tub, Sauna, Clubhouse, Fitness Center, Green Area, Racquetball, Security, Playground
- HOA fee: $150 monthly
Location
- Region: Madera
Financial & listing details
- Price per square foot: $277/sqft
- Tax assessed value: $397,588
- Annual tax amount: $5,611
- Date on market: 7/31/2025
- Listing agreement: Exclusive Right To Sell
- Total actual rent: 0
- Loading
- Loading