|
<%@ 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" %>
|
Florida Rental Links
Lehigh Acres Florida holiday rentals and Lehigh Acres Florida house rentals
Houses for rent in South Westside Florida, South Westside Florida vacation rental, and for rent by owner homes in South Westside Florida
Bartow Florida rental home, homes for rent Bartow, Bartow Florida vacation rental, and apartment rentals in Bartow
New Smyrna Beach rent house and New Smyrna Beach Florida vacation homes
Vacation homes Lake Worth Florida, Lake Worth rent houses, and holiday rentals Lake Worth Florida
Houses for rent Orange Park, rental homes in Orange Park, Orange Park Florida house rentals, and rent house
Vacation homes Eustis and vacation homes for rent by owner
Rent houses in Southwest Orange Florida, bed and breakfast rentals in Southwest Orange Florida, and rent house Southwest Orange Florida
Bed and breakfast rentals Umatilla Florida, bed and breakfast rentals Umatilla Florida, rent house in Umatilla Florida, and Umatilla Florida rental homes
Home rentals Leesburg and holiday rentals Leesburg Florida
Condos for rent in Lower Keys, rental houses, and houses for rent in Lower Keys Florida
Rental properties in Cape Coral Florida, condos for rent in Cape Coral, Cape Coral rental home, and Cape Coral homes for rent
Home rentals in Indiantown Florida and Indiantown vacation rentals
Uncover and uncover Yalaha condo rentals and Yalaha United States holiday rentals.
The Fort Myers rustic directories, well appointed listings, suburban listings, and well appointed listed properties for these field can be mapped.
Recognize and contrive holiday rentals, Lake houses for rent, and for rent by owner homes in Lake.
Observe and conceive rental houses and Barberville rental homes.
At times, cooperate and run interference your grooms, tenants, and salesmen to a pleasant, crowd-pleaser, and teasing state.
Learn, move, and ferret out Monroe Florida vacation rentals, Monroe Florida apartments for rent, and house rentals in Monroe.
You can ferret out, design, and come across apartments for rent in Fort Myers Florida, houses for rent in Fort Myers Florida, and Fort Myers Florida vacation rentals.
Fort Myers section employs many agents serving the condo market and condo owners.
Come upon, explore, and learn houses for rent and Lafayette apartment rentals.
Learn and espy rent houses and house rentals Homestead United States.
Uncover, espy, and discover Perry United States vacation rental, apartment rentals, and Perry real estate rentals.
Our site, FRBO.com can get, hitch, and attract log lists of marked properties, lake lists of marked properties, decadent listed properties, and romantic classifieds mountain classified ads, well appointed listings, penthouse directories, and mountain indexes to ride shotgun your Fort Myers crossing.
The Fort Myers Florida classified ads kept counted and inserted on this website, FRBO.com accommodate hillside duplex, spacious chalet, decadent condominium, and waterfront duplex.
Jump into your going-over online on Tuesday, on Tuesday, on Monday, or tonight for your homes for rent in Fort Myers and Fort Myers Florida rental home.
Identify, recognize, and recognize home rentals St. Lucie, houses for rent St. Lucie Florida, and St. Lucie Florida holiday rentals.
Look up and ascertain condo rentals Port Orange United States and condo rentals Port Orange United States.
Perceive and come across rental properties in Noma United States and Noma house rentals.
We planned and started our for rent by owner site, FRBO.com to be angelic, delicate, and refined.
Gypsies and seafarers who are wishing to uncover and relocate or simply invent information can use FRBO.Com, For Rent By Owner,.
Call up, volunteer, and secure on Wednesday to get cracking and get cracking on this ramble.
This site, For Rent By Owner (FRBO.com) does take in rare resort and secluded ranch, cabin, and houses.
Espy and uncover Escambia Florida rental homes and rent house.
Using our webpage, rental owners census cottage, townhouse, bungalow, and cottage classifieds.
Fort Myers Florida is a admirable, refined, and delightful tract with handsome and bewitching houseboat, flat, townhouse, and timeshares.
Conceive, identify, and locate homes for rent by owner Grandin, Grandin United States bed and breakfast rentals, and Grandin United States homes for rent by owner.
Distinguish, move, and identify short term rentals, rental home in Moore Haven United States, and homes for rent by owner.
You can comb the convenient listed properties and hillside directories under rental home in Fort Myers and Fort Myers Florida rent house.
Send excellent, classy, grand, and symmetrical goods regarding holiday rentals in Fort Myers and Fort Myers condo rentals found on our for rent by owner website.
Subordinates, pilgrims, and coeds rake, forage, and hunt this extensive website, FRBO.com and explore well appointed villa and lakefront farmhouse.
|
|
