stdClass Object
(
    [type] => Residential
    [status] => stdClass Object
        (
            [current] => Active
            [last] => Coming Soon
            [changed] => stdClass Object
                (
                    [$date] => 2025-04-07T07:01:12Z
                )

        )

    [ml_number] => 7554527
    [price] => stdClass Object
        (
            [amount] => 1400000
            [original] => 1400000
        )

    [description] => Welcome to 5749 Union Church Road, a newly constructed modern farmhouse blending timeless elegance with contemporary sophistication. Nestled on a 1.15-acre private gated entrance to ensure security and exclusivity. With a fenced lot, this 5,000 sq. ft. estate offers an unparalleled living experience with high-end finishes, smart design, and exceptional craftsmanship. The architectural design features four-sided brick construction with striking insulated windows, creating a bold yet refined aesthetic. The professionally landscaped grounds include ample space for a future pool. A three-car garage for added convenience. A covered front patio with custom flooring enhances curb appeal, while the expansive back patio, complete with an outdoor kitchen, a fully covered area, and built-in grill, is ideal for entertaining. Inside, soaring 20-foot ceilings in living areas create an open and airy ambiance. Tile and custom accent molding, and elegant hardwood flooring elevate the home’s sophistication, while modern upgraded lighting, under-cabinet, and shelf lighting add warmth and functionality. The open-concept living room features an electric fireplace with built-in shelving, offering a cozy yet stylish atmosphere. The gourmet chef’s kitchen is outfitted with a high-end appliance package, including a five-burner gas range with double ovens and grill, a custom vent hood, tile backsplash, oversized waterfall quartz island, and walk-in pantry with custom wood shelving. A formal dining room is perfect for intimate gatherings, while a private office off the entryway provides a refined workspace. The luxurious primary suite on the upper level is a true retreat, featuring a fireplace and spa-like en-suite with tile flooring, a freestanding soaking tub, frameless glass shower, dual quartz vanities, and a custom walk-in closet. The main level also includes a guest suite laundry room, a built-in mudroom with extra storage, and a half bath for guests. Upstairs, three spacious bedrooms each include closets. Two share a Jack-and-Jill bathroom with a shower and quartz countertops, while the third features its own en-suite and walk-in closet, ideal for guests. The expansive media room is a showstopper with a fireplace and wet bar, perfect for movie nights or entertaining. A secondary laundry room and motion-sensor stair lighting enhance convenience. Built for both beauty and efficiency. Energy-efficient features include an Energy Star tankless water heater and HVAC systems. The home also comes with a Homebuyers Warranty, offering 10-year structural coverage, and is protected by a termite bond for peace of mind. Located minutes from shopping, dining, and parks. With convenient access to Chateau Elan and major highways, this home is a perfect retreat offering privacy, luxury, and modern convenience. This modern farmhouse estate is designed for those who seek sophisticated living at its finest. Schedule your private tour today.
    [location] => stdClass Object
        (
            [city] => Braselton
            [state] => GA
            [postal_code] => 30517
            [county] => Hall - GA
            [street] => stdClass Object
                (
                    [number] => 5749
                    [name] => Union Church Road
                    [full] => 5749 Union Church Road
                )

            [directions] => See agent remarks
            [coordinates] => stdClass Object
                (
                    [latitude] => 34.135595
                    [longitude] => -83.842783
                    [geo_json] => stdClass Object
                        (
                            [type] => Point
                            [coordinates] => Array
                                (
                                    [0] => -83.842783
                                    [1] => 34.135595
                                )

                        )

                )

        )

    [building] => stdClass Object
        (
            [style] => Array
                (
                    [0] => Farmhouse
                    [1] => Modern
                )

            [construction] => Array
                (
                    [0] => Brick 4 Sides
                )

            [square_feet] => stdClass Object
                (
                    [size] => 5000
                    [source] => Builder
                )

            [stories] => Array
                (
                    [0] => Two
                )

            [built_in] => 2025
            [rooms] => stdClass Object
                (
                    [bed] => stdClass Object
                        (
                            [description] => Array
                                (
                                    [0] => In-Law Floorplan
                                    [1] => Oversized Master
                                )

                            [count] => 5
                        )

                    [baths] => stdClass Object
                        (
                            [master] => Array
                                (
                                    [0] => Double Vanity
                                    [1] => Separate Tub/Shower
                                    [2] => Soaking Tub
                                )

                            [full] => 4
                            [half] => 1
                        )

                    [kitchen] => Array
                        (
                            [0] => Cabinets White
                            [1] => Kitchen Island
                            [2] => Pantry Walk-In
                            [3] => Stone Counters
                        )

                    [description] => Array
                        (
                            [0] => Laundry
                            [1] => Living Room
                            [2] => Media Room
                            [3] => Office
                        )

                )

            [garage] => stdClass Object
                (
                    [count] => 3
                )

            [features] => Array
                (
                    [0] => Bookcases
                    [1] => Crown Molding
                    [2] => Double Vanity
                    [3] => High Ceilings 10 ft Main
                    [4] => Recessed Lighting
                    [5] => Walk-In Closet(s)
                    [6] => Wet Bar
                )

            [appliances] => Array
                (
                    [0] => Dishwasher
                    [1] => Double Oven
                    [2] => ENERGY STAR Qualified Water Heater
                    [3] => Gas Range
                    [4] => Microwave
                    [5] => Range Hood
                    [6] => Tankless Water Heater
                )

            [hvac] => Array
                (
                    [0] => Ceiling Fan(s)
                    [1] => Central Air
                    [2] => Electric
                )

            [fireplaces] => stdClass Object
                (
                    [count] => 3
                    [description] => Array
                        (
                            [0] => Electric
                        )

                    [exists] => 1
                )

        )

    [surroundings] => stdClass Object
        (
            [sewer] => Array
                (
                    [0] => Septic Tank
                )

            [utilities] => Array
                (
                    [0] => Electricity Available
                    [1] => Natural Gas Available
                    [2] => Water Available
                )

            [parking] => Array
                (
                    [0] => Attached
                    [1] => Garage
                )

            [features] => Array
                (
                    [0] => Lighting
                    [1] => Private Entrance
                    [2] => Private Yard
                    [3] => Rain Gutters
                )

            [land] => stdClass Object
                (
                    [size] => stdClass Object
                        (
                            [dimensions] => 1
                            [acres] => 1.15
                        )

                    [description] => Array
                        (
                            [0] => Back Yard
                            [1] => Landscaped
                            [2] => Wooded
                        )

                )

            [school] => stdClass Object
                (
                    [elementary] => Chestnut Mountain
                    [junior] => Cherokee Bluff
                    [high] => Cherokee Bluff
                )

        )

    [last_updated] => stdClass Object
        (
            [$date] => 2025-04-07T15:04:43Z
        )

    [office] => stdClass Object
        (
            [name] => Keller Williams Realty Chattahoochee North, LLC
            [broker_id] => KWCH01
            [broker_phone] => 678-578-2700
        )

    [agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Jaime
                            [last] => Quintero
                        )

                    [phone] => stdClass Object
                        (
                            [preferred] => 404-883-0120
                            [mobile] => 404-883-0120
                            [fax] => 678-578-2710
                        )

                    [agent_id] => JAIMEQ
                )

        )

    [media] => stdClass Object
        (
            [photos] => Array
                (
                    [0] => stdClass Object
                        (
                            [position] => 1
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/fmls-reso/7554527/b0b14e802ac57b69d31ffcfda25b26ee-m1.jpg
                                    [215x] => https://new.photos.idx.io/fmls-reso/7554527/b0b14e802ac57b69d31ffcfda25b26ee-m1/215x.jpg
                                    [440x] => https://new.photos.idx.io/fmls-reso/7554527/b0b14e802ac57b69d31ffcfda25b26ee-m1/440x.jpg
                                )

                        )

                    [1] => stdClass Object
                        (
                            [position] => 2
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/fmls-reso/7554527/b0b14e802ac57b69d31ffcfda25b26ee-m2.jpg
                                    [215x] => https://new.photos.idx.io/fmls-reso/7554527/b0b14e802ac57b69d31ffcfda25b26ee-m2/215x.jpg
                                    [440x] => https://new.photos.idx.io/fmls-reso/7554527/b0b14e802ac57b69d31ffcfda25b26ee-m2/440x.jpg
                                )

                        )

                )

        )

    [internet_display_allowed] => 1
    [key] => fmls-7554527
    [added_at] => stdClass Object
        (
            [$date] => 2025-04-05T17:01:32Z
        )

    [source] => fmls
    [self_link] => https://api.idx.io/listings/fmls-7554527
)