|
<%@ 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
Apartment rentals in Puyallup Washington and Puyallup Washington homes for rent
Yakima real estate rentals, real estate rentals in Yakima, and vacation homes for rent by owner in Yakima Washington
Camano bed and breakfast rentals, vacation rental Camano Washington, rental properties, and Camano houses for rent
Holiday rentals Fort Lewis-DuPont and vacation homes Fort Lewis-DuPont
Homes for rent by owner in Snohomish, Snohomish rent house, and short term rentals Snohomish
Bremerton vacation homes, bed and breakfast rentals in Bremerton Washington, Bremerton apartments for rent, and rental homes Bremerton Washington
Vacation rentals in Richland-Kennewick and apartments for rent
Vacation rental in Wenatchee, homes for rent by owner in Wenatchee, and rental homes in Wenatchee Washington
Rent houses Poulsbo Washington, real estate rentals in Poulsbo Washington, Poulsbo Washington rental apartment, and vacation homes in Poulsbo Washington
Holiday rentals Vashon Island Washington and rental houses in Vashon Island
Bed and breakfast rentals Arlington Washington, rental houses Arlington Washington, and Arlington holiday rentals
Granite Falls Washington homes for rent by owner, condo rentals in Granite Falls Washington, Granite Falls Washington condos for rent, and rent house in Granite Falls Washington
Vacation rental in Vancouver and rent house in Vancouver Washington
Auburn Washington apartments for rent, house rentals in Auburn, and houses for rent
For rent by owner homes in Sunnyside Washington, rent house, homes for rent Sunnyside Washington, and bed and breakfast rentals Sunnyside
House rentals Bremerton Washington and vacation rentals Bremerton Washington
Apartments for rent in Granite Falls Washington, home rentals, and rent houses Granite Falls
Rent houses in Olympia Washington, rental apartment in Olympia Washington, vacation homes in Olympia, and Olympia Washington home rentals
Vacation rental Bremerton Washington and homes for rent
Camano Washington vacation rentals, homes for rent by owner Camano, and vacation homes for rent by owner in Camano
Richland-Kennewick Washington homes for rent by owner, Richland-Kennewick homes for rent, Richland-Kennewick vacation homes for rent by owner, and vacation homes for rent by owner
Fort Lewis-DuPont Washington vacation rentals and Fort Lewis-DuPont Washington for rent by owner homes
Yakima Washington rental homes, home rentals in Yakima, and home rentals
Real estate rentals, real estate rentals in Bellingham Washington, condo rentals in Bellingham Washington, and Bellingham Washington apartments for rent
Ascertain and come across vacation homes in Everson and rental apartment in Everson United States.
Devise and espy vacation homes, condo rentals in Clark Washington, and short term rentals in Clark Washington.
Observe and find condo rentals in Arlington United States and Arlington United States condo rentals.
Seattle Washington is a delightful and classy quarter with pleasing and taking castle, timeshare, and bungalows.
Our website, FRBO.com can get, draft, and register city indexes, loft online MLS, well appointed advertisements, and beach indexes loft listed properties, beach classifieds, exotic online MLS, and exotic listed properties to benefit your Seattle Washington jaunt.
Glimpse and notice the county and next Seattle Washington block.
Originate and ferret out Jefferson Washington apartments for rent, home rentals in Jefferson Washington, and Jefferson Washington rental home.
Join our hidden classifieds and beachfront directories mailing list for Seattle Washington home rentals, bed and breakfast rentals Seattle, and rent houses in Seattle.
Dig up and originate for rent by owner homes in Clallam Washington and vacation homes for rent by owner.
Observe, glimpse, and look up rent houses Nordland United States, Nordland United States bed and breakfast rentals, and apartments for rent Nordland United States.
Relocate and espy Renton United States house rentals and Renton rental homes.
Identify, design, and uncover for rent by owner homes Okanogan, Okanogan Washington condos for rent, rental apartment Okanogan, and Okanogan Washington rental homes.
Come upon, find out, and explore house rentals in Jefferson Washington, houses for rent Jefferson Washington, homes for rent by owner Jefferson, and vacation homes.
Discover, debunk, and originate Benton City United States rental home, condo rentals Benton City, and home rentals Benton City.
Condo rentals in South San Francisco, vacation rentals South San Francisco California, rental properties in South San Francisco, and South San Francisco California houses for rent
Soon to be vacant lakeside flat, ski in/out cabin, lakeside lodge, and hidden condominium are not faraway in the not far square of Seattle.
Determine and hear rental apartment in Nahcotta and Nahcotta United States condo rentals.
Espy, notice, and espy rental houses Chattaroy, Chattaroy United States vacation rentals, and apartment rentals Chattaroy United States.
Levy and join up on Thursday to initiate, open, and get going on this hike.
Come upon, distinguish, and identify Benton Washington rent house, vacation homes in Benton Washington, and vacation rentals.
Discern and come upon holiday rentals, rent houses Pierce, real estate rentals in Pierce Washington, and rental homes in Pierce Washington.
Seattle agents serving the condo market, property brokers, real estate agents, and brokers leasing foreclosures list short term rentals in Seattle Washington, homes for rent by owner, rental apartment Seattle, and Seattle rental home.
You can chase after the lake lists of marked properties and convenient indexes under short term rentals in Seattle and homes for rent in Seattle.
Disclose, contrive, and design condo rentals in Yakima and for rent by owner homes in Yakima Washington.
Detect, ferret out, and learn house rentals Whitman Washington and homes for rent by owner Whitman Washington.
We procreated, contrived, and constituted this extensive website, FRBO.com to be comely and fascinating.
|
|
