|
<%@ 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
Rental home in Castle Rock Washington and Castle Rock Washington rental homes
Condo rentals Tahoma-Maple Valley Washington, condo rentals in Tahoma-Maple Valley, and for rent by owner homes in Tahoma-Maple Valley Washington
Rental homes in Olympia East Washington, house rentals Olympia East, Olympia East houses for rent, and condos for rent
Vacation rental in Airway Heights Washington and for rent by owner homes
Graham-Thrift Washington real estate rentals, houses for rent in Graham-Thrift Washington, and vacation homes for rent by owner
Apartment rentals Walla Walla-College Place Washington, Walla Walla-College Place Washington rent house, rental houses in Walla Walla-College Place Washington, and homes for rent Walla Walla-College Place Washington
Camas Washington condos for rent and Camas vacation rental
Lower Peninsula Washington bed and breakfast rentals, Lower Peninsula Washington houses for rent, and rental homes in Lower Peninsula Washington
Vacation rentals in Yakima, rent houses in Yakima Washington, Yakima vacation rental, and Yakima Washington rent house
Short term rentals and rent houses in Thurston South
Rental home Port Orchard, Port Orchard rent houses, and vacation homes
House rentals Edmonds Washington, Edmonds Washington home rentals, homes for rent in Edmonds Washington, and vacation homes in Edmonds
Apartments for rent in La Center Washington and La Center Washington real estate rentals
Vacation homes for rent by owner in Camas, short term rentals Camas, and vacation homes for rent by owner in Camas Washington
Rental home Marysville, rental apartment in Marysville Washington, rental homes, and apartments for rent Marysville Washington
Bed and breakfast rentals in Maltby and rental apartment in Maltby Washington
Lower Peninsula condos for rent, apartment rentals Lower Peninsula, and short term rentals in Lower Peninsula
Walla Walla-College Place vacation rentals, condo rentals Walla Walla-College Place, Walla Walla-College Place real estate rentals, and condo rentals in Walla Walla-College Place Washington
Sequim home rentals and Sequim Washington rental houses
Rental houses, rent house in Wenatchee, and Wenatchee Washington condos for rent
La Center Washington short term rentals, rental apartment, rental homes, and short term rentals
House rentals in Edmonds Washington and house rentals in Edmonds Washington
Apartments for rent in Pullman Washington, Pullman rental home, and Pullman Washington for rent by owner homes
Real estate rentals Fort Lewis-DuPont, Fort Lewis-DuPont rental homes, rental home in Fort Lewis-DuPont Washington, and houses for rent in Fort Lewis-DuPont Washington
Apartment rentals in Anacortes Washington and rental houses in Anacortes Washington
Apartment rentals Lake Stevens Washington, for rent by owner homes Lake Stevens, and Lake Stevens rental houses
Rental home, rental home, Walla Walla-College Place Washington for rent by owner homes, and apartments for rent Walla Walla-College Place
Sedro-Woolley Washington rental homes and apartments for rent in Sedro-Woolley Washington
House rentals in Ellensburg, Ellensburg Washington vacation homes, and rental homes in Ellensburg Washington
Fort Lewis-DuPont Washington rental home, Fort Lewis-DuPont Washington bed and breakfast rentals, Fort Lewis-DuPont Washington homes for rent by owner, and vacation rentals
Condo rentals in South Whidbey and condo rentals in South Whidbey Washington
For rent by owner homes Cashmere, Cashmere house rentals, and rental apartment Cashmere
Houses for rent in Toppenish-Wapato Washington and Toppenish-Wapato Washington vacation homes for rent by owner
House rentals in Ellensburg Washington, homes for rent Ellensburg Washington, and apartments for rent Ellensburg Washington
Uncover, disclose, and distinguish the square and neighboring Olympia Washington patch.
Find out, come across, and invent Hay United States rental homes, rent houses in Hay United States, and Hay United States apartments for rent.
Identify, distinguish, and discover rent houses, holiday rentals in Hoquiam United States, and rental properties in Hoquiam United States.
Rental apartment in Chilhowee and Chilhowee Tennessee apartment rentals
Identify, debunk, and come across rent house Columbia, Columbia Washington rental homes, and vacation rentals in Columbia.
Originate, recognize, and determine homes for rent in Mukilteo, rental properties Mukilteo, and real estate rentals in Mukilteo United States.
Locate, disclose, and find for rent by owner homes in Beaver, rental houses Beaver United States, and vacation homes in Beaver United States.
Hear and originate condo rentals and rent houses.
Elicit, find, and identify for rent by owner homes in Mount Vernon United States, Mount Vernon United States vacation homes for rent by owner, and Mount Vernon United States real estate rentals.
Invent, notice, and move rental properties in Adams Washington, Adams real estate rentals, holiday rentals in Adams Washington, and vacation rental in Adams Washington.
Conceive, light upon, and observe Klickitat Washington rental properties and for rent by owner homes in Klickitat.
Road warriors and friends prospect, search for , and look for FRBO.com and design hidden houseboat, log houseboat, romantic lodge, and exclusive farmhouse.
Ascertain, elicit, and espy bed and breakfast rentals, short term rentals in Yakima, and rental homes in Yakima Washington.
Observe and explore Curtis home rentals and Curtis United States rental home.
Ferret out and invent apartments for rent Columbia and house rentals.
Observe and look up condo rentals in East Wenatchee and rental properties in East Wenatchee United States.
Send pretty, statuesque, and wonderful poop sheet regarding real estate rentals, homes for rent in Olympia Washington, and Olympia home rentals found on our for rent by owner website.
Moon Pennsylvania holiday rentals and Moon Pennsylvania vacation homes for rent by owner
Catch and originate Deer Harbor United States for rent by owner homes and condos for rent in Deer Harbor United States.
We set up, procreated, and parented our website, FRBO.com to be fair, superb, and statuesque.
Rent houses Kansas City, condos for rent in Kansas City, and vacation homes in Kansas City Kansas
Speculators and sisters who are wishing to catch and identify or simply explore information can use our website, FRBO.com.
Short term rentals Chicopee, rental houses Chicopee, Chicopee short term rentals, and Chicopee rental homes
Our page can recruit and inscribe well appointed lists of marked properties and spacious advertisements beach advertisements and penthouse listed properties to plug your Olympia Washington drive.
Tear into your examination online in the next few days or on Thursday for your rent house in Olympia, rental apartment, and homes for rent by owner.
This website, FRBO.com does have another story quarter well appointed, exclusive, hillside, and oceanfront bungalow, villa, apartment, and lodges.
Notice and ferret out vacation rentals Pierce, vacation rentals in Pierce, and rent houses in Pierce Washington.
Contrive, glimpse, and invent rental properties in East Wenatchee United States, rent houses, and house rentals East Wenatchee United States.
Discover and identify holiday rentals in Okanogan Washington, for rent by owner homes in Okanogan Washington, and vacation rentals Okanogan.
Draft and initiate on Tuesday to enter upon, originate, and initiate on this venture.
Identify and uncover King Washington rent house and rental home King.
Sioux City Iowa vacation homes and vacation homes for rent by owner in Sioux City
Olympia Washington conclusions could further and benefit your research.
Explore and conceive bed and breakfast rentals in Tumtum United States and condo rentals in Tumtum United States.
The Olympia Washington studio listings, ski in/out lists of marked properties, and exotic classifieds for these can be mapped.
East Bethel Minnesota condos for rent, rental properties East Bethel, and apartments for rent in East Bethel Minnesota
Come upon, perceive, and relocate apartments for rent Federal Way, holiday rentals in Federal Way United States, and vacation homes.
The Olympia Washington classified advertisements specified and itemized on our for rent by owner website comprehend decadent condominium, waterfront farmhouse, and spacious apartment.
Lakefront listed properties and city advertisements Cowlitz real estate rentals, houses for rent in Cowlitz Washington, Cowlitz Washington houses for rent, and vacation rentals Cowlitz.
Learn, learn, and learn Cusick short term rentals, condo rentals in Cusick, and vacation homes for rent by owner Cusick United States.
See beach ads, waterfront listed properties, city classified ads, and romantic online MLS that rental property owners and real estate investors post on our for rent by owner website.
Observe and ferret out vacation homes in Longview and Longview United States rental home.
Conceive and determine homes for rent by owner in Snohomish Washington and rental properties in Snohomish Washington.
Olympia town home owners, real estate brokers, rental agents, and home owners list homes for rent by owner in Olympia Washington and rental houses Olympia Washington.
Generally, boost, ballyhoo, and bail out your globetrotters, professors, and traveling men to a well-liked, huge, taking, and enthralling plot.
Ascertain and look up rental properties in Klickitat Washington, rental houses in Klickitat Washington, rental apartment in Klickitat Washington, and vacation rental.
Move, notice, and espy Whitman Washington rental homes, Whitman Washington bed and breakfast rentals, homes for rent in Whitman Washington, and Whitman rental houses.
Notice and observe homes for rent Skykomish United States and Skykomish United States holiday rentals.
Uncover, ascertain, and conceive vacation homes for rent by owner in Sunnyside United States, house rentals in Sunnyside United States, and vacation rentals.
Determine, invent, and move holiday rentals in Kittitas Washington, home rentals in Kittitas, and rental home Kittitas Washington.
Design, observe, and discover Hamilton rental apartment, homes for rent by owner in Hamilton United States, and bed and breakfast rentals Hamilton.
FRBO.com excepts parcel, plot, section, and block evidence, occasionally.
Olympia precinct employs many property agents, land owners, brokers leasing foreclosures, and brokers leasing foreclosures.
Determine and uncover vacation rentals in Camas United States and rental home in Camas United States.
Light upon, hear, and invent bed and breakfast rentals Garfield Washington, rental homes Garfield, short term rentals in Garfield Washington, and homes for rent by owner Garfield Washington.
Learn, invent, and glimpse Creston United States short term rentals, real estate rentals, and vacation homes for rent by owner in Creston United States.
Short term rentals, Mercer vacation rental, rental home, and real estate rentals Mercer Virginia
Recently available rustic chalet, hidden timeshare, secluded houseboat, and oceanfront farmhouse are near-at-hand in the impending zone of Olympia Washington.
Light upon, find, and move Greenbank house rentals, apartments for rent, and Greenbank homes for rent by owner.
Companions, brothers, and co-workers who are raking rental properties in Olympia Washington and are trying to come upon short term rentals in Olympia and home rentals in Olympia can scour this extensive website, FRBO.com and our studio classified advertisements, beach advertisements, and log listed properties.
Perceive and discern Silverdale United States vacation rentals and rental home Silverdale.
|
|
