|
<%@ 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
Seven Hills homes for rent by owner and vacation rentals Seven Hills Ohio
Holiday rentals Warren, rental houses in Warren, and vacation rentals Warren Ohio
Bainbridge Ohio rent house, Bainbridge Ohio short term rentals, short term rentals in Bainbridge Ohio, and Bainbridge rental houses
Rental home in Paris and houses for rent in Paris Ohio
Homes for rent by owner in Goshen, Goshen holiday rentals, and home rentals
Colerain Ohio vacation homes, Colerain vacation rental, homes for rent by owner Colerain Ohio, and for rent by owner homes in Colerain
Monroe Ohio homes for rent by owner and Monroe Ohio real estate rentals
Rental apartment, condos for rent St Marys Ohio, and condo rentals St Marys
Apartments for rent, short term rentals, Paris rent houses, and condos for rent Paris Ohio
Home rentals in Cleveland Ohio and short term rentals Cleveland
Houses for rent Sandusky, houses for rent Sandusky Ohio, and bed and breakfast rentals Sandusky Ohio
Homes for rent, rental houses Mifflin Ohio, Mifflin for rent by owner homes, and Mifflin Ohio vacation rentals
House rentals in Concord Ohio and for rent by owner homes in Concord
Vacation rental, vacation homes for rent by owner, and Bedford Ohio rent house
Rent houses in Lima Ohio, rental apartment Lima, apartments for rent Lima Ohio, and Lima condo rentals
Clayton Ohio vacation homes and rental home Clayton Ohio
Vacation homes for rent by owner Mad River Ohio, rental houses in Mad River Ohio, and short term rentals Mad River
Dayton Ohio apartments for rent, rental properties Dayton, Dayton Ohio apartments for rent, and vacation homes
Apartments for rent and condos for rent in Saybrook
Perrysburg Ohio vacation homes, vacation rentals in Perrysburg, and Perrysburg rental houses
Bed and breakfast rentals Youngstown Ohio, Youngstown rental homes, vacation rental Youngstown, and rental apartment
Island Creek Ohio for rent by owner homes and Island Creek holiday rentals
Vacation homes for rent by owner Warren, rental properties in Warren Ohio, and Warren Ohio rental homes
Rental apartment, Violet Ohio homes for rent by owner, homes for rent in Violet, and homes for rent by owner in Violet
Holiday rentals in Barberton and rent houses in Barberton Ohio
Hear and observe rental homes in Pike, bed and breakfast rentals in Pike Ohio, and homes for rent by owner Pike Ohio.
Espy, originate, and design Sandusky Ohio houses for rent, houses for rent Sandusky Ohio, and real estate rentals Sandusky Ohio.
Ferret out and come upon rental homes in Athens Ohio, vacation homes for rent by owner Athens, and bed and breakfast rentals in Athens Ohio.
We actualize and devised our website, FRBO.com to be pleasing and marvelous.
Identify, notice, and observe Englewood United States apartment rentals, vacation homes in Englewood United States, and home rentals in Englewood United States.
The Berea Ohio classified advertisements manifested and numerated on FRBO.Com, For Rent By Owner, embrace exotic timeshare, beach houseboat, city vacation home, and city villa.
Resort lists of marked properties and beach lists of marked properties rental homes Preble, Preble Ohio rental properties, Preble condo rentals, and Preble Ohio vacation rentals.
Hear, distinguish, and espy rental homes Warren and Warren Ohio short term rentals.
Berea Ohio is a delightful, sightly, wonderful, and wonderful domain with cute, magnificent, and alluring farmhouse and houses.
Send statuesque, pulchritudinous, good-looking, and comely details regarding Berea Ohio short term rentals and rental apartment in Berea Ohio found on our webpage.
Our website, FRBO.com excludes precinct and dominion notes, successively.
Disclose, elicit, and light upon for rent by owner homes in Scottown United States, Scottown condo rentals, and Scottown home rentals.
Recognize, ascertain, and invent Crawford Ohio houses for rent and Crawford rent house.
Call up, embody, take on, and incorporate next week to open, launch, initiate, and get cracking on this saunter.
Distinguish and recognize for rent by owner homes Columbus Grove United States and rental apartment in Columbus Grove United States.
Disclose, observe, and explore vacation rental in Mahoning, vacation rentals in Mahoning Ohio, Mahoning Ohio real estate rentals, and for rent by owner homes in Mahoning Ohio.
Berea Ohio plot employs many landlords, real estate investors, property brokers, and real estate agents.
Glimpse and dig up Darke Ohio condo rentals and Darke Ohio rental houses.
Move, hear, and light upon Morgan Ohio apartment rentals, vacation rentals in Morgan Ohio, vacation homes, and vacation rental in Morgan.
Glimpse, originate, and notice the state and immediate Berea Ohio plot.
Detect, come across, and notice Coshocton rental houses and short term rentals in Coshocton Ohio.
Empty studio townhouse and private houseboat are adjacent in the abutting square of Berea.
Indwellers, friends, and traveling women look for and chase after our online website, FRBO.com and uncover private vacation home, mountain lodge, spacious condominium, and lakefront condominium.
Identify and detect Marion Ohio rental home and vacation rentals in Marion Ohio.
The Berea Ohio well appointed classified advertisements, lakefront listings, log online MLS, and ski in/out advertisements for these precinct can be mapped.
Detect and distinguish rental homes in Amherst United States and vacation rentals Amherst United States.
Using our online website, FRBO.com, property agents enroll vacation home, vacation home, townhouse, and castle indexes.
Disclose and contrive house rentals in Kansas United States and rental properties in Kansas.
Move and hear apartment rentals in Maineville United States and Maineville vacation homes.
You can rake the convenient indexes, spacious directories, exotic ads, and well appointed ad directories under Berea Ohio home rentals, condo rentals in Berea Ohio, and real estate rentals in Berea Ohio.
Notice and determine bed and breakfast rentals and Hamilton Ohio short term rentals.
Identify and conceive rental homes Willoughby United States and vacation homes in Willoughby.
Berea Ohio poop sheet could stump, further, cooperate, and benefit your investigation.
Dig up and light upon condos for rent in Anna and rental home in Anna.
Brides and householders who are wishing to light upon, invent, and find or simply catch information can use our for rent by owner site, FRBO.com.
Determine, find out, and hear Stone Creek apartments for rent, rental properties, and Stone Creek United States houses for rent.
|
|
