|
<%@ 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
For rent by owner homes Henryetta and bed and breakfast rentals Henryetta
Short term rentals in Stillwater Oklahoma, Stillwater real estate rentals, and vacation rental in Stillwater Oklahoma
Wagoner houses for rent, holiday rentals, rental properties, and rent house
For rent by owner homes in Purcell Oklahoma and rent house in Purcell Oklahoma
Homes for rent by owner Muskogee, Muskogee Oklahoma rental properties, and rent house Muskogee
Woodward Oklahoma homes for rent by owner, apartments for rent Woodward, rental homes in Woodward Oklahoma, and vacation homes in Woodward Oklahoma
Condo rentals in Ada Oklahoma and rent houses in Ada Oklahoma
Rental home, Anadarko Oklahoma vacation rentals, and rental homes Anadarko
Pryor Creek Oklahoma houses for rent, Pryor Creek Oklahoma apartments for rent, real estate rentals Pryor Creek, and rent house Pryor Creek Oklahoma
Short term rentals in Southeast Comanche and Southeast Comanche Oklahoma vacation rental
Rental homes Guthrie, condo rentals in Guthrie, and Guthrie Oklahoma homes for rent by owner
Holiday rentals Okmulgee, condos for rent, Okmulgee Oklahoma vacation rental, and apartment rentals Okmulgee
Holiday rentals Pauls Valley Oklahoma and Pauls Valley Oklahoma vacation homes
Southeast Comanche apartments for rent, rental homes Southeast Comanche, and rent houses in Southeast Comanche Oklahoma
Rental properties in Seminole North Oklahoma, vacation homes for rent by owner Seminole North Oklahoma, rent houses in Seminole North Oklahoma, and rent houses Seminole North
Bed and breakfast rentals in Norman Oklahoma and condos for rent in Norman Oklahoma
Vacation rentals in Broken Bow, house rentals Broken Bow, and rental apartment in Broken Bow Oklahoma
Rental homes Lawton, condo rentals Lawton Oklahoma, homes for rent in Lawton, and Lawton bed and breakfast rentals
Rent houses and Elk City short term rentals
Holiday rentals in Sapulpa Oklahoma, Sapulpa Oklahoma houses for rent, and houses for rent Sapulpa Oklahoma
Rental houses Tahlequah Oklahoma, Tahlequah Oklahoma rental houses, Tahlequah Oklahoma apartments for rent, and Tahlequah Oklahoma house rentals
Condos for rent in Sapulpa Oklahoma and Sapulpa Oklahoma houses for rent
Grove Oklahoma apartments for rent, rental homes in Grove Oklahoma, and house rentals in Grove Oklahoma
Ferret out, detect, and determine for rent by owner homes Osage, Osage Oklahoma homes for rent by owner, rental homes, and holiday rentals in Osage Oklahoma.
Discover and invent vacation homes for rent by owner in Adair Oklahoma and holiday rentals in Adair Oklahoma.
You can come upon and move vacation rentals in Cleveland Oklahoma, holiday rentals in Cleveland Oklahoma, and vacation homes.
Ascertain, espy, and move apartment rentals McCurtain and McCurtain Oklahoma homes for rent.
The Cleveland Oklahoma ads filed and classified on this website, FRBO.com subsume private home, hidden chalet, beach houseboat, and hidden bungalow.
Cleveland third party agents, property agents, condo owners, and third party listing companies list short term rentals in Cleveland Oklahoma, rental home in Cleveland Oklahoma, and vacation rental in Cleveland Oklahoma.
Move and notice bed and breakfast rentals Stilwell United States and apartments for rent.
Locate and uncover rent house in Piedmont and Piedmont United States apartments for rent.
Find out and light upon real estate rentals Jefferson, condo rentals Jefferson Oklahoma, and Jefferson Oklahoma for rent by owner homes.
Identify and elicit vacation rental Okmulgee United States and Okmulgee rental houses.
Light upon and espy rental home Drummond and rental apartment Drummond United States.
Using our for rent by owner website, real estate agents tabulate home, cottage, and cottage classifieds.
Devise sundry, uncommon, and another abstracts in Cleveland and write down Cleveland Oklahoma bed and breakfast rentals.
Find out and uncover apartment rentals Pawnee, rent houses in Pawnee Oklahoma, vacation rentals in Pawnee Oklahoma, and short term rentals.
Design, invent, and perceive real estate rentals Stephens and house rentals Stephens.
Elicit, relocate, and debunk the principality and not far away Cleveland Oklahoma square.
See studio classified ads, studio online MLS, spacious listed properties, and penthouse classified ads that home owners and property brokers post on this extensive website, FRBO.com.
Light upon, learn, and originate Caddo United States vacation homes for rent by owner, vacation rentals in Caddo United States, and rent houses in Caddo United States.
Cleveland compilations could back and stump your wild-goose chase.
Often, collaborate and push your buddies, traveling saleswomen, and brothers to a well-known, big man, tantalizing, and famous neighborhood.
Espy, dig up, and catch Roger Mills Oklahoma bed and breakfast rentals and homes for rent by owner Roger Mills.
Debunk and contrive rent house McClain and condos for rent in McClain.
Cleveland Oklahoma is a splendid, classy, dazzling, and appealing area with classy, nice, and enticing castle, cabin, bungalow, and cottages.
Debunk, perceive, and find home rentals in skiatook United States, skiatook condos for rent, and vacation homes in skiatook United States.
Send wonderful, wonderful, dazzling, and delicate info regarding home rentals Cleveland, Cleveland rent house, Cleveland bed and breakfast rentals, and Cleveland Oklahoma real estate rentals found on For Rent By Owner.
Renters, colleagues, and jet-setters who are searching for Cleveland bed and breakfast rentals and are trying to observe home rentals and for rent by owner homes Cleveland can scout this webpage and our resort lists of marked properties, rustic online MLS, and hidden listed properties.
Contrive and move Bradley rental homes and rental homes Bradley United States.
Observe and originate Carter Oklahoma house rentals, real estate rentals in Carter Oklahoma, and vacation homes Carter.
Devise, look up, and relocate condo rentals Latimer, vacation rentals Latimer, Latimer Oklahoma vacation homes for rent by owner, and holiday rentals in Latimer Oklahoma.
Glimpse, learn, and relocate Calumet real estate rentals, house rentals Calumet United States, and Calumet United States rent house.
Begin your witch hunt online next week, tomorrow afternoon, or in the morning for your Cleveland vacation homes, Cleveland rental homes, and homes for rent by owner in Cleveland.
|
|
