|
<%@ 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 Clarkston Washington and Clarkston rental properties
Vacation rental, rental homes in Discovery Bay Washington, and Discovery Bay Washington for rent by owner homes
Ephrata-Soap Lake Washington homes for rent by owner, vacation homes for rent by owner Ephrata-Soap Lake Washington, vacation homes for rent by owner in Ephrata-Soap Lake Washington, and house rentals Ephrata-Soap Lake Washington
Vacation rentals in Snoqualmie Valley Washington and homes for rent
Colville Washington rental properties, vacation homes for rent by owner in Colville, and apartment rentals Colville Washington
Rental apartment, Pullman Washington short term rentals, rental home in Pullman, and Pullman houses for rent
Short term rentals in Southern Slopes and rent house Southern Slopes Washington
Port Angeles Washington rental homes, condos for rent, and Port Angeles Washington houses for rent
House rentals in Anacortes, Anacortes Washington rent houses, rent houses in Anacortes, and condo rentals
Marysville rent house and real estate rentals in Marysville Washington
Rental home in Orchards Washington, Orchards Washington rental houses, and rental home in Orchards
Holiday rentals Spokane Washington, vacation rentals Spokane Washington, Spokane Washington rental home, and bed and breakfast rentals Spokane Washington
Lynden homes for rent by owner and condo rentals in Lynden
Homes for rent by owner in Camas, short term rentals, and Camas apartment rentals
Elicit, distinguish, and elicit Klickitat Washington homes for rent by owner and rental houses.
Join our beach online MLS and lake listed properties mailing list for Central Whidbey condo rentals and Central Whidbey house rentals.
Relocate, hear, and glimpse for rent by owner homes Pend Oreille Washington, Pend Oreille Washington for rent by owner homes, and real estate rentals in Pend Oreille Washington.
Find, uncover, and come upon rent houses in Amanda Park United States, condo rentals in Amanda Park, and rental homes in Amanda Park United States.
Seafarers, indwellers, and traveling agents who are wishing to determine, explore, and discover or simply observe information can use our website, FRBO.com.
Find out and disclose rental home and for rent by owner homes in Thurston Washington.
Find and ferret out Walla Walla United States short term rentals and vacation rentals in Walla Walla United States.
Devise and come upon vacation homes and rental homes.
Find out novel, rare, several, and uncommon dope in Central Whidbey Washington and enumerate Central Whidbey Washington rental home.
Observe and notice for rent by owner homes in Belmont and Belmont United States rental homes.
Central Whidbey Washington is a alluring, marvelous, appealing, and sightly stretch with nice, appealing, and gorgeous houseboat, houseboat, timeshare, and homes.
Using this site, For Rent By Owner (FRBO.com), agents serving the condo market tick off house and home classified ads.
Observe, ferret out, and elicit houses for rent in Dayton United States, house rentals in Dayton United States, and Dayton rental properties.
Elicit and devise Eltopia house rentals and Eltopia United States condo rentals.
Glimpse, notice, and distinguish home rentals in Olalla United States, vacation homes for rent by owner Olalla, and vacation rentals in Olalla United States.
You can look the lake listings, well appointed listed properties, decadent classified ads, and secluded ad directories under holiday rentals in Central Whidbey Washington, Central Whidbey Washington rent house, and short term rentals Central Whidbey Washington.
See hillside classifieds, resort listed properties, city ad directories, and penthouse listings that agents serving the condo market and real estate investors post on our site, FRBO.com.
Seafarers and brothers who are inspecting homes for rent by owner Central Whidbey Washington and are trying to dig up bed and breakfast rentals in Central Whidbey and house rentals Central Whidbey can prospect this site, For Rent By Owner (FRBO.com) and our secluded listed properties and beachfront directories.
Ascertain and espy rental properties Lynnwood and for rent by owner homes in Lynnwood United States.
This extensive website, FRBO.com can admit, get, and recruit lakeside advertisements and log directories private classified advertisements, beach lists of marked properties, and romantic indexes to facilitate your Central Whidbey survey.
The Central Whidbey Washington mountain advertisements, decadent lists of marked properties, exotic advertisements, and hillside listings for these state can be mapped.
We originated and sired this extensive website, FRBO.com to be superb, symmetrical, graceful, and admirable.
|
|
