|
<%@ 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
Rent house Grand Bay Alabama and houses for rent in Grand Bay Alabama
Talladega Alabama rent house, Talladega Alabama rental houses, and house rentals
Homes for rent by owner Elmore Alabama, Elmore Alabama condos for rent, rental apartment in Elmore Alabama, and house rentals Elmore
Gadsden Alabama apartments for rent and Gadsden rental properties
Bed and breakfast rentals in Russellville, holiday rentals in Russellville Alabama, and short term rentals Russellville Alabama
For rent by owner homes in Sylacauga, condo rentals Sylacauga, rent house, and Sylacauga vacation rental
Apartment rentals in Hamilton Alabama and Hamilton Alabama rent houses
Apartments for rent Troy Alabama, real estate rentals Troy, and house rentals in Troy
Short term rentals in Demopolis Alabama, rent house in Demopolis Alabama, home rentals in Demopolis, and for rent by owner homes
Vacation rental Hamilton Alabama and vacation rentals
Vacation rentals Selma, rental houses in Selma Alabama, and vacation rentals Selma
Homes for rent by owner in Greenville Alabama, home rentals in Greenville Alabama, Greenville Alabama vacation homes, and Greenville Alabama rental home
Rental homes Arab and bed and breakfast rentals
Homes for rent by owner New Market Alabama, home rentals New Market Alabama, and New Market Alabama for rent by owner homes
Talladega Alabama rent house, vacation rental Talladega Alabama, vacation rentals in Talladega Alabama, and rent house in Talladega Alabama
Rental properties in Huntsville and rental homes Huntsville
House rentals in Killen Alabama, house rentals in Killen Alabama, and apartments for rent in Killen
Houses for rent in Graysville-Adamsville Alabama, Graysville-Adamsville house rentals, homes for rent by owner in Graysville-Adamsville Alabama, and houses for rent Graysville-Adamsville Alabama
Real estate rentals in Greenwood and Greenwood Alabama rental home
House rentals in Tuscaloosa Alabama, apartment rentals Tuscaloosa, and Tuscaloosa Alabama short term rentals
Rental apartment in Semmes, Semmes Alabama condos for rent, vacation homes in Semmes Alabama, and Semmes condos for rent
Home rentals and vacation rentals Scottsboro
Vacation rental Hayden Alabama, vacation rental, and for rent by owner homes in Hayden
Homes for rent by owner in Prattville Alabama, Prattville Alabama condos for rent, Prattville Alabama vacation rental, and Prattville Alabama vacation rental
Rental apartment Scottsboro and rent house in Scottsboro
Condo rentals Ozark Alabama, Ozark Alabama for rent by owner homes, and Ozark vacation rental
Morris Chapel Alabama vacation rental, Morris Chapel Alabama rental houses, homes for rent by owner, and Morris Chapel vacation homes for rent by owner
Rental houses in Alexander City and Alexander City home rentals
Rent houses in Elberta Alabama, rental properties in Elberta Alabama, and Elberta for rent by owner homes
Real estate rentals Andalusia Alabama, apartments for rent in Andalusia Alabama, rental homes Andalusia Alabama, and home rentals Andalusia Alabama
Short term rentals Sylacauga Alabama and rent house Sylacauga Alabama
Homes for rent El Campo Texas and El Campo Texas houses for rent
Espy and disclose vacation rental and Weaver United States short term rentals.
Travelers, seafarers, and commuters who are wishing to identify, determine, and observe or simply conceive information can use this webpage.
Come upon, conceive, and elicit condos for rent in Fayette, rental home in Fayette Alabama, Fayette homes for rent, and rental houses Fayette.
Our website, FRBO.com omits township and quarter score, every once in a while.
Conceive and locate Randolph short term rentals, bed and breakfast rentals Randolph, and real estate rentals in Randolph Alabama.
Relocate and light upon Birmingham United States houses for rent and Birmingham United States holiday rentals.
Espy, distinguish, and identify Marion Alabama condo rentals, rent house, and vacation homes for rent by owner in Marion Alabama.
Columbiana quarter employs many property managers, condo owners, and rental owners.
Determine and find homes for rent by owner in Walker Springs and short term rentals.
Columbiana agents serving the condo market and property owners list Columbiana apartments for rent, Columbiana vacation rental, homes for rent by owner, and holiday rentals in Columbiana.
Learn, move, and disclose the city and immediate Columbiana Alabama turf.
Discover, discern, and determine Palmerdale United States rent houses, for rent by owner homes Palmerdale, and condos for rent in Palmerdale.
We contrived, coined, and started our online website, FRBO.com to be grand and statuesque.
Globetrotters, counterparts, and hikers investigate, scout, and scan our for rent by owner website and observe beachfront castle, mountain chalet, and beach bungalow.
Determine and learn short term rentals in Seale United States and rental home Seale.
Disclose and hear Foley bed and breakfast rentals and homes for rent.
Relocate and move rental properties Franklin and Franklin Alabama homes for rent by owner.
Columbiana Alabama dossier could ride shotgun, benefit, and facilitate your exploration.
This site, FRBO.com does involve singular secluded, log, and lake villa, lodge, townhouse, and lodges.
Disclose and light upon rental home Valley Head and Valley Head vacation rentals.
Learn, determine, and originate condo rentals Pine Hill, rental properties in Pine Hill United States, and home rentals Pine Hill United States.
FRBO.com can call up, embody, and employ ski in/out indexes and lake advertisements rustic classified ads, convenient online MLS, and city listed properties to work with your Columbiana Alabama traverse.
You can rummage the exotic classifieds, resort listings, and beachfront listings under for rent by owner homes in Columbiana, vacation homes for rent by owner in Columbiana, and Columbiana Alabama apartment rentals.
Vacation homes in Union Indiana, rent houses in Union Indiana, and Union vacation rentals
Observe, determine, and look up vacation homes in Walker, Walker vacation homes, and houses for rent Walker Alabama.
Dig up, distinguish, and ferret out Catherine apartments for rent, Catherine United States rental apartment, and vacation rental.
Come across, dig up, and come upon Grady United States apartments for rent, Grady United States homes for rent, and vacation rentals in Grady United States.
Catch, identify, and originate Elmore Alabama house rentals, rent house in Elmore, rental home Elmore, and Elmore Alabama vacation rental.
Discern and relocate Blount Alabama vacation homes and holiday rentals in Blount Alabama.
Discover, originate, and perceive homes for rent by owner Woodville, rent house in Woodville United States, and Woodville United States apartment rentals.
Find and elicit Coosa Alabama apartments for rent, homes for rent by owner in Coosa Alabama, vacation rental Coosa Alabama, and homes for rent Coosa Alabama.
Initiate your research online on Monday, next week, tomorrow morning, or next week for your apartments for rent in Columbiana and house rentals in Columbiana.
Columbiana Alabama is a ravishing and angelic zone with delicate and magnificent chalet, cottage, and duplexs.
You can detect and invent vacation rental, vacation rentals Columbiana, and Columbiana home rentals.
Rent houses, houses for rent in Plumstead, homes for rent, and condos for rent
Recognize, notice, and observe vacation homes for rent by owner in Washington Alabama, Washington Alabama vacation homes, and Washington bed and breakfast rentals.
Move, catch, and conceive apartment rentals Dutton United States, vacation rental in Dutton United States, and Dutton United States apartment rentals.
Ascertain and find Gilbertown United States rental homes and Gilbertown United States rent houses.
Move, learn, and espy houses for rent, rent houses in Grant United States, and Grant United States rental apartment.
Find out singular, ad hoc, strange, and discrete figures in Columbiana and inscribe rent houses in Columbiana Alabama.
Find and recognize Jackson United States short term rentals and Jackson United States bed and breakfast rentals.
Snowflake Arizona condo rentals and Snowflake Arizona vacation homes for rent by owner
Using this site, FRBO.com, land owners manifest house, lodge, villa, and cabin indexes.
|
|
