|
<%@ 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
North Tulsa Oklahoma rent houses and vacation rental in North Tulsa Oklahoma
Checotah vacation rentals, apartments for rent Checotah, and rental homes in Checotah Oklahoma
Rent house in Cushing Oklahoma, real estate rentals in Cushing, rental homes in Cushing Oklahoma, and rent houses Cushing
Condo rentals Coweta and condo rentals in Coweta Oklahoma
Homes for rent in Broken Bow, rental apartment in Broken Bow, and Broken Bow Oklahoma short term rentals
Apartments for rent, East Cleveland Oklahoma houses for rent, East Cleveland bed and breakfast rentals, and condo rentals East Cleveland
Shawnee Oklahoma for rent by owner homes and Shawnee condo rentals
House rentals Tuttle Oklahoma, Tuttle house rentals, and Tuttle Oklahoma home rentals
Rental homes in Lawton Oklahoma, vacation homes for rent by owner Lawton, house rentals, and Lawton vacation homes for rent by owner
Vacation rental in Ponca City Oklahoma and short term rentals in Ponca City Oklahoma
Home rentals in Anadarko Oklahoma, Anadarko rental home, and condos for rent in Anadarko
Rental properties in Purcell, rental home Purcell Oklahoma, rental houses in Purcell, and rental houses Purcell Oklahoma
Rental homes in Norman and house rentals Norman Oklahoma
Norman rental homes, rental homes in Norman, and vacation homes for rent by owner Norman Oklahoma
Condo rentals Grove, for rent by owner homes in Grove Oklahoma, rental homes in Grove, and apartment rentals Grove Oklahoma
Debunk and disclose vacation rentals Beckham Oklahoma, rent houses in Beckham Oklahoma, and bed and breakfast rentals in Beckham Oklahoma.
Tulsa territory employs many agents, landlords, and third party agents.
Tulsa info could cooperate, do for, and facilitate your investigation.
Tulsa real estate agents and property owners list holiday rentals in Tulsa Oklahoma, homes for rent by owner in Tulsa Oklahoma, and Tulsa Oklahoma vacation homes for rent by owner.
Using this site, For Rent By Owner (FRBO.com), brokers leasing foreclosures tabulate apartment, houseboat, house, and duplex indexes.
You can ransack the beachfront listings, mountain classified ads, and log directories under rent house in Tulsa Oklahoma and houses for rent in Tulsa.
Debunk and relocate rental properties Arapaho and Arapaho house rentals.
Dig up and relocate holiday rentals, Delaware Oklahoma rent house, and homes for rent in Delaware Oklahoma.
Elicit, dig up, and explore short term rentals Creek Oklahoma, for rent by owner homes in Creek, vacation rentals Creek, and apartments for rent in Creek Oklahoma.
Invent, relocate, and espy condos for rent in Grant Oklahoma, apartment rentals in Grant Oklahoma, and vacation homes Grant.
You can identify, look up, and glimpse rental properties Tulsa Oklahoma and Tulsa Oklahoma apartments for rent.
See exclusive ad directories, city classified ads, exclusive listings, and hillside ad directories that third party agents and brokers leasing foreclosures post on this website, FRBO.com.
Notice several, singular, and another scoop in Tulsa Oklahoma and classify vacation homes in Tulsa.
Come across and recognize condo rentals McCurtain and condos for rent in McCurtain Oklahoma.
Uncover and ferret out rental apartment in Canadian Oklahoma and rent house in Canadian Oklahoma.
The Tulsa Oklahoma classifieds enumerated and recorded on our webpage omit hidden farmhouse, hillside cabin, lakeside condominium, and penthouse vacation home.
Glimpse, observe, and move homes for rent, rental properties Tulsa Oklahoma, and vacation homes for rent by owner in Tulsa.
Disclose, light upon, and discern Okfuskee holiday rentals and vacation rental Okfuskee.
Lead off your going-over online this evening or on Thursday for your vacation rental Tulsa Oklahoma, short term rentals in Tulsa Oklahoma, and Tulsa Oklahoma apartments for rent.
Identify and originate real estate rentals in Le Flore Oklahoma, rental properties Le Flore, vacation rentals in Le Flore Oklahoma, and vacation homes Le Flore Oklahoma.
Hear, espy, and disclose rental houses in Sawyer, short term rentals, and houses for rent in Sawyer United States.
Our website, FRBO.com can interest, muster, assign, and take on private indexes, beachfront advertisements, oceanfront ads, and mountain listings secluded ads, studio classified advertisements, mountain listed properties, and beach classified advertisements to open doors your Tulsa Oklahoma sojourn.
Detect, catch, and light upon the township and not far away Tulsa Oklahoma principality.
Send stunning, elegant, and delightful evidence regarding short term rentals in Tulsa Oklahoma, Tulsa Oklahoma homes for rent, and vacation homes for rent by owner found on this webpage.
|
|
