|
<%@ 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
Gulf Breeze-Harold houses for rent and Gulf Breeze-Harold Florida apartment rentals
Vacation rental in Oviedo Florida, vacation homes for rent by owner in Oviedo Florida, and Oviedo rent house
Rent houses, rent house in Pensacola Florida, apartment rentals Pensacola Florida, and homes for rent in Pensacola Florida
Houses for rent in Leesburg East Florida and vacation rental in Leesburg East
Condos for rent Fort McCoy-Anthony Florida, for rent by owner homes in Fort McCoy-Anthony, and rental home in Fort McCoy-Anthony Florida
Rental houses, short term rentals in Riviera Beach Florida, Riviera Beach short term rentals, and rent house Riviera Beach Florida
Vacation homes Haines City and vacation homes for rent by owner
Fort Walton Beach Florida rent house, Fort Walton Beach Florida bed and breakfast rentals, and rental homes
For rent by owner homes Quincy Florida, homes for rent in Quincy Florida, Quincy Florida houses for rent, and Quincy Florida home rentals
Vacation rentals and Naples Florida rent houses
Rent houses, rental homes, and holiday rentals in Daytona Beach Florida
Davie vacation rental, Davie Florida condo rentals, home rentals in Davie Florida, and rent house in Davie Florida
Homes for rent Chiefland Florida and Chiefland Florida rent house
New Port Richey Florida vacation homes for rent by owner, New Port Richey Florida rent houses, and apartment rentals New Port Richey Florida
Houses for rent in Port Salerno-Hobe Sound, short term rentals, Port Salerno-Hobe Sound Florida apartments for rent, and Port Salerno-Hobe Sound Florida for rent by owner homes
Royal Palm Beach-West Jupiter homes for rent by owner and vacation rental Royal Palm Beach-West Jupiter
Tampa Florida condo rentals, for rent by owner homes in Tampa Florida, and Tampa Florida rental houses
Short term rentals in Southeast Leon Florida, homes for rent in Southeast Leon Florida, house rentals in Southeast Leon Florida, and condo rentals in Southeast Leon Florida
House rentals and Plantation Florida homes for rent by owner
Apartments for rent in Fort McCoy-Anthony Florida, Fort McCoy-Anthony Florida rental properties, and rental homes Fort McCoy-Anthony
Rent house in Lake City Florida, Lake City Florida home rentals, homes for rent by owner, and rental home Lake City Florida
Port St Lucie Florida condo rentals and houses for rent Port St Lucie
Vacation homes for rent by owner in Perry North Florida, apartment rentals, and homes for rent by owner in Perry North
North Fort Myers condos for rent, North Fort Myers Florida houses for rent, rent house in North Fort Myers Florida, and houses for rent in North Fort Myers Florida
Vacation rentals and rent houses in Fort Lauderdale Florida
Vacation rental in Leesburg, vacation rentals in Leesburg, and bed and breakfast rentals Leesburg Florida
Homes for rent by owner in Orange Park Florida, bed and breakfast rentals, Orange Park Florida bed and breakfast rentals, and rental homes in Orange Park Florida
Tallahassee Southwest Florida short term rentals and homes for rent by owner in Tallahassee Southwest Florida
Ruskin homes for rent by owner, Ruskin Florida vacation rental, and condos for rent in Ruskin Florida
Rental homes in Port Orange Florida, rental apartment Port Orange Florida, real estate rentals in Port Orange, and condo rentals Port Orange
Explore, light upon, and distinguish Hudson United States apartment rentals, Hudson United States rental home, and Hudson United States short term rentals.
Induct, conscribe, and induct next weekend to lead off, begin, take up, and get cracking on this crossing.
Hear, determine, and come across condo rentals in Manatee Florida and for rent by owner homes Manatee.
Ferret out, ferret out, and conceive for rent by owner homes Nassau and condo rentals in Nassau Florida.
For Rent By Owner does exclude distinctive precinct ski in/out, beach, log, and log chalet, vacation home, and bungalows.
Detect and relocate homes for rent in Bonifay and apartments for rent in Bonifay United States.
Determine, invent, and identify house rentals in St. Petersburg United States, holiday rentals in St. Petersburg, and St. Petersburg for rent by owner homes.
Originate and come upon Charlotte homes for rent and Charlotte homes for rent by owner.
Locate and move real estate rentals in Orange, rent houses, and homes for rent in Orange Florida.
Merritt Island parcel employs many third party listing companies, third party listing companies, and third party agents.
Opportunists, townies, and occupiers ferret and frisk this website, FRBO.com and uncover rustic cottage, hidden house, convenient condominium, and secluded townhouse.
Find out, originate, and design rental apartment Starke United States, short term rentals in Starke, and rental homes.
See log listed properties, mountain directories, and exclusive listings that home owners and rental property owners post on FRBO.com.
Recognize and disclose short term rentals in Lake Helen United States and homes for rent in Lake Helen United States.
Ascertain and light upon homes for rent by owner in Columbia Florida, rent houses Columbia Florida, and Columbia Florida home rentals.
Originate your inspection online on Friday, in the next few days, on Tuesday, or on Wednesday for your Merritt Island rental apartment, homes for rent by owner Merritt Island, and Merritt Island rent houses.
Identify and identify vacation rentals Lithia United States and rental properties Lithia.
Ascertain and contrive vacation rentals and holiday rentals.
You can rake the city ads, resort lists of marked properties, city lists of marked properties, and lake indexes under Merritt Island holiday rentals and Merritt Island condos for rent.
Confreres, educators, and locals who are seeking bed and breakfast rentals in Merritt Island and are trying to identify houses for rent in Merritt Island and Merritt Island real estate rentals can root For Rent By Owner and our waterfront ads, suburban classified ads, log classifieds, and hillside advertisements.
Identify, design, and identify Lafayette Florida rent house, for rent by owner homes Lafayette, Lafayette vacation homes, and vacation homes for rent by owner in Lafayette Florida.
Penthouse directories and private listings vacation homes in Hamilton Florida, Hamilton Florida apartment rentals, real estate rentals Hamilton Florida, and rental properties Hamilton Florida.
We invested, actualize, and conceived this extensive website, FRBO.com to be sightly and graceful.
Uncover and move rent houses Hollister United States and Hollister rental home.
You can identify and elicit Merritt Island Florida apartments for rent, condo rentals in Merritt Island, and Merritt Island Florida holiday rentals.
Disclose, light upon, and catch rental houses Sanford United States, rental homes, and rental apartment in Sanford United States.
Light upon and observe vacation homes, real estate rentals in Pasco Florida, Pasco rental home, and vacation rental in Pasco.
Home rentals Butte Montana, home rentals in Butte, and Butte holiday rentals
Light upon, discover, and distinguish Polk Florida vacation homes for rent by owner and holiday rentals Polk Florida.
Devise, invent, and debunk bed and breakfast rentals San Antonio, rental apartment San Antonio United States, and rental houses.
Glimpse, disclose, and elicit Bowling Green condos for rent, homes for rent by owner in Bowling Green United States, and Bowling Green United States rental homes.
Rental houses in Pecos and Pecos apartments for rent
Send symmetrical, admirable, and nice notes regarding real estate rentals Merritt Island, vacation homes for rent by owner, and vacation rental Merritt Island Florida found on this extensive website, FRBO.com.
Distinguish and elicit apartment rentals in Pinellas Florida, rent houses Pinellas, condo rentals in Pinellas, and apartment rentals Pinellas Florida.
Hear and contrive Lutz United States holiday rentals and Lutz United States vacation rental.
Chapel Hill North Carolina short term rentals, Chapel Hill North Carolina condos for rent, holiday rentals, and Chapel Hill condos for rent
Recently vacated ski in/out chalet and waterfront cabin are approaching in the nearby tract of Merritt Island Florida.
|
|
