$454,900
Geismar, LA 70734
MLS# 200ICS
4 beds | 3 baths
1 / 36
Property Description
This move-in-ready French Traditional sits on a prime lot with a serene water view and offers 4 bedrooms and 3 bathrooms of comfortable living space. Natural light fills the home from the moment you walk in, and the finishes are warm and inviting. The gourmet kitchen features rich custom wood cabinetry, granite countertops, an expansive angled eat-in island, and stainless steel appliances. The living room is anchored by a classic fireplace with a marble surround, with hardwood floors and floor-to-ceiling windows that frame the backyard and water. The primary suite offers a tray ceiling, a bay window overlooking the water, and a spa-style bath with dual vanities, a jetted soaking tub, a custom tile and marble shower, and a generous walk-in closet. Enjoy morning coffee or evening cookouts on the manicured lawn that slopes gently toward the water, with a covered back patio for year-round use. The home is in a family-friendly Geismar community in an excellent school district, with quick access to I-10 for easy commutes to Baton Rouge and New Orleans.
Details
Listing Information
Comp Sale YN: No
Property Sub Type: Single Family Residence
Lock Box Association: GBRAR
Status Change Information
Status Change Timestamp: 2026-10-29
Delayed Marketing: No
Address
Parish or County: Ascension
MLS Area Major: ASC MLS Area 91
Street Number: 12457
Street Name: Legacy Hills
Street Suffix: Drive
City Limits YN: Yes
State: LA
Postal Code (Zip): 70734
Directions: See map.
Parcel Number: 20022760
Contract
Current Price: $454,900
Original List Price: 454900
Status: Active
Listing Contract Date: 2026-10-20
List Price: $454,900
Listing Agreement: Exclusive Right To Sell
Listing Service: Full Service
Occupant Type: Vacant
List Price/SqFt: 170.69
Interior
Bedrooms Total: 4
Bathrooms Total: 3
Bathrooms Full: 3
Living Area: 2665
Living Area Units: Square Feet
Living Area Source: Estimated
Basement YN: No
Fireplace YN: Yes
Fireplaces Total: 1
Parking Information
Garage YN: Yes
Garage Spaces: 2
Carport YN: No
Building
Year Built: 2007
Approximate Age: 16 - 20 Years
Property Attached YN: No
Home Warranty YN: No
Lot
Lot Size Acres: 0.33
Lot Size Square Feet: 14374.8
Lot Size Dimensions: 73.92 x 80 x 150
Pool Private YN: No
Land Lease YN: No
Waterfront YN: Yes
Sign On Property YN: Yes
Remarks
Public Remarks: This move-in-ready French Traditional sits on a prime lot with a serene water view and offers 4 bedrooms and 3 bathrooms of comfortable living space. Natural light fills the home from the moment you walk in, and the finishes are warm and inviting. The gourmet kitchen features rich custom wood cabinetry, granite countertops, an expansive angled eat-in island, and stainless steel appliances. The living room is anchored by a classic fireplace with a marble surround, with hardwood floors and floor-to-ceiling windows that frame the backyard and water. The primary suite offers a tray ceiling, a bay window overlooking the water, and a spa-style bath with dual vanities, a jetted soaking tub, a custom tile and marble shower, and a generous walk-in closet. Enjoy morning coffee or evening cookouts on the manicured lawn that slopes gently toward the water, with a covered back patio for year-round use. The home is in a family-friendly Geismar community in an excellent school district, with quick access to I-10 for easy commutes to Baton Rouge and New Orleans.
Disclosure Details
Special Listing Conditions Remarks: Corporate RELOCATION!
Land Details
Mineral Rights: Conveyed
Lock Box Location
Lock Box Location: Front Door
Utility Providers
Electric Provider: Entergy
Gas Provider: Atmos
Water Provider: Ascension Water Co.
Tax Legal
Subdivision Name: Legacy Hills
Property Features
Utilities: Electricity Connected; Natural Gas Connected; Water Connected; Electricity Connected; Natural Gas Connected; Water Connected
Appliances: Dishwasher; Disposal; Electric Oven; Exhaust Fan; Gas Cooktop; Gas Stove Connection; Microwave; Oven; Stainless Steel Appliance(s)
Architectural Style: French Provincial
Association Fee Includes: Common Area; Common Area Maintenance; Maintenance of Subdivision Entry
Construction Materials: Block
Cooling: Central Air
Electric: Circuit Breakers
Fencing: Full
Fireplace Features: Gas
Flood Zone(s): X
Flooring: Carpet; Ceramic Tile; Wood
Foundation Details: Slab
Green Energy Efficient: HVAC; Insulation
Heating: Central
Interior Features: Computer Nook; Crown Molding; Eat-in Kitchen; En Suite; Entrance Foyer; High Ceilings; Jetted Tub; Kitchen Island; Pantry; Quartzite Counters; Separate Shower; Shower/Tub Combo; Solid Surface Counters; Standalone Tub; Storage; Tile Counters; Varied Ceiling Heights; Walk-In Closet(s)
Laundry Features: Electric Dryer Hookup; Inside; Laundry Closet; Sink; Washer Hookup
Levels: One
Listing Terms (Financing): Cash; Conventional; FHA; USDA/Rural Development; VA Loan
Lock Box Type: Combo; Supra
Lot Features: Landscaped
Parking Features: Attached Garage; Driveway
Road Frontage Type: Private Road
Road Surface Type: Asphalt
Roof: Shingle
Security Features: Carbon Monoxide Detector(s); Smoke Detector(s)
Sewer: Public Sewer
Structure Type: House
View: Creek/Stream; Water
Water Source: Public
Window Features: Bay Window(s); Screens
Waterfront Features: Creek
Showing Requirements: Appointment Only; Lockbox; Show Anytime
Room Information
| Room Name | Level | Dimensions |
| Kitchen | First | 15.8 x 17.8 |
| Primary Bedroom | First | 21 x 16.2 |
| Primary Bathroom | First | 14.7 x 10.3 |
| Bedroom | First | 12.7 x 11.3 |
| Bedroom | First | 13.5 x 12 |
| Bedroom | First | 12.5 x 11 |
| Bathroom | First | 9.6 x 10.3 |
| Bathroom | First | 9.1 x 5.3 |
Listing Office: Keller Williams Realty-First Choice
Office Phone: 225-744-0044
Office Email: juli@julijenkins.com
Last Updated: October - 30 - 2026
Information deemed reliable but not guaranteed.
Broker Attribution:
225-744-0044
GUIDRY & CO. REAL ESTATE, Lafayette, LA. All offices are independently owned and operated. The data relating to real estate for sale on this web site comes in part from the IDX Program of the Realtor® Association of Acadiana; MLS Real Estate listings held by brokerage firms other than GUIDRY & CO. REAL ESTATE are marked with the MLS approved icon for
IDX
. “Information Deemed Reliable But Not Guaranteed”. Copyright 2016 REALTOR® Association of Acadiana, All rights reserved.
Licensed & Regulated in the jurisdiction of the Louisiana Real Estate Commission, Members of the National Association of Realtors®, Louisiana Realtors®, Realtor® Association of Acadiana, Multiple Listing Service (MLS), Louisiana Commercial (www.lacdb.com), The Realtor® Commercial Alliance, Equal Housing Opportunity.