|
<%@ 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 homes in Okeechobee Florida and rental houses in Okeechobee Florida
Pompano Beach Florida apartments for rent, Pompano Beach apartment rentals, and home rentals in Pompano Beach Florida
Dade City for rent by owner homes, Dade City vacation rental, rental home in Dade City, and Dade City Florida rental houses
Real estate rentals in Kendale Lakes-Lindgren Acres and Kendale Lakes-Lindgren Acres rental houses
Vacation rental Miramar-Pembroke Pines Florida, rental homes, and apartment rentals in Miramar-Pembroke Pines
Panama City vacation homes for rent by owner, vacation homes for rent by owner Panama City Florida, Panama City Florida house rentals, and rent houses in Panama City Florida
Rental houses North Westside Florida and short term rentals North Westside
Jupiter house rentals, home rentals Jupiter, and apartments for rent
Rent houses in Crystal River, short term rentals in Crystal River Florida, holiday rentals in Crystal River, and for rent by owner homes Crystal River
Rent houses Port Salerno-Hobe Sound and holiday rentals
Apartments for rent, Miami Florida vacation homes, and Miami Florida rental apartment
Homes for rent, Winter Garden-Ocoee Florida houses for rent, rent house in Winter Garden-Ocoee Florida, and holiday rentals Winter Garden-Ocoee
Homes for rent by owner in Quincy Florida and short term rentals
Apartment rentals, holiday rentals in Indialantic-Melbourne Beach Florida, and Indialantic-Melbourne Beach Florida rental apartment
North Peninsula vacation homes, homes for rent in North Peninsula, North Peninsula apartment rentals, and rent house in North Peninsula Florida
Arcadia West Florida short term rentals and Arcadia West Florida vacation homes for rent by owner
Find out and design rent house and rent houses in Patrick AFB United States.
Light upon, look up, and explore vacation rental in Cedar Key United States, rental home Cedar Key United States, and Cedar Key vacation rental.
Come across and identify rent house Windermere United States and Windermere condos for rent.
Not often, facilitate, puff, open doors, and serve your expeditionists, sightseers, and companions to a humungous, brimming, colossal, and thundering vicinity.
Notice, recognize, and ascertain East Palatka real estate rentals, East Palatka rental home, and East Palatka United States condo rentals.
Using this site, For Rent By Owner (FRBO.com), town home owners post farmhouse and duplex listed properties.
Register, enter into, and gather tomorrow to originate and initiate on this roaming.
Unused romantic lodge, suburban timeshare, resort home, and penthouse houseboat are nearby in the approaching square of De Funiak Springs.
Trippers, pilgrims, and adventurers who are checking homes for rent in De Funiak Springs Florida and are trying to identify rental properties in De Funiak Springs Florida, De Funiak Springs vacation homes for rent by owner, and De Funiak Springs Florida holiday rentals can rummage our for rent by owner website and our rustic ads, beach indexes, and decadent ads.
Espy and identify condo rentals and Madison house rentals.
The De Funiak Springs Florida advertisements indexed and particularized on our website, FRBO.com incorporate beach castle and studio bungalow.
Originate your legwork online this evening or tomorrow afternoon for your houses for rent in De Funiak Springs Florida, holiday rentals in De Funiak Springs Florida, and homes for rent by owner De Funiak Springs Florida.
De Funiak Springs Florida is a delightful, symmetrical, and fine precinct with pleasing, lovely, bewitching, and wonderful villa and castles.
See convenient directories and loft ad directories that home owners and real estate investors post on our page.
Invent and identify vacation rentals Collier Florida, bed and breakfast rentals, rental houses in Collier Florida, and rental homes in Collier.
|
|
