function formatCurrency(num) {
	num = num.toString().replace(/\$|\,/g,'');
	if(isNaN(num))
		num = "0";
	sign = (num == (num = Math.abs(num)));
	num = Math.floor(num*100+0.50000000001);
	cents = num%100;
	num = Math.floor(num/100).toString();
	if(cents<10)
		cents = "0" + cents;
	for (var i = 0; i < Math.floor((num.length-(1+i))/3); i++)
		num = num.substring(0,num.length-(4*i+3))+','+
	num.substring(num.length-(4*i+3));
	return (((sign)?'':'-') + '$' + num);
}

var tmpSplit = ""
var tmpFinal = "<table border=0 cellpadding=5 cellspacing=1 bgcolor='#000000'>"
tmpFinal = tmpFinal + "<tr bgcolor='#cccccc'><td><strong>Location</strong></td><td><strong>Apartment / Home Size</strong></td>"
tmpFinal = tmpFinal + "<td><strong>Application Deadline</strong></td><td><strong>Rent</strong></td><td><strong>Income</strong></td></tr>"

var tmpCurDate = new Date();
var curDate = new Date((tmpCurDate.getMonth() + 1) + "/" + tmpCurDate.getDate() + "/" + tmpCurDate.getFullYear());


for (var x=0; x<housing.length; x++) {
	tmpSplit = housing[x].split("|");
	var tmpDate = new Date(tmpSplit[10]);

	if ((tmpDate.valueOf() >= curDate.valueOf()) || tmpDate == "NaN" || tmpDate == "Invalid Date") {
		tmpFinal = tmpFinal + "<tr bgcolor='#FFFFFF'><td>" + tmpSplit[1] + ", " + tmpSplit[2] + "</td>";
		tmpFinal = tmpFinal + "<td>";
		if (tmpSplit[4] == 0) {
			tmpFinal = tmpFinal + "Studio";	
		} else {
			if (tmpSplit[4] > 1) {
				tmpFinal = tmpFinal + tmpSplit[4] + " Bedrooms";	
			} else {
				tmpFinal = tmpFinal + tmpSplit[4] + " Bedroom";	
			}
		}
		tmpFinal = tmpFinal + "</td>";
		if (tmpSplit[11] != "") {
			tmpFinal = tmpFinal + "<td><a href='" + tmpSplit[11] + "'>" + tmpSplit[10] + "</a></td>";
		} else {
			tmpFinal = tmpFinal + "<td>" + tmpSplit[10] + "</td>";
		}
		tmpFinal = tmpFinal + "<td>$" + tmpSplit[7] + "</td>";
		tmpFinal = tmpFinal + "<td>" + formatCurrency(tmpSplit[8]) + " - " + formatCurrency(tmpSplit[9]) + "</td></tr>";
	}
}

tmpFinal = tmpFinal + "</table>"
document.write(tmpFinal);