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

1507 Williams Road
Dallas, GA 30132

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,900,000
Beds: 3
Baths:
Status: Active
SqFt: 2936 Square Feet
Agency: eXp Realty

Map Details Show Map | Show StreetView




House Features

Appliances: Cooktop, Dishwasher, Washer, Microwave, Refrigerator, Ice Maker
Architectural Style: Bungalow
Construction Materials: Wood Siding, Stone
Cooling: Zoned A/C, Ceiling Fan(s)
Flooring: Hardwood
Heating: Central Furnace, Zoned
Interior Features: High Ceilings, Walk-in Closet(s), Vaulted Ceiling(s), Bookcases, Beamed Ceilings, Master On Main Level
Rooms: Bathroom 1, Bathroom 2, Bathroom 3, Bedroom 1, Bedroom 2, Bedroom 3

Window Features

Exterior Features: Balcony
Parking Features: Garage, RV, Boat
Roof: Composition
View: River
Waterfront Features: Waterfront

Neighborhood/Schools

Elementary School/District: Burnt Hickory
Middle/Junior High School/District:
High School/District: North Paulding
Subvidision Name:

Description/Comments


Lot Size: 9 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2020
Notes: Welcome to Pumpkinvine Manor. That's right. This place has a name. That's because this place is awesome! Not like, "Wow, man. This beer is awesome." More like being completely gob-smacked. The owner has taken God's raw materials and sculpted a showcase of the Almighty's creation. It's a work of art, and it's awe-inspiring, and so it has a name: Pumpkinvine Manor. You'll never want to leave. The house is first-class, and it sits 500 wooded feet from the road, upon 9+ private acres, over-looking Pumpkinvine Creek. Along the 750 feet creek frontage, runs a big, flat lawn and a pavilion featuring a full kitchen & utilities, ceiling fans, fire pit, swings/seating, and a flushing toilet. The house was built in 2020 and has all you would expect in luxury living--details for days. Some highlights include a vintage walk-in cooler (wooden) door that guards a lounge with built-in curio cabinets and high-powered ventilation concealed within recessed lighting. Another (secret) room is hidden behind a bookcase doubling as a door. The kitchen holds a farmer's sink, commercial grade cooking/ventilation, replete with pot-filler and a butler's pantry. The Master Bath boasts a claw-footed soaking tub inside a double-headed shower room. The lighting, water, and door fixtures are timeless classics, and the fireplace burns real wood. The basement is an unfinished canvas, awaiting your dream of (theater, game room, ice cream parlor, fill-in-your-blank here). As the pictures show, this house is great, but Pumpkinvine Manor is an experience; it's a trophy property, nestled within nature's playground. You'll drink up the views that pour in throughout, and become pulled into the nature that surrounds. Entertain in or outdoors, in the sunshine or the shade. Or keep it all to yourself. To promote lazy living, the creek holds a swimming hole that is approximately twenty feet across by twelve feet deep. So, take a dip and chill out. Float the waterways by kayak or inner tube. Fish from the bank or wade into the stream. Hit the trails on foot, bike, or ATV. Just think of the wildlife you will meet along the way: deer, fox, hawks, and eagles to name a few frequent visitors. Explore the area, off-property. Walk to Foxberry Farm, a large equestrian estate, with stables, paddocks, and jumps (it is the next door neighbor). A short drive will find you hiking the Silver Comet Trail, hunting in Paulding Forest, or wake boarding on Lake Allatoona.
MlsNumber: --


Listing Provided By: eXp Realty, original listing
Phone: (888) 959-9461
Office Phone: (888) 959-9461
Agent Name: Peter Porcelli
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

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => virginia-beach-south [3] => VA [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: virginia-beach-south State: VA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: virginia-beach-south State: VA 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 = 3480 AND i.igate IN ('vahud','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 = 'vahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Daniel Patton
ASCIIProdigy Realty
Call Today!: (757) 642-1153

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App