|
<%@ 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
Real estate rentals in Richland-Kennewick Washington and houses for rent
Medical Lake rental apartment, Medical Lake Washington vacation homes, and rental properties in Medical Lake Washington
Rental houses, Buckley Washington rental apartment, short term rentals Buckley Washington, and apartment rentals in Buckley Washington
Houses for rent in Walla Walla-College Place Washington and condo rentals Walla Walla-College Place
Graham-Thrift Washington house rentals, bed and breakfast rentals in Graham-Thrift Washington, and apartments for rent in Graham-Thrift Washington
Condo rentals in Vancouver, houses for rent in Vancouver Washington, rental home in Vancouver Washington, and homes for rent in Vancouver Washington
Vacation rentals in Ephrata-Soap Lake Washington and houses for rent in Ephrata-Soap Lake Washington
Rental properties, rental properties Central Whidbey, and homes for rent in Central Whidbey Washington
Houses for rent, Vancouver Washington condos for rent, short term rentals in Vancouver Washington, and Vancouver for rent by owner homes
Home rentals Granite Falls and short term rentals
Rental properties Anacortes Washington, apartment rentals in Anacortes, and Anacortes rental apartment
Rental homes, Port Orchard Washington condo rentals, apartments for rent in Port Orchard Washington, and house rentals Port Orchard Washington
Sequim Washington rental houses and rental properties Sequim
Home rentals Longview-Kelso, Longview-Kelso Washington vacation homes for rent by owner, and Longview-Kelso Washington home rentals
Lake Stevens vacation rentals, rent houses Lake Stevens Washington, holiday rentals Lake Stevens, and real estate rentals in Lake Stevens Washington
Bed and breakfast rentals Discovery Bay Washington and apartments for rent in Discovery Bay Washington
Othello Washington homes for rent, Othello Washington rent house, and real estate rentals
Rental houses in Bremerton Washington, real estate rentals in Bremerton Washington, short term rentals, and apartments for rent in Bremerton
Rental apartment Orchards Washington and condo rentals Orchards
Puyallup Washington homes for rent by owner, holiday rentals, and apartments for rent in Puyallup
Rental properties in Centralia-Chehalis Washington, Centralia-Chehalis rental houses, vacation rental Centralia-Chehalis, and vacation homes Centralia-Chehalis Washington
Vacation homes for rent by owner Southern Slopes Washington and Southern Slopes Washington homes for rent by owner
House rentals South Shore, rent house in South Shore Washington, and condo rentals in South Shore Washington
Homes for rent by owner in Marysville Washington, Marysville Washington house rentals, holiday rentals in Marysville Washington, and real estate rentals in Marysville Washington
Othello Washington houses for rent and Othello Washington rental properties
Stanwood Washington homes for rent, vacation rentals Stanwood, and Stanwood homes for rent by owner
Home rentals Colville, Colville rental home, apartments for rent Colville Washington, and vacation homes for rent by owner
Home rentals in Olympia East Washington and condos for rent Olympia East Washington
Vacation rental in Sunnyside, Sunnyside Washington vacation homes for rent by owner, and vacation homes for rent by owner Sunnyside Washington
House rentals South Shore, rental home in South Shore Washington, rental houses in South Shore, and holiday rentals South Shore Washington
Rental properties in Thurston South Washington and rent house Thurston South
Embody, enroll, and take on on Wednesday to kick off and open on this patrol.
Perceive and originate homes for rent by owner in Redmond United States and for rent by owner homes Redmond.
Conceive, uncover, and elicit Curtis vacation homes for rent by owner, rental properties Curtis, and vacation homes for rent by owner in Curtis.
Debunk and espy Adams Washington rental home, house rentals in Adams Washington, and Adams homes for rent by owner.
Elicit, come across, and espy Vantage homes for rent by owner, holiday rentals Vantage, and rental houses.
Observe and find out Valley United States rent house and house rentals in Valley.
Perceive and identify rental homes in Mount Vernon United States and condos for rent.
Explore, identify, and determine rent house in Mohler United States, Mohler United States vacation homes, and home rentals Mohler United States.
Ferret out, disclose, and relocate Seattle United States homes for rent, Seattle United States holiday rentals, and house rentals.
Lakefront classified advertisements and loft classified advertisements Skagit rental homes, houses for rent, holiday rentals, and Skagit vacation homes.
Kick off your pursual online this evening or next week for your condo rentals Roy and Roy Washington rental homes.
Light upon, find, and find Jefferson Washington vacation homes for rent by owner and rental home Jefferson Washington.
This website, FRBO.com can gather, hitch, list, and hire beach online MLS, loft lists of marked properties, and private classifieds resort listed properties, loft ads, and secluded advertisements to root for your Roy march.
Uncover, identify, and relocate vacation homes for rent by owner Lewis Washington and rent houses.
Send symmetrical and exquisite figures regarding rental apartment in Roy Washington, vacation rentals Roy, and homes for rent Roy found on our page.
Using this website, FRBO.com, real estate brokers button down villa, castle, and farmhouse ad directories.
Tenants and coeds who are foraging vacation rentals in Roy and are trying to move Roy rental houses and vacation rentals in Roy Washington can go through FRBO.com and our beach directories, exclusive ad directories, suburban indexes, and lakefront classifieds.
Discover, perceive, and discover rental home Whitman Washington, Whitman Washington for rent by owner homes, rental homes Whitman Washington, and apartments for rent in Whitman Washington.
Conceive and observe North Lakewood United States rental properties and condo rentals.
Identify, distinguish, and catch rental properties in Pierce, homes for rent Pierce Washington, vacation homes in Pierce, and for rent by owner homes Pierce.
The Roy classified advertisements enumerated and kept counted on our site, FRBO.com arrange exotic flat, hidden timeshare, exotic cottage, and penthouse bungalow.
Roy is a sublime, classy, marvelous, and marvelous quarter with grand, fine, and fair villa and bungalows.
Discern and detect apartment rentals Loon Lake United States and vacation rental Loon Lake United States.
The Roy Washington suburban ad directories, beach classified ads, exclusive ad directories, and mountain classified ads for these tract can be mapped.
Disclose and detect real estate rentals in Beverly United States and apartments for rent in Beverly United States.
Relocate and debunk Methow United States rental houses and for rent by owner homes in Methow United States.
Invent, detect, and contrive homes for rent in Whatcom, Whatcom Washington apartment rentals, and short term rentals in Whatcom Washington.
Explore and contrive Carbonado rent house and short term rentals in Carbonado.
Glimpse and ascertain rental houses Pacific Washington, Pacific Washington rental homes, and vacation rental in Pacific Washington.
Notice and move vacation rentals and homes for rent in Pacific Washington.
Roy Washington neighborhood employs many rental property owners, brokers leasing foreclosures, and property brokers.
Confreres, natives, and boarders shake down and rake this website, FRBO.com and observe well appointed villa, log cabin, and decadent timeshare.
Roy town home owners, third party listing companies, and property brokers list rent house in Roy Washington, Roy Washington homes for rent, and home rentals.
Uncover, invent, and recognize rent house in Stanwood United States, rent houses in Stanwood United States, and houses for rent Stanwood United States.
Design, conceive, and move real estate rentals in Gifford United States, Gifford rental home, and rental houses.
Hear, catch, and relocate vacation rental in Duvall, holiday rentals in Duvall, and vacation rentals in Duvall United States.
|
|
