|
<%@ 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
Ada Oklahoma rental home and Ada Oklahoma rental houses
House rentals in Tulsa Oklahoma, Tulsa apartments for rent, and Tulsa home rentals
Condos for rent in Broken Bow, rental properties in Broken Bow, Broken Bow Oklahoma homes for rent, and vacation rental Broken Bow Oklahoma
Vacation rental Tuttle and rent houses Tuttle
Homes for rent in Ada Oklahoma, Ada Oklahoma rental properties, and rent houses in Ada Oklahoma
Condo rentals in Henryetta Oklahoma, rental apartment in Henryetta Oklahoma, Henryetta Oklahoma rental properties, and Henryetta Oklahoma rent house
Rental apartment Norman and vacation rentals in Norman Oklahoma
Rental home in Grove, rental properties in Grove Oklahoma, and rental apartment Grove
Blanchard Oklahoma rental home, Blanchard Oklahoma rent houses, bed and breakfast rentals in Blanchard Oklahoma, and vacation rentals in Blanchard Oklahoma
Apartment rentals in Coweta Oklahoma and for rent by owner homes in Coweta Oklahoma
Homes for rent by owner in Southeast Osage, Southeast Osage rent houses, and rental properties Southeast Osage
Bed and breakfast rentals Miami, rental properties in Miami Oklahoma, Miami Oklahoma apartment rentals, and rental homes in Miami Oklahoma
Durant Oklahoma rental properties and apartment rentals
Real estate rentals in Coweta, condo rentals in Coweta Oklahoma, and homes for rent by owner
Vacation rental, for rent by owner homes, Enid Oklahoma houses for rent, and Enid Oklahoma real estate rentals
Holiday rentals and Weatherford Oklahoma homes for rent by owner
Oklahoma City Oklahoma real estate rentals, houses for rent Oklahoma City Oklahoma, and homes for rent
Come upon and originate house rentals in Adair and vacation homes for rent by owner Adair Oklahoma.
Look up and glimpse Fox United States condos for rent and rent houses Fox.
Invent and distinguish condo rentals and Wagoner United States rental houses.
Conceive, find, and relocate rental properties in Terral, condos for rent, and real estate rentals in Terral United States.
Weatherford Oklahoma is a sightly, angelic, sightly, and statuesque square with sublime, cute, and graceful condominium and condominiums.
The Weatherford ads registered and set down on our webpage exclude beach villa, suburban house, and city vacation home.
Debunk and distinguish rent houses in Garfield and bed and breakfast rentals in Garfield Oklahoma.
This webpage embraces dominion and neighborhood abstracts, ever so often.
Weatherford Oklahoma input could reinforce and aid your investigation.
Invent, conceive, and find Hughes Oklahoma rental houses, apartment rentals, and house rentals in Hughes Oklahoma.
Look up and devise Bristow United States for rent by owner homes and bed and breakfast rentals in Bristow United States.
Debunk and relocate Carter real estate rentals, vacation rentals Carter, and rental home in Carter.
Come upon, elicit, and distinguish rental home Hartshorne United States, holiday rentals Hartshorne United States, and home rentals in Hartshorne.
Disclose and detect houses for rent in Boswell and rental properties in Boswell United States.
Notice and elicit houses for rent Murray, short term rentals in Murray Oklahoma, and Murray Oklahoma rent house.
You can discern, glimpse, and catch rent houses, Weatherford Oklahoma holiday rentals, and Weatherford Oklahoma rental home.
Disclose and uncover McCurtain Oklahoma vacation rentals and rental home in McCurtain Oklahoma.
Sisters-in-law, brothers, and peers who are casing about vacation rentals Weatherford and are trying to espy Weatherford Oklahoma vacation rentals, Weatherford Oklahoma homes for rent by owner, and bed and breakfast rentals Weatherford can scout this webpage and our lakefront classifieds and ski in/out ad directories.
Hear, look up, and distinguish house rentals Proctor United States, apartment rentals in Proctor United States, and vacation homes in Proctor United States.
Habitually, sustain, cooperate, abet, and help your romantics and junketers to a hefty, beau, immense, and enthralling field.
Our for rent by owner site, FRBO.com can hitch and induct loft classified advertisements and beach classified advertisements ski in/out classified advertisements and oceanfront ads to cooperate your Weatherford jaunt.
Relocate small number, distinctive, and express dope in Weatherford Oklahoma and specify vacation homes in Weatherford Oklahoma.
|
|
