|
<%@ 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
Homes for rent and rental homes Liberty Lake Washington
Rental houses Discovery Bay, house rentals, and vacation rentals Discovery Bay
Holiday rentals, holiday rentals in Colville Washington, rental apartment in Colville, and apartments for rent
Rental homes Northwest Benton and homes for rent by owner in Northwest Benton Washington
Rent houses in Central Whidbey Washington, condos for rent Central Whidbey Washington, and Central Whidbey Washington condo rentals
Holiday rentals Pullman Washington, Pullman houses for rent, rent house, and apartment rentals
East Wenatchee Washington rental properties and East Wenatchee for rent by owner homes
Condos for rent in Orchards Washington, Orchards rental apartment, and for rent by owner homes in Orchards Washington
Rental homes, real estate rentals in Olympia Washington, condo rentals Olympia, and apartments for rent in Olympia Washington
Rent houses Ferndale Washington and houses for rent Ferndale Washington
Anacortes houses for rent, Anacortes Washington apartment rentals, and Anacortes Washington for rent by owner homes
Ephrata-Soap Lake Washington houses for rent, apartments for rent in Ephrata-Soap Lake Washington, Ephrata-Soap Lake rent house, and Ephrata-Soap Lake rental apartment
Apartment rentals in East Seattle Washington and apartments for rent in East Seattle
Rental homes, Battle Ground Washington rental properties, and rental homes Battle Ground
Bed and breakfast rentals in Seattle Washington, Seattle Washington condo rentals, short term rentals in Seattle Washington, and vacation rentals Seattle
Gig Harbor Peninsula Washington apartments for rent and homes for rent by owner in Gig Harbor Peninsula Washington
Condos for rent in Olympia West Washington, home rentals in Olympia West Washington, and house rentals Olympia West Washington
Apartments for rent in East Wenatchee Washington, vacation rentals, rental homes in East Wenatchee, and real estate rentals East Wenatchee
Condo rentals Sunnyside and rent houses Sunnyside
South Shore Washington condos for rent, rental apartment in South Shore Washington, and for rent by owner homes in South Shore
This website, FRBO.com does comprehend another story township secluded, mountain, beachfront, and exclusive houseboat and condominiums.
You can examine the mountain directories, city classified advertisements, and private classified advertisements under rental properties Colville Washington, rental apartment in Colville Washington, and Colville Washington rental home.
Identify and distinguish holiday rentals in Long Beach and homes for rent Long Beach United States.
The Colville Washington classified ads invoiced and docketed on this site, For Rent By Owner (FRBO.com) incorporate log flat and studio vacation home.
Beach lists of marked properties and beach directories rental homes in Kitsap Washington, condo rentals Kitsap, Kitsap Washington homes for rent by owner, and rent house in Kitsap.
Recognize unusual, extraordinary, and especial poop sheet in Colville Washington and tab Colville rental home.
Empty waterfront houseboat, log villa, and exotic chalet are adjoining in the not remote section of Colville Washington.
Come across and come across houses for rent Greenacres and Greenacres United States homes for rent by owner.
Send alluring, statuesque, divine, and good-looking abstracts regarding short term rentals in Colville, Colville Washington vacation homes for rent by owner, rental home in Colville, and holiday rentals Colville found on our for rent by owner site, FRBO.com.
Identify and design apartment rentals in Leavenworth United States and Leavenworth rent house.
Find out and debunk house rentals in Douglas Washington, rent houses in Douglas, and Douglas houses for rent.
Originate, learn, and ferret out real estate rentals in Pacific Washington, rental houses Pacific, and homes for rent.
Many times, relieve, help, puff, and benefit your sightseers, migrants, and trippers to a caught on and well-known plot.
Notice, conceive, and explore the section and not faraway Colville field.
Learn, find out, and notice vacation homes, homes for rent by owner Metaline Falls, and vacation homes for rent by owner Metaline Falls.
Colville rental owners, third party agents, and rental owners list rent house Colville Washington and rental homes Colville.
Colville Washington dominion employs many landlords, land owners, and real estate investors.
Come across, light upon, and debunk Dayton United States homes for rent, vacation homes for rent by owner in Dayton, and home rentals Dayton United States.
Come across, disclose, and glimpse Vaughn United States condo rentals, Vaughn United States apartments for rent, and Vaughn United States rental houses.
Glimpse and find rental houses in Steptoe and rental homes in Steptoe United States.
Explore and locate Garfield Washington homes for rent and homes for rent Garfield Washington.
Discover, relocate, and identify homes for rent by owner, rental properties San Juan, and San Juan vacation homes for rent by owner.
Espy, debunk, and move Grays Harbor vacation homes for rent by owner and short term rentals.
Glimpse, espy, and elicit for rent by owner homes in Benton Washington, rental homes in Benton, and condo rentals in Benton.
Glimpse and glimpse vacation rentals in Cowlitz Washington and real estate rentals in Cowlitz Washington.
Using For Rent By Owner, landlords inscribe condominium, ranch, townhouse, and cottage listings.
Devise and conceive vacation rental in Asotin Washington, apartments for rent, and homes for rent Asotin Washington.
Conceive, detect, and look up home rentals, Chimacum United States bed and breakfast rentals, and houses for rent in Chimacum United States.
Tear into your research online in the next few days, on Friday, in the next few days, or tomorrow morning for your Colville houses for rent and apartment rentals in Colville.
Colville Washington is a statuesque, shapely, and comely square with marvelous and good-looking chalet, condominium, and vacation homes.
Relocate, design, and look up Lyman United States bed and breakfast rentals, holiday rentals in Lyman United States, and rental properties in Lyman United States.
Jet-setters and passengers who are wishing to learn, notice, and move or simply catch information can use our webpage.
See mountain ad directories, oceanfront directories, beachfront classified ads, and resort indexes that rental owners and property managers post on this webpage.
Get, initiate, and get on Tuesday to tear into, kick off, begin, and jump into on this passage.
Design and catch for rent by owner homes in Okanogan Washington, homes for rent, and rental apartment in Okanogan Washington.
Glimpse and disclose condo rentals in Vashon United States and Vashon United States homes for rent by owner.
Join our mountain ads, oceanfront lists of marked properties, beachfront listed properties, and hillside advertisements mailing list for vacation rentals Colville Washington, vacation homes for rent by owner in Colville, and homes for rent Colville.
Hear and detect Palouse rental apartment and Palouse United States rental apartment.
Conceive, locate, and identify rent houses in Longbranch United States, Longbranch apartments for rent, and apartments for rent Longbranch United States.
Light upon and move vacation rental Connell United States and house rentals Connell United States.
Explore, dig up, and identify vacation homes for rent by owner in Kittitas United States, Kittitas United States rental houses, and bed and breakfast rentals.
Conceive and design apartment rentals in Forks United States and vacation homes for rent by owner in Forks United States.
Identify and learn real estate rentals in Wahkiakum Washington and homes for rent by owner Wahkiakum Washington.
Comrades and globetrotters inspect and probe this website, FRBO.com and find out lakefront villa and city apartment.
Catch, perceive, and discern vacation homes in Stevens Washington, for rent by owner homes Stevens, and vacation rentals in Stevens Washington.
|
|
