2047-2045 Celeste Dr
Modesto, CA 95355
- 4 Beds
- 2 Baths
- 1,552 sqft
$540,000
Last Sold: Apr 10, 2026
1% over list $535K
$348/sqft
Est. Refi. Payment $3,261/mo*
$540,000
Last Sold: Apr 10, 2026
1% over list $535K
$348/sqft
Est. Refi. Payment $3,261/mo*
4 Beds
2 Baths
1,552 sqft
Local Information
© Google
-- mins to
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.
This property is off market, which means it's not currently listed for sale or rent on Trulia. This may be different from what's available on other websites or public sources. This description is from April 14, 2026
Home Highlights
Parking
Carport
Outdoor
No Info
A/C
Heating & Cooling
HOA
None
Price/Sqft
$348/sqft
Listed
131 days ago
Home Details for 2047-2045 Celeste Dr
|
|---|
MLS Status: Closed |
|
|---|
Beds & Baths Number of Bedrooms: 4Number of Bathrooms: 2Number of Bathrooms (full): 2 |
Dimensions and Layout Living Area: 1552 Square Feet |
Appliances & Utilities Appliances: Built-In Gas Range, Dishwasher, Microwave, DisposalDishwasherDisposalMicrowave |
Heating & Cooling Heating: CentralHas CoolingAir Conditioning: Ceiling Fan(s),Central AirHas HeatingHeating Fuel: Central |
Fireplace & Spa No Fireplace |
Windows, Doors, Floors & Walls Flooring: Carpet, Tile, Laminate, Wood |
Levels, Entrance, & Accessibility Stories: 1Levels: OneFloors: Carpet, Tile, Laminate, Wood |
|
|---|
Exterior Home Features Roof: CompositionFencing: FencedExterior: Yard Space |
Parking & Garage Has a CarportParking Spaces: 4Parking: Attached,Carport |
|
|---|
Year Built Year Built: 1967 |
Property Type / Style Property Type: Residential IncomeProperty Subtype: Duplex |
Building Construction Materials: Stucco |
|
|---|
Price List Price: $535,000Price Per Sqft: $348/sqft |
|
|---|
Direction & Address City: Modesto |
|
|---|
Association for this Listing: MetroList Services, Inc. |
|
|---|
Lot Area: 7326.792 sqft |
|
|---|
Special Conditions: Standard |
|
|---|
Mobile Home Park Mobile Home Units: Feet |
|
|---|
Expense Tenant Pays: Cable TV, Electricity, Gas, Grounds Care, Trash Collection |
|
|---|
Are Units Furnished: None |
|
|---|
Mls Number: 226013535 |
Last check for updates: about 15 hours ago
Listed by Robyn Brown DRE #01493255, (209) 603-6886
Dream Chasers Realty
Bought with: Malina Dunning Guerrero DRE #02196010, (209) 850-7686, Barrios Realty Consultants
Originating MLS: MetroList Services, Inc.
Source: MetroList Services of CA, MLS#226013535
Price History for 2047-2045 Celeste Dr
| Date | Price | Event | Source |
|---|---|---|---|
| 04/10/2026 | $540,000 | Sold | MetroList Services of CA #226013535 |
| 03/24/2026 | $535,000 | Pending | MetroList Services of CA #226013535 |
| 02/19/2026 | $535,000 | PriceChange | MetroList Services of CA #226013535 |
| 02/10/2026 | $515,000 | Pending | MetroList Services of CA #226013535 |
| 02/05/2026 | $515,000 | Listed For Sale | MetroList Services of CA #226013535 |
Market trends in Modesto
Last updated May 2026
Avg. sale price
$446K
$1.67KMoM
Sale-to-List Price
100.0%
Price per sq ft
$297
$1MoM
Available listings
505
17MoM
Homeowner tools
Estimated monthly rent$1,989/mo
Comparable Sales for 2047-2045 Celeste Dr
Address | Distance | Property Type | Sold Price | Sold Date | Bed | Bath | Sqft |
|---|---|---|---|---|---|---|---|
0.00 | Multi-Family Home | $436,000 | 08/21/25 | 4 | 2 | 1,474 | |
0.35 | Multi-Family Home | $520,000 | 09/30/25 | 4 | 2 | 1,440 | |
0.49 | Multi-Family Home | $575,000 | 04/08/26 | 4 | 2 | 2,098 | |
0.71 | Multi-Family Home | $470,000 | 12/05/25 | 6 | 2 | 2,262 | |
0.47 | Multi-Family Home | $750,000 | 03/24/26 | 6 | 3 | 2,678 | |
0.38 | Multi-Family Home | $565,000 | 06/11/26 | 4 | - | 1,876 | |
0.51 | Multi-Family Home | $820,000 | 07/16/25 | 4 | 6 | 2,580 | |
0.21 | Multi-Family Home | $810,000 | 06/24/25 | 8 | 4 | 3,024 | |
1.05 | Multi-Family Home | $440,000 | 12/12/25 | 4 | 2 | 1,508 |
Nearby homes
Get a sense of prices in the area by checking nearby homes.Assigned Schools
These are the assigned schools for 2047-2045 Celeste Dr.
What Locals Say about Modesto
At least 1786 Trulia users voted on each feature.
84 % Say there are sidewalks
82 % Say car is needed
80 % Say parking is easy
79 % Say yards are well-kept
79 % Say it's dog friendly
74 % Say there's holiday spirit
63 % Say it's walkable to grocery stores
58 % Say streets are well-lit
58 % Say kids play outside
56 % Say it's walkable to restaurants
52 % Say neighbors are friendly
51 % Say they plan to stay for at least 5 years
50 % Say it's quiet
46 % Say people would walk alone at night
24 % Say there are community events
23 % Say there's wildlife
Sourced by Trulia users. Learn more about our methodology.
LGBTQ Local Legal Protections
LGBTQ Local Legal Protections
Apartments for Rent
Explore by feature - Pet Friendly
Explore by feature - Garage
Explore by feature - Air Conditioning
Explore by feature - Pool
Explore by feature - Washer/dryer
Explore by feature - Outdoor Space
Homes for sale near 2047-2045 Celeste Dr
Off Market Homes Near 2047-2045 Celeste Dr
2047-2045 Celeste Dr, Modesto, CA 95355 is a 4 bedroom, 2 bathroom, 1,552 sqft multi-family built in 1967. This property is not currently available for sale. 2047-2045 Celeste Dr was last sold on Apr 10, 2026 for $540,000 (1% higher than the asking price of $535,000). The current Trulia Estimate for 2047-2045 Celeste Dr is $539,900.