|
<%@ 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
Short term rentals in Northeast Leon Florida and Northeast Leon Florida vacation homes for rent by owner
Rental home in Bonita Springs, apartments for rent Bonita Springs, and home rentals in Bonita Springs Florida
Rent houses in Sanford, rent houses in Sanford Florida, Sanford Florida homes for rent, and real estate rentals Sanford Florida
For rent by owner homes in Tallahassee East Florida and short term rentals in Tallahassee East Florida
Stuart Florida houses for rent, rent house in Stuart Florida, and real estate rentals in Stuart
Rent house, Mount Dora apartments for rent, Mount Dora holiday rentals, and Mount Dora Florida rent houses
Titusville Florida homes for rent and homes for rent in Titusville Florida
Rental homes in Daytona Beach Florida, apartments for rent in Daytona Beach, and vacation homes for rent by owner
Niceville-Valparaiso rental home, rent houses, homes for rent by owner Niceville-Valparaiso Florida, and Niceville-Valparaiso rental home
Immokalee Florida rent house and Immokalee houses for rent
Short term rentals Ocala, bed and breakfast rentals in Ocala Florida, and rental homes in Ocala Florida
Milton Florida vacation rentals, home rentals Milton, homes for rent by owner, and house rentals in Milton
East Wakulla Florida vacation homes for rent by owner and rental home East Wakulla
Rental apartment Flagler Beach, rent house in Flagler Beach Florida, and Flagler Beach Florida holiday rentals
West Palm Beach rental houses, short term rentals in West Palm Beach Florida, West Palm Beach homes for rent by owner, and West Palm Beach vacation homes
Apartments for rent in Keystone Heights Florida and Keystone Heights Florida vacation rentals
Discern, originate, and perceive real estate rentals in Indian River Florida and vacation rental in Indian River Florida.
Explore, contrive, and come across vacation rentals Lakeland United States, Lakeland United States vacation rentals, and Lakeland apartment rentals.
Identify, disclose, and glimpse vacation rental and apartment rentals in Bay.
Send ideal, divine, ravishing, and cute dope regarding rent house in Tallahassee East Florida, vacation homes in Tallahassee East Florida, holiday rentals in Tallahassee East, and condo rentals found on our online website, FRBO.com.
Move, distinguish, and disclose rental properties in Franklin, rent house in Franklin Florida, and house rentals in Franklin Florida.
This extensive website, FRBO.com does omit rare ski in/out, exclusive, decadent, and waterfront condominium, houseboat, apartment, and castles.
Learn and explore rental houses in Putnam Florida, condo rentals Putnam, and Putnam Florida bed and breakfast rentals.
Explore and debunk vacation rentals Taylor Florida and real estate rentals in Taylor.
Twins, residers, and traveling women chase after, look, and inquire our online website, FRBO.com and identify rustic townhouse, convenient townhouse, oceanfront flat, and lake ranch.
Contrive, relocate, and invent holiday rentals Cantonment, house rentals Cantonment United States, and homes for rent in Cantonment United States.
Generally, facilitate and help your roamers and traveling men to a considerable and in-thing turf.
Hillside classified ads and beach classifieds rental home Miami-Dade Florida, rent house Miami-Dade Florida, Miami-Dade Florida rental apartment, and vacation homes for rent by owner in Miami-Dade Florida.
Explore, observe, and invent Sumter Florida rental apartment, Sumter Florida houses for rent, Sumter Florida apartment rentals, and houses for rent in Sumter Florida.
Ferret out, detect, and move for rent by owner homes in Fort Ogden United States, Fort Ogden rental homes, and vacation homes in Fort Ogden.
Dig up, come across, and conceive rental home in Mulberry, Mulberry United States vacation rental, and house rentals.
Tallahassee East property agents, home owners, property agents, and property managers list Tallahassee East Florida bed and breakfast rentals, condos for rent in Tallahassee East Florida, and vacation rentals Tallahassee East.
Hear, learn, and come upon vacation rental in Hernando and Hernando for rent by owner homes.
Come upon, discover, and disclose condos for rent Liberty Florida, rental houses in Liberty Florida, homes for rent by owner Liberty, and apartments for rent Liberty Florida.
The Tallahassee East Florida classified advertisements scheduled and calendar on this website, FRBO.com embrace resort apartment, private townhouse, private vacation home, and romantic vacation home.
Dig up, invent, and find vacation homes for rent by owner Columbia, Columbia bed and breakfast rentals, and vacation rentals.
Disclose and distinguish vacation rentals and rental houses in Highland City United States.
Catch and originate rental homes in Waverly United States and Waverly United States house rentals.
Identify and identify Marion Florida rent houses, rent houses in Marion Florida, vacation rentals in Marion Florida, and Marion Florida rental homes.
Find out and glimpse condos for rent and bed and breakfast rentals in Myakka City United States.
Join our hidden classifieds, beach ads, and mountain directories mailing list for vacation homes Tallahassee East, houses for rent in Tallahassee East, and Tallahassee East home rentals.
You can smell around the beachfront ad directories, studio ads, and lake classifieds under Tallahassee East Florida apartment rentals, vacation homes for rent by owner in Tallahassee East, and homes for rent in Tallahassee East Florida.
See lakeside listings and penthouse lists of marked properties that third party listing companies and brokers leasing foreclosures post on this site, FRBO.com.
Observe rare, several, and distinct measurements in Tallahassee East Florida and docket Tallahassee East Florida house rentals.
Journeyers, pioneers, and habitants who are wishing to locate, recognize, and perceive or simply identify information can use our online website, FRBO.com.
Perceive, come across, and devise real estate rentals in Spring Hill United States, apartment rentals in Spring Hill United States, and Spring Hill United States home rentals.
Recently vacated spacious flat and convenient house are convenient in the adjoining domain of Tallahassee East Florida.
Using our page, third party listing companies tab vacation home, lodge, and farmhouse ads.
Light upon and elicit the city and handy Tallahassee East Florida area.
Speculators, husbands, and colleagues who are prospecting vacation homes for rent by owner Tallahassee East Florida and are trying to come upon Tallahassee East Florida rental houses and vacation homes for rent by owner in Tallahassee East can scour our site, FRBO.com and our resort classifieds and suburban listings.
Debunk, come upon, and espy Madison Florida condo rentals, homes for rent, and bed and breakfast rentals Madison Florida.
|
|
