2045 Celeste Drive, Modesto, CA 95355, Modesto, 95355 - 4 bed, 2 bath
Loading property details...
Modesto, CA 95355
This Turn-Key Duplex represents a High-Potential Investment Opportunity for those seeking immediate cash flow or a strategic house-hack. Listed at $535,000, the property is positioned accurately alongside its $529,184 Fair Market Value, reflecting its Good Condition Rating and extensive recent updates. Each unit features Granite Countertops, Dual-Pane Windows, and Private Backyards, ensuring strong rental appeal near Memorial Hospital. Having recently passed city inspections, the asset requires no immediate capital expenditure. This is an ideal acquisition for Owner-Occupants looking to offset mortgage costs or Buy-and-Hold Investors seeking a stabilized asset.
Comparables within 1 miles sold in recently
| Address | Sold Price | Beds | Baths | Sq Ft | $/Sqft | Distance |
|---|---|---|---|---|---|---|
★ 2045 Celeste Drive Subject | $535,000* List Price | 4 | 2 | 1,502 | $352 | - |
A 2117 Celeste Dr Sold | $520,000 | 0 | 0 | 1,440 | $361 | 0.1 mi |
B 1613 E Rumble Road Sold | $470,000 | 4 | 2 | 1,131 | $416 | 0.8 mi |
C 1500 FLOYD Avenue Sold | $575,000 | 2 | 0 | 2,012 | $286 | 0.7 mi |
D 2101 NE Milford Lane Active | $445,000 List Price | 0 | 0 | 1,216 | $366 | 0.1 mi |
* Subject property listed price vs sold prices of comps.
Property is move-in ready.
The property is a 1967 build that has been extensively updated within the last 5-7 years, placing it firmly in the 'good' category. Interior features include granite countertops, updated laminate and tile flooring, dual-pane windows, and fresh paint. The kitchen and bathrooms are modern and functional, and the property is described as turn-key, having recently passed a city rental inspection with no immediate repairs required.
The property is move-in ready with modern updates completed within the last 5-7 years, including granite countertops, dual-pane windows, and updated flooring, eliminating the need for immediate capital expenditures.
The duplex has recently passed the Modesto City annual rental inspection, providing immediate peace of mind for investors and ensuring the property meets local habitability standards.
Unlike many multi-family properties, each unit features its own large private backyard and an enclosed front patio, significantly increasing its appeal to long-term tenants and pet owners.
Lot size discrepancy between mls listing and other public or private record. mls listing lot size in square feet =7327, other record lot size in square feet = 6969. Bedroom count discrepancy between mls listing and other public or private record. mls listing bedroom count = 4, other record bedroom count = 2.
With only one covered carport and one additional parking space available, the property may face challenges accommodating households with multiple drivers or guest parking needs.
At approximately 751 square feet per 2-bedroom unit, the interior living space is relatively small, which may limit appeal for tenants or owners desiring more spacious rooms or extra storage.
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.
No exterior & parking available.
No sensitive facilities data found.
| Feature | Subject | Average Home | Neighborhood Ranking (50 Listings) |
|---|---|---|---|
| Beds | 4.0 | 5.0 | 44% |
| Baths | 2.0 | 3.0 | 44% |
| Square foot | 1,502 | 2,012 | 33% |
| Lot Size | 7,327 | 7,479 | 44% |
| Price | $535.0K | $575.0K | 44% |
| Price per sq ft | $356 | $286 | 67% |
| Built year | 1967 | 1973 | 22% |
| HOA | $0 | $0 | 50% |
| Days on market | 77 | 99 | 22% |
Feb 4, 2026
$535,000
Initial Listing
Jan 25, 2013
$145,000
Public Record
Jul 30, 2012
$112,000
Public Record
Jul 22, 2005
$400,000
Public Record
Mar 4, 2004
$250,000
Public Record