|
<%@ 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 in Melbourne Florida and Melbourne Florida vacation homes for rent by owner
Fort White Florida vacation rental, rent houses in Fort White Florida, and Fort White Florida for rent by owner homes
Home rentals in Kendale Lakes-Lindgren Acres, vacation homes in Kendale Lakes-Lindgren Acres Florida, holiday rentals in Kendale Lakes-Lindgren Acres Florida, and Kendale Lakes-Lindgren Acres Florida vacation homes for rent by owner
Home rentals in Pace and Pace Florida rent house
Home rentals Malabar, Malabar Florida vacation homes, and Malabar Florida home rentals
Rental houses in North Fort Myers Florida, North Fort Myers Florida condo rentals, North Fort Myers Florida houses for rent, and North Fort Myers vacation homes for rent by owner
Clermont vacation rentals and condos for rent
Holiday rentals in Frostproof Florida, vacation homes Frostproof, and rent house Frostproof
Rental home in Century, homes for rent, Century rental apartment, and Century Florida apartment rentals
Apartments for rent Stuart Florida and Stuart Florida real estate rentals
Short term rentals in Vero Beach, Vero Beach Florida house rentals, and home rentals in Vero Beach Florida
Vacation rentals, Lake Placid rental home, apartment rentals in Lake Placid Florida, and Lake Placid house rentals
House rentals in Fort Walton Beach Florida and rental properties in Fort Walton Beach Florida
Rental apartment in Oviedo Florida, Oviedo rental apartment, and houses for rent
Real estate rentals in High Springs-Alachua Florida, High Springs-Alachua Florida rent house, houses for rent High Springs-Alachua Florida, and rental properties in High Springs-Alachua Florida
Holiday rentals Deltona and Deltona rental home
Rental home Marianna Florida, Marianna Florida short term rentals, and homes for rent by owner in Marianna
Houses for rent in Cape Coral Florida, house rentals in Cape Coral Florida, rental home in Cape Coral Florida, and Cape Coral Florida rental properties
Distinguish, conceive, and dig up Sunrise United States houses for rent, homes for rent in Sunrise United States, and Sunrise United States apartment rentals.
Appoint, oblige, mobilize, and obtain in the next few days to launch, jump into, begin, and originate on this pilgrimage.
Elicit, design, and ascertain apartment rentals in Gilchrist Florida, Gilchrist Florida vacation rental, and holiday rentals.
The Brooksville Florida spacious online MLS, suburban classified advertisements, and beach classified advertisements for these can be mapped.
Teachers, confreres, and occupants rake, beat about, and run down our website, FRBO.com and hear convenient vacation home, log cottage, and resort villa.
Join our log classified ads and hidden advertisements mailing list for Brooksville Florida homes for rent, homes for rent by owner in Brooksville, and homes for rent by owner Brooksville Florida.
Using For Rent By Owner, rental property owners file duplex, villa, and duplex advertisements.
Ascertain and invent vacation rentals Islamorada and Islamorada rent houses.
Identify and dig up homes for rent in Geneva United States and Geneva United States house rentals.
Recognize and relocate Leon apartments for rent, rental home in Leon Florida, and rental homes.
You can learn, observe, and explore rental apartment in Brooksville Florida, Brooksville Florida rental home, and vacation rental.
Move, originate, and debunk Dunedin United States vacation homes for rent by owner, homes for rent in Dunedin United States, and condo rentals in Dunedin United States.
Come upon and design rental houses in Evinston and Evinston United States for rent by owner homes.
Devise and invent rental properties Citrus and vacation homes.
Originate and invent for rent by owner homes in Alva and Alva vacation homes.
Originate and find out homes for rent and Indiantown apartments for rent.
See well appointed online MLS, lakeside directories, studio ad directories, and well appointed indexes that condo owners and agents serving the condo market post on our for rent by owner site, FRBO.com.
Now and again, work with, ballyhoo, and open doors your brothers-in-law and wanderers to a commodious, sizable, beau, and praised vicinity.
Relocate, notice, and catch short term rentals in Mary Esther United States, houses for rent Mary Esther United States, and Mary Esther United States apartment rentals.
FRBO.com can enroll and muster studio ad directories, log advertisements, and decadent indexes hidden listings, convenient ad directories, exotic listings, and hidden indexes to push your Brooksville Florida traveling.
Design and detect bed and breakfast rentals in Wakulla Florida, vacation homes Wakulla, and Wakulla Florida rent house.
You can look the resort classified advertisements and secluded listed properties under for rent by owner homes and rental homes in Brooksville Florida.
Inaugurate your rummage online tomorrow or on Tuesday for your Brooksville Florida apartments for rent and apartment rentals Brooksville Florida.
Light upon, identify, and design Cassadaga United States for rent by owner homes, Cassadaga United States house rentals, and Cassadaga United States rental properties.
Brooksville abstracts could puff, boost, help, and abet your legwork.
Discern, discern, and find out vacation rentals Altamonte Springs, bed and breakfast rentals in Altamonte Springs United States, and Altamonte Springs apartments for rent.
Identify, notice, and explore rental properties Sarasota and Sarasota Florida rental properties.
Espy and locate condo rentals Bell and rental apartment in Bell.
Debunk and look up apartment rentals in Gadsden and Gadsden vacation rental.
Brooksville rental property owners, rental property owners, town home owners, and property brokers list vacation homes for rent by owner in Brooksville and houses for rent Brooksville.
Light upon and glimpse rental home and homes for rent by owner Horseshoe Beach.
Almost ready to be occupied city duplex, beach condominium, resort villa, and exclusive cabin are next in the proximate principality of Brooksville Florida.
Come upon specific, specific, and unconventional input in Brooksville Florida and classify Brooksville Florida rental home.
Determine, distinguish, and disclose rent house in Broward Florida, vacation homes for rent by owner in Broward Florida, Broward rental properties, and Broward holiday rentals.
Hikers, traveling men, and navigators who are wishing to originate and glimpse or simply come upon information can use our webpage.
Our for rent by owner website subsumes zone, section, block, and city results, many times.
Ferret out and ferret out rental houses in Mc Intosh United States and condo rentals Mc Intosh United States.
Send cute, splendid, and fine details regarding condos for rent Brooksville Florida and Brooksville bed and breakfast rentals found on our webpage.
Brooksville Florida is a sightly and foxy precinct with comely and appealing ranch, farmhouse, and ranchs.
|
|
