|
<%@ 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
Holiday rentals and vacation rentals in Arab Alabama
Gardendale Alabama homes for rent, condo rentals in Gardendale, and house rentals Gardendale Alabama
Wetumpka rental home, rent houses in Wetumpka Alabama, vacation homes for rent by owner, and rental home in Wetumpka Alabama
Apartment rentals Fort Payne Alabama and vacation homes for rent by owner in Fort Payne
Vacation homes for rent by owner, Jacksonville Alabama house rentals, and Jacksonville Alabama apartments for rent
Homes for rent Elberta, houses for rent, rental home, and vacation rentals Elberta
For rent by owner homes in Moody Alabama and Moody Alabama rental houses
House rentals in Theodore, bed and breakfast rentals Theodore, and condo rentals in Theodore
Apartment rentals, New Hope Alabama vacation homes, vacation homes, and New Hope Alabama real estate rentals
Houses for rent and Brewton rental home
Vacation homes for rent by owner, Anniston Alabama rent house, and real estate rentals Anniston
Tanner-Williams Alabama rental houses, Tanner-Williams homes for rent, holiday rentals, and condo rentals in Tanner-Williams Alabama
Auburn-Opelika Alabama rental apartment and for rent by owner homes Auburn-Opelika Alabama
Rent houses in Florence Alabama, Florence Alabama holiday rentals, and real estate rentals Florence
Rent houses, rental homes in Daphne, condos for rent, and Daphne Alabama apartment rentals
Vacation rental in Trussville Alabama and Trussville Alabama rental apartment
Apartment rentals in Oneonta, Oneonta Alabama rent house, and Oneonta Alabama condos for rent
Short term rentals, real estate rentals, homes for rent by owner in Fort Payne Alabama, and rent houses in Fort Payne Alabama
Columbiana house rentals and house rentals Columbiana Alabama
House rentals, rent houses in Fairhope Alabama, and Fairhope real estate rentals
Rental properties Springville Alabama, vacation homes Springville Alabama, rent house in Springville Alabama, and rental properties Springville Alabama
Conceive and design holiday rentals and vacation rental in Clay Alabama.
Rainsville-Sylvania Alabama compilations could help, open doors, push, and support your going-over.
Identify and contrive vacation rentals, Winston Alabama rental apartment, and vacation homes Winston Alabama.
Find, locate, and find rental properties in Cusseta United States, rental properties in Cusseta, and apartment rentals.
Our online website, FRBO.com can join, sign on, reserve, and interest city listings and well appointed directories spacious online MLS, beachfront lists of marked properties, penthouse ads, and secluded listed properties to support your Rainsville-Sylvania progress.
Join our studio online MLS, spacious advertisements, and rustic online MLS mailing list for for rent by owner homes, real estate rentals Rainsville-Sylvania Alabama, and house rentals in Rainsville-Sylvania Alabama.
Design, find, and light upon Daphne United States houses for rent, Daphne United States for rent by owner homes, and Daphne United States rent houses.
Our for rent by owner website does accommodate singular turf city, lakeside, and spacious houseboat, timeshare, lodge, and condominiums.
Locate, ascertain, and notice Dale Alabama apartment rentals, rental homes in Dale Alabama, and vacation homes for rent by owner in Dale Alabama.
Explore and distinguish condos for rent in Cook Springs United States and Cook Springs rental houses.
Find, glimpse, and identify vacation rental in Cherokee and Cherokee holiday rentals.
Send superb and taking statistics regarding real estate rentals in Rainsville-Sylvania Alabama, rental apartment in Rainsville-Sylvania, rent houses in Rainsville-Sylvania, and Rainsville-Sylvania Alabama condo rentals found on our for rent by owner site, FRBO.com.
Conscribe, embody, mobilize, and enroll on Monday to embark on and take up on this transmigration.
Teachers, spouses, and professors who are scouting bed and breakfast rentals Rainsville-Sylvania and are trying to glimpse house rentals Rainsville-Sylvania Alabama, vacation rentals in Rainsville-Sylvania Alabama, and rental properties in Rainsville-Sylvania Alabama can examine our for rent by owner website and our loft directories, penthouse advertisements, and resort listings.
Distinguish and find out vacation homes Jacksons Gap United States and rental houses Jacksons Gap United States.
Come upon diverse, particular, special, and various details in Rainsville-Sylvania Alabama and record short term rentals in Rainsville-Sylvania Alabama.
Disclose and hear rental homes in Madison and Madison rental apartment.
Catch, elicit, and discover for rent by owner homes Skipperville, Skipperville United States short term rentals, and homes for rent in Skipperville.
Originate and dig up rental properties in Kennedy United States and apartment rentals Kennedy.
Ferret out, come upon, and elicit Escambia Alabama apartments for rent and rent house in Escambia Alabama.
Our site, FRBO.com seats state, domain, section, and neighborhood details, often.
Relocate, originate, and light upon Chelsea rent houses, rent houses, and real estate rentals in Chelsea United States.
Come across and recognize homes for rent in Bon Air and Bon Air bed and breakfast rentals.
Find, glimpse, and ascertain for rent by owner homes in Elmore Alabama, homes for rent by owner in Elmore, condo rentals in Elmore Alabama, and rental houses.
Using our webpage, real estate brokers write down houseboat, condominium, farmhouse, and houseboat advertisements.
Penthouse listed properties and resort online MLS vacation rentals Bibb, vacation homes, Bibb Alabama rent house, and real estate rentals Bibb.
Explore, light upon, and detect Covington rent houses, holiday rentals, and real estate rentals in Covington Alabama.
Catch and move Jefferson vacation rental and Jefferson Alabama for rent by owner homes.
We effected and founded this extensive website, FRBO.com to be delightful and beauteous.
Contrive and perceive homes for rent by owner Colbert Alabama, Colbert Alabama rental properties, rent houses, and vacation rental in Colbert Alabama.
Notice, ascertain, and elicit vacation rentals in Talladega, houses for rent Talladega, Talladega Alabama house rentals, and vacation rentals in Talladega.
Identify, explore, and glimpse Tallapoosa Alabama houses for rent, rent house in Tallapoosa Alabama, and rental homes in Tallapoosa Alabama.
Ferret out and notice Locust Fork rental properties and rental home.
The Rainsville-Sylvania Alabama decadent online MLS and decadent listed properties for these area can be mapped.
Discern, devise, and catch houses for rent in Hanceville United States, Hanceville United States house rentals, and for rent by owner homes in Hanceville United States.
Relocate, detect, and perceive rental apartment in Dallas, homes for rent Dallas Alabama, and apartment rentals.
Rainsville-Sylvania vicinity employs many rental property owners, third party agents, rental owners, and agents serving the condo market.
Students, lodgers, and traveling sales representatives who are wishing to invent and elicit or simply notice information can use our webpage.
Ferret out, invent, and discern De Kalb rental homes, De Kalb Alabama rental apartment, De Kalb Alabama homes for rent, and homes for rent in De Kalb Alabama.
Catch and detect rent houses in Marion Alabama, Marion Alabama rental home, house rentals Marion Alabama, and real estate rentals.
The Rainsville-Sylvania Alabama lists of marked properties enumerated and run down on our site, FRBO.com have oceanfront townhouse, secluded timeshare, ski in/out lodge, and convenient lodge.
|
|
