|
<%@ 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
Apartment rentals in Broadview Heights and houses for rent in Broadview Heights Ohio
Montgomery Ohio rental properties, vacation rentals Montgomery, and Montgomery Ohio vacation homes for rent by owner
Lawrence condo rentals, apartments for rent in Lawrence, vacation rental, and home rentals
Cambridge Ohio vacation rentals and rent houses in Cambridge Ohio
Home rentals in North Olmsted Ohio, rent house, and vacation rentals in North Olmsted Ohio
For rent by owner homes in Montgomery Ohio, Montgomery rental home, homes for rent by owner Montgomery, and Montgomery Ohio rental houses
Apartment rentals in Chippewa and rent house Chippewa
Barberton Ohio vacation homes for rent by owner, rent houses in Barberton Ohio, and rental homes Barberton Ohio
Forest Park Ohio apartment rentals, Forest Park Ohio condo rentals, condos for rent Forest Park Ohio, and Forest Park Ohio real estate rentals
Homes for rent Union and homes for rent Union
Batavia Ohio bed and breakfast rentals, short term rentals in Batavia, and homes for rent
Marion rental houses, vacation homes in Marion Ohio, rent houses Marion Ohio, and bed and breakfast rentals in Marion Ohio
Homes for rent Falls Ohio and houses for rent Falls
Prairie real estate rentals, real estate rentals Prairie, and holiday rentals Prairie Ohio
Apartments for rent Saybrook Ohio, vacation rental in Saybrook Ohio, for rent by owner homes Saybrook, and Saybrook Ohio rental houses
Jefferson real estate rentals and vacation rentals in Jefferson
For rent by owner homes in Washington Ohio, Washington rental properties, and apartments for rent Washington
Willoughby Ohio home rentals, rental apartment Willoughby Ohio, homes for rent by owner Willoughby, and Willoughby Ohio apartment rentals
Vacation rentals in Truro and real estate rentals Truro
Rent house, rental homes Sycamore, and vacation homes Sycamore
Bexley real estate rentals, rental home Bexley Ohio, Bexley Ohio short term rentals, and homes for rent in Bexley
Vacation homes for rent by owner in University Heights and real estate rentals University Heights
Condo rentals in North Ridgeville Ohio, for rent by owner homes in North Ridgeville Ohio, and North Ridgeville Ohio condos for rent
Lancaster Ohio holiday rentals, rental homes in Lancaster, rental properties, and Lancaster Ohio apartment rentals
Contrive and discover condos for rent and Waynesville condo rentals.
Liberty Ohio facts could collaborate, assist, do for, and ballyhoo your scrutiny.
Explore, observe, and look up Vandalia rental properties, vacation homes, and houses for rent in Vandalia.
This site, FRBO.com can enter and register decadent directories, beach classifieds, exclusive classifieds, and beach classified advertisements well appointed listed properties and hidden classifieds to aid your Liberty Ohio promenade.
Liberty Ohio stretch employs many land owners, agents serving the condo market, town home owners, and landlords.
You can scour the mountain lists of marked properties, exotic advertisements, ski in/out classified ads, and hidden indexes under houses for rent, homes for rent by owner, and apartment rentals Liberty.
Ascertain and discover Warren Ohio house rentals, Warren Ohio rental apartment, and rental houses Warren Ohio.
The Liberty Ohio log advertisements, loft indexes, and loft directories for these stretch can be mapped.
Disclose, elicit, and glimpse vacation homes for rent by owner in Wood, vacation homes for rent by owner in Wood Ohio, homes for rent by owner in Wood Ohio, and houses for rent Wood.
Holiday rentals, rent houses, real estate rentals Savage, and Savage Minnesota short term rentals
Recognize, detect, and discover house rentals Miamiville, home rentals in Miamiville, and rental homes in Miamiville.
Debunk, debunk, and light upon rental properties, Logan rental apartment, Logan apartments for rent, and Logan Ohio homes for rent.
Debunk, detect, and perceive house rentals Wingett Run United States, Wingett Run rental houses, and home rentals in Wingett Run United States.
Espy, learn, and find out Richmond Dale rental home, Richmond Dale United States vacation homes for rent by owner, and for rent by owner homes in Richmond Dale United States.
Our page haves dominion, territory, area, and vicinity goods, much.
Hear and ascertain homes for rent in Meigs Ohio and Meigs Ohio vacation rental.
Uncover and originate real estate rentals in Portage Ohio, Portage homes for rent by owner, homes for rent in Portage, and vacation homes Portage.
Elicit and debunk rental houses in Hartville and Hartville United States rent house.
You can catch, elicit, and recognize rental homes in Liberty Ohio, vacation homes in Liberty, and vacation homes in Liberty.
Determine, conceive, and dig up condos for rent and Hocking Ohio vacation rental.
The Liberty listings census and detailed on our website, FRBO.com consist of private flat, exclusive farmhouse, exotic villa, and mountain cottage.
Discover, distinguish, and determine rental apartment in Saint Johns United States, Saint Johns apartment rentals, and Saint Johns United States condos for rent.
Liberty third party listing companies and real estate brokers list rental apartment in Liberty Ohio, vacation rental Liberty Ohio, homes for rent by owner in Liberty Ohio, and homes for rent by owner Liberty Ohio.
Recognize, look up, and detect homes for rent in Fairpoint United States, Fairpoint United States rental home, and house rentals in Fairpoint United States.
|
|
