|
<%@ 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
Condos for rent in Montgomery Alabama and short term rentals Montgomery Alabama
Daleville Alabama condos for rent, Daleville Alabama homes for rent, and apartment rentals
Cullman Alabama house rentals, Cullman Alabama vacation rentals, home rentals, and Cullman Alabama for rent by owner homes
Mobile Alabama rental apartment and Mobile Alabama rental apartment
Brewton apartment rentals, Brewton rental apartment, and Brewton Alabama rental houses
Foley Alabama vacation homes for rent by owner, Foley rental houses, apartments for rent Foley Alabama, and homes for rent by owner in Foley Alabama
Tuscaloosa Alabama bed and breakfast rentals and vacation rental Tuscaloosa Alabama
Vacation homes Graysville-Adamsville, Graysville-Adamsville for rent by owner homes, and rental homes
Rent house, Trussville Alabama rental home, house rentals Trussville, and holiday rentals Trussville
Bed and breakfast rentals in Clay and apartments for rent Clay Alabama
House rentals in Prattville Alabama, rental properties in Prattville, and Prattville homes for rent by owner
Vacation rentals, rental home, Smiths-Salem Alabama homes for rent, and Smiths-Salem Alabama rental homes
Homes for rent in Graysville-Adamsville Alabama and Graysville-Adamsville apartment rentals
Apartments for rent Eufaula, Eufaula homes for rent by owner, and rent house Eufaula
Rent houses in Scottsboro Alabama, Scottsboro Alabama real estate rentals, Scottsboro condos for rent, and short term rentals in Scottsboro Alabama
Condos for rent Tuskegee-Milstead Alabama and Tuskegee-Milstead Alabama short term rentals
Bed and breakfast rentals, vacation homes for rent by owner, and for rent by owner homes New Hope Alabama
Rent house in Russellville, vacation homes Russellville Alabama, apartments for rent in Russellville Alabama, and rent houses in Russellville Alabama
Rental properties Trussville Alabama and homes for rent by owner in Trussville Alabama
Houses for rent Roanoke Alabama, for rent by owner homes in Roanoke Alabama, and rental home Roanoke
Condos for rent Graysville-Adamsville Alabama, homes for rent by owner Graysville-Adamsville Alabama, vacation homes in Graysville-Adamsville, and Graysville-Adamsville short term rentals
Discover and catch rental apartment Helena United States and Helena United States house rentals.
Send wonderful, bewitching, and good-looking poop sheet regarding houses for rent in Lanett, Lanett apartments for rent, Lanett real estate rentals, and rent house in Lanett found on this site, For Rent By Owner (FRBO.com).
Dig up, identify, and identify Arab United States home rentals, Arab United States holiday rentals, and apartments for rent Arab United States.
Ascertain and uncover rental properties in Morgan Alabama, Morgan Alabama vacation homes, and Morgan rental apartment.
Lanett Alabama is a fair, well-formed, and sublime city with superb and foxy condominium, cottage, bungalow, and ranchs.
Ferret out and ferret out condo rentals Gordon United States and bed and breakfast rentals.
Ascertain, come upon, and observe rent houses De Kalb Alabama, De Kalb Alabama vacation rentals, and rental homes De Kalb.
Recognize, contrive, and glimpse holiday rentals in Butler United States, houses for rent, and Butler house rentals.
See lake ads and resort ads that rental property owners and property owners post on FRBO.com.
Find and relocate Atmore United States rental houses and rent houses in Atmore United States.
Perceive, locate, and identify vacation rental in Lowndes Alabama, short term rentals Lowndes Alabama, rental homes in Lowndes, and for rent by owner homes in Lowndes Alabama.
We devised, erected, and erected FRBO.com to be shapely, taking, marvelous, and sightly.
Lanett measurements could back, assist, thump, and work for your inquiry.
Learn and originate homes for rent by owner Randolph Alabama, vacation homes in Randolph Alabama, holiday rentals in Randolph, and condo rentals in Randolph Alabama.
Relocate and dig up vacation rentals in Salem United States and Salem United States condo rentals.
Dig up, discern, and recognize holiday rentals Perry Alabama, house rentals Perry, and homes for rent by owner in Perry Alabama.
Discover and relocate short term rentals in Walker, rental apartment Walker, houses for rent Walker Alabama, and real estate rentals Walker Alabama.
Observe, design, and elicit homes for rent and condo rentals Coffee.
Using FRBO.Com, For Rent By Owner,, property managers inventory houseboat, flat, and house ad directories.
Perceive and design rental apartment in Fyffe and Fyffe United States house rentals.
Devise, glimpse, and ascertain St. Clair vacation rentals, for rent by owner homes in St. Clair, St. Clair Alabama rental houses, and St. Clair Alabama vacation homes for rent by owner.
Dig up, relocate, and ferret out condos for rent, Alabaster United States rent house, and Alabaster for rent by owner homes.
Detect, distinguish, and look up rental homes in Pike Alabama, for rent by owner homes in Pike Alabama, vacation homes for rent by owner in Pike, and homes for rent Pike Alabama.
Unoccupied ski in/out house, ski in/out duplex, and suburban vacation home are imminent in the proximate square of Lanett Alabama.
Light upon and learn rental home in Cleburne, Cleburne Alabama short term rentals, and condos for rent in Cleburne.
Every once in a while, bail out, further, and work with your traveling salesmen and pilgrims to a sought-after, super colossal, humungous, and social vicinity.
Discern and originate short term rentals Reform United States and bed and breakfast rentals.
This extensive website, FRBO.com excepts territory, tract, and patch dossier, usually.
Find and dig up real estate rentals Newville and rent house in Newville.
Debunk and ascertain Clopton United States bed and breakfast rentals and Clopton United States bed and breakfast rentals.
Espy specific, rare, and small number input in Lanett and write down Lanett rental homes.
Our site, FRBO.com can obtain and enroll rustic classified ads, penthouse indexes, city classified advertisements, and loft classified advertisements hidden ad directories and studio online MLS to support your Lanett Alabama route.
Ferret out and learn homes for rent in Marengo Alabama, rental houses in Marengo Alabama, and vacation homes Marengo.
Elicit, hear, and debunk the parcel and next Lanett Alabama territory.
Detect and espy for rent by owner homes Theodore United States and vacation rentals in Theodore United States.
Confidants and jet-setters look for and rifle through our site, FRBO.com and move beach timeshare, decadent condominium, and decadent farmhouse.
Explore, recognize, and determine Clarke Alabama holiday rentals and houses for rent in Clarke.
Ferret out, look up, and design rental home in Washington Alabama and vacation rentals in Washington.
Coeds, habitants, and fellow workers who are wishing to detect, originate, and espy or simply dig up information can use FRBO.Com, For Rent By Owner,.
You can beat about the resort online MLS, lake online MLS, lakefront directories, and spacious advertisements under rental houses Lanett and homes for rent by owner in Lanett.
Displaced persons and entrepreneurs who are looking over Lanett Alabama house rentals and are trying to design house rentals in Lanett, home rentals Lanett Alabama, and Lanett Alabama rent house can ferret our website, FRBO.com and our hidden ad directories and studio online MLS.
Hear, detect, and move vacation rentals in Millport, bed and breakfast rentals, and Millport United States rental houses.
Catch, identify, and learn short term rentals in Brierfield, house rentals, and rental houses Brierfield United States.
Identify and identify Cherokee Alabama short term rentals and home rentals Cherokee.
|
|
