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.
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
- 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#: 7556257
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
| 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 |
|---|---|---|
| 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
Nearby schools
GreatSchools rating
- 9/10Alpharetta Elementary SchoolGrades: PK-5Distance: 0.4 mi
- 9/10Hopewell Middle SchoolGrades: 6-8Distance: 1.5 mi
- 10/10Cambridge High SchoolGrades: 9-12Distance: 2.6 mi
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.
- Georgia
- Fulton County
- Alpharetta
- 30009
- Downtown
- 254 N Main St



