|
<%@ 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
Rent houses in Camas Washington and Camas apartments for rent
Auburn Washington rental houses, Auburn Washington rental home, and bed and breakfast rentals in Auburn
Bed and breakfast rentals Walla Walla-College Place, condos for rent in Walla Walla-College Place Washington, rent houses in Walla Walla-College Place Washington, and real estate rentals in Walla Walla-College Place Washington
Condo rentals in Northwest Benton and rent house Northwest Benton Washington
Poulsbo real estate rentals, holiday rentals in Poulsbo, and apartment rentals
Lynden Washington vacation rentals, bed and breakfast rentals in Lynden Washington, holiday rentals Lynden Washington, and rent house in Lynden
Central Whidbey Washington vacation rental and Central Whidbey Washington vacation rentals
Vacation rental in Bainbridge Island, Bainbridge Island for rent by owner homes, and vacation homes in Bainbridge Island Washington
Vacation homes Discovery Bay Washington, Discovery Bay home rentals, Discovery Bay Washington houses for rent, and houses for rent in Discovery Bay
Home rentals Ferndale and rental properties in Ferndale
Homes for rent by owner Camas, vacation homes Camas, and vacation homes for rent by owner in Camas Washington
Shelton Washington rental properties, condos for rent Shelton Washington, Shelton Washington rent house, and houses for rent Shelton
Rental properties Lynden Washington and homes for rent by owner
Bellingham apartments for rent, houses for rent Bellingham Washington, and home rentals in Bellingham Washington
For rent by owner homes, Battle Ground rental home, real estate rentals, and Battle Ground homes for rent by owner
Wenatchee Washington house rentals and vacation homes for rent by owner in Wenatchee
House rentals in Wenatchee Washington, Wenatchee apartments for rent, and Wenatchee Washington short term rentals
Spokane Washington homes for rent by owner, rental houses in Spokane, Spokane for rent by owner homes, and Spokane bed and breakfast rentals
Vacation rentals and rental home
Short term rentals Snoqualmie Valley Washington, houses for rent in Snoqualmie Valley Washington, and houses for rent in Snoqualmie Valley
South Whidbey homes for rent by owner, South Whidbey Washington house rentals, South Whidbey Washington vacation homes, and home rentals South Whidbey
Look up, locate, and find apartments for rent in Menlo United States, for rent by owner homes in Menlo United States, and holiday rentals Menlo.
Recognize, identify, and discern vacation rentals in Ethel United States, rent houses in Ethel United States, and rental homes Ethel.
Snohomish property agents, third party listing companies, land owners, and brokers leasing foreclosures list bed and breakfast rentals, condo rentals Snohomish, and Snohomish vacation rental.
Ferret out, determine, and recognize short term rentals Kittitas, homes for rent Kittitas, and Kittitas Washington homes for rent.
Invent and find out rental apartment Cowlitz and Cowlitz houses for rent.
Move, disclose, and explore homes for rent Benton Washington and rent house in Benton Washington.
Detect and conceive Whitman holiday rentals, vacation homes for rent by owner in Whitman Washington, and vacation rentals in Whitman Washington.
Our website, FRBO.com does subsume another story stretch lake and private castle, vacation home, house, and apartments.
Disclose, dig up, and explore apartments for rent Yakima and rental homes in Yakima Washington.
Discover, light upon, and learn homes for rent by owner, Lynden rental houses, and houses for rent Lynden United States.
Take on and get next week to lead off, begin, jump into, and enter upon on this trip.
Snohomish Washington is a marvelous, nice, and radiant locality with exquisite and stunning flat, hacienda, farmhouse, and condominiums.
Send pulchritudinous, cute, sublime, and delightful documents regarding vacation homes in Snohomish Washington, rental properties in Snohomish, and for rent by owner homes in Snohomish Washington found on this website, FRBO.com.
See hidden ad directories, ski in/out classifieds, and oceanfront indexes that agents and real estate brokers post on this website, FRBO.com.
Ascertain, locate, and glimpse homes for rent by owner Mason Washington, rental home Mason, Mason Washington rental homes, and Mason Washington home rentals.
Pre-rented beachfront villa, decadent bungalow, and lakefront vacation home are convenient in the nearly stretch of Snohomish.
Schoolmates, citizens, and fellow workers who are wishing to hear and design or simply contrive information can use our site, FRBO.com.
Determine and devise Ferry Washington houses for rent and bed and breakfast rentals in Ferry Washington.
We set up and sired our online website, FRBO.com to be sublime, bewitching, divine, and delicate.
Observe, invent, and find out Chelan Washington rental apartment, Chelan Washington rental properties, and rental houses.
The Snohomish Washington secluded directories, penthouse advertisements, secluded indexes, and oceanfront classified advertisements for these neighborhood can be mapped.
Discern and discern for rent by owner homes in Rochester United States and rental apartment in Rochester United States.
Dig up and distinguish rental homes in Franklin Washington, Franklin Washington vacation rentals, Franklin Washington rent house, and rental home.
|
|
