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

491 Pecan
Cobb, GA 31735
Kristina Horne with RE/MAX OF ALBANY, original listing - (229) 434-1600

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $799,900
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 4454 Square Feet
Agency: RE/MAX OF ALBANY
Agency Phone: (229) 434-1600

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Property Type: Residential-Other
Year Built: 2006
Notes: Discover your personal slice of paradise with this stunning 3-bedroom, 2.5-bath, 2,582 sq. ft. home, just 5 minutes from Lake Blackshear in Cobb, GA. Perfect for outdoor enthusiasts, this hunter's haven sits on 10 acres in the heart of quail country, where the #1 crossbow buck in Sumter County was taken—right behind this house. The home features an open-concept kitchen and living area with luxury vinyl plank flooring, tongue-and-groove ceilings, and recessed lighting. The kitchen is a chef's dream, showcasing stainless steel appliances, quartz countertops, and plenty of room to entertain. Off the living room, you'll find a versatile space perfect for an office, den, or craft room. The enclosed garage adds even more flexibility, serving as a potential mudroom, bonus room, or hobby space with its own half bath. Outside, the property shines with features that make it an entertainer's delight. Two 26x36 buildings with 6-inch spray foam insulation, 2x6 paneling, and beautifully finished concrete floors are perfect for man caves, game rooms, or extra space for kids and gatherings. The property also includes two sets of dog kennels making this an ideal option for an avid hunter or dog enthusiast. This property is not part of any conservation program, giving you full freedom to enjoy the land. With so many unique features to explore, this home is truly a must-see! Whether you're a hunter, nature lover, or looking for a serene escape, this one-of-a-kind property is waiting for you! Schedule your showing today and make this quaint gem yours!
MlsNumber: --
ListingId: 164101


Listing Provided By: RE/MAX OF ALBANY, original listing
Phone: (678) 523-2861
Office Phone: (229) 434-1600
Agent Name: Kristina Horne
Disclaimer: Copyright © 2024 Albany Board of Realtors and Southwest Georgia MLS. 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