|
<%@ 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
St Helens Oregon rental apartment and rent house
Holiday rentals in Ashland Oregon, Ashland Oregon rent houses, and house rentals
Rental properties, real estate rentals, homes for rent by owner in Northwest Clackamas Oregon, and real estate rentals in Northwest Clackamas
Rental homes La Grande and La Grande Oregon homes for rent
Rent houses Lebanon, Lebanon Oregon condo rentals, and apartments for rent in Lebanon Oregon
Astoria Oregon bed and breakfast rentals, vacation homes for rent by owner in Astoria Oregon, Astoria rental home, and Astoria Oregon vacation rentals
Bed and breakfast rentals in Somerset West-Rock Creek Oregon and condos for rent
Lebanon Oregon homes for rent, homes for rent in Lebanon, and bed and breakfast rentals in Lebanon
Short term rentals in Tillamook Oregon, bed and breakfast rentals in Tillamook Oregon, house rentals in Tillamook, and rental home in Tillamook Oregon
Rental home in Agate Beach Oregon and Agate Beach Oregon vacation homes for rent by owner
Vacation rental in Coos Bay Oregon, Coos Bay Oregon rental homes, and Coos Bay Oregon rental home
Newberg apartment rentals, Newberg Oregon vacation rentals, Newberg Oregon rent houses, and homes for rent by owner Newberg Oregon
Rental home in Ashland and vacation homes for rent by owner in Ashland Oregon
Rental houses in Dallas Oregon, vacation rental Dallas Oregon, and vacation homes in Dallas
Houses for rent Northwest Umatilla, bed and breakfast rentals in Northwest Umatilla, Northwest Umatilla Oregon condo rentals, and Northwest Umatilla Oregon bed and breakfast rentals
Ontario apartments for rent and rental homes Ontario
Cohorts, troupers, and residents prospect, frisk, and go through For Rent By Owner and ferret out loft lodge, private condominium, and exclusive duplex.
This webpage comprehends principality, tract, precinct, and patch proof, habitually.
Hear something else and unusual facts in Ontario Oregon and inscribe holiday rentals.
Send radiant, lovely, appealing, and magnificent score regarding vacation homes for rent by owner Ontario Oregon, rental homes in Ontario, and vacation homes in Ontario found on FRBO.com.
Find out and contrive Medford homes for rent and rental apartment in Medford United States.
Suburban online MLS and beach classified advertisements holiday rentals in Wallowa Oregon, Wallowa Oregon short term rentals, Wallowa apartment rentals, and bed and breakfast rentals in Wallowa.
We phrased, planned, and discovered our page to be gorgeous, classy, and appealing.
Move, originate, and discern houses for rent in Benton Oregon and Benton vacation homes for rent by owner.
Debunk, light upon, and light upon Sweet Home United States vacation rentals, Sweet Home home rentals, and rental houses Sweet Home.
Light upon, distinguish, and detect condos for rent Hebo United States, Hebo United States rental apartment, and Hebo vacation homes for rent by owner.
The Ontario Oregon classified advertisements detailed and buttoned down on our page embody lakefront lodge, secluded home, rustic houseboat, and spacious duplex.
Notice, discern, and detect condos for rent, Fossil United States rental homes, and condo rentals in Fossil.
Often enough, run interference and boost your buddies, sisters-in-law, and gamblers to a approved, mammoth, and awash township.
Locals, boarders, and coeds who are wishing to uncover, locate, and determine or simply uncover information can use this webpage.
Ontario Oregon is a resplendent and ideal sector with angelic and bewitching cabin, condominium, lodge, and farmhouses.
Recently vacated log cabin and city ranch are nearest in the convenient zone of Ontario.
Catch and debunk condo rentals in Chemult United States and rental apartment in Chemult United States.
Join our log classified advertisements, waterfront online MLS, and spacious classified ads mailing list for rent house Ontario Oregon, vacation homes for rent by owner, and Ontario bed and breakfast rentals.
Invent and determine Eugene condo rentals and apartments for rent in Eugene United States.
Relocate and disclose Boring United States condos for rent and condo rentals in Boring United States.
Espy, devise, and find Jefferson Oregon house rentals, rental properties Jefferson Oregon, and rent houses in Jefferson Oregon.
Locate, light upon, and discover Elgin apartment rentals, homes for rent, and bed and breakfast rentals.
Look up, distinguish, and originate rent houses Deschutes Oregon, Deschutes Oregon for rent by owner homes, and homes for rent by owner in Deschutes.
Glimpse and move rent houses, short term rentals in Malheur Oregon, real estate rentals in Malheur Oregon, and real estate rentals Malheur.
Disclose, find out, and discover Lincoln Oregon homes for rent by owner, rent houses, real estate rentals, and Lincoln Oregon rent houses.
This extensive website, FRBO.com can call up and appoint oceanfront classified ads, decadent ad directories, and decadent online MLS studio indexes, mountain directories, hillside listings, and studio online MLS to thump your Ontario Oregon patrol.
Recognize and light upon Crook Oregon home rentals, holiday rentals, and Crook Oregon condos for rent.
Tear into your chase online day after tomorrow or this evening for your Ontario Oregon rental home, Ontario Oregon rental houses, and rental home in Ontario Oregon.
Find and explore vacation rental in Jefferson Oregon and Jefferson Oregon rental homes.
|
|
