---
listing_id: ME226110888
status: Active
price: 859500
beds: 4
baths_full: 2
baths_half: 0
sqft_living: 3233
sqft_lot: 7623
lot_acres: 
year_built: 
property_type: Residential
property_subtype: Single Family Residence
address: "823 W Lodi Ave"
city: Lodi
state: CA
zip: 95240
county: "San Joaquin County"
lat: 38.1302326
lng: -121.2833254
days_on_market: 1
hoa_fee: 
hoa_frequency: 
garage_spaces: 2
list_agent: "Stephanie Ceja"
list_office: "Residential Group"
list_agent_phone: "(209) 481-2384"
list_agent_license: 01996884
mls_source: REMTRO
modified: 2026-09-03
transaction_type: buy
---

Home | San Joaquin County | Lodi | 95240 | 823 W Lodi Ave

823 W Lodi Ave, Lodi, CA 95240

MLS: ME226110888 | Status: Active | Price: $859,500
Beds/Baths: 4 / 2
Property Type: Residential

Quick Facts

Beds Baths Sq Ft Sq Ft Lot Yr Built
4 2 3,233 7,623

Upcoming Open Houses

Date Time Hosted By
Friday, September 4 4:30 pm - 7:30 pm

Remarks

Step into timeless character and modern comfort with this stunning 1930s Tudor Revival, where classic architecture meets beautifully updated living. This 4-bedroom, 2-bath home is filled with distinctive details, including a dramatic living room with soaring vaulted wood ceilings, exposed beams, rich hardwood floors, and an impressive floor-to-ceiling brick fireplace. The beautifully updated kitchen offers a fresh, sophisticated design with a charming breakfast nook, while the formal dining room provides the perfect setting for gatherings and entertaining. A finished basement adds valuable additional living space with flexibility for a media room, game room, gym, or whatever fits your lifestyle. Outside, the detached garage features a loft above, creating an incredible opportunity for a home office, studio, creative space, or additional flex space. With four bedrooms and multiple versatile spaces throughout, this home offers truly endless possibilities. Thoughtfully updated while preserving the beauty of its 1930s design, this is a truly special home that offers timeless style and endless possibilities.

MLS Listing Information

Field Value
MLS # ME226110888
MLS Source MetroList Services, Inc.
Days on Site 1

Features

Interior Features

Feature Details
Bathrooms Updated Bath(s)
Kitchen Updated
Appliances Dishwasher, Oven Range - Built-In, Gas
Dining Room Breakfast Nook, Formal Dining Room
Fireplace Living Room
Flooring Carpet, Tile, Wood
Laundry In Closet
Cooling Ceiling Fan, Central Forced Air
Heating Central Forced Air, Fireplace

Exterior Features

Feature Details
Roof Shingle
Foundation Raised
Pool Pool - No
Style Tudor

Parking, School, and Other Information

Feature Details
Garage/Parking Detached, Garage: 2 Car(s)
Elementary District Lodi Unified
High School District Lodi Unified
Sewer Public Sewer
Water Public
Zoning R

Contact Information

Stephanie Ceja
Residential Group
License #: 01996884
Phone: (209) 481-2384

Property Units

# Buildings # Leased Units # Total Units
0

School Ratings

School data provided by GreatSchools.org

Nearby Schools

School Type Grades Distance Rating
Liberty High School public 9-12 0.12 mi 2
Clyde W. Needham Elementary School public K-6 0.43 mi 7
Lodi High School public 9-12 0.53 mi 6
George Washington Elementary School public K-6 0.63 mi 7
Lodi Middle School public 7-8 0.67 mi 4
Vinewood Elementary School public K-6 0.68 mi 8
Erma B. Reese Elementary School public K-6 0.77 mi 6
Leroy Nichols Elementary School public K-6 0.93 mi 4
Millswood Middle School public 7-8 1.01 mi 4
Lakewood Elementary School public K-6 1.13 mi 6
Heritage Elementary School public K-6 1.15 mi 4
Lawrence Elementary School public K-6 1.23 mi 5
Lodi Adult public UG 1.25 mi N/A
Tokay High School public 9-12 1.45 mi 5
Woodbridge School public K-6 1.73 mi 4
Beckman Elementary School public K-6 1.76 mi 5
Lois E. Borchardt Elementary School public K-6 2.03 mi 4
Ellerth E. Larson Elementary School public K-6 2.11 mi 6
Independence School public K-12 2.55 mi 5
Henderson School public 7-8 2.55 mi N/A

Nearby Homes

Address Price Beds Baths Sq Ft Status
2227 Heavenly Way $780,000 4 3 2,892 Active
18432 Ironstone St $710,000 4 3 2,681 Active
3087 Wisteria Drive $689,950 3 2 2,155 Active
2920 La Jolla Way $739,950 4 2 2,232 Active

Disclosures

©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 September 03, 2026. For the most current information, please contact Stephanie Ceja, (209) 481-2384.