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 = 469 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 = 469 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 = 469 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;

1325 Mineral Springs Road
Hoschton, GA 30548

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,390,000
Beds: 6
Baths: 6
Status: Active
SqFt: 6992
Agency: Redfin Corporation

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 11 acre(s)
Property Type: Residential
Year Built: 1992
Notes: PRICED BELOW APPRAISED VALUE AND SELLER OFFERING $10K IN CONCESSIONS with ACCEPTED OFFER!! Request your showing TODAY! PRIVACY on 11.5+/- ACRES w/ 3 buildable lots, LUXURY & NO HOA! What more can you ask for???? Tons of natural light throughout! This stately 6BR/5.5BTH home w/ gorgeous custom touches, has been exceptionally maintained and has over $170K in home improvements which include: city/public water line connect, NEW hardwood flooring, NEW roof, chimney cover & gutters, NEW water heater & circular pump, NEW gas furnace, repaired like new deck and porch, NEW carport and so much more!!!! Enjoy the grand entrance with an extensive front porch, perfect for rocking chairs and tranquil evenings outside. Step inside to gorgeous hardwood floors. The opulent 2-story foyer is flanked by the elegant Dining Room ready to host your guests and the grand Family Room w/stack stone wood burning fireplace, coffered ceiling, access to the executive office and double door access to the private sundeck and capacious screened porch w/ a beautiful stone grill overlooking the woods providing a private oasis, perfect for dinner parties or Sunday brunch. The gourmet chef's kitchen beckons culinary enthusiasts to unleash their culinary artistry upon the commercial grade gas range/oven and also features an oversized island with room for seating, granite counters, stainless steel appliances, and butler's station with more storage and counterspace. Your choice of TWO (2) owner suites...on MAIN level w/ tray ceiling, built-ins, outdoor access to front porch, and a spa-like en-suite with dual sinks, garden tub, extra-large frameless glass shower, and spacious walk-in closet with custom built-ins. Ascend UPSTAIRS to more luxury...one wing boasts the 2nd owner's suite with a private bath, two walk-in closets and private balcony and spacious laundry room. Across the catwalk features another bedroom w/ en suite and walk-in closet. The opposite wing has two additional generously sized bedrooms with walk-in closets that share a full hall bath. And don't miss the FINISHED TERRACE LEVEL featuring more room for storage, a bedroom, full bath, kitchenette, an additional living room w/custom floor-to-ceiling stacked stone fireplace, artfully equipped with a gas starter, and media room/flex space with multi-access to the covered veranda that overlooks the custom brick fire pit. Home also comes with 3-car garage, ample guest parking, RV parking pad with power, carriage house for storage and well water! Walking distance to Little Mulberry Park. A must see! Schedule your showing today!
MlsNumber: 7353641


Listing Provided By: Redfin Corporation, original listing
Name: Redfin Corporation
Phone: (678) 916-2126
Office Name: Redfin Corporation
Office Phone: (404) 800-3623
Agent Name: Leah Gause
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.


Local Real Estate Expert

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 = 469 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;
Real Estate Expert Photo for Jenneisha Parker
Jenneisha Parker
ASCIIeXp Realty
Call Today!: (678) 975-4686

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App