<?php
error_reporting(E_ALL & ~E_NOTICE);
// include("/Library/WebServer/virtual-footers/" . $_SERVER['SERVER_NAME'] . "-vfooter.php");
function mmmr($array, $output){ 
    if(!is_array($array)){ 
        return FALSE; 
    }else{ 
        switch($output){ 
            case 'mean': 
                $count = count($array); 
                $sum = array_sum($array); 
                $total = $sum / $count; 
            break; 
            case 'median': 
                $cnt = count($array); //total numbers in array
    			// $middle_val = floor(($cnt-1) / 2); // find  middle val, or low mid val
     			$middle_val = floor(($cnt) / 2); // find  middle val, or low mid val
   			if($cnt % 2) { // odd number, middle is the median
        			$median = $array[$middle_val];
    			} else { // even number, calculate avg of 2 medians
        		$low = $array[$middle_val];
        		$high = $array[$middle_val + 1];
        		$median = (($low + $high) / 2);
	            }
                $total = $median;
            break;
            case 'mode': 
                $v = array_count_values($array); 
                arsort($v); 
                foreach($v as $k => $v){$total = $k; break;} 
            break; 
            case 'range': 
                sort($array); 
                $sml = $array[0]; 
                rsort($array); 
                $lrg = $array[0]; 
                $total = $lrg - $sml; 
            break; 
        } 
        return $total; 
    } 
} 

$collected['Bedminster Twp'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['Bensalem Twp'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['Bridgeton Twp'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['Bristol Boro'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['Bristol Twp'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['Buckingham Twp'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['Chalfont Boro'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['Doylestown Boro'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['Doylestown Twp'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['Dublin Boro'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['Durham Twp'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['East Rockhill Twp'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['Falls Twp'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['Haycock Twp'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['Hilltown Twp'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['Hulmeville Boro'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['Ivyland Boro'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['Langhorne Boro'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['Langhorne Manor Boro'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['Lower Makefield Twp'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['Lower Southampton Twp'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['Middletown Twp'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['Milford Twp'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['Morrisville Boro'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['New Britain Boro'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['New Britain Twp'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['New Hope Boro'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['Newtown Boro'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['Newtown Twp'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['Nockamixon Twp'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['Northampton Twp'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['Penndel Boro'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['Perkasie Boro'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['Plumstead Twp'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['Quakertown Boro'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['Richland Twp'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['Richlandtown Boro'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['Riegelsville Boro'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['Sellersville Boro'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['Silverdale Boro'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['Solebury Twp'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['Springfield Twp'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['Telford Boro'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['Tinicum Twp'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['Trumbauersville Boro'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['Tullytown Boro'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['Upper Makefield Twp'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['Upper Southampton Twp'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['Warminster Twp'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['Warrington Twp'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['Warwick Twp'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['West Rockhill Twp'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['Wrightstown Twp'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];
$collected['Yardley Boro'] = ['muni' => "", 'thecount' => 0, 'prices' => "",'medianprice' > 0, 'doms' => "", 'dom' => 0];


ini_set("auto_detect_line_endings", true);
$fp = fopen('/Library/WebServer/csv/bucks-pa-2024-new-con.csv','r');
while(($entry = fgetcsv($fp,8192,',')) !== FALSE) {
 // if(($entry[33] < "2024-06-01") || ($entry[33] > "2024-07-31")) {continue;}
 $ma = explode(" - ", $entry[2]);
 $entry[0] = $ma[0]; // parse MLS Area Full Name
 //if($entry[NEWCON] == "Yes") {
 // (continue;
 //}
 // $entry[MUNI] = preg_replace('~ \([0-9][0-9][0-9][0-9][0-9]\)~','',$entry[MUNI]);
 // (int) $price = str_replace(",","",str_replace("$","",$entry[PRICE]));
 if(array_key_exists($entry[0],$collected)) {
  $collected[$entry[0]]['thecount'] += 1;
  $collected[$entry[0]]['prices'] .= ($entry[8] . ",");
  $collected[$entry[0]]['dom'] .= ($entry[18] . ",");
    if($price < $collected[$entry[0]]['low']) {
    $collected[$entry[0]]['low']  = $price;
    }
   if($price > $collected[$entry[0]]['high']) {
   $collected[$entry[0]]['high']  = $price;
   }

 }
}

// $status = array_column($collected,0);
// array_multisort($collected,SORT_DESC,$status,$collected[]);

?>

<!DOCTYPE html>
<html lang="en">
<head>
<meta property="og:image" content="https://johnmcclintockteam.com/2025/01/li/green-avenue-bensalem-bud-silcox.jpg" />
<meta property="og:title" content="Bucks County Single Family New Construction Homes Sold in 2024 by Municipality" />
<style>

<style>
table {margin: auto; text-align: center; width: 98%; max-width: 800px;border-collapse: collapse; min-width: 600px;}
tr.rd {color: #b00; font-weight: normal;}
table tr td {border-bottom: 1px solid #ccc; width: 12%;}
table td:first-child {text-align: left; width: 16%;}
table tr td {text-align: right; padding: 0.33em 0em;}
td {font-size: 1.33em; padding-center: 1rem; text-align: center;}
tr:nth-child(even) {
    background-color: #e2e2e2;
}
td {text-align: center;}
</style>
<script>
  (function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
  (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
  m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
  })(window,document,'script','https://www.google-analytics.com/analytics.js','ga');

  ga('create', '<?php echo($gatrack);?>', 'auto');
  ga('send', 'pageview');

</script>

<meta name="viewport" content="width=device-width, initial-scale=1">
<meta charset="utf-8" />
<title>Single Family Resales Summary, Bucks County, PA 2024</title>
           <meta name="robots" content="noindex, nofollow">

<link rel="stylesheet" type="text/css" href="https://johnmcclintockteam.com/css/simple.css" />

</head>
<body style="max-width: 960px; margin: auto; text-align: center;">

<div id="layout">


    <div id="main">
        <div class="header">

        <h2>
<a href="https://johnmcclintockteam.com/">Blog Home</a> &nbsp; <a href="https://johnmcclintockteam.com/contact.html">Contact</a></h2>
       <h1 class="kwrd">Bucks County Pennsylvania<br>Single Family New Construction<br>Homes Sold in 2024</h1>
<img style="width: 100%;" src="https://www.johnmcclintockteam.com/2025/01/li/green-avenue-bensalem-bud-silcox.jpg" alt="The John McClintock Team" />
<h2>New Bensalem Colonial built by Snyder Homes<br>
sold by Bud Silcox, Realtor<sup>&reg;</sup><br>Keller Williams Real Estate, Bensalem, PA</h2></div>

        <div class="content" style="">
<?php
echo("<table style='max-width: 720px; margin: auto; text-align: center;'><tr class='rd'>
<td>Municipality</td><td>Median &Dagger;<br>Sold Price</td><td># Homes<br>Sold</td></tr>");

foreach($collected as $key => $content) {
 $price_array = explode(",",$content['prices']);
 $dom_array = explode(",",$content['dom']);
 sort($price_array, SORT_NUMERIC);
 sort($dom_array, SORT_NUMERIC);
unset($price_array[0]);
unset($dom_array[0]);
// $average = ceil( array_sum($price_array) / count($price_array) );
// $avg = mmmr($price_array, 'mean');
$median = mmmr($price_array, 'median');
$collected[$key]['medianprice'] = $median;
$dom = mmmr($dom_array, 'median');
$collected[$key]['dom'] = $dom;
$mode = mmmr($price_array, 'mode');
$low = $price_array[1];
$high = $price_array[count($price_array)];
$howmany = count($price_array);
$collectd[$key]['thecount'] = $howmany;

// Make Key into key-link
//$link = $key;
//$link = "<a href=\"" . strtolower( str_replace("-Boro","-borough",str_replace("-Twp","-township",str_replace(" ","-",$key)))) . ".html\">" . $key . "</a>";
$link = $key;
}
foreach($collected as $key => $val) {
	$medianprice[$key] = $val['medianprice'];
	// $dom[$key] = $val['dom'];
	$thecount[$key] = $val['thecount'];
}
array_multisort($medianprice, SORT_DESC, $collected);

foreach($collected as $key => $val) {
if($collected[$key]['medianprice'] < 100) {
	continue;
}

echo("<tr><td class='gb'> " . $key . "</td>");
echo("<td>" . number_format(round($collected[$key]['medianprice'],-3)) . "</td>");
echo("<td>" . number_format($collected[$key]['thecount'],-3) . "</td></tr>");
//echo("<td>" . number_format($collected[$key]['dom']) . "</td></tr>");

}

echo("</table>");

?> 
<p>&Dagger; Sold Prices 2024, Bright MLS Settled Sales, Bucks County (rounded to the nearest $1,000).</p>
        </div>
    </div>

</div>
<div>
<img style="width: 100%; max-width: 840px; text-align: center;" src="https://johnmcclintockteam.com/li/locations.jpg" alt="locations">
</div>

<hr style="width: 90%;" />
<div style="text=align:center;">
<img style="width: 100%; max-width: 840px;" src="https://johnmcclintockteam.com/li/mcclintock-footer-840.jpg" alt="john mcclintock team, realtors"></div>
</body>
</html>