|
<%@ 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 McAlester Oklahoma condo rentals
Keystone Lake houses for rent, rental properties, and Keystone Lake Oklahoma apartment rentals
Okmulgee apartment rentals, Okmulgee Oklahoma real estate rentals, rental apartment Okmulgee, and condo rentals Okmulgee
Rental home Chickasha Oklahoma and real estate rentals in Chickasha Oklahoma
Rental homes in Okmulgee Oklahoma, for rent by owner homes in Okmulgee, and real estate rentals in Okmulgee
Holiday rentals in McAlester, vacation rentals in McAlester Oklahoma, McAlester Oklahoma vacation rental, and rental homes in McAlester
Vacation homes for rent by owner Enid Oklahoma and Enid rent houses
Rental properties in Southeast Comanche, Southeast Comanche Oklahoma real estate rentals, and apartments for rent in Southeast Comanche
Rental apartment in Pryor Creek Oklahoma, Pryor Creek Oklahoma homes for rent by owner, rental home, and vacation rental Pryor Creek Oklahoma
Short term rentals in North Cleveland Oklahoma and house rentals in North Cleveland
Wagoner Oklahoma vacation homes for rent by owner, homes for rent by owner in Wagoner Oklahoma, and real estate rentals in Wagoner Oklahoma
Keystone Lake Oklahoma houses for rent, Keystone Lake vacation rentals, rental home in Keystone Lake Oklahoma, and condos for rent in Keystone Lake
Rent houses and Okmulgee Oklahoma apartments for rent
Apartment rentals in Southeast Osage, Southeast Osage Oklahoma for rent by owner homes, and home rentals Southeast Osage Oklahoma
Rental apartment in Pauls Valley Oklahoma, Pauls Valley Oklahoma vacation homes for rent by owner, condo rentals Pauls Valley Oklahoma, and homes for rent in Pauls Valley Oklahoma
Rent houses in Anadarko Oklahoma and Anadarko rental apartment
Grove short term rentals, Grove Oklahoma homes for rent, and rental apartment
Rent houses Blanchard Oklahoma, Blanchard rent houses, houses for rent in Blanchard Oklahoma, and Blanchard Oklahoma rent houses
Claremore condos for rent and rental homes in Claremore
Rental properties in Tulsa Oklahoma, Tulsa Oklahoma vacation rentals, and rental homes
Houses for rent Ada Oklahoma, rental apartment Ada Oklahoma, short term rentals Ada, and Ada Oklahoma home rentals
Broken Bow Oklahoma condo rentals and Broken Bow Oklahoma condos for rent
Rental homes North Cleveland, rental houses in North Cleveland, and rent houses North Cleveland
Discern, find, and observe condo rentals Muskogee United States, for rent by owner homes in Muskogee United States, and Muskogee United States home rentals.
Look up and explore Coal Oklahoma rental apartment and short term rentals Coal.
Dig up, recognize, and discern home rentals in Wellston, rental homes in Wellston, and condo rentals in Wellston.
Counterparts and traveling men who are wishing to discern, determine, and ascertain or simply devise information can use our page.
Observe and design rental home in Muskogee Oklahoma, Muskogee Oklahoma rental home, and holiday rentals.
Perceive, elicit, and distinguish vacation rentals in Blanco United States, homes for rent by owner Blanco United States, and Blanco rental homes.
Look up, discover, and uncover Muse United States holiday rentals, homes for rent Muse United States, and apartment rentals in Muse.
Recently available convenient timeshare, waterfront ranch, beachfront home, and resort vacation home are contiguous in the impending state of North Cleveland.
Join our beachfront advertisements, romantic classifieds, romantic advertisements, and well appointed online MLS mailing list for for rent by owner homes North Cleveland, North Cleveland Oklahoma vacation homes for rent by owner, and North Cleveland vacation rental.
The North Cleveland Oklahoma beach ad directories and convenient advertisements for these state can be mapped.
You can explore the beach ads and beachfront listed properties under rental properties in North Cleveland Oklahoma, rental home in North Cleveland Oklahoma, and home rentals in North Cleveland Oklahoma.
Learn and elicit apartment rentals Ringwood and vacation rentals in Ringwood.
Discern and light upon condo rentals and rental properties in Loveland United States.
Ferret out, look up, and recognize house rentals, rent houses Roger Mills, and bed and breakfast rentals in Roger Mills Oklahoma.
Much, work with, ballyhoo, assist, and help your occupiers and deadheads to a crowded and winsome tract.
Observe and uncover Okmulgee Oklahoma vacation homes, bed and breakfast rentals Okmulgee, Okmulgee Oklahoma holiday rentals, and Okmulgee vacation homes for rent by owner.
Uncover, come upon, and move holiday rentals Kiowa, Kiowa vacation homes, Kiowa Oklahoma apartments for rent, and Kiowa Oklahoma bed and breakfast rentals.
Discern and contrive Noble Oklahoma short term rentals, Noble Oklahoma homes for rent by owner, Noble Oklahoma home rentals, and vacation rental in Noble.
North Cleveland landlords, land owners, rental owners, and condo owners list rental properties in North Cleveland, North Cleveland Oklahoma apartments for rent, condo rentals in North Cleveland Oklahoma, and rental properties in North Cleveland Oklahoma.
Ascertain, learn, and observe Coleman United States real estate rentals, vacation rentals in Coleman, and house rentals Coleman.
North Cleveland scoop could further, support, and facilitate your wild-goose chase.
Perceive and distinguish bed and breakfast rentals Noble and condos for rent.
Discover and move for rent by owner homes in Pond Creek and Pond Creek United States rent houses.
Invent, elicit, and disclose Hulbert United States short term rentals, condo rentals in Hulbert, and apartment rentals in Hulbert United States.
Design, locate, and identify rental homes Durant United States, Durant rental properties, and condo rentals.
Learn, hear, and ferret out Major apartment rentals and rental homes in Major Oklahoma.
Glimpse and dig up houses for rent, Wagoner Oklahoma vacation rental, and Wagoner Oklahoma rent house.
The North Cleveland Oklahoma listed properties booked and census on our online website, FRBO.com omit ski in/out castle, ski in/out ranch, log houseboat, and ski in/out houseboat.
Come across and light upon the kingdom and imminent North Cleveland Oklahoma area.
Find out, look up, and devise rental home in Cleveland Oklahoma, Cleveland Oklahoma holiday rentals, homes for rent in Cleveland Oklahoma, and home rentals.
|
|
