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 = 1120 AND i.igate IN ('usahud','lahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'lahud', 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 = 1120 AND i.igate IN ('usahud','lahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'lahud', 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 = 1120 AND i.igate IN ('usahud','lahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'lahud', 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;

18441 Amite Acres Dr
Prairieville, LA 70769
Tom Bhramayana with Keller Williams Realty Premier Partners, original listing - (225) 664-1911

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,135,000
Beds: 4
Baths: Full: 3, ½: 2
Status: Active
SqFt: 4174 Square Feet
Agency: Keller Williams Realty Premier Partners
Agency Phone: (225) 664-1911

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2007
Notes: NEW ROOF!!! The Jewel of the Amite River offers stunning waterfront views, with over 9000 sq/ft of pure pleasure, entertainment, and recreation. This spacious home has an open split floorplan, large porches, tons of covered parking, garage, and a workshop. The expansive home is nestled on a 0.58-acre lot with 125’ of bulkhead, a 34x32 covered boat slip with lift, 23x10 deck, a 33x15 gunite pool, and a patio equipped with large mason fireplace. The interior boasts 20’ ceilings in the living room with exposed wood beams, a stone face woodburning fireplace with gas starter, and has a retractable window wall that opens up to a large riverside screen porch with fireplace. The kitchen has a large 8-person center island with granite counters, wood stained and staggered cabinets with over and under lighting, stainless steel 5 burner GE Café gas range and convection oven, full fridge, mini fridge, ice maker, two undermount sinks with one being a prep sink. The master bedroom is large with river views through wood trim cased windows with transoms and offers access to the bottom floor and dog yard. Master bath has large walk-in shower with 2 shower heads, 72” jetted tub, dual vanities, toe warmers, and a massive 16x14 master closet with dresser island with granite counter, & dressing mirror. All floors are accessible by elevator equipped with metal accordion safety gates & stained wood panels. Guest beds share a Jack and Jill bath with dual vanities & jetted tub. The third floor has a rec-room and a guest suite with full bath and a riverside balcony with breathtaking views. Additional features: metal railings on all porches, landscaped with irrigation, drainage, and lighting, a climate-controlled bottom floor bathroom, dog washroom, RV cover with power hookups, oversized driveway, an outdoor kitchen with concrete countertops, Bull grill and cooktop, and prep sink. Just 30 minutes from Baton Rouge and convenient to shopping, medical & dining.
MlsNumber: --
ListingId: 2023017899


Listing Provided By: Keller Williams Realty Premier Partners, original listing
Phone: (225) 933-8942
Office Phone: (225) 664-1911
Agent Name: Tom Bhramayana
Disclaimer: Copyright © 2024 Greater Baton Rouge Association 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