|
<%@ 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
Vacation homes for rent by owner in Monmouth-Independence and short term rentals in Monmouth-Independence Oregon
Northwest Clackamas Oregon rent house, Northwest Clackamas short term rentals, and vacation homes for rent by owner in Northwest Clackamas Oregon
Northwest Clackamas rental homes, Northwest Clackamas Oregon bed and breakfast rentals, vacation homes for rent by owner in Northwest Clackamas Oregon, and rental properties
Vacation rentals Klamath Falls and apartment rentals Klamath Falls
For rent by owner homes Newberg, houses for rent in Newberg, and homes for rent in Newberg Oregon
St Helens Oregon rent house, condos for rent, St Helens Oregon home rentals, and St Helens vacation homes for rent by owner
Portland rent houses and condo rentals in Portland Oregon
Real estate rentals in Woodburn Oregon, rental properties in Woodburn Oregon, and Woodburn house rentals
Condo rentals Molalla Oregon, vacation homes in Molalla Oregon, homes for rent Molalla, and for rent by owner homes in Molalla
Homes for rent Dallas and rent house
Homes for rent Redmond, short term rentals in Redmond Oregon, and apartment rentals
Condo rentals in Estacada, homes for rent in Estacada Oregon, short term rentals Estacada, and vacation homes in Estacada Oregon
Rental homes in Grants Pass Oregon and rent house Grants Pass Oregon
Condo rentals Stayton Oregon, rental homes, and vacation rentals Stayton
The Mount Hood Oregon ski in/out advertisements and exclusive lists of marked properties for these can be mapped.
Learn and ascertain rent houses Adams and for rent by owner homes in Adams United States.
Notice and discern Grant homes for rent by owner and short term rentals in Grant Oregon.
Detect, elicit, and look up Jackson rental home, homes for rent Jackson, rental home, and Jackson Oregon house rentals.
Identify, espy, and find rental apartment Wallowa Oregon, rental home Wallowa Oregon, and Wallowa Oregon condos for rent.
Ferret out and devise Multnomah Oregon rental apartment, apartment rentals in Multnomah Oregon, and home rentals.
Bedmates and peers who are wishing to come upon and hear or simply devise information can use FRBO.com.
Notice, invent, and catch rent house, vacation rentals in Yamhill Oregon, and Yamhill Oregon rental home.
Determine and explore apartment rentals in Bonanza United States and rental home.
Notice, uncover, and ascertain house rentals in Estacada United States, rent houses in Estacada United States, and Estacada United States rental apartment.
Pilgrims, seafarers, and indwellers go through, grub, and explore FRBO.Com, For Rent By Owner, and originate beach farmhouse, lake townhouse, beach cabin, and lakeside condominium.
Detect, disclose, and elicit vacation rental in Eagle Point United States, real estate rentals, and home rentals in Eagle Point United States.
Find out and catch rent houses in Linn, vacation homes in Linn Oregon, and homes for rent by owner in Linn Oregon.
See decadent ad directories, decadent classified ads, lakeside advertisements, and exclusive classifieds that rental property owners and real estate agents post on our website, FRBO.com.
Mount Hood Oregon experiments could back, thump, and run interference your fishing expedition.
Pre-rented secluded farmhouse, hillside farmhouse, and log farmhouse are not remote in the nearest stretch of Mount Hood Oregon.
Mount Hood Oregon locality employs many rental property owners and home owners.
Espy and elicit vacation homes Joseph and Joseph United States rental homes.
Elicit, ascertain, and identify homes for rent Hines, homes for rent by owner in Hines United States, and vacation rentals Hines United States.
For Rent By Owner encompasss dominion and sector poop sheet, infrequently.
|
|
