<%@page language="java" import="java.sql.*"%> <%@page import="java.util.*"%> <%@page import="realestate.subdivisionNameCodeMap"%> <%@page import="realestate.streetnameSubcodeMap"%> <%@page import="realestate.subdivisionPriceList"%> <% String paramStr = "?"; %> StreetSearch


Price Search By Subdivision or Street

Use this search to find out what homes are selling for in your subdivision! If you do not know your subdivision name then use your street name.
<% String formName = request.getParameter("form1"); String masterplan = request.getParameter("masterplan"); Vector subdivisionNames = null; Vector streetNames = null; int mastercode = 303001; if ( masterplan != null) mastercode= Integer.parseInt(masterplan); %>
Search Entry Form
1) Enter Master Plan or Area :    
2) Enter Street Name :
Or 2) Enter Subdivision Name :
3) Search by Street Name
 Subdivision 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) { if ( formName.compareTo("null") != 0 ) { String sb = request.getParameter("searchby"); String subcode = "0"; String snv = request.getParameter("subdivision"); String sv = request.getParameter("street"); String sname = ""; String sdname =""; if ( sb.compareTo("subdivision") == 0) { int index = Integer.parseInt(snv); snc= (subdivisionNameCodeMap) subdivisionNames.get(index); sdname = snc.getNameStr(); subcode = snc.getSubcodeStr(); } else { int index = Integer.parseInt(sv); snm = (streetnameSubcodeMap) streetNames.get(index); sname = snm.getNameStr(); subcode = snm.getSubcodeStr(); } String subname = PriceSearchBeanId.getsubNamefromCode(subcode); //out.println("SDName = " + sdname + " 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 ( snv!= null) { Vector pl = null; // log the request PriceSearchBeanId.logPriceSearch( "0000", 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