This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/49
$535,000
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/49
Property Description
Turn-Key Duplex with Strong Cash Flow Live in One Unit & Let the Other Pay Your Mortgage! Welcome to this beautifully maintained and updated duplex a fantastic opportunity for both investors and owner-occupants! Each unit offers 2 bedrooms and 1 bathroom with approximately 751 square feet of comfortable living space, featuring modern interior updates completed within the last 5-7 years. Inside, you'll find fresh interior paint, granite countertops, stylish lighting fixtures, dual-pane windows, and a mix of laminate flooring, tile, and some carpet for comfort and durability. Both units include central heating and air conditioning, as well as a convenient storage and laundry room. The front entry welcomes you with an enclosed patio yard, perfect for relaxing or enjoying morning coffee. Out back, each unit boasts a large private backyard with plenty of room for kids to play, pets to roam, gardening, barbecuing, or entertaining with one side already thoughtfully set up as a garden space. Parking is easy with a covered carport for one vehicle plus an additional parking space for a second car. Ideally located near Memorial Hospital, schools, churches, and major shopping areas. This property offers both convenience and strong rental appeal. Best of all, no repairs are currently needed, and the duplex has just passed the Modesto City annual rental inspection, providing peace of mind for the next owner. This is a perfect opportunity for someone looking to purchase their first investment property while living in one unit and renting out the other or for an investor seeking a turn-key income property.
Full Property Details
Full Property Details for 2045 Celeste Dr
General
- Price: $535,000
- Status: Active
- Type: Single Family
- Source: METROLIST_Cali
- MLS ID: 226013535
- Updated: 2/18/2026
- Added to Site: 15 day(s) ago
Rental Information
- Lease/Rent Term: Other
Interior
- Interior Features: Storage Area(s)
- Appliances: Built-In Gas Range, Dishwasher, Microwave, Disposal
- Flooring: Carpet, Tile, Laminate, Wood
Rooms
Other Rooms
- Laundry: In Each Unit, Laundry Closet, Washer/Dryer Hookups
Exterior
- Exterior Features: Fenced Yard, Yard Space
Parking
- Total Spaces: 4
- Parking: Attached, Carport
Location
- Area: 20102
- County: Stanislaus
- Cross Streets: Sage
- Driving Directions: N Oakdale rd to Celeste , turn left on Celeste. Property on the right side
School Information
- School District: Stanislaus
- Elem School District: Modesto City
- Midd School District: Modesto City
- High School District: Modesto City
Heating & Cooling
- Cooling Type: Ceiling Fan(s), Central
- Heating Type: Central
Utilities
- Sewer: Public Sewer
- Water: Meter on Site, Public
- Utility Description: Sewer In & Connected
Structural Information
- Architectural Style: One Story
- Construction Status: Updated/Remodeled
- Construction: Stucco
- Foundation: Raised
- Roof: Composition
- Windows: Dual Pane Full
- Stories/Levels: 1
- Square Feet: 1,552
- Sq. Ft. Source: Appraiser
- Year Built: 1967
Unit Information
Unit 1
- Bedrooms: 2
Unit 2
- Bedrooms: 2
Lot Features
- Lot Size (Acres): 0.1682
- Lot Size (Sq. Ft.): 7,327
- Irrigation System: None
- Zoning: R2
- Lot Description: Garden
Financial Considerations
- Tenant Pays: Cable TV, Electricity, Gas, Grounds Care, Trash Collection
Disclosures and Reports
- Special Conditions: None
- APN: 066-019-008-000
Listed by Dream Chasers Realty
Get Pre-Approved Today
Schools
Schools serving 2045 Celeste Dr
School Districts:Sylvan Union Elementary School District, Modesto City High School District
| Name | Grades | Distance |
|---|---|---|
Coleman F. Brown Elementary School 2024 Vera Cruz Drive, Modesto, CA 95355 | K-5 | 0.5 mi |
Somerset Middle School 1037 Floyd Ave, Modesto, CA 95350 | 6-8 | 1.8 mi |
Fred C. Beyer High School 1717 Sylvan Avenue, Modesto, CA 95355 | 9-12 | 1.3 mi |
Disclaimer:
School attendance boundaries provided by Pitney Bowes and are for reference only. Contact the school directly to verify enrollment eligibility.
Price & Sales History for 2045 Celeste Dr
Date
Details
Price
Change
Source
2/18/2026
Price Increased
$535,000
3.88%
MLS
2/05/2026
Listed
$515,000
255.17%
MLS
12/20/2012
Sold
$145,000
—
Public Record
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
Tax History
Tax History for 2045 Celeste Dr
Year
Property Taxes
Change
Tax Assessment
Change
2025
$1,973
4%
$178,543
4%
2023
$1,900
4%
$171,612
2%
2022
$1,824
2%
$168,248
2%
2021
$1,792
1%
$164,950
1%
2020
$1,766
2%
$163,260
2%
2019
$1,734
2%
$160,059
2%
2018
$1,700
2%
$156,922
2%
2017
$1,659
1%
$153,846
2%
2016
$1,649
1%
$150,830
2%
2015
$1,625
—
$148,566
33%
2014
$1,619
30%
$112,000
—
2013
$1,249
—
$112,000
—
Disclaimer: Historical tax information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
Estimate the Cost
Estimate the Cost for 2045 Celeste Dr
2045 Celeste Drive, Modesto, CA 95355 (MLS# 226013535) is a Single Family property with 0 bedrooms and 0 full bathrooms. 2045 Celeste Drive is currently listed for $535,000 and was received on February 05, 2026. Want to learn more about 2045 Celeste Drive? Do you have questions about finding other Single Family real estate for sale in Modesto? You can browse all Modesto real estate or contact a Coldwell Banker agent to request more information.

