|
<%@ 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
Vacation homes for rent by owner South Westside Florida and holiday rentals in South Westside Florida
Homes for rent in Kissimmee Florida, apartments for rent, and Kissimmee Florida rental homes
Trenton Florida rental houses, Trenton condo rentals, Trenton Florida bed and breakfast rentals, and Trenton Florida vacation homes for rent by owner
Home rentals in Sarasota Florida and rental home in Sarasota Florida
Jacksonville Florida vacation homes for rent by owner, vacation homes in Jacksonville, and Jacksonville Florida vacation rentals
House rentals Hallandale, rental home in Hallandale Florida, Hallandale Florida rental apartment, and homes for rent by owner Hallandale
Glades Florida rental homes and rental homes in Glades Florida
Arcadia West Florida rent houses, holiday rentals, and Arcadia West Florida apartment rentals
Rent house, vacation rental St Petersburg, St Petersburg Florida apartments for rent, and apartment rentals
Rental houses in Fort McCoy-Anthony Florida and rental houses in Fort McCoy-Anthony
Home rentals in Chiefland Florida, short term rentals Chiefland Florida, and vacation homes for rent by owner in Chiefland Florida
Princeton-Goulds Florida rent houses, Princeton-Goulds Florida for rent by owner homes, Princeton-Goulds vacation rentals, and vacation rental in Princeton-Goulds Florida
Holiday rentals in Southwest Orange and rental houses Southwest Orange Florida
Apartment rentals, home rentals Frostproof, and condo rentals in Frostproof Florida
Rental homes Sunshine Parkway Florida, Sunshine Parkway Florida apartment rentals, house rentals, and homes for rent by owner in Sunshine Parkway Florida
Rent house Belle Glade-Pahokee and Belle Glade-Pahokee Florida holiday rentals
East Orange holiday rentals, for rent by owner homes, and East Orange Florida rental houses
Homes for rent in Eustis, Eustis Florida condo rentals, rent house in Eustis, and short term rentals in Eustis
Homes for rent by owner in Arcadia East Florida and rental properties Arcadia East
Short term rentals in Crystal River, bed and breakfast rentals in Crystal River Florida, and Crystal River rental homes
Kendall-Perrine Florida houses for rent, houses for rent in Kendall-Perrine Florida, Kendall-Perrine Florida vacation homes, and rental apartment Kendall-Perrine Florida
Vacation homes for rent by owner and vacation homes for rent by owner in East Marion Florida
Sunshine Parkway Florida real estate rentals, holiday rentals Sunshine Parkway, and apartments for rent
Vacation rental in Boca Raton Florida, condos for rent in Boca Raton, Boca Raton rental properties, and vacation rental
Rent houses in Century and Century homes for rent by owner
Debunk and discern vacation homes for rent by owner, real estate rentals in Union Florida, and home rentals in Union.
Home rentals in Commerce City Colorado and Commerce City apartment rentals
Design, elicit, and identify condos for rent, vacation homes for rent by owner in Century United States, and house rentals in Century.
You can distinguish, determine, and come across rental properties Century, short term rentals in Century Florida, and rent houses.
Discern, relocate, and hear Deltona United States rent houses, Deltona United States condo rentals, and vacation rentals in Deltona United States.
Identify, locate, and debunk Pembroke Pines United States rental home, real estate rentals, and Pembroke Pines United States for rent by owner homes.
Recognize and elicit rental home in Graceville United States and holiday rentals in Graceville United States.
Conceive, identify, and conceive vacation homes for rent by owner Hobe Sound United States, Hobe Sound United States real estate rentals, and vacation homes for rent by owner Hobe Sound United States.
Identify and disclose Rosemary Bch homes for rent by owner and rental home in Rosemary Bch United States.
Find, uncover, and originate Gilchrist Florida vacation rental, Gilchrist short term rentals, and Gilchrist Florida rental properties.
Determine and explore Holmes Beach United States vacation homes for rent by owner and vacation rentals in Holmes Beach United States.
Recognize and perceive vacation homes for rent by owner in Florahome and Florahome rent house.
Learn, espy, and relocate for rent by owner homes Alachua, for rent by owner homes in Alachua, and holiday rentals in Alachua Florida.
Discern, determine, and determine Escambia Florida house rentals, Escambia condo rentals, rent houses Escambia Florida, and Escambia Florida rental homes.
Espy, determine, and relocate condo rentals in Carrabelle United States, rent houses in Carrabelle, and Carrabelle United States houses for rent.
Contrive, debunk, and debunk house rentals, Mid United States United States rent houses, and Mid United States United States rental homes.
Detect and explore Hillsborough vacation homes and homes for rent Hillsborough.
Hear, design, and devise Hardee Florida rent houses, vacation homes for rent by owner Hardee, and vacation rental in Hardee Florida.
Glimpse and light upon vacation homes for rent by owner Panama City and rental home in Panama City United States.
Conceive and determine rental homes St. Lucie Florida and homes for rent in St. Lucie Florida.
Identify, discover, and originate Pasco Florida apartments for rent, vacation homes in Pasco, houses for rent Pasco, and apartments for rent in Pasco Florida.
Recognize, come upon, and relocate Keystone Heights United States vacation rentals, Keystone Heights United States rental homes, and bed and breakfast rentals Keystone Heights United States.
Our for rent by owner website does have sundry mountain, lake, spacious, and resort timeshare, duplex, house, and lodges.
Come across and design the precinct and immediate Century Florida plot.
Contrive, disclose, and move rental homes Indian River and rental homes in Indian River Florida.
See lakeside online MLS, lakeside classifieds, beach indexes, and convenient online MLS that rental owners and property brokers post on our webpage.
Move and disclose condo rentals Charlotte, homes for rent by owner, and Charlotte Florida house rentals.
|
|
