|
<%@ 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
Holiday rentals in Elberta Alabama and home rentals Elberta Alabama
Jasper Alabama rent house, home rentals in Jasper, and house rentals Jasper
Bay Minette Alabama vacation homes for rent by owner, Bay Minette holiday rentals, Bay Minette holiday rentals, and rental home in Bay Minette
Bed and breakfast rentals in Alabaster-Helena Alabama and Alabaster-Helena homes for rent
Short term rentals Langdale Alabama, rent house, and Langdale Alabama bed and breakfast rentals
New Hope apartment rentals, rent houses New Hope Alabama, vacation rental New Hope, and homes for rent
Vacation homes in Athens and apartments for rent in Athens
Sylacauga Alabama vacation rentals, rental homes, and Sylacauga Alabama rental homes
Apartment rentals Huntsville, Huntsville apartments for rent, house rentals in Huntsville, and Huntsville Alabama rental home
Vacation homes Andalusia and condos for rent in Andalusia Alabama
Rent houses in Morris Chapel, Morris Chapel bed and breakfast rentals, and rental homes in Morris Chapel Alabama
Anniston Alabama rental houses, vacation homes, Anniston Alabama home rentals, and Anniston Alabama condos for rent
Vacation homes for rent by owner and Hartselle Alabama holiday rentals
Rent houses in New Hope, rental homes New Hope Alabama, and New Hope Alabama rental houses
Apartments for rent in Hamilton, Hamilton condo rentals, real estate rentals in Hamilton Alabama, and Hamilton for rent by owner homes
Rental properties in Lanett Alabama and bed and breakfast rentals in Lanett Alabama
Holiday rentals Oneonta, vacation rental in Oneonta, and Oneonta bed and breakfast rentals
Websters Chapel-Alexandria Valley Alabama condo rentals, Websters Chapel-Alexandria Valley homes for rent by owner, Websters Chapel-Alexandria Valley rent house, and Websters Chapel-Alexandria Valley Alabama condos for rent
House rentals Andalusia and rental home
Rental homes Greenwood, Greenwood Alabama homes for rent by owner, and Greenwood Alabama vacation homes
Homes for rent in Atmore Alabama, house rentals Atmore, Atmore Alabama home rentals, and condo rentals Atmore Alabama
Cullman condos for rent and homes for rent by owner Cullman
Tri-Cities Alabama rental homes, vacation homes in Tri-Cities Alabama, and homes for rent by owner Tri-Cities
Determine, relocate, and elicit rental home in Bibb Alabama, Bibb rental homes, Bibb Alabama homes for rent, and real estate rentals Bibb.
Notice, debunk, and dig up short term rentals in Lauderdale Alabama and home rentals in Lauderdale.
Send ideal, ravishing, fine, and beauteous facts regarding rental homes, real estate rentals in Mobile, and rent houses in Mobile Alabama found on our page.
Mobile Alabama is a gorgeous and lovely zone with splendid, delicate, good-looking, and divine ranch, home, apartment, and bungalows.
Design, conceive, and glimpse the tract and neighboring Mobile Alabama township.
Devise, notice, and explore short term rentals Dora, house rentals, and Dora United States vacation homes for rent by owner.
Invent, originate, and disclose homes for rent by owner in Winston Alabama, houses for rent Winston, houses for rent, and Winston Alabama apartment rentals.
Distinguish and explore Calhoun Alabama homes for rent by owner, rental apartment, and home rentals in Calhoun Alabama.
Disclose and light upon condos for rent Sulligent United States and short term rentals Sulligent United States.
Observe and relocate Dutton United States rental houses and Dutton United States rent house.
Learn, catch, and glimpse rental apartment in Shorter, rent houses in Shorter, and Shorter real estate rentals.
Design, discern, and detect real estate rentals Cloverdale United States, Cloverdale condos for rent, and vacation rentals.
Observe and determine Elba United States homes for rent by owner and real estate rentals in Elba United States.
Disclose, discern, and debunk vacation rentals Marengo Alabama, Marengo for rent by owner homes, and real estate rentals in Marengo Alabama.
Catch and perceive Pennington United States rental apartment and Pennington rental home.
Dig up, debunk, and contrive rental homes, rental apartment Smiths, and short term rentals.
Perceive, ascertain, and learn real estate rentals in Barbour and homes for rent Barbour Alabama.
Ferret out and invent rental homes in Adger United States and homes for rent by owner Adger United States.
You can cast about the ski in/out ads, studio lists of marked properties, and loft classifieds under house rentals in Mobile Alabama and condos for rent.
Ferret out, ascertain, and hear rental apartment in Sumter Alabama, rental homes in Sumter, and Sumter Alabama vacation rentals.
This site, For Rent By Owner (FRBO.com) does seat another story area resort, private, loft, and beach condominium, bungalow, bungalow, and houses.
|
|
