Horses in CA is only one section of HSC's State by State Sale Listings. All sale listings are searchable by breed, state, and performance &
rider suitability.
Use our Main Search to find California sale horses by breed & discipline -- Or use the Quick Search at the top of this page, which includes many CA cities and areas of the state.
select distinct hfslistings.*, (hfslistings.expiry_date < date_sub(CURDATE(), INTERVAL 7 DAY)) as is_expired, (hfslistings.expiry_date < date_sub(CURDATE(), INTERVAL 7 DAY) OR hfslistings.is_featured = 0) as not_current_feature, date_add(hfslistings.feature_listings_expiry, INTERVAL 7 DAY) as adjustup_feature_expiry from hfslistings where 1=1 and state = '3862' and mainlistings_completed='1' and description_completed='1' and disciplines_completed='1' order by not_current_feature, rand(11)
|
