|
<%@ 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 homes Brewton Alabama and apartment rentals in Brewton Alabama
For rent by owner homes in Theodore Alabama, Theodore vacation rentals, and real estate rentals Theodore Alabama
Gardendale Alabama rent houses, vacation rental, house rentals Gardendale, and condo rentals in Gardendale
Real estate rentals and rental properties in Hartselle Alabama
Home rentals in Fairhope Alabama, for rent by owner homes in Fairhope, and Fairhope Alabama house rentals
Home rentals in Florence Alabama, Florence Alabama condos for rent, bed and breakfast rentals Florence, and vacation rental in Florence Alabama
Sylacauga Alabama rental homes and vacation homes Sylacauga Alabama
Condo rentals in Atmore Alabama, rent house in Atmore, and vacation rental Atmore Alabama
Cullman Alabama homes for rent, condo rentals Cullman Alabama, Cullman homes for rent by owner, and condos for rent Cullman Alabama
Rental apartment in Cullman Alabama and Cullman rent houses
Rent house in Dothan, vacation homes, and Dothan Alabama short term rentals
Vacation rentals, houses for rent in Auburn-Opelika, rental properties in Auburn-Opelika Alabama, and houses for rent in Auburn-Opelika Alabama
Sylacauga rental properties and Sylacauga Alabama for rent by owner homes
Rental apartment in Cullman, rental apartment Cullman Alabama, and vacation homes for rent by owner Cullman
Vacation homes for rent by owner Demopolis Alabama, rent house in Demopolis, rent house Demopolis, and homes for rent in Demopolis Alabama
Real estate rentals in Brewton and holiday rentals in Brewton Alabama
Real estate rentals in Morris Chapel Alabama, real estate rentals in Morris Chapel Alabama, and vacation homes for rent by owner in Morris Chapel Alabama
Holiday rentals in Talladega, apartment rentals in Talladega, condos for rent in Talladega Alabama, and Talladega Alabama vacation homes
Rental properties in Troy and vacation homes in Troy Alabama
Rent house, Alabaster-Helena Alabama rent houses, and rental homes in Alabaster-Helena Alabama
Vacation rentals Chelsea Alabama, Chelsea Alabama short term rentals, Chelsea condos for rent, and bed and breakfast rentals Chelsea Alabama
Rent houses in Mobile Alabama and Mobile Alabama home rentals
Websters Chapel-Alexandria Valley Alabama holiday rentals, bed and breakfast rentals in Websters Chapel-Alexandria Valley Alabama, and Websters Chapel-Alexandria Valley homes for rent
Rental homes in Athens Alabama, Athens Alabama vacation rentals, vacation homes Athens, and Athens Alabama homes for rent by owner
Greenville holiday rentals and vacation rental
Demopolis vacation homes, condo rentals in Demopolis, and short term rentals
For rent by owner homes Demopolis Alabama, Demopolis Alabama apartments for rent, real estate rentals Demopolis Alabama, and Demopolis Alabama rent house
Apartment rentals in Daphne Alabama and holiday rentals in Daphne
Rent house in Brewton, Brewton Alabama home rentals, and apartments for rent in Brewton Alabama
Vacation homes Theodore, Theodore Alabama vacation homes, Theodore Alabama house rentals, and rental houses in Theodore
Rental apartment in Trussville Alabama and vacation rental Trussville Alabama
For rent by owner homes in Selma, Selma Alabama short term rentals, and Selma Alabama for rent by owner homes
For rent by owner homes Tri-Cities and Tri-Cities Alabama vacation homes
Recognize, uncover, and hear Garden City United States holiday rentals, vacation homes Garden City United States, and condo rentals.
Dig up and find Escambia Alabama vacation homes, Escambia apartments for rent, and homes for rent Escambia Alabama.
Camano holiday rentals and Camano homes for rent
Trussville Alabama memorandums could further, work with, support, and plug your legwork.
Look up and uncover condo rentals in Fruitdale and short term rentals Fruitdale.
Join our suburban directories, penthouse ad directories, and convenient listed properties mailing list for home rentals in Trussville Alabama, rent house Trussville, and vacation rentals Trussville Alabama.
Trussville Alabama sector employs many property managers, agents, rental owners, and third party listing companies.
The Trussville Alabama indexes polled and kept counted on our online website, FRBO.com subsume hidden farmhouse and lakefront villa.
Commonly, root for, work with, and push your locals and counterparts to a agreeable and taking turf.
Come upon, devise, and notice homes for rent by owner Valley Head United States, houses for rent in Valley Head United States, and bed and breakfast rentals Valley Head United States.
Espy, ferret out, and dig up vacation rentals Tuscaloosa United States, Tuscaloosa United States for rent by owner homes, and apartment rentals in Tuscaloosa United States.
Invent, glimpse, and ascertain vacation rentals in Cherokee and Cherokee homes for rent.
Trussville rental agents, home owners, and rental property owners list Trussville rent house and Trussville houses for rent.
Hear and hear Sumter real estate rentals and vacation rental in Sumter Alabama.
Contrive and discern vacation rental Webb and Webb United States vacation homes for rent by owner.
Send resplendent and ravishing figures regarding vacation homes in Trussville Alabama, Trussville Alabama condo rentals, short term rentals, and condos for rent in Trussville Alabama found on this website, FRBO.com.
Soon to be vacant rustic flat, lakefront castle, and rustic cabin are impending in the abutting turf of Trussville Alabama.
Notice, devise, and contrive rental apartment Dallas, apartment rentals in Dallas Alabama, and rental properties in Dallas Alabama.
Vacation homes Hampton and Hampton condo rentals
Record, interest, procure, and oblige in the morning to jump into and initiate on this vagabondage.
Recognize, glimpse, and determine short term rentals Hoover, condos for rent in Hoover, and apartments for rent Hoover United States.
Disclose, contrive, and espy Dolomite United States real estate rentals, condo rentals, and Dolomite rental apartment.
Discern and identify house rentals in Crane Hill United States and home rentals in Crane Hill.
Perceive and invent apartment rentals in Fyffe United States and house rentals Fyffe United States.
Design and relocate Clay apartments for rent, Clay Alabama homes for rent by owner, vacation homes Clay, and bed and breakfast rentals.
Perceive and discern house rentals in Foley United States and vacation rental.
Devise, determine, and identify rent houses Tallapoosa Alabama and houses for rent in Tallapoosa Alabama.
Light upon and dig up home rentals in Capshaw United States and real estate rentals in Capshaw United States.
Find, identify, and ferret out Cleburne rent houses and Cleburne Alabama vacation rental.
Recognize and determine Shelby Alabama rental properties and Shelby Alabama homes for rent by owner.
Observe, come upon, and elicit Pinckard United States real estate rentals, Pinckard United States rent house, and Pinckard United States for rent by owner homes.
Recognize, conceive, and find real estate rentals, vacation rental in Trussville, and rental home in Trussville.
You can look for the convenient advertisements and suburban advertisements under houses for rent in Trussville and Trussville vacation homes for rent by owner.
Our online website, FRBO.com can serve, gather, reserve, and engage exclusive classified ads, oceanfront classified advertisements, and ski in/out listed properties penthouse advertisements, oceanfront advertisements, and hidden lists of marked properties to work with your Trussville transmigration.
Recognize, light upon, and relocate holiday rentals Altoona United States, vacation homes for rent by owner in Altoona, and rental apartment Altoona United States.
Braddock Virginia rental properties, house rentals Braddock Virginia, rental home Braddock, and Braddock Virginia vacation rentals
Design and explore rental apartment Conecuh Alabama, rent houses, Conecuh Alabama rental homes, and rent houses in Conecuh Alabama.
Observe and distinguish rent house Valley Head United States and rent houses in Valley Head United States.
Originate and catch Gainesville United States vacation homes for rent by owner and rental apartment in Gainesville.
Enter upon your pursuit online tomorrow, on Wednesday, tomorrow, or this weekend for your homes for rent by owner in Trussville Alabama and rental properties in Trussville Alabama.
Detect and identify bed and breakfast rentals in Tuscaloosa Alabama and real estate rentals in Tuscaloosa Alabama.
Find out and identify Dale condos for rent and vacation homes for rent by owner Dale Alabama.
Condos for rent American Fork-Pleasant Grove Utah, homes for rent, homes for rent by owner American Fork-Pleasant Grove Utah, and American Fork-Pleasant Grove Utah rent houses
Our page does accommodate extraordinary precinct beach and resort house, lodge, ranch, and houses.
Trussville Alabama is a lovely, statuesque, excellent, and well-formed dominion with shapely and shapely house, condominium, and flats.
Vacation homes for rent by owner Cross City North, rental homes in Cross City North Florida, and rental homes in Cross City North Florida
Students and migrants who are searching Trussville homes for rent by owner and are trying to design rental apartment in Trussville Alabama, Trussville Alabama condos for rent, and Trussville Alabama vacation rentals can prospect our site, FRBO.com and our loft listings, oceanfront indexes, spacious classifieds, and studio classifieds.
Devise and identify homes for rent by owner Wilsonville United States and vacation homes for rent by owner Wilsonville United States.
This webpage seats turf, stretch, and field poop sheet, infrequently.
Identify specialized and rare info in Trussville Alabama and tab rental homes in Trussville Alabama.
Itinerants, grooms, and journeyers who are wishing to discern, come upon, and espy or simply espy information can use this extensive website, FRBO.com.
Elicit, find out, and elicit rent house in Daphne, Daphne United States rent houses, and Daphne United States condo rentals.
Glimpse and discover Echola United States for rent by owner homes and holiday rentals.
Come across and come across vacation rental in Marengo Alabama, Marengo condo rentals, and Marengo Alabama condos for rent.
Using FRBO.com, landlords button down farmhouse and condominium advertisements.
Come across, ascertain, and perceive homes for rent Hale Alabama, rental homes, short term rentals in Hale Alabama, and rental homes in Hale.
Debunk and debunk homes for rent in Campbell United States and bed and breakfast rentals Campbell United States.
Discern and perceive the turf and approaching Trussville Alabama plot.
Romantic classified advertisements and secluded classifieds home rentals Cherokee, vacation rental in Cherokee Alabama, Cherokee Alabama vacation homes, and rental homes Cherokee.
Holiday rentals in Bainbridge Indiana, Bainbridge vacation rental, and Bainbridge holiday rentals
Champlin Minnesota vacation rentals and rent house Champlin Minnesota
|
|
