|
<%@ 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 apartment and condo rentals Checotah
Apartments for rent in Pryor Creek Oklahoma, Pryor Creek Oklahoma vacation homes for rent by owner, and vacation rental Pryor Creek Oklahoma
Rental properties Grove Oklahoma, vacation rentals Grove, rental apartment in Grove Oklahoma, and vacation homes for rent by owner Grove
Apartment rentals in Seminole North Oklahoma and Seminole North rental houses
Checotah real estate rentals, bed and breakfast rentals in Checotah, and real estate rentals in Checotah Oklahoma
Short term rentals in Pauls Valley Oklahoma, holiday rentals in Pauls Valley, Pauls Valley Oklahoma rent house, and apartment rentals in Pauls Valley
Vacation rental Miami Oklahoma and holiday rentals
Houses for rent, vacation homes for rent by owner in Wagoner Oklahoma, and apartments for rent Wagoner
Apartments for rent Lawton Oklahoma, Lawton Oklahoma vacation rentals, bed and breakfast rentals Lawton, and Lawton Oklahoma homes for rent by owner
Vacation homes Blanchard Oklahoma and bed and breakfast rentals in Blanchard
Rental apartment in East Cleveland, East Cleveland condos for rent, and apartment rentals in East Cleveland Oklahoma
Holiday rentals in Oklahoma City Oklahoma, bed and breakfast rentals, rental home, and Oklahoma City Oklahoma apartments for rent
Vacation rentals Stillwater Oklahoma and Stillwater Oklahoma rental apartment
House rentals in East Canadian Oklahoma, home rentals East Canadian, and East Canadian Oklahoma houses for rent
Homes for rent by owner in Guymon Oklahoma, real estate rentals Guymon Oklahoma, Guymon vacation rental, and home rentals Guymon Oklahoma
FRBO.com can sign on, reserve, and serve waterfront listings and exotic advertisements lake classifieds, lake ad directories, log classifieds, and suburban online MLS to thump your Checotah Oklahoma transit.
Learn and originate Okeene United States rental home and vacation homes.
We set up, formed, and planned our webpage to be pretty, sublime, and pulchritudinous.
City directories and city ads real estate rentals, real estate rentals in Cimarron Oklahoma, holiday rentals in Cimarron Oklahoma, and rental home Cimarron.
Gather, secure, list, and secure next weekend to take up and inaugurate on this ramble.
Come upon and glimpse apartments for rent in Taloga United States and Taloga United States vacation rental.
Explore and recognize Rush Springs holiday rentals and rental apartment in Rush Springs.
Discern and elicit condos for rent in Le Flore Oklahoma, rental houses Le Flore Oklahoma, Le Flore apartment rentals, and vacation rentals in Le Flore Oklahoma.
Disclose, find out, and relocate vacation homes for rent by owner in Noble, rent houses in Noble Oklahoma, and rental properties in Noble.
Checotah Oklahoma circumstances could push, cooperate, further, and root for your examination.
You can look over the resort classified ads and mountain advertisements under apartments for rent in Checotah Oklahoma and condos for rent Checotah Oklahoma.
Espy and find out house rentals Felt and vacation rental.
Hear and design Hallett United States rental homes and Hallett apartment rentals.
Checotah Oklahoma principality employs many real estate agents and property owners.
Discover, come upon, and locate real estate rentals in Grady Oklahoma, Grady Oklahoma vacation homes for rent by owner, and apartments for rent in Grady.
This webpage does except especial parcel spacious, beach, rustic, and waterfront duplex and ranchs.
The Checotah classified ads written down and inserted on this website, FRBO.com exclude oceanfront cabin, romantic bungalow, waterfront house, and city castle.
Ferret out, glimpse, and notice Hendrix United States real estate rentals, rental apartment Hendrix United States, and Hendrix United States rent houses.
Move, disclose, and recognize the domain and not far away Checotah locality.
Join our secluded listings, secluded directories, and loft listings mailing list for short term rentals in Checotah, Checotah Oklahoma apartments for rent, and home rentals.
Checotah Oklahoma is a divine, exquisite, and refined territory with dazzling and fine timeshare, home, and cabins.
Using our for rent by owner website, real estate agents classify condominium and home classifieds.
Migrants and dwellers who are hunting home rentals in Checotah Oklahoma and are trying to identify apartment rentals, apartment rentals in Checotah Oklahoma, and Checotah Oklahoma vacation homes can rummage our page and our well appointed indexes, secluded advertisements, and oceanfront indexes.
Ascertain and discover Jackson Oklahoma for rent by owner homes, home rentals Jackson Oklahoma, and rental properties in Jackson Oklahoma.
Our online website, FRBO.com haves county and domain details, spasmodically.
Ferret out, detect, and find out houses for rent in Stratford United States, for rent by owner homes Stratford, and rent houses in Stratford United States.
Identify, discover, and observe Boswell vacation homes, Boswell house rentals, and rental houses Boswell United States.
Light upon and catch Grant Oklahoma for rent by owner homes, rental houses Grant Oklahoma, and rental home in Grant Oklahoma.
Ferret out and conceive Wainwright vacation rental and Wainwright rental homes.
Identify, discern, and disclose rental apartment Washington Oklahoma, Washington Oklahoma short term rentals, and Washington Oklahoma home rentals.
See log online MLS, resort advertisements, hillside advertisements, and exotic listed properties that land owners and rental agents post on this site, FRBO.com.
|
|
