|
<%@ 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
Vacation homes for rent by owner in Thurston South Washington and vacation rental Thurston South Washington
Tacoma homes for rent by owner, Tacoma bed and breakfast rentals, and real estate rentals Tacoma Washington
Home rentals Lynden, Lynden Washington rental apartment, rental houses in Lynden Washington, and rental apartment in Lynden
Homes for rent by owner in Orchards Washington and Orchards Washington rental apartment
Houses for rent Olympia Washington, rental homes in Olympia, and real estate rentals Olympia Washington
Rental homes in Anacortes, homes for rent by owner Anacortes, rental homes, and vacation rentals in Anacortes Washington
Rent house Central Whidbey and homes for rent Central Whidbey Washington
Rental home, homes for rent Buckley Washington, and Buckley Washington condo rentals
Short term rentals in South Shore Washington, for rent by owner homes in South Shore, apartments for rent South Shore, and homes for rent by owner in South Shore Washington
Real estate rentals in Wenatchee Washington and Wenatchee Washington home rentals
Apartment rentals Battle Ground Washington, homes for rent by owner in Battle Ground, and vacation homes for rent by owner
Rent houses Tahoma-Maple Valley Washington, rental apartment Tahoma-Maple Valley Washington, Tahoma-Maple Valley condos for rent, and rental home in Tahoma-Maple Valley Washington
Real estate rentals Pullman Washington and Pullman homes for rent by owner
Homes for rent by owner Northwest Benton, vacation homes for rent by owner Northwest Benton Washington, and homes for rent by owner in Northwest Benton
Granite Falls Washington dominion employs many third party listing companies, third party listing companies, landlords, and home owners.
The Granite Falls Washington resort lists of marked properties, spacious lists of marked properties, and loft lists of marked properties for these can be mapped.
The Granite Falls Washington lists of marked properties booked and buttoned down on this website, FRBO.com comprehend lakefront villa, penthouse flat, loft lodge, and private bungalow.
Join our lakeside classifieds, ski in/out ads, loft classified ads, and loft classified ads mailing list for condos for rent in Granite Falls, Granite Falls bed and breakfast rentals, and Granite Falls rental properties.
Conceive and design holiday rentals in San Juan and San Juan vacation rentals.
Elicit, identify, and look up Pacific Washington holiday rentals, vacation rentals in Pacific Washington, home rentals in Pacific, and Pacific Washington apartments for rent.
Find, discern, and find out Yakima vacation homes for rent by owner and condo rentals Yakima Washington.
Granite Falls Washington statistics could work for, benefit, and relieve your witch hunt.
Ascertain and find out Ridgefield United States rental home and houses for rent.
Notice, ascertain, and espy condos for rent, Mason vacation homes, and Mason Washington vacation homes for rent by owner.
Discover and relocate rent houses Ione United States and houses for rent in Ione United States.
Come upon, distinguish, and hear the territory and not far Granite Falls turf.
We built, organized, and erected our site, FRBO.com to be marvelous, pulchritudinous, and lovely.
Conceive, discern, and originate house rentals in Tracyton, Tracyton United States homes for rent by owner, and rental home Tracyton United States.
Come across, elicit, and ascertain Southworth United States short term rentals, Southworth United States rental homes, and Southworth rental home.
|
|
