2045 Celeste Dr

1,552 Sq. Ft.
$345 / Sq. Ft.
1,552
Sq. Ft.
$345
per Sq. Ft.

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...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.
  1. Listed by Robyn Brown • DRE #01493255 • Dream Chasers Realty
    P: (209)-603-6886 dreamchasersrlty@gmail.com

Property Details for 2045 Celeste Drive

Parking Features
Attached, Carport
Zoning
R2
LISTING UPDATED: 02/02/2026 12:10 PM

Property Details for 2045 Celeste Drive

StatusActive
MLS #226011921
Days on Compass2
Taxes-
HOA Fees-
Condo/Co-op Fees-
Compass TypeMulti Family
MLS TypeResidential Income / Duplex
Year Built1967
Lot Size0.17 AC / 7,326 SF
CountyStanislaus County

Location

Listing Courtesy of Dream Chasers Realty, Robyn Brown, DRE #01493255
Add your commute

Building Information for 2045 Celeste Drive

Stories1Residences2Year Built1967Building Size-Lot Size0.17 AC / 7,326 SF

Payment Calculator

$2,771 per month

30 year fixed, 6.15% Interest

Principal and Interest

$2,607

Property Taxes

$164

HOA Dues

$0

The Payment Calculator is for illustrative purposes only.

Property Information for 2045 Celeste Drive

Summary
Location and General Information
  • Area/District: 20102
  • Area Short Display: 20102
  • Cross Street: Sage
  • City: Modesto
  • County: Stanislaus
  • State: CA
  • Zip Code: 95355
  • Zip Plus 4: 2614
  • Directions to Property: N Oakdale rd to Celeste , turn left on Celeste. Property on the right side
Taxes and HOA Information
  • APN: 066-019-008-000
  • License Fee: $.00
  • City Transfer Tax Rate: .00%
  • County Transfer Tax Rate: .00%
  • Association: false
  • Association Fee: $.00
School Information
  • School District (County): Stanislaus
  • Elementary School District: Modesto City
  • Middle or Junior School District: Modesto City
  • Senior High School District: Modesto City
Parking
  • Covered Spaces: 0
  • Independent Parking Spaces: 0
  • Carport Spaces: 2
  • Garage Spaces: 0
  • Total Parking Spaces: 4
  • Tandem Parking Spaces: 0
  • Open Parking Spaces: 2
  • Parking Fee $: 0.0
Virtual Tour
  • Virtual Media Count: 0
Property
Lot Information
  • Square Footage: 0.0
  • Year Built Source: Assessor Auto-Fill
  • Minimum Bldg SqFt: 0.0
  • # of Lots: 0
  • Lot Size Acres: 0.1682
  • Lot Size Source: Assessor Auto-Fill
  • Lot Size Square Feet: 7327.0
  • Lot Features: Garden
Property and Assessments
  • Property Condition: Updated/Remodeled
  • Home Warranty: false
  • Irrigation: None
  • Year Built: 1967
  • Picture Count: 49
  • Photos Provided By: Agent
  • Elevation: 0
  • Units Furnished: None
  • Property Disclaimer: All data, photos, visualizations and information regarding a property, including all measurements and calculations of area, has been obtained from various sources and has not been, and will not be verified by the listing broker, except as required by the MLS Rules, or MLS. Information on this website may be from sources other than broker, sellers and/or MLS, may include information generated using artificial intelligence, digitally altered photographs or images, and is not guaranteed as complete, accurate or reliable. All data, photos, visualizations and information regarding a property is provided “AS IS” and without any warranty, express or implied, and should be independently reviewed and verified for accuracy.
  • Signs: No
  • Census Tract: 9.1
  • Actual or Scheduled: Actual
Green Features
  • Green Verification Year: 0
  • Energy Efficient: Windows
Utilities
  • Separate Meters: Electricity, Gas
  • Sewer: Public Sewer
  • Utilities: Sewer In & Connected
  • Water Source: Meter on Site, Public
Interior and Exterior Features
Exterior Features
  • # of Floors: 1
  • # of Guest Space(s): 0
  • # Of Buildings: 1
  • Construction Materials: Stucco
  • Foundation: Raised
  • Stories: 1
  • Levels: One
  • Exterior Features: Fenced Yard, Yard Space
  • Window Features: Dual Pane Full
  • Horse Property: false
  • Pool: false
  • Roof: Composition
  • Senior Community: false
Interior Features
  • Interior Features: Storage Area(s)
  • Heating: Central
  • Appliances: Built-In Gas Range, Dishwasher, Microwave, Disposal
  • Laundry Features: In Each Unit, Laundry Closet, Washer/Dryer Hookups
  • Spa: false
  • # of Fireplaces: 0
  • Cooling: Ceiling Fan(s), Central
  • Flooring: Carpet, Tile, Laminate, Wood
  • Entry Level: 0
  • Possible Bedrooms: 0.0
  • Bedrooms: 0
  • Bathrooms: 0.0
  • Full Bathrooms: 0
  • Half Bathrooms: 0
  • # of Rooms: 0
Room Information
1 Bedroom Unit
  • # of 1 Bedroom Units: 0
  • 1 Bedroom Annual Occupancy: .00%
  • # of 1 Bedrooms Occupied: 0
2 Bedroom Unit
  • # of 2 Bedroom Units: 2
  • 2 Bedroom Annual Occupancy: 100.00%
  • # of 2 Bedrooms Occupied: 2
3 Bedroom Unit
  • # of 3 Bedroom Units: 0
  • 3 Bedroom Annual Occupancy: .00%
  • # of 3 Bedrooms Occupied: 0
4 Bedroom Unit
  • # of 4 Bedroom Units: 0
  • 4 Bedroom Annual Occupancy: .00%
  • # of 4 Bedrooms Occupied: 0
Multi Family
Multi-Family Information
  • # Commercial Units: 0
  • Total # Owner Occupied: 2
  • # Studios Occupied: 0
  • # of Studio Units: 0
  • # of Units: 2
  • # Of Units Total: 2
  • Num of Units: 2
Multi-Family Additional Information
  • 2nd Unit Approx SqFt: 0.0
  • 2nd Unit Rents for: $.00
  • 2nd Unit Bedrooms: 0.0
Unit 1
  • Unit 1 Bedrooms: 2
  • Unit 1 Full Baths: 1
  • Unit 1 Partial Baths: 0
  • Unit 1 Lease Term: Other
  • Unit 1 Occupancy: Tenant
  • Unit 1 Rent Source: Rental
  • Unit 1 Rent: $1,565.00
  • Unit 1 Approx SqFt: 751.0
  • Unit 1 SqFt Source: Appraiser
  • Unit 1 # of Rooms: 4
Unit 2
  • Unit 2 Bedrooms: 2
  • Unit 2 Full Baths: 1
  • Unit 2 Partial Baths: 0
  • Unit 2 Lease Term: Other
  • Unit 2 Occupancy: Tenant
  • Unit 2 Rent Source: Rental
  • Unit 2 Rent: $1,750.00
  • Unit 2 Approx SqFt: 751.0
  • Unit 2 SqFt Source: Appraiser
  • Unit 2 # of Rooms: 0
Unit 3
  • Unit 3 Bedrooms: 0
  • Unit 3 Full Baths: 0
  • Unit 3 Partial Baths: 0
  • Unit 3 Rent: $.00
  • Unit 3 Approx SqFt: 0.0
  • Unit 3 # of Rooms: 0
Unit 4
  • Unit 4 Bedrooms: 0
  • Unit 4 Full Baths: 0
  • Unit 4 Partial Baths: 0
  • Unit 4 Rent: $.00
  • Unit 4 Approx SqFt: 0.0
  • Unit 4 # of Rooms: 0
Mobile/Manufactured Home
  • Width: 0.0
  • Length: 0.0
  • Berth Size Length: 0.0
  • Berth Size Width: 0.0
Income & Expenses
  • Income Includes: Rent Only
Rental
Rent Information
  • Land Lease: false
  • Studio Annual Occupancy: .00%
  • Tenant Pays: Cable TV, Electricity, Gas, Grounds Care, Trash Collection

Property History for 2045 Celeste Drive

DateEvent & SourcePriceAppreciation
Feb 1, 2026

Listed (Active)

METROLIST #226011921

$535,000
Jan 25, 2013

Sold

METROLIST #12068682

$145,000
Jan 25, 2013

Sold

RESFAR #12068682

$145,000
Dec 20, 2012

Sold (Public Record)

Public Record #346129161

$145,000

+72.0% / yr

Nov 26, 2012

Pending

RESFAR #12068682

Nov 26, 2012

Pending

METROLIST #12068682

Nov 16, 2012

Listed (Active)

RESFAR #12068682

$154,900
Nov 16, 2012

Listed (Active)

METROLIST #12068682

$154,900
Jun 29, 2012

Sold (Public Record)

Public Record #334736276

$112,000

-16.7% / yr

Apr 28, 2012

Price Change

RESFAR #10052035

$120,000
Dec 30, 2010

Expired

RESFAR #10052035

Dec 30, 2010

Withdrawn

METROLIST #10052035

$120,000
Aug 3, 2010

Withdrawn

RESFAR #10010779

$135,000
Jun 30, 2010

Price Change

RESFAR #10052035

$135,000
Jun 30, 2010

Listed (Active)

RESFAR #10052035

$120,000
May 25, 2010

Withdrawn

METROLIST #10010779

Feb 10, 2010

Listed (Active)

RESFAR #10010779

$135,000
Feb 10, 2010

Listed (Active)

METROLIST #10010779

$135,000
Jul 28, 2005

Sold

METROLIST #50038336

$395,000
Jul 18, 2005

Sold (Public Record)

Public Record #161453174

$400,000

+40.9% / yr

May 25, 2005

Pending

METROLIST #50038336

May 13, 2005

Listed (Active)

METROLIST #50038336

$399,950
Mar 4, 2004

Sold (Public Record)

Public Record #130461532

$250,000
Mar 4, 2004

Sold

RESFAR #30067440

$250,000
Mar 4, 2004

Sold

METROLIST #30067440

$250,000
Jan 20, 2004

Pending

RESFAR #30067440

Jan 20, 2004

Pending

METROLIST #30067440

DateEvent & SourcePrice
02/01/2026

Listed (Active)

METROLIST #226011921

$535,000
01/25/2013

Sold

METROLIST #12068682

$145,000
01/25/2013

Sold

RESFAR #12068682

$145,000
12/20/2012

Sold (Public Record)

Public Record #346129161

$145,000

+72.0% / yr

11/26/2012

Pending

RESFAR #12068682

11/26/2012

Pending

METROLIST #12068682

11/16/2012

Listed (Active)

RESFAR #12068682

$154,900
11/16/2012

Listed (Active)

METROLIST #12068682

$154,900
06/29/2012

Sold (Public Record)

Public Record #334736276

$112,000

-16.7% / yr

04/28/2012

Price Change

RESFAR #10052035

$120,000
12/30/2010

Expired

RESFAR #10052035

12/30/2010

Withdrawn

METROLIST #10052035

$120,000
08/03/2010

Withdrawn

RESFAR #10010779

$135,000
06/30/2010

Price Change

RESFAR #10052035

$135,000
06/30/2010

Listed (Active)

RESFAR #10052035

$120,000
05/25/2010

Withdrawn

METROLIST #10010779

02/10/2010

Listed (Active)

RESFAR #10010779

$135,000
02/10/2010

Listed (Active)

METROLIST #10010779

$135,000
07/28/2005

Sold

METROLIST #50038336

$395,000
07/18/2005

Sold (Public Record)

Public Record #161453174

$400,000

+40.9% / yr

05/25/2005

Pending

METROLIST #50038336

05/13/2005

Listed (Active)

METROLIST #50038336

$399,950
03/04/2004

Sold (Public Record)

Public Record #130461532

$250,000
03/04/2004

Sold

RESFAR #30067440

$250,000
03/04/2004

Sold

METROLIST #30067440

$250,000
01/20/2004

Pending

RESFAR #30067440

01/20/2004

Pending

METROLIST #30067440

For completeness, Compass often displays two records for one sale: the MLS record and the public record.

Public Records for 2045 Celeste Drive

Taxable ValueLand$49,250Additions$129,293Total$178,543
Tax Record2025$1,973 ($164 / month)
Home Facts
Baths1Total Finished SqFt1,474 SqFtAbove Grade Finished SqFt1,474 SqFtStories1Lot Size6,969 SqFtStyleMulti-Family Dwelling (2-4)Year Built1967CountySTANISLAUSAPN066-019-008-000

Schools near 2045 Celeste Drive

This home is within Sylvan Union Elementary School District.
Rating
School
Type
Grades
Distance
Public - K to 5
Public - 6 to 8
Public - 9 to 12
Public - 9 to 12
Rating
School
Distance
Coleman F. Brown Elementary School
PublicK to 5

Daniel J. Savage Middle School
Public6 to 8

Fred C. Beyer High School
Public9 to 12

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

Similar Sold Homes

2045 Celeste Drive is a multi-family home for sale in Modesto, CA 95355. This property was listed for sale on February 1, 2026 by Dream Chasers Realty, it's currently listed at $535,000. It has been on the market for a total of 2 days and was last sold on January 25, 2013. This listing's school districts are Sylvan Union Elementary School District, Modesto City High School District. Nearby schools include Coleman F. Brown Elementary School, Daniel J. Savage Middle School and Fred C. Beyer High School. 2045 Celeste Drive is a 4-bed, 2-bath, 1,552 sqft multi-family home built in 1967.

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of descriptions or measurements (including square footage measurements and property condition), such should be independently verified, and Compass, Inc., its subsidiaries, affiliates and their agents and associated third parties expressly disclaims any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the discretion of the seller. No financial or legal advice provided. Equal Housing Opportunity.

Listing Courtesy of Dream Chasers Realty, Robyn Brown, DRE #01493255

1. The following are terms of a legal agreement between you, the person viewing and/or using this Internet site (“User”) and the operator ("Provider") of this Internet site ("Site"), By accessing, browsing and/or using this Site, User acknowledges that User has read, understood, and agrees to be bound by these terms and to comply with all applicable laws and regulations, including but not limited to U.S. export and re-export control laws and regulations. If User does not agree to these terms, User is not authorized to use this Site. The material provided on this Site is protected by law, including, but not limited to, United States Copyright law and international treaties. 2. User must be a prospective purchaser or seller of real estate with a bona fide interest in the purchase or sale of such real estate. 3. All real estate data and other informational content provided on this Site (including but not limited to descriptions, images, and other information constituting or relating to real estate listings) is strictly for the personal, private, non-commercial use of User and is not made available for redistribution, retransmission, reformatting, modification or copying. User may not sell or use any of the real estate data on this Site for any purpose other than attempting to evaluate houses or properties for sale or purchase by User. User acknowledges that the real estate data and other informational content on this Site is provided by MetroList Services, Inc., a California corporation (“MetroList”), and User acknowledges the validity of MetroList's copyright as to such data. User expressly acknowledges and agrees that MetroList is a third-party beneficiary of these Terms of Use, and that MetroList will be entitled to enforce these Terms of Use against User. 4. To the fullest extent permitted by law, the data on this Site is provided "as is," without warranty or representation of any kind, either express or implied, as to the nature, quality, characteristics or value of any property or information to which the data pertains. NEITHER PROVIDER NOR METROLIST MAKES ANY WARRANTIES, EXPRESS OR IMPLIED, REGARDING THE DATA DISPLAYED ON THIS SITE, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE, OR AS TO THE TIMELINESS, ACCURACY AND/OR COMPLETENESS OF THE DATA. 5. NEITHER PROVIDER NOR METROLIST SHALL BE LIABLE FOR ANY INCIDENTAL, SPECIAL, CONSEQUENTIAL, INDIRECT, SPECIAL, PUNITIVE OR EXEMPLARY DAMAGES WHATSOEVER (INCLUDING WITHOUT LIMITATION, DAMAGES FOR LOSS OF BUSINESS INFORMATION, LOSS OF DATA, LOST PROFITS, LOSS OF CUSTOMERS OR OTHER PECUNIARY LOSS), ARISING OUT OF THE USE OR INABILITY TO USE THE DATA DISPLAYED ON THIS SITE, WHETHER THE CLAIM OR CAUSE OF ACTION ARISES IN TORT, CONTRACT, NEGLIGENCE, STRICT LIABILITY OR UNDER ANY OTHER LEGAL THEORY. 6. User agrees that the prevailing party or parties in any action brought to enforce or for breach of these Terms of Use shall be entitled to recover, in addition to any other relief, that party’s or those parties’ reasonable attorney’s fees and court costs incurred in such action from the non-prevailing party or parties.