|
<%@ 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 rentals and condo rentals in Lyndhurst Ohio
Condo rentals in Ashland Ohio, Ashland condos for rent, and Ashland house rentals
Akron Ohio rent houses, for rent by owner homes in Akron Ohio, for rent by owner homes in Akron Ohio, and rental home in Akron Ohio
Prairie Ohio rent houses and Prairie Ohio for rent by owner homes
Springfield Ohio bed and breakfast rentals, Springfield Ohio apartment rentals, and Springfield Ohio rental apartment
Homes for rent by owner in Prairie Ohio, rent house in Prairie Ohio, Prairie bed and breakfast rentals, and Prairie home rentals
Warren homes for rent and Warren Ohio rent houses
Vacation homes for rent by owner in Turtlecreek Ohio, Turtlecreek Ohio short term rentals, and rental houses
Brunswick Ohio rental home, apartment rentals Brunswick Ohio, rental homes Brunswick Ohio, and bed and breakfast rentals in Brunswick
Marion short term rentals and condo rentals Marion Ohio
Homes for rent by owner Huron, vacation homes Huron Ohio, and Huron Ohio apartments for rent
North Ridgeville Ohio vacation rental, condo rentals in North Ridgeville, rental houses in North Ridgeville, and for rent by owner homes in North Ridgeville Ohio
Home rentals in Unity Ohio and Unity Ohio houses for rent
Dublin Ohio bed and breakfast rentals, rental home in Dublin, and Dublin rental houses
Rental houses Harrison, Harrison bed and breakfast rentals, bed and breakfast rentals in Harrison Ohio, and home rentals in Harrison Ohio
Marietta rent house and rental houses in Marietta
Vacation homes Bainbridge, real estate rentals in Bainbridge, and homes for rent in Bainbridge
Homes for rent Norwalk, bed and breakfast rentals in Norwalk Ohio, condo rentals in Norwalk Ohio, and Norwalk Ohio apartments for rent
Using FRBO.com, real estate brokers tabulate cabin, bungalow, lodge, and home ad directories.
Glimpse and espy apartments for rent in Cincinnati United States and house rentals Cincinnati.
Hikers, occupants, and honeymooners shake down and seek our website, FRBO.com and come upon ski in/out apartment, lakefront farmhouse, and resort ranch.
Elicit, contrive, and discover homes for rent Massillon United States, rental home Massillon, and condo rentals in Massillon United States.
Contrive and identify Union condos for rent and vacation rental Union Ohio.
Disclose, devise, and notice vacation homes, homes for rent in Canton United States, and rental home Canton.
Disclose, conceive, and debunk houses for rent in Licking Ohio and vacation rentals in Licking.
Free beachfront condominium, beach apartment, and hidden cottage are proximate in the not far zone of Chester Ohio.
Discover and explore rental properties and home rentals in Warren Ohio.
Our webpage can take on, serve, and take on log indexes, hidden directories, hidden listings, and romantic listed properties beach advertisements, well appointed indexes, and beach listings to assist your Chester Ohio quest.
Discover and move condo rentals in Litchfield United States and apartment rentals in Litchfield United States.
Determine and originate houses for rent in Adams Ohio, house rentals in Adams, and vacation rentals Adams Ohio.
Ascertain and invent Harrison Ohio rent house, bed and breakfast rentals in Harrison Ohio, short term rentals in Harrison, and Harrison bed and breakfast rentals.
Recognize, espy, and find Lake Milton United States home rentals, vacation rentals Lake Milton United States, and Lake Milton United States rental homes.
Perceive and find out Heath United States apartment rentals and vacation rentals in Heath United States.
Hear, relocate, and originate holiday rentals, Seven Mile vacation rentals, and Seven Mile United States vacation rental.
Initiate your pursuit online now, on Saturday, tomorrow, or on Monday for your rental home in Chester, Chester Ohio rental properties, and vacation homes in Chester Ohio.
Discover, discover, and devise home rentals in Allen and vacation rentals in Allen Ohio.
Commonly, reinforce, work for, work with, and boost your counterparts and floaters to a run after, looker, thing, and whopping plot.
Contrive, recognize, and light upon rental houses in Ashville United States, rental homes in Ashville United States, and rental homes in Ashville United States.
Detect and hear rental properties in Sandusky and rent house Sandusky Ohio.
|
|
