Provide a name for your search and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Search
Please log in or create an account.
Save Property
Provide a name for your property and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Property
Please log in or create an account.
The ULTIMATE Guide To Buying Your Home!
Get Your FREE Copy Share a few contact details and we will send you the guide to your inbox.
THANK YOU!
Check your inbox for the Buyer's Guide.
Get More Info
Please provide the following information and one of our customer service representatives will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.londonproperties.com/property/link/metrolist/226021174/1900-Berryessa-Dr/Modesto/https://www.londonproperties.com/images/props/metrolist/full/226021174.jpgLondon Properties Modesto Real Estate | 1900 Berryessa Dr
Nicely updated property featuring a bright and open floor plan designed for comfortable living and effortless entertaining. The spacious open kitchen offers tile countertops, abundant cabinetry, and seamless flow into the main living areas perfect for gatherings and everyday life. Enjoy the fresh feel of new interior paint and new flooring throughout, creating a modern and move-in ready atmosphere. High ceilings enhance the sense of space and natural light, while the cozy fireplace adds warmth and charm to the living area. The generously sized primary suite includes a walk-in closet, providing ample storage and comfort. With its open layout, stylish updates, and inviting features, this home delivers both functionality and appeal.
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Detached, Tract
Property Condition
Updated/Remodeled, Original
Year Built
1990
Year Built Source
Assessor Agent-Fill
Remodeled/Updated
Yes
Remodeled/Updated Desc
Other-Rmks 0-5YR
Stories
2
Levels
Two
Pets Allowed
Cats OK, Dogs OK
Home Warranty
No
Directions to Property
GPS
Cross Street
Shasta
County
Stanislaus
Special Listing Conditions
None
Main Level
Family Room, Partial Bath(s), Garage, Kitchen, Street Entrance
Architectural Style
Contemporary, Spanish
Construction Materials
Stucco, Frame
Foundation
Slab
Roof
Tile
Heating
Central, Fireplace(s), Natural Gas
Cooling
Ceiling Fan(s)
Laundry Features
Cabinets, Gas Hook-Up, Inside Room
Window Features
Dual Pane Full
Property Faces
North
Interior Features
Cathedral Ceiling
Full Bathrooms
2
Half Bathrooms
1
Bath Features
Tub, Tub w/Shower Over
# of Fireplaces
1
Fireplace Features
Living Room, Family Room, Wood Burning, Gas Piped
Flooring
Carpet, Wood
Appliances
Gas Cook Top, Gas Water Heater, Hood Over Range, Dishwasher, Disposal, Free Standing Gas Oven
Room Type
Primary Bathroom, Baths Other, Primary Bedroom, Dining Room, Family Room, Kitchen, Laundry, Living Room
Kitchen Features
Breakfast Area, Pantry Closet, Tile Counter
Dining Room Features
Breakfast Nook, Space in Kitchen
Living Room Features
Great Room
Primary Bedroom Features
Walk-In Closet, Sitting Area
Primary Bathroom Features
Shower Stall(s), Double Sinks, Tub, Window
Upper Level
Primary Bedroom, Full Bath(s)
Patio And Porch Features
Covered Patio
Pool
No
Spa
No
ADU/2nd Unit
No
Utilities
Cable Available, Public, Electric, Natural Gas Connected
Electric
220 Volts in Laundry
Irrigation
Meter on Site, None
Water Source
Meter on Site
Sewer
Public Sewer
Parking Features
Attached, Garage Door Opener, Garage Facing Front
Garage Spaces
2.00
Lot Features
Auto Sprinkler F&R, Auto Sprinkler Front, Manual Sprinkler Rear, Low Maintenance
APN
081 049 081 000
Land Use
Residential
Topography
Level
Driveway/Sidewalks
Sidewalk/Curb/Gutter
Fencing
Back Yard, Wood
Horse Property
No
Road Surface Type
Paved
Road Responsibility
Public Maintained Road
Zoning Description
R1
Subdivision
Mountain View Terrace
List AOR
MetroList Services, Inc.
Association
No
Senior Community
No
School District (County)
Stanislaus
Elementary School District
Modesto City
Middle or Junior School District
Modesto City
Senior High School District
Modesto City
Census Tract
6.02
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 451250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 498750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1777 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2277 AND ((`props-main`.`PropertyType` = 'Residential' AND (
`props-main`.`PropertySubtype1` = '1 House on Lot' OR `props-main`.`PropertySubtype2` = '1 House on Lot' OR `props-main`.`PropertySubtype3` = '1 House on Lot' OR
`props-main`.`PropertySubtype1` = 'Cabin' OR `props-main`.`PropertySubtype2` = 'Cabin' OR `props-main`.`PropertySubtype3` = 'Cabin' OR
`props-main`.`PropertySubtype1` = 'House on Lot' OR `props-main`.`PropertySubtype2` = 'House on Lot' OR `props-main`.`PropertySubtype3` = 'House on Lot' OR
`props-main`.`PropertySubtype1` = 'Own Your Own' OR `props-main`.`PropertySubtype2` = 'Own Your Own' OR `props-main`.`PropertySubtype3` = 'Own Your Own' OR
`props-main`.`PropertySubtype1` = 'Rural Residence' OR `props-main`.`PropertySubtype2` = 'Rural Residence' OR `props-main`.`PropertySubtype3` = 'Rural Residence' OR
`props-main`.`PropertySubtype1` = 'Rural/Residence' OR `props-main`.`PropertySubtype2` = 'Rural/Residence' OR `props-main`.`PropertySubtype3` = 'Rural/Residence' OR
`props-main`.`PropertySubtype1` LIKE '%fam%' OR `props-main`.`PropertySubtype2` LIKE '%fam%' OR `props-main`.`PropertySubtype3` LIKE '%fam%'))) AND ((`props-main`.`id` = 1703092 OR `props-main`.`id` = 1711786 OR `props-main`.`id` = 1709553 OR `props-main`.`id` = 1706715 OR `props-main`.`id` = 1697625 OR `props-main`.`id` = 1709770 OR `props-main`.`id` = 1706663 OR `props-main`.`id` = 1702599 OR `props-main`.`id` = 1711670 OR `props-main`.`id` = 1712392 OR `props-main`.`id` = 1704429 OR `props-main`.`id` = 1712470 OR `props-main`.`id` = 1711783 OR `props-main`.`id` = 1711784 OR `props-main`.`id` = 1711785 OR `props-main`.`id` = 1711903 OR `props-main`.`id` = 1711307 OR `props-main`.`id` = 1712484 OR `props-main`.`id` = 1703306 OR `props-main`.`id` = 1712474 OR `props-main`.`id` = 1711111 OR `props-main`.`id` = 1695792 OR `props-main`.`id` = 1701832 OR `props-main`.`id` = 1684215 OR `props-main`.`id` = 1712162 OR `props-main`.`id` = 1710068 OR `props-main`.`id` = 1703059 OR `props-main`.`id` = 1712248 OR `props-main`.`id` = 1701740 OR `props-main`.`id` = 1711323 OR `props-main`.`id` = 1697884 OR `props-main`.`id` = 1697394 OR `props-main`.`id` = 1701906 OR `props-main`.`id` = 1710097 OR `props-main`.`id` = 1705434 OR `props-main`.`id` = 1711940 OR `props-main`.`id` = 1702533 OR `props-main`.`id` = 1686383 OR `props-main`.`id` = 1685007 OR `props-main`.`id` = 1712044 OR `props-main`.`id` = 1704339 OR `props-main`.`id` = 1712465)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226021174' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-02-27' OR `props-main`.`ExpiredDate` IS NULL OR TRIM(`props-main`.`ExpiredDate`) = '') AND `props-main`.`Status` != 'Unapproved' AND (`props-main`.`DupeOf` IS NULL OR TRIM(`props-main`.`DupeOf`) = '') AND `props-main`.`Delayed` = 0 GROUP BY `props-main`.`id` ORDER BY RAND();
0
Courtesy of Garrett Smith, Realty ONE Group Zoom IDX provided by Reliance Marketing
The data relating to real estate for sale on this web site comes in part from the Internet Data eXchange (IDX) of the Multiple Listing Service. Real estate listings are marked with the IDX logo and detailed information about them includes the name of the listing broker and the name of the listing agent. The information being provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumer may be interested in purchasing. Information herein deemed reliable but not guaranteed, representations are approximate, individual verification recommended.
