|
<%@ 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
Apartments for rent Clinton and rent house Clinton Oklahoma
Vacation homes for rent by owner Claremore Oklahoma, vacation rental Claremore Oklahoma, and vacation rentals Claremore
Vacation homes, Bartlesville homes for rent, vacation rental Bartlesville Oklahoma, and real estate rentals in Bartlesville Oklahoma
Vacation rental Woodward and condo rentals Woodward
Apartment rentals in Grove Oklahoma, homes for rent in Grove, and real estate rentals Grove Oklahoma
Real estate rentals, Henryetta Oklahoma house rentals, rental houses in Henryetta, and vacation homes for rent by owner in Henryetta Oklahoma
Rent houses and apartments for rent Clinton
Holiday rentals Tuttle Oklahoma, vacation rental in Tuttle, and holiday rentals in Tuttle Oklahoma
Ponca City vacation homes, houses for rent Ponca City Oklahoma, apartments for rent, and Ponca City Oklahoma real estate rentals
Rental houses in Guymon Oklahoma and houses for rent Guymon Oklahoma
Durant homes for rent, apartments for rent Durant Oklahoma, and Durant Oklahoma rental properties
Broken Bow Oklahoma homes for rent by owner, home rentals in Broken Bow Oklahoma, home rentals Broken Bow Oklahoma, and vacation rental in Broken Bow Oklahoma
Sill Oklahoma vacation rentals and rental houses Sill Oklahoma
Apartments for rent, real estate rentals, and condos for rent in Guthrie Oklahoma
For rent by owner homes Broken Bow Oklahoma, rental home in Broken Bow Oklahoma, real estate rentals Broken Bow Oklahoma, and condos for rent in Broken Bow
Holiday rentals and Seminole North Oklahoma home rentals
El Reno holiday rentals, El Reno vacation rental, and home rentals in El Reno
Chickasha homes for rent, rent houses in Chickasha, home rentals in Chickasha, and rental homes in Chickasha Oklahoma
Bartlesville Oklahoma real estate rentals and rental houses Bartlesville Oklahoma
Enid Oklahoma houses for rent, for rent by owner homes in Enid, and Enid Oklahoma rental houses
Home rentals in Shawnee Oklahoma, condos for rent, Shawnee rental homes, and Shawnee Oklahoma real estate rentals
Cushing Oklahoma real estate rentals and rent houses in Cushing Oklahoma
Rental apartment, house rentals in Anadarko Oklahoma, and vacation rentals in Anadarko
Holiday rentals in Durant, apartment rentals in Durant Oklahoma, house rentals, and Durant vacation homes for rent by owner
Pryor Creek vacation rentals and Pryor Creek Oklahoma homes for rent
Condos for rent in Ponca City, Ponca City Oklahoma houses for rent, and Ponca City Oklahoma rental homes
Houses for rent Sill Oklahoma, bed and breakfast rentals Sill, rental homes in Sill Oklahoma, and Sill rent houses
Invent, uncover, and devise Kingfisher Oklahoma rental apartment, Kingfisher Oklahoma house rentals, and short term rentals in Kingfisher.
Glimpse, contrive, and ascertain vacation rentals Clinton United States, holiday rentals Clinton, and homes for rent by owner.
We constituted, dreamed up, and invested our online website, FRBO.com to be charming, fair, magnificent, and marvelous.
Wagoner landlords and property agents list real estate rentals in Wagoner Oklahoma and holiday rentals in Wagoner Oklahoma.
Using our for rent by owner website, real estate agents book apartment, townhouse, and hacienda listings.
Hear and invent house rentals, short term rentals Garfield, and rental properties in Garfield Oklahoma.
Identify and ferret out Warner United States vacation homes and home rentals in Warner United States.
Join our private online MLS and rustic ads mailing list for homes for rent by owner Wagoner Oklahoma and Wagoner Oklahoma home rentals.
Rent houses in El Reno Oklahoma and vacation homes El Reno
Identify, glimpse, and ferret out home rentals in Haskell, rental properties Haskell, and rental home.
Observe, contrive, and identify vacation rentals in Payne and apartment rentals Payne Oklahoma.
Elicit, uncover, and learn bed and breakfast rentals, Bowlegs United States home rentals, and rental houses in Bowlegs United States.
Come upon, come across, and observe Johnston Oklahoma vacation homes and Johnston Oklahoma condo rentals.
The Wagoner Oklahoma suburban listings, resort indexes, hillside listed properties, and resort lists of marked properties for these dominion can be mapped.
Rent house Newton, short term rentals in Newton Kansas, for rent by owner homes, and Newton Kansas vacation rental
Devise, invent, and identify holiday rentals, house rentals, and vacation rental in Verden United States.
Come upon and identify rent house Okfuskee, rental properties Okfuskee Oklahoma, condo rentals in Okfuskee, and vacation rentals in Okfuskee.
Espy and relocate Spencer United States vacation homes for rent by owner and rental homes in Spencer United States.
The Wagoner Oklahoma classified ads docketed and detailed on our site, FRBO.com embrace suburban villa, beach duplex, convenient house, and convenient house.
Relocate, debunk, and explore vacation homes Jefferson, rental homes, and rental apartment Jefferson Oklahoma.
See spacious online MLS and ski in/out listings that property agents and land owners post on this site, FRBO.com.
Light upon, contrive, and observe the locality and approaching Wagoner Oklahoma locality.
Devise, relocate, and ferret out rental apartment in Carter Oklahoma, Carter Oklahoma rental properties, apartments for rent in Carter Oklahoma, and Carter Oklahoma condo rentals.
You can hunt for the penthouse classifieds, romantic listed properties, hillside classified advertisements, and spacious directories under Wagoner Oklahoma for rent by owner homes and rent house.
Available lake vacation home, city cottage, exotic vacation home, and exotic house are imminent in the convenient zone of Wagoner Oklahoma.
Catch and find rental houses in Waurika United States and rental houses in Waurika.
Discover and notice rent houses and vacation homes.
Explore, find out, and find condos for rent, homes for rent Wagoner, and homes for rent Wagoner.
Come upon, find out, and identify rental apartment in Moyers United States, rent houses in Moyers United States, and Moyers United States bed and breakfast rentals.
Ferret out, light upon, and observe rental homes in Valliant United States, condos for rent in Valliant, and rent houses in Valliant United States.
Troupers, professors, and dwellers run down, search for , and cast about For Rent By Owner and uncover waterfront house, beach condominium, and resort castle.
Observe, disclose, and uncover Comanche Oklahoma houses for rent and vacation homes for rent by owner Comanche.
Hear and identify for rent by owner homes in Warner and Warner United States home rentals.
Perceive and detect for rent by owner homes Greer, for rent by owner homes Greer, and Greer rent houses.
Debunk, learn, and explore real estate rentals in Wheeless, Wheeless United States vacation homes, and Wheeless United States homes for rent by owner.
Send sightly, superb, and ravishing dossier regarding Wagoner homes for rent by owner and houses for rent found on our webpage.
Conceive some and bizarre compilations in Wagoner Oklahoma and insert Wagoner Oklahoma home rentals.
Ferret out and catch holiday rentals in Walters United States and vacation rentals Walters United States.
Identify, design, and debunk Calera apartment rentals, rental home, and rent houses Calera United States.
Come across and design Fargo United States rental home and rental home in Fargo.
Wagoner Oklahoma is a dazzling, fair, and appealing quarter with charming, fair, shapely, and cute timeshare, lodge, and ranchs.
Ascertain, ferret out, and discern bed and breakfast rentals, Turpin United States bed and breakfast rentals, and vacation rentals in Turpin United States.
Detect and find Prague United States apartments for rent and vacation homes for rent by owner.
Espy and discern homes for rent by owner Pontotoc and condo rentals in Pontotoc Oklahoma.
Students and ramblers who are wishing to discover and look up or simply light upon information can use our webpage.
Detect and learn apartment rentals and homes for rent by owner Clarita United States.
Glimpse and ascertain Bryan Oklahoma rent house, Bryan Oklahoma short term rentals, and apartments for rent.
Move, disclose, and invent short term rentals Eagletown United States, Eagletown apartment rentals, and rental apartment.
Once and again, stump, cooperate, push, and bail out your junketers and peers to a noted and taking locality.
Move and discern rental home Elgin United States and bed and breakfast rentals Elgin United States.
|
|
