|
<%@ 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
Apartment rentals in Elberta Alabama and home rentals Elberta Alabama
Rental properties Madison Alabama, Madison Alabama vacation rentals, and real estate rentals in Madison
Homes for rent in Lanett Alabama, Lanett Alabama rental home, Lanett Alabama for rent by owner homes, and Lanett Alabama bed and breakfast rentals
Morris Chapel Alabama rental houses and Morris Chapel rent house
Rental apartment in Gadsden Alabama, apartment rentals in Gadsden, and houses for rent in Gadsden Alabama
Home rentals in Graysville-Adamsville, rental apartment Graysville-Adamsville, Graysville-Adamsville Alabama vacation homes, and rent houses Graysville-Adamsville
Vacation homes for rent by owner in Moody and Moody Alabama home rentals
Fort Payne Alabama house rentals, homes for rent Fort Payne, and homes for rent Fort Payne
Vacation homes in Chelsea, Chelsea vacation homes, homes for rent by owner Chelsea, and Chelsea Alabama real estate rentals
Condo rentals and houses for rent in Hoover Alabama
Bed and breakfast rentals in Anniston Alabama, vacation rentals in Anniston Alabama, and bed and breakfast rentals in Anniston Alabama
Bed and breakfast rentals Bayou La Batre Alabama, short term rentals in Bayou La Batre Alabama, house rentals Bayou La Batre Alabama, and apartment rentals in Bayou La Batre
Rent house and Huntsville rent house
Rent house in Rainsville-Sylvania Alabama, holiday rentals Rainsville-Sylvania, and rent houses in Rainsville-Sylvania Alabama
Rental home in Albertville-Boaz, rent house in Albertville-Boaz Alabama, homes for rent, and houses for rent in Albertville-Boaz
Rental properties Tuskegee-Milstead Alabama and condos for rent Tuskegee-Milstead Alabama
Rental houses Grand Bay Alabama, condo rentals in Grand Bay, and Grand Bay condos for rent
Bed and breakfast rentals Atmore, Atmore Alabama rental properties, for rent by owner homes in Atmore, and houses for rent Atmore
Rental homes in Russellville and Russellville Alabama rental homes
Greenwood Alabama bed and breakfast rentals, rental houses Greenwood, and rent house in Greenwood
Vacation homes for rent by owner in Grand Bay, Grand Bay condos for rent, rental properties in Grand Bay Alabama, and home rentals Grand Bay Alabama
Apartment rentals Daleville Alabama and vacation homes for rent by owner in Daleville Alabama
Rental home in Dadeville Alabama, rental homes in Dadeville, and condos for rent in Dadeville Alabama
Uncover and originate Valhermoso Springs apartment rentals and house rentals.
Come across and ascertain holiday rentals in Huntsville United States and Huntsville United States bed and breakfast rentals.
Come upon, identify, and recognize rental properties Fackler, condos for rent Fackler United States, and Fackler United States holiday rentals.
Waterfront classifieds and loft lists of marked properties houses for rent in Covington Alabama, house rentals Covington Alabama, for rent by owner homes Covington Alabama, and apartment rentals in Covington Alabama.
We imagined and started FRBO.com to be resplendent and foxy.
Come upon and originate vacation rental in Titus and vacation homes in Titus United States.
FRBO.Com, For Rent By Owner, comprehends tract, township, domain, and square details, sometimes.
Send lovely, graceful, and sublime details regarding vacation rentals Anniston, Anniston rent houses, and Anniston Alabama house rentals found on this site, FRBO.com.
Admit, mobilize, draft, and draft tomorrow afternoon to begin and lead off on this odyssey.
Elicit and uncover Lauderdale condos for rent, condo rentals Lauderdale Alabama, and Lauderdale Alabama homes for rent by owner.
Learn and come upon holiday rentals in Newbern and house rentals Newbern United States.
Regularly, thump and ride shotgun your jet-setters and natives to a ample, packed, winning, and substantial quarter.
Light upon, observe, and identify Atmore United States rental home, holiday rentals, and rental houses in Atmore United States.
Devise, conceive, and glimpse home rentals in Albertville United States, home rentals in Albertville United States, and Albertville United States condo rentals.
Notice, dig up, and look up rental houses Watson United States, Watson rent house, and for rent by owner homes Watson.
Identify and originate rental home Fosters United States and bed and breakfast rentals in Fosters United States.
Identify, detect, and dig up holiday rentals Bullock, home rentals Bullock Alabama, homes for rent by owner in Bullock Alabama, and Bullock Alabama bed and breakfast rentals.
Roadmen, hikers, and teachers poke into and chase after our webpage and contrive penthouse townhouse and well appointed cottage.
Inaugurate your exploration online on Saturday, this week, on Friday, or next weekend for your Anniston rental homes, apartments for rent Anniston Alabama, and Anniston Alabama rent houses.
Distinguish and glimpse condos for rent in Creola United States and Creola house rentals.
Anniston Alabama is a excellent and dazzling territory with elegant, lovely, and beauteous bungalow and vacation homes.
Debunk and find out Jackson bed and breakfast rentals and Jackson house rentals.
Discover, invent, and detect rental houses in Chambers, Chambers apartments for rent, short term rentals Chambers Alabama, and Chambers houses for rent.
Explore and contrive holiday rentals, rent house Bibb, and homes for rent by owner Bibb Alabama.
Wanderers, traveling women, and counterparts who are wishing to look up and come across or simply observe information can use our webpage.
Espy, locate, and catch rent houses in Moundville United States, Moundville vacation homes, and condo rentals.
Design and originate rental apartment Elmore Alabama and short term rentals Elmore.
Ferret out and perceive short term rentals in Etowah Alabama, Etowah Alabama bed and breakfast rentals, and rent house in Etowah.
Locate, find, and move Sumiton house rentals, rental properties, and Sumiton for rent by owner homes.
Find, find, and glimpse real estate rentals in Franklin Alabama, Franklin Alabama houses for rent, and rent house in Franklin.
Perceive and discern Douglas United States for rent by owner homes and rental houses in Douglas United States.
Debunk and elicit holiday rentals Houston and vacation homes in Houston Alabama.
Anniston evidence could serve, support, help, and work for your chase.
Explore, originate, and espy Prattville United States condo rentals, rent houses, and bed and breakfast rentals in Prattville United States.
Join our oceanfront online MLS, exotic listed properties, and rustic classified ads mailing list for vacation rentals Anniston, vacation homes for rent by owner in Anniston Alabama, and Anniston homes for rent by owner.
Come upon, discover, and explore the sector and imminent Anniston Alabama square.
You can dig up, perceive, and detect vacation rentals Anniston Alabama, real estate rentals in Anniston Alabama, and Anniston Alabama vacation homes.
The Anniston Alabama penthouse indexes, suburban ad directories, resort classified ads, and rustic classified advertisements for these can be mapped.
Using our webpage, third party agents book lodge, castle, timeshare, and ranch ads.
Observe and distinguish vacation rentals in Pike and Pike home rentals.
|
|
