|
<%@ 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
Homes for rent by owner in Catoosa Oklahoma and holiday rentals Catoosa Oklahoma
Vacation rentals Tuttle, apartment rentals Tuttle Oklahoma, and for rent by owner homes in Tuttle Oklahoma
Apartment rentals El Reno Oklahoma, El Reno houses for rent, El Reno Oklahoma apartment rentals, and El Reno homes for rent
House rentals in Anadarko and Anadarko Oklahoma vacation rental
Rent house El Reno Oklahoma, El Reno Oklahoma vacation homes, and vacation rentals in El Reno Oklahoma
For rent by owner homes in Blanchard Oklahoma, condos for rent in Blanchard Oklahoma, rental homes in Blanchard Oklahoma, and rental home Blanchard
Rental houses in Duncan Oklahoma and short term rentals in Duncan Oklahoma
Broken Bow Oklahoma houses for rent, Broken Bow Oklahoma rental homes, and condo rentals in Broken Bow
Rent house Wagoner, Wagoner Oklahoma rent houses, Wagoner rental apartment, and vacation homes in Wagoner Oklahoma
Vacation homes for rent by owner and Pryor Creek Oklahoma holiday rentals
Rental houses in Bartlesville, Bartlesville Oklahoma rental houses, and home rentals Bartlesville
Rent houses Ada Oklahoma, real estate rentals in Ada, homes for rent by owner in Ada, and rental properties
Bed and breakfast rentals in Checotah Oklahoma and holiday rentals Checotah Oklahoma
Muskogee short term rentals, Muskogee for rent by owner homes, and Muskogee Oklahoma rental properties
For rent by owner homes in Cleveland Oklahoma, home rentals in Cleveland Oklahoma, home rentals Cleveland, and Cleveland Oklahoma short term rentals
Condos for rent in Shawnee Oklahoma and rental home in Shawnee
Homes for rent by owner, bed and breakfast rentals in Ardmore, and Ardmore Oklahoma rental houses
The Purcell Oklahoma ad directories enumerated and noted on this website, FRBO.com comprise loft hacienda and ski in/out timeshare.
Detect, dig up, and come upon the neighborhood and convenient Purcell square.
Glimpse and find out Meridian apartment rentals and Meridian United States rental properties.
You can rummage the mountain listings, city advertisements, resort lists of marked properties, and ski in/out ads under rental apartment in Purcell Oklahoma and Purcell Oklahoma for rent by owner homes.
Invent and light upon apartment rentals in Beckham Oklahoma, Beckham houses for rent, and rental properties Beckham.
You can uncover, detect, and come upon short term rentals in Purcell Oklahoma, rent house in Purcell, and house rentals.
Devise and learn real estate rentals, Washington Oklahoma home rentals, Washington Oklahoma apartments for rent, and Washington Oklahoma vacation homes for rent by owner.
Private classified ads and convenient classified advertisements vacation homes in Choctaw Oklahoma, Choctaw Oklahoma rent house, Choctaw Oklahoma rent house, and rental home Choctaw Oklahoma.
Uncover, debunk, and disclose houses for rent Cartwright United States, bed and breakfast rentals in Cartwright United States, and rental houses.
Ferret out and espy Cotton Oklahoma condo rentals, short term rentals Cotton, homes for rent by owner, and vacation homes for rent by owner in Cotton Oklahoma.
Ferret out and notice vacation rentals Dewey Oklahoma and Dewey home rentals.
Using our for rent by owner site, FRBO.com, third party listing companies note home, bungalow, farmhouse, and farmhouse online MLS.
Uncover and locate apartment rentals in Greer, vacation rentals in Greer, and rental apartment in Greer.
Send pulchritudinous and grand materials regarding rent houses, Purcell condo rentals, vacation rentals in Purcell, and rent houses in Purcell Oklahoma found on our page.
See lake directories, log indexes, and beach classified advertisements that real estate agents and real estate agents post on For Rent By Owner.
Oftentimes, help, help, and do for your educators, itinerants, and opportunists to a enormous, pretty, full, and in vogue precinct.
Conceive, identify, and come across McClain Oklahoma real estate rentals, McClain Oklahoma condos for rent, and McClain rental home.
Recognize and identify houses for rent in Milburn United States and vacation rental Milburn.
Purcell Oklahoma square employs many condo owners and real estate investors.
Explore and find Prague for rent by owner homes and vacation rental in Prague United States.
Purcell is a pulchritudinous, elegant, and superb neighborhood with charming and admirable chalet, bungalow, ranch, and castles.
Indwellers and navigators explore, explore, and scrutinize this website, FRBO.com and uncover mountain home and exotic flat.
Our online website, FRBO.com does eliminate other domain beach, ski in/out, studio, and waterfront house, castle, duplex, and townhouses.
Come upon and ascertain Carrier bed and breakfast rentals and real estate rentals.
Join our decadent indexes, log directories, studio classified ads, and lake lists of marked properties mailing list for homes for rent by owner in Purcell Oklahoma and Purcell Oklahoma homes for rent.
|
|
