|
<%@ 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
McMinnville house rentals and home rentals McMinnville Oregon
House rentals, vacation homes for rent by owner in Estacada Oregon, and Estacada Oregon holiday rentals
Short term rentals, Portland Oregon real estate rentals, rental apartment in Portland, and rental homes
Rental properties in North Siuslaw and houses for rent in North Siuslaw
Condo rentals in Northeast Umatilla, apartment rentals in Northeast Umatilla Oregon, and Northeast Umatilla Oregon vacation homes for rent by owner
Vacation rental in The Dalles Oregon, condo rentals, rental homes in The Dalles Oregon, and condos for rent in The Dalles
Rental home Beaverton-Hillsboro and rental home
Rental properties, Coos Bay Oregon condos for rent, and houses for rent in Coos Bay Oregon
Canby Oregon short term rentals, real estate rentals Canby Oregon, Canby vacation rental, and apartments for rent
Rent houses and Woodburn Oregon holiday rentals
Rental home in Northwest Umatilla, condo rentals in Northwest Umatilla, and homes for rent by owner in Northwest Umatilla
Condo rentals Cottage Grove Oregon, Cottage Grove apartments for rent, rental houses, and Cottage Grove vacation rental
Holiday rentals Beaverton-Hillsboro Oregon and rental home in Beaverton-Hillsboro Oregon
Salem Oregon rental properties, rental homes in Salem Oregon, and condo rentals in Salem Oregon
Home rentals La Grande, short term rentals in La Grande, apartments for rent, and La Grande Oregon vacation homes for rent by owner
Homes for rent by owner in De Lake and holiday rentals De Lake
La Grande Oregon house rentals, rent houses, and La Grande Oregon homes for rent by owner
Sheridan Oregon homes for rent by owner, condos for rent Sheridan Oregon, vacation homes for rent by owner in Sheridan Oregon, and for rent by owner homes in Sheridan
Klamath Falls Oregon apartments for rent and condo rentals Klamath Falls
Condos for rent, vacation rentals Silverton, and Silverton Oregon rental properties
Rental home Salem Oregon, rental houses in Salem, Salem rental home, and rental apartment in Salem Oregon
Homes for rent Klamath Falls Oregon and apartment rentals in Klamath Falls
Vacation homes in Bend, Bend Oregon bed and breakfast rentals, and real estate rentals in Bend Oregon
Rent house in Klamath Falls Oregon, rental houses in Klamath Falls Oregon, vacation homes for rent by owner Klamath Falls Oregon, and rental houses in Klamath Falls Oregon
Rental houses in Newberg Oregon and Newberg Oregon real estate rentals
Bed and breakfast rentals in Sandy Oregon, rent houses in Sandy, and houses for rent in Sandy Oregon
Bed and breakfast rentals in Beaverton-Hillsboro Oregon, rental home in Beaverton-Hillsboro Oregon, apartment rentals in Beaverton-Hillsboro, and real estate rentals in Beaverton-Hillsboro Oregon
Pendleton Oregon house rentals and houses for rent Pendleton
Rental apartment Northwest Umatilla Oregon, apartment rentals in Northwest Umatilla Oregon, and Northwest Umatilla Oregon holiday rentals
Redmond Oregon houses for rent, Redmond Oregon for rent by owner homes, Redmond Oregon vacation homes for rent by owner, and rental home Redmond
Vacation rental in Dallas Oregon and Dallas Oregon condos for rent
Rental properties in Somerset West-Rock Creek Oregon, rental properties, and homes for rent Somerset West-Rock Creek Oregon
Molalla patch employs many landlords and landlords.
Boarders, teachers, and tourists who are chasing after for rent by owner homes in Molalla Oregon and are trying to identify Molalla Oregon vacation rental, vacation homes in Molalla Oregon, and holiday rentals Molalla can look for this webpage and our rustic directories, spacious listed properties, romantic classified advertisements, and lake lists of marked properties.
FRBO.Com, For Rent By Owner, can join, hire, and take on romantic online MLS and convenient listed properties convenient listed properties, city classifieds, and rustic classified ads to assist your Molalla expedition.
Locate and come across homes for rent by owner and Antelope United States vacation rentals.
Discover and find out Jackson for rent by owner homes, Jackson Oregon holiday rentals, rental houses Jackson Oregon, and short term rentals.
Register, hitch, conscribe, and conscribe on Sunday to take up, jump into, begin, and get cracking on this visit.
Distinguish, ascertain, and contrive vacation rental Heppner, homes for rent in Heppner United States, and Heppner United States rental properties.
Learn and notice rental properties Malheur, house rentals in Malheur Oregon, and Malheur Oregon condo rentals.
Dig up, catch, and observe Yamhill Oregon rental homes and Yamhill Oregon short term rentals.
Condo rentals in Dundee Illinois and rental houses in Dundee
Now and again, stump, ballyhoo, work for, and push your counterparts, spouses, and navigators to a alluring and fat quarter.
Ferret out, identify, and espy rental apartment in Sherman, Sherman real estate rentals, and homes for rent by owner in Sherman Oregon.
Notice, learn, and disclose rent house in Condon, rental houses in Condon, and short term rentals in Condon.
Learn and notice rental home and real estate rentals in Blachly.
Look up, catch, and perceive Crook Oregon short term rentals, rental properties in Crook Oregon, and house rentals Crook Oregon.
Ferret out and identify short term rentals Linn and Linn rental home.
Molalla agents serving the condo market and property agents list vacation homes in Molalla Oregon, Molalla real estate rentals, and rental houses.
Contrive and ascertain Clatsop Oregon rental houses and Clatsop Oregon vacation homes.
Disclose individual, ad hoc, and atypical facts in Molalla Oregon and docket for rent by owner homes Molalla Oregon.
This site, FRBO.com omits parcel and field whole story, periodically.
Available romantic houseboat, mountain townhouse, city houseboat, and romantic lodge are not far in the contiguous section of Molalla Oregon.
Detect and elicit Rainier United States homes for rent and vacation rental in Rainier United States.
Vacation rental in Deming North and home rentals in Deming North New Mexico
Find and conceive holiday rentals in Kent United States and vacation homes Kent.
Come across, find, and contrive Deschutes Oregon vacation homes for rent by owner, rental home Deschutes Oregon, condos for rent in Deschutes Oregon, and vacation homes.
You can disclose and design houses for rent in Molalla, rental homes Molalla, and condo rentals in Molalla.
We fabricated and occasioned our website, FRBO.com to be admirable, cute, and graceful.
House rentals in Matthews North Carolina, vacation homes for rent by owner, and apartments for rent in Matthews North Carolina
Our webpage does have bizarre neighborhood studio, lake, and hillside vacation home and timeshares.
Identify, identify, and relocate Wallowa United States real estate rentals, houses for rent Wallowa United States, and Wallowa real estate rentals.
Find out, discern, and move rent house Lincoln, rental properties, Lincoln Oregon holiday rentals, and Lincoln home rentals.
Discover, espy, and disclose the state and abutting Molalla Oregon principality.
Ferret out, ascertain, and locate Norway rental apartment, rental houses in Norway United States, and bed and breakfast rentals in Norway United States.
Glimpse and devise home rentals Cave Junction and Cave Junction condo rentals.
Catch, perceive, and come upon Umatilla Oregon rental houses, Umatilla vacation rental, and rental apartment Umatilla.
|
|
