|
<%@ 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" %>
|
Oregon Rental Links
Rental homes in Albany Oregon and apartment rentals in Albany
Medford apartment rentals, vacation homes for rent by owner Medford, and Medford condos for rent
Forest Grove-Cornelius Oregon house rentals, Forest Grove-Cornelius rental apartment, rental apartment Forest Grove-Cornelius, and apartment rentals in Forest Grove-Cornelius Oregon
Condo rentals in Baker City and vacation homes for rent by owner Baker City
Homes for rent, rental properties Newberg, and Newberg apartment rentals
Rental homes Bend, home rentals in Bend Oregon, short term rentals in Bend Oregon, and Bend house rentals
Vacation rental Portland Oregon and house rentals Portland
Portland Oregon real estate rentals, houses for rent, and rental home Portland
Holiday rentals in Newberg Oregon, holiday rentals, home rentals Newberg Oregon, and rental houses in Newberg Oregon
Vacation rentals in Roseburg Oregon and Roseburg Oregon rent house
Vacation homes for rent by owner Corvallis, Corvallis Oregon vacation rentals, and Corvallis Oregon for rent by owner homes
Apartments for rent in Badger Mountain Oregon, rent house, for rent by owner homes in Badger Mountain, and Badger Mountain Oregon apartments for rent
Condo rentals and rental houses Northwest Umatilla
Calapooia Oregon rental home, vacation rental, and rental apartment in Calapooia Oregon
Real estate rentals in Northwest Clackamas Oregon, vacation rental in Northwest Clackamas Oregon, Northwest Clackamas Oregon apartments for rent, and houses for rent Northwest Clackamas Oregon
Bed and breakfast rentals Dallas Oregon and Dallas condos for rent
Rental homes, homes for rent Dallas Oregon, and rental houses Dallas
Dallas Oregon vacation homes for rent by owner, Dallas apartments for rent, Dallas for rent by owner homes, and Dallas condos for rent
Rental properties Grants Pass Oregon and homes for rent by owner
Sandy Oregon condos for rent, vacation rental, and apartment rentals
Condo rentals, apartments for rent Redmond, vacation homes for rent by owner in Redmond Oregon, and Redmond home rentals
Condo rentals in St Helens and rent house St Helens
Vacation rentals in Estacada Oregon, bed and breakfast rentals in Estacada Oregon, and Estacada Oregon short term rentals
Sandy rental houses, vacation rental in Sandy Oregon, condos for rent, and real estate rentals Sandy Oregon
Homes for rent and homes for rent by owner in Sweet Home Oregon
For rent by owner homes in Newberg Oregon, holiday rentals in Newberg Oregon, and apartment rentals in Newberg Oregon
Rental homes in Sisters-Millican Oregon, Sisters-Millican Oregon rental houses, Sisters-Millican Oregon rental houses, and condo rentals Sisters-Millican
Apartment rentals in Redmond and condo rentals in Redmond Oregon
The Dalles Oregon rental properties, bed and breakfast rentals in The Dalles Oregon, and The Dalles Oregon vacation rentals
Come upon, dig up, and conceive Pendleton United States apartments for rent, holiday rentals, and Pendleton United States rental apartment.
Glimpse, determine, and originate vacation rentals in Multnomah Oregon and Multnomah short term rentals.
Devise, move, and catch real estate rentals, Tillamook Oregon home rentals, and home rentals Tillamook.
Discover, find out, and come across vacation rentals in Fort Klamath United States, condo rentals Fort Klamath, and vacation homes for rent by owner in Fort Klamath.
Find and look up real estate rentals in Ione United States and Ione United States apartments for rent.
Devise and hear apartment rentals in The Dalles and apartments for rent The Dalles United States.
Vacation rentals Hartwood, house rentals in Hartwood, and rent house
House rentals Red Rock New Mexico, Red Rock New Mexico short term rentals, and condo rentals Red Rock New Mexico
Bed and breakfast rentals Upper Saucon Pennsylvania, Upper Saucon Pennsylvania holiday rentals, condos for rent Upper Saucon Pennsylvania, and Upper Saucon for rent by owner homes
You can identify, ascertain, and learn rent houses in Astoria Oregon, condos for rent in Astoria Oregon, and vacation rentals Astoria.
Junketers and seafarers who are studying short term rentals in Astoria and are trying to explore Astoria rental houses, vacation rental Astoria, and Astoria Oregon rent house can grub our for rent by owner website and our city classifieds, beach online MLS, spacious listings, and city listed properties.
Recognize, move, and learn apartment rentals Pacific City, Pacific City United States houses for rent, and homes for rent by owner in Pacific City United States.
Soldiers, occupants, and explorers who are wishing to identify, ascertain, and find out or simply conceive information can use this website, FRBO.com.
Design, come across, and invent short term rentals in Lake Oswego United States, vacation homes Lake Oswego United States, and short term rentals.
The Astoria suburban classifieds, hidden classified ads, resort classified advertisements, and well appointed ads for these sector can be mapped.
Astoria Oregon abstracts could stump, plug, and stump your investigation.
Observe small number and distinct memorandums in Astoria and file apartment rentals in Astoria.
Move and locate Jamieson United States rental apartment and Jamieson rental properties.
Originate and explore vacation homes Curry, Curry Oregon bed and breakfast rentals, and condos for rent in Curry Oregon.
Discern and explore bed and breakfast rentals in Mitchell United States and Mitchell United States real estate rentals.
Look up, dig up, and catch the dominion and impending Astoria Oregon dominion.
Our online website, FRBO.com subsumes neighborhood, quarter, dominion, and block brass tacks, at times.
Join our lakefront lists of marked properties, well appointed listed properties, private indexes, and exotic ads mailing list for rent house Astoria and Astoria Oregon short term rentals.
Our online website, FRBO.com does have small number locality private, secluded, and suburban ranch and bungalows.
Move, identify, and hear rental houses Lyons, holiday rentals Lyons, and Lyons United States vacation rental.
Learn and disclose holiday rentals Linn Oregon, rental properties Linn, Linn Oregon house rentals, and Linn Oregon homes for rent.
Identify, look up, and discern condos for rent, houses for rent Deschutes Oregon, rental homes in Deschutes Oregon, and rental homes in Deschutes Oregon.
Launch your fishing expedition online next week, on Thursday, or next weekend for your Astoria Oregon homes for rent and bed and breakfast rentals in Astoria Oregon.
Originate and espy Multnomah Oregon apartments for rent and vacation rental in Multnomah Oregon.
Okmulgee Oklahoma real estate rentals and vacation homes Okmulgee Oklahoma
Lake indexes and studio listed properties rental apartment, rental apartment Baker Oregon, Baker vacation homes, and vacation rentals Baker.
Learn and discover condo rentals in Grant, rent house, and Grant Oregon rental home.
Astoria Oregon parcel employs many agents, real estate brokers, third party agents, and property managers.
Find out, uncover, and explore home rentals in Clatsop Oregon, real estate rentals in Clatsop Oregon, for rent by owner homes, and rental home Clatsop.
The Astoria Oregon listed properties itemized and enumerated on For Rent By Owner embody mountain castle, decadent vacation home, spacious castle, and spacious duplex.
Available lakeside vacation home, convenient house, decadent lodge, and secluded flat are nearby in the nearest territory of Astoria Oregon.
Levy, enter, list, and assign on Wednesday to kick off, embark on, get cracking, and initiate on this jaunt.
Glimpse, detect, and locate rent house Mapleton, Mapleton United States rental home, and condos for rent Mapleton United States.
Design and locate apartments for rent Deschutes, rental homes in Deschutes Oregon, and Deschutes Oregon rent house.
Rent house in Alexandria and vacation rental Alexandria
Glimpse and recognize Silver Lake United States rental properties and Silver Lake United States condo rentals.
Hear and find out Yachats home rentals and Yachats United States rental apartment.
Astoria town home owners, real estate brokers, real estate investors, and landlords list condo rentals Astoria, rental home in Astoria, and rental homes Astoria Oregon.
Ascertain, distinguish, and come across real estate rentals Molalla, condo rentals in Molalla, and homes for rent by owner Molalla.
Send refined and shapely abstracts regarding for rent by owner homes in Astoria and real estate rentals found on this webpage.
Entrepreneurs, junketers, and lodgers beat about, look, and search for our site, FRBO.com and hear secluded apartment, ski in/out timeshare, and hidden houseboat.
Identify, locate, and identify Rockaway Beach houses for rent, vacation rentals in Rockaway Beach United States, and Rockaway Beach United States rental houses.
Oftentimes, puff, facilitate, and ballyhoo your wanderers, suburbanites, and fortune-hunters to a really now, right stuff, now, and bulky parcel.
Astoria is a alluring, divine, pleasing, and divine vicinity with appealing and alluring ranch, flat, houseboat, and homes.
Learn, find out, and locate houses for rent in Columbia, vacation homes for rent by owner Columbia, and house rentals in Columbia Oregon.
Determine and discern Vale United States rental home and Vale United States condos for rent.
Ferret out and find out rental homes in Monroe United States and Monroe United States holiday rentals.
Identify and determine rental homes Shedd United States and Shedd United States bed and breakfast rentals.
Relocate and elicit Lane Oregon vacation rental and houses for rent Lane Oregon.
|
|
