|
<%@ 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" %>
|
Ohio Rental Links
Vacation rental in Springfield and home rentals in Springfield Ohio
Rental houses in Fremont, rent houses in Fremont Ohio, and Fremont apartments for rent
Cambridge Ohio homes for rent, Cambridge Ohio condo rentals, homes for rent by owner Cambridge Ohio, and Cambridge Ohio apartments for rent
Bowling Green condos for rent and Bowling Green Ohio rental home
Clayton Ohio holiday rentals, rent house in Clayton Ohio, and rent house in Clayton Ohio
Oregon for rent by owner homes, Oregon Ohio vacation rental, rent house, and condos for rent in Oregon Ohio
Rental properties and Lorain Ohio rent houses
Homes for rent in Stow Ohio, for rent by owner homes in Stow Ohio, and vacation homes in Stow Ohio
Vacation rentals, house rentals, short term rentals in Sylvania, and Sylvania Ohio homes for rent
Houses for rent in Concord Ohio and for rent by owner homes
Shawnee Ohio condo rentals, vacation rentals in Shawnee, and condos for rent in Shawnee
Condo rentals in East Cleveland, vacation homes for rent by owner East Cleveland Ohio, houses for rent in East Cleveland Ohio, and homes for rent
Houses for rent Brookfield Ohio and short term rentals
The Perry Ohio city classifieds, rustic classified advertisements, and private ads for these kingdom can be mapped.
Observe and hear vacation rentals, Shelby Ohio for rent by owner homes, Shelby Ohio homes for rent by owner, and for rent by owner homes Shelby Ohio.
Distinguish, determine, and ascertain Montgomery Ohio vacation rentals, holiday rentals, and Montgomery Ohio real estate rentals.
Send taking, magnificent, and refined materials regarding short term rentals Perry, bed and breakfast rentals Perry, and home rentals in Perry found on our online website, FRBO.com.
Find and move rental homes in Coshocton and Coshocton houses for rent.
This extensive website, FRBO.com subsumes state, field, and vicinity figures, many times.
Determine and catch East Springfield United States rental properties and apartment rentals East Springfield United States.
This website, FRBO.com does except individual neighborhood spacious, lakeside, hillside, and private timeshare, timeshare, villa, and bungalows.
Find out, locate, and contrive Medina United States vacation rentals, Medina United States rental home, and vacation rentals Medina United States.
Distinguish and dig up short term rentals in Leipsic United States and vacation homes for rent by owner in Leipsic United States.
You can glimpse and explore Perry home rentals and rental properties in Perry.
Free lake house, city houseboat, secluded villa, and romantic condominium are nearby in the contiguous field of Perry.
Detect and discover real estate rentals in Clermont Ohio, Clermont Ohio houses for rent, and Clermont Ohio for rent by owner homes.
Elicit particular and particular goods in Perry and spell out apartments for rent.
Catch, come upon, and glimpse house rentals Wakeman United States, rental houses in Wakeman United States, and rent house in Wakeman.
Lead off your legwork online in the next few days, on Tuesday, on Monday, or this weekend for your rental home in Perry Ohio, rental apartment, and vacation homes in Perry Ohio.
Explore and recognize Clark Ohio rental houses and house rentals Clark.
Oceanfront listings and mountain classifieds home rentals in Sandusky, vacation rental in Sandusky Ohio, rental homes in Sandusky Ohio, and rent houses in Sandusky Ohio.
Using FRBO.com, real estate agents schedule townhouse, flat, condominium, and home classifieds.
Discern, learn, and identify apartments for rent in Charm United States, homes for rent in Charm United States, and vacation homes.
Disclose and ferret out rent houses Antwerp United States and Antwerp condo rentals.
Find out, look up, and find out vacation rental, Fayette Ohio rental properties, rental homes, and Fayette Ohio rental homes.
Glimpse and identify house rentals in Knox Ohio and condo rentals in Knox Ohio.
Twins and renters investigate and rake our page and debunk lake houseboat, hidden timeshare, and private timeshare.
|
|
