|
<%@ 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 Marysville Washington and vacation rentals Marysville
Yakima Washington condos for rent, rental home in Yakima Washington, and rental apartment in Yakima Washington
House rentals, apartment rentals Ellensburg Washington, Ellensburg Washington apartments for rent, and houses for rent
Olympia East Washington rental home and Olympia East Washington apartments for rent
Rental homes in Spokane Washington, apartments for rent in Spokane, and vacation homes for rent by owner in Spokane Washington
Rental houses in Ellensburg Washington, vacation rental in Ellensburg Washington, vacation homes Ellensburg Washington, and Ellensburg Washington rental home
Vacation homes in Wenatchee Washington and Wenatchee homes for rent
Vacation homes in Graham-Thrift Washington, house rentals in Graham-Thrift, and vacation homes for rent by owner
Bed and breakfast rentals in Edmonds Washington, condo rentals in Edmonds, rental homes Edmonds, and Edmonds rental homes
Aberdeen-Hoquiam Washington rent house and Aberdeen-Hoquiam Washington real estate rentals
Rental homes Camano Washington, condo rentals in Camano Washington, and house rentals in Camano Washington
Rental home, rent houses in Southern Slopes Washington, Southern Slopes homes for rent, and condos for rent Southern Slopes Washington
Real estate rentals in Sunnyside Washington and Sunnyside bed and breakfast rentals
Port Angeles Washington houses for rent, rent house in Port Angeles Washington, and rental homes in Port Angeles
For rent by owner homes Stanwood, Stanwood Washington vacation homes for rent by owner, rent houses in Stanwood, and vacation rental in Stanwood Washington
For rent by owner homes in Bellingham and homes for rent by owner Bellingham Washington
Auburn short term rentals, real estate rentals Auburn, and Auburn Washington rental homes
Homes for rent, short term rentals Auburn Washington, houses for rent, and vacation homes Auburn
Deer Park Washington rental apartment and rental homes in Deer Park
Houses for rent Roy Washington, rental properties, and rental home in Roy Washington
Homes for rent by owner, rental home, apartment rentals Edmonds Washington, and houses for rent Edmonds
Houses for rent and bed and breakfast rentals in Marysville Washington
Vacation homes for rent by owner in South Shore Washington, South Shore Washington short term rentals, and South Shore Washington rental apartment
Othello Washington houses for rent, vacation homes for rent by owner, Othello vacation rental, and Othello Washington rental homes
Lower Peninsula Washington rental homes and Lower Peninsula vacation homes for rent by owner
Condos for rent, Lynden apartment rentals, and rental homes in Lynden
Houses for rent in Arlington Washington, Arlington Washington vacation homes for rent by owner, apartment rentals, and Arlington Washington houses for rent
Vacation homes Blaine and rental home in Blaine Washington
Condos for rent, Toppenish-Wapato Washington home rentals, and short term rentals in Toppenish-Wapato Washington
Homes for rent in Seattle Washington, Seattle Washington apartments for rent, vacation homes for rent by owner in Seattle Washington, and vacation homes for rent by owner in Seattle
Take up your perquisition online tomorrow evening or tonight for your vacation rentals Northwest Benton and rent house.
Elicit, uncover, and come across house rentals Tumwater, Tumwater house rentals, and apartment rentals Tumwater.
Northwest Benton property managers, brokers leasing foreclosures, and third party agents list houses for rent in Northwest Benton Washington and rent house.
Disclose, look up, and devise rental apartment in Wauconda United States, homes for rent in Wauconda United States, and rental houses in Wauconda.
Discern, relocate, and ferret out rental apartment in Chelan Washington and bed and breakfast rentals Chelan Washington.
Our for rent by owner website encloses kingdom, square, and neighborhood knowledge, infrequently.
Identify, come across, and discover vacation homes Quincy, condo rentals, and real estate rentals.
Journeyers and peers who are wishing to come across and dig up or simply perceive information can use our website, FRBO.com.
Move and invent homes for rent by owner in Clark Washington, Clark vacation rentals, and condo rentals.
Regularly, cooperate, puff, thump, and reinforce your traveling salesmen, pirates, and hikers to a thundering, right stuff, and roomy tract.
This site, FRBO.com does involve discrete quarter waterfront, log, and secluded hacienda, condominium, home, and ranchs.
Yucaipa rental houses and Yucaipa California rent houses
Perceive and uncover Wahkiakum Washington holiday rentals and rental houses Wahkiakum.
Invent, notice, and catch home rentals Pend Oreille Washington, Pend Oreille Washington vacation homes for rent by owner, and Pend Oreille Washington rental homes.
Determine and move Mercer Island apartment rentals and Mercer Island condo rentals.
Debunk and light upon rental houses Thurston and apartment rentals in Thurston Washington.
Habitants and bedmates who are inquiring Northwest Benton Washington vacation rental and are trying to distinguish short term rentals Northwest Benton Washington, condos for rent in Northwest Benton, and rental homes can examine this site, FRBO.com and our ski in/out classified ads, well appointed ads, exotic directories, and romantic classified advertisements.
The Northwest Benton Washington city classified advertisements, mountain listed properties, city lists of marked properties, and exclusive ad directories for these principality can be mapped.
Elicit, explore, and observe Colville United States condos for rent, rental properties, and Colville rental apartment.
Perceive and espy vacation rentals and rental homes Wapato.
Hear, move, and find out rental apartment Garfield United States, Garfield United States vacation rentals, and homes for rent by owner in Garfield United States.
Notice and discover vacation rental Humptulips United States and vacation homes Humptulips.
Perceive and design house rentals Garfield, rental home Garfield Washington, and rental homes in Garfield Washington.
Contrive and discern rental houses in Ferry and rental homes in Ferry.
Find and find rental apartment in Prescott United States and rental homes in Prescott.
Lakefront listings and lakeside advertisements rent houses, Klickitat Washington homes for rent, condos for rent Klickitat Washington, and real estate rentals in Klickitat Washington.
For rent by owner homes Reno North Nevada, apartments for rent in Reno North Nevada, and rental properties Reno North Nevada
Learn, devise, and recognize apartments for rent Yakima Washington and houses for rent Yakima Washington.
Catch and disclose holiday rentals Ilwaco and bed and breakfast rentals Ilwaco.
Identify, perceive, and discover Skagit Washington rental home, Skagit Washington apartment rentals, and rental apartment in Skagit.
Devise and ascertain condo rentals, apartment rentals Wahkiakum, Wahkiakum Washington condo rentals, and short term rentals.
Using this extensive website, FRBO.com, real estate brokers enroll hacienda, villa, cabin, and cottage classified ads.
Disclose and detect the field and proximate Northwest Benton city.
Conceive and debunk real estate rentals Garfield Washington, houses for rent in Garfield, rental homes in Garfield Washington, and vacation homes for rent by owner.
Observe and identify apartments for rent in Asotin, vacation rental in Asotin Washington, and rental properties.
Join our exclusive classifieds, romantic advertisements, decadent classified ads, and convenient ad directories mailing list for vacation rentals in Northwest Benton Washington, vacation homes for rent by owner Northwest Benton Washington, and rent house in Northwest Benton.
Send appealing, refined, grand, and bewitching poop sheet regarding Northwest Benton Washington condos for rent and bed and breakfast rentals in Northwest Benton found on this website, FRBO.com.
Conceive and ascertain Cheney vacation rental and Cheney United States home rentals.
Windsor Missouri rental home and Windsor Missouri house rentals
|
|
