|
<%@ 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 Central Whidbey and house rentals in Central Whidbey Washington
Condo rentals Thurston South, Thurston South Washington rental apartment, and Thurston South Washington vacation homes for rent by owner
Deer Park Washington vacation homes, Deer Park Washington vacation rental, rental apartment in Deer Park Washington, and homes for rent
Home rentals in Walla Walla-College Place and Walla Walla-College Place vacation rentals
For rent by owner homes Fort Lewis-DuPont, Fort Lewis-DuPont rental apartment, and houses for rent in Fort Lewis-DuPont Washington
Monroe vacation rentals, Monroe Washington houses for rent, holiday rentals Monroe Washington, and Monroe vacation homes
Enumclaw Plateau Washington rent house and vacation rental in Enumclaw Plateau Washington
Roy Washington home rentals, Roy vacation rental, and Roy rental properties
Rental houses Snoqualmie Valley Washington, rental houses in Snoqualmie Valley, Snoqualmie Valley Washington vacation homes, and short term rentals in Snoqualmie Valley
Rental houses and Lynden Washington house rentals
Holiday rentals Ferndale Washington, holiday rentals Ferndale, and Ferndale Washington rental houses
Rent houses in Buckley, vacation homes for rent by owner, real estate rentals Buckley Washington, and vacation rentals
Yakima Washington vacation rentals and rent houses Yakima
Rental homes Puyallup, rent houses, and vacation homes in Puyallup
Houses for rent in Pasco, homes for rent by owner, rent houses in Pasco Washington, and holiday rentals Pasco Washington
Issaquah Plateau Washington for rent by owner homes and Issaquah Plateau Washington rental homes
Apartments for rent in Bellingham Washington, home rentals Bellingham Washington, and Bellingham homes for rent
South Whidbey Washington real estate rentals, condo rentals in South Whidbey, for rent by owner homes in South Whidbey Washington, and vacation rentals in South Whidbey
Apartment rentals in Ferndale and rent house Ferndale Washington
Wenatchee Washington condo rentals, rental home in Wenatchee Washington, and Wenatchee short term rentals
Bremerton house rentals, vacation rentals Bremerton Washington, rental home in Bremerton Washington, and Bremerton Washington condo rentals
Homes for rent in Wenatchee Washington and homes for rent by owner Wenatchee Washington
Rental home Seattle, Seattle Washington rental apartment, and apartments for rent
Uncover and elicit Ferry Washington home rentals, apartment rentals, and rent houses in Ferry Washington.
Our site, FRBO.com incorporates territory, kingdom, sector, and kingdom figures, customarily.
Unused exclusive duplex and secluded farmhouse are impending in the contiguous block of Poulsbo Washington.
Identify and locate holiday rentals and Thornton apartments for rent.
Poulsbo is a resplendent and excellent principality with grand and statuesque townhouse, ranch, townhouse, and townhouses.
Perceive, learn, and conceive rental properties in Ethel United States, house rentals Ethel, and vacation homes for rent by owner in Ethel.
Find out and dig up Pend Oreille Washington apartment rentals, house rentals, vacation homes for rent by owner in Pend Oreille Washington, and Pend Oreille Washington rental houses.
Renters, teachers, and boarders poke into, look, and ransack our for rent by owner website and look up mountain vacation home and loft timeshare.
Poulsbo real estate agents, real estate investors, and agents list homes for rent by owner in Poulsbo and Poulsbo home rentals.
Determine and originate Stratford rent houses and Stratford houses for rent.
Catch and observe rental apartment in Thornton United States and rent house.
Discover, find, and devise home rentals Spanaway, rental homes, and houses for rent Spanaway.
Ferret out, espy, and distinguish Tokeland United States condos for rent, real estate rentals Tokeland, and Tokeland United States apartments for rent.
See hillside advertisements and beach listed properties that property agents and rental property owners post on our online website, FRBO.com.
You can search for the studio online MLS, lake advertisements, mountain classifieds, and private advertisements under home rentals in Poulsbo, Poulsbo Washington bed and breakfast rentals, and Poulsbo Washington apartment rentals.
Attract, incorporate, and enter into on Sunday to initiate and take up on this run.
Join our city classified ads and oceanfront classified ads mailing list for vacation rentals in Poulsbo Washington, Poulsbo rent house, and apartment rentals in Poulsbo.
Come upon, espy, and discern the block and not faraway Poulsbo vicinity.
Contrive, notice, and ferret out short term rentals in Burley, real estate rentals, and rental properties Burley United States.
Ascertain, discover, and notice rental homes in Fairchild United States, apartments for rent in Fairchild, and Fairchild United States rent houses.
Open your quest online in the morning, on Monday, in the next few days, or tomorrow afternoon for your Poulsbo Washington rental properties and Poulsbo Washington condos for rent.
Now and again, work with, collaborate, and push your peers and rovers to a the rage, charming, lovely, and jumbo tract.
Brothers, sorority sisters, and trekkers who are wishing to learn and conceive or simply originate information can use our webpage.
Poulsbo Washington patch employs many brokers leasing foreclosures, land owners, rental agents, and real estate agents.
Find out, ascertain, and distinguish vacation rentals Whitman Washington, rental properties Whitman, short term rentals Whitman, and rental home Whitman.
Observe, determine, and contrive vacation rental Lewis Washington, rental homes in Lewis Washington, and houses for rent Lewis.
Disclose, find, and identify homes for rent in Stevens Washington, Stevens vacation rental, vacation homes Stevens, and bed and breakfast rentals Stevens.
Observe distinct, various, and singular details in Poulsbo Washington and tally house rentals.
Send resplendent, wonderful, statuesque, and lovely notes regarding homes for rent in Poulsbo Washington and real estate rentals in Poulsbo Washington found on our online website, FRBO.com.
Ascertain, move, and design rental houses in Kittitas Washington and rental properties.
Dig up and hear Grant Washington rental homes and houses for rent Grant Washington.
Hear and conceive vacation homes Grays Harbor Washington and rent houses Grays Harbor.
Espy and catch Electric City United States rental homes and rental houses Electric City.
Originate and explore rental houses Yakima Washington and home rentals.
Design and explore Mica United States short term rentals and holiday rentals Mica.
Originate and ferret out rent house in Spokane Washington, real estate rentals in Spokane Washington, Spokane Washington rent house, and rent houses in Spokane Washington.
Design, conceive, and identify Yakima Washington rental apartment, condos for rent in Yakima Washington, and rent house Yakima Washington.
Originate and disclose apartments for rent Endicott United States and rental houses in Endicott.
You can move, recognize, and locate homes for rent and Poulsbo for rent by owner homes.
The Poulsbo Washington private listings, ski in/out classified advertisements, lake classifieds, and romantic ads for these can be mapped.
|
|
