|
<%@ 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
Bay Minette short term rentals and houses for rent
Vacation homes for rent by owner in Daphne Alabama, rental home in Daphne, and for rent by owner homes in Daphne Alabama
Rental home Leeds, real estate rentals, Leeds Alabama for rent by owner homes, and vacation homes for rent by owner in Leeds
Rental apartment in Tri-Cities Alabama and Tri-Cities Alabama rental houses
Wetumpka rental homes, for rent by owner homes in Wetumpka, and rental properties Wetumpka
Trussville Alabama homes for rent, Trussville Alabama rental home, holiday rentals in Trussville Alabama, and short term rentals Trussville Alabama
Vacation rentals in Cullman Alabama and Cullman house rentals
Greenville Alabama apartment rentals, rental homes in Greenville Alabama, and Greenville Alabama rent house
Apartments for rent in Tanner-Williams Alabama, rent house, Tanner-Williams Alabama vacation rentals, and house rentals in Tanner-Williams Alabama
Athens Alabama rent house and homes for rent Athens
Alabaster-Helena Alabama real estate rentals, rental houses Alabaster-Helena Alabama, and apartments for rent in Alabaster-Helena Alabama
Vacation homes for rent by owner Jemison Alabama, holiday rentals in Jemison Alabama, Jemison Alabama houses for rent, and Jemison apartment rentals
Eufaula Alabama short term rentals and vacation homes in Eufaula Alabama
Graysville-Adamsville Alabama rental properties, Graysville-Adamsville condo rentals, and homes for rent by owner Graysville-Adamsville
Wetumpka Alabama for rent by owner homes, rental apartment in Wetumpka, house rentals in Wetumpka Alabama, and Wetumpka rental home
Holiday rentals in Phenix City Alabama and Phenix City rental home
Langdale real estate rentals, Langdale Alabama rental home, and rent houses Langdale Alabama
Graysville-Adamsville Alabama for rent by owner homes, homes for rent in Graysville-Adamsville, vacation rental in Graysville-Adamsville Alabama, and houses for rent in Graysville-Adamsville Alabama
Rental homes in Montgomery Alabama and vacation homes for rent by owner in Montgomery
Hoover patch employs many real estate agents, rental property owners, property brokers, and property owners.
Dig up and espy Winston Alabama houses for rent and homes for rent by owner in Winston Alabama.
Acquaintances, co-workers, and traveling salesmen who are rooting house rentals and are trying to ascertain houses for rent in Hoover, Hoover Alabama apartment rentals, and Hoover rental homes can rake this site, FRBO.com and our resort classified ads, suburban ads, and romantic classified advertisements.
Explore and identify Winston Alabama vacation rental, rent houses in Winston Alabama, Winston Alabama apartment rentals, and holiday rentals in Winston.
Hoover real estate brokers, property agents, and real estate agents list homes for rent Hoover Alabama and homes for rent Hoover Alabama.
Mountain classified ads and loft classified advertisements Calhoun house rentals, vacation homes in Calhoun Alabama, for rent by owner homes Calhoun Alabama, and short term rentals in Calhoun.
Invent, relocate, and conceive Childersburg short term rentals, for rent by owner homes, and rent house in Childersburg United States.
Send superb, alluring, and appealing materials regarding condo rentals in Hoover, rent house Hoover, and vacation rentals Hoover Alabama found on this webpage.
The Hoover beachfront listed properties, beach classified ads, well appointed ads, and city advertisements for these can be mapped.
Find out and invent Lawrence Alabama bed and breakfast rentals, rental houses Lawrence Alabama, and vacation homes for rent by owner Lawrence Alabama.
Discern and devise Bon Secour United States house rentals and Bon Secour United States real estate rentals.
You can recognize and disclose apartments for rent Hoover Alabama and Hoover Alabama vacation rentals.
Come upon and ferret out Macon Alabama rent houses and Macon condo rentals.
Determine unconventional, another story, and individual info in Hoover and spell out short term rentals in Hoover.
Hear, move, and ferret out home rentals and vacation rental in Colbert Alabama.
Move, locate, and look up vacation homes in Atmore, short term rentals, and Atmore United States houses for rent.
Catch, dig up, and uncover rental houses in Somerville United States, Somerville condo rentals, and Somerville United States holiday rentals.
Move, recognize, and disclose vacation homes for rent by owner, apartments for rent in Deer Park, and vacation rental in Deer Park United States.
Look up, ascertain, and discover home rentals in Fayette, apartment rentals in Fayette Alabama, and short term rentals.
Our page does enclose individual zone beachfront, oceanfront, and studio vacation home, houseboat, and townhouses.
|
|
