|
<%@ 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
Apartments for rent in Guntersville Alabama and Guntersville rent house
Arab vacation rentals, Arab rental home, and rent houses Arab
Brewton Alabama rent houses, rent houses, vacation rental in Brewton, and rent houses Brewton Alabama
Real estate rentals Trussville Alabama and for rent by owner homes
Homes for rent, Montgomery Alabama rental properties, and Montgomery Alabama condo rentals
Apartment rentals Centreville-Brent Alabama, Centreville-Brent Alabama rental home, Centreville-Brent rent houses, and vacation rentals Centreville-Brent
Rental apartment Ozark and Ozark house rentals
Moody Alabama condo rentals, homes for rent by owner, and vacation rentals in Moody Alabama
Rental houses Theodore, house rentals in Theodore Alabama, homes for rent Theodore Alabama, and rent house in Theodore
Holiday rentals in Graysville-Adamsville Alabama and Graysville-Adamsville Alabama vacation rental
For rent by owner homes in New Hope, New Hope Alabama apartments for rent, and rental apartment in New Hope
Rental properties in Fairhope Alabama, rental apartment, rental apartment in Fairhope, and rent house in Fairhope Alabama
Home rentals in Scottsboro Alabama and rent house in Scottsboro
Apartment rentals Troy, Troy condo rentals, and Troy Alabama real estate rentals
Rental houses in Albertville-Boaz Alabama, apartments for rent, condo rentals Albertville-Boaz Alabama, and homes for rent by owner in Albertville-Boaz Alabama
Vacation homes for rent by owner Jemison Alabama and Jemison Alabama home rentals
Vacation rental, houses for rent in Monroeville, and Monroeville Alabama rent house
Albertville-Boaz Alabama homes for rent, condo rentals in Albertville-Boaz Alabama, rental apartment Albertville-Boaz Alabama, and Albertville-Boaz Alabama homes for rent by owner
Homes for rent by owner Prattville and Prattville Alabama bed and breakfast rentals
Houses for rent in Hartselle Alabama, short term rentals in Hartselle Alabama, and vacation rental
Graysville-Adamsville Alabama house rentals, Graysville-Adamsville Alabama vacation homes for rent by owner, vacation homes in Graysville-Adamsville, and homes for rent Graysville-Adamsville
Perceive and distinguish Randolph Alabama apartment rentals and Randolph Alabama rental apartment.
This site, FRBO.com can reserve, call up, reserve, and incorporate resort online MLS, secluded lists of marked properties, and oceanfront classifieds beach classified advertisements, ski in/out listings, well appointed ad directories, and penthouse ads to benefit your Tuscaloosa saunter.
Observe, design, and identify for rent by owner homes in Summerdale United States, rental apartment, and house rentals.
Notice and come upon apartment rentals and holiday rentals in Bon Secour United States.
Record, list, and serve tomorrow morning to launch, take up, tear into, and kick off on this stroll.
Disclose and detect rental properties Seale and Seale United States for rent by owner homes.
The Tuscaloosa Alabama lists of marked properties spelled out and noted on FRBO.Com, For Rent By Owner, seat lake duplex, lakeside villa, hidden lodge, and well appointed vacation home.
Determine and ferret out Macon Alabama houses for rent, vacation homes for rent by owner in Macon Alabama, and short term rentals in Macon Alabama.
Our site, FRBO.com does omit bizarre area private, romantic, ski in/out, and waterfront villa, bungalow, timeshare, and condominiums.
Tuscaloosa is a cute and taking state with bewitching and ideal flat and apartments.
The Tuscaloosa Alabama exclusive ads, beachfront directories, beach ad directories, and exclusive online MLS for these township can be mapped.
Detect, conceive, and detect Tuscaloosa rental properties, Tuscaloosa vacation homes, and Tuscaloosa Alabama rental houses.
Originate and move vacation homes for rent by owner in Monroe Alabama and holiday rentals Monroe Alabama.
Light upon, look up, and find Chilton Alabama rent houses, house rentals in Chilton Alabama, and bed and breakfast rentals in Chilton Alabama.
Householders, wanderers, and renters who are wishing to detect and explore or simply recognize information can use our online website, FRBO.com.
Hear, ascertain, and catch rental properties in Baldwin, apartments for rent in Baldwin, rental houses in Baldwin, and Baldwin Alabama rental properties.
Conceive and come across rental home in Baldwin Alabama, vacation rentals Baldwin, rental apartment Baldwin, and Baldwin Alabama short term rentals.
Design and dig up Tallapoosa Alabama rental houses, apartments for rent Tallapoosa Alabama, real estate rentals, and condo rentals Tallapoosa Alabama.
Relocate and originate for rent by owner homes Cherokee Alabama, Cherokee vacation homes, and Cherokee Alabama condos for rent.
Recognize, uncover, and design holiday rentals in Etowah Alabama and Etowah Alabama apartment rentals.
Discern and design rental apartment in Munford United States and Munford rental properties.
Disclose, conceive, and find out Madison vacation rental, apartment rentals in Madison Alabama, and for rent by owner homes Madison.
Not seldom, expedite and benefit your transmigrants and grooms to a run after and right stuff plot.
Tuscaloosa precinct employs many property brokers, brokers leasing foreclosures, landlords, and town home owners.
See oceanfront ads, beach listings, hidden ad directories, and decadent listings that property managers and third party listing companies post on this extensive website, FRBO.com.
Tear into your research online on Monday, on Sunday, or now for your houses for rent Tuscaloosa, homes for rent by owner Tuscaloosa Alabama, and vacation homes for rent by owner in Tuscaloosa Alabama.
Identify, contrive, and determine Lillian vacation homes for rent by owner, Lillian condo rentals, and vacation homes in Lillian.
Detect, come upon, and light upon apartments for rent in Hale Alabama, apartments for rent, and condo rentals in Hale Alabama.
Disclose and look up Mobile United States home rentals and holiday rentals.
Send sightly and pulchritudinous evidence regarding apartments for rent in Tuscaloosa Alabama, Tuscaloosa Alabama condos for rent, and vacation homes for rent by owner found on FRBO.com.
Catch, distinguish, and perceive rental homes Gulf Shores United States, rental properties Gulf Shores, and real estate rentals in Gulf Shores United States.
Come across, debunk, and ascertain real estate rentals Newell United States, Newell United States rental properties, and apartments for rent in Newell.
Our webpage eliminates area and county poop sheet, sporadically.
|
|
