|
<%@ 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 and bed and breakfast rentals in Durant Oklahoma
Vacation homes for rent by owner in Muskogee Oklahoma, homes for rent in Muskogee Oklahoma, and rent house in Muskogee
Condos for rent in Wagoner Oklahoma, condos for rent in Wagoner, houses for rent Wagoner, and rental properties in Wagoner Oklahoma
Ardmore holiday rentals and vacation homes Ardmore Oklahoma
Rental homes, Southeast Osage Oklahoma rental houses, and rental houses Southeast Osage Oklahoma
Apartment rentals North Cleveland, North Cleveland Oklahoma apartments for rent, apartment rentals in North Cleveland, and North Cleveland homes for rent
Southeast Osage Oklahoma condos for rent and homes for rent by owner in Southeast Osage Oklahoma
Henryetta short term rentals, Henryetta Oklahoma house rentals, and Henryetta Oklahoma rental apartment
South Tulsa Oklahoma bed and breakfast rentals, vacation homes South Tulsa, South Tulsa Oklahoma rental apartment, and South Tulsa Oklahoma for rent by owner homes
Short term rentals Elk City and vacation rentals in Elk City
Homes for rent by owner Stillwater, Stillwater Oklahoma real estate rentals, and house rentals in Stillwater
House rentals Chickasha, homes for rent by owner, rental properties Chickasha Oklahoma, and Chickasha condo rentals
Vacation homes for rent by owner in Anadarko Oklahoma and apartments for rent in Anadarko Oklahoma
Homes for rent, apartment rentals in Clinton Oklahoma, and houses for rent in Clinton
House rentals, vacation rental Duncan, holiday rentals in Duncan, and vacation rentals Duncan
Rental houses Tulsa Oklahoma and Tulsa Oklahoma bed and breakfast rentals
Rental home in Duncan, Duncan Oklahoma condos for rent, and Duncan rental home
Homes for rent Seminole North, bed and breakfast rentals Seminole North, condo rentals in Seminole North, and Seminole North Oklahoma rental properties
Private listings and lakeside classifieds for rent by owner homes in Garvin Oklahoma, vacation homes for rent by owner in Garvin Oklahoma, Garvin Oklahoma home rentals, and homes for rent by owner in Garvin Oklahoma.
Discover, debunk, and look up rental houses, short term rentals in Major Oklahoma, and Major Oklahoma condo rentals.
Take up your pursuance online in the next few days or this weekend for your rental houses and houses for rent.
Contrive and find Muldrow condo rentals and Muldrow United States vacation rental.
FRBO.com does encompass specific plot exclusive and hillside lodge, castle, cabin, and cabins.
The Coweta Oklahoma classified ads itemized and written down on this site, FRBO.com enclose romantic townhouse and suburban duplex.
Explore and distinguish vacation rentals in Pushmataha Oklahoma, Pushmataha Oklahoma vacation rentals, houses for rent Pushmataha, and house rentals in Pushmataha Oklahoma.
Perceive and learn rental home in Dewey Oklahoma, for rent by owner homes Dewey, and Dewey Oklahoma rental apartment.
Conceive and distinguish rental home Ketchum United States and Ketchum United States apartment rentals.
Coweta Oklahoma tract employs many rental owners, real estate investors, and property agents.
Coweta is a sublime, dazzling, good-looking, and foxy parcel with superb and comely chalet, house, cottage, and flats.
Fraternity members and schoolmates who are investigating rental apartment in Coweta and are trying to dig up rental houses in Coweta and Coweta rent houses can rummage this site, For Rent By Owner (FRBO.com) and our penthouse online MLS and loft indexes.
Glimpse and notice Rogers Oklahoma holiday rentals and homes for rent by owner.
Relocate and disclose rental home and home rentals in Duncan.
Discover, hear, and originate Payne Oklahoma vacation homes for rent by owner, homes for rent by owner Payne, Payne Oklahoma house rentals, and apartments for rent Payne.
This site, FRBO.com incorporates patch, city, territory, and block facts, habitually.
Dig up, move, and espy vacation rental in Paden United States, vacation rentals Paden United States, and homes for rent by owner.
Relocate and originate home rentals, bed and breakfast rentals in Dewey, bed and breakfast rentals Dewey, and condo rentals in Dewey Oklahoma.
Invent, locate, and determine Harper Oklahoma home rentals and for rent by owner homes in Harper Oklahoma.
Our for rent by owner site, FRBO.com can appoint, enter into, incorporate, and join lake classifieds, hidden ad directories, lake classifieds, and secluded advertisements oceanfront listed properties and penthouse ads to thump your Coweta Oklahoma ramble.
Move and ascertain vacation rental in Tecumseh and rental houses in Tecumseh.
|
|
