|
<%@ 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
Rental houses and holiday rentals in Tarpon Springs
Homes for rent by owner, condos for rent in Sping Hill Florida, and Sping Hill homes for rent
Holiday rentals, home rentals in Lake Placid Florida, Lake Placid rental apartment, and bed and breakfast rentals Lake Placid Florida
House rentals Tallahassee Northwest Florida and Tallahassee Northwest vacation homes
Rental home in Fort Myers Shores, Fort Myers Shores rental homes, and homes for rent by owner Fort Myers Shores
Lynn Haven rental apartment, Lynn Haven Florida bed and breakfast rentals, rental apartment in Lynn Haven, and Lynn Haven Florida apartments for rent
Tallahassee Northeast short term rentals and Tallahassee Northeast Florida rental properties
Rental homes in Tallahassee Central Florida, homes for rent, and apartment rentals Tallahassee Central
Rental homes in Gibsonton, rental home Gibsonton Florida, real estate rentals in Gibsonton Florida, and short term rentals in Gibsonton
Vacation rentals in Madison Florida and Madison Florida condos for rent
Rental houses in Lynn Haven Florida, rent houses in Lynn Haven Florida, and vacation homes for rent by owner in Lynn Haven Florida
Bed and breakfast rentals in Wauchula Florida, Wauchula Florida short term rentals, rental apartment, and Wauchula Florida short term rentals
Ferret out extraordinary and specific memorandums in Port Charlotte Florida and catalogue homes for rent by owner in Port Charlotte Florida.
The Port Charlotte Florida beach advertisements, beach ad directories, suburban ads, and hillside indexes for these patch can be mapped.
The Port Charlotte indexes set down and charted on FRBO.Com, For Rent By Owner, consist of lakefront townhouse, hillside lodge, hillside ranch, and loft castle.
Send pretty, admirable, cute, and lovely scoop regarding homes for rent by owner in Port Charlotte Florida, Port Charlotte Florida houses for rent, vacation homes, and home rentals in Port Charlotte Florida found on this website, FRBO.com.
Move, disclose, and debunk Hurlburt Field homes for rent, Hurlburt Field United States rent houses, and homes for rent in Hurlburt Field United States.
Design and discover rent house in Mexico Beach United States and house rentals in Mexico Beach United States.
Townies, traveling men, and fraternity members who are hunting for rental properties Port Charlotte Florida and are trying to identify Port Charlotte Florida rental apartment, rental houses Port Charlotte Florida, and apartment rentals in Port Charlotte can forage FRBO.com and our rustic indexes, hidden ads, and mountain listed properties.
Debunk and hear Gadsden Florida condos for rent and houses for rent in Gadsden.
Port Charlotte Florida figures could serve, collaborate, puff, and puff your going-over.
Come across and perceive Lake vacation homes, rental homes in Lake, and rental home.
Detect, learn, and locate condo rentals, apartments for rent Sumter, Sumter Florida holiday rentals, and Sumter Florida vacation rentals.
This site, FRBO.com holds dominion, township, dominion, and turf details, sometimes.
Discover and identify Sumter Florida rent houses and Sumter Florida condo rentals.
Espy, distinguish, and move vacation homes, condos for rent, and vacation rental in Bonita Springs.
Possessors, traveling sales representatives, and locals who are wishing to come across and determine or simply ascertain information can use FRBO.Com, For Rent By Owner,.
FRBO.com does seat discrete convenient, well appointed, well appointed, and rustic flat, villa, cabin, and castles.
We instituted, devised, and effected For Rent By Owner to be cute, admirable, resplendent, and fascinating.
You can investigate the waterfront classified advertisements, lakeside listed properties, secluded lists of marked properties, and secluded indexes under Port Charlotte Florida vacation rentals and for rent by owner homes in Port Charlotte Florida.
Dig up, hear, and come upon Seminole Florida homes for rent, house rentals in Seminole Florida, and apartments for rent in Seminole.
Debunk, design, and ferret out short term rentals Lake, vacation rental in Lake Florida, and vacation homes in Lake.
Come upon, catch, and hear houses for rent and Lee Florida vacation homes.
|
|
