Home | San Joaquin County | Lodi | 95240 | 333 W Locust St
MLS: ME226014710 | Status: Active | Price: $1,249,950
Beds/Baths: 5 / 3 /1
Property Type: Residential
| Beds | Baths | Sq Ft | Acres Lot | Yr Built |
|---|---|---|---|---|
| 5 | 3 /1 | 2,776 | 0.298 | – |
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.
| Field | Value |
|---|---|
| MLS # | ME226014710 |
| MLS Source | MetroList Services, Inc. |
| Days on Site | 75 |
| Feature | Details |
|---|---|
| Bedrooms | Primary Suite/Retreat - 2+, Remodeled |
| Bathrooms | Updated Bath(s) |
| Kitchen | 220 Volt Outlet, Breakfast Bar, Breakfast Nook, Breakfast Room, Countertop - Concrete, Countertop - Granite, Countertop - Other, Hookups - Gas, Hookups - Ice Maker, Island, Other, Pantry, Pantry Cabinet, Updated |
| Appliances | Built-in BBQ Grill, Dishwasher, Garbage Disposal, Hood Over Range, Microwave, Other, Oven - Double, Oven - Gas, Oven Range - Gas, Refrigerator, Wine Refrigerator, Washer |
| Dining Room | Breakfast Nook, Dining Area in Living Room, Formal Dining Room, In Kitchen, Other |
| Family Room | Kitchen/Family Room Combo, Other, View |
| Fireplace | Electric, Family Room, Gas Piped, Insert, Living Room |
| Flooring | Carpet, Laminate, Parquet, Tile, Wood |
| Laundry | 220 Volt Outlet, Hookup - Electric, In Laundry Room, Laundry - Yes, Space for Frzr/Refr, Tub / Sink |
| Cooling | Ceiling Fan, Central Forced Air, Multi Units, Window/Wall Unit |
| Heating | Central Forced Air, Fireplace, Fireplace Insert, Gas |
| Feature | Details |
|---|---|
| Roof | Composition |
| Foundation | Raised, Slab, Concrete Perimeter and Slab |
| Pool | Pool - No |
| Style | Custom, Victorian |
| Feature | Details |
|---|---|
| Garage/Parking | Access - Alley, Detached, Guest / Visitor Parking, RV Possible, Garage: 1 Car(s) |
| Elementary District | Lodi Unified |
| High School District | Lodi Unified |
| Sewer | Public Sewer |
| Water | Public |
| Zoning | RES |
Ryan Sherman
Sherman & Associates RE
License #: 01410123
Phone: (209) 896-6012
| # Buildings | # Leased Units | # Total Units |
|---|---|---|
| 0 | – | – |
School data provided by GreatSchools.org
| School | Type | Grades | Distance | Rating |
|---|---|---|---|---|
| George Washington Elementary School | public | K-6 | 0.45 mi | 7 |
| Liberty High School | public | 9-12 | 0.47 mi | 2 |
| Clyde W. Needham Elementary School | public | K-6 | 0.59 mi | 7 |
| Lawrence Elementary School | public | K-6 | 0.74 mi | 5 |
| Lodi High School | public | 9-12 | 0.86 mi | 6 |
| Lakewood Elementary School | public | K-6 | 0.87 mi | 6 |
| Lodi Adult | public | UG | 0.93 mi | N/A |
| Erma B. Reese Elementary School | public | K-6 | 0.95 mi | 6 |
| Heritage Elementary School | public | K-6 | 1.01 mi | 4 |
| Millswood Middle School | public | 7-8 | 1.17 mi | 4 |
| Vinewood Elementary School | public | K-6 | 1.22 mi | 8 |
| Lodi Middle School | public | 7-8 | 1.22 mi | 4 |
| Leroy Nichols Elementary School | public | K-6 | 1.45 mi | 4 |
| Woodbridge School | public | K-6 | 1.66 mi | 4 |
| Tokay High School | public | 9-12 | 1.90 mi | 5 |
| Beckman Elementary School | public | K-6 | 2.30 mi | 5 |
| Lois E. Borchardt Elementary School | public | K-6 | 2.33 mi | 4 |
| Ellerth E. Larson Elementary School | public | K-6 | 2.62 mi | 6 |
| Houston School | public | K-8 | 2.72 mi | N/A |
| Independence School | public | K-12 | 3.12 mi | 5 |
| Address | Price | Beds | Baths | Sq Ft | Status |
|---|---|---|---|---|---|
| 2948 E Woodbridge Rd | $1,139,000 | 2 | 2 | 1,618 | Active |
| 1483 Centennial Dr | $1,089,000 | 3 | 2/1 | 2,655 | Active |
| 119 South Avena Ave | $1,200,000 | 3 | 2/1 | 3,376 | PendingDoNotShow |
| 838 Virginia Ave | $1,149,000 | 4 | 4/1 | 3,840 | Active |
©2026 MetroList Services, Inc. All rights reserved. All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Information provided is for personal, non-commercial use by the viewer and may not be redistributed without explicit authorization from MetroList Services, Inc.
Presently MLSListings.com displays Active, Contingent, Pending, and Recently Sold listings. Recently Sold listings are properties which were sold within the last three years. After that period listings are no longer displayed in MLSListings.com. Pending listings are properties under contract and no longer available for sale. Contingent listings are properties where there is an accepted offer, and seller may be seeking back-up offers. Active listings are available for sale.
This listing information is up-to-date as of April 08, 2026. For the most current information, please contact Ryan Sherman, (209) 896-6012.