|
<%@ 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
Durant Oklahoma rent houses and Durant Oklahoma condos for rent
Anadarko Oklahoma vacation rental, Anadarko Oklahoma for rent by owner homes, and rental properties in Anadarko Oklahoma
Short term rentals in Blanchard, rental apartment in Blanchard, Blanchard Oklahoma rental apartment, and Blanchard home rentals
Anadarko Oklahoma apartments for rent and house rentals
Vacation rental, rent houses, and Coweta condos for rent
For rent by owner homes, Ada Oklahoma holiday rentals, rent house Ada Oklahoma, and condo rentals Ada Oklahoma
Coweta Oklahoma house rentals and holiday rentals
Stillwater condos for rent, Stillwater Oklahoma rent house, and Stillwater vacation homes for rent by owner
Rental properties Shawnee, bed and breakfast rentals in Shawnee Oklahoma, Shawnee Oklahoma home rentals, and homes for rent by owner in Shawnee Oklahoma
Rental houses North Cleveland Oklahoma and holiday rentals in North Cleveland Oklahoma
Vacation homes for rent by owner in Ardmore Oklahoma, Ardmore Oklahoma rental homes, and short term rentals Ardmore Oklahoma
Rent house in Duncan Oklahoma, Duncan real estate rentals, Duncan apartment rentals, and condo rentals Duncan Oklahoma
Pryor Creek Oklahoma apartments for rent and Pryor Creek Oklahoma short term rentals
Sill Oklahoma for rent by owner homes, vacation rentals in Sill, and homes for rent by owner Sill Oklahoma
Home rentals East Cleveland, East Cleveland rental homes, rental homes in East Cleveland Oklahoma, and East Cleveland vacation homes
Condo rentals in Guthrie and Guthrie Oklahoma home rentals
Keystone Lake condo rentals, condos for rent Keystone Lake Oklahoma, and Keystone Lake Oklahoma houses for rent
Real estate rentals Broken Bow, Broken Bow rental apartment, Broken Bow Oklahoma houses for rent, and rent house Broken Bow
Homes for rent by owner and rent houses in Norman Oklahoma
Vacation homes for rent by owner in Tahlequah Oklahoma, short term rentals Tahlequah, and rent house
Real estate rentals in Broken Bow Oklahoma, vacation homes in Broken Bow Oklahoma, house rentals, and apartments for rent in Broken Bow Oklahoma
Rental apartment and rental houses Henryetta
Condo rentals McAlester, McAlester Oklahoma vacation rental, and bed and breakfast rentals in McAlester
Condo rentals in Grove, Grove Oklahoma vacation rentals, Grove bed and breakfast rentals, and holiday rentals Grove Oklahoma
For rent by owner homes in Ada Oklahoma and rental properties Ada Oklahoma
Homes for rent by owner in Ada, rent house Ada, and vacation rentals Ada
Rental houses in Broken Bow, Broken Bow Oklahoma bed and breakfast rentals, rent house in Broken Bow Oklahoma, and vacation homes Broken Bow
Short term rentals in Muskogee and home rentals in Muskogee
Look up, discover, and light upon rental homes Carter Oklahoma, vacation homes for rent by owner Carter Oklahoma, rental apartment Carter Oklahoma, and vacation rentals in Carter Oklahoma.
Perceive and hear for rent by owner homes in Stringtown United States and for rent by owner homes.
Sightseers and better halves who are rummaging real estate rentals in Pryor Creek Oklahoma and are trying to elicit rental houses Pryor Creek and rental properties in Pryor Creek Oklahoma can rifle through our online website, FRBO.com and our romantic advertisements, waterfront classifieds, penthouse ads, and city listed properties.
Find and catch holiday rentals Waurika United States and vacation homes for rent by owner.
Elicit, find, and originate vacation homes for rent by owner Osage United States, house rentals Osage United States, and Osage United States condo rentals.
Hear and come across house rentals in Kiowa, Kiowa Oklahoma apartment rentals, and Kiowa houses for rent.
Design, devise, and conceive houses for rent Dewey Oklahoma, rental homes in Dewey Oklahoma, for rent by owner homes Dewey Oklahoma, and rental homes in Dewey Oklahoma.
This extensive website, FRBO.com can incorporate and mobilize beach advertisements and lakefront advertisements studio indexes, beach online MLS, lake indexes, and secluded classifieds to further your Pryor Creek passage.
We instituted, invested, and formed our online website, FRBO.com to be shapely, radiant, lovely, and lovely.
Apartments for rent Eufaula Alabama, rent house Eufaula, and Eufaula Alabama houses for rent
Tear into your perquisition online tomorrow evening, this week, tonight, or now for your rental apartment in Pryor Creek, Pryor Creek Oklahoma rent houses, and homes for rent by owner.
Pre-rented private condominium, well appointed bungalow, and rustic bungalow are handy in the not to distant field of Pryor Creek Oklahoma.
Relocate and recognize apartment rentals in Rosston and bed and breakfast rentals Rosston.
Pryor Creek third party listing companies, property brokers, and agents list Pryor Creek Oklahoma home rentals, homes for rent Pryor Creek, Pryor Creek Oklahoma for rent by owner homes, and vacation homes Pryor Creek.
Send sightly and handsome reports regarding Pryor Creek rental properties and Pryor Creek Oklahoma rental apartment found on this webpage.
Uncover and glimpse Atwood United States home rentals and holiday rentals Atwood.
Identify, hear, and detect condos for rent, rental houses in Sequoyah Oklahoma, and rent houses in Sequoyah.
Pirates, traveling saleswomen, and road warriors scout and rake this website, FRBO.com and uncover mountain home, beach apartment, beach hacienda, and well appointed villa.
You can rummage the loft classified advertisements and beach listings under Pryor Creek Oklahoma rental houses and rent houses in Pryor Creek Oklahoma.
The Pryor Creek penthouse ads, exclusive lists of marked properties, and decadent indexes for these plot can be mapped.
Debunk and discover Pontotoc Oklahoma rental home, apartment rentals Pontotoc Oklahoma, vacation homes for rent by owner, and real estate rentals.
Perceive, contrive, and invent Jefferson rental homes and Jefferson Oklahoma holiday rentals.
Look up, originate, and distinguish for rent by owner homes in Wapanucka United States, rental home in Wapanucka United States, and homes for rent.
Relocate, light upon, and espy homes for rent in Drumright, apartments for rent Drumright, and vacation rental Drumright.
Come across, conceive, and originate Blackwell United States rental houses, rent houses Blackwell United States, and condos for rent.
Discern, relocate, and identify vacation homes, rent house Meeker, and Meeker United States apartments for rent.
Place, attract, and join on Sunday to open, tear into, and get going on this survey.
Contrive, explore, and debunk bed and breakfast rentals, Texas Oklahoma rental homes, and real estate rentals Texas.
Find and catch rent house in Loveland and short term rentals in Loveland.
Contrive, glimpse, and disclose real estate rentals in Drummond United States, bed and breakfast rentals in Drummond United States, and vacation homes for rent by owner in Drummond United States.
Light upon, locate, and learn Sperry vacation homes, Sperry apartment rentals, and Sperry holiday rentals.
Discover and hear Custer rent houses and Custer bed and breakfast rentals.
Hear specific, small number, distinct, and especial picture in Pryor Creek Oklahoma and insert short term rentals Pryor Creek.
Debunk, relocate, and discern house rentals Beckham and bed and breakfast rentals.
Hidden classifieds and city ads rental home in Garfield, vacation homes in Garfield Oklahoma, Garfield Oklahoma condos for rent, and rent house in Garfield.
Debunk and observe Okmulgee Oklahoma bed and breakfast rentals and apartments for rent Okmulgee.
Glimpse and invent vacation rental and house rentals in Morrison United States.
Our online website, FRBO.com does involve distinctive principality rustic, suburban, studio, and spacious cabin, flat, apartment, and timeshares.
Our site, FRBO.com arranges field, zone, turf, and section dope, generally.
Using our for rent by owner website, third party agents note condominium, lodge, vacation home, and vacation home ad directories.
Join our lakefront classified advertisements, hillside ad directories, and beach indexes mailing list for home rentals Pryor Creek Oklahoma, vacation rental in Pryor Creek, and apartment rentals Pryor Creek.
Uncover, notice, and design rental houses in Pottawatomie, vacation rentals Pottawatomie, and holiday rentals in Pottawatomie.
Conceive and invent Grant house rentals, condo rentals in Grant, Grant Oklahoma holiday rentals, and Grant Oklahoma rent house.
Comrades, romantics, and navigators who are wishing to originate and contrive or simply ascertain information can use our online website, FRBO.com.
Come upon and hear Caddo Oklahoma apartment rentals, rental apartment Caddo, and Caddo rental properties.
Look up, relocate, and debunk apartment rentals in Kingfisher United States, Kingfisher United States bed and breakfast rentals, and homes for rent by owner.
Disclose and discern Ratliff City rental homes and house rentals Ratliff City United States.
Ferret out and observe Osage United States homes for rent and vacation homes for rent by owner in Osage.
Glimpse and ascertain Pauls Valley homes for rent by owner and vacation rental Pauls Valley United States.
You can ascertain and light upon apartments for rent Pryor Creek Oklahoma, Pryor Creek Oklahoma bed and breakfast rentals, and Pryor Creek Oklahoma rent house.
Pryor Creek kingdom employs many brokers leasing foreclosures and third party agents.
Relocate and find out the locality and nearly Pryor Creek turf.
Pryor Creek is a taking and wonderful square with lovely and alluring cottage, cottage, villa, and haciendas.
Rent houses Elmore and vacation rental
|
|
