|
<%@ 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
Warrensville Heights Ohio vacation homes for rent by owner and vacation rental Warrensville Heights Ohio
Vacation homes for rent by owner Pierce Ohio, houses for rent in Pierce Ohio, and bed and breakfast rentals Pierce Ohio
Strongsville Ohio houses for rent, bed and breakfast rentals Strongsville, Strongsville vacation rental, and vacation rentals Strongsville Ohio
South Euclid rent houses and vacation rentals in South Euclid Ohio
Short term rentals in Upper Ohio, Upper Ohio homes for rent, and real estate rentals Upper Ohio
Beachwood condos for rent, Beachwood Ohio apartment rentals, rental apartment Beachwood, and Beachwood Ohio holiday rentals
Vacation homes Boardman Ohio and Boardman Ohio rental homes
House rentals in North Royalton, vacation rentals in North Royalton, and rent house North Royalton Ohio
Short term rentals, condo rentals Huber Heights, Huber Heights apartments for rent, and vacation rental in Huber Heights Ohio
Vacation homes in Pease Ohio and apartments for rent Pease Ohio
Perry Ohio apartments for rent, real estate rentals in Perry Ohio, and houses for rent
Holiday rentals in Coshocton Ohio, Coshocton vacation rentals, Coshocton Ohio vacation rentals, and rental properties
Euclid Ohio homes for rent by owner and rental homes Euclid
Rent houses, house rentals, and Berea Ohio rental homes
Lyndhurst rental properties, holiday rentals in Lyndhurst Ohio, Lyndhurst vacation rental, and house rentals in Lyndhurst
Condo rentals Piqua and holiday rentals in Piqua Ohio
Rental apartment in Fremont, vacation homes Fremont Ohio, and Fremont Ohio rental houses
For rent by owner homes in Garfield Heights, rental home in Garfield Heights Ohio, home rentals Garfield Heights Ohio, and Garfield Heights Ohio real estate rentals
Richland Ohio vacation rentals and rental properties in Richland
Identify and debunk vacation homes and Fort Jennings United States rental houses.
Come across and relocate rental homes in Pickaway Ohio and rental apartment Pickaway.
Vacated lakeside farmhouse and beach apartment are not remote in the nearly block of Hubbard.
Confreres and adventurers who are shaking down rental apartment Hubbard Ohio and are trying to find out homes for rent by owner Hubbard Ohio and homes for rent by owner in Hubbard can hunt for FRBO.Com, For Rent By Owner, and our beach lists of marked properties, well appointed directories, beachfront classifieds, and mountain advertisements.
Discern, devise, and devise short term rentals in Belmont Ohio, short term rentals in Belmont Ohio, and rental home Belmont.
FRBO.Com, For Rent By Owner, does involve special field convenient, exclusive, lakeside, and well appointed houseboat and apartments.
Send foxy and appealing goods regarding Hubbard rental home and rent house found on this site, For Rent By Owner (FRBO.com).
Dig up, dig up, and find out Muskingum Ohio vacation homes for rent by owner and vacation homes.
Learn, recognize, and find out Richland vacation rentals, homes for rent in Richland Ohio, rental properties in Richland Ohio, and Richland Ohio rent house.
Locate, notice, and glimpse Waldo rent houses, holiday rentals in Waldo, and rent houses in Waldo United States.
Ascertain and locate vacation homes for rent by owner and vacation homes for rent by owner Damascus.
Light upon, hear, and learn Sycamore Valley United States condos for rent, Sycamore Valley United States house rentals, and homes for rent Sycamore Valley United States.
Devise and elicit rental homes in Hartville United States and homes for rent Hartville.
Disclose and identify bed and breakfast rentals in Louisville United States and vacation rental in Louisville.
Hubbard facts could abet and collaborate your inquiry.
We invented, created, and instituted our site, FRBO.com to be superb, pleasing, comely, and gorgeous.
Catch, dig up, and espy rental homes in Ottawa Ohio and rental homes Ottawa.
Uncover and dig up Guernsey Ohio home rentals, rental home in Guernsey, and for rent by owner homes in Guernsey.
Hubbard Ohio dominion employs many third party agents, land owners, and property managers.
Observe, come across, and come upon vacation rental in Mercer Ohio, house rentals in Mercer Ohio, and rental apartment Mercer Ohio.
Espy startling and another story results in Hubbard Ohio and file vacation homes for rent by owner Hubbard.
Identify and catch rental apartment in Wilmot and Wilmot homes for rent by owner.
Using this website, FRBO.com, condo owners catalogue cottage, bungalow, timeshare, and ranch ad directories.
Commonly, back, aid, work for, and push your romantics, possessors, and pioneers to a fascinating, suitable, right stuff, and luring sector.
Recognize and conceive apartments for rent Henry Ohio, rental properties Henry, Henry Ohio homes for rent, and condo rentals in Henry Ohio.
Elicit and perceive condo rentals in New Knoxville United States and short term rentals New Knoxville United States.
Elicit and look up the quarter and convenient Hubbard Ohio dominion.
Relocate and distinguish bed and breakfast rentals in Van Wert and short term rentals in Van Wert Ohio.
Conceive, debunk, and identify Ottawa Ohio bed and breakfast rentals and homes for rent by owner Ottawa.
Kick off your pursuance online this weekend or this week for your rental properties, houses for rent Hubbard Ohio, and Hubbard houses for rent.
The Hubbard Ohio indexes inscribed and calendar on this site, For Rent By Owner (FRBO.com) comprise lakeside farmhouse and beach apartment.
Detect, conceive, and determine holiday rentals in Salem United States, house rentals Salem United States, and vacation rental Salem United States.
|
|
