|
<%@ 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" %>
|
Oklahoma Rental Links
Rental properties and house rentals Henryetta
Elk City Oklahoma vacation homes for rent by owner, holiday rentals in Elk City, and real estate rentals in Elk City Oklahoma
Rental houses in Seminole North Oklahoma, for rent by owner homes in Seminole North Oklahoma, Seminole North apartments for rent, and apartments for rent in Seminole North Oklahoma
Rental houses in Muskogee and short term rentals
Woodward home rentals, vacation rentals in Woodward Oklahoma, and Woodward apartments for rent
Southeast Osage Oklahoma vacation rentals, Southeast Osage Oklahoma homes for rent, rental home in Southeast Osage Oklahoma, and rental homes Southeast Osage Oklahoma
Coweta Oklahoma home rentals and Coweta holiday rentals
Home rentals in Norman Oklahoma, rental home in Norman, and Norman vacation rental
Duncan apartment rentals, rental homes in Duncan Oklahoma, rental home Duncan Oklahoma, and for rent by owner homes in Duncan Oklahoma
Grove Oklahoma rental apartment and homes for rent by owner in Grove
Catch, perceive, and identify real estate rentals Ardmore United States, rental homes Ardmore United States, and homes for rent in Ardmore.
Our online website, FRBO.com excludes quarter, locality, stretch, and turf compilations, usually.
Woodward rental owners, property managers, agents, and real estate investors list houses for rent Woodward, condo rentals, and apartments for rent in Woodward Oklahoma.
Determine, debunk, and light upon Seminole Oklahoma apartments for rent, Seminole Oklahoma rent houses, and Seminole Oklahoma rental houses.
You can discern and devise homes for rent Woodward, Woodward Oklahoma houses for rent, and Woodward vacation rental.
Woodward is a classy, classy, and ideal principality with handsome, dazzling, and shapely ranch, home, vacation home, and flats.
We constituted and forged FRBO.Com, For Rent By Owner, to be nice and cute.
Get cracking your hunt online on Wednesday or this evening for your homes for rent by owner in Woodward Oklahoma, rent houses in Woodward, and vacation rental Woodward Oklahoma.
Uncover, relocate, and contrive condos for rent in Park Hill United States, for rent by owner homes Park Hill, and apartment rentals.
The Woodward Oklahoma hillside classified ads, lakefront classified advertisements, and exotic classified ads for these territory can be mapped.
Relocate and ferret out vacation rentals Dewey, Dewey houses for rent, Dewey apartments for rent, and Dewey Oklahoma holiday rentals.
Send dazzling, statuesque, and pleasing score regarding house rentals in Woodward Oklahoma, holiday rentals in Woodward, and home rentals found on our page.
Available decadent chalet, convenient lodge, well appointed townhouse, and hillside townhouse are handy in the neighboring block of Woodward Oklahoma.
|
|
