Welcome to this Rose Gate Executive home. Experience the comfort and convenience of single story living in this beautifully maintained 4 bedroom, 2.5 bath home offering 2740 square feet of thoughtfully designed living space on an approximately 7000 square-foot lot. Built in 2017, this exceptional home blends modern style with a spacious, open floor plan that's perfect for both everyday living and entertaining. The heart of the home features an inviting open concept with generous living and dining spaces that flow seamlessly into the well appointed kitchen, offering ample cabinetry, abundant counter space, and an ideal gathering place for family and friends. The spacious primary suite provides a private retreat, while three additional bedrooms offer flexibility for guests, a home office, or multigenerational living. Step outside to a backyard ready for relaxing, entertaining, or creating your own oasis. As an added benefit, the Seller is including the refrigerator, multiple wall-mounted TVS with mounts, and programed Shark Vacuum making this truly move-in ready. The home is also prewired for Solar, providing the opportunity for future energy efficiency. Ideally located just minutes from parks, shopping, dining, and Lodi's renowned wine country, this home offers the perfect blend of comfort, convenience, and location.
Active
Price cut: $30K (8/17)
$949,950
3045 Celebration Dr, Lodi, CA 95242
4beds
2,740sqft
Single Family Residence
Built in 2017
7,000 Square Feet Lot
$935,000 Zestimate®
$347/sqft
$-- HOA
What's special
Single story livingModern styleAmple cabinetrySpacious open floor planAbundant counter spaceWell appointed kitchen
- 71 days
- 658
- 22
Zillow last checked:
Listing updated:
Listed by:
Joann Bear DRE #01304736 209-606-7020,
Core Four Realty
Source: MetroList Services of CA,MLS#: 226095679Originating MLS: MetroList Services, Inc.
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 3
- Full bathrooms: 2
- Partial bathrooms: 1
Dining room
- Features: Formal Area
Kitchen
- Features: Quartz Counter, Granite Counters, Island w/Sink
Heating
- Central
Cooling
- Ceiling Fan(s), Central Air
Appliances
- Included: Free-Standing Refrigerator, Range Hood, Dishwasher, Disposal
- Laundry: Cabinets, Sink, Hookups Only, Inside, Inside Room
Features
- Flooring: Carpet, Tile, Wood
- Has fireplace: No
Interior area
- Total interior livable area: 2,740 sqft
Video & virtual tour
Property
Parking
- Total spaces: 3
- Parking features: Attached
- Attached garage spaces: 3
Features
- Levels: One
- Stories: 1
- Exterior features: Uncovered Courtyard
- Fencing: Back Yard
Lot
- Size: 7,000 Square Feet
- Features: Landscape Back, Landscape Front
- Topography: Lot Grade Varies,Lot Grade Varies
Details
- Additional structures: Pergola
- Parcel number: 029560690000
- Zoning: SFR
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence
Materials
- Frame
- Foundation: Slab
- Roof: Cement
Condition
- Year built: 2017
Utilities & green energy
- Electric: 220 Volts in Laundry
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Public
Community & HOA
Location
- Region: Lodi
Financial & listing details
- Price per square foot: $347/sqft
- Tax assessed value: $782,424
- Price range: $950K - $950K
- Date on market: 7/30/2026
Estimated market value
$935,000
$888,000 - $982,000
$3,340/mo
Price history
| Date | Event | Price |
|---|---|---|
| 8/17/2026 | Price change | $949,950-3.1%$347/sqft |
Source: MetroList Services of CA #226095679 Report a problem | ||
| 7/30/2026 | Listed for sale | $979,950+48.3%$358/sqft |
Source: SFAR #226095679 Report a problem | ||
| 6/19/2017 | Sold | $661,000$241/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2026 | -- | $782,424 +2% |
| 2025 | $8,913 +2.8% | $767,083 +2% |
| 2024 | $8,674 +1.2% | $752,043 +2% |
| 2023 | $8,569 +2.2% | $737,298 +2% |
| 2022 | $8,380 -1.5% | $722,842 +2% |
| 2021 | $8,511 +2.6% | $708,669 +1% |
| 2020 | $8,293 +2.1% | $701,403 +2% |
| 2019 | $8,126 +1.6% | $687,651 +2% |
| 2018 | $7,999 +73.2% | $674,169 +82.3% |
| 2017 | $4,619 +436% | $369,901 +360.7% |
| 2016 | $862 | $80,295 +29.8% |
| 2015 | -- | $61,841 |
Find assessor info on the county website
Monthly payment
Est. payment






