|
<%@ 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 in Roseburg Oregon and homes for rent by owner in Roseburg Oregon
St Helens houses for rent, St Helens house rentals, and condos for rent St Helens Oregon
Salem real estate rentals, house rentals, Salem homes for rent, and houses for rent Salem Oregon
Houses for rent Sheridan Oregon and homes for rent by owner Sheridan Oregon
Real estate rentals in Beaverton-Hillsboro, houses for rent Beaverton-Hillsboro Oregon, and rental houses Beaverton-Hillsboro Oregon
Apartment rentals in Baker City Oregon, houses for rent in Baker City Oregon, Baker City Oregon rent houses, and Baker City Oregon apartments for rent
Homes for rent Beaverton-Hillsboro Oregon and Beaverton-Hillsboro apartment rentals
Bed and breakfast rentals in Roseburg Oregon, rent houses in Roseburg, and short term rentals
Bend Oregon homes for rent, rental apartment in Bend, vacation rental in Bend Oregon, and vacation homes for rent by owner in Bend Oregon
Real estate rentals Klamath Falls and homes for rent
House rentals Lebanon Oregon, house rentals, and short term rentals Lebanon Oregon
Junction City Oregon real estate rentals, rental apartment in Junction City Oregon, Junction City apartment rentals, and rental houses in Junction City Oregon
Rent house in Ashland Oregon and Ashland Oregon rental homes
For rent by owner homes in Stayton, Stayton condo rentals, and for rent by owner homes in Stayton Oregon
Albany apartments for rent, Albany Oregon rent houses, vacation rentals in Albany, and condos for rent
Rental apartment in Baker City and holiday rentals Baker City Oregon
Condos for rent, Grants Pass real estate rentals, and Grants Pass Oregon bed and breakfast rentals
Homes for rent Tillamook Oregon, Tillamook Oregon vacation homes for rent by owner, Tillamook Oregon condos for rent, and condo rentals in Tillamook
Rent houses in Sweet Home Oregon and rent houses Sweet Home Oregon
Bed and breakfast rentals, Northeast Umatilla Oregon vacation homes for rent by owner, and Northeast Umatilla Oregon vacation rentals
Rent houses in Astoria, Astoria Oregon rental properties, homes for rent Astoria Oregon, and Astoria Oregon vacation rentals
Rental properties Grants Pass Oregon and for rent by owner homes in Grants Pass Oregon
Astoria Oregon rent house, vacation homes for rent by owner in Astoria, and for rent by owner homes
Tillamook Oregon rental homes, rental properties in Tillamook, vacation homes for rent by owner in Tillamook Oregon, and rental apartment in Tillamook
Rental properties Ashland and Ashland Oregon for rent by owner homes
Espy, recognize, and uncover Wolf Creek United States homes for rent by owner, Wolf Creek homes for rent by owner, and short term rentals.
Glimpse and light upon homes for rent in Seaside United States and Seaside apartments for rent.
Devise, catch, and elicit Polk Oregon short term rentals, rental home Polk Oregon, and homes for rent Polk Oregon.
You can seek the exclusive advertisements, resort ads, lake classified advertisements, and well appointed online MLS under rental apartment, rental home, and homes for rent in Somerset West-Rock Creek Oregon.
Espy and uncover Clatsop Oregon real estate rentals and Clatsop Oregon rental home.
Come upon and look up Swisshome United States real estate rentals and Swisshome United States holiday rentals.
This webpage does embrace diverse vicinity suburban, log, city, and exotic flat, flat, apartment, and farmhouses.
Renters and trippers study, ferret, and rummage our website, FRBO.com and discover beachfront ranch, city cottage, hillside home, and lakeside ranch.
Explore and ascertain rental houses in Jefferson Oregon, house rentals in Jefferson Oregon, and Jefferson Oregon rental apartment.
Come across and find rental apartment Columbia Oregon, rental home in Columbia Oregon, Columbia Oregon rental properties, and Columbia rental home.
Elicit, dig up, and explore North Powder United States house rentals, holiday rentals in North Powder United States, and homes for rent by owner North Powder.
Debunk and distinguish real estate rentals in Echo and rent houses Echo United States.
Beach lists of marked properties and studio listed properties rental properties Polk, vacation homes for rent by owner Polk Oregon, rental properties in Polk Oregon, and rental home in Polk.
Find, discern, and learn Clatsop Oregon rental properties and vacation homes in Clatsop Oregon.
Determine, discern, and contrive Wasco home rentals, rental apartment, and Wasco Oregon real estate rentals.
Espy, design, and distinguish Wheeler rent house, vacation homes for rent by owner in Wheeler, for rent by owner homes in Wheeler Oregon, and homes for rent in Wheeler.
Send magnificent, magnificent, and charming details regarding vacation homes for rent by owner in Somerset West-Rock Creek Oregon and Somerset West-Rock Creek Oregon short term rentals found on our site, FRBO.com.
Identify, identify, and notice homes for rent in Jackson Oregon and rental apartment in Jackson.
Hear and look up rental houses Garibaldi and Garibaldi United States rental houses.
Occupiers, companions, and friends who are going through Somerset West-Rock Creek Oregon vacation rentals and are trying to recognize home rentals Somerset West-Rock Creek and Somerset West-Rock Creek Oregon homes for rent by owner can ransack our online website, FRBO.com and our log ad directories, loft classifieds, private online MLS, and log indexes.
Relocate, notice, and originate the quarter and proximate Somerset West-Rock Creek Oregon county.
Hear, explore, and recognize rental apartment Canyonville, rental apartment, and homes for rent by owner in Canyonville United States.
Lead off your going-over online day after tomorrow, this weekend, or this evening for your Somerset West-Rock Creek Oregon vacation homes for rent by owner, rent houses Somerset West-Rock Creek Oregon, and house rentals in Somerset West-Rock Creek Oregon.
Devise special and distinct picture in Somerset West-Rock Creek Oregon and place apartments for rent Somerset West-Rock Creek Oregon.
You can come across and contrive Somerset West-Rock Creek apartments for rent and vacation rental Somerset West-Rock Creek.
Espy, originate, and distinguish vacation rentals in Gales Creek, Gales Creek rental apartment, and vacation rentals Gales Creek.
Notice and distinguish rent houses Kent and short term rentals in Kent.
This site, For Rent By Owner (FRBO.com) consist ofs stretch, township, locality, and neighborhood notes, customarily.
Discern and originate rental properties in Benton and apartments for rent in Benton Oregon.
Vacation homes for rent by owner and rent house
Recently vacated secluded townhouse, lakefront lodge, studio duplex, and beach flat are handy in the not far principality of Somerset West-Rock Creek Oregon.
See convenient indexes, studio listed properties, secluded indexes, and exclusive classified ads that landlords and real estate agents post on this extensive website, FRBO.com.
Levy, hire, engage, and muster on Sunday to tear into, open, get going, and enter upon on this course.
Discover and come upon Powers United States for rent by owner homes and vacation homes.
Look up and locate vacation homes in Shedd United States and Shedd United States rental homes.
Originate and invent home rentals, condo rentals in Polk Oregon, and Polk Oregon home rentals.
Perceive, catch, and look up homes for rent by owner in Mapleton United States, Mapleton real estate rentals, and Mapleton United States houses for rent.
Somerset West-Rock Creek score could collaborate, sustain, help, and abet your pursuance.
Look up and relocate Hillsboro vacation rentals and Hillsboro United States rent houses.
Discover and glimpse rent house Grant, rental apartment Grant Oregon, and condos for rent in Grant.
Find, contrive, and distinguish holiday rentals in Rose Lodge United States, apartments for rent Rose Lodge, and home rentals in Rose Lodge.
Ferret out and identify bed and breakfast rentals in Lyons and real estate rentals in Lyons.
Catch, conceive, and elicit rental homes Tillamook Oregon, Tillamook Oregon homes for rent, short term rentals, and home rentals Tillamook.
Somerset West-Rock Creek agents serving the condo market, rental property owners, third party agents, and agents list Somerset West-Rock Creek Oregon short term rentals, vacation rental in Somerset West-Rock Creek Oregon, Somerset West-Rock Creek Oregon houses for rent, and Somerset West-Rock Creek Oregon bed and breakfast rentals.
The Somerset West-Rock Creek Oregon beach listings, lakefront directories, and lakefront advertisements for these township can be mapped.
Hear, find, and look up apartments for rent in Wasco and Wasco Oregon apartments for rent.
|
|
