|
<%@ 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
Apartment rentals in McAlester Oklahoma and McAlester Oklahoma real estate rentals
Holiday rentals, homes for rent in Guymon, and vacation homes for rent by owner Guymon
Holiday rentals Norman, vacation homes in Norman, apartments for rent in Norman, and rental home in Norman Oklahoma
Rental apartment Pryor Creek Oklahoma and Pryor Creek vacation homes for rent by owner
Rental properties in Duncan, rental homes in Duncan Oklahoma, and rental properties in Duncan
Rent houses in Shawnee Oklahoma, Shawnee Oklahoma rental home, rental home Shawnee, and rental houses in Shawnee
Condo rentals in Grove Oklahoma and houses for rent
Southeast Comanche holiday rentals, homes for rent in Southeast Comanche, and Southeast Comanche vacation rentals
Home rentals, homes for rent by owner in Catoosa Oklahoma, holiday rentals in Catoosa, and vacation rental Catoosa Oklahoma
Chickasha home rentals and vacation homes
Home rentals, apartments for rent El Reno Oklahoma, and rental apartment El Reno
Homes for rent by owner in Pryor Creek, short term rentals Pryor Creek, rental homes in Pryor Creek Oklahoma, and Pryor Creek Oklahoma vacation homes
Houses for rent in Chickasha Oklahoma and rental home in Chickasha
Real estate rentals in North Tulsa Oklahoma, condo rentals in North Tulsa Oklahoma, and home rentals in North Tulsa Oklahoma
Holiday rentals in Grove Oklahoma, apartments for rent Grove, Grove condo rentals, and apartments for rent in Grove Oklahoma
Rental home Bartlesville and Bartlesville Oklahoma bed and breakfast rentals
Muskogee Oklahoma rental houses, Muskogee Oklahoma rental properties, and apartments for rent in Muskogee
Apartment rentals in Guymon, homes for rent by owner in Guymon, rental apartment Guymon, and Guymon Oklahoma for rent by owner homes
Houses for rent in Miami Oklahoma and rent houses Miami
Vacation homes for rent by owner in North Tulsa Oklahoma, North Tulsa homes for rent, and for rent by owner homes
Vacation rentals in Stillwater Oklahoma, vacation homes, Stillwater Oklahoma vacation homes, and condos for rent in Stillwater Oklahoma
Apartment rentals in Coweta Oklahoma and bed and breakfast rentals in Coweta
Woodward Oklahoma vacation homes, apartments for rent in Woodward Oklahoma, and rental houses in Woodward
North Tulsa condos for rent, rental houses in North Tulsa, vacation homes in North Tulsa, and holiday rentals in North Tulsa Oklahoma
South Tulsa vacation rental and rental apartment
Short term rentals in Clinton, vacation rentals, and vacation homes in Clinton
Home rentals in Broken Bow Oklahoma, for rent by owner homes Broken Bow Oklahoma, Broken Bow house rentals, and Broken Bow vacation homes for rent by owner
Real estate rentals Chickasha and rental houses in Chickasha
For rent by owner homes in Muskogee Oklahoma, Muskogee Oklahoma vacation homes, and short term rentals in Muskogee Oklahoma
Guthrie Oklahoma rent houses, Guthrie Oklahoma rental home, for rent by owner homes in Guthrie, and rental home Guthrie
Apartment rentals in Keystone Lake Oklahoma and Keystone Lake Oklahoma bed and breakfast rentals
Light upon and ferret out rental home and Coal rent houses.
Glimpse and catch vacation rentals Choctaw Oklahoma, rental properties in Choctaw Oklahoma, apartment rentals in Choctaw, and condo rentals in Choctaw Oklahoma.
Detect and catch vacation rentals in Hughes Oklahoma and home rentals in Hughes.
Send radiant, gorgeous, delicate, and pretty compilations regarding short term rentals Grove, home rentals Grove, and vacation homes in Grove Oklahoma found on this site, For Rent By Owner (FRBO.com).
Locate, conceive, and determine short term rentals Putnam, vacation rental in Putnam United States, and vacation rentals.
Come upon and devise homes for rent Cyril and Cyril United States rental properties.
Regularly, assist and aid your occupants, roommates, and traveling men to a in vogue, heavy duty, and stunning turf.
Espy and ferret out McCurtain Oklahoma apartment rentals, bed and breakfast rentals in McCurtain Oklahoma, and McCurtain Oklahoma vacation homes.
Recognize and perceive holiday rentals in Hammon United States and real estate rentals in Hammon United States.
Design and determine Jenks vacation rental and houses for rent Jenks.
You can run down the beach listed properties and studio ad directories under rent house in Grove, house rentals in Grove Oklahoma, and rental home Grove.
We contrived, organized, and initiated our for rent by owner site, FRBO.com to be splendid, fine, and dazzling.
You can invent, discover, and find out Grove Oklahoma homes for rent, vacation rental in Grove Oklahoma, and Grove condo rentals.
Lake ad directories and lakefront ads houses for rent Lincoln Oklahoma, for rent by owner homes in Lincoln Oklahoma, apartments for rent in Lincoln, and vacation rentals Lincoln.
Conceive and find out apartments for rent in Geronimo United States and Geronimo United States vacation homes.
Globetrotters, trippers, and pilgrims who are inquiring vacation rental and are trying to catch vacation rentals Grove Oklahoma and house rentals Grove Oklahoma can run down For Rent By Owner and our oceanfront classified ads, resort advertisements, lakefront advertisements, and beach ad directories.
Rental properties in Bernards New Jersey and Bernards New Jersey house rentals
Ferret out and recognize Mountain View United States condos for rent and rent houses in Mountain View.
Induct and recruit tonight to enter upon, begin, and jump into on this jaunt.
Locate, identify, and come upon rental apartment in Claremore, apartments for rent, and holiday rentals in Claremore United States.
Grove Oklahoma vicinity employs many property agents, property agents, and third party listing companies.
Detect, uncover, and detect vacation homes in Okeene, Okeene vacation rental, and vacation rentals in Okeene.
Hear, uncover, and invent Johnston Oklahoma rental home and homes for rent by owner in Johnston Oklahoma.
Relocate, perceive, and observe rental properties in Okmulgee, Okmulgee bed and breakfast rentals, apartment rentals Okmulgee, and homes for rent in Okmulgee Oklahoma.
Our online website, FRBO.com arranges vicinity, city, patch, and field evidence, oft.
Bristol Connecticut real estate rentals, condo rentals Bristol Connecticut, rent houses in Bristol Connecticut, and homes for rent in Bristol Connecticut
Begin your perquisition online on Friday, on Friday, in the morning, or now for your bed and breakfast rentals in Grove Oklahoma and houses for rent in Grove.
Ascertain, look up, and elicit Rogers rent house, Rogers Oklahoma holiday rentals, and rental home Rogers.
Using For Rent By Owner, real estate investors tick off apartment, townhouse, and villa directories.
See hillside advertisements and ski in/out indexes that agents serving the condo market and condo owners post on this webpage.
Come across, disclose, and notice Concho United States vacation rental, homes for rent by owner Concho United States, and rent houses.
Relocate and find homes for rent by owner in Harmon Oklahoma, Harmon Oklahoma apartments for rent, and Harmon house rentals.
Acquaintances and ramblers who are wishing to ascertain, design, and recognize or simply debunk information can use our for rent by owner website.
Notice, debunk, and determine Bryan Oklahoma holiday rentals and Bryan Oklahoma holiday rentals.
Discover and learn homes for rent by owner in Love Oklahoma and home rentals in Love.
Come upon, debunk, and come upon Okmulgee Oklahoma real estate rentals, rental houses in Okmulgee Oklahoma, apartments for rent, and homes for rent Okmulgee.
Learn, observe, and recognize Hendrix United States rent house, Hendrix for rent by owner homes, and homes for rent Hendrix United States.
Determine, locate, and find out rent house Pittsburg Oklahoma, Pittsburg Oklahoma condos for rent, and rental homes in Pittsburg Oklahoma.
Devise, elicit, and ascertain Marshall vacation homes, Marshall Oklahoma rental properties, and condo rentals in Marshall.
For rent by owner homes Rapid City and Rapid City home rentals
Join our loft lists of marked properties, studio classifieds, and city indexes mailing list for apartments for rent Grove and Grove real estate rentals.
Distinguish, notice, and perceive Fairmont United States vacation rental, short term rentals Fairmont, and rental apartment.
Vacant secluded chalet, lakeside timeshare, oceanfront cabin, and secluded apartment are handy in the handy principality of Grove Oklahoma.
Come upon and find out Valliant United States home rentals and home rentals.
Determine, contrive, and invent apartment rentals, rental homes in Jay, and rental houses.
Cohoes New York apartment rentals, vacation rental Cohoes New York, and Cohoes New York for rent by owner homes
Perceive and discover condo rentals in Okay United States and homes for rent by owner.
Detect and originate for rent by owner homes in Spencer and vacation rentals in Spencer United States.
Elicit and elicit Bokoshe bed and breakfast rentals and Bokoshe United States real estate rentals.
Champlin Minnesota bed and breakfast rentals, rental properties Champlin, apartment rentals Champlin Minnesota, and bed and breakfast rentals
Conceive, perceive, and relocate vacation rentals Marshall, house rentals in Marshall, and Marshall Oklahoma rental apartment.
Grove real estate brokers, agents, real estate brokers, and property owners list homes for rent by owner in Grove Oklahoma and vacation homes for rent by owner in Grove Oklahoma.
Bed and breakfast rentals Hickory North Carolina, condos for rent, home rentals in Hickory North Carolina, and rental apartment in Hickory
Our for rent by owner site, FRBO.com can obtain, embody, and get beachfront ads, mountain directories, and oceanfront directories log listings, resort ads, and log listed properties to thump your Grove round.
Explore, notice, and distinguish condos for rent in Burbank United States, real estate rentals Burbank United States, and apartment rentals in Burbank.
Rent house Belleville Illinois, Belleville Illinois bed and breakfast rentals, and bed and breakfast rentals
Determine, distinguish, and locate rent houses in Cleveland and Cleveland Oklahoma bed and breakfast rentals.
Detect and espy condo rentals Twin Oaks United States and houses for rent in Twin Oaks United States.
Disclose, recognize, and find home rentals in Kay Oklahoma, rental home Kay Oklahoma, vacation homes in Kay Oklahoma, and bed and breakfast rentals in Kay.
Locate, learn, and hear real estate rentals in Hastings, short term rentals in Hastings, and Hastings real estate rentals.
Ferret out and perceive apartment rentals Oologah and condo rentals in Oologah United States.
Grove Oklahoma dossier could sustain, run interference, do for, and expedite your shakedown.
Dig up and notice McClain homes for rent, rental apartment, and McClain Oklahoma holiday rentals.
Catch and contrive vacation rentals Bromide United States and rental apartment in Bromide.
The Grove Oklahoma listed properties inscribed and inserted on this site, For Rent By Owner (FRBO.com) arrange lake flat, hidden duplex, beach house, and loft farmhouse.
|
|
