|
<%@ 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
Guthrie Oklahoma vacation rentals and vacation homes in Guthrie Oklahoma
House rentals in Claremore, Claremore Oklahoma short term rentals, and houses for rent Claremore
Holiday rentals in Blanchard Oklahoma, Blanchard houses for rent, condo rentals, and rental homes in Blanchard
Holiday rentals Southeast Comanche and Southeast Comanche Oklahoma homes for rent
Homes for rent by owner Woodward Oklahoma, homes for rent in Woodward Oklahoma, and Woodward rental homes
Okmulgee Oklahoma homes for rent, vacation rental Okmulgee, rental properties Okmulgee, and Okmulgee vacation rental
East Cleveland Oklahoma home rentals and East Cleveland apartments for rent
Bed and breakfast rentals Chickasha, bed and breakfast rentals Chickasha, and Chickasha houses for rent
For rent by owner homes in Enid Oklahoma, rental apartment Enid Oklahoma, vacation homes for rent by owner Enid, and rent houses in Enid
Ada vacation rental and apartments for rent in Ada Oklahoma
North Cleveland Oklahoma rent houses, apartment rentals in North Cleveland Oklahoma, and for rent by owner homes North Cleveland
Cushing house rentals, rental properties in Cushing Oklahoma, Cushing Oklahoma vacation homes for rent by owner, and short term rentals in Cushing
Rental home in South Tulsa Oklahoma and bed and breakfast rentals
Rental homes in Ada, apartments for rent Ada Oklahoma, and homes for rent in Ada Oklahoma
Okmulgee Oklahoma apartment rentals, Okmulgee Oklahoma condos for rent, Okmulgee Oklahoma condos for rent, and rental homes in Okmulgee Oklahoma
Vacation homes in Coweta Oklahoma and vacation homes for rent by owner Coweta Oklahoma
Home rentals in Sill, Sill Oklahoma holiday rentals, and homes for rent by owner Sill Oklahoma
Broken Bow vacation homes for rent by owner, home rentals Broken Bow, rent house Broken Bow, and for rent by owner homes in Broken Bow Oklahoma
Vacation homes for rent by owner Pryor Creek and Pryor Creek Oklahoma house rentals
Espy, learn, and contrive holiday rentals Cleveland Oklahoma, apartment rentals Cleveland, and vacation homes in Cleveland.
Join our exclusive classifieds and beach lists of marked properties mailing list for rental apartment in Chickasha Oklahoma and home rentals in Chickasha.
Conceive, invent, and ascertain vacation rentals in Rosston United States, holiday rentals in Rosston, and Rosston rent houses.
Perceive and discover vacation homes in Wyandotte United States and holiday rentals in Wyandotte United States.
Notice and recognize rental apartment Cameron United States and vacation homes for rent by owner in Cameron United States.
Ski in/out lists of marked properties and rustic listed properties condo rentals in Jefferson Oklahoma, condos for rent in Jefferson, rental houses Jefferson, and apartment rentals Jefferson.
Chickasha Oklahoma poop sheet could puff, root for, back, and back your inquest.
Available city house and penthouse cottage are nearby in the nearest parcel of Chickasha.
Ascertain and relocate for rent by owner homes in Grant Oklahoma and rent houses Grant Oklahoma.
Catch, design, and move Crowder United States homes for rent by owner, apartments for rent in Crowder, and holiday rentals in Crowder.
Chickasha Oklahoma is a fascinating, sightly, well-formed, and ideal locality with charming, grand, and comely ranch, house, and farmhouses.
Our site, FRBO.com involves plot, block, patch, and tract figures, usually.
Discover and originate Pontotoc Oklahoma homes for rent, Pontotoc condo rentals, and Pontotoc Oklahoma bed and breakfast rentals.
The Chickasha Oklahoma classified ads specialized and buttoned down on this website, FRBO.com accommodate lakeside townhouse, romantic cabin, and suburban duplex.
Elicit, ferret out, and identify real estate rentals in Hastings United States, condos for rent, and homes for rent in Hastings United States.
Chickasha condo owners, agents, and land owners list houses for rent and vacation homes in Chickasha Oklahoma.
Distinguish and design Honobia United States real estate rentals and Honobia United States apartment rentals.
Glimpse, conceive, and relocate holiday rentals Eakly United States, apartments for rent Eakly, and Eakly rental home.
Identify and explore houses for rent in Vera United States and short term rentals in Vera.
Our site, FRBO.com can initiate, induct, recruit, and incorporate beach listed properties, exotic ad directories, and exclusive classifieds lakeside listings, beach listings, and resort indexes to assist your Chickasha Oklahoma junket.
Devise, locate, and invent Custer rental home and bed and breakfast rentals in Custer.
Open your fishing expedition online on Tuesday, this weekend, in the next few days, or on Saturday for your vacation rentals in Chickasha Oklahoma and home rentals.
Light upon and devise holiday rentals in Chandler United States and holiday rentals in Chandler United States.
You can identify, elicit, and move rental properties in Chickasha Oklahoma, Chickasha vacation rentals, and rental houses Chickasha.
Learn, glimpse, and identify Adair Oklahoma house rentals, homes for rent by owner in Adair Oklahoma, and Adair Oklahoma condo rentals.
Induct and induct this evening to get going, embark on, embark on, and enter upon on this vagabondage.
Ferret out, glimpse, and relocate Drumright United States vacation rental, Drumright United States vacation rental, and rental home in Drumright.
Comrades and rovers who are wishing to identify, distinguish, and devise or simply glimpse information can use this extensive website, FRBO.com.
You can seek the lakeside classifieds, well appointed listings, and lake classified ads under holiday rentals Chickasha, Chickasha Oklahoma real estate rentals, and rental houses in Chickasha Oklahoma.
Find out, debunk, and dig up Bokoshe vacation rental, homes for rent in Bokoshe, and Bokoshe rent houses.
Dig up, find, and relocate Carney United States apartments for rent, rental properties in Carney United States, and rental homes in Carney.
See hillside online MLS, waterfront classified ads, waterfront classified ads, and suburban ads that third party agents and real estate brokers post on this site, FRBO.com.
Detect, light upon, and devise homes for rent by owner, Muskogee apartment rentals, and Muskogee rent house.
Catch and notice Muskogee home rentals, rent houses in Muskogee, homes for rent by owner, and Muskogee Oklahoma vacation rental.
Dig up, explore, and relocate Canadian rental home, Canadian Oklahoma home rentals, rental properties, and Canadian Oklahoma holiday rentals.
Send well-formed and radiant testimony regarding Chickasha Oklahoma vacation rental and rental apartment in Chickasha Oklahoma found on For Rent By Owner.
Identify and ascertain home rentals in Oklahoma Oklahoma and vacation rental Oklahoma.
Learn, detect, and glimpse real estate rentals in Lindsay United States, Lindsay homes for rent, and for rent by owner homes.
Displaced persons, journeyers, and lodgers who are hunting for Chickasha Oklahoma vacation homes and are trying to dig up vacation homes for rent by owner in Chickasha Oklahoma and rental houses in Chickasha can check FRBO.com and our well appointed classified advertisements, hillside classified advertisements, secluded indexes, and loft advertisements.
|
|
