<%@page language="java" import="java.sql.*"%> <%@page import="java.util.*"%> <%@page import="realestate.subdivisionNameCodeMap"%> <%@page import="realestate.streetnameSubcodeMap"%> <%@page import="realestate.subdivisionPriceList"%> <% Cookie [] pncookies = request.getCookies(); String housenumber_ck = null; String street_ck = null; Vector streetNames = null; streetNames = PriceSearchBeanId.getStreetNames(0); String sv = request.getParameter("street"); String hn = request.getParameter("housenumber"); String housenumber = request.getParameter("housenumber"); String paramStr = "?"; String sname = ""; String subcode = "0"; streetnameSubcodeMap snm = null; String formName = request.getParameter("form1"); if ( sv != null ) { int index = Integer.parseInt(sv); snm = (streetnameSubcodeMap) streetNames.get(index); sname = snm.getNameStr(); subcode = snm.getSubcodeStr(); } if ( hn != null ) { //out.println("hn = " + hn); //out.println("seting hn" ); Cookie c1 = new Cookie("prefs.housenumber", hn); c1.setMaxAge(60*60*24*365); response.addCookie(c1); } if ( sv != null ) { //out.println("streets = " + sname); //out.println("seting street" ); Cookie c2 = new Cookie("prefs.street", sname); //c.setPath("/"); c2.setMaxAge(60*60*24*365); //c2.setMaxAge(0); response.addCookie(c2); } %> StreetSearch


Price Search By Street Address

<% //out.println("cookie count= " + pncookies.length); /* for ( int i = 0; i < pncookies.length; i++) { Cookie c = pncookies[i]; out.println("cookie names= " + c.getName()); out.println("cookie value= " + c.getValue()); if ( c.getName().compareTo("prefs.housenumber") == 0) { housenumber_ck = c.getValue(); } if ( c.getName().compareTo("prefs.street")== 0 ) { street_ck = c.getValue(); } } if ( housenumber_ck != null ) out.println("housenumber_ck =" + housenumber_ck.toString()); */ %>
Use this search to find out what homes are selling for in your subdivision! Just enter your home's location and the program will determine your subdivision. ( Note this is only valid for certain master plan areas in the south valley at this time.)
Search Entry Form
1) Enter House Number name="housenumber" class="resultstable">  
2) Enter Street Name :  
 
Click on the sign to get notified by email when a home in your neigborhood is For Sale or is Sold!
Click here to receive a more detailed estimate of your home's value with a CMA
Click here to get an explanation of the search results.
<% String resultsStr =""; if ( formName!= null) { sv = request.getParameter("street"); if ( sv != null ) { int index = Integer.parseInt(sv); snm = (streetnameSubcodeMap) streetNames.get(index); sname = snm.getNameStr(); subcode = snm.getSubcodeStr(); } if ( formName.compareTo("null") != 0 ) { String subname = PriceSearchBeanId.getsubNamefromCode(subcode); //out.println(" SNAME = " + sname + "subcode = " + subcode ); //out.println("Request adr = " + request.getRemoteAddr()); resultsStr = "Homes that have recently sold(last 12 months) for in this subdivision, " + subname + " are listed below"; if ( sv!= null) { Vector pl = null; // log the request PriceSearchBeanId.logPriceSearch( housenumber,sname, subcode,request.getRemoteAddr(), true); pl = PriceSearchBeanId.getPricesbySubdivision(subcode , 12); subdivisionPriceList sdpl = null; %> <% for ( int i = 0; i< pl.size(); i++) { sdpl = (subdivisionPriceList) pl.get(i); String location = sdpl.getLocation(); int price = sdpl.getLastSoldPrice(); String date = sdpl.getLastSoldDate(); int size = sdpl.getDwellingsize(); int pricesf = sdpl.getPricepersf(); %> <% } %>
<%=resultsStr%>
Location Last Sold Price Last Sold Date Dwelling SizePrice SF
<%=location%> <%=price%> <%=date%> <%=size%> <%=pricesf%>

<% } } } %> This data is provided as a courtesy of Royal Castle Realty/Chet Pressler. For informational purposes only.

Understanding the results

To find our your home's current value:
1) find a home with a similar square footage and use that for an estimate.
OR If an exact square footage is not available:
2) then use the price/SF times your homes square footage to estimate it's current value