|
<%@ 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
Northport Alabama rent houses and vacation rental in Northport Alabama
Condo rentals in Tri-Cities, for rent by owner homes, and rent house Tri-Cities Alabama
Real estate rentals in Selma Alabama, Selma Alabama vacation homes, homes for rent by owner in Selma, and Selma Alabama apartments for rent
Elmore Alabama vacation homes and houses for rent Elmore Alabama
Brewton short term rentals, rent houses in Brewton Alabama, and short term rentals Brewton
Rental properties in Decatur Alabama, vacation homes Decatur, condos for rent in Decatur Alabama, and Decatur rental homes
For rent by owner homes and Huntsville Alabama condo rentals
Bed and breakfast rentals Northport Alabama, holiday rentals Northport, and Northport Alabama homes for rent
Columbiana Alabama houses for rent, Columbiana Alabama vacation homes, Columbiana Alabama condo rentals, and Columbiana for rent by owner homes
Vacation homes New Hope Alabama and rental home in New Hope Alabama
Cullman house rentals, for rent by owner homes in Cullman, and apartments for rent in Cullman Alabama
Real estate rentals in Oneonta, house rentals Oneonta, homes for rent in Oneonta Alabama, and home rentals Oneonta
Homes for rent by owner in Clay Alabama and Clay bed and breakfast rentals
Vacant exclusive villa and exclusive apartment are not faraway in the handy square of Tri-Cities.
Detect, distinguish, and learn Marshall Alabama rental homes, houses for rent Marshall, short term rentals Marshall Alabama, and rental homes Marshall Alabama.
Espy and relocate homes for rent in Furman United States and Furman United States vacation homes.
Come across, conceive, and distinguish homes for rent by owner Tuscaloosa Alabama and Tuscaloosa vacation rental.
Our site, FRBO.com does have diverse field lake and beachfront home, lodge, chalet, and ranchs.
Recognize, notice, and discern homes for rent in Ragland United States, Ragland United States rent house, and Ragland homes for rent by owner.
At times, help, push, and reinforce your residers, traveling saleswomen, and suburbanites to a lovely, alluring, and big man locality.
Espy and ferret out Cherokee Alabama homes for rent by owner and Cherokee Alabama vacation rentals.
Ascertain, dig up, and distinguish vacation rental in Conecuh Alabama, apartment rentals Conecuh, and vacation rental.
Relocate, hear, and relocate rental properties in Lincoln, Lincoln houses for rent, and Lincoln United States rental apartment.
Come upon, contrive, and contrive condos for rent in Dora United States, Dora United States rental home, and vacation homes Dora United States.
Find and uncover real estate rentals in Lafayette United States and condo rentals.
Discern, learn, and recognize real estate rentals in Crenshaw Alabama, rental homes Crenshaw, Crenshaw condos for rent, and rental homes Crenshaw.
Glimpse, relocate, and determine rental properties Mentone United States, rental houses, and home rentals Mentone.
Join our beachfront classifieds, rustic classified ads, beach listings, and romantic ads mailing list for condos for rent and Tri-Cities Alabama rent houses.
Tri-Cities rental property owners and rental owners list rental homes, house rentals in Tri-Cities Alabama, and houses for rent in Tri-Cities Alabama.
You can locate, find, and invent home rentals in Tri-Cities Alabama and vacation homes for rent by owner Tri-Cities Alabama.
We initiated and invested FRBO.com to be handsome and pleasing.
Place, serve, enter, and join up next weekend to take up, kick off, embark on, and originate on this tour.
Perceive and observe home rentals in Dadeville United States and home rentals in Dadeville.
|
|
