NOT LISTED FOR SALE

3123 Castle Rock Loop Discovery Bay, CA 94505

Estimated Value: $843,000 - $911,000

6 Beds
4 Baths
3,394 Sq Ft
$259/Sq Ft Est. Value

Last Sold August 29, 2023

Last sale price $869,000 $256 Per Sq Ft

Est. 1% increase in value since last sale

Current estimated payment $5,815/month

61 Days on Market

Highlights

  • Solar Heated In Ground Pool
  • Gated Community
  • Traditional Architecture
  • Liberty High School Rated A-
  • Recreation Room
  • Wood Flooring

About This Home

As of August 2023

This beautiful and bright North facing home is located in the desirable and prestigious gated community of Lakeshore and boasts a well thought out floor plan which includes a dual grand staircase and hardwood flooring throughout that greets upon entry. Two living spaces consisting of a family and formal living room with a fireplace. Vaulted ceilings provide natural sunlight to shine throughout the home. The exceptionally large kitchen is an entertainer’s dream equipped with stainless steel appliances, including Newer Samsung Refrigerator. granite counters, 5 burner range and double oven, kitchen island and walk-in pantry. First floor bedroom is perfect for guests or in-laws. Retreat to your Master suite with separate tub and steam shower, heated tile flooring. Possible 2nd master upstairs and decently sized bedrooms with their own walk-in closets, built in desk in hallway. Your own backyard oasis awaits with custom solar heated pool featuring waterfalls, easy maintenance patio perfect for entertaining with lights and outdoor heater. Newer Samsung Washer/Dryer. Tankless water heater, water softener, Ev charger and 3 car garage. Conveniently located near walking trails, community pool, park, nearby amenities.Open House 8/5 2-4pm

Last Agent to Sell the Property

Rebecca Rook

Compass License #01909914 Listed on: 06/08/2023

Compass

Last Buyer's Agent

Kevin Eklund

Re/max Accord License #01506889

Re/max Accord

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $11,313

Year Built

  • Built in 2004

Lot Details

  • 6,534 Sq Ft Lot
  • Landscaped
  • Rectangular Lot
  • Back Yard

HOA Fees

  • $230 Monthly HOA Fees

Parking

  • 3 Car Attached Garage
  • Guest Parking

Home Design

  • Traditional Architecture
  • Stucco

Interior Spaces

  • 2-Story Property
  • Fireplace With Gas Starter
  • Family Room Off Kitchen
  • Recreation Room

Kitchen

  • Double Oven
  • Dishwasher
  • Stone Countertops
  • Trash Compactor

Flooring

  • Wood
  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 6 Bedrooms
  • 4 Full Bathrooms

Laundry

  • Dryer
  • Washer

Home Security

  • Security Gate
  • Carbon Monoxide Detectors

Pool

  • Solar Heated In Ground Pool
  • Outdoor Pool

Utilities

  • Forced Air Heating and Cooling System
  • Tankless Water Heater

Listing and Financial Details

  • Assessor Parcel Number 0114600216

Community Details

Overview

  • Association fees include common area maintenance, management fee, reserves, security/gate fee
  • Lakeshore HOA, Phone Number (925) 901-0255
  • Lake Shore Subdivision

Recreation

  • Community Pool
  • Trails

Additional Features

  • Community Barbecue Grill
  • Gated Community

Home Details

Home Type

Single Family

Est. Annual Taxes

$11,313

Year Built

Built in 2004

Lot Details

0

HOA Fees

$230 per month

Parking

3

Listing Details

  • Stories: 2
  • Year Built: 2004
  • Property Sub Type: Single Family Residence
  • Prop. Type: Residential
  • Lot Size Acres: 0.15
  • Subdivision Name: Lake Shore
  • Directions: Timber/Grand/Lakeshore/Castle Rock
  • Architectural Style: Traditional
  • Carport Y N: No
  • Garage Yn: Yes
  • Unit Levels: Two Story
  • New Construction: No
  • ResoPropertyType: Residential
  • ResoBuildingAreaSource: PublicRecords
  • Special Features: VirtualTour

Interior Features

  • Flooring: Hardwood Flrs Throughout, Tile, Carpet
  • Appliances: Dishwasher, Double Oven, Refrigerator, Trash Compactor, Dryer, Washer, Tankless Water Heater
  • Full Bathrooms: 4
  • Total Bedrooms: 6
  • Door Features: Mirrored Closet Door(s)
  • Fireplace Features: Gas Starter
  • Fireplaces: 1
  • Fireplace: Yes
  • Interior Amenities: Kitchen/Family Combo, Rec/Rumpus Room, Stone Counters
  • Room Kitchen Features: Counter - Stone, Dishwasher, Double Oven, Refrigerator, Trash Compactor

Exterior Features

  • Lot Features: Regular, Landscape Back, Landscape Front
  • Pool Features: In Ground, Solar Heat, Solar Pool Owned, Outdoor Pool
  • Pool Private: Yes
  • Construction Type: Siding - Stucco
  • Exterior Features: Backyard, Landscape Back
  • Property Condition: Existing

Garage/Parking

  • Garage Spaces: 3
  • Attached Garage: Yes
  • Covered Parking Spaces: 3
  • Parking Features: Attached

Utilities

  • Heating: Forced Air
  • Cooling: Central Air
  • Laundry Features: Laundry Room
  • Security: Security Alarm - Leased, Carbon Monoxide Detector(s), Security Gate
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Water Source: Public

Condo/Co-op/Association

  • Amenities: Pool, Gated, BBQ Area, Guest Parking, Trail(s)
  • Association Fee: 230
  • Association Fee Frequency: Monthly
  • Association Name: LAKESHORE HOA
  • Phone: 925-901-0255
  • Association: Yes
  • ResoAssociationFeeFrequency: Monthly

Fee Information

  • Association Fee Includes: Common Area Maint, Management Fee, Reserves, Security/Gate Fee

Lot Info

  • Lot Size Sq Ft: 6534
  • Parcel Number: 0114600216
  • ResoLotSizeUnits: Acres

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jun 8, 2023
Closed on
Aug 25, 2023
Sold by
Patwardhan Yashas Sukumar and Patwardhan Swathi Chopp
Bought by
Selph Morgan and Segovia Jorge
Seller's Agent
Rebecca Rook
Compass
Buyer's Agent
Kevin Eklund
Re/max Accord
List Price
$869,000
Sold Price
$869,000
Views
64
Current Estimated Value
$879,000

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$10,000
Avg. Annual Appreciation
0.24%
Original Mortgage
$825,550
Outstanding Balance
$808,820
Interest Rate
6.96%
Mortgage Type
New Conventional
Estimated Equity
$64,475

Purchase Details

Listed on
Oct 31, 2021
Closed on
Nov 29, 2021
Sold by
Regalo Susan D and The 2015 Regalo Family Trust
Bought by
Patwardhan Yashas Sukumar and Thyagarai Swathi Choppalli
Seller's Agent
Emilio Leypon
EXP Realty
List Price
$899,888
Sold Price
$920,000
Premium/Discount to List
$20,112
2.23%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
-3.22%
Original Mortgage
$822,000
Interest Rate
3.09%
Mortgage Type
New Conventional

Purchase Details

Closed on
Nov 28, 2018
Sold by
Abreau Richard F and Abreau Leah
Bought by
Regalo Susan D

Purchase Details

Closed on
Oct 10, 2005
Sold by
Abreau Richard F and Abreau Leah
Bought by
Abreau Richard F and Abreau Leah

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$165,000
Interest Rate
5.63%
Mortgage Type
Stand Alone Refi Refinance Of Original Loan

Purchase Details

Closed on
Jul 15, 2005
Sold by
Abreau Richard F and Hanoka Leah
Bought by
Abreau Richard F and Hanoka Leah

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$540,000
Interest Rate
5.12%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Jul 8, 2004
Sold by
Meritage Homes Of California Inc
Bought by
Abreau Richard F and Hanoka Leah

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$459,600
Interest Rate
4.75%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Dec 19, 2003
Sold by
Inca Capital Fund 18 Llc
Bought by
Meritage Homes Of Northern Ca Inc
Source: Public Records

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Selph Morgan $869,000 Chicago Title
Patwardhan Yashas Sukumar $920,000 First American Title Company
Regalo Susan D $670,000 Chicago Title Company
Abreau Richard F -- First American Title
Abreau Richard F -- Placer Title Company
Abreau Richard F $575,000 First American Title
Meritage Homes Of Northern Ca Inc -- North American Title
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Selph Morgan $825,550
Previous Owner Patwardhan Yashas Sukumar $822,000
Previous Owner Abreau Leah $42,724
Previous Owner Abreau Richard F $531,000
Previous Owner Abreau Richard F $165,000
Previous Owner Abreau Richard F $540,000
Previous Owner Abreau Richard F $152,000
Previous Owner Abreau Richard F $115,100
Previous Owner Abreau Richard F $459,600
Closed Abreau Richard F $86,300
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
02/04/2025 02/04/25 Off Market $869,000 -- --
08/29/2023 08/29/23 Sold $869,000 0.0% $256 / Sq Ft
08/08/2023 08/08/23 Pending -- -- --
07/27/2023 07/27/23 For Sale $869,000 0.0% $256 / Sq Ft
06/14/2023 06/14/23 Pending -- -- --
06/08/2023 06/08/23 For Sale $869,000 -5.5% $256 / Sq Ft
12/03/2021 12/03/21 Sold $920,000 +2.2% $271 / Sq Ft
11/08/2021 11/08/21 Pending -- -- --
10/31/2021 10/31/21 For Sale $899,888 -- $265 / Sq Ft
Source: Bay East Association of REALTORS®

Tax History Compared to Growth

Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $11,313 $886,380 $183,600 $702,780
2024 $10,711 $869,000 $180,000 $689,000
2023 $10,711 $807,000 $118,000 $689,000
2022 $11,942 $920,000 $135,000 $785,000
2021 $9,363 $690,479 $120,576 $569,903
2019 $9,218 $670,000 $117,000 $553,000
2018 $8,635 $642,500 $140,677 $501,823
2017 $8,229 $608,500 $133,233 $475,267
2016 $7,143 $534,500 $117,030 $417,470
2015 $6,868 $516,500 $113,089 $403,411
2014 $6,379 $473,000 $103,565 $369,435
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Bay East Association of REALTORS®

MLS Number: 41029700

Bay East Association of REALTORS®

APN: 011-460-021-6