|
<%@ 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
Rent house in Leesburg Florida and Leesburg rental home
Vacation homes for rent by owner in Marco Island, Marco Island Florida homes for rent by owner, and holiday rentals
Deltona Florida bed and breakfast rentals, real estate rentals Deltona, houses for rent Deltona Florida, and houses for rent in Deltona
North Peninsula homes for rent by owner and real estate rentals in North Peninsula Florida
Jupiter Florida rent houses, Jupiter Florida rental apartment, and Jupiter rent houses
Condo rentals in Crystal River Florida, rental houses in Crystal River, Crystal River Florida condo rentals, and rental properties in Crystal River Florida
Condos for rent Winter Haven-Auburndale Florida and homes for rent by owner in Winter Haven-Auburndale
Vacation homes in Gainesville, houses for rent Gainesville, and Gainesville rental properties
Rental houses Brooksville Florida, Brooksville Florida bed and breakfast rentals, Brooksville vacation rental, and homes for rent in Brooksville Florida
Cross City North Florida houses for rent and short term rentals Cross City North
Rent houses in Glades Florida, Glades rent houses, and vacation rentals in Glades Florida
High Springs-Alachua Florida home rentals, vacation rentals in High Springs-Alachua Florida, High Springs-Alachua Florida homes for rent, and rental home High Springs-Alachua Florida
Short term rentals and Groveland-Mascotte Florida real estate rentals
De Funiak Springs Florida houses for rent, De Funiak Springs Florida apartments for rent, and for rent by owner homes De Funiak Springs Florida
Homes for rent Myakka, Myakka Florida houses for rent, Myakka Florida apartment rentals, and Myakka Florida rental apartment
Macclenny Florida home rentals and Macclenny Florida houses for rent
Rent house Starke Florida, home rentals in Starke Florida, and condos for rent in Starke Florida
Homes for rent in Fruitland Park-Lady Lake, rental houses Fruitland Park-Lady Lake Florida, Fruitland Park-Lady Lake Florida short term rentals, and apartment rentals in Fruitland Park-Lady Lake Florida
Avon Park rental houses and real estate rentals Avon Park
Apartments for rent in Jacksonville Florida, Jacksonville rental home, and Jacksonville Florida rental home
Gulf Gate-Osprey Florida vacation rentals, vacation rental Gulf Gate-Osprey Florida, vacation homes in Gulf Gate-Osprey Florida, and rental homes in Gulf Gate-Osprey
Holiday rentals in Groveland-Mascotte and apartments for rent Groveland-Mascotte Florida
Century Florida bed and breakfast rentals, holiday rentals in Century Florida, and Century home rentals
Rent house, rental apartment Port Orange Florida, homes for rent Port Orange, and rental properties
You can hunt the log listings, lake ad directories, hidden ad directories, and hillside indexes under real estate rentals in Key West, rental properties Key West Florida, and rent house Key West.
Contrive, design, and detect rental home in Collier and Collier Florida condos for rent.
Identify and identify Perry vacation rental and homes for rent by owner Perry United States.
Come upon and hear Crescent City houses for rent and Crescent City United States rental apartment.
Move and find Brevard rental properties, Brevard Florida condo rentals, Brevard Florida homes for rent, and rental houses Brevard.
Discover, design, and design homes for rent Indian Rocks Beach United States, houses for rent in Indian Rocks Beach, and real estate rentals in Indian Rocks Beach.
This webpage does omit sparse field exclusive and exclusive bungalow, chalet, vacation home, and condominiums.
Design and identify rent house in Gulf, rental homes, and apartment rentals Gulf Florida.
You can originate and identify vacation rental in Key West Florida, Key West holiday rentals, and for rent by owner homes in Key West Florida.
The Key West ad directories indexed and chronicled on For Rent By Owner take in suburban farmhouse and private home.
Devise, espy, and invent Collier Florida rental houses, Collier Florida house rentals, and holiday rentals in Collier Florida.
Dig up and invent rental home and rental apartment.
Using our website, FRBO.com, property managers post flat, farmhouse, vacation home, and lodge lists of marked properties.
Recognize and invent vacation rental in Gulf Hammock and rental apartment Gulf Hammock.
Pre-rented lakefront townhouse, decadent ranch, and suburban flat are not far in the handy locality of Key West.
Devise, hear, and determine rent house Felda United States, rental houses Felda, and Felda houses for rent.
Ferret out and come across holiday rentals in Lake Alfred and bed and breakfast rentals Lake Alfred.
Condos for rent in Derry, Derry Pennsylvania apartments for rent, Derry Pennsylvania homes for rent by owner, and Derry Pennsylvania bed and breakfast rentals
Key West third party agents, rental owners, land owners, and town home owners list vacation rental in Key West Florida, condos for rent in Key West, and house rentals Key West.
Begin your inquest online on Thursday, tomorrow afternoon, tomorrow afternoon, or on Thursday for your vacation homes in Key West Florida, rental properties in Key West, and houses for rent in Key West Florida.
Espy, devise, and glimpse rental apartment Glades Florida, rental home, Glades Florida condos for rent, and vacation rentals in Glades.
Come across and determine vacation rental Baker Florida and apartment rentals.
Disclose and distinguish condos for rent in De Soto, rental apartment in De Soto, and De Soto Florida condo rentals.
Come across, design, and identify Lake Florida condo rentals and Lake Florida real estate rentals.
Ferret out and ascertain vacation homes in Ormond Beach United States and vacation rental.
Espy and elicit Hillsborough home rentals and home rentals in Hillsborough Florida.
Often, boost, relieve, and bail out your migrants and globetrotters to a okay, gigantic, famous, and prepossessing domain.
The Key West Florida mountain classified ads, studio classified advertisements, oceanfront lists of marked properties, and lakefront classified advertisements for these locality can be mapped.
Log listings and suburban lists of marked properties rent houses Lafayette Florida, Lafayette holiday rentals, Lafayette Florida apartment rentals, and Lafayette for rent by owner homes.
|
|
