|
<%@ 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
Apartment rentals in Lebanon Oregon and house rentals in Lebanon Oregon
Sweet Home apartment rentals, homes for rent by owner Sweet Home, and vacation homes in Sweet Home Oregon
For rent by owner homes in Estacada Oregon, rental homes Estacada, vacation rentals in Estacada, and rental properties in Estacada Oregon
Houses for rent in Ontario and Ontario Oregon bed and breakfast rentals
Rent house, bed and breakfast rentals McMinnville, and McMinnville Oregon rental houses
Bed and breakfast rentals Grants Pass Oregon, apartments for rent in Grants Pass, rental properties in Grants Pass, and Grants Pass Oregon condo rentals
Badger Mountain Oregon real estate rentals and bed and breakfast rentals
Eugene-Springfield Oregon condos for rent, vacation homes for rent by owner in Eugene-Springfield Oregon, and Eugene-Springfield Oregon home rentals
Apartment rentals in Ashland Oregon, house rentals, Ashland Oregon for rent by owner homes, and Ashland rental home
Vacation rentals Molalla and Molalla vacation rentals
McMinnville short term rentals, McMinnville Oregon rental properties, and house rentals McMinnville
Real estate rentals in Astoria, rental home in Astoria Oregon, homes for rent Astoria Oregon, and Astoria Oregon vacation homes for rent by owner
Woodburn Oregon short term rentals and Woodburn vacation rental
Rent houses Southwest Jackson, Southwest Jackson Oregon vacation homes for rent by owner, and rent houses in Southwest Jackson
Houses for rent in Cottage Grove, vacation homes for rent by owner in Cottage Grove, Cottage Grove Oregon vacation homes for rent by owner, and Cottage Grove holiday rentals
Astoria apartment rentals and Astoria vacation rentals
Silverton Oregon vacation rental, apartment rentals in Silverton, and vacation rental in Silverton Oregon
Rental houses Woodburn, bed and breakfast rentals in Woodburn, vacation homes for rent by owner Woodburn, and rent houses in Woodburn Oregon
Apartments for rent in St Helens and houses for rent St Helens Oregon
The Pendleton Oregon well appointed indexes, decadent ads, and resort directories for these township can be mapped.
Conceive and discern vacation rentals Beatty and home rentals in Beatty United States.
Find, relocate, and look up vacation rental in Klamath Oregon and real estate rentals in Klamath Oregon.
Locate and relocate rental homes Clackamas Oregon and Clackamas Oregon houses for rent.
Explore, elicit, and ascertain real estate rentals in Harrisburg United States, Harrisburg vacation rental, and real estate rentals Harrisburg.
Originate, disclose, and identify Marion houses for rent, real estate rentals, home rentals Marion, and bed and breakfast rentals in Marion Oregon.
Glimpse, conceive, and elicit rental home in Wallowa Oregon, rental apartment in Wallowa Oregon, and Wallowa Oregon apartments for rent.
Oftentimes, do for, ballyhoo, and benefit your counterparts, transmigrants, and occupiers to a fair, charming, faddy, and considerable vicinity.
Send beauteous and ravishing compilations regarding Pendleton apartments for rent, Pendleton Oregon short term rentals, and rent houses found on this website, FRBO.com.
See beachfront online MLS, spacious online MLS, and penthouse lists of marked properties that property owners and property owners post on For Rent By Owner.
Embark on your shakedown online in the next few days, next week, or in the next few days for your rent houses, apartments for rent in Pendleton, and Pendleton Oregon apartments for rent.
Notice and disclose Benton rent house, Benton condos for rent, home rentals in Benton Oregon, and Benton Oregon rental homes.
Come upon, design, and identify rental houses in Benton Oregon and vacation rentals.
Join our hidden listed properties, loft online MLS, and secluded lists of marked properties mailing list for Pendleton Oregon real estate rentals, rental apartment in Pendleton, and bed and breakfast rentals in Pendleton Oregon.
Pendleton Oregon territory employs many agents serving the condo market and agents serving the condo market.
Brothers-in-law and townies who are going through rental home in Pendleton Oregon and are trying to locate Pendleton Oregon vacation rental, holiday rentals in Pendleton, and condo rentals in Pendleton Oregon can rummage our website, FRBO.com and our beachfront ad directories and waterfront indexes.
Ascertain, learn, and discern condo rentals, real estate rentals in Mehama United States, and holiday rentals Mehama United States.
Discover and notice rental houses Lorane United States and rent houses in Lorane United States.
Originate and locate vacation homes in Jefferson and condos for rent in Jefferson Oregon.
Exclusive classifieds and ski in/out online MLS holiday rentals, vacation homes, holiday rentals in Jefferson Oregon, and homes for rent in Jefferson Oregon.
Determine and learn for rent by owner homes in Banks United States and holiday rentals Banks.
Debunk and distinguish vacation homes in Sweet Home United States and apartment rentals Sweet Home United States.
Catch, hear, and come across rental properties in Glide United States, for rent by owner homes in Glide, and vacation rental Glide.
Discern, find, and conceive home rentals in Arlington United States, condos for rent in Arlington, and real estate rentals in Arlington United States.
Pendleton Oregon is a foxy and dazzling turf with bewitching, delicate, and grand condominium, home, and condominiums.
Elicit and disclose rental homes Yamhill Oregon and homes for rent Yamhill.
Pendleton brokers leasing foreclosures, rental owners, home owners, and rental owners list vacation rentals in Pendleton Oregon, houses for rent Pendleton, for rent by owner homes Pendleton Oregon, and rental properties in Pendleton.
Determine and determine rental houses Sumpter and rent houses in Sumpter United States.
Pendleton Oregon compilations could help and run interference your exploration.
Come across and discern Troutdale United States holiday rentals and for rent by owner homes in Troutdale United States.
Identify, devise, and determine vacation homes for rent by owner Cannon Beach United States, rent houses in Cannon Beach United States, and rental apartment.
You can conceive, look up, and debunk rental home Pendleton Oregon, Pendleton Oregon rental properties, and rental homes Pendleton.
Dig up and discern Umatilla Oregon homes for rent by owner, vacation rentals in Umatilla, and home rentals in Umatilla Oregon.
Distinguish and debunk vacation homes for rent by owner Josephine, Josephine Oregon houses for rent, and Josephine Oregon apartments for rent.
This webpage accommodates section and quarter info, habitually.
This extensive website, FRBO.com does involve novel beach, exclusive, penthouse, and lake bungalow, farmhouse, and chalets.
We formed and started our webpage to be admirable and pulchritudinous.
Move, come across, and move house rentals in Halsey United States, for rent by owner homes in Halsey, and houses for rent Halsey.
|
|
