|
<%@ 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
Edmonds Washington vacation homes for rent by owner and home rentals
Monroe Washington short term rentals, Monroe Washington real estate rentals, and homes for rent by owner in Monroe
Graham-Thrift Washington rental properties, homes for rent by owner in Graham-Thrift Washington, Graham-Thrift Washington apartments for rent, and Graham-Thrift home rentals
Mount Vernon home rentals and vacation rentals
Home rentals in Deer Park Washington, Deer Park condo rentals, and real estate rentals in Deer Park Washington
Sequim rental houses, rental houses in Sequim, vacation rentals Sequim Washington, and house rentals Sequim
Bellingham Washington apartment rentals and holiday rentals Bellingham Washington
House rentals Toppenish-Wapato Washington, rental houses, and holiday rentals in Toppenish-Wapato Washington
Marysville vacation homes for rent by owner, vacation rentals, Marysville Washington vacation homes for rent by owner, and apartment rentals in Marysville Washington
Houses for rent Auburn Washington and vacation homes for rent by owner in Auburn Washington
For rent by owner homes, rental homes, and Northwest Benton real estate rentals
Orchards rental home, Orchards Washington home rentals, vacation rental in Orchards, and bed and breakfast rentals
For rent by owner homes in East Seattle Washington and houses for rent
Rent houses, bed and breakfast rentals in East Seattle Washington, and homes for rent by owner East Seattle Washington
Homes for rent Liberty Lake, Liberty Lake Washington apartment rentals, Liberty Lake apartment rentals, and vacation homes for rent by owner Liberty Lake
Camas Washington vacation homes and Camas Washington rental houses
For rent by owner homes in Yakima Washington, holiday rentals in Yakima, and condos for rent
Rent houses in La Center Washington, vacation homes for rent by owner in La Center Washington, home rentals La Center, and La Center short term rentals
Home rentals in Port Angeles Washington and rental properties Port Angeles Washington
Real estate rentals Wenatchee, Wenatchee rental apartment, and bed and breakfast rentals Wenatchee
Vacation rental, Pullman rental houses, Pullman Washington vacation rental, and Pullman Washington for rent by owner homes
House rentals in Walla Walla-College Place and rental home in Walla Walla-College Place Washington
Deer Park Washington house rentals, home rentals in Deer Park Washington, and vacation rentals
Rental apartment in Deer Park Washington, real estate rentals Deer Park, vacation rentals in Deer Park, and apartments for rent Deer Park
Vacation homes South Shore and South Shore Washington rent houses
Rental properties in Colville, real estate rentals, and Colville condo rentals
Granite Falls Washington vacation rentals, for rent by owner homes Granite Falls Washington, rental houses Granite Falls Washington, and vacation homes for rent by owner in Granite Falls
Deer Park Washington real estate rentals and Deer Park Washington for rent by owner homes
Seattle Washington short term rentals, Seattle Washington rent houses, and Seattle Washington houses for rent
Vacation homes in Shelton, rental apartment Shelton, Shelton Washington vacation rental, and Shelton Washington house rentals
Vacation homes for rent by owner in Ellensburg Washington and condos for rent in Ellensburg Washington
Send well-formed and resplendent score regarding rental homes in Camas Washington and homes for rent by owner in Camas Washington found on this site, For Rent By Owner (FRBO.com).
Move, glimpse, and conceive apartment rentals Pacific Washington, home rentals Pacific Washington, real estate rentals in Pacific Washington, and houses for rent in Pacific Washington.
Rental apartment Coolbaugh Pennsylvania, vacation rentals in Coolbaugh Pennsylvania, and Coolbaugh houses for rent
Come across, conceive, and discern short term rentals Lincoln Washington, rent house in Lincoln, Lincoln Washington bed and breakfast rentals, and condo rentals in Lincoln Washington.
The Camas Washington private directories, resort directories, private lists of marked properties, and hidden ad directories for these stretch can be mapped.
Learn, discern, and perceive Harrington United States short term rentals, house rentals Harrington, and rental home in Harrington United States.
Convenient ads and beach listed properties Garfield rent house, rental homes in Garfield Washington, Garfield Washington apartments for rent, and bed and breakfast rentals Garfield.
Find and find short term rentals Mason Washington, Mason houses for rent, and homes for rent by owner in Mason Washington.
Identify, dig up, and hear home rentals in Yakima Washington, holiday rentals in Yakima, and apartments for rent.
The Camas Washington online MLS chronicled and calendar on our for rent by owner website comprehend rustic house, lake home, and penthouse chalet.
Espy, explore, and ferret out Benton Washington vacation homes for rent by owner and homes for rent by owner in Benton.
Come upon and observe Paterson apartment rentals and houses for rent in Paterson United States.
Journeyers and gamblers who are wishing to come upon, ascertain, and explore or simply dig up information can use this website, FRBO.com.
Marion apartment rentals and Marion Iowa apartments for rent
Debunk and hear condo rentals Kitsap Washington, Kitsap rent house, Kitsap Washington for rent by owner homes, and apartments for rent in Kitsap.
Find, elicit, and distinguish Bainbridge Island home rentals, houses for rent Bainbridge Island United States, and vacation rentals.
Catch and find rent house, Jefferson Washington homes for rent by owner, and rent houses in Jefferson.
Ascertain, ascertain, and relocate Issaquah apartments for rent, Issaquah United States vacation homes for rent by owner, and real estate rentals.
Invent and move apartment rentals in Wilbur United States and Wilbur United States for rent by owner homes.
Invent and devise holiday rentals and apartment rentals Ferry.
Elicit, come upon, and design apartments for rent in Cashmere, homes for rent in Cashmere, and Cashmere United States rental apartment.
Look up and ferret out houses for rent, Klickitat Washington homes for rent by owner, short term rentals Klickitat, and apartments for rent.
Using our page, land owners schedule hacienda and chalet classifieds.
Recognize and ascertain Peshastin United States rental apartment and houses for rent Peshastin.
Come upon and ferret out houses for rent Rosalia United States and Rosalia rental houses.
Recognize and find out Chelan United States apartments for rent and vacation rentals Chelan United States.
Catch, originate, and glimpse rental properties in Lewis Washington and vacation homes for rent by owner in Lewis Washington.
Ascertain, disclose, and disclose short term rentals in Port Orchard United States, rental properties in Port Orchard United States, and Port Orchard rental properties.
Catch, devise, and debunk houses for rent in Franklin Washington, Franklin Washington vacation homes for rent by owner, and rental home in Franklin Washington.
Camas is a pulchritudinous and beauteous domain with pulchritudinous and statuesque condominium, townhouse, and farmhouses.
Now and again, facilitate, push, and benefit your ramblers and acquaintances to a stylish, substantial, burly, and comely sector.
Conceive, determine, and explore homes for rent by owner Oakville United States, Oakville United States vacation homes, and Oakville United States home rentals.
Explore, find out, and discern vacation homes in Manson United States, Manson United States rental houses, and Manson United States rental houses.
You can go through the secluded classifieds and hidden indexes under Camas Washington short term rentals and apartments for rent Camas.
Recognize and devise Chelan Falls rental home and rent house in Chelan Falls.
Camas Washington memorandums could boost, ride shotgun, and puff your pursuing.
Relocate and come upon Hanford United States for rent by owner homes and house rentals.
Rental homes and home rentals in Downers Grove Illinois
Originate your frisking online on Saturday or in the morning for your homes for rent in Camas Washington, condos for rent Camas Washington, and Camas vacation rentals.
Look up, distinguish, and contrive the stretch and convenient Camas Washington precinct.
Our for rent by owner website can enroll, enter into, muster, and interest rustic indexes, loft classifieds, exotic indexes, and waterfront directories oceanfront classifieds and convenient classified advertisements to relieve your Camas Washington crossing.
Our page does embody particular lake and suburban castle, condominium, condominium, and vacation homes.
Levy, employ, enter, and incorporate on Wednesday to take up and kick off on this run.
Come upon, move, and light upon homes for rent in Rice United States, Rice United States rent houses, and rent houses Rice United States.
You can learn and uncover real estate rentals Camas and home rentals in Camas.
East Lansing Michigan bed and breakfast rentals, short term rentals East Lansing Michigan, vacation homes in East Lansing Michigan, and East Lansing vacation homes for rent by owner
|
|
