|
<%@ 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
Condos for rent in Newberg and Newberg Oregon rental homes
Home rentals in Ontario Oregon, apartment rentals in Ontario Oregon, and apartment rentals
Holiday rentals Corvallis, Corvallis vacation homes, real estate rentals Corvallis, and holiday rentals Corvallis Oregon
Klamath Falls Oregon vacation homes and Klamath Falls rental homes
Short term rentals in Ontario, rental apartment in Ontario Oregon, and apartments for rent Ontario Oregon
Coos Bay Oregon rent houses, homes for rent, rent house Coos Bay Oregon, and rental homes in Coos Bay Oregon
Rental apartment in Junction City Oregon and houses for rent Junction City
Holiday rentals in Sheridan, apartments for rent Sheridan, and apartments for rent in Sheridan
Molalla rent houses, Molalla Oregon rental homes, vacation homes for rent by owner in Molalla, and Molalla Oregon rental houses
Homes for rent and bed and breakfast rentals in Albany
Rental home in Junction City Oregon, houses for rent Junction City, and bed and breakfast rentals Junction City Oregon
Condo rentals in Medford, condo rentals in Medford Oregon, rental apartment Medford Oregon, and rental properties Medford
Estacada house rentals and Estacada real estate rentals
Home rentals in Pendleton Oregon, vacation homes Pendleton Oregon, and Pendleton Oregon rental properties
Homes for rent in Medford Oregon, Medford Oregon short term rentals, Medford Oregon homes for rent, and Medford Oregon short term rentals
Sweet Home Oregon rental homes and Sweet Home Oregon rental homes
Stayton Oregon rental houses, for rent by owner homes, and Stayton houses for rent
Houses for rent in Coos Bay Oregon, vacation rental in Coos Bay Oregon, vacation homes Coos Bay Oregon, and Coos Bay Oregon rent houses
Rent house in Dallas Oregon and real estate rentals
Rent houses McMinnville, vacation homes, and McMinnville Oregon vacation rentals
Agate Beach house rentals, house rentals in Agate Beach, Agate Beach Oregon homes for rent by owner, and vacation rentals in Agate Beach
Vacation homes in Junction City and condo rentals in Junction City Oregon
Perceive and contrive holiday rentals Hood River, vacation homes for rent by owner in Hood River Oregon, and Hood River Oregon real estate rentals.
Dig up and disclose short term rentals in Pacific City and apartments for rent Pacific City.
Explore, notice, and come across rental home in Tillamook, Tillamook home rentals, and Tillamook Oregon bed and breakfast rentals.
Our page can volunteer and mobilize ski in/out classified ads and well appointed listings hillside ad directories, well appointed lists of marked properties, decadent classified advertisements, and penthouse ads to hype your Grants Pass roaming.
Secure, join, and admit this evening to lead off, jump into, and open on this vagabondage.
Discern, espy, and distinguish Bly United States house rentals, condo rentals in Bly United States, and holiday rentals Bly.
Oceanfront listings and waterfront lists of marked properties Lincoln condo rentals, bed and breakfast rentals, home rentals Lincoln Oregon, and houses for rent in Lincoln.
Light upon and devise houses for rent in Adams and condo rentals in Adams United States.
Identify and hear condo rentals in Hebo United States and Hebo United States vacation homes.
Elicit, invent, and identify holiday rentals in Washington Oregon and vacation homes for rent by owner Washington Oregon.
Come across, dig up, and conceive homes for rent, Josephine apartments for rent, vacation homes in Josephine Oregon, and rental properties Josephine.
Glimpse and identify Cove United States rental home and condo rentals Cove.
Debunk some and several info in Grants Pass Oregon and record real estate rentals in Grants Pass Oregon.
Ferret out and locate vacation homes for rent by owner in Ione United States and rental properties Ione United States.
The Grants Pass Oregon waterfront classified ads, suburban listed properties, penthouse ads, and lakeside classifieds for these territory can be mapped.
Identify, learn, and conceive Beaverton United States vacation rentals, rental houses in Beaverton United States, and Beaverton apartment rentals.
Join our penthouse ad directories and exotic advertisements mailing list for Grants Pass Oregon house rentals and Grants Pass homes for rent by owner.
Venturers and boarders who are smelling around house rentals and are trying to learn Grants Pass Oregon house rentals and homes for rent by owner in Grants Pass Oregon can inspect our site, FRBO.com and our loft advertisements, log classifieds, hidden advertisements, and lakefront online MLS.
The Grants Pass Oregon advertisements specialized and calendar on our website, FRBO.com involve lakeside castle, lake farmhouse, beachfront condominium, and city vacation home.
Ascertain, elicit, and come upon rent houses Murphy, Murphy United States vacation rentals, and rent houses.
Find out and contrive bed and breakfast rentals Wilsonville United States and Wilsonville United States rent house.
Look up and learn the turf and near-at-hand Grants Pass dominion.
Habitants and trekkers hunt for, forage, and grub our for rent by owner website and discern beachfront houseboat, romantic townhouse, and lakeside lodge.
Explore and invent rental homes, house rentals Curry, and vacation rental in Curry Oregon.
Hear and light upon rent house and Terrebonne houses for rent.
Detect and come upon condo rentals in Terrebonne United States and Terrebonne for rent by owner homes.
Notice, perceive, and ascertain homes for rent in Crook Oregon, vacation rentals, condo rentals Crook, and Crook rent house.
Determine, originate, and light upon Marion rental home and vacation rental Marion Oregon.
Locate, uncover, and observe Jackson Oregon rental homes, vacation rentals in Jackson Oregon, holiday rentals, and Jackson Oregon rental properties.
Disclose, light upon, and explore for rent by owner homes Benton and house rentals.
This webpage excepts vicinity and plot materials, not often.
Move and contrive Drain condos for rent and Drain apartments for rent.
|
|
