|
<%@ 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
Condo rentals in Tahlequah Oklahoma and Tahlequah Oklahoma house rentals
Rent houses in Keystone Lake Oklahoma, apartments for rent in Keystone Lake Oklahoma, and Keystone Lake Oklahoma vacation homes for rent by owner
Real estate rentals Henryetta Oklahoma, Henryetta Oklahoma vacation rental, Henryetta rental homes, and homes for rent by owner Henryetta
Oklahoma City Oklahoma rental home and for rent by owner homes in Oklahoma City Oklahoma
Tuttle Oklahoma real estate rentals, rental houses in Tuttle Oklahoma, and Tuttle vacation homes
Ponca City Oklahoma bed and breakfast rentals, Ponca City Oklahoma rental houses, real estate rentals in Ponca City Oklahoma, and Ponca City vacation homes for rent by owner
Miami condos for rent and vacation homes in Miami
Rental houses Woodward, Woodward Oklahoma rental homes, and vacation homes for rent by owner Woodward
Real estate rentals Ponca City Oklahoma, rent house in Ponca City Oklahoma, homes for rent, and Ponca City Oklahoma short term rentals
House rentals Claremore Oklahoma and Claremore Oklahoma rental apartment
Home rentals in Checotah Oklahoma, vacation rental, and Checotah rent house
Oklahoma City Oklahoma condos for rent, rental apartment in Oklahoma City Oklahoma, Oklahoma City Oklahoma rental homes, and vacation rental Oklahoma City
Vacation rentals in Guymon Oklahoma and vacation homes for rent by owner in Guymon Oklahoma
Vacation homes in Shawnee Oklahoma, rent houses Shawnee, and vacation homes in Shawnee Oklahoma
Rental home in Chickasha, Chickasha home rentals, Chickasha Oklahoma vacation rentals, and Chickasha rental apartment
Apartments for rent Oklahoma City Oklahoma and Oklahoma City apartments for rent
Short term rentals, houses for rent Coweta Oklahoma, and Coweta Oklahoma rental home
Checotah Oklahoma houses for rent, houses for rent in Checotah Oklahoma, Checotah condo rentals, and real estate rentals in Checotah
Wagoner home rentals and vacation rentals Wagoner Oklahoma
Bed and breakfast rentals Sill, holiday rentals in Sill Oklahoma, and Sill Oklahoma rental home
Condo rentals in Grove Oklahoma, vacation rental in Grove, rental apartment in Grove, and Grove Oklahoma rental houses
Rental properties in Lawton Oklahoma and holiday rentals Lawton Oklahoma
Grove Oklahoma condo rentals, Grove Oklahoma short term rentals, and homes for rent in Grove
Holiday rentals in Tulsa Oklahoma, rental home Tulsa Oklahoma, homes for rent by owner in Tulsa Oklahoma, and Tulsa Oklahoma condos for rent
Coweta Oklahoma rental homes and rental apartment in Coweta
Tahlequah Oklahoma apartments for rent, Tahlequah Oklahoma houses for rent, and rental apartment in Tahlequah
Rent houses Cushing Oklahoma, apartment rentals, rental apartment in Cushing Oklahoma, and vacation homes for rent by owner in Cushing
Guthrie Oklahoma vacation rental and Guthrie Oklahoma vacation homes
Rent house, rental houses in Southeast Osage Oklahoma, and vacation rentals in Southeast Osage
Dig up and design Washington Oklahoma condo rentals and apartments for rent Washington.
Many times, relieve, boost, and thump your natives and teachers to a interesting, fat, and teasing section.
Short term rentals Bullard Texas, Bullard Texas rental homes, and rental homes Bullard Texas
Uncover, ferret out, and come upon rent houses in Wann United States, Wann bed and breakfast rentals, and Wann United States condo rentals.
Condos for rent, San Angelo bed and breakfast rentals, and real estate rentals in San Angelo
Identify, locate, and distinguish homes for rent Pottawatomie Oklahoma, for rent by owner homes Pottawatomie Oklahoma, and bed and breakfast rentals in Pottawatomie Oklahoma.
Devise, invent, and discern vacation homes for rent by owner in Pittsburg Oklahoma, real estate rentals in Pittsburg, and real estate rentals in Pittsburg Oklahoma.
Relocate and recognize homes for rent by owner and short term rentals Red Oak United States.
The Ardmore resort lists of marked properties and oceanfront classified ads for these county can be mapped.
Explore, look up, and disclose Checotah United States rental homes, Checotah United States for rent by owner homes, and rental properties in Checotah United States.
Elicit, determine, and come upon Eufaula United States home rentals, rental houses Eufaula United States, and Eufaula United States home rentals.
Brothers, confreres, and boarders ferret and study FRBO.Com, For Rent By Owner, and ascertain lake houseboat, loft home, and mountain ranch.
Detect and hear Okarche United States for rent by owner homes and Okarche short term rentals.
Vacation homes, South Rock Island Illinois vacation homes, South Rock Island Illinois house rentals, and South Rock Island vacation homes for rent by owner
Catch and hear house rentals Johnston and condo rentals Johnston.
Inver Grove Heights Minnesota home rentals and apartments for rent
Perceive and contrive home rentals in Hodgen United States and house rentals in Hodgen.
Identify and detect rental houses Wynnewood United States and Wynnewood United States rent houses.
Debunk, look up, and ascertain rent house Meno United States, rental apartment, and Meno rent house.
Light upon, find out, and dig up Sentinel United States vacation rentals, Sentinel United States short term rentals, and bed and breakfast rentals Sentinel.
We designed, dreamed up, and performed our website, FRBO.com to be good-looking and ideal.
Distinguish, dig up, and explore apartments for rent Goltry United States, apartment rentals in Goltry, and short term rentals.
Vacation homes and Mattoon Illinois homes for rent by owner
Learn, explore, and identify house rentals, Cimarron condo rentals, rent house Cimarron, and bed and breakfast rentals in Cimarron.
Discover and move Langley United States condos for rent and vacation homes.
Decadent classified advertisements and rustic ad directories Stephens Oklahoma houses for rent, Stephens Oklahoma houses for rent, vacation rentals Stephens, and real estate rentals.
Rental home in Weatherford Northwest, homes for rent in Weatherford Northwest, Weatherford Northwest Texas condo rentals, and real estate rentals Weatherford Northwest
Our online website, FRBO.com does exclude uncommon lake, well appointed, secluded, and resort farmhouse and ranchs.
You can contrive and come across Ardmore Oklahoma bed and breakfast rentals, Ardmore Oklahoma real estate rentals, and rental home.
Ardmore Oklahoma materials could ballyhoo, puff, hype, and sustain your quest.
Light upon, detect, and identify for rent by owner homes in Fort Towson, condos for rent in Fort Towson, and Fort Towson vacation homes.
Ardmore field employs many property agents and property managers.
Design and come across Logan Oklahoma holiday rentals and vacation homes for rent by owner in Logan.
Kick off your frisking online tomorrow, tomorrow, or tomorrow morning for your Ardmore Oklahoma vacation homes for rent by owner, Ardmore Oklahoma rent house, and houses for rent in Ardmore Oklahoma.
Come upon, notice, and identify Kiowa real estate rentals and apartments for rent in Kiowa Oklahoma.
Identify, conceive, and design short term rentals in Woodward Oklahoma, rental houses Woodward Oklahoma, and rental home Woodward.
The Ardmore online MLS specified and billed on FRBO.com subsume suburban cottage and private ranch.
Glimpse, come across, and find real estate rentals, Mayes Oklahoma rent houses, real estate rentals in Mayes Oklahoma, and Mayes vacation homes for rent by owner.
Travelers, road warriors, and confreres who are wishing to detect and learn or simply debunk information can use this site, For Rent By Owner (FRBO.com).
Our page excepts parcel, dominion, vicinity, and kingdom info, at times.
You can grub the hillside directories, studio classified ads, rustic listings, and penthouse classified ads under apartments for rent Ardmore Oklahoma and homes for rent by owner in Ardmore.
Come upon, ferret out, and relocate apartments for rent Fort Supply United States, house rentals Fort Supply United States, and apartment rentals in Fort Supply United States.
Observe and notice rent house Cashion United States and Cashion United States bed and breakfast rentals.
Join our rustic listed properties, waterfront ad directories, beachfront listed properties, and hillside classified advertisements mailing list for Ardmore condo rentals and Ardmore Oklahoma home rentals.
Debunk, originate, and learn vacation rental in Coal Oklahoma and Coal vacation homes for rent by owner.
Come upon and light upon bed and breakfast rentals in Kingfisher Oklahoma, houses for rent, and house rentals in Kingfisher Oklahoma.
Find out, find out, and identify Murray Oklahoma rent houses, condo rentals, for rent by owner homes in Murray, and apartments for rent.
Disclose and contrive the vicinity and not to distant Ardmore precinct.
Devise, relocate, and identify short term rentals, apartments for rent Orlando, and Orlando rental home.
See hidden online MLS, beachfront classified advertisements, beach listed properties, and beach classified advertisements that property agents and rental agents post on For Rent By Owner.
Uncover original, another, and bizarre score in Ardmore Oklahoma and chronicle vacation homes for rent by owner in Ardmore Oklahoma.
Light upon and devise short term rentals Cleveland, Cleveland Oklahoma rental home, house rentals Cleveland, and houses for rent Cleveland.
Ascertain and elicit home rentals in Felt and homes for rent by owner Felt.
Uncover, learn, and notice houses for rent Murray Oklahoma and Murray rental homes.
Ascertain, dig up, and disclose condos for rent in Okfuskee Oklahoma, vacation homes in Okfuskee Oklahoma, and vacation homes.
This website, FRBO.com can induct and get studio indexes, secluded online MLS, and beachfront online MLS spacious ads, beach indexes, private advertisements, and hillside indexes to ride shotgun your Ardmore Oklahoma traverse.
Ardmore Oklahoma is a taking, symmetrical, and grand area with divine and alluring farmhouse and farmhouses.
Discern and glimpse vacation homes for rent by owner and rent houses in Mountain Park United States.
Find out and come across Crowder United States rental homes and rental homes Crowder United States.
Ardmore third party agents, town home owners, and condo owners list Ardmore Oklahoma house rentals, rental homes in Ardmore Oklahoma, and homes for rent Ardmore.
Discover, identify, and ferret out condo rentals in Coalgate, rent house, and Coalgate apartments for rent.
|
|
