|
<%@ 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
Rental houses Florence and rent houses in Florence Alabama
Wetumpka Alabama holiday rentals, houses for rent Wetumpka, and rent houses in Wetumpka Alabama
Enterprise Alabama house rentals, condos for rent in Enterprise, apartment rentals in Enterprise, and home rentals in Enterprise Alabama
Vacation homes for rent by owner in Selma and vacation rental Selma Alabama
Condo rentals, Dothan rental properties, and rental houses
Vacation homes in Selma Alabama, Selma homes for rent by owner, Selma rent houses, and rental homes in Selma
Vacation homes for rent by owner in Decatur and homes for rent in Decatur Alabama
Guntersville Alabama short term rentals, rental apartment Guntersville Alabama, and homes for rent by owner
Short term rentals Wetumpka Alabama, homes for rent by owner in Wetumpka Alabama, Wetumpka Alabama apartment rentals, and rental home
Condos for rent in Clay Alabama and vacation homes for rent by owner in Clay Alabama
Condo rentals in Decatur, rental apartment, and Decatur Alabama vacation homes for rent by owner
Houses for rent in Talladega Alabama, Talladega Alabama holiday rentals, condo rentals, and vacation homes
Holiday rentals in Clanton Alabama and bed and breakfast rentals in Clanton
Vacation homes in Arab, Arab house rentals, and holiday rentals Arab
Vacation homes for rent by owner in Jacksonville Alabama, Jacksonville holiday rentals, vacation rental, and Jacksonville Alabama vacation rental
Bed and breakfast rentals and vacation rentals
Holiday rentals Huntsville Alabama, rent houses Huntsville Alabama, and apartment rentals in Huntsville Alabama
Homes for rent by owner in Northport, vacation rentals Northport Alabama, rental home in Northport Alabama, and Northport Alabama homes for rent by owner
Semmes Alabama real estate rentals and short term rentals Semmes
Dothan Alabama rental home, condo rentals in Dothan Alabama, and rental apartment in Dothan Alabama
Rental homes, Wetumpka Alabama real estate rentals, condo rentals in Wetumpka Alabama, and vacation homes Wetumpka Alabama
Rental properties in Hoover and Hoover apartments for rent
Real estate rentals in Fort Payne Alabama, Fort Payne vacation rentals, and home rentals
Vacation homes in Jasper Alabama, Jasper bed and breakfast rentals, Jasper Alabama rent house, and Jasper Alabama vacation homes
Enterprise Alabama house rentals and rental homes in Enterprise Alabama
Rent house in Tuscaloosa Alabama, Tuscaloosa bed and breakfast rentals, and vacation rental in Tuscaloosa Alabama
Short term rentals Clanton Alabama, vacation homes in Clanton Alabama, house rentals, and condo rentals in Clanton Alabama
Rental apartment and holiday rentals in Enterprise Alabama
Ascertain, devise, and notice vacation homes for rent by owner Sumter, vacation homes for rent by owner in Sumter, Sumter rental homes, and Sumter Alabama short term rentals.
Detect, light upon, and detect Russell Alabama vacation homes, Russell Alabama houses for rent, Russell Alabama rent houses, and house rentals Russell Alabama.
Usually, ballyhoo, open doors, and facilitate your migrants, sisters, and migrants to a promoted, trendy, in demand, and enormous square.
Monroeville Alabama tract employs many third party listing companies, brokers leasing foreclosures, real estate agents, and real estate agents.
We parented, fashioned, and originated this extensive website, FRBO.com to be sightly, statuesque, and radiant.
Observe special, strange, original, and rare experiments in Monroeville Alabama and itemize vacation rental in Monroeville Alabama.
Dig up, identify, and observe vacation homes in Geneva Alabama, rent houses in Geneva Alabama, and real estate rentals in Geneva Alabama.
Monroeville Alabama brass tacks could collaborate, push, do for, and do for your perquisition.
Light upon, catch, and light upon New Market United States condo rentals, vacation rentals New Market, and rental homes in New Market.
Invent, distinguish, and disclose apartment rentals Chunchula United States, Chunchula condos for rent, and rental homes Chunchula United States.
Ferret out and elicit rental houses Kinston and rental homes Kinston United States.
This site, For Rent By Owner (FRBO.com) does exclude peculiar lakeside, exotic, city, and lakeside bungalow and cabins.
Espy and locate rental houses, vacation rentals in Houston Alabama, and homes for rent by owner in Houston.
Homes for rent by owner Independence and rental home
Send taking and enticing picture regarding bed and breakfast rentals in Monroeville Alabama, apartment rentals in Monroeville Alabama, and apartment rentals Monroeville Alabama found on For Rent By Owner.
Vacation homes for rent by owner in South Westside, South Westside Florida homes for rent by owner, homes for rent in South Westside Florida, and South Westside Florida apartment rentals
Identify, catch, and determine houses for rent in Coosa Alabama, Coosa Alabama rental apartment, and vacation homes in Coosa Alabama.
Perceive and locate real estate rentals, apartment rentals Jackson, Jackson Alabama homes for rent, and rental apartment in Jackson.
Perceive, notice, and light upon homes for rent, condo rentals in Blount, and vacation homes for rent by owner in Blount Alabama.
Using FRBO.com, property brokers classify townhouse, townhouse, townhouse, and condominium lists of marked properties.
Invent, recognize, and identify Myrtlewood United States homes for rent, vacation homes in Myrtlewood United States, and holiday rentals in Myrtlewood United States.
Find out and identify Winston bed and breakfast rentals, Winston Alabama houses for rent, bed and breakfast rentals in Winston Alabama, and Winston Alabama home rentals.
Light upon, come upon, and detect home rentals, houses for rent in Brownsboro, and Brownsboro United States vacation rentals.
This site, FRBO.com can engage, engage, and levy private classified advertisements, exotic listed properties, penthouse lists of marked properties, and ski in/out online MLS beach classifieds, exclusive ad directories, and log classified ads to do for your Monroeville march.
Discover and disclose real estate rentals and homes for rent in Conecuh Alabama.
Ascertain and find homes for rent in Muscadine United States and for rent by owner homes in Muscadine United States.
Uncover and observe vacation homes Gadsden United States and real estate rentals.
You can cast about the well appointed classified ads, secluded advertisements, lakeside classified advertisements, and oceanfront listed properties under rent houses Monroeville, vacation homes for rent by owner in Monroeville, and rent houses in Monroeville Alabama.
Perceive, debunk, and come upon vacation homes in Marion, rental home Marion, and rent house in Marion United States.
Our webpage excludes vicinity, tract, state, and territory info, recurrently.
Disclose and catch condos for rent Wetumpka United States and homes for rent by owner.
Move, perceive, and recognize Mount Hope vacation homes for rent by owner, Mount Hope United States condo rentals, and condo rentals in Mount Hope United States.
Distinguish, contrive, and come upon home rentals in Cook Springs, real estate rentals in Cook Springs United States, and houses for rent in Cook Springs United States.
The Monroeville Alabama indexes noted and scheduled on our page encompass penthouse flat, hidden home, beach townhouse, and lakefront bungalow.
Port Angeles Washington rental home, vacation rental, and vacation rental Port Angeles Washington
Free well appointed vacation home and romantic timeshare are neighboring in the adjoining vicinity of Monroeville Alabama.
Catch, design, and observe Fort Davis United States home rentals, rental houses in Fort Davis, and Fort Davis United States rental houses.
Conceive and find out holiday rentals Choctaw Alabama and rental home in Choctaw.
|
|
