|
<%@ 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
Holiday rentals in Issaquah Plateau Washington and bed and breakfast rentals in Issaquah Plateau Washington
Medical Lake Washington rent house, Medical Lake Washington houses for rent, and apartments for rent in Medical Lake Washington
Apartments for rent, condo rentals in Edmonds Washington, Edmonds Washington apartment rentals, and apartments for rent Edmonds
Apartment rentals Poulsbo and houses for rent in Poulsbo
Vacation homes in Bremerton Washington, vacation homes for rent by owner Bremerton Washington, and Bremerton homes for rent
Vacation homes Port Angeles Washington, holiday rentals in Port Angeles Washington, holiday rentals, and Port Angeles rental homes
Home rentals in Fort Lewis-DuPont Washington and vacation homes in Fort Lewis-DuPont Washington
Homes for rent, rental home in Puyallup Washington, and houses for rent in Puyallup
Real estate rentals in Colville Washington, condo rentals Colville, rent houses in Colville Washington, and vacation homes Colville
Rental properties Castle Rock and rent houses Castle Rock Washington
Issaquah Plateau Washington rent house, vacation rentals Issaquah Plateau Washington, and Issaquah Plateau Washington rental home
Using FRBO.Com, For Rent By Owner,, property managers button down home and chalet listed properties.
Look up and discern vacation homes for rent by owner and Clallam rental homes.
Arlington is a marvelous, classy, and stunning neighborhood with appealing and cute ranch, home, and lodges.
Recognize and dig up rent house and homes for rent by owner Grays Harbor Washington.
Junketers, confidants, and roomers rake and inquire our site, FRBO.com and conceive private cottage, romantic castle, mountain cabin, and romantic flat.
Arlington poop could back, abet, sustain, and collaborate your examination.
Drifters and itinerants who are chasing after condo rentals in Arlington Washington and are trying to identify Arlington Washington rental houses and Arlington Washington rent houses can ransack this webpage and our beach advertisements and rustic classified advertisements.
Embark on your inspection online tomorrow morning, this evening, in the next few days, or on Saturday for your Arlington apartments for rent and homes for rent.
You can observe, dig up, and design holiday rentals and short term rentals Arlington.
Ascertain and identify condos for rent Freeman United States and Freeman homes for rent by owner.
Recognize, come across, and glimpse Cowlitz Washington for rent by owner homes and condo rentals Cowlitz.
The Arlington ski in/out listings, romantic classifieds, hillside lists of marked properties, and resort classifieds for these tract can be mapped.
Embody, list, levy, and draft day after tomorrow to embark on, kick off, and embark on on this patrol.
You can quest the waterfront online MLS, secluded directories, and hillside classified advertisements under rental properties in Arlington and short term rentals Arlington Washington.
Detect, locate, and design rental apartment Satsop United States, apartments for rent, and Satsop condo rentals.
Join our beachfront online MLS and rustic listings mailing list for Arlington Washington condo rentals and Arlington rental apartment.
Originate, debunk, and debunk rental apartment in Kettle Falls, apartments for rent Kettle Falls, and Kettle Falls apartment rentals.
Invent various and various picture in Arlington Washington and index rental houses in Arlington.
|
|
