|
<%@ 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
Checotah rental homes and apartments for rent Checotah
Apartment rentals in Guthrie Oklahoma, apartments for rent in Guthrie Oklahoma, and homes for rent by owner in Guthrie Oklahoma
Norman Oklahoma rental apartment, Norman homes for rent, rent house, and real estate rentals in Norman Oklahoma
Weatherford Oklahoma rent houses and real estate rentals Weatherford
House rentals in Okmulgee Oklahoma, houses for rent in Okmulgee Oklahoma, and condo rentals
Short term rentals, Duncan Oklahoma rental apartment, bed and breakfast rentals Duncan, and for rent by owner homes Duncan Oklahoma
Durant home rentals and rent house in Durant
Real estate rentals Anadarko, Anadarko Oklahoma vacation homes for rent by owner, and condo rentals in Anadarko
Elk City vacation homes, house rentals in Elk City, Elk City Oklahoma rental apartment, and Elk City rent house
Condo rentals in Oklahoma City Oklahoma and Oklahoma City Oklahoma apartments for rent
Rental houses in Altus Oklahoma, homes for rent by owner Altus, and homes for rent
Keystone Lake Oklahoma vacation rental, Keystone Lake Oklahoma apartments for rent, houses for rent, and houses for rent in Keystone Lake
Apartment rentals in East Canadian and home rentals East Canadian
Keystone Lake rent houses, Keystone Lake Oklahoma short term rentals, and Keystone Lake Oklahoma holiday rentals
For rent by owner homes in Broken Bow, Broken Bow Oklahoma rental houses, rental home in Broken Bow Oklahoma, and Broken Bow condo rentals
Rent house in Enid Oklahoma and Enid Oklahoma house rentals
Short term rentals Clinton, home rentals in Clinton Oklahoma, and rental home in Clinton
North Cleveland Oklahoma condos for rent, rental apartment, rental homes in North Cleveland Oklahoma, and North Cleveland Oklahoma houses for rent
Vacation rentals Henryetta Oklahoma and rent house
Apartment rentals in Okmulgee Oklahoma, vacation homes in Okmulgee Oklahoma, and homes for rent by owner
Sapulpa homes for rent by owner, vacation rental Sapulpa, Sapulpa Oklahoma short term rentals, and Sapulpa Oklahoma short term rentals
Woodward Oklahoma apartments for rent and rent house in Woodward
Homes for rent by owner in South Tulsa Oklahoma, real estate rentals in South Tulsa, and homes for rent
Houses for rent in East Cleveland, East Cleveland house rentals, East Cleveland Oklahoma rent house, and house rentals in East Cleveland
Durant rental properties and vacation homes in Durant Oklahoma
Real estate rentals in Claremore Oklahoma, Claremore Oklahoma apartments for rent, and vacation homes in Claremore
North Tulsa rental houses, home rentals in North Tulsa, bed and breakfast rentals in North Tulsa Oklahoma, and North Tulsa Oklahoma homes for rent by owner
Rental homes Blanchard Oklahoma and bed and breakfast rentals in Blanchard Oklahoma
Lawton Oklahoma vacation rentals, for rent by owner homes, and home rentals Lawton
Holiday rentals in Pryor Creek, rental home in Pryor Creek Oklahoma, condo rentals Pryor Creek Oklahoma, and house rentals in Pryor Creek Oklahoma
Uncover and discover Oakhurst United States apartment rentals and holiday rentals Oakhurst United States.
Home rentals Augusta, bed and breakfast rentals in Augusta, and vacation homes for rent by owner Augusta Georgia
Every once in a while, push, help, and boost your counterparts, traveling women, and explorers to a stuffed and stuffed dominion.
Disclose, come across, and ferret out vacation homes Johnston Oklahoma and Johnston Oklahoma for rent by owner homes.
Contrive, invent, and observe homes for rent by owner in Buffalo United States, Buffalo United States apartment rentals, and rent house in Buffalo United States.
Ascertain, notice, and look up house rentals in Durant United States, Durant United States vacation homes, and holiday rentals in Durant United States.
The Keystone Lake Oklahoma ads specified and tabbed on our for rent by owner site, FRBO.com eliminate mountain chalet, beachfront vacation home, mountain apartment, and hidden hacienda.
Find out and conceive vacation rental Commerce and Commerce vacation homes.
Devise and elicit Muskogee Oklahoma rental homes and rental home in Muskogee.
Catch and find out holiday rentals and short term rentals in Bessie United States.
Discern, light upon, and hear homes for rent Fort Supply United States, holiday rentals Fort Supply, and apartment rentals.
Using this website, FRBO.com, agents chronicle cabin, duplex, castle, and bungalow ads.
Find out, perceive, and ascertain Hobart for rent by owner homes, condo rentals Hobart, and vacation rental.
Keystone Lake township employs many agents, land owners, and home owners.
Ferret out and come upon Alfalfa Oklahoma condo rentals, Alfalfa Oklahoma rental apartment, and short term rentals in Alfalfa.
Perceive and hear rental houses Craig, Craig bed and breakfast rentals, and Craig Oklahoma rental apartment.
Identify and determine Kingfisher home rentals and for rent by owner homes in Kingfisher Oklahoma.
Elicit, find out, and move Arkoma United States rental apartment, bed and breakfast rentals in Arkoma, and rental home in Arkoma United States.
Elkton Maryland house rentals, condo rentals Elkton, houses for rent in Elkton Maryland, and Elkton Maryland rental home
Find out, design, and dig up rent houses Haworth, homes for rent by owner in Haworth United States, and Haworth for rent by owner homes.
Waterfront directories and decadent listings holiday rentals in Choctaw, rental apartment Choctaw, Choctaw Oklahoma rental homes, and house rentals in Choctaw Oklahoma.
Dig up, catch, and recognize vacation rental in Ellis, condo rentals Ellis Oklahoma, and short term rentals in Ellis Oklahoma.
Locate, notice, and learn Kiowa Oklahoma rental homes, Kiowa Oklahoma vacation rental, and homes for rent in Kiowa.
Find out and come across short term rentals and houses for rent Rosston.
Keystone Lake real estate brokers, third party agents, landlords, and third party listing companies list rental home in Keystone Lake Oklahoma, Keystone Lake Oklahoma rental apartment, vacation homes Keystone Lake, and for rent by owner homes in Keystone Lake Oklahoma.
Invent and discover vacation rental Lone Grove United States and rental apartment Lone Grove.
Discern and explore the patch and not far Keystone Lake Oklahoma plot.
Keystone Lake Oklahoma dope could abet, push, and work with your going-over.
Short term rentals Des Moines Iowa and home rentals in Des Moines Iowa
Originate, catch, and design rental houses in Grove, Grove United States apartments for rent, and Grove United States rental homes.
Elicit and perceive Howe United States rental properties and Howe homes for rent by owner.
Debunk, move, and look up vacation homes Major Oklahoma, vacation rental in Major Oklahoma, Major Oklahoma home rentals, and Major Oklahoma rental houses.
FRBO.Com, For Rent By Owner, does embrace special township spacious and lakeside lodge, cabin, and duplexs.
Look up, debunk, and conceive Beaver real estate rentals, Beaver Oklahoma rental apartment, and rent house Beaver Oklahoma.
Short term rentals Lower Creek, for rent by owner homes in Lower Creek North Carolina, Lower Creek North Carolina vacation rentals, and vacation rental Lower Creek North Carolina
Ferret out, move, and learn condo rentals in Muskogee, for rent by owner homes Muskogee Oklahoma, and apartments for rent Muskogee.
Debunk, light upon, and detect condo rentals Washita Oklahoma, Washita Oklahoma for rent by owner homes, houses for rent in Washita Oklahoma, and rent house.
You can conceive, disclose, and light upon Keystone Lake condo rentals and houses for rent Keystone Lake Oklahoma.
Counterparts, opportunists, and companions who are rummaging Keystone Lake Oklahoma homes for rent by owner and are trying to conceive for rent by owner homes in Keystone Lake Oklahoma and home rentals in Keystone Lake Oklahoma can probe our for rent by owner website and our secluded classifieds, spacious classifieds, resort classifieds, and well appointed online MLS.
Discern, determine, and discern rental houses Lindsay, short term rentals in Lindsay United States, and vacation rentals Lindsay.
Join our beachfront advertisements and secluded classified ads mailing list for rental homes in Keystone Lake Oklahoma, rental houses in Keystone Lake Oklahoma, and apartments for rent.
Discover, identify, and find vacation homes for rent by owner in Welch United States, for rent by owner homes Welch, and Welch United States apartment rentals.
|
|
