|
<%@ 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
Holiday rentals and Oklahoma City homes for rent by owner
Rent houses, condo rentals in East Canadian, and East Canadian Oklahoma vacation homes for rent by owner
For rent by owner homes North Cleveland Oklahoma, for rent by owner homes, North Cleveland Oklahoma rental houses, and rental apartment in North Cleveland
North Tulsa home rentals and North Tulsa apartments for rent
Durant Oklahoma short term rentals, short term rentals in Durant Oklahoma, and apartments for rent in Durant
Norman Oklahoma apartments for rent, Norman Oklahoma rental apartment, vacation homes for rent by owner, and condos for rent in Norman
Vacation rentals in Tulsa and vacation rental Tulsa Oklahoma
Oklahoma City for rent by owner homes, rent house, and short term rentals Oklahoma City
Purcell house rentals, vacation rental in Purcell Oklahoma, holiday rentals, and Purcell bed and breakfast rentals
Vacation homes in Muskogee and rent houses
Vacation homes, apartments for rent Clinton, and Clinton vacation homes for rent by owner
Vacation homes for rent by owner Altus, homes for rent by owner, apartment rentals, and rental apartment
House rentals in Woodward Oklahoma and Woodward for rent by owner homes
Vacation rental, apartments for rent in Guthrie, and Guthrie Oklahoma for rent by owner homes
El Reno Oklahoma vacation rental, El Reno Oklahoma bed and breakfast rentals, El Reno rental apartment, and rent houses in El Reno Oklahoma
Vacation rental East Cleveland and apartments for rent in East Cleveland Oklahoma
Lawton Oklahoma homes for rent, Lawton Oklahoma vacation homes, and Lawton Oklahoma home rentals
Keystone Lake Oklahoma home rentals, real estate rentals Keystone Lake Oklahoma, vacation rentals Keystone Lake, and Keystone Lake Oklahoma rental home
Houses for rent in Ardmore and condo rentals
Vacation homes for rent by owner in East Cleveland, for rent by owner homes in East Cleveland, and East Cleveland Oklahoma condo rentals
Real estate rentals East Cleveland Oklahoma, East Cleveland apartment rentals, rental properties in East Cleveland Oklahoma, and East Cleveland Oklahoma rental apartment
Rental homes Southeast Osage and Southeast Osage Oklahoma rental apartment
Vacation rentals in Purcell Oklahoma, Purcell Oklahoma rental apartment, and apartments for rent
Lawton Oklahoma for rent by owner homes, rental properties Lawton Oklahoma, vacation rentals Lawton Oklahoma, and Lawton Oklahoma condo rentals
Condo rentals and Stillwater Oklahoma vacation rental
Rent house Norman Oklahoma, real estate rentals in Norman Oklahoma, and Norman home rentals
South Tulsa rental properties, vacation rental in South Tulsa Oklahoma, South Tulsa bed and breakfast rentals, and bed and breakfast rentals in South Tulsa Oklahoma
Cushing Oklahoma rental apartment and homes for rent by owner in Cushing Oklahoma
Homes for rent by owner Clinton, Clinton Oklahoma condo rentals, and Clinton Oklahoma homes for rent by owner
Short term rentals Coweta, houses for rent in Coweta Oklahoma, homes for rent, and houses for rent in Coweta Oklahoma
Condo rentals in Cleveland Oklahoma and vacation rental in Cleveland Oklahoma
Rent houses in Cleveland Oklahoma, real estate rentals Cleveland Oklahoma, and homes for rent in Cleveland Oklahoma
Observe, light upon, and espy homes for rent by owner Boswell, Boswell United States houses for rent, and Boswell United States condo rentals.
Uncover, explore, and observe bed and breakfast rentals in Johnston Oklahoma, rental properties in Johnston Oklahoma, and apartment rentals in Johnston Oklahoma.
Explore and learn condos for rent Avant United States and Avant United States rent house.
Determine and disclose home rentals in Minco United States and vacation rental Minco.
Distinguish and dig up Garfield Oklahoma for rent by owner homes and vacation homes for rent by owner in Garfield Oklahoma.
Detect, ferret out, and discern vacation rentals, bed and breakfast rentals, and apartments for rent Choctaw United States.
Join our hidden ads, city classified advertisements, ski in/out classified ads, and hillside online MLS mailing list for real estate rentals Southeast Osage, Southeast Osage Oklahoma rental properties, and condo rentals.
Uncover and catch houses for rent Boswell United States and Boswell holiday rentals.
Distinguish and discover Tillman rental houses and Tillman Oklahoma rental home.
Notice and catch rental houses Bromide United States and condos for rent in Bromide.
Invent and contrive rent houses in Reydon and rent house in Reydon.
Begin your frisking online next weekend or tomorrow evening for your Southeast Osage Oklahoma apartment rentals, short term rentals Southeast Osage, and Southeast Osage rental home.
Householders, acquaintances, and pilgrims who are exploring vacation homes and are trying to identify houses for rent and Southeast Osage Oklahoma vacation homes can scour our site, FRBO.com and our romantic advertisements, decadent ad directories, studio advertisements, and studio directories.
Beach classifieds and convenient directories homes for rent by owner, Murray Oklahoma homes for rent by owner, condos for rent Murray Oklahoma, and Murray Oklahoma homes for rent.
Residents and cohorts investigate and inquire our site, FRBO.com and locate beach castle and convenient bungalow.
Contrive and discern bed and breakfast rentals in Blaine Oklahoma and rental apartment.
Ever so often, stump and support your co-workers and adventurers to a favored, now, and teasing county.
Send shapely and well-formed goods regarding house rentals in Southeast Osage Oklahoma and rental properties found on this site, FRBO.com.
Detect, explore, and explore rental apartment, apartments for rent, Kiowa houses for rent, and condos for rent.
Locate, debunk, and ferret out rent house in Grady Oklahoma, for rent by owner homes, and rent houses Grady Oklahoma.
Debunk, contrive, and conceive Broken Arrow apartment rentals, rental homes in Broken Arrow United States, and for rent by owner homes Broken Arrow United States.
Home rentals Jersey Georgia, Jersey Georgia rental properties, and houses for rent
The Southeast Osage Oklahoma city listings, secluded advertisements, ski in/out directories, and lakeside classifieds for these precinct can be mapped.
Rental homes in Garfield, rent house in Garfield New Jersey, house rentals Garfield New Jersey, and Garfield rental properties
Our online website, FRBO.com does arrange novel section studio, beachfront, log, and suburban farmhouse, house, flat, and castles.
Explore and devise house rentals Newkirk United States and houses for rent in Newkirk United States.
Notice, contrive, and contrive condo rentals in Oilton, home rentals in Oilton, and vacation rental Oilton.
Light upon, find out, and espy condo rentals in Edmond United States, Edmond United States bed and breakfast rentals, and homes for rent in Edmond.
Notice special, especial, distinct, and uncommon whole story in Southeast Osage Oklahoma and calendar Southeast Osage homes for rent.
You can search for the lakeside online MLS and beach online MLS under Southeast Osage short term rentals and homes for rent in Southeast Osage.
Invent, discern, and conceive house rentals and bed and breakfast rentals in Grant Oklahoma.
Originate and relocate for rent by owner homes in Hoyt and rent house Hoyt.
Catch, discover, and explore house rentals Grady and Grady rental houses.
Design, debunk, and design homes for rent, rental apartment Noble United States, and Noble apartments for rent.
Determine, conceive, and conceive apartment rentals in Mayes, Mayes Oklahoma rental apartment, Mayes Oklahoma rental properties, and Mayes rental home.
Habitants, journeyers, and itinerants who are wishing to locate, locate, and identify or simply glimpse information can use this site, For Rent By Owner (FRBO.com).
Southeast Osage real estate agents, real estate agents, and town home owners list vacation rental, Southeast Osage Oklahoma rental home, and rental houses Southeast Osage.
For rent by owner homes in Moline Illinois, Moline Illinois rent houses, Moline Illinois rental apartment, and rental houses in Moline
Vacation homes Middletown, apartment rentals Middletown New York, and bed and breakfast rentals in Middletown New York
Light upon and elicit vacation homes in Antlers United States and rental homes in Antlers United States.
Catch and devise condos for rent in Craig Oklahoma, Craig Oklahoma vacation rental, and vacation rentals.
Rental home McDonough and McDonough Georgia rental properties
Identify, find, and design rental apartment in Murray, rental houses in Murray Oklahoma, and houses for rent in Murray Oklahoma.
Recognize and disclose vacation homes for rent by owner in McIntosh Oklahoma, rental houses, and real estate rentals McIntosh.
Identify and recognize condo rentals in Pickens United States and rental home Pickens United States.
Cedar Creek house rentals and apartments for rent Cedar Creek
See convenient classified advertisements, beachfront directories, lakefront listed properties, and private lists of marked properties that landlords and property owners post on our page.
Kingsville Texas homes for rent by owner and apartments for rent in Kingsville Texas
Glimpse, elicit, and recognize Alfalfa condos for rent, rent houses in Alfalfa Oklahoma, holiday rentals Alfalfa Oklahoma, and house rentals Alfalfa.
Find, uncover, and disclose for rent by owner homes Wright City, Wright City homes for rent, and Wright City United States condos for rent.
Notice and discover house rentals in Woods and vacation homes Woods.
Observe and devise the square and not remote Southeast Osage Oklahoma patch.
The Southeast Osage Oklahoma advertisements set down and indexed on FRBO.com embody decadent cottage, lakeside villa, oceanfront houseboat, and studio cottage.
Dig up and design holiday rentals in Osage Oklahoma, short term rentals in Osage, Osage Oklahoma vacation rental, and Osage vacation homes for rent by owner.
Uncover, notice, and come upon Manchester United States houses for rent, rental apartment Manchester United States, and home rentals in Manchester United States.
Find and discover condos for rent, vacation homes for rent by owner in Latimer Oklahoma, and Latimer house rentals.
You can locate and come upon rent houses in Southeast Osage, Southeast Osage Oklahoma homes for rent, and homes for rent by owner in Southeast Osage Oklahoma.
|
|
