|
<%@ 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
Tuskegee-Milstead Alabama rental homes and apartments for rent in Tuskegee-Milstead Alabama
Hoover Alabama real estate rentals, vacation homes in Hoover Alabama, and rent houses Hoover Alabama
Short term rentals Demopolis Alabama, apartments for rent Demopolis, real estate rentals in Demopolis Alabama, and apartment rentals
Houses for rent in New Market and New Market Alabama bed and breakfast rentals
Prattville Alabama short term rentals, vacation homes for rent by owner in Prattville Alabama, and Prattville Alabama rental properties
For rent by owner homes in Prattville Alabama, condo rentals in Prattville Alabama, rental home in Prattville Alabama, and Prattville Alabama rental houses
Bed and breakfast rentals New Hope and New Hope Alabama apartments for rent
Huntsville house rentals, rental properties, and apartments for rent in Huntsville
Vacation rental in Jasper, rental apartment in Jasper, rental apartment in Jasper, and rental home in Jasper
Anniston Alabama short term rentals and rental properties in Anniston Alabama
Apartment rentals in Alabaster-Helena Alabama, Alabaster-Helena Alabama rental homes, and condo rentals in Alabaster-Helena
Rental apartment in Tanner-Williams, Tanner-Williams rent houses, apartments for rent in Tanner-Williams Alabama, and short term rentals in Tanner-Williams
Fairhope Alabama rental apartment and rental home
Homes for rent by owner in Roanoke, bed and breakfast rentals in Roanoke, and homes for rent Roanoke
Sylacauga Alabama homes for rent, homes for rent in Sylacauga, Sylacauga vacation homes, and condos for rent in Sylacauga
Disclose, perceive, and relocate vacation homes Fort Deposit United States, home rentals in Fort Deposit United States, and houses for rent in Fort Deposit United States.
Catch sundry and discrete dossier in Jemison and register home rentals.
Devise, uncover, and move Roanoke condo rentals, homes for rent by owner in Roanoke United States, and Roanoke houses for rent.
You can notice and contrive condos for rent Jemison Alabama, Jemison condo rentals, and Jemison houses for rent.
Perceive and perceive holiday rentals in Dale Alabama and Dale Alabama short term rentals.
Dig up, explore, and come across Wadley condos for rent, Wadley United States bed and breakfast rentals, and house rentals in Wadley United States.
Uncover and discover real estate rentals in Montgomery and condos for rent Montgomery Alabama.
Learn and dig up Vernon United States vacation rental and Vernon United States bed and breakfast rentals.
Contrive and disclose the area and adjoining Jemison Alabama vicinity.
Elicit, light upon, and glimpse holiday rentals and Houston apartments for rent.
Design and elicit vacation rental in Tallassee United States and Tallassee United States short term rentals.
Indwellers, excursionists, and wanderers who are hunting for homes for rent by owner in Jemison Alabama and are trying to find out rental apartment in Jemison and Jemison Alabama houses for rent can seek our for rent by owner site, FRBO.com and our loft ads, beach classified ads, and resort classifieds.
Distinguish and glimpse Mobile United States rental apartment and Mobile United States real estate rentals.
Notice and locate rental houses in Coosa Alabama, Coosa Alabama vacation homes, and Coosa Alabama rental homes.
This extensive website, FRBO.com can draft, join up, conscribe, and register beach classified ads, lake directories, and romantic indexes loft directories and lakeside classified advertisements to collaborate your Jemison tramp.
Identify, distinguish, and glimpse rent houses in Brierfield United States, vacation homes in Brierfield United States, and Brierfield United States rental houses.
Log advertisements and penthouse classified advertisements rental apartment Wilcox, condo rentals in Wilcox, holiday rentals in Wilcox, and house rentals Wilcox Alabama.
Debunk and explore Catherine United States rental apartment and rental home.
Using our website, FRBO.com, landlords manifest house and bungalow listed properties.
The Jemison listed properties billed and buttoned down on this webpage have ski in/out house, ski in/out houseboat, mountain flat, and waterfront apartment.
Conceive, debunk, and identify apartments for rent Perry, Perry Alabama rental homes, and for rent by owner homes in Perry.
|
|
