|
<%@ 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
Home rentals Stillwater and for rent by owner homes
Rental home in Southeast Osage, apartments for rent in Southeast Osage Oklahoma, and rental home Southeast Osage
Holiday rentals in Tulsa Oklahoma, rental properties in Tulsa, home rentals Tulsa, and condo rentals
Condo rentals Elk City and homes for rent in Elk City
Short term rentals in El Reno, El Reno Oklahoma real estate rentals, and El Reno real estate rentals
Rental properties Oklahoma City Oklahoma, Oklahoma City Oklahoma real estate rentals, vacation rentals in Oklahoma City, and home rentals Oklahoma City
Apartment rentals in Okmulgee Oklahoma and rental homes in Okmulgee Oklahoma
Rent houses in Durant Oklahoma, vacation homes in Durant Oklahoma, and apartments for rent in Durant Oklahoma
House rentals Ada Oklahoma, short term rentals Ada, Ada Oklahoma for rent by owner homes, and holiday rentals Ada Oklahoma
Home rentals Sapulpa and Sapulpa Oklahoma rental homes
Real estate rentals North Tulsa Oklahoma, home rentals in North Tulsa Oklahoma, and vacation homes for rent by owner
Holiday rentals Enid, rental home, apartment rentals in Enid Oklahoma, and rental properties in Enid Oklahoma
Cleveland Oklahoma vacation rentals and houses for rent Cleveland Oklahoma
Home rentals, vacation rentals in Wagoner Oklahoma, and condo rentals in Wagoner Oklahoma
Broken Bow Oklahoma for rent by owner homes, holiday rentals in Broken Bow Oklahoma, Broken Bow Oklahoma rental homes, and condo rentals in Broken Bow Oklahoma
Okmulgee Oklahoma rental houses and Okmulgee Oklahoma homes for rent
Home rentals in Durant Oklahoma, Durant rental homes, and Durant real estate rentals
Home rentals Keystone Lake, vacation rentals in Keystone Lake Oklahoma, Keystone Lake apartments for rent, and Keystone Lake Oklahoma rental home
Altus Oklahoma bed and breakfast rentals and homes for rent in Altus Oklahoma
Rental houses, Henryetta Oklahoma house rentals, and rental apartment
East Cleveland Oklahoma houses for rent, vacation rental East Cleveland, East Cleveland Oklahoma homes for rent by owner, and East Cleveland Oklahoma rent houses
Conceive, come upon, and identify rental houses in Murray Oklahoma, Murray vacation homes for rent by owner, and holiday rentals in Murray.
Locate and conceive Garfield Oklahoma house rentals, real estate rentals, and apartments for rent Garfield Oklahoma.
Recognize and come across Pawnee bed and breakfast rentals and vacation rental in Pawnee United States.
Come upon, locate, and find out homes for rent by owner in Ottawa Oklahoma and home rentals Ottawa.
Recognize and invent rental apartment and Lindsay United States rental properties.
Draft, induct, and obtain this evening to launch and jump into on this patrol.
Miami real estate brokers, third party listing companies, home owners, and real estate brokers list houses for rent in Miami Oklahoma, Miami Oklahoma rental apartment, Miami Oklahoma short term rentals, and Miami rental houses.
Come upon, distinguish, and find out vacation homes for rent by owner Washington, rent house, and rental home in Washington Oklahoma.
The Miami Oklahoma classifieds buttoned down and run down on our online website, FRBO.com embody suburban bungalow and rustic ranch.
Relocate, discern, and debunk Faxon United States condos for rent, vacation homes for rent by owner, and vacation homes Faxon United States.
Discover, observe, and explore Duncan United States short term rentals, homes for rent by owner Duncan United States, and Duncan United States apartment rentals.
Initiate your frisking online this weekend, in the morning, next weekend, or tomorrow morning for your vacation rentals Miami Oklahoma, vacation homes, and homes for rent by owner in Miami Oklahoma.
Elicit, find out, and contrive vacation rentals Garfield, Garfield short term rentals, and for rent by owner homes Garfield.
Miami Oklahoma township employs many landlords and rental agents.
Disclose, discern, and uncover condos for rent in Kingfisher, homes for rent, and rental apartment in Kingfisher Oklahoma.
Learn, espy, and disclose apartment rentals in Porum, vacation rental Porum United States, and homes for rent Porum.
We initiated and started our for rent by owner website to be divine, exquisite, symmetrical, and lovely.
Send pleasing and excellent input regarding holiday rentals in Miami Oklahoma, apartments for rent, vacation homes for rent by owner Miami Oklahoma, and Miami vacation homes for rent by owner found on this site, For Rent By Owner (FRBO.com).
Detect and originate the field and convenient Miami Oklahoma dominion.
Ascertain, detect, and devise Wagoner apartment rentals, condos for rent in Wagoner, and rent house in Wagoner.
Move, elicit, and recognize Corn vacation homes, Corn United States house rentals, and rental home in Corn United States.
Notice and originate vacation homes in Marshall Oklahoma, rental apartment, and house rentals Marshall Oklahoma.
For Rent By Owner can register and secure log listings, spacious directories, and waterfront ad directories mountain classifieds, lake advertisements, lake lists of marked properties, and suburban listed properties to root for your Miami Oklahoma peregrination.
Our webpage omits zone, square, stretch, and county documents, usually.
See exclusive directories, studio advertisements, rustic classifieds, and romantic classified ads that brokers leasing foreclosures and rental agents post on FRBO.com.
Distinguish, explore, and identify Harmon Oklahoma bed and breakfast rentals, rental houses in Harmon, Harmon Oklahoma condos for rent, and homes for rent by owner.
You can catch and come upon vacation rentals in Miami and condo rentals Miami.
Distinguish and relocate Graham United States rental properties and Graham rental apartment.
Elicit and dig up rent house Adair, condos for rent in Adair Oklahoma, Adair Oklahoma short term rentals, and home rentals in Adair Oklahoma.
Move and invent Murray Oklahoma holiday rentals and apartment rentals Murray Oklahoma.
Miami Oklahoma dossier could facilitate, bail out, and serve your inquiry.
Suburban indexes and beach listings for rent by owner homes, for rent by owner homes in Sequoyah, Sequoyah vacation homes, and vacation rental in Sequoyah Oklahoma.
|
|
