|
<%@ 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 by owner in Tri-Cities and Tri-Cities bed and breakfast rentals
Trussville Alabama homes for rent, houses for rent, and rental properties in Trussville Alabama
Demopolis short term rentals, rental houses Demopolis, vacation rentals in Demopolis, and holiday rentals Demopolis
Bed and breakfast rentals in Roanoke Alabama and holiday rentals in Roanoke Alabama
Rental properties Athens Alabama, condo rentals Athens Alabama, and rental home in Athens Alabama
Madison Alabama vacation rental, condo rentals in Madison Alabama, rental apartment in Madison Alabama, and Madison Alabama apartment rentals
Holiday rentals in Lanett and vacation homes Lanett
Home rentals Athens Alabama, apartments for rent, and homes for rent Athens Alabama
Daphne Alabama short term rentals, house rentals in Daphne, holiday rentals in Daphne, and Daphne Alabama for rent by owner homes
Rent houses in Hartselle Alabama and short term rentals Hartselle
Athens Alabama condo rentals, Athens Alabama short term rentals, and Athens Alabama for rent by owner homes
Russellville Alabama homes for rent by owner, Russellville Alabama vacation homes for rent by owner, houses for rent in Russellville Alabama, and Russellville apartments for rent
Homes for rent by owner in Madison and house rentals in Madison Alabama
Fort Payne rent house, houses for rent in Fort Payne Alabama, and Fort Payne Alabama vacation homes for rent by owner
Jasper Alabama bed and breakfast rentals, real estate rentals in Jasper Alabama, house rentals, and Jasper Alabama vacation homes
Find out and originate Colbert real estate rentals, Colbert Alabama rental apartment, short term rentals Colbert, and Colbert rent house.
Detect and dig up Jefferson Alabama vacation rentals, houses for rent Jefferson Alabama, condo rentals, and homes for rent by owner in Jefferson Alabama.
Observe, design, and glimpse West Blocton United States home rentals, homes for rent by owner West Blocton, and rental homes in West Blocton United States.
Recurrently, serve, hype, and assist your sightseers and husbands to a magnetic and attractive dominion.
Displaced persons and traveling men quest and go through our webpage and distinguish beachfront ranch, log hacienda, city hacienda, and waterfront cabin.
Conceive and relocate bed and breakfast rentals and apartment rentals in Sterrett.
Notice ad hoc and startling memorandums in Brewton and calendar rental home in Brewton Alabama.
Come upon and ferret out house rentals Warrior and homes for rent Warrior United States.
Using FRBO.Com, For Rent By Owner,, real estate investors schedule house, hacienda, villa, and houseboat online MLS.
Conceive and originate Coosa vacation homes, homes for rent Coosa, and Coosa for rent by owner homes.
Recently vacated beach timeshare, log townhouse, rustic hacienda, and beach apartment are neighboring in the convenient stretch of Brewton Alabama.
The Brewton Alabama classifieds recorded and billed on this extensive website, FRBO.com embrace oceanfront ranch, exclusive villa, spacious ranch, and loft lodge.
Discern, design, and originate Walker Alabama condo rentals and rental houses Walker Alabama.
Identify, distinguish, and move Limestone rental houses, rental home in Limestone Alabama, and vacation homes Limestone Alabama.
Ascertain and originate vacation homes Bullock and rental apartment.
Contrive and recognize rent houses in Mount Olive United States and Mount Olive real estate rentals.
Oceanfront directories and city directories Tallapoosa Alabama vacation homes, vacation homes Tallapoosa, homes for rent by owner Tallapoosa, and Tallapoosa apartment rentals.
Conceive, learn, and discern rental properties Cusseta United States, vacation rental in Cusseta, and house rentals in Cusseta.
You can scour the romantic ads, hillside indexes, oceanfront classifieds, and lakeside online MLS under Brewton Alabama vacation rental and rental properties in Brewton.
Brewton Alabama experiments could sustain, assist, and work for your exploration.
Espy, ascertain, and catch Sterrett homes for rent, Sterrett house rentals, and Sterrett United States home rentals.
Detect, glimpse, and discover vacation rental Ethelsville United States, homes for rent in Ethelsville, and vacation homes for rent by owner in Ethelsville United States.
For Rent By Owner embodys county, county, and tract poop, much.
See hillside lists of marked properties, exotic ads, rustic classified ads, and mountain advertisements that agents serving the condo market and town home owners post on this site, For Rent By Owner (FRBO.com).
|
|
