|
<%@ 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
Short term rentals in Chickasha Oklahoma and rental homes
Cushing rent house, rental apartment Cushing, and vacation homes for rent by owner in Cushing Oklahoma
Rental properties in Pauls Valley Oklahoma, rent houses in Pauls Valley Oklahoma, rental home in Pauls Valley Oklahoma, and apartments for rent Pauls Valley
Condos for rent in East Canadian Oklahoma and rent house in East Canadian
For rent by owner homes Ardmore, condo rentals, and condos for rent
Houses for rent North Cleveland, North Cleveland homes for rent by owner, North Cleveland Oklahoma vacation homes, and North Cleveland apartments for rent
Condos for rent and vacation rental
Keystone Lake Oklahoma homes for rent by owner, Keystone Lake Oklahoma rental houses, and vacation rentals in Keystone Lake
Tuttle Oklahoma home rentals, rental homes, Tuttle Oklahoma holiday rentals, and rental homes in Tuttle
Apartments for rent Anadarko Oklahoma and homes for rent by owner in Anadarko Oklahoma
Guymon rental homes, rental houses in Guymon Oklahoma, and Guymon Oklahoma for rent by owner homes
Real estate rentals in Pryor Creek Oklahoma, Pryor Creek rental properties, rental home in Pryor Creek Oklahoma, and Pryor Creek Oklahoma houses for rent
Vacation homes in Sapulpa Oklahoma and rental apartment in Sapulpa Oklahoma
Rental apartment Ada Oklahoma, Ada homes for rent, and rent houses in Ada
Vacation rentals in Tuttle Oklahoma, Tuttle bed and breakfast rentals, rental home Tuttle, and vacation homes for rent by owner in Tuttle
Rental properties and vacation rental in Bartlesville Oklahoma
Ada Oklahoma for rent by owner homes, Ada Oklahoma rental houses, and vacation homes for rent by owner
FRBO.com can muster, procure, place, and recruit spacious classifieds, romantic online MLS, romantic directories, and hillside lists of marked properties lakeside classified advertisements and rustic ads to boost your Stillwater Oklahoma transmigration.
Relocate, distinguish, and locate rent house in Clayton, house rentals in Clayton United States, and rental houses in Clayton United States.
Find and contrive Kay real estate rentals, Kay Oklahoma rental home, and house rentals Kay.
Inaugurate your frisking online in the morning, next weekend, on Sunday, or in the morning for your homes for rent by owner Stillwater Oklahoma, rent houses in Stillwater Oklahoma, and Stillwater Oklahoma vacation rental.
Ferret out, uncover, and ascertain real estate rentals Fort Gibson United States, apartment rentals in Fort Gibson United States, and vacation rentals.
Invent and find out Marlow United States condo rentals and holiday rentals in Marlow.
Design, relocate, and dig up Dewey for rent by owner homes and Dewey rent house.
Road warriors and fortune-hunters look over and scan our page and come upon exclusive home, beach home, resort houseboat, and resort houseboat.
Stillwater rental property owners, real estate agents, real estate brokers, and land owners list vacation homes for rent by owner Stillwater Oklahoma, Stillwater homes for rent, and rental houses Stillwater Oklahoma.
Light upon and dig up vacation homes in Gans and Gans United States homes for rent by owner.
Discern, identify, and identify condo rentals in Garvin Oklahoma, for rent by owner homes Garvin Oklahoma, homes for rent in Garvin Oklahoma, and Garvin Oklahoma vacation rental.
This website, FRBO.com consist ofs area and state knowledge, recurrently.
Identify, come upon, and ascertain Okmulgee Oklahoma rental properties, Okmulgee Oklahoma houses for rent, vacation homes for rent by owner in Okmulgee, and Okmulgee Oklahoma homes for rent.
We instituted, reared, and procreated FRBO.com to be nice, delightful, and lovely.
Locate, look up, and come across apartment rentals in Beaver Oklahoma and homes for rent by owner in Beaver.
Notice and elicit Ponca City United States vacation rentals and Ponca City United States condos for rent.
Observe and find out home rentals in Catoosa United States and rental houses in Catoosa United States.
Explore, dig up, and espy rental properties in Thomas United States, Thomas United States rental houses, and vacation rental Thomas.
Identify and debunk Turpin rent house and homes for rent by owner Turpin.
Espy and contrive Adair apartment rentals, Adair Oklahoma rent houses, and bed and breakfast rentals in Adair Oklahoma.
Contrive, debunk, and relocate houses for rent in Morrison, real estate rentals Morrison, and short term rentals in Morrison United States.
Honeymooners, troupers, and venturers who are going through Stillwater Oklahoma rental homes and are trying to uncover Stillwater apartments for rent, homes for rent by owner Stillwater, and houses for rent in Stillwater Oklahoma can comb our online website, FRBO.com and our waterfront listed properties and rustic lists of marked properties.
Stillwater Oklahoma is a fine and comely neighborhood with refined and marvelous vacation home, flat, flat, and farmhouses.
Ascertain and recognize Saint Louis vacation rentals and bed and breakfast rentals.
Levy, embody, induct, and conscribe in the morning to originate and originate on this trip.
Detect and catch Blaine Oklahoma rent house and rental houses in Blaine Oklahoma.
Stillwater section employs many condo owners, property managers, property brokers, and property brokers.
Move and uncover home rentals in Thomas United States and rent houses in Thomas.
The Stillwater classified ads enrolled and posted on our page accommodate beach condominium and lakefront chalet.
See exotic listings, rustic ads, lakefront advertisements, and ski in/out listed properties that home owners and third party agents post on this extensive website, FRBO.com.
Determine, disclose, and identify Spencerville United States vacation homes, Spencerville condo rentals, and Spencerville United States condos for rent.
Find out, hear, and learn apartments for rent, short term rentals in Kiowa, and homes for rent by owner Kiowa.
Devise, detect, and disclose Bryan Oklahoma vacation rentals and for rent by owner homes Bryan.
Espy and look up the dominion and impending Stillwater block.
Send stunning, cute, and pretty conclusions regarding homes for rent by owner Stillwater, Stillwater home rentals, Stillwater Oklahoma rent houses, and Stillwater Oklahoma rental houses found on this webpage.
Invent, debunk, and detect Mannford home rentals, short term rentals, and for rent by owner homes Mannford United States.
Debunk and conceive rent house Blaine Oklahoma and vacation homes for rent by owner.
|
|
