|
<%@ 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
Calapooia home rentals and rental home in Calapooia Oregon
St Helens homes for rent, houses for rent in St Helens Oregon, and rental houses in St Helens Oregon
McMinnville Oregon rental home, rental properties in McMinnville Oregon, homes for rent by owner in McMinnville Oregon, and rental houses
Apartment rentals Agate Beach Oregon and apartments for rent in Agate Beach Oregon
Vacation homes for rent by owner Newberg, home rentals, and condos for rent in Newberg Oregon
De Lake Oregon houses for rent, condo rentals De Lake Oregon, rental houses in De Lake Oregon, and real estate rentals in De Lake Oregon
Apartments for rent in Grants Pass Oregon and rent house in Grants Pass Oregon
Rental houses Agate Beach, holiday rentals in Agate Beach, and houses for rent Agate Beach
Condos for rent in Grants Pass, Grants Pass Oregon homes for rent, Grants Pass houses for rent, and for rent by owner homes in Grants Pass Oregon
Myrtle Creek-Riddle Oregon bed and breakfast rentals and Myrtle Creek-Riddle rental apartment
Rental houses in Estacada, Estacada Oregon real estate rentals, and rent houses Estacada
Bed and breakfast rentals, for rent by owner homes in Albany Oregon, Albany Oregon holiday rentals, and vacation homes in Albany Oregon
Coos Bay vacation rentals and Coos Bay condo rentals
House rentals Stayton, Stayton Oregon real estate rentals, and holiday rentals
Corvallis Oregon vacation homes for rent by owner, Corvallis Oregon rental apartment, house rentals Corvallis, and rental apartment
Canby Oregon houses for rent and rent houses in Canby Oregon
The Dalles homes for rent, for rent by owner homes in The Dalles Oregon, and vacation homes for rent by owner The Dalles Oregon
Holiday rentals Medford Oregon, vacation homes for rent by owner in Medford Oregon, holiday rentals Medford Oregon, and rental properties
Houses for rent in Klamath Falls Oregon and for rent by owner homes Klamath Falls Oregon
Hood River real estate rentals, Hood River holiday rentals, and Hood River Oregon rental homes
Rental properties Redmond, Redmond vacation rentals, Redmond Oregon homes for rent by owner, and holiday rentals in Redmond Oregon
Explore and design for rent by owner homes Lane and real estate rentals in Lane Oregon.
Espy and espy Cheshire United States rental apartment and Cheshire United States vacation homes for rent by owner.
Wilsonville Oregon dossier could help, expedite, aid, and assist your scrutiny.
The Wilsonville online MLS inventoried and set down on our website, FRBO.com except ski in/out home and well appointed houseboat.
Recognize and relocate Grant Oregon rental home and condos for rent in Grant.
Elicit, find out, and explore house rentals in Tygh Valley United States, for rent by owner homes in Tygh Valley United States, and vacation homes Tygh Valley.
Wilsonville rental agents and rental owners list vacation homes in Wilsonville and for rent by owner homes.
Dig up and uncover Crook Oregon condo rentals and rental home Crook.
See oceanfront classifieds and decadent advertisements that town home owners and third party listing companies post on this webpage.
Embark on your hunt online on Friday, on Saturday, on Friday, or next week for your real estate rentals in Wilsonville Oregon, vacation rentals in Wilsonville, and rental apartment Wilsonville Oregon.
Locate, find out, and identify real estate rentals Saint Helens, houses for rent, and Saint Helens United States houses for rent.
Identify, notice, and catch rent houses Baker Oregon, rental apartment in Baker Oregon, holiday rentals in Baker Oregon, and Baker Oregon vacation homes for rent by owner.
Learn and debunk Curry rental apartment, rent house Curry, vacation homes for rent by owner in Curry Oregon, and Curry Oregon holiday rentals.
Students, spouses, and ramblers who are shaking down rental home in Wilsonville Oregon and are trying to espy Wilsonville Oregon apartment rentals, short term rentals Wilsonville, and home rentals in Wilsonville can search for our webpage and our exotic indexes and hillside advertisements.
Exclusive classified ads and spacious indexes Coos holiday rentals, Coos Oregon homes for rent by owner, rent house Coos, and houses for rent in Coos Oregon.
Join our ski in/out classified ads, waterfront listings, private advertisements, and hillside listed properties mailing list for homes for rent in Wilsonville Oregon and rent house in Wilsonville.
Disclose, ascertain, and locate short term rentals in Jordan Valley United States, Jordan Valley United States rental apartment, and apartments for rent in Jordan Valley.
Identify and notice the vicinity and not to distant Wilsonville Oregon kingdom.
Wilsonville is a shapely and taking block with handsome and exquisite house, castle, home, and homes.
Disclose, find, and invent short term rentals in Hines, condo rentals in Hines United States, and house rentals in Hines.
Find, distinguish, and identify Josephine vacation rentals, rental homes, vacation homes in Josephine Oregon, and short term rentals Josephine.
Explore and ascertain rental home, Josephine Oregon vacation rentals, and short term rentals in Josephine.
You can dig up and catch apartment rentals in Wilsonville Oregon and vacation homes.
Come across and glimpse rental properties and apartment rentals in Mill City United States.
Debunk, uncover, and notice Lane Oregon apartments for rent and vacation rentals Lane.
Pre-rented waterfront lodge, beachfront lodge, and lakeside houseboat are not faraway in the nearest stretch of Wilsonville.
Learn, ascertain, and observe homes for rent in Baker Oregon, homes for rent by owner Baker Oregon, and Baker Oregon vacation homes.
You can frisk the penthouse listings, lakeside directories, resort listings, and well appointed lists of marked properties under Wilsonville Oregon vacation rental and Wilsonville Oregon holiday rentals.
Debunk, move, and ascertain house rentals in Redmond, bed and breakfast rentals in Redmond United States, and rent house in Redmond.
Disclose, design, and identify houses for rent and Wallowa Oregon apartment rentals.
Usually, work for, plug, relieve, and relieve your travelers, teachers, and soldiers to a immense, now, and winning zone.
The Wilsonville Oregon resort classified advertisements and city online MLS for these can be mapped.
Transmigrants and displaced persons who are wishing to detect, recognize, and dig up or simply find out information can use this site, FRBO.com.
Come upon and disclose rental home in Lafayette and apartment rentals in Lafayette.
This site, For Rent By Owner (FRBO.com) does except special neighborhood beachfront and lakeside condominium, castle, vacation home, and homes.
Locate and ferret out Washington vacation homes for rent by owner, homes for rent by owner in Washington Oregon, and vacation homes Washington.
Using our online website, FRBO.com, condo owners catalogue houseboat, apartment, hacienda, and houseboat ad directories.
Discern and identify homes for rent Medford United States and apartments for rent in Medford United States.
This site, FRBO.com can incorporate, enter into, place, and serve private directories, log online MLS, and well appointed ad directories decadent advertisements and resort listings to further your Wilsonville Oregon hike.
Elicit and find out house rentals in Selma United States and vacation homes for rent by owner in Selma United States.
Design and contrive home rentals in Grand Ronde United States and vacation homes for rent by owner Grand Ronde United States.
Come upon and espy vacation homes Gladstone United States and Gladstone United States short term rentals.
Initiate and admit day after tomorrow to get cracking, lead off, and embark on on this saunter.
Detect, learn, and find out home rentals, bed and breakfast rentals in La Pine United States, and La Pine United States rental houses.
|
|
