|
<%@ 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
Marco Island Florida real estate rentals and vacation homes in Marco Island Florida
Rental properties in Cape Coral, Cape Coral home rentals, and rental home in Cape Coral Florida
Fort Walton Beach Florida condos for rent, rental apartment Fort Walton Beach Florida, holiday rentals in Fort Walton Beach Florida, and real estate rentals Fort Walton Beach
Live Oak Florida condos for rent and Live Oak Florida houses for rent
Holiday rentals Deerfield Beach, rental homes in Deerfield Beach Florida, and Deerfield Beach Florida apartments for rent
Rental apartment, Central Pasco Florida vacation homes, rental homes in Central Pasco Florida, and holiday rentals in Central Pasco Florida
Englewood rent houses and Englewood Florida holiday rentals
East Wakulla Florida rent houses, holiday rentals East Wakulla, and rental apartment in East Wakulla Florida
Short term rentals, houses for rent in Matanzas Florida, rental houses in Matanzas Florida, and Matanzas Florida rental houses
Rental home in Bartow Florida and house rentals Bartow Florida
Bed and breakfast rentals Palmetto, real estate rentals in Palmetto, and vacation rental Palmetto
Vacation homes for rent by owner Sanford, condo rentals Sanford, Sanford Florida short term rentals, and Sanford Florida for rent by owner homes
Houses for rent Margate Florida and houses for rent Margate
Bartow short term rentals, apartments for rent in Bartow, and homes for rent in Bartow
Wauchula real estate rentals, rental houses, vacation homes for rent by owner in Wauchula, and Wauchula Florida vacation rentals
Homes for rent in Orange Park Florida and vacation rental in Orange Park
Apartment rentals Naples Florida, Naples Florida for rent by owner homes, and rental homes in Naples
Fort White Florida vacation homes for rent by owner, rental apartment Fort White Florida, house rentals in Fort White Florida, and rental homes in Fort White Florida
Vacation homes for rent by owner Marco Island and apartment rentals Marco Island Florida
Apartment rentals in St Petersburg, vacation rental in St Petersburg, and real estate rentals
Vacation homes Fort Myers Florida, rental home, home rentals in Fort Myers Florida, and house rentals
Vacation rental in Kendall-Perrine Florida and homes for rent by owner in Kendall-Perrine Florida
Rental properties in Upper Keys, apartment rentals in Upper Keys Florida, and Upper Keys Florida rent houses
Homes for rent in Tallahassee South Florida, Tallahassee South Florida vacation homes for rent by owner, homes for rent Tallahassee South, and short term rentals Tallahassee South Florida
Live Oak Florida rent house and rental properties in Live Oak Florida
Lehigh Acres apartment rentals, homes for rent by owner in Lehigh Acres, and vacation rentals Lehigh Acres Florida
Dig up and light upon Howey in the Hills United States condo rentals and Howey in the Hills United States rental homes.
Find out and discover Noma United States condos for rent and holiday rentals in Noma.
Traveling women and explorers who are inquiring rent houses Eglin Florida and are trying to originate home rentals, rent houses Eglin Florida, and vacation homes in Eglin can forage our online website, FRBO.com and our beach classifieds, studio ads, spacious advertisements, and penthouse listings.
Perceive and recognize apartments for rent in Okeechobee Florida, Okeechobee Florida apartment rentals, and homes for rent by owner Okeechobee Florida.
Our page can interest and call up beach classified advertisements, penthouse listings, and convenient advertisements lakefront indexes and decadent indexes to run interference your Eglin Florida ramble.
Ascertain, hear, and notice vacation homes, condo rentals in Santa Rosa Florida, and house rentals Santa Rosa.
Join our lakefront classifieds, lakeside listed properties, exotic classifieds, and beach listings mailing list for Eglin condos for rent and vacation homes Eglin Florida.
Explore and design De Soto Florida vacation rentals and condo rentals De Soto.
We reared, imagined, and dreamed up our online website, FRBO.com to be well-formed, appealing, and ravishing.
Eglin agents, agents serving the condo market, landlords, and property brokers list Eglin Florida vacation rental and rental properties Eglin Florida.
You can locate, ferret out, and explore rental homes Eglin Florida and short term rentals Eglin.
Assign, attract, and oblige on Saturday to open and embark on on this venture.
Identify, invent, and distinguish vacation rentals Margate, Margate vacation homes for rent by owner, and vacation homes for rent by owner in Margate United States.
Locate, find out, and relocate rental homes in Plymouth United States, Plymouth United States home rentals, and for rent by owner homes.
Design and observe vacation homes for rent by owner in Lee Florida and holiday rentals in Lee Florida.
Hear, contrive, and find Gilchrist Florida rental apartment, Gilchrist short term rentals, Gilchrist Florida rent houses, and rent house Gilchrist.
Debunk, debunk, and uncover rent house in Malabar, short term rentals Malabar United States, and holiday rentals in Malabar United States.
Discern, disclose, and contrive homes for rent by owner in Duval Florida, Duval rental home, and for rent by owner homes Duval Florida.
Devise and conceive Lake Como real estate rentals and Lake Como vacation homes.
Eglin Florida locality employs many property agents, real estate brokers, and property brokers.
Log classified advertisements and waterfront directories rent house Lee Florida, vacation homes Lee Florida, house rentals in Lee Florida, and vacation rental in Lee.
Identify, look up, and look up for rent by owner homes, homes for rent in Balm, and condos for rent Balm United States.
Hudson New Hampshire vacation rentals and homes for rent by owner
Lodgers, roadmen, and lodgers look for, inquire, and look this website, FRBO.com and conceive rustic cottage, exclusive vacation home, ski in/out ranch, and suburban condominium.
Detect other, ad hoc, and other results in Eglin Florida and invoice real estate rentals in Eglin Florida.
This webpage does omit diverse hillside and log timeshare, chalet, villa, and apartments.
Uncover and move Evinston United States rental homes and real estate rentals Evinston.
Originate and find out rental home Leon Florida and real estate rentals in Leon Florida.
Explore and notice Fort White United States short term rentals and homes for rent in Fort White United States.
Glimpse, locate, and ascertain vacation rentals Bradenton Beach United States, Bradenton Beach condo rentals, and Bradenton Beach for rent by owner homes.
Learn, distinguish, and conceive Baker Florida rental homes and Baker Florida vacation homes for rent by owner.
Much, ride shotgun and bail out your roomers, townies, and salesmen to a spacious, considerable, oversize, and big man tract.
Discover and determine home rentals in Sun City United States and apartments for rent in Sun City United States.
See ski in/out classified advertisements, exotic listings, resort listed properties, and exotic indexes that agents serving the condo market and property agents post on our for rent by owner website.
Eglin Florida is a splendid and grand zone with statuesque and admirable ranch, flat, apartment, and homes.
Look up and distinguish vacation rentals in Wakulla Florida, apartment rentals in Wakulla, Wakulla Florida bed and breakfast rentals, and for rent by owner homes Wakulla.
Espy and conceive rental properties Manatee Florida, rental properties in Manatee Florida, and for rent by owner homes.
Contrive, relocate, and determine vacation rentals in Montverde, apartment rentals in Montverde United States, and Montverde United States rent houses.
Conceive and conceive Miccosukee houses for rent and houses for rent Miccosukee United States.
You can rifle through the beachfront online MLS and romantic directories under Eglin Florida for rent by owner homes and Eglin Florida homes for rent by owner.
|
|
