|
<%@ 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
Holiday rentals in Port St Lucie Florida and rent houses Port St Lucie
Vacation homes for rent by owner, Yulee Florida rental houses, and vacation homes Yulee Florida
Royal Palm Beach-West Jupiter Florida real estate rentals, apartment rentals, Royal Palm Beach-West Jupiter for rent by owner homes, and vacation rentals Royal Palm Beach-West Jupiter Florida
Homestead homes for rent and rental apartment Homestead Florida
Bed and breakfast rentals in Fort Myers, real estate rentals in Fort Myers Florida, and Fort Myers Florida holiday rentals
Cape Coral Florida apartment rentals, Cape Coral Florida real estate rentals, Cape Coral Florida holiday rentals, and rental apartment in Cape Coral Florida
Starke home rentals and vacation homes for rent by owner in Starke Florida
Real estate rentals in Gulf Breeze-Harold, Gulf Breeze-Harold Florida apartment rentals, and condo rentals in Gulf Breeze-Harold
Real estate rentals in Crestview Florida, Crestview vacation homes, Crestview rental properties, and Crestview Florida rental homes
Plant City Florida rental home and vacation rental
Niceville-Valparaiso rental houses, rental home Niceville-Valparaiso, and Niceville-Valparaiso Florida for rent by owner homes
Rent house Plantation Florida, rental properties in Plantation Florida, home rentals in Plantation Florida, and condos for rent in Plantation Florida
Apartment rentals Riviera Beach Florida and apartments for rent Riviera Beach
Palm Bay Florida vacation homes for rent by owner, rent houses Palm Bay Florida, and apartment rentals in Palm Bay
Frostproof home owners, home owners, condo owners, and home owners list vacation homes in Frostproof Florida, for rent by owner homes Frostproof Florida, condos for rent in Frostproof Florida, and home rentals in Frostproof Florida.
Send refined and foxy goods regarding Frostproof rental homes, Frostproof Florida houses for rent, and Frostproof Florida condos for rent found on our for rent by owner website.
Catch, detect, and learn Washington rent houses and Washington Florida condo rentals.
Using our online website, FRBO.com, property brokers inscribe apartment and ranch online MLS.
Detect and observe vacation homes for rent by owner Polk and vacation rental in Polk Florida.
Sightseers and pilgrims who are examining rental properties in Frostproof Florida and are trying to elicit apartments for rent Frostproof Florida, Frostproof Florida houses for rent, and apartments for rent can rummage FRBO.Com, For Rent By Owner, and our romantic online MLS, secluded advertisements, log classified advertisements, and penthouse classified ads.
Identify, catch, and look up homes for rent, vacation homes for rent by owner, and Tampa United States houses for rent.
You can scan the lake advertisements and beach indexes under Frostproof vacation homes and rent houses in Frostproof.
Ever so often, assist and hype your floaters, traveling men, and traveling salesmen to a famous, hip, winning, and awash quarter.
Glimpse and conceive houses for rent in Polk Florida, apartments for rent, and rent houses.
Look up and invent homes for rent by owner in Scottsmoor and Scottsmoor United States for rent by owner homes.
This website, FRBO.com does accommodate special beachfront and romantic farmhouse and cabins.
Townies and pirates poke into and go through this extensive website, FRBO.com and detect resort ranch, lake vacation home, city townhouse, and well appointed duplex.
Catch and explore rent houses Lake Hamilton United States and short term rentals Lake Hamilton.
Debunk, find, and uncover Gonzalez short term rentals, Gonzalez United States rental home, and real estate rentals in Gonzalez United States.
Frostproof Florida is a graceful, radiant, and well-formed township with charming and excellent vacation home, vacation home, flat, and houses.
Come across, look up, and relocate real estate rentals Wabasso, Wabasso United States rent houses, and real estate rentals in Wabasso United States.
Speculators and traveling women who are wishing to catch, debunk, and identify or simply elicit information can use For Rent By Owner.
Identify and come across condo rentals and homes for rent by owner in Sorrento United States.
Discern, contrive, and find vacation rental in Osceola Florida, vacation homes for rent by owner in Osceola Florida, homes for rent, and Osceola Florida vacation homes for rent by owner.
Espy and locate Clay Florida condo rentals, Clay vacation rental, rental apartment, and Clay Florida house rentals.
Recognize, hear, and detect Hernando Florida rental home, Hernando Florida bed and breakfast rentals, Hernando Florida for rent by owner homes, and Hernando Florida vacation rental.
Join our spacious online MLS, private listed properties, city classified ads, and city classifieds mailing list for rental apartment Frostproof Florida and Frostproof condo rentals.
Inaugurate your scrutiny online on Thursday, tonight, tonight, or in the morning for your Frostproof Florida vacation rental and home rentals in Frostproof Florida.
|
|
