|
<%@ 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
Real estate rentals in Jasper Alabama and Jasper Alabama apartments for rent
Houses for rent Prattville Alabama, houses for rent in Prattville Alabama, and houses for rent in Prattville Alabama
Rental home Foley Alabama, apartment rentals in Foley, apartment rentals in Foley, and Foley rental properties
Springville Alabama home rentals and short term rentals
Auburn-Opelika rental properties, Auburn-Opelika rental homes, and holiday rentals in Auburn-Opelika Alabama
Apartments for rent in Tri-Cities, homes for rent by owner in Tri-Cities, apartments for rent Tri-Cities Alabama, and Tri-Cities vacation rentals
Rent house in Sylacauga and homes for rent by owner in Sylacauga Alabama
Guntersville Alabama vacation homes for rent by owner, Guntersville Alabama vacation rentals, and homes for rent Guntersville
Real estate rentals in Foley, vacation rentals in Foley Alabama, vacation rentals in Foley Alabama, and vacation rentals in Foley
Athens Alabama for rent by owner homes and apartments for rent
Anniston Alabama holiday rentals, Anniston home rentals, and homes for rent by owner in Anniston Alabama
House rentals in Fairhope Alabama, for rent by owner homes in Fairhope, houses for rent, and Fairhope for rent by owner homes
Short term rentals in Morris Chapel Alabama and homes for rent by owner in Morris Chapel Alabama
Decatur rental apartment, real estate rentals, and rental apartment in Decatur
Decatur condos for rent, Decatur Alabama vacation homes for rent by owner, Decatur Alabama bed and breakfast rentals, and house rentals Decatur Alabama
Condos for rent in Greenville and short term rentals Greenville
Rainsville-Sylvania for rent by owner homes, Rainsville-Sylvania real estate rentals, and Rainsville-Sylvania Alabama rental homes
Condo rentals Alabaster-Helena Alabama, rent houses in Alabaster-Helena, vacation homes Alabaster-Helena, and Alabaster-Helena Alabama condos for rent
Graysville-Adamsville holiday rentals and holiday rentals in Graysville-Adamsville
Columbiana homes for rent by owner, Columbiana rent houses, and real estate rentals Columbiana Alabama
Rent house Decatur, vacation homes in Decatur, rent house in Decatur, and Decatur Alabama rental properties
Real estate rentals and Robertsdale Alabama rent houses
Elberta Alabama home rentals, Elberta bed and breakfast rentals, and apartments for rent in Elberta Alabama
Rental homes, vacation rental Cullman, condo rentals in Cullman, and Cullman Alabama rental apartment
Houses for rent and vacation homes for rent by owner in Pell City Alabama
Demopolis rental homes, Demopolis vacation rentals, and Demopolis Alabama rental apartment
Apartments for rent in Graysville-Adamsville, vacation homes for rent by owner in Graysville-Adamsville Alabama, vacation homes in Graysville-Adamsville, and Graysville-Adamsville Alabama for rent by owner homes
Real estate rentals in Tuscaloosa Alabama and apartments for rent in Tuscaloosa Alabama
We parented, reared, and initiated our webpage to be graceful, admirable, and sublime.
Identify and locate bed and breakfast rentals in Fayette Alabama and houses for rent in Fayette Alabama.
Liberty Lake rental home and vacation homes Liberty Lake
Open your wild-goose chase online tomorrow afternoon or this week for your Foley real estate rentals and Foley Alabama rental homes.
Invent and explore homes for rent by owner in Perry Alabama, vacation homes for rent by owner in Perry, and vacation homes for rent by owner Perry Alabama.
Recognize and elicit Notasulga United States rental houses and homes for rent in Notasulga.
Detect, explore, and recognize for rent by owner homes in Conecuh, Conecuh Alabama rental homes, and Conecuh rental apartment.
Our online website, FRBO.com does incorporate specific romantic, decadent, secluded, and hillside townhouse, lodge, hacienda, and condominiums.
Contrive bizarre, especial, and various info in Foley Alabama and numerate short term rentals Foley.
Foley Alabama domain employs many agents serving the condo market, third party listing companies, third party agents, and agents serving the condo market.
Condos for rent in Milledgeville-Midway-Hardwick Georgia, rental home in Milledgeville-Midway-Hardwick Georgia, Milledgeville-Midway-Hardwick vacation homes for rent by owner, and bed and breakfast rentals
Empty beachfront lodge, penthouse duplex, penthouse villa, and loft houseboat are adjoining in the immediate city of Foley Alabama.
Ascertain, find out, and dig up vacation homes for rent by owner Crane Hill United States, Crane Hill United States vacation homes for rent by owner, and homes for rent Crane Hill United States.
Learn and recognize vacation homes for rent by owner Deatsville and short term rentals Deatsville United States.
Look up, perceive, and distinguish rental houses Shelby, real estate rentals Shelby Alabama, vacation homes Shelby Alabama, and vacation rentals Shelby.
The Foley Alabama city ads, secluded directories, private indexes, and secluded listings for these principality can be mapped.
Ferret out and originate holiday rentals in Boaz United States and holiday rentals.
See city listed properties, log classified advertisements, oceanfront ads, and beachfront indexes that landlords and property brokers post on our page.
Identify, identify, and recognize homes for rent in Fayette Alabama and holiday rentals Fayette Alabama.
Apartment rentals in Riverview, vacation homes, Riverview Michigan house rentals, and apartments for rent in Riverview
Join our beach listings, hillside online MLS, and lakeside ad directories mailing list for short term rentals in Foley Alabama, apartment rentals Foley Alabama, and vacation homes for rent by owner.
Identify, identify, and catch condos for rent in Goodwater United States, Goodwater United States short term rentals, and rental properties in Goodwater.
Hear and observe Madison Alabama real estate rentals and apartments for rent Madison.
You can explore the penthouse online MLS, hidden lists of marked properties, rustic ads, and resort advertisements under apartment rentals Foley, apartment rentals in Foley, and Foley Alabama rent houses.
Dig up and locate the tract and convenient Foley Alabama section.
Students, excursionists, and globetrotters who are wishing to come upon and light upon or simply ferret out information can use our page.
Call up, enter into, initiate, and recruit this evening to kick off, embark on, begin, and open on this wayfaring.
Habitually, further and bail out your habitants, residers, and co-workers to a run after, pleasing, run after, and awash turf.
Distinguish, detect, and observe Gurley United States rental properties, Gurley United States holiday rentals, and vacation rentals.
Find out, distinguish, and perceive Eutaw United States homes for rent by owner, Eutaw United States houses for rent, and Eutaw apartment rentals.
Houses for rent Sycamore, Sycamore Illinois short term rentals, and rental apartment in Sycamore
Using FRBO.com, landlords invoice house and flat lists of marked properties.
Locate, find out, and find out apartments for rent Blount Alabama and Blount Alabama houses for rent.
Come across, identify, and discern vacation rentals in Geneva, rental home in Geneva Alabama, and short term rentals Geneva.
Locate and observe rent houses Danville United States and apartment rentals.
Espy, detect, and come upon rent houses Morgan Alabama and condos for rent.
Foley Alabama is a beauteous, alluring, superb, and admirable state with superb and charming castle, ranch, flat, and haciendas.
Move, elicit, and light upon homes for rent Kansas, Kansas United States short term rentals, and short term rentals in Kansas United States.
Send wonderful, enticing, and resplendent info regarding rental houses in Foley Alabama and condos for rent Foley Alabama found on our page.
Glimpse and recognize real estate rentals in Autaugaville United States and Autaugaville United States holiday rentals.
Light upon and disclose Gantt United States rental houses and holiday rentals.
Find, move, and explore rental homes Mc Intosh United States, Mc Intosh United States rental houses, and rental apartment in Mc Intosh United States.
Identify, conceive, and originate Estillfork United States vacation rental, Estillfork apartments for rent, and Estillfork homes for rent.
Observe, discover, and detect Tallapoosa Alabama for rent by owner homes, holiday rentals in Tallapoosa, and condo rentals Tallapoosa Alabama.
Traveling saleswomen and sightseers poke into and scout this webpage and catch rustic cabin, private ranch, hillside villa, and hillside townhouse.
Disclose and determine rent houses in Haleyville United States and Haleyville United States condo rentals.
Notice, hear, and locate home rentals in Green Pond United States, house rentals Green Pond, and Green Pond United States vacation homes.
Light upon and catch Bibb vacation homes for rent by owner, bed and breakfast rentals Bibb Alabama, and vacation homes for rent by owner Bibb Alabama.
Conceive, glimpse, and devise Tuskegee apartment rentals, Tuskegee United States condo rentals, and Tuskegee vacation homes for rent by owner.
East Hempfield rental homes and East Hempfield Pennsylvania short term rentals
Recognize and identify bed and breakfast rentals in Westover United States and Westover United States bed and breakfast rentals.
Espy and conceive houses for rent in De Kalb Alabama, De Kalb Alabama vacation homes for rent by owner, holiday rentals in De Kalb Alabama, and vacation rental in De Kalb.
Foley Alabama memorandums could stump, hype, thump, and bail out your rummage.
This webpage can inscribe, procure, and interest suburban classified advertisements, beach advertisements, and secluded classified advertisements lakefront classified advertisements and spacious indexes to hype your Foley tour.
Our website, FRBO.com embraces block, city, principality, and domain whole story, at times.
Come upon and debunk Lynn United States for rent by owner homes and for rent by owner homes.
Contrive, devise, and move apartments for rent Dale, rental home in Dale Alabama, rental homes in Dale Alabama, and vacation rentals Dale Alabama.
|
|
