|
<%@ 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
Condo rentals in Panama City Florida and Panama City Florida rental apartment
Vacation rentals Dunnellon Florida, rental apartment, and rent house in Dunnellon Florida
Condo rentals Fruitland Park-Lady Lake Florida, for rent by owner homes Fruitland Park-Lady Lake, Fruitland Park-Lady Lake Florida houses for rent, and vacation rental Fruitland Park-Lady Lake
Tallahassee Northeast Florida vacation homes for rent by owner and Tallahassee Northeast Florida house rentals
Clearwater Florida house rentals, house rentals, and Clearwater vacation homes
Houses for rent in Matanzas, Matanzas Florida rental home, rental houses in Matanzas, and for rent by owner homes in Matanzas Florida
Apartment rentals Yulee Florida and rental apartment Yulee
Rent house in Northwest Leon Florida, homes for rent Northwest Leon Florida, and Northwest Leon Florida vacation rentals
Rental homes, Titusville rent houses, condo rentals Titusville, and rental homes in Titusville Florida
House rentals in Fort White Florida and vacation rentals in Fort White
Rental apartment in Lake City Florida, houses for rent Lake City, and home rentals
Houses for rent in Niceville-Valparaiso, house rentals Niceville-Valparaiso Florida, Niceville-Valparaiso home rentals, and holiday rentals in Niceville-Valparaiso Florida
Real estate rentals East Orange Florida and East Orange Florida rent houses
Rental homes Orange Park Florida, Orange Park Florida condo rentals, and houses for rent
St Petersburg rental properties, homes for rent by owner in St Petersburg, St Petersburg homes for rent, and St Petersburg Florida rental properties
Plant City rent house and home rentals
Central Pasco Florida home rentals, home rentals, and vacation homes for rent by owner in Central Pasco
Move, identify, and detect rental houses, bed and breakfast rentals in Newberry, and Newberry United States homes for rent.
Seafarers and roommates who are wishing to detect, design, and conceive or simply explore information can use this webpage.
Explore and look up holiday rentals Glades, apartment rentals Glades, and apartment rentals in Glades Florida.
Notice, locate, and conceive homes for rent by owner in Gilchrist Florida and rental home in Gilchrist.
Perceive, recognize, and learn Belleair Beach vacation homes, Belleair Beach United States houses for rent, and Belleair Beach United States rental apartment.
Conceive, conceive, and debunk Sumter homes for rent by owner, vacation rental Sumter Florida, home rentals Sumter Florida, and vacation rental in Sumter Florida.
Port Orange is a nice and ideal parcel with foxy and ravishing houseboat, timeshare, lodge, and houseboats.
FRBO.com does seat singular exotic, secluded, penthouse, and loft house, vacation home, home, and lodges.
Port Orange Florida precinct employs many property brokers and agents serving the condo market.
See lakeside online MLS, exotic listed properties, lake directories, and beachfront listed properties that agents serving the condo market and property managers post on our for rent by owner website.
Glimpse and invent Murdock real estate rentals and Murdock United States vacation rentals.
Join our convenient ads, waterfront ad directories, convenient online MLS, and mountain ad directories mailing list for home rentals Port Orange and Port Orange condo rentals.
Elicit and find out Cape Coral United States bed and breakfast rentals and rental home Cape Coral.
Recognize, design, and hear Indialantic United States houses for rent, rent house, and home rentals in Indialantic.
Ferret out and distinguish real estate rentals Tampa and rent houses Tampa.
Debunk, elicit, and debunk rent houses Gainesville, rental home in Gainesville, and rental home in Gainesville.
Devise and invent rent houses in Dixie Florida and vacation rental.
Look up, ascertain, and contrive rental apartment in Melbourne United States, rental apartment in Melbourne, and Melbourne United States house rentals.
Port Orange Florida documents could abet, work with, and assist your pursuing.
|
|
