Home | San Joaquin County | Lodi | 95242 | 507 Gerard Dr
MLS: ME226059182 | Status: Active | Price: $499,000
Beds/Baths: 3 / 2
Property Type: Residential
| Beds | Baths | Sq Ft | Sq Ft Lot | Yr Built |
|---|---|---|---|---|
| 3 | 2 | 1,380 | 6,599 | – |
Welcome home to this beautifully updated 3-bedroom, 2-bath residence nestled in an established Lodi neighborhood. Thoughtfully refreshed with today's buyer in mind, this move-in ready home features a new roof, fresh exterior paint, updated lighting, stylish flooring, a beautifully remodeled kitchen, and tastefully renovated bathrooms. The inviting floor plan offers approximately 1,380 square feet of comfortable living space, including the convenience of an interior laundry room. Whether you're enjoying quiet evenings at home or entertaining family and friends, this home offers the perfect blend of comfort and functionality. Ideally located just minutes from shopping, dining, parks, and everyday amenities, you'll appreciate both the charm of the neighborhood and the convenience of the location. This is a wonderful opportunity to enjoy all that Lodi has to offer.
| Field | Value |
|---|---|
| MLS # | ME226059182 |
| MLS Source | MetroList Services, Inc. |
| Days on Site | 8 |
| Feature | Details |
|---|---|
| Bathrooms | Updated Bath(s) |
| Kitchen | Countertop - Stone, Updated |
| Dining Room | In Kitchen |
| Fireplace | Living Room |
| Flooring | Laminate, Tile |
| Laundry | In Laundry Room |
| Cooling | Central Forced Air |
| Heating | Central Forced Air |
| Feature | Details |
|---|---|
| Roof | Composition |
| Foundation | Raised |
| Pool | Pool - No |
| Feature | Details |
|---|---|
| Garage/Parking | Attached Garage, Garage: 2 Car(s) |
| Elementary District | Lodi Unified |
| High School District | Lodi Unified |
| Sewer | Public Sewer |
| Water | Public |
| Zoning | SFR |
Christina Brogna
PMZ Real Estate
License #: 01885113
Phone: (209) 565-7121
| # 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.25 mi | 7 |
| Lakewood Elementary School | public | K-6 | 0.45 mi | 6 |
| Erma B. Reese Elementary School | public | K-6 | 0.47 mi | 6 |
| Lodi High School | public | 9-12 | 0.52 mi | 6 |
| Millswood Middle School | public | 7-8 | 0.57 mi | 4 |
| Liberty High School | public | 9-12 | 0.77 mi | 2 |
| Woodbridge School | public | K-6 | 0.99 mi | 4 |
| Vinewood Elementary School | public | K-6 | 1.03 mi | 8 |
| Clyde W. Needham Elementary School | public | K-6 | 1.11 mi | 7 |
| Lawrence Elementary School | public | K-6 | 1.23 mi | 5 |
| Lodi Middle School | public | 7-8 | 1.27 mi | 4 |
| Lodi Adult | public | UG | 1.63 mi | N/A |
| Leroy Nichols Elementary School | public | K-6 | 1.65 mi | 4 |
| Heritage Elementary School | public | K-6 | 1.69 mi | 4 |
| Tokay High School | public | 9-12 | 2.14 mi | 5 |
| Beckman Elementary School | public | K-6 | 2.47 mi | 5 |
| Ellerth E. Larson Elementary School | public | K-6 | 2.61 mi | 6 |
| Lois E. Borchardt Elementary School | public | K-6 | 2.80 mi | 4 |
| Houston School | public | K-8 | 2.81 mi | N/A |
| Independence School | public | K-12 | 2.98 mi | 5 |
| Address | Price | Beds | Baths | Sq Ft | Status |
|---|---|---|---|---|---|
| 2708 Chardonnay Ln | $579,900 | 3 | 2 | 1,595 | Active |
| 2403 Tejon St | $499,999 | 5 | 3 | 1,416 | Active |
| 2664 Ponderosa Dr | $570,000 | 3 | 2 | 1,675 | Active |
| 1901 W Locust St | $464,950 | 3 | 1/1 | 1,088 | 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 June 25, 2026. For the most current information, please contact Christina Brogna, (209) 565-7121.