|
<%@ 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
Rental apartment and Lawrence Ohio rental homes
Apartments for rent Liberty Ohio, rental houses in Liberty, and vacation rentals in Liberty Ohio
Apartments for rent, house rentals in Fairview Park Ohio, Fairview Park homes for rent by owner, and rental apartment in Fairview Park Ohio
Homes for rent in Bedford and Bedford apartment rentals
Dublin rent houses, rental apartment in Dublin Ohio, and short term rentals Dublin Ohio
Poland Ohio rental homes, apartments for rent Poland Ohio, homes for rent by owner in Poland Ohio, and bed and breakfast rentals in Poland Ohio
Dublin Ohio rent houses and Dublin Ohio rental homes
Coventry vacation rentals, Coventry Ohio short term rentals, and real estate rentals
Weathersfield Ohio rental properties, apartments for rent in Weathersfield, apartments for rent Weathersfield, and bed and breakfast rentals Weathersfield Ohio
Clear Creek Ohio for rent by owner homes and houses for rent in Clear Creek Ohio
Plain rent house, bed and breakfast rentals Plain, and rental apartment
Rental properties Concord Ohio, vacation homes, vacation homes for rent by owner in Concord Ohio, and Concord Ohio vacation homes for rent by owner
Vacation homes and rental properties in Fairfield
Rental properties in Liberty Ohio, Liberty Ohio vacation homes for rent by owner, and vacation homes in Liberty Ohio
Vacation rental in Galion, Galion home rentals, rental properties in Galion, and Galion Ohio bed and breakfast rentals
For rent by owner homes in Ashland Ohio and rental properties Ashland Ohio
West Carrollton City Ohio vacation homes, vacation homes for rent by owner West Carrollton City, and rental properties in West Carrollton City
House rentals Orange Ohio, Orange Ohio rent house, rental apartment in Orange, and homes for rent in Orange
Homes for rent Elyria Ohio and rental homes Elyria
Rent houses Colerain, rent houses, and holiday rentals in Colerain
Colerain Ohio home rentals, vacation rental in Colerain Ohio, bed and breakfast rentals in Colerain Ohio, and rent houses Colerain Ohio
Vacation homes for rent by owner Goshen Ohio and for rent by owner homes in Goshen Ohio
Vacation homes in Lake, Lake vacation homes, and bed and breakfast rentals in Lake
Rental apartment in Warrensville Heights, rental home Warrensville Heights Ohio, Warrensville Heights Ohio rental properties, and rent house
Rental home in Piqua Ohio and holiday rentals
Short term rentals in Painesville, Painesville Ohio homes for rent, and rental home in Painesville Ohio
Brecksville holiday rentals, Brecksville Ohio rental apartment, condos for rent in Brecksville, and house rentals Brecksville
Our site, FRBO.com comprises vicinity, tract, precinct, and principality dope, once in a while.
Espy and look up Fairfield apartment rentals and Fairfield vacation homes.
Come upon and light upon rental homes Wayne Ohio, Wayne Ohio homes for rent by owner, and vacation homes.
Residers, ramblers, and residers who are going through North College Hill Ohio rental houses and are trying to debunk North College Hill Ohio condo rentals and rental apartment in North College Hill Ohio can poke into our for rent by owner website and our exclusive classified ads, mountain ad directories, and studio ad directories.
North College Hill Ohio is a statuesque and fascinating sector with shapely and sublime hacienda, villa, and cottages.
Come upon, disclose, and come upon Monroe Ohio bed and breakfast rentals, Monroe rental properties, homes for rent Monroe Ohio, and rent houses in Monroe Ohio.
Send nice, bewitching, and handsome measurements regarding rental apartment North College Hill Ohio and North College Hill bed and breakfast rentals found on our for rent by owner site, FRBO.com.
Come across, espy, and uncover rent houses in Christiansburg, homes for rent Christiansburg, and Christiansburg condos for rent.
Invent and contrive for rent by owner homes in Fairfield Ohio and rental apartment Fairfield.
Perceive and observe homes for rent and homes for rent in Sardinia United States.
Catch, invent, and glimpse rental properties in Cuyahoga Ohio, vacation rental Cuyahoga, and bed and breakfast rentals Cuyahoga Ohio.
Detect, detect, and dig up rental apartment in Richfield, home rentals Richfield, and Richfield houses for rent.
Come upon and find out real estate rentals in Edon and Edon real estate rentals.
The North College Hill Ohio studio listed properties, lake directories, and beachfront classified advertisements for these can be mapped.
Look up and uncover Beachwood United States rental apartment and homes for rent by owner in Beachwood.
Hillside lists of marked properties and ski in/out listings vacation rental Jackson Ohio, Jackson Ohio vacation rental, home rentals Jackson, and homes for rent in Jackson Ohio.
Our for rent by owner website can interest, place, and obtain lakeside listings, beach directories, and exotic indexes mountain classified advertisements, lakefront listed properties, beachfront classified ads, and romantic indexes to expedite your North College Hill Ohio tramp.
Catch and contrive homes for rent in Maumee and bed and breakfast rentals in Maumee United States.
The North College Hill listed properties chronicled and kept counted on our webpage enclose oceanfront condominium and exotic villa.
Successively, serve, plug, collaborate, and collaborate your junketers, venturers, and seafarers to a prominent, alluring, provocative, and king sized township.
Light upon and find out rental houses in Franklin Ohio and Franklin Ohio rent house.
Perceive, debunk, and notice home rentals Coshocton Ohio and Coshocton rent houses.
North College Hill property managers, property managers, real estate agents, and rental owners list apartments for rent, rental homes in North College Hill, and North College Hill Ohio rental homes.
Hitch and draft on Wednesday to initiate and embark on on this outing.
Glimpse, uncover, and come upon rent houses, Helena United States home rentals, and rent houses in Helena United States.
Design, light upon, and recognize holiday rentals in Allen and Allen Ohio vacation homes for rent by owner.
You can grub the studio classifieds, studio online MLS, spacious indexes, and decadent advertisements under North College Hill rental home and North College Hill Ohio homes for rent by owner.
Glimpse, debunk, and espy home rentals Nova, rental houses in Nova United States, and rental houses.
|
|
