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

6418 Topsy Bel Road
Ragley, LA 70657
ANALEE DUPUIE with RE/MAX ONE, original listing - (337) 725-4663

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $356,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: RE/MAX ONE
Agency Phone: (337) 725-4663

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 27,443 sqft
Garage: Garage
Property Type: Residential Multi Family-Single Family Residence
Year Built: 2018
Notes: **$1000 BONUS TO THE SELLING BROKER WHOSE BUYER GOES UNDER CONTRACT BY MARCH 31, 2024, AND TRANSACTION CLOSES** This 4 bedroom/3 bathroom newly remodeled house is in close proximity to three casinos which make it ideal as a bed and breakfast. Coushatta Casino is about 25 minutes to the northeast while the Golden Nugget and L'auberge are only 30 minutes to the west. The house was built in 2018 but received a total remodel after Hurricanes Laura and Delta. It was gutted and received a new architectural roof, walls, ceilings, floors, interior doors, cam lights, baseboards, ceilings, ceiling fans, triple crown molding, master bedroom tray ceiling, window and door headers, a new window in the upstairs bonus room and one in the garage, insulation, custom cabinets and hardware in the kitchen and laundry, granite in kitchen, laundry, and upstairs bedroom and travertine backsplash. The modern kitchen features an island with an eat-in bar, farm sink, pot filler, and 5 burner high-end gas range. Additionally, the upstairs exterior AC unit was replaced and all new ductwork installed. The large bonus room upstairs can accommodate several beds. The house features an electric fireplace with a wooden mantel and surrounds. Most of the gutters were replaced and the landscaping was refreshed with many new plants including gardenia bushes and Hibiscus trees and new mulch. Guests will enjoy the outdoor kitchen which boasts of a grill and hibachi, sink, and granite counters. A 10 x 16 barn-style shed with two lofts was brought onto the property after the hurricanes. Because the owners had to live in their 5th wheel on the side of the house during the renovations, a culvert was installed to form a second driveway and dirt and crushed concrete were laid to create firm parking. A 50 amp service was installed as well. All of this additional parking would serve well for a B & B. Current owners are relocating to a smaller house to prepare for future retirement. One of the owners is a licensed realtor in La. Flood zone X.
MlsNumber: --
ListingId: SWL24001195


Listing Provided By: RE/MAX ONE, original listing
Phone: (337) 478-2668
Office Phone: (337) 725-4663
Agent Name: ANALEE DUPUIE
Disclaimer: Copyright © 2024 Greater Southern 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