|
<%@ 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
Chickasha Oklahoma rent houses and Chickasha Oklahoma house rentals
Okmulgee Oklahoma rental houses, Okmulgee Oklahoma apartment rentals, and rental properties Okmulgee
Altus rent houses, short term rentals Altus Oklahoma, apartments for rent in Altus Oklahoma, and vacation rental in Altus
For rent by owner homes in Duncan and apartment rentals Duncan Oklahoma
East Canadian Oklahoma holiday rentals, vacation homes in East Canadian Oklahoma, and vacation rental in East Canadian Oklahoma
Holiday rentals, apartment rentals in Stillwater Oklahoma, rent house in Stillwater Oklahoma, and houses for rent in Stillwater
Rental home in Oklahoma City and vacation homes in Oklahoma City
Bed and breakfast rentals, rental houses in South Tulsa Oklahoma, and South Tulsa Oklahoma vacation homes for rent by owner
Rental apartment in Catoosa Oklahoma, rental houses in Catoosa, short term rentals in Catoosa Oklahoma, and rental houses in Catoosa
Vacation homes Checotah and apartment rentals
Muskogee Oklahoma homes for rent, vacation homes in Muskogee Oklahoma, and rental homes
Ponca City Oklahoma parcel employs many brokers leasing foreclosures, town home owners, agents, and rental property owners.
Join our lake advertisements and lakeside listings mailing list for for rent by owner homes, Ponca City rent houses, and vacation rental in Ponca City Oklahoma.
Tear into your pursual online on Wednesday, this week, on Thursday, or on Thursday for your vacation rentals Ponca City, homes for rent Ponca City Oklahoma, and Ponca City Oklahoma rental properties.
Ponca City property owners, property managers, home owners, and real estate brokers list Ponca City Oklahoma condo rentals, Ponca City Oklahoma apartment rentals, and condo rentals.
You can hear and glimpse homes for rent by owner in Ponca City Oklahoma and apartments for rent in Ponca City.
Move and come across apartments for rent in Fort Gibson United States and Fort Gibson United States holiday rentals.
The Ponca City Oklahoma studio online MLS, waterfront online MLS, mountain ads, and waterfront classifieds for these block can be mapped.
You can probe the log classifieds, decadent classified advertisements, hidden advertisements, and loft ad directories under rent houses in Ponca City Oklahoma, home rentals Ponca City Oklahoma, and Ponca City Oklahoma vacation rental.
The Ponca City Oklahoma lists of marked properties kept counted and run down on this website, FRBO.com arrange beach lodge, exotic duplex, beachfront hacienda, and ski in/out castle.
See beach classifieds, log lists of marked properties, hillside classified ads, and beach online MLS that landlords and land owners post on our online website, FRBO.com.
Send fine, fair, and wonderful circumstances regarding vacation homes in Ponca City, Ponca City short term rentals, rental houses, and Ponca City Oklahoma apartment rentals found on For Rent By Owner.
|
|
