Beautifull Spacious Upgraded Trumark Home - Desirable Davis Floor Plan - C Elevation located across from Park in Prestigious River Stone Master Plan Community.Enjoy amenities such as Club House , Parks , Pickleball Court , Dog Park and much more.Home is tastefully upgraded with Gourmet Kitchen , Formal Dinning , Butler Pantry plus Great room and Covered Patio for outdoor entertaining .Too many great features to list - Must See.Do not forget to ask for Seller Incentives.
New construction
$646,043
817 Discovery Rd S, Madera, CA 93636
5beds
4baths
3,243sqft
Residential, Single Family Residence
Built in ----
5,131 sqft lot
$645,800 Zestimate®
$199/sqft
$125/mo HOA
What's special
Gourmet kitchenButler pantryLocated across from parkGreat roomCovered patio
- 5 days
- on Zillow |
- 122 |
- 2 |
Zillow last checked: 7 hours ago
Listing updated: June 10, 2025 at 03:02pm
Listed by:
Shaminder Cheema DRE #01470153 559-314-0740,
Trumark Construction Services
Source: Fresno MLS,MLS#: 631887Originating MLS: Fresno MLS
Travel times
Schedule tour
Select your preferred tour type — either in-person or real-time video tour — then discuss available options with the builder representative you're connected with.
Select a date
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 4
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: Upper Level
Features
- Has fireplace: No
Interior area
- Total structure area: 3,243
- Total interior livable area: 3,243 sqft
Property
Parking
- Total spaces: 2
- Parking features: Garage - Attached
- Attached garage spaces: 2
Features
- Levels: Two
- Stories: 2
- Has private pool: Yes
- Pool features: Community, In Ground
- Has view: Yes
- View description: Park/Greenbelt
Lot
- Size: 5,131 sqft
- Features: Rural, Sprinklers In Front
Details
- Parcel number: NEW/UNDER CONSTRUCTION/NA
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Residential, Single Family Residence
Materials
- Stucco
- Foundation: Concrete
- Roof: Tile
Condition
- New construction: Yes
Details
- Builder name: Trumark Homes
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Public Utilities
Community & HOA
Community
- Subdivision: Artisan at Riverstone
HOA
- Has HOA: Yes
- Amenities included: Pool, Clubhouse, Fitness Center
- HOA fee: $125 monthly
Location
- Region: Madera
Financial & listing details
- Price per square foot: $199/sqft
- Date on market: 6/10/2025
- Listing agreement: Exclusive Right To Sell
- Total actual rent: 0
About the community
Located in the Park District at Riverstone resides one of our signature home collections, Artisan. These one- and two-story home collections range from 1,622 to 3,243 square feet and offer a variety of styles and features, earning their spot as some of our most popular designs. Riverstone is a beautiful master-planned community located just minutes outside of Fresno. Life here is as multi-dimensional as it gets, with walkable neighborhoods that connect to the many thoughtfully designed amenities including vibrant parks and trails, multiple clubhouses, farm and garden environments, and a spirited town center.
Source: Trumark Homes