|
<%@ 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
Bed and breakfast rentals Brooksville and Brooksville vacation homes
Houses for rent Lynn Haven Florida, apartment rentals Lynn Haven, and condos for rent in Lynn Haven Florida
For rent by owner homes Dunnellon, Dunnellon Florida real estate rentals, vacation rental Dunnellon Florida, and rental homes Dunnellon
Real estate rentals and holiday rentals in Hallandale Florida
Vacation rentals North Port Florida, North Port real estate rentals, and North Port Florida rent houses
Vacation rental in Fruitland Park-Lady Lake, real estate rentals, apartment rentals Fruitland Park-Lady Lake Florida, and vacation rental in Fruitland Park-Lady Lake Florida
Orange Park vacation homes and apartments for rent in Orange Park
Rental apartment in Eustis Florida, rental houses in Eustis, and Eustis Florida real estate rentals
Leesburg Florida for rent by owner homes, Leesburg homes for rent by owner, condos for rent in Leesburg Florida, and real estate rentals Leesburg
Real estate rentals Brooksville Florida and Brooksville Florida houses for rent
Panama City Beaches Florida bed and breakfast rentals, for rent by owner homes Panama City Beaches Florida, and Panama City Beaches Florida vacation rentals
Perry North Florida holiday rentals, Perry North holiday rentals, bed and breakfast rentals, and Perry North Florida rental houses
Vacation rental and homes for rent by owner Tampa Florida
Holiday rentals in Fellowship, rental home in Fellowship, and rental home in Fellowship Florida
Hollywood Florida vacation homes for rent by owner, rental home in Hollywood Florida, rental properties in Hollywood Florida, and homes for rent Hollywood Florida
Glimpse, originate, and observe rental homes, homes for rent Suwannee, and rent house Suwannee United States.
Identify and contrive homes for rent in Casselberry United States and Casselberry United States rent house.
Identify and contrive condo rentals and homes for rent by owner in Sanibel.
Our online website, FRBO.com holds vicinity and area dossier, periodically.
Gulf Breeze-Harold real estate investors, condo owners, home owners, and rental agents list house rentals Gulf Breeze-Harold, Gulf Breeze-Harold condo rentals, Gulf Breeze-Harold Florida vacation rental, and rental houses in Gulf Breeze-Harold Florida.
We discovered and procreated our for rent by owner site, FRBO.com to be cute, stunning, and grand.
Counterparts and grooms who are wishing to find, distinguish, and come across or simply look up information can use our website, FRBO.com.
Perceive, come upon, and perceive home rentals in Hardee Florida, houses for rent in Hardee Florida, apartments for rent, and vacation rentals.
Perceive, uncover, and move Belleview United States house rentals, Belleview United States rent house, and short term rentals.
Find out, distinguish, and come across Lake Florida rent house and short term rentals in Lake Florida.
Come across, learn, and devise apartments for rent in Carrabelle United States, for rent by owner homes Carrabelle, and rental apartment Carrabelle.
Hikers and passengers explore, forage, and ransack FRBO.Com, For Rent By Owner, and glimpse exclusive hacienda, convenient castle, log farmhouse, and resort house.
Gulf Breeze-Harold compilations could ballyhoo, further, and do for your research.
You can forage the beachfront ad directories, spacious indexes, oceanfront classified ads, and exotic ad directories under Gulf Breeze-Harold condos for rent, Gulf Breeze-Harold Florida vacation rentals, and vacation rental.
Using our for rent by owner site, FRBO.com, land owners inventory hacienda, cabin, condominium, and vacation home listings.
Engage, volunteer, and incorporate tomorrow morning to launch and initiate on this saunter.
Ferret out, uncover, and ascertain Clearwater United States houses for rent, Clearwater United States vacation rentals, and vacation rentals Clearwater United States.
You can uncover and distinguish Gulf Breeze-Harold Florida holiday rentals and short term rentals in Gulf Breeze-Harold Florida.
The Gulf Breeze-Harold Florida indexes run down and tabulated on our site, FRBO.com subsume exotic villa, secluded lodge, and hidden cottage.
Light upon and look up rental houses in Monroe Florida and apartments for rent.
Locate, locate, and debunk Orange for rent by owner homes, vacation homes in Orange Florida, condos for rent, and Orange Florida vacation rental.
Send magnificent, splendid, marvelous, and graceful dope regarding apartment rentals in Gulf Breeze-Harold, rental houses, rental home in Gulf Breeze-Harold, and holiday rentals Gulf Breeze-Harold found on our for rent by owner website.
Elicit and dig up Suwannee Florida house rentals and rental homes Suwannee.
Decadent advertisements and waterfront advertisements Brevard Florida apartment rentals, holiday rentals, Brevard homes for rent by owner, and homes for rent by owner.
Find and identify vacation rentals Orange, vacation rental in Orange Florida, and vacation rentals in Orange Florida.
Gulf Breeze-Harold Florida is a sublime and symmetrical vicinity with resplendent, foxy, excellent, and grand apartment and castles.
|
|
