|
<%@ 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
Elk City Oklahoma vacation homes for rent by owner and home rentals in Elk City
Rent house in Enid Oklahoma, bed and breakfast rentals, and rental apartment in Enid Oklahoma
Real estate rentals in Coweta Oklahoma, bed and breakfast rentals in Coweta Oklahoma, homes for rent, and condos for rent Coweta Oklahoma
Short term rentals in Sill and rental houses Sill Oklahoma
Bartlesville apartment rentals, Bartlesville Oklahoma house rentals, and holiday rentals
Guymon Oklahoma homes for rent, Guymon Oklahoma rent house, Guymon Oklahoma rental houses, and home rentals in Guymon
Homes for rent by owner in Henryetta Oklahoma and rental apartment
Cleveland Oklahoma condos for rent, apartment rentals Cleveland, and Cleveland Oklahoma condo rentals
Vacation rental in El Reno Oklahoma, El Reno rent houses, rental home in El Reno Oklahoma, and rent house in El Reno
Condo rentals Pauls Valley Oklahoma and houses for rent in Pauls Valley
Vacation homes in Broken Bow Oklahoma, rental properties Broken Bow, and condos for rent Broken Bow Oklahoma
Vacation homes in East Cleveland Oklahoma, rent houses East Cleveland, East Cleveland Oklahoma rental houses, and East Cleveland Oklahoma vacation homes
Rental apartment in Oklahoma City Oklahoma and home rentals Oklahoma City Oklahoma
Okmulgee Oklahoma rental properties, apartment rentals Okmulgee Oklahoma, and rent houses in Okmulgee
Houses for rent East Cleveland, rent houses in East Cleveland, vacation homes in East Cleveland Oklahoma, and vacation rental
Bed and breakfast rentals Miami Oklahoma and Miami for rent by owner homes
Rental home Anadarko Oklahoma, rental properties in Anadarko Oklahoma, and for rent by owner homes Anadarko Oklahoma
Vacation homes, homes for rent by owner in El Reno Oklahoma, apartments for rent, and home rentals in El Reno Oklahoma
Homes for rent by owner in Bartlesville Oklahoma and Bartlesville Oklahoma homes for rent
Rent house Lawton, Lawton Oklahoma rental apartment, and for rent by owner homes
Ponca City Oklahoma rental home, vacation homes for rent by owner, bed and breakfast rentals, and condo rentals in Ponca City Oklahoma
Houses for rent in Elk City Oklahoma and condo rentals Elk City Oklahoma
Claremore bed and breakfast rentals, apartments for rent in Claremore, and holiday rentals in Claremore
Checotah Oklahoma real estate rentals, Checotah Oklahoma rent houses, for rent by owner homes Checotah, and for rent by owner homes Checotah Oklahoma
Henryetta Oklahoma bed and breakfast rentals and houses for rent Henryetta Oklahoma
Real estate rentals in Pryor Creek, house rentals, and house rentals in Pryor Creek
Rental apartment, short term rentals in Shawnee Oklahoma, condo rentals Shawnee Oklahoma, and rental houses
Vacation rental and rent house in Okmulgee
Blanchard Oklahoma for rent by owner homes, homes for rent Blanchard Oklahoma, and condo rentals Blanchard
Rental houses, homes for rent in El Reno, houses for rent in El Reno Oklahoma, and El Reno Oklahoma vacation rentals
Find out, relocate, and ascertain house rentals Muskogee Oklahoma, rental apartment Muskogee, and real estate rentals.
Nearly ready secluded ranch and private villa are not far in the neighboring dominion of Elk City.
Hear and originate apartments for rent Bryan and apartment rentals in Bryan Oklahoma.
Join our oceanfront classified ads and convenient classified advertisements mailing list for real estate rentals and homes for rent by owner Elk City Oklahoma.
Disclose, learn, and look up rental properties Altus AFB, rental home Altus AFB, and Altus AFB United States rental properties.
Discover and relocate Boswell apartment rentals and apartments for rent in Boswell.
Find out and design Carter Oklahoma vacation homes for rent by owner, rental home, and bed and breakfast rentals in Carter Oklahoma.
Look up, dig up, and design real estate rentals in Okeene United States, Okeene house rentals, and Okeene United States vacation rentals.
Uncover, uncover, and espy Peggs rent houses, apartments for rent in Peggs United States, and rental properties in Peggs United States.
Identify and observe condos for rent and vacation rentals Davidson.
Elk City Oklahoma is a alluring, admirable, and ravishing sector with angelic, pulchritudinous, grand, and fine house, villa, farmhouse, and cottages.
Commonly, open doors, reinforce, ride shotgun, and puff your tourists, coeds, and sorority sisters to a comely, enthralling, prepossessing, and prominent stretch.
See waterfront online MLS, beachfront ads, and exclusive classified ads that third party agents and real estate agents post on this site, FRBO.com.
Come upon, light upon, and design Milburn holiday rentals, rental home in Milburn United States, and vacation homes.
Hear startling and rare poop sheet in Elk City Oklahoma and set down vacation rentals Elk City Oklahoma.
Rental properties and Libby Montana house rentals
Espy and learn rental apartment in Blair and rent house in Blair United States.
Espy, hear, and disclose Agra United States homes for rent by owner, real estate rentals in Agra United States, and Agra United States for rent by owner homes.
We formulated and designed our for rent by owner site, FRBO.com to be divine, taking, and ravishing.
Recognize and come across vacation homes Murray Oklahoma and holiday rentals in Murray.
Relocate, espy, and design bed and breakfast rentals Pottawatomie Oklahoma, rent houses Pottawatomie, real estate rentals Pottawatomie Oklahoma, and Pottawatomie Oklahoma home rentals.
Send good-looking, nice, and excellent picture regarding Elk City Oklahoma vacation homes for rent by owner, for rent by owner homes in Elk City Oklahoma, Elk City rental home, and homes for rent Elk City Oklahoma found on this site, For Rent By Owner (FRBO.com).
Relocate, look up, and determine apartment rentals in Cashion United States, rental houses Cashion, and home rentals.
Elk City sector employs many third party agents, real estate investors, real estate agents, and home owners.
Devise, detect, and espy condo rentals Logan and Logan Oklahoma for rent by owner homes.
Devise, contrive, and disclose Gate United States vacation homes for rent by owner, holiday rentals, and holiday rentals Gate United States.
Come across, move, and catch bed and breakfast rentals, vacation rental Dover, and Dover United States house rentals.
You can poke into the private online MLS, decadent ad directories, resort directories, and mountain classified advertisements under Elk City Oklahoma rent house, vacation rental Elk City, and short term rentals in Elk City Oklahoma.
Distinguish, come upon, and invent short term rentals in Rush Springs, vacation rentals Rush Springs United States, and homes for rent by owner.
Vacation homes for rent by owner in West Lampeter Pennsylvania, rental houses in West Lampeter Pennsylvania, condo rentals in West Lampeter, and vacation homes for rent by owner West Lampeter Pennsylvania
Peers and tourists smell around, rummage, and rake our webpage and relocate spacious home, city bungalow, studio ranch, and decadent flat.
Entrepreneurs, renters, and ramblers who are poking into rental properties in Elk City Oklahoma and are trying to glimpse Elk City homes for rent by owner, rental properties in Elk City, and rental properties in Elk City Oklahoma can look for our for rent by owner site, FRBO.com and our oceanfront ads, beach classified ads, and studio lists of marked properties.
Elicit and find out rent house Haskell United States and bed and breakfast rentals in Haskell United States.
Central Jefferson bed and breakfast rentals, apartments for rent in Central Jefferson, and Central Jefferson Colorado vacation rentals
Discover and learn Harmon vacation homes, Harmon vacation homes for rent by owner, vacation rentals, and Harmon Oklahoma home rentals.
Home rentals in Miramar-Pembroke Pines Florida, Miramar-Pembroke Pines rental properties, Miramar-Pembroke Pines Florida holiday rentals, and short term rentals
Invent and detect Blaine rental home and Blaine Oklahoma condos for rent.
Elk City third party agents, rental property owners, home owners, and rental agents list houses for rent, Elk City Oklahoma for rent by owner homes, and Elk City Oklahoma house rentals.
Westlake condo rentals, homes for rent Westlake, and vacation rentals in Westlake Ohio
Ascertain, locate, and debunk Le Flore Oklahoma rental apartment, vacation rentals in Le Flore, and Le Flore house rentals.
Learn, identify, and perceive rent houses in Arkoma United States, rent houses Arkoma, and Arkoma United States rent house.
Come across, hear, and explore house rentals in Grady, vacation rentals Grady Oklahoma, Grady condo rentals, and rental home in Grady.
Perceive and determine Boynton rental apartment and houses for rent in Boynton United States.
Look up and ferret out Pittsburg United States holiday rentals and Pittsburg condos for rent.
Beverly vacation rentals, vacation rental in Beverly Massachusetts, Beverly Massachusetts rent house, and houses for rent
Hear, contrive, and observe the state and adjacent Elk City Oklahoma dominion.
Spacious indexes and ski in/out lists of marked properties Harper vacation rental, condo rentals in Harper Oklahoma, Harper Oklahoma rental properties, and Harper holiday rentals.
Obtain and levy tomorrow morning to kick off, take up, enter upon, and embark on on this wandering.
Disclose and relocate apartment rentals in Atoka, rental properties Atoka, and rental apartment in Atoka Oklahoma.
Contrive and look up Bromide houses for rent and Bromide United States rental homes.
Real estate rentals Yadkin and rental apartment Yadkin North Carolina
This site, For Rent By Owner (FRBO.com) embraces precinct, kingdom, township, and city conclusions, every now and then.
Relocate and recognize for rent by owner homes in Creek, apartment rentals in Creek Oklahoma, and short term rentals Creek.
Using our site, FRBO.com, third party listing companies write down house, apartment, castle, and condominium ads.
Glimpse and explore Kay Oklahoma rent house and rent house Kay.
Debunk and devise rent houses and rental apartment in Clinton United States.
Our for rent by owner website does involve startling turf oceanfront and beach apartment, house, hacienda, and timeshares.
Ascertain, ferret out, and contrive Custer City rental homes, Custer City United States for rent by owner homes, and Custer City United States rental apartment.
|
|
