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

222 Tiger Tail Rd
Houma, LA 70360

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $975,000
Beds: 5
Baths: 5
Status: Active
SqFt: 4957
Agency: Bayou Partners Investments, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1987
Notes: ++++ PRICE IMPROVEMENT++++ PERFECT TIME OF THE YEAR....17' X 42' HEATED SALTWATER POOL WITH TANNING LEDGES, IN WATER UMBRELLAS, SPA TUB WITH WATERFALL WITH CHAIN WALL, AMAZING LIGHTING AT NIGHT AND 2,252 SQ.FT. OF TRAVERTINE DECKING. *******PRICED SIGNIFICANTLY BELOW APPRAISAL******* +++++EXCELLENT AND IMPORTANT INFORMATION .... EFFECTIVE 9/7/2023, FLOOD ZONE: X 0.2 PERCENT CHANCE OF FLOOD HAZARD IN COAsTAL ZONE. 7.4 FT. GROUND ELEVATION....THIS MEANS THAT A LENDER WILL NOT REQUIRE FLOOD INSURANCE+++++ HOME IS IN EXCELLENT CONDITION AND IS WELL MAINTAINED ON A REGULAR BASIS. HOME IS PERFECTLY NESTLED IN SUGAR MILL POINT ESTATES....NAVIGATES OUT OF THE SUBDIVISION FROM SEVERAL OUTLETS AND DIRECTIONS. MAJESTIC ENTRANCE INTO HOME FEATURING 20' CEILINGS, OUTSTANDING CHANDELIERS, COLUMNS, CHERRY WOOD STAIRCASE. THIS AREA WOULD BE CONSIDERED THE GRAND ROOM. TO THE LEFT SIDE IS AN ELEGANT FORMAL LIVING ROOM WITH REGAL FIREPLACE AND MAHOGANY FLOORS EXTENDING IT'S FLOW THROUGH THE FORMAL DINING AREA. RIGTH SIDE OF THE GRAND ROOM IS A MASTER SUITE WITH SEPARATE OFFICE AND FIREPLACE. CENTRAL TO AREA GOES INTO A LESS FORMAL FAMILY ROOM WITH FIREPLACE AND OPEN TO KITCHEN. FRENCH DOORS OF BEDROOM AND FAMILY ROOM GO OUT TO COURTYARD. CUSTOM KITCHEN WITH GRANITE CENTER ISLAND WITH GAS COOKTOP AND STAINLESS APPLIANCES..... OPEN TO FAMILY ROOM AND REAR BONUS AREA AND ANOTHER GUEST SUITE. FROM THIS AREA, YOU CAN STEP OUT TO A FULLY SCREENED ENTERTAINMENT COVERED PATIO. UPPER FLOOR IS 1,560' WITH 2 GUEST SUITES WITH PRIVATE BATHS AND ANOTHER BEDROOM. UPGRADES INCLUDE: POOL STATED ABOVE AND DECKING, 20 KW GAS AUTO TRANSFER GENRAC. NEW ROOF WITH RIDGE TILES. 2 NEW CHIMNEY STACKS. BACK PATIO IS COVERED.....WITH TORCH DOWN COMMERCIAL ROOF ABOVE PATIO AND COURTYARD AREA. SO MUCH MORE.....A LIST IS AVAILABLE OF IMPROVEMENTS. ALL INFORMATION TO BE VERIFIED BY BUYER.....NO SIGN IN YARD. LIST OF IMPROVEMENTS AVAILABLE IN DOCUMENTS.
MlsNumber: 2023015652


Listing Provided By: Bayou Partners Investments, LLC, original listing
Name: Bayou Partners Investments, LLC
Phone: (985) 262-4400
Office Name: KELLER WILLIAMS BAYOU PARTNERS
Office Phone: (985) 262-4400
Agent Name: Cindy King
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