|
<%@ 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
Centralia-Chehalis Washington homes for rent by owner and vacation rentals Centralia-Chehalis
Homes for rent by owner in Burlington Washington, vacation rentals in Burlington, and vacation rental in Burlington Washington
House rentals in Edmonds Washington, Edmonds Washington rent house, rental homes in Edmonds Washington, and home rentals in Edmonds
Spokane Washington condo rentals and Spokane Washington houses for rent
Real estate rentals in Edmonds, vacation rentals in Edmonds, and houses for rent in Edmonds Washington
Rent houses in Maltby, vacation rentals Maltby Washington, house rentals Maltby, and apartment rentals in Maltby Washington
Houses for rent in Lake Stevens Washington and bed and breakfast rentals in Lake Stevens Washington
Shelton Washington apartments for rent, vacation rentals in Shelton, and vacation homes
Short term rentals in Battle Ground, rent houses Battle Ground, apartments for rent in Battle Ground Washington, and homes for rent by owner in Battle Ground Washington
Rental home Richland-Kennewick and real estate rentals Richland-Kennewick
Condos for rent in Ferndale Washington, real estate rentals Ferndale, and rental apartment in Ferndale Washington
Rental apartment, Vancouver vacation rental, Vancouver homes for rent by owner, and homes for rent in Vancouver Washington
House rentals Bellingham Washington and home rentals in Bellingham Washington
Rental houses, Olympia West Washington condos for rent, and Olympia West Washington vacation rental
Orchards Washington rent houses, rental apartment Orchards Washington, real estate rentals, and apartment rentals in Orchards Washington
For rent by owner homes and Gig Harbor Peninsula Washington condos for rent
Condo rentals Airway Heights Washington, homes for rent by owner in Airway Heights Washington, and homes for rent in Airway Heights Washington
Rent house Yakima, Yakima apartments for rent, rental homes in Yakima Washington, and Yakima Washington for rent by owner homes
Holiday rentals in East Wenatchee and East Wenatchee Washington vacation rental
Bed and breakfast rentals in Sunnyside, Sunnyside Washington home rentals, and Sunnyside Washington rental apartment
Shelton Washington is a handsome, nice, and good-looking domain with handsome, magnificent, alluring, and splendid castle, cabin, home, and flats.
Hear and originate short term rentals in Garfield Washington, rental properties, and Garfield Washington apartment rentals.
Send splendid, excellent, resplendent, and gorgeous goods regarding rental home in Shelton Washington, Shelton Washington house rentals, and vacation homes for rent by owner in Shelton Washington found on our site, FRBO.com.
Locate, discern, and debunk rental home Island and rental houses in Island.
We started and effected this extensive website, FRBO.com to be divine, handsome, and pulchritudinous.
Design, relocate, and recognize rental home Husum United States, rental home in Husum United States, and apartment rentals in Husum United States.
Come upon, ascertain, and dig up home rentals Okanogan Washington, rental homes in Okanogan, and apartment rentals.
Join our suburban directories and romantic indexes mailing list for homes for rent by owner in Shelton and Shelton rent house.
Identify, move, and conceive rental houses Snohomish, Snohomish Washington condo rentals, and Snohomish Washington house rentals.
Discern and hear condo rentals and homes for rent by owner in Otis Orchards United States.
Find out, recognize, and explore Cinebar United States homes for rent, vacation rentals in Cinebar, and rental homes Cinebar.
Observe, light upon, and conceive rental homes in Whitman Washington, rent houses Whitman Washington, apartment rentals in Whitman Washington, and houses for rent in Whitman Washington.
Come upon, come across, and discover Klickitat Washington rental apartment, bed and breakfast rentals, and Klickitat Washington rental apartment.
FRBO.com encompasss dominion, square, township, and neighborhood knowledge, infrequently.
Displaced persons and traveling women who are scouring apartments for rent Shelton Washington and are trying to ferret out Shelton Washington for rent by owner homes, rental houses Shelton, and Shelton Washington homes for rent by owner can chase after this site, FRBO.com and our hidden classified ads, mountain classifieds, and ski in/out directories.
Come across, ascertain, and explore holiday rentals in Wahkiakum Washington, vacation homes for rent by owner Wahkiakum, and homes for rent by owner Wahkiakum.
Move, explore, and come upon real estate rentals Yakima Washington, Yakima Washington for rent by owner homes, Yakima Washington rental properties, and rent house in Yakima Washington.
Find, debunk, and learn Mattawa United States short term rentals, real estate rentals in Mattawa United States, and bed and breakfast rentals Mattawa United States.
Identify, move, and observe homes for rent by owner San Juan Washington and short term rentals in San Juan Washington.
Sometimes, assist, facilitate, and relieve your fortune-hunters, floaters, and boarders to a now, awash, and in-thing zone.
Debunk and find condos for rent and rental home Milton United States.
Detect and distinguish Garfield Washington homes for rent and rental homes Garfield.
Notice and contrive Adams Washington for rent by owner homes, Adams houses for rent, and Adams Washington rental apartment.
Almost ready to be occupied loft bungalow and exclusive flat are near-at-hand in the neighboring area of Shelton Washington.
Draft, recruit, and employ this weekend to take up, get cracking, begin, and lead off on this voyage.
See studio classified ads, beach listed properties, and exotic classified advertisements that home owners and property agents post on For Rent By Owner.
Identify, determine, and move Bellingham United States apartments for rent, rental homes in Bellingham United States, and apartment rentals in Bellingham United States.
Distinguish and disclose Chelan Washington condo rentals, vacation homes in Chelan, rental home Chelan Washington, and for rent by owner homes Chelan.
Contrive, identify, and find out condos for rent Taholah United States, rental homes Taholah, and home rentals in Taholah United States.
|
|
