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/226072973/2533-Burlwood-Dr/Modesto/https://www.londonproperties.com/images/camerashy.pngLondon Properties Modesto Real Estate | 2533 Burlwood Dr
Great opportunity to own a home in this neighborhood! Most recent improvement - HVAC updated in 2024. Great floor plan - Built in 1986 with just over 1900 square feet, 4 bedrooms and 3 full bathrooms. The primary bedroom is downstairs with slider out to the back yard, plus there's another downstairs bedroom. Upstairs you will find 2 more bedrooms, full bathroom and a huge loft. The great room has laminate flooring, fireplace and is open to the dining area/kitchen. The backyard has a large covered patio, large side yard could be a great dog run area or place to put a shed. The pool has not been filled with water for many years - unknown if its operable. With some updating/improvements and some TLC this home can shine! Orchard Elementary school close by, also Ace Hardware, Starbucks and other shopping centers.
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Detached
Year Built
1986
Year Built Source
Assessor Auto-Fill
Remodeled/Updated
No
Stories
2
Home Warranty
No
Directions to Property
Oakdale Road to Merle, turn North onto Walnut Tree then right onto Burlwood.
Cross Street
Walnut Tree
County
Stanislaus
Special Listing Conditions
Trust
Main Level
Bedroom(s), Living Room, Primary Bedroom, Full Bath(s), Garage, Kitchen
Construction Materials
Stucco, Wood
Foundation
Slab
Roof
Composition
Heating
Central
Cooling
Ceiling Fan(s), Central
Laundry Features
In Garage
Window Features
Dual Pane Full
Interior Features
Cathedral Ceiling
Full Bathrooms
2
Bath Features
Double Sinks, Tub w/Shower Over
# of Fireplaces
1
Fireplace Features
Living Room
Flooring
Carpet, Laminate, Tile
Appliances
Free Standing Refrigerator, Hood Over Range, Free Standing Electric Range
Room Type
Loft, Great Room
Kitchen Features
Pantry Closet, Kitchen/Family Combo, Tile Counter
Dining Room Features
Dining Bar, Dining/Living Combo
Living Room Features
Other
Primary Bedroom Features
Closet, Ground Floor, Outside Access
Primary Bathroom Features
Tub w/Shower Over
Upper Level
Bedroom(s), Loft, Full Bath(s)
Patio And Porch Features
Covered Patio
Pool
Yes
Pool Features
See Remarks
Spa
No
ADU/2nd Unit
No
Utilities
Public, Sewer In & Connected
Electric
220 Volts
Irrigation
None
Water Source
Meter on Site
Sewer
Sewer in Street
Parking Features
Attached
Garage Spaces
2.00
Lot Features
Curb(s)/Gutter(s), Shape Regular
APN
077 003 045 000
Driveway/Sidewalks
Sidewalk/Curb/Gutter
Horse Property
No
Zoning Description
res
List AOR
MetroList Services, Inc.
Association
No
Senior Community
No
School District (County)
Stanislaus
Elementary School District
Sylvan Union
Middle or Junior School District
Sylvan Union
Senior High School District
Modesto City
Census Tract
9.11
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 455050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 502950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1678 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2178 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` = 1718929 OR `props-main`.`id` = 1725322 OR `props-main`.`id` = 1725741 OR `props-main`.`id` = 1734712 OR `props-main`.`id` = 1726885 OR `props-main`.`id` = 1725715 OR `props-main`.`id` = 1722882 OR `props-main`.`id` = 1721924 OR `props-main`.`id` = 1728140 OR `props-main`.`id` = 1698031 OR `props-main`.`id` = 1728303 OR `props-main`.`id` = 1723228 OR `props-main`.`id` = 1729154 OR `props-main`.`id` = 1734251 OR `props-main`.`id` = 1737123 OR `props-main`.`id` = 1722133 OR `props-main`.`id` = 1724813 OR `props-main`.`id` = 1736602 OR `props-main`.`id` = 1720806 OR `props-main`.`id` = 1736600 OR `props-main`.`id` = 1723565 OR `props-main`.`id` = 1723651 OR `props-main`.`id` = 1680147 OR `props-main`.`id` = 1736806 OR `props-main`.`id` = 1713035 OR `props-main`.`id` = 1726844 OR `props-main`.`id` = 1732004 OR `props-main`.`id` = 1720915 OR `props-main`.`id` = 1736188 OR `props-main`.`id` = 1728433 OR `props-main`.`id` = 1726935 OR `props-main`.`id` = 1726824 OR `props-main`.`id` = 1726500 OR `props-main`.`id` = 1713425 OR `props-main`.`id` = 1724506 OR `props-main`.`id` = 1719270 OR `props-main`.`id` = 1698444 OR `props-main`.`id` = 1734601 OR `props-main`.`id` = 1729808 OR `props-main`.`id` = 1713241 OR `props-main`.`id` = 1714510 OR `props-main`.`id` = 1728802 OR `props-main`.`id` = 1726644 OR `props-main`.`id` = 1728785 OR `props-main`.`id` = 1726436 OR `props-main`.`id` = 1735397 OR `props-main`.`id` = 1726982 OR `props-main`.`id` = 1727300 OR `props-main`.`id` = 1731022 OR `props-main`.`id` = 1712373 OR `props-main`.`id` = 1737007 OR `props-main`.`id` = 1728414 OR `props-main`.`id` = 1728330 OR `props-main`.`id` = 1726442 OR `props-main`.`id` = 1736668 OR `props-main`.`id` = 1728990 OR `props-main`.`id` = 1733618 OR `props-main`.`id` = 1725762 OR `props-main`.`id` = 1718161 OR `props-main`.`id` = 1730684 OR `props-main`.`id` = 1736178 OR `props-main`.`id` = 1730997 OR `props-main`.`id` = 1724948 OR `props-main`.`id` = 1729286 OR `props-main`.`id` = 1728198 OR `props-main`.`id` = 1733610 OR `props-main`.`id` = 1737270 OR `props-main`.`id` = 1728207 OR `props-main`.`id` = 1727176 OR `props-main`.`id` = 1725877 OR `props-main`.`id` = 1728177 OR `props-main`.`id` = 1714546 OR `props-main`.`id` = 1733579 OR `props-main`.`id` = 1715732 OR `props-main`.`id` = 1732003 OR `props-main`.`id` = 1725328 OR `props-main`.`id` = 1725327 OR `props-main`.`id` = 1725326 OR `props-main`.`id` = 1722553 OR `props-main`.`id` = 1725329 OR `props-main`.`id` = 1732923 OR `props-main`.`id` = 1736355 OR `props-main`.`id` = 1736599 OR `props-main`.`id` = 1723784 OR `props-main`.`id` = 1733605 OR `props-main`.`id` = 1715680 OR `props-main`.`id` = 1733600 OR `props-main`.`id` = 1727079 OR `props-main`.`id` = 1728232 OR `props-main`.`id` = 1729210 OR `props-main`.`id` = 1728179 OR `props-main`.`id` = 1723462 OR `props-main`.`id` = 1720807 OR `props-main`.`id` = 1728945 OR `props-main`.`id` = 1735917 OR `props-main`.`id` = 1733603 OR `props-main`.`id` = 1727945 OR `props-main`.`id` = 1727836 OR `props-main`.`id` = 1734260 OR `props-main`.`id` = 1726869 OR `props-main`.`id` = 1726642 OR `props-main`.`id` = 1728205 OR `props-main`.`id` = 1708028 OR `props-main`.`id` = 1735300 OR `props-main`.`id` = 1715659 OR `props-main`.`id` = 1727422 OR `props-main`.`id` = 1720853 OR `props-main`.`id` = 1721984 OR `props-main`.`id` = 1721978 OR `props-main`.`id` = 1727944 OR `props-main`.`id` = 1732931 OR `props-main`.`id` = 1730671 OR `props-main`.`id` = 1725189 OR `props-main`.`id` = 1723461 OR `props-main`.`id` = 1707870 OR `props-main`.`id` = 1722859 OR `props-main`.`id` = 1716441 OR `props-main`.`id` = 1735306 OR `props-main`.`id` = 1728794 OR `props-main`.`id` = 1721328 OR `props-main`.`id` = 1721459 OR `props-main`.`id` = 1725186 OR `props-main`.`id` = 1728139 OR `props-main`.`id` = 1735305 OR `props-main`.`id` = 1723887 OR `props-main`.`id` = 1733143 OR `props-main`.`id` = 1710082 OR `props-main`.`id` = 1731206)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226072973' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-13' 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 Peggy Halsor, Century 21 Select Real Estate 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.
