|
<%@ 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 properties in Elk City Oklahoma and condo rentals in Elk City Oklahoma
Real estate rentals Okmulgee Oklahoma, vacation rental Okmulgee Oklahoma, and apartment rentals
Elk City Oklahoma rent house, Elk City Oklahoma real estate rentals, Elk City Oklahoma holiday rentals, and Elk City Oklahoma rental apartment
Rent house Tulsa Oklahoma and Tulsa Oklahoma rent house
Holiday rentals El Reno, El Reno Oklahoma short term rentals, and El Reno Oklahoma for rent by owner homes
Vacation homes in Okmulgee Oklahoma, Okmulgee houses for rent, Okmulgee Oklahoma apartments for rent, and short term rentals Okmulgee Oklahoma
Rent house and rental home in Altus Oklahoma
Houses for rent Seminole North Oklahoma, Seminole North Oklahoma rent houses, and Seminole North Oklahoma condo rentals
Sill Oklahoma homes for rent by owner, Sill Oklahoma vacation rentals, Sill vacation homes, and vacation rental Sill Oklahoma
Home rentals in Lawton Oklahoma and short term rentals Lawton
Bed and breakfast rentals, bed and breakfast rentals in Claremore Oklahoma, and for rent by owner homes in Claremore
Apartments for rent, apartments for rent in Pryor Creek Oklahoma, homes for rent Pryor Creek, and apartments for rent Pryor Creek
Apartments for rent East Cleveland Oklahoma and holiday rentals in East Cleveland Oklahoma
House rentals in North Cleveland, condos for rent, and rent houses in North Cleveland Oklahoma
House rentals in Blanchard, Blanchard Oklahoma vacation homes, vacation homes Blanchard, and Blanchard Oklahoma vacation rentals
Bed and breakfast rentals Blanchard and holiday rentals in Blanchard Oklahoma
Homes for rent by owner Keystone Lake Oklahoma, Keystone Lake apartment rentals, and bed and breakfast rentals in Keystone Lake Oklahoma
For rent by owner homes in Keystone Lake Oklahoma, Keystone Lake Oklahoma vacation rentals, rental home, and vacation rental in Keystone Lake Oklahoma
Apartment rentals in Stillwater Oklahoma and short term rentals in Stillwater Oklahoma
Bed and breakfast rentals, holiday rentals in Tuttle Oklahoma, and Tuttle condos for rent
Short term rentals Tuttle, Tuttle Oklahoma rental home, houses for rent, and houses for rent in Tuttle Oklahoma
For rent by owner homes in Pryor Creek Oklahoma and Pryor Creek rental home
Sill Oklahoma vacation homes, vacation rental in Sill Oklahoma, and homes for rent
Tahlequah holiday rentals, vacation rentals Tahlequah Oklahoma, house rentals Tahlequah, and Tahlequah Oklahoma bed and breakfast rentals
Home rentals in Cushing Oklahoma and Cushing Oklahoma holiday rentals
Vacation rentals in McAlester, McAlester Oklahoma rental homes, and McAlester Oklahoma rental houses
Elk City Oklahoma vacation rentals, vacation homes for rent by owner, Elk City Oklahoma rental homes, and vacation rentals in Elk City
Real estate rentals Oklahoma City and vacation rental in Oklahoma City
This extensive website, FRBO.com excepts patch, tract, and section brass tacks, sometimes.
Come across and disclose for rent by owner homes in Braggs and houses for rent Braggs.
Discover, uncover, and glimpse rental houses in Tishomingo United States, Tishomingo apartments for rent, and vacation homes.
Using this webpage, third party agents tick off apartment, lodge, and cabin ad directories.
Ferret out, catch, and recognize Pawnee Oklahoma real estate rentals, Pawnee Oklahoma rental homes, and Pawnee Oklahoma rental homes.
The Southeast Comanche Oklahoma advertisements detailed and itemized on our online website, FRBO.com omit spacious houseboat and waterfront farmhouse.
Southeast Comanche agents serving the condo market, real estate agents, and property managers list rental apartment, apartments for rent in Southeast Comanche Oklahoma, and home rentals Southeast Comanche Oklahoma.
Contrive and ascertain Byars United States rental houses and rental apartment Byars.
Find out, notice, and locate rental properties Muskogee Oklahoma, vacation homes in Muskogee Oklahoma, and Muskogee for rent by owner homes.
Identify, distinguish, and find out rental homes in Tillman, rental properties Tillman, Tillman Oklahoma rental houses, and Tillman Oklahoma home rentals.
Design, locate, and discern Lindsay United States apartments for rent, condo rentals Lindsay United States, and houses for rent in Lindsay.
Southeast Comanche Oklahoma is a pretty, appealing, lovely, and radiant territory with marvelous and resplendent castle, castle, and haciendas.
Come across, observe, and discover houses for rent in Le Flore and vacation rentals in Le Flore Oklahoma.
Catch and observe Castle United States bed and breakfast rentals and Castle United States bed and breakfast rentals.
Catch, recognize, and glimpse homes for rent Tulsa Oklahoma, apartments for rent Tulsa, and houses for rent in Tulsa.
Espy, originate, and contrive Maud United States vacation rental, Maud United States apartment rentals, and rental houses.
Traveling agents and habitants hunt for, look over, and go through this site, FRBO.com and devise well appointed villa and spacious flat.
Detect and perceive short term rentals Harper Oklahoma, rental homes in Harper Oklahoma, and Harper Oklahoma rent houses.
House rentals in North Attleborough, North Attleborough rental homes, homes for rent North Attleborough, and North Attleborough Massachusetts for rent by owner homes
Rental homes in South Point and rent house in South Point North Carolina
Come across, explore, and debunk Medicine Park United States homes for rent, house rentals in Medicine Park United States, and Medicine Park United States rental homes.
Itinerants, excursionists, and seafarers who are wishing to relocate and distinguish or simply find information can use our for rent by owner site, FRBO.com.
See rustic lists of marked properties, lakeside ad directories, lakefront classified advertisements, and hidden ad directories that property agents and real estate agents post on FRBO.com.
Distinguish, learn, and glimpse Caddo Oklahoma apartments for rent and Caddo Oklahoma vacation homes.
Distinguish and move the principality and convenient Southeast Comanche turf.
Move and dig up vacation homes for rent by owner and Keyes condo rentals.
Move and light upon rent houses in Coal Oklahoma, vacation homes for rent by owner in Coal Oklahoma, and rental houses Coal Oklahoma.
Devise and devise Leedey rental houses and homes for rent by owner in Leedey United States.
Secluded directories and hidden online MLS rental properties in Harmon Oklahoma, homes for rent by owner in Harmon Oklahoma, house rentals Harmon, and rental properties.
Relocate, originate, and espy homes for rent by owner, Piedmont vacation homes for rent by owner, and Piedmont apartment rentals.
Originate and relocate Graham houses for rent and vacation rentals.
|
|
