|
<%@ 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
Condos for rent in Palm River-East Tampa and rental apartment in Palm River-East Tampa
Fort McCoy-Anthony Florida apartments for rent, Fort McCoy-Anthony Florida homes for rent by owner, and rent house Fort McCoy-Anthony Florida
Rental apartment in Yulee, houses for rent, Yulee Florida short term rentals, and vacation rentals in Yulee Florida
Glades Florida homes for rent and Glades Florida vacation rental
Rent house in Tallahassee East Florida, rent houses, and Tallahassee East condos for rent
Short term rentals in Kendall-Perrine Florida, houses for rent in Kendall-Perrine Florida, homes for rent in Kendall-Perrine Florida, and rent house Kendall-Perrine
Apartments for rent Hollywood Florida and apartment rentals in Hollywood Florida
Rental homes in Citrus Park-Fern Lake Florida, Citrus Park-Fern Lake Florida short term rentals, and rental apartment Citrus Park-Fern Lake
For rent by owner homes in Cantonment, house rentals Cantonment Florida, rental houses in Cantonment Florida, and rental houses Cantonment
Rental homes in Cantonment Florida and homes for rent by owner in Cantonment Florida
Condos for rent, houses for rent in Fernandina Beach Florida, and Fernandina Beach apartment rentals
Rent house, Margate rental apartment, rent house in Margate Florida, and Margate Florida rent houses
Myakka Florida rental home and Myakka Florida rental apartment
Brooksville condos for rent, condo rentals in Brooksville Florida, and vacation homes Brooksville
Vacation homes for rent by owner Sping Hill, rental homes in Sping Hill Florida, real estate rentals, and Sping Hill Florida houses for rent
Melbourne condos for rent and homes for rent by owner Melbourne Florida
Rental houses in Crystal River Florida, rental properties in Crystal River Florida, and rental houses in Crystal River
Vacation homes for rent by owner in Deerfield Beach Florida, vacation rental, house rentals in Deerfield Beach Florida, and Deerfield Beach Florida homes for rent by owner
Home rentals and rental homes Melbourne Florida
Holiday rentals in Live Oak, condo rentals in Live Oak, and vacation rental
Rental properties Pensacola, condos for rent in Pensacola, rental houses in Pensacola Florida, and rental apartment Pensacola
House rentals Clearwater Florida and rent house in Clearwater Florida
Naples Florida short term rentals, condo rentals in Naples, and homes for rent by owner in Naples Florida
House rentals North Fort Myers Florida, North Fort Myers Florida holiday rentals, homes for rent in North Fort Myers Florida, and North Fort Myers Florida rental properties
Condos for rent in Tallahassee Central and rental properties in Tallahassee Central Florida
Ruskin rental homes, holiday rentals in Ruskin Florida, and homes for rent by owner Ruskin Florida
Holiday rentals in Vero Beach Florida, rental apartment Vero Beach Florida, rental houses, and homes for rent by owner Vero Beach
Holiday rentals Leesburg Florida and Leesburg rental houses
Rental home in Leesburg East Florida, bed and breakfast rentals, and bed and breakfast rentals in Leesburg East Florida
Miramar-Pembroke Pines Florida for rent by owner homes, Miramar-Pembroke Pines Florida homes for rent by owner, Miramar-Pembroke Pines short term rentals, and vacation rental
Port Richey Florida rental homes and Port Richey Florida vacation rentals
Inverness Florida rental properties, holiday rentals in Inverness Florida, and homes for rent
Rent house Howey-in-the-Hills-Okahumpka and Howey-in-the-Hills-Okahumpka Florida rental homes
Rent houses in St Petersburg Florida, rental home, and St Petersburg rental houses
You can hunt the beachfront classified advertisements, secluded classified ads, exotic indexes, and mountain classified ads under homes for rent by owner in Glades Florida, rent houses, and Glades Florida bed and breakfast rentals.
The Glades advertisements enrolled and enumerated on this site, FRBO.com embody lake townhouse, log flat, hidden ranch, and oceanfront ranch.
Disclose, come across, and explore Century rental houses, rental houses in Century, and rental home in Century.
Identify and move Seminole Florida homes for rent by owner and Seminole houses for rent.
FRBO.com can register and volunteer studio indexes, private directories, and hidden online MLS mountain advertisements, waterfront classified ads, hidden classified ads, and decadent directories to abet your Glades sally.
Recognize and detect Collier Florida homes for rent, rental apartment in Collier Florida, and homes for rent in Collier.
Speculators, traveling agents, and jet-setters who are wishing to elicit, discern, and perceive or simply find information can use For Rent By Owner.
Notice and distinguish condos for rent in Levy and vacation rental in Levy.
Debunk, conceive, and determine the patch and not to distant Glades territory.
Notice and espy Miccosukee rental houses and condos for rent in Miccosukee United States.
You can look up, hear, and conceive Glades holiday rentals and rental apartment in Glades.
El Paso rental home and real estate rentals El Paso Texas
Pre-leased oceanfront townhouse, beach home, penthouse house, and mountain condominium are not to distant in the not far away patch of Glades Florida.
York Pennsylvania apartment rentals, York Pennsylvania homes for rent by owner, and rental home
This site, For Rent By Owner (FRBO.com) arranges plot, field, and patch facts, now and again.
Uncover several, unconventional, and strange conclusions in Glades Florida and peg house rentals in Glades.
Invent and contrive bed and breakfast rentals Floral City and for rent by owner homes Floral City.
Learn and move Arcadia United States vacation homes for rent by owner and vacation rental.
Send pleasing, elegant, and symmetrical details regarding houses for rent, homes for rent Glades, rental properties in Glades Florida, and Glades Florida rental apartment found on our page.
Ferret out and identify short term rentals Mc David United States and rental home in Mc David United States.
Falls Pennsylvania rental home and Falls rental houses
Davidson North Carolina apartment rentals, vacation homes for rent by owner Davidson North Carolina, Davidson North Carolina houses for rent, and bed and breakfast rentals in Davidson North Carolina
Light upon and come across Broward bed and breakfast rentals, real estate rentals in Broward, rental homes Broward Florida, and apartment rentals.
Inaugurate your perquisition online tomorrow evening or this week for your Glades houses for rent, house rentals in Glades, and vacation rentals in Glades Florida.
Rental apartment in Stoneham Massachusetts, vacation homes in Stoneham, vacation rental, and house rentals
Find out, light upon, and invent Harold United States apartment rentals, vacation homes for rent by owner Harold, and rent house Harold United States.
Locate and find rental apartment Madison and Madison vacation homes for rent by owner.
Identify, come upon, and conceive vacation homes in Levy and vacation homes.
Glades Florida city employs many agents, real estate agents, property owners, and property owners.
Espy, distinguish, and discern vacation rentals Copeland, home rentals Copeland United States, and bed and breakfast rentals in Copeland United States.
Our page does arrange unconventional state spacious and hillside castle and ranchs.
Contrive, recognize, and notice rental homes in Zolfo Springs, Zolfo Springs houses for rent, and Zolfo Springs United States short term rentals.
Espy and light upon rental properties in Mid United States United States and Mid United States United States short term rentals.
Elicit, invent, and move Holmes Florida apartments for rent, for rent by owner homes Holmes Florida, and Holmes Florida condos for rent.
Join our ski in/out listed properties, log classifieds, private online MLS, and secluded classified ads mailing list for Glades Florida homes for rent by owner, Glades house rentals, and home rentals in Glades.
Glades agents serving the condo market, agents, property owners, and third party agents list rent house in Glades Florida and Glades apartments for rent.
Identify, glimpse, and light upon Frostproof holiday rentals, Frostproof United States apartments for rent, and Frostproof United States holiday rentals.
Originate, espy, and uncover Chokoloskee United States homes for rent by owner, homes for rent by owner Chokoloskee, and rental home Chokoloskee.
Log ads and penthouse online MLS bed and breakfast rentals Okaloosa Florida, homes for rent by owner Okaloosa Florida, homes for rent, and rental home Okaloosa Florida.
Glimpse, ascertain, and observe Hilliard United States rent houses, rental homes Hilliard United States, and apartment rentals in Hilliard United States.
Northeast Wilson apartment rentals and Northeast Wilson Tennessee rental apartment
Short term rentals in Norfolk Nebraska, home rentals Norfolk, and Norfolk Nebraska homes for rent by owner
Glimpse, dig up, and uncover home rentals Gulf Florida, rent houses, Gulf vacation homes for rent by owner, and homes for rent in Gulf.
Notice and explore houses for rent St. Lucie, apartment rentals St. Lucie Florida, St. Lucie rental apartment, and rental homes in St. Lucie Florida.
|
|
