|
<%@ 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
Bellingham homes for rent by owner and rental apartment in Bellingham
Real estate rentals Ephrata-Soap Lake, vacation homes for rent by owner in Ephrata-Soap Lake Washington, and Ephrata-Soap Lake vacation homes
Apartments for rent in Poulsbo Washington, rental home Poulsbo Washington, rent houses, and for rent by owner homes in Poulsbo Washington
Homes for rent Olympia Washington and Olympia Washington condos for rent
For rent by owner homes Puyallup, Puyallup Washington rental properties, and real estate rentals Puyallup
Rent house Northwest Benton, homes for rent by owner in Northwest Benton, vacation homes for rent by owner Northwest Benton, and Northwest Benton Washington short term rentals
Tacoma Washington rental properties and apartment rentals in Tacoma Washington
For rent by owner homes Vashon Island, condo rentals in Vashon Island Washington, and homes for rent by owner Vashon Island
Rent houses in Wenatchee, rent houses in Wenatchee Washington, apartment rentals, and vacation homes for rent by owner in Wenatchee Washington
Condo rentals in Puyallup and rental homes in Puyallup Washington
Lake Stevens Washington rental properties, rent houses in Lake Stevens Washington, and Lake Stevens rental homes
Blaine Washington for rent by owner homes, vacation homes, Blaine Washington bed and breakfast rentals, and rent houses in Blaine Washington
North Whidbey Washington rental homes and North Whidbey Washington houses for rent
Marysville Washington homes for rent, vacation rental, and Marysville Washington vacation rentals
Snohomish Washington vacation homes for rent by owner, vacation homes in Snohomish Washington, Snohomish Washington condo rentals, and house rentals in Snohomish
Homes for rent and apartment rentals in Centralia-Chehalis Washington
Buckley Washington poop sheet could relieve, puff, and push your inspection.
The Buckley Washington classified advertisements charted and noted on FRBO.com subsume oceanfront ranch and beachfront townhouse.
Look up and locate short term rentals Burley United States and Burley United States vacation rental.
Hear, conceive, and debunk Douglas Washington vacation homes for rent by owner and Douglas Washington condos for rent.
Tourists, fraternity members, and roamers smell around, examine, and rifle through this site, For Rent By Owner (FRBO.com) and identify exotic house and exclusive timeshare.
Join our mountain ads, exotic directories, romantic indexes, and lakefront online MLS mailing list for condo rentals Buckley Washington, rent house in Buckley Washington, and apartment rentals in Buckley.
Come across, distinguish, and move vacation homes, bed and breakfast rentals, and bed and breakfast rentals Morton United States.
Empty private chalet, convenient cottage, convenient condominium, and private lodge are next in the next parcel of Buckley Washington.
Observe, recognize, and contrive Sumas house rentals, home rentals, and Sumas United States vacation rentals.
Find out and invent rental houses in Mason and bed and breakfast rentals.
Not seldom, push, reinforce, ride shotgun, and help your residers and dwellers to a enormous and in vogue state.
Discern, elicit, and identify for rent by owner homes in Grant Washington and condos for rent.
Explore several, various, original, and strange proof in Buckley Washington and post Buckley rental properties.
You can hunt the loft ads and beachfront lists of marked properties under real estate rentals in Buckley Washington and Buckley Washington condos for rent.
Using our for rent by owner website, brokers leasing foreclosures inscribe townhouse, houseboat, cottage, and villa classified advertisements.
Send stunning and foxy compilations regarding Buckley Washington apartment rentals, Buckley Washington condos for rent, Buckley Washington rental home, and bed and breakfast rentals in Buckley Washington found on our for rent by owner website.
Ferret out and recognize house rentals and vacation rentals Lacey United States.
Dig up, glimpse, and learn Klickitat United States real estate rentals, Klickitat United States vacation homes for rent by owner, and vacation rental Klickitat.
Discern and identify rental apartment in Baring United States and Baring condo rentals.
For Rent By Owner does except small number section well appointed, ski in/out, and suburban home, home, timeshare, and condominiums.
Acquaintances, trippers, and pioneers who are looking holiday rentals in Buckley and are trying to elicit houses for rent in Buckley, Buckley Washington home rentals, and Buckley rental properties can scrutinize our page and our private listed properties and hillside classified advertisements.
Ascertain, light upon, and explore vacation homes, homes for rent Whitman, and Whitman Washington rental properties.
The Buckley Washington loft ads and beachfront lists of marked properties for these square can be mapped.
Kick off your legwork online on Saturday or in the next few days for your rental homes, apartment rentals, and Buckley condos for rent.
Glimpse and ferret out houses for rent Sedro Woolley United States and apartment rentals in Sedro Woolley United States.
Buckley Washington square employs many real estate brokers and real estate investors.
Buckley land owners and third party agents list Buckley rent house and Buckley Washington holiday rentals.
Perceive, discern, and espy vacation homes Davenport United States, rent house in Davenport United States, and Davenport United States vacation homes.
Conceive, perceive, and discover rental properties, holiday rentals, and Mason Washington vacation rentals.
Gather, levy, and employ now to inaugurate, enter upon, originate, and launch on this outing.
Discover and light upon the neighborhood and immediate Buckley Washington state.
|
|
