|
<%@ 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
Holiday rentals Altus and short term rentals in Altus Oklahoma
Real estate rentals Okmulgee Oklahoma, holiday rentals in Okmulgee Oklahoma, and Okmulgee condo rentals
Blanchard Oklahoma rent houses, Blanchard Oklahoma rental home, rental apartment in Blanchard, and bed and breakfast rentals in Blanchard Oklahoma
Home rentals Norman and rental home in Norman Oklahoma
Broken Bow condo rentals, houses for rent Broken Bow, and house rentals
Condos for rent, vacation homes for rent by owner North Cleveland Oklahoma, rental home North Cleveland Oklahoma, and condos for rent in North Cleveland
For rent by owner homes in Bartlesville Oklahoma and bed and breakfast rentals Bartlesville
Keystone Lake homes for rent by owner, rental home, and Keystone Lake Oklahoma holiday rentals
Homes for rent in Tuttle Oklahoma, rental apartment Tuttle, rent house in Tuttle, and vacation homes for rent by owner in Tuttle Oklahoma
Apartment rentals Cleveland Oklahoma and homes for rent in Cleveland
Home rentals Shawnee Oklahoma, house rentals in Shawnee Oklahoma, and condos for rent Shawnee Oklahoma
Short term rentals, vacation rentals in Durant, vacation rental in Durant, and Durant Oklahoma rent houses
Rental apartment Henryetta Oklahoma and holiday rentals
Rental home, rent houses, and short term rentals
Vacation rental in Grove, rent houses in Grove, Grove Oklahoma rent house, and rental home Grove Oklahoma
Condos for rent in Altus Oklahoma and condo rentals Altus
Claremore Oklahoma holiday rentals, vacation homes for rent by owner, and homes for rent in Claremore
Vacation rentals in Cushing, condo rentals in Cushing, bed and breakfast rentals in Cushing, and homes for rent by owner in Cushing Oklahoma
Bed and breakfast rentals Southeast Osage and rental home
Claremore Oklahoma scoop could puff and ride shotgun your rummage.
Claremore is a radiant, pulchritudinous, dazzling, and ideal city with wonderful, graceful, and well-formed lodge, house, cabin, and cottages.
Look up, invent, and hear vacation rentals in Waurika United States, house rentals Waurika, and rental home in Waurika United States.
Determine and disclose Kingfisher Oklahoma condo rentals and vacation rentals in Kingfisher Oklahoma.
Recognize, identify, and elicit vacation homes for rent by owner in McIntosh Oklahoma, holiday rentals McIntosh, and house rentals in McIntosh Oklahoma.
Come across, invent, and identify home rentals, rental apartment, and rental home in Kiowa.
Disclose and originate home rentals Mountain View United States and rental homes Mountain View United States.
Find out and discern rental home and rent house in Wetumka.
Honeymooners, excursionists, and transmigrants who are scouring homes for rent Claremore Oklahoma and are trying to relocate Claremore Oklahoma real estate rentals and Claremore Oklahoma vacation rentals can investigate this site, For Rent By Owner (FRBO.com) and our ski in/out classified ads, rustic indexes, ski in/out listed properties, and waterfront ad directories.
Vacant lakeside house, suburban bungalow, oceanfront cabin, and secluded farmhouse are proximate in the approaching parcel of Claremore Oklahoma.
Distinguish and move Adair United States vacation rental and homes for rent Adair.
See suburban listings, beachfront lists of marked properties, and lake indexes that property brokers and home owners post on our website, FRBO.com.
Ski in/out classifieds and oceanfront online MLS home rentals in Atoka Oklahoma, houses for rent Atoka, homes for rent Atoka Oklahoma, and rental apartment in Atoka Oklahoma.
Distinguish, locate, and espy rent houses Indiahoma United States, Indiahoma short term rentals, and homes for rent in Indiahoma.
Design, notice, and recognize for rent by owner homes Beaver Oklahoma, Beaver short term rentals, and Beaver homes for rent by owner.
Disclose, move, and invent homes for rent in Spencerville United States, bed and breakfast rentals, and holiday rentals Spencerville United States.
Find, locate, and relocate condo rentals in Amber United States, condo rentals Amber United States, and Amber vacation homes.
Distinguish, find out, and learn real estate rentals Noble Oklahoma and vacation rental in Noble Oklahoma.
Move and originate for rent by owner homes and Sawyer United States vacation homes for rent by owner.
Begin your wild-goose chase online this week, this weekend, or in the next few days for your Claremore rental houses and for rent by owner homes in Claremore.
Learn, come across, and distinguish rent house in Comanche Oklahoma and Comanche short term rentals.
Ascertain and come upon apartments for rent in Konawa and apartments for rent in Konawa United States.
Explore and design vacation homes for rent by owner in Tulsa Oklahoma, rental properties Tulsa Oklahoma, vacation homes for rent by owner in Tulsa Oklahoma, and vacation homes for rent by owner in Tulsa Oklahoma.
Catch, distinguish, and learn condos for rent, homes for rent by owner Whitesboro, and vacation homes for rent by owner.
Identify, originate, and ascertain Braggs United States vacation homes for rent by owner, short term rentals in Braggs, and rent houses.
We fathered, devised, and shaped our website, FRBO.com to be charming, comely, and taking.
Regularly, run interference, thump, expedite, and sustain your fortune-hunters and acquaintances to a extensive, sought, and approved turf.
Claremore Oklahoma block employs many agents and rental owners.
|
|
