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

502 Whitworth Street
Berwick, LA 70342
Calyn Welch with Simon Real Estate, LLC, original listing - (985) 395-7878

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $489,000
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 3767 Square Feet
Agency: Simon Real Estate, LLC
Agency Phone: (985) 395-7878

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1998
Notes: NEW Roof Installed & Fencing in Process of being installed! Situated on almost a Half an Acre along Berwick's Picturesque Golf Course, this Exquisite Beauty is a One of a Kind Find! If you Love to Entertain, this home is Perfect for You as Both the Interior and Exterior offer Exceptional Space & Layout! Upon Entering you are Welcomed by a Beautiful Grand Staircase that Cascades down the center of the Foyer, making this a Breathtaking Entrance! The Many Features of the Interior include, but are not limited to, a Spacious Split-Level Living Room that offers Great Space and beautiful Natural Light, a Formal Dining Room, Kitchen with an Abundance of Storage, Island with Range, Stainless Appliances that are Less than 2 Years Old, Pantry & Granite Countertops, Split-Level Den with Gas Fireplace that overlooks the Back Patio and Kitchen, 4 Bedrooms with Great Closet Space, 3 Baths, Laundry Room with Storage, Large Primary Suite with Sitting Area, Walk-In Closet w/Built-Ins, Dressing Vanity, Soaker Bathtub, & Walk-In Shower, and MORE! The Exterior Offers a Spacious Fenced-In Backyard with Rear Yard Access, Covered Back Patio with an Exceptional Outdoor Kitchen Featuring a Natural Gas Grill, Additional Burners, a Big Green Egg Grill, & Mini Refrigerator, an Open Back Patio, Entire Home Generator, a Fiberglass Pool that was Resurfaced in 2024, 3 Car Garage, and More! Other Features include, but are not limited to, Breaker Panel Updated in 2024, Central Vacuum System and has minimal traffic since it is located on a cul-de-sac street! Located in Flood Zone X, NO Flood Insurance Required! Schedule Your Private Viewing Today! This Home could be Perfect for Your Family and offers Great Space Entertaining! *All measurements to be verified by the Buyer*
MlsNumber: --
ListingId: 11336000


Listing Provided By: Simon Real Estate, LLC, original listing
Phone: (985) 395-7878
Office Phone: (985) 395-7878
Agent Name: Calyn Welch
Disclaimer: Copyright © 2024 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