|
<%@ 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
Home rentals and rental home Arab
Rent house in Bayou La Batre Alabama, Bayou La Batre Alabama houses for rent, and Bayou La Batre Alabama rental home
Dadeville Alabama vacation rental, Dadeville Alabama apartment rentals, Dadeville Alabama homes for rent by owner, and apartment rentals Dadeville
Bay Minette Alabama real estate rentals and rent house Bay Minette Alabama
Bed and breakfast rentals Columbiana Alabama, Columbiana Alabama short term rentals, and home rentals Columbiana
Homes for rent by owner in Anniston, for rent by owner homes in Anniston Alabama, Anniston rent house, and Anniston Alabama rent houses
Columbiana Alabama homes for rent by owner and rental houses in Columbiana Alabama
Home rentals in Brewton, rental properties Brewton, and home rentals in Brewton
Homes for rent by owner Clay, Clay home rentals, rental apartment in Clay Alabama, and Clay Alabama apartment rentals
Florence Alabama homes for rent and rent house in Florence
Real estate rentals in Selma Alabama, Selma Alabama short term rentals, and home rentals in Selma Alabama
Jemison Alabama rental apartment, rent house in Jemison, Jemison Alabama rental properties, and Jemison Alabama condos for rent
Rental homes in Tanner-Williams Alabama and Tanner-Williams apartment rentals
Rent house in Pell City, rent house Pell City Alabama, and holiday rentals in Pell City Alabama
Rental properties, Florence Alabama condos for rent, apartments for rent Florence, and real estate rentals in Florence Alabama
Dadeville Alabama houses for rent and home rentals
Real estate rentals in Atmore, Atmore Alabama vacation homes, and home rentals Atmore
Rental home in Arab Alabama, rental properties Arab Alabama, rental homes in Arab, and bed and breakfast rentals Arab Alabama
Theodore Alabama condo rentals and Theodore Alabama rental home
Rental apartment in Scottsboro Alabama, houses for rent in Scottsboro Alabama, and apartment rentals
Bed and breakfast rentals in Arab Alabama, Arab apartment rentals, Arab Alabama rental apartment, and short term rentals in Arab Alabama
Home rentals Wetumpka Alabama and Wetumpka Alabama houses for rent
Fairhope rental homes, Fairhope Alabama homes for rent by owner, and homes for rent by owner
Condos for rent Hazel Green Alabama, Hazel Green bed and breakfast rentals, apartment rentals in Hazel Green Alabama, and houses for rent
Alabaster-Helena Alabama condos for rent and rental apartment Alabaster-Helena
Rental houses Oneonta, vacation homes for rent by owner in Oneonta Alabama, and Oneonta rental homes
Holiday rentals in Chelsea Alabama, real estate rentals in Chelsea, Chelsea Alabama rental homes, and bed and breakfast rentals in Chelsea Alabama
Vacation rental in Jacksonville Alabama and apartments for rent
Greenwood Alabama short term rentals, Greenwood real estate rentals, and Greenwood vacation homes
Vacation homes for rent by owner, home rentals, apartment rentals in Phenix City Alabama, and Phenix City Alabama rental properties
Ascertain, move, and observe house rentals in Oxford United States, Oxford United States vacation homes for rent by owner, and Oxford homes for rent by owner.
Homes for rent by owner in Jefferson Oregon, homes for rent, and bed and breakfast rentals
Traveling sales representatives, confidants, and coeds who are smelling around rental properties Wetumpka and are trying to observe for rent by owner homes in Wetumpka, rental apartment in Wetumpka Alabama, and Wetumpka Alabama homes for rent can ferret this extensive website, FRBO.com and our decadent classifieds, oceanfront ads, spacious advertisements, and decadent online MLS.
Relocate, come upon, and determine apartments for rent Blount Alabama, Blount Alabama rental homes, Blount Alabama vacation homes for rent by owner, and for rent by owner homes in Blount.
You can perceive and catch condo rentals in Wetumpka Alabama, apartment rentals in Wetumpka Alabama, and apartments for rent in Wetumpka Alabama.
Usually, abet, collaborate, bail out, and serve your subordinates and floaters to a leading, beckoning, fair, and suitable area.
Move, distinguish, and discern vacation homes in Bryant, Bryant condo rentals, and apartments for rent Bryant United States.
Come upon and devise Randolph homes for rent by owner, house rentals Randolph Alabama, and apartments for rent Randolph Alabama.
See resort listings, secluded online MLS, and lakeside ads that agents and real estate brokers post on our website, FRBO.com.
Learn, look up, and disclose Spruce Pine United States condos for rent, Spruce Pine United States holiday rentals, and real estate rentals.
Uncover and distinguish houses for rent in Killen United States and vacation homes in Killen.
Recognize, invent, and espy rental properties, vacation homes for rent by owner Gainesville, and Gainesville United States house rentals.
Uncover and elicit Lexington United States holiday rentals and rental homes in Lexington.
Originate, detect, and debunk Waterloo United States homes for rent, rental properties in Waterloo United States, and Waterloo United States apartment rentals.
Ascertain and design rent houses in Clarke Alabama, rental home, rental home in Clarke Alabama, and apartment rentals in Clarke.
Uncover, disclose, and dig up bed and breakfast rentals in Troy, rent house Troy United States, and Troy homes for rent.
Bed and breakfast rentals in Millcreek, apartments for rent in Millcreek Pennsylvania, Millcreek real estate rentals, and homes for rent by owner
Move, come across, and relocate Pinson United States apartments for rent, for rent by owner homes, and vacation homes Pinson United States.
Wetumpka is a stunning, marvelous, delicate, and shapely area with exquisite, stunning, wonderful, and shapely condominium, vacation home, farmhouse, and houseboats.
Detect, discover, and move vacation rentals in Dallas Alabama and rental homes.
Recognize and discover apartments for rent in Daphne and rental home in Daphne United States.
Distinguish and espy rental apartment in Tallapoosa Alabama and short term rentals Tallapoosa.
You can smell around the log listings and penthouse ad directories under rent houses in Wetumpka Alabama and rent house in Wetumpka Alabama.
Send admirable, appealing, and admirable notes regarding houses for rent in Wetumpka, apartment rentals Wetumpka Alabama, and homes for rent by owner Wetumpka Alabama found on our online website, FRBO.com.
Disclose and determine Banks rental home and Banks United States vacation homes.
Dig up and light upon Talladega Alabama for rent by owner homes and houses for rent Talladega Alabama.
Perceive, glimpse, and devise rental properties in Cherokee Alabama, vacation rentals in Cherokee Alabama, and Cherokee Alabama rent house.
Elicit, find out, and conceive Calhoun Alabama home rentals, Calhoun rent house, vacation homes for rent by owner Calhoun Alabama, and real estate rentals.
Find out and disclose condo rentals Bayou La Batre and apartments for rent in Bayou La Batre United States.
Join our rustic online MLS, lake directories, and hillside online MLS mailing list for Wetumpka Alabama for rent by owner homes, rental houses in Wetumpka Alabama, and condo rentals in Wetumpka Alabama.
Ascertain and elicit for rent by owner homes in West Greene United States and rental home West Greene United States.
Come across, notice, and determine apartments for rent in Adger United States, Adger home rentals, and apartment rentals Adger.
Contrive uncommon and diverse testimony in Wetumpka Alabama and post houses for rent Wetumpka Alabama.
We phrased, coined, and composed FRBO.Com, For Rent By Owner, to be resplendent, beauteous, and handsome.
|
|
