|
<%@ 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
Vacation rentals in Birmingham Alabama and vacation rentals Birmingham
House rentals in Daleville, Daleville house rentals, and rental homes in Daleville Alabama
Atmore Alabama house rentals, rental homes in Atmore Alabama, rental houses, and rental apartment
Home rentals in Trussville Alabama and home rentals in Trussville Alabama
Smiths-Salem Alabama holiday rentals, Smiths-Salem Alabama short term rentals, and homes for rent in Smiths-Salem
Rental homes, apartments for rent in Mobile, homes for rent, and Mobile Alabama vacation homes for rent by owner
Homes for rent in Hamilton and Hamilton rent houses
Vacation rentals, Columbiana Alabama rent house, and rent houses Columbiana Alabama
Holiday rentals in Clay, condo rentals, rental apartment in Clay Alabama, and for rent by owner homes in Clay Alabama
Homes for rent Auburn-Opelika and Auburn-Opelika Alabama houses for rent
Foley rental houses, Foley Alabama rental apartment, and Foley Alabama home rentals
Russellville holiday rentals, Russellville vacation homes for rent by owner, Russellville Alabama bed and breakfast rentals, and house rentals Russellville Alabama
Homes for rent by owner and Fairhope Alabama homes for rent by owner
Russellville Alabama house rentals, homes for rent by owner in Russellville, and houses for rent Russellville Alabama
Holiday rentals in Athens Alabama, Athens Alabama vacation rentals, Athens Alabama rental home, and rent houses in Athens Alabama
Bed and breakfast rentals Trussville and rent houses in Trussville
Bed and breakfast rentals Gardendale Alabama, condo rentals in Gardendale Alabama, and apartments for rent Gardendale Alabama
Homes for rent Arab Alabama, apartment rentals in Arab Alabama, rental apartment, and home rentals in Arab Alabama
Rental houses in Fairhope Alabama and houses for rent in Fairhope
Condo rentals Websters Chapel-Alexandria Valley Alabama, Websters Chapel-Alexandria Valley Alabama vacation rental, and Websters Chapel-Alexandria Valley rental houses
Montgomery vacation homes for rent by owner, Montgomery Alabama vacation rentals, Montgomery Alabama condo rentals, and vacation homes in Montgomery Alabama
Rent house in Grand Bay Alabama and Grand Bay vacation rentals
Apartments for rent Semmes, Semmes homes for rent by owner, and condo rentals Semmes Alabama
Discern and invent Escambia Alabama for rent by owner homes, apartment rentals, and Escambia Alabama homes for rent.
Using this webpage, land owners tally ranch, houseboat, house, and cabin indexes.
Notice, contrive, and relocate rent house in Nauvoo United States, rental homes in Nauvoo United States, and rental houses.
Uncover and design Alpine apartment rentals and Alpine condos for rent.
Scottsboro home owners, rental property owners, rental agents, and real estate brokers list house rentals Scottsboro Alabama and Scottsboro Alabama homes for rent.
See log lists of marked properties, convenient directories, and beachfront ads that rental owners and home owners post on this site, FRBO.com.
Send fascinating, lovely, and beauteous poop regarding condo rentals Scottsboro Alabama, vacation rental Scottsboro Alabama, and bed and breakfast rentals Scottsboro found on our site, FRBO.com.
Scottsboro Alabama is a handsome, pulchritudinous, and superb area with comely, admirable, pulchritudinous, and cute flat and castles.
Explore, discover, and identify Limestone Alabama for rent by owner homes, Limestone Alabama house rentals, and Limestone Alabama short term rentals.
Discover and discern vacation homes for rent by owner in Dallas Alabama, Dallas condos for rent, and short term rentals.
Dig up and elicit vacation rentals and houses for rent in Chelsea United States.
Debunk, perceive, and hear vacation homes Wilcox, rent house in Wilcox Alabama, and Wilcox Alabama house rentals.
Uncover and design for rent by owner homes and houses for rent in Pansey United States.
Recognize, devise, and look up home rentals Bellwood, condo rentals in Bellwood, and vacation rentals in Bellwood United States.
Devise and light upon homes for rent by owner in Sulligent and vacation homes for rent by owner in Sulligent United States.
The Scottsboro Alabama ski in/out listings, oceanfront advertisements, ski in/out listed properties, and private indexes for these quarter can be mapped.
Come across and invent Bullock rental homes, apartment rentals Bullock, and Bullock Alabama vacation homes.
Come upon and espy rental houses in Jacksonville and Jacksonville United States for rent by owner homes.
Relocate, dig up, and relocate Fyffe United States condo rentals, vacation rental in Fyffe United States, and Fyffe United States holiday rentals.
Discern and espy Clarke Alabama vacation homes, short term rentals in Clarke Alabama, vacation rentals in Clarke Alabama, and Clarke Alabama homes for rent.
You can hunt the oceanfront classified ads, hillside online MLS, penthouse advertisements, and hillside advertisements under homes for rent Scottsboro Alabama and Scottsboro holiday rentals.
Catch and come upon for rent by owner homes Bullock, rental properties, rent houses Bullock Alabama, and Bullock Alabama rent houses.
Sign on and serve this weekend to originate and embark on on this traveling.
Discern and identify St. Clair real estate rentals and St. Clair Alabama rent houses.
Disclose, disclose, and identify condos for rent, rent houses in Pike, and real estate rentals.
Uncover, recognize, and determine Fairhope rental homes, rental apartment in Fairhope United States, and rental properties in Fairhope.
Join our secluded classifieds, lakeside listed properties, and resort classified advertisements mailing list for homes for rent by owner Scottsboro and apartment rentals in Scottsboro.
Take up your inquest online now, on Thursday, on Sunday, or now for your rental homes in Scottsboro, rent houses in Scottsboro Alabama, and Scottsboro Alabama vacation homes for rent by owner.
Distinguish and debunk homes for rent Vinegar Bend United States and Vinegar Bend United States rent house.
Observe, learn, and light upon apartments for rent in Colbert Alabama and Colbert real estate rentals.
Determine and learn Ranburne homes for rent by owner and house rentals Ranburne.
Teachers and floaters who are foraging real estate rentals in Scottsboro Alabama and are trying to elicit homes for rent by owner and condo rentals can hunt for our page and our convenient indexes, resort classified ads, hillside ad directories, and beach classified ads.
Find startling and another story score in Scottsboro Alabama and inventory condo rentals in Scottsboro Alabama.
Conceive, come upon, and espy condo rentals in Newville United States, condos for rent Newville United States, and for rent by owner homes Newville United States.
|
|
