Property Attributes
- ID#41144268
- TypeSingle Family
- Listing Status Active
- CountyContra Costa
- CityConcord
- NeighborhoodLimeridge
- Zip94518
- StyleContemporary
- Year Built2005
- Price$ 1,499,000
- Bedrooms5
- Full Bathrooms4
- Half Bathrooms0
- Sqr Footage3867
- Lot Size0.37 Acres
Data Source:
Bay East MLS, CCAR MLS, or bridgeMLS
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! This home is move-in ready and looks even better in person! Must see these VIEWS!
| Price History | |
|---|---|
| 8/27/2026 | Listed $1,499,000 |
General Features
| Living Area | 3867 |
|---|---|
| Sewer | Public Sewer |
| Heating | Zoned |
| Cooling | Ceiling Fan(s),Central Air,ENERGY STAR Qualified Equipment |
| Roof | Tile |
| Appliances | Double Oven,Gas Range,Microwave,Refrigerator,Gas Water Heater |
| Garage Spaces | 3 |
| Architectural Style | Contemporary |
| Pool Features | None |
| Construction Materials | Aluminum Siding,Stone,Wood Siding |
| Year Built | 2005 |
| Electric | Photovoltaics Seller Owned,220 Volts in Kitchen |
| View | City Lights,Downtown,Hills,Panoramic,Ridge,City |
| Stories Count | 2 |
| Levels | Two Story |
| Property Subtype | Detached |
| County | Contra Costa |
| New Construction | false |
| Property Type | Residential |
| HOA | false |
| Energy Efficient | Walls Insulated |
| Subdivision Name | Limeridge |
| Garage Y/N | true |
| Green Energy Generation | Solar Available,Solar Power Off Grid |
| Total Rooms | 12 |
| Full Baths | 4 |
| Status | Active |
| Directions | From Treat Blvd to Davenport Lane to Newhaven.. |
| City | Concord |
| MLS Area | Listing |
| Lot Size Square Feet | 16290 |
| Property Condition | Existing |
| Virtual Tour | https://listings.dremarvisuals.com/sites/raojazan/unbranded |
| Standard Status | Active |
Interior Features
| Interior Amenities | Breakfast Bar,Pantry,Updated Kitchen |
|---|---|
| Flooring | Hardwood,Carpet |
| Total Fireplaces | 2 |
| Fireplace Features | Family Room,Master Bedroom |
| Air Conditioning Y/N | true |
| Heating Y/N | true |
| Window Features | Double Pane Windows,ENERGY STAR Qualified Windows |
| Fireplace Y/N | true |
| Laundry Features | 220 Volt Outlet,Laundry Room |
| Total Bedrooms | 5 |
| Kitchen Features | 220 Volt Outlet,Breakfast Bar,Stone Counters,Double Oven,Eat-in Kitchen,Gas Range/Cooktop,Kitchen Island,Microwave,Pantry,Refrigerator,Updated Kitchen |
| Total Baths | 4 |
| Power Production Type | Photovoltaics |
Exterior Features
| Exterior Amenities | Back Yard,Side Yard,Garden,Landscape Back,Landscape Front |
|---|---|
| Parking Features | Attached,Garage Door Opener |
| Lot Features | Corner Lot,Sloped Up |
| Water Source | Public |
| Lot Size Area | 16290 |
| Building Area Total | 3867 |
| Lot Size Acres | 0.37 |
| ADU Y/N | false |
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
The data relating to real estate for sale on this web site comes in part from the Internet Data Exchange Program of RealTracs Solutions as distributed by MLS Grid. Real estate listings held by brokerage firms other than Intero are marked with the Internet Data Exchange Program logo or thumbnail logo and detailed information about them includes the name of the listing brokers.
Last updated: September 15, 2026 1:27 AM UTC Property Information © 2026
All measurements and all calculations of area are approximate. Information provided by Seller/Other sources, not verified by Broker. All interested persons should independently verify accuracy of information. Provided properties may or may not be listed by the office/agent presenting the information. Data maintained by MetroList© may not reflect all real estate activity in the market.
All real estate content on this site is subject to the Federal Fair Housing Act of 1968, as amended, which makes it illegal to advertise any preference, limitation or discrimination because of race, color, religion, sex, handicap, family status or national origin or an intention to make any such preference, limitation or discrimination.
MetroList CA data last updated: September 15, 2026 12:44 AM UTC
The information being provided by Houston Association of REALTORS, Inc. is for the 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. Any information relating to real estate for sale referenced on this web site comes from the Internet Data Exchange (IDX) program of the Houston Association of REALTORS, Inc. This web site may reference real estate listing(s) held by a brokerage firm other
Austin Board of REALTORS® Copyright ©2026 All rights reserved.
Bay East ©2026. CCAR ©2026. bridgeMLS ©2026. Information Deemed Reliable But Not Guaranteed. This information is being provided by the Bay East MLS, or CCAR MLS, or bridgeMLS. The listings presented here may or may not be listed by the Broker/Agent operating this website. This information is intended for the personal use of consumers and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Data last updated at September
This information, including square footage, while not guaranteed, has been acquired from sources believed to be reliable. Listings on this page identified as belonging to another listing firm are based upon data obtained from the SFAR MLS, which data is copyrighted by the San Francisco Association of REALTORS©, but is not warranted.
All data, photos, visualizations, and information regarding a property, including the property's compliance with state and local legal requirements and all measurements and calculations of area, have been obtained from various sources, and may include such material that has been generated by use of artificial intelligence. Such information and material have not been and will not be verified for accuracy by the listing broker or the multiple listing service, and are not guaranteed as complete, accurate or reliable. Such information and material should be independently reviewed and verified for accuracy. This information and material are intended for the personal use of consumers and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Copyright ©2026 Bay Area Real Estate Information Services, Inc. All Rights Reserved.
The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity program of the Northern Nevada Regional Multiple Listing Service®. Real estate listings held by brokerage firms other than the owner of this site are marked with the Broker Reciprocity logo and detailed information about those listings includes the name of the listing brokerage. Copyright 2026 of the Northern Nevada Regional Multiple Listing Service MLS. All rights reserved.
The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity Program of the Tahoe Sierra Multiple Listing Service. Real estate listings held by brokerage firms other than Tahoe Sierra Board of Realtors are marked with the Broker Reciprocity logo and detailed information about them includes the name of the listing brokers.
The information being provided is for consumers' personal, non-commercial use and may not be used for any other purpose other than to
Plumas 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 interested
Incline Village 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 consumers may be interested
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 deemed reliable but not guaranteed
© Copyright South Tahoe Association of Realtors. All rights reserved.
Information should be deemed reliable but not guaranteed, all representations are approximate, and individual verification is recommended. Copyright ©2017 All rights reserved.