Title Page Background
DEBUG FN args: Array ( [0] => 530 [1] => [2] => [3] => agent ) BEFORE: Site: 530 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 530 Igate: njhud LocID: 530 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 = 530 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] => 530 [1] => [2] => [3] => lender ) BEFORE: Site: 530 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 530 Igate: njhud LocID: 530 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 = 530 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] => 530 [1] => [2] => [3] => other ) BEFORE: Site: 530 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 530 Igate: njhud LocID: 530 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 = 530 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;

154 Parkview Lane
Young Harris, GA 30582

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $565,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: --
Agency: REMAX Hiawassee Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2022
Notes: Welcome to Paradise! This CREEKFRONT home is perfect for those looking for a peaceful retreat surrounded by nature, yet still close to all the amenities and attractions of the surrounding towns. Located on Ivy Log Creek, this newer construction, energy efficient home sits on 2 acres of level terrain. Completed in 2023, this home still feels, looks and smells brand new and is ready for the new owner to make it their own! This modern, ranch home has 3BR/2BA with a split bedroom floor plan. The open kitchen features granite countertops, black stainless steel appliances, and a breakfast bar for casual dining. The creek side Master suite is a true oasis with a large walk-in closet, dual purpose vanity with make-up counter, and a luxurious tiled shower. Great Room, with beautiful stacked-stone fireplace, opens to a large screened, covered rear deck that provides a wonderful spot to sit and enjoy the sounds of the year-round, fast flowing creek. Tongue & groove pine ceilings enhance the Great Room as well as all 3 bedrooms. Home also features a large covered front porch that overlooks the expansive park-like front yard with beautiful hardwoods scattered throughout. Imagine how gorgeous this will be in the fall! Centrally located just north of Blairsville, this great location is near Lake Nottely, Murphy, Hiawassee and Blue Ridge, making it easy to explore all this beautiful mountain area has to offer. Home has a Young Harris address but is located in Union County. Don't miss this opportunity to own a beautiful, almost-new creek-front home in the mountains. Schedule a showing today and start enjoying the peaceful and serene lifestyle this home has to offer!
MlsNumber: --


Listing Provided By: REMAX Hiawassee Realty, original listing
Phone: (706) 299-9024
Office Phone: (706) 896-4183
Agent Name: Kathryn Seals
Disclaimer: Copyright © 2024 Northeast Georgia Board 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