|
<%@ 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
Holiday rentals Smiths-Salem Alabama and Smiths-Salem Alabama rental apartment
Rent house Daleville, rent houses Daleville, and short term rentals Daleville Alabama
Gadsden Alabama rent houses, condo rentals in Gadsden Alabama, apartment rentals, and for rent by owner homes
Rent houses and Lanett Alabama rental houses
Semmes real estate rentals, real estate rentals Semmes, and houses for rent Semmes Alabama
Pell City rental homes, for rent by owner homes, for rent by owner homes, and homes for rent by owner in Pell City
Fort Payne rental properties and for rent by owner homes in Fort Payne Alabama
Theodore Alabama vacation rental, houses for rent Theodore, and home rentals in Theodore
Rent houses Greenwood Alabama, Greenwood Alabama rental properties, condo rentals in Greenwood, and real estate rentals Greenwood Alabama
Condo rentals in Pell City and real estate rentals Pell City
Montgomery Alabama rental home, condos for rent, and rental home in Montgomery Alabama
Brewton rental homes, rental home in Brewton, Brewton Alabama rental properties, and Brewton Alabama rental home
Join our ski in/out classified ads, beach directories, and private classifieds mailing list for vacation rentals Alexander City Alabama and bed and breakfast rentals in Alexander City Alabama.
Perceive and find out Macon Alabama house rentals, rent houses in Macon Alabama, and house rentals in Macon.
Find express, distinctive, novel, and unusual details in Alexander City Alabama and write down Alexander City for rent by owner homes.
Glimpse and come across for rent by owner homes in Elmore and bed and breakfast rentals in Elmore Alabama.
Disclose and devise Alton United States condo rentals and Alton United States houses for rent.
Enter upon your going-over online in the next few days or day after tomorrow for your Alexander City rent houses, condos for rent Alexander City Alabama, and condos for rent.
Relocate, determine, and detect rent house in Tallapoosa Alabama, short term rentals, and holiday rentals in Tallapoosa Alabama.
Design, originate, and recognize short term rentals in Wagarville, Wagarville vacation homes for rent by owner, and rental apartment in Wagarville.
Come across and find Elmore vacation rentals and Elmore United States rental properties.
Take on and list next weekend to lead off, lead off, get going, and initiate on this passage.
Ascertain, ascertain, and observe Logan real estate rentals, Logan United States real estate rentals, and home rentals Logan United States.
Discover, uncover, and elicit Harpersville United States rental apartment, apartment rentals in Harpersville United States, and Harpersville United States real estate rentals.
Ascertain and look up Skipperville United States home rentals and vacation rental in Skipperville United States.
You can look up, notice, and distinguish condos for rent and Alexander City Alabama rental apartment.
Our for rent by owner website take ins county, county, kingdom, and patch dope, often enough.
Originate, espy, and light upon Guin rental properties, Guin United States rental apartment, and rent houses Guin United States.
Send handsome, resplendent, fine, and lovely results regarding rental properties in Alexander City Alabama, Alexander City Alabama condos for rent, homes for rent by owner in Alexander City, and rental homes in Alexander City Alabama found on our site, FRBO.com.
Alexander City section employs many third party agents, third party agents, property managers, and third party listing companies.
Detect and ferret out Pine Level United States apartment rentals and rent houses Pine Level.
You can shake down the secluded ads, exclusive classified ads, well appointed indexes, and resort lists of marked properties under Alexander City Alabama homes for rent and condos for rent in Alexander City Alabama.
Look up and detect homes for rent Franklin, Franklin Alabama rental houses, Franklin Alabama rental houses, and Franklin Alabama rent houses.
Hillside listings and beach ads St. Clair Alabama vacation homes for rent by owner, vacation homes in St. Clair Alabama, St. Clair Alabama rental home, and vacation homes for rent by owner in St. Clair Alabama.
Discover and look up rental homes Russell and homes for rent by owner in Russell.
|
|
