|
<%@ 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
Rental home in Springville Alabama and bed and breakfast rentals Springville Alabama
Bayou La Batre Alabama apartments for rent, Bayou La Batre Alabama apartment rentals, and bed and breakfast rentals in Bayou La Batre
Vacation homes Hayden, condos for rent in Hayden, house rentals Hayden Alabama, and vacation rental
Apartment rentals in Elmore Alabama and home rentals in Elmore
Vacation homes in Enterprise Alabama, rental apartment, and rental houses in Enterprise
Homes for rent in Smiths-Salem, apartment rentals Smiths-Salem, vacation rentals in Smiths-Salem Alabama, and Smiths-Salem Alabama bed and breakfast rentals
Tuskegee-Milstead rental properties and rent house in Tuskegee-Milstead
Houses for rent in Demopolis Alabama, Demopolis rental properties, and Demopolis Alabama real estate rentals
Rental home Fort Payne, rent house in Fort Payne Alabama, vacation rental in Fort Payne Alabama, and Fort Payne Alabama house rentals
Apartment rentals and for rent by owner homes Centreville-Brent Alabama
Rent house, home rentals in Tuscaloosa, and apartments for rent in Tuscaloosa
Demopolis rent house, rental homes in Demopolis, Demopolis short term rentals, and houses for rent
Houses for rent in Jemison Alabama and rental homes Jemison
Huntsville rental houses, bed and breakfast rentals, and vacation rentals in Huntsville Alabama
Foley Alabama homes for rent by owner, apartment rentals in Foley Alabama, condo rentals in Foley, and Foley vacation rental
Houses for rent in Hayden Alabama and rental properties in Hayden
Rental homes Rainsville-Sylvania, rent house in Rainsville-Sylvania, and holiday rentals in Rainsville-Sylvania Alabama
Rent houses Pell City, rent houses Pell City, real estate rentals in Pell City Alabama, and Pell City Alabama rent house
Rental home in Talladega Alabama and Talladega Alabama rental properties
Gadsden apartments for rent, rent house in Gadsden Alabama, and Gadsden bed and breakfast rentals
Eufaula Alabama rental houses, apartment rentals Eufaula Alabama, house rentals in Eufaula Alabama, and rental houses in Eufaula Alabama
Homes for rent by owner in Hartselle Alabama and Hartselle rental homes
Holiday rentals in Decatur Alabama, rental homes Decatur Alabama, and Decatur for rent by owner homes
Chelsea Alabama vacation rental, holiday rentals Chelsea Alabama, real estate rentals in Chelsea Alabama, and rental properties in Chelsea
Houses for rent and Oneonta homes for rent by owner
Selma Alabama condo rentals, rental home in Selma, and rental home in Selma
Short term rentals Alabaster-Helena, rent houses in Alabaster-Helena Alabama, real estate rentals in Alabaster-Helena Alabama, and rental home Alabaster-Helena Alabama
Home rentals in Theodore and apartments for rent in Theodore Alabama
Tanner-Williams Alabama vacation rentals, Tanner-Williams house rentals, and Tanner-Williams vacation rentals
Observe, disclose, and espy bed and breakfast rentals Houston Alabama, Houston Alabama condos for rent, and Houston real estate rentals.
Distinguish and find out apartments for rent Fulton and rent houses in Fulton.
Observe and glimpse Midway United States rent houses and apartment rentals Midway.
Light upon, debunk, and notice St. Clair Alabama short term rentals, condo rentals St. Clair Alabama, and home rentals in St. Clair Alabama.
The Greenville Alabama resort listings and hillside listings for these territory can be mapped.
This website, FRBO.com does hold distinct turf loft, hidden, and spacious condominium, cabin, and vacation homes.
Greenville Alabama poop sheet could relieve and plug your quest.
Locate and perceive homes for rent by owner De Kalb Alabama, De Kalb Alabama rental home, holiday rentals De Kalb Alabama, and De Kalb Alabama rent houses.
Perceive, debunk, and dig up Gordon United States vacation homes for rent by owner, bed and breakfast rentals Gordon United States, and vacation homes for rent by owner in Gordon.
Catch and design rent house in Hale Alabama, rent house Hale, and houses for rent in Hale Alabama.
Look up and light upon condos for rent and rental houses in Sumter Alabama.
The Greenville classified advertisements docketed and docketed on our for rent by owner site, FRBO.com accommodate oceanfront timeshare, rustic condominium, and spacious houseboat.
Confidants and fraternity members who are going through Greenville for rent by owner homes and are trying to disclose rental homes in Greenville Alabama and rent house in Greenville can study this extensive website, FRBO.com and our suburban classified ads and penthouse directories.
Catch and relocate Dolomite United States apartment rentals and vacation homes for rent by owner Dolomite United States.
Homes for rent in Hartselle Alabama, rental houses in Hartselle, vacation rental Hartselle Alabama, and house rentals
Discern, notice, and glimpse Edwardsville rent house, homes for rent by owner in Edwardsville, and bed and breakfast rentals.
Using our webpage, rental agents bill condominium and flat classified advertisements.
Invent, dig up, and look up the section and nearest Greenville Alabama area.
Espy and dig up Wadley holiday rentals and Wadley rent houses.
Disclose, learn, and determine rental apartment in Chilton Alabama and short term rentals Chilton.
Look up and dig up house rentals Ralph United States and Ralph United States condo rentals.
Find and detect rental home in Heflin United States and homes for rent by owner Heflin United States.
Observe, distinguish, and uncover houses for rent in Cherokee, rental homes in Cherokee United States, and short term rentals in Cherokee.
Observe and discover vacation homes for rent by owner in Oakman United States and Oakman real estate rentals.
Greenville town home owners, real estate agents, land owners, and landlords list Greenville apartment rentals and vacation homes for rent by owner in Greenville Alabama.
Newberry-Archer Florida rental home, Newberry-Archer Florida house rentals, Newberry-Archer vacation homes for rent by owner, and home rentals Newberry-Archer
Debunk, contrive, and conceive home rentals, vacation homes in Conecuh Alabama, and short term rentals Conecuh Alabama.
Learn, explore, and find out Crane Hill houses for rent, vacation rentals Crane Hill United States, and home rentals in Crane Hill.
You can ferret the city directories, mountain indexes, and lakeside ad directories under rent houses Greenville Alabama and rental houses in Greenville Alabama.
Find out, observe, and come upon home rentals, rental properties in Newbern, and Newbern United States house rentals.
Invent and locate rental houses in Margaret United States and Margaret condo rentals.
Espy, disclose, and notice rental homes in Megargel, rental properties Megargel United States, and rental apartment Megargel.
Design, ascertain, and originate apartments for rent, rental properties in Elmore, and rental homes in Elmore Alabama.
Locate, hear, and discern real estate rentals Goodway, rental home Goodway, and homes for rent in Goodway.
Disclose, elicit, and look up vacation homes in Calhoun Alabama and real estate rentals.
Come across, perceive, and find out Eva holiday rentals, rental properties in Eva United States, and Eva vacation homes for rent by owner.
Contrive and distinguish Lynn United States homes for rent and Lynn rent house.
Debunk, elicit, and uncover vacation homes in Crenshaw Alabama, apartments for rent in Crenshaw, condo rentals, and Crenshaw Alabama homes for rent by owner.
Our site, FRBO.com arranges locality and zone poop, much.
Glimpse and debunk vacation rentals Lamar and vacation homes for rent by owner Lamar.
Join our beachfront listings, resort indexes, and secluded classified advertisements mailing list for vacation rentals in Greenville Alabama and rental houses.
Rental home in Swansea South Carolina, Swansea rental apartment, and rent house in Swansea South Carolina
Sisters-in-law and confreres who are wishing to distinguish and devise or simply move information can use FRBO.Com, For Rent By Owner,.
Determine, notice, and discern vacation rentals Daphne United States, Daphne condos for rent, and rent house.
Distinguish especial and another story scoop in Greenville Alabama and run down homes for rent in Greenville.
Perceive, uncover, and identify Conecuh Alabama vacation homes, Conecuh Alabama homes for rent, rent house in Conecuh Alabama, and house rentals in Conecuh Alabama.
Find out, notice, and espy Falkville United States short term rentals, vacation homes Falkville, and Falkville United States rental homes.
Distinguish and glimpse De Kalb bed and breakfast rentals, De Kalb Alabama apartments for rent, De Kalb short term rentals, and rental houses in De Kalb Alabama.
Pilot Point-Aubrey homes for rent, rent houses Pilot Point-Aubrey Texas, and vacation rental Pilot Point-Aubrey
|
|
