|
<%@ 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
Rental properties in Steubenville Ohio and home rentals in Steubenville Ohio
Rental homes Jackson, rental houses in Jackson, and Jackson Ohio real estate rentals
House rentals in Beavercreek Ohio, Beavercreek Ohio for rent by owner homes, Beavercreek Ohio houses for rent, and rent houses Beavercreek Ohio
South Euclid Ohio condos for rent and holiday rentals in South Euclid
Vacation rental in Medina Ohio, rental properties in Medina Ohio, and condos for rent in Medina Ohio
Norwalk Ohio homes for rent by owner, Norwalk Ohio rent house, real estate rentals in Norwalk Ohio, and Norwalk Ohio real estate rentals
Apartments for rent and Liberty Ohio homes for rent
Holiday rentals in Truro Ohio, Truro Ohio condos for rent, and holiday rentals Truro Ohio
Condo rentals in Unity Ohio, rent houses in Unity Ohio, for rent by owner homes in Unity, and for rent by owner homes in Unity
Homes for rent by owner and home rentals in Oxford Ohio
Rent house Newark, real estate rentals Newark Ohio, and Newark apartments for rent
Home rentals in Middleburg Heights, Middleburg Heights Ohio rental apartment, rental apartment, and home rentals in Middleburg Heights Ohio
Spacious ad directories and beach directories house rentals Scioto Ohio, vacation homes in Scioto Ohio, Scioto Ohio houses for rent, and rental home in Scioto Ohio.
Determine, find out, and ferret out the quarter and next Olmsted Ohio state.
FRBO.Com, For Rent By Owner, does have particular decadent, lake, hillside, and rustic bungalow, chalet, ranch, and apartments.
We forged, actualize, and generated our site, FRBO.com to be delicate, exquisite, and fine.
Identify, move, and conceive Montgomery Ohio apartment rentals and Montgomery Ohio rental home.
Our website, FRBO.com can enroll, sign on, interest, and oblige city lists of marked properties, ski in/out ads, and romantic directories waterfront classified advertisements, hidden lists of marked properties, and beachfront listed properties to work with your Olmsted Ohio sally.
See decadent advertisements, suburban lists of marked properties, mountain advertisements, and private advertisements that property managers and property managers post on our website, FRBO.com.
Move and relocate College Corner United States vacation homes and holiday rentals in College Corner.
Identify and move holiday rentals and vacation homes for rent by owner.
Discern, look up, and come upon Junction City holiday rentals, holiday rentals in Junction City United States, and rental properties in Junction City United States.
Ready to move in well appointed cottage, beach villa, lakefront farmhouse, and lakeside condominium are adjoining in the not to distant township of Olmsted Ohio.
Come across, catch, and uncover homes for rent Miami, home rentals in Miami Ohio, and homes for rent by owner.
|
|
