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/226055220/748-Codington-Way/Modesto/https://www.londonproperties.com/images/props/metrolist/full/226055220.jpgLondon Properties Modesto Real Estate | 748 Codington Way
Welcome to 748 Condington Way located in the Dry Creek Meadows area. This 2 story, 2318 square foot single family home has 5 bedrooms and 3 bathrooms, with tile flooring throughout the lower lever of the home, and Laminate flooring on the second floor. Large Living and Dining room area for entertaining guests. Step down from kitchen into a cozy family room with brick fire place and extra counter space with cabinets. There is one bedroom and bathroom with double sinks, and a laundry room with cabinets located on the first floor. Climb up the stairs to find Primary bedroom with spacious primary bath that features a large tub, separate shower stall, double sinks and closet, 3 other bedrooms and another bathroom with double sinks. A beautiful landscaped front yard with large driveway and a 3 car garage. Spacious back yard with covered patio for a table and seating area to enjoy, and a shed for storage. Located near Johansen High School, resturants, shopping and more!
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Attached
Year Built
1991
Year Built Source
Assessor Auto-Fill
Remodeled/Updated
No
Stories
2
Levels
Two
Home Warranty
No
Directions to Property
Creekwood Dr, to Leavenworth, to Waddell Way, to Codington Way.
Cross Street
Waddel Way
County
Stanislaus
Special Listing Conditions
Notice Of Default
Main Level
Living Room, Dining Room, Family Room, Full Bath(s), Garage, Kitchen
Construction Materials
Wood
Foundation
Slab
Roof
Composition
Heating
Central, Fireplace(s)
Cooling
Ceiling Fan(s), Central
Laundry Features
Gas Hook-Up, Hookups Only, Inside Area, Inside Room
Other Structures
Shed(s), Storage
Interior Features
Cathedral Ceiling
Full Bathrooms
3
Bath Features
Double Sinks, Granite, Tile, Tub w/Shower Over, Window
# of Fireplaces
1
Fireplace Features
Brick, Family Room
Flooring
Carpet, Tile, Wood
Appliances
Ice Maker, Dishwasher, Disposal, Microwave, Free Standing Electric Oven
Auto Sprinkler F&R, Landscape Back, Landscape Front
APN
079 006 011 000
Driveway/Sidewalks
Paved Driveway, Paved Sidewalk
Fencing
Back Yard, Wood
Horse Property
No
Road Surface Type
Asphalt
Road Responsibility
Public Maintained Road
Zoning Description
R1
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
20.06
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 493050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 544950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2068 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2568 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` = 1718728 OR `props-main`.`id` = 1724225 OR `props-main`.`id` = 1724142 OR `props-main`.`id` = 1714418 OR `props-main`.`id` = 1698929 OR `props-main`.`id` = 1723662 OR `props-main`.`id` = 1722224 OR `props-main`.`id` = 1706147 OR `props-main`.`id` = 1709971 OR `props-main`.`id` = 1721078 OR `props-main`.`id` = 1722030 OR `props-main`.`id` = 1719465 OR `props-main`.`id` = 1718929 OR `props-main`.`id` = 1723420 OR `props-main`.`id` = 1719395 OR `props-main`.`id` = 1724872 OR `props-main`.`id` = 1724257 OR `props-main`.`id` = 1723696 OR `props-main`.`id` = 1722490 OR `props-main`.`id` = 1712540 OR `props-main`.`id` = 1724231 OR `props-main`.`id` = 1721657 OR `props-main`.`id` = 1721924 OR `props-main`.`id` = 1708338 OR `props-main`.`id` = 1725074 OR `props-main`.`id` = 1724813 OR `props-main`.`id` = 1717056 OR `props-main`.`id` = 1717037 OR `props-main`.`id` = 1720806 OR `props-main`.`id` = 1680147 OR `props-main`.`id` = 1720915 OR `props-main`.`id` = 1711309 OR `props-main`.`id` = 1697604 OR `props-main`.`id` = 1713425 OR `props-main`.`id` = 1724506 OR `props-main`.`id` = 1718308 OR `props-main`.`id` = 1719270 OR `props-main`.`id` = 1698444 OR `props-main`.`id` = 1718130 OR `props-main`.`id` = 1713241 OR `props-main`.`id` = 1721996 OR `props-main`.`id` = 1689340 OR `props-main`.`id` = 1708424 OR `props-main`.`id` = 1709273 OR `props-main`.`id` = 1714780 OR `props-main`.`id` = 1724718 OR `props-main`.`id` = 1717922 OR `props-main`.`id` = 1722240 OR `props-main`.`id` = 1708497 OR `props-main`.`id` = 1718726 OR `props-main`.`id` = 1717143 OR `props-main`.`id` = 1717482 OR `props-main`.`id` = 1722765 OR `props-main`.`id` = 1718161 OR `props-main`.`id` = 1724762 OR `props-main`.`id` = 1724594 OR `props-main`.`id` = 1703104 OR `props-main`.`id` = 1720809 OR `props-main`.`id` = 1721074 OR `props-main`.`id` = 1724948 OR `props-main`.`id` = 1717543 OR `props-main`.`id` = 1717549 OR `props-main`.`id` = 1721418 OR `props-main`.`id` = 1722150 OR `props-main`.`id` = 1714546 OR `props-main`.`id` = 1723784 OR `props-main`.`id` = 1720509)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226055220' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-05-02' 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 Amy Avila, Atlantic Realty 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.
