Seize a rare opportunity to own TWO distinct homes on a single lot, ideally situated in the heart of vibrant Downtown Woodstock! 8175 Main Street is a premier location, directly across from prestigious Adair Park, with its restaurants, shops and luxury flats. This dual-living property, perfect for multi-generational living, business, entertaining, or extended stay guests offers exceptional flexibility as well as investment opportunity. The primary residence, originally an historic home constructed in 1948, was masterfully reimagined by owner/designer and her team of architects in 2022 into a stunning residence which retains some of the original timeless charm and character, blended with modern luxury and cutting-edge upgrades. This property was uniquely curated to combine CHARM, LUXURY, CONVENIENCE, OUTDOOR LIVING and ENTERTAINING as its key components. The home boasts a chef's dream kitchen anchored by a breathtaking 12 foot island adorned with a gorgeous Brazilian Quartz, also featured in the backsplash and wet bar in the living area. Entertain effortlessly with a spacious oversized butler pantry, indoor wet bar, and flowing open floor plan. The living area off kitchen is centered around a cozy fire place and has three sets of french doors leading to the show-stopping outdoor oasis poolside. The custom designed pool features a tanning ledge and a unique swim ledge that curves along the water's edge. Outdoor living takes center stage with an outdoor covered kitchen featuring a smoker, oversized gas grill, Blackstone griddle, gourmet pizza oven , dishwasher, two beverage refrigerators and an ice machine, all surrounding a large entertainment area with a cozy outdoor fireplace. There is also a "DJ Balcony" perched above the entertaining space, ready for the party! The main home has wide corridors leading to each of the three bedrooms, perfectly positioned each with its own 'wing" for peace and privacy. A beautifully appointed second residence is located directly behind the poolside oasis, featuring three private bedrooms, one on the main level and two on the secondary level, a split bedroom plan for privacy. The main level features an expansive 6-car garage, which can also be used as indoor event space, an EV charging station, a set up for a second laundry, a dog shower, a private sitting porch ,a custom putting green, and a large detached tool/equipment shed. The second story comprises an open floorplan, kitchenette, dining area, living room, two bedrooms ( one with a balcony overlooking pool with views of downtown, currently used as office space), a full bath and generous closet space throughout. Lovely landscaping, outdoor lighting, a large yard for PETS, a commercial grade security system with AV closet, and a charming front sitting porch overlooking downtown add to the charm and appeal of this special downtown property. Experience all the perks of downtown Woodstock living as you walk to restaurants, spas, shopping, the summer concerts in the park, and outdoor events. Experience life without the hassles and restrictions of HOAs and management fees! This extraordinary property is a rare find--two residences, thoughtfully designed for comfort, entertaining and luxurious everyday living in one of Woodstock's most desirable locations.
Active
$3,999,900
8175 Main St, Woodstock, GA 30188
6beds
--sqft
Est.:
Single Family Residence, Residential
Built in 2022
0.55 Acres Lot
$3,997,000 Zestimate®
$--/sqft
$-- HOA
What's special
- 13 days
- on Zillow |
- 1,033 |
- 53 |
Zillow last checked: 7 hours ago
Listing updated: April 17, 2025 at 12:26pm
Listing Provided by:
Cheryl Melis,
Better Homes GA Properties , LLC.,
ELIZABETH YANCEY,
Better Homes GA Properties , LLC.
Source: FMLS GA,MLS#: 7559247

Travel times
Tour with a buyer’s agent
Tour with a buyer’s agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 6
- Bathrooms: 5
- Full bathrooms: 4
- 1/2 bathrooms: 1
- Main level bathrooms: 3
- Main level bedrooms: 4
Rooms
- Room types: Workshop
Primary bedroom
- Features: Master on Main, Oversized Master
- Level: Master on Main, Oversized Master
Bedroom
- Features: Master on Main, Oversized Master
Primary bathroom
- Features: Double Shower, Double Vanity
Dining room
- Features: Seats 12+, Separate Dining Room
Kitchen
- Features: Cabinets Stain, Kitchen Island, Pantry Walk-In, Stone Counters
Heating
- Central
Cooling
- Ceiling Fan(s), Central Air
Appliances
- Included: Dishwasher, Double Oven, Gas Range, Refrigerator
- Laundry: In Hall, Laundry Room, Main Level
Features
- Crown Molding, High Speed Internet, His and Hers Closets, Recessed Lighting, Sound System, Walk-In Closet(s), Wet Bar
- Flooring: Hardwood, Stone
- Windows: Insulated Windows
- Basement: None
- Number of fireplaces: 2
- Fireplace features: Family Room, Outside
- Common walls with other units/homes: No Common Walls
Interior area
- Total structure area: 0
Video & virtual tour
Property
Parking
- Total spaces: 6
- Parking features: Garage, Garage Faces Side
- Garage spaces: 6
Accessibility
- Accessibility features: None
Features
- Levels: One
- Stories: 1
- Patio & porch: Covered, Front Porch, Patio, Rear Porch
- Exterior features: Gas Grill, Lighting, Private Yard, Storage
- Pool features: Gunite, In Ground
- Spa features: Community, None
- Fencing: Back Yard,Privacy,Wood
- Has view: Yes
- View description: City
- Waterfront features: None
- Body of water: None
Lot
- Size: 0.55 Acres
- Dimensions: 100x240
- Features: Back Yard, Front Yard, Landscaped, Level
Details
- Additional structures: Workshop
- Parcel number: 92N02 030 A
- Special conditions: Standard
- Other equipment: None
- Horse amenities: None
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Modern,Ranch
- Property subtype: Single Family Residence, Residential
Materials
- Brick 3 Sides, HardiPlank Type
- Foundation: Brick/Mortar
- Roof: Composition
Condition
- Resale
- New construction: No
- Year built: 2022
Utilities & green energy
- Electric: 220 Volts, 220 Volts in Garage
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Cable Available, Electricity Available, Natural Gas Available, Phone Available, Sewer Available, Water Available
Green energy
- Energy efficient items: Insulation, Windows
- Energy generation: None
Community & HOA
Community
- Features: Curbs, Dog Park, Near Schools, Near Shopping, Near Trails/Greenway, Park, Restaurant, Sidewalks, Street Lights, Other
- Security: Closed Circuit Camera(s), Security System Owned, Smoke Detector(s)
- Subdivision: Downtown Woodstock
HOA
- Has HOA: No
Location
- Region: Woodstock
Financial & listing details
- Tax assessed value: $423,720
- Annual tax amount: $3,093
- Date on market: 4/13/2025
- Electric utility on property: Yes
- Road surface type: Asphalt
- Loading
- Loading