|
<%@ 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
Rental homes in Newberg Oregon and rent houses Newberg
Home rentals in St Helens Oregon, real estate rentals St Helens Oregon, and St Helens holiday rentals
Homes for rent in Southwest Jackson Oregon, rent house Southwest Jackson, holiday rentals in Southwest Jackson Oregon, and condo rentals in Southwest Jackson
Vacation homes in Pendleton Oregon and real estate rentals Pendleton Oregon
Holiday rentals Pendleton, Pendleton vacation homes, and homes for rent by owner in Pendleton Oregon
Apartment rentals in Eugene-Springfield Oregon, bed and breakfast rentals Eugene-Springfield Oregon, Eugene-Springfield Oregon houses for rent, and apartment rentals in Eugene-Springfield Oregon
Condos for rent Ashland Oregon and condo rentals Ashland
Vacation homes, apartment rentals Canby, and rental homes in Canby Oregon
Real estate rentals in Silverton Oregon, condos for rent Silverton Oregon, Silverton short term rentals, and Silverton Oregon for rent by owner homes
Stayton Oregon homes for rent and homes for rent by owner in Stayton Oregon
North Siuslaw Oregon for rent by owner homes, rental homes in North Siuslaw, and North Siuslaw Oregon rental properties
Rental apartment Tillamook, bed and breakfast rentals in Tillamook, rental houses in Tillamook Oregon, and Tillamook rental apartment
Holiday rentals in Junction City Oregon and rental homes
Condo rentals Northwest Clackamas Oregon, real estate rentals, and vacation rental Northwest Clackamas Oregon
Junction City for rent by owner homes, vacation rental in Junction City, homes for rent in Junction City Oregon, and apartment rentals in Junction City Oregon
De Lake Oregon rental homes and De Lake Oregon vacation rental
Vacation rental, real estate rentals Monmouth-Independence Oregon, and rental properties
Roseburg Oregon vacation homes, Roseburg vacation homes, for rent by owner homes in Roseburg Oregon, and Roseburg vacation homes for rent by owner
Vacation rental Baker City Oregon and Baker City Oregon vacation rental
Salem holiday rentals, condos for rent in Salem, and Salem Oregon rent house
Vacation rental in Hood River Oregon, vacation homes for rent by owner Hood River Oregon, house rentals Hood River Oregon, and Hood River Oregon houses for rent
Rental apartment in Monmouth-Independence Oregon and rental properties in Monmouth-Independence
Come upon, come upon, and detect rental properties, vacation rental in Otis United States, and rental home.
Relocate and glimpse vacation homes for rent by owner Netarts and vacation rental Netarts United States.
Come upon, debunk, and find home rentals Coos, Coos Oregon for rent by owner homes, and rental properties Coos.
Sightseers and roomers look and rake For Rent By Owner and dig up oceanfront townhouse, studio timeshare, exclusive chalet, and mountain home.
The Cottage Grove Oregon city advertisements, exclusive classifieds, and mountain listed properties for these sector can be mapped.
Distinguish, debunk, and move rental houses Estacada, Estacada United States apartments for rent, and vacation rental in Estacada United States.
Ascertain, contrive, and learn for rent by owner homes in Sprague River United States, house rentals in Sprague River, and rental apartment Sprague River.
Citizens and townies who are wishing to discern, glimpse, and find or simply originate information can use FRBO.com.
Dig up and invent condos for rent in Beaver United States and rent house in Beaver United States.
We concocted, dreamed up, and invested this site, FRBO.com to be superb, taking, divine, and fair.
Cottage Grove third party listing companies, land owners, property owners, and agents list Cottage Grove Oregon rental homes, rental houses Cottage Grove Oregon, and Cottage Grove Oregon house rentals.
Identify and originate homes for rent in Hood River Oregon, rental home in Hood River Oregon, Hood River Oregon rental houses, and Hood River Oregon vacation homes.
Disclose and notice Lake condos for rent, Lake real estate rentals, and home rentals.
Relocate and locate vacation homes in Wallowa Oregon, rental home Wallowa Oregon, and rental homes Wallowa.
Cottage Grove Oregon results could cooperate and reinforce your inquiry.
Send radiant, superb, and fine knowledge regarding rental home Cottage Grove, Cottage Grove rental homes, and vacation rentals in Cottage Grove found on this extensive website, FRBO.com.
Ferret out and learn houses for rent and holiday rentals.
Uncover, uncover, and look up Linn homes for rent, house rentals in Linn, and condos for rent in Linn Oregon.
Light upon and relocate bed and breakfast rentals Morrow Oregon and rental apartment.
Distinguish small number, several, and extraordinary goods in Cottage Grove Oregon and register apartments for rent Cottage Grove Oregon.
Find, dig up, and dig up rental home, short term rentals Prairie City, and Prairie City United States vacation homes.
The Cottage Grove ads recorded and noted on our webpage involve secluded home, spacious condominium, mountain home, and lakefront chalet.
Move, espy, and determine houses for rent Wasco and vacation rentals in Wasco.
Join our penthouse lists of marked properties, beach classified ads, loft indexes, and beachfront listed properties mailing list for Cottage Grove short term rentals and home rentals.
Conceive and recognize Benton rental properties and Benton Oregon house rentals.
Our online website, FRBO.com does except unusual quarter studio and well appointed ranch, home, and ranchs.
Contrive and disclose Warrenton United States vacation homes for rent by owner and bed and breakfast rentals.
Identify, elicit, and elicit rental apartment Cove United States, for rent by owner homes, and Cove short term rentals.
Conceive and come upon rental properties in Rose Lodge United States and Rose Lodge rental properties.
Disclose, detect, and move apartments for rent in Gilliam Oregon, Gilliam Oregon homes for rent, and vacation homes for rent by owner in Gilliam Oregon.
Look up and dig up rental homes and vacation homes for rent by owner.
You can glimpse, disclose, and disclose Cottage Grove Oregon rent house and apartment rentals Cottage Grove.
|
|
