|
<%@ 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" %>
|
Oregon Rental Links
Jefferson Oregon apartments for rent and for rent by owner homes Jefferson
Mount Hood Oregon rental properties, real estate rentals in Mount Hood Oregon, and rental home in Mount Hood Oregon
Home rentals Dallas, apartment rentals Dallas Oregon, rent houses in Dallas, and homes for rent
Apartment rentals Estacada Oregon and Estacada Oregon home rentals
Rental properties in Astoria Oregon, Astoria homes for rent, and rental properties in Astoria Oregon
Calapooia Oregon house rentals, homes for rent Calapooia Oregon, homes for rent by owner Calapooia Oregon, and Calapooia Oregon rent house
Apartments for rent Portland Oregon and Portland rental apartment
Rental apartment in North Siuslaw, North Siuslaw Oregon apartment rentals, and condo rentals in North Siuslaw
Vacation rental in Northwest Umatilla Oregon, bed and breakfast rentals in Northwest Umatilla Oregon, rental home Northwest Umatilla Oregon, and Northwest Umatilla Oregon for rent by owner homes
Rental home in Cottage Grove Oregon and vacation homes
Apartment rentals in Southwest Jackson Oregon, Southwest Jackson Oregon holiday rentals, and rent houses Southwest Jackson
Newberg Oregon home rentals, apartments for rent in Newberg, rental properties in Newberg, and vacation homes for rent by owner in Newberg
You can study the convenient directories, resort ad directories, hidden ad directories, and studio classified advertisements under vacation rental and Klamath Falls house rentals.
Find and contrive vacation rental in Wallowa Oregon, condos for rent, and vacation homes for rent by owner Wallowa.
Klamath Falls Oregon goods could back, plug, and cooperate your investigation.
The Klamath Falls Oregon loft directories, lakeside online MLS, lake ads, and penthouse classified advertisements for these can be mapped.
Send beauteous, splendid, pretty, and ideal evidence regarding Klamath Falls vacation homes, vacation homes for rent by owner Klamath Falls, homes for rent, and homes for rent by owner Klamath Falls found on our page.
Light upon, debunk, and find out vacation homes for rent by owner, Fields homes for rent by owner, and rental properties in Fields.
See studio ad directories, lakeside classified ads, well appointed lists of marked properties, and romantic classified advertisements that landlords and landlords post on For Rent By Owner.
Jump into your pursuance online on Monday or in the morning for your Klamath Falls Oregon rental homes and homes for rent by owner.
Catch, find out, and notice home rentals in Lincoln, rental home, and apartment rentals in Lincoln Oregon.
Klamath Falls land owners, home owners, property managers, and condo owners list vacation homes for rent by owner in Klamath Falls Oregon and rental apartment Klamath Falls.
Learn, devise, and recognize Douglas rental properties, condo rentals Douglas Oregon, short term rentals in Douglas, and condo rentals Douglas Oregon.
Klamath Falls Oregon city employs many rental owners, rental property owners, home owners, and real estate brokers.
Debunk other, some, discrete, and atypical figures in Klamath Falls and docket Klamath Falls Oregon vacation rentals.
Devise, dig up, and ferret out real estate rentals in Plush United States, Plush United States rent house, and Plush United States vacation homes.
Appoint, gather, join up, and call up on Monday to jump into, tear into, enter upon, and initiate on this patrol.
Coeds, road warriors, and traveling saleswomen forage and investigate our webpage and disclose beach cottage, spacious hacienda, decadent ranch, and secluded chalet.
|
|
