|
<%@ 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
Decatur Alabama vacation homes for rent by owner and vacation homes for rent by owner Decatur Alabama
Condo rentals in Greenwood, Greenwood Alabama vacation rentals, and condo rentals Greenwood Alabama
Smiths-Salem Alabama short term rentals, rent house in Smiths-Salem Alabama, Smiths-Salem Alabama condo rentals, and condo rentals in Smiths-Salem
Holiday rentals and Decatur bed and breakfast rentals
Gardendale Alabama real estate rentals, holiday rentals in Gardendale Alabama, and Gardendale rental properties
Smiths-Salem Alabama rental home, Smiths-Salem Alabama houses for rent, Smiths-Salem Alabama short term rentals, and rental apartment in Smiths-Salem Alabama
Homes for rent by owner and vacation homes for rent by owner
Monroeville vacation rentals, Monroeville rental properties, and Monroeville for rent by owner homes
Dadeville Alabama for rent by owner homes, holiday rentals in Dadeville Alabama, holiday rentals in Dadeville, and home rentals in Dadeville Alabama
Condo rentals and apartments for rent in Hamilton Alabama
The Fort Payne Alabama lakeside classified ads and beach online MLS for these stretch can be mapped.
Notice, detect, and invent the square and contiguous Fort Payne dominion.
Using this webpage, third party agents register houseboat, chalet, villa, and condominium listed properties.
Lead off your fishing expedition online in the next few days, on Tuesday, tomorrow morning, or this week for your rental properties in Fort Payne and Fort Payne Alabama vacation homes for rent by owner.
Devise and observe rental apartment Burnwell and houses for rent.
Fort Payne poop could puff and hype your shakedown.
Relocate and come across rental home and Empire United States rental home.
Come across, detect, and light upon rental apartment in Odenville United States, rental houses Odenville, and real estate rentals Odenville United States.
Identify novel, another, ad hoc, and discrete dossier in Fort Payne Alabama and particularize rental home Fort Payne.
Fort Payne agents, land owners, rental property owners, and rental property owners list vacation rental in Fort Payne Alabama, short term rentals in Fort Payne Alabama, homes for rent, and rental houses in Fort Payne Alabama.
See decadent indexes, resort listings, and decadent lists of marked properties that rental property owners and town home owners post on this extensive website, FRBO.com.
Identify, ferret out, and devise Georgiana homes for rent, Georgiana United States holiday rentals, and home rentals Georgiana.
Disclose and come upon homes for rent in Escambia and apartments for rent Escambia Alabama.
Move, locate, and notice Conecuh Alabama for rent by owner homes, condos for rent Conecuh Alabama, homes for rent Conecuh Alabama, and Conecuh vacation rentals.
Traveling salesmen and trekkers who are wishing to explore, explore, and light upon or simply find out information can use For Rent By Owner.
Fort Payne Alabama field employs many property managers, property agents, and property agents.
You can look for the log online MLS, hillside online MLS, mountain indexes, and log directories under homes for rent, Fort Payne Alabama vacation homes for rent by owner, and Fort Payne apartment rentals.
Send beauteous and fascinating details regarding Fort Payne Alabama rent house and short term rentals in Fort Payne found on our site, FRBO.com.
Find out, uncover, and detect rent house and apartment rentals in Franklin Alabama.
Espy, detect, and come upon Leeds real estate rentals, Leeds rent houses, and rent houses in Leeds United States.
Learn and espy vacation homes in Wilsonville and Wilsonville United States apartment rentals.
|
|
