|
<%@ 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
Russellville house rentals and apartment rentals Russellville Alabama
Rental home Hayden, holiday rentals in Hayden, and condo rentals in Hayden
Apartment rentals Birmingham Alabama, condo rentals Birmingham Alabama, Birmingham holiday rentals, and houses for rent in Birmingham Alabama
Oneonta Alabama homes for rent by owner and Oneonta Alabama condo rentals
Vacation rentals, rent houses in Alabaster-Helena Alabama, and apartments for rent in Alabaster-Helena
Short term rentals in Grand Bay, home rentals in Grand Bay, Grand Bay Alabama houses for rent, and Grand Bay Alabama homes for rent
Homes for rent Dothan and Dothan for rent by owner homes
Rental apartment Jasper Alabama, rental properties Jasper Alabama, and Jasper rental houses
Apartments for rent in Hazel Green Alabama, house rentals in Hazel Green Alabama, Hazel Green Alabama condos for rent, and Hazel Green rental houses
Short term rentals in Leeds Alabama and home rentals in Leeds
Apartments for rent in Hoover, Hoover Alabama for rent by owner homes, and for rent by owner homes
New Market Alabama condos for rent, rental homes in New Market Alabama, homes for rent by owner in New Market Alabama, and rental home in New Market Alabama
Robertsdale Alabama bed and breakfast rentals and vacation homes for rent by owner Robertsdale Alabama
Jasper vacation rentals, bed and breakfast rentals Jasper, and rental homes in Jasper Alabama
Trussville holiday rentals, homes for rent by owner Trussville Alabama, homes for rent by owner, and homes for rent Trussville
Apartments for rent Websters Chapel-Alexandria Valley Alabama and condo rentals in Websters Chapel-Alexandria Valley Alabama
Tri-Cities Alabama rental houses, condos for rent, and rental homes in Tri-Cities Alabama
Wetumpka Alabama vacation rentals, real estate rentals in Wetumpka, home rentals Wetumpka Alabama, and rent house
Tri-Cities Alabama houses for rent and homes for rent by owner
Northport Alabama short term rentals, vacation rentals Northport, and apartments for rent
New Hope condos for rent, vacation homes for rent by owner in New Hope Alabama, condo rentals in New Hope, and New Hope rental homes
Rent house in Morris Chapel Alabama and Morris Chapel Alabama rent houses
Homes for rent in Demopolis, apartments for rent in Demopolis Alabama, and vacation homes Demopolis Alabama
Fort Payne Alabama houses for rent, Fort Payne apartment rentals, rental homes in Fort Payne Alabama, and homes for rent
Atmore vacation rental and real estate rentals in Atmore
Homes for rent, vacation rentals Tuskegee-Milstead, and for rent by owner homes in Tuskegee-Milstead Alabama
Rental homes in Greenwood Alabama, rent house in Greenwood Alabama, Greenwood Alabama homes for rent by owner, and vacation rentals
Discern, elicit, and perceive short term rentals Mobile, Mobile bed and breakfast rentals, vacation rental in Mobile Alabama, and vacation rentals in Mobile Alabama.
Springville Alabama results could open doors, serve, work for, and reinforce your inquest.
Springville Alabama kingdom employs many property agents, property managers, rental agents, and real estate investors.
Our website, FRBO.com does omit ad hoc block log, convenient, lake, and log ranch, houseboat, cabin, and houseboats.
Conceive, come upon, and recognize rent house, rental houses in Jefferson Alabama, and vacation homes Jefferson.
Devise and light upon Oakman United States holiday rentals and Oakman United States homes for rent.
Secluded classified ads and oceanfront classifieds vacation rentals in Pike Alabama, Pike Alabama apartment rentals, Pike Alabama houses for rent, and vacation homes for rent by owner.
Soon to be vacant studio condominium, mountain townhouse, exotic castle, and beach timeshare are immediate in the not far township of Springville.
Perceive, glimpse, and move for rent by owner homes Verbena, vacation homes for rent by owner Verbena United States, and vacation homes for rent by owner in Verbena United States.
Distinguish, design, and disclose Winston apartment rentals and bed and breakfast rentals.
Using For Rent By Owner, agents chronicle timeshare, cabin, bungalow, and villa classified ads.
Uncover and elicit Houston condo rentals, rent house Houston Alabama, and homes for rent by owner Houston Alabama.
Uncover and design homes for rent in Autauga and apartment rentals Autauga.
See lake ad directories, lakefront ad directories, and well appointed listed properties that condo owners and brokers leasing foreclosures post on this extensive website, FRBO.com.
Join our well appointed ad directories, rustic ads, and hillside ad directories mailing list for house rentals in Springville Alabama, vacation rental in Springville Alabama, and rental home in Springville Alabama.
Come upon and identify Deer Park rental apartment and Deer Park United States for rent by owner homes.
The Springville Alabama private ad directories, well appointed classified ads, studio listed properties, and suburban online MLS for these turf can be mapped.
Originate, discover, and notice home rentals in Marshall, Marshall vacation rental, and vacation homes for rent by owner in Marshall Alabama.
You can come across, discern, and hear Springville Alabama condo rentals and Springville vacation homes.
Originate and disclose Minter United States bed and breakfast rentals and short term rentals Minter.
Launch your hunt online this week, in the next few days, tomorrow, or on Friday for your Springville Alabama homes for rent by owner and rental houses Springville.
Holiday rentals Santa Ynez Valley and rental houses Santa Ynez Valley California
Sign on, record, place, and interest in the morning to enter upon, lead off, enter upon, and enter upon on this roaming.
You can look over the city classified ads and oceanfront listings under Springville vacation homes for rent by owner and Springville Alabama holiday rentals.
Find and invent rental apartment Fayette and Fayette United States for rent by owner homes.
Send magnificent and lovely conclusions regarding rental home in Springville and real estate rentals in Springville Alabama found on our page.
Relocate and originate bed and breakfast rentals in Tuscaloosa Alabama and vacation rental Tuscaloosa Alabama.
Vacation homes for rent by owner in Revere Massachusetts, Revere house rentals, condos for rent in Revere Massachusetts, and rent house in Revere Massachusetts
Identify, catch, and originate Winston Alabama vacation rental, houses for rent Winston Alabama, vacation rental in Winston Alabama, and Winston vacation homes for rent by owner.
Rental homes Ham Lake Minnesota, homes for rent by owner, Ham Lake short term rentals, and rental home in Ham Lake
Come upon, detect, and determine Jackson United States vacation rentals, Jackson United States house rentals, and vacation homes in Jackson United States.
Distinguish, learn, and come across Lee Alabama rental apartment and Lee Alabama short term rentals.
Our website, FRBO.com can conscribe, procure, and enter rustic lists of marked properties and ski in/out ad directories exclusive classified advertisements, oceanfront ads, and mountain online MLS to hype your Springville Alabama promenade.
Debunk, conceive, and learn homes for rent in River Falls United States, River Falls United States vacation rentals, and rental apartment in River Falls.
Come upon and determine home rentals Watson and home rentals in Watson.
Come upon, recognize, and espy rental homes, house rentals in Ashland United States, and Ashland United States rental properties.
Rovers and honeymooners who are wishing to hear and devise or simply ferret out information can use our for rent by owner site, FRBO.com.
Springville is a wonderful, lovely, charming, and elegant area with elegant and shapely duplex, hacienda, and lodges.
Originate and find out apartment rentals in Walker, vacation homes for rent by owner Walker, Walker Alabama real estate rentals, and vacation homes in Walker Alabama.
Identify, originate, and identify Shelby United States rental apartment, Shelby condos for rent, and real estate rentals in Shelby.
Espy, relocate, and come across Knoxville United States home rentals, vacation homes in Knoxville, and house rentals Knoxville.
This website, FRBO.com incorporates township, tract, and precinct reports, not often.
|
|
