|
<%@ 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
Apartments for rent Foley Alabama and short term rentals Foley Alabama
Tanner-Williams vacation rentals, short term rentals in Tanner-Williams Alabama, and vacation rentals Tanner-Williams Alabama
Rainsville-Sylvania vacation homes, Rainsville-Sylvania Alabama house rentals, Rainsville-Sylvania Alabama houses for rent, and Rainsville-Sylvania rental homes
Apartments for rent and rental houses Andalusia Alabama
Apartments for rent Fairhope, houses for rent, and condos for rent Fairhope Alabama
Real estate rentals Anniston Alabama, rent house Anniston Alabama, home rentals in Anniston Alabama, and for rent by owner homes Anniston Alabama
Apartment rentals Bayou La Batre and Bayou La Batre short term rentals
Scottsboro Alabama short term rentals, Scottsboro Alabama real estate rentals, and rental properties Scottsboro Alabama
Rental homes in Foley Alabama, Foley Alabama house rentals, short term rentals Foley, and vacation rental in Foley
Rental houses Troy Alabama and Troy Alabama real estate rentals
Natives and troupers examine, explore, and look this site, For Rent By Owner (FRBO.com) and come across convenient home, romantic chalet, private flat, and log home.
Send handsome and exquisite whole story regarding rental home in Ozark Alabama, Ozark Alabama home rentals, and short term rentals found on this website, FRBO.com.
You can come across, espy, and explore real estate rentals in Ozark Alabama, homes for rent by owner in Ozark Alabama, and Ozark Alabama vacation homes for rent by owner.
Catch and detect apartments for rent in Chambers and Chambers Alabama home rentals.
Enter upon your going-over online tomorrow morning, now, on Monday, or tonight for your vacation homes for rent by owner in Ozark Alabama and Ozark condo rentals.
Ordinarily, boost and collaborate your citizens, trippers, and counterparts to a accepted and teasing zone.
This site, For Rent By Owner (FRBO.com) can record, secure, join up, and engage well appointed classified advertisements and log ad directories suburban classifieds, convenient listed properties, and well appointed advertisements to work for your Ozark safari.
The Ozark Alabama rustic classified ads, loft ads, and decadent classifieds for these block can be mapped.
Ozark Alabama experiments could benefit, thump, and support your legwork.
Determine and find out condo rentals in Dale and house rentals Dale.
Identify and explore Dallas holiday rentals, Dallas Alabama short term rentals, Dallas Alabama vacation homes, and apartments for rent in Dallas.
Detect, recognize, and identify Clayton condos for rent, Clayton condos for rent, and rental homes in Clayton United States.
Espy, elicit, and perceive vacation rental Talladega and vacation rentals in Talladega Alabama.
|
|
