Kotohomes Logo
Kotohomes partnered with:
Athens Banner-Herald
For Sale For Rent
Advertise
bedrooms
bedrooms
5
bathrooms
bathrooms
5
square feet
square feet
5,000
acreage
Acreage
1.15
open houses
Open Houses
-
year built
year built
2025
full baths
Full Baths
4
half baths
Half Baths
1
Welcome to 5749 Union Church Road, a newly constructed modern farmhouse blending timeless elegance with contemporary sophistication. Nestled on a 1.15-acre private gated entrance to ensure security and exclusivity. With a fenced lot, this 5,000 sq. ft. estate offers an unparalleled living experience with high-end finishes, smart design, and exceptional craftsmanship. The architectural design features four-sided brick construction with striking insulated windows, creating a bold yet refined aesthetic. The professionally landscaped grounds include ample space for a future pool. A three-car garage for added convenience. A covered front patio with custom flooring enhances curb appeal, while the expansive back patio, complete with an outdoor kitchen, a fully covered area, and built-in grill, is ideal for entertaining. Inside, soaring 20-foot ceilings in living areas create an open and airy ambiance. Tile and custom accent molding, and elegant hardwood flooring elevate the home’s sophistication, while modern upgraded lighting, under-cabinet, and shelf lighting add warmth and functionality. The open-concept living room features an electric fireplace with built-in shelving, offering a cozy yet stylish atmosphere. The gourmet chef’s kitchen is outfitted with a high-end appliance package, including a five-burner gas range with double ovens and grill, a custom vent hood, tile backsplash, oversized waterfall quartz island, and walk-in pantry with custom wood shelving. A formal dining room is perfect for intimate gatherings, while a private office off the entryway provides a refined workspace. The luxurious primary suite on the upper level is a true retreat, featuring a fireplace and spa-like en-suite with tile flooring, a freestanding soaking tub, frameless glass shower, dual quartz vanities, and a custom walk-in closet. The main level also includes a guest suite laundry room, a built-in mudroom with extra storage, and a half bath for guests. Upstairs, three spacious bedrooms each include closets. Two share a Jack-and-Jill bathroom with a shower and quartz countertops, while the third features its own en-suite and walk-in closet, ideal for guests. The expansive media room is a showstopper with a fireplace and wet bar, perfect for movie nights or entertaining. A secondary laundry room and motion-sensor stair lighting enhance convenience. Built for both beauty and efficiency. Energy-efficient features include an Energy Star tankless water heater and HVAC systems. The home also comes with a Homebuyers Warranty, offering 10-year structural coverage, and is protected by a termite bond for peace of mind. Located minutes from shopping, dining, and parks. With convenient access to Chateau Elan and major highways, this home is a perfect retreat offering privacy, luxury, and modern convenience. This modern farmhouse estate is designed for those who seek sophisticated living at its finest. Schedule your private tour today. Home to be completed by the end of April 2025. Up to $5,500 lender credit and reimbursed appraisal cost (credited at closing) available when using preferred lender Matt Kuglin with Onward Home Mortgage.
Location
Subdivision None
County Hall - GA
Elementary School Chestnut Mountain
Middle School Cherokee Bluff
High School Cherokee Bluff
open houses Open houses
None scheduled.
Find out more
Tell us who you are, and we will have someone reach out to you.

By proceeding, you consent to receive calls, texts and voicemails at the number you provided (may be recorded and may be autodialed and use pre-recorded and artificial voices), and email, from Kotohomes, Jaime Quintero, and their network of service providers about your inquiry and other home-related matters.

Msg/data rates may apply. This consent applies even if you are on a do not call list and is not a condition of any purchase.

MLS number: 7554527
Listing agent: Jaime Quintero
Listing broker: Keller Williams Realty Chattahoochee North (678) 578-2701
Copyright © 2025 First Multiple Listing Service, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.   [source]
Last update: Thursday, April 10 2025 at 12:15 a.m. EDT
Kotohomes National