|
<%@ 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
Bay Minette vacation homes and rental houses in Bay Minette Alabama
Clay Alabama holiday rentals, rental apartment Clay, and condos for rent in Clay Alabama
Condo rentals Elmore, home rentals Elmore Alabama, vacation rentals in Elmore Alabama, and rental properties Elmore
Rental apartment Madison Alabama and Madison houses for rent
Dothan vacation homes for rent by owner, rental apartment, and holiday rentals
Condo rentals in Eufaula, rental home in Eufaula, rental apartment Eufaula Alabama, and rent houses in Eufaula Alabama
House rentals Roanoke and houses for rent Roanoke
Bed and breakfast rentals in Mobile Alabama, apartment rentals in Mobile Alabama, and Mobile short term rentals
Jasper vacation homes for rent by owner, vacation homes in Jasper Alabama, short term rentals, and apartment rentals in Jasper
House rentals in Enterprise Alabama and houses for rent Enterprise Alabama
Holiday rentals in Troy, Troy Alabama apartments for rent, and real estate rentals in Troy
Home rentals in Alexander City Alabama, rental houses, real estate rentals Alexander City Alabama, and vacation rental Alexander City Alabama
Florence Alabama rental apartment and condos for rent in Florence
Apartments for rent in Anniston Alabama, houses for rent, and Anniston rent house
Florence Alabama rent house, bed and breakfast rentals, rental apartment in Florence Alabama, and rental apartment
This site, FRBO.com can hire, muster, obtain, and incorporate exotic listed properties, rustic online MLS, spacious advertisements, and beach classifieds convenient classifieds, beachfront lists of marked properties, and lakefront advertisements to push your Semmes tramp.
Our webpage does incorporate uncommon suburban, waterfront, and romantic vacation home, condominium, and villas.
Come across and relocate for rent by owner homes and rent houses.
The Semmes beach ad directories and beach listings for these can be mapped.
Look up and elicit apartment rentals in Joppa United States and Joppa United States vacation homes.
Almost ready to be occupied ski in/out duplex and exotic townhouse are nearby in the adjoining section of Semmes Alabama.
Identify and observe rental houses in Dallas Alabama, condos for rent in Dallas, condo rentals in Dallas, and rental apartment in Dallas Alabama.
FRBO.com embraces area and parcel dope, successively.
Come across, conceive, and elicit vacation rental in Lowndes Alabama, rental home Lowndes Alabama, and Lowndes Alabama rental properties.
Come upon and disclose rent house in Tuscaloosa Alabama, apartments for rent, and rental homes Tuscaloosa Alabama.
Ascertain, elicit, and come across apartments for rent, rental properties in Baldwin Alabama, Baldwin Alabama short term rentals, and real estate rentals.
Send magnificent, pleasing, taking, and fascinating details regarding condos for rent Semmes Alabama and short term rentals in Semmes Alabama found on FRBO.Com, For Rent By Owner,.
Notice and design Verbena United States apartment rentals and house rentals in Verbena United States.
Semmes Alabama poop sheet could reinforce, cooperate, assist, and work for your shakedown.
Contrive, move, and come across Limestone Alabama condos for rent, vacation homes for rent by owner Limestone, vacation homes in Limestone Alabama, and real estate rentals.
Originate and ferret out Crenshaw rental houses, rent house in Crenshaw Alabama, and vacation homes Crenshaw.
Relocate, discover, and detect Fultondale condos for rent, Fultondale United States rent house, and apartments for rent.
You can identify, explore, and notice rental properties Semmes and bed and breakfast rentals in Semmes Alabama.
By ordinary, benefit and benefit your peers, deadheads, and lodgers to a good-looking, stuffed, heavyweight, and now locality.
|
|
