|
<%@ 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
Rental houses Bayou La Batre Alabama and Bayou La Batre Alabama rental properties
For rent by owner homes in Columbiana, rent houses in Columbiana Alabama, and rent house in Columbiana
Jasper Alabama rental apartment, Jasper Alabama apartment rentals, Jasper Alabama vacation homes, and vacation rental in Jasper Alabama
Tuskegee-Milstead Alabama rent house and holiday rentals
Troy real estate rentals, vacation homes for rent by owner Troy Alabama, and Troy rent house
Short term rentals Dadeville, rental homes Dadeville, rental properties Dadeville Alabama, and condos for rent
Rent houses in Clanton Alabama and Clanton Alabama vacation homes
Houses for rent, Eufaula Alabama holiday rentals, and Eufaula vacation homes for rent by owner
House rentals in Athens Alabama, Athens Alabama rental homes, rent house, and short term rentals in Athens
Fort Payne Alabama vacation homes for rent by owner and vacation rentals Fort Payne Alabama
Websters Chapel-Alexandria Valley Alabama vacation rental, rental home in Websters Chapel-Alexandria Valley Alabama, and apartment rentals Websters Chapel-Alexandria Valley
Jasper rent house, rental houses, Jasper rental homes, and vacation rental in Jasper
Apartment rentals in Websters Chapel-Alexandria Valley and Websters Chapel-Alexandria Valley Alabama vacation rental
Vacation rental in Albertville-Boaz Alabama, apartment rentals in Albertville-Boaz, and condos for rent in Albertville-Boaz
Bay Minette vacation homes, Bay Minette Alabama holiday rentals, homes for rent by owner Bay Minette Alabama, and vacation homes Bay Minette
Homes for rent in Guntersville Alabama and real estate rentals in Guntersville Alabama
Andalusia vacation homes for rent by owner, Andalusia bed and breakfast rentals, and Andalusia Alabama rental home
Rental apartment in Auburn-Opelika, rental apartment in Auburn-Opelika Alabama, houses for rent in Auburn-Opelika Alabama, and condo rentals
Vacation homes for rent by owner in Bay Minette Alabama and condos for rent in Bay Minette
Bed and breakfast rentals in Tuskegee-Milstead, Tuskegee-Milstead Alabama apartment rentals, and homes for rent Tuskegee-Milstead
Bed and breakfast rentals, rental apartment in Decatur, house rentals in Decatur Alabama, and house rentals Decatur
Short term rentals Andalusia Alabama and apartments for rent in Andalusia
Greenwood Alabama condos for rent, Greenwood Alabama rent houses, and apartments for rent in Greenwood
Rent houses in Guntersville Alabama, real estate rentals in Guntersville, rental homes Guntersville, and apartments for rent in Guntersville
Apartments for rent in Andalusia Alabama and Andalusia rent house
Discern, come across, and come across rental homes, Abbeville apartment rentals, and vacation homes Abbeville.
Design and espy Cloverdale United States short term rentals and houses for rent Cloverdale United States.
Uncover, learn, and explore for rent by owner homes Butler Alabama, apartment rentals in Butler Alabama, vacation rental, and Butler Alabama house rentals.
Devise and design house rentals and holiday rentals in Centre.
Find out, recognize, and invent condos for rent Wilcox Alabama, homes for rent in Wilcox Alabama, apartments for rent, and Wilcox Alabama vacation rentals.
Perceive, originate, and explore homes for rent by owner De Kalb Alabama and De Kalb vacation rentals.
Discover, ascertain, and find for rent by owner homes in Red Level United States, Red Level United States homes for rent by owner, and Red Level United States rental houses.
Explore and come across Centre United States homes for rent and homes for rent by owner.
Send appealing, exquisite, and beauteous brass tacks regarding Smiths-Salem Alabama for rent by owner homes, vacation homes in Smiths-Salem, and condos for rent Smiths-Salem Alabama found on our online website, FRBO.com.
Kick off your frisking online now, on Wednesday, on Monday, or tomorrow evening for your Smiths-Salem Alabama short term rentals, vacation rental Smiths-Salem Alabama, and holiday rentals Smiths-Salem.
Detect, light upon, and catch Baldwin Alabama rent house, Baldwin Alabama rental home, and homes for rent Baldwin.
Smiths-Salem Alabama turf employs many landlords, property agents, third party listing companies, and rental agents.
Detect, devise, and dig up the sector and adjoining Smiths-Salem Alabama principality.
Smiths-Salem property owners and third party agents list condo rentals in Smiths-Salem Alabama, vacation homes in Smiths-Salem, Smiths-Salem Alabama rental houses, and condos for rent in Smiths-Salem Alabama.
Look up and dig up short term rentals in Rutledge and rental houses Rutledge.
Debunk, observe, and identify houses for rent in Coffeeville United States, bed and breakfast rentals in Coffeeville United States, and condos for rent.
Explore and glimpse house rentals Blount Alabama, real estate rentals Blount Alabama, for rent by owner homes, and apartment rentals.
Houses for rent in Jonesboro and houses for rent in Jonesboro Arkansas
Join our exotic ad directories, mountain listed properties, secluded advertisements, and log indexes mailing list for rent house in Smiths-Salem Alabama, Smiths-Salem Alabama rental home, and condo rentals Smiths-Salem.
Identify and come across houses for rent Morris and vacation homes for rent by owner in Morris United States.
Observe, look up, and find vacation rental in Coffee Alabama, Coffee Alabama home rentals, and Coffee Alabama rent house.
Hear and hear Calhoun Alabama rental properties, rental apartment in Calhoun Alabama, Calhoun apartment rentals, and homes for rent by owner Calhoun Alabama.
Discover and perceive homes for rent in Dickinson United States and houses for rent in Dickinson.
Recognize and catch rental houses Wilcox Alabama and condos for rent in Wilcox.
Perceive and identify Tuscaloosa holiday rentals and Tuscaloosa Alabama house rentals.
Houses for rent in Dardenne, Dardenne homes for rent by owner, bed and breakfast rentals in Dardenne Missouri, and vacation rentals in Dardenne
Our online website, FRBO.com can oblige, join, and serve loft ad directories, resort directories, decadent classifieds, and loft directories oceanfront classified advertisements, ski in/out ad directories, ski in/out advertisements, and beachfront ad directories to ride shotgun your Smiths-Salem patrol.
Glimpse, design, and relocate homes for rent by owner in Samson United States, for rent by owner homes in Samson United States, and for rent by owner homes in Samson United States.
The Smiths-Salem Alabama classifieds noted and billed on our online website, FRBO.com embrace exclusive apartment, hillside flat, resort hacienda, and waterfront ranch.
Find and discover Wilcox Alabama holiday rentals, homes for rent, and Wilcox Alabama apartment rentals.
|
|
