Western is only one section of HSC's sale listings, and is searchable by name, breed, disciplines and state.
Click to view current Western horses for sale. -- OR Use the Quick Search at the top of the page.
select distinct hfslistings.*, date_add(hfslistings.feature_listings_expiry, INTERVAL 7 DAY) as adjustup_feature_expiry from hfslistings, hfslistingsXperformancesuitability where 1=1 and hfslistingsXperformancesuitability.listing_id = hfslistings.id and (hfslistingsXperformancesuitability.performance_suit_id = '642' or hfslistingsXperformancesuitability.performance_suit_id = '209' or hfslistingsXperformancesuitability.performance_suit_id = '210' or hfslistingsXperformancesuitability.performance_suit_id = '217' or hfslistingsXperformancesuitability.performance_suit_id = '229' or hfslistingsXperformancesuitability.performance_suit_id = '233' or hfslistingsXperformancesuitability.performance_suit_id = '234' or hfslistingsXperformancesuitability.performance_suit_id = '235' or hfslistingsXperformancesuitability.performance_suit_id = '236' or hfslistingsXperformancesuitability.performance_suit_id = '238' or hfslistingsXperformancesuitability.performance_suit_id = '239' or hfslistingsXperformancesuitability.performance_suit_id = '242' or hfslistingsXperformancesuitability.performance_suit_id = '243' or hfslistingsXperformancesuitability.performance_suit_id = '244' or hfslistingsXperformancesuitability.performance_suit_id = '245' or hfslistingsXperformancesuitability.performance_suit_id = '651') and mainlistings_completed='1' and description_completed='1' and disciplines_completed='1' order by horse_name asc
|
