254 N Main St

Alpharetta, GA 30009

$2,900,000
Price
24,776 / 0.57
Lot Size / Acres
a picture of a floor plan
a picture of a wall
a picture of a picture
unknown
a picture of a wall
a bathroom with a shower

Description

Attention investors: 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. 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...Attention investors: 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. 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!
  1. Listed by Trish Hauser • Coldwell Banker Realty • 770-993-9200
  2. Listed by Michael Barsky • Coldwell Banker Realty

Property Details for 254 North Main Street

Subdivision Complex
None
Architectural Style
Ranch
Property Attached
No
Waterfront Features
None
LISTING UPDATED: 06/12/2025 12:10 AM

Property Details for 254 North Main Street

StatusActive
MLS #7556257
Days on Market328
Taxes$5,179 / year
HOA Fees-
Condo/Co-op Fees-
Compass TypeLand
MLS TypeLand / Other
Year Built1963
Lot Size0.57 AC
CountyFulton County

Location

Listing Courtesy of Coldwell Banker Realty, Trish Hauser; Coldwell Banker Realty, Michael Barsky
Add your commute

Building Information for 254 North Main Street

Lot Size0.57 AC

Payment Calculator

$14,566 per month

30 year fixed, 6.15% Interest

Principal and Interest

$14,134

Property Taxes

$432

HOA Dues

$0

The Payment Calculator is for illustrative purposes only.

Property Information for 254 North Main Street

Summary
Location and General Information
  • Community Features: None
  • Directions: Please use GPS.
  • Lake Name: None
  • View: City
  • Coordinates: -84.295478, 34.082519
Taxes and HOA Information
  • Parcel Number: 22 481411970441
  • Tax Year: 2024
  • Association: No
  • Tax Legal Description: See Docs
  • Tax Lot: 0
School Information
  • Elementary School: Manning Oaks
  • High School: Alpharetta
  • Middle School: Hopewell
Interior and Exterior Features
Interior Features
  • Levels/Stories: One
  • Other Equipment: None
  • Timber: Mixed
  • Bedroom Features: None
  • Master Bathroom Features: None
  • Main Bedrooms: 5
  • Total Half Baths: 2
  • Bathrooms Total Interger: 2
  • Main Full Baths: 0
  • Additional Rooms: Office
  • Bathrooms Total Decimal: 1.00
Exterior Features
  • Fencing: None
  • Horse Amenities: None
  • Patio And Porch Features: None
  • Road Surface Type: Asphalt
  • Security Features: None
  • Pool Private: No
  • Road Frontage Type: City Street, Easement
  • Other Structures: None
Property
Utilities
  • Utilities: Cable Available,Electricity Available,Natural Gas Available,Phone Available,Sewer Available,Underground Utilities,Water Available
Property and Assessments
  • Home Warranty: No
  • Property Condition: Resale
  • Current Use: Office
  • Possession: Negotiable
Lot Information
  • Section/GMD: 2nd
  • HabitableResidenceYN: Yes
  • Land lot: 1197
  • Lot Features: Rectangular Lot
  • Acreage Source: Other
  • Vegetation: Partially Wooded
  • Current Zoning: OI
Rental
Rent Information
  • Occupant Types: Owner

Property History for 254 North Main Street

DateEvent & SourcePriceAppreciation
Aug 29, 2016

Sold (Public Record)

Public Record #579810933

$610,000

+10.9% / yr

Jan 28, 2011

Sold (Public Record)

Public Record #308844719

$343,000

-0.6% / yr

Dec 15, 2004

Sold (Public Record)

Public Record #308368419

$355,000—
DateEvent & SourcePrice
08/29/2016

Sold (Public Record)

Public Record #579810933

$610,000

+10.9% / yr

01/28/2011

Sold (Public Record)

Public Record #308844719

$343,000

-0.6% / yr

12/15/2004

Sold (Public Record)

Public Record #308368419

$355,000

For completeness, Compass often displays two records for one sale: the MLS record and the public record.

Public Records for 254 North Main Street

Taxable ValueLand$125,480Additions$70,040Total$195,520
Home Facts
Beds3Total Finished SqFt2,301 SqFtAbove Grade Finished SqFt2,301 SqFtStories1Lot Size24,742 SqFtStyleSingle Family ResidenceYear Built1963ZoningOICountyFULTONAPN22 481411970441Fireplace TypeHas Fireplace

Schools near 254 North Main Street

This home is within Fulton County School District.
Rating
School
Type
Grades
Distance
Alpharetta Elementary School
Public - PK to 5
Hopewell Middle School
Public - 6 to 8
Cambridge High School
Public - 9 to 12
Innovation Academy
Public - 9 to 11
Rating
School
Distance
Alpharetta Elementary School
PublicPK to 5

Hopewell Middle School
Public6 to 8

Cambridge High School
Public9 to 12

Innovation Academy
Public9 to 11

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

Similar Sold Homes

Explore Nearby Homes

More information about 254 North Main Street, Alpharetta, GA 30009

254 North Main Street is a 0.57 ac of land for sale in Alpharetta, GA 30009. This property was listed for sale on March 31, 2025 by Coldwell Banker Realty, it's currently listed at $2,900,000. It has been on the market for a total of 328 days and was last sold on August 29, 2016. This listing's school district is Fulton County School District. Nearby schools include Alpharetta Elementary School, Hopewell Middle School and Cambridge High School. 254 North Main Street is a 5-bed, 2-bath, 0.57 ac of land built in 1963 on a 24,776 sq. ft. / 0.57 acres lot.

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of descriptions or measurements (including square footage measurements and property condition), such should be independently verified, and Compass, Inc., its subsidiaries, affiliates and their agents and associated third parties expressly disclaims any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the discretion of the seller. No financial or legal advice provided. Equal Housing Opportunity.

Listing Courtesy of Coldwell Banker Realty, Trish Hauser; Coldwell Banker Realty, Michael Barsky

Based on information from one of the following Multiple Listing Services:FMLS,FMLS_CS,GAMLS,Middle GA MLS,Columbus Board of REALTORS, Northeast Georgia Board of REALTORS.Information being provided is for the visitor’s personal, noncommercial use and may not be used for any purpose other than to identify prospective properties visitor may be interested in purchasing. The data contained herein is copyrighted by FMLS,FMLS_CS,GAMLS, Middle GA MLS,Columbus Board of REALTORS, Northeast Georgia Board of REALTORS is protected by all applicable copyright laws. Any dissemination of this information is in violation of copyright laws and is strictly prohibited. Property information referenced on this web site comes from the Internet Data Exchange (IDX) program of the MLS. This web site may reference real estate listing(s) held by a brokerage firm other than the broker and/or agent who owns this web site. For the avoidance of doubt, the accuracy of all information, regardless of source, is deemed reliable but not guaranteed and should be personally verified through personal inspection by and/or with the appropriate professionals.