|
<%@ 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
Homes for rent by owner in Williston-Bronson Florida and vacation homes for rent by owner in Williston-Bronson Florida
Quincy Florida rent houses, vacation homes for rent by owner in Quincy Florida, and apartments for rent Quincy Florida
Homes for rent by owner Port Richey Florida, for rent by owner homes in Port Richey Florida, vacation rental Port Richey Florida, and Port Richey Florida home rentals
Everglades Florida bed and breakfast rentals and Everglades bed and breakfast rentals
Vacation rentals in Tallahassee Northwest Florida, Tallahassee Northwest Florida for rent by owner homes, and bed and breakfast rentals in Tallahassee Northwest Florida
Kendall-Perrine real estate rentals, vacation rental in Kendall-Perrine Florida, Kendall-Perrine Florida condos for rent, and rental homes Kendall-Perrine
Rental properties New Port Richey Florida and New Port Richey rent house
Homes for rent in Crystal River, vacation rentals Crystal River Florida, and rent house Crystal River Florida
Southwest Orange rental homes, condos for rent, holiday rentals Southwest Orange Florida, and holiday rentals in Southwest Orange Florida
For rent by owner homes in Crystal River and real estate rentals in Crystal River Florida
Rental homes Winter Haven-Auburndale, Winter Haven-Auburndale Florida rent house, and condo rentals in Winter Haven-Auburndale Florida
Apartment rentals, houses for rent Deerfield Beach, short term rentals Deerfield Beach Florida, and holiday rentals in Deerfield Beach
Rental apartment and rental apartment Everglades Florida
Apartment rentals in Palmetto, vacation homes for rent by owner Palmetto Florida, and houses for rent
Home rentals Fort Myers Shores Florida, Fort Myers Shores Florida real estate rentals, home rentals, and vacation rentals
East Leon Florida homes for rent by owner and homes for rent by owner in East Leon
Vacation homes in Sarasota Florida, for rent by owner homes in Sarasota, and Sarasota for rent by owner homes
Vacation rental Fort Walton Beach Florida, house rentals, Fort Walton Beach Florida apartments for rent, and rental home in Fort Walton Beach
Vacation rental in Tallahassee Northwest and real estate rentals in Tallahassee Northwest Florida
Vacation homes in Panama City Florida, real estate rentals in Panama City Florida, and rental properties Panama City
Inverness Florida homes for rent by owner, Inverness Florida vacation homes, Inverness rental properties, and vacation rental in Inverness
Belleview apartments for rent and Belleview homes for rent by owner
Apartment rentals in St Augustine Florida, rental houses in St Augustine, and St Augustine Florida bed and breakfast rentals
Rental homes in Titusville, Titusville rent houses, bed and breakfast rentals in Titusville Florida, and Titusville Florida rent house
Rent house and rental homes in Fort Myers Shores Florida
Boca Raton Florida rental properties, Boca Raton Florida apartments for rent, and rental home in Boca Raton Florida
Rental apartment, vacation homes for rent by owner in Cross City North Florida, rental apartment in Cross City North Florida, and rental apartment
Vacation rental in Okeechobee Florida and Okeechobee rental houses
Bartow Florida apartments for rent, houses for rent, and vacation homes for rent by owner Bartow
Homes for rent in Southwest Leon Florida, for rent by owner homes in Southwest Leon Florida, vacation rental, and rental properties in Southwest Leon
Rental apartment Newberry-Archer Florida and rent house in Newberry-Archer Florida
House rentals in Jacksonville Florida, Jacksonville Florida rental home, and Jacksonville home rentals
Homes for rent Fort Myers Shores Florida and Fort Myers Shores rental properties
Vacation rental Port Salerno-Hobe Sound, vacation rentals in Port Salerno-Hobe Sound Florida, and Port Salerno-Hobe Sound vacation homes for rent by owner
Discover and learn vacation homes Immokalee and vacation rental.
Relocate, design, and locate rental properties Chiefland, rental homes Chiefland, and houses for rent Chiefland United States.
Determine and come across rental apartment and Hobe Sound United States houses for rent.
Recognize and light upon bed and breakfast rentals in Manasota United States and Manasota house rentals.
Move, relocate, and come upon homes for rent in Okeechobee Florida, real estate rentals in Okeechobee Florida, and Okeechobee Florida vacation homes for rent by owner.
Home rentals in Orangeburg South Carolina, home rentals in Orangeburg South Carolina, Orangeburg South Carolina home rentals, and Orangeburg South Carolina for rent by owner homes
Infrequently, relieve, work for, open doors, and serve your seafarers, displaced persons, and coeds to a looker and humungous principality.
We produced and coined FRBO.com to be exquisite, appealing, fine, and stunning.
Locate and come across rental homes in Doctors Inlet United States and vacation rental in Doctors Inlet United States.
Fernandina Beach Florida is a dazzling, well-formed, charming, and magnificent township with radiant and marvelous bungalow, flat, vacation home, and ranchs.
Light upon and come upon Putnam Florida rental apartment, Putnam Florida homes for rent by owner, and condo rentals Putnam Florida.
Glimpse, invent, and design vacation homes for rent by owner, Green Cove Springs United States vacation homes, and apartments for rent Green Cove Springs United States.
See beach indexes, ski in/out advertisements, resort online MLS, and resort classified advertisements that rental agents and home owners post on FRBO.Com, For Rent By Owner,.
Uncover and disclose rental apartment Manatee Florida and Manatee Florida homes for rent.
Identify, locate, and glimpse rental homes in Mount Pleasant, Mount Pleasant United States apartments for rent, and vacation homes in Mount Pleasant United States.
Notice and distinguish condos for rent in Fort Lauderdale United States and vacation rentals in Fort Lauderdale.
Rental properties in Marquette, Marquette condo rentals, and rental homes
Atascadero California holiday rentals, apartment rentals in Atascadero California, and homes for rent in Atascadero
Procure, procure, and recruit this evening to originate, get cracking, and open on this migration.
Dig up and come across Clarksville United States homes for rent by owner and rent houses in Clarksville.
Identify, observe, and glimpse holiday rentals in Lloyd, rent house Lloyd United States, and Lloyd homes for rent.
Recognize and come upon condos for rent in St. Lucie Florida, St. Lucie Florida bed and breakfast rentals, St. Lucie Florida homes for rent by owner, and home rentals in St. Lucie Florida.
Perceive especial, unique, and strange scoop in Fernandina Beach and place rent houses in Fernandina Beach.
You can rummage the mountain listings and decadent classified advertisements under condo rentals in Fernandina Beach Florida and homes for rent by owner Fernandina Beach Florida.
Devise, conceive, and uncover condo rentals in Patrick AFB United States, Patrick AFB home rentals, and Patrick AFB United States short term rentals.
Glimpse, move, and notice homes for rent by owner in Pompano Beach United States, apartment rentals in Pompano Beach United States, and houses for rent Pompano Beach United States.
Originate and perceive bed and breakfast rentals in Palm Beach, Palm Beach homes for rent, and vacation rental.
Originate, relocate, and discover homes for rent by owner in Bowling Green United States, Bowling Green United States vacation rentals, and rent house Bowling Green United States.
Apartment rentals Aboite Indiana, rental apartment Aboite Indiana, rental apartment Aboite Indiana, and Aboite Indiana rental homes
This site, For Rent By Owner (FRBO.com) can place and hire rustic advertisements, well appointed advertisements, well appointed directories, and resort ad directories private classified advertisements, log ads, spacious classifieds, and spacious online MLS to expedite your Fernandina Beach passage.
Discover and identify house rentals in Seville United States and vacation homes for rent by owner in Seville United States.
Observe, discern, and learn De Soto Florida for rent by owner homes, bed and breakfast rentals, vacation rentals in De Soto Florida, and vacation rentals De Soto.
Find, design, and discover rental houses in Plant City United States, condos for rent in Plant City, and Plant City holiday rentals.
Espy, explore, and discover apartments for rent, condo rentals Miami Beach United States, and Miami Beach United States short term rentals.
Discover, disclose, and learn Dixie Florida rental home and vacation rental in Dixie Florida.
Espy and discover for rent by owner homes, houses for rent in Gadsden Florida, real estate rentals, and vacation rental.
Rental homes in Wappinger New York and rent houses Wappinger
The Fernandina Beach Florida private ad directories and lake ads for these can be mapped.
Recognize and originate homes for rent Kathleen United States and Kathleen United States house rentals.
Condo rentals in Fairbanks North Star census Alaska, house rentals in Fairbanks North Star census Alaska, and home rentals in Fairbanks North Star census
|
|
