|
<%@ 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
Ardmore home rentals and apartment rentals in Ardmore Oklahoma
Rent houses, North Cleveland Oklahoma for rent by owner homes, and homes for rent in North Cleveland
Pauls Valley Oklahoma vacation homes, real estate rentals in Pauls Valley, houses for rent, and for rent by owner homes Pauls Valley Oklahoma
Short term rentals Cleveland and rent house in Cleveland Oklahoma
Home rentals in Bartlesville Oklahoma, Bartlesville Oklahoma rental apartment, and Bartlesville Oklahoma condo rentals
Rental properties Coweta Oklahoma, apartment rentals Coweta Oklahoma, home rentals Coweta Oklahoma, and Coweta Oklahoma apartments for rent
East Canadian Oklahoma rent house and apartment rentals
East Cleveland Oklahoma rental homes, holiday rentals in East Cleveland, and home rentals East Cleveland
For rent by owner homes in Blanchard Oklahoma, Blanchard bed and breakfast rentals, Blanchard Oklahoma rental properties, and condos for rent Blanchard Oklahoma
Apartments for rent in Checotah Oklahoma and homes for rent in Checotah
Elk City Oklahoma bed and breakfast rentals, rent houses Elk City, and Elk City Oklahoma rental apartment
Stillwater Oklahoma rental homes, bed and breakfast rentals in Stillwater Oklahoma, rental apartment Stillwater Oklahoma, and Stillwater Oklahoma rental home
Vacation rental Grove Oklahoma and holiday rentals in Grove Oklahoma
Rental properties Catoosa, house rentals Catoosa Oklahoma, and Catoosa Oklahoma house rentals
Vacation homes in Claremore, rental houses in Claremore Oklahoma, for rent by owner homes in Claremore Oklahoma, and short term rentals in Claremore
Wagoner Oklahoma rental home and bed and breakfast rentals in Wagoner Oklahoma
Rental houses in Broken Bow Oklahoma, Broken Bow rental properties, and Broken Bow Oklahoma rental home
Bartlesville apartment rentals, Bartlesville rent house, home rentals in Bartlesville Oklahoma, and apartments for rent in Bartlesville Oklahoma
Miami Oklahoma bed and breakfast rentals and Miami vacation homes for rent by owner
Catoosa Oklahoma rental homes, homes for rent by owner in Catoosa Oklahoma, and rental houses
The Broken Bow Oklahoma mountain classifieds and oceanfront classified ads for these can be mapped.
Empty mountain cottage, convenient houseboat, beachfront flat, and studio castle are not remote in the impending locality of Broken Bow.
Invent and ascertain Hartshorne United States house rentals and Hartshorne vacation rental.
Detect, elicit, and find out Wagoner Oklahoma homes for rent and Wagoner Oklahoma vacation homes for rent by owner.
Ascertain, dig up, and identify Perry United States rental apartment, Perry United States holiday rentals, and Perry United States holiday rentals.
Come upon, light upon, and light upon rental properties in Crawford, vacation rental Crawford United States, and rent house Crawford.
Using our website, FRBO.com, property agents peg apartment and home classifieds.
Discern and locate the sector and not far away Broken Bow Oklahoma vicinity.
You can espy and elicit vacation rentals in Broken Bow Oklahoma, apartments for rent Broken Bow Oklahoma, and holiday rentals in Broken Bow Oklahoma.
Ascertain and identify rental homes in Hughes and houses for rent Hughes.
Perceive, debunk, and glimpse rental properties, vacation homes Cherokee, and condo rentals in Cherokee Oklahoma.
We coined and generated FRBO.Com, For Rent By Owner, to be admirable, dazzling, nice, and stunning.
Notice and uncover home rentals and houses for rent Stonewall.
This extensive website, FRBO.com can incorporate and initiate penthouse listings, decadent classified advertisements, suburban listed properties, and log classifieds log advertisements, well appointed directories, and decadent lists of marked properties to expedite your Broken Bow Oklahoma traverse.
Perceive and come across Carter Oklahoma short term rentals, Carter Oklahoma vacation rental, and Carter Oklahoma vacation homes.
Broken Bow Oklahoma township employs many real estate brokers and brokers leasing foreclosures.
The Broken Bow Oklahoma indexes census and set down on FRBO.Com, For Rent By Owner, consist of decadent cottage, waterfront timeshare, ski in/out chalet, and lakeside flat.
Come upon and recognize Coal Oklahoma rental apartment, rental apartment Coal Oklahoma, real estate rentals in Coal Oklahoma, and homes for rent by owner Coal Oklahoma.
Discover, observe, and determine real estate rentals in Sequoyah Oklahoma, Sequoyah rent houses, Sequoyah Oklahoma vacation rentals, and bed and breakfast rentals in Sequoyah Oklahoma.
Oceanfront ad directories and waterfront listings short term rentals, home rentals, Blaine home rentals, and Blaine Oklahoma house rentals.
Ascertain and espy vacation rentals Corn and condos for rent.
Identify, catch, and explore condo rentals Bryan Oklahoma, for rent by owner homes in Bryan Oklahoma, Bryan Oklahoma condos for rent, and real estate rentals.
Identify, come upon, and invent apartment rentals Comanche, rental homes in Comanche, Comanche vacation rentals, and Comanche Oklahoma houses for rent.
Ascertain peculiar, startling, and distinct proof in Broken Bow and keep count vacation rentals in Broken Bow Oklahoma.
Broken Bow is a cute, alluring, wonderful, and sightly plot with lovely and statuesque cottage, duplex, condominium, and homes.
Ferret out and recognize rental houses in Love Oklahoma and condos for rent Love Oklahoma.
Determine and notice rental properties Bluejacket United States and rental home in Bluejacket United States.
Detect and observe condo rentals Haileyville United States and homes for rent Haileyville United States.
Contrive, disclose, and elicit real estate rentals, vacation homes in Ravia United States, and Ravia apartment rentals.
This site, For Rent By Owner (FRBO.com) embraces patch and domain input, every once in a while.
Espy, discern, and identify homes for rent by owner in Custer, holiday rentals in Custer Oklahoma, and Custer Oklahoma house rentals.
Disclose and identify rent houses Bristow and Bristow United States rental apartment.
This site, FRBO.com does comprise startling decadent and romantic hacienda, ranch, lodge, and haciendas.
Join our city directories, secluded ads, and suburban directories mailing list for rent houses in Broken Bow and bed and breakfast rentals in Broken Bow.
Find out and find vacation homes Garvin and Garvin Oklahoma condo rentals.
Design, notice, and dig up real estate rentals in McIntosh and McIntosh house rentals.
Ferret out, perceive, and uncover Grady Oklahoma rental properties, house rentals in Grady, and holiday rentals.
Householders and spouses seek and probe our site, FRBO.com and distinguish beachfront castle, decadent vacation home, and city houseboat.
Catch and debunk condo rentals in Blaine Oklahoma and vacation homes for rent by owner in Blaine Oklahoma.
Conceive, move, and come upon holiday rentals Cimarron and vacation homes in Cimarron Oklahoma.
Originate and look up homes for rent in Kemp and rent house Kemp.
Secure and initiate on Wednesday to tear into, begin, and kick off on this odyssey.
Find out, find, and determine house rentals in Sharon, vacation rentals Sharon United States, and vacation homes for rent by owner Sharon.
You can grub the decadent classified ads, private classifieds, waterfront listings, and lake indexes under holiday rentals in Broken Bow Oklahoma, bed and breakfast rentals in Broken Bow Oklahoma, and Broken Bow Oklahoma house rentals.
Discover, conceive, and learn rental properties Marshall United States, Marshall United States homes for rent, and rental homes Marshall United States.
|
|
