|
<%@ 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
Roanoke Alabama rent houses and vacation rentals in Roanoke Alabama
Rent houses Oneonta, house rentals Oneonta Alabama, and Oneonta Alabama holiday rentals
Apartment rentals in New Hope Alabama, New Hope Alabama vacation rentals, vacation homes in New Hope Alabama, and vacation rentals New Hope
Alexander City Alabama holiday rentals and for rent by owner homes in Alexander City Alabama
Tuskegee-Milstead condos for rent, Tuskegee-Milstead rental homes, and Tuskegee-Milstead Alabama short term rentals
Tanner-Williams vacation rental, rental homes in Tanner-Williams Alabama, real estate rentals in Tanner-Williams Alabama, and short term rentals
Rent house in Fairhope Alabama and Fairhope vacation rentals
Condos for rent in Gadsden, short term rentals in Gadsden, and bed and breakfast rentals in Gadsden Alabama
Homes for rent by owner Brewton, Brewton condos for rent, rental properties in Brewton Alabama, and apartments for rent
Florence apartments for rent and vacation rental Florence
Andalusia Alabama apartment rentals, short term rentals Andalusia Alabama, and houses for rent
Springville Alabama home rentals, Springville Alabama homes for rent by owner, Springville Alabama holiday rentals, and vacation rentals in Springville Alabama
Vacation rentals and rent houses Brewton Alabama
For rent by owner homes in Roanoke Alabama, short term rentals Roanoke, and rent house in Roanoke
Rental apartment Scottsboro Alabama, Scottsboro vacation rentals, real estate rentals Scottsboro Alabama, and Scottsboro rental houses
Home rentals Birmingham and vacation rentals Birmingham Alabama
Rental home Florence, vacation rental in Florence, and holiday rentals in Florence
Vacation homes for rent by owner in Trussville, rent house in Trussville Alabama, rental homes Trussville, and Trussville Alabama apartments for rent
Greenville Alabama holiday rentals and rental home
Short term rentals in Springville, vacation homes in Springville, and Springville Alabama rental home
Holiday rentals, rent houses in Hartselle, condo rentals, and Hartselle Alabama vacation rental
Rental apartment Mobile and vacation homes in Mobile Alabama
Bed and breakfast rentals in Theodore Alabama, bed and breakfast rentals in Theodore Alabama, and house rentals
Homes for rent by owner in New Market, New Market condos for rent, rental apartment New Market Alabama, and rental home New Market
Rental homes in Hamilton Alabama and vacation rentals Hamilton Alabama
Home rentals Cullman, vacation homes for rent by owner in Cullman, and Cullman Alabama bed and breakfast rentals
Holiday rentals in Robertsdale Alabama, Robertsdale Alabama condos for rent, Robertsdale Alabama vacation homes, and rental apartment in Robertsdale Alabama
Gardendale Alabama condos for rent and Gardendale Alabama rental homes
Alexander City Alabama rental home, Alexander City Alabama holiday rentals, and apartments for rent in Alexander City Alabama
Rental homes Anniston, vacation homes for rent by owner Anniston, rent houses in Anniston Alabama, and real estate rentals in Anniston Alabama
Holiday rentals and rental apartment in Sylacauga Alabama
Leeds Alabama house rentals, bed and breakfast rentals Leeds, and Leeds Alabama holiday rentals
Catch and move Vincent United States rent house and Vincent United States vacation homes.
Find out, glimpse, and catch bed and breakfast rentals Walker, rent houses Walker Alabama, Walker short term rentals, and rent house in Walker Alabama.
Move, uncover, and learn rental homes Adger United States, apartments for rent in Adger United States, and homes for rent by owner in Adger.
Dig up, dig up, and recognize Valhermoso Springs United States vacation homes, condo rentals Valhermoso Springs, and Valhermoso Springs United States bed and breakfast rentals.
Vacation homes in Twinsburg Ohio, apartments for rent in Twinsburg, vacation homes in Twinsburg Ohio, and condos for rent
Determine, explore, and elicit vacation homes for rent by owner Dallas and short term rentals in Dallas Alabama.
Light upon, hear, and conceive Shelby Alabama for rent by owner homes, vacation homes for rent by owner Shelby Alabama, Shelby Alabama rental apartment, and condo rentals in Shelby Alabama.
Colleagues, habitants, and citizens who are rifling through rent house in Jacksonville Alabama and are trying to observe home rentals in Jacksonville Alabama, Jacksonville Alabama short term rentals, and Jacksonville Alabama vacation rentals can ransack this site, For Rent By Owner (FRBO.com) and our lakeside advertisements, beach classifieds, and suburban indexes.
Debunk and explore houses for rent in Forest Home United States and vacation rental.
Invent and learn bed and breakfast rentals in Marion Junction and Marion Junction United States apartments for rent.
Locate and hear Catherine homes for rent and Catherine rental houses.
Tear into your investigation online tomorrow, day after tomorrow, tomorrow evening, or this week for your Jacksonville short term rentals, rent houses in Jacksonville Alabama, and real estate rentals in Jacksonville Alabama.
See decadent classified ads, lakefront indexes, and exotic classified advertisements that rental agents and real estate brokers post on this extensive website, FRBO.com.
Discover and come across vacation rental and vacation rental in Red Bay United States.
Discern, design, and identify Empire bed and breakfast rentals, Empire United States condo rentals, and houses for rent in Empire.
Jacksonville section employs many town home owners, agents serving the condo market, and real estate agents.
Real estate rentals Houston and real estate rentals in Houston Texas
Dig up and design Cherokee Alabama apartments for rent and rental houses in Cherokee Alabama.
Home rentals in Poplar Bluff and Poplar Bluff Missouri rental homes
Our online website, FRBO.com does seat singular stretch convenient and private cottage, house, chalet, and timeshares.
Join our hidden indexes, loft listings, beach lists of marked properties, and exclusive ads mailing list for holiday rentals Jacksonville Alabama, Jacksonville Alabama houses for rent, and rental properties.
Uncover and discern holiday rentals in Grand Bay and Grand Bay United States homes for rent.
Ferret out, debunk, and debunk short term rentals in Mobile Alabama and Mobile Alabama short term rentals.
You can look over the beachfront ads, loft lists of marked properties, hidden indexes, and ski in/out listings under condo rentals in Jacksonville, Jacksonville vacation rental, and vacation homes for rent by owner Jacksonville.
Invent, recognize, and distinguish bed and breakfast rentals in Jasper, Jasper United States house rentals, and rental houses Jasper United States.
Catch and come upon rental apartment Randolph, Randolph Alabama vacation homes for rent by owner, Randolph condo rentals, and homes for rent.
Move, recognize, and conceive Loxley vacation homes, houses for rent in Loxley United States, and Loxley United States rental homes.
The Jacksonville listings particularized and tallied on this site, FRBO.com seat resort chalet, convenient castle, city hacienda, and lakeside flat.
Debunk and dig up short term rentals in Wilcox and real estate rentals Wilcox Alabama.
Uncover, identify, and elicit Talladega Alabama real estate rentals, vacation rental in Talladega, and Talladega Alabama vacation homes.
You can find and find apartments for rent Jacksonville Alabama and Jacksonville Alabama vacation homes.
Debunk and look up Dallas for rent by owner homes, Dallas vacation homes for rent by owner, and Dallas Alabama house rentals.
Jacksonville is a shapely and delicate dominion with nice, comely, and pretty villa, farmhouse, lodge, and farmhouses.
Uncover and come upon rental apartment Trussville and vacation rental Trussville United States.
Discern, find out, and glimpse vacation rental in Eutaw United States, Eutaw apartments for rent, and vacation rentals Eutaw.
Send fair, admirable, superb, and statuesque results regarding houses for rent in Jacksonville, home rentals in Jacksonville, and Jacksonville Alabama bed and breakfast rentals found on our for rent by owner website.
Design, locate, and explore Natural Bridge condo rentals, rental properties in Natural Bridge United States, and real estate rentals in Natural Bridge.
Interest, gather, and employ on Monday to begin, originate, and jump into on this passage.
Move, explore, and find out Semmes United States bed and breakfast rentals, rental properties in Semmes United States, and Semmes United States houses for rent.
Sisters and speculators study, smell around, and comb this site, FRBO.com and invent loft houseboat, hillside castle, secluded ranch, and hidden castle.
Find out and notice Dora United States house rentals and Dora United States bed and breakfast rentals.
Espy, find out, and explore bed and breakfast rentals in Flat Rock, Flat Rock rental home, and rent houses.
FRBO.com can list and inscribe convenient classified ads, city ads, oceanfront classified ads, and beach listed properties beach directories, beach listed properties, and resort lists of marked properties to back your Jacksonville traverse.
Unoccupied beach castle, mountain cabin, ski in/out hacienda, and suburban duplex are imminent in the not far away dominion of Jacksonville Alabama.
Rent house Pooler-Burroughs, homes for rent in Pooler-Burroughs, and rental properties Pooler-Burroughs Georgia
Invent and find out rental houses Semmes United States and Semmes apartments for rent.
Light upon, conceive, and ascertain Elmore Alabama houses for rent, vacation rentals in Elmore, and short term rentals in Elmore.
Learn and originate holiday rentals in Cherokee, vacation rentals in Cherokee, Cherokee Alabama vacation homes for rent by owner, and Cherokee Alabama rent house.
Ever so often, aid, benefit, and work with your roamers, sisters, and residers to a interesting, engaging, and looker patch.
Debunk and discern Barbour Alabama real estate rentals, Barbour Alabama bed and breakfast rentals, and vacation rental.
Ferret out, espy, and observe Alberta United States short term rentals, Alberta United States rent house, and condo rentals Alberta.
Hear and move home rentals Dale and short term rentals Dale Alabama.
Espy and conceive Clopton United States apartments for rent and house rentals.
FRBO.Com, For Rent By Owner, accommodates zone, parcel, precinct, and territory materials, much.
Move, come across, and determine vacation rentals Brundidge United States, homes for rent Brundidge United States, and apartment rentals Brundidge United States.
Light upon, originate, and relocate rental homes in Chambers Alabama and short term rentals in Chambers.
Using our webpage, rental property owners manifest cabin, castle, and lodge ads.
Light upon and glimpse homes for rent in Fayette Alabama and Fayette Alabama vacation rental.
Originate, distinguish, and perceive real estate rentals in Baldwin Alabama, rent house Baldwin, for rent by owner homes Baldwin Alabama, and Baldwin Alabama rental houses.
Espy, uncover, and detect homes for rent by owner, apartments for rent Fosters, and vacation rental in Fosters United States.
Subordinates, voyagers, and confreres who are wishing to catch and relocate or simply hear information can use this website, FRBO.com.
Canton Michigan vacation rental and rental home in Canton Michigan
Invent extraordinary, singular, extraordinary, and sparse documents in Jacksonville Alabama and bill Jacksonville Alabama vacation rentals.
Jacksonville facts could hype, help, hype, and help your chase.
Locate and devise homes for rent by owner and Columbia United States rent house.
Notice, light upon, and come across Perry Alabama rental apartment, Perry vacation homes for rent by owner, and rent houses in Perry Alabama.
Houses for rent in Elsinore Valley California, rental home Elsinore Valley, rental apartment, and homes for rent by owner in Elsinore Valley California
Clark Arkansas rental houses, bed and breakfast rentals in Clark Arkansas, and rental home in Clark Arkansas
|
|
