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.
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
- 557 days
- 71
- 2
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#: 10496595
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: 558 days
- Listing agreement: Exclusive Right To Sell
- Electric utility on property: Yes
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 5/5/2025 | Price change | $2,900,000-6.5% |
Source: | ||
| 4/8/2025 | Listed for sale | $3,100,000+408.2% |
Source: | ||
| 8/29/2016 | Sold | $610,000+77.8% |
Source: Public Record Report a problem | ||
| 3/4/2011 | Sold | $343,000-3.4% |
Source: Public Record Report a problem | ||
| 12/16/2004 | Sold | $355,000 |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax 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
Climate risks
Neighborhood: Downtown
Nearby schools
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.







