FBpixel

Get More Info

Print A Flyer

Get A Home Loan

Share

2045 2047 Celeste Dr

Modesto, CA 95355

Copy Link Get Directions

$535,000

4 bd
  |  
2 ba
  |  
1,552 sq ft
  |  
0.17 acre

2045 2047 Celeste Dr

Modesto, CA 95355

Get Directions
Listed On: 02/04/2026
Status: Active
Listing Number: 226013535 (Metrolist MLS)

Schedule a Tour

Contact Info


Presented By:

London Properties, Ltd.
London Properties, Ltd. 559.436.4071 Email Agent
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.
Property Type
Residential Income
Property Subtype 1
Duplex
Subtype Description
Townhouses
Property Condition
Updated/Remodeled
Year Built
1967
Year Built Source
Assessor Auto-Fill
Stories
1
# of Buildings
1
Total Units
2
# of Floors
1
Levels
One
Signs
No
Directions to Property
N Oakdale rd to Celeste , turn left on Celeste. Property on the right side
Cross Street
Sage
County
Stanislaus
Special Listing Conditions
None
Construction Materials
Stucco
Foundation
Raised
Roof
Composition
Heating
Central
Cooling
Ceiling Fan(s), Central
Laundry Features
In Each Unit, Laundry Closet, Washer/Dryer Hookups
Window Features
Dual Pane Full
Interior Features
Storage Area(s)
Flooring
Carpet, Tile, Laminate, Wood
Appliances
Built-In Gas Range, Dishwasher, Microwave, Disposal
Exterior Features
Fenced Yard, Yard Space
Total Units
2
# of 2 Bedroom Units
2
# of 2 Bedrooms Occupied
2
Units Furnished
None
Unit 1 # of Rooms
4
Unit 1 Approx SqFt
751
Unit 1 SqFt Source
Appraiser
Unit 1 Bedrooms
2
Unit 1 Full Baths
1
Unit 1 Rent
1565
Unit 1 Rent Source
Rental
Unit 1 Occupancy
Tenant
Unit 1 Lease Term
Other
Unit 2 Approx SqFt
751
Unit 2 SqFt Source
Appraiser
Unit 2 Bedrooms
2
Unit 2 Full Baths
1
Unit 2 Rent
1750
Unit 2 Rent Source
Rental
Unit 2 Occupancy
Tenant
Unit 2 Lease Term
Other
Utilities
Sewer In & Connected
Irrigation
None
Water Source
Meter on Site, Public
Sewer
Public Sewer
Separate Meters
Electricity, Gas
Energy Efficient
Windows
Parking Features
Attached, Carport
Total Parking Spaces
4.00
Carport Spaces
2.00
Open Parking Spaces
2.00
Lot Features
Garden
APN
066 019 008 000
Zoning Description
R2
List AOR
MetroList Services, Inc.
Association
No
School District (County)
Stanislaus
Elementary School District
Modesto City
Middle or Junior School District
Modesto City
Senior High School District
Modesto City
Total # Leasable
2
Total # Owner Occupied
2
Income Includes
Rent Only
Actual or Scheduled
Actual
2 Bedroom Annual Occupancy
100
Tenant Pays
Cable TV, Electricity, Gas, Grounds Care, Trash Collection
Lease Term
Other
Census Tract
9.10

Courtesy of Robyn Brown, Dream Chasers Realty
IDX provided by Reliance Marketing

Metrolist
Terms of Use

The data relating to real estate for sale on this web site comes in part from the Internet Data eXchange (IDX) of the Multiple Listing Service. Real estate listings are marked with the IDX logo and detailed information about them includes the name of the listing broker and the name of the listing agent. The information being provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumer may be interested in purchasing. Information herein deemed reliable but not guaranteed, representations are approximate, individual verification recommended.

Copyright © 2026  London Properties, Ltd. All rights reserved.