Lyzbet Carolin Castillo Bosque
    Lyzbet Carolin Castillo Bosque
    (754) 308-4188lcastillo@providentlegacyrealtors.com
      • Home
      • Search
        • Search Listings
        • Featured Properties
        • Home Valuation
      • Buying
        • Buying Guide
        • Buy a Home in Hudson County
        • Mortgage Calculator
      • Selling
        • Selling Guide
        • Sell Your Home
      • About
        • Meet Lyzbet
        • Contact
        • Testimonials
      • Lyzbet Carolin Castillo Bosque (754) 308-4188
        lcastillo@providentlegacyrealtors.com
        Copy Email
      • Provident Legacy Realtors
        177 Broadway
        Bayonne, NJ 07002
        (201) 809-9925
        admin@providentlegacyrealtors.com
        1220816
      • Provident Legacy Realtors Sugar Hill
        740 N Price Rd
        Sugar Hill, GA 30518
        (470) 797-7400
        admin@providentlegacyrealtors.com
        79174
      • Provident Legacy Realtors Cliffside Park
        607B Anderson Avenue
        Cliffside Park, NJ 07010
        (201) 809-9923
        admin@providentlegacyrealtors.com
        1220816

      Company

      • Home
      • Contact
      • Testimonials
      • Get Licensed

      Buying

      • Buying Guide
      • Mortgage Calculator

      Search

      • Featured Properties
      • Home Valuation

      Selling

      • Sell Your Home
      • Selling Guide

      Explore

      • Communities
      Lyzbet Carolin Castillo Bosque  - Footer Logo
      • Office Holidays/Closures
      • Fiduciary Responsibilities
      © 2025 Lyzbet Carolin Castillo Bosque . 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.

        $1,999,999
        For Sale

        192 Upshaw Drive

        Alpharetta, GA 30009
        4 beds | 3.5 baths | 0.38 acres | #7690414
        • Save
        • Contact
        • Share
        • Price Change Alerts
        16 photos
        Type:Purchase
        Structure:House
        Zone:Residential

        Description

        Walk to Downtown Alpharetta — Modern European Luxury Meets Everyday Comfort If you’ve been dreaming of living just a 5-minute stroll from everything you love in Downtown Alpharetta, this home is the one you’ve been waiting for. Sitting proudly on a beautifully landscaped corner lot, this nearly new Modern European home is the perfect blend of high-end design, warmth, and everyday livability. From the moment you step inside, the grand vaulted foyer sets the tone. The tongue-and-groove ceiling, custom details, and natural light immediately make the home feel special. Just off the entry is a gorgeous private office with built-ins — the kind of workspace that actually makes working from home enjoyable. The main level is all about effortless living. The primary suite feels like your own retreat, complete with a spa-like bathroom and an oversized two-sided shower. The huge walk-in closet makes organization a breeze, and having the primary on the main level brings a sense of ease to daily life. The heart of the home is the stunning vaulted great room with custom beams and a cozy fireplace. It flows right into the gourmet kitchen, where a massive island, premium appliances, custom cabinetry, and a hidden walk-in pantry make cooking, entertaining, and hosting feel effortless. The dining room adds an elegant touch and includes a stylish bar area that’s perfect for gatherings. Upstairs, there’s space for everyone. Three bright, comfortable bedrooms — including a charming bunk room with its own private bath — plus a flexible loft that can be a playroom, media room, or second office. Two full bathrooms mean no morning traffic jams. And then there’s the outdoor living space. The back porch is built to be enjoyed year-round, with a built-in grill, tons of prep space, and a fireplace that brings cozy charm to every season. The yard has been thoughtfully landscaped for beauty, privacy, and space to play, unwind, or garden. Additional highlights include: Spacious 3-car garage Designer lighting and custom finishes throughout Vaulted ceilings and architectural details that make every room feel elevated Walkable to top-rated Alpharetta Elementary and Innovation Academy STEM High School Stunning curb appeal on a prime corner lot Homes like this — walkable, luxurious, thoughtfully designed, and truly move-in ready — rarely come along in this location. Come see why this one feels like home the moment you walk through the door.

        • Interior Details
            • InteriorBeamed Ceilings, Bookcases, Cathedral Ceiling(s), Crown Molding, Double Vanity, Entrance Foyer 2 Story, High Ceilings 9 ft Upper
            • Fireplaces2
          • Heating & Cooling
            • CoolingCeiling Fan(s), Central Air, Electric, Multi Units
            • HeatingCentral, Electric, Heat Pump
          • Beds & Baths
            • Bathrooms3.5
            • Bedrooms4
            • Full Baths3
            • Half Baths1
            • Bedrooms on Main Level1
        • Property Details
            • Lot FeaturesBack Yard, Corner Lot, Front Yard, Sprinklers In Front, Sprinklers In Rear
            • Lot DescriptionBack Yard, Corner Lot, Front Yard, Sprinklers In Front, Sprinklers In Rear
            • Exterior FeaturesGas Grill, Lighting, Rain Gutters
            • Exterior MaterialsGas Grill, Lighting, Rain Gutters
            • ViewCity
          • Measurements
            • Acres0.3845
          • Parking
            • Parking FeaturesDriveway, Garage, Garage Door Opener, Garage Faces Front, Garage Faces Side, Kitchen Level, Level Driveway
            • Parking TypeDriveway
            • Parking Spaces3
        • Construction Details
            • StyleCraftsman, European, Modern
            • Property TypePurchase
          • Condition
            • Year Built2024
          • Material information
            • RoofMetal, Shingle
        • Utilities / Energy Details
            • AppliancesDishwasher, Disposal, Electric Water Heater, Gas Cooktop, Gas Oven, Microwave, Range Hood, Refrigerator, Self Cleaning Oven
            • Utility FeaturesCable Available, Electricity Available, Natural Gas Available, Sewer Available, Underground Utilities, Water Available
            • Sewer InformationPublic Sewer
            • Utility SourcePublic
        • Community and Neighborhood Details
            • SubdivisionMeadow Brook Hills
          • Location
            • CountyFulton - GA
            • Elementary SchoolAlpharetta
            • High SchoolCambridge
            • Middle SchoolHopewell
        • Financial Details
            • Original List Price$1,999,999
            • Taxes Annual$14,333
        • Other
            • MLS #7690414

        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: RONALD BROWN (#BROWNRON)
        Listing Office: Trend Atlanta Realty, Inc. (#TRND01)

        Lyzbet Carolin Castillo Bosque Real Estate Group
        Facebook
        Google
        OR

        Interested in Purchasing 192 Upshaw Drive?

        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