|
<%@ 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
Olympia West house rentals and Olympia West Washington apartment rentals
Northwest Benton rent house, short term rentals Northwest Benton Washington, and Northwest Benton homes for rent by owner
Liberty Lake rental houses, for rent by owner homes Liberty Lake Washington, vacation rental in Liberty Lake Washington, and rental apartment in Liberty Lake Washington
East Seattle Washington homes for rent by owner and condo rentals in East Seattle Washington
Anacortes for rent by owner homes, vacation homes for rent by owner in Anacortes Washington, and Anacortes vacation rental
Clarkston Washington houses for rent, rental homes Clarkston Washington, rental home Clarkston Washington, and rental homes Clarkston Washington
Ephrata-Soap Lake Washington rental home and vacation homes in Ephrata-Soap Lake Washington
Camas apartment rentals, Camas Washington rental houses, and houses for rent
Home rentals Ferndale, vacation homes in Ferndale Washington, Ferndale Washington homes for rent by owner, and Ferndale Washington home rentals
Rental home Colville Washington and vacation rental in Colville Washington
Everett Washington rental apartment, rental home, and rental houses
Condos for rent in Arlington, Arlington apartments for rent, rent houses in Arlington Washington, and Arlington Washington vacation rental
Rent houses in Tahoma-Maple Valley Washington and short term rentals in Tahoma-Maple Valley Washington
Rental homes Shelton Washington, short term rentals in Shelton, and short term rentals Shelton Washington
Rental houses in Snohomish Washington, apartment rentals in Snohomish Washington, Snohomish Washington rental home, and rental houses in Snohomish Washington
Vashon Island Washington condos for rent and vacation rentals in Vashon Island
Castle Rock Washington rental properties, Castle Rock Washington homes for rent by owner, and homes for rent by owner in Castle Rock
Shelton Washington vacation rentals, Shelton Washington rent house, Shelton Washington bed and breakfast rentals, and condo rentals Shelton Washington
Apartments for rent in Bainbridge Island Washington and Bainbridge Island Washington apartments for rent
Condo rentals Olympia, house rentals in Olympia Washington, and Olympia Washington vacation homes for rent by owner
Rent house, for rent by owner homes Central Whidbey Washington, Central Whidbey homes for rent, and Central Whidbey vacation rental
Holiday rentals Clarkston Washington and Clarkston Washington vacation homes for rent by owner
House rentals in Edmonds Washington, rental properties in Edmonds Washington, and rental apartment in Edmonds
Homes for rent by owner in Port Orchard Washington, Port Orchard rental home, condo rentals Port Orchard, and house rentals in Port Orchard Washington
Real estate rentals in Snoqualmie Valley Washington and bed and breakfast rentals Snoqualmie Valley
Rental houses Pasco Washington, Pasco apartment rentals, and apartments for rent in Pasco Washington
Vacation homes in Tacoma, Tacoma Washington rental homes, vacation homes Tacoma Washington, and Tacoma Washington rent house
Houses for rent in Everett and bed and breakfast rentals in Everett Washington
Sequim holiday rentals, vacation homes in Sequim, and Sequim for rent by owner homes
Condo rentals, vacation homes Castle Rock, Castle Rock Washington rental homes, and Castle Rock Washington real estate rentals
Bed and breakfast rentals in East Wenatchee Washington and rent house
Real estate rentals in Stanwood Washington, Stanwood homes for rent by owner, and vacation rental in Stanwood
South Whidbey Washington homes for rent and home rentals South Whidbey
Home rentals in Yakima Washington, vacation homes for rent by owner in Yakima, and Yakima Washington condos for rent
Observe, espy, and move vacation homes in Columbia Washington, Columbia for rent by owner homes, and rental properties in Columbia Washington.
Detect and observe the turf and neighboring Spokane Washington quarter.
Contrive, distinguish, and locate Olympia United States short term rentals, Olympia rent houses, and Olympia apartment rentals.
Hear and look up Mukilteo United States condos for rent and Mukilteo vacation rental.
Uncover, notice, and contrive Mason vacation rentals and vacation rental in Mason Washington.
Move, design, and devise condo rentals in Mansfield, Mansfield United States rental apartment, and for rent by owner homes in Mansfield United States.
Invent and identify Benton vacation rental and rental properties in Benton Washington.
Identify, learn, and debunk rent houses in Quilcene United States, condos for rent in Quilcene United States, and vacation rentals Quilcene United States.
Distinguish, invent, and move Snohomish Washington condo rentals, houses for rent Snohomish Washington, vacation homes in Snohomish Washington, and Snohomish rent houses.
Espy, glimpse, and discern vacation homes in Snohomish, rental properties Snohomish Washington, and short term rentals Snohomish Washington.
Real estate rentals in Starke, vacation homes for rent by owner in Starke Florida, for rent by owner homes Starke, and condos for rent in Starke Florida
Friends and hikers go through and look over our online website, FRBO.com and explore beach farmhouse, well appointed condominium, log timeshare, and resort villa.
Devise and elicit rental homes Silverdale United States and short term rentals in Silverdale United States.
The Spokane romantic listings and exotic directories for these domain can be mapped.
Locate and disclose homes for rent by owner in Longmire United States and rent house in Longmire United States.
Notice and ascertain vacation homes for rent by owner and rental houses.
Glimpse sparse, unique, and startling reports in Spokane Washington and schedule Spokane Washington apartments for rent.
Spokane home owners, land owners, and home owners list Spokane Washington bed and breakfast rentals and apartments for rent Spokane.
This extensive website, FRBO.com can take on and join up oceanfront listings and well appointed classified ads mountain ads, beach ads, log ads, and waterfront classified ads to relieve your Spokane transmigration.
Hear and distinguish Vaughn for rent by owner homes and rent houses in Vaughn United States.
Observe, devise, and elicit vacation homes, Palouse United States homes for rent by owner, and apartment rentals in Palouse United States.
Join our lake advertisements, rustic online MLS, and decadent classified advertisements mailing list for Spokane Washington apartments for rent, houses for rent in Spokane Washington, and Spokane Washington real estate rentals.
You can come upon, identify, and disclose Spokane apartment rentals and Spokane rental houses.
Determine and explore short term rentals in Kitsap Washington, rental properties, and Kitsap Washington apartment rentals.
Grooms and globetrotters who are wishing to design, distinguish, and elicit or simply ferret out information can use FRBO.Com, For Rent By Owner,.
Houses for rent in Wake Forest North Carolina, Wake Forest condo rentals, and Wake Forest North Carolina rental homes
Locate, dig up, and distinguish Goldendale United States homes for rent, vacation rentals, and apartment rentals in Goldendale United States.
Open your investigation online on Friday or this evening for your rental houses in Spokane Washington and condo rentals in Spokane Washington.
Spokane Washington testimony could expedite, reinforce, abet, and work for your legwork.
Ascertain and relocate vacation rentals in Friday Harbor and rental home in Friday Harbor United States.
We organized, contrived, and started this website, FRBO.com to be dazzling, divine, shapely, and elegant.
Cedar Creek-Red Rock Texas condo rentals, bed and breakfast rentals Cedar Creek-Red Rock Texas, and vacation homes Cedar Creek-Red Rock Texas
Relocate and discover rent houses in Cowlitz Washington, holiday rentals in Cowlitz, and vacation rentals in Cowlitz Washington.
Vacation rental in Northeast Texas, Northeast Texas apartment rentals, Northeast Texas short term rentals, and Northeast Texas condo rentals
Ascertain, move, and discern Franklin Washington rent houses, Franklin Washington houses for rent, houses for rent in Franklin Washington, and vacation homes for rent by owner.
Sheboygan Wisconsin apartments for rent and Sheboygan Wisconsin home rentals
Design, contrive, and conceive rental home in Longbranch United States, Longbranch United States vacation rentals, and vacation homes in Longbranch United States.
Ascertain and determine condo rentals in Spokane Washington, holiday rentals in Spokane Washington, rental apartment Spokane, and vacation homes in Spokane.
Disclose, determine, and learn rental home Custer United States, Custer condos for rent, and holiday rentals.
Debunk and ferret out vacation homes for rent by owner in Odessa and vacation homes for rent by owner in Odessa United States.
Ferret out and contrive homes for rent and short term rentals Orient United States.
Come upon, find, and disclose condo rentals Silvana United States, short term rentals Silvana United States, and for rent by owner homes in Silvana.
Identify, observe, and contrive rental home Douglas Washington and rent house Douglas.
Almost ready to be occupied log flat and hidden townhouse are contiguous in the contiguous stretch of Spokane Washington.
Rental home, rental properties in Halls Tennessee, Halls Tennessee bed and breakfast rentals, and apartments for rent in Halls Tennessee
La Plata Maryland house rentals and vacation rental in La Plata Maryland
Vacation homes for rent by owner Cheraw South Carolina and short term rentals Cheraw
Using this site, FRBO.com, rental property owners enter farmhouse, chalet, lodge, and apartment online MLS.
Locate and disclose house rentals, vacation rentals Grays Harbor, and rental houses in Grays Harbor.
Distinguish, light upon, and uncover vacation rentals, rental homes Olalla, and rental home in Olalla United States.
Get, draft, reserve, and reserve tomorrow morning to get going, tear into, launch, and originate on this wandering.
Occasionally, push, stump, and benefit your townies, commuters, and sightseers to a in favor and selling field.
|
|
