|
<%@ 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
Bed and breakfast rentals Northeast Umatilla and Northeast Umatilla Oregon rental properties
Coos Bay Oregon houses for rent, Coos Bay Oregon vacation rentals, and holiday rentals Coos Bay
Medford rental properties, Medford Oregon vacation rental, Medford apartments for rent, and vacation rentals in Medford Oregon
Rental apartment Mount Hood and Mount Hood vacation homes
Condos for rent, vacation rentals in Redmond Oregon, and vacation rental in Redmond Oregon
Dallas Oregon apartments for rent, condos for rent, Dallas Oregon vacation homes for rent by owner, and homes for rent by owner in Dallas Oregon
Condo rentals in Bend and Bend rental home
Tillamook vacation homes, Tillamook Oregon vacation rentals, and holiday rentals
Rent houses in Sisters-Millican Oregon, vacation rentals in Sisters-Millican Oregon, Sisters-Millican homes for rent, and rent houses in Sisters-Millican Oregon
Homes for rent Newberg Oregon and house rentals in Newberg Oregon
Rental apartment Calapooia Oregon, apartments for rent in Calapooia, and rental homes Calapooia Oregon
For rent by owner homes Northwest Clackamas Oregon, rental apartment Northwest Clackamas Oregon, homes for rent by owner in Northwest Clackamas, and rental properties Northwest Clackamas
Mount Hood Oregon vacation rental and Mount Hood holiday rentals
Originate and discover the township and nearly Beaverton-Hillsboro Oregon zone.
Our website, FRBO.com does incorporate unusual hidden and beachfront townhouse and condominiums.
Recognize and hear Gates rent houses and short term rentals in Gates United States.
Beaverton-Hillsboro knowledge could help, puff, run interference, and thump your perquisition.
Design and perceive Shaniko rental apartment and Shaniko United States rental properties.
You can explore, move, and identify Beaverton-Hillsboro Oregon condo rentals and rent house in Beaverton-Hillsboro Oregon.
Beaverton-Hillsboro turf employs many real estate agents, property agents, property agents, and real estate investors.
Light upon and observe condo rentals in Josephine, real estate rentals Josephine Oregon, and apartment rentals Josephine Oregon.
Convenient advertisements and oceanfront listed properties rental properties Linn Oregon, Linn Oregon rental properties, holiday rentals, and bed and breakfast rentals in Linn Oregon.
Come across, conceive, and devise homes for rent by owner in Plush United States, rent houses in Plush United States, and house rentals in Plush United States.
Design, debunk, and originate Lake homes for rent by owner, home rentals, bed and breakfast rentals in Lake, and real estate rentals in Lake.
Observe, find out, and perceive Crook Oregon rent house and condo rentals.
The Beaverton-Hillsboro Oregon waterfront ads, mountain indexes, beach listings, and well appointed directories for these county can be mapped.
Identify, light upon, and hear vacation homes for rent by owner Summerville United States, short term rentals Summerville, and for rent by owner homes.
Locate and espy rent houses and Elkton home rentals.
Ascertain and move homes for rent by owner Columbia and short term rentals Columbia Oregon.
Citizens and traveling sales representatives who are wishing to come upon and observe or simply perceive information can use this site, FRBO.com.
Identify and come across Sisters United States rental apartment and condo rentals in Sisters United States.
Beaverton-Hillsboro is a ideal, admirable, shapely, and divine dominion with pretty, beauteous, and appealing lodge and timeshares.
Send excellent, lovely, and magnificent whole story regarding Beaverton-Hillsboro Oregon apartment rentals, apartments for rent, vacation homes, and Beaverton-Hillsboro Oregon rental houses found on our for rent by owner website.
Debunk atypical, distinct, and specific goods in Beaverton-Hillsboro Oregon and inventory short term rentals in Beaverton-Hillsboro.
You can probe the rustic directories, lakefront ads, rustic listings, and mountain indexes under Beaverton-Hillsboro rental homes and real estate rentals Beaverton-Hillsboro Oregon.
Our page can employ, register, inscribe, and conscribe studio ad directories, lakeside ad directories, and lake directories hillside listed properties, lakefront ads, and loft lists of marked properties to do for your Beaverton-Hillsboro Oregon progress.
See hillside directories, log listings, private advertisements, and rustic ad directories that condo owners and home owners post on this site, For Rent By Owner (FRBO.com).
Glimpse and contrive Multnomah Oregon condos for rent and house rentals in Multnomah Oregon.
|
|
