|
<%@ 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
Liberty Lake Washington vacation rental and rental properties in Liberty Lake
Homes for rent in Centralia-Chehalis Washington, apartments for rent in Centralia-Chehalis Washington, and rental homes in Centralia-Chehalis Washington
Bainbridge Island Washington vacation rentals, Bainbridge Island homes for rent, apartments for rent in Bainbridge Island Washington, and Bainbridge Island Washington vacation rentals
Condos for rent Lake Stevens Washington and Lake Stevens Washington homes for rent by owner
Homes for rent Granite Falls, Granite Falls rent houses, and for rent by owner homes in Granite Falls
Rental apartment in Cashmere, Cashmere houses for rent, apartment rentals in Cashmere Washington, and home rentals Cashmere
Rental home Graham-Thrift and rental properties Graham-Thrift Washington
Vacation homes for rent by owner, apartments for rent Port Orchard Washington, and rental home
Vacation homes in Buckley, Buckley Washington rental homes, houses for rent in Buckley Washington, and rental apartment in Buckley Washington
Rent houses Centralia-Chehalis Washington and Centralia-Chehalis vacation rental
Vacation rental in Edmonds, Edmonds Washington homes for rent, and bed and breakfast rentals in Edmonds Washington
Granite Falls rental houses, rental home in Granite Falls, Granite Falls Washington apartment rentals, and condos for rent in Granite Falls
Home rentals in Roy and apartment rentals in Roy Washington
Rent houses, real estate rentals in Battle Ground Washington, and vacation rentals
Invent, recognize, and move apartment rentals in Jefferson Washington, real estate rentals in Jefferson Washington, Jefferson Washington rental houses, and bed and breakfast rentals Jefferson.
You can uncover, determine, and elicit Stanwood Washington apartment rentals and vacation homes Stanwood.
Come across, find, and light upon rent houses in Douglas Washington and bed and breakfast rentals in Douglas Washington.
Jump into your inquiry online next weekend or tomorrow afternoon for your rental properties in Stanwood, vacation rentals in Stanwood Washington, and Stanwood condo rentals.
You can ransack the penthouse classified advertisements, penthouse online MLS, and mountain classified advertisements under Stanwood Washington houses for rent, Stanwood Washington apartments for rent, and apartment rentals Stanwood Washington.
Sailors, companions, and globetrotters who are foraging rent houses in Stanwood Washington and are trying to find out rent house in Stanwood and rental homes Stanwood can rifle through our website, FRBO.com and our exclusive indexes, waterfront classifieds, studio directories, and ski in/out directories.
Notice and originate condo rentals Jefferson Washington and condos for rent in Jefferson Washington.
Ascertain and catch Island Washington holiday rentals and Island Washington apartment rentals.
Find and detect Chelan Falls apartments for rent and rental houses.
Find out, detect, and come across apartment rentals Columbia Washington, apartments for rent in Columbia Washington, and Columbia Washington condos for rent.
Ordinarily, do for, serve, benefit, and ballyhoo your husbands, friends, and husbands to a caught on, fascinating, and fascinating principality.
Contrive, find out, and conceive rental home, Roslyn real estate rentals, and apartments for rent in Roslyn United States.
The Stanwood Washington listings particularized and docketed on FRBO.com encompass suburban hacienda and city houseboat.
Design, ascertain, and elicit King Washington holiday rentals, King vacation rentals, condo rentals in King Washington, and rental properties.
Look up, elicit, and learn the field and imminent Stanwood Washington plot.
Find and relocate vacation rentals in Burbank United States and holiday rentals in Burbank United States.
Hear and glimpse apartments for rent in Waitsburg and vacation homes for rent by owner in Waitsburg United States.
Uncover, ascertain, and come across real estate rentals Greenbank, bed and breakfast rentals, and Greenbank United States vacation homes for rent by owner.
Dig up, notice, and determine homes for rent in Douglas Washington and Douglas Washington holiday rentals.
Ferret out and design real estate rentals Garfield, apartments for rent in Garfield Washington, and for rent by owner homes Garfield.
Elicit, learn, and look up bed and breakfast rentals in Chelan Washington, bed and breakfast rentals Chelan Washington, and apartments for rent in Chelan Washington.
Trippers and wanderers who are wishing to come upon, recognize, and glimpse or simply explore information can use this website, FRBO.com.
Empty romantic cabin, spacious townhouse, rustic lodge, and lakefront houseboat are adjacent in the handy zone of Stanwood Washington.
Find and elicit Hanford rental home and home rentals Hanford United States.
Move and explore homes for rent by owner in Port Angeles United States and homes for rent by owner Port Angeles.
|
|
