s?
$includeFile = "$pageDir/customFilters.php";
include($include);
// Now build actual SQL query
$filters = array();
if ($sxf) {
if ($sxf =='br') {
$sxf = 'm';
$txf = 'broodmare';
}
if ($sxf == 'w' || $sxf == 'fo') {
$agf = "0:1";
$sxf = '';
}
if ($sxf == 'y') {
$agf = "1:2";
$sxf = '';
}
}
if ($prf || $mnprc || $mxprc) {
if ($prf) {
list($mnprc,$mxprc) = split(":",$prf);
}
if (!$mnprc) {
$mnprc = 0;
}
if (!$mxprc) {
$mxprc = 10000000;
}
$filters[] = "(price >= '$mnprc' and price <= '$mxprc')";
}
if ($adf) {
if ($adf == 'ph') $filters[] = "(adclass <= 'p')";
elseif ($adf == 'hr') $filters[] = "(created >= '".date('Y-m-d',strtotime('-24 hours'))."')";
else $filters[] = "(adtype = '$adf')";
}
if ($rgf) {
//Region Filter
if ($customFilters[rgf][$rgf]) {
$innerJoin = " inner join users on (users.userid = ads.userid)";
$filters[] = $customFilters[rgf][$rgf];
} else {
$filters[] = "(title like '%$rgf%')";
}
}
if ($brf) {
//Some custom filters for some of the new breeds
//$filters[] = "(breed = '".str_replace("|","' or breed = '",$brf)."')";
if ($customFilters[brf][$brf]) {
$filters[] = $customFilters[brf][$brf];
} else {
if (ereg("\|", $brf)) {
foreach(split("\|", $brf) as $br) {
if ($customFilters[brf][$br]) {
$newFilter[] = $customFilters[brf][$br];
} else {
$newFilter[] = "(breed = '$br')";
}
}
$filters[] = "(" . join(" or ", $newFilter) . ")";
} else {
$filters[] = "(breed = '$brf')";
}
}
//}
}
if ($mnhtf || $htf || $mxhtf) {
if (!$mnhtf && !$mxhtf) {
list($mnhtf,$mxhtf) = split(":",$htf);
}
if (!$mnhtf) {
$mnhtf = 0;
}
if (!$mxhtf) {
$mxhtf = 20;
}
$filters[] = "(height >= $mnhtf and height <= $mxhtf)";
}
if ($sxf) $filters[] = "(sex = '".str_replace("|","' or sex = '",$sxf)."')";
if ($clf) {
if ($customFilters[clf][$clf]) {
$filters[] = $customFilters[clf][$clf];
} else {
if (ereg("\|", $clf)) {
foreach(split("\|", $clf) as $cl) {
if ($customFilters[clf][$cl]) {
$newFilter[] = $customFilters[clf][$cl];
} else {
$newFilter[] = "(color = '$cl')";
}
}
$filters[] = "(" . join(" or ", $newFilter) . ")";
} else {
$filters[] = "(color = '$clf')";
}
}
}
if ($usf) $filters[] = "(userid = '$usf')";
if ($aaf) {
$aaff = array();
$aafs = split('\|',$aaf);
if ($aafs[0]) $aaff[] = "adclass != 't'";
if ($aafs[1]) $aaff[] = "pregnant = '1'";
if ($aafs[2]) $aaff[] = "shipsemen = '1'";
if ($aafs[3]) $aaff[] = "adtype != 'd'";
$filters[] = "(".join(" and ",$aaff).")";
}
if ($mkf) {
$mkfs = array();
foreach (split(" ",$mkf) as $mk)
$mkfs[] = "markings like '%$mk%'";
$filters[] = "(".join(" and ",$mkfs).")";
}
if ($agf || $mnage || $mxage) {
if ($agf) {
list($mnage,$mxage) = split(":",$agf);
}
if (!$mnage) {
$mnage = 0;
}
if (!$mxage) {
$mxage = 50;
}
$filters[] = "(dob <= '".date("Y-m-d",strtotime("-$mnage years"))."' and dob >= '".date("Y-m-d",strtotime("-$mxage years"))."')";
}
if ($dtf) $filters[] = "(lastmodified >= '".date("Y-m-d",strtotime("-$dtf"))."')";
if ($rsf) $filters[] = "(registry like '%". $rsf ."%')";
if ($sld) $filters[] = "(visible < 0)";
if ($tlf) $filters[] = "(title like '%$tlf%')";
if ($txf) { $txf = urldecode($txf); $filters[] = "(name like '%$txf%' or title like '%$txf%' or comments like '%$txf%' or listdetails like '%$txf%')";}
// if ($csf) {
//modify to use the new distance filter
// $m = array(0);
// $db->query("select userid from users where city = '$csf' and state != ''");
// while ($s = $db->fetchRef())
// $m[] = $s[userid];
// $db->free();
// $filters[] = "(userid in (".join(',',$m)."))";
//}
if ($tgf) {
//Tag Filter
$tgf = urldecode($tgf);
if ($customFilters[tgf][$tgf]) {
$filters[] = $customFilters[tgf][$tgf];
} else {
if (ereg("\|", $tgf)) {
foreach(split("\|", $tgf) as $tg) {
if ($customFilters[tgf][$tg]) {
$newFilter[] = $customFilters[tgf][$tg];
} else {
$newFilter[] = "(comments like '%%')";
}
}
$filters[] = "(" . join(" or ", $newFilter) . ")";
} else {
$filters[] = "(comments like '%%')";
}
}
// if (ereg("|", $tgf)) {
// if ($tgf == "gaited") {
// $filters[] = "((breed = 'tn' or breed = 'sx' or breed = 'ra' or breed = 'mf' or breed = 'pf' or breed = 'sp' or breed = 'pp' or breed = 'rm' or breed = 'ic' or breed = 'sd' or breed = 'mo' or breed = 'fc' or breed = 'si' or breed = 'mc' or breed = 'wk' or breed = 'ti' or comments like '%walkaloosa%' or title like '%walkaloosa%') and comments like '%%')";
// } else {
// $filters[] = "(comments like '%' or comments like '%%')";
// }
// } else {
// $filters[] = "(comments like '%%')";
// }
}
if ($acf) {
$filters[] = "(adclass = '$acf')";
}
//print_r($_SESSION);
if ($ssf) {
if (!$dsf) {
//if the distance filter is set, ignore the state filter
# $m = array(0);
# $db->query("select userid from users where state = '$ssf' and state != ''");
# while ($s = $db->fetchRef())
# $m[] = $s[userid];
# $db->free();
# $filters[] = "(userid in (".join(',',$m)."))";
$innerJoin = " inner join users on (users.userid = ads.userid)";
$filters[] = "(users.state = '$ssf')";
}
}
if ($cnf) {
if (!$dsf) {
//Country and distance searches conflict
#$m = array(0);
#$db->query("select userid from users where country = '$cnf'");
#while ($s = $db->fetchRef())
# $m[] = $s[userid];
#$db->free();
#$filters[] = "(userid in (".join(',',$m)."))";
$innerJoin = " inner join users on (users.userid = ads.userid)";
if ($cnf == "United States") {
$filters[] = "(users.country = 'US' or users.country = 'USA' or users.country = '' or users.country = 'United States')";
// $filters[] = "(users.country = '$cnf')";
} else {
$filters[] = "(users.country = '$cnf')";
}
}
}
if ($fmf) {
# $m = array(0);
# $db->query("select userid from users where company like '%$fmf%'");
# while ($s = $db->fetchRef())
# $m[] = $s[userid];
# $db->free();
# $filters[] = "(userid in (".join(',',$m)."))";
$innerJoin = " inner join users on (users.userid = ads.userid)";
$filters[] = "(users.company like '%$fmf%')";
}
if ($pdf) {
$m = array(0);
$db->query("select adid from equinepedigrees where pedigree like '%;$pdf;%'");
while ($s = $db->fetchRef())
$m[] = $s[adid];
$db->free;
$filters[] = "(adid in (".join(',',$m)."))";
}
if ($tmf) {
$filters[] = "(temperment != 0 and temperment < $tmf)";
}
if ($dsf && !ereg("^:",$dsf)) {
if (!$loc) {
list ($loc,$dst) = split(':',$dsf);
}
$testState = capitalize($loc);
foreach ($stateCodeList as $code => $state) {
if ($state == $testState) {
$innerJoin = " inner join users on (users.userid = ads.userid)";
$filters[] = "(users.state = '$testState')";
$ssf = $testState;
$_SESSION['dsf'] = '';
$_SESSION['ssf'] = $testState;
$noDist = 1;
}
}
if (!$noDist) {
if ($dst == 0) {
$dst = 150;
}
$_SESSION[search][dsf] = "$loc:$dst";
list ($mapx,$mapy,$mapx1,$mapx2,$mapy1,$mapy2) = getCoordLimits($loc, $dst);
$distances = array();
$db->query("select userid, mapx, mapy from users where mapx >= '$mapx1' and mapx <= '$mapx2' and mapy >= '$mapy1' and mapy <= '$mapy2'");
while ($z = $db->fetchRef())
if ($z[mapx] && $z[mapy]) $distances[$z[userid]] = calcDistance($mapx, $mapy, $z[mapx], $z[mapy]);
$db->free();
if (!$distances) $distances = array(0 => 0);
$innerJoin = " inner join users on (users.userid = ads.userid)";
$filters[] = "(users.userid in (".join(',',array_keys($distances))."))";
asort($distances);
// Nope!
//if (!$orf) {
// Yes!
// If $dsf, add DISTANCE search
$distOrfKey = 'Closest '.pluralize($animalList[$forceAnimal]);
$orderList = array_merge($orderList,array($distOrfKey => 'dist'));
if ($orf == $distOrfKey) {
$orf = '';
$deforf = $distOrfKey;
foreach ($distances as $uid => $dst)
$orf .= ($orf ? ', ' : '') . "users.userid = '$uid' desc";
}
}
}
// If Order
if ($orf) {
$orf = urldecode($orf);
$orderBy = $orderList[$orf] ? $orderList[$orf] : $orf;
}
// Else use tricky algorithm
else {
$orderBy = 'adclass, date_format(lastmodified,\'%Y-%m-%d\') desc';
/* screw this
$orderBy = "created desc";
$db->query("select created from ads where visible != 0 and active = 1 and created >= '$expiryDate' order by $orf limit 1");
$r = $db->fetchRef();
$db->free();
if ($r) {
$orderBy = "( created >= '".date("Y-m-d",strtotime($r[0]) - (86400 * 1))."' and created <= '".date("Y-m-d",strtotime($r[0]) + (86400 * 1))."') ";
}
if ($orderBy) $orderBy = "( localad and $orderBy ) desc";
*/
}
if ($pg == "") $pg = $_SESSION[sPg];
if ($pg == "") $pg = 0;
//$_SESSION[sPg] = $pg;
$_SESSION[sPg] = $pg;
//print_r($filters);
?>
Andalusian for Sale in Connecticut
|
 | | Grey Andalusian Filly |
|  | | Grey Andalusian Gelding |
|  | | Grey Andalusian Colt |
|  | | Bay Andalusian Colt |
| |
|
There aren't any Andalusian Horse Classifieds in Connecticut that match all of your search criteria. We've pictured a few other andalusians above that are similar and there are thousands of horses listed for sale on Equine Now. Some breeds are rare though and hard to find.
Perhaps you should start over with a New Horse Search or try starting your search with just a zip code below.
|
  Farm Directory
|
|
|
|
|
|
Andalusian Horses for Sale by State
|
|
Canadian Horses by Province
|
|
|
|
