Property Attributes
- ID#226055796
- TypeSingle Family
- Listing Status Active
- CountySAN JOAQUIN
- CityLodi
- AreaLodi
- NeighborhoodClairmont
- Zip95242
- StyleSingle Family Residence
- Year Built2004
- Price$ 769,000
- Bedrooms4
- Full Bathrooms3
- Half Bathrooms0
- Sqr Footage2892
- Lot Size0.1929 Acres
Data Source:
MetroList MLS
Property Description
70k in professional updates in 2025! Premium lot with gorgeous newer updates including energy efficient new glass panes throughout, a whole house fan, tankless water heater and newer HVAC, ideally situated on an expansive 8,400 sq ft corner lot at the entrance to a cul-de-sac. The property features stunning custom stamped concrete and landscaping with ambient lighting, creating exceptional curb appeal both day and night. Step inside to a thoughtfully refreshed kitchen showcasing newer quartz countertops, stylish tile backsplash, KitchenAid stainless steel appliances, a farmhouse sink, custom range hood, and freshly painted cabinetry with added drawers for enhanced functionality. The home offers both separate living and family rooms, filled with abundant natural light and complemented by elegant plantation shutters. The inviting family room features a newer gas fireplace insert, accented by beautiful stonework at the hearth and built-in TV cabinet. Need a bedroom downstairs? Just add a closet to the guest room. There's already a full bath downstairs. Additional conveniences include a laundry room with sink, garage sink, and ample built-in garage cabinetry/shelving for storage. Designed for entertaining, the backyard is a true retreat with a covered built-in BBQ and eating bar with TV, fire pit with stone/concrete bench seating, and extensive custom stamped concrete across the driveway and patios. There's a 3-car garage too! Conveniently located near Larson Elementary, Debenedetti Park, as well as shopping and dining, this home offers the perfect blend of comfort, style, and location. See amenities list for more amazing features.
| Price History | |
|---|---|
| 5/4/2026 | Listed $799,000 |
| 8/27/2026 | 3$780,000 |
| 9/9/2026 | 2$769,000 |
General Features
| Sewer | Public Sewer |
|---|---|
| Heating | Central,Gas |
| Cooling | Ceiling Fan(s),Central,Whole House Fan |
| Utilities | Public,Electric,Natural Gas Connected |
| Roof | Tile |
| Appliances | Built-In Electric Oven,Free Standing Refrigerator,Gas Cook Top,Hood Over Range,Dishwasher,Disposal,Microwave,Double Oven,Tankless Water Heater |
| Garage Spaces | 3.0 |
| Patio/Porch Features | Uncovered Patio |
| Construction Materials | Frame |
| Year Built | 2004 |
| Electric | 220 Volts in Laundry |
| Stories Count | 2 |
| Property Subtype | Single Family Residence |
| County | San Joaquin |
| Property Type | Residential |
| HOA | No |
| Energy Efficient | Appliances,Water Heater,Windows |
| Subdivision Name | Clairmont |
| Other Structures | Pergola |
| Full Baths | 3 |
| Close Price | 0.0 |
| Status | Active |
| Directions | Century Boulevard,south on Heavenly Way,home is on the right. |
| City | Lodi |
| Senior Community Y/N | No |
| High School District | Lodi Unified |
| Zoning Description | SFR |
| Open Parking Spaces | 0.0 |
| MLS Area | 20901 |
| Lot Size Square Feet | 8403.0 |
| Carport Spaces | 0.0 |
| Home Warranty Y/N | No |
| Standard Status | Active |
| Middle/Junior School District | Lodi Unified |
| Elementary School District | Lodi Unified |
| Year Built Source | Assessor Auto-Fill |
Interior Features
| Flooring | Carpet,Luxury Vinyl Plank |
|---|---|
| Total Fireplaces | 1 |
| Fireplace Features | Insert,Family Room,Gas Log |
| Window Features | Dual Pane Full,Low E Glass Full |
| Laundry Features | Dryer Included,Sink,Washer Included,Inside Room |
| Total Bedrooms | 4 |
| LivingAreaSource | Assessor Auto-Fill |
| Kitchen Features | Breakfast Area,Pantry Cabinet,Quartz Counter,Island w/Sink,Kitchen/Family Combo |
| Total Baths | 3 |
| Bedrooms Possible | 5 |
| Primary Bathroom Features | Shower Stall(s),Double Sinks,Soaking Tub |
| Living Room Features | Other |
| Dining Room Features | Breakfast Nook,Formal Room,Dining Bar,Dining/Family Combo,Dining/Living Combo |
| Primary Bedroom Features | Walk-In Closet 2+ |
| Family Room Features | Other |
| RoomBathsOtherFeatures | Shower Stall(s),Double Sinks,Tub w/Shower Over |
Exterior Features
| Exterior Amenities | Built-In Barbeque,Fire Pit |
|---|---|
| Fencing | Back Yard |
| Parking Features | Attached |
| Lot Features | Auto Sprinkler F&R,Corner |
| Water Source | Meter on Site |
| Total Parking | 0.0 |
| Foundation Details | Slab |
| Spa | No |
| Lot Size Acres | 0.1929 |
| Private Pool | No |
| Lot Size Source | Assessor Auto-Fill |
| Other Equipment | Water Cond Equipment Owned |
| Horse Y/N | No |
Amenities
- Foreclosure
- Views
- Short Sale
- New Construction
- Adult 55+
- Lease To Own
- No HOA Fees
- Furnished
- Primary On Main
- Air Conditioning
- Seller Finance
- Green
- Fixer Upper
- Horse
- Golf
- Fireplace
- Deck
- Garage
- Basement
- Pool
All measurements and all calculations of area are approximate. Information provided by Seller/Other sources, not verified by Broker. All interested persons should independently verify accuracy of information. Provided properties may or may not be listed by the office/agent presenting the information. Data maintained by MetroList© may not reflect all real estate activity in the market.
All real estate content on this site is subject to the Federal Fair Housing Act of 1968, as amended, which makes it illegal to advertise any preference, limitation or discrimination because of race, color, religion, sex, handicap, family status or national origin or an intention to make any such preference, limitation or discrimination.
MetroList CA data last updated: September 12, 2026 8:28 PM UTC
Bay East ©2026. CCAR ©2026. bridgeMLS ©2026. Information Deemed Reliable But Not Guaranteed. This information is being provided by the Bay East MLS, or CCAR MLS, or bridgeMLS. The listings presented here may or may not be listed by the Broker/Agent operating this website. This information is intended for the personal use of consumers and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Data last updated at September