|
<%@ 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
Rental houses Miami Oklahoma and homes for rent by owner Miami Oklahoma
Rental homes in Norman Oklahoma, holiday rentals in Norman Oklahoma, and Norman homes for rent by owner
Homes for rent Seminole North Oklahoma, rent houses in Seminole North Oklahoma, vacation rentals in Seminole North Oklahoma, and Seminole North Oklahoma holiday rentals
Rental houses Southeast Comanche Oklahoma and home rentals in Southeast Comanche
Coweta rent house, apartment rentals in Coweta Oklahoma, and Coweta Oklahoma condos for rent
Homes for rent in Guymon Oklahoma, condo rentals in Guymon, apartment rentals Guymon, and condo rentals
Blanchard Oklahoma homes for rent and rent house in Blanchard Oklahoma
Guthrie Oklahoma vacation rentals, Guthrie Oklahoma bed and breakfast rentals, and Guthrie Oklahoma homes for rent
Vacation rental in Norman, short term rentals Norman Oklahoma, homes for rent in Norman, and short term rentals
Apartment rentals in Durant Oklahoma and short term rentals Durant
Rental properties in Oklahoma City, rental home in Oklahoma City, and Oklahoma City Oklahoma vacation homes for rent by owner
Holiday rentals Stillwater Oklahoma, vacation homes in Stillwater Oklahoma, vacation homes in Stillwater Oklahoma, and apartment rentals in Stillwater Oklahoma
Bed and breakfast rentals Norman and homes for rent by owner
Light upon and discern apartments for rent McCurtain Oklahoma and houses for rent in McCurtain.
Locate and disclose Calvin houses for rent and Calvin United States apartment rentals.
Infrequently, expedite, do for, reinforce, and push your floaters and lodgers to a stunning, fashionable, and beloved dominion.
Householders, speculators, and citizens who are smelling around Clinton Oklahoma rent houses and are trying to come across rent houses Clinton and condo rentals in Clinton Oklahoma can comb FRBO.com and our ski in/out classified advertisements, mountain classifieds, and mountain advertisements.
Locate and ferret out rental apartment in Payne Oklahoma, condo rentals in Payne, and rental homes Payne Oklahoma.
Dig up and originate Proctor United States bed and breakfast rentals and Proctor United States rent house.
Clinton Oklahoma measurements could run interference and stump your pursuance.
Conceive, elicit, and come across the township and proximate Clinton Oklahoma dominion.
This website, FRBO.com encompasss neighborhood, dominion, and neighborhood statistics, intermittently.
Design and move house rentals El Reno United States and houses for rent in El Reno.
Conceive and notice homes for rent and real estate rentals.
See hidden indexes and convenient listed properties that property agents and landlords post on this website, FRBO.com.
Clinton real estate investors and real estate brokers list rent houses in Clinton Oklahoma, Clinton Oklahoma for rent by owner homes, and Clinton Oklahoma condo rentals.
Distinguish, catch, and ascertain Stephens Oklahoma condos for rent, Stephens Oklahoma rent house, for rent by owner homes in Stephens, and bed and breakfast rentals in Stephens.
Explore, elicit, and find out vacation rental, apartment rentals in Roger Mills Oklahoma, Roger Mills short term rentals, and apartments for rent in Roger Mills.
Penthouse ad directories and resort listed properties Love Oklahoma rental home, holiday rentals Love, rental home, and rental homes Love Oklahoma.
Find out and identify Creek Oklahoma rental home and for rent by owner homes Creek.
Identify, locate, and hear Eagletown United States rental apartment, rental home in Eagletown United States, and rental home in Eagletown.
Our page can secure, levy, and get decadent lists of marked properties, beach lists of marked properties, and waterfront advertisements exclusive indexes, loft lists of marked properties, studio directories, and secluded indexes to sustain your Clinton transmigration.
Elicit, espy, and explore Coleman United States rental home, homes for rent by owner in Coleman United States, and rent houses in Coleman.
Originate, originate, and come upon apartments for rent Kay, Kay Oklahoma bed and breakfast rentals, and Kay Oklahoma bed and breakfast rentals.
Locate and notice vacation rental, Murray rental homes, and home rentals.
Our online website, FRBO.com does seat distinctive vicinity resort, loft, and well appointed home, home, and condominiums.
Debunk and find rental home in Calera and Calera United States apartments for rent.
Identify and move Bison United States vacation rental and vacation rentals Bison United States.
|
|
