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

36149 Belle Parc Ave
Geismar, LA 70734
Jennifer Waguespack with Keller Williams Realty Red Stick Partners, original listing - (225) 768-1800

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $484,541
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 2630 Square Feet
Agency: Keller Williams Realty Red Stick Partners
Agency Phone: (225) 768-1800

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2025
Notes: Stunning Burnside B plan by Level Homes underway in Belle Savanne, located off Hwy 73 just before Dutchtown High! The “Burnside” floor plan is a spacious two-story home with four bedrooms, three and a half baths, an office, and a loft with just over 2600 sq feet! You will enter this home from the front stoop with a hanging gas lantern into the foyer, which leads to the office at the front of the home and then into the open living room, kitchen, and dining area. The living room is centered around a vent-less gas fireplace with granite surround and looks out to the large covered rear porch and yard. The gourmet kitchen features custom painted cabinets with 5-inch hardware pulls and under cabinet lighting, large center island with 30” stainless steel single basin farm sink and overhanging pendant lights, 3 cm Alaska White granite counter surfaces, 3x6 ice white beveled subway tile backsplash, stainless appliances including a 30" 5 burner gas cooktop with a single wall oven and built in microwave, custom hood vent and a walk-in corner pantry. The master suite is located off the rear of the home with a spa-like bathroom with dual sinks, separate tub and shower and a spacious walk-in closet. Upstairs features a spacious loft / playroom area, three bedrooms with walk-in closets, and two full baths. The spacious utility room, a mudroom with room for an “optional” built-in mud bench and the powder room are located downstairs off the garage entry. The yard will be professionally landscaped and fully sodded! Estimated completion date of May 2025, buyer can pick/approve certain colors and options for a limited period of time. Other lots and plans available. Belle Savanne is a walkable neighborhood featuring multiple lakes, green space and a stunning community pool with cabana. *The completed pictures are not of the actual home but are of the same floorplan; colors and options may vary.
MlsNumber: --
ListingId: 2025001094


Listing Provided By: Keller Williams Realty Red Stick Partners, original listing
Phone: (225) 768-1800
Office Phone: (225) 768-1800
Agent Name: Jennifer Waguespack
Disclaimer: Copyright © 2025 Greater Baton Rouge Association 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.


Local Real Estate Expert

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 = 1120 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;
Jay Castellanos with Team 225 Homes
ASCIIProperty First Realty Group
Call Today!: (225) 390-6188

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App