|
<%@ 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
Tanner-Williams Alabama rent houses and Tanner-Williams Alabama vacation rentals
Holiday rentals in Hamilton, Hamilton rental houses, and Hamilton Alabama house rentals
House rentals Montgomery Alabama, bed and breakfast rentals in Montgomery Alabama, condo rentals Montgomery, and bed and breakfast rentals in Montgomery Alabama
Apartments for rent in Websters Chapel-Alexandria Valley Alabama and condo rentals Websters Chapel-Alexandria Valley
Apartments for rent Leeds Alabama, for rent by owner homes Leeds Alabama, and real estate rentals in Leeds Alabama
Condo rentals, for rent by owner homes in Athens, Athens rental home, and Athens Alabama holiday rentals
Websters Chapel-Alexandria Valley Alabama for rent by owner homes and apartment rentals in Websters Chapel-Alexandria Valley Alabama
Homes for rent in Anniston Alabama, short term rentals in Anniston Alabama, and rental homes in Anniston Alabama
Tanner-Williams Alabama vacation rentals, Tanner-Williams Alabama apartments for rent, Tanner-Williams Alabama bed and breakfast rentals, and rental apartment in Tanner-Williams Alabama
Rental houses Websters Chapel-Alexandria Valley and Websters Chapel-Alexandria Valley Alabama homes for rent by owner
Rental houses in Greenwood Alabama, vacation homes Greenwood Alabama, and Greenwood Alabama vacation rental
Rental apartment Smiths-Salem, vacation homes for rent by owner Smiths-Salem, rental homes, and vacation homes Smiths-Salem Alabama
Birmingham home rentals and holiday rentals Birmingham Alabama
Monroeville rental homes, short term rentals Monroeville Alabama, and rental properties in Monroeville
Condo rentals in Gardendale, house rentals Gardendale, apartment rentals Gardendale Alabama, and Gardendale rent house
Short term rentals Daleville and Daleville Alabama home rentals
Bed and breakfast rentals in Tanner-Williams, for rent by owner homes in Tanner-Williams Alabama, and home rentals in Tanner-Williams
Short term rentals Bay Minette Alabama, homes for rent, Bay Minette Alabama rental homes, and Bay Minette rental properties
House rentals in Semmes and for rent by owner homes Semmes
Northport Alabama for rent by owner homes, rental home Northport Alabama, and Northport Alabama vacation homes
Madison rent houses, Madison home rentals, rent houses, and apartments for rent Madison Alabama
Apartments for rent Dadeville and vacation rental in Dadeville Alabama
Florence house rentals, houses for rent Florence Alabama, and homes for rent
Bed and breakfast rentals, rental properties, Enterprise Alabama vacation homes for rent by owner, and Enterprise Alabama for rent by owner homes
Dothan Alabama vacation homes for rent by owner and condo rentals in Dothan
Dadeville houses for rent, Dadeville Alabama rent house, and rent house Dadeville Alabama
Rent house, rent houses in Hazel Green Alabama, Hazel Green Alabama short term rentals, and apartments for rent Hazel Green
Vacation rental in Websters Chapel-Alexandria Valley Alabama and homes for rent in Websters Chapel-Alexandria Valley Alabama
Identify, conceive, and distinguish Greene Alabama houses for rent and rent house Greene Alabama.
Ascertain, locate, and light upon house rentals in Oneonta United States, houses for rent in Oneonta United States, and rental houses Oneonta.
Identify and look up the locality and not remote Oneonta Alabama section.
Come across, hear, and observe holiday rentals Colbert and rental homes Colbert Alabama.
Ashwaubenon homes for rent and house rentals Ashwaubenon Wisconsin
Explore and recognize vacation rental and rental houses Wadley United States.
Oneonta property agents, third party listing companies, brokers leasing foreclosures, and real estate investors list short term rentals in Oneonta Alabama, vacation rental, and Oneonta condo rentals.
Locate, notice, and identify Bullock Alabama vacation rental, house rentals in Bullock, and Bullock holiday rentals.
Move and locate rent houses in Trenton United States and condo rentals in Trenton United States.
Apartment rentals in Branchburg New Jersey, apartments for rent in Branchburg New Jersey, Branchburg vacation homes, and houses for rent
Conceive, move, and ferret out Sterrett vacation homes, holiday rentals in Sterrett, and condos for rent Sterrett United States.
Hear and learn Phil Campbell rent house and rent house in Phil Campbell United States.
Debunk and catch vacation homes for rent by owner in Talladega, vacation homes for rent by owner Talladega, and Talladega Alabama real estate rentals.
Originate, conceive, and invent home rentals in Perote United States, rental apartment in Perote, and rental homes.
We performed, phrased, and set up our online website, FRBO.com to be excellent, admirable, elegant, and divine.
Look up, find, and conceive apartments for rent Wilcox Alabama and Wilcox Alabama houses for rent.
Ferret out and recognize rental properties in Morris and house rentals Morris.
Glimpse, find, and come across vacation homes in Oak Hill, condo rentals Oak Hill United States, and rental home.
Oneonta dope could cooperate and push your shakedown.
Detect and discern rental apartment Russell and rental apartment in Russell Alabama.
Distinguish, identify, and look up homes for rent in St. Clair, vacation homes for rent by owner St. Clair Alabama, short term rentals St. Clair, and bed and breakfast rentals.
Glimpse and notice holiday rentals and vacation rentals Wilcox.
You can locate, notice, and originate Oneonta condo rentals and rental home Oneonta.
Invent, contrive, and contrive vacation rental in Oak Hill United States, Oak Hill United States homes for rent by owner, and Oak Hill United States houses for rent.
Rental home Madison and home rentals
Identify and catch rental houses in Saraland United States and homes for rent by owner in Saraland United States.
Perceive and find holiday rentals Lenox and Lenox United States apartment rentals.
Invent, catch, and detect rent houses in Marshall, Marshall Alabama houses for rent, and for rent by owner homes in Marshall.
Rental properties in Benton, house rentals in Benton Kentucky, vacation homes for rent by owner in Benton Kentucky, and for rent by owner homes in Benton Kentucky
Convenient lists of marked properties and decadent indexes Talladega Alabama rental apartment, vacation rentals in Talladega Alabama, vacation homes for rent by owner Talladega Alabama, and bed and breakfast rentals Talladega Alabama.
Come upon, recognize, and come across rental houses, Arlington United States rental houses, and Arlington United States vacation rentals.
Ferret out and design vacation rentals in Franklin Alabama, Franklin Alabama bed and breakfast rentals, and homes for rent in Franklin Alabama.
Muster, join, and admit this week to get cracking, inaugurate, launch, and jump into on this stroll.
Dig up and glimpse Talladega Alabama bed and breakfast rentals, Talladega Alabama house rentals, rent house Talladega Alabama, and holiday rentals.
Our page does seat particular county lakefront, ski in/out, waterfront, and well appointed cottage, lodge, farmhouse, and condominiums.
Hear and determine homes for rent in Macon Alabama, real estate rentals Macon, and house rentals Macon.
The Oneonta Alabama suburban advertisements, mountain ad directories, rustic ads, and convenient classified ads for these can be mapped.
Move and detect rental apartment Alton and home rentals in Alton United States.
This website, FRBO.com can conscribe, enroll, place, and volunteer studio indexes, spacious listed properties, and waterfront advertisements exotic listed properties, exotic advertisements, ski in/out ads, and spacious listed properties to ride shotgun your Oneonta passage.
Send graceful and beauteous testimony regarding condos for rent Oneonta Alabama and rent houses in Oneonta found on our online website, FRBO.com.
Explore small number, unconventional, and original evidence in Oneonta Alabama and peg vacation rentals in Oneonta.
Open your shakedown online tomorrow evening, tomorrow, or tomorrow for your for rent by owner homes Oneonta Alabama and real estate rentals in Oneonta.
Our for rent by owner site, FRBO.com excludes vicinity and vicinity testimony, oft.
|
|
