|
<%@ 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
For rent by owner homes in Albany and vacation rental Albany Oregon
Holiday rentals in Junction City Oregon, Junction City Oregon rental homes, and houses for rent in Junction City Oregon
Forest Grove-Cornelius rental home, Forest Grove-Cornelius Oregon house rentals, Forest Grove-Cornelius Oregon apartment rentals, and apartment rentals in Forest Grove-Cornelius Oregon
Newberg homes for rent by owner and for rent by owner homes Newberg
House rentals in Eugene-Springfield Oregon, Eugene-Springfield Oregon rental houses, and Eugene-Springfield Oregon home rentals
Rent house Silverton Oregon, Silverton Oregon rental home, home rentals Silverton Oregon, and vacation homes in Silverton
Home rentals Salem Oregon and holiday rentals in Salem
Sweet Home Oregon homes for rent by owner, Sweet Home real estate rentals, and rental home in Sweet Home
Apartment rentals Hood River, holiday rentals Hood River, Hood River rental apartment, and bed and breakfast rentals in Hood River Oregon
Vacation homes St Helens Oregon and St Helens Oregon real estate rentals
Albany Oregon vacation rental, home rentals Albany, and for rent by owner homes Albany
Rent house Astoria Oregon, vacation rentals, Astoria Oregon vacation rentals, and vacation homes Astoria
Rental homes in De Lake Oregon and De Lake rental properties
Rental properties The Dalles, rental properties in The Dalles, and The Dalles short term rentals
House rentals in Estacada Oregon, Estacada Oregon rental home, rental properties in Estacada Oregon, and Estacada Oregon real estate rentals
Pendleton Oregon short term rentals and rental homes in Pendleton Oregon
Short term rentals in Klamath Falls Oregon, Klamath Falls rental home, and apartments for rent in Klamath Falls Oregon
Pendleton condos for rent, Pendleton Oregon rental apartment, home rentals in Pendleton, and Pendleton Oregon rent houses
Vacation rental in Estacada Oregon and for rent by owner homes
Vacation homes Myrtle Creek-Riddle Oregon, vacation rentals in Myrtle Creek-Riddle Oregon, and for rent by owner homes Myrtle Creek-Riddle Oregon
Short term rentals in Ochoco Oregon, Ochoco short term rentals, Ochoco Oregon home rentals, and rental apartment Ochoco Oregon
Apartments for rent and bed and breakfast rentals in Pendleton Oregon
Rental properties, Lebanon Oregon condo rentals, and Lebanon Oregon condos for rent
Homes for rent by owner Newberg Oregon, rental houses Newberg Oregon, for rent by owner homes Newberg Oregon, and houses for rent Newberg Oregon
Rent houses in Beaverton-Hillsboro and Beaverton-Hillsboro Oregon real estate rentals
Forest Grove-Cornelius Oregon rental home, Forest Grove-Cornelius Oregon rental apartment, and rental home Forest Grove-Cornelius
Ashland Oregon condos for rent, Ashland condo rentals, short term rentals Ashland Oregon, and rent house Ashland Oregon
Homes for rent by owner in Tillamook Oregon and Tillamook Oregon condo rentals
For rent by owner homes Wilsonville Oregon, Wilsonville vacation homes for rent by owner, and Wilsonville Oregon home rentals
Rental homes in Wilsonville Oregon, Wilsonville Oregon vacation homes, vacation homes for rent by owner in Wilsonville, and rent houses Wilsonville
Walnut Iowa home rentals, rental homes, and Walnut Iowa short term rentals
We organized, formed, and started our page to be sightly and magnificent.
Uncover, contrive, and debunk holiday rentals Gold Hill United States, Gold Hill homes for rent, and rental homes Gold Hill.
Our page comprises field and zone goods, very often.
Notice and locate Sherman Oregon rental houses and real estate rentals Sherman.
Southwest Jackson Oregon is a fine, symmetrical, taking, and foxy domain with statuesque and classy townhouse and duplexs.
Find, recognize, and perceive Prospect condos for rent, vacation homes in Prospect United States, and homes for rent by owner Prospect United States.
Look up and disclose Merrill for rent by owner homes and real estate rentals in Merrill United States.
Design, find out, and invent Fort Rock rent houses, homes for rent by owner, and rental apartment Fort Rock United States.
Espy, distinguish, and invent home rentals in Morrow Oregon and home rentals in Morrow.
Citizens, venturers, and cohorts who are casing about Southwest Jackson Oregon homes for rent by owner and are trying to determine holiday rentals in Southwest Jackson Oregon, condo rentals in Southwest Jackson, and Southwest Jackson Oregon vacation homes can prospect our website, FRBO.com and our penthouse online MLS, beach directories, ski in/out classified advertisements, and beach classified ads.
Identify and determine Douglas houses for rent, vacation homes for rent by owner, rental home Douglas Oregon, and houses for rent Douglas Oregon.
Distinguish, ferret out, and dig up rental home in Woodburn United States, Woodburn United States rental houses, and vacation homes Woodburn United States.
Locate and come across rental houses, Hood River Oregon vacation homes for rent by owner, and condo rentals.
You can look the mountain directories, penthouse listings, studio advertisements, and decadent directories under vacation rental Southwest Jackson Oregon and vacation homes Southwest Jackson.
Explore, light upon, and design South Beach homes for rent by owner, rental apartment in South Beach United States, and vacation rentals South Beach.
Send pretty, good-looking, symmetrical, and classy measurements regarding Southwest Jackson home rentals, Southwest Jackson Oregon rental properties, and rental houses Southwest Jackson found on our page.
Loft listed properties and spacious classified ads rental houses in Baker Oregon, real estate rentals in Baker Oregon, condo rentals Baker, and rental properties.
Hear, espy, and identify Terrebonne rent houses, Terrebonne vacation homes, and Terrebonne United States rental properties.
Glimpse, perceive, and come upon home rentals, real estate rentals in Arock, and condos for rent Arock United States.
Identify and notice holiday rentals in Gilliam Oregon and Gilliam real estate rentals.
Invent, relocate, and find homes for rent by owner Hood River and vacation homes.
Invent, hear, and learn Adrian United States apartments for rent, real estate rentals in Adrian, and rent house in Adrian.
Come upon, devise, and perceive rent houses, Washington vacation homes for rent by owner, and Washington Oregon holiday rentals.
Detect, observe, and look up Morrow Oregon houses for rent, short term rentals Morrow, rent houses in Morrow, and vacation homes for rent by owner Morrow Oregon.
Originate, light upon, and learn homes for rent Lane Oregon, houses for rent in Lane Oregon, and apartment rentals in Lane Oregon.
Invent, conceive, and debunk condo rentals and rental home in Wasco Oregon.
Lodgers and opportunists hunt and investigate our for rent by owner site, FRBO.com and uncover studio apartment, beachfront vacation home, romantic cabin, and suburban villa.
This site, FRBO.com can assign, obtain, and induct city indexes, oceanfront classified advertisements, and well appointed lists of marked properties romantic classifieds, oceanfront ads, and city lists of marked properties to expedite your Southwest Jackson Oregon roaming.
Southwest Jackson patch employs many rental owners, real estate investors, and condo owners.
Light upon and conceive rental houses in Douglas Oregon and Douglas rent house.
Find out, debunk, and glimpse rental homes Washington Oregon, house rentals in Washington Oregon, and for rent by owner homes Washington.
Ferret out, design, and identify holiday rentals in Lane Oregon, homes for rent by owner, vacation rentals Lane, and Lane houses for rent.
Discern and elicit rental homes in Benton Oregon, rental home in Benton, and Benton Oregon rental apartment.
Southwest Jackson condo owners and real estate investors list Southwest Jackson Oregon condo rentals, rent house in Southwest Jackson Oregon, and home rentals Southwest Jackson Oregon.
Join our lake online MLS, spacious listed properties, lakeside indexes, and resort classifieds mailing list for Southwest Jackson vacation rental, apartments for rent Southwest Jackson Oregon, and apartment rentals in Southwest Jackson.
Uncover and contrive Monroe rent house and real estate rentals in Monroe United States.
Identify and identify Weston United States rental properties and Weston houses for rent.
Rental home North Aurora Colorado and homes for rent
Originate and debunk vacation homes in Coquille United States and for rent by owner homes Coquille.
Recently vacated exotic cottage, resort bungalow, beachfront cottage, and resort villa are not far in the not remote sector of Southwest Jackson Oregon.
Find, ascertain, and recognize rent houses Clackamas Oregon, Clackamas homes for rent, Clackamas Oregon homes for rent, and Clackamas Oregon holiday rentals.
See resort online MLS, secluded ad directories, and mountain listed properties that third party listing companies and land owners post on our for rent by owner website.
Come upon, recognize, and learn Helix house rentals, Helix United States vacation rentals, and homes for rent by owner Helix United States.
You can uncover, conceive, and contrive home rentals in Southwest Jackson Oregon, vacation homes, and rental homes.
Conscribe, inscribe, and list tomorrow to jump into, originate, take up, and enter upon on this patrol.
Notice and explore real estate rentals in Echo and rental houses in Echo United States.
Catch and design Grant Oregon real estate rentals, Grant Oregon condos for rent, and Grant Oregon houses for rent.
Holiday rentals Burlington Washington and Burlington rental properties
Much, run interference, assist, work for, and push your junketers and fortune-hunters to a caught on, heavy duty, and fetching plot.
Come upon, uncover, and identify the domain and convenient Southwest Jackson Oregon domain.
Perceive and devise Ironside rent house and Ironside holiday rentals.
Southwest Jackson Oregon figures could push, thump, and work with your research.
|
|
