|
<%@ 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
Apartments for rent in Killen and Killen Alabama rent houses
Brewton Alabama apartment rentals, Brewton homes for rent by owner, and holiday rentals in Brewton
Jemison Alabama apartments for rent, rental apartment Jemison Alabama, home rentals, and Jemison Alabama rental houses
Condos for rent in Morris Chapel Alabama and apartments for rent in Morris Chapel Alabama
Athens homes for rent, home rentals, and houses for rent in Athens Alabama
Talladega Alabama rental homes, vacation homes for rent by owner in Talladega Alabama, house rentals, and Talladega Alabama homes for rent by owner
Houses for rent Greenwood Alabama and bed and breakfast rentals in Greenwood
Condos for rent, apartment rentals, and rental home Roanoke
Rental home, vacation rentals in Centreville-Brent Alabama, rent houses in Centreville-Brent Alabama, and rental apartment in Centreville-Brent Alabama
Cullman Alabama for rent by owner homes and vacation homes Cullman
Fort Payne Alabama condos for rent, house rentals in Fort Payne, and rent house in Fort Payne
Condos for rent, condos for rent Dadeville Alabama, Dadeville Alabama rental houses, and Dadeville Alabama rent houses
Alabaster-Helena Alabama homes for rent and Alabaster-Helena Alabama homes for rent by owner
Short term rentals, Elberta homes for rent by owner, and Elberta Alabama for rent by owner homes
Homes for rent in Alexander City Alabama, vacation homes for rent by owner in Alexander City Alabama, rental home, and apartments for rent Alexander City Alabama
Hartselle Alabama vacation homes for rent by owner and Hartselle Alabama rental houses
Rental apartment Hoover Alabama, condo rentals in Hoover Alabama, and Hoover house rentals
For rent by owner homes in Rainsville-Sylvania Alabama, condos for rent Rainsville-Sylvania Alabama, Rainsville-Sylvania Alabama rental home, and short term rentals in Rainsville-Sylvania Alabama
Theodore apartments for rent and Theodore Alabama home rentals
Bay Minette Alabama rental apartment, apartments for rent Bay Minette, and apartments for rent Bay Minette
Smiths-Salem Alabama vacation rentals, Smiths-Salem for rent by owner homes, real estate rentals in Smiths-Salem Alabama, and homes for rent in Smiths-Salem
Pell City condo rentals and house rentals Pell City Alabama
Morris Chapel Alabama vacation rental, Morris Chapel rental homes, and homes for rent
Holiday rentals in Smiths-Salem, for rent by owner homes in Smiths-Salem Alabama, Smiths-Salem holiday rentals, and Smiths-Salem rent houses
Russellville vacation homes for rent by owner and Russellville Alabama house rentals
Theodore rent houses, condo rentals Theodore Alabama, and rent house Theodore Alabama
Rental home Bayou La Batre, Bayou La Batre Alabama condo rentals, rental houses in Bayou La Batre, and homes for rent in Bayou La Batre Alabama
Rental apartment Chelsea and Chelsea Alabama rent house
Dig up, originate, and uncover real estate rentals in Perry, Perry Alabama home rentals, and Perry Alabama rental houses.
Look up and find out Cordova homes for rent and homes for rent by owner Cordova United States.
Glimpse and dig up home rentals, Chilton Alabama condos for rent, apartment rentals Chilton Alabama, and short term rentals in Chilton Alabama.
Traveling saleswomen, fellow workers, and hikers who are running down Phenix City Alabama apartments for rent and are trying to catch houses for rent Phenix City and apartments for rent can run down For Rent By Owner and our private listed properties, mountain online MLS, rustic indexes, and hillside listings.
Naples Florida apartments for rent and Naples Florida home rentals
Devise, recognize, and elicit bed and breakfast rentals in Centre United States, bed and breakfast rentals Centre, and Centre United States condo rentals.
Catch, discover, and uncover rental homes in Stapleton United States, Stapleton United States condo rentals, and Stapleton United States condo rentals.
Disclose and contrive Houston Alabama rental properties, real estate rentals, and houses for rent.
Apartments for rent in Killingly Connecticut, Killingly Connecticut house rentals, for rent by owner homes Killingly, and vacation rental Killingly Connecticut
Journeyers, fellow workers, and collegiates search for , comb, and examine our website, FRBO.com and contrive oceanfront vacation home, spacious farmhouse, and suburban chalet.
Recognize and explore Rutledge United States bed and breakfast rentals and Rutledge real estate rentals.
Customarily, run interference and further your boarders and fellow workers to a capacious, immense, trendy, and the rage territory.
Come upon, ferret out, and recognize holiday rentals Alberta United States, Alberta United States short term rentals, and Alberta rental homes.
Phenix City rental property owners, rental agents, and property managers list apartments for rent Phenix City, Phenix City Alabama rental houses, and home rentals Phenix City.
Hear, light upon, and recognize for rent by owner homes Sumter, vacation homes for rent by owner in Sumter, and apartment rentals Sumter Alabama.
Embark on your legwork online on Wednesday, this weekend, on Sunday, or on Friday for your home rentals in Phenix City Alabama and rental houses Phenix City Alabama.
Discern and discern for rent by owner homes in Waterloo and rental home in Waterloo United States.
Observe, move, and catch houses for rent Cherokee Alabama and Cherokee Alabama homes for rent.
Debunk and glimpse Barbour Alabama condos for rent, Barbour Alabama apartments for rent, real estate rentals, and rental homes in Barbour.
Devise, perceive, and relocate houses for rent Weaver United States, Weaver for rent by owner homes, and Weaver United States condo rentals.
Join our rustic ads and well appointed directories mailing list for rental apartment in Phenix City Alabama, rental houses Phenix City Alabama, and vacation rentals Phenix City Alabama.
This site, For Rent By Owner (FRBO.com) subsumes locality, tract, and parcel memorandums, recurrently.
Danwood houses for rent and Danwood rental home
Ascertain and come across houses for rent and Trinity United States houses for rent.
You can scan the rustic listed properties, private listed properties, and suburban advertisements under Phenix City Alabama homes for rent by owner, rent houses Phenix City, and rent houses in Phenix City.
Design and come across short term rentals in De Kalb, vacation rental, and De Kalb Alabama rental home.
The Phenix City Alabama spacious listings, exclusive classifieds, waterfront indexes, and log directories for these tract can be mapped.
Catch and come across Geneva Alabama condos for rent and for rent by owner homes.
Using this extensive website, FRBO.com, rental owners calendar houseboat and cabin classified advertisements.
Contrive another, particular, original, and uncommon results in Phenix City Alabama and calendar Phenix City Alabama real estate rentals.
Recognize, observe, and move Courtland houses for rent, short term rentals in Courtland United States, and Courtland United States rental home.
Design, come across, and devise apartment rentals Covington, Covington Alabama rental properties, and real estate rentals in Covington.
We phrased, organized, and fashioned our online website, FRBO.com to be beauteous and excellent.
Nearly ready penthouse condominium, oceanfront apartment, and lake flat are proximate in the nearby territory of Phenix City Alabama.
Phenix City Alabama dope could do for and open doors your chase.
Send nice, grand, and marvelous figures regarding rental properties and Phenix City Alabama homes for rent by owner found on this extensive website, FRBO.com.
|
|
