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

213 West 86th Street
Cut Off, LA 70345

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $699,000
Beds: 4
Baths: 5
Status: Active
SqFt: 6568
Agency: Cabin Realty LLC/USA

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 1980
Notes: Absolutely stunning is the phrase that describes this unique home. Main house is filled will awesome amenities which include solid sheeting in and out with 5/8" plywood, oak floors, vaulted cathedral ceilings, wood burning fire place, granite cabinet tops in kitchen, large spacious closets, marble floored foyer, private dining room, library, sun room, land scaped yard with mature oak trees. Out door living areas includes slated decking surrounding in ground heated pool & hot tub, creating a paradise at home. Then there is the jewel of this dream home which is the custom built cabana/guest home offering antique knotted pine floor high cathedral ceilings, a large rec room with full open kitchen , a second large entertainment room which features high ceilings, a massive custom built gun cabinet, fire place, built in wet bar, guest bed room with attached half bath , 2nd full bath, large closet, and slate floor which opens up to an enormous deck. Remaining in Cabana/Guest house is pool table, gas stove , 2 subzero drawer refrigerators, 2 subzero drawer freezers, & dishwasher. When it comes to entertaining and hosting parties this home is ideal! The Cabana/guest house offers a seller the possibility of 2nd home income, mother in Law living quarters, & possibly a party/wedding venue. Post Ida the following repairs have made this home practically new: 2022 new roof, replaced 40 sheets of sheetrock, replastered all sheetrock walls, all fresh paint through out both main house and Cabana, all new lighting and light switch cover in main, some facia and repair in main house, refinished kitchen & laundry room cabinets in main, and added new back splash in kitchen. This grand home awaits you! (measurements are not warranted by sellers and are to be verified by buyers)
MlsNumber: 2024008289


Listing Provided By: Cabin Realty LLC/USA, original listing
Name: Cabin Realty LLC/USA
Phone: (985) 475-4710
Office Name: CABIN REALTY, LLC
Office Phone: (985) 664-3030
Agent Name: Rhonda Comeaux
Disclaimer: Copyright © 2024 Bayou Board 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