---
listing_id: CC41142551
status: Pending
price: 549000
beds: 3
baths_full: 2
baths_half: 0
sqft_living: 1370
sqft_lot: 8500
lot_acres: 
year_built: 1956
property_type: Residential
property_subtype: Single Family Residence
address: "1240 Sherlock Way"
city: Concord
state: CA
zip: 94521
county: "Contra Costa County"
lat: 37.9569849
lng: -122.0000778
days_on_market: 6
hoa_fee: 
hoa_frequency: 
garage_spaces: 2
list_agent: "Drew Shiller"
list_office: "Dudum Real Estate Group"
list_agent_phone: "(925) 338-0178"
list_agent_license: 02166533
mls_source: MAXEBRDI
modified: 2026-07-27
transaction_type: buy
---

Home | Contra Costa County | Concord | 94521 | 1240 Sherlock Way

1240 Sherlock Way, Concord, CA 94521

MLS: CC41142551 | Status: PendingDoNotShow | Price: $549,000
Beds/Baths: 3 / 2
Property Type: Residential

Quick Facts

Beds Baths Sq Ft Sq Ft Lot Yr Built
3 2 1,370 8,500 1956

Remarks

Call your contractor and bring your vision—this is an incredible opportunity in the highly sought-after Sheffield Village neighborhood! Ideally located near the Treat Boulevard and Cowell Road intersection, this property offers convenient access to shopping, dining, parks, schools, and commuter routes. Situated on a generous 8,500-square-foot flat lot, the possibilities are endless. Inside, multiple living spaces provide flexibility for a variety of lifestyles, whether you're looking to reimagine the existing layout, create an open-concept design, or add value through thoughtful updates. With great bones, a prime location, and tremendous upside, this is your chance to transform a diamond in the rough into something truly special. Bring your creativity and unlock the full potential of this wonderful property!

MLS Listing Information

Field Value
MLS # CC41142551
MLS Source Contra Costa Association of Realtors

Features

Interior Features

Feature Details
Appliances Garbage Disposal, Oven Range, Refrigerator, Dryer
Fireplace Living Room
Flooring Carpet - Wall to Wall, Vinyl
Laundry In Garage
Cooling Central -1 Zone
Heating Forced Air

Exterior Features

Feature Details
Roof Composition
Pool None, Pool - No
Style Ranch

Parking, School, and Other Information

Feature Details
Garage/Parking Attached Garage, Garage, Garage: 2 Car(s)

Contact Information

Drew Shiller
Dudum Real Estate Group
License #: 02166533
Phone: (925) 338-0178

School Ratings

School data provided by GreatSchools.org

Nearby Schools

School Type Grades Distance Rating
El Monte Elementary School public K-5 1.04 mi 6
Mountain View Elementary School public K-5 1.34 mi 6
Westwood Elementary School public K-5 1.38 mi 4
El Dorado Middle School public 6-8 1.45 mi 3
Woodside Elementary School public K-5 1.55 mi 6
Silverwood Elementary School public K-5 1.57 mi 7
Concord High School public 9-12 1.62 mi 5
Loma Vista Adult Center public UG 1.67 mi N/A
Ygnacio Valley Elementary School public K-5 1.70 mi 2
Valle Verde Elementary School public K-5 1.80 mi 10
Wren Avenue Elementary School public K-5 1.90 mi 1
Sunrise (Special Education) School public K-8 1.99 mi N/A
Ygnacio Valley High School public 9-12 2.06 mi 3
Monte Gardens Elementary School public K-5 2.12 mi 7
Crossroads High (Continuation) School public 7-12 2.17 mi N/A
Ayers Elementary School public K-5 2.21 mi 5
Olympic Continuation High School public 9-12 2.22 mi 2
Meadow Homes Elementary School public K-5 2.25 mi 2
Oak Grove Middle School public 6-8 2.25 mi 4
Cambridge Elementary School public K-5 2.47 mi 2

Nearby Homes

Address Price Beds Baths Sq Ft Status
1766 Oakmead Dr $575,000 3 2 1,224 Active
3000 Montebello Ct $650,000 3 1 1,086 Active
2880 Mount Diablo St $649,950 2 2 1,019 Active
4131 Chaucer Drive $550,000 4 2 1,160 Active

Disclosures

©2026 Contra Costa Association of Realtors. All rights reserved. All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Information provided is for personal, non-commercial use by the viewer and may not be redistributed without explicit authorization from Contra Costa Association of Realtors.

Presently MLSListings.com displays Active, Contingent, Pending, and Recently Sold listings. Recently Sold listings are properties which were sold within the last three years. After that period listings are no longer displayed in MLSListings.com. Pending listings are properties under contract and no longer available for sale. Contingent listings are properties where there is an accepted offer, and seller may be seeking back-up offers. Active listings are available for sale.

This listing information is up-to-date as of July 27, 2026. For the most current information, please contact Drew Shiller, (925) 338-0178.