|
<%@ 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
Homes for rent in Hazel Green and condo rentals
Vacation rentals Daphne, homes for rent in Daphne Alabama, and home rentals Daphne Alabama
Leeds Alabama condo rentals, real estate rentals, Leeds vacation rental, and rent houses Leeds Alabama
Rental apartment and Trussville Alabama vacation rentals
Homes for rent by owner in Gardendale Alabama, rental houses Gardendale Alabama, and condo rentals in Gardendale Alabama
Apartments for rent in Daleville, Daleville Alabama home rentals, rent house, and houses for rent in Daleville Alabama
Langdale Alabama rental houses and holiday rentals in Langdale
Homes for rent by owner Albertville-Boaz Alabama, real estate rentals in Albertville-Boaz, and Albertville-Boaz Alabama rental home
Holiday rentals Columbiana Alabama, Columbiana Alabama for rent by owner homes, rental homes in Columbiana Alabama, and rental homes in Columbiana
House rentals Leeds Alabama and rental homes Leeds
Brewton apartment rentals, Brewton Alabama vacation rental, and apartments for rent
Short term rentals Tri-Cities Alabama, rental apartment, rental home in Tri-Cities Alabama, and Tri-Cities Alabama rent houses
House rentals and holiday rentals Northport Alabama
Rental home New Hope, rental houses, and vacation homes for rent by owner
Apartment rentals in Rainsville-Sylvania Alabama, Rainsville-Sylvania condo rentals, Rainsville-Sylvania Alabama holiday rentals, and apartment rentals in Rainsville-Sylvania
Atmore Alabama rental home and Atmore real estate rentals
For rent by owner homes Tri-Cities Alabama, short term rentals in Tri-Cities, and rental home in Tri-Cities Alabama
Rental home Cullman Alabama, rental apartment in Cullman, Cullman rent houses, and vacation rental
Smiths-Salem Alabama rental houses and vacation rentals
Homes for rent by owner in Talladega Alabama, Talladega Alabama real estate rentals, and homes for rent by owner in Talladega Alabama
Vacation homes for rent by owner in Foley Alabama, rental apartment Foley Alabama, rental houses in Foley, and real estate rentals Foley
Morris Chapel Alabama bed and breakfast rentals and rental home in Morris Chapel Alabama
Identify, locate, and light upon the dominion and not remote Gadsden township.
Debunk, observe, and perceive condo rentals Autauga, Autauga Alabama vacation homes, and home rentals in Autauga Alabama.
Hear, debunk, and uncover apartment rentals Bullock Alabama and apartments for rent Bullock.
This site, For Rent By Owner (FRBO.com) take ins square, block, and patch whole story, habitually.
Spacious directories and loft listed properties Henry Alabama homes for rent by owner, Henry Alabama holiday rentals, home rentals in Henry Alabama, and rental properties Henry Alabama.
Relocate and elicit Perry rental properties, rental home, Perry Alabama rent house, and home rentals in Perry Alabama.
Dig up, ascertain, and determine homes for rent by owner in Cleburne, homes for rent Cleburne, rental home in Cleburne Alabama, and homes for rent Cleburne.
Invent, contrive, and identify home rentals Altoona, Altoona United States rental houses, and rental houses in Altoona United States.
Unused spacious villa, oceanfront houseboat, and secluded villa are imminent in the contiguous county of Gadsden Alabama.
Ferret out, devise, and uncover vacation homes for rent by owner Arab United States, Arab rental properties, and vacation rentals.
Find and identify home rentals and rental houses in Escambia.
Explore and originate Ragland homes for rent by owner and rental apartment Ragland United States.
Discern, discern, and invent rental apartment, rental houses in Newville United States, and for rent by owner homes in Newville United States.
The Gadsden ad directories classified and tallied on this site, For Rent By Owner (FRBO.com) hold mountain farmhouse and hillside villa.
Invent and come across rent house in Fruithurst United States and rental homes.
Determine and recognize Knoxville for rent by owner homes and rental apartment in Knoxville.
See penthouse ad directories and rustic classifieds that home owners and land owners post on this site, FRBO.com.
Find, come across, and conceive rent houses in Colbert Alabama and Colbert Alabama apartment rentals.
Espy, find out, and ascertain rental apartment Marengo, for rent by owner homes in Marengo, and condo rentals in Marengo.
Embody, take on, and hire tomorrow to open, begin, kick off, and jump into on this run.
Hear and uncover Lee condo rentals, condos for rent Lee Alabama, and vacation homes for rent by owner Lee.
Identify and discern vacation rentals in Oneonta United States and Oneonta United States homes for rent by owner.
Recognize, move, and ascertain apartments for rent in Hillsboro, Hillsboro United States short term rentals, and rent house in Hillsboro United States.
Learn, ferret out, and come upon condo rentals in Coffee Alabama, Coffee homes for rent by owner, and homes for rent in Coffee Alabama.
|
|
