Title Page Background
DEBUG FN args: Array ( [0] => 486 [1] => [2] => [3] => agent ) BEFORE: Site: 486 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 486 Igate: njhud LocID: 486 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 486 AND i.igate IN ('gahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 486 [1] => [2] => [3] => lender ) BEFORE: Site: 486 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 486 Igate: njhud LocID: 486 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 486 AND i.igate IN ('gahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 486 [1] => [2] => [3] => other ) BEFORE: Site: 486 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 486 Igate: njhud LocID: 486 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 486 AND i.igate IN ('gahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

105 Crystal Creek Court
Hull, GA 30646

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $525,000
Beds: 3
Baths:
Status: Active
SqFt: 3432 Square Feet
Agency: COZART REALTY LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1995
Notes: Set back on an expansive 1.22 acre corner lot in the established Hidden Lake community is a private oasis and true epitome of gracious Southern charm. Crafted in the Cape Cod style, a warm welcome is extended by the grand rocking-chair porch spanning the front porch. Comprised of a flowing formal concept highlighted by custom appointments, designated living areas are provided to offer a more intimate atmosphere. Once received by the 2-story foyer, notable features come alive with multiple windows boasting panoramic views of the poolside retreat, palatial ceilings, updated paint palette and gleaming engineered wood floors lending warmth and durability as you travel throughout the main floor. Whether you enjoy throwing dinner parties, in need of a home office or prefer a formal living room, through a French door off the Foyer, this multifunctional space is ready to serve. Hosting large gatherings is made easy with this entertainer's delight, the expansive great room. Centrally located, this vaulted-ceiling living space is the heart of the home, providing ample space for relaxing, and offers guest overflow to the backyard paradise. The flowing plan seamlessly transitions to the graciously-sized dining area featuring picture window, and gourmet kitchen beyond. This layout continues to allow the home chef to interact with guest while remaining focus with the task at hand, creating sumptous feasts. Well-equipped and quite spacious, the kitchen offers ample granite counter tops that transition to the breakfast bar, solid wood cabinets accented by slate tile backsplash, updated light fixtures, stainless appliances and upgraded tile floors. Additionally, the kitchen provides access to the laundry room and lends space to a built-in desk area, perfect for keeping your busy life organized. Adding a little extra charm, the oversized pantry is upgraded with custom shelving, and a sleek sliding barn door. Tucked away in its preferable location, on the main, the owner's suite provides a separate retreat of its own. Carpet-free, the wood floors expand throughout the primary bedroom, and it features excess space allowing room for a siting area. Adding to its appeal, the owner's suite is complete with an upgraded lavatory appointed with all the expected amenities including updated luxury vinyl tile floors, separate shower, spacious vanity, large closet with shelving and a Whirlpool tub encouraging relaxation. Ascend the stairs to the upper level where whimsical balcony views greet you. This 2nd floor is comprised of two, like-kind accessory bedrooms, each featuring plush carpet flooring, ceiling fan light fixtures, dormer nooks perfect for a desk, ample closet space and quick access to the perfectly detailed full bath. Whether you need a little flex space, a 4th bedroom option or room for your hobbies - the expansive 2nd level bonus room, with private stair case to the main, can meet any need. Hidden away in the rear is the jewel of this home. Encapsulated by privacy fencing, adorned with professional landscaping and sodded yard, welcome to your very own little private slice of paradise. This haven centers around a saltwater filter pool with updated liner and stamped concrete surround providing ample space to soak up some sun. To enjoy a little shade, simply grab a spot on the oversized deck. Enjoy even more relaxation as you take a dip in the hot tub. Summer is here and the crisp, cool water is calling your name! This spectacular home resides in Hull, GA offering quick access to Hwy 72, is 3 miles to the booming Trail Creek Village Shopping Center and within 13 minutes to Downtown Athens and UGA. Modern updates, pristine condition and a backyard full of entertaining fun is the hallmarks of this move-in ready Cape Cod.
MlsNumber: --


Listing Provided By: COZART REALTY LLC, original listing
Phone: (706) 410-1941
Office Phone: (706) 410-1941
Agent Name: Deanna Cozart
Disclaimer: Copyright © 2024 Athens Area Association of Realtors. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App