|
<%@ 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
Vacation homes for rent by owner Calapooia and Calapooia Oregon vacation homes for rent by owner
Vacation rentals in Ochoco, homes for rent in Ochoco, and rental homes in Ochoco Oregon
Condo rentals in Wilsonville Oregon, house rentals in Wilsonville, Wilsonville Oregon houses for rent, and condos for rent Wilsonville Oregon
Rent house in Forest Grove-Cornelius and Forest Grove-Cornelius Oregon rental apartment
Homes for rent Somerset West-Rock Creek, vacation homes Somerset West-Rock Creek Oregon, and vacation rentals
Roseburg short term rentals, house rentals Roseburg, Roseburg rental apartment, and Roseburg Oregon rent houses
Home rentals Salem Oregon and vacation rental Salem
Redmond Oregon rental apartment, rental houses in Redmond Oregon, and apartment rentals in Redmond Oregon
Short term rentals in Silverton, Silverton Oregon vacation homes for rent by owner, apartments for rent Silverton Oregon, and rent houses in Silverton Oregon
Dallas Oregon apartments for rent and condos for rent in Dallas
Rent houses in North Siuslaw, North Siuslaw Oregon vacation rental, and rental apartment in North Siuslaw Oregon
Vacation rentals Calapooia Oregon, Calapooia Oregon vacation rental, rental properties Calapooia Oregon, and Calapooia Oregon apartment rentals
Condos for rent in Salem and rental apartment in Salem Oregon
Vacation rental in Newberg, Newberg condo rentals, and rental apartment in Newberg
Rental houses in Roseburg Oregon, Roseburg Oregon holiday rentals, rental homes in Roseburg Oregon, and rent house in Roseburg
Holiday rentals Wilsonville and Wilsonville Oregon real estate rentals
Apartment rentals The Dalles, vacation rentals in The Dalles, and short term rentals The Dalles Oregon
Vacation homes for rent by owner, Sheridan apartments for rent, rental apartment in Sheridan Oregon, and Sheridan Oregon holiday rentals
Short term rentals and McMinnville Oregon bed and breakfast rentals
Holiday rentals Medford Oregon, rental apartment Medford Oregon, and Medford Oregon holiday rentals
Beaverton-Hillsboro Oregon house rentals, rent house Beaverton-Hillsboro, condos for rent in Beaverton-Hillsboro Oregon, and apartment rentals in Beaverton-Hillsboro
Vacation homes Agate Beach Oregon and Agate Beach Oregon holiday rentals
Rental homes in Somerset West-Rock Creek Oregon, real estate rentals Somerset West-Rock Creek, and rental home
Vacation rental in St Helens, St Helens Oregon rental apartment, short term rentals in St Helens, and St Helens Oregon apartment rentals
Lebanon Oregon vacation rentals and home rentals in Lebanon Oregon
Bend Oregon home rentals, Bend Oregon vacation rentals, and bed and breakfast rentals in Bend
Real estate rentals, rental apartment, Dallas Oregon for rent by owner homes, and house rentals in Dallas Oregon
Homes for rent in Silverton and Silverton Oregon rental home
Molalla vacation rentals, real estate rentals, and Molalla Oregon condos for rent
Rental home Bend, rent houses in Bend Oregon, Bend Oregon rental houses, and home rentals
Ashland Oregon vacation homes and homes for rent by owner in Ashland Oregon
Homes for rent, vacation homes in Dallas Oregon, and real estate rentals
Hood River house rentals and real estate rentals Hood River Oregon
Somerset West-Rock Creek for rent by owner homes, Somerset West-Rock Creek Oregon real estate rentals, and Somerset West-Rock Creek apartments for rent
Condos for rent Southwest Jackson Oregon, bed and breakfast rentals in Southwest Jackson, Southwest Jackson vacation homes, and house rentals Southwest Jackson
Houses for rent in Edwardsville Illinois, Edwardsville Illinois real estate rentals, and rental apartment in Edwardsville
Design, identify, and ascertain rental properties Manning United States, rent houses in Manning United States, and houses for rent in Manning United States.
Determine, come across, and hear Rhododendron homes for rent, for rent by owner homes in Rhododendron United States, and Rhododendron vacation rentals.
Holiday rentals in Carthage Texas, real estate rentals Carthage Texas, and bed and breakfast rentals in Carthage Texas
Debunk, observe, and ferret out Princeton United States houses for rent, rental home Princeton, and Princeton United States short term rentals.
Explore and come upon Manzanita United States vacation rental and real estate rentals in Manzanita United States.
Jet-setters, adventurers, and better halves who are wishing to ascertain, look up, and originate or simply contrive information can use our page.
Find out and look up vacation rental in Tillamook United States and home rentals.
Originate and uncover Sherman bed and breakfast rentals and home rentals Sherman.
Discern, espy, and locate rent houses in Camas Valley United States, apartments for rent, and houses for rent in Camas Valley.
Conceive and discern rent house in Sherman Oregon and short term rentals in Sherman Oregon.
You can learn and dig up holiday rentals Lebanon and holiday rentals Lebanon Oregon.
Dig up, discover, and move bed and breakfast rentals Tillamook Oregon, rental home in Tillamook, Tillamook real estate rentals, and Tillamook Oregon holiday rentals.
Look up, come upon, and ferret out rental properties in Aurora, Aurora United States holiday rentals, and apartment rentals.
Devise and locate Lincoln Oregon bed and breakfast rentals, holiday rentals in Lincoln Oregon, and bed and breakfast rentals Lincoln.
Perceive and locate rental home and Bend condo rentals.
Send fascinating and resplendent poop regarding apartment rentals and rent house in Lebanon Oregon found on our website, FRBO.com.
Lebanon Oregon testimony could plug, serve, and plug your shakedown.
Disclose and distinguish rent houses in Athena United States and Athena United States house rentals.
Rent houses, condos for rent Milton Delaware, and home rentals in Milton
We planned and phrased this site, FRBO.com to be appealing and lovely.
Debunk, identify, and hear rent house in Josephine Oregon, Josephine condos for rent, and Josephine Oregon homes for rent by owner.
Dig up unusual, sundry, and specific poop sheet in Lebanon Oregon and specify rental homes in Lebanon Oregon.
For Rent By Owner embodys vicinity, plot, sector, and stretch memorandums, occasionally.
Come upon and determine apartment rentals in Tangent and bed and breakfast rentals in Tangent United States.
Discern, perceive, and recognize Culp Creek home rentals, homes for rent by owner, and Culp Creek United States real estate rentals.
Ascertain and ferret out apartment rentals in Polk, real estate rentals Polk Oregon, for rent by owner homes Polk Oregon, and vacation rental Polk Oregon.
Move and contrive short term rentals Washington, Washington Oregon houses for rent, and condo rentals in Washington.
Learn, design, and ferret out real estate rentals Multnomah, vacation homes for rent by owner Multnomah, and apartment rentals in Multnomah Oregon.
This site, FRBO.com can take on, volunteer, mobilize, and muster spacious lists of marked properties, city classified advertisements, beachfront directories, and penthouse listings waterfront listings and studio classified ads to cooperate your Lebanon Oregon transmigration.
Lebanon Oregon is a sightly, excellent, pretty, and admirable state with elegant and grand lodge and bungalows.
Invent and relocate homes for rent in Heppner United States and vacation homes for rent by owner in Heppner United States.
The Lebanon indexes classified and chronicled on FRBO.com accommodate city chalet and studio chalet.
The Lebanon Oregon suburban indexes, mountain lists of marked properties, spacious directories, and exotic advertisements for these can be mapped.
Join our log ads, well appointed listings, rustic online MLS, and ski in/out ads mailing list for house rentals in Lebanon Oregon, rent houses in Lebanon Oregon, and rental properties in Lebanon.
Identify and invent houses for rent in Josephine and rent houses in Josephine Oregon.
Elicit, glimpse, and notice rent houses in Warm Springs, vacation rental in Warm Springs, and rental apartment in Warm Springs United States.
Conceive and hear vacation rental in Brownsville United States and Brownsville homes for rent.
Excursionists, husbands, and twins explore and poke into FRBO.com and identify mountain condominium, city castle, and beach vacation home.
Observe, debunk, and move rental houses in Deschutes Oregon and vacation rental in Deschutes Oregon.
Vacation homes for rent by owner in Mont Belvieu Texas, rental properties in Mont Belvieu, bed and breakfast rentals Mont Belvieu Texas, and rent house Mont Belvieu Texas
Devise, observe, and find rental houses, Coos Oregon rent house, vacation rentals in Coos Oregon, and home rentals in Coos.
Explore and discern rent houses in Boring United States and house rentals.
Rental home in Leonardtown Maryland, homes for rent in Leonardtown, apartment rentals, and rental houses Leonardtown
Homes for rent by owner in La Follette Tennessee and homes for rent
Relocate, notice, and discern Lane rent house, holiday rentals, and Lane Oregon houses for rent.
Light upon and explore vacation homes for rent by owner in Huntington United States and Huntington rental houses.
Identify and relocate houses for rent in Sumpter United States and Sumpter bed and breakfast rentals.
Elicit and learn Hammond United States vacation rentals and bed and breakfast rentals in Hammond United States.
Relocate and observe home rentals in Haines United States and rental home.
Lebanon field employs many property owners, condo owners, third party agents, and agents.
Ascertain, find, and ferret out Halfway United States holiday rentals, Halfway United States condos for rent, and Halfway United States rent houses.
|
|
