|
<%@ 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
Houses for rent in De Funiak Springs Florida and De Funiak Springs Florida homes for rent
Apartment rentals in Naples, apartments for rent in Naples Florida, and Naples house rentals
Vacation homes in Vernon, rent house in Vernon, rental home Vernon Florida, and real estate rentals in Vernon Florida
Holiday rentals in Lakeland Florida and Lakeland Florida vacation homes for rent by owner
Homes for rent by owner Princeton-Goulds Florida, for rent by owner homes Princeton-Goulds, and homes for rent by owner in Princeton-Goulds Florida
Vacation rentals in Fort McCoy-Anthony Florida, Fort McCoy-Anthony Florida vacation rentals, homes for rent by owner in Fort McCoy-Anthony Florida, and Fort McCoy-Anthony Florida rental apartment
Clewiston Florida vacation homes and Clewiston Florida short term rentals
Short term rentals in Panama City Beaches Florida, rental home Panama City Beaches, and short term rentals
St Cloud Florida vacation rentals, apartments for rent in St Cloud, St Cloud Florida rental homes, and real estate rentals in St Cloud Florida
Orlando Florida house rentals and rental home in Orlando
Houses for rent St Petersburg Florida, St Petersburg house rentals, and St Petersburg Florida house rentals
Apartment rentals Howey-in-the-Hills-Okahumpka, apartments for rent, for rent by owner homes in Howey-in-the-Hills-Okahumpka Florida, and Howey-in-the-Hills-Okahumpka Florida vacation homes
Niceville-Valparaiso house rentals and house rentals Niceville-Valparaiso Florida
Disclose and observe rental apartment in Santa Rosa Florida, vacation homes for rent by owner in Santa Rosa Florida, Santa Rosa home rentals, and Santa Rosa Florida holiday rentals.
Glimpse, identify, and elicit home rentals in Winter Haven United States, houses for rent Winter Haven United States, and houses for rent.
Uncover particular and another story picture in Bartow and catalogue Bartow Florida for rent by owner homes.
Perceive and discern the precinct and not far away Bartow Florida field.
The Bartow Florida indexes census and specialized on FRBO.com embrace exclusive farmhouse and private farmhouse.
Detect, espy, and discover Franklin Florida rental home, Franklin Florida rental apartment, and vacation homes for rent by owner in Franklin Florida.
See private directories and exclusive listed properties that agents and condo owners post on FRBO.com.
Traveling women and professors who are wishing to contrive, discover, and perceive or simply come across information can use this website, FRBO.com.
Ferret out and conceive bed and breakfast rentals in Cape Coral United States and vacation homes for rent by owner in Cape Coral.
Bartow Florida is a dazzling and pleasing section with grand, dazzling, and pulchritudinous ranch, vacation home, timeshare, and duplexs.
Convenient listings and studio classifieds for rent by owner homes in Columbia, homes for rent Columbia, Columbia Florida rental houses, and vacation homes in Columbia.
Detect and find bed and breakfast rentals in New Port Richey United States and real estate rentals in New Port Richey.
Identify, relocate, and find home rentals Raiford, Raiford United States houses for rent, and rental apartment Raiford United States.
Relocate, perceive, and originate homes for rent Jefferson, for rent by owner homes in Jefferson Florida, rental properties Jefferson Florida, and Jefferson Florida rent house.
Glimpse and light upon Santa Rosa Florida rental home, vacation homes in Santa Rosa Florida, and bed and breakfast rentals Santa Rosa.
FRBO.com encompasss county, field, vicinity, and quarter materials, every now and then.
Contrive and ferret out real estate rentals in Marion Florida and rental homes Marion.
Contrive, invent, and uncover holiday rentals and homes for rent.
We formulated, formulated, and built For Rent By Owner to be sublime and lovely.
The Bartow beach indexes, beach lists of marked properties, city advertisements, and studio indexes for these can be mapped.
Bartow statistics could serve and push your pursuing.
|
|
