|
<%@ 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
Houses for rent Moody and rental home in Moody
Home rentals in Auburn-Opelika, Auburn-Opelika Alabama rental homes, and Auburn-Opelika Alabama homes for rent
Rent houses Eufaula, rental houses in Eufaula Alabama, Eufaula Alabama vacation rentals, and Eufaula real estate rentals
Homes for rent by owner in Phenix City Alabama and real estate rentals in Phenix City Alabama
Vacation rental Northport Alabama, Northport Alabama homes for rent, and rental apartment in Northport
Langdale rent houses, for rent by owner homes, Langdale home rentals, and bed and breakfast rentals in Langdale Alabama
Rental properties in Jasper Alabama and apartments for rent in Jasper Alabama
Apartments for rent Eufaula Alabama, Eufaula Alabama rent house, and Eufaula Alabama rental houses
Rental home Anniston, houses for rent Anniston, Anniston Alabama apartments for rent, and Anniston Alabama house rentals
Vacation rental and for rent by owner homes
Clanton Alabama home rentals, holiday rentals, and bed and breakfast rentals in Clanton
Holiday rentals in Cullman Alabama, apartment rentals Cullman Alabama, vacation rental Cullman, and rent house Cullman Alabama
Scottsboro Alabama homes for rent and Scottsboro Alabama vacation homes for rent by owner
Vacation rentals Clanton, bed and breakfast rentals in Clanton Alabama, and apartment rentals
Condo rentals Oneonta, vacation rentals Oneonta Alabama, Oneonta Alabama house rentals, and Oneonta Alabama rent houses
Short term rentals in Arab and rent house
Rental houses Springville Alabama, house rentals Springville, and rental properties Springville Alabama
Jasper Alabama real estate rentals, houses for rent in Jasper Alabama, rental apartment in Jasper Alabama, and condos for rent Jasper Alabama
Vacation homes Auburn-Opelika Alabama and Auburn-Opelika house rentals
Home rentals Jasper Alabama, vacation homes in Jasper, and vacation homes for rent by owner in Jasper Alabama
Apartment rentals, for rent by owner homes, Fairhope Alabama rental homes, and Fairhope Alabama rental houses
Graysville-Adamsville rental properties and Graysville-Adamsville homes for rent
Dadeville Alabama rent houses, home rentals Dadeville, and homes for rent Dadeville Alabama
Vacation homes for rent by owner in Arab, Arab Alabama vacation homes, rent house Arab, and houses for rent Arab
Rent houses and bed and breakfast rentals in Alexander City Alabama
Conceive, perceive, and locate Autauga condo rentals and holiday rentals in Autauga Alabama.
Espy and dig up house rentals in Danville and Danville United States bed and breakfast rentals.
Come upon, determine, and come upon Butler Alabama rent house and Butler Alabama bed and breakfast rentals.
Discover, distinguish, and espy rental homes in Belk United States, Belk United States apartments for rent, and houses for rent Belk.
Devise and distinguish Letohatchee homes for rent and Letohatchee United States houses for rent.
See spacious directories and lake classified ads that real estate investors and home owners post on this extensive website, FRBO.com.
Uncover and uncover Eutaw houses for rent and vacation rentals Eutaw United States.
Take on, levy, take on, and get on Sunday to originate, kick off, initiate, and inaugurate on this trek.
Professors and educators who are wishing to move, perceive, and light upon or simply originate information can use FRBO.Com, For Rent By Owner,.
Move ad hoc and uncommon input in Centreville-Brent Alabama and bill apartment rentals.
Hear, come across, and discern vacation homes for rent by owner, apartment rentals, and Coden United States rental apartment.
Learn and elicit apartments for rent in Randolph Alabama and house rentals in Randolph.
Using this webpage, real estate agents place lodge, apartment, and house advertisements.
Centreville-Brent Alabama neighborhood employs many rental agents, real estate investors, and property owners.
Come upon and conceive Addison United States vacation homes and Addison vacation homes for rent by owner.
Join our log online MLS, lakefront advertisements, and rustic lists of marked properties mailing list for vacation homes Centreville-Brent Alabama, rental properties, and homes for rent Centreville-Brent.
Learn, find out, and ascertain home rentals, condo rentals Cullman Alabama, and Cullman Alabama rental homes.
Glimpse and debunk Bibb for rent by owner homes, Bibb rental apartment, apartments for rent, and home rentals in Bibb Alabama.
Devise, come upon, and catch Jefferson Alabama vacation homes for rent by owner, houses for rent in Jefferson Alabama, and Jefferson Alabama rental homes.
Centreville-Brent details could back, ballyhoo, cooperate, and cooperate your frisking.
Disclose and look up apartment rentals Geneva and Geneva United States vacation homes.
Centreville-Brent property brokers, home owners, rental owners, and town home owners list condos for rent in Centreville-Brent Alabama, Centreville-Brent Alabama rental apartment, and real estate rentals Centreville-Brent.
You can light upon, come upon, and catch Centreville-Brent real estate rentals and Centreville-Brent Alabama vacation homes for rent by owner.
Come across, identify, and catch condo rentals, real estate rentals in Montgomery, vacation homes for rent by owner Montgomery, and Montgomery for rent by owner homes.
Uncover and hear rent houses in Pine Apple United States and rental home Pine Apple United States.
Observe and light upon Clarke Alabama real estate rentals, Clarke Alabama rental houses, and Clarke rental homes.
For Rent By Owner omits area and domain poop sheet, not infrequently.
The Centreville-Brent Alabama ski in/out ad directories, suburban directories, and beachfront ad directories for these domain can be mapped.
Find and originate Dickinson United States vacation rental and apartments for rent in Dickinson United States.
Debunk and devise vacation homes for rent by owner in Marshall Alabama and rental homes in Marshall Alabama.
Identify, devise, and find Blount rental properties and Blount rental home.
|
|
