Title Page Background
HFQUERY 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 = 518 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 = 518 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 = 518 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

82 Childs Street
Martin, GA 30557
Betty Cheek with 85 North, original listing - (706) 654-2086

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $565,000
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 2800 Square Feet
Agency: 85 North
Agency Phone: (706) 654-2086

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 23,522 sqft
Property Type: Residential-Single Family Residence
Year Built: 2021
Notes: Step into the charm of the past with the luxuries of modern living in this newly constructed home, completed in 2021. Built on the historic site of the original Mitchell - Morgan home (circa 1920), this exceptional residence beautifully honors its heritage with thoughtful design elements, including reclaimed wood and some original interior doors. The heart of the home is a chef's kitchen that blends style and function. Equipped with a commercial gas cooktop, electric oven, Krass stainless steel sink and kitchen faucet, its a dream for culinary enthusiasts. Quartz countertops, expansive cabinetry, and a walk-in pantry offer unparalleled storage and prep space. Adjacent to the kitchen, the dining area features a Restoration Hardware chandelier and opens onto a large screened porch with maintenance-free composite decking - perfect for seamless indoor-outdoor living. The living area is anchored by a fireplace adorned with original stone from the 1920 home. Quality finishes abound, from the 9-inch European white oak plan flooring to Pella windows and energy-efficient LED recessed lighting. All bathrooms feature Kohler sinks and fixtures, with Toto toilets adding an extra touch of luxury. Additional highlights include tankless gas water heater, fully fenced backyard with a firepit, outdoor shower, custom TUFF shed with power, designed to complement the home, and professionally landscaped and lighted grounds. This property combines timeless elegance, impeccable craftsmanship, and modern conveniences. Come experience a home where history meets sophistication!
MlsNumber: --
ListingId: 10427364


Listing Provided By: 85 North, original listing
Phone: (770) 364-0805
Office Phone: (706) 654-2086
Agent Name: Betty Cheek
Disclaimer: Copyright © 2024 Berkshire Hathaway HomeServices Georgia Properties. 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