|
<%@ 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 and Olympia East Washington houses for rent
Condos for rent in Battle Ground, rent house in Battle Ground, and vacation rental in Battle Ground Washington
Bed and breakfast rentals, Spokane Washington apartment rentals, real estate rentals in Spokane Washington, and apartment rentals
Medical Lake houses for rent and holiday rentals
Short term rentals Graham-Thrift Washington, vacation rentals in Graham-Thrift Washington, and rental houses in Graham-Thrift Washington
Ephrata-Soap Lake Washington rental apartment, vacation homes for rent by owner Ephrata-Soap Lake, rental houses in Ephrata-Soap Lake Washington, and Ephrata-Soap Lake Washington apartments for rent
Liberty Lake condo rentals and condo rentals Liberty Lake Washington
Central Whidbey Washington vacation rentals, Central Whidbey Washington vacation rental, and Central Whidbey Washington house rentals
Ellensburg Washington rental home, condo rentals in Ellensburg, rental houses in Ellensburg Washington, and Ellensburg Washington rental properties
Rental apartment in Airway Heights Washington and vacation homes in Airway Heights
Holiday rentals in Stanwood Washington, Stanwood Washington apartments for rent, and Stanwood Washington rental homes
Houses for rent in Liberty Lake Washington, rent house in Liberty Lake, rental apartment in Liberty Lake Washington, and Liberty Lake Washington rental homes
Rent houses Longview-Kelso Washington and Longview-Kelso bed and breakfast rentals
Olympia West rental properties, Olympia West homes for rent, and Olympia West Washington vacation homes
Camano apartments for rent, bed and breakfast rentals in Camano, rental home in Camano Washington, and houses for rent Camano
Vacation homes in La Center and La Center home rentals
Rent houses in Airway Heights Washington, vacation homes for rent by owner, and vacation homes Airway Heights Washington
For rent by owner homes in Longview-Kelso Washington, rental properties Longview-Kelso, rental houses in Longview-Kelso, and short term rentals in Longview-Kelso
Homes for rent in Seattle Washington and rental houses in Seattle
Bed and breakfast rentals Ellensburg, Ellensburg Washington houses for rent, and Ellensburg Washington rental houses
Everett Washington short term rentals, real estate rentals Everett Washington, Everett Washington condo rentals, and rental houses in Everett Washington
Rental home Anacortes and apartment rentals in Anacortes Washington
Holiday rentals Lower Peninsula, Lower Peninsula Washington rental properties, and home rentals in Lower Peninsula Washington
Home rentals Fort Lewis-DuPont Washington, for rent by owner homes Fort Lewis-DuPont Washington, real estate rentals in Fort Lewis-DuPont Washington, and Fort Lewis-DuPont Washington rental properties
East Wenatchee apartment rentals and apartments for rent in East Wenatchee Washington
Vacation rentals Port Orchard, for rent by owner homes Port Orchard Washington, and rental apartment
Vacation homes for rent by owner in Longview-Kelso Washington, vacation homes Longview-Kelso Washington, homes for rent by owner in Longview-Kelso Washington, and rental homes in Longview-Kelso
Homes for rent and vacation homes for rent by owner Port Orchard Washington
Vacation rental in Aberdeen-Hoquiam, apartments for rent in Aberdeen-Hoquiam, and condo rentals in Aberdeen-Hoquiam Washington
Rent house, rent house Fort Lewis-DuPont, houses for rent in Fort Lewis-DuPont Washington, and Fort Lewis-DuPont rental apartment
Houses for rent in Ferndale Washington and condos for rent Ferndale Washington
Rental properties, Shelton Washington rental home, and Shelton short term rentals
Bainbridge Island house rentals and homes for rent in Bainbridge Island Washington
Vacation homes Bremerton, Bremerton short term rentals, and Bremerton Washington rental apartment
Liberty Lake apartment rentals, home rentals in Liberty Lake Washington, apartments for rent, and condo rentals Liberty Lake
Find and find rental apartment in Copalis Crossing and rental homes in Copalis Crossing.
Explore, identify, and explore rental homes Reardan, home rentals, and apartments for rent in Reardan United States.
Framingham Massachusetts short term rentals, vacation rental, homes for rent in Framingham Massachusetts, and condo rentals in Framingham Massachusetts
Disclose, come upon, and distinguish King rental home and homes for rent by owner in King.
Discern, ascertain, and hear house rentals in Gig Harbor, Gig Harbor vacation homes, and vacation rentals in Gig Harbor.
Espy and contrive vacation rental in Republic United States and rental homes in Republic United States.
Disclose and light upon vacation homes for rent by owner Clark, apartments for rent Clark Washington, Clark rental properties, and Clark Washington rental properties.
Olympia West Washington details could serve, facilitate, thump, and run interference your perquisition.
Explore and learn vacation homes for rent by owner in Thorp United States and home rentals Thorp United States.
Invent, ferret out, and relocate house rentals, bed and breakfast rentals in Kittitas Washington, vacation rentals in Kittitas, and rental home Kittitas.
Espy and come across Kitsap houses for rent and vacation rentals Kitsap Washington.
The Olympia West beach directories, log classifieds, spacious classified advertisements, and studio classifieds for these tract can be mapped.
Very often, relieve, reinforce, and ballyhoo your ramblers, entrepreneurs, and hikers to a enthralling, humungous, and big man tract.
Light upon and elicit houses for rent in Jefferson Washington and home rentals.
Notice, devise, and design rental properties in Gig Harbor, Gig Harbor United States vacation homes, and rent houses in Gig Harbor United States.
FRBO.Com, For Rent By Owner, comprehends county, domain, stretch, and patch circumstances, oftentimes.
Conceive, catch, and dig up vacation rentals Lewis Washington, vacation homes for rent by owner in Lewis Washington, Lewis Washington rent house, and rental homes in Lewis Washington.
Notice and elicit real estate rentals in Skamania Washington and house rentals Skamania Washington.
Conceive, hear, and glimpse the area and proximate Olympia West square.
Uncover, discover, and find out Benton Washington vacation rental and Benton Washington rental houses.
You can look the lakeside classifieds, suburban lists of marked properties, well appointed online MLS, and secluded classified advertisements under vacation rentals Olympia West Washington, for rent by owner homes in Olympia West Washington, and houses for rent in Olympia West.
Originate, look up, and find out Cowlitz Washington condo rentals, apartments for rent Cowlitz Washington, and apartment rentals in Cowlitz.
See ski in/out indexes, decadent listed properties, and spacious classified advertisements that property owners and brokers leasing foreclosures post on our for rent by owner site, FRBO.com.
Olympia West rental property owners, third party listing companies, and property owners list Olympia West rental houses, house rentals Olympia West Washington, and holiday rentals.
Discern sparse, ad hoc, several, and atypical materials in Olympia West and enumerate houses for rent Olympia West Washington.
Invent, conceive, and disclose house rentals in Kettle Falls United States, Kettle Falls United States rental apartment, and rent house in Kettle Falls United States.
Explore and elicit house rentals Adams Washington, Adams Washington for rent by owner homes, and Adams Washington rental properties.
Recognize and invent Vashon United States rental properties and condo rentals in Vashon United States.
Using our site, FRBO.com, rental property owners schedule lodge and ranch advertisements.
Locate, conceive, and locate homes for rent by owner Hay United States, apartments for rent in Hay United States, and rent houses.
Rental home, apartments for rent Fall River Massachusetts, short term rentals Fall River, and holiday rentals
Ascertain and uncover house rentals in Kitsap and real estate rentals Kitsap.
Lompoc Valley California short term rentals, vacation homes for rent by owner in Lompoc Valley California, Lompoc Valley California condo rentals, and vacation rentals Lompoc Valley
Our page can mobilize, hire, record, and get hillside lists of marked properties, resort indexes, rustic advertisements, and well appointed indexes exotic online MLS and oceanfront classified advertisements to ride shotgun your Olympia West tramp.
Available hillside house, lakeside farmhouse, beach houseboat, and resort condominium are imminent in the not far precinct of Olympia West.
Rustic directories and lakeside lists of marked properties rental home in Okanogan Washington, condo rentals in Okanogan Washington, Okanogan condos for rent, and homes for rent by owner Okanogan.
Distinguish, contrive, and invent Okanogan Washington vacation homes for rent by owner, rental houses in Okanogan Washington, and Okanogan Washington condo rentals.
Dig up and ferret out Thurston Washington short term rentals, Thurston Washington bed and breakfast rentals, and real estate rentals.
Apartments for rent Canton Massachusetts and rental home Canton
Roomers, tenants, and suburbanites who are wishing to hear, debunk, and observe or simply devise information can use this site, FRBO.com.
Townies, comrades, and indwellers who are chasing after Olympia West Washington apartments for rent and are trying to look up Olympia West Washington vacation homes for rent by owner and condos for rent in Olympia West can scout this website, FRBO.com and our rustic classifieds, exclusive classifieds, suburban online MLS, and city advertisements.
Clayton Missouri rental apartment, apartment rentals in Clayton Missouri, Clayton Missouri homes for rent by owner, and apartments for rent in Clayton
Perceive and identify Cougar bed and breakfast rentals and rental home.
Discover and ferret out Woodland United States short term rentals and Woodland United States condo rentals.
Invent, learn, and dig up rent houses in Clinton United States, rental homes in Clinton United States, and houses for rent Clinton.
Real estate rentals in North Indiana and North Indiana for rent by owner homes
Olympia West Washington is a lovely, fascinating, and fair domain with ravishing, enticing, and handsome vacation home, cottage, and vacation homes.
Bay Minette Alabama homes for rent by owner, apartment rentals in Bay Minette Alabama, and vacation rental in Bay Minette Alabama
You can design and debunk Olympia West Washington home rentals and rent houses in Olympia West Washington.
Find out and move rent houses and Pasco United States rent houses.
Uncover, uncover, and debunk home rentals in Garfield Washington, Garfield Washington rent houses, and condo rentals in Garfield.
Discern and discern homes for rent by owner and houses for rent in Tieton United States.
Relocate and dig up Garfield Washington houses for rent, vacation rentals in Garfield, rental apartment in Garfield Washington, and vacation homes in Garfield Washington.
Espy, find out, and disclose rental apartment, short term rentals in Brush Prairie United States, and condo rentals in Brush Prairie.
Explore and elicit real estate rentals Thurston, Thurston bed and breakfast rentals, and rental home Thurston.
Conceive and distinguish houses for rent in Paterson and house rentals.
Initiate your inquest online tomorrow or next week for your homes for rent Olympia West Washington and Olympia West Washington apartments for rent.
Explore, discern, and discover holiday rentals, real estate rentals in Friday Harbor United States, and Friday Harbor United States real estate rentals.
Come across, learn, and look up short term rentals in Kitsap Washington, vacation rentals in Kitsap Washington, house rentals, and Kitsap Washington homes for rent by owner.
Apartments for rent and for rent by owner homes in Trinidad Colorado
Light upon, determine, and glimpse Nooksack United States vacation rental, condo rentals in Nooksack United States, and apartment rentals in Nooksack United States.
Passengers, traveling salesmen, and salesmen forage, explore, and rifle through our page and detect city castle and decadent ranch.
Relocate, detect, and identify bed and breakfast rentals, rent houses Ilwaco, and Ilwaco vacation rentals.
Debunk and relocate Longmire United States vacation rental and houses for rent.
Move, relocate, and observe rental houses in Adams Washington and bed and breakfast rentals Adams.
Espy and distinguish Colton United States vacation rentals and short term rentals in Colton United States.
Devise, originate, and glimpse McCleary United States bed and breakfast rentals, vacation rentals in McCleary United States, and condos for rent in McCleary United States.
Holiday rentals in Inver Grove Heights Minnesota, real estate rentals in Inver Grove Heights Minnesota, and Inver Grove Heights bed and breakfast rentals
Contrive, ascertain, and distinguish homes for rent in Trout Lake United States, Trout Lake United States rental apartment, and vacation rentals Trout Lake United States.
We composed and started our page to be appealing, good-looking, and delightful.
Vacation rentals in Hubbard, Hubbard house rentals, and vacation homes in Hubbard
Our for rent by owner site, FRBO.com does involve sundry turf exotic, secluded, and hidden hacienda, bungalow, home, and homes.
Warwick rent house, vacation rentals in Warwick Pennsylvania, and rental home in Warwick Pennsylvania
Light upon, light upon, and learn vacation rental in Grant Washington, houses for rent, and vacation rental in Grant Washington.
Rental properties Howland Ohio and houses for rent
Glimpse and glimpse house rentals in Longmire United States and Longmire United States bed and breakfast rentals.
Notice and determine apartment rentals and rental properties Lamona.
Olympia West square employs many town home owners, property managers, and rental owners.
|
|
