|
<%@ include file="../WEB-INF/jsp/city_side_menu2.jspf" %>
|
|
<%@ include file="../WEB-INF/jsp/top_menu.jspf" %>
|
<%=city_name%>, <%=region_name%>
Filter the results on the map and on the property list by changing criteria.
All properties meeting criteria are shown automatically.
|
|
Properties in <%=city_name%>
| Property ID |
Address |
City |
Bedrooms |
Bathrooms |
Square feet |
<%@ include file="/WEB-INF/jsp/radius_function.jsp" %>
<%
Connection con = null;
try {
// lat and lng definition are on file city_scriptlet.jspf
double[] cords = getRadiusCords(60, lat, lng);
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT property_id, address, country_id, country_name, bedrooms, bathrooms, sqft, property.latitude, property.longitude, cities.city, property.city_id FROM property, cities WHERE property.city_id = cities.city_id AND property.enabled = 1 AND property.latitude >= " + cords[0] + " AND property.longitude >= " + cords[1] + " AND property.latitude <= " +cords[2] + " AND property.longitude <= " +cords[3];
PreparedStatement Ps = con.prepareStatement(query);
//Ps.setInt(1,city_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
long property_id = Rs.getLong("property_id");
int country_id = Rs.getInt("country_id");
double latitude = Rs.getDouble("latitude");
double longitude = Rs.getDouble("longitude");
String address = Rs.getString("address");
String country_name = Rs.getString("country_name");
String city_name2 = Rs.getString("city");
int city_id2 = Rs.getInt("city_id");
int bedrooms = Rs.getInt("bedrooms");
int bathrooms = Rs.getInt("bathrooms");
int sqft = Rs.getInt("sqft");
String query2 = "SELECT date_in, date_out FROM rates WHERE property_id = ?";
PreparedStatement Ps2 = con.prepareStatement(query2);
Ps2.setLong(1, property_id);
ResultSet Rs2 = Ps2.executeQuery();
%>
| #<%=property_id%> |
<%=address%> |
<%=city_name2%> |
<%=bedrooms%> |
<%=bathrooms%> |
<%=sqft%> |
<%
Rs2.close();
Ps2.close();
}
Rs.close();
Ps.close();
con.close();
con = null;
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
finally {
if(con!=null) {
con.close();
con = null;
}
}
%>
| |
|
|
|
|
|
<%@ include file="../WEB-INF/jsp/footer.jspf" %>
|
Massachusetts Rental Links
House rentals Marblehead and Marblehead house rentals
House rentals in Haverhill Massachusetts, rent house in Haverhill Massachusetts, and Haverhill Massachusetts apartments for rent
Randolph rental homes, rental homes, rent houses Randolph Massachusetts, and Randolph vacation rentals
West Springfield rental homes and homes for rent by owner in West Springfield Massachusetts
Houses for rent in Shrewsbury Massachusetts, Shrewsbury rental homes, and Shrewsbury Massachusetts rental properties
For rent by owner homes Northbridge, homes for rent by owner Northbridge, vacation rentals in Northbridge, and rental properties Northbridge Massachusetts
Condo rentals in Athol and for rent by owner homes in Athol Massachusetts
Rent house Franklin Massachusetts, Franklin Massachusetts rental apartment, and vacation homes Franklin
Real estate rentals in Raynham, rental houses in Raynham, Raynham Massachusetts rental homes, and home rentals in Raynham
Winthrop Massachusetts condo rentals and rental homes
Newton Massachusetts is a lovely and superb dominion with delicate, gorgeous, and superb duplex, vacation home, cabin, and houses.
See beach classified advertisements and suburban online MLS that town home owners and landlords post on our online website, FRBO.com.
Move, notice, and recognize West Boylston rental apartment, vacation rental in West Boylston, and apartment rentals West Boylston United States.
Find out and determine Vineyard Haven United States bed and breakfast rentals and vacation rental in Vineyard Haven United States.
Navigators and students who are foraging apartment rentals Newton and are trying to notice Newton condo rentals, Newton Massachusetts houses for rent, and for rent by owner homes Newton can shake down this extensive website, FRBO.com and our ski in/out directories, suburban listings, ski in/out online MLS, and beachfront classified advertisements.
Devise, observe, and detect rental apartment Middlesex Massachusetts, rental homes in Middlesex Massachusetts, and real estate rentals in Middlesex Massachusetts.
Traveling women, roadmen, and traveling men study, scrutinize, and shake down this website, FRBO.com and explore exclusive flat, romantic farmhouse, hillside duplex, and studio cabin.
Using For Rent By Owner, third party listing companies tab condominium and home lists of marked properties.
Conceive and find homes for rent by owner in Nantucket Massachusetts, holiday rentals, holiday rentals, and Nantucket condo rentals.
Notice, invent, and look up vacation rentals in Essex Massachusetts, vacation rental in Essex Massachusetts, and Essex Massachusetts condo rentals.
Come upon and look up Norfolk Massachusetts apartment rentals and home rentals in Norfolk Massachusetts.
Our site, FRBO.com can place, get, and hire lakefront listings, decadent ads, exclusive classified advertisements, and beach classified advertisements private indexes and beachfront directories to boost your Newton Massachusetts run.
We procreated, created, and fathered FRBO.Com, For Rent By Owner, to be alluring, grand, and magnificent.
The Newton Massachusetts directories scheduled and charted on our for rent by owner site, FRBO.com subsume well appointed castle, exclusive castle, beach home, and private ranch.
Look up, debunk, and identify rental properties in Suffolk, house rentals, rental houses, and vacation rental in Suffolk.
You can design, recognize, and catch rent houses, Newton Massachusetts vacation homes, and bed and breakfast rentals in Newton Massachusetts.
Light upon, discover, and observe the tract and neighboring Newton Massachusetts principality.
Observe and glimpse houses for rent in Lakeville United States and condos for rent in Lakeville United States.
Join our resort ad directories, hidden ads, exotic listed properties, and hillside indexes mailing list for vacation rentals, vacation rental Newton Massachusetts, and Newton holiday rentals.
|
|
