|
<%@ 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
Corvallis Oregon vacation homes for rent by owner and rent house Corvallis
Holiday rentals Salem Oregon, Salem homes for rent by owner, and bed and breakfast rentals Salem
Rental apartment Silverton, for rent by owner homes, real estate rentals Silverton, and vacation homes for rent by owner in Silverton
Klamath Falls Oregon rental homes and Klamath Falls Oregon home rentals
Dallas Oregon for rent by owner homes, vacation rental Dallas Oregon, and real estate rentals Dallas
Astoria Oregon rental apartment, for rent by owner homes in Astoria Oregon, Astoria Oregon rental apartment, and rental properties in Astoria
Vacation homes and rental houses Pendleton Oregon
Condo rentals Baker City Oregon, rental home in Baker City Oregon, and bed and breakfast rentals in Baker City Oregon
Real estate rentals, Northeast Umatilla for rent by owner homes, Northeast Umatilla Oregon rental apartment, and apartment rentals Northeast Umatilla
Jefferson Oregon house rentals and rental houses Jefferson
Real estate rentals Agate Beach, rent house Agate Beach Oregon, and Agate Beach Oregon condos for rent
Exclusive classifieds and spacious online MLS rental properties Curry Oregon, Curry vacation homes for rent by owner, rental home in Curry Oregon, and rental properties in Curry Oregon.
Recently available beachfront ranch and lakefront duplex are imminent in the near-at-hand square of St Helens Oregon.
Detect and locate house rentals Umatilla Oregon, rent houses Umatilla Oregon, and apartment rentals.
You can study the beach classified ads, suburban classified advertisements, and secluded classifieds under vacation homes and St Helens houses for rent.
Elicit and conceive the turf and not far St Helens vicinity.
We constructed and established For Rent By Owner to be bewitching, pleasing, and alluring.
Come across, learn, and distinguish rent house in Cheshire United States, bed and breakfast rentals Cheshire, and Cheshire United States holiday rentals.
Find out and learn rental apartment in Butte Falls United States and vacation rental in Butte Falls United States.
Recognize, learn, and locate rental homes, Newport United States rental properties, and short term rentals.
Mobilize, obtain, and place next week to get going and kick off on this sojourn.
Lead off your research online tomorrow morning, in the next few days, or on Sunday for your holiday rentals St Helens Oregon, St Helens Oregon rental homes, and St Helens Oregon vacation rentals.
St Helens real estate investors, agents serving the condo market, rental agents, and rental owners list St Helens vacation homes, St Helens Oregon for rent by owner homes, and St Helens Oregon apartment rentals.
Detect, glimpse, and discern rent houses O Brien, real estate rentals, and O Brien apartment rentals.
Explore and recognize short term rentals Lafayette and Lafayette rental properties.
Journeyers, adventurers, and peers who are beating about St Helens Oregon homes for rent by owner and are trying to determine short term rentals in St Helens, rent houses in St Helens, and rental apartment in St Helens Oregon can go through our webpage and our suburban directories, lakeside classified advertisements, and mountain listed properties.
Once and again, plug, bail out, boost, and support your floaters, husbands, and migrants to a in vogue and interesting section.
You can ferret out and learn rent house in St Helens, vacation homes for rent by owner in St Helens, and vacation homes in St Helens Oregon.
Come across and espy Deschutes Oregon for rent by owner homes and holiday rentals Deschutes.
Using our website, FRBO.com, rental owners enter home and townhouse listings.
St Helens dominion employs many real estate brokers, property agents, real estate investors, and property brokers.
Send pulchritudinous, superb, and well-formed poop sheet regarding vacation rental in St Helens and St Helens Oregon rental homes found on our website, FRBO.com.
Observe and originate Tillamook bed and breakfast rentals and Tillamook United States vacation rentals.
|
|
