Skip main navigation
Active
  • $2,900,000

    254 N Main St, Alpharetta, GA 30009

    5beds
    0.57Acres
    Other, Unimproved Land
    Built in 1963
    0.57 Acres Lot
    $-- Zestimate®
    $--/sqft
    $-- HOA

    What's special

    ATTENTION INVESTORS: 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 264 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! FIVE UNIQUE EXIT STRATEGIES FOR 254 AND 264 MAIN STREET: CLUSTER/TOWNHOMES, DT-MU W/ COMMERCIAL, SF DETACHED, STACKED CONDOS OR TOWNHOMES. SEE ATTACHED PROPOSED SKETCH PLANS.
    461 days
    |
    87
    |
    3
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Trish Hauser,

    Coldwell Banker Realty 770-993-9200,

    Michael Barsky,

    Coldwell Banker Realty

    Source: FMLS GA,MLS#: 7556257MLS Logo

    Loading...

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 5
      • Bathrooms: 2
      • 1/2 bathrooms: 2
      • Main level bedrooms: 5
      Rooms
      • Room types: Office
      Primary bedroom
      • Features: None
      • Level: None
      Bedroom
      • Features: None
      Primary bathroom
      • Features: None
      Video & virtual tour

      Property

      Features
      • Levels: One
      • Stories: 1
      • Patio & porch: None
      • Fencing: None
      • Has view: Yes
      • View description: City
      • Waterfront features: None
      • Body of water: None
      Lot
      • Size: 0.57 Acres
      • Features: Rectangular Lot
      • Residential vegetation: Partially Wooded, Mixed Timber
      Details
      • Additional structures: None
      • Parcel number: 22 481411970441
      • Zoning: OI
      • Zoning description: Office/Industrial
      • Other equipment: None
      • Horse amenities: None

      Utilities & green energy

      • Utilities for property: Cable Available, Electricity Available, Natural Gas Available, Phone Available, Sewer Available, Underground Utilities, Water Available

      Community & HOA

      Community
      • Features: None
      • Security: None
      • Subdivision: None
      HOA
      • Has HOA: No
      Location
      • Region: Alpharetta

      Financial & listing details

      • Tax assessed value: $495,700
      • Annual tax amount: $5,179
      • Date on market: 3/31/2025
      • Cumulative days on market: 461 days
      • Electric utility on property: Yes
      • Road surface type: Asphalt

        Estimated market value

        Not available

        Estimated sales range

        Not available

        $4,673/mo

        Price history

        DateEventPrice
        5/5/2025Price change$2,900,000-6.5%
        Source: GAMLS #10496595 Report a problem
        4/8/2025Listed for sale$3,100,000+408.2%
        Source: FMLS GA #7556257 Report a problem
        8/29/2016Sold$610,000+77.8%
        Source: Public Record Report a problem
        3/4/2011Sold$343,000-3.4%
        Source: Public Record Report a problem
        12/16/2004Sold$355,000
        Source: Public Record Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2024$5,179 -0.3%$198,280
        2023$5,193 -0.5%$198,280
        2022$5,217 -3%$198,280
        2021$5,379 -3.9%--
        2020$5,597 -18.5%$198,280 -0.2%
        2019$6,869 $198,720 -1.7%
        2018$6,869 $202,160
        2017$6,869 -2.7%$202,160 +47.4%
        2016$7,061 +46.8%$137,170
        2015$4,808 +14.4%$137,170
        2014$4,205 +5.2%$137,170
        2013$3,996 -0.4%$137,170
        2012$4,013 $137,170 -32.1%
        2011-- $202,160
        2010$5,869 +3.6%$202,160
        2009$5,667 $202,160
        2008-- $202,160 +16.9%
        2007$4,949 $172,920

        Find assessor info on the county website

        Monthly payment

        Estimated monthly payment$1,822
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
        See how much you could borrow to make a competitive offer.

        Climate risks

        Neighborhood: Downtown

        Getting around

        58 / 100
        Somewhat Walkable
        26 / 100
        Some Transit
        43 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating
        Schools provided by the listing agent
        • Elementary: Manning Oaks
        • Middle: Hopewell
        • High: Alpharetta

        Source: FMLS GA. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

        A local agent can set up tours, give advice and negotiate with sellers.

        Browse local experts

        Similar homes

        Skip to the end of the carouselSkip to the beginning of the carousel