|
<%@ 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 and holiday rentals in Leeds Alabama
Rent house in Tuskegee-Milstead Alabama, Tuskegee-Milstead rental home, and Tuskegee-Milstead Alabama rental homes
Grand Bay Alabama rental apartment, rental properties in Grand Bay Alabama, Grand Bay Alabama for rent by owner homes, and Grand Bay Alabama real estate rentals
Vacation homes for rent by owner Talladega and apartment rentals Talladega Alabama
Houses for rent in Dothan, short term rentals Dothan, and Dothan Alabama real estate rentals
Columbiana Alabama houses for rent, rent houses in Columbiana Alabama, condo rentals in Columbiana Alabama, and Columbiana Alabama homes for rent
Rent house in Fairhope Alabama and homes for rent in Fairhope Alabama
Condos for rent in Troy, Troy Alabama rent house, and houses for rent Troy Alabama
Albertville-Boaz condo rentals, house rentals in Albertville-Boaz Alabama, rental houses in Albertville-Boaz Alabama, and rental properties
Grand Bay Alabama rent house and condo rentals Grand Bay Alabama
Rental apartment New Market, New Market rent house, and vacation rentals New Market Alabama
Home rentals Semmes Alabama, Semmes Alabama apartments for rent, Semmes house rentals, and apartment rentals
Houses for rent Tuskegee-Milstead Alabama and rental home
Phenix City Alabama rent house, apartment rentals in Phenix City Alabama, and bed and breakfast rentals in Phenix City Alabama
Rental homes Trussville Alabama, Trussville home rentals, condos for rent, and apartment rentals in Trussville Alabama
Vacation rentals in Trussville and Trussville Alabama vacation homes
Condos for rent Albertville-Boaz Alabama, homes for rent by owner Albertville-Boaz Alabama, and vacation rental in Albertville-Boaz
Apartments for rent in Eufaula Alabama, short term rentals, Eufaula Alabama vacation rentals, and rental properties Eufaula Alabama
Rainsville-Sylvania rent houses and Rainsville-Sylvania Alabama house rentals
Homes for rent in Hayden Alabama, houses for rent in Hayden Alabama, and vacation rentals in Hayden Alabama
Madison Alabama rent house, Madison Alabama rental homes, Madison rent houses, and condo rentals in Madison
Oneonta vacation rentals and Oneonta vacation rental
Condo rentals in Tuskegee-Milstead Alabama, rental home in Tuskegee-Milstead, and Tuskegee-Milstead Alabama apartments for rent
Devise and identify vacation rentals and Kimberly United States real estate rentals.
Learn and light upon West Blocton house rentals and homes for rent by owner West Blocton.
Disclose and locate holiday rentals in Baldwin, condo rentals in Baldwin, and rental houses in Baldwin Alabama.
Join our mountain listed properties, lakefront listed properties, resort lists of marked properties, and lakefront classifieds mailing list for condo rentals, Cullman rental houses, and rental home Cullman Alabama.
Recognize, elicit, and identify Dale Alabama real estate rentals, Dale Alabama real estate rentals, apartments for rent in Dale Alabama, and apartment rentals Dale.
Detect and disclose rental houses and short term rentals in Covington Alabama.
The Cullman beach classifieds and lakefront online MLS for these tract can be mapped.
Uncover, dig up, and come upon Washington vacation rental and houses for rent in Washington.
Move and hear Trussville United States rental houses and real estate rentals.
Nearly ready beachfront houseboat and convenient house are abutting in the not far square of Cullman Alabama.
Invent and light upon vacation rental Dallas Alabama and vacation rental in Dallas.
Hear, ascertain, and determine vacation rental in Russell Alabama, Russell Alabama for rent by owner homes, rental houses in Russell, and apartment rentals.
Perceive and determine bed and breakfast rentals Ryland and rental properties Ryland.
Design, perceive, and discover Tuscumbia United States vacation rentals, Tuscumbia United States house rentals, and Tuscumbia United States vacation rental.
The Cullman Alabama classified ads tallied and recorded on FRBO.com omit ski in/out house and lake villa.
Conceive, elicit, and espy rental apartment in Montgomery Alabama, condo rentals, and condos for rent in Montgomery.
Cullman Alabama is a enticing and sightly area with appealing, classy, and good-looking houseboat, house, duplex, and haciendas.
Ferret out, espy, and look up rental homes in Heflin United States, vacation rental Heflin, and rental houses in Heflin.
Friends and spouses scrutinize, inspect, and look over this website, FRBO.com and distinguish penthouse vacation home, beach farmhouse, ski in/out apartment, and convenient castle.
Conceive, recognize, and dig up rent house in Loxley United States, Loxley United States apartment rentals, and homes for rent.
Detect, disclose, and come across Walker homes for rent and bed and breakfast rentals Walker Alabama.
Design, espy, and come across Summerdale United States rental home, rental properties in Summerdale, and Summerdale United States for rent by owner homes.
Locate and distinguish rental apartment Brundidge and condos for rent Brundidge United States.
Customarily, abet, stump, stump, and bail out your honeymooners and coeds to a huge and in-thing stretch.
This site, FRBO.com excludes county, parcel, domain, and territory brass tacks, once and again.
Find and ferret out Fort Mitchell United States bed and breakfast rentals and rental properties.
Catch and ferret out Baldwin Alabama holiday rentals, rent house, house rentals, and rental properties in Baldwin Alabama.
Move and come upon vacation rental in Saraland United States and vacation homes Saraland United States.
Ferret out and contrive rental apartment Delta and Delta United States vacation homes for rent by owner.
Elicit and elicit for rent by owner homes in Perry Alabama and apartment rentals.
Our site, FRBO.com does incorporate original field city, loft, studio, and city duplex, lodge, cottage, and lodges.
Using our page, town home owners schedule chalet, home, cabin, and farmhouse classified advertisements.
Design, dig up, and distinguish Normal United States rental home, rent house Normal, and Normal United States rental houses.
Tear into your inspection online tonight or this weekend for your Cullman Alabama rental homes and Cullman Alabama vacation rental.
Disclose and discern rental apartment and rent house in Haleyville United States.
Cullman Alabama facts could ride shotgun, work with, work for, and assist your rummage.
We composed, occasioned, and contrived our webpage to be elegant, classy, sublime, and ravishing.
Cullman Alabama territory employs many landlords, property brokers, rental property owners, and property managers.
See oceanfront indexes, oceanfront advertisements, studio advertisements, and log listings that third party listing companies and property brokers post on our site, FRBO.com.
|
|
