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

111 Janise Lane
Ragley, LA 70657

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $384,500
Beds: 4
Baths: 3
Status: Active
SqFt: 2284
Agency: Coldwell Banker Ingle Safari Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 2024
Notes: Just completed this stunning new construction 4 bedroom, 3 bath home. It is situated in a picturesque and serene country setting on 2 lots/ 1.2 acres, offering the perfect combination of tranquility and modern living. Located within easy reach of modern amenities and major highways, this location provides the best of both worlds. The lot is over a half acre located in Dream Home Subdivision in the Ragley/Topsy area and is situated on the community pond. You must see the exterior of this home which boast a charming design, blending seamlessly with the natural surroundings and creating a warm and inviting atmosphere. Step inside and be amazed by the meticulous attention to detail and luxurious finishes throughout. The open floorplan allows for seamless flow and abundant natural light creating a bright and airy ambiance. The gourmet kitchen is a chefs delight, featuring upgraded appliances, abundance of beautiful custom cabinets, granite counters, spacious island perfect for entertaining and walk-in pantry. The main living space features high ceilings and is open to kitchen & dining areas. Large breathtaking master suite boasts tray ceiling, oversized walk-in closet with built-ins, double vanities, granite counters, custom tile shower & soaking tub. Spacious laundry room with extra storage. All bedrooms are spacious w/nice size closets. This floorplan has an upstairs bonus room that could be used as an game room or 4th bedroom. Large covered patio with outdoor kitchen area featuring granite counter tops and sink. 2 car garage with extra storage room. Loaded with extras and has the WOW factor. Flood Zone X so no flood insurance required by mortgage & 100% rural financing. Whether you are looking to escape the hustle and bustle of city life or simply enjoy nature, this country home offers the perfect retreat.
MlsNumber: SWL23002100


Listing Provided By: Coldwell Banker Ingle Safari Realty, original listing
Name: Coldwell Banker Ingle Safari Realty
Phone: (337) 274-5684
Office Name: Coldwell Banker Ingle Safari R
Office Phone: (337) 478-1601
Agent Name: ROBBIE INGLE
Disclaimer: Copyright © 2024 Greater Southern 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