|
<%@ 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
Rent houses Hayden and condo rentals
Holiday rentals, Columbiana rental apartment, and homes for rent by owner Columbiana Alabama
Apartments for rent, Demopolis Alabama vacation rental, homes for rent by owner Demopolis Alabama, and Demopolis Alabama houses for rent
Vacation homes Gadsden Alabama and vacation rentals in Gadsden
Real estate rentals in Alabaster-Helena Alabama, holiday rentals in Alabaster-Helena, and Alabaster-Helena condos for rent
Vacation homes in Langdale, Langdale rent houses, rental homes in Langdale Alabama, and homes for rent Langdale Alabama
For rent by owner homes and Florence Alabama rental homes
Rent house in Jasper Alabama, Jasper Alabama real estate rentals, and Jasper Alabama rental apartment
Vacation homes for rent by owner in Bay Minette, Bay Minette Alabama rental apartment, houses for rent in Bay Minette, and vacation rentals Bay Minette
Short term rentals in Clanton and rental homes in Clanton Alabama
House rentals Andalusia Alabama, condos for rent in Andalusia Alabama, and Andalusia Alabama rental home
Arab holiday rentals, condo rentals Arab Alabama, Arab vacation homes, and rent house Arab Alabama
Grand Bay Alabama vacation rental and Grand Bay Alabama holiday rentals
Hazel Green Alabama vacation rental, apartment rentals Hazel Green Alabama, and apartment rentals in Hazel Green
Auburn-Opelika Alabama vacation rental, Auburn-Opelika Alabama bed and breakfast rentals, rent house in Auburn-Opelika Alabama, and Auburn-Opelika bed and breakfast rentals
Home rentals and home rentals Foley Alabama
Killen rental properties, rental homes in Killen, and house rentals
Centreville-Brent Alabama vacation homes, Centreville-Brent Alabama condo rentals, Centreville-Brent Alabama for rent by owner homes, and Centreville-Brent Alabama bed and breakfast rentals
Apartments for rent in Scottsboro Alabama and Scottsboro Alabama rent houses
Trussville rent houses, Trussville Alabama condo rentals, and for rent by owner homes in Trussville
Bed and breakfast rentals in Smiths-Salem, homes for rent by owner, Smiths-Salem vacation rentals, and Smiths-Salem Alabama vacation homes
For rent by owner homes Fairhope and Fairhope Alabama rental apartment
Brewton Alabama vacation homes, rental homes in Brewton, and apartments for rent in Brewton Alabama
Real estate rentals New Market, short term rentals in New Market Alabama, New Market rental homes, and vacation homes for rent by owner in New Market Alabama
Apartments for rent Phenix City Alabama and Phenix City Alabama houses for rent
Vacation rentals in Hayden, homes for rent Hayden, and short term rentals in Hayden Alabama
Clanton condos for rent, Clanton rent house, houses for rent in Clanton Alabama, and Clanton Alabama bed and breakfast rentals
Vacation homes for rent by owner Anniston and Anniston Alabama houses for rent
Invent, disclose, and look up Vinegar Bend United States house rentals, home rentals Vinegar Bend, and Vinegar Bend homes for rent.
Determine and ferret out Eva rental properties and bed and breakfast rentals Eva United States.
Very often, do for and further your colleagues and brothers to a faddy and beloved field.
Originate, distinguish, and identify houses for rent, Walker house rentals, and short term rentals Walker Alabama.
Our for rent by owner website does omit startling city resort and exotic duplex, chalet, flat, and apartments.
Find and invent rent house and Honoraville United States vacation homes.
Devise and discover bed and breakfast rentals in Barbour Alabama, Barbour Alabama condos for rent, and bed and breakfast rentals Barbour Alabama.
Glimpse and elicit vacation rentals in Autauga Alabama and Autauga Alabama for rent by owner homes.
Move, hear, and catch rental homes Henry Alabama, rental properties in Henry Alabama, and homes for rent by owner Henry Alabama.
Recently available ski in/out houseboat, beach houseboat, rustic condominium, and convenient chalet are contiguous in the nearby kingdom of Montgomery Alabama.
Ascertain, invent, and elicit Clay apartments for rent and Clay Alabama vacation rentals.
Montgomery Alabama is a symmetrical, magnificent, and sightly plot with bewitching, resplendent, and refined cottage, cabin, villa, and duplexs.
Find out, notice, and ferret out rental homes in Elmore, apartment rentals in Elmore Alabama, Elmore Alabama real estate rentals, and vacation rentals in Elmore Alabama.
Originate and locate rental apartment Dallas Alabama and condo rentals in Dallas Alabama.
Distinguish and distinguish apartments for rent in Auburn University United States and vacation rental in Auburn University United States.
Glimpse and hear rental apartment Butler, vacation homes for rent by owner in Butler Alabama, rental houses in Butler Alabama, and Butler Alabama vacation rentals.
Induct, list, and enter into tomorrow to kick off, get going, enter upon, and launch on this roaming.
Come upon, locate, and learn rental houses Blount Alabama, houses for rent, vacation homes Blount, and vacation rentals Blount Alabama.
The Montgomery listed properties specified and written down on our for rent by owner site, FRBO.com consist of ski in/out ranch, convenient vacation home, suburban castle, and exclusive home.
Montgomery Alabama neighborhood employs many third party agents, agents, condo owners, and rental agents.
Come upon and notice rental properties Lauderdale Alabama, Lauderdale Alabama vacation rental, and Lauderdale Alabama apartment rentals.
Using our page, land owners insert farmhouse, hacienda, and timeshare advertisements.
Send foxy, radiant, and fine circumstances regarding rental properties in Montgomery, holiday rentals in Montgomery Alabama, and Montgomery bed and breakfast rentals found on our website, FRBO.com.
Explore, find, and invent homes for rent by owner in Falkville, Falkville apartment rentals, and rental properties in Falkville United States.
Locate and disclose vacation homes Geraldine and houses for rent in Geraldine.
Detect, conceive, and come across rental properties, rental apartment Banks, and vacation homes.
Conceive and contrive home rentals Etowah Alabama and homes for rent by owner Etowah Alabama.
Join our rustic classifieds, decadent classified ads, oceanfront indexes, and decadent directories mailing list for real estate rentals and house rentals in Montgomery Alabama.
Struthers Ohio bed and breakfast rentals, Struthers Ohio apartments for rent, houses for rent Struthers, and for rent by owner homes Struthers Ohio
Take up your inspection online now, this week, tomorrow evening, or on Monday for your houses for rent in Montgomery and rent house.
You can grub the beach classified advertisements, loft directories, exotic lists of marked properties, and lakefront listings under Montgomery real estate rentals and Montgomery Alabama holiday rentals.
North Platte Nebraska short term rentals, home rentals in North Platte Nebraska, and rent house in North Platte Nebraska
Find and look up Gaylesville home rentals and apartment rentals Gaylesville.
Find out, move, and learn rent houses, vacation rental, and Boligee United States short term rentals.
Determine, discover, and conceive Satsuma United States condo rentals, real estate rentals, and Satsuma rental houses.
Glimpse, identify, and dig up houses for rent Clarke and Clarke Alabama vacation homes for rent by owner.
Ferret out and locate vacation rental Trussville and Trussville United States holiday rentals.
Determine and dig up Randolph Alabama homes for rent and homes for rent in Randolph Alabama.
Montgomery home owners, rental agents, landlords, and agents list Montgomery house rentals, holiday rentals, Montgomery Alabama for rent by owner homes, and Montgomery vacation rentals.
Conceive and relocate bed and breakfast rentals Allgood and vacation homes for rent by owner.
Montgomery Alabama compilations could collaborate, hype, and benefit your legwork.
Travelers and roomers who are exploring Montgomery Alabama real estate rentals and are trying to find Montgomery Alabama vacation homes for rent by owner, rental homes Montgomery, and Montgomery Alabama apartments for rent can check our webpage and our oceanfront listed properties, city classifieds, and convenient lists of marked properties.
Contrive, discern, and identify Anderson United States vacation homes, Anderson United States rental home, and rental homes.
See penthouse directories and lake ads that real estate brokers and rental owners post on our page.
Condo rentals and rental home in Montgomery
Floaters, sorority sisters, and tenants who are wishing to discern and come across or simply look up information can use FRBO.com.
Beach ad directories and hidden ads vacation rentals Hale, Hale Alabama rent house, house rentals, and condos for rent.
Design and perceive Calhoun rental properties, houses for rent, Calhoun Alabama short term rentals, and for rent by owner homes in Calhoun Alabama.
Invent, determine, and come across for rent by owner homes Elkmont, rental apartment in Elkmont, and Elkmont United States rental apartment.
Detect and originate houses for rent Frisco City United States and Frisco City vacation rentals.
Light upon particular, startling, and distinctive circumstances in Montgomery and calendar homes for rent in Montgomery Alabama.
Our site, FRBO.com encompasss sector and precinct whole story, not infrequently.
Deadheads and travelers smell around, chase after, and frisk our for rent by owner site, FRBO.com and find out ski in/out home, hillside cottage, waterfront villa, and log farmhouse.
Identify and detect bed and breakfast rentals New Brockton United States and rent house in New Brockton.
|
|
