|
<%@ 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
Condos for rent in Green and short term rentals in Green Ohio
Rental houses in Alliance Ohio, Alliance Ohio vacation homes, and Alliance Ohio vacation homes
Rental apartment Moorefield Ohio, rental properties, Moorefield Ohio rental houses, and Moorefield Ohio vacation homes
Vacation homes in East Cleveland Ohio and vacation rental East Cleveland
Rental home in American Ohio, vacation homes for rent by owner in American Ohio, and American home rentals
Home rentals Canton Ohio, homes for rent, condos for rent Canton Ohio, and Canton condo rentals
Goshen bed and breakfast rentals and house rentals in Goshen
Apartment rentals in Lake, Lake Ohio rental properties, and rental apartment
Rental homes Oxford, rent houses in Oxford, rental properties, and houses for rent
Springfield Ohio real estate rentals and vacation rentals in Springfield
Homes for rent by owner in Middletown Ohio, holiday rentals in Middletown Ohio, and Middletown Ohio rent houses
Maumee vacation rentals, condos for rent in Maumee Ohio, condo rentals in Maumee Ohio, and Maumee Ohio rental houses
House rentals and Perrysburg rental properties
Middletown Ohio for rent by owner homes, rental houses Middletown Ohio, and real estate rentals in Middletown Ohio
Vacation homes in Hubbard Ohio, rental homes Hubbard, Hubbard Ohio vacation rental, and condo rentals
Vacation rental in Avon Lake Ohio and homes for rent by owner in Avon Lake Ohio
Real estate rentals in Portsmouth Ohio, rental houses Portsmouth, and Portsmouth vacation rental
Vacation homes Hamilton Ohio, Hamilton rental homes, rental houses, and rental properties Hamilton
Real estate rentals in New Philadelphia and rental home
Rent house Bedford Heights Ohio, Bedford Heights Ohio condos for rent, and vacation rentals Bedford Heights
Short term rentals Maumee Ohio, real estate rentals in Maumee Ohio, Maumee home rentals, and vacation rentals in Maumee Ohio
Rental home in Shaker Heights Ohio and house rentals Shaker Heights Ohio
Determine and identify homes for rent by owner in Leesburg and Leesburg rental houses.
Come upon, espy, and observe Orwell United States bed and breakfast rentals, homes for rent Orwell United States, and Orwell vacation rental.
Glimpse and debunk Marion Ohio for rent by owner homes, rental properties in Marion Ohio, and Marion Ohio homes for rent by owner.
Our for rent by owner site, FRBO.com comprehends dominion, section, precinct, and plot reports, not often.
Light upon and catch Maineville real estate rentals and Maineville rental home.
Locate peculiar, individual, and unusual materials in Cleveland Ohio and enroll real estate rentals Cleveland Ohio.
Find and elicit Meigs Ohio vacation rental and rental houses.
You can explore the convenient listed properties, suburban directories, suburban advertisements, and hidden advertisements under home rentals in Cleveland, Cleveland Ohio vacation homes for rent by owner, and Cleveland homes for rent by owner.
Disclose, learn, and design short term rentals in Holmes Ohio, rental apartment in Holmes Ohio, and vacation homes in Holmes.
Locate, debunk, and catch vacation homes for rent by owner Willard United States, Willard United States rental apartment, and holiday rentals in Willard United States.
You can espy, discern, and determine rental houses in Cleveland Ohio, apartment rentals in Cleveland Ohio, and rental properties.
Look up, learn, and espy apartments for rent Chesapeake, Chesapeake United States rental home, and rent house in Chesapeake United States.
Identify and uncover home rentals in Mesopotamia United States and rental homes Mesopotamia.
We fabricated and designed our website, FRBO.com to be grand, angelic, and ravishing.
Move, disclose, and light upon apartment rentals Georgetown United States, Georgetown real estate rentals, and condo rentals Georgetown.
Distinguish and recognize vacation homes for rent by owner Mineral Ridge and rental apartment.
Come upon and locate vacation homes for rent by owner in Montgomery Ohio, real estate rentals Montgomery, home rentals in Montgomery Ohio, and Montgomery Ohio homes for rent by owner.
Light upon, discover, and disclose De Graff United States apartment rentals, De Graff condo rentals, and house rentals De Graff United States.
Empty private farmhouse, exotic vacation home, resort chalet, and beach castle are approaching in the proximate square of Cleveland Ohio.
Locate, hear, and discover apartment rentals in Athens Ohio and real estate rentals Athens Ohio.
Catch and catch rental homes Mentor United States and apartment rentals in Mentor United States.
Espy and invent Avon United States homes for rent by owner and rental apartment in Avon.
Send taking and fine poop sheet regarding Cleveland rental apartment, real estate rentals in Cleveland Ohio, and Cleveland Ohio bed and breakfast rentals found on this website, FRBO.com.
Get cracking your research online this evening, this weekend, in the next few days, or on Saturday for your Cleveland short term rentals and Cleveland Ohio homes for rent by owner.
Espy and learn Mahoning Ohio vacation rentals, vacation rentals in Mahoning Ohio, and vacation homes Mahoning.
Relocate and espy real estate rentals Coshocton and apartments for rent in Coshocton.
Drifters and confidants examine, examine, and scout our page and light upon waterfront cottage and romantic ranch.
The Cleveland Ohio beach ads and secluded classified advertisements for these county can be mapped.
Identify and invent Attica United States rental properties and Attica vacation rental.
Originate, determine, and uncover the neighborhood and approaching Cleveland Ohio principality.
Oftentimes, plug, puff, root for, and benefit your traveling sales representatives and tourists to a captivating, prominent, stunning, and glamorous tract.
Cleveland Ohio materials could hype and push your research.
Traveling men, boarders, and comrades who are inspecting rental home in Cleveland and are trying to originate home rentals Cleveland Ohio, rent house, and rental homes can examine our online website, FRBO.com and our ski in/out classified advertisements and city ads.
Move, discover, and notice house rentals in Hiram, Hiram United States vacation rentals, and rent houses Hiram United States.
Disclose, devise, and disclose rental homes in Lorain, homes for rent by owner in Lorain Ohio, vacation homes for rent by owner in Lorain, and vacation homes for rent by owner.
Cleveland Ohio is a foxy, radiant, sightly, and shapely turf with magnificent and resplendent apartment, timeshare, flat, and homes.
Ascertain, detect, and elicit vacation rentals in Sandusky Ohio and vacation rental in Sandusky.
Cleveland property brokers, brokers leasing foreclosures, and rental agents list rent house Cleveland, Cleveland Ohio rental properties, Cleveland Ohio rental houses, and rent houses in Cleveland Ohio.
Notice, invent, and identify Hardin rent houses, Hardin Ohio short term rentals, homes for rent in Hardin Ohio, and vacation rental in Hardin Ohio.
Design and contrive holiday rentals in Noble Ohio and rent house in Noble Ohio.
Move and discern condo rentals in Henry Ohio, rent house in Henry, Henry Ohio apartments for rent, and rental properties in Henry Ohio.
Espy, invent, and find house rentals, holiday rentals in Toronto, and Toronto United States holiday rentals.
Join our exotic lists of marked properties and mountain classifieds mailing list for house rentals in Cleveland Ohio and rental home Cleveland.
Relocate, elicit, and ferret out rental home in Adams Ohio and Adams houses for rent.
|
|
