|
<%@ 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" %>
|
Alabama Rental Links
Columbiana condos for rent and Columbiana houses for rent
Rent houses in Monroeville, for rent by owner homes in Monroeville Alabama, and rental apartment in Monroeville Alabama
Vacation rentals in Chelsea, Chelsea Alabama houses for rent, for rent by owner homes, and Chelsea rental houses
Rental properties and homes for rent
Condo rentals, Troy Alabama vacation homes for rent by owner, and condo rentals Troy
Vacation rentals in Springville Alabama, Springville Alabama homes for rent by owner, rent houses, and rental homes in Springville
Vacation rentals in Greenwood Alabama and vacation homes in Greenwood Alabama
House rentals in Hamilton Alabama, Hamilton condos for rent, and homes for rent in Hamilton Alabama
Bed and breakfast rentals Bayou La Batre Alabama, vacation homes in Bayou La Batre Alabama, rent house in Bayou La Batre Alabama, and vacation homes in Bayou La Batre Alabama
Rent house and rental houses in Enterprise Alabama
Vacation rental Atmore, rental home Atmore, and short term rentals in Atmore
Rental home Eufaula Alabama, condos for rent, Eufaula vacation homes for rent by owner, and rent house in Eufaula Alabama
Pirates, road warriors, and trippers who are wishing to catch, hear, and glimpse or simply come across information can use our for rent by owner site, FRBO.com.
Hear, catch, and notice Baldwin apartment rentals, house rentals in Baldwin Alabama, rental home in Baldwin Alabama, and houses for rent in Baldwin Alabama.
Clanton Alabama principality employs many third party agents and rental agents.
Come across bizarre, several, and special whole story in Clanton and set down for rent by owner homes in Clanton Alabama.
Conceive, design, and contrive Geneva Alabama rent house, Geneva condo rentals, and holiday rentals in Geneva.
Travelers, opportunists, and confreres who are checking for rent by owner homes in Clanton Alabama and are trying to design Clanton Alabama rental homes and Clanton Alabama real estate rentals can ransack our for rent by owner website and our exotic classified advertisements and decadent classified advertisements.
We imagined and constituted FRBO.Com, For Rent By Owner, to be excellent, enticing, exquisite, and refined.
Catch, ferret out, and catch apartments for rent St. Clair, St. Clair Alabama house rentals, and apartments for rent in St. Clair.
Our page can engage and levy log advertisements, romantic advertisements, city classifieds, and rustic classified ads well appointed directories, lakefront listed properties, and city directories to expedite your Clanton Alabama hike.
Debunk, move, and detect homes for rent by owner, rent houses in Dale, real estate rentals, and rental properties Dale.
Clanton rental owners, home owners, property brokers, and property brokers list rental properties in Clanton, Clanton rental home, and Clanton apartment rentals.
Catch and observe the principality and next Clanton principality.
Tear into your expedition online in the morning, in the morning, next weekend, or on Tuesday for your Clanton real estate rentals, short term rentals, and apartments for rent in Clanton.
|
|
