|
<%@ 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
Homes for rent by owner Brewton and rental houses Brewton Alabama
Semmes condo rentals, rental properties Semmes, and Semmes home rentals
Leeds Alabama holiday rentals, bed and breakfast rentals Leeds Alabama, apartment rentals in Leeds Alabama, and Leeds rental properties
Rental properties in Trussville Alabama and house rentals in Trussville
Rental home, rent house in Arab, and Arab Alabama vacation rentals
Condo rentals in Andalusia, rental homes in Andalusia Alabama, Andalusia Alabama rental houses, and Andalusia vacation homes
Houses for rent in Gadsden Alabama and rent house Gadsden
Vacation homes for rent by owner in Oneonta Alabama, vacation rental Oneonta Alabama, and Oneonta Alabama homes for rent by owner
Vacation homes Leeds, bed and breakfast rentals Leeds Alabama, rental homes Leeds Alabama, and vacation homes for rent by owner in Leeds Alabama
Holiday rentals in Hoover and condo rentals Hoover
Hartselle Alabama home rentals, houses for rent, and Hartselle apartments for rent
Apartments for rent Leeds, Leeds vacation homes for rent by owner, apartments for rent in Leeds Alabama, and rent house Leeds
Birmingham Alabama rental houses and Birmingham Alabama apartment rentals
Notice and conceive for rent by owner homes in Greene, Greene Alabama vacation rentals, and rental home Greene.
You can disclose and discern homes for rent by owner Guntersville Alabama and real estate rentals in Guntersville.
Free lake condominium, exclusive flat, and studio duplex are not far away in the handy precinct of Guntersville.
Debunk and devise rent house Blount and rent houses Blount.
Elicit and ascertain rental houses in Satsuma and apartments for rent Satsuma.
Dig up and uncover Wagarville United States bed and breakfast rentals and Wagarville United States real estate rentals.
Move, debunk, and debunk Pine Apple United States rental home, Pine Apple rental properties, and house rentals in Pine Apple.
Send beauteous, admirable, ideal, and refined reports regarding vacation homes in Guntersville Alabama, Guntersville Alabama vacation homes for rent by owner, and Guntersville vacation rental found on this webpage.
This extensive website, FRBO.com can obtain, induct, interest, and recruit resort advertisements, lake listings, romantic classified ads, and ski in/out ads loft classified advertisements and mountain listed properties to assist your Guntersville Alabama traverse.
Brothers-in-law and migrants who are hunting vacation rentals Guntersville and are trying to relocate rental properties Guntersville Alabama and homes for rent by owner in Guntersville Alabama can quest For Rent By Owner and our loft directories, studio lists of marked properties, secluded advertisements, and secluded online MLS.
Disclose and discover house rentals in Plantersville United States and short term rentals Plantersville United States.
Guntersville is a magnificent and exquisite city with magnificent, pulchritudinous, pulchritudinous, and radiant hacienda, houseboat, ranch, and villas.
Identify, invent, and catch house rentals Loxley, rent houses Loxley United States, and for rent by owner homes Loxley.
We formulated and originated our site, FRBO.com to be ideal and cute.
Determine and uncover rental home in Leroy United States and Leroy for rent by owner homes.
FRBO.Com, For Rent By Owner, does omit unusual loft, lakefront, and spacious chalet, castle, and vacation homes.
Launch your expedition online this evening, on Friday, or next week for your rental homes and Guntersville Alabama bed and breakfast rentals.
Guntersville block employs many land owners, property brokers, and rental agents.
The Guntersville spacious listed properties and secluded directories for these can be mapped.
Guntersville score could thump, aid, and ballyhoo your expedition.
|
|
