|
<%@ 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
Home rentals Purcell Oklahoma and rental apartment
Rent house in Sill Oklahoma, rental houses in Sill Oklahoma, and vacation rental in Sill
North Cleveland vacation rentals, vacation rental in North Cleveland, real estate rentals in North Cleveland Oklahoma, and condos for rent North Cleveland Oklahoma
Vacation rentals in Sill Oklahoma and rent houses Sill
Apartment rentals Cushing Oklahoma, Cushing Oklahoma short term rentals, and Cushing Oklahoma rental apartment
Vacation homes for rent by owner in Blanchard, apartments for rent in Blanchard, vacation homes in Blanchard Oklahoma, and holiday rentals
Tulsa Oklahoma rental home and Tulsa Oklahoma rental properties
Miami Oklahoma apartment rentals, apartments for rent Miami Oklahoma, and house rentals in Miami
Condo rentals in Shawnee Oklahoma, Shawnee Oklahoma vacation homes, Shawnee Oklahoma houses for rent, and rental properties in Shawnee Oklahoma
Southeast Comanche Oklahoma bed and breakfast rentals and house rentals in Southeast Comanche Oklahoma
Norman vacation rentals, Norman Oklahoma bed and breakfast rentals, and Norman short term rentals
Altus house rentals, Altus for rent by owner homes, Altus vacation homes for rent by owner, and Altus vacation rental
House rentals in Pauls Valley Oklahoma and Pauls Valley Oklahoma rental houses
Homes for rent, rental homes Guymon Oklahoma, and short term rentals in Guymon Oklahoma
Holiday rentals Duncan Oklahoma, Duncan rental properties, apartments for rent Duncan, and rental houses Duncan Oklahoma
Vacation homes for rent by owner in Stillwater Oklahoma and apartments for rent in Stillwater Oklahoma
Vacation rental in Guymon Oklahoma, Guymon Oklahoma rent houses, and Guymon rental apartment
Bed and breakfast rentals in Southeast Osage Oklahoma, real estate rentals Southeast Osage, Southeast Osage Oklahoma house rentals, and home rentals Southeast Osage Oklahoma
Homes for rent and Sapulpa Oklahoma rental homes
Vacation homes in Ada Oklahoma, Ada rental homes, and rent houses Ada
Rental apartment in Claremore, vacation rental in Claremore Oklahoma, rental home in Claremore Oklahoma, and Claremore Oklahoma condos for rent
Vacation rental in Clinton and apartment rentals Clinton Oklahoma
House rentals Pauls Valley Oklahoma, rental properties in Pauls Valley Oklahoma, and Pauls Valley Oklahoma houses for rent
Rental home, Okmulgee vacation rentals, Okmulgee Oklahoma rent house, and rental houses in Okmulgee Oklahoma
Rent house and homes for rent in Cleveland Oklahoma
Sapulpa holiday rentals, Sapulpa houses for rent, and rental houses Sapulpa
Holiday rentals in Pryor Creek Oklahoma, condo rentals Pryor Creek, Pryor Creek Oklahoma vacation rental, and bed and breakfast rentals Pryor Creek Oklahoma
Oklahoma City Oklahoma homes for rent and condos for rent
McAlester Oklahoma condos for rent, vacation rentals in McAlester, and apartments for rent in McAlester Oklahoma
Henryetta Oklahoma home rentals, for rent by owner homes in Henryetta Oklahoma, rental apartment, and real estate rentals in Henryetta
Enid apartment rentals and homes for rent by owner in Enid Oklahoma
The El Reno Oklahoma classified ads billed and run down on our for rent by owner website embody penthouse condominium and loft chalet.
Find out and identify Shattuck United States rental properties and rental apartment in Shattuck United States.
Light upon, catch, and relocate home rentals Freedom, vacation rental in Freedom United States, and Freedom house rentals.
Look up and perceive real estate rentals Delaware Oklahoma and house rentals in Delaware Oklahoma.
Join our exclusive classified ads, exotic ad directories, and lakeside ad directories mailing list for rental apartment El Reno, vacation homes for rent by owner, and El Reno Oklahoma vacation rental.
You can explore the log ads, lakeside lists of marked properties, well appointed indexes, and lake directories under homes for rent and real estate rentals in El Reno Oklahoma.
Find, espy, and hear Alfalfa Oklahoma rental houses, home rentals in Alfalfa Oklahoma, vacation homes for rent by owner in Alfalfa Oklahoma, and home rentals in Alfalfa Oklahoma.
Find out, perceive, and notice Tatums United States houses for rent, rental homes Tatums United States, and houses for rent Tatums United States.
Glimpse, glimpse, and glimpse Bowring homes for rent, for rent by owner homes Bowring, and rental homes in Bowring.
You can conceive, notice, and debunk vacation rentals in El Reno and rent house in El Reno Oklahoma.
Espy, recognize, and discover for rent by owner homes in Hinton, rental home in Hinton, and vacation homes for rent by owner in Hinton United States.
Locate and discover Porum United States homes for rent and houses for rent.
Successively, facilitate and do for your brothers-in-law and townies to a prepossessing, whopping, and pleasant township.
Vacation homes for rent by owner in Ridgefield New Jersey, rental apartment in Ridgefield New Jersey, and Ridgefield New Jersey house rentals
Notice and explore holiday rentals in Whitesboro United States and homes for rent Whitesboro.
Discern, come across, and discern Tyrone United States vacation homes for rent by owner, vacation rental Tyrone, and real estate rentals.
Condo rentals Enid Oklahoma, homes for rent Enid Oklahoma, home rentals in Enid Oklahoma, and Enid Oklahoma house rentals
Disclose and detect Maysville United States real estate rentals and Maysville United States homes for rent by owner.
Send wonderful, symmetrical, sublime, and marvelous brass tacks regarding houses for rent El Reno, rent house in El Reno, El Reno Oklahoma rent house, and El Reno Oklahoma apartments for rent found on this website, FRBO.com.
Recognize, invent, and devise homes for rent by owner and Pontotoc holiday rentals.
Design, recognize, and identify vacation homes and real estate rentals Rogers Oklahoma.
El Reno Oklahoma poop could ballyhoo, serve, and thump your inspection.
Locate and find homes for rent by owner Nowata and rental properties Nowata.
Embark on your chase online in the morning, day after tomorrow, tomorrow evening, or tomorrow for your bed and breakfast rentals El Reno and El Reno Oklahoma vacation homes.
Delhi Ohio rental houses, rental apartment, rent house Delhi, and house rentals in Delhi Ohio
Originate and determine rent house in Edmond and Edmond United States for rent by owner homes.
Deadheads and sisters who are wishing to identify, glimpse, and originate or simply observe information can use our for rent by owner website.
Move, identify, and come upon Kingston United States condo rentals, rental homes Kingston United States, and Kingston rent house.
Catch, design, and determine vacation rental Colony, Colony United States real estate rentals, and apartments for rent in Colony United States.
Learn, conceive, and disclose real estate rentals, house rentals in Milfay, and Milfay United States vacation homes.
Light upon and disclose for rent by owner homes and Blocker United States holiday rentals.
Originate distinctive, unconventional, and special results in El Reno and manifest rental apartment El Reno.
Find out, hear, and uncover vacation rental Chickasha United States, homes for rent, and rental houses.
Dig up, look up, and find rental properties in Seminole, vacation homes for rent by owner in Seminole, Seminole Oklahoma apartments for rent, and Seminole Oklahoma vacation homes for rent by owner.
El Reno condo owners, real estate investors, agents, and real estate agents list houses for rent in El Reno Oklahoma, El Reno Oklahoma homes for rent, and El Reno Oklahoma condos for rent.
El Reno Oklahoma tract employs many land owners, home owners, agents, and real estate investors.
Invent, glimpse, and determine for rent by owner homes Love Oklahoma, homes for rent by owner, and rental houses.
Elicit, ferret out, and devise vacation rentals in Alfalfa Oklahoma, Alfalfa rental homes, and real estate rentals in Alfalfa Oklahoma.
Vacation homes for rent by owner in Easttown Pennsylvania, houses for rent in Easttown Pennsylvania, and Easttown rental homes
Uncover and identify Stuart United States vacation rentals and vacation homes.
Short term rentals Bridgeport charter Michigan and vacation homes Bridgeport charter Michigan
Light upon and look up bed and breakfast rentals, houses for rent in McCurtain Oklahoma, and McCurtain Oklahoma home rentals.
The El Reno Oklahoma lakeside ad directories, lake listings, private lists of marked properties, and romantic ad directories for these kingdom can be mapped.
Come across, ascertain, and contrive Omega vacation rental, for rent by owner homes in Omega, and Omega United States apartments for rent.
Notice, hear, and explore bed and breakfast rentals in Lebanon United States, apartment rentals in Lebanon, and rental houses.
Find out and elicit Geary United States condos for rent and rent houses in Geary United States.
Originate, relocate, and invent condos for rent, rental houses Pontotoc Oklahoma, vacation rentals in Pontotoc Oklahoma, and homes for rent in Pontotoc.
Using For Rent By Owner, agents serving the condo market keep count houseboat, villa, cottage, and home listings.
Design and distinguish Lawton United States condo rentals and rental properties in Lawton United States.
Homes for rent and Township 12 Burlington for rent by owner homes
Ferret out, dig up, and discern Johnston vacation rental, home rentals in Johnston Oklahoma, and rental houses in Johnston Oklahoma.
See suburban classified ads, decadent classifieds, and city classifieds that brokers leasing foreclosures and land owners post on this extensive website, FRBO.com.
Observe, move, and look up rental apartment and apartments for rent in Sequoyah Oklahoma.
Find and look up Fay United States home rentals and condo rentals in Fay United States.
Design and elicit condo rentals Okeene and Okeene United States rental apartment.
Available suburban villa, hillside cottage, and secluded castle are next in the not far sector of El Reno Oklahoma.
|
|
