Seller's Agent in 2025
Shelley Sellars Smith
Atlanta Communities
(770) 490-9897
8 in this area
40 Total Sales
6770 Ulster Ct Alpharetta, GA 30005
Big Creek Neighborhood
4
Beds
4.5
Baths
4,851
Sq Ft
0.34
Acres
Highlights
- Home Theater
- Dining Room Seats More Than Twelve
- Fireplace in Primary Bedroom
- Big Creek Elementary School Rated A+
- Clubhouse
- Deck
About This Home
As of May 2025Your 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 Agent to Sell the Property
Atlanta Communities Brokerage Phone: 7704909897 License #274067 Listed on: 04/10/2025
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $6,013
Year Built
- Built in 2001
Lot Details
- 0.34 Acre Lot
- Private Lot
- Partially Wooded Lot
HOA Fees
- $108 Monthly HOA Fees
Home Design
- Slab Foundation
- Composition Roof
- Concrete Siding
Interior Spaces
- 2-Story Property
- Rear Stairs
- Bookcases
- Tray Ceiling
- High Ceiling
- Factory Built Fireplace
- Gas Log Fireplace
- Double Pane Windows
- Two Story Entrance Foyer
- Family Room with Fireplace
- 2 Fireplaces
- Dining Room Seats More Than Twelve
- Breakfast Room
- Formal Dining Room
- Home Theater
- Home Office
- Game Room
Kitchen
- Walk-In Pantry
- Double Oven
- Microwave
- Dishwasher
- Kitchen Island
Flooring
- Wood
- Carpet
Bedrooms and Bathrooms
- 4 Bedrooms
- Fireplace in Primary Bedroom
- Walk-In Closet
Laundry
- Laundry Room
- Laundry on upper level
Finished Basement
- Interior and Exterior Basement Entry
- Finished Basement Bathroom
- Natural lighting in basement
Home Security
- Carbon Monoxide Detectors
- Fire and Smoke Detector
Parking
- Garage
- Parking Accessed On Kitchen Level
- Side or Rear Entrance to Parking
- Garage Door Opener
Eco-Friendly Details
- Energy-Efficient Appliances
Outdoor Features
- Deck
- Patio
- Separate Outdoor Workshop
- Porch
Location
- Property is near schools
- Property is near shops
Schools
- Big Creek Elementary School
- Desana Middle School
- Denmark High School
Utilities
- Forced Air Zoned Heating and Cooling System
- Heating System Uses Natural Gas
- Underground Utilities
- Gas Water Heater
- High Speed Internet
- Cable TV Available
Community Details
Overview
- $1,296 Initiation Fee
- Association fees include reserve fund, swimming, tennis, trash
- Shiloh Farms Subdivision
Amenities
- Clubhouse
Recreation
- Tennis Courts
- Community Playground
- Swim Team
- Community Pool
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Apr 10, 2025
Closed on
May 15, 2025
Sold by
Schmitt Steve and Schmitt Carole
Bought by
Chong Hong Suck
Seller's Agent
Shelley Sellars Smith
Atlanta Communities
Buyer's Agent
Hannah Bae
BHHS Georgia Properties
List Price
$839,000
Sold Price
$839,000
Views
344
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
-9.97%
Original Mortgage
$645,500
Outstanding Balance
$645,500
Interest Rate
6.64%
Mortgage Type
New Conventional
Estimated Equity
$184,737
Purchase Details
Closed on
Jul 10, 2006
Sold by
Knight Claude C and Knight Anne G
Bought by
Schmitt Steve and Schmitt Carole
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$340,000
Interest Rate
6.68%
Mortgage Type
New Conventional
Purchase Details
Closed on
Mar 26, 2004
Sold by
Posch Timothy R and Posch Karen
Bought by
Knight Claude C and Knight Annie
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$269,650
Interest Rate
6.3%
Mortgage Type
New Conventional
Purchase Details
Closed on
Mar 13, 2003
Sold by
Posch Timothy R
Bought by
Posch Timothy R and Posch Karen E
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$286,300
Interest Rate
5.82%
Mortgage Type
New Conventional
Purchase Details
Closed on
Mar 22, 2001
Sold by
First Choice Builders Inc
Bought by
Posch Timothy R
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$235,700
Interest Rate
7.11%
Mortgage Type
New Conventional
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area
Home Values in the Area
Average Home Value in this Area
Purchase History
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| Special Warranty Deed | $839,000 | None Listed On Document | |
| Special Warranty Deed | $839,000 | None Listed On Document | |
| Deed | $425,000 | -- | |
| Deed | $337,100 | -- | |
| Quit Claim Deed | -- | -- | |
| Quit Claim Deed | -- | -- | |
| Deed | $294,700 | -- |
Source: Public Records
Mortgage History
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $645,500 | New Conventional | |
| Closed | $645,500 | New Conventional | |
| Previous Owner | $328,000 | New Conventional | |
| Previous Owner | $321,100 | New Conventional | |
| Previous Owner | $46,000 | Stand Alone Second | |
| Previous Owner | $340,000 | New Conventional | |
| Previous Owner | $269,650 | New Conventional | |
| Previous Owner | $25,000 | Stand Alone Second | |
| Previous Owner | $286,300 | New Conventional | |
| Previous Owner | $50,000 | Credit Line Revolving | |
| Previous Owner | $235,700 | New Conventional |
Source: Public Records
Property History
| Date | Event | Price | Change | Sq Ft Price |
|---|---|---|---|---|
| 05/15/2025 05/15/25 | Sold | $839,000 | 0.0% | $173 / Sq Ft |
| 04/14/2025 04/14/25 | Pending | -- | -- | -- |
| 04/10/2025 04/10/25 | For Sale | $839,000 | -- | $173 / Sq Ft |
Source: Georgia MLS
Tax History Compared to Growth
Tax History
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2024 | $6,013 | $284,248 | $68,000 | $216,248 |
| 2023 | $5,596 | $279,472 | $60,000 | $219,472 |
| 2022 | $5,477 | $187,460 | $40,000 | $147,460 |
| 2021 | $4,931 | $187,460 | $40,000 | $147,460 |
| 2020 | $4,150 | $153,568 | $28,000 | $125,568 |
| 2019 | $4,156 | $153,568 | $28,000 | $125,568 |
| 2018 | $4,159 | $153,568 | $28,000 | $125,568 |
| 2017 | $4,479 | $164,548 | $24,000 | $140,548 |
| 2016 | $4,479 | $164,548 | $24,000 | $140,548 |
| 2015 | $4,487 | $164,548 | $24,000 | $140,548 |
| 2014 | $3,908 | $150,888 | $24,000 | $126,888 |
Source: Public Records
Agents Affiliated with this Home
-
Shelley Sellars Smith
-
Hannah Bae
Buyer's Agent in 2025
Hannah Bae
BHHS Georgia Properties
(470) 403-0046
2 in this area
11 Total Sales
Map
Source: Georgia MLS
MLS Number: 10494287
APN: 087-290
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity Program of Georgia MLS. Real estate listings held by brokerage firms other than Redfin are marked with the Broker Reciprocity logo and detailed information about them includes the name of the listing brokers. Information deemed reliable but not guaranteed. Copyright 2025 Georgia MLS. All rights reserved.
Nearby Homes
- 6795 Preston Glen Dr
- 6765 Crofton Dr
- 2620 Bent Creek Dr
- 3155 Wills Mill Rd
- 2260 Wood Falls Dr
- 2155 Mindy Ln
- 2580 Glaramara Terrace Unit 2
- 3010 Florence St
- 2905 Medford Dr
- 2160 Bradley Trail
- 2430 Flat Stone Dr
- 2335 Flat Stone Dr
- 2545 Bertrand Way
- 2505 Kirkwood Dr
- 2725 Monet Dr
- 2740 Cezanne Ln
- 2755 Cezanne Ln
- 2720 Garonne Way
- 2750 Herrington Dr