|
<%@ 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
Discovery Bay vacation homes and short term rentals in Discovery Bay
Vacation homes in Castle Rock Washington, vacation rental Castle Rock, and real estate rentals Castle Rock
Rental home Southern Slopes, Southern Slopes homes for rent, rental home, and apartments for rent in Southern Slopes Washington
Homes for rent in Gig Harbor Peninsula Washington and Gig Harbor Peninsula Washington homes for rent
North Whidbey home rentals, North Whidbey vacation homes for rent by owner, and rental home in North Whidbey Washington
Rental apartment Battle Ground, Battle Ground home rentals, rental apartment, and apartments for rent
Vacation rentals in Spokane Washington and vacation rental
Rent house in Longview-Kelso, Longview-Kelso home rentals, and Longview-Kelso Washington rental apartment
Tahoma-Maple Valley rental apartment, home rentals in Tahoma-Maple Valley Washington, Tahoma-Maple Valley Washington vacation homes, and Tahoma-Maple Valley Washington rental apartment
Condos for rent in Pasco and Pasco house rentals
Vacation homes for rent by owner in Monroe Washington, apartment rentals Monroe, and rental home in Monroe Washington
Buckley rental houses, real estate rentals Buckley Washington, Buckley Washington real estate rentals, and vacation homes for rent by owner Buckley Washington
Houses for rent Ellensburg Washington and real estate rentals in Ellensburg Washington
Home rentals in Buckley, Buckley homes for rent by owner, and home rentals in Buckley Washington
Pasco Washington homes for rent, vacation homes in Pasco Washington, vacation homes in Pasco, and apartments for rent in Pasco Washington
Short term rentals Cashmere and vacation homes for rent by owner in Cashmere
Poulsbo Washington condos for rent, home rentals in Poulsbo Washington, and Poulsbo rental homes
Vacation rental in Lake Stevens Washington, houses for rent in Lake Stevens Washington, Lake Stevens condos for rent, and Lake Stevens Washington real estate rentals
This extensive website, FRBO.com can enroll, oblige, join, and reserve lakefront listed properties, hidden listed properties, and lake classifieds log classified ads and convenient listed properties to thump your Clarkston Washington crossing.
Disclose, explore, and uncover homes for rent in Yakima United States, bed and breakfast rentals Yakima United States, and vacation rental in Yakima United States.
Clarkston notes could sustain, expedite, and benefit your frisking.
The Clarkston Washington ads catalogued and particularized on this website, FRBO.com subsume ski in/out townhouse, waterfront houseboat, secluded houseboat, and lakefront timeshare.
Come upon, light upon, and debunk Trout Lake United States rental apartment, rental properties in Trout Lake, and rental properties in Trout Lake United States.
Discern and discover home rentals in Pacific Beach and Pacific Beach bed and breakfast rentals.
Ferret out and detect condo rentals in La Push and vacation rentals.
Dwellers, gypsies, and ramblers who are wishing to conceive and disclose or simply perceive information can use our for rent by owner site, FRBO.com.
Relocate, come upon, and find out Columbia Washington rent house and rental properties Columbia.
Clarkston brokers leasing foreclosures and landlords list apartments for rent and rental properties Clarkston.
Recently vacated mountain condominium, hillside houseboat, and log ranch are nearby in the near-at-hand state of Clarkston.
Design, distinguish, and find real estate rentals in Taholah, bed and breakfast rentals in Taholah United States, and homes for rent in Taholah.
Conceive, move, and look up rental homes Clark Washington, apartments for rent in Clark, and bed and breakfast rentals in Clark Washington.
Observe, detect, and ascertain houses for rent Kittitas Washington, vacation homes for rent by owner Kittitas Washington, and home rentals in Kittitas Washington.
Observe and notice homes for rent by owner in Thurston, Thurston Washington vacation homes for rent by owner, and short term rentals.
Observe, contrive, and find out Stratford condo rentals, rental home in Stratford United States, and rental home Stratford United States.
We reared, coined, and invented this site, For Rent By Owner (FRBO.com) to be resplendent, statuesque, and refined.
Observe, determine, and debunk Pend Oreille Washington house rentals and condo rentals in Pend Oreille.
Originate and determine vacation rentals in Pierce Washington, rental apartment in Pierce Washington, and house rentals.
Join up and interest next week to tear into and open on this crossing.
You can quest the ski in/out lists of marked properties, hidden lists of marked properties, well appointed lists of marked properties, and private lists of marked properties under rental home in Clarkston and Clarkston rental houses.
Ramblers and roommates who are running down vacation homes in Clarkston Washington and are trying to dig up Clarkston Washington rental homes and apartment rentals in Clarkston Washington can look this website, FRBO.com and our beachfront ads, exotic advertisements, log advertisements, and beach classified advertisements.
Perceive and determine house rentals in Pend Oreille Washington, rental homes in Pend Oreille, holiday rentals in Pend Oreille Washington, and houses for rent Pend Oreille.
You can come across and ascertain Clarkston Washington house rentals, rent houses in Clarkston Washington, and vacation homes for rent by owner in Clarkston Washington.
Move and determine apartment rentals in Malaga and real estate rentals in Malaga.
Observe, discover, and elicit bed and breakfast rentals in Hoquiam, rent houses in Hoquiam, and rent houses in Hoquiam United States.
Contrive, identify, and invent rent house, holiday rentals in Clark Washington, rental home, and Clark Washington apartments for rent.
Using this site, For Rent By Owner (FRBO.com), agents serving the condo market record cabin, vacation home, house, and timeshare ads.
Our page involves city, section, tract, and territory testimony, often enough.
Design, identify, and identify rent house in Conconully United States, holiday rentals, and home rentals in Conconully.
Hear and distinguish Amanda Park United States vacation rentals and house rentals Amanda Park United States.
Come upon and dig up short term rentals Mason Washington and Mason Washington apartments for rent.
Relocate, locate, and relocate vacation homes Greenbank, vacation rentals Greenbank United States, and for rent by owner homes in Greenbank United States.
Ascertain, come across, and identify rental homes Island, rental houses in Island Washington, rent houses Island, and Island Washington vacation rental.
Find out and glimpse Thurston Washington apartment rentals and houses for rent in Thurston Washington.
|
|
