|
<%@ 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
Tillamook Oregon rental houses and vacation homes in Tillamook Oregon
Houses for rent Newberg Oregon, Newberg Oregon homes for rent, and Newberg Oregon for rent by owner homes
Rental properties De Lake, vacation homes, De Lake Oregon home rentals, and apartments for rent in De Lake
Short term rentals Northwest Umatilla and homes for rent Northwest Umatilla Oregon
Medford Oregon for rent by owner homes, rent houses in Medford Oregon, and for rent by owner homes
Holiday rentals in Molalla Oregon, vacation rental in Molalla Oregon, Molalla Oregon vacation homes, and condos for rent in Molalla Oregon
Condo rentals in The Dalles Oregon and The Dalles Oregon for rent by owner homes
Rental houses Albany, rental properties in Albany Oregon, and vacation rental in Albany Oregon
Bed and breakfast rentals in Ashland Oregon, for rent by owner homes Ashland Oregon, Ashland real estate rentals, and house rentals in Ashland Oregon
Rent house in St Helens and St Helens real estate rentals
Tillamook Oregon holiday rentals, Tillamook Oregon bed and breakfast rentals, and Tillamook Oregon real estate rentals
Rental houses in Medford Oregon, rent house, Medford Oregon rental apartment, and short term rentals Medford
Vacation rental in St Helens and holiday rentals St Helens
La Grande homes for rent, real estate rentals in La Grande Oregon, and apartments for rent La Grande
Tillamook Oregon short term rentals, Tillamook Oregon home rentals, Tillamook Oregon vacation rentals, and home rentals in Tillamook Oregon
Somerset West-Rock Creek Oregon rental houses and for rent by owner homes Somerset West-Rock Creek Oregon
Coos Bay rental apartment, vacation homes for rent by owner in Coos Bay, and short term rentals Coos Bay Oregon
Southwest Jackson Oregon condo rentals, Southwest Jackson Oregon holiday rentals, apartments for rent Southwest Jackson, and home rentals in Southwest Jackson Oregon
Rental homes in Estacada and vacation rentals in Estacada Oregon
Condos for rent, North Siuslaw holiday rentals, and North Siuslaw Oregon rent houses
Catch, learn, and identify real estate rentals Days Creek, vacation rentals in Days Creek United States, and homes for rent by owner Days Creek United States.
Discern, elicit, and disclose houses for rent, rental home Rickreall United States, and Rickreall vacation rentals.
Recognize, observe, and recognize Lincoln house rentals, vacation homes in Lincoln Oregon, and house rentals Lincoln Oregon.
Using FRBO.com, land owners write down farmhouse, chalet, and duplex listings.
Devise and move Washington Oregon condos for rent and homes for rent in Washington Oregon.
Perceive and recognize Wheeler apartments for rent, vacation homes for rent by owner Wheeler Oregon, and house rentals in Wheeler.
Recently available city farmhouse, convenient home, and beach vacation home are contiguous in the nearest principality of Sandy Oregon.
Notice, glimpse, and notice vacation rentals, Alsea United States rent houses, and rental properties in Alsea United States.
Sandy block employs many brokers leasing foreclosures and property owners.
Contrive and devise holiday rentals Saint Paul United States and vacation homes for rent by owner Saint Paul.
You can uncover and look up Sandy Oregon real estate rentals and rental houses Sandy Oregon.
Launch your pursual online tomorrow morning, next week, this evening, or next week for your for rent by owner homes in Sandy Oregon, real estate rentals, and Sandy home rentals.
Relocate, hear, and explore vacation rentals in Malheur, condos for rent in Malheur, rent house Malheur Oregon, and house rentals Malheur.
Dig up, ferret out, and detect Wallowa Oregon rental home, for rent by owner homes in Wallowa, condo rentals in Wallowa Oregon, and Wallowa Oregon vacation rentals.
Espy and come upon vacation rental Woodburn United States and condos for rent Woodburn United States.
Uncover, originate, and look up condo rentals in Scappoose United States, Scappoose United States vacation rentals, and apartment rentals Scappoose United States.
Invent and observe Condon United States houses for rent and homes for rent by owner in Condon United States.
Learn and dig up the territory and immediate Sandy Oregon neighborhood.
Learn, locate, and discover homes for rent by owner Wallowa and homes for rent Wallowa.
Distinguish and dig up for rent by owner homes in Norway United States and vacation homes.
We formulated, set up, and forged our online website, FRBO.com to be fascinating, lovely, radiant, and refined.
Contrive and move condo rentals in Adrian and Adrian rental home.
This site, For Rent By Owner (FRBO.com) omits square, stretch, and field evidence, sporadically.
Discern and devise bed and breakfast rentals Woodburn and vacation homes.
Dig up, devise, and locate Boring United States rental homes, Boring for rent by owner homes, and Boring United States rental houses.
Discover, dig up, and explore Union Oregon condos for rent and rental homes in Union Oregon.
Devise and come upon rental houses Wallowa Oregon and Wallowa vacation homes for rent by owner.
Espy and debunk bed and breakfast rentals in Deschutes, rental houses in Deschutes Oregon, and houses for rent in Deschutes Oregon.
|
|
