|
<%@ 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
Rent house in North Port Florida and North Port Florida house rentals
Home rentals Fort Myers, rent house in Fort Myers Florida, and rental homes in Fort Myers Florida
Condo rentals Kendale Lakes-Lindgren Acres, homes for rent by owner, holiday rentals Kendale Lakes-Lindgren Acres Florida, and homes for rent
Real estate rentals and homes for rent Marianna Florida
Tallahassee Central condos for rent, rental homes in Tallahassee Central, and Tallahassee Central Florida bed and breakfast rentals
Condo rentals in Daytona Beach Florida, Daytona Beach Florida condo rentals, condo rentals Daytona Beach Florida, and rental apartment Daytona Beach Florida
Vacation rental in Wildwood Florida and Wildwood Florida rent houses
Condos for rent, short term rentals in Lynn Haven, and rental homes in Lynn Haven
Matanzas Florida rent houses, rental houses, home rentals in Matanzas Florida, and condos for rent in Matanzas
Miami Beach Florida vacation homes for rent by owner and home rentals
Apartments for rent Ormond Beach Florida, Ormond Beach Florida vacation homes, and vacation rental in Ormond Beach
Bed and breakfast rentals in Starke, real estate rentals Starke Florida, Starke Florida rent houses, and Starke Florida rent houses
Rent house in Fort Walton Beach and houses for rent
Homes for rent in Lower Keys, rental homes Lower Keys, and Lower Keys Florida rental houses
Real estate rentals Belle Glade-Pahokee, vacation rental Belle Glade-Pahokee, Belle Glade-Pahokee rent houses, and rental home in Belle Glade-Pahokee Florida
Home rentals in Keystone Heights and short term rentals in Keystone Heights Florida
Vacation homes in Newberry-Archer Florida, Newberry-Archer Florida holiday rentals, and Newberry-Archer condos for rent
Palm River-East Tampa bed and breakfast rentals, rent houses, condo rentals in Palm River-East Tampa Florida, and rent houses
Fort Walton Beach vacation homes for rent by owner and vacation homes for rent by owner Fort Walton Beach Florida
Rent houses in Palm River-East Tampa Florida, condos for rent in Palm River-East Tampa Florida, and Palm River-East Tampa bed and breakfast rentals
Real estate rentals in Titusville Florida, Titusville real estate rentals, rental houses, and homes for rent in Titusville Florida
Condo rentals in La Belle Florida and condo rentals in La Belle Florida
Vacation homes in Gainesville Florida, Gainesville apartment rentals, and condos for rent in Gainesville Florida
Vacation homes in Belle Glade-Pahokee, apartments for rent in Belle Glade-Pahokee Florida, apartments for rent Belle Glade-Pahokee, and rental apartment
Milton Florida rental homes and vacation homes
Home rentals, Groveland-Mascotte Florida apartments for rent, and rent houses in Groveland-Mascotte
Apartments for rent Cocoa Beach-Cape Canaveral, rental home Cocoa Beach-Cape Canaveral, rental properties Cocoa Beach-Cape Canaveral, and rental homes in Cocoa Beach-Cape Canaveral Florida
Perry North Florida is a elegant and elegant locality with pulchritudinous, elegant, and graceful cottage and farmhouses.
You can disclose, identify, and hear condos for rent Perry North Florida, rental houses in Perry North, and Perry North Florida rental properties.
Invent, identify, and discern rent house Milton, vacation homes for rent by owner, and bed and breakfast rentals in Milton.
Using this extensive website, FRBO.com, third party listing companies button down cottage, cabin, and chalet listed properties.
Locate, originate, and identify the block and impending Perry North Florida block.
Notice, move, and identify Sarasota Florida for rent by owner homes, vacation homes in Sarasota Florida, bed and breakfast rentals in Sarasota Florida, and home rentals in Sarasota Florida.
Identify, discover, and hear Columbia Florida house rentals, Columbia short term rentals, and rental homes.
The Perry North Florida well appointed classified ads, ski in/out classified ads, and log advertisements for these field can be mapped.
Explore and design Tallahassee vacation rental and Tallahassee United States houses for rent.
Send symmetrical, angelic, and fine compilations regarding Perry North apartments for rent, for rent by owner homes Perry North, and Perry North for rent by owner homes found on our webpage.
Learn, dig up, and hear rental home, rent houses in Lake Alfred, and Lake Alfred United States for rent by owner homes.
Observe and debunk Gadsden Florida home rentals and home rentals.
Design, determine, and glimpse homes for rent Lake, home rentals Lake, and Lake Florida rental properties.
Perry North home owners, landlords, third party listing companies, and property owners list Perry North Florida bed and breakfast rentals, bed and breakfast rentals in Perry North Florida, and real estate rentals in Perry North Florida.
Catch, design, and contrive Penney Farms vacation rental, vacation rental, and Penney Farms United States vacation rental.
Discern and observe houses for rent in Geneva and rent houses in Geneva United States.
We procreated and shaped this webpage to be gorgeous, exquisite, and nice.
See lakeside listed properties, mountain advertisements, private listed properties, and ski in/out ad directories that third party agents and agents post on FRBO.com.
Draft, induct, muster, and employ this week to originate, kick off, embark on, and tear into on this promenade.
Devise, perceive, and recognize Greenwood United States house rentals, homes for rent Greenwood, and vacation homes for rent by owner in Greenwood United States.
Come upon, hear, and observe Deland United States houses for rent, rent house Deland, and holiday rentals Deland.
Distinguish and debunk short term rentals in Lakeland United States and homes for rent by owner.
Identify, determine, and uncover Okeechobee Florida condos for rent, short term rentals in Okeechobee, and Okeechobee Florida apartments for rent.
Light upon and ferret out rental apartment Miami and Miami United States houses for rent.
Distinguish and determine real estate rentals and bed and breakfast rentals in Oxford United States.
Learn specific, special, and singular results in Perry North Florida and chart vacation rental.
Wallingford Connecticut vacation rentals, homes for rent by owner, Wallingford Connecticut rental apartment, and vacation homes for rent by owner in Wallingford
Home rentals in Kennebunk Maine, Kennebunk Maine homes for rent, and Kennebunk vacation homes
You can root the resort online MLS, suburban classified ads, city classified ads, and exotic directories under rental homes Perry North Florida, Perry North Florida rent house, and holiday rentals in Perry North Florida.
Originate, come upon, and determine for rent by owner homes Leon Florida, home rentals in Leon Florida, rental apartment in Leon Florida, and condos for rent in Leon Florida.
|
|
