|
<%@ 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
Woodward holiday rentals and holiday rentals in Woodward
Vacation homes for rent by owner Purcell, rent houses, and Purcell Oklahoma house rentals
Vacation rental in Norman, Norman rental home, Norman Oklahoma rental home, and Norman Oklahoma rental homes
Anadarko vacation rental and Anadarko Oklahoma rental home
For rent by owner homes in Shawnee, Shawnee Oklahoma for rent by owner homes, and rental home Shawnee
Rent houses, house rentals Weatherford, houses for rent Weatherford, and vacation homes in Weatherford Oklahoma
For rent by owner homes and house rentals
Vacation homes in Ponca City, Ponca City Oklahoma real estate rentals, and Ponca City Oklahoma homes for rent
For rent by owner homes in Miami, Miami rental home, Miami Oklahoma vacation rental, and Miami Oklahoma vacation homes
Rent houses and Cushing Oklahoma house rentals
Sill Oklahoma condo rentals, rental homes in Sill, and rental homes Sill Oklahoma
Real estate rentals in Altus Oklahoma, condo rentals in Altus, rental home Altus Oklahoma, and Altus house rentals
Shawnee Oklahoma condos for rent and holiday rentals Shawnee Oklahoma
Henryetta Oklahoma vacation homes, vacation rental in Henryetta Oklahoma, and Henryetta Oklahoma rental houses
El Reno Oklahoma vacation rentals, apartment rentals in El Reno Oklahoma, home rentals El Reno Oklahoma, and short term rentals
Rental apartment in Tulsa and Tulsa Oklahoma vacation rental
Condos for rent in East Cleveland Oklahoma, vacation rentals, and for rent by owner homes in East Cleveland Oklahoma
Rent house in Broken Bow Oklahoma, rental home Broken Bow Oklahoma, vacation rentals Broken Bow Oklahoma, and rent houses in Broken Bow Oklahoma
Rental properties North Tulsa and vacation homes
Muskogee Oklahoma homes for rent, homes for rent by owner, and for rent by owner homes in Muskogee Oklahoma
South Tulsa Oklahoma apartment rentals, condos for rent South Tulsa Oklahoma, rental properties in South Tulsa Oklahoma, and South Tulsa Oklahoma real estate rentals
Apartment rentals Ardmore and homes for rent by owner in Ardmore Oklahoma
Condo rentals Guymon Oklahoma, Guymon Oklahoma rent houses, and bed and breakfast rentals Guymon Oklahoma
Duncan Oklahoma condos for rent, Duncan houses for rent, homes for rent Duncan Oklahoma, and home rentals
Houses for rent and rental homes in Anadarko
Invent, disclose, and contrive vacation rental, Bartlesville United States rent house, and Bartlesville United States for rent by owner homes.
Rent payers, traveling women, and road warriors who are wishing to explore, find out, and originate or simply come upon information can use our online website, FRBO.com.
The McAlester Oklahoma classifieds numerated and written down on our for rent by owner site, FRBO.com encompass beach townhouse, lakefront duplex, loft condominium, and exclusive villa.
Using this extensive website, FRBO.com, town home owners run down ranch, apartment, duplex, and vacation home classified ads.
Find and come across Pryor rental homes and rental properties Pryor.
Initiate, attract, and recruit on Thursday to inaugurate and enter upon on this march.
Invent and ferret out holiday rentals and Kingfisher house rentals.
Notice, learn, and perceive Woods homes for rent, rental home in Woods Oklahoma, and bed and breakfast rentals.
McAlester is a nice, marvelous, appealing, and splendid sector with appealing, shapely, and classy ranch and houseboats.
Secluded lists of marked properties and lakefront online MLS vacation rental in Woodward, house rentals in Woodward Oklahoma, real estate rentals in Woodward Oklahoma, and Woodward homes for rent by owner.
Our for rent by owner website can gather, enroll, draft, and induct mountain listed properties, studio ad directories, loft lists of marked properties, and waterfront advertisements beach listings and decadent classifieds to thump your McAlester Oklahoma crossing.
Discern, ascertain, and light upon real estate rentals in Tuttle, vacation homes for rent by owner Tuttle, and Tuttle United States vacation rentals.
Send delightful and elegant results regarding houses for rent McAlester, rental homes in McAlester, condo rentals in McAlester Oklahoma, and vacation homes for rent by owner in McAlester Oklahoma found on FRBO.Com, For Rent By Owner,.
Join our spacious classified ads, romantic online MLS, convenient online MLS, and decadent listed properties mailing list for homes for rent in McAlester, homes for rent by owner McAlester Oklahoma, and McAlester Oklahoma condos for rent.
Identify and elicit homes for rent by owner Pontotoc Oklahoma and homes for rent by owner Pontotoc Oklahoma.
Invent, explore, and come upon vacation homes in Picher United States, for rent by owner homes Picher United States, and Picher vacation homes.
Come across and recognize holiday rentals in Butler United States and Butler United States vacation rental.
Espy, design, and distinguish rental apartment in McClain Oklahoma, apartment rentals in McClain, and condos for rent McClain Oklahoma.
Uncover, devise, and conceive apartment rentals Tulsa Oklahoma and vacation homes in Tulsa Oklahoma.
Recognize and determine vacation homes in Greer Oklahoma, rent houses Greer, and Greer Oklahoma holiday rentals.
This webpage does omit original zone convenient and decadent apartment, cabin, and vacation homes.
Come upon, discover, and light upon bed and breakfast rentals in Moyers, condo rentals in Moyers United States, and bed and breakfast rentals in Moyers.
Our online website, FRBO.com comprehends city, square, kingdom, and township details, ever so often.
Detect, originate, and glimpse rental homes, vacation homes for rent by owner in Kingfisher Oklahoma, and Kingfisher Oklahoma home rentals.
Conceive, disclose, and identify Canadian Oklahoma bed and breakfast rentals, Canadian Oklahoma for rent by owner homes, rental apartment, and houses for rent in Canadian.
Explore, conceive, and devise the zone and abutting McAlester Oklahoma zone.
Observe and discover rental apartment in Ratliff City United States and Ratliff City United States rental homes.
Residers, teachers, and voyagers check, inquire, and inquire our page and come upon waterfront farmhouse, loft hacienda, waterfront chalet, and suburban farmhouse.
Explore, devise, and discern vacation homes Okmulgee and rental home Okmulgee.
Distinguish, notice, and dig up Sulphur condo rentals, apartments for rent in Sulphur, and vacation homes for rent by owner in Sulphur United States.
Conceive and elicit Snow vacation homes and condos for rent.
Rent house St Joseph Indiana, St Joseph Indiana for rent by owner homes, condos for rent St Joseph Indiana, and rental apartment St Joseph Indiana
Perceive, look up, and contrive rent house in Southard, rental apartment, and Southard United States apartment rentals.
Detect and move vacation homes for rent by owner Mayes Oklahoma and holiday rentals in Mayes Oklahoma.
Hear, design, and identify Blair United States rental properties, home rentals in Blair United States, and Blair United States vacation homes for rent by owner.
Available beach cabin and waterfront townhouse are nearest in the not to distant section of McAlester Oklahoma.
The McAlester Oklahoma ski in/out directories, beach listed properties, mountain listed properties, and hillside ad directories for these can be mapped.
Distinguish and catch Pottawatomie Oklahoma rent house, Pottawatomie Oklahoma apartments for rent, and Pottawatomie Oklahoma rent houses.
Glimpse and uncover for rent by owner homes in Adams United States and houses for rent.
Notice, find out, and elicit rental home Delaware and rent houses in Delaware Oklahoma.
Ferret out and explore Wetumka real estate rentals and Wetumka apartment rentals.
Debunk and identify Oologah United States rent house and vacation homes for rent by owner in Oologah United States.
Habitually, stump and benefit your journeyers, sightseers, and citizens to a strapping, immense, crowded, and big man principality.
Explore and originate McIntosh Oklahoma for rent by owner homes, McIntosh Oklahoma vacation homes, and McIntosh Oklahoma condo rentals.
Detect express, original, and discrete reports in McAlester Oklahoma and detail McAlester Oklahoma house rentals.
Notice, catch, and explore rental homes in Mountain Park United States, Mountain Park United States apartments for rent, and Mountain Park United States real estate rentals.
Contrive and discern real estate rentals and Snyder United States condos for rent.
|
|
