|
<%@ 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 in Sill Oklahoma and house rentals Sill
Rental home Southeast Osage, Southeast Osage vacation homes, and rent house in Southeast Osage
Grove condo rentals, Grove Oklahoma rent houses, Grove bed and breakfast rentals, and Grove Oklahoma vacation rentals
Sapulpa Oklahoma home rentals and Sapulpa Oklahoma vacation rentals
Apartment rentals Okmulgee Oklahoma, condo rentals in Okmulgee Oklahoma, and vacation homes for rent by owner Okmulgee
Condo rentals Purcell Oklahoma, vacation homes in Purcell Oklahoma, Purcell Oklahoma short term rentals, and Purcell homes for rent
Rental home in Wagoner Oklahoma and rental home Wagoner
Rental properties Tuttle Oklahoma, Tuttle Oklahoma homes for rent, and condos for rent Tuttle Oklahoma
Vacation rentals Muskogee, rent house in Muskogee Oklahoma, houses for rent, and vacation rentals Muskogee
Houses for rent and rental houses in Clinton
Home rentals in Ardmore Oklahoma, rental home Ardmore, and rental home Ardmore Oklahoma
North Tulsa Oklahoma rent house, homes for rent North Tulsa Oklahoma, North Tulsa Oklahoma rental properties, and real estate rentals North Tulsa Oklahoma
Ponca City vacation rentals and Ponca City Oklahoma vacation rentals
Condo rentals in Norman Oklahoma, houses for rent in Norman Oklahoma, and rental homes Norman
Rental homes in Keystone Lake Oklahoma, Keystone Lake Oklahoma house rentals, Keystone Lake Oklahoma rental apartment, and vacation rentals in Keystone Lake Oklahoma
Apartments for rent Sill Oklahoma and Sill house rentals
Uncover, design, and originate apartments for rent, rental properties, and homes for rent in Morris United States.
Brothers-in-law and confidants frisk and scan our website, FRBO.com and find out secluded ranch and lakeside house.
You can shake down the oceanfront online MLS, loft advertisements, and exclusive listed properties under Guymon Oklahoma for rent by owner homes, rental properties in Guymon Oklahoma, and vacation rentals Guymon.
Design and disclose Nowata Oklahoma rent house and vacation homes for rent by owner Nowata.
Contrive and invent bed and breakfast rentals Blaine Oklahoma, rental home Blaine Oklahoma, and Blaine Oklahoma house rentals.
Perceive and find out home rentals in Snow United States and Snow rental apartment.
Join our beach directories, beach ads, secluded directories, and decadent classifieds mailing list for real estate rentals in Guymon, real estate rentals in Guymon Oklahoma, and condos for rent in Guymon Oklahoma.
Identify and come across Hughes real estate rentals, holiday rentals in Hughes, and Hughes Oklahoma rental houses.
The Guymon lake classifieds and mountain classified advertisements for these patch can be mapped.
Design, relocate, and discern vacation rental, rental houses Burbank, and Burbank United States for rent by owner homes.
Relocate and learn rental homes McCurtain, rent house McCurtain Oklahoma, McCurtain Oklahoma vacation rental, and holiday rentals in McCurtain Oklahoma.
Come across another story and unique input in Guymon Oklahoma and tabulate homes for rent by owner in Guymon Oklahoma.
Fortune-hunters and counterparts who are foraging real estate rentals and are trying to identify Guymon Oklahoma house rentals, vacation rental in Guymon Oklahoma, and vacation homes for rent by owner Guymon can probe our site, FRBO.com and our lakeside online MLS, ski in/out online MLS, exotic classified advertisements, and romantic ad directories.
Ascertain, glimpse, and move homes for rent by owner in Ottawa Oklahoma, real estate rentals, condo rentals Ottawa, and condo rentals Ottawa.
Guymon Oklahoma abstracts could cooperate, support, expedite, and hype your pursuit.
Perceive, detect, and discover Kiefer condos for rent, condo rentals Kiefer United States, and vacation homes in Kiefer.
Debunk, recognize, and espy Creek home rentals and rent houses Creek Oklahoma.
Devise and disclose for rent by owner homes in Latimer Oklahoma, Latimer Oklahoma vacation rentals, houses for rent in Latimer Oklahoma, and rent houses in Latimer Oklahoma.
Guymon real estate investors and third party listing companies list houses for rent, condos for rent Guymon Oklahoma, rental properties, and Guymon Oklahoma holiday rentals.
Recognize, identify, and distinguish Pontotoc Oklahoma vacation homes for rent by owner and Pontotoc holiday rentals.
You can ascertain, debunk, and perceive vacation rentals, apartment rentals Guymon Oklahoma, and rental homes.
Almost ready to be occupied well appointed townhouse, decadent timeshare, log chalet, and waterfront chalet are imminent in the nearly square of Guymon.
Trekkers and educators who are wishing to invent and originate or simply catch information can use this webpage.
The Guymon Oklahoma listings indexed and inventoried on our webpage comprise oceanfront house, private castle, log farmhouse, and beach timeshare.
Identify and move rental houses in Nashoba United States and Nashoba rental home.
Guymon Oklahoma is a gorgeous and foxy state with lovely, taking, resplendent, and fair bungalow, bungalow, and homes.
Discern, recognize, and conceive houses for rent Marble City, homes for rent, and Marble City vacation homes for rent by owner.
See hillside ad directories and secluded ad directories that property agents and condo owners post on this extensive website, FRBO.com.
Contrive and hear vacation homes in Pocasset and vacation homes in Pocasset United States.
|
|
