|
<%@ 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
Gadsden Alabama vacation rentals and condo rentals Gadsden Alabama
Montgomery rental apartment, bed and breakfast rentals, and vacation rental in Montgomery Alabama
Rental home Northport, bed and breakfast rentals in Northport Alabama, rental home Northport Alabama, and Northport Alabama homes for rent
For rent by owner homes Smiths-Salem and apartment rentals in Smiths-Salem Alabama
Rent house, rental apartment Moody Alabama, and house rentals in Moody Alabama
Bay Minette Alabama home rentals, vacation rentals Bay Minette Alabama, Bay Minette Alabama vacation homes, and vacation homes for rent by owner
Russellville Alabama homes for rent and rent houses in Russellville Alabama
Trussville Alabama short term rentals, vacation homes in Trussville, and Trussville Alabama house rentals
Rental properties Smiths-Salem, Smiths-Salem Alabama vacation homes, Smiths-Salem condo rentals, and Smiths-Salem vacation rentals
Eufaula Alabama rent houses and for rent by owner homes in Eufaula
Apartments for rent in Pell City Alabama, house rentals in Pell City Alabama, and Pell City homes for rent by owner
Tuscaloosa Alabama house rentals, vacation rentals, home rentals Tuscaloosa, and Tuscaloosa Alabama house rentals
Clay vacation rentals and Clay Alabama apartments for rent
Jemison Alabama rent houses, real estate rentals in Jemison Alabama, and Jemison houses for rent
Vacation rental in Killen Alabama, condos for rent in Killen Alabama, houses for rent in Killen Alabama, and condo rentals in Killen
Rental properties Clay and rent house Clay Alabama
Holiday rentals in Hazel Green Alabama, rental home, and Hazel Green Alabama rental apartment
Rent houses in Madison Alabama, houses for rent Madison, Madison Alabama condo rentals, and Madison vacation rental
Bed and breakfast rentals Florence Alabama and short term rentals in Florence Alabama
Rental homes in Hoover Alabama, condo rentals in Hoover, and rental homes in Hoover Alabama
Rent houses Hamilton Alabama, apartment rentals Hamilton Alabama, apartment rentals in Hamilton, and Hamilton apartment rentals
Homes for rent by owner and vacation homes in Cullman Alabama
Vacation rental in Decatur, Decatur Alabama holiday rentals, and vacation homes
Short term rentals, homes for rent by owner Tri-Cities, Tri-Cities Alabama condos for rent, and homes for rent by owner
Originate and explore holiday rentals Cherokee and house rentals Cherokee.
Unoccupied resort ranch, lakeside timeshare, city vacation home, and mountain apartment are nearby in the nearest domain of Jasper Alabama.
Explore and distinguish house rentals Marshall Alabama, holiday rentals Marshall Alabama, and holiday rentals Marshall Alabama.
The Jasper Alabama decadent listings, city listed properties, romantic classified advertisements, and romantic classified advertisements for these can be mapped.
Light upon and learn Henry Alabama holiday rentals, vacation homes, and rent house in Henry Alabama.
Come across and observe vacation homes in Letohatchee United States and home rentals Letohatchee United States.
Move and look up Madison Alabama rental houses and short term rentals in Madison Alabama.
Come across and identify Fitzpatrick United States rental properties and homes for rent by owner in Fitzpatrick.
Devise, originate, and come upon Clarke Alabama holiday rentals and rent house in Clarke Alabama.
Observe, explore, and look up apartments for rent in Helena United States, Helena vacation homes for rent by owner, and Helena United States rent house.
Hear, observe, and find bed and breakfast rentals in Newville United States, Newville vacation rentals, and homes for rent by owner in Newville United States.
Ferret out and dig up Montgomery real estate rentals, vacation homes in Montgomery, and Montgomery rental properties.
Identify, learn, and explore vacation homes in Walker Alabama, apartment rentals in Walker Alabama, Walker Alabama apartment rentals, and home rentals in Walker Alabama.
See studio listings and city indexes that property owners and town home owners post on For Rent By Owner.
Dig up, observe, and move Calera United States apartments for rent, real estate rentals Calera United States, and rental apartment in Calera.
Send shapely and refined picture regarding houses for rent Jasper, rent house in Jasper Alabama, condo rentals Jasper Alabama, and Jasper Alabama vacation rental found on our page.
Waterfront ads and lake classified ads vacation rental, rental properties, Escambia Alabama vacation rental, and home rentals.
Glimpse, uncover, and disclose rental home in Cullman Alabama and house rentals in Cullman Alabama.
Distinguish and observe Midland City United States condo rentals and Midland City United States homes for rent.
This site, FRBO.com does have small number territory spacious, oceanfront, exclusive, and convenient home, duplex, villa, and chalets.
The Jasper Alabama classified ads specified and census on our page embrace private duplex, exotic duplex, and lakefront hacienda.
Determine, dig up, and conceive for rent by owner homes in Walker Alabama, bed and breakfast rentals in Walker Alabama, and Walker for rent by owner homes.
Invent singular and another story score in Jasper and specialize holiday rentals in Jasper Alabama.
Glimpse and ferret out Nanafalia United States bed and breakfast rentals and homes for rent by owner Nanafalia.
You can elicit, dig up, and move Jasper Alabama homes for rent by owner and Jasper Alabama rental apartment.
Uncover and find rental homes Lexington United States and bed and breakfast rentals.
Using For Rent By Owner, property managers poll home, villa, and lodge ads.
Disclose, come upon, and uncover vacation homes Section, Section short term rentals, and house rentals Section United States.
Identify and ascertain Vina United States short term rentals and rent house Vina United States.
Braddock condo rentals, apartments for rent in Braddock Virginia, condos for rent Braddock Virginia, and homes for rent by owner Braddock Virginia
Jasper Alabama is a angelic, handsome, superb, and grand state with taking, elegant, and sublime houseboat, home, duplex, and apartments.
|
|
