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

479 Rivermont Circle
Pickensville, AL 35447
John Marine, Jr with Logan Land Co., original listing - (205) 372-9800

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $495,000
Beds: 3
Baths: Full: 3, ½: 1
Status: Active
SqFt: 2693 Square Feet
Agency: Logan Land Co.
Agency Phone: (205) 372-9800

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: --
Notes: This waterfront home offers some of the most spectacular sunsets you will ever see anywhere on the Tombigbee River. Aliceville Lake is known for its tremendous fishing and watersport opportunities. Rivermont residents own a share of the boat launch, pavilion and playground area. This home is conveniently located to all three. Recent upgrades include the walkway to the boat dock, replaced decking at docks, all new handrails on the decks of the house, and replaced the pressure treated lumber on porches and decks. New stairways on both decks were completed. A new 40' by 40' shop with three roll up, bay doors adds the convenience of storage for all of your boats, equipment and other items. This shop has a 16' x 16' bedroom inside for overflow of guests, or for use as needed. The streets have been upgraded and repaved. The beautiful home consists of 3 spacious bedrooms, a loft bedroom,3.5 large baths, kitchen, dining, family room and beautiful loft. Kitchen appliances will remain with the home. Two bedrooms are on the main level,and the lower level offers a spacious 3rd bedroom with full bath, carport and utility area. The home also features a utility and laundry room with cabinets, a built in gun cabinet, walk in closets, and a fireplace with gas logs. The two car garage with doors, and outside utility room with door offers added convenience. The topography of the lot is level with a gentle grade to waterfront and 2 slip boat houses with metal roof and seawall. The lot is spacious and landscaped with beautiful open views of Aliceville Lake. Property is serviced with county water. Cell service is good with AT&T tower located approximately 1 mile away, and fire protection from local fire department is within 2 miles, Home is built on concrete and brick reinforced piers, Pella windows with built in blinds, 6-year-old heat pump, and 2 year old asphalt architectural shingles. Columbus MS is located approximately 20 minutes away. Lowndes County also offers a hospital (Baptist Memorial Hospital-Golden Triangle). This is truly a move in ready home with beautiful views and convenient access to the Tombigbee River. You will not find a more peaceful location with the ease of access. If you're looking for that perfect family get away of forever home don't miss out on this opportunity. Showings will be by appointment only. Property is being sold as-is and unfurnished.
MlsNumber: --
ListingId: 11504670


Listing Provided By: Logan Land Co., original listing
Phone: (205) 372-9800
Office Phone: (205) 372-9800
Agent Name: John Marine, Jr
Disclaimer: Copyright © 2025 My State 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