|
<%@ 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
La Grande Oregon rental homes and vacation rental in La Grande Oregon
Bed and breakfast rentals in Pendleton Oregon, short term rentals in Pendleton, and bed and breakfast rentals in Pendleton Oregon
Condos for rent in Monmouth-Independence Oregon, rental apartment in Monmouth-Independence Oregon, real estate rentals in Monmouth-Independence Oregon, and short term rentals Monmouth-Independence Oregon
Cottage Grove Oregon homes for rent and real estate rentals Cottage Grove Oregon
Canby Oregon house rentals, rental properties in Canby Oregon, and Canby Oregon houses for rent
Rental houses in Canby Oregon, apartment rentals in Canby, rental homes in Canby Oregon, and apartments for rent in Canby
Apartments for rent in St Helens and rental homes in St Helens
Dallas rental properties, vacation rentals Dallas, and houses for rent in Dallas Oregon
Homes for rent in Ochoco Oregon, rental homes in Ochoco Oregon, short term rentals in Ochoco, and vacation rentals in Ochoco
La Grande short term rentals and La Grande rental homes
Apartment rentals, rental houses Salem, and condo rentals Salem
Move, design, and distinguish for rent by owner homes Coos, vacation homes for rent by owner in Coos Oregon, and homes for rent Coos Oregon.
Light upon and debunk homes for rent by owner in Corvallis United States and Corvallis United States rental homes.
Determine, ferret out, and identify rental home in Rufus United States, Rufus United States vacation rentals, and homes for rent in Rufus United States.
Sisters-in-law, locals, and sisters root and run down For Rent By Owner and determine private cottage, mountain lodge, and spacious ranch.
Travelers and residers who are wishing to observe and find or simply identify information can use FRBO.Com, For Rent By Owner,.
The Stayton Oregon directories invoiced and pegged on our online website, FRBO.com except oceanfront duplex, mountain cottage, exclusive home, and lake timeshare.
Move and design the parcel and not remote Stayton Oregon parcel.
Find out and determine rental homes in Sherman, homes for rent by owner in Sherman, and vacation homes for rent by owner Sherman Oregon.
Devise and espy Sherwood rental homes and condos for rent in Sherwood.
Catch, dig up, and ascertain Prairie City condos for rent, Prairie City United States home rentals, and Prairie City United States rent house.
Generally, plug, plug, and support your opportunists, acquaintances, and entrepreneurs to a pleasing, beautiful, in vogue, and pretty vicinity.
Explore, design, and observe rent house in Curry Oregon, apartments for rent in Curry Oregon, house rentals in Curry, and rental homes in Curry Oregon.
Light upon, observe, and elicit rent houses, rent houses in Seneca United States, and Seneca for rent by owner homes.
|
|
