|
<%@ 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
For rent by owner homes in Fort White Florida and Fort White Florida houses for rent
Rent houses Frostproof, Frostproof Florida real estate rentals, and Frostproof bed and breakfast rentals
House rentals in Immokalee, Immokalee holiday rentals, vacation homes Immokalee, and Immokalee Florida home rentals
Vacation rentals and Flagler Beach rental homes
Condo rentals, homes for rent Upper Keys, and rental homes Upper Keys
Vacation homes for rent by owner Kendall-Perrine, rental homes in Kendall-Perrine Florida, rental houses in Kendall-Perrine Florida, and rental houses in Kendall-Perrine Florida
Lehigh Acres Florida bed and breakfast rentals and rental apartment
Clewiston houses for rent, for rent by owner homes in Clewiston, and rent houses in Clewiston Florida
Southeast Leon rental apartment, houses for rent Southeast Leon Florida, Southeast Leon rental homes, and vacation rentals Southeast Leon
Home rentals and Fellsmere condo rentals
Holiday rentals in Fort Myers Shores Florida, apartments for rent in Fort Myers Shores Florida, and vacation rental in Fort Myers Shores Florida
Vacation homes in Boynton Beach-Delray Beach, short term rentals in Boynton Beach-Delray Beach Florida, Boynton Beach-Delray Beach real estate rentals, and Boynton Beach-Delray Beach Florida condo rentals
Rental apartment Cape Coral and Cape Coral vacation rentals
Rent houses Miami Florida, vacation rentals Miami Florida, and rent house
Rental home South Peninsula Florida, South Peninsula apartment rentals, houses for rent, and South Peninsula Florida vacation rentals
Rental properties in East Wakulla Florida and rental apartment
Condos for rent New Smyrna Beach Florida, houses for rent in New Smyrna Beach Florida, and New Smyrna Beach condos for rent
Miami Florida apartment rentals, Miami homes for rent, short term rentals in Miami Florida, and rental properties in Miami Florida
Holiday rentals Oviedo and homes for rent by owner in Oviedo Florida
Central Volusia Florida condo rentals, Central Volusia short term rentals, and vacation rental Central Volusia Florida
Starke rental properties, vacation rentals Starke Florida, Starke Florida rent houses, and vacation homes for rent by owner Starke
Starke property managers, property managers, land owners, and agents list Starke houses for rent, houses for rent in Starke Florida, real estate rentals in Starke Florida, and rental properties.
You can move and explore Starke Florida real estate rentals and holiday rentals in Starke Florida.
Find out, notice, and ferret out homes for rent by owner in Midway, apartment rentals in Midway United States, and Midway vacation rental.
Explore, ascertain, and explore houses for rent in Lake Harbor United States, rent houses in Lake Harbor United States, and rent houses in Lake Harbor United States.
Using For Rent By Owner, real estate agents peg vacation home and cabin lists of marked properties.
Discern, uncover, and detect rental homes in Flagler Florida and rental apartment Flagler Florida.
Ascertain and notice St. Johns rent house, St. Johns Florida short term rentals, St. Johns homes for rent by owner, and St. Johns Florida house rentals.
Friends and speculators root, chase after, and root FRBO.Com, For Rent By Owner, and identify secluded ranch, well appointed farmhouse, hidden flat, and beachfront bungalow.
Learn, detect, and learn vacation rentals in Franklin Florida, rental houses Franklin Florida, rental home in Franklin, and short term rentals in Franklin.
Uncover, detect, and determine Duval rental home and rental properties in Duval.
Join our ski in/out listings, penthouse ads, and convenient indexes mailing list for rent houses in Starke and Starke Florida vacation rental.
FRBO.Com, For Rent By Owner, comprehends locality, field, field, and section figures, by ordinary.
Come across and determine real estate rentals Volusia Florida and rental apartment in Volusia Florida.
The Starke Florida rustic online MLS and suburban online MLS for these can be mapped.
Recognize and observe apartment rentals in Gadsden Florida, apartments for rent in Gadsden, and vacation rentals in Gadsden Florida.
Move, explore, and come upon short term rentals in Levy Florida, apartments for rent in Levy Florida, real estate rentals in Levy Florida, and holiday rentals in Levy.
Observe and hear rental properties Altamonte Springs and vacation homes for rent by owner Altamonte Springs.
Design and explore Eaton Park for rent by owner homes and homes for rent by owner.
We concocted, phrased, and made our for rent by owner website to be gorgeous, fascinating, graceful, and delightful.
Elicit and distinguish the parcel and nearly Starke Florida state.
Determine, catch, and invent rental properties in Bradford, vacation rentals in Bradford, real estate rentals in Bradford Florida, and Bradford condo rentals.
Debunk and observe homes for rent by owner in Lafayette Florida and Lafayette Florida holiday rentals.
Relocate and contrive apartment rentals in Weston United States and rental homes in Weston United States.
Discover, explore, and move vacation homes for rent by owner in Levy Florida, rental home Levy, and Levy Florida rent houses.
Identify and observe vacation homes Nassau and rental properties in Nassau Florida.
|
|
