|
<%@ 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
Thurston South houses for rent and Thurston South Washington real estate rentals
Real estate rentals Olympia West Washington, rental properties Olympia West, and vacation homes for rent by owner in Olympia West
North Whidbey Washington apartment rentals, rent house North Whidbey, homes for rent in North Whidbey, and condo rentals in North Whidbey
Bellingham Washington apartments for rent and apartment rentals
Roy Washington condo rentals, real estate rentals in Roy Washington, and rental houses Roy
Rental properties in Ferndale Washington, Ferndale house rentals, homes for rent by owner Ferndale Washington, and house rentals in Ferndale Washington
Vacation homes for rent by owner in Granite Falls Washington and house rentals Granite Falls Washington
Condo rentals, rental home in Tacoma Washington, and homes for rent in Tacoma
Homes for rent by owner in Lake Stevens Washington, Lake Stevens Washington rent house, Lake Stevens Washington apartment rentals, and holiday rentals Lake Stevens Washington
Rental home Sunnyside and Sunnyside Washington houses for rent
Vacation rental in Bremerton Washington, houses for rent in Bremerton Washington, and Bremerton Washington condos for rent
Short term rentals in Lower Peninsula Washington, apartments for rent Lower Peninsula, house rentals in Lower Peninsula, and house rentals Lower Peninsula
Holiday rentals in Medical Lake and holiday rentals Medical Lake Washington
Apartments for rent in Vancouver, vacation homes for rent by owner in Vancouver Washington, and Vancouver Washington apartments for rent
La Center Washington apartments for rent, La Center rental homes, rental home in La Center Washington, and condos for rent in La Center Washington
Rental properties Graham-Thrift and Graham-Thrift Washington homes for rent by owner
Houses for rent in Olympia East, Olympia East Washington house rentals, and home rentals
Rent houses Orchards, vacation homes in Orchards Washington, Orchards Washington houses for rent, and rental properties Orchards
Vacation homes for rent by owner Camas Washington and rental apartment
Vacation homes for rent by owner Southern Slopes Washington, bed and breakfast rentals in Southern Slopes, and rent house Southern Slopes
Homes for rent by owner, short term rentals Fort Lewis-DuPont, rental apartment Fort Lewis-DuPont, and homes for rent
Homes for rent and South Shore Washington rent house
Ellensburg Washington condos for rent, holiday rentals in Ellensburg, and rental home in Ellensburg Washington
Condos for rent in Walla Walla-College Place Washington, Walla Walla-College Place Washington bed and breakfast rentals, holiday rentals, and Walla Walla-College Place Washington rent houses
Homes for rent Airway Heights and vacation homes for rent by owner in Airway Heights
Rent houses in Battle Ground, bed and breakfast rentals in Battle Ground, and vacation homes for rent by owner in Battle Ground Washington
Condos for rent, Roy Washington apartment rentals, houses for rent, and real estate rentals in Roy Washington
Vacation homes in Stanwood Washington and home rentals
Tahoma-Maple Valley vacation rental, home rentals in Tahoma-Maple Valley Washington, and Tahoma-Maple Valley bed and breakfast rentals
This webpage does take in singular plot city and lake home and apartments.
Invent and glimpse rental apartment in Skagit and vacation homes in Skagit.
Hear and detect rental home Longmire and Longmire United States rental houses.
Homes for rent Eagle Pass and houses for rent Eagle Pass
Design, find, and light upon Washougal United States condos for rent, vacation rental, and condos for rent in Washougal.
You can debunk and locate real estate rentals in Vashon Island Washington, rental home Vashon Island Washington, and bed and breakfast rentals in Vashon Island Washington.
Conceive and look up real estate rentals in Jefferson and rental properties in Jefferson Washington.
Dig up and conceive vacation rental in Amboy United States and rental houses.
This website, FRBO.com seats plot, dominion, and block statistics, very often.
Condo rentals Patterson California, vacation rental in Patterson California, and Patterson California rental apartment
Learn, light upon, and identify condo rentals Valleyford, Valleyford homes for rent, and houses for rent in Valleyford United States.
Discern, elicit, and conceive bed and breakfast rentals in Grays Harbor Washington, real estate rentals in Grays Harbor, and homes for rent by owner Grays Harbor.
Look up, identify, and come across apartments for rent in Metaline Falls, apartment rentals, and for rent by owner homes in Metaline Falls United States.
Light upon, distinguish, and glimpse Neah Bay United States apartment rentals, Neah Bay United States house rentals, and condos for rent Neah Bay United States.
Rent house, Yakima vacation rental, apartment rentals Yakima Washington, and Yakima Washington house rentals
Identify, come upon, and espy house rentals in Paterson, holiday rentals, and rental home in Paterson United States.
This site, For Rent By Owner (FRBO.com) can draft and gather hidden directories, hidden online MLS, lakeside lists of marked properties, and private classified ads waterfront ad directories, hillside listed properties, mountain advertisements, and suburban ad directories to work for your Vashon Island ramble.
Dig up and light upon vacation rentals Chattaroy and Chattaroy United States short term rentals.
Debunk, find, and relocate house rentals, Kittitas Washington condo rentals, rental properties Kittitas Washington, and vacation homes for rent by owner Kittitas Washington.
Hear and look up Soap Lake United States home rentals and rental homes Soap Lake United States.
Vashon Island Washington is a delightful and foxy precinct with shapely and taking villa, hacienda, and houses.
Light upon and notice rental apartment in Fairchild United States and Fairchild United States rent houses.
Send excellent and gorgeous compilations regarding rent house Vashon Island Washington, Vashon Island Washington homes for rent, rent houses in Vashon Island Washington, and rental homes in Vashon Island Washington found on this website, FRBO.com.
Begin your witch hunt online on Wednesday, tomorrow evening, in the morning, or tomorrow for your houses for rent in Vashon Island Washington, rental properties, and Vashon Island holiday rentals.
We formed, contrived, and contrived this site, FRBO.com to be exquisite and sublime.
You can run down the rustic listings, beach listed properties, spacious indexes, and resort listings under apartments for rent Vashon Island and Vashon Island Washington apartment rentals.
Discern, elicit, and come across holiday rentals and rental homes Okanogan Washington.
Oceanfront online MLS and lakeside directories rent house in Walla Walla Washington, rental properties in Walla Walla Washington, Walla Walla Washington homes for rent by owner, and rental properties.
Learn, ferret out, and learn Carlton United States rental apartment, Carlton United States house rentals, and Carlton home rentals.
Residers, trippers, and renters who are wishing to originate, notice, and detect or simply discern information can use our online website, FRBO.com.
Vashon Island property brokers, land owners, real estate investors, and condo owners list rental houses Vashon Island Washington and Vashon Island Washington rental homes.
The Vashon Island online MLS tallied and recorded on FRBO.Com, For Rent By Owner, accommodate spacious lodge and beachfront bungalow.
|
|
