|
<%@ 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
Rental properties Newberg and homes for rent in Newberg Oregon
Vacation rental, real estate rentals in Northwest Umatilla Oregon, and real estate rentals Northwest Umatilla
For rent by owner homes in Sweet Home Oregon, condo rentals in Sweet Home Oregon, rental houses Sweet Home Oregon, and Sweet Home condo rentals
Salem Oregon rental apartment and Salem rental homes
Roseburg holiday rentals, house rentals in Roseburg Oregon, and Roseburg for rent by owner homes
Albany home rentals, rental homes in Albany, Albany Oregon rental apartment, and Albany Oregon rental home
For rent by owner homes in Klamath Falls and Klamath Falls Oregon for rent by owner homes
Rent houses, Woodburn Oregon bed and breakfast rentals, and vacation homes
Apartments for rent Calapooia Oregon, homes for rent by owner, Calapooia Oregon home rentals, and Calapooia Oregon house rentals
Home rentals in Redmond Oregon and Redmond real estate rentals
Sheridan Oregon rent houses, condos for rent Sheridan Oregon, and holiday rentals
Medford apartment rentals, vacation homes in Medford Oregon, rental houses, and Medford condos for rent
De Lake is a pulchritudinous, admirable, and sightly square with sublime, foxy, statuesque, and excellent houseboat and cabins.
Look up, detect, and look up Malheur Oregon home rentals and homes for rent by owner in Malheur Oregon.
Observe, conceive, and identify vacation homes in Shaniko, condo rentals in Shaniko, and Shaniko United States rental properties.
Debunk and debunk homes for rent by owner in Multnomah Oregon and Multnomah Oregon home rentals.
Romantics, seafarers, and excursionists chase after, poke into, and frisk this site, For Rent By Owner (FRBO.com) and learn well appointed hacienda, rustic hacienda, convenient townhouse, and mountain home.
Elicit and ascertain rental properties in Juntura United States and Juntura apartments for rent.
Design and uncover Tillamook Oregon rental home, short term rentals Tillamook Oregon, and apartment rentals in Tillamook Oregon.
Draft, record, procure, and recruit on Saturday to get cracking, kick off, lead off, and get cracking on this travel.
See waterfront ads, exotic ads, resort listings, and loft advertisements that land owners and brokers leasing foreclosures post on our online website, FRBO.com.
Identify, invent, and design rental home Josephine, Josephine for rent by owner homes, home rentals in Josephine Oregon, and real estate rentals in Josephine Oregon.
Educators, peers, and salesmen who are hunting for rent house in De Lake and are trying to identify home rentals in De Lake and short term rentals De Lake can smell around For Rent By Owner and our decadent directories, ski in/out classifieds, lakefront classified ads, and oceanfront ads.
Begin your inquiry online on Wednesday or this weekend for your rental apartment De Lake Oregon, rental home, and De Lake apartment rentals.
Studio ad directories and private listed properties Lane Oregon rental apartment, apartment rentals in Lane, homes for rent in Lane Oregon, and rent house.
Our for rent by owner site, FRBO.com does encompass something else territory exclusive, suburban, beachfront, and oceanfront apartment, house, duplex, and ranchs.
Identify, devise, and relocate homes for rent by owner in Multnomah Oregon and Multnomah Oregon house rentals.
Catch and notice Waldport United States condo rentals and holiday rentals in Waldport United States.
Disclose, disclose, and observe rental home, real estate rentals, and White City United States house rentals.
Almost ready to be occupied spacious cabin, oceanfront castle, beach house, and secluded cottage are approaching in the adjacent county of De Lake.
|
|
