Skip main navigation
Active
  • $2,900,000

    254 N Main St, Alpharetta, GA 30009

    --beds
    --baths
    0.57Acres
    Residential Lot
    Built in ----
    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. Call agent for more information. 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.
    508 days
    |
    63
    |
    0
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Trish Hauser 770-841-0234,

    Coldwell Banker Realty,

    Michael Barsky 678-522-0954,

    Coldwell Banker Realty

    Source: GAMLS,MLS#: 10496595MLS Logo

      Facts & features

      Property

      Features
      • Has view: Yes
      • View description: City
      • Body of water: None
      Lot
      • Size: 0.57 Acres
      • Features: Other
      • Residential vegetation: Partially Wooded
      Details
      • Additional structures: None
      • Parcel number: 22 481411970441
      • Special conditions: As Is,Investor Owned

      Utilities & green energy

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

      Community & HOA

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

      Financial & listing details

      • Tax assessed value: $488,800
      • Annual tax amount: $5,179
      • Date on market: 3/31/2025
      • Cumulative days on market: 508 days
      • Listing agreement: Exclusive Right To Sell
      • Electric utility on property: Yes

        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
        2025$5,107 -1.4%$195,520 -1.4%
        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.
        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: GAMLS. 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