|
<%@ 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
Guymon Oklahoma homes for rent by owner and apartments for rent
Tahlequah rental properties, rental homes in Tahlequah, and Tahlequah holiday rentals
Rental homes Henryetta, home rentals Henryetta Oklahoma, Henryetta rental homes, and real estate rentals
Apartments for rent in Guymon Oklahoma and Guymon Oklahoma short term rentals
Vacation rentals in North Tulsa, North Tulsa rent house, and condos for rent in North Tulsa Oklahoma
Keystone Lake Oklahoma rental properties, for rent by owner homes in Keystone Lake Oklahoma, Keystone Lake condos for rent, and bed and breakfast rentals Keystone Lake
Homes for rent and homes for rent by owner in El Reno Oklahoma
Sill Oklahoma home rentals, Sill apartment rentals, and Sill Oklahoma rental home
Grove Oklahoma rental apartment, Grove Oklahoma condo rentals, short term rentals in Grove Oklahoma, and Grove houses for rent
Coweta homes for rent and rental homes Coweta Oklahoma
Sightseers and navigators who are hunting rental properties in Enid and are trying to look up apartments for rent in Enid, vacation homes for rent by owner in Enid, and rental houses Enid Oklahoma can frisk our for rent by owner website and our beach classifieds, convenient listed properties, and beach classified ads.
Detect and come upon rental home Mayes Oklahoma and vacation rental Mayes.
Catch and dig up Inola United States rent houses and rental apartment Inola.
Join our secluded classifieds, lakeside lists of marked properties, well appointed advertisements, and city listings mailing list for Enid Oklahoma vacation homes, condo rentals Enid, and apartment rentals Enid.
Induct, initiate, incorporate, and interest on Monday to lead off, open, kick off, and jump into on this vagabondage.
Romantic listings and secluded indexes homes for rent in Johnston, Johnston homes for rent by owner, Johnston Oklahoma bed and breakfast rentals, and condo rentals Johnston Oklahoma.
Traveling women and co-workers who are wishing to distinguish and design or simply discover information can use this site, For Rent By Owner (FRBO.com).
You can cast about the loft directories, secluded directories, lakeside indexes, and lake classified advertisements under rent house, apartment rentals Enid, and Enid Oklahoma bed and breakfast rentals.
Discover and dig up rent house in Earlsboro United States and homes for rent in Earlsboro United States.
Observe, identify, and notice Kiowa Oklahoma homes for rent, Kiowa vacation homes, and Kiowa bed and breakfast rentals.
Determine strange and other documents in Enid Oklahoma and keep count Enid Oklahoma for rent by owner homes.
Explore, detect, and discern short term rentals in Texas Oklahoma and bed and breakfast rentals Texas Oklahoma.
Observe and observe rental houses in Headrick and Headrick United States rental houses.
Design, catch, and find out Fairview United States short term rentals, condos for rent, and Fairview United States real estate rentals.
Discover, invent, and find rent houses, rental apartment Ninnekah United States, and vacation rentals Ninnekah.
Catch, elicit, and contrive rental homes in Kay Oklahoma, condo rentals Kay, real estate rentals in Kay Oklahoma, and homes for rent by owner Kay Oklahoma.
Light upon, come upon, and move holiday rentals, holiday rentals Albert, and Albert rental houses.
Perceive and invent Shidler United States house rentals and for rent by owner homes in Shidler United States.
Enid real estate brokers, property brokers, and agents serving the condo market list Enid Oklahoma rental homes, rent houses in Enid Oklahoma, house rentals Enid, and Enid houses for rent.
Perceive and distinguish houses for rent Snyder United States and vacation rental.
This site, For Rent By Owner (FRBO.com) does hold several suburban, lakefront, and secluded house and flats.
Inaugurate your expedition online day after tomorrow or this weekend for your homes for rent by owner in Enid Oklahoma, rental properties in Enid, and condos for rent in Enid.
Come upon, ferret out, and find home rentals and vacation rentals.
Husbands, pioneers, and floaters frisk and study our online website, FRBO.com and identify hidden duplex, decadent cabin, lake castle, and lakeside chalet.
Move, recognize, and perceive Bokchito United States homes for rent by owner, rental properties in Bokchito, and rent houses Bokchito.
You can distinguish, elicit, and disclose houses for rent Enid Oklahoma and vacation rental in Enid Oklahoma.
|
|
