Property Attributes
- MLS#41144268
- TypeSingle Family
- Listing Status Active
- CountyContra Costa
- CityConcord
- NeighborhoodLIMERIDGE
- Zip94518
- Style
- Year Built2005
- Price$ 1,499,000
- Bedrooms5
- Full Bathrooms4
- Half Bathrooms0
- Sqr Footage3867
- Lot Size0.374 Acres
Data Source:
California Regional MLS (CRMLS)
Property Description
Breathtaking Views & Timeless Elegance in the Coveted Lime Ridge Neighborhood Perched on a hill on the border of Concord and Walnut Creek, this stunning 3,814 sq ft home delivers panoramic views from every room and a lifestyle that's hard to find. Dine with sunset views and wake up to the most amazing morning light on the hilltops! Thoughtfully designed to live like a single-story home, the main level welcomes you with a gracious formal living and dining room, an open kitchen and family room, a private office, and a luxurious primary suite. Everything you need, all on one floor, with no steps. The lower level offers three additional bedrooms, including a second primary suite with its own en suite bath and custom walk-in closet, plus a spacious second living area and two full bathrooms. It's the perfect setup for multigenerational families or guests who want their own private retreat, all while you enjoy true single-story living upstairs. Step outside and discover a backyard paradise. One side features a charming orchard with mature fruit trees. The other offers a built-in barbecue, a serene lily pond with Koi fish, a spacious hot tub, and multiple lounge areas, all framed by incredible views. Two back decks, two huge balconies, and a covered front porch mean you'll never run out of space to relax and entertain. There are so many recent updates: 10kW Tesla solar panels with two backup batteries, hardwood floors throughout, newer lighting fixtures and fans, newer appliances, and fresh paint inside and out, including the cabinets. The home also features two fireplaces and a spacious 3-car attached garage. With an excellent location, the home is just a stone's throw from Carondelet and De La Salle High Schools, Walnut Creek shopping and dining, and has direct neighborhood access to the Lime Ridge Open Space trails for all your outdoor activities. Easy access to BART & 680! Only the second owner- this home is move-in ready and looks even better in person! Must see these VIEWS! Views: Downtown, Ridge
| Price History | |
|---|---|
| 8/27/2026 | Listed $1,499,000 |
General Features
| Living Area | 3867 |
|---|---|
| Heating | Forced Air |
| Cooling | Central Air |
| Possession | Close Of Escrow |
| Roof | Tile |
| Appliances | Gas Water Heater |
| Garage Spaces | 3 |
| Patio/Porch Features | Deck,Patio |
| Architectural Style | Contemporary |
| Pool Features | None |
| Construction Materials | Aluminum Siding,Stone,Wood Siding |
| Year Built | 2005 |
| View | City Lights,Hills,Panoramic |
| Stories Count | 2 |
| Levels | Two |
| Property Subtype | Single Family Residence |
| County | Contra Costa |
| New Construction | false |
| Property Type | Residential |
| HOA | false |
| Attached Garage | true |
| Subdivision Name | LIMERIDGE |
| Garage Y/N | true |
| Full Baths | 4 |
| Status | Active |
| Directions | Cross Street: Davenport Lane. |
| City | Concord |
| Lot Size Units | Square Feet |
| Lot Size Square Feet | 16290 |
| Listing Terms | Cash,Conventional |
| Virtual Tour | https://listings.dremarvisuals.com/sites/raojazan/unbranded |
| Standard Status | Active |
| Occupancy Type | Vacant |
| Property Sub Type Additional | Single Family Residence |
| Expected Active Date | 2026-08-27 |
| PostalCity | CONCORD |
Interior Features
| Interior Amenities | Breakfast Bar,Eat-in Kitchen |
|---|---|
| Flooring | Carpet,Stone,Wood |
| Fireplace Features | Family Room,Primary Bedroom |
| Air Conditioning Y/N | true |
| Heating Y/N | true |
| Fireplace Y/N | true |
| Total Bedrooms | 5 |
| Total Baths | 4 |
Exterior Features
| Parking Features | Garage,Garage Door Opener |
|---|---|
| Lot Features | Back Yard,Corner Lot,Sloped Up,Yard |
| Total Parking | 3 |
| Lot Size Area | 16290 |
| Lot Size Acres | 0.374 |
| Private Pool | false |
| Lot Size Source | Public Records |
Amenities
- Foreclosure
- Views
- Short Sale
- New Construction
- Adult 55+
- Lease To Own
- No HOA Fees
- Furnished
- Primary On Main
- Air Conditioning
- Seller Finance
- Green
- Fixer Upper
- Horse
- Golf
- Fireplace
- Deck
- Garage
- Basement
- Pool
Based on information from California Regional Multiple Listing Service, Inc. as of September 27, 2026 10:46 PM UTC This information is for your personal, non-commercial use and may not be used for any purpose other than to identify prospective properties you may be interested in purchasing. Display of MLS data is usually deemed reliable but is NOT guaranteed accurate by the MLS. Buyers are responsible for verifying the accuracy of all information and should investigate the data themselves or retain appropriate professionals. Information from sources other than the Listing Agent may have been included in the MLS data. Unless otherwise specified in writing, Broker/Agent has not and will not verify any information obtained from other sources. The Broker/Agent providing the information contained herein may or may not have been the Listing and/or Selling Agent.
Copyright Southeast Florida Multiple Listing Service © 2026. Accuracy of listing information is not guaranteed. Listing information is provided for personal consumer, non-commercial use, solely to identify potential properties for potential purchase. All other use is strictly prohibited, is a violation of the terms of use, and may violate federal and state law.
Data Last Updated: September 27, 2026 10:46 PM UTC
The data relating to real estate for sale on this web site comes in part from the INTERNET DATA EXCHANGE Program of the Greater Las Vegas Association of REALTORS® MLS. Real estate listings held by brokerage firms other than this site-owner are marked with the IDX logo. The information being provided is for the consumers' personal, noncommercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information on this
The content relating to real estate for sale on this website comes in part from the MLS of Central Oregon. Real estate listings held by Brokerages other than qa are marked with the Reciprocity/IDX logo, and detailed information about these properties includes the name of the listing Brokerage. © MLS of Central Oregon (MLSCO).
This content last updated on September 27, 2026 10:50 PM UTC Some properties which appear for sale on this website may subsequently have sold or may no longer be available.
All
Information provided by Intermountain MLS (IMLS) is deemed reliable but not guaranteed.
The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of the Intermountain MLS system. Real estate listings held by brokerage firms other than qa are marked with the IDX icon.
IDX information is provided exclusively for consumer's personal, non-commercial use, that it may not be used for any purpose other than to identify prospective properties consumers
Information provided courtesy of LERA MLS. IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is believed to be accurate but not guaranteed. Provided courtesy of LERA MLS. Copyright 2026 LERA MLS, All Rights Reserved. Data last updated September 27, 2026 10:20 PM UTC
The data relating to real estate for sale on this web site comes from the participating brokers of the South Jersey Shore MLS. Any use of search facilities of data on the site, other than a consumer looking to purchase real estate, is prohibited. Information displayed on this web site is Deemed Reliable But Not Guaranteed. This data is updated daily.
© 2026 Florida Gulf Coast MLS (FGCMLS) Information deemed reliable, but not guaranteed. The IDX data relating to real estate for sale on this web site comes in part from the Florida Gulf Coast Multiple Listing Service. 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 consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.
Wasatch Front Regional MLS - Salt Lake Board of REALTORS® All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties
Southern Oregon Multiple Listing Service All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be
Information is deemed to be reliable, but is not guaranteed. © 2026 MLS and FBS. Prepared by Florida Keys MLS, Inc. on September 27, 2026 10:44 PM UTC The information on this sheet has been made available by the MLS and may not be the listing of the provider. The data relating to real estate for sale on this web site comes in part from the Florida Keys MLS, Inc. Information provided is deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. The information
The content relating to real estate for sale and/or lease on this Web site comes in part from
the Internet Data eXchange ("IDX") program of the Northwest Indiana REALTORS® Association Multiple Listing Service ("NIRA MLS"). and is communicated verbatim, without change, as filed by its members. This information is being provided for the consumers' personal, noncommercial use and may not be used for any other purpose other than to identify prospective properties consumers may be interested in purchasing
West Central Association Of REALTORS® All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be
All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data relating
All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data relating
Information should be deemed reliable but not guaranteed, all representations are approximate, and individual verification is recommended. Copyright ©2018 All rights reserved. Last Update: September 27, 2026 10:38 PM UTC
OneKey® MLS required Copyright, Source of Data and Disclaimer for IDX display
Information Copyright 2026, OneKey® MLS. All Rights Reserved.
The source of the displayed data is either the property owner or public record provided by non-governmental third parties. It is believed to be reliable but not guaranteed. This information is provided exclusively for consumers' personal, non-commercial use.
The data relating to real estate for sale on this website comes in part from the
All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data relating