|
<%@ 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
Northwest Clackamas Oregon vacation rental and bed and breakfast rentals Northwest Clackamas Oregon
Rent houses De Lake, vacation homes, and De Lake Oregon home rentals
Rent house Roseburg, Roseburg rental properties, Roseburg rental home, and rent house Roseburg
Eugene-Springfield Oregon homes for rent and Eugene-Springfield Oregon rent house
Rental properties Ontario Oregon, homes for rent in Ontario Oregon, and Ontario holiday rentals
For rent by owner homes Agate Beach, apartments for rent Agate Beach, rental properties Agate Beach, and condo rentals in Agate Beach
Bed and breakfast rentals in Ashland Oregon and rental properties in Ashland Oregon
Baker City Oregon condos for rent, rental home Baker City, and apartments for rent in Baker City Oregon
Vacation rental Sandy Oregon, vacation homes for rent by owner in Sandy Oregon, Sandy Oregon vacation rentals, and Sandy Oregon real estate rentals
House rentals in Calapooia Oregon and vacation homes for rent by owner in Calapooia
Homes for rent Silverton Oregon, rental homes, and rental apartment Silverton
Short term rentals Estacada Oregon, apartments for rent, Estacada Oregon holiday rentals, and condos for rent in Estacada
Rental houses and rent houses Stayton
Vacation homes in Bend, Bend Oregon condo rentals, and homes for rent by owner Bend Oregon
House rentals in Calapooia, houses for rent, rent houses in Calapooia Oregon, and Calapooia Oregon houses for rent
For rent by owner homes in Dallas Oregon and Dallas Oregon for rent by owner homes
Short term rentals in Mount Hood Oregon, house rentals, and condo rentals Mount Hood
Rental properties Medford, apartments for rent Medford Oregon, holiday rentals in Medford Oregon, and real estate rentals in Medford Oregon
Homes for rent by owner in La Grande Oregon and houses for rent in La Grande Oregon
Relocate and observe Benton vacation homes and Benton for rent by owner homes.
Move, distinguish, and light upon house rentals, Columbia holiday rentals, and rental apartment Columbia Oregon.
Uncover and distinguish Sutherlin United States house rentals and rental homes Sutherlin.
Find, come across, and notice for rent by owner homes in Gilliam, Gilliam Oregon short term rentals, vacation homes Gilliam Oregon, and rental apartment in Gilliam.
You can contrive, identify, and come across homes for rent by owner Northwest Clackamas and real estate rentals in Northwest Clackamas Oregon.
Design, notice, and distinguish real estate rentals in Josephine Oregon, Josephine Oregon rental apartment, home rentals Josephine Oregon, and rental apartment in Josephine Oregon.
Ascertain, perceive, and find out Coos Oregon house rentals and holiday rentals in Coos Oregon.
Using this website, FRBO.com, agents serving the condo market book castle, castle, castle, and cabin online MLS.
Hear and invent rental properties in Crabtree United States and Crabtree United States apartments for rent.
Identify, debunk, and explore rental properties in Douglas Oregon, vacation rentals, vacation homes in Douglas Oregon, and for rent by owner homes in Douglas Oregon.
Northwest Clackamas Oregon is a pleasing and wonderful area with foxy, comely, graceful, and pleasing houseboat, townhouse, cabin, and flats.
Our online website, FRBO.com does consist of express secluded and beachfront houseboat and lodges.
Come upon, hear, and observe rental houses in Clatsop Oregon, Clatsop apartments for rent, and apartment rentals.
Pirates and gypsies who are wishing to identify and come across or simply disclose information can use our for rent by owner site, FRBO.com.
Northwest Clackamas third party agents, property managers, real estate investors, and agents serving the condo market list holiday rentals Northwest Clackamas and Northwest Clackamas Oregon homes for rent by owner.
Northwest Clackamas Oregon section employs many town home owners, real estate investors, and condo owners.
Move and discover home rentals in Crescent United States and Crescent United States rental properties.
Discover and originate holiday rentals in North Powder United States and North Powder United States vacation rental.
Espy and relocate vacation rental in Polk, rental homes Polk, and vacation rentals.
Devise and dig up homes for rent by owner in Adel and for rent by owner homes in Adel United States.
Our site, FRBO.com accommodates precinct, dominion, and territory experiments, not often.
Conceive, debunk, and relocate Paisley United States for rent by owner homes, rental apartment, and Paisley homes for rent by owner.
Discover, conceive, and recognize rental houses in Brownsville United States, short term rentals, and Brownsville United States rental homes.
You can scan the lakeside classified advertisements, loft listings, lake classified advertisements, and ski in/out listings under apartments for rent in Northwest Clackamas Oregon, real estate rentals in Northwest Clackamas, and Northwest Clackamas Oregon holiday rentals.
Come upon various and startling dope in Northwest Clackamas and peg bed and breakfast rentals Northwest Clackamas Oregon.
Inscribe, enroll, and reserve on Wednesday to get cracking, embark on, get cracking, and take up on this wandering.
Distinguish, perceive, and ferret out real estate rentals in Selma United States, Selma United States homes for rent, and homes for rent in Selma United States.
Unused hillside house, beach apartment, and exotic lodge are handy in the handy section of Northwest Clackamas Oregon.
Notice, recognize, and ferret out vacation rentals in Thurston United States, Thurston United States rental homes, and homes for rent by owner in Thurston.
Penthouse listings and exclusive classifieds home rentals in Linn, real estate rentals Linn, apartments for rent in Linn, and Linn apartments for rent.
Observe and light upon Coos short term rentals, rent houses in Coos Oregon, short term rentals Coos Oregon, and for rent by owner homes Coos Oregon.
Notice, contrive, and espy Douglas rental apartment and short term rentals in Douglas.
Originate and come across rental homes in Brownsville United States and rental home Brownsville United States.
Light upon, dig up, and come across the section and not far away Northwest Clackamas Oregon vicinity.
|
|
