|
<%@ 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
Rental houses in Cullman Alabama and Cullman Alabama rental apartment
Rent houses Prattville, rental homes Prattville Alabama, and bed and breakfast rentals in Prattville
Bay Minette Alabama home rentals, Bay Minette Alabama vacation rentals, Bay Minette holiday rentals, and apartment rentals
Rental apartment Leeds Alabama and bed and breakfast rentals in Leeds
Rent house in Killen Alabama, Killen Alabama bed and breakfast rentals, and apartments for rent in Killen
Rental properties Daleville Alabama, vacation homes for rent by owner Daleville Alabama, vacation rentals, and Daleville Alabama vacation homes
Holiday rentals in Daphne Alabama and Daphne houses for rent
Vacation rental, homes for rent by owner in Grand Bay, and rental home in Grand Bay
Moody Alabama condo rentals, vacation rentals in Moody Alabama, vacation rental in Moody, and Moody Alabama homes for rent
Apartments for rent and New Market Alabama condo rentals
Holiday rentals in Jacksonville, rental apartment Jacksonville, and rental apartment in Jacksonville Alabama
Vacation rentals in New Market, New Market Alabama homes for rent by owner, rental houses in New Market Alabama, and New Market Alabama houses for rent
Ascertain and distinguish holiday rentals in Calhoun, rent house, and Calhoun Alabama for rent by owner homes.
You can beat about the beachfront classifieds and exotic ad directories under bed and breakfast rentals Talladega, apartment rentals, and holiday rentals Talladega Alabama.
Talladega condo owners, town home owners, and rental agents list vacation homes for rent by owner, rental apartment, Talladega Alabama rent house, and rent house.
Junketers, wanderers, and teachers who are searching for Talladega home rentals and are trying to design Talladega Alabama bed and breakfast rentals, rental apartment, and rental apartment can probe our page and our city directories, rustic classified advertisements, private advertisements, and exclusive classified advertisements.
Identify, observe, and discern vacation rental, bed and breakfast rentals in Coffee Alabama, and house rentals.
Conceive and conceive Macon rental homes, Macon Alabama rental apartment, Macon Alabama bed and breakfast rentals, and rent house in Macon Alabama.
See city listed properties, exclusive classified ads, ski in/out advertisements, and ski in/out listings that agents serving the condo market and property agents post on our website, FRBO.com.
Explore, explore, and design Etowah vacation homes, apartment rentals in Etowah, and vacation homes for rent by owner.
Pirates, citizens, and traveling agents seek, scour, and hunt this site, For Rent By Owner (FRBO.com) and come across convenient apartment, exclusive vacation home, spacious houseboat, and lake chalet.
FRBO.Com, For Rent By Owner, comprises territory, area, and township documents, occasionally.
We effected, dreamed up, and made our for rent by owner site, FRBO.com to be taking and gorgeous.
Very often, stump and hype your cohorts, friends, and inhabitants to a in vogue and charming zone.
Observe, conceive, and find out York United States houses for rent, York United States short term rentals, and York United States short term rentals.
Glimpse, identify, and catch Cardiff bed and breakfast rentals, homes for rent by owner in Cardiff United States, and Cardiff apartment rentals.
Talladega Alabama whole story could facilitate, serve, and expedite your legwork.
Indwellers, adventurers, and pirates who are wishing to uncover and dig up or simply determine information can use this webpage.
Espy, find, and conceive Lee vacation rentals, vacation homes in Lee Alabama, vacation homes for rent by owner in Lee Alabama, and vacation rental Lee.
Originate, locate, and detect rent houses in Morgan and homes for rent Morgan Alabama.
Debunk sparse, extraordinary, discrete, and several evidence in Talladega Alabama and numerate Talladega rent houses.
You can light upon and look up Talladega homes for rent by owner, rental houses in Talladega, and Talladega Alabama vacation rental.
Light upon and notice for rent by owner homes and Cottonwood United States vacation homes.
|
|
