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

122 Lee Road 844
Valley, AL 36854

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $789,000
Beds: 3
Baths:
Status: Active
SqFt: --
Agency: Coldwell Banker Kpdd

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2005
Notes: DEEDED LOT!!! ENGLISH MANOR HOUSE/CRAFTSMAN HOMESTYLE ON LAKE HARDING WITH EFFECTIVE YEAR BUILT 2005. The complete home remodeling renovation completed in 2018 including: New hardwood and tile flooring, all bath fixtures, shower and tub, ceramic tile and glass doors, HVAC replacement, exterior siding and trim, windows, doors, appliances, kitchen island, Doors and door hardware, Light fixtures interior and exterior,<br /> security and smoke detector central system. Triple garage was also completed 2018. HOME IS FRESH and completely modernized. <br /> <br /> QUALITY CONSTRUCTION THROUGHOUT. A GREAT LOCATION TO ENJOY LAKE LIVING FULL OR PART TIME. FEATURES INCLUDE REFURBISHED DOCKS AND SEA WALLS WITH DOUBLE DECKER VIEWING DECK (GRANDFATHERED IN) WITH A ROOF COVER, TWO BOAT SLIPS, DOCK STORAGE AND BIG FLOATING DOCK WITH SLIDE AND NEW WOOD. MORE FEATURES INCLUDE HIGH QUALIITY "CERTAIN MANOR" QUALITY HOUSE AND GARAGE SHINGLES, FOAM INSULATION, EXTERIOR HIGH END SIDING FACTORY PAINTED. ALL TRIM WINDOWS ARE MAINTENANCE, PEST AND ROT FREE. GEOTHERMAL HEATING/COOLING ARE VERY EFFICIENT AND COMFORTABE WITH 3 UNITS COVERING THE HOME. AQUA SYSTEM PLUMBING HAS CENTRAL CONTROL TO TURN OFF WATER FLOW IF NEEDED. MARATHON LIFE TIME WARRANTY 80 GALLON WATER TANK. RACHIO IRRIGATION CONTROLLER ON WI-FI TO MONITOR. STEEL VAULTED CEILING SUPPORT AND VAULTED ROOF BEAM SYSTEM. WOOD ON 2 STORY SCREENED IN PORCH FEATURES CEDAR WHICH IS INSECT AND ROT RESISTANT, SCREEN IS SPECIAL WEAVE TO KEEP INSECTS OUT. LOTS OF QUALITYY GLASS AND PACE SLIDING DOORS ON LAKE SIDE. VINTAGE CHIMNEY CAP FROM ENGLAND, WROUGHT IRON FROM FOX THEATRE IN ATLANTA AND FRONT DOOR FROM AN ATLANTA ESTATE. BIG AIRCRAFT ALUMINUM FLOATING DOCK. CAST STAINLESS STEEL ON BOAT LIFTS FOR JET SKIS. TRIPLE GARAGE/DOOR HAS 8 FOOT OPENINGS, RUBBERIZED FLOOR. COME FIND YOUR PLACE AT LAKE HARDING !!
MlsNumber: --


Listing Provided By: Coldwell Banker Kpdd, original listing
Phone: (706) 256-1000
Office Phone: (706) 256-1000
Agent Name: Mike See
Disclaimer: Copyright © 2024 East Alabama 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