Nelson Rodriguez
    Nelson Rodriguez
    (770) 925-5105nelson890am@gmail.com
    • Home
    • Search
      • Search Listings
      • Featured Properties
      • Home Valuation
    • Buying
      • Buying Guide
      • Mortgage Calculator
    • Selling
      • Selling Guide
      • Sell Your Home
    • About
      • Meet Nelson
      • Contact
      • Testimonials
    • Nelson Rodriguez(770) 925-5105
      nelson890am@gmail.com
      Copy Email
    • Provident Legacy Realtors Sugar Hill
      740 N Price Rd
      Sugar Hill, GA 30518
      (470) 797-7400
      admin@providentlegacyrealtors.com
      79174

    Company

    • Home
    • Contact
    • Testimonials
    • Get Licensed

    Buying

    • Buying Guide
    • Mortgage Calculator

    Search

    • Featured Properties
    • Home Valuation

    Selling

    • Sell Your Home
    • Selling Guide

    Explore

    • Communities
    Nelson Rodriguez - Footer Logo
    • Office Holidays/Closures
    • Fiduciary Responsibilities
    • Privacy
    • Terms
    • DMCA
    • Accessibility
    • Fair Housing
    © 2025 Provident Legacy Realtors. All rights reserved.
    Website built by CloseHack.
    First Multiple Listing Service, Inc.

    ​ Listings identified with the FMLS IDX logo come from FMLS and are held by brokerage firms other than the owner of this website. The listing brokerage is identified in any listing details. Information is deemed reliable but is not guaranteed. If you believe any FMLS listing contains material that infringes your copyrighted work please click here to review our DMCA policy and learn how to submit a takedown request. © 2022 First Multiple Listing Service, Inc.​

    Georgia MLS

    The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity Program of GAMLS. All real estate listings are marked with the GAMLS Broker Reciprocity thumbnail logo and detailed information about them includes the name of the listing brokers. The broker providing these data believes them to be correct, but advises interested parties to confirm them before relying on them in a purchase decision. Copyright 2023 GAMLS. All rights reserved.

    $3,100,000
    For Sale

    8175 Main Street

    Woodstock, GA 30188
    6 beds | 4.5 baths | 0.55 acres | #7596215
    • Save
    • Contact
    • Share
    • Price Change Alerts
    69 photos
    Type:Purchase
    Structure:House
    Zone:Residential

    Description

    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. Zoned DTRO Woodstock

    • Interior Details
        • InteriorCrown Molding, High Speed Internet, His and Hers Closets, Recessed Lighting, Sound System, Walk-In Closet(s), Wet Bar
        • Fireplaces2
      • Heating & Cooling
        • CoolingCeiling Fan(s), Central Air
        • HeatingCentral
      • Beds & Baths
        • Bathrooms4.5
        • Bedrooms6
        • Full Baths4
        • Half Baths1
        • Bedrooms on Main Level4
    • Property Details
        • Exterior FeaturesGas Grill, Lighting, Private Yard, Storage
        • Exterior MaterialsGas Grill, Lighting, Private Yard, Storage
        • Lot FeaturesBack Yard, Front Yard, Landscaped, Level
        • Lot DescriptionBack Yard, Front Yard, Landscaped, Level
        • Pool FeaturesGunite, In Ground
        • ViewCity
      • Measurements
        • Acres0.55
      • Parking
        • Parking FeaturesGarage, Garage Faces Side
        • Parking TypeGarage
        • Parking Spaces6
    • Construction Details
        • StyleModern, Ranch
        • Property TypePurchase
      • Condition
        • Year Built2022
      • Material information
        • RoofComposition
    • Utilities / Energy Details
        • Utility FeaturesCable Available, Electricity Available, Natural Gas Available, Phone Available, Sewer Available, Water Available
        • AppliancesDishwasher, Double Oven, Gas Range, Refrigerator
        • Sewer InformationPublic Sewer
        • Utility SourcePublic
    • Community and Neighborhood Details
        • Community FeaturesCurbs, Dog Park, Near Schools, Near Shopping, Near Trails/Greenway, Park, Restaurant, Sidewalks, Spa/Hot Tub, Street Lights, Oth
        • SubdivisionDowntown Woodstock
      • Location
        • CountyCherokee - GA
        • Elementary SchoolWoodstock
        • Middle SchoolWoodstock
        • High SchoolWoodstock
    • Financial Details
        • Original List Price$2,999,960
        • Taxes Annual$3,093
    • Other
        • MLS #7596215

    Location

    Legal

    ​ Listings identified with the FMLS IDX logo come from FMLS and are held by brokerage firms other than the owner of this website. The listing brokerage is identified in any listing details. Information is deemed reliable but is not guaranteed. If you believe any FMLS listing contains material that infringes your copyrighted work please click here to review our DMCA policy and learn how to submit a takedown request. © 2022 First Multiple Listing Service, Inc.​

    Last Updated: 09/17/2025 8:18 AM. Source: FMLS

    Provided By
    Listing Agent: Cheryl Melis (#MELIS)
    Listing Office: Better Homes GA Properties , LLC. (#BHGA01)

    Nelson RodriguezReal Estate Group
    Facebook
    Google
    OR

    Interested in Purchasing 8175 Main Street?

    Get an estimate on monthly payments on this property.

    Note: The results shown are estimates only and do not include all factors. Speak with a licensed agent or loan provider for exact details. This tool is sourced from CloseHack.

    Estimated Monthly Payment
    $0.00
    Loan Amount
    $0.00
    $
    years

    Down Payment

    $
    %
    10.0%

    Interest Rate

    %
    6.0%

    Tax Rate

    %
    2.6%
    $
    $
    annually
    $
    monthly