- 5 beds
- 4 baths
- 2,306 sqft
- 9,980 sqft lot
- $268 per sqft
- 1974 build
- – on site
More homes
STUNNING, This Ultra-Modern, SMART, Single Level Home on a quiet cul-de-sac features 5 bedrooms, 4 full bathrooms (two of which are ensuite)The primary suite features spacious his & her closets, extra storage and a extraordinary ensuite boasting a Penhaglion 57 Swedish Slipper cast iron enamel Clawfoot Tub, LED backlit mirror, dual sinks and soft-close drawers. The interior floors throughout the house are glazed porcelain tile, giving it a resort feel. The stunning kitchen boasts a large Quartz kitchen island (63X129.5), marble backsplash with gold & silver metal inlay, Kraftmaid ultra modern soft-close cabinets, farmhouse sink including a rollup dish rack, storage and more! A full sized pool with jacuzzi, waterfall feature and Acapulco bench, 3 piece pool house, gazebo, RV port, and large shed. The pool house is perfect for hosting parties, as it provides access to a full bathroom outside and facilitates hot/cold showers after a dip in the pool. This home provides wonderful living experiences all year round. Sylvan school district, and close proximity to Riverbank Costco and shopping! New roof 2017, renovation 2020-2022. This smart home is truly one of a kind with many additional amenities! Call for a print out of upgrades and A private showing!SOLAR!
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 Jul 12, 2025
•
MLS# 225069535 —
The Building
-
Year Built:1974
-
Year Built Source:Assessor Auto-Fill
-
Remodeled Updated:Yes
-
Construction Materials:Stucco
-
Construction Materials:#Collection(String)
-
Building Features:#Collection(String)
-
Architectural Style:Ranch
-
Architectural Style:#Collection(String)
-
Development Status:#Collection(String)
-
Structure Type:#Collection(String)
-
Subtype Description:#Collection(String)
-
Roof:Composition
-
Roof:#Collection(String)
-
Foundation Details:Slab
-
Foundation Details:#Collection(String)
-
Stories:1
-
Levels:#Collection(String)
-
Upper Level:#Collection(String)
-
Main Level:#Collection(String)
-
Lower Level:#Collection(String)
-
Basement:#Collection(String)
-
Exterior Features:#Collection(String)
-
Window Features:Dual Pane Full
-
Window Features:#Collection(String)
-
Patio And Porch Features:#Collection(String)
-
Accessibility Features:#Collection(String)
Interior
-
Interior Features:#Collection(String)
-
Kitchen Features:Quartz Counter, Island, Kitchen/Family Combo
-
Flooring:See Remarks
-
Flooring:#Collection(String)
-
Main Level:Bedroom(s), Dining Room, Family Room, Master Bedroom, Full Bath(s), Garage, Kitchen
-
Dining Room Features:Formal Area
-
Living Room Features:Great Room
-
Fireplace Features:#Collection(String)
-
Laundry Features:Cabinets, Electric, Gas Hook-Up, Inside Room
-
Laundry Features:#Collection(String)
Room Dimensions
-
Living Area:2306.0
-
Living Area Source:Architect
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:Keller to Coffee Villa to Maryanna CT
The Property
-
Property Type:Residential
-
Property Subtype:Single Family Residence
-
Property Condition:Updated/Remodeled
-
Property Condition:#Collection(String)
-
Parcel Number:065-004-020-000
-
Current Use:#Collection(String)
-
Possible Use:#Collection(String)
-
Zoning:R-1
-
Lot Features:Auto Sprinkler F&R, Cul-De-Sac
-
Lot Features:#Collection(String)
-
Lot Size Acres:0.2291
-
Lot Size Square Feet:9980.0
-
Lot Size Units:Acres
-
Lot Size Source:Assessor Auto-Fill
-
Land Lease:false
-
View:#Collection(String)
-
Vegetation:#Collection(String)
-
Irrigation Source:#Collection(String)
-
Fencing:#Collection(String)
-
Horse:false
-
Horse Amenities:#Collection(String)
-
Crops:#Collection(String)
-
Other Equipment:Water Cond Equipment Owned, Water Filter System
-
Soil:#Collection(String)
-
Other Structures:Gazebo, Shed(s)
-
Land Use:#Collection(String)
-
Irrigation Source:None
-
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:5
-
Master Bedroom Features:Closet, Outside Access
Baths
-
Total Baths:4
-
Full Baths:4
-
Master Bathroom Features:Shower Stall(s), Double Sinks, Soaking Tub, Marble, Quartz
The Listing
-
Home Warranty:false
Heating & Cooling
-
Heating:Central
-
Heating:#Collection(String)
-
Cooling:Ceiling Fan(s), Central
-
Cooling:#Collection(String)
Utilities
-
Utilities:Public
-
Utilities:#Collection(String)
-
Electric:220 Volts in Laundry, Passive Solar, See Remarks
-
Electric:#Collection(String)
-
Sewer:Public Sewer
-
Sewer:#Collection(String)
-
Water Source:Public
-
Water Source:#Collection(String)
-
Green Energy Efficient:#Collection(String)
Appliances
-
Appliances:Hood Over Range, Dishwasher, Disposal
-
Appliances:#Collection(String)
Schools
-
Elementary School District:Sylvan Union
-
Middle Or Junior School District:Sylvan Union
-
High School District:Modesto City
The Community
-
Subdivision Name:Coffee Villa
-
Community Features:#Collection(String)
-
Association:false
-
Association Amenities:#Collection(String)
-
Spa:true
-
Spa Features:Spa/Hot Tub Built-In
-
Spa Features:#Collection(String)
-
Pool Private:true
-
Pool Features:On Lot, Pool/Spa Combo, Gunite Construction
-
Pool Features:#Collection(String)
-
Senior Community:false
Parking
-
Garage Spaces:2.0
-
Parking Type:#Collection(String)
-
Parking Access:#Collection(String)
-
Parking Features:RV Access, RV Storage, Garage Door Opener, Garage Facing Front
-
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)
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).
Air Pollution Index
Provided by ClearlyEnergy
The air pollution index is calculated by county or urban area using the past three years data. The index ranks the county or urban area on a scale of 0 (best) - 100 (worst) across the United Sates.
Sale history
Date | Event | Source | Price | % Change |
---|---|---|---|---|
7/12/25
Jul 12, 2025
|
Sold | METROLIST | $620,000 | -4.6% |
6/14/25
Jun 14, 2025
|
Pending | METROLIST | $650,000 | |
6/3/25
Jun 3, 2025
|
Listed / Active | METROLIST | $650,000 |