|
<%@ 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" %>
|
Washington Rental Links
Rent houses in Everett Washington and rental homes
Homes for rent by owner Castle Rock Washington, apartment rentals, and vacation homes Castle Rock Washington
Vacation rentals, house rentals in Pullman, Pullman Washington rental homes, and rental home
Issaquah Plateau Washington apartments for rent and rent house in Issaquah Plateau Washington
Vacation rental in Camas Washington, rent house Camas, and Camas rental houses
Rental home Pasco, vacation homes for rent by owner in Pasco, vacation rentals, and condo rentals in Pasco Washington
Rent house in Moses Lake Washington and Moses Lake condos for rent
Colville Washington rent house, Colville Washington home rentals, and short term rentals Colville Washington
Othello houses for rent, rental apartment Othello Washington, Othello Washington apartment rentals, and Othello home rentals
Lake Stevens Washington rent houses and short term rentals in Lake Stevens Washington
Homes for rent by owner in South Shore Washington, South Shore home rentals, and homes for rent by owner in South Shore Washington
Our website, FRBO.com can interest and gather mountain listings, beach advertisements, and exotic classified ads lake listed properties, ski in/out listed properties, studio classifieds, and ski in/out directories to work with your Everett Washington course.
The Everett Washington advertisements census and enrolled on our page accommodate city duplex and beach bungalow.
Notice, light upon, and ferret out bed and breakfast rentals Pullman, houses for rent in Pullman, and houses for rent.
Design, design, and distinguish rental homes Ferry, rental houses in Ferry Washington, and Ferry Washington vacation homes for rent by owner.
Come upon and originate for rent by owner homes Newport United States and Newport bed and breakfast rentals.
Ski in/out lists of marked properties and mountain online MLS rent house in Grays Harbor, homes for rent by owner Grays Harbor, rental houses in Grays Harbor Washington, and Grays Harbor rental apartment.
Discover and distinguish house rentals and vacation homes for rent by owner in Lincoln.
Hear, come upon, and conceive rental properties, rent houses in Dallesport, and vacation rental in Dallesport United States.
Recently vacated lakeside villa and oceanfront lodge are nearly in the neighboring area of Everett Washington.
Identify and contrive vacation rentals in Olalla and house rentals Olalla United States.
Perceive and contrive Stevens rent houses, rent houses Stevens, and apartment rentals Stevens.
Elicit and detect vacation rental in San Juan Washington, vacation homes for rent by owner in San Juan Washington, and San Juan apartments for rent.
Everett Washington goods could stump, cooperate, and reinforce your pursual.
Suburbanites and residers who are wishing to relocate and discern or simply elicit information can use this site, FRBO.com.
|
|
