- 4 beds
- 3 baths
- 2,876 sqft
- 10,925 sqft lot
- $521 per sqft
- – on site
Embark on a journey where innovation effortlessly intertwines timeless elegance, giving rise to spaces that inspire and enhance everyday living. Nestled within the exclusive gated River Oaks Estates, a newly crafted custom residence exceeds expectations. Marvel of engineering and design, spanning two levels, adorned with expansive 1304 sq ft wrap-around porch, the home harmoniously blends with its natural exterior surroundings while standing out as an interior showcase of contemporary sophistication. Lower floor unfolds as open-concept, featuring cutting-edge kitchen, Fisher & Paykel, ZLINE, and Cafe Advantium SmartHome appliances, finishes exuding character, an effortless and clean ambiance, while detail-driven plumbing fixtures accentuate understated luxury. Downstairs en suite, doubles as office with private entrance, seamlessly connects to impressive entertaining areas that extend to exterior. Ascend to the second level, discover the luxurious primary suite, boasting a soaking tub, zero-entry shower, walk-in closet, and captivating bedroom with balcony. Two additional bedrooms, and bathroom flawlessly marry elegance with relaxed comfort. The 722 sq ft preplumbed loft, for future use, adds versatility. This custom estate transcends the definition of a home.
Last checked:
As a licensed real estate brokerage, Estately has access to the same database professional Realtors use: the Multiple Listing Service (or MLS). That means we can display all the properties listed by other member brokerages of the local Association of Realtors—unless the seller has requested that the listing not be published or marketed online.
The MLS is widely considered to be the most authoritative, up-to-date, accurate, and complete source of real estate for-sale in the USA.
Estately updates this data as quickly as possible and shares as much information with our users as allowed by local rules. Estately can also email you updates when new homes come on the market that match your search, change price, or go under contract.
Checking…
•
Last updated Jun 17, 2025
•
MLS# 225073808 —
The Building
-
Year Built Details:New
-
Year Built Source:Builder
-
Remodeled Updated:Yes
-
Construction Materials:Frame, Wood
-
Construction Materials:#Collection(String)
-
Builder Name:Schwartz Design Group
-
Building Features:#Collection(String)
-
Architectural Style:#Collection(String)
-
Development Status:#Collection(String)
-
Structure Type:#Collection(String)
-
Subtype Description:#Collection(String)
-
Roof:Tile, Metal
-
Roof:#Collection(String)
-
Foundation Details:Raised
-
Foundation Details:#Collection(String)
-
Stories:2
-
Levels:Two
-
Levels:#Collection(String)
-
Upper Level:#Collection(String)
-
Main Level:#Collection(String)
-
Lower Level:#Collection(String)
-
Basement:#Collection(String)
-
Direction Faces:East
-
Exterior Features:Balcony
-
Exterior Features:#Collection(String)
-
Window Features:Dual Pane Full
-
Window Features:#Collection(String)
-
Patio And Porch Features:Front Porch, Back Porch, Wrap Around Porch
-
Patio And Porch Features:#Collection(String)
-
Accessibility Features:#Collection(String)
Interior
-
Interior Features:#Collection(String)
-
Kitchen Features:Breakfast Area, Pantry Cabinet, Quartz Counter, Island
-
Flooring:Tile, See Remarks
-
Flooring:#Collection(String)
-
Upper Level:Bedroom(s), Master Bedroom, Full Bath(s), Retreat
-
Main Level:Bedroom(s), Dining Room, Family Room, Master Bedroom, Full Bath(s), Retreat, Kitchen
-
Dining Room Features:Dining Bar, Space in Kitchen, Dining/Living Combo
-
Living Room Features:Great Room
-
Family Room Features:Great Room
-
Fireplaces Total:1
-
Fireplace Features:Insert, Living Room, Gas Starter
-
Fireplace Features:#Collection(String)
-
Laundry Features:Stacked Only, Ground Floor, Inside Area
-
Laundry Features:#Collection(String)
Room Dimensions
-
Living Area:2876.0
-
Living Area Source:Assessor Agent-Fill
Financial & Terms
-
Lease Type:Net
-
Lease Type:#Collection(String)
-
Lease Info:#Collection(String)
-
Lease Includes:#Collection(String)
-
Rent Includes:#Collection(String)
-
Tenant Pays:#Collection(String)
-
Owner Pays:#Collection(String)
-
Pets Allowed:#Collection(String)
Location
-
Directions:Scenic Drive East to Scenic Bend, turn Southeast to River Oak Subdivision, entrance at Penhurst Park.
The Property
-
Property Type:Residential
-
Property Subtype:Single Family Residence
-
Property Condition:New Construction
-
Property Condition:#Collection(String)
-
Parcel Number:067-024-037-000
-
Current Use:#Collection(String)
-
Possible Use:#Collection(String)
-
Zoning:R-1
-
Lot Features:Auto Sprinkler F&R, Cul-De-Sac, Private, Shape Irregular, Gated Community, Landscape Back, Landscape Front, Low Maintenance
-
Lot Features:#Collection(String)
-
Lot Size Acres:0.2508
-
Lot Size Square Feet:10925.0
-
Land Use:Residential
-
Lot Size Units:Acres
-
Lot Size Source:Builder
-
Land Lease:false
-
View:#Collection(String)
-
Vegetation:#Collection(String)
-
Irrigation Source:#Collection(String)
-
Fencing:Back Yard, Wood, Masonry, Other
-
Fencing:#Collection(String)
-
Horse:false
-
Horse Amenities:#Collection(String)
-
Crops:#Collection(String)
-
Soil:#Collection(String)
-
Land Use:#Collection(String)
-
Irrigation Source:None, See Remarks
-
Frontage Type:#Collection(String)
-
Road Surface Type:#Collection(String)
-
Road Frontage Type:#Collection(String)
-
Road Responsibility:#Collection(String)
-
Driveway Sidewalks:#Collection(String)
Listing Agent
- Contact info:
- No listing contact info available
Beds
-
Bedrooms Total:4
-
Master Bedroom Features:Balcony, Closet, Outside Access, Sitting Area
Baths
-
Total Baths:3
-
Full Baths:3
-
Master Bathroom Features:Closet, Shower Stall(s), Double Sinks, Soaking Tub, Stone, Walk-In Closet, Quartz, Window
The Listing
-
Virtual Tour URL:https://youtu.be/i5cyYluTaSE
-
Home Warranty:false
Heating & Cooling
-
Heating:Central, Fireplace Insert, Fireplace(s)
-
Heating:#Collection(String)
-
Cooling:Ceiling Fan(s), Central
-
Cooling:#Collection(String)
Utilities
-
Utilities:Public
-
Utilities:#Collection(String)
-
Electric:Other
-
Electric:#Collection(String)
-
Sewer:In & Connected, See Remarks
-
Sewer:#Collection(String)
-
Water Source:Meter on Site
-
Water Source:#Collection(String)
-
Green Energy Efficient:#Collection(String)
Appliances
-
Appliances:Built-In Freezer, Built-In Gas Oven, Built-In Gas Range, Built-In Refrigerator, Hood Over Range, Dishwasher, Disposal, Microwave, Self/Cont Clean Oven, Tankless Water Heater, Other
-
Appliances:#Collection(String)
Schools
-
Elementary School District:Modesto City
-
Middle Or Junior School District:Modesto City
-
High School District:Modesto City
The Community
-
Subdivision Name:Scenic Bend Estates
-
Community Features:#Collection(String)
-
Association:true
-
Association Fee:358
-
Association Fee Frequency:Monthly
-
Association Fee Includes:Management, Common Areas, Road, Maintenance Exterior
-
Association Mandatory:Yes
-
Association Amenities:Greenbelt
-
Association Amenities:#Collection(String)
-
Restrictions:See Remarks, Other
-
Spa:false
-
Spa Features:#Collection(String)
-
Pool Private:false
-
Pool Features:#Collection(String)
-
Driveway Sidewalks:Paved Driveway
-
Senior Community:false
Parking
-
Garage Spaces:3.0
-
Parking Type:#Collection(String)
-
Parking Access:#Collection(String)
-
Parking Features:24'+ Deep Garage, Attached, Restrictions, Garage Facing Side, Other
-
Parking Features:#Collection(String)
Extra Units
-
Unit 1 Type:#Collection(String)
-
Unit 2 Type:#Collection(String)
-
Unit 3 Type:#Collection(String)
-
Unit 4 Type:#Collection(String)
-
Other Units:#Collection(String)
Monthly cost estimate

Asking price
$1,500,000
Expense | Monthly cost |
---|---|
Mortgage
This calculator is intended for planning and education purposes only. It relies on assumptions and information provided by you regarding your goals, expectations and financial situation, and should not be used as your sole source of information. The output of the tool is not a loan offer or solicitation, nor is it financial or legal advice. |
$8,032
|
Taxes | N/A |
Insurance | $412 |
HOA fees | $358 |
Utilities | N/A |
Total | $8,802/mo.* |
*This is an estimate |
Walk Score®
Provided by WalkScore® Inc.
Walk Score is the most well-known measure of walkability for any address. It is based on the distance to a variety of nearby services and pedestrian friendliness. Walk Scores range from 0 (Car-Dependent) to 100 (Walker’s Paradise).
Bike Score®
Provided by WalkScore® Inc.
Bike Score evaluates a location's bikeability. It is calculated by measuring bike infrastructure, hills, destinations and road connectivity, and the number of bike commuters. Bike Scores range from 0 (Somewhat Bikeable) to 100 (Biker’s Paradise).
Transit Score®
Provided by WalkScore® Inc.
Transit Score measures a location's access to public transit. It is based on nearby transit routes frequency, type of route (bus, rail, etc.), and distance to the nearest stop on the route. Transit Scores range from 0 (Minimal Transit) to 100 (Rider’s Paradise).
Soundscore™
Provided by HowLoud
Soundscore is an overall score that accounts for traffic, airport activity, and local sources. A Soundscore rating is a number between 50 (very loud) and 100 (very quiet).
Sale history
Date | Event | Source | Price | % Change |
---|---|---|---|---|
6/11/25
Jun 11, 2025
|
Listed / Active | METROLIST | $1,500,000 |