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

507 Griffin Road
Pitts, GA 31072

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $450,000
Beds: 4
Baths: 3
Status: Active
SqFt: --
Agency: NATIONAL REALTY COMPANY

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2021
Notes: Welcome to your dream property! Nestled in the serene countryside, this stunning estate boasts modern comfort and rural charm. Step into luxury with a 2021 manufactured home spanning over 2500 square feet of meticulously designed living space. Upon entering, be greeted by the elegant double-pane windows inviting natural light to dance across the rooms. The expansive 4 bedrooms and 2 and a half bathrooms, providing ample space for relaxation and rejuvenation. Prepare culinary delights in the spacious kitchen featuring a convenient island with a sink equipped with a reverse osmosis filtration system, ensuring pure and refreshing water for all your culinary endeavors. Cozy up in the inviting family room, complete with a fireplace, perfect for creating lasting memories with loved ones. The Mud room/laundry room with a sink, simplifying household chores. Embrace the tranquility of outdoor living on the large screened-in porch. This property offers more than just luxury living; it also boasts practical amenities including a well with a filter and water softener, a detached 2-car carport, and a 16 x 40 utility building providing ample storage space. For the outdoor enthusiast, a 35 x 36 shed, partially enclosed, offers versatility for various needs. Approximately 1 acre is fenced in, ideal for horses or other livestock, while approximately 16 acres are dedicated to the Long Leaf planted pine tree program, providing not only a steady income of around $1100 per year for the next 2 years but also promising future income potential with long-leaf straw, estimated at $200 per acre annually. With approximately 7.5 acres of natural woods and a thriving deer population in the area, this property offers the perfect blend of modern comfort and rural bliss making it an unparalleled opportunity to embrace a lifestyle of tranquility and luxury amidst nature's splendor. Call now to View.
MlsNumber: 57949


Listing Provided By: NATIONAL REALTY COMPANY, original listing
Name: NATIONAL REALTY COMPANY
Phone: (229) 273-4132
Office Name: NATIONAL REALTY COMPANY
Office Phone: (229) 273-4132
Agent Name: Jeff Smith
Disclaimer: Copyright © 2024 Crisp Area 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