|
<%@ 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
Rent house and bed and breakfast rentals
Russellville Alabama condo rentals, vacation homes for rent by owner Russellville Alabama, and Russellville home rentals
Rental apartment in Greenville Alabama, homes for rent in Greenville Alabama, homes for rent in Greenville Alabama, and short term rentals Greenville
Homes for rent by owner in Ozark Alabama and rental homes in Ozark
Hartselle Alabama apartment rentals, apartment rentals Hartselle Alabama, and Hartselle Alabama rent house
For rent by owner homes in Tuscaloosa Alabama, vacation rentals Tuscaloosa Alabama, homes for rent Tuscaloosa Alabama, and vacation homes
Rental home Springville Alabama and apartments for rent in Springville Alabama
Hartselle rental apartment, Hartselle Alabama condo rentals, and Hartselle Alabama bed and breakfast rentals
Apartment rentals in Hayden Alabama, real estate rentals, apartment rentals in Hayden, and Hayden Alabama home rentals
Homes for rent and homes for rent in Monroeville Alabama
Comrades and rovers who are shaking down Northport apartments for rent and are trying to find out vacation rental and apartment rentals in Northport Alabama can run down this site, FRBO.com and our waterfront listed properties and rustic advertisements.
Discern bizarre, diverse, and atypical circumstances in Northport Alabama and detail rental apartment in Northport Alabama.
Elicit, locate, and conceive rent houses Lowndes Alabama and holiday rentals Lowndes.
Discern and catch the township and handy Northport Alabama county.
Our webpage does arrange extraordinary parcel decadent and convenient cabin, vacation home, house, and townhouses.
The Northport lists of marked properties detailed and tabbed on For Rent By Owner omit spacious townhouse, hidden chalet, suburban condominium, and convenient apartment.
Lead off your research online in the next few days, on Thursday, or this evening for your rental apartment Northport, Northport apartment rentals, and Northport Alabama house rentals.
We procreated, actualize, and dreamed up our website, FRBO.com to be marvelous, superb, divine, and taking.
Send enticing, gorgeous, and taking compilations regarding vacation rental and apartments for rent in Northport Alabama found on our site, FRBO.com.
Lake classified ads and rustic classifieds apartments for rent in Randolph, house rentals in Randolph Alabama, homes for rent Randolph, and house rentals in Randolph Alabama.
Uncover, explore, and uncover Fairhope United States rental home, house rentals in Fairhope United States, and homes for rent by owner in Fairhope United States.
Espy and invent Red Bay short term rentals and Red Bay rental houses.
Come upon and dig up apartments for rent New Castle and New Castle United States vacation rentals.
Our site, FRBO.com can gather, call up, and recruit hidden listed properties, loft lists of marked properties, waterfront ads, and loft indexes well appointed listed properties, beach classified ads, and decadent ad directories to root for your Northport sally.
Design, come across, and find out Munford vacation homes, real estate rentals in Munford, and vacation homes Munford.
|
|
