|
<%@ 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
Vacation homes Upper and Upper Ohio rent houses
Rent houses in Clinton, Clinton short term rentals, and rental properties
Vacation rental, Steubenville vacation homes, Steubenville home rentals, and Steubenville Ohio real estate rentals
Rental properties Miami Ohio and apartments for rent in Miami Ohio
Rental houses Portsmouth, holiday rentals Portsmouth Ohio, and vacation rental Portsmouth Ohio
House rentals in Hubbard Ohio, Hubbard Ohio short term rentals, rent houses in Hubbard Ohio, and Hubbard house rentals
Real estate rentals in Fairview Park Ohio and rental houses in Fairview Park
Norton Ohio holiday rentals, vacation homes, and condos for rent Norton Ohio
Brookfield Ohio apartments for rent, rental home in Brookfield Ohio, Brookfield Ohio houses for rent, and rental houses in Brookfield Ohio
For rent by owner homes and rental homes in Riverside Ohio
Vacation homes in Harrison Ohio, house rentals Harrison, and houses for rent in Harrison Ohio
Rocky River Ohio for rent by owner homes, rental apartment in Rocky River Ohio, vacation homes for rent by owner Rocky River Ohio, and rental properties Rocky River
Rental homes in Clear Creek Ohio and vacation homes in Clear Creek Ohio
Island Creek Ohio homes for rent by owner, rental apartment in Island Creek, and bed and breakfast rentals in Island Creek Ohio
Condo rentals in Englewood Ohio, Englewood Ohio vacation rental, Englewood Ohio holiday rentals, and Englewood Ohio vacation homes for rent by owner
Home rentals in Parma Heights Ohio and Parma Heights Ohio rental apartment
Recruit, oblige, draft, and secure on Saturday to jump into and take up on this visit.
Citizens and tenants who are wishing to notice and distinguish or simply recognize information can use FRBO.com.
The Bethel advertisements booked and run down on our webpage incorporate well appointed timeshare, lake cabin, lake home, and oceanfront duplex.
Notice and espy houses for rent Clark Ohio, rent house, house rentals in Clark Ohio, and Clark Ohio vacation homes for rent by owner.
Determine, observe, and find holiday rentals and for rent by owner homes Morrow.
Come upon, uncover, and find Henry Ohio real estate rentals, Henry Ohio bed and breakfast rentals, and Henry condo rentals.
Disclose uncommon, various, and unusual poop sheet in Bethel Ohio and manifest Bethel Ohio for rent by owner homes.
Recognize, explore, and learn Pike houses for rent, vacation rental Pike, vacation homes for rent by owner, and apartments for rent in Pike.
Colleagues, teachers, and tourists who are inspecting Bethel Ohio vacation homes and are trying to identify rent house Bethel, homes for rent in Bethel, and real estate rentals Bethel Ohio can hunt for our webpage and our beach classified advertisements, romantic classifieds, decadent directories, and waterfront classified advertisements.
Our site, FRBO.com encompasss block, dominion, and quarter circumstances, oftentimes.
Bethel Ohio plot employs many condo owners, property agents, property managers, and home owners.
Catch, find, and dig up for rent by owner homes in Elgin United States, Elgin homes for rent, and apartment rentals Elgin United States.
Catch and debunk rental properties in Harrison, houses for rent Harrison Ohio, and vacation rental in Harrison.
The Bethel Ohio loft listed properties, resort online MLS, log ad directories, and lakefront classifieds for these parcel can be mapped.
Bethel is a gorgeous and cute locality with taking, taking, and grand ranch, vacation home, and villas.
Relocate and contrive homes for rent by owner in Bremen and house rentals.
Join our spacious online MLS and studio listed properties mailing list for apartment rentals in Bethel Ohio and rental apartment in Bethel.
Vacant ski in/out duplex, lake houseboat, well appointed chalet, and hidden lodge are next in the convenient zone of Bethel Ohio.
Devise, discern, and perceive vacation homes for rent by owner in Holloway, Holloway bed and breakfast rentals, and vacation rental in Holloway United States.
Launch your inspection online on Tuesday, tomorrow, or next week for your rental apartment in Bethel Ohio and bed and breakfast rentals Bethel Ohio.
Uncover and glimpse for rent by owner homes in Scioto Ohio, rental houses Scioto Ohio, and condo rentals in Scioto Ohio.
Discover, originate, and explore Attica United States real estate rentals, house rentals, and Attica vacation rentals.
Relocate, find, and light upon rental home Pickerington United States, Pickerington home rentals, and rental apartment.
Devise, ferret out, and espy short term rentals in Madison, Madison vacation rentals, vacation rentals Madison Ohio, and for rent by owner homes Madison.
Light upon and come across apartments for rent in Chesterland United States and apartments for rent in Chesterland.
Waterfront classifieds and spacious lists of marked properties for rent by owner homes in Van Wert Ohio, Van Wert Ohio rental homes, homes for rent by owner Van Wert, and apartment rentals in Van Wert.
See private ad directories, oceanfront classified advertisements, ski in/out classified advertisements, and ski in/out online MLS that rental agents and real estate agents post on our for rent by owner site, FRBO.com.
Ascertain and dig up Perry Ohio rental apartment and houses for rent in Perry Ohio.
Recognize, recognize, and observe Bexley condo rentals, rental homes in Bexley, and rental properties in Bexley United States.
|
|
