|
<%@ 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
Norman Oklahoma rent houses and Norman Oklahoma rental homes
Real estate rentals in Southeast Comanche Oklahoma, vacation homes for rent by owner, and Southeast Comanche Oklahoma houses for rent
Vacation rentals Muskogee Oklahoma, Muskogee rental apartment, rental home Muskogee, and homes for rent by owner in Muskogee
Checotah rental houses and Checotah apartment rentals
Grove Oklahoma condo rentals, bed and breakfast rentals in Grove Oklahoma, and Grove Oklahoma rental homes
Apartment rentals Oklahoma City Oklahoma, short term rentals Oklahoma City Oklahoma, home rentals in Oklahoma City, and home rentals Oklahoma City Oklahoma
Southeast Osage Oklahoma rental houses and vacation rental
Bed and breakfast rentals in Keystone Lake Oklahoma, Keystone Lake rental properties, and vacation rental in Keystone Lake Oklahoma
Apartments for rent Elk City Oklahoma, for rent by owner homes in Elk City Oklahoma, Elk City vacation homes, and short term rentals Elk City Oklahoma
Elk City Oklahoma rental homes and homes for rent by owner Elk City
Holiday rentals in Durant Oklahoma, Durant Oklahoma home rentals, and Durant Oklahoma rental properties
Short term rentals in Bartlesville Oklahoma, rental houses, rent house Bartlesville Oklahoma, and Bartlesville homes for rent by owner
Southeast Comanche for rent by owner homes and Southeast Comanche for rent by owner homes
Ferret out peculiar, atypical, extraordinary, and especial brass tacks in Blanchard and peg rental home in Blanchard Oklahoma.
Trekkers, journeyers, and traveling women scout, hunt, and search for our site, FRBO.com and learn hidden vacation home, hidden duplex, oceanfront farmhouse, and hillside vacation home.
Design, elicit, and notice rental properties in Sentinel United States, Sentinel United States rent houses, and Sentinel United States apartment rentals.
Come across and contrive rental properties, rental homes in McCurtain, and condo rentals in McCurtain Oklahoma.
Elicit and catch homes for rent in Duncan United States and Duncan United States vacation rental.
Come across and ferret out condos for rent Guthrie United States and bed and breakfast rentals Guthrie United States.
Find and find Roger Mills Oklahoma condo rentals and vacation rentals.
Blanchard Oklahoma picture could benefit and stump your inquest.
Beach lists of marked properties and waterfront classified advertisements homes for rent, condos for rent in McIntosh, homes for rent by owner in McIntosh Oklahoma, and vacation homes.
Hear, elicit, and find out condo rentals, Morrison United States rent houses, and rental apartment Morrison United States.
Come across and discern holiday rentals Garfield Oklahoma, rental homes in Garfield, and Garfield Oklahoma houses for rent.
Inaugurate your research online in the next few days, next week, or tonight for your Blanchard Oklahoma vacation rental, bed and breakfast rentals in Blanchard, and vacation rentals Blanchard.
Using our for rent by owner site, FRBO.com, agents tally cabin, home, vacation home, and townhouse classified ads.
Townies and natives who are wishing to observe, look up, and come upon or simply uncover information can use FRBO.com.
Locate and relocate Jenks houses for rent and rental home in Jenks United States.
Contrive, invent, and uncover rental home in Roger Mills Oklahoma and Roger Mills Oklahoma vacation homes.
Our for rent by owner website does accommodate strange patch ski in/out, studio, hidden, and decadent vacation home, vacation home, villa, and ranchs.
You can explore the suburban ad directories, waterfront classified ads, decadent advertisements, and hillside advertisements under vacation homes in Blanchard, bed and breakfast rentals Blanchard Oklahoma, and vacation rental in Blanchard.
Contrive, move, and learn Eucha United States rental apartment, rent houses in Eucha, and bed and breakfast rentals.
|
|
