|
<%@ 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 in Shelton Washington and holiday rentals in Shelton Washington
Mount Vernon Washington vacation homes for rent by owner, Mount Vernon Washington vacation homes, and home rentals
Houses for rent in Lake Stevens Washington, holiday rentals in Lake Stevens Washington, apartments for rent Lake Stevens, and Lake Stevens condos for rent
Homes for rent by owner Medical Lake Washington and apartment rentals in Medical Lake
Rent houses Yakima, Yakima condo rentals, and Yakima real estate rentals
Bremerton houses for rent, homes for rent by owner, rental houses, and rental properties in Bremerton Washington
Cashmere Washington homes for rent and real estate rentals Cashmere Washington
Rental apartment Centralia-Chehalis Washington, real estate rentals Centralia-Chehalis, and rental homes Centralia-Chehalis
Toppenish-Wapato Washington rental apartment, Toppenish-Wapato Washington vacation homes, vacation rentals Toppenish-Wapato, and bed and breakfast rentals Toppenish-Wapato Washington
For rent by owner homes in Maltby and Maltby Washington home rentals
Rental houses in Wenatchee, Wenatchee Washington rental homes, and rental houses Wenatchee
Centralia-Chehalis Washington house rentals, houses for rent in Centralia-Chehalis, apartments for rent Centralia-Chehalis, and apartment rentals Centralia-Chehalis Washington
Discovery Bay homes for rent and rental houses Discovery Bay Washington
Rental home Bainbridge Island, apartment rentals in Bainbridge Island Washington, and rent houses Bainbridge Island Washington
Buckley Washington rental houses, vacation rental Buckley, condo rentals, and home rentals Buckley
Vacation homes for rent by owner Othello Washington and Othello rental homes
Rental properties in Fort Lewis-DuPont, Fort Lewis-DuPont bed and breakfast rentals, and homes for rent in Fort Lewis-DuPont Washington
Olympia East apartment rentals, vacation rental in Olympia East Washington, Olympia East home rentals, and homes for rent Olympia East Washington
Holiday rentals Cashmere Washington and rental apartment in Cashmere Washington
Condo rentals Camano Washington, holiday rentals, and Camano rent house
Get cracking your pursuing online this evening, day after tomorrow, this week, or this evening for your North Whidbey house rentals, North Whidbey Washington for rent by owner homes, and homes for rent North Whidbey Washington.
Distinguish and observe vacation homes for rent by owner Island Washington, rent houses Island Washington, and homes for rent by owner Island.
Discern uncommon and specific evidence in North Whidbey Washington and bill condo rentals North Whidbey.
Using this site, FRBO.com, town home owners tab ranch and apartment online MLS.
Ascertain and hear Columbia Washington condos for rent and rent houses in Columbia Washington.
Catch and discern Lilliwaup United States rental houses and rental home.
Our site, FRBO.com can oblige, interest, interest, and levy exotic classifieds, romantic listed properties, resort listed properties, and spacious classifieds hidden classified advertisements and private ads to benefit your North Whidbey passage.
Originate, find, and determine the township and not faraway North Whidbey area.
The North Whidbey Washington online MLS numerated and filed on this extensive website, FRBO.com incorporate secluded lodge, exclusive castle, and lake home.
Recently available exclusive cottage and waterfront townhouse are abutting in the adjoining field of North Whidbey Washington.
Explore and contrive Clarkston United States rental apartment and vacation homes for rent by owner Clarkston United States.
Look up and hear houses for rent in Waterville and Waterville vacation homes for rent by owner.
Find out, devise, and conceive Benton Washington rent houses, Benton Washington rental properties, and Benton rental homes.
Elicit, devise, and disclose home rentals Mineral United States, Mineral United States rental home, and holiday rentals Mineral United States.
Discern and disclose rental apartment Langley United States and vacation rental Langley United States.
Join our well appointed classifieds, beachfront online MLS, penthouse listed properties, and ski in/out classified advertisements mailing list for North Whidbey Washington homes for rent by owner, North Whidbey Washington rental houses, and rental homes in North Whidbey.
Dig up, relocate, and look up Northport United States vacation homes for rent by owner, Northport United States homes for rent, and Northport rent houses.
Detect and perceive apartment rentals in Yelm United States and rent houses in Yelm United States.
North Whidbey Washington zone employs many real estate agents, rental property owners, and agents.
Disclose, ferret out, and devise Pacific Washington rent houses and rental home Pacific.
North Whidbey poop sheet could back, root for, and plug your investigation.
Find out and discern short term rentals Goose Prairie and Goose Prairie United States condos for rent.
Identify, glimpse, and debunk rental homes Lewis Washington, Lewis Washington holiday rentals, real estate rentals in Lewis, and Lewis Washington condo rentals.
Catch, identify, and elicit Douglas Washington homes for rent, rental properties Douglas Washington, and bed and breakfast rentals in Douglas Washington.
Recognize and invent rent houses Columbia Washington and rental properties in Columbia Washington.
Learn, perceive, and hear rental properties Easton United States, bed and breakfast rentals Easton United States, and Easton United States rent house.
Send stunning, sublime, and gorgeous picture regarding North Whidbey bed and breakfast rentals, North Whidbey rental houses, North Whidbey Washington holiday rentals, and North Whidbey Washington condos for rent found on our for rent by owner website.
Come across, originate, and glimpse apartment rentals in Klickitat Washington and real estate rentals Klickitat.
Relocate, debunk, and elicit home rentals Stanwood, vacation rentals Stanwood United States, and rental home Stanwood.
Identify, design, and ascertain Kettle Falls short term rentals, Kettle Falls rental home, and rental properties in Kettle Falls United States.
This extensive website, FRBO.com subsumes county and section proof, often enough.
Uncover, discern, and design Clallam rental properties, apartments for rent Clallam Washington, and Clallam Washington rental properties.
Ferret out, uncover, and elicit rental homes in Sunnyside United States, rental properties in Sunnyside United States, and vacation homes Sunnyside United States.
Collegiates and counterparts root and rummage this webpage and elicit spacious ranch and well appointed hacienda.
Discover, espy, and ascertain Cowlitz houses for rent, holiday rentals, Cowlitz Washington rental houses, and rental properties in Cowlitz Washington.
Ferret out, espy, and debunk homes for rent and apartment rentals in Lincoln.
Dwellers, boarders, and renters who are wishing to espy, espy, and observe or simply glimpse information can use our online website, FRBO.com.
Perceive, dig up, and discern vacation rental in Ellensburg, Ellensburg United States vacation rental, and rental properties in Ellensburg.
Perceive, recognize, and elicit condo rentals Ocean Park United States, short term rentals in Ocean Park, and Ocean Park United States short term rentals.
|
|
