English is only one section of HSC's sale listings, and is searchable by name, breed, disciplines and state.
Click to view current English 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 = '641' or hfslistingsXperformancesuitability.performance_suit_id = '207' or hfslistingsXperformancesuitability.performance_suit_id = '208' or hfslistingsXperformancesuitability.performance_suit_id = '211' or hfslistingsXperformancesuitability.performance_suit_id = '212' or hfslistingsXperformancesuitability.performance_suit_id = '215' or hfslistingsXperformancesuitability.performance_suit_id = '216' or hfslistingsXperformancesuitability.performance_suit_id = '218' or hfslistingsXperformancesuitability.performance_suit_id = '220' or hfslistingsXperformancesuitability.performance_suit_id = '222' or hfslistingsXperformancesuitability.performance_suit_id = '224' or hfslistingsXperformancesuitability.performance_suit_id = '225' or hfslistingsXperformancesuitability.performance_suit_id = '226' or hfslistingsXperformancesuitability.performance_suit_id = '227' or hfslistingsXperformancesuitability.performance_suit_id = '228' or hfslistingsXperformancesuitability.performance_suit_id = '230' or hfslistingsXperformancesuitability.performance_suit_id = '231' or hfslistingsXperformancesuitability.performance_suit_id = '232' or hfslistingsXperformancesuitability.performance_suit_id = '241' or hfslistingsXperformancesuitability.performance_suit_id = '646' or hfslistingsXperformancesuitability.performance_suit_id = '649') and mainlistings_completed='1' and description_completed='1' and disciplines_completed='1' order by horse_name asc
|
