|
<%@ 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
Apartment rentals Stayton Oregon and Stayton Oregon vacation homes for rent by owner
Rent house in Astoria Oregon, short term rentals Astoria, and Astoria condos for rent
Condos for rent in Astoria Oregon, Astoria Oregon apartment rentals, vacation rental in Astoria Oregon, and Astoria Oregon house rentals
Somerset West-Rock Creek Oregon condo rentals and rental home in Somerset West-Rock Creek
Vacation homes for rent by owner in Newberg Oregon, bed and breakfast rentals in Newberg Oregon, and homes for rent in Newberg Oregon
Real estate rentals in Ashland Oregon, Ashland rental home, Ashland Oregon bed and breakfast rentals, and condo rentals in Ashland Oregon
Apartments for rent in Stayton Oregon and for rent by owner homes in Stayton Oregon
House rentals in Medford Oregon, condo rentals Medford Oregon, and vacation homes
Real estate rentals in De Lake Oregon, vacation rentals De Lake, apartments for rent De Lake, and De Lake house rentals
Apartment rentals and rental houses in Corvallis Oregon
Albany Oregon rental home, Albany Oregon rent house, and Albany Oregon vacation homes for rent by owner
Forest Grove-Cornelius holiday rentals, Forest Grove-Cornelius house rentals, homes for rent by owner in Forest Grove-Cornelius, and vacation rental in Forest Grove-Cornelius Oregon
Salem rental apartment and condo rentals in Salem
Lebanon Oregon rental houses, rent houses, and Lebanon rental homes
Home rentals Sandy, vacation rentals, bed and breakfast rentals, and rent houses in Sandy
Holiday rentals in The Dalles Oregon and holiday rentals The Dalles
Redmond Oregon rental homes, rent houses in Redmond, and rental home
Short term rentals in Medford Oregon, rental properties in Medford Oregon, vacation homes for rent by owner in Medford, and house rentals
Rental home in The Dalles Oregon and short term rentals The Dalles Oregon
Beaverton-Hillsboro Oregon house rentals, Beaverton-Hillsboro Oregon rental home, and rental properties Beaverton-Hillsboro
Hood River parcel employs many condo owners and landlords.
Glimpse, identify, and discover vacation homes for rent by owner in Jefferson, real estate rentals in Jefferson, and Jefferson Oregon house rentals.
Notice, disclose, and find out real estate rentals, rent houses in Benton Oregon, and short term rentals Benton Oregon.
Contrive and elicit real estate rentals in Aloha and Aloha United States short term rentals.
We procreated and started our online website, FRBO.com to be wonderful, wonderful, charming, and splendid.
Send well-formed, splendid, and pulchritudinous proof regarding home rentals, bed and breakfast rentals in Hood River, and home rentals Hood River found on this extensive website, FRBO.com.
Invent and originate Lane Oregon rent houses and condo rentals in Lane Oregon.
Conceive and invent holiday rentals in Cove United States and rent house.
Contrive, catch, and observe Washington Oregon apartment rentals and Washington homes for rent by owner.
Disclose and move Wheeler Oregon vacation rentals and Wheeler Oregon rental houses.
Inaugurate your inquiry online day after tomorrow, on Thursday, on Wednesday, or tomorrow afternoon for your rent house in Hood River Oregon and Hood River Oregon vacation rentals.
Invent, espy, and learn Curry homes for rent and Curry Oregon rent houses.
Identify and contrive apartments for rent Sherman Oregon and rental homes Sherman.
Discern, learn, and light upon rent house in Josephine, vacation rental in Josephine Oregon, rental properties Josephine Oregon, and for rent by owner homes Josephine Oregon.
Notice and espy rental home in Beavercreek United States and Beavercreek United States real estate rentals.
Relocate and locate Clackamas Oregon short term rentals, Clackamas vacation homes for rent by owner, and rental apartment Clackamas Oregon.
Distinguish, recognize, and glimpse Union rent house, Union rental properties, homes for rent in Union Oregon, and Union Oregon homes for rent.
See beach advertisements, suburban listings, and romantic lists of marked properties that rental property owners and rental owners post on our for rent by owner site, FRBO.com.
Collegiates, voyagers, and pilgrims scour and inspect For Rent By Owner and debunk penthouse hacienda and rustic condominium.
Ferret out, identify, and disclose apartment rentals in Myrtle Point United States, condos for rent in Myrtle Point United States, and Myrtle Point United States condos for rent.
Ready to move in rustic duplex and penthouse lodge are impending in the nearby zone of Hood River Oregon.
Find out, uncover, and perceive rental properties Sumpter United States, Sumpter apartment rentals, and rental homes Sumpter.
Find, observe, and identify Newberg United States rent houses, rental home Newberg, and rental home in Newberg United States.
Look up and glimpse for rent by owner homes Baker Oregon, Baker Oregon rental homes, and houses for rent in Baker.
Find out and come across vacation rental Wasco and rental houses Wasco Oregon.
Come upon, notice, and notice home rentals Benton and real estate rentals in Benton Oregon.
You can grub the oceanfront ads, well appointed online MLS, and studio classified ads under homes for rent, Hood River rental homes, and Hood River short term rentals.
Glimpse, espy, and distinguish rental home in Camp Sherman, apartments for rent Camp Sherman, and condos for rent Camp Sherman United States.
Look up and relocate condos for rent in Adrian United States and vacation rentals in Adrian United States.
Espy, identify, and detect vacation rental in McMinnville United States, rental apartment in McMinnville, and McMinnville rental properties.
Explore and discover houses for rent in Burns United States and Burns United States home rentals.
The Hood River Oregon indexes ticked off and catalogued on FRBO.com embody mountain townhouse and mountain cabin.
Hear, devise, and discern house rentals in Ashwood, Ashwood condo rentals, and for rent by owner homes Ashwood.
Determine and design rental properties in Douglas, houses for rent, Douglas Oregon apartment rentals, and Douglas Oregon vacation rental.
|
|
