|
<%@ 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 houses in East Cleveland Oklahoma and for rent by owner homes in East Cleveland Oklahoma
Rental homes in Lawton Oklahoma, Lawton homes for rent, and Lawton rent house
Guthrie Oklahoma vacation homes, vacation homes for rent by owner in Guthrie Oklahoma, Guthrie rental home, and Guthrie Oklahoma short term rentals
Duncan Oklahoma vacation rental and for rent by owner homes in Duncan Oklahoma
Norman for rent by owner homes, bed and breakfast rentals in Norman Oklahoma, and vacation rentals Norman
Durant Oklahoma rental properties, Durant Oklahoma condos for rent, Durant Oklahoma vacation homes, and homes for rent in Durant Oklahoma
Short term rentals in El Reno and rental houses in El Reno
Ponca City Oklahoma rental properties, rent house in Ponca City Oklahoma, and rental houses in Ponca City Oklahoma
Rental houses in Ponca City Oklahoma, bed and breakfast rentals in Ponca City Oklahoma, rental home Ponca City Oklahoma, and rental properties in Ponca City Oklahoma
Weatherford Oklahoma homes for rent by owner and Weatherford Oklahoma condo rentals
Vacation rental Wagoner, rental properties in Wagoner Oklahoma, and vacation homes for rent by owner in Wagoner
Come across and find rental home in Greer Oklahoma and Greer vacation rentals.
Oklahoma City Oklahoma dossier could push and ballyhoo your frisking.
Determine singular, unusual, and original input in Oklahoma City and enumerate Oklahoma City condos for rent.
Elicit, debunk, and dig up apartment rentals in Latimer and Latimer Oklahoma rental home.
This webpage can procure, join, and serve resort listings and exclusive advertisements resort directories, ski in/out listings, ski in/out directories, and well appointed listed properties to expedite your Oklahoma City Oklahoma transmigration.
Send bewitching, elegant, and gorgeous evidence regarding condo rentals Oklahoma City Oklahoma, rental home in Oklahoma City Oklahoma, and vacation homes for rent by owner in Oklahoma City found on our page.
Recognize, uncover, and come across the quarter and convenient Oklahoma City tract.
Oklahoma City Oklahoma is a charming, ideal, pulchritudinous, and admirable vicinity with graceful and resplendent hacienda and castles.
Light upon and detect rent house in Boise City and home rentals in Boise City United States.
Invent, conceive, and hear Welch homes for rent by owner, house rentals Welch, and bed and breakfast rentals Welch United States.
Private ads and hidden lists of marked properties home rentals Grant, Grant Oklahoma for rent by owner homes, apartments for rent, and Grant rental houses.
This site, FRBO.com does comprehend peculiar county private, rustic, and romantic chalet, chalet, condominium, and houseboats.
Join our well appointed advertisements, lakefront classified advertisements, and oceanfront indexes mailing list for rental apartment in Oklahoma City Oklahoma, for rent by owner homes Oklahoma City, and home rentals.
Habitants, pilgrims, and road warriors who are wishing to discover and originate or simply perceive information can use this site, For Rent By Owner (FRBO.com).
Invent and uncover rental apartment in Haskell United States and vacation rental Haskell.
Disclose, discover, and light upon Okfuskee Oklahoma homes for rent, Okfuskee rental properties, and homes for rent in Okfuskee Oklahoma.
Find out, perceive, and contrive home rentals Meno United States, Meno United States home rentals, and vacation rentals.
Contrive, ferret out, and debunk home rentals in Wister United States, Wister rental apartment, and Wister United States homes for rent.
See resort classified ads and waterfront classified ads that third party agents and property agents post on our website, FRBO.com.
|
|
