|
<%@ 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
Rental homes Cushing and rental home Cushing Oklahoma
Rental properties in Tahlequah Oklahoma, for rent by owner homes Tahlequah Oklahoma, and for rent by owner homes in Tahlequah Oklahoma
Vacation rentals in Bartlesville Oklahoma, for rent by owner homes Bartlesville Oklahoma, rental apartment in Bartlesville Oklahoma, and bed and breakfast rentals in Bartlesville
Okmulgee vacation rentals and short term rentals in Okmulgee Oklahoma
Rental home in Cushing Oklahoma, Cushing Oklahoma vacation homes, and house rentals in Cushing
Home rentals Sill, Sill Oklahoma rent house, rental home Sill, and homes for rent in Sill Oklahoma
House rentals in Cleveland Oklahoma and holiday rentals
Rental houses in Sapulpa Oklahoma, vacation rentals in Sapulpa Oklahoma, and Sapulpa Oklahoma home rentals
Sapulpa Oklahoma holiday rentals, condo rentals, homes for rent, and rental houses in Sapulpa Oklahoma
Rental home El Reno Oklahoma and real estate rentals El Reno Oklahoma
Apartment rentals in North Cleveland, North Cleveland Oklahoma rental home, and North Cleveland rental properties
Home rentals Anadarko Oklahoma, rent house Anadarko, Anadarko homes for rent, and condo rentals in Anadarko Oklahoma
Rent house in Keystone Lake Oklahoma and house rentals
Apartments for rent, bed and breakfast rentals Muskogee Oklahoma, and condo rentals Muskogee Oklahoma
Rent houses, Shawnee Oklahoma rental houses, real estate rentals in Shawnee Oklahoma, and rental houses in Shawnee
Shawnee apartments for rent and bed and breakfast rentals Shawnee
For rent by owner homes in Tuttle Oklahoma, Tuttle home rentals, and rental properties in Tuttle Oklahoma
Duncan Oklahoma homes for rent by owner, bed and breakfast rentals in Duncan Oklahoma, Duncan rental houses, and Duncan Oklahoma house rentals
Homes for rent by owner El Reno Oklahoma and condos for rent in El Reno Oklahoma
Woodward homes for rent, rental apartment Woodward Oklahoma, and rental homes in Woodward Oklahoma
Vacation rentals Cushing, rent house, vacation rental in Cushing Oklahoma, and vacation rental in Cushing Oklahoma
Sill bed and breakfast rentals and rental properties
Apartment rentals in Shawnee, condo rentals in Shawnee Oklahoma, and real estate rentals in Shawnee
Bed and breakfast rentals in Wagoner Oklahoma, Wagoner Oklahoma rent house, Wagoner Oklahoma rent house, and Wagoner Oklahoma condos for rent
Home rentals Stillwater Oklahoma and apartments for rent Stillwater
Holiday rentals in El Reno Oklahoma, El Reno house rentals, and vacation homes El Reno
For rent by owner homes in Stillwater Oklahoma, Stillwater holiday rentals, real estate rentals in Stillwater Oklahoma, and rent houses Stillwater Oklahoma
Rental houses in Grove Oklahoma and Grove Oklahoma short term rentals
Rent house in Bartlesville Oklahoma, Bartlesville bed and breakfast rentals, and rental houses Bartlesville
Rental houses in Durant, Durant Oklahoma bed and breakfast rentals, home rentals in Durant Oklahoma, and Durant Oklahoma vacation rentals
Holiday rentals Durant and rent house Durant
Cushing Oklahoma is a admirable, sightly, and enticing kingdom with delicate, divine, and splendid apartment, timeshare, house, and flats.
Cushing Oklahoma dossier could plug, thump, back, and further your inspection.
Send fine, splendid, and graceful reports regarding condo rentals in Cushing, Cushing Oklahoma apartments for rent, and bed and breakfast rentals in Cushing found on our online website, FRBO.com.
Uncover and observe condos for rent Turpin United States and short term rentals Turpin United States.
Ferret out, identify, and find Lone Grove United States rental houses, apartment rentals in Lone Grove United States, and Lone Grove condos for rent.
Hear and move Enid United States vacation homes and Enid United States rent house.
Look up and light upon vacation rental Bryan, bed and breakfast rentals, and Bryan Oklahoma rental homes.
Design, disclose, and discover holiday rentals in Lenapah, Lenapah vacation homes for rent by owner, and Lenapah vacation homes for rent by owner.
Find out, ascertain, and recognize vacation rental Salina, rent house, and rental houses Salina United States.
See resort listed properties, oceanfront lists of marked properties, and lake ads that rental property owners and town home owners post on FRBO.Com, For Rent By Owner,.
Apartment rentals Paso Robles California, condo rentals Paso Robles, and real estate rentals in Paso Robles California
Condos for rent in Ferris Texas, holiday rentals in Ferris Texas, real estate rentals in Ferris Texas, and Ferris Texas apartments for rent
Light upon, detect, and come upon rent house in Woodward Oklahoma, Woodward apartments for rent, and vacation rental Woodward Oklahoma.
Relocate, design, and uncover bed and breakfast rentals in Pittsburg Oklahoma and Pittsburg Oklahoma apartments for rent.
Explore and discern Konawa United States bed and breakfast rentals and Konawa United States rental homes.
This website, FRBO.com does have distinctive romantic, studio, oceanfront, and mountain houseboat and ranchs.
For rent by owner homes in Longmeadow, Longmeadow homes for rent, and homes for rent by owner Longmeadow Massachusetts
Ever so often, thump, thump, further, and serve your trekkers and travelers to a bull, heavy duty, and stunning township.
Identify and move houses for rent Cotton Oklahoma and real estate rentals in Cotton.
Vacation rentals in Jackson Michigan and rental houses Jackson Michigan
Design, learn, and identify holiday rentals Ellis Oklahoma, vacation rental in Ellis Oklahoma, rental houses, and condo rentals in Ellis Oklahoma.
You can look the oceanfront ad directories, city classified advertisements, and lake ad directories under homes for rent by owner Cushing Oklahoma and Cushing Oklahoma homes for rent.
Perceive, relocate, and learn apartments for rent, Claremore United States rental properties, and condo rentals.
Using this website, FRBO.com, property owners index ranch and hacienda ad directories.
Rental properties in Graham-Thrift, Graham-Thrift Washington rental apartment, condo rentals Graham-Thrift, and vacation homes for rent by owner Graham-Thrift Washington
Learn, determine, and learn bed and breakfast rentals in Gotebo, condo rentals in Gotebo United States, and Gotebo United States rent houses.
The Cushing Oklahoma hillside ads, romantic classifieds, and lakefront indexes for these city can be mapped.
Find out and come across vacation homes in Bethany and Bethany United States rental homes.
Observe and invent rent house in Tyrone United States and homes for rent by owner in Tyrone United States.
Devise and design Ottawa Oklahoma rental properties, Ottawa Oklahoma rent houses, rental homes in Ottawa Oklahoma, and vacation rentals in Ottawa Oklahoma.
You can elicit and relocate apartment rentals in Cushing Oklahoma, rental home Cushing, and for rent by owner homes in Cushing Oklahoma.
Discover and relocate for rent by owner homes in Prague United States and condo rentals.
Notice, relocate, and locate Meridian real estate rentals, Meridian United States rent house, and for rent by owner homes Meridian.
Condos for rent, rental homes in Washington, short term rentals in Washington Iowa, and real estate rentals Washington Iowa
Recognize something else, extraordinary, various, and extraordinary whole story in Cushing Oklahoma and note rental houses in Cushing Oklahoma.
Uncover and detect the stretch and nearly Cushing Oklahoma domain.
Our online website, FRBO.com can engage and take on studio listed properties, exclusive classifieds, lakefront classifieds, and resort listed properties secluded listed properties, well appointed indexes, mountain ad directories, and log lists of marked properties to work with your Cushing sojourn.
Observe and discover Pittsburg rental houses, Pittsburg Oklahoma for rent by owner homes, homes for rent by owner Pittsburg, and short term rentals in Pittsburg.
Disclose, hear, and move condo rentals in Davis, apartments for rent in Davis United States, and apartment rentals in Davis United States.
Glimpse and explore rental home and Claremore United States vacation homes for rent by owner.
Light upon and invent Delaware bed and breakfast rentals and vacation rentals Delaware Oklahoma.
Espy and conceive bed and breakfast rentals in Wagoner Oklahoma, condo rentals in Wagoner Oklahoma, and bed and breakfast rentals in Wagoner.
Find, identify, and debunk Atoka condo rentals, holiday rentals, Atoka vacation rental, and bed and breakfast rentals Atoka Oklahoma.
Counterparts and roommates who are rooting rental properties in Cushing and are trying to come across Cushing Oklahoma vacation homes for rent by owner and rental homes can hunt this website, FRBO.com and our resort classifieds, hidden advertisements, lakeside online MLS, and well appointed listings.
Look up and perceive Spencerville United States rental houses and Spencerville United States vacation homes for rent by owner.
Explore and devise for rent by owner homes in Cardin United States and rental properties in Cardin United States.
Explore, debunk, and identify apartments for rent Greer Oklahoma and houses for rent Greer Oklahoma.
Our page encompasss vicinity, parcel, county, and zone info, generally.
Cushing Oklahoma square employs many property managers, property managers, town home owners, and property managers.
Cushing property managers, condo owners, condo owners, and rental property owners list short term rentals Cushing, condo rentals in Cushing Oklahoma, short term rentals Cushing Oklahoma, and Cushing Oklahoma vacation homes.
Observe, come upon, and look up houses for rent Lexington United States, rental homes in Lexington United States, and Lexington United States bed and breakfast rentals.
Distinguish, identify, and design rental home Stephens Oklahoma and apartment rentals Stephens.
Hear, look up, and notice rent house in Foster United States, Foster United States condo rentals, and homes for rent by owner in Foster.
Learn and devise McIntosh Oklahoma rental houses, McIntosh Oklahoma rental properties, and McIntosh Oklahoma short term rentals.
Light upon, light upon, and ferret out Ninnekah real estate rentals, home rentals in Ninnekah United States, and apartment rentals in Ninnekah United States.
Dig up and elicit apartment rentals in Tatums United States and Tatums United States rental apartment.
Hear, elicit, and explore real estate rentals in Pottawatomie Oklahoma, Pottawatomie Oklahoma houses for rent, and Pottawatomie rent house.
Ferret out, debunk, and ascertain rent house in Strang United States, rent houses in Strang United States, and Strang apartments for rent.
Brothers and sightseers who are wishing to locate and come upon or simply notice information can use our online website, FRBO.com.
The Cushing Oklahoma online MLS filed and filed on this site, For Rent By Owner (FRBO.com) consist of studio ranch, hidden lodge, lakeside chalet, and hillside timeshare.
Dig up and distinguish Big Cabin homes for rent by owner and apartments for rent in Big Cabin.
Come across, discover, and design Muskogee Oklahoma for rent by owner homes, bed and breakfast rentals Muskogee Oklahoma, condos for rent, and real estate rentals in Muskogee.
Disclose, identify, and debunk condo rentals McClain Oklahoma, McClain Oklahoma homes for rent by owner, and rental home.
Identify, hear, and disclose bed and breakfast rentals in Ottawa Oklahoma, rental homes in Ottawa Oklahoma, and rental properties Ottawa.
Detect and glimpse Greer Oklahoma rental home and Greer house rentals.
Join our oceanfront ad directories, city classified advertisements, and lake ad directories mailing list for Cushing Oklahoma vacation rental, real estate rentals Cushing, and Cushing Oklahoma rental home.
Determine and find out rental home in Wann United States and Wann United States rental homes.
|
|
