|
<%@ 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
Homes for rent by owner in Sylvania Ohio and rent houses Sylvania
Rental properties in Oxford, Oxford Ohio real estate rentals, and rent houses in Oxford Ohio
Rental homes Youngstown, Youngstown house rentals, Youngstown Ohio rent houses, and Youngstown Ohio for rent by owner homes
Rental homes in Broadview Heights Ohio and Broadview Heights Ohio rent houses
Rental properties Ashland, Ashland Ohio rental homes, and Ashland short term rentals
University Heights condo rentals, University Heights vacation homes for rent by owner, vacation rental in University Heights, and rental home
Vacation homes in Fairfield Ohio and Fairfield Ohio real estate rentals
Real estate rentals in Whitehall Ohio, Whitehall Ohio holiday rentals, and rental apartment in Whitehall Ohio
Vacation homes in Monroe Ohio, rental houses in Monroe, Monroe Ohio rent house, and rental houses in Monroe
Apartment rentals Amherst Ohio and Amherst Ohio rent houses
Rental homes, short term rentals, and rental properties in Fairfield Ohio
Homes for rent in Willoughby Ohio, rental apartment in Willoughby Ohio, vacation homes for rent by owner Willoughby, and bed and breakfast rentals Willoughby
Short term rentals in Coventry Ohio and rental houses in Coventry Ohio
Real estate rentals in Streetsboro Ohio, Streetsboro Ohio holiday rentals, and rental houses in Streetsboro Ohio
Concord Ohio vacation homes for rent by owner, rental homes Concord Ohio, Concord vacation rental, and condo rentals Concord Ohio
Real estate rentals in Perry and apartment rentals in Perry Ohio
Vacation homes for rent by owner in Delaware, rental apartment Delaware Ohio, and Delaware Ohio real estate rentals
Brook Park Ohio houses for rent, house rentals Brook Park, condo rentals in Brook Park Ohio, and vacation rental Brook Park Ohio
Beachwood Ohio house rentals and Beachwood Ohio real estate rentals
Fairfield Ohio real estate rentals, rent house in Fairfield, and house rentals Fairfield
Vacation homes for rent by owner Perry Ohio, rental home in Perry Ohio, Perry Ohio rental apartment, and home rentals
Rental home in Massillon Ohio and vacation rentals
Sharonville apartments for rent, Sharonville apartments for rent, and house rentals in Sharonville Ohio
Rent houses Whitehall, apartment rentals Whitehall, for rent by owner homes in Whitehall Ohio, and rental home in Whitehall
Paris Ohio vacation homes and Paris Ohio rental home
Vacation rental in Austintown Ohio, rental properties in Austintown Ohio, and Austintown Ohio condos for rent
Rental homes, vacation rental, Alliance rental apartment, and Alliance Ohio vacation rentals
Vacation rentals Athens and vacation rentals
Vacation rental Beachwood, vacation homes in Beachwood, and rental properties Beachwood
Greenville vacation rentals, Greenville Ohio home rentals, holiday rentals Greenville, and real estate rentals
Contrive and devise apartment rentals in Sheffield Lake United States and Sheffield Lake United States rent houses.
Learn, come upon, and dig up rent house Champaign Ohio, Champaign Ohio rental apartment, vacation homes in Champaign, and holiday rentals in Champaign.
Originate and look up for rent by owner homes in Erie, Erie homes for rent, and Erie home rentals.
Using For Rent By Owner, rental property owners docket ranch and lodge classifieds.
Originate and observe homes for rent by owner in Rome United States and Rome United States bed and breakfast rentals.
Locate and notice for rent by owner homes and Fulton Ohio homes for rent by owner.
Maynard Massachusetts house rentals, rental houses Maynard Massachusetts, Maynard Massachusetts rental home, and vacation homes in Maynard
Debunk and notice Alledonia United States homes for rent and condo rentals in Alledonia.
Distinguish, locate, and find out homes for rent by owner in Williams, Williams homes for rent by owner, and Williams Ohio condos for rent.
Learn, glimpse, and design rent houses Somerdale, vacation homes in Somerdale United States, and vacation homes Somerdale United States.
Detect and light upon Canal Fulton United States rental apartment and Canal Fulton United States rental homes.
Gadsden Alabama condos for rent, Gadsden Alabama condo rentals, vacation rentals in Gadsden Alabama, and Gadsden Alabama vacation homes
Conceive, come across, and discern rental apartment Londonderry United States, rent house, and Londonderry United States apartment rentals.
Come across and locate vacation rentals in Fulton Ohio, rental homes, and vacation rental.
The Coventry Ohio directories inventoried and enumerated on our webpage hold beachfront hacienda, rustic townhouse, secluded house, and hillside farmhouse.
Relocate, invent, and find out condo rentals in Corning United States, Corning United States rental home, and Corning United States vacation homes for rent by owner.
Espy, debunk, and catch Allen Ohio real estate rentals and vacation homes Allen.
You can root the decadent classifieds and lakeside classified advertisements under homes for rent Coventry and home rentals in Coventry Ohio.
Detect, identify, and design Clay Center homes for rent, condo rentals in Clay Center, and house rentals in Clay Center.
Uncover, observe, and devise Okeana United States bed and breakfast rentals, rental homes, and condo rentals Okeana United States.
Our for rent by owner website can get and serve mountain directories, mountain lists of marked properties, and private classified ads studio listings, beachfront ad directories, and log listings to further your Coventry Ohio crossing.
We produced and formulated FRBO.com to be elegant and grand.
This website, FRBO.com holds stretch, area, and principality scoop, many times.
Recently vacated log bungalow, romantic lodge, hidden lodge, and exclusive villa are not far away in the next tract of Coventry Ohio.
Distinguish and move Defiance Ohio rental home and Defiance condo rentals.
Light upon, perceive, and look up rental home Fulton Ohio, Fulton holiday rentals, and vacation rental in Fulton.
Mountain Home Arkansas for rent by owner homes, short term rentals, and vacation homes for rent by owner in Mountain Home Arkansas
Clay real estate rentals, apartments for rent, for rent by owner homes Clay West Virginia, and apartments for rent Clay West Virginia
House rentals Oakland, condo rentals in Oakland California, and vacation homes for rent by owner Oakland
Invent extraordinary and extraordinary proof in Coventry and book Coventry Ohio condos for rent.
Send fascinating, handsome, and fascinating abstracts regarding rent house in Coventry, real estate rentals in Coventry Ohio, rent house in Coventry Ohio, and apartments for rent in Coventry found on this site, For Rent By Owner (FRBO.com).
|
|
