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.
Closed
$590,000
1924 Celeste Ct, Modesto, CA 95355
2beds
2,292sqft
Multi Family, Single Family Residence
Built in 1969
9,587.56 Square Feet Lot
$584,700 Zestimate®
$257/sqft
$1,711 Estimated rent
Home value
$584,700
$526,000 - $649,000
$1,711/mo
Zestimate® history
Loading...
Owner options
List your home for rent
$1,711/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
Learn more$1,711/mo
Rent Zestimate®
Refinance and save
$3,637/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
See today's rates$3,637/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Zillow last checked: 7 hours ago
Listing updated: August 04, 2025 at 04:08pm
Listed by:
Kimberly Roberts DRE #02172672 209-620-4139,
EXIT Realty Consultants
Bought with:
Kimberly Roberts, DRE #02172672
EXIT Realty Consultants
Source: MetroList Services of CA,MLS#: 225086799Originating MLS: MetroList Services, Inc.
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 sqft
- 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 & neighborhood
Location
- Region: Modesto
Other
Other facts
- Road surface type: Asphalt
Price history
| Date | Event | Price |
|---|---|---|
| 8/4/2025 | Sold | $590,000+7.3%$257/sqft |
Source: MetroList Services of CA #225086799 Report a problem | ||
| 7/10/2025 | Pending sale | $549,900$240/sqft |
Source: MetroList Services of CA #225086799 Report a problem | ||
| 7/3/2025 | Listed for sale | $549,900+134%$240/sqft |
Source: MetroList Services of CA #225086799 Report a problem | ||
| 6/7/2013 | Sold | $235,000$103/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $3,198 +1.8% | $289,375 +2% |
| 2024 | $3,140 +1.9% | $283,702 +2% |
| 2023 | $3,080 +4.2% | $278,140 +2% |
Find assessor info on the county website
Neighborhood: 95355
Nearby schools
GreatSchools rating
- 4/10Coleman F. Brown Elementary SchoolGrades: K-5Distance: 0.5 mi
- 7/10Somerset Middle SchoolGrades: 6-8Distance: 1.8 mi
- 6/10Fred C. Beyer High SchoolGrades: 9-12Distance: 1.3 mi
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$584,700
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$584,700
- California
- Stanislaus County
- Modesto
- 95355
- 1924 Celeste Ct