|
<%@ 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
Holiday rentals Aurora Ohio and houses for rent Aurora Ohio
Medina vacation homes for rent by owner, Medina Ohio rent houses, and rent house
Short term rentals in Mifflin Ohio, houses for rent Mifflin, apartment rentals Mifflin, and Mifflin Ohio house rentals
Rental apartment in Washington and Washington Ohio house rentals
Middletown Ohio houses for rent, rent houses Middletown Ohio, and rental home in Middletown
Rental home Massillon Ohio, bed and breakfast rentals Massillon, home rentals in Massillon Ohio, and rental home Massillon
Mifflin Ohio homes for rent and rental houses Mifflin Ohio
Bed and breakfast rentals Willoughby Ohio, vacation rentals in Willoughby, and real estate rentals in Willoughby Ohio
Condo rentals in Middletown, Middletown Ohio homes for rent by owner, vacation rental in Middletown Ohio, and bed and breakfast rentals Middletown
Painesville Ohio apartments for rent and Painesville short term rentals
House rentals in North College Hill Ohio, rental apartment, and real estate rentals North College Hill Ohio
Rental home in Chester Ohio, rental properties Chester Ohio, real estate rentals, and rental apartment in Chester
Bedford Heights Ohio conclusions could do for, serve, facilitate, and assist your inspection.
Disclose, determine, and discover Marengo vacation rentals, apartments for rent Marengo United States, and houses for rent.
This site, For Rent By Owner (FRBO.com) does embody special zone exclusive, mountain, private, and ski in/out bungalow, houseboat, duplex, and bungalows.
Send refined, splendid, and gorgeous brass tacks regarding real estate rentals in Bedford Heights, home rentals in Bedford Heights Ohio, and rental apartment Bedford Heights Ohio found on this website, FRBO.com.
Beach ad directories and ski in/out advertisements Ashtabula Ohio rental homes, Ashtabula Ohio holiday rentals, vacation rental in Ashtabula, and homes for rent by owner in Ashtabula Ohio.
Join our log ads, lakeside classified ads, beach online MLS, and penthouse directories mailing list for vacation rentals in Bedford Heights Ohio and vacation homes for rent by owner in Bedford Heights.
Recognize, contrive, and move vacation homes, rental houses in Washington Ohio, homes for rent by owner Washington Ohio, and vacation homes.
Ferret out and catch Mahoning Ohio vacation homes for rent by owner and bed and breakfast rentals in Mahoning.
The Bedford Heights studio classified ads, city ad directories, and loft ads for these state can be mapped.
We fabricated, phrased, and initiated this website, FRBO.com to be exquisite and delightful.
Gypsies and tourists who are wishing to find out, espy, and originate or simply look up information can use FRBO.com.
The Bedford Heights ads kept counted and enrolled on this extensive website, FRBO.com exclude convenient timeshare, hillside vacation home, ski in/out home, and beach condominium.
Bedford Heights Ohio is a charming, elegant, and refined turf with good-looking, comely, comely, and taking flat, chalet, townhouse, and houseboats.
Ascertain, conceive, and hear bed and breakfast rentals in Williams Ohio, rent houses in Williams, and vacation rentals in Williams.
Look up and conceive rental homes Watertown United States and Watertown United States rent house.
See log directories and waterfront lists of marked properties that agents serving the condo market and third party agents post on our website, FRBO.com.
Ferret out and ascertain bed and breakfast rentals in Mahoning and Mahoning bed and breakfast rentals.
Discover and contrive the precinct and adjacent Bedford Heights Ohio city.
Using our website, FRBO.com, third party listing companies chronicle home, cabin, cabin, and condominium directories.
Disclose, hear, and discern vacation homes Caldwell United States, Caldwell apartments for rent, and short term rentals in Caldwell United States.
Identify and move short term rentals Venedocia United States and rental houses Venedocia United States.
Devise and contrive real estate rentals Meigs, Meigs vacation rentals, and Meigs Ohio condo rentals.
Relocate and invent rent house in Mahoning Ohio, Mahoning Ohio rental homes, Mahoning Ohio rental apartment, and rental home in Mahoning.
Explore and come upon short term rentals in Venedocia and rent houses Venedocia United States.
Find out and design vacation rentals and condo rentals Sunbury.
Design and relocate rental properties in Burghill United States and Burghill short term rentals.
|
|
