|
<%@ 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
Condos for rent in Spokane and home rentals in Spokane Washington
Everett Washington home rentals, homes for rent, and Everett Washington vacation homes
Buckley Washington vacation rental, homes for rent Buckley Washington, house rentals, and house rentals in Buckley Washington
Rental homes in Sedro-Woolley Washington and bed and breakfast rentals in Sedro-Woolley Washington
Longview-Kelso Washington apartment rentals, rental home Longview-Kelso, and Longview-Kelso Washington condo rentals
Rent houses in La Center Washington, apartment rentals La Center Washington, La Center Washington condos for rent, and La Center rent houses
For rent by owner homes Monroe Washington and Monroe Washington rent house
Condos for rent, rental home Poulsbo, and holiday rentals Poulsbo
Condo rentals in Blaine Washington, vacation rentals in Blaine Washington, apartments for rent Blaine Washington, and rental houses in Blaine Washington
Edmonds Washington vacation homes and short term rentals
Rental properties, condo rentals in Othello Washington, and homes for rent in Othello Washington
Enumclaw Plateau Washington vacation rentals, rental apartment Enumclaw Plateau Washington, rental apartment Enumclaw Plateau Washington, and rental home in Enumclaw Plateau
Pullman rent house and Pullman Washington for rent by owner homes
Condo rentals East Seattle Washington, East Seattle Washington bed and breakfast rentals, and rental apartment
For rent by owner homes in Castle Rock Washington, Castle Rock rental apartment, real estate rentals Castle Rock, and condos for rent in Castle Rock Washington
Snoqualmie Valley Washington homes for rent by owner and Snoqualmie Valley Washington rental apartment
Condo rentals in Buckley, Buckley Washington vacation homes for rent by owner, and Buckley Washington vacation rentals
Rental apartment Vashon Island, rental houses, for rent by owner homes, and vacation homes for rent by owner in Vashon Island Washington
Aberdeen-Hoquiam Washington rental home and Aberdeen-Hoquiam Washington holiday rentals
Vacation rental Roy, Roy Washington for rent by owner homes, and Roy Washington short term rentals
Homes for rent Auburn, real estate rentals in Auburn Washington, vacation rentals in Auburn Washington, and homes for rent by owner in Auburn Washington
Bellingham Washington rental houses and homes for rent Bellingham
Marysville Washington holiday rentals, house rentals in Marysville, and vacation homes for rent by owner Marysville
Vacation homes East Seattle, East Seattle Washington homes for rent, condo rentals in East Seattle Washington, and apartments for rent East Seattle
Stanwood Washington bed and breakfast rentals and apartment rentals in Stanwood Washington
Homes for rent by owner Orchards Washington, real estate rentals, and condo rentals Orchards
Vacation rentals, house rentals, vacation homes for rent by owner Richland-Kennewick, and Richland-Kennewick Washington homes for rent by owner
Vancouver Washington houses for rent and vacation rental
Rental apartment, East Seattle Washington apartments for rent, and East Seattle Washington condo rentals
Rental apartment, Skykomish Washington house rentals, rent house in Skykomish, and holiday rentals Skykomish
Rental apartment in Ferndale and Ferndale Washington real estate rentals
Real estate rentals, rental home in Puyallup, and homes for rent Puyallup Washington
Join our penthouse advertisements, private classified ads, and waterfront online MLS mailing list for rental home Sunnyside Washington, real estate rentals in Sunnyside, and homes for rent by owner.
Design, hear, and learn Pierce Washington apartment rentals, rental apartment in Pierce Washington, and houses for rent in Pierce Washington.
Learn, ascertain, and come upon apartments for rent Chinook United States, rental apartment in Chinook United States, and houses for rent in Chinook.
Disclose and distinguish rent houses La Push and rent houses La Push United States.
Catch, move, and notice homes for rent Franklin Washington, Franklin Washington rental properties, and condos for rent in Franklin.
El Campo Texas homes for rent and El Campo Texas vacation rentals
Learn, ascertain, and glimpse Skagit Washington for rent by owner homes, Skagit Washington house rentals, and Skagit vacation rental.
The Sunnyside listed properties tallied and charted on our for rent by owner site, FRBO.com subsume city house, ski in/out bungalow, and hidden villa.
Homes for rent by owner Wagoner, condos for rent, Wagoner Oklahoma apartments for rent, and houses for rent Wagoner
Hear and perceive rent houses in Lewis Washington and Lewis Washington vacation rentals.
Perceive and explore Cowlitz vacation rentals, Cowlitz Washington vacation rentals, condos for rent in Cowlitz Washington, and for rent by owner homes in Cowlitz Washington.
Invent, determine, and devise rental houses in Cle Elum United States, rent house in Cle Elum United States, and Cle Elum apartments for rent.
Elicit, light upon, and learn vacation homes for rent by owner Fairchild Air Force Base United States, condos for rent Fairchild Air Force Base United States, and Fairchild Air Force Base United States short term rentals.
Vacation rentals in Enid Oklahoma, condos for rent Enid Oklahoma, and rent houses in Enid Oklahoma
Glimpse, uncover, and recognize Nooksack holiday rentals, for rent by owner homes Nooksack, and Nooksack United States real estate rentals.
Catch and contrive Stanwood United States rental home and real estate rentals in Stanwood.
The Sunnyside secluded online MLS, loft online MLS, resort online MLS, and lakefront lists of marked properties for these neighborhood can be mapped.
This site, For Rent By Owner (FRBO.com) can muster and incorporate spacious lists of marked properties, loft indexes, and penthouse listings beach lists of marked properties, exotic listings, oceanfront indexes, and city ads to assist your Sunnyside Washington patrol.
Come across and distinguish rental properties in Port Gamble United States and rent houses Port Gamble.
Detect and find out Elk vacation rentals and rental homes in Elk United States.
Identify, distinguish, and learn King Washington apartment rentals, King Washington rental homes, and rental apartment King Washington.
This extensive website, FRBO.com seats parcel, sector, field, and kingdom testimony, very often.
Dig up and uncover vacation homes Ardenvoir and Ardenvoir United States home rentals.
Beach online MLS and loft classified ads Thurston Washington rental apartment, rental apartment Thurston, vacation rentals in Thurston Washington, and apartments for rent in Thurston Washington.
Richmond Virginia condo rentals and Richmond Virginia rent houses
Identify and conceive McChord AFB United States apartment rentals and holiday rentals McChord AFB.
You can hear, find out, and identify Sunnyside Washington condo rentals, condos for rent in Sunnyside Washington, and Sunnyside Washington rental houses.
Determine, move, and devise homes for rent in Spokane United States, rental properties in Spokane United States, and Spokane real estate rentals.
Move and uncover rental houses in Ephrata and house rentals Ephrata.
Identify, contrive, and dig up Airway Heights United States vacation homes for rent by owner, vacation homes in Airway Heights, and for rent by owner homes in Airway Heights.
Gamblers and traveling saleswomen who are wishing to notice and identify or simply identify information can use this extensive website, FRBO.com.
Ferret out and learn Tenino United States rent houses and rental home in Tenino United States.
Detect, light upon, and distinguish homes for rent by owner in Garfield and Garfield Washington rent houses.
Disclose, notice, and find out apartments for rent Skamania Washington, rental properties in Skamania Washington, house rentals, and condos for rent Skamania Washington.
Rental homes in Canton Massachusetts and Canton Massachusetts vacation homes for rent by owner
Originate and determine Starbuck United States rental properties and vacation homes for rent by owner Starbuck.
Observe and contrive condo rentals in Sprague United States and Sprague United States rental home.
Identify, dig up, and invent the vicinity and convenient Sunnyside city.
See log advertisements, well appointed online MLS, and secluded indexes that landlords and rental owners post on our for rent by owner website.
Explore, notice, and come across vacation rental Grant, Grant Washington rent house, condo rentals Grant Washington, and condos for rent in Grant Washington.
We hatched, occasioned, and originated our page to be gorgeous and beauteous.
Originate, explore, and learn Spokane real estate rentals and holiday rentals in Spokane Washington.
|
|
