6770 Ulster Court
Alpharetta, GA 30005
- 4 beds
- 5 baths
- 14,810 sqft lot
- 2001 build
- 23 days on site
Your Updated European Dream Home Awaits! Step into timeless elegance with this beautifully updated home, where every detail has been thoughtfully curated for luxury and comfort. Newly installed solid White Oak hardwoods grace the living and family rooms, while the remaining hardwoods have been refinished in a rich Jacobean stain—creating a seamless flow throughout the entire main floor. Upstairs, you'll find brand-new neutral Mohawk designer carpeting with 8lb pet/life-proof padding for lasting durability and comfort. The updated kitchen is a true showstopper, featuring professionally painted creamy white cabinets, stunning quartz counters, antique gold faucet and hardware, and stainless-steel appliances—including double ovens, a gas cooktop, microwave, dishwasher, and refrigerator. A spacious walk-in pantry and a functional butler’s pantry provide ample storage. The formal dining room is designed to impress with detailed crown molding and chair rail accents and a new chandelier—perfect for hosting large gatherings. Generously sized rooms can be found throughout the home—from the expansive kitchen to the luxurious primary suite, which includes a cozy fireside sitting room and custom built-ins. Secondary bedrooms are large as well, with two sharing a jack-and-jill bath, and one featuring a private en-suite. The laundry room adds charm and practicality with a sink, cabinetry, wainscoting, and even a window—so you can finally tell your blue socks from your black ones! Downstairs, the finished daylight terrace level features LVP flooring, a full bath, and a private room perfect for guests or a dedicated home office. There's also a spacious billiards area and an additional family room for entertaining. Step outside to a cozy screened-in porch with party lights—just off the kitchen—leading to a large deck and a generous backyard. Enjoy the stone patio and fire pit, ideal for outdoor gatherings, or explore the lower wooded area with a playset in place. The flat upper lawn is perfect for family fun and events. Located in the sought-after Forsyth County school district with an Alpharetta address and low Forsyth County taxes, this home blends luxury with value. Community amenities in Shiloh Farms include a pool, clubhouse, tennis and pickle-ball courts, and a playground. Plus, the neighborhood hosts seasonal events like a 4th of July bike parade, Halloween costume parade, Fall Festival, and pictures with Santa—fostering a strong sense of community. Enjoy proximity to Halcyon, The Collection, Big Creek Greenway Trailheads, and Denmark High School. With the Ameris Amphitheater just 20 minutes away, and the upcoming The Gathering and Whole Foods nearby, you’re never far from the best dining, shopping, and entertainment. Come down the tree-lined drive and experience a neighborhood where neighbors become lifelong friends. This is more than just a home—it’s a lifestyle.
Last checked:
As a licensed real estate brokerage, Estately has access to the same database professional Realtors use: the Multiple Listing Service (or MLS). That means we can display all the properties listed by other member brokerages of the local Association of Realtors—unless the seller has requested that the listing not be published or marketed online.
The MLS is widely considered to be the most authoritative, up-to-date, accurate, and complete source of real estate for-sale in the USA.
Estately updates this data as quickly as possible and shares as much information with our users as allowed by local rules. Estately can also email you updates when new homes come on the market that match your search, change price, or go under contract.
Checking…
•
Last updated Apr 21, 2025
•
MLS# 7552217 —
The Building
-
Year Built:2001
-
Construction Materials:Brick Front
-
Building Area Source:Appraiser
-
Architectural Style:European
-
Levels:Two
-
Foundation Details:Concrete Perimeter
-
Roof:Composition
-
Basement:Daylight
-
Common Walls:No Common Walls
-
Exterior Features:Courtyard
-
Window Features:Double Pane Windows
-
Security Features:Carbon Monoxide Detector(s)
-
Patio And Porch Features:Deck
-
Accessibility Features:None
-
Green Energy Efficient:Appliances
-
Building Area Total:4851
-
Above Grade Finished Area:3367
-
Below Grade Finished Area:1484
-
Below Grade Unfinished Area:149
Interior
-
Interior Features:Cathedral Ceiling(s)
-
Kitchen Features:Breakfast Room, Cabinets White, Kitchen Island, Pantry Walk-In, Stone Counters, View to Family Room
-
Dining Room Features:Butlers Pantry, Seats 12+
-
Flooring:Carpet
-
Other Equipment:None
-
Laundry Features:Laundry Room
-
Fireplace Features:Factory Built
-
Fireplaces Total:2
-
Room Type:Game Room
Location
-
Directions:400 N. Exit 12b left on Shiloh road, Left on Crofton, left on Roxbury, right on Ulster house down on the right.
-
Latitude:34.122044
-
Longitude:-84.19506
The Property
-
Parcel Number:087 290
-
Property Type:Residential Detached
-
Property Type:Residential
-
Property Subtype:Single Family Residence
-
Property Condition:Resale
-
Lot Features:Back Yard
-
Lot Size Acres:0.34
-
Lot Size Dimensions:x
-
Lot Size Source:Public Records
-
View:Trees/Woods
-
Fencing:None
-
Horse Amenities:None
-
Other Structures:None
-
Waterfront Features:None
-
Water Body Name:None
-
Road Frontage Type:None
-
Road Surface Type:Asphalt
-
Property Attached:false
-
Land Lease:false
Listing Agent
- Contact info:
- Agent phone:
- (770) 490-9897
- Office phone:
- (770) 637-5070
Taxes
-
Tax Year:2024
-
Tax Annual Amount:6013
Beds
-
Bedrooms Total:4
-
Bedroom Features:Oversized Master, Sitting Room
-
Upper Level Bedrooms:4
Baths
-
Total Baths:5
-
Half Baths:1
-
Full Baths:4
-
Master Bath Features:Double Vanity, Separate Tub/Shower, Vaulted Ceiling(s)
-
Main Level Half Bathrooms:1
-
Lower Level Full Bathrooms:1
-
Upper Level Full Bathrooms:3
The Listing
-
Virtual Tour URL Unbranded:https://player.vimeo.com/progressive_redirect/playback/1075147625/rendition/1080p/file.mp4?loc=external&log_user=0&signature=314a23ee681eb7fc446ee8a2948f29751ddb6b98a10adeb6f0b6d03f79777a8f
-
Virtual Tour URL Unbranded 2:https://www.propertypanorama.com/6770-Ulster-Court-Alpharetta-GA-30005/unbranded
-
Virtual Tour URL Unbranded 3:https://player.vimeo.com/progressive_redirect/playback/1075147625/rendition/1080p/file.mp4?loc=external&log_user=0&signature=314a23ee681eb7fc446ee8a2948f29751ddb6b98a10adeb6f0b6d03f79777a8f
-
Home Warranty:false
-
Special Listing Conditions:None
-
Special Circumstances:None
Heating & Cooling
-
Cooling:Central Air
-
Heating:Central
Utilities
-
Utilities:Cable Available
-
Sewer:Public Sewer
-
Electric:110 Volts
-
Water Source:Public
-
Green Energy Generation:None
Appliances
-
Appliances:Dishwasher
Schools
-
Elementary School:Big Creek
-
Middle Or Junior School:DeSana
-
High School:Denmark High School
The Community
-
Subdivision Name:Shiloh Farms
-
Community Features:Clubhouse
-
Association:true
-
Association Fee:1296
-
Association Fee Frequency:Annually
-
Association Fee Includes:Reserve Fund
-
Swim Tennis Fee Due:None
-
Spa Features:None
-
Pool Features:None
-
Pool Private:false
-
Dock:None
-
Assessment Due Contemplated:false
Parking
-
Garage Spaces:2
-
Parking Features:Garage
-
Carport Garage Total:2
Listing Provided Courtesy of Atlanta Communities
Listings identified with the FMLS IDX logo come from FMLS and are held by brokerage firms other than the owner of this website and the listing brokerage is identified in any listing details. Information is deemed reliable but is not guaranteed. If you believe any FMLS listing contains material that infringes your copyrighted work, please click here to review our DMCA policy and learn how to submit a takedown request. © 2025 First Multiple Listing Service, Inc.
Monthly cost estimate
Asking price
$839,000
| Expense | Monthly cost |
|---|---|
|
Mortgage
This calculator is intended for planning and education purposes only. It relies on assumptions and information provided by you regarding your goals, expectations and financial situation, and should not be used as your sole source of information. The output of the tool is not a loan offer or solicitation, nor is it financial or legal advice. |
$4,492
|
| Taxes | $501 |
| Insurance | $230 |
| HOA fees | $108 |
| Utilities | $197 See report |
| Total | $5,528/mo.* |
| *This is an estimate |
Walk Score®
Provided by WalkScore® Inc.
Walk Score is the most well-known measure of walkability for any address. It is based on the distance to a variety of nearby services and pedestrian friendliness. Walk Scores range from 0 (Car-Dependent) to 100 (Walker’s Paradise).
Soundscore™
Provided by HowLoud
Soundscore is an overall score that accounts for traffic, airport activity, and local sources. A Soundscore rating is a number between 50 (very loud) and 100 (very quiet).
Air Pollution Index
Provided by ClearlyEnergy
The air pollution index is calculated by county or urban area using the past three years data. The index ranks the county or urban area on a scale of 0 (best) - 100 (worst) across the United Sates.
Max Internet Speed
Provided by BroadbandNow®
This is the maximum advertised internet speed available for this home. Under 10 Mbps is in the slower range, and anything above 30 Mbps is considered fast. For heavier internet users, some plans allow for more than 100 Mbps.
