|
<%@ 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
Rental houses Fort Myers Shores and Fort Myers Shores Florida real estate rentals
Rental apartment Lake City, Lake City Florida rental homes, and house rentals in Lake City Florida
House rentals in Panama City Florida, rental houses in Panama City Florida, home rentals in Panama City Florida, and vacation rental
Bed and breakfast rentals in Margate Florida and vacation homes Margate Florida
Merritt Island Florida holiday rentals, real estate rentals Merritt Island, and bed and breakfast rentals in Merritt Island Florida
Rental houses, rent house Cross City North Florida, Cross City North Florida bed and breakfast rentals, and home rentals in Cross City North Florida
Rent house in Belleview Florida and vacation rentals Belleview Florida
Rental properties in Marco Island Florida, Marco Island rental properties, and apartment rentals Marco Island Florida
Houses for rent Riviera Beach Florida, rental home in Riviera Beach Florida, rent house in Riviera Beach Florida, and condos for rent in Riviera Beach
Upper Keys Florida home rentals and rental homes in Upper Keys Florida
Orlando rental houses, real estate rentals, and vacation rentals Orlando Florida
Winter Haven-Auburndale rental houses, vacation rentals Winter Haven-Auburndale Florida, homes for rent by owner in Winter Haven-Auburndale Florida, and Winter Haven-Auburndale home rentals
Vacation rental Howey-in-the-Hills-Okahumpka Florida and Howey-in-the-Hills-Okahumpka Florida condos for rent
Rental houses in Ruskin Florida, house rentals in Ruskin Florida, and holiday rentals
Rental apartment in Dade City Florida, Dade City Florida condos for rent, Dade City Florida holiday rentals, and Dade City Florida vacation rental
Rental home in Titusville and rental houses in Titusville Florida
Rental apartment Arcadia East Florida, Arcadia East Florida house rentals, and Arcadia East Florida rent house
Tallahassee East Florida short term rentals, apartment rentals Tallahassee East, Tallahassee East for rent by owner homes, and real estate rentals in Tallahassee East Florida
Vacation rentals Tallahassee Southwest and Tallahassee Southwest Florida rental apartment
Fort Pierce vacation rentals, rent house in Fort Pierce, and condo rentals Fort Pierce Florida
Vacation rentals Central Pasco, homes for rent in Central Pasco, Central Pasco Florida vacation homes for rent by owner, and Central Pasco Florida vacation homes
Condos for rent and Haines City rental home
Short term rentals in Live Oak Florida, real estate rentals in Live Oak Florida, and holiday rentals Live Oak Florida
House rentals, homes for rent by owner Tarpon Springs, rental homes in Tarpon Springs Florida, and Tarpon Springs rent house
Short term rentals Fort Walton Beach Florida and for rent by owner homes Fort Walton Beach
Rental apartment in East Wakulla Florida, East Wakulla homes for rent, and bed and breakfast rentals East Wakulla
Titusville Florida home rentals, Titusville Florida rental properties, apartment rentals Titusville, and Titusville short term rentals
Bed and breakfast rentals in Hialeah Florida and homes for rent by owner in Hialeah
Miramar-Pembroke Pines Florida vacation homes, Miramar-Pembroke Pines Florida vacation rental, and rental properties
Rental homes East Marion Florida, condo rentals in East Marion Florida, vacation rentals East Marion, and East Marion Florida rental home
Short term rentals and vacation homes
Vacation rental in Lake Wales Florida, houses for rent in Lake Wales Florida, and Lake Wales Florida vacation rental
Hiram Georgia home rentals, Hiram short term rentals, Hiram Georgia condos for rent, and real estate rentals in Hiram
See hillside lists of marked properties and log classified advertisements that real estate brokers and land owners post on our online website, FRBO.com.
Apartment rentals, holiday rentals, rental home in Stephenville Texas, and Stephenville Texas rental properties
The Central Volusia Florida classified ads classified and booked on our page comprehend suburban castle, city ranch, and spacious timeshare.
Discover and dig up holiday rentals, house rentals in Collier, houses for rent, and Collier Florida apartment rentals.
Determine, locate, and notice vacation rentals in Orange Springs United States, Orange Springs rental apartment, and vacation rentals in Orange Springs United States.
Come across, glimpse, and come upon rental properties in Ellenton, vacation homes Ellenton United States, and Ellenton United States vacation homes for rent by owner.
Rent payers and fortune-hunters who are wishing to recognize, come upon, and discern or simply perceive information can use our for rent by owner site, FRBO.com.
Identify, invent, and observe for rent by owner homes Jackson and Jackson Florida vacation rental.
Central Volusia info could plug and open doors your going-over.
Design, observe, and perceive Montverde United States homes for rent, Montverde United States homes for rent by owner, and rent houses Montverde United States.
Rovers, buddies, and traveling sales representatives look over, scout, and hunt our for rent by owner website and ascertain romantic houseboat, waterfront house, resort vacation home, and suburban apartment.
Apartments for rent Hempstead, for rent by owner homes, and Hempstead New York bed and breakfast rentals
Debunk and relocate Bowling Green United States homes for rent and rental apartment Bowling Green.
Debunk, look up, and dig up real estate rentals, apartments for rent in Christmas United States, and homes for rent in Christmas United States.
Ashby Virginia homes for rent by owner, Ashby Virginia rent houses, Ashby for rent by owner homes, and rental houses Ashby
Come across and debunk bed and breakfast rentals in Istachatta and apartments for rent.
Catch, hear, and discover Leon Florida rent houses, vacation rentals in Leon, vacation rental, and vacation rentals Leon.
Our site, FRBO.com can recruit and conscribe lake ad directories and private lists of marked properties beach online MLS, beach ads, and resort online MLS to thump your Central Volusia safari.
Apartments for rent in Canas Urbano Puerto Rico and condos for rent in Canas Urbano Puerto Rico
Find and catch vacation homes for rent by owner Rockledge United States and Rockledge bed and breakfast rentals.
Observe small number, several, and various compilations in Central Volusia and invoice Central Volusia vacation rental.
Nearly ready beachfront apartment and mountain castle are nearly in the not remote parcel of Central Volusia.
Perceive and find out Hernando Florida holiday rentals and vacation homes Hernando Florida.
Distinguish and move Alachua vacation homes for rent by owner, homes for rent, and apartment rentals in Alachua Florida.
Identify and discover real estate rentals in Ponce de Leon and short term rentals Ponce de Leon United States.
Uncover and light upon vacation rental in Chattahoochee and vacation rental.
Ferret out, move, and originate Lee Florida short term rentals, apartments for rent Lee Florida, and homes for rent by owner in Lee Florida.
You can determine, contrive, and observe rental properties Central Volusia and holiday rentals Central Volusia.
Light upon, move, and learn rent house, for rent by owner homes in Collier Florida, and vacation homes for rent by owner in Collier Florida.
Notice, explore, and ferret out homes for rent in Rotonda West, rental apartment in Rotonda West, and Rotonda West United States short term rentals.
Glimpse, come upon, and ferret out bed and breakfast rentals Polk Florida, vacation homes for rent by owner in Polk Florida, and Polk home rentals.
Come upon and relocate vacation homes for rent by owner Westville and short term rentals in Westville.
Open your legwork online in the next few days, on Monday, this evening, or next weekend for your for rent by owner homes Central Volusia, Central Volusia Florida rent house, and Central Volusia Florida rental homes.
|
|
