Home | San Joaquin County | Lodi | 95240 | 823 W Lodi Ave
MLS: ME226110888 | Status: Active | Price: $859,500
Beds/Baths: 4 / 2
Property Type: Residential
| Beds | Baths | Sq Ft | Sq Ft Lot | Yr Built |
|---|---|---|---|---|
| 4 | 2 | 3,233 | 7,623 | – |
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.
| Field | Value |
|---|---|
| MLS # | ME226110888 |
| MLS Source | MetroList Services, Inc. |
| Days on Site | 3 |
| 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 |
| Feature | Details |
|---|---|
| Roof | Shingle |
| Foundation | Raised |
| Pool | Pool - No |
| Style | Tudor |
| 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 |
Stephanie Ceja
Residential Group
License #: 01996884
Phone: (209) 481-2384
| # Buildings | # Leased Units | # Total Units |
|---|---|---|
| 0 | – | – |
School data provided by GreatSchools.org
| 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 |
| Valley Robotics Academy | public | K-12 | 2.55 mi | 4 |
| Independence School | public | K-12 | 2.55 mi | 5 |
| Address | Price | Beds | Baths | Sq Ft | Status |
|---|---|---|---|---|---|
| 113 Solera Dr | $693,990 | 3 | 2 | 1,917 | Active |
| 1827 Tulip Ct | $774,900 | 3 | 3 | 2,279 | Active |
| 1116 Bridgetowne Dr | $930,000 | 3 | 2 | 2,715 | Active |
| 97 Bodega Dr | $725,000 | 3 | 2/1 | 2,046 | 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 September 05, 2026. For the most current information, please contact Stephanie Ceja, (209) 481-2384.