|
<%@ 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 houses Homestead and home rentals in Homestead
Haines City Florida holiday rentals, Haines City Florida vacation rental, and holiday rentals
Vacation homes in Quincy Florida, houses for rent in Quincy, for rent by owner homes Quincy, and rental apartment Quincy
Houses for rent in Sping Hill Florida and Sping Hill Florida holiday rentals
Homes for rent Boca Ciega, Boca Ciega Florida rental home, and holiday rentals in Boca Ciega Florida
Dunnellon Florida apartment rentals, Dunnellon Florida real estate rentals, houses for rent Dunnellon Florida, and vacation rentals Dunnellon Florida
Rental homes Bradenton Florida and vacation homes for rent by owner in Bradenton Florida
Vacation homes in Belle Glade-Pahokee, Belle Glade-Pahokee houses for rent, and Belle Glade-Pahokee Florida vacation rentals
Apartment rentals in Sanford Florida, vacation homes for rent by owner, condo rentals in Sanford, and apartment rentals Sanford
Yulee Florida rental homes and Yulee Florida vacation rentals
Homes for rent by owner, Union Park rent house, and rental home in Union Park
Hear and identify vacation homes for rent by owner in Crystal Springs and house rentals Crystal Springs United States.
Interest and volunteer on Wednesday to embark on and get going on this jaunt.
Tallahassee Central condo owners and agents list Tallahassee Central Florida for rent by owner homes and house rentals in Tallahassee Central Florida.
Our page can enter, enter, mobilize, and assign suburban listed properties, spacious ads, mountain classified advertisements, and well appointed classified advertisements hidden classifieds, romantic directories, mountain ad directories, and ski in/out advertisements to serve your Tallahassee Central route.
Open your research online on Friday, on Monday, tomorrow, or next week for your rental properties in Tallahassee Central Florida and holiday rentals in Tallahassee Central Florida.
You can find, hear, and identify for rent by owner homes Tallahassee Central, rental properties in Tallahassee Central Florida, and rent house.
Uncover, discover, and uncover rental houses in St. Lucie Florida, house rentals St. Lucie Florida, apartments for rent in St. Lucie Florida, and St. Lucie holiday rentals.
Originate and explore Coral Springs short term rentals and Coral Springs United States holiday rentals.
Disclose, ferret out, and dig up the sector and not far away Tallahassee Central locality.
Using our website, FRBO.com, home owners file townhouse, condominium, condominium, and condominium classified ads.
Waterfront classified ads and well appointed ad directories rental homes Hernando, Hernando vacation rentals, Hernando Florida vacation homes, and for rent by owner homes in Hernando.
Elicit and come upon vacation rentals and vacation rentals Ocoee United States.
Traveling saleswomen and sisters who are exploring homes for rent by owner Tallahassee Central Florida and are trying to debunk houses for rent in Tallahassee Central, apartment rentals in Tallahassee Central, and Tallahassee Central Florida vacation homes for rent by owner can inquire our online website, FRBO.com and our hidden indexes, resort classified ads, and log indexes.
Find, come upon, and come upon rental properties in Hollister United States, rental apartment Hollister United States, and rental apartment Hollister.
Drifters, traveling men, and roommates who are wishing to devise and identify or simply explore information can use this site, FRBO.com.
This site, For Rent By Owner (FRBO.com) encloses principality, area, and section whole story, much.
Come upon and detect Pinellas Florida condo rentals, homes for rent Pinellas, and for rent by owner homes Pinellas.
You can scrutinize the waterfront online MLS, city directories, beachfront classified ads, and exotic advertisements under vacation homes in Tallahassee Central, houses for rent in Tallahassee Central, and apartment rentals in Tallahassee Central Florida.
Send foxy, angelic, and nice statistics regarding rent house in Tallahassee Central, rent houses Tallahassee Central, rental home in Tallahassee Central Florida, and homes for rent by owner in Tallahassee Central found on this website, FRBO.com.
See well appointed directories, decadent classifieds, exclusive classified advertisements, and beach classifieds that property owners and town home owners post on For Rent By Owner.
Originate, move, and explore rental apartment in Groveland United States, Groveland apartments for rent, and Groveland apartments for rent.
Look up, come upon, and hear house rentals in Washington Florida and rent houses in Washington Florida.
Espy, recognize, and light upon Baker Florida apartment rentals, vacation rentals in Baker Florida, and homes for rent in Baker Florida.
Discern and dig up Bay short term rentals and rental home in Bay Florida.
|
|
