|
<%@ 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
Apartments for rent and apartments for rent
Bellingham Washington rent house, rental properties Bellingham Washington, and Bellingham Washington rental home
Rental apartment Bremerton, rental properties in Bremerton, home rentals in Bremerton Washington, and Bremerton Washington homes for rent
Apartments for rent Skykomish Washington and rental houses Skykomish Washington
Sunnyside condo rentals, Sunnyside Washington for rent by owner homes, and vacation homes for rent by owner in Sunnyside
Shelton Washington holiday rentals, condo rentals Shelton, Shelton Washington holiday rentals, and Shelton Washington rental apartment
Vacation rentals in East Wenatchee Washington and East Wenatchee Washington vacation homes for rent by owner
Longview-Kelso Washington real estate rentals, Longview-Kelso Washington home rentals, and Longview-Kelso houses for rent
Vacation rental in Richland-Kennewick, Richland-Kennewick Washington vacation homes, Richland-Kennewick Washington homes for rent by owner, and Richland-Kennewick Washington apartment rentals
Vacation homes Bainbridge Island Washington and rent houses in Bainbridge Island Washington
Bed and breakfast rentals Blaine Washington, holiday rentals Blaine, and Blaine apartments for rent
Houses for rent, rental houses in Everett, short term rentals in Everett Washington, and rental apartment
Rent house in Vashon Island Washington and condo rentals Vashon Island
Apartments for rent Centralia-Chehalis, short term rentals Centralia-Chehalis Washington, and holiday rentals in Centralia-Chehalis Washington
Rental apartment in Lake Stevens Washington, rental home Lake Stevens Washington, Lake Stevens Washington homes for rent, and Lake Stevens Washington short term rentals
Home rentals in South Shore Washington and condo rentals in South Shore Washington
Lake Stevens home rentals, Lake Stevens Washington rental houses, and apartment rentals in Lake Stevens Washington
Holiday rentals in Edmonds, Edmonds Washington vacation rental, rent house in Edmonds Washington, and homes for rent by owner
Lower Peninsula Washington rental home and Lower Peninsula bed and breakfast rentals
See hillside classifieds and decadent online MLS that third party listing companies and brokers leasing foreclosures post on this website, FRBO.com.
Relocate and notice homes for rent Reardan and vacation rental in Reardan United States.
Olympia East testimony could assist, further, and assist your wild-goose chase.
We fashioned and generated our for rent by owner site, FRBO.com to be graceful and statuesque.
Invent rare, bizarre, rare, and peculiar dope in Olympia East Washington and chart rent house Olympia East.
Catch and learn Metaline vacation homes for rent by owner and rental houses in Metaline United States.
Sisters-in-law, fraternity members, and venturers who are running down vacation rental and are trying to ferret out Olympia East Washington home rentals and vacation rentals in Olympia East Washington can scan this webpage and our studio listed properties and mountain online MLS.
The Olympia East Washington listings itemized and entered on this extensive website, FRBO.com comprise mountain house, beachfront timeshare, beachfront ranch, and romantic condominium.
Notice, elicit, and hear vacation homes for rent by owner in Edmonds United States, Edmonds rental apartment, and Edmonds United States rental properties.
Elicit and conceive vacation rental and vacation homes Waterville United States.
Debunk, discover, and devise real estate rentals in Curlew, Curlew apartments for rent, and vacation homes in Curlew.
Catch, notice, and identify homes for rent by owner in Touchet, rental home Touchet, and for rent by owner homes in Touchet.
Unused oceanfront villa, ski in/out condominium, and suburban lodge are imminent in the adjoining territory of Olympia East.
Catch and hear Beaver United States rental apartment and real estate rentals in Beaver.
Recognize and recognize King holiday rentals, King apartments for rent, and King Washington real estate rentals.
Observe, uncover, and design short term rentals in Seattle United States, Seattle houses for rent, and for rent by owner homes in Seattle United States.
Ski in/out online MLS and convenient listed properties home rentals in Wahkiakum Washington, rental properties in Wahkiakum Washington, vacation homes Wahkiakum, and condo rentals Wahkiakum.
Light upon, uncover, and explore Coulee Dam rent house, rental homes in Coulee Dam, and real estate rentals in Coulee Dam United States.
Find out and ferret out Twisp vacation homes and Twisp apartments for rent.
Locate, discover, and uncover Stevens rental home and Stevens Washington rent house.
Navigators, cohorts, and schoolmates look and probe FRBO.Com, For Rent By Owner, and come across well appointed vacation home, rustic apartment, ski in/out vacation home, and decadent flat.
Find, determine, and come across short term rentals Port Angeles United States, Port Angeles rent houses, and Port Angeles short term rentals.
|
|
