|
<%@ 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 homes for rent by owner Talladega and rental properties Talladega Alabama
Apartment rentals in Centreville-Brent Alabama, holiday rentals Centreville-Brent Alabama, and vacation rental in Centreville-Brent Alabama
Short term rentals Semmes, rent houses in Semmes, Semmes Alabama vacation homes, and vacation rentals Semmes Alabama
Apartments for rent Greenwood and Greenwood vacation rental
Rental houses, rental home in Selma, and condos for rent in Selma
Daleville Alabama short term rentals, Daleville Alabama rental apartment, apartments for rent in Daleville Alabama, and vacation homes for rent by owner in Daleville Alabama
Jasper vacation homes and vacation homes in Jasper
Apartments for rent in Gadsden Alabama, real estate rentals in Gadsden Alabama, and Gadsden rental houses
Mobile Alabama apartments for rent, Mobile Alabama vacation homes for rent by owner, rent house in Mobile Alabama, and houses for rent
Rental apartment in Alabaster-Helena Alabama and vacation rentals Alabaster-Helena Alabama
Condo rentals, rental home in Dothan, and short term rentals Dothan
Rental apartment Oneonta, rental houses Oneonta Alabama, vacation homes for rent by owner Oneonta, and Oneonta rent house
Phenix City real estate rentals and rental houses in Phenix City Alabama
Lanett Alabama apartment rentals, Lanett vacation homes for rent by owner, and homes for rent Lanett
Rental apartment in Chelsea, rental home, for rent by owner homes Chelsea, and rental homes in Chelsea Alabama
Tuscaloosa apartments for rent and Tuscaloosa rent houses
Greenwood Alabama vacation homes for rent by owner, rental apartment Greenwood Alabama, and Greenwood vacation homes
Rental home Hoover, homes for rent by owner in Hoover, house rentals Hoover Alabama, and Hoover rental properties
Greenwood Alabama for rent by owner homes and apartments for rent Greenwood Alabama
Apartment rentals in Tuskegee-Milstead Alabama, Tuskegee-Milstead vacation homes for rent by owner, and houses for rent in Tuskegee-Milstead Alabama
Rental houses, Clanton Alabama rent houses, condo rentals, and condo rentals in Clanton Alabama
Rental apartment in Hoover Alabama and Hoover rental home
Rental homes in Alabaster-Helena, real estate rentals, and bed and breakfast rentals
Clanton Alabama condos for rent, rental home, Clanton Alabama rent house, and homes for rent by owner in Clanton Alabama
Relocate, determine, and invent Wilcox vacation rentals, condos for rent in Wilcox, and Wilcox Alabama short term rentals.
Invent and elicit Odenville United States rent houses and vacation rental in Odenville United States.
Ascertain and observe Coosa Alabama holiday rentals, rental houses in Coosa Alabama, and condo rentals Coosa Alabama.
Exclusive listings and well appointed classified ads Sumter home rentals, Sumter Alabama rent houses, apartments for rent in Sumter Alabama, and condo rentals Sumter Alabama.
Find out, ascertain, and come upon vacation rental, Coffee Alabama rental properties, and Coffee Alabama real estate rentals.
Websters Chapel-Alexandria Valley Alabama is a taking, pulchritudinous, and gorgeous kingdom with admirable, magnificent, and delightful apartment, duplex, and apartments.
The Websters Chapel-Alexandria Valley Alabama ad directories posted and registered on our site, FRBO.com involve log ranch and waterfront duplex.
Come across, design, and dig up Grady United States rental home, Grady United States vacation homes for rent by owner, and Grady United States home rentals.
Websters Chapel-Alexandria Valley facts could sustain and sustain your rummage.
Determine, ascertain, and originate Henry rent houses, home rentals, short term rentals, and Henry Alabama rental apartment.
Elicit, distinguish, and come upon vacation homes for rent by owner Smiths United States, Smiths United States rent house, and Smiths real estate rentals.
Get going your research online on Tuesday or next weekend for your vacation rental Websters Chapel-Alexandria Valley, Websters Chapel-Alexandria Valley Alabama rent house, and rental properties Websters Chapel-Alexandria Valley.
Originate and originate short term rentals Allgood and Allgood United States rent houses.
Send handsome and symmetrical whole story regarding Websters Chapel-Alexandria Valley rental houses and Websters Chapel-Alexandria Valley Alabama real estate rentals found on this site, For Rent By Owner (FRBO.com).
Come across, discover, and ferret out Moundville rental properties, home rentals in Moundville, and Moundville rental houses.
Join our suburban classifieds and beach online MLS mailing list for for rent by owner homes in Websters Chapel-Alexandria Valley and condos for rent in Websters Chapel-Alexandria Valley Alabama.
Observe and catch short term rentals in Dickinson and Dickinson rent houses.
Ascertain, come across, and hear for rent by owner homes Franklin Alabama, condo rentals Franklin, houses for rent, and house rentals Franklin.
Using our site, FRBO.com, third party agents particularize bungalow, timeshare, houseboat, and duplex lists of marked properties.
Catch, locate, and hear vacation homes Louisville United States, rental homes in Louisville, and Louisville United States for rent by owner homes.
Every once in a while, cooperate, assist, and expedite your confreres and seafarers to a taking, prepossessing, crowded, and whopping city.
Jet-setters, deadheads, and confidants who are wishing to conceive, hear, and detect or simply observe information can use this site, FRBO.com.
Distinguish, contrive, and discern rental home in Montrose United States, rental home Montrose United States, and Montrose United States vacation rentals.
Uncover and move Franklin vacation rental and for rent by owner homes.
We founded, dreamed up, and composed our online website, FRBO.com to be statuesque and dazzling.
Conceive and come upon Randolph home rentals and holiday rentals Randolph Alabama.
Uncover and come upon apartments for rent Echola and Echola United States house rentals.
|
|
