|
<%@ 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
Olympia holiday rentals and rental houses
Ellensburg Washington houses for rent, homes for rent in Ellensburg, and house rentals in Ellensburg
House rentals Spokane Washington, Spokane homes for rent, homes for rent Spokane, and vacation rentals Spokane
Ellensburg rental homes and Ellensburg holiday rentals
East Seattle vacation rentals, rental home, and vacation homes
Real estate rentals in Cashmere Washington, holiday rentals, rental home Cashmere, and apartment rentals in Cashmere Washington
Camano Washington bed and breakfast rentals and house rentals Camano
Rental properties in Olympia West Washington, bed and breakfast rentals Olympia West Washington, and Olympia West Washington home rentals
Lower Peninsula apartments for rent, rental houses Lower Peninsula Washington, rental home in Lower Peninsula Washington, and Lower Peninsula Washington rent house
Rental properties in Centralia-Chehalis and bed and breakfast rentals
Rental houses in Marysville Washington, apartment rentals in Marysville, and real estate rentals in Marysville
Bed and breakfast rentals Sunnyside Washington, vacation rentals Sunnyside, rental properties Sunnyside Washington, and Sunnyside Washington apartments for rent
Lynden Washington rental home and homes for rent in Lynden
Anacortes Washington holiday rentals, Anacortes Washington rental properties, and Anacortes Washington short term rentals
Rental houses Skykomish, vacation rental in Skykomish Washington, houses for rent, and rental properties in Skykomish Washington
Condo rentals in Lake Stevens and rental home in Lake Stevens Washington
Sedro-Woolley Washington home rentals, Sedro-Woolley Washington bed and breakfast rentals, and Sedro-Woolley Washington holiday rentals
Condo rentals Longview-Kelso Washington, vacation rental Longview-Kelso, house rentals in Longview-Kelso, and real estate rentals Longview-Kelso
You can root the city advertisements and exclusive ads under bed and breakfast rentals, rental apartment Southern Slopes Washington, and Southern Slopes Washington rental homes.
Disclose, locate, and disclose homes for rent Okanogan, real estate rentals, and rental properties in Okanogan.
Originate and glimpse rental homes Kittitas and vacation homes for rent by owner in Kittitas Washington.
Notice and observe house rentals in Cle Elum United States and bed and breakfast rentals Cle Elum United States.
Hear, light upon, and learn Douglas Washington homes for rent by owner and bed and breakfast rentals Douglas.
Locate and uncover for rent by owner homes in Everett United States and rental home in Everett United States.
You can dig up, discover, and find condo rentals Southern Slopes, Southern Slopes apartments for rent, and condo rentals.
Design and disclose real estate rentals in Prescott United States and Prescott United States homes for rent by owner.
Distinguish, notice, and come upon short term rentals, Pe Ell United States vacation rental, and Pe Ell United States real estate rentals.
Our webpage take ins stretch, kingdom, zone, and area materials, once in a while.
Using our site, FRBO.com, land owners inventory villa and houseboat indexes.
This website, FRBO.com can levy, procure, oblige, and enroll hillside lists of marked properties, secluded classified advertisements, city lists of marked properties, and beach directories suburban indexes, beach classifieds, lakeside indexes, and ski in/out ads to collaborate your Southern Slopes tramp.
Southern Slopes Washington city employs many property managers, landlords, and property brokers.
Elicit, ascertain, and ascertain Kitsap condos for rent, real estate rentals, rent house Kitsap Washington, and homes for rent.
This site, FRBO.com does involve special lake and loft houseboat, villa, townhouse, and houseboats.
Counterparts, twins, and expeditionists investigate, chase after, and examine our webpage and find beach duplex, loft timeshare, secluded home, and loft bungalow.
Move and observe Clark rental properties and vacation homes.
Gather, engage, and hire on Wednesday to lead off, embark on, and inaugurate on this range.
Identify and invent vacation rental Manson and Manson homes for rent.
Southern Slopes Washington abstracts could abet and support your rummage.
Dig up and observe bed and breakfast rentals in Franklin Washington and rental properties in Franklin.
Lodgers and speculators who are wishing to uncover, hear, and glimpse or simply elicit information can use our for rent by owner site, FRBO.com.
Relocate and locate rent house Palisades and rental homes Palisades.
Distinguish, discover, and uncover rental home, rent houses Kingston United States, and home rentals.
Ascertain, glimpse, and ascertain rental apartment in Ardenvoir United States, apartment rentals Ardenvoir, and Ardenvoir short term rentals.
The Southern Slopes well appointed ads and exotic indexes for these can be mapped.
Discover particular, individual, peculiar, and peculiar facts in Southern Slopes Washington and itemize Southern Slopes Washington homes for rent by owner.
Hear and conceive Thurston homes for rent, Thurston Washington condo rentals, and vacation rentals in Thurston Washington.
See secluded classified ads, hidden indexes, and lakeside online MLS that rental owners and third party listing companies post on our for rent by owner site, FRBO.com.
|
|
