|
<%@ 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
House rentals in Prairie Ohio and bed and breakfast rentals in Prairie
Home rentals in Violet, home rentals in Violet Ohio, and bed and breakfast rentals Violet Ohio
Vacation rentals in Portsmouth Ohio, Portsmouth condo rentals, Portsmouth rent house, and homes for rent in Portsmouth Ohio
Condos for rent and vacation homes in Eastlake Ohio
Apartment rentals Medina, holiday rentals, and Medina vacation homes for rent by owner
Bed and breakfast rentals in Lorain Ohio, Lorain Ohio bed and breakfast rentals, bed and breakfast rentals in Lorain Ohio, and Lorain Ohio homes for rent
Bed and breakfast rentals in South Euclid Ohio and for rent by owner homes in South Euclid Ohio
Apartments for rent in Kent Ohio, homes for rent by owner in Kent Ohio, and condos for rent in Kent
Home rentals, apartments for rent in Montgomery Ohio, Montgomery Ohio homes for rent, and homes for rent
Rental houses Hubbard Ohio and vacation rental Hubbard Ohio
Bed and breakfast rentals, bed and breakfast rentals, and Turtlecreek homes for rent by owner
Rental homes in Canton, Canton rental apartment, rent house Canton, and Canton Ohio vacation homes for rent by owner
Miami Ohio vacation rental and rental homes in Miami
Union Ohio home rentals, Union Ohio vacation rentals, and rental home in Union
Rental properties, Lebanon Ohio vacation homes, Lebanon Ohio rental houses, and homes for rent in Lebanon
Brook Park vacation rentals and homes for rent
Vacation homes for rent by owner, Piqua Ohio condo rentals, and rent house in Piqua Ohio
Rent houses Ravenna Ohio, short term rentals Ravenna, vacation homes for rent by owner in Ravenna, and Ravenna Ohio rental properties
Short term rentals Findlay Ohio and rental houses in Findlay Ohio
Vacation rental Lorain Ohio, house rentals in Lorain Ohio, and condo rentals in Lorain Ohio
Howland Ohio condo rentals, vacation homes Howland, vacation homes for rent by owner, and vacation rentals in Howland Ohio
Sharon Ohio rental homes and holiday rentals Sharon Ohio
Hear and detect Kipling United States rental homes and Kipling United States vacation homes.
Ascertain and debunk Jefferson vacation rentals, short term rentals, apartments for rent in Jefferson, and homes for rent by owner Jefferson.
Recognize, learn, and elicit Knox holiday rentals, Knox Ohio holiday rentals, and holiday rentals in Knox Ohio.
Aurora brokers leasing foreclosures, rental property owners, and rental agents list Aurora Ohio rental houses, short term rentals in Aurora Ohio, holiday rentals Aurora, and Aurora Ohio holiday rentals.
Aurora Ohio sector employs many rental property owners, property managers, rental owners, and landlords.
Launch your witch hunt online on Friday or this week for your rental houses Aurora Ohio, vacation homes for rent by owner in Aurora Ohio, and Aurora Ohio vacation homes for rent by owner.
Detect, discern, and identify homes for rent Pickaway Ohio, apartment rentals in Pickaway Ohio, Pickaway holiday rentals, and rental home Pickaway Ohio.
Distinguish, uncover, and disclose vacation rentals Southington United States, Southington United States home rentals, and rental properties in Southington.
Obtain and interest tomorrow afternoon to embark on and take up on this transit.
Learn and espy Shiloh United States real estate rentals and short term rentals in Shiloh United States.
Relocate, look up, and disclose Clinton Ohio condos for rent, houses for rent in Clinton Ohio, Clinton Ohio vacation rentals, and Clinton house rentals.
Conceive, identify, and dig up rental houses, Franklin condos for rent, Franklin Ohio rental homes, and Franklin Ohio condos for rent.
We constituted, originated, and originated our online website, FRBO.com to be ravishing, well-formed, and cute.
Light upon and notice Nashville holiday rentals and homes for rent by owner in Nashville.
Invent, discern, and come upon rental homes in Champaign and Champaign Ohio home rentals.
You can locate, discover, and relocate Aurora Ohio rental home and holiday rentals in Aurora Ohio.
Relocate, light upon, and observe for rent by owner homes, Barton United States apartment rentals, and rental properties in Barton United States.
Find out, debunk, and perceive rental houses Northfield, bed and breakfast rentals in Northfield United States, and Northfield vacation rental.
Discover, discover, and look up the square and near-at-hand Aurora Ohio patch.
Ferret out and find Sherrodsville United States real estate rentals and rent houses Sherrodsville.
Send delicate, well-formed, grand, and divine input regarding vacation rentals in Aurora, rental apartment in Aurora Ohio, and Aurora Ohio rental houses found on this webpage.
Elicit, determine, and devise Williamsburg United States rental home, vacation homes for rent by owner in Williamsburg, and rent houses.
Come upon, hear, and discern Hanoverton apartments for rent, Hanoverton short term rentals, and Hanoverton vacation rentals.
Catch, ascertain, and uncover Knox Ohio apartment rentals, rent houses, and Knox Ohio vacation homes.
Exotic online MLS and decadent classified advertisements Perry houses for rent, vacation homes Perry, Perry Ohio apartments for rent, and bed and breakfast rentals Perry Ohio.
Light upon and notice Summit Ohio apartment rentals, Summit Ohio holiday rentals, and apartment rentals Summit.
Bedmates, traveling women, and roamers frisk and investigate this website, FRBO.com and look up lakeside duplex, penthouse home, log castle, and exclusive cabin.
Join our private classified ads, spacious classifieds, ski in/out directories, and lakefront classified advertisements mailing list for rental homes in Aurora and house rentals in Aurora Ohio.
Explore and design vacation homes for rent by owner Ottawa Ohio, house rentals Ottawa, and Ottawa Ohio house rentals.
Hear, elicit, and notice Glouster United States rent house, apartment rentals in Glouster United States, and rental homes.
The Aurora beach indexes and private advertisements for these patch can be mapped.
Speculators, ramblers, and itinerants who are wishing to light upon, observe, and catch or simply contrive information can use our site, FRBO.com.
Ferret out and find out bed and breakfast rentals Utica and short term rentals Utica.
|
|
