Main Content

    stdClass Object
(
    [type] => Commercial
    [status] => stdClass Object
        (
            [current] => Active
            [changed] => stdClass Object
                (
                    [$date] => 2025-04-07T21:17:20Z
                )

        )

    [ml_number] => 7555688
    [price] => stdClass Object
        (
            [amount] => 3100000
            [original] => 3100000
        )

    [listing_flags] => Array
        (
            [0] => Investor Owned
            [1] => Sold As/Is
        )

    [description] => LOCATION, LOCATION, LOCATION!!! Prime Downtown Alpharetta Redevelopment Opportunity. Unlock the potential of a remarkable commercial property located at 254 North Main Street, just blocks north of Downtown Alpharetta. Situated on 0.568 acres, this property is within the heart of the city’s Downtown Master Plan, and is designated as "mixed use - live work," offering unmatched opportunity for visionary developers and investors. This prime location is ideal for high-density residential projects, including condominiums, townhomes, or single-family homes. Whether you are looking to capitalize on the growing demand for upscale housing in this vibrant area or seeking to be part of Alpharetta's ongoing transformation, this property is a perfect canvas for your next development project. To maximize the development potential, this property is ideally sold in conjunction with the neighboring property at 254 North Main St., offering a combined total of 1.1 acres and enhanced opportunities for larger-scale residential development. Located in one of the most sought-after regions in North Fulton, this property boasts proximity to top-rated schools, parks, shopping, dining, and all the amenities that make Alpharetta a premier destination. With easy access to major highways and just minutes from downtown Alpharetta, this location is poised for exceptional growth. Don’t miss your chance to be part of Alpharetta’s bright future. Contact us today to learn more about this incredible redevelopment opportunity!
    [location] => stdClass Object
        (
            [city] => Alpharetta
            [state] => GA
            [postal_code] => 30009
            [county] => Fulton - GA
            [street] => stdClass Object
                (
                    [number] => 264
                    [name] => N Main Street
                    [full] => 264 N Main Street
                )

            [directions] => Please use GPS
            [coordinates] => stdClass Object
                (
                    [latitude] => 34.082793
                    [longitude] => -84.295351
                    [geo_json] => stdClass Object
                        (
                            [type] => Point
                            [coordinates] => Array
                                (
                                    [0] => -84.295351
                                    [1] => 34.082793
                                )

                        )

                )

        )

    [building] => stdClass Object
        (
            [construction] => Array
                (
                    [0] => Frame
                )

            [square_feet] => stdClass Object
                (
                    [size] => 2780
                )

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

            [built_in] => 1960
            [features] => Array
                (
                    [0] => Reception Area
                    [1] => Restrooms
                )

            [hvac] => Array
                (
                    [0] => Central Air
                )

            [fireplaces] => stdClass Object
                (
                    [exists] => 
                )

        )

    [surroundings] => stdClass Object
        (
            [utilities] => Array
                (
                    [0] => Cable Available
                    [1] => Electricity Available
                    [2] => Natural Gas Available
                    [3] => Phone Available
                    [4] => Sewer Available
                    [5] => Underground Utilities
                    [6] => Water Available
                )

            [parking] => Array
                (
                    [0] => Parking Lot
                )

            [land] => stdClass Object
                (
                    [size] => stdClass Object
                        (
                            [dimensions] => x
                            [acres] => 0.54
                        )

                    [description] => Array
                        (
                            [0] => Rectangular Lot
                        )

                )

        )

    [last_updated] => stdClass Object
        (
            [$date] => 2025-04-09T10:12:37Z
        )

    [office] => stdClass Object
        (
            [name] => Coldwell Banker Realty
            [broker_id] => CBRB09
            [broker_phone] => 770-993-9200
        )

    [agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Trish
                            [last] => Hauser
                        )

                    [phone] => stdClass Object
                        (
                            [preferred] => 770-841-0234
                            [mobile] => 770-841-0234
                            [fax] => 770-594-2010
                        )

                    [agent_id] => THAUSER
                )

            [1] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Michael
                            [last] => Barsky
                        )

                    [phone] => stdClass Object
                        (
                            [preferred] => 678-522-0954
                            [mobile] => 678-522-0954
                            [fax] => 770-594-2010
                        )

                    [agent_id] => BMICHA
                )

        )

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

                        )

                )

        )

    [internet_display_allowed] => 1
    [key] => fmls-7555688
    [added_at] => stdClass Object
        (
            [$date] => 2025-04-07T21:17:20Z
        )

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

264 N Main Street, Alpharetta, GA 30009

Price

$3,100,000

Sqft

2,780

Property Details for 264 N Main Street

N Main Street

MLS#7555688

Save Property
LOCATION, LOCATION, LOCATION!!! Prime Downtown Alpharetta Redevelopment Opportunity. Unlock the potential of a remarkable commercial property located at 254 North Main Street, just blocks north of Downtown Alpharetta. Situated on 0.568 acres, this property is within the heart of the city’s Downtown Master Plan, and is designated as "mixed use - live work," offering unmatched opportunity for visionary developers and investors. This prime location is ideal for high-density residential projects, including condominiums, townhomes, or single-family homes. Whether you are looking to capitalize on the growing demand for upscale housing in this vibrant area or seeking to be part of Alpharetta's ongoing transformation, this property is a perfect canvas for your next development project. To maximize the development potential, this property is ideally sold in conjunction with the neighboring property at 254 North Main St., offering a combined total of 1.1 acres and enhanced opportunities for larger-scale residential development. Located in one of the most sought-after regions in North Fulton, this property boasts proximity to top-rated schools, parks, shopping, dining, and all the amenities that make Alpharetta a premier destination. With easy access to major highways and just minutes from downtown Alpharetta, this location is poised for exceptional growth. Don’t miss your chance to be part of Alpharetta’s bright future. Contact us today to learn more about this incredible redevelopment opportunity!

Listing Agents

Exterior Details

ConstructionFrame
Built In1960
StoriesOne
ParkingParking Lot
UtilitiesCable Available, Electricity Available, Natural Gas Available, Phone Available, Sewer Available, Underground Utilities, Water Available
Lot DescriptionRectangular Lot
Lot Dimensionsx
Acres0.54

Location

Zip Code 30009
City Alpharetta
County Fulton - GA
SQ FT 2780

First Multiple Listing Service

Listing Provided Courtesy Of: Coldwell Banker Realty 770-993-9200

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. © 2025 First Multiple Listing Service, Inc.

This property information delivered from various sources that may include, but not be limited to, county records and the multiple listing service. Although the information is believed to be reliable, it is not warranted and you should not rely upon it without independent verification. Property information is subject to errors, omissions, changes, including price, or withdrawal without notice.

For issues regarding this website, please contact Eyesore, Inc. at 678.692.8512.

Data Last updated on April 28, 2025 9:10am

Get In Touch Connect With Us

    Accessibility Tools