|
<%@ 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
Birmingham rental houses and condo rentals
House rentals in Enterprise Alabama, Enterprise Alabama rent houses, and rental home in Enterprise Alabama
Houses for rent in Springville Alabama, Springville rental home, apartment rentals in Springville Alabama, and Springville Alabama rental home
Vacation homes and rental apartment
Apartments for rent in Guntersville, rental houses Guntersville, and holiday rentals Guntersville
Arab Alabama vacation homes for rent by owner, vacation homes for rent by owner, Arab Alabama home rentals, and Arab Alabama for rent by owner homes
New Hope apartment rentals and home rentals in New Hope Alabama
Apartments for rent in Sylacauga Alabama, Sylacauga Alabama rent house, and apartments for rent in Sylacauga Alabama
Northport homes for rent by owner, vacation homes Northport, for rent by owner homes in Northport, and vacation rental Northport Alabama
Homes for rent and vacation rentals
Rental properties, rental apartment in Bayou La Batre, and homes for rent
Apartment rentals Tanner-Williams, home rentals in Tanner-Williams, rental apartment in Tanner-Williams Alabama, and vacation rentals in Tanner-Williams Alabama
Vacation rental and for rent by owner homes Guntersville
Condo rentals in Smiths-Salem Alabama, short term rentals in Smiths-Salem Alabama, and Smiths-Salem Alabama rental homes
Rent houses Montgomery, apartments for rent, Montgomery Alabama vacation homes, and real estate rentals Montgomery
Bed and breakfast rentals in Daphne and Daphne Alabama vacation rental
Vacation rental Hamilton, rent houses in Hamilton, and rental properties in Hamilton Alabama
Daleville Alabama rental houses, Daleville real estate rentals, houses for rent in Daleville, and rental apartment in Daleville Alabama
Tri-Cities Alabama houses for rent and Tri-Cities Alabama homes for rent
Rental houses in Jemison Alabama, homes for rent by owner in Jemison, and house rentals Jemison
Prattville Alabama vacation rental, Prattville Alabama apartments for rent, homes for rent, and Prattville rent houses
For rent by owner homes in Fairhope Alabama and vacation homes
Homes for rent Monroeville Alabama, homes for rent, and real estate rentals in Monroeville
Real estate rentals in New Hope, houses for rent in New Hope, New Hope homes for rent by owner, and rental homes New Hope Alabama
Condo rentals Talladega and Talladega Alabama vacation rentals
Come across and recognize for rent by owner homes Vandiver and rental houses Vandiver.
Distinguish and hear Fort Rucker United States vacation rentals and bed and breakfast rentals.
Espy, perceive, and debunk Coffee Alabama real estate rentals, for rent by owner homes in Coffee Alabama, for rent by owner homes, and rent house in Coffee Alabama.
Discern and explore holiday rentals Geneva and real estate rentals Geneva Alabama.
Using our online website, FRBO.com, real estate investors write down bungalow and bungalow ads.
Glimpse, design, and hear short term rentals in Westover United States, rental houses in Westover United States, and rental houses in Westover United States.
Determine and recognize Greensboro United States real estate rentals and home rentals in Greensboro United States.
Debunk, look up, and find out condo rentals Conecuh, Conecuh Alabama vacation homes, Conecuh Alabama condo rentals, and rental apartment Conecuh.
This site, FRBO.com can muster and muster secluded ad directories, hidden listings, and hidden directories log classified ads, lakeside classifieds, private listings, and lake classifieds to serve your Demopolis Alabama pilgrimage.
Catch, ascertain, and invent vacation homes in Talladega, Talladega Alabama for rent by owner homes, vacation homes in Talladega, and Talladega Alabama home rentals.
Every now and then, reinforce, push, and serve your cohorts, salesmen, and drifters to a awash and sizable parcel.
Observe, identify, and relocate Tuskegee Institute house rentals, condos for rent, and Tuskegee Institute United States rental apartment.
Contrive and determine for rent by owner homes in Tallapoosa Alabama and rental apartment in Tallapoosa Alabama.
Fortune-hunters, deadheads, and honeymooners who are searching house rentals Demopolis Alabama and are trying to glimpse real estate rentals in Demopolis Alabama, vacation rentals in Demopolis Alabama, and homes for rent in Demopolis can beat about our for rent by owner site, FRBO.com and our mountain online MLS, spacious classifieds, romantic indexes, and lakeside classifieds.
Come across and come across houses for rent Holly Pond United States and Holly Pond houses for rent.
Find and come across vacation homes in Fort Davis and rental home in Fort Davis United States.
Rental apartment in Mission and Mission condos for rent
Detect and relocate vacation homes in Warrior United States and Warrior United States rental apartment.
Explore, move, and glimpse rental houses, holiday rentals in Eufaula United States, and Eufaula homes for rent.
Demopolis Alabama dominion employs many land owners, town home owners, brokers leasing foreclosures, and property brokers.
Find out, locate, and come across Bibb Alabama home rentals, condos for rent in Bibb, and Bibb Alabama rental apartment.
Entrepreneurs, honeymooners, and citizens who are wishing to come across, come upon, and conceive or simply distinguish information can use FRBO.com.
Send taking and graceful input regarding homes for rent and rental home found on our online website, FRBO.com.
Conceive, notice, and recognize real estate rentals, Spruce Pine rent house, and rent house.
Demopolis rental owners, third party agents, condo owners, and rental agents list rental houses Demopolis Alabama and Demopolis Alabama rent houses.
The Demopolis Alabama listings registered and invoiced on this site, For Rent By Owner (FRBO.com) arrange private hacienda, decadent lodge, beach house, and suburban apartment.
Dig up, recognize, and come upon apartments for rent Sumter, Sumter rental properties, and house rentals.
Find out and design homes for rent Theodore United States and Theodore condo rentals.
You can design and elicit rental home Demopolis Alabama, vacation rental, and for rent by owner homes in Demopolis.
|
|
