Skip main navigation
Active
  • $2,250,000

    15800 N Tretheway Rd, Lodi, CA 95240

    3beds
    3,737sqft
    : 
    $14,582/mo
    Get pre-qualified
    Single Family Residence
    Built in 2018
    10 Acres Lot
    $2,121,100 Zestimate®
    $602/sqft
    $-- HOA

    What's special

    Private gated entranceExquisite finishesGourmet kitchenWolf and sub-zero appliancesExpansive drivewayElegant lightingSoaring ceilings
    Beauty and brains? It's possible! Discover this stunning custom estate in Lodi's enchanting countryside, where a cherry orchard becomes your everyday backdrop. Beyond the private gated entrance, an expansive driveway leads to grand entry doors welcoming you into a home where modern sophistication meets warmth and comfort. Soaring ceilings, exquisite finishes, and thoughtful design set the stage for something extraordinary. The gourmet kitchen impresses with Wolf and Sub-Zero appliances, breathtaking Mont Blanc quartzite countertops, a striking center island and elegant lighting. The dining room frames spectacular sunsets through expansive picture windows, while a magnificent crystal chandelier casts vibrant rainbow reflections throughout the surrounding spaces. The primary suite is a private retreat offering generous space, peaceful orchard views, and a luxurious bathroom featuring floor-to-ceiling tile, a glass-enclosed double shower, and a freestanding MTI soaking tub beneath a breathtaking crystal light fixture. Two additional junior suites are thoughtfully designed with private bathrooms featuring beautiful quartz accents and refined tilework, offering exceptional comfort and privacy.A beautifully appointed officeand media room features premium cabinetry, quartz countertops, and inspiring views. A spacious mudroom with a charming barn door provides convenient access near the breezeway connecting the home to the impressive finished shop. And the shop you've been dreaming about? It's already here! Featuring 3 oversized roll-up doors, RV and sewer hookups, plumbed air lines, a full bathroom, and a 10x5 tack room. Equestrian amenities include a 24x12 paddock area with heavy-duty metal fencing, a drive-through gate, and a horse shelter with feeder and mats. Outdoor living is just as captivating! The California room flows beautifully into the outdoor kitchen, creating the perfect setting for entertaining. A stunning saltwater pool with clean architectural lines and an elegant sheer-descent waterfall invites you to unwind and enjoy peaceful evenings beneath the stars. Set on approximately 10 acres, with 8 acres currently leased for cherry farming, this estate also features owned solar and the tranquility of country living. Here, luxury is not just about beautiful finishes; it's about having the space, privacy, and freedom to enjoy life at your own pace. More than a property... Beauty, brains, and a lifestyle to match. This estate truly has it all.
    23 days
    3,701
    293

    Zillow last checked:

    Listing updated:

    Listed by:

    Adriana Tenbrink DRE #01907061 209-747-8814,

    Real Brokerage Technologies

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

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 3
      • Bathrooms: 4
      • Full bathrooms: 3
      • Partial bathrooms: 1
      Rooms
      • Room types: Office, Storage, Kitchen, Laundry, Living Room
      Primary bedroom
      • Features: Sound System, Walk-In Closet, Outside Access, Sitting Area
      Primary bathroom
      • Features: Shower Stall(s), Soaking Tub, Tile, Walk-In Closet(s), Quartz, Window
      Dining room
      • Features: Breakfast Nook, Space in Kitchen, Formal Area
      Kitchen
      • Features: Breakfast Area, Quartz Counter, Kitchen Island
      Heating
      • Propane, Central, Fireplace(s)
      Cooling
      • Ceiling Fan(s), Central Air, Whole House Fan
      Appliances
      • Included: Gas Cooktop, Dishwasher, Disposal, Microwave, Double Oven
      • Laundry: Laundry Room, Cabinets, Space For Frzr/Refr, Inside Room
      Features
      • Central Vacuum
      • Flooring: Carpet, Tile
      • Number of fireplaces: 1
      • Fireplace features: Stone, Wood Burning
      Interior area
      • Total interior livable area: 3,737 sqft

      Property

      Parking
      • Total spaces: 5
      • Parking features: 24'+ Deep Garage, Attached, Boat, RV Access/Parking, RV Garage Detached, Garage Faces Side, Guest, Workshop in Garage, Driveway, Gated
      • Attached garage spaces: 3
      • Carport spaces: 2
      • Has uncovered spaces: Yes
      Features
      • Exterior features: Outdoor Kitchen, Outdoor Grill, Dog Run
      • Has private pool: Yes
      • Pool features: In Ground, Salt Water
      • Fencing: Metal,Partial,Gated Driveway/Sidewalks
      Lot
      • Size: 10 Acres
      • Features: Auto Sprinkler F&R, Landscaped
      • Topography: Level,Trees Many,Level,Trees Many
      Details
      • Additional structures: RV/Boat Storage, Workshop
      • Parcel number: 051200130000
      • Zoning: AG-40AG-40AG-40AG-40
      • Special conditions: Standard
      • Other equipment: Water Filter System
      • Horses can be raised: Yes
      • Horse amenities: Paddocks, Pens, Tack Room

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Contemporary
      • Property subtype: Single Family Residence
      Materials
      • Metal, Stone, Stucco, Frame, Wood
      • Foundation: Slab
      • Roof: Metal
      Condition
      • Year built: 2018

      Utilities & green energy

      • Electric: Battery Backup, 220 Volts in Laundry
      • Sewer: Septic System
      • Water: Well
      • Utilities for property: Public, Internet Available, Solar, Propane Tank Leased
      Green energy
      • Energy generation: Solar

      Community & HOA

      Location
      • Region: Lodi

      Financial & listing details

      • Price per square foot: $602/sqft
      • Tax assessed value: $1,193,441
      • Price range: $2.3M - $2.3M
      • Date on market: 10/15/2026

        Estimated market value

        $2,121,100

        $2.02M - $2.23M

        $4,155/mo

        Price history

        DateEventPrice
        10/15/2026Listed for sale$2,250,000+552.2%$602/sqft
        Source: MetroList Services of CA #226127565 Report a problem
        7/14/2017Sold$345,000$92/sqft
        Source: MetroList Services of CA #17030819 Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2026-- $1,193,441 +2%
        2025$13,546 +3.5%$1,170,041 +2%
        2024$13,087 +1.3%$1,147,100 +2%
        2023$12,916 +4.8%$1,124,608 +4.8%
        2022$12,327 +1.7%$1,073,146 +2%
        2021$12,116 +2.6%$1,052,105 +1%
        2020$11,807 +5.5%$1,041,318 +5.6%
        2019$11,190 +190.7%$985,900 +185.8%
        2018$3,849 +192.1%$345,000 +195.7%
        2017$1,318 +6.6%$116,684 +2%
        2016$1,236 +2.6%$114,396 +1.5%
        2015$1,205 $112,679
        Find assessor info on the county website

        Monthly payment

        Est. payment

        Payment breakdown

        Explore the cost of this home by adjusting the details. Changes won't be saved.
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        See how much you could borrow to make a competitive offer.

        Climate risks

        Neighborhood: 95240

        Getting around

        7 / 100
        Car-Dependent
        26 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating

        A local agent can set up tours, give advice and negotiate with sellers.

        Browse local experts