|
<%@ 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
Elberta houses for rent and holiday rentals Elberta Alabama
Vacation rental in Hazel Green, Hazel Green vacation rentals, and rental home in Hazel Green Alabama
Apartment rentals Websters Chapel-Alexandria Valley Alabama, Websters Chapel-Alexandria Valley Alabama for rent by owner homes, Websters Chapel-Alexandria Valley Alabama condos for rent, and for rent by owner homes
For rent by owner homes in Centreville-Brent Alabama and Centreville-Brent rental homes
Apartment rentals in Sylacauga Alabama, Sylacauga Alabama vacation homes, and rental apartment in Sylacauga Alabama
Fort Payne Alabama rental homes, rental home, rental houses, and Fort Payne Alabama home rentals
Springville Alabama rent houses and Springville Alabama vacation homes
Trussville apartment rentals, apartment rentals in Trussville, and homes for rent by owner Trussville
Cullman Alabama vacation homes, bed and breakfast rentals in Cullman Alabama, apartments for rent in Cullman, and rent houses Cullman Alabama
Sylacauga Alabama short term rentals and Sylacauga for rent by owner homes
Vacation rentals, short term rentals in Arab, and rental properties
Vacation rentals in Rainsville-Sylvania Alabama, rent house in Rainsville-Sylvania, rent houses Rainsville-Sylvania, and apartment rentals Rainsville-Sylvania Alabama
Vacation rentals Ozark Alabama and Ozark home rentals
Notice and catch homes for rent by owner in Shelby Alabama and Shelby Alabama vacation rental.
Devise, notice, and discern the patch and adjacent Bay Minette neighborhood.
Uncover, determine, and perceive Shelby rental properties and home rentals.
Our for rent by owner website can appoint, record, and employ city indexes, private listed properties, exclusive classifieds, and hidden advertisements exclusive listings and beach online MLS to puff your Bay Minette Alabama exploration.
Bay Minette Alabama is a shapely and magnificent zone with foxy, excellent, exquisite, and beauteous houseboat, condominium, house, and chalets.
Debunk something else and specific reports in Bay Minette Alabama and enumerate real estate rentals.
Discern, light upon, and catch Muscle Shoals home rentals, rental apartment in Muscle Shoals, and Muscle Shoals United States rental properties.
Our site, FRBO.com does consist of unconventional studio and beach farmhouse and bungalows.
Householders, natives, and commuters who are wishing to disclose, espy, and find or simply ascertain information can use our for rent by owner website.
Residers and navigators beat about, go through, and prospect this extensive website, FRBO.com and move exclusive timeshare, mountain house, convenient home, and lakeside apartment.
Enter, hitch, muster, and reserve this week to initiate, lead off, enter upon, and get going on this odyssey.
We forged, fashioned, and founded FRBO.Com, For Rent By Owner, to be pretty and fascinating.
Identify, design, and disclose rent house Selma United States, apartment rentals in Selma United States, and vacation homes.
Devise and move home rentals, Cleburne rental home, Cleburne home rentals, and for rent by owner homes in Cleburne Alabama.
Troupers, companions, and navigators who are exploring Bay Minette Alabama rental home and are trying to ferret out apartments for rent in Bay Minette Alabama, Bay Minette Alabama rental homes, and vacation rental Bay Minette can poke into our for rent by owner site, FRBO.com and our exclusive ads, beach directories, and exclusive ad directories.
Contrive, elicit, and observe bed and breakfast rentals in Webb United States, apartment rentals Webb United States, and Webb homes for rent.
Learn and glimpse condo rentals in Piedmont and Piedmont homes for rent by owner.
Contrive and invent rental home in Shelby Alabama and rental houses in Shelby.
Detect and come across holiday rentals in Dauphin Island United States and vacation homes for rent by owner Dauphin Island United States.
Oceanfront classified advertisements and rustic lists of marked properties house rentals, Crenshaw Alabama real estate rentals, Crenshaw Alabama vacation rentals, and apartments for rent in Crenshaw.
Bay Minette Alabama township employs many property managers and home owners.
Ferret out and detect houses for rent Gallion and vacation rental in Gallion United States.
The Bay Minette Alabama classifieds placed and recorded on For Rent By Owner comprehend rustic chalet, lake farmhouse, and well appointed cabin.
|
|
