T
Seller's Agent in 2025
Team Stowe Group
Ansley RE | Christie's Int'l RE
(404) 480-4663
3 in this area
35 Total Sales
Estimated Value: $2,675,000
Discover 504 Trinity Church Rd - a meticulously crafted modern farmhouse estate by Hunt Homes, offering a rare combination of gated privacy, timeless design, and collector-grade garage accommodations, with a temperature-controlled 6-car garage in the custom carriage house and an attached 3-car garage seamlessly integrated into the main residence. Set on an immaculately landscaped 2 acre estate, this architectural showpiece is accessed via a picturesque private bridge and grand double gates, delivering an immediate sense of exclusivity. Designed for both elegance and functionality, the home strikes a perfect balance between serenity and convenience-located just minutes from Alpharetta and Milton, with quick access to GA 400 for a seamless commute or weekend escape. A charming rocking-chair front porch provides a warm welcome, while striking black steel double doors open to a sun-drenched foyer. Inside, custom white oak hardwood floors and expansive windows highlight the open-concept layout, creating an effortless flow between the living, dining, and entertaining areas. The fireside family room features custom built-ins and oversized sliding glass doors that extend the living space to a resort-style lanai. The outdoor living area is an entertainer's dream-complete with a fully equipped kitchen and dining space, cozy fireside lounge, and a custom heated saltwater pool and spa, designed for year-round enjoyment. As day turns to night, the home and grounds beautifully illuminate, with thoughtfully integrated landscape lighting that enhances both ambiance and security. At the heart of the home, the chef's kitchen is a true culinary masterpiece. Anchored by a dramatic quartzite waterfall island, it boasts professional-grade Thermador appliances, custom cabinetry, and a walk-in pantry cleverly hidden behind a sliding barn door. An elegant butler's pantry adds sophistication and ease for entertaining. The main-level owner's suite offers a peaceful retreat, featuring a spa-like bath with heated floors, a soaking tub, frameless glass shower, and dual vanities. The spacious walk-in closet is thoughtfully outfitted with custom built-ins. A secondary en-suite bedroom on the main level provides flexibility for guests, a nursery, or home office, complemented by a spacious laundry room. Upstairs, you'll find multiple en-suite bedrooms with walk-in closets, a dedicated media room, a versatile bonus room, a private office, and a child's dream playroom-designed to inspire imagination and creativity. Completing the estate is a custom-designed carriage house offering remarkable versatility. The main level features the epoxy-finished, climate-controlled 6-car garage, ideal for collectors, hobbyists, or recreational storage. Above, a beautifully appointed guest suite includes dramatic wood beams, a full kitchen, living room, laundry room, and a spa-like bath-perfect for extended stays, private accommodations, or multigenerational living. Additional features that enhance daily living include a smart security system with cameras, whole-house generator, Wi-Fi-enabled irrigation system, landscape lighting, and an indoor/outdoor speaker system. Every detail of this exceptional home has been carefully curated to offer a lifestyle of comfort, sophistication, and seamless functionality.
Last Agent to Sell the Property
Ansley RE | Christie's Int'l RE License #239349 Listed on: 06/25/2025
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Mccullough Donald | $2,455,000 | -- | |
| Parhizkar Francesca M | $2,375,000 | -- |
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Previous Owner | Parhizkar Francesca M | $1,900,000 |
| Date | Event | Price | List to Sale | Price per Sq Ft | Prior Sale |
|---|---|---|---|---|---|
| 08/15/2025 08/15/25 | Sold | $2,455,000 | -1.6% | $404 / Sq Ft | |
| 07/17/2025 07/17/25 | Price Changed | $2,495,000 | -0.2% | $411 / Sq Ft | |
| 06/25/2025 06/25/25 | For Sale | $2,499,000 | +5.2% | $412 / Sq Ft | |
| 03/01/2024 03/01/24 | Sold | $2,375,000 | -1.0% | $396 / Sq Ft | View Prior Sale |
| 10/09/2023 10/09/23 | For Sale | $2,399,000 | -- | $400 / Sq Ft |
| 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 |
|---|---|---|---|---|
| 2025 | $19,880 | $816,800 | $125,960 | $690,840 |
| 2024 | $16,342 | $628,840 | $83,600 | $545,240 |
| 2023 | $16,154 | $621,600 | $69,200 | $552,400 |
| 2022 | $11,561 | $439,880 | $69,200 | $370,680 |
T
Seller's Agent in 2025
Team Stowe Group
Ansley RE | Christie's Int'l RE
(404) 480-4663
3 in this area
35 Total Sales
Seller Co-Listing Agent in 2025
Troy Stowe
Ansley RE | Christie's Int'l RE
(404) 375-8749
4 in this area
92 Total Sales
Buyer's Agent in 2025
Scott Hauswirth
Premier Atlanta Real Estate
(404) 664-5733
5 in this area
84 Total Sales
Source: Georgia MLS
MLS Number: 10551010
APN: 003N18-00000-123-00C-0000
Ask me questions while you tour the home.