Investors check out this New build, no updating required!! Beautifully designed duplex, 3-bedroom, 2-bath per side , zero-entry ranch homes with separate utilities, separate tax parcels, top quality construction. Step inside to vaulted ceilings, luxury vinyl plank flooring, and a cozy electric fireplace that creates an inviting living space. The split-bedroom layout provides added privacy. The kitchen features custom hickory cabinetry with soft-close hinges and full drawer extensions, quartz countertops, tile backsplash, and great workspace for entertaining. The spacious primary suite includes a double vanity, tiled walk-in shower with rain head, and oversized walk-in closet. The insulated 3-car garage includes floor drains. Dining area opens to a low-maintenance composite deck overlooking the level 0.49-acre corner lot. Full basement with 2 egress windows per side, offers excellent future expansion potential.
New construction
$1,105,000
638 Sunset & 217 Dl, Lodi, WI 53555
6beds
3,288sqft
Duplex
Built in 2026
-- sqft lot
$-- Zestimate®
$336/sqft
$-- HOA
What's special
Quartz countertopsSplit-bedroom layoutOversized walk-in closetTile backsplashVaulted ceilingsCozy electric fireplaceLow-maintenance composite deck
- 2 days |
- 120 |
- 2 |
Zillow last checked:
Listing updated:
Listed by:
Barry Bodendein,
First Weber Inc
Source: SCWMLS,MLS#: 2027210
Loading...
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 6
- Bathrooms: 4
- Full bathrooms: 4
Heating
- Natural Gas, Forced Air, Individual Heat Control (Unit 1), Individual Heat Control (Unit 2)
Cooling
- Air Conditioning (Unit 1), Air Conditioning (Unit 2)
Appliances
- Included: Range/Oven (Unit 1), Refrigerator (Unit 1), Dishwasher (Unit 1), Range/Oven (Unit 2), Refrigerator (Unit 2), Dishwasher (Unit 2), Water Softener Owned
- Laundry: In Unit (Unit 1), In Unit (Unit 2)
Features
- Internet -Fiber Available, Family/Rec Room (Unit 1), Dining Room (Unit 1), Fireplace (Unit 1), Primary bedroom bath, Vaulted Ceiling(s) (Unit 1), Pantry ((Unit 1), Private basement, Family/Rec Room (Unit 2), Dining Room (Unit 2), Fireplace (Unit 2), Vaulted Ceiling(s) (Unit 2), Pantry ((Unit 2)
- Flooring: Wood or Simulated Wood (Unit 1)
- Windows: Low Emissivity Windows
- Basement: Full,Full size windows/Exposed,Sump Pump,Radon Mitigation System,Unfinished
- Number of fireplaces: 2
Interior area
- Total structure area: 3,288
- Total interior livable area: 3,288 sqft
Property
Parking
- Total spaces: 12
- Parking features: 2 stall garage, Attached, Garage Door Opener, Concrete
- Attached garage spaces: 4
- Details: Outside
Features
- Levels: One
- Patio & porch: Balcony/Patio (Unit 2)
Lot
- Size: 0.49 Acres
Details
- Parcel number: 11246770.902
- Zoning: R-3
Construction
Type & style
- Home type: MultiFamily
- Property subtype: Duplex
Materials
- Vinyl Siding, Engineered Wood
- Foundation: Poured concrete foundatn
Condition
- New Construction
- New construction: Yes
- Year built: 2026
Details
- Warranty included: Yes
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Separate elec meters, Separate gas meters, Separate water meters
Green energy
- Energy efficient items: Appliances, Low VOC Materials
Community & HOA
Community
- Subdivision: Ridgestone Estates
Location
- Region: Lodi
Financial & listing details
- Price per square foot: $336/sqft
- Tax assessed value: $129,900
- Annual tax amount: $1,963
- Date on market: 7/2/2026
- Inclusions: 2 refrigerators, 2 stoves, dishwashers, 2micro-hoods, 2 water softeners
- Exclusions: sellers personal property
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 7/2/2026 | Listed for sale | $1,105,000$336/sqft |
Source: SCWMLS #2027210 Report a problem | ||
Public tax history
Tax history is unavailable.
Monthly payment
Est. payment$--/mo
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
Climate risks
Neighborhood: 53555
Nearby schools
GreatSchools rating
- NALodi Primary SchoolGrades: PK-2Distance: 0.5 mi
- 9/10Lodi Middle SchoolGrades: 6-8Distance: 0.3 mi
- 9/10Lodi High SchoolGrades: 9-12Distance: 0.2 mi
Schools provided by the listing agent
- Elementary: Lodi
- Middle: Lodi
- High: Lodi
- District: Lodi
Source: SCWMLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
A local agent can set up tours, give advice and negotiate with sellers.
A local lender can help you make sure your offer is ready when you are.
- Wisconsin
- Columbia County
- Lodi
- 53555
- 638 Sunset & 217 Dl




