333 W Locust Street

Clicking on links may lead to other third party sites and ads. Visiting those sites or viewing the ads is deemed voluntary by you. LKV Realty, LLC does not endorse the access to or content of those sites.

LKV Realty, LLC is an affiliate of Lakeview Loan Servicing, LLC (“Lakeview”). Lakeview customers are not required to use LKV Realty, LLC and/or any of the third-party products and services. Lakeview Loan Servicing, LLC (“Lakeview”) is located at 4425 Ponce de Leon Blvd., MS 5-251, Coral Gables, FL 33146 and can be reached at 855-294-8564, or on the internet at www.lakeview.com. Lakeview’s NMLS/Unique Identifier number is NMLS #39152. www.nmlsconsumeraccess.org It is the policy of Lakeview to provide services without regard to race, color, religion, national origin, ancestry, age, sex, familial status, physical handicap, disability, or any other prohibited basis. Lakeview is licensed by the Department of Financial Protection and Innovation under the California Residential Mortgage Lending Act (license #4131216). Lakeview is not licensed for lending activities in any U.S. territory. Not authorized to originate loans in the State of New York. Lakeview Loan Servicing, LLC is an Equal Housing Lender.

All information provided within this website is for informational purposes only and does not constitute legal or financial advice. Lakeview and their affiliates make no guarantees as to the accuracy, quality, or completeness of such information, and shall not be responsible or liable for any errors, omissions, or inaccuracies in the information, or for any user’s reliance or the information. Any information made available on this website may change from time to time, and at any time without prior notice. Lakeview does not warrant, and is not responsible for, any affiliate third-party products or services, representations, actions, or omissions.

LKV Realty, LLC is licensed as a real estate brokerage in: Alabama, Arizona, Arkansas, California (license number 2241129), Colorado, Delaware, Florida, Georgia, Idaho, Illinois, Indiana, Iowa, Kansas, Kentucky, Louisiana, Maine, Maryland, Massachusetts, Michigan, Minnesota, Mississippi, Missouri, Nebraska, Nevada, New Hampshire, New Mexico, New York, North Carolina, North Dakota, Ohio, Oklahoma, Oregon, Pennsylvania, Rhode Island, South Carolina, South Dakota, Tennessee, Texas, Utah, Vermont, Virginia, Washington, West Virginia, Wisconsin, and Wyoming.

*Average of $2,150 in rewards is calculated based on the purchase or sale of a home between $400,000 to $449,000. The median home price for all housing types is in the United States is $405,400 as of 2025 as reported by the National Association of Realtors® (NAR). The actual reward amount may vary depending on the purchase or sales price of the home. Please see the Lakeview Home Rewards program terms and conditions for more details. The National Association of Realtors® is a registered trademark of the National Association of Realtors®.

Source: MetroList

All data, content or information on this site, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by the listing broker/agent or MetroList Services, Inc. Information from sources other than the listing broker/agent may be included on this site, and, unless otherwise specified, has not been verified by the listing broker/agent or MetroList Services, Inc. All data, content or information on this site should be independently reviewed and verified for accuracy.

For corrections to this data please contact Brytecore MLS Support.

DSHERMAR

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.

Property Information

Property Details

Location

Address

333 W Locust Street

County

San Joaquin

City

Lodi

Zip Code

95240

School District

Lodi Unified

MLS Area

20901

Interior Features

Beds and Baths

Bedrooms

Full Bathrooms

Building

Building Information

Year Built

1907

Stories

Construction

Brick, Stucco, Lap Siding, Wood Siding

Foundation

Raised, Slab

Roof

Composition

Condition

Updated/Remodeled

Financial

Special Conditions

Offer As Is, None

333 W Locust Street, Lodi, CA 95240

Market Report for 95240