Investor's Dream! Charming Triplex on a Corner Lot in Modesto Don't miss this fantastic opportunity to own a well-maintained triplex ideally situated on a desirable corner lot in Modesto. Each of the three units offers 2 spacious bedrooms and 1 full bathroom, full kitchens and indoor laundry providing comfortable living spaces perfect for tenants. Highlights include: Private backyard areas for each unit, offering outdoor space to relax or entertain. Covered parking spaces, ensuring convenience and protection from the elements. Excellent curb appeal on a corner lot, enhancing long-term value and rental desirability. This property is truly an investor's dream, with solid income potential and the flexibility to live in one unit while renting out the others. Close to local schools, shopping, and major commuter routes, it's a turnkey addition to any real estate portfolio.
Pending
$549,900
1924 Celeste Ct, Modesto, CA 95355
2beds
2,292sqft
Est.:
Multi Family, Single Family Residence
Built in 1969
9,587.56 Square Feet Lot
$550,300 Zestimate®
$240/sqft
$-- HOA
What's special
Private backyard areasCorner lotFull kitchensExcellent curb appealCovered parking spacesIndoor laundry
- 13 days
- on Zillow |
- 319 |
- 11 |
Likely to sell faster than
Zillow last checked: 7 hours ago
Listing updated: July 10, 2025 at 03:02pm
Listed by:
DRE #02172672 209-620-4139,
EXIT Realty Consultants
Source: MetroList Services of CA,MLS#: 225086799Originating MLS: MetroList Services, Inc.
Travel times
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 2
- Bathrooms: 1
- Full bathrooms: 1
Dining room
- Features: Breakfast Nook
Kitchen
- Features: Breakfast Area
Heating
- Wall Furnace
Cooling
- Ceiling Fan(s), Wall Unit(s)
Appliances
- Laundry: Hookups Only, In Kitchen
Features
- Flooring: Carpet, Laminate
- Has fireplace: No
Interior area
- Total interior livable area: 2,292 sqft
Property
Parking
- Total spaces: 4
- Parking features: Covered, Detached, Guest, Gated, Driveway
- Garage spaces: 1
- Carport spaces: 3
- Has uncovered spaces: Yes
Features
- Stories: 1
- Fencing: Back Yard,Wood,Front Yard,Gated
Lot
- Size: 9,587.56 Square Feet
- Features: Corner Lot, Court, Curb(s), Curb(s)/Gutter(s), Landscape Front
Details
- Parcel number: 066019033000
- Zoning description: R-3
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Other
- Property subtype: Multi Family, Single Family Residence
- Attached to another structure: Yes
Materials
- Stucco, Wood
- Foundation: Raised
- Roof: Composition
Condition
- Year built: 1969
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Public
Community & HOA
Location
- Region: Modesto
Financial & listing details
- Price per square foot: $240/sqft
- Tax assessed value: $283,702
- Annual tax amount: $3,140
- Price range: $549.9K - $549.9K
- Date on market: 7/3/2025
- Road surface type: Asphalt
- Loading