Skip main navigation
Closed
  • $540,000

    2047-2045 Celeste Dr, Modesto, CA 95355

    4beds
    1,552sqft
    Duplex
    Built in 1967
    -- sqft lot
    $538,100 Zestimate®
    $348/sqft
    $2,149 Estimated rent

    Home value

    $538,100

    $490,000 - $592,000

    $2,149/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $2,149/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

    $2,149/mo

    Rent Zestimate®

    Refinance and save

    $3,384/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,384/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 started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    Fresh interior paintGranite countertopsStylish lighting fixturesDual-pane windows
    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.

    Zillow last checked:

    Listing updated:

    Listed by:

    Robyn Brown DRE #01493255 209-603-6886,

    Dream Chasers Realty

    Bought with:

    Malina Dunning Guerrero, DRE #02196010

    Barrios Realty Consultants

    Source: MetroList Services of CA,MLS#: 226013535Originating MLS: MetroList Services, Inc.

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 4
    • Bathrooms: 2
    • Full bathrooms: 2
    Heating
    • Central
    Cooling
    • Ceiling Fan(s), Central Air
    Appliances
    • Included: Built-In Gas Range, Dishwasher, Microwave, Disposal
    • Laundry: In Unit, Laundry Closet, Washer/Dryer Hookups
    Features
    • Flooring: Carpet, Tile, Laminate, Wood
    • Has fireplace: No
    Interior area
    • Total structure area: 0
    • Total interior livable area: 1,552 sqft

    Property

    Parking
    • Total spaces: 4
    • Parking features: Attached, Carport
    • Carport spaces: 2
    • Uncovered spaces: 2
    Features
    • Levels: One
    • Stories: 1
    • Exterior features: Yard Space
    • Fencing: Fenced
    Lot
    • Size: 7,326 Square Feet
    • Features: Garden
    Details
    • Parcel number: 066019008000
    • Zoning: R2
    • Special conditions: Standard

    Construction

    Type & style
    • Home type: MultiFamily
    • Property subtype: Duplex
    Materials
    • Stucco
    • Foundation: Raised
    • Roof: Composition
    Condition
    • Year built: 1967

    Utilities & green energy

    • Sewer: Public Sewer
    • Water: Meter on Site, Public
    • Utilities for property: Sewer In & Connected

    Community & HOA

    Location
    • Region: Modesto

    Financial & listing details

    • Price per square foot: $348/sqft
    • Date on market: 2/5/2026
    • Tenant pays: Cable TV, Electricity, Gas, Grounds Care, Trash Collection
    • Income includes: Rent Only

    Price history

    DateEventPrice
    4/10/2026Sold$540,000+0.9%$348/sqft
    Source: MetroList Services of CA #226013535 Report a problem
    3/24/2026Pending sale$535,000$345/sqft
    Source: MetroList Services of CA #226013535 Report a problem
    2/19/2026Price change$535,000+3.9%$345/sqft
    Source: MetroList Services of CA #226013535 Report a problem
    2/10/2026Pending sale$515,000$332/sqft
    Source: MetroList Services of CA #226013535 Report a problem
    2/5/2026Listed for sale$515,000$332/sqft
    Source: MetroList Services of CA #226013535 Report a problem

    Public tax history

    Tax history is unavailable.

    Neighborhood: 95355

    Nearby schools

    GreatSchools rating
    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
    $538,100
    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
    $538,100