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

149 Pine Needle Drive
Dawsonville, GA 30534
Jose Romero with Keller Williams Lanier Partner, original listing - (770) 503-7070

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,890,000
Beds: 5
Baths: Full: 5
Status: Active
SqFt: 8928 Square Feet
Agency: Keller Williams Lanier Partner
Agency Phone: (770) 503-7070

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2024
Notes: Remarkable masterpiece built with the highest quality and no expenses spared. So many details about this beautiful home, here are a few specs: 5 car garage. Electric front gate. Attached in-law house. Circular driveway. Over 2,500 ft of fencing and 3rd septic tank ready for a barn are ready for your animals. Patio consist of brick floors, cedar columns, and cedar tongue and grove ceilings. Car charger in garage, Marcy arched 10CO front door. Marcy back doors. 34CO vaulted ceilings in the living room. All interior doors 8CO tall. Living room cedar beam. Cozy heat Carlton 46C direct vent fireplace with Spanish style stucco. Floors are Legends Dawn Patrol. 9C wide. Custom trim and shelving throughout. 10C baseboards with S4S trim. Lights are Capital lighting Savoy house, Visual comfort, Hinkley and Vera Luz. Double island with extra storage. Quartz islands with waterfall. 8' stucco vent hood. Custom 12x6 wrought iron wine rack. Floor to ceiling cabinetry with hidden pantry. 42" Fridge. 48" gas stove top. Double oven. Porcelain Farmhouse sink. Coffee bar. Pot filler. Glass rinser. Garbage disposal. Automatic microwave drawer. Dining room wet bar and custom wrought iron passover window. Oversized primary bedroom with cedar beams, electric fireplace, 9Cy arched doors, sunroom with coffee/dry bar and 2 fandaliers. His and hers vanities. Free standing tub. Walk in grand primary shower with double heads. Oversized primary closet with 12CO tall of custom built in shelving with room for her shoes and purses. Ceiling mount bathroom exhaust fans with bluetooth speakers and LED lights. Laundry room includes dog bath, lavatory sink and laundry chute from upstairs. Office space with natural sunlight, shelving and gorgeous oversized light fixture. Stairs and hallway secured with custom wrought iron railing. Upstairs consists of 3 bedrooms, 3 bathrooms, dry bar area with flex space. In-law house consists of its own living room, electric fireplace, full kitchen with 9CO island with farmhouse sink, waterfall quartz counters, garbage disposal, pot filler, glass rinser, automatic microwave drawer, 42C fridge, 36C electrical range, large bedroom, curb-less shower, wide doors, oversized double car garage. 24CO vaulted ceilings. Own laundry with custom closet. And much more...
MlsNumber: --
ListingId: 10331353


Listing Provided By: Keller Williams Lanier Partner, original listing
Phone: (770) 503-7070
Office Phone: (770) 503-7070
Agent Name: Jose Romero
Disclaimer: Copyright © 2024 Georgia Multiple Listing Service. 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 = 432 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 Karen Brown
Karen Brown
ASCIIMaximum One Premier Realtors
Call Today!: (678) 704-1202

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App