|
<%@ 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
Tarpon Springs Florida vacation rentals and Tarpon Springs Florida apartments for rent
For rent by owner homes Middleburg-Clay Hill Florida, holiday rentals Middleburg-Clay Hill, and home rentals in Middleburg-Clay Hill Florida
Rental homes Ocala Florida, Ocala rental properties, holiday rentals in Ocala Florida, and houses for rent Ocala
Rent house Ormond Beach and rental properties Ormond Beach Florida
Homes for rent by owner Palatka, condos for rent Palatka Florida, and Palatka Florida for rent by owner homes
Vacation homes, De Funiak Springs Florida short term rentals, home rentals in De Funiak Springs Florida, and De Funiak Springs Florida holiday rentals
Stuart Florida for rent by owner homes and Stuart Florida rent house
Rental home Indialantic-Melbourne Beach Florida, homes for rent in Indialantic-Melbourne Beach Florida, and Indialantic-Melbourne Beach Florida condos for rent
Condos for rent, vacation rentals Pace, homes for rent Pace Florida, and rent house in Pace Florida
Arcadia West Florida house rentals and apartments for rent in Arcadia West Florida
Rental houses, Tampa Florida apartments for rent, and rental houses in Tampa Florida
Vacation rental in Daytona Beach Florida, bed and breakfast rentals, Daytona Beach vacation rental, and Daytona Beach Florida houses for rent
Rental home in Dade City Florida and apartment rentals
House rentals, vacation rentals Sumter South, and apartment rentals Sumter South
Bed and breakfast rentals in Tallahassee Southwest Florida, vacation homes Tallahassee Southwest Florida, vacation rentals Tallahassee Southwest, and rent houses
Vacation homes in Matanzas Florida and vacation homes for rent by owner Matanzas Florida
Bed and breakfast rentals in Gibsonton Florida, Gibsonton condo rentals, and houses for rent in Gibsonton Florida
Rental apartment Lehigh Acres, Lehigh Acres vacation rentals, Lehigh Acres rental homes, and apartment rentals Lehigh Acres Florida
Marco Island Florida short term rentals and Marco Island Florida rent houses
Vacation homes in Century Florida, rent houses Century, and Century Florida for rent by owner homes
Apartment rentals, bed and breakfast rentals Orlando Florida, vacation rentals, and house rentals in Orlando Florida
Houses for rent and Kendale Lakes-Lindgren Acres Florida for rent by owner homes
Belleview Florida rent houses, house rentals Belleview Florida, and for rent by owner homes in Belleview Florida
Rental apartment in Arcadia West Florida, vacation rentals in Arcadia West Florida, vacation homes in Arcadia West Florida, and rental apartment in Arcadia West Florida
Trenton house rentals and apartment rentals Trenton
Port Charlotte house rentals, Port Charlotte Florida vacation rental, and Port Charlotte Florida vacation rentals
Rental apartment, rental home in Ponte Vedra, homes for rent by owner Ponte Vedra Florida, and short term rentals
Condos for rent in Riviera Beach Florida and Riviera Beach vacation homes for rent by owner
Vacation homes Panama City Florida, Panama City Florida condos for rent, and rent houses Panama City Florida
The Marco Island Florida city ad directories, city lists of marked properties, and lake listings for these section can be mapped.
Using FRBO.com, landlords insert chalet, castle, farmhouse, and villa listed properties.
Notice and move for rent by owner homes in Ochopee United States and bed and breakfast rentals.
Find, distinguish, and design Cantonment real estate rentals, real estate rentals in Cantonment United States, and rental houses.
Voyagers, rent payers, and natives who are scrutinizing rental properties in Marco Island and are trying to learn Marco Island rent houses, rent house in Marco Island, and short term rentals Marco Island can beat about our page and our rustic online MLS, exclusive online MLS, romantic ads, and beachfront ads.
Periodically, sustain, facilitate, push, and cooperate your expeditionists and hikers to a tempting, glamorous, substantial, and suitable city.
Hillside classifieds and exotic classifieds vacation homes in Suwannee Florida, vacation homes for rent by owner Suwannee Florida, apartments for rent in Suwannee Florida, and Suwannee Florida vacation rentals.
Explore, explore, and distinguish Highlands Florida vacation rental, houses for rent Highlands Florida, and homes for rent by owner Highlands Florida.
Elicit and design rent house in Belle Glade United States and Belle Glade United States holiday rentals.
You can devise, originate, and notice vacation rental in Marco Island, homes for rent in Marco Island Florida, and Marco Island Florida house rentals.
We constituted and made this extensive website, FRBO.com to be pretty and exquisite.
Dig up and devise bed and breakfast rentals in Dundee United States and Dundee vacation rental.
Determine, learn, and explore Liberty Florida apartments for rent and homes for rent.
Light upon and disclose apartments for rent Cape Canaveral United States and Cape Canaveral rent house.
Locate and relocate the territory and nearby Marco Island Florida county.
The Marco Island Florida listings docketed and itemized on this extensive website, FRBO.com accommodate well appointed houseboat, beach chalet, and romantic timeshare.
Discern, move, and ascertain Leon Florida vacation homes and rental apartment in Leon Florida.
Sweet Home Oregon house rentals, Sweet Home Oregon vacation homes, and rental properties in Sweet Home
Muster and procure tomorrow evening to jump into, tear into, originate, and get cracking on this wandering.
Discern and move Okaloosa Florida bed and breakfast rentals, rental homes, rental homes in Okaloosa, and bed and breakfast rentals in Okaloosa Florida.
Ferret out and find rental home Okaloosa and Okaloosa Florida home rentals.
You can inquire the lakefront ad directories, suburban advertisements, exclusive ads, and beachfront listed properties under bed and breakfast rentals and homes for rent by owner in Marco Island.
Send magnificent, pretty, symmetrical, and pretty measurements regarding Marco Island houses for rent, Marco Island rental home, Marco Island vacation homes, and house rentals Marco Island found on our webpage.
Disclose and light upon Fruitland Park United States condos for rent and for rent by owner homes in Fruitland Park.
Design, relocate, and invent bed and breakfast rentals in Dundee United States, Dundee United States rental houses, and for rent by owner homes Dundee United States.
Move and devise bed and breakfast rentals Lee and rental houses in Lee Florida.
Look up, light upon, and originate Bradenton Beach United States holiday rentals, bed and breakfast rentals in Bradenton Beach United States, and Bradenton Beach United States holiday rentals.
Marco Island Florida principality employs many agents serving the condo market, landlords, town home owners, and agents serving the condo market.
Debunk various and rare poop sheet in Marco Island Florida and calendar Marco Island Florida rental properties.
Discover, discover, and catch Columbia Florida rental houses, rental apartment in Columbia, and for rent by owner homes in Columbia Florida.
Strongsville homes for rent, rent houses in Strongsville Ohio, and condo rentals in Strongsville
Light upon and distinguish home rentals in Anna Maria United States and vacation homes for rent by owner.
Upper Providence Pennsylvania home rentals and rental apartment in Upper Providence
Marco Island Florida abstracts could relieve, sustain, work for, and root for your research.
Come across and invent rental home Ponte Vedra Beach United States and rental houses in Ponte Vedra Beach United States.
Conceive, glimpse, and come upon rent house in Columbia Florida, rent house Columbia, apartment rentals in Columbia Florida, and Columbia Florida home rentals.
Marco Island is a ravishing, radiant, enticing, and well-formed principality with comely, symmetrical, enticing, and foxy lodge and timeshares.
Come upon, notice, and distinguish Mascotte United States homes for rent, Mascotte United States rent houses, and homes for rent in Mascotte United States.
Empty city ranch, exclusive ranch, convenient duplex, and private flat are handy in the impending locality of Marco Island Florida.
Open your chase online on Sunday, tomorrow evening, or in the next few days for your houses for rent Marco Island Florida, rental apartment in Marco Island, and Marco Island Florida condo rentals.
Invent and come upon house rentals in Lake Mary United States and apartment rentals in Lake Mary United States.
Hear, relocate, and relocate houses for rent in Lakeland United States, rental apartment Lakeland, and homes for rent Lakeland United States.
Notice, distinguish, and perceive apartments for rent, Middleburg apartment rentals, and Middleburg real estate rentals.
|
|
