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

21211 Dewberry Road
Kaplan, LA 70548
Michelle Foreman with Keaty Real Estate Team, original listing - (337) 235-7770

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $975,000
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 4440 Square Feet
Agency: Keaty Real Estate Team
Agency Phone: (337) 235-7770

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: --
Notes: Meticulously built with every detail thought of, this three bed, three bath home has so much character and charm! Wood salvaged from the late 1800s was used for many of the built-ins and for a lot of the flooring! Brick floors lead you through the kitchen, which has ample counter space. Just past the kitchen is a walk-in pantry, a laundry room with a sink and added storage, a restroom, and the garage-which can also be used as an additional entertaining area. Not only is the garage climate controlled, it also has a wet bar, storage, access to a SECOND full kitchen, and doors that open to the pool-a 24,000 gallon gunite pool framed by an Italian travertine deck. Sit back and enjoy the pool views from the covered outdoor patio, equipped with ceiling fans and a fireplace. While you could practically live outdoors, the indoors also has so much to offer. An elegant floor to ceiling brick fireplace in the living room commands attention. The living room is equipped with a wet bar and views of pool area. The primary bedroom has a comfortable seating area overlooking the pool, making this room a peaceful oasis. The primary restroom is spacious and has double sinks and a large walk-in closet with built-ins. Two separate stairwells make accessing the upstairs of this home very easy. Each upstairs bedroom has a cozy window seat nook, yet another perfect space for relaxation. There is also a spacious bonus room and an office. Additional upgrades include a central vacuum, storm shutters, hurricane bars on all garage doors (house and shop), plenty of storage, climate controlled shop with a sink, heated and cooled attic storage space, and a wrapping closet. The luxurious finishes are endless! Please note full list of impressive upgrades, too many to list here! This home isn't just a place to live--it's a piece of history! Pre-inspection done, ready to move-in! Option to purchase additional land.
MlsNumber: --
ListingId: 25000335


Listing Provided By: Keaty Real Estate Team, original listing
Phone: (337) 235-7770
Office Phone: (337) 235-7770
Agent Name: Michelle Foreman
Disclaimer: Copyright © 2025 Realtor Association of Acadiana. 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