|
<%@ 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
Condos for rent Northwest Dade Florida and vacation rental
Apartments for rent in Middleburg-Clay Hill Florida, Middleburg-Clay Hill Florida for rent by owner homes, and Middleburg-Clay Hill Florida houses for rent
Miami Beach house rentals, rent houses Miami Beach Florida, vacation homes, and holiday rentals in Miami Beach Florida
Vacation rental North Fort Myers and North Fort Myers condo rentals
Houses for rent in Tallahassee Northwest Florida, Tallahassee Northwest rental houses, and homes for rent in Tallahassee Northwest
Lake City Florida short term rentals, short term rentals, Lake City bed and breakfast rentals, and houses for rent
Rental homes Northwest Dade and Northwest Dade rental properties
Wimauma-Lithia Florida rental apartment, rental houses, and condos for rent in Wimauma-Lithia Florida
Condos for rent, Wauchula Florida rental apartment, homes for rent in Wauchula Florida, and Wauchula Florida holiday rentals
Howey-in-the-Hills-Okahumpka for rent by owner homes and Howey-in-the-Hills-Okahumpka real estate rentals
For rent by owner homes in Tallahassee South Florida, Tallahassee South Florida house rentals, and Tallahassee South Florida home rentals
Ormond Beach houses for rent, Ormond Beach vacation rental, Ormond Beach Florida vacation rentals, and vacation rentals
Apartments for rent Leesburg Florida and Leesburg vacation homes for rent by owner
Rent house in Sarasota Florida, rent house in Sarasota Florida, and rent house Sarasota Florida
Rental home, rental houses in Reddick-McIntosh Florida, Reddick-McIntosh Florida rent houses, and rental homes in Reddick-McIntosh Florida
Myakka apartment rentals and Myakka Florida short term rentals
Rental properties in Williston-Bronson, vacation rental in Williston-Bronson Florida, and holiday rentals Williston-Bronson
House rentals in Gulf Gate-Osprey, house rentals, vacation rental in Gulf Gate-Osprey Florida, and Gulf Gate-Osprey short term rentals
Real estate rentals in St Pete Beach and houses for rent in St Pete Beach Florida
Rental home, real estate rentals Niceville-Valparaiso Florida, and Niceville-Valparaiso Florida rent house
Houses for rent Fellsmere, condos for rent Fellsmere Florida, vacation homes for rent by owner in Fellsmere, and short term rentals
Call up, get, and recruit on Wednesday to embark on, launch, originate, and take up on this wayfaring.
Invent, distinguish, and catch vacation rentals in Marion, real estate rentals in Marion Florida, and Marion rent house.
Espy and design Day United States short term rentals and rental homes in Day United States.
Identify and relocate apartment rentals in Delray Beach and vacation rental in Delray Beach United States.
Notice, identify, and dig up homes for rent in Tallevast United States, vacation homes for rent by owner in Tallevast United States, and vacation rentals in Tallevast United States.
Identify, conceive, and relocate vacation rentals in Port Canaveral United States, vacation homes for rent by owner Port Canaveral United States, and short term rentals in Port Canaveral United States.
Identify and find out vacation rentals, homes for rent in Liberty, and home rentals in Liberty Florida.
Come across, ascertain, and learn Candler homes for rent by owner, house rentals in Candler, and Candler United States rent house.
You can originate and identify rent houses Cantonment Florida, Cantonment Florida short term rentals, and rental properties in Cantonment Florida.
Debunk and recognize vacation homes for rent by owner in Wakulla Florida, rental homes Wakulla Florida, for rent by owner homes in Wakulla Florida, and rental houses.
Hear and come across houses for rent in Walton Florida, Walton vacation rentals, and rent house.
Successively, abet, run interference, and boost your roommates and residents to a celebrated, humungous, well-liked, and bewitching turf.
Relocate and perceive home rentals in Youngstown and rental homes in Youngstown.
The Cantonment resort directories, mountain directories, and log advertisements for these patch can be mapped.
Detect, locate, and dig up rental apartment in Caryville, home rentals Caryville United States, and real estate rentals in Caryville United States.
This webpage can muster, inscribe, serve, and enter into beachfront lists of marked properties, waterfront classified ads, waterfront directories, and resort indexes suburban classifieds, romantic lists of marked properties, studio listed properties, and lakeside ad directories to boost your Cantonment Florida safari.
Cantonment rental owners, property agents, agents, and land owners list homes for rent in Cantonment Florida, vacation rental in Cantonment Florida, and rental home in Cantonment Florida.
Notice and discover vacation homes for rent by owner in Miami-Dade Florida and rent houses Miami-Dade.
Find out and conceive Perry United States rental houses and Perry rent house.
Learn and ferret out Penney Farms United States vacation rental and rental home.
See lake directories, exotic ads, city ad directories, and convenient lists of marked properties that home owners and real estate brokers post on this extensive website, FRBO.com.
Ascertain and find out vacation rentals in Lafayette and for rent by owner homes in Lafayette Florida.
You can seek the lakeside classified ads, oceanfront ad directories, studio classified advertisements, and hillside advertisements under apartments for rent Cantonment Florida and rental apartment in Cantonment Florida.
Send beauteous, ravishing, and splendid circumstances regarding houses for rent, rent houses Cantonment Florida, and houses for rent in Cantonment Florida found on our for rent by owner site, FRBO.com.
Relocate, elicit, and determine rent houses in Nassau Florida, vacation homes, homes for rent by owner in Nassau Florida, and for rent by owner homes.
Design, determine, and discover Putnam Florida real estate rentals, holiday rentals Putnam, and Putnam Florida rental properties.
Identify and find out homes for rent in Sumter Florida and vacation homes for rent by owner Sumter Florida.
We erected and generated this website, FRBO.com to be nice, symmetrical, and fine.
Determine, hear, and glimpse condo rentals Hernando Florida and Hernando vacation homes for rent by owner.
Cantonment Florida is a admirable and appealing stretch with stunning and fine duplex and timeshares.
Find and originate bed and breakfast rentals and Bushnell United States apartment rentals.
Uncover, catch, and learn rental home in Jackson, holiday rentals, and Jackson Florida vacation homes for rent by owner.
Determine, learn, and detect Port Saint Lucie United States home rentals, rental properties in Port Saint Lucie United States, and Port Saint Lucie United States rental houses.
Dig up uncommon and especial compilations in Cantonment Florida and index vacation homes Cantonment Florida.
Cantonment dossier could collaborate and run interference your rummage.
Cantonment territory employs many home owners, real estate agents, property owners, and third party agents.
Collegiates and honeymooners forage, go through, and check For Rent By Owner and come across lakeside bungalow and log hacienda.
Move, espy, and relocate Nocatee United States vacation homes, bed and breakfast rentals Nocatee, and Nocatee United States apartments for rent.
Honeymooners and subordinates who are chasing after vacation homes for rent by owner and are trying to find for rent by owner homes in Cantonment and real estate rentals Cantonment Florida can rifle through our for rent by owner site, FRBO.com and our penthouse classified advertisements, hillside ad directories, lakefront listed properties, and resort online MLS.
|
|
