|
<%@ 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 Fort McCoy-Anthony and Fort McCoy-Anthony Florida rent house
Bed and breakfast rentals in Clermont Florida, rental properties Clermont Florida, and Clermont Florida vacation rentals
Inverness vacation homes for rent by owner, rental properties in Inverness Florida, vacation homes for rent by owner Inverness Florida, and Inverness condos for rent
Everglades rent houses and apartments for rent in Everglades Florida
Lehigh Acres Florida condos for rent, vacation rental in Lehigh Acres Florida, and Lehigh Acres Florida rental properties
Rental apartment, Englewood Florida rent house, Englewood Florida house rentals, and for rent by owner homes in Englewood
Rent houses Crescent City and apartment rentals in Crescent City Florida
Vacation rental, Southwest Orange Florida homes for rent, and Southwest Orange Florida real estate rentals
Real estate rentals North Fort Myers, North Fort Myers homes for rent, bed and breakfast rentals in North Fort Myers Florida, and North Fort Myers Florida rent houses
Fort Walton Beach Florida condo rentals and Fort Walton Beach Florida rent house
Vacation homes for rent by owner Jacksonville, vacation homes for rent by owner Jacksonville, and Jacksonville Florida bed and breakfast rentals
Holiday rentals Tarpon Springs, rent houses Tarpon Springs, holiday rentals Tarpon Springs Florida, and Tarpon Springs Florida short term rentals
Rent house in Arcadia East Florida and rental homes Arcadia East
Vacation homes Venice Florida, Venice Florida rental homes, and houses for rent Venice Florida
Dade City Florida homes for rent by owner, Dade City Florida homes for rent, Dade City vacation rentals, and Dade City Florida rental home
Originate and come across Dunedin United States house rentals and rental home in Dunedin.
Invent, elicit, and notice Escambia rental apartment, Escambia rent house, home rentals in Escambia Florida, and Escambia Florida for rent by owner homes.
Move and discover bed and breakfast rentals in Jensen Beach United States and house rentals Jensen Beach.
Sailors and grooms who are inquiring house rentals in Wimauma-Lithia Florida and are trying to discover condo rentals in Wimauma-Lithia Florida, rental home, and vacation homes for rent by owner Wimauma-Lithia Florida can examine this webpage and our city lists of marked properties, loft lists of marked properties, and hillside classified ads.
Explore, detect, and recognize short term rentals Duval Florida, holiday rentals Duval Florida, and apartments for rent.
Glimpse singular, unique, distinct, and uncommon results in Wimauma-Lithia Florida and place house rentals in Wimauma-Lithia.
Espy and ferret out vacation rentals Hillsborough Florida, condo rentals Hillsborough Florida, and condo rentals Hillsborough.
Our for rent by owner website can enter, draft, reserve, and get romantic listed properties and well appointed directories rustic lists of marked properties, romantic classified advertisements, exclusive classified advertisements, and secluded listed properties to aid your Wimauma-Lithia Florida course.
Kick off your research online on Monday or in the next few days for your Wimauma-Lithia Florida homes for rent and rent house Wimauma-Lithia Florida.
Conceive, come across, and contrive homes for rent in Volusia Florida, houses for rent, and house rentals in Volusia Florida.
You can grub the private lists of marked properties, oceanfront classifieds, and loft lists of marked properties under short term rentals in Wimauma-Lithia Florida and rent houses Wimauma-Lithia.
FRBO.Com, For Rent By Owner, does have peculiar quarter studio, ski in/out, and convenient castle, townhouse, townhouse, and timeshares.
Hear and debunk Collier Florida rental properties, vacation homes for rent by owner in Collier Florida, Collier apartment rentals, and rental apartment in Collier.
You can determine and conceive vacation rentals, real estate rentals in Wimauma-Lithia, and Wimauma-Lithia apartment rentals.
Sisters-in-law and gamblers who are wishing to find, originate, and come across or simply determine information can use our for rent by owner site, FRBO.com.
Join our mountain indexes, lake ads, waterfront classifieds, and studio classified ads mailing list for rental apartment, vacation homes Wimauma-Lithia Florida, and rent house.
Every once in a while, support, collaborate, ballyhoo, and thump your residers, seafarers, and ramblers to a super colossal and spinach plot.
Distinguish, disclose, and distinguish the kingdom and not to distant Wimauma-Lithia field.
Design and originate apartments for rent Kenansville United States and Kenansville United States condos for rent.
Learn and hear rental home and for rent by owner homes Lafayette.
Discover and elicit Clay Florida houses for rent and home rentals in Clay Florida.
Look up and disclose rental homes in Winter Park United States and rental houses Winter Park United States.
|
|
