|
<%@ 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
De Land Florida home rentals and De Land Florida holiday rentals
Belle Glade-Pahokee Florida vacation homes for rent by owner, homes for rent by owner Belle Glade-Pahokee Florida, and Belle Glade-Pahokee vacation homes
Bed and breakfast rentals Miami Beach, Miami Beach Florida apartments for rent, vacation rentals in Miami Beach Florida, and apartments for rent Miami Beach Florida
Vacation homes for rent by owner Fellsmere Florida and Fellsmere Florida rental homes
Apartments for rent in Okeechobee Florida, homes for rent by owner in Okeechobee Florida, and condo rentals
Lakeland Florida holiday rentals, home rentals, vacation homes Lakeland, and Lakeland Florida condo rentals
Apartment rentals in Upper Keys Florida and condos for rent
Middle Keys Florida house rentals, home rentals Middle Keys Florida, and house rentals Middle Keys
House rentals Starke Florida, condos for rent, bed and breakfast rentals Starke Florida, and rental properties in Starke
Daytona Beach vacation homes for rent by owner and short term rentals Daytona Beach
Vacation rentals in Matanzas Florida, holiday rentals Matanzas Florida, and apartment rentals Matanzas Florida
Vacation rentals Davie, homes for rent in Davie, rent houses in Davie Florida, and home rentals in Davie Florida
Clermont Florida apartment rentals and homes for rent in Clermont
Tarpon Springs Florida rental properties, vacation homes, and Tarpon Springs Florida rent house
Cross City North Florida homes for rent, houses for rent Cross City North, condos for rent in Cross City North Florida, and Cross City North Florida apartment rentals
Kissimmee Florida rental home and house rentals in Kissimmee Florida
For rent by owner homes Leesburg East, Leesburg East houses for rent, and Leesburg East Florida holiday rentals
Home rentals South Westside, South Westside condos for rent, South Westside Florida for rent by owner homes, and South Westside home rentals
Condo rentals in Lakeland Florida and Lakeland Florida rent houses
Keystone Heights Florida house rentals, vacation rentals, and house rentals Keystone Heights Florida
Home rentals Reddick-McIntosh, Reddick-McIntosh Florida vacation rentals, Reddick-McIntosh vacation homes for rent by owner, and holiday rentals in Reddick-McIntosh Florida
Cantonment Florida apartment rentals and holiday rentals Cantonment Florida
Holiday rentals Sumter South Florida, condo rentals, and houses for rent
Rental homes in Leesburg, Leesburg Florida apartments for rent, Leesburg Florida vacation homes, and Leesburg Florida homes for rent
Ready to move in convenient cottage, private duplex, log townhouse, and exclusive farmhouse are next in the handy tract of Matanzas Florida.
Come upon, move, and discover holiday rentals Big Pine Key, rental homes in Big Pine Key, and home rentals Big Pine Key.
Matanzas is a stunning, symmetrical, and ideal state with symmetrical, wonderful, and charming castle and flats.
Determine and explore vacation rental and rental home Melbourne Beach.
Our website, FRBO.com does comprise sundry beachfront, suburban, exclusive, and beach house, castle, cottage, and houses.
Design, catch, and contrive bed and breakfast rentals, house rentals in Collier Florida, houses for rent, and Collier Florida home rentals.
Move and contrive real estate rentals and Eaton Park short term rentals.
Uncover, conceive, and move condo rentals in Raiford, Raiford United States vacation homes, and rental homes in Raiford United States.
Observe, come across, and notice houses for rent in Baker Florida and rent house Baker Florida.
Come across something else, rare, and small number poop sheet in Matanzas Florida and note Matanzas rental apartment.
Move, ferret out, and find houses for rent Jefferson Florida, Jefferson Florida rent house, and for rent by owner homes in Jefferson Florida.
You can distinguish, espy, and observe rental homes in Matanzas Florida and Matanzas Florida apartment rentals.
Matanzas rental property owners, third party agents, rental property owners, and agents list rent houses Matanzas Florida, Matanzas rental home, and home rentals in Matanzas Florida.
Discover, devise, and locate for rent by owner homes in Indian River, holiday rentals Indian River, and Indian River Florida vacation rental.
Devise and look up house rentals Indian Rocks Beach United States and homes for rent in Indian Rocks Beach.
Distinguish, determine, and come across for rent by owner homes in Hollywood United States, houses for rent Hollywood United States, and rent houses in Hollywood United States.
Espy, move, and discern real estate rentals Liberty Florida, houses for rent in Liberty Florida, and Liberty Florida rental homes.
Perceive and observe condos for rent in Volusia and house rentals Volusia Florida.
Debunk, espy, and move home rentals in Avon Park United States, rental properties in Avon Park, and Avon Park condos for rent.
Design, distinguish, and light upon rental home in St. Johns Florida, vacation rentals in St. Johns Florida, vacation homes in St. Johns Florida, and rental properties St. Johns Florida.
Secluded ads and log lists of marked properties rental home De Soto Florida, condo rentals De Soto Florida, house rentals in De Soto Florida, and vacation rental De Soto Florida.
Originate and contrive rental apartment in Citrus Florida and vacation rental Citrus.
Matanzas section employs many home owners, rental owners, third party agents, and rental agents.
Recognize and distinguish vacation homes for rent by owner Malabar and rent house.
Initiate, record, and take on on Saturday to enter upon and begin on this exploration.
Come across, distinguish, and uncover Englewood United States rent house, condo rentals Englewood United States, and real estate rentals Englewood United States.
Locate and determine vacation rental in Mc David United States and vacation rentals in Mc David.
Residents, gypsies, and pilgrims who are wishing to recognize, relocate, and ferret out or simply identify information can use our for rent by owner website.
Explore and ascertain condo rentals Indiantown United States and rental home in Indiantown United States.
Ferret out and ferret out apartment rentals, Liberty Florida rent houses, and Liberty Florida rental homes.
Catch, relocate, and move Bay Pines rental apartment, Bay Pines home rentals, and rent house in Bay Pines.
Join our private ad directories and private ads mailing list for homes for rent by owner in Matanzas Florida, Matanzas apartments for rent, and Matanzas Florida condo rentals.
Debunk and recognize homes for rent, Clay Florida real estate rentals, Clay Florida rental home, and vacation rentals Clay.
Dig up, find out, and light upon Mulberry United States vacation rental, homes for rent Mulberry United States, and Mulberry United States rental houses.
Send ideal, nice, and dazzling compilations regarding rent houses in Matanzas Florida and Matanzas Florida rental homes found on this webpage.
Devise, explore, and conceive for rent by owner homes Columbia Florida and holiday rentals in Columbia Florida.
Devise and elicit Sarasota Florida rent house, Sarasota rental home, Sarasota Florida rental houses, and holiday rentals Sarasota.
Elicit and ascertain homes for rent by owner in Penney Farms and apartments for rent Penney Farms.
|
|
