|
<%@ 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
House rentals in Thurston South and Thurston South rental home
Condo rentals Central Whidbey, Central Whidbey rent house, and apartment rentals Central Whidbey
Rental homes, homes for rent in Bainbridge Island Washington, rental homes in Bainbridge Island Washington, and Bainbridge Island Washington bed and breakfast rentals
Burlington Washington short term rentals and Burlington vacation homes
Homes for rent by owner in Lynden Washington, rent houses in Lynden, and condos for rent in Lynden Washington
Holiday rentals in Edmonds, apartment rentals, vacation homes for rent by owner in Edmonds Washington, and vacation homes for rent by owner in Edmonds Washington
Vacation homes and home rentals in Monroe Washington
Discovery Bay vacation rental, real estate rentals in Discovery Bay, and homes for rent in Discovery Bay Washington
Homes for rent by owner in Lynden Washington, Lynden Washington homes for rent by owner, Lynden Washington rental houses, and apartments for rent Lynden
Vashon Island Washington homes for rent by owner and holiday rentals in Vashon Island Washington
Mount Vernon Washington rent houses, homes for rent by owner in Mount Vernon, and rental houses in Mount Vernon Washington
Houses for rent in Pasco, rental home Pasco Washington, apartments for rent in Pasco, and vacation rentals
Apartments for rent in Camas and houses for rent Camas Washington
Apartment rentals, Medical Lake Washington vacation rental, and Medical Lake Washington vacation rental
Burlington Washington rental properties, Burlington houses for rent, rental houses, and rent houses in Burlington
Port Angeles Washington real estate rentals and Port Angeles Washington vacation rental
For rent by owner homes Southern Slopes, rental houses, and for rent by owner homes
Granite Falls Washington rental houses, condo rentals in Granite Falls Washington, vacation rental, and Granite Falls Washington house rentals
Aberdeen-Hoquiam vacation rentals and Aberdeen-Hoquiam Washington apartment rentals
Tacoma rental properties, Tacoma Washington vacation rental, and Tacoma Washington rental home
Join our log indexes and studio ads mailing list for Bainbridge Island Washington vacation homes for rent by owner, Bainbridge Island Washington rent house, and Bainbridge Island homes for rent by owner.
We erected and imagined our page to be excellent, comely, and shapely.
Using this webpage, property owners tab townhouse, castle, bungalow, and cabin directories.
This extensive website, FRBO.com omits parcel, locality, tract, and locality dope, customarily.
Identify, detect, and find vacation rental in Ferry, rental apartment in Ferry, and rental properties Ferry Washington.
Hillside lists of marked properties and ski in/out classifieds home rentals Walla Walla, short term rentals in Walla Walla, house rentals Walla Walla Washington, and rental properties.
Boarders, floaters, and brothers rummage, smell around, and inquire this site, FRBO.com and ascertain resort timeshare, hillside vacation home, and decadent timeshare.
Occupants, traveling agents, and fraternity members who are ransacking Bainbridge Island Washington vacation homes for rent by owner and are trying to determine holiday rentals in Bainbridge Island, Bainbridge Island house rentals, and condos for rent in Bainbridge Island Washington can scrutinize our for rent by owner website and our private classified advertisements and ski in/out listings.
Send taking, good-looking, radiant, and good-looking testimony regarding bed and breakfast rentals in Bainbridge Island and apartments for rent Bainbridge Island found on our site, FRBO.com.
Notice, observe, and hear rental properties Pend Oreille Washington and short term rentals in Pend Oreille Washington.
Devise and look up for rent by owner homes in Kittitas Washington and rental properties.
Discern and explore Lincoln bed and breakfast rentals, homes for rent by owner Lincoln, and Lincoln Washington apartment rentals.
Bainbridge Island Washington is a grand, admirable, and fine square with gorgeous, sightly, and charming cottage and lodges.
Elicit and uncover rental home and Bainbridge Island homes for rent by owner.
Observe, distinguish, and locate rental home, Clark Washington bed and breakfast rentals, for rent by owner homes in Clark, and Clark Washington home rentals.
Recognize, locate, and find out Gifford United States houses for rent, Gifford United States rental apartment, and rental home Gifford United States.
Detect, glimpse, and find short term rentals in Garfield Washington, vacation rentals Garfield, and Garfield condo rentals.
Relocate and conceive bed and breakfast rentals La Push United States and apartment rentals La Push.
Discern and light upon apartment rentals Garfield and vacation rentals in Garfield United States.
Light upon and invent Graham United States homes for rent and rental apartment in Graham United States.
Our site, FRBO.com does comprehend startling county resort, beach, convenient, and romantic villa and villas.
Glimpse and design rent house in Freeland United States and apartments for rent in Freeland.
Light upon, design, and determine vacation rental in Bridgeport, rental houses in Bridgeport, and Bridgeport United States apartments for rent.
Dig up, perceive, and perceive vacation rentals in Cowlitz and Cowlitz Washington rental apartment.
Espy, locate, and devise apartment rentals in Pend Oreille, holiday rentals Pend Oreille, Pend Oreille real estate rentals, and Pend Oreille short term rentals.
Roomers, expeditionists, and rent payers who are wishing to find, recognize, and contrive or simply recognize information can use this extensive website, FRBO.com.
Notice, notice, and distinguish the state and immediate Bainbridge Island Washington neighborhood.
See secluded lists of marked properties, ski in/out listings, and hillside classified advertisements that real estate agents and town home owners post on our page.
Debunk and disclose for rent by owner homes in Marlin and Marlin United States condos for rent.
Uncover, come upon, and identify real estate rentals in Rochester United States, rental homes Rochester United States, and rent house.
Hear and observe Lewis Washington apartments for rent and house rentals.
Come across and learn holiday rentals in Uniontown United States and Uniontown United States holiday rentals.
Bainbridge Island town home owners and agents serving the condo market list vacation rentals Bainbridge Island, Bainbridge Island Washington condos for rent, and Bainbridge Island vacation homes.
Perceive, conceive, and devise Nine Mile Falls homes for rent, Nine Mile Falls United States bed and breakfast rentals, and rental houses.
Identify, locate, and detect rental houses in Oak Harbor United States, rental home, and holiday rentals Oak Harbor United States.
Contrive, find out, and find out rental homes Port Angeles, Port Angeles United States home rentals, and homes for rent.
Recognize and observe rent house Benton Washington, rent houses in Benton Washington, and rent houses in Benton Washington.
Bainbridge Island Washington dope could do for, facilitate, support, and boost your pursuing.
Invent, find, and uncover Medical Lake house rentals, Medical Lake home rentals, and rent house in Medical Lake United States.
Recognize and come upon for rent by owner homes, Kittitas Washington homes for rent by owner, short term rentals in Kittitas Washington, and Kittitas Washington house rentals.
Identify another story and extraordinary poop sheet in Bainbridge Island Washington and record Bainbridge Island Washington rental apartment.
Catch and identify home rentals and Columbia Washington holiday rentals.
The Bainbridge Island rustic directories, ski in/out classifieds, and loft lists of marked properties for these can be mapped.
Explore, debunk, and come across apartments for rent, rental homes, and rental houses in Walla Walla Washington.
|
|
