$1,299,950

Estimated payment $7,475/month

Total Views 3,487
5 Beds
3.5 Baths
2,776 Sq Ft
$468 Price per Sq Ft

Highlights

  • Popular Property
  • RV Access or Parking
  • Sitting Area In Primary Bedroom
  • Guest House
  • Two Primary Bedrooms
  • 4-minute walk to Emerson Park

About This Home

Welcome to 333 W Locust Street-A beautiful home that seamlessly blends turn-of-the-century elegance w/ modern luxury. Fresh off a high-end renovation completed in 2023. Main home 5-bdrm, 3.5 ba home spans 3,205 sq/ft + ADU 1 bdrm, 1 ba 429sq/ft, sits in one of Lodi's most desirable historic neighborhoods. Whether you envision a thriving short-term rental, a cozy bed & breakfast(lic. in place), or a grand family residence, this property offers the flexibility to suit your dreams. Main-Level Elegance: Bright, open layout uniting the living room, great room & dining area. Gourmet kitchen with 6-burner stove, dual ovens, wine fridge, & stainless-steel appliances. Primary suite with ensuite bath+second bedroom/bonus room w/convenient half bath. Second-Floor Comfort: An expansive Primary suite with private bath and bonus room (office, nursery, or extra bedroom). Two additional bedrooms, each with its own full bath - privacy for guests or family Outdoor Retreat & ADU: Large front porch and expansive backyard patio for relaxation and entertainment. Electric gated driveway (EV charger included)+spacious basement for storage. 429 sq. ft. detached ADU/Studio/Granny Flat: Ideal rental income, in-laws, or a private home office-featuring a modern kitchen, luxury bath, and laundry hook-up.

Listing Agent

Ryan Sherman

Sherman & Associates RE License #01410123 Listed on: 02/07/2026

Home Details

Home Type

  • Single Family

Year Built

  • Built in 1907 | Remodeled

Lot Details

  • 0.3 Acre Lot
  • Southeast Facing Home
  • Front and Back Yard Sprinklers
  • Back Yard Fenced and Front Yard

Parking

  • 1 Car Garage
  • 1 Carport Space
  • Electric Vehicle Home Charger
  • Alley Access
  • Guest Parking
  • RV Access or Parking

Home Design

  • Custom Home
  • Victorian Architecture
  • Brick Exterior Construction
  • Raised Foundation
  • Slab Foundation
  • Composition Roof
  • Wood Siding
  • Lap Siding
  • Marble or Granite Building Materials
  • Stucco

Interior Spaces

  • 2,776 Sq Ft Home
  • 2-Story Property
  • Wet Bar
  • Ceiling Fan
  • Self Contained Fireplace Unit Or Insert
  • Electric Fireplace
  • Gas Fireplace
  • Double Pane Windows
  • Formal Entry
  • Family Room with Fireplace
  • 2 Fireplaces
  • Great Room
  • Formal Dining Room
  • Home Office
  • Storage Room
  • Downtown Views
  • Partial Basement
  • Attic Fan

Kitchen

  • Breakfast Room
  • Walk-In Pantry
  • Double Oven
  • Free-Standing Gas Oven
  • Free-Standing Gas Range
  • Range Hood
  • Microwave
  • Plumbed For Ice Maker
  • Dishwasher
  • Wine Refrigerator
  • Kitchen Island
  • Granite Countertops
  • Quartz Countertops
  • Butcher Block Countertops
  • Disposal

Flooring

  • Wood
  • Parquet
  • Carpet
  • Laminate
  • Tile

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Sitting Area In Primary Bedroom
  • Retreat
  • Primary Bedroom on Main
  • Primary Bedroom Upstairs
  • Double Master Bedroom
  • Walk-In Closet
  • Jack-and-Jill Bathroom
  • In-Law or Guest Suite
  • Quartz Bathroom Countertops
  • Tile Bathroom Countertop
  • Low Flow Toliet
  • Bathtub with Shower
  • Separate Shower
  • Low Flow Shower
  • Window or Skylight in Bathroom

Laundry

  • Laundry Room
  • Laundry on main level
  • Washer
  • Sink Near Laundry
  • 220 Volts In Laundry

Home Security

  • Security System Owned
  • Carbon Monoxide Detectors
  • Fire and Smoke Detector

Outdoor Features

  • Patio
  • Fire Pit
  • Front Porch

Additional Homes

  • Guest House

Utilities

  • Multiple cooling system units
  • Central Heating and Cooling System
  • Cooling System Mounted In Outer Wall Opening
  • 220 Volts
  • 220 Volts in Kitchen
  • Natural Gas Connected
  • Water Filtration System
  • Gas Water Heater
  • Cable TV Available

Community Details

  • No Home Owners Association

Listing and Financial Details

  • Assessor Parcel Number 037-260-17

Home Details

Home Type

Single Family

Year Built

Built in 1907 | Remodeled

Lot Details

0.3 Acres

Parking

1

Listing Details

  • Property Type: Residential
  • Subtype Description: Custom
  • Property Subtype 1: Single Family Residence
  • Remodeled Updated: Yes
  • Stories: 2
  • Year Built: 1907
  • Architectural Style: Victorian
  • Remodeled/Updated Desc: Bath 0-5YR, Kitchen 0-5YR, Bed 0-5YR, Other-Rmks 0-5YR
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Appliances: Free Standing Gas Range, Free Standing Refrigerator, Gas Plumbed, Gas Water Heater, Hood Over Range, Dishwasher, Disposal, Microwave, Double Oven, Plumbed For Ice Maker, Wine Refrigerator, Free Standing Gas Oven
  • Interior Amenities: Storage Area(s), Formal Entry, Wet Bar
  • Other Equipment: Attic Fan(s), Water Filter System
  • Fireplace Features: Insert, Living Room, Electric, Family Room, Gas Piped
  • Fireplaces: 2
  • Flooring: Carpet, Laminate, Tile, Wood, Parquet
  • Master Bathroom Features: Shower Stall(s), Low-Flow Shower(s), Low-Flow Toilet(s), Tile, Marble, Tub w/Shower Over, Quartz, Window
  • Master Bedroom Features: Sitting Room, Closet, Ground Floor, Walk-In Closet, Sitting Area
  • Total Bathrooms: 4
  • Bathroom Features: Shower Stall(s), Jack & Jill, Tile, Low-Flow Shower(s), Low-Flow Toilet(s), Tub w/Shower Over, Marble, Window, Quartz
  • Basement: Partial
  • Dining Room Features: Breakfast Nook, Formal Room, Space in Kitchen, Dining/Living Combo
  • Family Room Features: Great Room, View
  • Kitchen Features: Breakfast Area, Breakfast Room, Butcher Block Counters, Pantry Cabinet, Pantry Closet, Quartz Counter, Granite Counter, Slab Counter, Island
  • Living Room Features: Great Room, View
  • Room Type: Master Bedrooms 2+, Office, Dining Room, Family Room, Storage, Guest Quarters, In Law Apartment, Kitchen, Laundry, Living Room
  • Main Level: Bedroom(s), Living Room, Dining Room, Master Bedroom, Full Bath(s), Partial Bath(s), Kitchen, Street Entrance
  • Price Per Square Foot: 468.28
  • Square Footage: 2776.00
  • Window Features: Dual Pane Partial

Exterior Features

  • Other Structures: Guest House
  • Construction Materials: Brick, Stucco, Lap Siding, Wood Siding
  • Property Faces: Southeast
  • Disclosures/Documents: See Remarks, Preliminary Title Report
  • Exterior Features: Built-In Barbeque, Fire Pit
  • Fencing: Back Yard, Front Yard
  • Foundation: Raised, Slab
  • Home Warranty: No
  • Horse Property: No
  • Listing Price: 1299950.00
  • Lot Features: Auto Sprinkler Front, Auto Sprinkler Rear
  • New Construction: No
  • Patio And Porch Features: Front Porch, Uncovered Patio
  • Pool: No
  • Property Condition: Updated/Remodeled
  • Roof: Composition
  • Spa: No
  • View Description: City, Downtown
  • Land Use: Residential
  • Second Unit Kitchen: Yes

Garage/Parking

  • Carport Spaces: 1.00
  • Garage Spaces: 1.00
  • Parking Features: Alley Access, RV Possible, Detached, Guest Parking Available

Utilities

  • Security: Carbon Mon Detector, Double Strapped Water Heater, Security System Owned, Fire Extinguisher, Smoke Detector, Video System
  • Sewer: Public Sewer
  • Utilities: Cable Available, Public, Sewer In & Connected, Electric, Natural Gas Connected
  • Cooling: Ceiling Fan(s), Central, Wall Unit(s), MultiUnits
  • Electric: 220 Volts, 220 Volts in Kitchen, 220 Volts in Laundry
  • Heating: Central, Fireplace(s), Gas
  • Laundry Features: Sink, Electric, Space For Frzr/Refr, Ground Floor, Washer Included, Inside Room
  • Water Source: Meter Required, Public

Condo/Co-op/Association

  • Association: No
  • Senior Community: No

Fee Information

  • Land Lease: No

Schools

  • Senior High School District: Lodi Unified

Lot Info

  • Zoning: RES
  • Current Use: Vacation Rental
  • Irrigation: None
  • Lot Size Acres: 0.2980
  • Lot Size Sq Ft: 12981.00

Multi Family

  • Unit 2 Partial Bathrooms: 0
  • Unit 2 Description: ADU
  • Unit 2 Occupied: Yes
  • Unit 2 Type: Detached

Tax Info

  • Assessor Parcel Number: 037-260-17
  • Bonds/Assessments/Taxes Description: Local Assessments
  • Bonds/Assessments/Taxes: Yes

MLS Schools

  • School District (County): San Joaquin

Map

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $9,423 $868,734 $260,100 $608,634
2024 $9,166 $851,700 $255,000 $596,700
2023 $5,444 $501,979 $169,556 $332,423
2022 $5,323 $492,137 $166,232 $325,905
2021 $5,419 $482,488 $162,973 $319,515
2020 $5,278 $477,541 $161,302 $316,239
2019 $5,172 $468,179 $158,140 $310,039
2018 $5,100 $443,700 $155,040 $288,660
2017 $4,820 $435,000 $152,000 $283,000
2016 $3,712 $350,028 $87,507 $262,521
2014 $3,607 $336,600 $101,200 $235,400
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
02/07/2026 02/07/26 For Sale $1,299,950 +55.7% $468 / Sq Ft
01/04/2023 01/04/23 Sold $835,000 -16.4% $261 / Sq Ft View Prior Sale
12/05/2022 12/05/22 Pending -- -- --
11/14/2022 11/14/22 Price Changed $999,000 -13.1% $312 / Sq Ft
10/24/2022 10/24/22 Price Changed $1,149,000 0.0% $359 / Sq Ft
10/24/2022 10/24/22 For Sale $1,149,000 -4.2% $359 / Sq Ft
10/13/2022 10/13/22 Pending -- -- --
09/15/2022 09/15/22 For Sale $1,199,000 +43.6% $374 / Sq Ft
08/31/2022 08/31/22 Off Market $835,000 -- --
08/23/2022 08/23/22 For Sale $1,199,000 +43.6% $374 / Sq Ft
08/23/2022 08/23/22 Off Market $835,000 -- --
12/01/2016 12/01/16 Sold $435,000 -1.0% $157 / Sq Ft View Prior Sale
10/25/2016 10/25/16 Pending -- -- --
09/01/2016 09/01/16 For Sale $439,500 -- $158 / Sq Ft
Source: MetroList

Purchase History

Date Type Sale Price Title Company
Grant Deed -- --
Deed -- Chicago Title
Grant Deed $835,000 Chicago Title
Interfamily Deed Transfer -- None Available
Grant Deed $435,000 Chicago Title Company
Interfamily Deed Transfer -- --
Quit Claim Deed -- --
Interfamily Deed Transfer -- --
Grant Deed $275,000 Old Republic Title Company
Grant Deed $220,000 Chicago Title Co
Trustee Deed -- --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $626,250 New Conventional
Closed $626,250 No Value Available
Previous Owner $391,500 New Conventional
Previous Owner $200,000 No Value Available
Previous Owner $198,000 No Value Available
Source: Public Records

Source: MetroList

MLS Number: 226014710

MetroList

APN: 037-260-17

Your Personal Tour Guide

Ask me questions while you tour the home.