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

0 Valley View Lane
Menlo, GA 30731

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $212,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Keller Williams Realty Peachtree Rd.
Agency Phone: (404) 419-3500

Map Details Show Map | Show StreetView




House Features

Architectural Style: Other

Neighborhood/Schools

Elementary School/District: Gilbert/Lexington One
Middle/Junior High School/District:
High School/District: LAFAYETTE
Subvidision Name: None

Description/Comments


Lot Size: 4 acre(s)
Property Type: Land-Unimproved Land
Year Built: --
Notes: Nestled in northwest Georgia lies a rare gem - 4.73 acres of brow property in Cloudland, offering an idyllic setting to bring your dream home to life. Positioned on the eastern brow of the Lookout Mountain Range, this property boasts over 300 feet of breathtaking brow, providing awe-inspiring panoramic vistas. Unlike western brow locations, here, you'll enjoy uninterrupted views without the sun's afternoon glare. The property extends over the brow giving a long-range view stretching across the valley to the east, boasting a remarkable unobstructed view spanning 30-50 miles. With a topography cascading from elevated rock outcroppings, the view is truly indescribable. The remaining acreage is perfectly suited for a cabin or home having a gentle sloping topography and abundant hardwood trees. McLemore Resort and Golf Community is a short 20-minute drive with home prices starting at $1MM+ and a new Curio by Hilton hotel. Construction of a second 18-hole course to host PGA tournaments is underway, further elevating the area's prestige. You’ll be pleasantly surprised by how close it is to Chattanooga, less than 40 miles for those who may need to fly out and approximately 100 miles from Atlanta. Imagine your dream home here! Reach out today to embark on how this breathtaking canvas can become your reality.
MlsNumber: --
ListingId: 7361405


Listing Provided By: Keller Williams Realty Peachtree Rd., original listing
Phone: (404) 557-5571
Office Phone: (404) 419-3500
Agent Name: Suzanne Rutkowski
Disclaimer: Copyright © 2024 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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App