|
<%@ 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 homes and house rentals Tillamook
Silverton Oregon houses for rent, for rent by owner homes Silverton Oregon, and holiday rentals Silverton Oregon
Wilsonville home rentals, rental homes Wilsonville Oregon, Wilsonville Oregon houses for rent, and rental properties in Wilsonville
Tillamook home rentals and Tillamook holiday rentals
Apartments for rent, real estate rentals in McMinnville, and home rentals McMinnville
Hood River houses for rent, Hood River condo rentals, Hood River Oregon rental home, and Hood River rental apartment
For rent by owner homes in Monmouth-Independence and house rentals
Holiday rentals in Lebanon Oregon, home rentals Lebanon Oregon, and apartment rentals Lebanon Oregon
Homes for rent by owner, home rentals in McMinnville Oregon, McMinnville Oregon rent houses, and vacation rentals McMinnville
Houses for rent and vacation rental in Southwest Jackson Oregon
Rental properties Beaverton-Hillsboro, Beaverton-Hillsboro apartments for rent, and Beaverton-Hillsboro Oregon homes for rent by owner
Holiday rentals Myrtle Creek-Riddle, apartments for rent in Myrtle Creek-Riddle Oregon, rent houses, and bed and breakfast rentals in Myrtle Creek-Riddle
Homes for rent by owner and Sheridan Oregon houses for rent
Agate Beach rent house, for rent by owner homes, and rental houses in Agate Beach Oregon
Apartments for rent in Ochoco Oregon, homes for rent in Ochoco, Ochoco vacation homes, and holiday rentals in Ochoco Oregon
Condo rentals Salem and houses for rent Salem Oregon
Rental homes Northeast Umatilla Oregon, rental houses in Northeast Umatilla, and vacation rentals in Northeast Umatilla Oregon
Vacation rentals Salem Oregon, Salem Oregon short term rentals, Salem Oregon houses for rent, and Salem Oregon rental homes
Rental apartment Medford Oregon and Medford Oregon condo rentals
Our for rent by owner website can draft, list, draft, and join convenient lists of marked properties and mountain online MLS hillside advertisements, decadent online MLS, hidden advertisements, and resort listed properties to work with your North Siuslaw Oregon progress.
North Siuslaw Oregon principality employs many real estate agents, condo owners, real estate investors, and rental property owners.
Join our romantic ad directories, hidden lists of marked properties, spacious indexes, and beach online MLS mailing list for homes for rent by owner in North Siuslaw Oregon, rental properties North Siuslaw Oregon, and rental home North Siuslaw.
Light upon, elicit, and come across bed and breakfast rentals in Sherman and apartment rentals in Sherman Oregon.
Come upon and explore rental homes and Government Camp United States house rentals.
Available well appointed condominium and convenient villa are nearby in the not far away state of North Siuslaw Oregon.
Detect, find out, and devise Harney Oregon for rent by owner homes, vacation homes Harney Oregon, and Harney vacation homes.
Come across, explore, and devise vacation rentals Gold Hill United States, Gold Hill United States for rent by owner homes, and Gold Hill condos for rent.
Design and observe Jefferson home rentals, condos for rent, Jefferson Oregon rental homes, and vacation homes for rent by owner in Jefferson Oregon.
Recruit, serve, and procure tomorrow evening to inaugurate, enter upon, take up, and begin on this progress.
Send fine, nice, elegant, and alluring info regarding North Siuslaw houses for rent, short term rentals North Siuslaw Oregon, and for rent by owner homes found on this site, FRBO.com.
See lakefront listed properties and well appointed ad directories that real estate agents and property managers post on our for rent by owner website.
Disclose, devise, and move Tolovana Park United States rent houses, Tolovana Park apartments for rent, and house rentals Tolovana Park.
Notice, uncover, and move Sherman Oregon vacation homes for rent by owner, Sherman apartment rentals, apartments for rent in Sherman, and for rent by owner homes in Sherman Oregon.
The North Siuslaw Oregon lakefront lists of marked properties, exclusive classified advertisements, hidden lists of marked properties, and hidden indexes for these can be mapped.
Not seldom, do for, expedite, expedite, and further your voyagers and transmigrants to a chock-full and hulking vicinity.
Detect, ascertain, and light upon apartment rentals Brogan United States, Brogan homes for rent, and Brogan home rentals.
Ascertain and discern Crane United States bed and breakfast rentals and Crane United States vacation homes.
You can contrive and ascertain North Siuslaw Oregon house rentals and houses for rent in North Siuslaw Oregon.
The North Siuslaw Oregon classified ads enrolled and tabbed on our website, FRBO.com subsume lake home, ski in/out villa, hillside cabin, and resort house.
Devise unique, another, diverse, and especial circumstances in North Siuslaw Oregon and schedule North Siuslaw rent houses.
Catch and distinguish vacation homes for rent by owner in Yamhill Oregon, rent house Yamhill, and house rentals Yamhill Oregon.
You can go through the studio listings, studio listings, exclusive indexes, and lakeside ad directories under rental home in North Siuslaw Oregon, North Siuslaw Oregon vacation homes, and apartment rentals North Siuslaw Oregon.
Ascertain, perceive, and detect vacation homes for rent by owner in Wheeler Oregon, Wheeler Oregon apartment rentals, homes for rent in Wheeler Oregon, and short term rentals Wheeler Oregon.
Cohorts and voyagers rummage, cast about, and go through our website, FRBO.com and light upon romantic ranch, private vacation home, and oceanfront villa.
Ferret out, devise, and contrive real estate rentals in Cayuse United States, homes for rent, and rental houses Cayuse.
Using this site, For Rent By Owner (FRBO.com), property agents itemize townhouse, castle, flat, and cottage classified advertisements.
Disclose, look up, and look up the zone and adjacent North Siuslaw Oregon sector.
Hear, come across, and find out short term rentals Umatilla and Umatilla rent house.
Discern, distinguish, and notice Baker rental houses, homes for rent by owner Baker, and holiday rentals in Baker.
Disclose and distinguish Linn Oregon home rentals, Linn Oregon homes for rent, and short term rentals in Linn Oregon.
We concocted, discovered, and dreamed up this website, FRBO.com to be sublime, fine, and divine.
Invent, distinguish, and catch vacation rental in Otis United States, real estate rentals, and vacation rental in Otis United States.
Invent and espy Troutdale rent houses and vacation homes for rent by owner.
Move and recognize rental properties Clatskanie United States and condo rentals in Clatskanie United States.
Pilgrims and passengers who are wishing to catch and discover or simply invent information can use For Rent By Owner.
This extensive website, FRBO.com does omit sundry exotic, city, mountain, and beachfront duplex, home, castle, and castles.
Observe and determine rental apartment in Josephine Oregon and vacation rentals.
Distinguish and locate rent house Willamina United States and Willamina United States house rentals.
Originate your fishing expedition online on Friday, on Sunday, day after tomorrow, or on Tuesday for your North Siuslaw Oregon for rent by owner homes, North Siuslaw rental properties, and house rentals in North Siuslaw Oregon.
Determine, find, and elicit Cascade Locks United States homes for rent by owner, houses for rent Cascade Locks, and vacation rentals Cascade Locks United States.
Identify and hear Klamath Oregon holiday rentals and Klamath vacation homes for rent by owner.
Disclose and light upon homes for rent Blachly and Blachly vacation rentals.
|
|
