Title Page Background
DEBUG FN args: Array ( [0] => 418 [1] => [2] => [3] => agent ) BEFORE: Site: 418 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 418 Igate: njhud LocID: 418 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 = 418 AND i.igate IN ('ohhud','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 = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 418 [1] => [2] => [3] => lender ) BEFORE: Site: 418 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 418 Igate: njhud LocID: 418 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 = 418 AND i.igate IN ('ohhud','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 = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 418 [1] => [2] => [3] => other ) BEFORE: Site: 418 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 418 Igate: njhud LocID: 418 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 = 418 AND i.igate IN ('ohhud','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 = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back | All Foreclosures | | | All Cities

145 Sunset Peak
Waleska, GA 30183
Lisa Steele with Lake Homes Realty LLC, original listing - (205) 985-2991
« Prev
Next »
Currently Displayed Property Photo


Property Details

List Price: $1,600,000
Beds: 5
Baths: Full: 5
Status: Active
SqFt: 4450 Square Feet
Agency: Lake Homes Realty LLC
Agency Phone: (205) 985-2991

Map Details Show Map | Show StreetView



Description/Comments

Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2018
Notes: Stunning Waterfront Craftsman Home in Lake Arrowhead. Welcome to your dream retreat! This breathtaking waterfront home in the highly sought-after community of Lake Arrowhead is a true gem. With its impeccable craftsmanship and turnkey condition, this residence is ready for you to move in and start enjoying the unique lake lifestyle that Lake Arrowhead has to offer. As you approach this exquisite craftsman-style home, youCOll be greeted by a charming exterior featuring natural stone and cedar accents and a welcoming front porch, perfect for sipping your morning coffee. Step inside to discover an open-concept living space bathed in natural light, showcasing high ceilings and a gorgeous stone fireplace that serves as the heart of the home. The gourmet kitchen is a chefCOs dream, complete with stainless steel appliances, custom painted cabinetry with beautiful gold hardware, a spacious island perfect for entertaining with gorgeous oversized glass pendant lighting. Adjacent to the kitchen, the dining area offers views of the lake, creating the ideal setting for family gatherings and dinner parties. This space offers access to an incredible covered deck with stone fireplace that can be screened in or open, at the touch of a remote! Retreat to the luxurious master suite, where you can unwind with breathtaking views overlooking the water. The ensuite bathroom features a spa-like atmosphere with a soaking tub, dual vanities, and a beautifully tiled walk-in shower. An additional bedroom on the main is generously sized and has access to a full bath providing comfort and privacy for family and guests. Upstairs you will find an incredible media room that will provide hours of family fun after a fun filled day on the lake. The upper level also boasts two guest rooms that share a full bath making this ideal for over night lake quests or family. Head downstairs to discover and incredible finished terrace level complete with spacious family room, second master with private en suite and hidden safe room! This level exits to a second covered deck that runs the length of the home and offers incredible views. But wait, there's more! A full unfinished basement providing endless storage for all your boat and lake toys along with easy access to the covered dock, complete with solar powered hydraulic boat lift and deep water! Outside you will find your own personal oasisCoa beautifully landscaped backyard that leads directly to the waterCOs edge. Enjoy summer days lounging by the lake, fishing from your private dock, or hosting barbecues on the spacious deck. With lush greenery and professional landscaping surrounding the property, youCOll feel a sense of tranquility and privacy. No detail has been overlooked. Fresh paint inside and out, full house generator, commercial grade cameras and wifi boosters thoughout the house and electric car charger in the garage! Lake Arrowhead has an array of amenities, including hiking trails, pickleball, courts and exclusive community events. This home is not just a residence; itCOs a lifestyle waiting for you to embrace. DonCOt miss your chance to own this incredible waterfront craftsman homeCoschedule your private showing today and experience the magic of Lake Arrowhead living!
MlsNumber: --
ListingId: 10495307


Listing Provided By: Lake Homes Realty LLC, original listing
Phone: (205) 985-2991
Office Phone: (205) 985-2991
Agent Name: Lisa Steele
Disclaimer: Copyright © 2025 Georgia Multiple Listing Service. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => cherokee-north [3] => GA [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: cherokee-north State: GA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: cherokee-north State: GA 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 = 418 AND i.igate IN ('ohhud','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 = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Sherri Godwin
Sherri Godwin
ASCIIAtlanta Communities
Call Today!: (770) 316-5139

Contact Me

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App