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','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 = 1147 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 = 1147 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;

216 Ridgewood Blvd.
Golden Meadow, LA 70357
Brandi Phillips with NextHome Solutions, original listing - (225) 744-6403

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $710,000
Beds: 5
Baths: Full: 3, ½: 1
Status: Active
SqFt: 4600 Square Feet
Agency: NextHome Solutions
Agency Phone: (225) 744-6403

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1983
Notes: This exquisite 5-bedroom, 3.5-bath home has undergone a complete renovation, down to the studs, ensuring modern updates throughout while maintaining its timeless charm. Boasting solid sheeting and entirely new wiring, beautiful pine hardwood floors and brass knobs, this residence is a showcase of both luxury and durability. The dream kitchen features stunning 3cm quartz countertops, with an expansive island that comfortably seats 12. Top-of-the-line Wolf appliances include a 36" 6-burner gas stove, warming drawer, microwave drawer, and four 30" Sub-Zero refrigerator drawers. Also, a separate 30" Sub-Zero refrigerator and freezer, plus there is a nugget ice maker and a Wolf vacuum pack machine built in. The kitchen has a large walk-in pantry for ample storage. A cozy keeping room is situated off the kitchen, and the formal dining room is adorned with a chandelier. The living room has a wood-burning fireplace and has a large wall of windows which provides a view of the lush backyard. The master suite includes a sitting area, a wood burning fire place, a massive walk-in closet with shelving, space for shoes and handbags, and a luxurious master bath with quartz countertops, a makeup station, and an oversized shower. Upstairs, you have an office that could serve as a sixth bedroom. Bedrooms 3 and 4 share a Jack-and-Jill bath. Both rooms feature built-ins in their walk-in closet, along with ample storage and play space in the dormer areas. Situated on a beautifully landscaped 2-acre lot, this home offers a covered brick back patio, and large covered front porch, perfect for outdoor relaxation. Two on-demand water heaters, and three separate A/C units plus a large storage shed with plenty space for freezers. With extra rooms such as an office, game room with pool table, and bonus room, this home offers plenty of space for versatile living. There is an additional 10 acres that is available for purchase! Schedule your appointment today!
MlsNumber: --
ListingId: 2024018780


Listing Provided By: NextHome Solutions, original listing
Phone: (225) 413-7655
Office Phone: (225) 744-6403
Agent Name: Brandi Phillips
Disclaimer: Copyright © 2024 NextHome, Inc. 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