|
<%@ 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
Rent houses in Ephrata-Soap Lake Washington and Ephrata-Soap Lake Washington houses for rent
Burlington Washington rent houses, vacation rental in Burlington Washington, and houses for rent in Burlington Washington
Rental properties in Buckley Washington, houses for rent in Buckley Washington, rent house Buckley Washington, and apartments for rent in Buckley Washington
Roy Washington condos for rent and rent house Roy Washington
Clarkston Washington real estate rentals, vacation rental, and homes for rent by owner in Clarkston
Castle Rock Washington rental properties, condos for rent, bed and breakfast rentals in Castle Rock, and rental houses in Castle Rock
Mount Vernon vacation homes for rent by owner and Mount Vernon short term rentals
Vancouver Washington homes for rent, short term rentals in Vancouver Washington, and for rent by owner homes in Vancouver Washington
House rentals, rental homes in Olympia, Olympia Washington vacation homes, and vacation rental Olympia
Houses for rent and rental homes
Rental apartment Seattle, Seattle Washington short term rentals, and bed and breakfast rentals Seattle
Rental homes in Spokane Washington, Spokane Washington short term rentals, Spokane Washington for rent by owner homes, and condos for rent in Spokane Washington
You can design and disclose condos for rent Puyallup Washington and Puyallup Washington rental properties.
Take up your research online tomorrow evening, in the next few days, tomorrow, or in the next few days for your home rentals in Puyallup Washington and Puyallup Washington vacation rentals.
Move, discern, and originate Skagit apartment rentals and rental properties in Skagit Washington.
Puyallup property owners and land owners list rental properties in Puyallup Washington, Puyallup rent houses, rental homes Puyallup Washington, and short term rentals Puyallup.
Discover, discern, and debunk Uniontown United States rental houses, rental home Uniontown United States, and for rent by owner homes.
Discover and originate Graham condo rentals and rental houses in Graham United States.
Excursionists, schoolmates, and road warriors who are wishing to contrive and disclose or simply detect information can use this site, FRBO.com.
Originate and espy rental homes Skagit, Skagit rental apartment, and Skagit apartments for rent.
Puyallup Washington facts could do for, facilitate, and run interference your pursuing.
Recognize and devise condos for rent Clallam Washington, for rent by owner homes, and for rent by owner homes Clallam Washington.
Distinguish, locate, and espy home rentals Skagit, Skagit rent houses, house rentals in Skagit, and Skagit Washington rental home.
See mountain lists of marked properties, exotic ad directories, well appointed indexes, and oceanfront ads that home owners and real estate agents post on FRBO.com.
Recognize and discover Galvin vacation rental and rental houses in Galvin United States.
City online MLS and romantic classified ads apartments for rent in Grant Washington, bed and breakfast rentals in Grant Washington, real estate rentals Grant Washington, and homes for rent in Grant Washington.
Relocate, ascertain, and catch Whatcom Washington rental houses, apartment rentals Whatcom, and house rentals in Whatcom Washington.
The Puyallup Washington classified advertisements docketed and inserted on our website, FRBO.com encompass exotic house, penthouse duplex, and hidden townhouse.
Move and light upon Waitsburg apartments for rent and rental properties in Waitsburg.
Ascertain and determine the principality and near-at-hand Puyallup township.
Learn, observe, and ascertain Columbia Washington for rent by owner homes, rental houses in Columbia Washington, and rental homes in Columbia.
Explore, hear, and devise Seahurst United States real estate rentals, Seahurst United States bed and breakfast rentals, and vacation rental.
Pioneers and confreres hunt for and quest this extensive website, FRBO.com and detect city condominium, ski in/out apartment, and lake cabin.
Recognize and ferret out rent houses Mesa and rental houses Mesa United States.
Join our suburban classified ads, loft directories, oceanfront online MLS, and exotic online MLS mailing list for vacation rentals and Puyallup Washington real estate rentals.
|
|
