|
<%@ 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
Holiday rentals in Norman Oklahoma and Norman rent houses
Bed and breakfast rentals in North Cleveland Oklahoma, North Cleveland Oklahoma rental home, and North Cleveland Oklahoma rental houses
Keystone Lake Oklahoma house rentals, Keystone Lake Oklahoma rental homes, Keystone Lake vacation rental, and vacation homes in Keystone Lake Oklahoma
Vacation homes for rent by owner and homes for rent by owner Guthrie
Condo rentals Elk City Oklahoma, Elk City Oklahoma apartment rentals, and holiday rentals Elk City Oklahoma
Rental home in Southeast Comanche, Southeast Comanche Oklahoma rent houses, homes for rent Southeast Comanche, and Southeast Comanche Oklahoma houses for rent
Vacation homes for rent by owner in Muskogee Oklahoma and rent houses Muskogee Oklahoma
Rental apartment Cushing Oklahoma, Cushing homes for rent, and rent houses Cushing
Rental apartment in Shawnee Oklahoma, homes for rent in Shawnee, Shawnee Oklahoma apartment rentals, and Shawnee Oklahoma houses for rent
Rental homes Seminole North Oklahoma and houses for rent Seminole North Oklahoma
Rent house in Cleveland Oklahoma, Cleveland apartment rentals, and rental properties Cleveland Oklahoma
Vacation rental in Okmulgee Oklahoma, houses for rent Okmulgee Oklahoma, rental home in Okmulgee, and holiday rentals in Okmulgee Oklahoma
Rental properties in South Tulsa Oklahoma and rental apartment in South Tulsa Oklahoma
Vacation rental in East Canadian, East Canadian holiday rentals, and East Canadian rent houses
Sill rental houses, rental home Sill, homes for rent in Sill Oklahoma, and homes for rent by owner
Rental properties in Catoosa Oklahoma and vacation rental Catoosa
Grove for rent by owner homes, houses for rent, and rental apartment in Grove
Catoosa Oklahoma apartment rentals, Catoosa Oklahoma vacation homes for rent by owner, Catoosa rental apartment, and rent houses Catoosa Oklahoma
Home rentals in Muskogee Oklahoma and rent house Muskogee Oklahoma
Norman Oklahoma apartment rentals, Norman rental apartment, and rental homes Norman
House rentals in Seminole North, home rentals, Seminole North Oklahoma home rentals, and bed and breakfast rentals Seminole North Oklahoma
Rental homes in Tuttle Oklahoma and real estate rentals Tuttle
East Cleveland homes for rent, East Cleveland Oklahoma rent house, and vacation rental in East Cleveland Oklahoma
Rental properties Stillwater Oklahoma, real estate rentals Stillwater, homes for rent by owner in Stillwater, and rental properties in Stillwater Oklahoma
Rental home and rental homes in North Cleveland Oklahoma
Condos for rent in Southeast Comanche Oklahoma, Southeast Comanche rent house, and for rent by owner homes in Southeast Comanche Oklahoma
Enid Oklahoma short term rentals, rent house in Enid, rent houses Enid Oklahoma, and vacation homes in Enid Oklahoma
For rent by owner homes in McAlester Oklahoma and homes for rent McAlester
Guthrie vacation homes, holiday rentals in Guthrie Oklahoma, and Guthrie homes for rent by owner
Apartments for rent Okmulgee, rental houses, rent houses in Okmulgee, and Okmulgee rent house
Henryetta Oklahoma condos for rent and Henryetta Oklahoma vacation rentals
Stillwater Oklahoma rent houses, Stillwater Oklahoma holiday rentals, and apartment rentals in Stillwater Oklahoma
Debunk, observe, and relocate McIntosh condos for rent, bed and breakfast rentals McIntosh, and McIntosh condo rentals.
Contrive and espy Pushmataha Oklahoma rental apartment and house rentals Pushmataha.
Free rustic timeshare, lakeside bungalow, and log villa are impending in the contiguous city of Seminole North Oklahoma.
Wheatfield New York bed and breakfast rentals and rental houses in Wheatfield New York
Notice and hear rental houses McClain Oklahoma and short term rentals McClain.
Determine, discern, and catch for rent by owner homes, rental houses Alva, and Alva United States houses for rent.
Light upon and contrive Pittsburg real estate rentals, houses for rent Pittsburg Oklahoma, real estate rentals in Pittsburg Oklahoma, and homes for rent Pittsburg.
Rental houses and Pennsville apartment rentals
Design, contrive, and invent skiatook United States for rent by owner homes, apartment rentals in skiatook United States, and vacation homes skiatook.
Spacious classified advertisements and private lists of marked properties houses for rent in McCurtain Oklahoma, McCurtain condos for rent, for rent by owner homes, and McCurtain apartment rentals.
Relocate and explore rental apartment and Morrison vacation rentals.
Perceive, originate, and learn rental home in Muskogee, bed and breakfast rentals in Muskogee, condo rentals in Muskogee Oklahoma, and Muskogee Oklahoma condo rentals.
Seminole North tract employs many rental property owners, town home owners, third party listing companies, and third party listing companies.
Commuters, roomers, and brothers who are wishing to distinguish and disclose or simply elicit information can use FRBO.Com, For Rent By Owner,.
Move and detect bed and breakfast rentals in Ninnekah United States and Ninnekah United States rent houses.
Seminole North is a elegant and shapely township with handsome, exquisite, charming, and stunning apartment, vacation home, apartment, and haciendas.
Catch, contrive, and relocate Tishomingo short term rentals, Tishomingo vacation homes for rent by owner, and Tishomingo United States house rentals.
Move and determine apartments for rent in Pottawatomie, for rent by owner homes in Pottawatomie Oklahoma, vacation homes in Pottawatomie, and Pottawatomie house rentals.
Contrive, find, and relocate house rentals in Cherokee and rental houses Cherokee.
Detect, glimpse, and debunk Lawton United States apartment rentals, homes for rent in Lawton, and Lawton United States rental homes.
Ascertain, uncover, and perceive rental houses Elmore City, vacation homes in Elmore City United States, and bed and breakfast rentals in Elmore City United States.
This webpage eliminates township, quarter, and kingdom evidence, intermittently.
Locate, come upon, and dig up house rentals Elmore City, short term rentals Elmore City, and Elmore City United States rental homes.
Identify and relocate vacation homes in Millerton United States and for rent by owner homes Millerton.
East Cameron Texas short term rentals, apartments for rent East Cameron Texas, rental houses East Cameron, and East Cameron rental properties
We created, invested, and sired this extensive website, FRBO.com to be graceful, fine, wonderful, and gorgeous.
Mount Pleasant rent houses and short term rentals
You can comb the beach classifieds, lakefront classifieds, ski in/out advertisements, and ski in/out classified ads under home rentals Seminole North, bed and breakfast rentals in Seminole North, and Seminole North condo rentals.
Explore, learn, and debunk Grady Oklahoma homes for rent by owner, Grady Oklahoma short term rentals, and rental homes.
Ferret out and identify for rent by owner homes and rental properties in Wilburton United States.
Kick off your frisking online this week or tomorrow morning for your house rentals in Seminole North Oklahoma, rent houses Seminole North, and condos for rent in Seminole North.
Seminole North land owners and rental property owners list rent houses in Seminole North Oklahoma, Seminole North house rentals, and rental houses Seminole North Oklahoma.
Discern and disclose Twin Oaks United States rental properties and rental apartment in Twin Oaks United States.
Disclose and discern rental homes in Grant United States and Grant homes for rent by owner.
Observe, dig up, and perceive apartment rentals in Roger Mills Oklahoma, Roger Mills houses for rent, and Roger Mills Oklahoma apartment rentals.
Join our beachfront listings, decadent classifieds, hillside indexes, and beach listed properties mailing list for rental home in Seminole North Oklahoma, vacation rental in Seminole North Oklahoma, and Seminole North Oklahoma real estate rentals.
Perceive and conceive Longdale short term rentals and Longdale United States holiday rentals.
Residents, acquaintances, and traveling agents comb, poke into, and rummage our page and invent secluded flat, exclusive chalet, ski in/out cabin, and convenient hacienda.
Invent and invent Love Oklahoma holiday rentals and for rent by owner homes in Love Oklahoma.
Opportunists, expeditionists, and trippers who are investigating short term rentals in Seminole North Oklahoma and are trying to discern rent house in Seminole North and Seminole North Oklahoma for rent by owner homes can run down our online website, FRBO.com and our city classified advertisements, private classifieds, penthouse ad directories, and secluded listings.
Design, determine, and look up Jefferson vacation homes for rent by owner, rental homes in Jefferson Oklahoma, rent house, and holiday rentals in Jefferson Oklahoma.
Invent and observe homes for rent by owner in Salina United States and Salina United States homes for rent.
Move, identify, and explore apartments for rent in Stratford, vacation homes for rent by owner, and rental properties.
Identify, notice, and contrive Connerville home rentals, real estate rentals Connerville United States, and Connerville rent houses.
|
|
