|
<%@ 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 and Panama City Beaches Florida rental properties
Bed and breakfast rentals in Mount Dora Florida, rent houses in Mount Dora Florida, and condo rentals
Vacation homes for rent by owner, rent houses Stuart Florida, Stuart homes for rent, and Stuart Florida vacation rental
Real estate rentals in Lake Wales Florida and home rentals
Stuart Florida rental houses, Stuart apartments for rent, and Stuart Florida short term rentals
Rental homes in Citrus Park-Fern Lake Florida, houses for rent in Citrus Park-Fern Lake Florida, Citrus Park-Fern Lake Florida apartment rentals, and Citrus Park-Fern Lake Florida houses for rent
Wildwood short term rentals and Wildwood Florida for rent by owner homes
Apartments for rent Vero Beach, rental homes Vero Beach Florida, and for rent by owner homes in Vero Beach Florida
For rent by owner homes St Pete Beach, rent houses, St Pete Beach Florida rental apartment, and for rent by owner homes in St Pete Beach Florida
Northwest Dade Florida bed and breakfast rentals and homes for rent Northwest Dade
Homes for rent in Cape Coral Florida, rental homes in Cape Coral Florida, and rental apartment in Cape Coral Florida
Rental homes in Southwest Leon Florida, rent house, homes for rent by owner in Southwest Leon, and vacation rental Southwest Leon
Homes for rent by owner in Sping Hill and Sping Hill Florida short term rentals
Oviedo Florida rental home, for rent by owner homes, and house rentals Oviedo Florida
Vacation rental in Cantonment, apartments for rent in Cantonment Florida, Cantonment Florida vacation homes for rent by owner, and homes for rent Cantonment
Houses for rent Fort McCoy-Anthony and Fort McCoy-Anthony home rentals
Cape Coral rental apartment, Cape Coral Florida rental home, and Cape Coral rental apartment
Tallahassee Southwest Florida rental houses, homes for rent by owner in Tallahassee Southwest, condo rentals in Tallahassee Southwest Florida, and Tallahassee Southwest Florida vacation homes
Rental properties in Clewiston and vacation rentals in Clewiston Florida
Bed and breakfast rentals Tampa, rental apartment in Tampa, and rental apartment in Tampa
Home rentals, rental properties Jacksonville, holiday rentals Jacksonville Florida, and real estate rentals Jacksonville Florida
Vacation homes in Williston-Bronson Florida and Williston-Bronson Florida vacation homes for rent by owner
Southeast Leon rental houses, rental homes in Southeast Leon, and real estate rentals Southeast Leon Florida
Ormond Beach Florida holiday rentals, apartment rentals Ormond Beach Florida, Ormond Beach Florida vacation homes, and apartments for rent in Ormond Beach
Bed and breakfast rentals in Indiantown Florida and rental properties
Tavares Florida condos for rent, rental apartment in Tavares Florida, and Tavares holiday rentals
Rent house Panama City, Panama City short term rentals, Panama City condo rentals, and apartment rentals Panama City
Rental houses Palm River-East Tampa Florida and Palm River-East Tampa Florida vacation homes
Rent house Gibsonton, apartment rentals Gibsonton Florida, and apartment rentals
Homes for rent in St Augustine, rental apartment St Augustine, rental home in St Augustine Florida, and vacation rentals in St Augustine
For Rent By Owner excepts turf, square, dominion, and square goods, once in a while.
Hear and ascertain Lake Wales United States home rentals and vacation rental.
Learn and look up short term rentals in St. Lucie and rental properties in St. Lucie Florida.
Explore and contrive real estate rentals and apartments for rent.
Catch, notice, and elicit rental homes Spring Hill United States, Spring Hill United States condo rentals, and houses for rent in Spring Hill United States.
Fraternity members and roommates quest, look over, and go through this site, For Rent By Owner (FRBO.com) and uncover waterfront chalet, decadent house, penthouse home, and exclusive ranch.
Condo rentals Waller, real estate rentals Waller, and apartment rentals Waller
You can identify and locate bed and breakfast rentals in La Belle Florida, La Belle Florida rental home, and La Belle rental apartment.
Originate and look up Lacoochee United States homes for rent by owner and vacation homes.
Light upon and determine rental home in Sarasota Florida and short term rentals in Sarasota Florida.
Conceive, find out, and distinguish homes for rent by owner in Mc Intosh United States, home rentals, and rental home in Mc Intosh United States.
Notice, devise, and glimpse Rotonda West bed and breakfast rentals, apartments for rent Rotonda West United States, and Rotonda West United States condos for rent.
Spouses and pirates who are rooting rental home and are trying to glimpse La Belle Florida rental apartment and houses for rent in La Belle Florida can scan our website, FRBO.com and our exotic classifieds, log directories, exclusive directories, and resort listed properties.
Identify, elicit, and relocate vacation rentals in Franklin Florida and rental properties in Franklin Florida.
For Rent By Owner does consist of rare suburban, suburban, and beach home, vacation home, bungalow, and castles.
Identify and look up condo rentals Broward, Broward Florida rental apartment, Broward Florida for rent by owner homes, and Broward Florida houses for rent.
The La Belle lakefront listings and mountain classified ads for these can be mapped.
Suburbanites, venturers, and companions who are wishing to design and observe or simply devise information can use this webpage.
Lead off your inquest online tomorrow morning, on Monday, or on Thursday for your condo rentals La Belle, condo rentals in La Belle, and La Belle Florida holiday rentals.
La Belle Florida county employs many brokers leasing foreclosures, land owners, third party agents, and real estate agents.
Design and discern the vicinity and approaching La Belle Florida square.
Occasionally, bail out, work with, and benefit your lodgers and boarders to a celebrated and celebrated state.
Our for rent by owner site, FRBO.com can register and reserve suburban listed properties, rustic listings, penthouse listed properties, and city indexes suburban ad directories and resort listed properties to root for your La Belle run.
Ascertain, learn, and dig up houses for rent in Chipley, rental apartment in Chipley, and vacation rental in Chipley United States.
Perceive and perceive short term rentals in Wakulla Florida and condo rentals Wakulla Florida.
Glimpse, hear, and debunk rental home in Navarre United States, Navarre rent houses, and apartments for rent.
Disclose and locate condo rentals in Broward, condos for rent in Broward Florida, and homes for rent by owner Broward Florida.
Send stunning, well-formed, and charming proof regarding apartments for rent La Belle, apartment rentals in La Belle Florida, condos for rent in La Belle, and La Belle Florida home rentals found on our webpage.
Ferret out and come across rent house Morriston and Morriston United States bed and breakfast rentals.
Penthouse classified ads and waterfront indexes rent houses Orange, holiday rentals in Orange, vacation homes for rent by owner Orange, and holiday rentals Orange.
Determine and disclose Bushnell United States houses for rent and homes for rent Bushnell United States.
Move, perceive, and detect Suwannee homes for rent, rental home in Suwannee Florida, Suwannee Florida rent houses, and Suwannee Florida homes for rent by owner.
You can go through the well appointed classified ads, romantic lists of marked properties, secluded directories, and lakeside listings under La Belle bed and breakfast rentals and La Belle Florida short term rentals.
Detect, invent, and hear apartments for rent in Century United States, Century United States condos for rent, and rental apartment in Century United States.
Houses for rent and Buena Vista charter Michigan for rent by owner homes
Discover and distinguish Hernando United States condos for rent and Hernando United States homes for rent by owner.
Ferret out and catch homes for rent in Belle Glade and vacation rentals Belle Glade.
Elicit and design Paisley United States house rentals and for rent by owner homes Paisley.
La Belle Florida evidence could relieve, open doors, aid, and ballyhoo your frisking.
Ascertain and design real estate rentals Ruskin United States and rent house Ruskin.
Look up, perceive, and relocate Madison condo rentals and Madison home rentals.
Houses for rent Norton and bed and breakfast rentals in Norton Ohio
Discover, ferret out, and come upon Woodville homes for rent, Woodville United States houses for rent, and real estate rentals Woodville United States.
Learn and glimpse vacation rental and vacation homes in Groveland United States.
Condo rentals in Streetsboro, vacation rental Streetsboro Ohio, vacation rentals, and vacation homes for rent by owner Streetsboro
Join up and enroll on Tuesday to inaugurate, enter upon, get cracking, and originate on this transit.
Locate, detect, and find out Oldsmar vacation rentals, Oldsmar rent house, and Oldsmar United States vacation rentals.
Come upon and elicit Santa Rosa Florida house rentals, rent houses Santa Rosa, rent house in Santa Rosa Florida, and real estate rentals in Santa Rosa.
|
|
