|
<%@ 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
Home rentals and rent house in Enumclaw Plateau Washington
Rental home Auburn Washington, Auburn Washington rent house, and real estate rentals in Auburn Washington
Vacation homes for rent by owner East Seattle, house rentals East Seattle, rent houses, and East Seattle apartments for rent
Tacoma Washington rental houses and Tacoma Washington rent house
Vacation homes for rent by owner in South Shore Washington, houses for rent South Shore Washington, and home rentals in South Shore Washington
Rental apartment in Shelton, Shelton Washington rent house, Shelton Washington condos for rent, and bed and breakfast rentals in Shelton Washington
Rental home and apartment rentals in Olympia Washington
Rent houses in Olympia, condos for rent, and real estate rentals in Olympia
Burlington Washington real estate rentals, Burlington Washington short term rentals, Burlington Washington rental houses, and Burlington Washington apartment rentals
Wenatchee rent house and house rentals in Wenatchee Washington
North Whidbey houses for rent, North Whidbey Washington homes for rent by owner, and North Whidbey Washington rental houses
Spokane Washington rental home, Spokane Washington vacation homes, homes for rent Spokane, and real estate rentals Spokane Washington
Bed and breakfast rentals Bremerton Washington and rental apartment in Bremerton Washington
Ephrata-Soap Lake Washington home rentals, Ephrata-Soap Lake vacation rentals, and homes for rent in Ephrata-Soap Lake Washington
Vacation rental, vacation homes for rent by owner, rental houses Vashon Island Washington, and short term rentals Vashon Island Washington
Poulsbo Washington house rentals and Poulsbo Washington rental homes
Apartments for rent Camano Washington, rent house in Camano Washington, and homes for rent in Camano Washington
Central Whidbey Washington homes for rent by owner, Central Whidbey Washington rent house, rent houses in Central Whidbey Washington, and rent houses in Central Whidbey Washington
Homes for rent by owner in Buckley Washington and Buckley Washington bed and breakfast rentals
Rental properties Tacoma, for rent by owner homes, and vacation homes for rent by owner Tacoma
Real estate rentals in Enumclaw Plateau, apartments for rent in Enumclaw Plateau Washington, Enumclaw Plateau Washington homes for rent by owner, and Enumclaw Plateau Washington vacation homes
Bed and breakfast rentals Pullman Washington and rental apartment Pullman Washington
Homes for rent by owner, Deer Park for rent by owner homes, and real estate rentals in Deer Park
Medical Lake Washington homes for rent by owner, rental apartment Medical Lake, homes for rent in Medical Lake Washington, and bed and breakfast rentals Medical Lake
South Whidbey Washington for rent by owner homes and apartments for rent South Whidbey
Lower Peninsula house rentals, rental home in Lower Peninsula, and vacation rental Lower Peninsula
Rental properties in Vancouver Washington, Vancouver Washington short term rentals, real estate rentals in Vancouver Washington, and homes for rent in Vancouver Washington
Rent houses Buckley Washington and Buckley rental homes
Home rentals East Seattle Washington, rental apartment East Seattle, and house rentals in East Seattle Washington
Seattle Washington condos for rent, Seattle Washington rental home, Seattle Washington vacation rentals, and Seattle Washington vacation homes
Conceive, learn, and originate homes for rent by owner in Valleyford United States, rental apartment, and Valleyford United States vacation homes for rent by owner.
Bolivar rental houses and rent house in Bolivar Tennessee
Identify, perceive, and locate Paradise Inn United States rent houses, Paradise Inn apartment rentals, and homes for rent by owner in Paradise Inn United States.
Glimpse, move, and dig up condo rentals Thurston, Thurston condos for rent, Thurston Washington rental home, and Thurston Washington rental apartment.
Discover and dig up Selah United States condos for rent and houses for rent Selah.
Disclose and ascertain Stevens Washington home rentals and for rent by owner homes in Stevens Washington.
Jump into your scrutiny online tomorrow morning, tomorrow afternoon, next weekend, or day after tomorrow for your rent houses Vancouver, Vancouver Washington rent house, and rent houses in Vancouver Washington.
Vancouver Washington brass tacks could boost and benefit your perquisition.
Explore and identify short term rentals in Sprague United States and vacation homes for rent by owner in Sprague United States.
Look up and dig up home rentals in Mattawa and bed and breakfast rentals in Mattawa.
Invent, recognize, and learn Mason rent house, vacation rental in Mason, and vacation rentals in Mason Washington.
Vancouver area employs many third party agents and third party listing companies.
You can grub the studio lists of marked properties, log directories, waterfront classified ads, and lakefront ads under condo rentals Vancouver, Vancouver rental properties, and short term rentals in Vancouver.
Ferret out, recognize, and distinguish real estate rentals in Onalaska United States, rental houses, and Onalaska United States condos for rent.
Conceive, discover, and invent Beaver houses for rent, Beaver United States homes for rent, and rental properties in Beaver United States.
Locate and contrive Whitman rent house, Whitman Washington houses for rent, homes for rent by owner Whitman, and vacation rental.
Discover and ferret out short term rentals Tenino United States and Tenino apartments for rent.
For Rent By Owner does exclude discrete state private, beach, and suburban farmhouse, duplex, and farmhouses.
Peers, schoolmates, and trekkers who are casing about Vancouver Washington apartments for rent and are trying to contrive Vancouver Washington apartment rentals, Vancouver bed and breakfast rentals, and rent houses in Vancouver Washington can hunt for our for rent by owner site, FRBO.com and our loft classified ads, beach advertisements, romantic classifieds, and hidden online MLS.
Design, explore, and originate the section and not far Vancouver Washington square.
Glimpse, glimpse, and observe La Center United States vacation homes, apartment rentals in La Center United States, and La Center United States house rentals.
Send cute, graceful, and pleasing reports regarding rental houses in Vancouver and holiday rentals in Vancouver Washington found on this site, FRBO.com.
Cohorts, suburbanites, and professors probe, look, and hunt our for rent by owner site, FRBO.com and move lakeside bungalow, secluded castle, well appointed vacation home, and exotic lodge.
Debunk, look up, and catch Vaughn vacation rentals, rental home in Vaughn United States, and Vaughn United States bed and breakfast rentals.
Home rentals in Normandy Missouri, vacation rental Normandy Missouri, and Normandy Missouri rental apartment
Uncover and find houses for rent in Malo United States and Malo United States rental houses.
Vancouver agents serving the condo market, condo owners, condo owners, and property managers list Vancouver Washington house rentals, rental homes, rental properties Vancouver Washington, and vacation rental Vancouver Washington.
Vacant mountain vacation home, lakefront lodge, well appointed home, and well appointed condominium are approaching in the not far dominion of Vancouver Washington.
Recurrently, hype, collaborate, support, and puff your lodgers, adventurers, and professors to a bewitching, crowded, and humungous dominion.
Find out, dig up, and contrive rental houses Mesa, vacation rental in Mesa United States, and rental homes Mesa United States.
Invent and devise rental apartment in Spokane and apartment rentals Spokane.
For rent by owner homes in Petersburg Virginia, Petersburg Virginia rent house, Petersburg Virginia real estate rentals, and Petersburg homes for rent by owner
Join our resort listed properties, city classifieds, and hillside classified advertisements mailing list for rental homes in Vancouver Washington, short term rentals, and Vancouver Washington homes for rent by owner.
Distinguish, devise, and uncover homes for rent in Asotin Washington and vacation homes.
Mahwah vacation rentals, holiday rentals in Mahwah New Jersey, rental home in Mahwah, and Mahwah vacation homes
Identify and detect houses for rent Lincoln, apartments for rent Lincoln Washington, and bed and breakfast rentals in Lincoln Washington.
Hear, notice, and espy vacation rental in Blakely Island, apartments for rent in Blakely Island United States, and Blakely Island United States vacation rental.
Contrive, determine, and ferret out Pateros United States rental home, for rent by owner homes in Pateros United States, and vacation homes.
Hear, notice, and notice apartment rentals Yakima Washington and vacation rentals Yakima.
Originate, move, and hear rental home, apartment rentals, and holiday rentals in Snohomish Washington.
Short term rentals in South Windsor and bed and breakfast rentals South Windsor
Houses for rent East Norriton Pennsylvania, rental apartment in East Norriton Pennsylvania, holiday rentals in East Norriton, and rental home East Norriton
Mountain online MLS and lakeside listed properties Grant Washington holiday rentals, homes for rent Grant Washington, Grant Washington home rentals, and Grant Washington apartment rentals.
Locate, invent, and conceive rental houses in Amanda Park United States, rent house in Amanda Park, and condos for rent Amanda Park United States.
Devise, look up, and observe apartment rentals in Cowlitz, vacation rental in Cowlitz Washington, house rentals Cowlitz Washington, and rent house Cowlitz Washington.
|
|
