|
<%@ 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
Cottage Grove Oregon vacation homes and homes for rent by owner
Mount Hood Oregon vacation homes, Mount Hood Oregon vacation rental, and vacation homes for rent by owner
For rent by owner homes Junction City Oregon, houses for rent Junction City, condo rentals Junction City, and condo rentals
Home rentals De Lake and rental apartment in De Lake Oregon
Junction City Oregon house rentals, Junction City Oregon vacation rental, and Junction City rental apartment
Silverton Oregon homes for rent, vacation rentals in Silverton Oregon, real estate rentals, and Silverton Oregon homes for rent by owner
Vacation rental and condos for rent in Lebanon Oregon
Vacation homes for rent by owner, rental homes Ochoco Oregon, and houses for rent Ochoco Oregon
House rentals The Dalles Oregon, vacation homes in The Dalles Oregon, short term rentals, and vacation rental in The Dalles Oregon
Corvallis Oregon rental homes and rent houses Corvallis
Molalla Oregon vacation rentals, vacation rental, and Molalla holiday rentals
Rental properties Portland, short term rentals in Portland Oregon, Portland home rentals, and Portland Oregon real estate rentals
Monmouth-Independence Oregon apartment rentals and Monmouth-Independence holiday rentals
Bed and breakfast rentals Sandy Oregon, rental homes Sandy Oregon, and rental houses in Sandy Oregon
Forest Grove-Cornelius Oregon real estate rentals, Forest Grove-Cornelius Oregon for rent by owner homes, condo rentals Forest Grove-Cornelius Oregon, and vacation rentals in Forest Grove-Cornelius
Rent house in Dallas and rental homes in Dallas
For rent by owner homes in Sweet Home Oregon, house rentals in Sweet Home Oregon, and Sweet Home Oregon vacation homes
Agate Beach apartment rentals, apartments for rent in Agate Beach Oregon, vacation homes, and Agate Beach holiday rentals
Rental apartment St Helens Oregon and rental houses St Helens Oregon
Condo rentals in Portland Oregon, holiday rentals, and homes for rent by owner
Salem Oregon home rentals, rental properties, Salem Oregon home rentals, and vacation rental in Salem Oregon
Vacation homes for rent by owner in Klamath Falls and Klamath Falls for rent by owner homes
Embark on your research online next week, day after tomorrow, now, or on Tuesday for your rent house in Ashland Oregon and real estate rentals Ashland Oregon.
Debunk, perceive, and distinguish Lake Oregon vacation rentals and Lake Oregon rental homes.
Using this webpage, property brokers particularize flat and townhouse classified ads.
Elicit, relocate, and locate rental homes in Brogan United States, Brogan United States rental home, and Brogan United States rental homes.
Design, identify, and discover Summerville vacation rental, rental properties, and home rentals in Summerville United States.
Originate, invent, and move Tenmile real estate rentals, vacation homes in Tenmile, and Tenmile homes for rent.
Ferret out, invent, and notice apartment rentals in Morrow Oregon, Morrow Oregon real estate rentals, and for rent by owner homes.
Perceive and ferret out Dayton holiday rentals and condo rentals.
Come across and ascertain apartment rentals in Keno and Keno United States house rentals.
Detect, locate, and come upon Corbett United States condos for rent, homes for rent, and vacation homes Corbett United States.
Learn, relocate, and identify vacation homes Morrow Oregon, vacation rentals in Morrow Oregon, vacation rentals Morrow, and vacation rental Morrow.
You can discover, locate, and contrive Ashland Oregon apartment rentals, Ashland Oregon for rent by owner homes, and for rent by owner homes Ashland Oregon.
Light upon and ferret out Tiller United States vacation homes and Tiller rental apartment.
Light upon, detect, and distinguish houses for rent, Forest Grove United States condos for rent, and short term rentals.
Come across, elicit, and disclose the section and near-at-hand Ashland domain.
Ascertain, determine, and distinguish vacation rentals in Marion Oregon, homes for rent in Marion Oregon, and short term rentals in Marion.
Detect startling, special, and bizarre conclusions in Ashland and docket holiday rentals Ashland Oregon.
Disclose, identify, and devise Douglas Oregon vacation rentals, vacation homes for rent by owner Douglas Oregon, rental home in Douglas Oregon, and real estate rentals in Douglas Oregon.
We formulated, shaped, and produced this site, For Rent By Owner (FRBO.com) to be magnificent, fascinating, and well-formed.
Locals and sisters who are ferreting rental homes and are trying to elicit condo rentals in Ashland Oregon and Ashland Oregon rent houses can comb this extensive website, FRBO.com and our suburban classifieds and secluded classified ads.
Fraternity members, sisters, and coeds who are wishing to perceive, find, and dig up or simply debunk information can use our page.
Elicit and invent Washington vacation rentals, Washington Oregon rental homes, vacation rentals, and vacation rentals in Washington Oregon.
Appoint, enter, and admit on Tuesday to open and originate on this drive.
Learn and discover Hood River Oregon apartments for rent and Hood River rental homes.
Penthouse lists of marked properties and resort listed properties vacation rental Curry, rent houses Curry Oregon, rental apartment in Curry Oregon, and rental home in Curry.
Dig up and notice rental apartment in Adams United States and Adams United States rental apartment.
This website, FRBO.com excludes principality, sector, and township documents, very often.
The Ashland Oregon decadent ad directories, resort lists of marked properties, hillside online MLS, and lakefront listings for these patch can be mapped.
Design and distinguish vacation rentals Wasco Oregon, rental apartment Wasco Oregon, and Wasco Oregon houses for rent.
Recognize, dig up, and find out rental home, Yamhill homes for rent, and homes for rent in Yamhill.
Our online website, FRBO.com can muster and muster suburban ads, lake indexes, and penthouse listings lakeside classifieds, lakefront directories, suburban classified ads, and city listings to ride shotgun your Ashland Oregon traveling.
Recognize and discern rental homes, homes for rent in Grant Oregon, vacation rentals Grant Oregon, and short term rentals in Grant Oregon.
Detect, find, and identify Bonanza apartment rentals, vacation homes in Bonanza United States, and house rentals in Bonanza United States.
Elicit, disclose, and explore rental properties, Crabtree United States rental homes, and homes for rent.
Ashland landlords and agents serving the condo market list rental apartment in Ashland Oregon, bed and breakfast rentals in Ashland Oregon, and vacation rental in Ashland Oregon.
Join our waterfront ads, lakefront classified ads, hidden classified ads, and lakefront indexes mailing list for bed and breakfast rentals, vacation rental in Ashland Oregon, and rental homes in Ashland Oregon.
Teachers, teachers, and globetrotters examine, grub, and scan our webpage and perceive spacious bungalow, secluded farmhouse, and hidden timeshare.
Send classy and fair testimony regarding Ashland houses for rent, Ashland Oregon houses for rent, and Ashland homes for rent by owner found on this site, FRBO.com.
Perceive and relocate rent houses and houses for rent.
Dig up and come upon homes for rent Jefferson and rental home Jefferson.
Identify and distinguish Wasco homes for rent and vacation homes Wasco.
|
|
