- 4 beds
- 4 baths
- 3,153 sqft
- ~3/4 acre lot
- $269 per sqft
- 1988 build
- – on site
Unique and Rare opportunity to own a fully remolded home that backs into East Laloma Park. This beauty of a home consists of 4 bedrooms, 3.5 baths, 2 car garage, 3,153 sq.ft., with 0.64-acres, pool, hot-tub, and fruit filled orchard. Step into a home that feels like a five-star vacation every day. This stunning Talavera-inspired retreat blends luxurious living with vibrant artisan charm. Hardwood floors flow throughout, leading to a showstopping 6-ft illuminated quartzite island anchoring the chef's kitchen complete with pro-grade appliances, oversized fridge, pot filler, and ample prep space. Gather in the 1,000 sq ft Talavera-tiled entertainment room featuring a pizza oven, indoor BBQ, copper hood, and custom tiled bar and buffet for unforgettable celebrations. Cozy up by the living room fireplace or retreat to the primary suite with its own fireplace and spa- style bath showcasing a dual-head rain shower. Step outside to a resort-style oasis with a cascading waterfall pool, tranquil fountain, outdoor fireplace, and full kitchen for al fresco dining. Mature citrus and stone fruit trees fill the orchard, offering fresh seasonal harvests year- round. A rare fusion of color, craftsmanship, and comfort, this home is a dream retreat designed for inspired living. MUST SEE!
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 26, 2025
•
MLS# 225084040 —
Upcoming Open Houses
-
Saturday, 6/28
11am-1pm -
Sunday, 6/29
11am-1pm
The Building
-
Year Built:1988
-
Year Built Source:Assessor Auto-Fill
-
Remodeled Updated:Yes
-
Construction Materials:Stucco, Wood
-
Construction Materials:#Collection(String)
-
Building Features:#Collection(String)
-
Architectural Style:Traditional
-
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:2
-
Levels:#Collection(String)
-
Upper Level:#Collection(String)
-
Main Level:#Collection(String)
-
Lower Level:#Collection(String)
-
Basement:#Collection(String)
-
Direction Faces:Southeast
-
Exterior Features:BBQ Built-In, Kitchen
-
Exterior Features:#Collection(String)
-
Window Features:Dual Pane Full, Window Screens
-
Window Features:#Collection(String)
-
Patio And Porch Features:Covered Patio
-
Patio And Porch Features:#Collection(String)
-
Accessibility Features:#Collection(String)
-
Green Energy Efficient:Windows
Interior
-
Interior Features:#Collection(String)
-
Kitchen Features:Breakfast Area, Pantry Cabinet, Quartz Counter, Granite Counter, Island
-
Flooring:Tile, Wood
-
Flooring:#Collection(String)
-
Upper Level:Bedroom(s), Master Bedroom, Full Bath(s)
-
Main Level:Dining Room, Family Room, Full Bath(s), Partial Bath(s), Garage, Retreat, Kitchen, Street Entrance
-
Dining Room Features:Dining Bar, Formal Area
-
Living Room Features:Cathedral/Vaulted
-
Fireplaces Total:2
-
Fireplace Features:Master Bedroom, Electric, Family Room, Wood Burning, Gas Piped
-
Fireplace Features:#Collection(String)
-
Laundry Features:Cabinets, Inside Room
-
Laundry Features:#Collection(String)
Room Dimensions
-
Living Area:3153.0
-
Living Area Source:Assessor Auto-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:From El Vista go West on Edgebrook to the Property.
The Property
-
Property Type:Residential
-
Property Subtype:Single Family Residence
-
Property Condition:Updated/Remodeled
-
Property Condition:#Collection(String)
-
Parcel Number:034-028-002-000
-
Current Use:#Collection(String)
-
Possible Use:#Collection(String)
-
Zoning:R1
-
Lot Features:Auto Sprinkler F&R, Curb(s)/Gutter(s), Landscape Back, Landscape Front
-
Lot Features:#Collection(String)
-
Lot Size Acres:0.6478
-
Lot Size Square Feet:28218.0
-
Lot Size Units:Acres
-
Lot Size Source:Assessor Auto-Fill
-
Land Lease:false
-
View:#Collection(String)
-
View:Park
-
Topography:Lot Sloped,Trees Many,Lot Sloped,Trees Many
-
Vegetation:#Collection(String)
-
Irrigation Source:#Collection(String)
-
Fencing:Back Yard, Chain Link, Fenced, Wood
-
Fencing:#Collection(String)
-
Horse:false
-
Horse Amenities:#Collection(String)
-
Crops:#Collection(String)
-
Other Equipment:Water Cond Equipment Owned
-
Soil:#Collection(String)
-
Other Structures:Workshop
-
Land Use:#Collection(String)
-
Irrigation Source:Public District
-
Frontage Type:#Collection(String)
-
Road Surface Type:#Collection(String)
-
Road Surface Type:Asphalt
-
Road Frontage Type:#Collection(String)
-
Road Responsibility:#Collection(String)
-
Road Responsibility:Public Maintained Road
-
Driveway Sidewalks:#Collection(String)
Listing Agent
- Contact info:
- No listing contact info available
Beds
-
Bedrooms Total:4
-
Master Bedroom Features:Walk-In Closet
Baths
-
Total Baths:4
-
Full Baths:3
-
Partial Baths:1
-
Master Bathroom Features:Double Sinks, Tile, Marble, Tub, Multiple Shower Heads, Window
The Listing
-
Home Warranty:false
Heating & Cooling
-
Heating:Central, Fireplace(s)
-
Heating:#Collection(String)
-
Cooling:Ceiling Fan(s), Central, MultiUnits, MultiZone
-
Cooling:#Collection(String)
Utilities
-
Utilities:Cable Available, Electric, Underground Utilities, Internet Available, Natural Gas Connected
-
Utilities:#Collection(String)
-
Electric:220 Volts in Kitchen, 220 Volts in Laundry
-
Electric:#Collection(String)
-
Sewer:In & Connected
-
Sewer:#Collection(String)
-
Water Source:Public
-
Water Source:#Collection(String)
-
Green Energy Efficient:#Collection(String)
Appliances
-
Appliances:Built-In BBQ, Built-In Electric Oven, Built-In Gas Range, Gas Water Heater, Built-In Refrigerator, Hood Over Range, Dishwasher, Disposal, Microwave, Double Oven, Plumbed For Ice Maker, Self/Cont Clean Oven, Wine Refrigerator
-
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:Parks Oaks
-
Community Features:#Collection(String)
-
Association:false
-
Association Amenities:#Collection(String)
-
Spa:true
-
Spa Features:Spa/Hot Tub Personal
-
Spa Features:#Collection(String)
-
Pool Private:true
-
Pool Features:Built-In, On Lot, Pool Sweep, Gas Heat, Gunite Construction
-
Pool Features:#Collection(String)
-
Driveway Sidewalks:Sidewalk/Curb/Gutter
-
Senior Community:false
Parking
-
Garage Spaces:2.0
-
Parking Type:#Collection(String)
-
Parking Access:#Collection(String)
-
Parking Features:Attached, RV Possible, 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)
Monthly cost estimate

Asking price
$849,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. |
$4,546
|
Taxes | N/A |
Insurance | $233 |
Utilities | $271 See report |
Total | $5,050/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).
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 |
---|---|---|---|---|
6/24/25
Jun 24, 2025
|
Listed / Active | METROLIST | $849,000 | 239.6% (7.9% / YR) |
4/13/95
Apr 13, 1995
|
Sold | Public Record | $250,000 |