$1,040,000
●
House -
Off Market
2962 Celeste Way
Brentwood, CA 94513
5 Beds
4 Baths,
1
Half Bath
4,070 Ft²
$5,147
Est. Monthly
$45
HOA / Fees
About This Property
Welcome home! Prepare to be amazed as you arrive at this stunning
5-bedroom, 4.5-bathroom gem. From the moment you enter, you'll be
greeted by a grand staircase, elegant custom wainscoting, soaring
vaulted ceilings, brand-new flooring, and freshly painted walls
that create an atmosphere of sophistication and warmth. The modern
kitchen features new appliances, a spacious island, and a walk-in
pantry. It flows effortlessly into the family room and opens to the
backyard, creating the perfect space for seamless entertaining.
With two luxurious primary suites, one on each floor, this home
offers the ultimate comfort and privacy. Upstairs, you'll find two
versatile lofts and four spacious rooms, ideal for family
gatherings, home offices, or whatever your heart desires. Venture
outside to your own personal oasis, featuring a built-in kitchen
island with a grill, a pergola and gazebo to relax under, and a
tranquil pond complete with a cascading waterfall. This home truly
has it all! Don't miss your chance to experience this MUST-SEE
home.
Unit Size
4,070 Ft²
Days on Market
61 days
Land Size
0.20 acres
Price per sqft
$255
Property Type
House
Property Taxes
-
HOA Dues
$45
Year Built
2006
Payment Calculator
Home Price
Down Payment
%
Loan Term
Interest %
Your Estimated Monthly Payment
Principal + Interest:
Property Tax:
HOA:
Home Insurance:
Mortgage Insurance:
Cap Rate Calculator
Purchase Price
Monthly Property Taxes
Monthly Rental Income
Maintenance & HOA
Income Per Year
Expenses Per Year
Operating Profit Per Year
Cap Rate
100% Occupancy
N/A (extreme outlier) What does this mean?
Based on our analysis, the cap rate of this property is 1.25%. A negative cap rate indicates that the property might not be feasible as an income-producing asset. The median cap rate for a near zip code 11238 is 4.23%.
How much can I actually make?
Actual monthly rental income may vary between $4,760 and $7,140 depending on unit-specific characteristics. You can change the amount using the slider to further explore.
How is cap rate calculated?
Cap Rate = Net Operating Income (NOI) / Property Asset Value.
When calculating the cap rate, we assume 100% occupancy. Leverage (mortgage) is not considered.
Cap Rate provided by RealtyHop and RentHop, learn more about cap rate here.
Last updated: 9 months ago (bridgeMLS/CCAR/Bay East AOR #41088237)
Price History
| Date / Event | Date | Event | Price |
|---|---|---|---|
| May 5, 2025 | Sold | ||
| Sold | |||
| Mar 5, 2025 | Listed by Twin Oaks Real Estate Inc. | $1,039,000 | |
| Listed by Twin Oaks Real Estate Inc. | |||
Property Highlights
Air Conditioning
Fireplace
Garage
Building Info
Data used for valuation calculations is provided by RealtyHop, and other third party sources
Comparables
Unit
Status
Status
Type
Beds
Baths
ft²
Price/ft²
Price/ft²
Asking Price
Listed On
Listed On
Closing Price
Sold On
Sold On
HOA + Taxes
About Rose Garden
Similar Homes for Sale
Currently no similar homes aroundNearby Rentals
Listed by: Yen Lu, Twin Oaks Real Estate Inc.
Last Updated: 9 months ago
Data Source: CRMLS, MLS# 41088237
Last Updated: 9 months ago
Data Source: CRMLS, MLS# 41088237
The multiple listing data appearing on this website, or contained in reports produced therefrom, is owned and copyrighted by California Regional Multiple Listing Service, Inc. ("CRMLS") and is protected by all applicable copyright laws. Information provided is for viewer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties the viewer may be interested in purchasing. All listing data, including but not limited to square footage and lot size is believed to be accurate, but the listing Agent, listing Broker and CRMLS and its affiliates do not warrant or guarantee such accuracy. The viewer should independently verify the listed data prior to making any decisions based on such information by personal inspection and/or contacting a real estate professional. 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
Your Privacy Choices
Phone: 425-283-2930
Address: 335 Madison Avenue, New York, NY 10017