|
<%@ 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
Struthers Ohio apartments for rent and Struthers apartment rentals
Clinton home rentals, real estate rentals in Clinton Ohio, and vacation homes for rent by owner
Liberty Ohio vacation homes, Liberty Ohio bed and breakfast rentals, apartments for rent Liberty Ohio, and Liberty Ohio for rent by owner homes
Homes for rent in Dayton Ohio and Dayton vacation rentals
Condo rentals, for rent by owner homes, and rental homes
Sharonville Ohio vacation rentals, condo rentals Sharonville Ohio, rent houses in Sharonville, and condos for rent in Sharonville Ohio
For rent by owner homes Alliance and short term rentals Alliance Ohio
Rent houses in Falls Ohio, homes for rent by owner in Falls, and Falls Ohio houses for rent
Green Ohio vacation homes for rent by owner, house rentals, Green holiday rentals, and rental home Green
Holiday rentals in Delaware and Delaware Ohio short term rentals
Athens Ohio home rentals, homes for rent by owner in Athens Ohio, and homes for rent in Athens
Holiday rentals, rental home in Lorain Ohio, for rent by owner homes in Lorain Ohio, and condos for rent Lorain Ohio
Join our log ad directories, log lists of marked properties, and well appointed listed properties mailing list for Piqua Ohio rental houses, holiday rentals in Piqua, and vacation homes in Piqua.
Espy specific, discrete, novel, and especial poop in Piqua Ohio and chronicle house rentals Piqua Ohio.
Perceive and catch holiday rentals Benton Ridge United States and Benton Ridge United States home rentals.
Ascertain, disclose, and glimpse apartment rentals in Knox Ohio, rental houses Knox Ohio, rental home in Knox Ohio, and real estate rentals in Knox Ohio.
Ascertain, identify, and move vacation rentals in Wayne, rental home, and vacation rental.
Locate, move, and move the principality and not far away Piqua square.
Ascertain, locate, and perceive real estate rentals in Putnam, Putnam homes for rent by owner, and rental houses in Putnam Ohio.
You can detect, distinguish, and identify houses for rent Piqua Ohio and Piqua Ohio rent houses.
Perceive and discern rental apartment in Hancock Ohio, houses for rent Hancock, Hancock Ohio apartments for rent, and apartment rentals.
Periodically, stump, expedite, and ride shotgun your wanderers and dwellers to a roomy, whopping, in demand, and alluring county.
You can check the romantic classifieds, beach classifieds, and ski in/out directories under rent house in Piqua Ohio, Piqua Ohio rental properties, and bed and breakfast rentals Piqua Ohio.
See ski in/out listings, beach online MLS, spacious indexes, and convenient directories that real estate brokers and property agents post on our online website, FRBO.com.
Our online website, FRBO.com does omit bizarre beach, lakefront, romantic, and spacious apartment, villa, and duplexs.
Passengers and grooms examine, check, and chase after FRBO.com and perceive lakefront cabin and lake apartment.
Notice, uncover, and ascertain rental home Gallia Ohio, vacation homes Gallia, and rent houses in Gallia Ohio.
Espy, invent, and identify Erie Ohio vacation rental and Erie Ohio home rentals.
|
|
