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

102 E Bremond St
Colquitt, GA 39837
A. J. Bailey with Premier Group Realty, original listing - (229) 246-9837

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $215,000
Beds: 2
Baths: Full: 2
Status: Active
SqFt: 2404 Square Feet
Agency: Premier Group Realty
Agency Phone: (229) 246-9837

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1950
Notes: Welcome to this stunning 2404 sq. ft. home that welcomes you with open arms! As you cross the threshold, you'll be engulfed by the atmosphere that defines the space! The family room is not just a gathering area; it's a retreat! Picture cozy evenings by the large fireplace, a place where friends and family can truly come together! For the chef enthusiasts, the kitchen is complete with abundant cabinetry, complete with appliances, tile flooring, along with a convenient caf area for your morning coffee or evening wind-down. The adjoining breakfast nook creates a comfortable and convenient space close by the kitchen for a quick breakfast to get going or lunch to get back on the go! The dining hall is just as it sounds with grand column pillars that encapsulate the corner walls along with an elongated view into almost all the gathering areas throughout the home. Additionally, there's great potential to transform this space into a third bedroom, allowing you to customize the space to suit your needs! The primary bedroom is a central retreat with beautiful hard wood flooring and a true walk-in closet that could make you consider hiring a closet organizer! Enjoy the walk-in-tiled shower that turns your daily routine into a spa-like experience, a stylish vanity space, separate entrances to both the primary bedroom and the primary's walk-in closet areas! Your guests will feel right at home in their own private retreat, complete with their own mini walk-in closet and a full bathroom that ensures your guests have a completely convenient and comfortable experience! Outside take advantage of the attached two-car carport with extra storage, a private fenced-in backyard, an above-ground swimming pool along with a fire pit area creating the perfect setting for summertime fun and cooler weather relaxation. With a roof installed in 2019 and a 2022 HVAC system, you can feel confident in your investment. This extraordinary property is waiting for you to call it home! Call your favori
MlsNumber: --
ListingId: 13511


Listing Provided By: Premier Group Realty, original listing
Phone: (229) 220-9655
Office Phone: (229) 246-9837
Agent Name: A. J. Bailey
Disclaimer: Copyright © 2025 Southwest Georgia Board of Realtors 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