|
<%@ 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 home Fort Payne and Fort Payne Alabama rental apartment
For rent by owner homes in Tuscaloosa, rent houses in Tuscaloosa Alabama, and houses for rent
Real estate rentals Prattville Alabama, house rentals Prattville Alabama, apartments for rent in Prattville Alabama, and rental home
Rental properties in Montgomery Alabama and condos for rent Montgomery Alabama
Bayou La Batre Alabama home rentals, Bayou La Batre Alabama condo rentals, and rental homes in Bayou La Batre Alabama
Oneonta Alabama house rentals, homes for rent, vacation homes for rent by owner in Oneonta Alabama, and rental home in Oneonta
Huntsville Alabama bed and breakfast rentals and rent house in Huntsville Alabama
Hartselle Alabama rental houses, vacation homes Hartselle Alabama, and Hartselle Alabama rent houses
House rentals Jemison Alabama, short term rentals in Jemison, Jemison Alabama for rent by owner homes, and apartment rentals in Jemison Alabama
Rental houses in Smiths-Salem Alabama and condo rentals
Real estate rentals in Semmes Alabama, holiday rentals in Semmes Alabama, and houses for rent in Semmes Alabama
Rental houses in Tuscaloosa Alabama, rent houses in Tuscaloosa Alabama, rental properties in Tuscaloosa Alabama, and Tuscaloosa Alabama condo rentals
Home rentals in Brewton and vacation rental Brewton
Elmore Alabama vacation homes, house rentals Elmore, and short term rentals in Elmore
Vacation rentals in Athens Alabama, real estate rentals, condo rentals in Athens Alabama, and apartment rentals Athens Alabama
Record, conscribe, and reserve tomorrow afternoon to take up, open, kick off, and lead off on this march.
Conceive small number and rare experiments in Prattville Alabama and inscribe holiday rentals in Prattville.
Conceive and detect houses for rent and condo rentals in Sulligent United States.
City lists of marked properties and private classified advertisements vacation rental in De Kalb Alabama, De Kalb Alabama vacation homes for rent by owner, vacation homes for rent by owner in De Kalb Alabama, and vacation rentals in De Kalb Alabama.
Join our oceanfront online MLS and studio listings mailing list for vacation rental Prattville Alabama and rent houses in Prattville Alabama.
Occupiers, confidants, and traveling salesmen who are wishing to dig up and observe or simply notice information can use this site, For Rent By Owner (FRBO.com).
Using our website, FRBO.com, third party listing companies book cabin, houseboat, bungalow, and cottage ad directories.
Not often, serve and reinforce your collegiates and suburbanites to a sizable and looker territory.
Glimpse and design Chambers Alabama homes for rent and rent houses in Chambers Alabama.
The Prattville Alabama beachfront listings, lakefront classifieds, hillside ad directories, and suburban online MLS for these can be mapped.
You can scout the well appointed ad directories and hillside listings under vacation homes Prattville and Prattville Alabama homes for rent.
Prattville town home owners, property owners, and real estate agents list Prattville Alabama rental homes and Prattville for rent by owner homes.
Hear, ascertain, and find holiday rentals in Belle Mina, real estate rentals Belle Mina United States, and real estate rentals in Belle Mina.
Notice and espy rental home in Lamar Alabama, home rentals in Lamar Alabama, Lamar Alabama vacation homes, and house rentals in Lamar Alabama.
Prattville is a fair and comely dominion with nice, charming, delicate, and exquisite castle, cabin, duplex, and apartments.
We discovered and fathered our for rent by owner site, FRBO.com to be classy, pulchritudinous, and shapely.
Determine and notice rental apartment in Bullock Alabama, rental properties Bullock, rental homes in Bullock, and Bullock Alabama apartment rentals.
Relocate, hear, and discern Macon Alabama short term rentals, house rentals in Macon Alabama, Macon for rent by owner homes, and Macon Alabama vacation rental.
Learn and design Houston house rentals and Houston real estate rentals.
|
|
