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

575 Zick Miller Rd
Sunset, LA 70584
Oliver Carmichael with Wildlife Land Group, original listing - (337) 345-1797

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,379,500
Beds: 2
Baths: Full: 1
Status: Active
SqFt: 860 Square Feet
Agency: Wildlife Land Group
Agency Phone: (337) 345-1797

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 28 acre(s)
Garage: Garage
Property Type: Farm-Farm
Year Built: --
Notes: Prime 28.7-Acre Development Opportunity on the Coveted Coteau Ridge This remarkable 28.7-acre property in southern St. Landry Parish, Louisiana, offers an unparalleled investment and development opportunity. Boasting over 850 feet of road frontage on Zick Miller Road, this property is perfectly positioned on the sought-after Coteau Ridge, just minutes from Lafayette, Sunset, and Opelousas. With seamless access to the I-49 frontage road, it's an ideal location for a residential development or a private equestrian estate. Currently serving as a horse boarding and training facility, this property is fully equipped to meet equestrian needs: • Structures & Facilities: o A 2,475 sq. ft. exercise barn complete with an exercise pool. o A 1,500 sq. ft. metal storage building for tack, feed, or other equipment. o Stall space to accommodate over 70 horses. o Seven fully-fenced paddocks and a training track. • Residences: o A 2-bedroom, 1-bathroom single-wide mobile home, ideal for on-site living or staff housing. • Bonus: Some equipment included in the sale. Whether you envision transforming this property into a residential community, a private estate, or maintaining its equestrian focus, its location and amenities make it an exceptional offering. Don't miss this rare opportunity to own a piece of Coteau Ridge with unlimited potential.
MlsNumber: --
ListingId: 11415546


Listing Provided By: Wildlife Land Group, original listing
Phone: (337) 345-1797
Office Phone: (337) 345-1797
Agent Name: Oliver Carmichael
Disclaimer: Copyright © 2025 My State 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