Property Attributes
- MLS#7821717
- TypeSingle Family
- Listing Status Active
- CountyFulton
- CityAlpharetta
- NeighborhoodDowntown Alpharetta
- Zip30009
- StyleModern, Traditional
- Year Built2026
- Taxes$ 7227
- Price$ 4,279,000
- Bedrooms6
- Full Bathrooms7
- Half Bathrooms2
- Lot Size0.4371 Acres
Data Source:
First Multiple Listing Services (FMLS)
Property Description
Rare basement home on the most sought-after streets in Downtown Alpharetta! This exceptional new build by builder Rosen Custom Homes has paved the way for over 25 years in the luxury market. Offering the rare combination of walkability to the vibrant energy of downtown, while tucked quietly within an intimate neighborhood setting. The home’s striking exterior showcases French modern elegance, featuring Texas limestone, hardcoat stucco, a herringbone paver driveway and walkways, and herringbone-patterned wood garage doors for timeless curb appeal. Enter through dramatic French metal glass doors into a grand two-story foyer, flanked by a sophisticated dining room highlighted by a metal picture window, designer lighting, and a fully appointed butler’s pantry with wet bar, ice maker, beverage cooler, and LED-lit cabinetry. At the heart of the home, the great room impresses with vaulted, beamed ceilings, a floor-to-ceiling modern linear fireplace finished in custom wood and quartzite, and expansive 10-foot-high, 16-foot-wide metal sliders that seamlessly connect indoor and outdoor living. The chef’s kitchen is both stunning, featuring custom beaded inset cabinetry, a full-slab quartzite backsplash, a waterfall island with porcelain sink and polished nickel fixtures, and premium appliances including a Wolf 48” dual-fuel range and Wolf integrated hoodless vent, a paneled Sub Zero refrigerator/freezer, a paneled dishwasher, and a hidden pantry for abundant storage. A fully equipped prep kitchen offers additional cabinetry, sink, refrigerator/freezer, microwave, dishwasher, and generous workspace. Nearby, a mudroom and laundry area with a sink provides convenience between garage entries. A private main-level office overlooks the resort-style backyard through a dramatic metal picture window. The primary suite on the main level is a luxurious retreat, complete with a stone fireplace, abundant natural light, and a spa-inspired bath featuring marble finishes, custom inset cabinetry, soaking tub, oversized shower with dual shower heads and body sprayers, and an expansive custom walk-in closet with a multi-drawer island. Designed for year-round entertaining, the outdoor living space features a vaulted tongue-and-groove ceiling with skylights, motorized screens, a fully vented built-in kitchen with grill, beverage center, and sink, plus a fire table with dedicated gas line—all overlooking the saltwater pool, spa, sundeck, and tanning ledge. A dedicated exterior pool bath adds thoughtful convenience. Upstairs, hardwood floors extend throughout four ensuite bedrooms, including a vaulted secondary primary suite with soaking tub, dual vanities, oversized shower, and large walk-in closet. An additional laundry room with a sink completes the level. The fully finished terrace level is designed for entertaining, offering open-concept recreation spaces, a full wet bar with ice maker and illuminated cabinetry, a dedicated media room (or optional fitness space), powder room, and a private guest suite. Walk-out access leads directly to the level backyard. The home is prewired for whole-home audio, security cameras, and low-voltage needs. A hidden neighborhood pathway provides direct access to downtown, placing dining, shopping, weekly festivals, farmers markets, and entertainment just moments from your front door. Top-rated schools, including Alpharetta Elementary and Innovation Academy, are only a few minutes away. Some photos have been digitally enhanced.
| Elementary School | Middle School | High School |
|---|---|---|
| Alpharetta Elementary School | Hopewell Middle School | Cambridge High School |
| Price History | |
|---|---|
| 8/14/2026 | Listed $4,279,000 |
General Features
| Sewer | Public Sewer |
|---|---|
| Heating | Central,Zoned |
| Cooling | Ceiling Fan(s),Central Air,Zoned |
| Utilities | Cable Available,Electricity Available,Natural Gas Available,Phone Available,Sewer Available,Underground Utilities,Water Available |
| Roof | Composition,Shingle |
| Appliances | Dishwasher,Disposal,Double Oven,Gas Range,Microwave,Range Hood,Refrigerator,Tankless Water Heater |
| Garage Spaces | 3 |
| Patio/Porch Features | Covered,Screened |
| Architectural Style | Modern,Traditional |
| Pool Features | Gunite,Heated,In Ground,Pool/Spa Combo,Private,Salt Water |
| Security Features | Carbon Monoxide Detector(s),Security System Owned,Smoke Detector(s) |
| Construction Materials | Stone,Stucco |
| Year Built | 2026 |
| Electric | 220 Volts |
| View | Neighborhood |
| Levels | Three Or More |
| Property Subtype | Single Family Residence |
| Tax Year | 2025 |
| Waterfront Features | None |
| Community Features | Near Schools,Near Shopping,Near Trails/Greenway,Park,Pickleball,Playground,Pool,Restaurant,Street Lights,Tennis Court(s) |
| Accessibility | None |
| County | Fulton - GA |
| Property Type | Residential |
| HOA | false |
| Energy Efficient | Thermostat,Water Heater,Windows |
| Subdivision Name | Downtown Alpharetta |
| Green Energy Generation | None |
| Other Structures | Outdoor Kitchen |
| Full Baths | 7 |
| Status | Active |
| Directions | from Downtown Alpharetta go north on Canton St. LT on Mayfield, first LT on Upshaw, RT on Meadow to home on right. |
| High School | Cambridge |
| City | Alpharetta |
| Body of Water | None |
| Spa Features | Private |
| Elementary School | Alpharetta |
| Property Attached Y/N | false |
| Land Lease Y/N | false |
| Tax Annual Amount | 7227 |
| Home Warranty Y/N | false |
| Middle/Junior High School | Hopewell |
| Property Condition | Resale |
| Virtual Tour | https://iframe.videodelivery.net/5918f53d9d08b3ce117f2b2278a8b1fa |
| Standard Status | Active |
| Freehold | IDX |
| Corporate Owner | None |
Interior Features
| Interior Amenities | Beamed Ceilings,Disappearing Attic Stairs,Double Vanity,Entrance Foyer 2 Story,High Ceilings 9 ft Upper,High Ceilings 10 ft Main,High Speed Internet,Low Flow Plumbing Fixtures,Recessed Lighting,Vaulted Ceiling(s),Walk-In Closet(s),Wet Bar |
|---|---|
| Basement | Daylight,Exterior Entry,Finished,Finished Bath,Full,Interior Entry |
| Flooring | Hardwood |
| Total Fireplaces | 2 |
| Fireplace Features | Factory Built,Gas Log,Great Room,Master Bedroom |
| Common Walls | No Common Walls |
| Window Features | Aluminum Frames,Insulated Windows,Skylight(s) |
| Above Grade Finished Area | 5047 |
| Half Baths | 2 |
| Laundry Features | Laundry Room,Main Level,Sink,Upper Level |
| Total Bedrooms | 6 |
| Below Grade Finished Area | 2233 |
| Room Type | Basement,Media Room,Office |
| Main Level Bedrooms | 1 |
| Main Level Bathrooms | 2 |
| Kitchen Features | Cabinets Stain,Eat-in Kitchen,Kitchen Island,Pantry Walk-In,Stone Counters,View to Family Room |
| Total Baths | 9 |
| RoomBedroomFeatures | Double Master Bedroom,Master on Main |
| Primary Bathroom Features | Double Shower,Double Vanity,Separate Tub/Shower,Soaking Tub |
| Dining Room Features | Butlers Pantry,Separate Dining Room |
Exterior Features
| Exterior Amenities | Private Yard |
|---|---|
| Fencing | Back Yard |
| Parking Features | Attached,Garage,Garage Door Opener,Garage Faces Side,Kitchen Level,Level Driveway |
| Lot Features | Back Yard,Front Yard,Landscaped,Level |
| Water Source | Public |
| Foundation Details | Concrete Perimeter |
| Building Area Total | 7707 |
| Lot Dimensions | x |
| Lot Size Acres | 0.4371 |
| Road Surface Type | Asphalt |
| Lot Size Source | Public Records |
| Road Frontage Type | City Street |
| Other Equipment | Irrigation Equipment |
| Horse Amenities | None |
Amenities
- Foreclosure
- Views
- Short Sale
- New Construction
- Adult 55+
- Lease To Own
- No HOA Fees
- Furnished
- Primary On Main
- Air Conditioning
- Seller Finance
- Green
- Fixer Upper
- Horse
- Golf
- Fireplace
- Deck
- Garage
- Basement
- Pool
Property vs Single Family Average in 30009
Statistics provided by Inside Real Estate
©2026 Georgia Multiple Listing Service All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may
Northeast Georgia Board of REALTORS® All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be
The information set forth on this site is based upon information which we consider reliable, but because it has been supplied by third parties to our franchisees (who in turn supplied it to us), we can not represent that it is accurate or complete, and it should not be relied upon as such. The offerings are subject to errors, omissions, changes, including price, or withdrawal without notice. All dimensions are approximate and have not been verified by the selling party and can not be verified. It