787 Terrapin Ct, Concord, CA 94518
Property image
Property image
OFF MARKET

$871,400

Trulia Estimate
as of Aug 30, 2026
  • 3 Beds
  • 2 Baths
  • 1,547 sqft
  • 3 Beds
  • 2 Baths
  • 1,547 sqft

787 Terrapin Ct, Concord, CA 94518

Lime Ridge

Home Highlights

Property Type
Single-Family Home
Living Area
1,547 sqft
Price/Sqft
$563
Parking
Attached Garage

Local Information

  • Map ViewExplore the area around 787 Terrapin Ct.
  • Schools1 Elementary School1 Middle School1 High School
  • Shop & Eat
-- mins to
Commute Destination

About this House

** A TOUR IS MANDIDTORY IF APPLICATIONS ARE TO BE CONSIDERED **

Tucked away on a quiet court, this charming 3-bedroom, 2-bath Concord home offers comfort, space, and abundant natural light. Featuring vaulted ceilings with exposed beams, new flooring throughout, spacious living areas, and an updated kitchen with generous storage and counter space, the home is both welcoming and functional. The primary suite includes a walk-in closet and private bath, while the expansive covered deck and backyard provide the perfect setting for relaxing or entertaining. Complete with an attached two-car garage and conveniently located near schools, shopping, restaurants, and parks, 787 Terrapin Ct. is a wonderful place to call home.

Renter pays for water, gas, electricity, and garbage. No smoking allowed. Up to two pets allowed. Limit 4 people.
787 Terrapin Ct, Concord, CA 94518 is a 3 bedroom, 2 bathroom, 1,547 sqft single-family home in Lime Ridge. More recently, it was listed as a rental in July 2026 with an asking price of $3,800 per month. That rental listing was removed on July 15, 2026. This property is not currently displayed as for sale or rent on Trulia. The Trulia Estimate is $871,400, with a rent estimate of $3,500/month.

Home Details for 787 Terrapin Ct

Interior Features

Heating & Cooling
Heating: Forced AirAir ConditioningCooling System: Central AirHeating Fuel: Forced Air
Appliances & Utilities
DishwasherDryerMicrowaveRefrigeratorWasher
Levels, Entrance, & Accessibility
Floors: Hardwood

Property Information

Property Type / Style
Property Type: Single Family Home

Rental Terms, Policies & Fees

Lease Term: 1 YearAvailable: now

Exterior Features

Parking & Garage
Parking: Attached, On Site

Comparable Sales for 787 Terrapin Ct

Address
Distance
Property Type
Sold Price
Sold Date
Bed
Bath
Sqft
740 Sunflower Ct, Concord, CA
0.18
Single-Family Home
$895,000
12/30/25
3
2
2,311 sqft
714 Navaronne Way, Concord, CA
0.33
Single-Family Home
$910,000
08/24/26
3
2
1,547 sqft
2920 Frayne Ln, Concord, CA
0.32
Single-Family Home
$807,000
06/16/26
3
2
1,497 sqft
3513 Torino Way, Concord, CA
0.05
Single-Family Home
$1,135,000
08/04/26
4
3
2,123 sqft
811 Navaronne Way, Concord, CA
0.17
Single-Family Home
$1,200,000
09/25/25
3
3
2,006 sqft
3331 Alfonso Dr, Concord, CA
0.29
Single-Family Home
$977,000
06/24/26
4
2
1,611 sqft
737 Sunflower Ct, Concord, CA
0.20
Single-Family Home
$1,125,000
07/21/26
3
3
1,979 sqft
723 Navaronne Way, Concord, CA
0.28
Single-Family Home
$1,200,000
07/02/26
4
2
1,852 sqft
752 Citrus Ave, Concord, CA
0.30
Single-Family Home
$1,050,000
07/01/26
4
2
1,772 sqft
3445 Chugach Pl, Concord, CA
0.27
Single-Family Home
$900,000
10/02/25
4
2
2,000 sqft

Nearby homes

Get a sense of prices in the area by checking nearby homes.
Skip to last item
Skip to first item

Around this home

Neighborhood Overview

Lime Ridge
See Local Highlights
Neighborhood stats provided by third party data sources.

What Locals Say about Lime Ridge

At least 40 Trulia users voted on each feature.

  • 91 % Say car is needed

  • 90 % Say yards are well-kept

  • 89 % Say it's dog friendly

  • 83 % Say parking is easy

  • 72 % Say there are sidewalks

  • 71 % Say there's holiday spirit

  • 68 % Say people would walk alone at night

  • 67 % Say kids play outside

  • 65 % Say there's wildlife

  • 64 % Say it's quiet

  • 63 % Say neighbors are friendly

  • 62 % Say they plan to stay for at least 5 years

  • 57 % Say streets are well-lit

  • 45 % Say it's walkable to grocery stores

  • 35 % Say there are community events

  • 33 % Say it's walkable to restaurants

Sourced by Trulia users. Learn more about our methodology.
  • Edith B.
    "terrible. concord to Oakland and back. unless I catch Bart, I lose an extra hour of my day each way. ridiculous! and Bart is getting too expensive with parking. I could see if they have more police force to make up for that cost, but I've been riding 13 years and still don't see more officers or ambassadors... it sucks that both options are just as bad in different ways"
    3
    Flag
  • Trulia User
    "There are great well kept and safe roads near here and a wonderful park with excellent amenities. People decorate their houses for holidays too."
    1
    Flag
  • Edith B.
    "the complex is quiet, clean and is kept up to date. the neighborhood seems nice and I feel safe. I like it so much I'd like to buy a home in my neighborhood"
    1
    Flag
  • Edith B.
    "no pets allowed where I live. so don't see many around. I'm sure there are dogs in the house area around the corner"
    0
    Flag

LGBTQ Local Legal Protections

Price and Tax history

DateEventPrice
Jul 15, 2026
Source: Zillow Rentals
ListingRemoved
$3,800
Jul 2, 2026
Source: Zillow Rentals
Listed For Rent
$3,800

Frequently asked questions about 787 Terrapin Ct

  • What is 787 Terrapin Ct estimated to be worth?
    Trulia's estimated value for 787 Terrapin Ct in Concord, CA is $871,400.
  • Is Concord a buyer's or seller's market?
    Concord is currently a seller's market, based on recent for-sale activity.
  • What's the median sale price in Concord?
    The median sale price in Concord is $776K. That is up $29.33K from the prior month.
  • What do residents say about the Lime Ridge neighborhood?
    Residents describe the Lime Ridge neighborhood in Concord, CA as well-kept, dog-friendly, and easy to park in. Most residents say you need a car. See recently sold homes in Lime Ridge, Concord.
  • Does 787 Terrapin Ct have air conditioning?
    Yes, 787 Terrapin Ct in Concord, CA has air conditioning.
  • Does 787 Terrapin Ct have laundry facilities?
    Yes, 787 Terrapin Ct in Concord, CA has in-unit laundry.

Homes for rent near 787 Terrapin Ct

Skip to last item
Skip to first item

Affordability

TIP:Try to keep your rent within a third of your gross household income. Learn why in our Renter's Guide.
For this property
PER YEAR
is the suggested income
Win over prospective landlords with your smart budgeting. As a good rule of thumb, ideally you would have at least three times your monthly rent in combined household income.
Skip to last item
  • Results are loading
Skip to first item