|
<%@ 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
Apartment rentals in American and real estate rentals American
Rental home North College Hill Ohio, North College Hill Ohio apartments for rent, and rent houses North College Hill Ohio
Bowling Green Ohio rent houses, Bowling Green Ohio vacation rentals, condos for rent in Bowling Green Ohio, and rental properties
Vacation homes for rent by owner in Jefferson Ohio and holiday rentals in Jefferson Ohio
Vacation rental Massillon, homes for rent, and rent house Massillon
Rental home Canton Ohio, Canton Ohio house rentals, rent house in Canton Ohio, and apartments for rent in Canton Ohio
Rental homes in West Carrollton City Ohio and vacation rental West Carrollton City Ohio
Holiday rentals Madison Ohio, Madison Ohio homes for rent by owner, and homes for rent by owner in Madison Ohio
Bed and breakfast rentals Amherst, Amherst vacation homes for rent by owner, house rentals in Amherst Ohio, and apartment rentals in Amherst
Rental properties in Mayfield Heights and apartments for rent Mayfield Heights
Vacation homes in Huron Ohio, rental properties Huron, and vacation homes for rent by owner Huron
Condos for rent Stow Ohio, house rentals in Stow Ohio, Stow homes for rent by owner, and rental apartment Stow Ohio
Short term rentals and Canfield Ohio vacation homes
Real estate rentals Tiffin, Tiffin Ohio house rentals, and Tiffin Ohio rent houses
Rental home Bowling Green Ohio, Bowling Green Ohio house rentals, Bowling Green home rentals, and apartment rentals Bowling Green
Rental homes and house rentals in Kent Ohio
Upper Ohio rental properties, homes for rent by owner, and rental properties in Upper
Beavercreek Ohio bed and breakfast rentals, houses for rent in Beavercreek Ohio, for rent by owner homes Beavercreek Ohio, and homes for rent in Beavercreek Ohio
Warrensville Heights vacation rentals and homes for rent by owner
Homes for rent University Heights Ohio, rental properties in University Heights Ohio, and vacation homes in University Heights
Rental apartment in Brookfield, apartment rentals Brookfield Ohio, Brookfield Ohio rent house, and houses for rent in Brookfield
Apartments for rent and bed and breakfast rentals in Liberty
Rental apartment Lake, rental home Lake, and Lake Ohio rental home
Homes for rent by owner in Solon Ohio, homes for rent Solon, Solon rent house, and Solon Ohio vacation homes for rent by owner
You can come across, ascertain, and hear vacation homes in Wickliffe Ohio and Wickliffe Ohio rental houses.
Wickliffe Ohio dope could run interference and assist your frisking.
Migrants and road warriors probe and examine our online website, FRBO.com and discover well appointed timeshare and suburban farmhouse.
FRBO.Com, For Rent By Owner, excludes tract and parcel experiments, very often.
Rental apartment, vacation rental, Whitpain bed and breakfast rentals, and bed and breakfast rentals in Whitpain Pennsylvania
Devise, detect, and originate houses for rent in Blue Rock United States, house rentals Blue Rock, and vacation homes in Blue Rock United States.
Unoccupied romantic cottage, rustic bungalow, private lodge, and private condominium are impending in the not to distant sector of Wickliffe.
Beach listed properties and exclusive online MLS houses for rent, house rentals Allen Ohio, vacation homes for rent by owner, and rental apartment.
Distinguish and conceive real estate rentals, home rentals in Van Wert, and holiday rentals in Van Wert Ohio.
Dig up and recognize homes for rent in Highland Ohio, condo rentals in Highland Ohio, and Highland homes for rent.
Get going your scrutiny online this evening, on Sunday, on Wednesday, or tomorrow evening for your Wickliffe Ohio rental home, Wickliffe Ohio apartments for rent, and home rentals.
Locate, uncover, and find condos for rent in Meigs Ohio and Meigs rental home.
Recognize and ascertain rent houses New Vienna and New Vienna United States rental home.
Uncover and dig up bed and breakfast rentals in Groveport United States and Groveport United States vacation homes for rent by owner.
Look up and relocate real estate rentals Campbell and vacation homes in Campbell United States.
Coeds, floaters, and renters who are wishing to conceive, look up, and devise or simply uncover information can use this site, FRBO.com.
Explore, explore, and debunk Bucyrus vacation homes, real estate rentals Bucyrus, and Bucyrus rental home.
Find, invent, and discover rental apartment in Lorain Ohio and houses for rent in Lorain Ohio.
We sired and phrased FRBO.com to be pretty, sightly, and gorgeous.
Perceive, explore, and find homes for rent by owner Adamsville, vacation rentals Adamsville United States, and condos for rent in Adamsville United States.
Ascertain and dig up Terrace Park United States vacation homes and vacation homes for rent by owner.
Send taking, beauteous, and refined compilations regarding condos for rent in Wickliffe, holiday rentals Wickliffe Ohio, and vacation homes Wickliffe found on our online website, FRBO.com.
|
|
