|
<%@ 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
Elberta short term rentals and homes for rent
Apartments for rent, New Hope Alabama rental houses, and bed and breakfast rentals
Ozark Alabama for rent by owner homes, condos for rent Ozark Alabama, Ozark Alabama vacation rental, and holiday rentals in Ozark Alabama
Real estate rentals in Auburn-Opelika and real estate rentals in Auburn-Opelika Alabama
Grand Bay Alabama holiday rentals, homes for rent, and rent house in Grand Bay Alabama
Rental properties in Talladega Alabama, Talladega Alabama rental properties, Talladega Alabama houses for rent, and condos for rent
Fort Payne holiday rentals and Fort Payne Alabama condos for rent
For rent by owner homes Grand Bay Alabama, for rent by owner homes in Grand Bay Alabama, and rental apartment in Grand Bay Alabama
House rentals, apartment rentals in Brewton Alabama, Brewton Alabama rental properties, and Brewton vacation rental
Russellville Alabama vacation homes for rent by owner and Russellville Alabama apartments for rent
Trussville for rent by owner homes, rent house in Trussville Alabama, and rental home
Rent house Tri-Cities, rental homes in Tri-Cities Alabama, vacation rental Tri-Cities, and Tri-Cities Alabama rent houses
Rent house Jemison and rental apartment
Rainsville-Sylvania condo rentals, vacation homes for rent by owner Rainsville-Sylvania Alabama, and vacation rentals in Rainsville-Sylvania Alabama
Houses for rent in Elberta Alabama, for rent by owner homes in Elberta Alabama, homes for rent in Elberta Alabama, and rental home
Rental home in Daleville Alabama and Daleville Alabama rental homes
Rental houses in Killen Alabama, short term rentals Killen, and vacation rentals Killen Alabama
Vacation homes Athens Alabama, Athens Alabama rental properties, condos for rent in Athens, and rent houses in Athens
Clay holiday rentals and real estate rentals Clay
Rental apartment in Andalusia, homes for rent by owner in Andalusia Alabama, and house rentals in Andalusia Alabama
Rental apartment in Morris Chapel Alabama, vacation rental in Morris Chapel, vacation homes for rent by owner Morris Chapel, and Morris Chapel houses for rent
Rental home in Websters Chapel-Alexandria Valley Alabama and rental home in Websters Chapel-Alexandria Valley Alabama
Rental houses in Fairhope, Fairhope Alabama homes for rent, and real estate rentals
Hamilton Alabama rental home, Hamilton Alabama rent houses, apartments for rent Hamilton, and Hamilton Alabama houses for rent
For rent by owner homes Gardendale and Gardendale Alabama homes for rent
For rent by owner homes Cullman, condo rentals, and rental home in Cullman Alabama
Rental apartment in Sylacauga, vacation homes Sylacauga Alabama, vacation rentals in Sylacauga Alabama, and condos for rent Sylacauga Alabama
Real estate rentals in Auburn-Opelika and Auburn-Opelika Alabama house rentals
Apartment rentals in Columbiana Alabama, short term rentals in Columbiana, and Columbiana rental apartment
Real estate rentals in Centreville-Brent Alabama, Centreville-Brent condo rentals, homes for rent in Centreville-Brent, and vacation homes
Leeds Alabama homes for rent and Leeds Alabama homes for rent by owner
Short term rentals in Gadsden Alabama, homes for rent, and vacation homes for rent by owner in Gadsden Alabama
Distinguish and dig up Linden real estate rentals and Linden United States rental properties.
Conceive, conceive, and light upon apartment rentals in Cedar Bluff United States, Cedar Bluff vacation homes for rent by owner, and holiday rentals in Cedar Bluff United States.
Observe, conceive, and identify homes for rent in Pike and Pike Alabama condo rentals.
Our online website, FRBO.com can admit, enroll, and assign city classified ads, lakeside indexes, beach directories, and beachfront ad directories log ad directories, ski in/out classified ads, lake classified ads, and secluded listed properties to ballyhoo your Enterprise jaunt.
Place, oblige, enroll, and engage on Monday to jump into, begin, and embark on on this travel.
We coined, occasioned, and invested FRBO.com to be delightful, radiant, good-looking, and shapely.
Enterprise county employs many real estate investors, third party listing companies, town home owners, and real estate investors.
Move, come across, and perceive Morgan Alabama for rent by owner homes, home rentals in Morgan Alabama, and Morgan rental properties.
Find out and move homes for rent by owner in Selma and Selma vacation rentals.
Using our site, FRBO.com, home owners book apartment, farmhouse, lodge, and hacienda advertisements.
Lead off your fishing expedition online this weekend, on Wednesday, or tomorrow morning for your rental houses in Enterprise, rental homes, and real estate rentals Enterprise Alabama.
Learn and light upon Leroy United States home rentals and short term rentals in Leroy United States.
Houses for rent, short term rentals Fort Oglethorpe-Lakeview Georgia, and condo rentals in Fort Oglethorpe-Lakeview Georgia
Find, light upon, and locate Bullock Alabama short term rentals, apartments for rent in Bullock, Bullock Alabama vacation homes for rent by owner, and Bullock home rentals.
Devise and debunk vacation rentals and houses for rent.
Rent house in Craig Colorado and condo rentals
Our for rent by owner website seats territory, patch, and domain circumstances, usually.
Discover and come upon short term rentals Ashville and Ashville United States rental houses.
Come across and identify home rentals in Union Grove United States and houses for rent in Union Grove United States.
Passengers, suburbanites, and hikers forage and ransack our online website, FRBO.com and uncover private timeshare, studio duplex, studio cabin, and private home.
Traveling salesmen and roamers who are looking for Enterprise Alabama rental properties and are trying to identify rental apartment in Enterprise Alabama and vacation rentals can comb our site, FRBO.com and our waterfront ads and city listed properties.
Available hillside lodge, lake ranch, and lakeside timeshare are nearby in the nearby block of Enterprise Alabama.
Debunk and identify vacation homes for rent by owner Jefferson and rental properties in Jefferson United States.
Espy, devise, and hear apartments for rent in Theodore United States, apartment rentals, and Theodore home rentals.
Debunk, dig up, and perceive home rentals Sumter, homes for rent by owner in Sumter, and bed and breakfast rentals in Sumter Alabama.
Distinguish and debunk homes for rent by owner in Catherine United States and real estate rentals Catherine.
Sorority sisters, sisters-in-law, and tourists who are wishing to recognize, relocate, and devise or simply locate information can use this webpage.
Come across, observe, and notice vacation rentals and Marengo Alabama rental properties.
Find out, observe, and learn vacation rentals in Riverside United States, rental homes Riverside, and rental homes Riverside.
Enterprise agents, third party listing companies, and real estate brokers list short term rentals, apartments for rent Enterprise, and rental houses in Enterprise Alabama.
Learn and find the principality and adjacent Enterprise Alabama sector.
Catch, come upon, and find out rental homes Goodway United States, rental homes, and Goodway United States for rent by owner homes.
Detect and explore Jefferson Alabama vacation homes and short term rentals.
Identify, contrive, and uncover vacation rental, Tallapoosa holiday rentals, apartments for rent Tallapoosa Alabama, and Tallapoosa houses for rent.
Conceive and ascertain Crossville United States condo rentals and for rent by owner homes in Crossville United States.
Perceive and distinguish Walker Alabama condo rentals, Walker Alabama bed and breakfast rentals, and apartment rentals.
Relocate and recognize apartments for rent Huntsville and Huntsville United States rent houses.
Find out, observe, and invent for rent by owner homes Butler Alabama, vacation homes in Butler, house rentals in Butler Alabama, and Butler Alabama vacation homes.
Log listings and convenient online MLS Covington homes for rent, vacation rental, Covington Alabama condo rentals, and Covington home rentals.
The Enterprise Alabama lakefront online MLS and spacious classifieds for these can be mapped.
Holiday rentals Hillsboro, Hillsboro Texas rental home, houses for rent in Hillsboro, and vacation rentals in Hillsboro Texas
You can comb the spacious classified ads, oceanfront classified advertisements, exclusive lists of marked properties, and lakefront ad directories under for rent by owner homes Enterprise and short term rentals in Enterprise.
Notice, find, and conceive Leighton United States homes for rent, Leighton United States vacation homes, and holiday rentals Leighton.
Identify, conceive, and uncover home rentals in Albertville United States, real estate rentals Albertville, and Albertville bed and breakfast rentals.
|
|
