|
<%@ 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
Short term rentals in Ashland and for rent by owner homes in Ashland
Real estate rentals in North Siuslaw, North Siuslaw houses for rent, and North Siuslaw Oregon rental properties
Apartments for rent in Redmond Oregon, house rentals Redmond, rent house in Redmond, and Redmond Oregon rental apartment
Rental apartment in Agate Beach and Agate Beach apartments for rent
Vacation rental Southwest Jackson, bed and breakfast rentals in Southwest Jackson Oregon, and rent house Southwest Jackson
Rental home Pendleton, rent house in Pendleton Oregon, houses for rent in Pendleton Oregon, and vacation rental Pendleton
Apartment rentals Woodburn and holiday rentals in Woodburn Oregon
Houses for rent in La Grande Oregon, La Grande homes for rent by owner, and La Grande Oregon bed and breakfast rentals
Somerset West-Rock Creek Oregon vacation homes, short term rentals in Somerset West-Rock Creek Oregon, rental apartment in Somerset West-Rock Creek, and Somerset West-Rock Creek Oregon rental homes
Homes for rent Cottage Grove Oregon and houses for rent Cottage Grove Oregon
Real estate rentals in Tillamook Oregon, apartments for rent Tillamook Oregon, and short term rentals
Condo rentals, rental houses in Jefferson Oregon, rental home Jefferson, and Jefferson Oregon vacation homes for rent by owner
Rent house in Sisters-Millican Oregon and rent house Sisters-Millican Oregon
Houses for rent in Portland Oregon, rental properties in Portland Oregon, and rental apartment
Rent houses, condos for rent in North Siuslaw, rental homes North Siuslaw, and North Siuslaw vacation rentals
Ashland Oregon rental home and condos for rent
Condo rentals in Junction City Oregon, homes for rent by owner Junction City Oregon, and for rent by owner homes Junction City
Vacation rental in Eugene-Springfield Oregon, vacation rental Eugene-Springfield, real estate rentals, and holiday rentals Eugene-Springfield
Hood River Oregon rental properties and rental apartment Hood River
Jefferson Oregon houses for rent, Jefferson rent house, and vacation rentals Jefferson Oregon
Holiday rentals in Molalla, for rent by owner homes in Molalla, house rentals, and rental homes Molalla Oregon
Homes for rent and vacation rental
Short term rentals in Northeast Umatilla, Northeast Umatilla for rent by owner homes, and condo rentals in Northeast Umatilla
Junction City Oregon rental apartment, apartment rentals in Junction City, vacation rental Junction City Oregon, and rent houses Junction City Oregon
Rental apartment Silverton and Silverton rent houses
Hear, move, and ascertain Fields United States real estate rentals, home rentals in Fields United States, and rent houses in Fields United States.
Light upon, uncover, and relocate rental homes in Dorena United States, homes for rent by owner in Dorena United States, and rental properties in Dorena United States.
Learn and explore Union United States rental houses and bed and breakfast rentals in Union United States.
Look up, debunk, and notice Deadwood United States vacation homes, Deadwood United States house rentals, and rental home.
Elicit, find out, and invent apartment rentals in Gilliam Oregon, rental home in Gilliam, home rentals in Gilliam Oregon, and Gilliam homes for rent.
Debunk, identify, and come upon vacation homes Deschutes Oregon and apartments for rent Deschutes Oregon.
Come across and identify condo rentals in Otis and Otis United States rental houses.
The Badger Mountain classified ads scheduled and detailed on our for rent by owner site, FRBO.com embody beach cabin, resort lodge, spacious flat, and penthouse condominium.
Penthouse classifieds and studio advertisements Benton apartments for rent, Benton Oregon homes for rent, Benton Oregon home rentals, and Benton Oregon real estate rentals.
Catch, light upon, and notice house rentals Benton Oregon and apartment rentals Benton.
Identify and relocate Union rental homes, Union Oregon apartment rentals, Union home rentals, and Union Oregon house rentals.
Badger Mountain Oregon is a statuesque, wonderful, splendid, and appealing quarter with good-looking and radiant ranch and condominiums.
Originate, distinguish, and locate vacation rental in Paisley, Paisley United States condos for rent, and houses for rent Paisley United States.
Learn and notice home rentals Blue River and Blue River United States homes for rent by owner.
Hear and originate Yamhill Oregon rental homes and real estate rentals in Yamhill Oregon.
See beachfront ad directories, loft indexes, and oceanfront lists of marked properties that home owners and real estate brokers post on FRBO.Com, For Rent By Owner,.
FRBO.com excepts territory, neighborhood, tract, and principality results, at times.
Move, relocate, and come across apartments for rent, Kerby United States homes for rent, and Kerby rental houses.
Disclose, identify, and glimpse the patch and immediate Badger Mountain township.
Espy, come upon, and light upon real estate rentals Harney, for rent by owner homes Harney Oregon, and house rentals in Harney Oregon.
Discover special and specialized score in Badger Mountain and write down rental homes Badger Mountain Oregon.
Design and come upon Hood River rental properties, Hood River Oregon real estate rentals, and apartment rentals Hood River.
Dig up, identify, and discover Morrow Oregon rental properties, rental homes in Morrow Oregon, and home rentals Morrow Oregon.
Explore and identify rent house in Wallowa and Wallowa Oregon condos for rent.
Move and learn vacation rentals and rental apartment.
Light upon and discern rent houses Union and rental home.
Jump into your hunt online day after tomorrow, tomorrow, on Friday, or in the morning for your holiday rentals and rental home in Badger Mountain.
Our for rent by owner site, FRBO.com does have particular city oceanfront and rustic vacation home and apartments.
The Badger Mountain Oregon beachfront classified advertisements and city ads for these principality can be mapped.
Contrive, disclose, and determine Jackson for rent by owner homes, rental apartment Jackson Oregon, and real estate rentals in Jackson Oregon.
Badger Mountain agents, real estate agents, real estate brokers, and home owners list bed and breakfast rentals, vacation homes, rental properties in Badger Mountain Oregon, and Badger Mountain condo rentals.
This website, FRBO.com can recruit, enter, obtain, and serve beach listed properties, beach classified ads, waterfront ads, and lake advertisements lakeside listed properties and romantic classifieds to collaborate your Badger Mountain crossing.
Ready to move in mountain lodge, exotic duplex, lakefront chalet, and lakeside houseboat are immediate in the nearly territory of Badger Mountain Oregon.
Determine and identify house rentals in Wheeler, Wheeler Oregon rent house, and Wheeler Oregon homes for rent.
Badger Mountain Oregon circumstances could relieve and hype your research.
Ascertain, uncover, and elicit Tualatin United States apartments for rent, Tualatin United States homes for rent, and rent house in Tualatin United States.
Look up, discover, and locate Baker Oregon homes for rent, holiday rentals in Baker Oregon, rental homes Baker Oregon, and home rentals Baker.
Look up, espy, and espy vacation rental in Brightwood, Brightwood United States houses for rent, and Brightwood United States rent house.
Move and discern vacation homes for rent by owner in Butte Falls United States and Butte Falls short term rentals.
Traveling agents, roadmen, and romantics who are searching for rent by owner homes in Badger Mountain Oregon and are trying to invent Badger Mountain Oregon rental properties and real estate rentals in Badger Mountain Oregon can probe this site, For Rent By Owner (FRBO.com) and our ski in/out ads, rustic online MLS, and exclusive classified ads.
Condo rentals in Inman South Carolina and apartment rentals
Observe and espy vacation homes for rent by owner New Pine Creek United States and homes for rent by owner New Pine Creek.
Badger Mountain locality employs many landlords and condo owners.
Uncover, move, and come upon Gresham United States condo rentals, Gresham house rentals, and real estate rentals Gresham.
Learn and elicit Warm Springs holiday rentals and rental properties.
Jet-setters, seafarers, and gamblers hunt and rake our site, FRBO.com and light upon city lodge and loft villa.
Ferret out and glimpse Multnomah Oregon condo rentals, apartments for rent in Multnomah Oregon, and rental properties in Multnomah.
Determine and hear Deadwood short term rentals and real estate rentals in Deadwood United States.
Identify and come upon Lowell United States apartment rentals and Lowell United States rental apartment.
|
|
