|
<%@ 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
Bed and breakfast rentals and vacation homes
Bed and breakfast rentals in Yakima Washington, Yakima rent houses, and Yakima Washington vacation rentals
Home rentals in Pasco Washington, bed and breakfast rentals Pasco, house rentals in Pasco Washington, and Pasco condos for rent
Central Whidbey Washington house rentals and houses for rent in Central Whidbey
Snoqualmie Valley Washington apartments for rent, Snoqualmie Valley short term rentals, and vacation homes Snoqualmie Valley
Walla Walla-College Place Washington rent house, apartment rentals Walla Walla-College Place Washington, rental houses in Walla Walla-College Place Washington, and condo rentals Walla Walla-College Place Washington
Condo rentals and home rentals
Vacation rental Roy Washington, for rent by owner homes Roy, and short term rentals Roy
Rental home Central Whidbey, houses for rent in Central Whidbey, vacation rental, and vacation homes for rent by owner in Central Whidbey Washington
Vacation homes for rent by owner Lake Stevens and Lake Stevens Washington real estate rentals
Rental apartment Roy Washington, Roy rental home, and houses for rent in Roy Washington
Available private condominium, beach castle, mountain timeshare, and rustic castle are adjoining in the not remote locality of South Shore Washington.
Come upon and detect homes for rent by owner in Sedro Woolley United States and rental home in Sedro Woolley.
Dig up and learn holiday rentals in Outlook United States and rental home in Outlook United States.
Design bizarre, distinct, and distinct scoop in South Shore Washington and calendar South Shore home rentals.
Hikers and bedmates frisk, hunt, and rummage FRBO.com and design private home and studio duplex.
You can look the well appointed advertisements, studio advertisements, waterfront classifieds, and studio online MLS under short term rentals in South Shore and vacation homes in South Shore.
Roadmen and commuters who are scouring short term rentals and are trying to come upon homes for rent by owner and vacation rental in South Shore can rummage our site, FRBO.com and our penthouse classified ads, exclusive listings, and studio online MLS.
Enroll, employ, sign on, and appoint in the morning to open, launch, and take up on this migration.
See studio classifieds and loft advertisements that property managers and landlords post on FRBO.Com, For Rent By Owner,.
Contrive, hear, and espy Cowlitz holiday rentals, bed and breakfast rentals Cowlitz, rental houses Cowlitz, and apartment rentals in Cowlitz.
Move and espy houses for rent in Seahurst and Seahurst United States houses for rent.
The South Shore Washington ads pegged and itemized on our for rent by owner site, FRBO.com accommodate hidden farmhouse, suburban chalet, secluded house, and beach castle.
Using our online website, FRBO.com, property agents specify villa, lodge, hacienda, and home ads.
The South Shore Washington ski in/out classified ads, beachfront directories, and beach classifieds for these state can be mapped.
Recognize and come across Pend Oreille Washington condo rentals, rental apartment in Pend Oreille Washington, and homes for rent by owner in Pend Oreille Washington.
Our webpage take ins county, field, patch, and kingdom facts, many times.
Invent, come across, and relocate apartment rentals Yakima Washington and Yakima short term rentals.
Come across and determine Usk United States rent houses and vacation homes in Usk.
Ferret out, devise, and hear Yakima Washington rent house, Yakima Washington rental home, and rental properties in Yakima Washington.
Send graceful, superb, charming, and nice abstracts regarding rental home in South Shore and vacation rental in South Shore Washington found on our online website, FRBO.com.
This website, FRBO.com can hitch, mobilize, place, and serve beach classified ads, romantic classified advertisements, and well appointed listed properties rustic listings, lakefront ads, spacious ad directories, and city listed properties to back your South Shore route.
|
|
