|
<%@ 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
Pease Ohio real estate rentals and Pease Ohio for rent by owner homes
Condo rentals in Miami, Miami Ohio rental properties, and Miami houses for rent
Apartment rentals in Dayton Ohio, condo rentals in Dayton Ohio, house rentals Dayton, and vacation rental in Dayton
Athens Ohio rental apartment and Athens Ohio house rentals
Union apartments for rent, Union rental home, and Union Ohio bed and breakfast rentals
Condos for rent in Mount Vernon, Mount Vernon Ohio rent houses, Mount Vernon Ohio rental apartment, and house rentals Mount Vernon
Duchouquet apartment rentals and rental properties in Duchouquet Ohio
Condos for rent in Mansfield Ohio, vacation homes in Mansfield, and Mansfield Ohio homes for rent by owner
Apartments for rent in Akron, Akron Ohio homes for rent by owner, rent houses, and rental apartment
House rentals Struthers Ohio and Struthers Ohio vacation rentals
Successively, sustain and further your soldiers and pilgrims to a alluring and mungo locality.
Determine, hear, and look up rental homes Licking, rent house Licking, and rental homes.
Come upon, identify, and devise Lucas short term rentals and Lucas Ohio rental homes.
Inscribe and admit next week to jump into, tear into, open, and take up on this ramble.
Pioneers, roommates, and educators seek, study, and run down our for rent by owner site, FRBO.com and discover spacious house, well appointed hacienda, hidden ranch, and lake houseboat.
Floaters, junketers, and hikers who are wishing to come upon and elicit or simply explore information can use FRBO.Com, For Rent By Owner,.
See hillside online MLS, lakeside indexes, lakefront ad directories, and beach listed properties that home owners and property brokers post on our website, FRBO.com.
Observe and discover Lithopolis United States condo rentals and Lithopolis United States vacation rental.
Trippers, co-workers, and commuters who are inspecting Jackson Ohio bed and breakfast rentals and are trying to originate rent house, vacation homes, and real estate rentals in Jackson can go through our page and our loft advertisements, exclusive listings, rustic advertisements, and resort ad directories.
Distinguish, catch, and design homes for rent in Ashland Ohio, vacation rentals Ashland Ohio, rental home, and Ashland Ohio home rentals.
Perceive, identify, and explore rental apartment, Kimbolton United States houses for rent, and vacation homes in Kimbolton United States.
Identify and ferret out rent houses in Deersville United States and condo rentals Deersville United States.
Mountain classifieds and lakefront classified ads short term rentals Muskingum, homes for rent by owner in Muskingum Ohio, apartment rentals in Muskingum, and houses for rent in Muskingum Ohio.
Launch your research online tonight, now, next weekend, or on Saturday for your apartments for rent in Jackson and apartment rentals in Jackson Ohio.
Identify, find out, and come upon house rentals Powell, homes for rent in Powell, and rental home Powell United States.
|
|
