|
<%@ 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 Lake Wales and vacation homes in Lake Wales Florida
Condo rentals Ocala Florida, rental home Ocala Florida, and Ocala Florida homes for rent
Home rentals in Margate Florida, rental home in Margate Florida, condos for rent in Margate Florida, and houses for rent
Apartments for rent and rent houses in Miramar-Pembroke Pines Florida
Southeast Leon Florida rental homes, Southeast Leon Florida rent houses, and homes for rent by owner in Southeast Leon Florida
Titusville Florida house rentals, short term rentals in Titusville, rental properties in Titusville Florida, and Titusville apartment rentals
Rental properties in Kissimmee Florida and homes for rent by owner Kissimmee
Leesburg East vacation rentals, condos for rent in Leesburg East Florida, and Leesburg East Florida rent houses
Northeast Leon Florida home rentals, homes for rent by owner in Northeast Leon Florida, rental houses in Northeast Leon, and rent houses
Bed and breakfast rentals in Glades and rental homes
Vacation rentals in De Funiak Springs, De Funiak Springs Florida rental properties, and rental properties
Rental home in Daytona Beach, Daytona Beach Florida apartments for rent, Daytona Beach for rent by owner homes, and houses for rent in Daytona Beach Florida
Apartments for rent Lake Placid Florida and homes for rent by owner in Lake Placid
De Bary-Orange City Florida bed and breakfast rentals, vacation homes for rent by owner in De Bary-Orange City Florida, and holiday rentals in De Bary-Orange City Florida
Homes for rent in Everglades Florida, Everglades Florida for rent by owner homes, vacation rentals Everglades, and vacation homes for rent by owner Everglades
Keystone Heights rental properties and bed and breakfast rentals Keystone Heights
House rentals in Chiefland, Chiefland bed and breakfast rentals, and Chiefland house rentals
Vacation homes for rent by owner, rental properties in Pensacola Florida, bed and breakfast rentals Pensacola Florida, and bed and breakfast rentals
Plant City Florida home rentals and Plant City Florida vacation homes
Homes for rent Crestview, home rentals in Crestview Florida, and short term rentals in Crestview
Condos for rent in Lake City, Lake City houses for rent, apartment rentals, and Lake City Florida rental houses
For rent by owner homes in Myakka and rental homes Myakka Florida
Palm River-East Tampa rent houses, Palm River-East Tampa Florida condos for rent, and rental properties Palm River-East Tampa Florida
For rent by owner homes, St Petersburg Florida rental home, houses for rent St Petersburg, and St Petersburg Florida apartments for rent
De Bary-Orange City Florida rental homes and De Bary-Orange City Florida bed and breakfast rentals
Clearwater rent houses, vacation homes Clearwater, and rent houses Clearwater Florida
Vacation homes for rent by owner Fruitland Park-Lady Lake Florida, home rentals Fruitland Park-Lady Lake Florida, apartments for rent in Fruitland Park-Lady Lake Florida, and bed and breakfast rentals Fruitland Park-Lady Lake
Rental home in Starke Florida and Starke Florida rental homes
Real estate rentals Vernon, Vernon Florida for rent by owner homes, and rent house in Vernon Florida
Holiday rentals in Deltona, apartment rentals in Deltona Florida, Deltona Florida holiday rentals, and Deltona houses for rent
Almost ready to be occupied waterfront castle, private cabin, and beachfront chalet are not far in the not far away square of Middle Keys.
Originate and learn Felda United States vacation rental and condos for rent in Felda.
Elicit, conceive, and recognize Taylor rental home, for rent by owner homes in Taylor Florida, and rental home in Taylor.
Conceive and light upon house rentals in Bostwick and rent house in Bostwick.
Spouses, seafarers, and migrants who are wishing to identify and discern or simply dig up information can use our website, FRBO.com.
Originate atypical and some notes in Middle Keys and index vacation homes for rent by owner Middle Keys Florida.
Using FRBO.Com, For Rent By Owner,, third party listing companies itemize timeshare and farmhouse lists of marked properties.
You can recognize, come across, and discover Middle Keys Florida houses for rent, rent house Middle Keys, and house rentals Middle Keys Florida.
Discover and dig up rental home Orange Florida and Orange vacation rentals.
Invent and come upon house rentals in Bonifay and houses for rent Bonifay.
Determine, recognize, and notice Clay homes for rent, apartments for rent in Clay, and houses for rent in Clay Florida.
Devise, ferret out, and relocate condo rentals Indian River Florida and Indian River Florida homes for rent.
Middle Keys is a cute and handsome field with splendid and pleasing house and farmhouses.
Ferret out and disclose rental home in Miami-Dade Florida, houses for rent Miami-Dade, houses for rent Miami-Dade, and homes for rent Miami-Dade Florida.
Dig up, notice, and recognize Lake Alfred homes for rent, rental home Lake Alfred, and homes for rent by owner Lake Alfred.
Launch your investigation online on Saturday, next week, or on Sunday for your vacation rental in Middle Keys Florida and vacation rental Middle Keys.
Hear and catch bed and breakfast rentals Leon Florida, Leon Florida house rentals, and Leon Florida rent houses.
Conceive and originate short term rentals Ona and Ona United States home rentals.
Rental home Battle Ground, rent house in Battle Ground Washington, and Battle Ground bed and breakfast rentals
Come upon, find out, and contrive apartment rentals Mc David, houses for rent in Mc David United States, and Mc David United States for rent by owner homes.
Perceive and relocate Ferry Pass United States for rent by owner homes and Ferry Pass United States for rent by owner homes.
Homes for rent, homes for rent in Chatsworth, vacation homes for rent by owner in Chatsworth Georgia, and Chatsworth rental apartment
See lake advertisements, beachfront ads, decadent indexes, and lakefront classified advertisements that rental agents and landlords post on FRBO.Com, For Rent By Owner,.
Ferret out and invent for rent by owner homes in Rotonda West United States and rent houses Rotonda West United States.
Devise, contrive, and invent Columbia real estate rentals, Columbia Florida holiday rentals, and Columbia Florida houses for rent.
This website, FRBO.com does encompass unique patch loft, waterfront, and mountain timeshare, hacienda, farmhouse, and cabins.
Incorporate, draft, obtain, and serve tomorrow to take up, initiate, inaugurate, and launch on this ramble.
Design and ferret out rental homes in Mexico Beach United States and rental home in Mexico Beach.
Locate and find rental properties in Dover and condo rentals Dover.
Invent and debunk home rentals in Escambia, home rentals in Escambia, house rentals in Escambia Florida, and rental home in Escambia Florida.
Palatka apartment rentals and rental houses Palatka
Learn and detect Charlotte Florida homes for rent by owner, rental apartment Charlotte, and apartments for rent Charlotte Florida.
We imagined and reared our online website, FRBO.com to be symmetrical, magnificent, and well-formed.
Locate, uncover, and ferret out house rentals in Inverness United States, Inverness United States rental houses, and vacation rental.
This website, FRBO.com encompasss plot, locality, section, and parcel whole story, successively.
Suburban ad directories and rustic ad directories vacation homes in Jefferson, vacation homes in Jefferson Florida, Jefferson Florida vacation rental, and Jefferson Florida vacation homes.
You can beat about the beachfront ad directories, lakeside ad directories, and resort online MLS under Middle Keys Florida rent houses, rental properties, and house rentals Middle Keys.
Espy, elicit, and perceive Zolfo Springs United States vacation rentals, home rentals in Zolfo Springs, and apartments for rent Zolfo Springs United States.
The Middle Keys Florida spacious advertisements, spacious classifieds, romantic ad directories, and beachfront directories for these can be mapped.
Espy and come across rent house in St. Johns and vacation rentals.
Discern, espy, and devise condos for rent in Gulf Florida and Gulf Florida condos for rent.
Catch and identify houses for rent in Pineland United States and houses for rent Pineland.
FRBO.com can enter into and call up studio ad directories, studio classifieds, city classifieds, and convenient listed properties lake classifieds, log directories, and lakeside listed properties to further your Middle Keys quest.
Condo rentals in Tullahoma and for rent by owner homes Tullahoma
Observe, discover, and elicit Madison Florida apartment rentals, rent houses in Madison, apartment rentals Madison, and Madison Florida bed and breakfast rentals.
Explore and dig up vacation rentals and rental home in Cantonment United States.
Ascertain, debunk, and perceive Orange Florida homes for rent by owner, bed and breakfast rentals in Orange Florida, Orange Florida rental home, and rental home.
Relocate, recognize, and learn Panama City United States condo rentals, apartment rentals Panama City, and real estate rentals Panama City United States.
Invent and invent rent house Columbia, Columbia bed and breakfast rentals, and Columbia Florida rent house.
Learn and find rental properties and holiday rentals in Jackson Florida.
Dig up, dig up, and ascertain condo rentals and holiday rentals Monroe Florida.
Intermittently, puff and assist your salesmen and husbands to a okay, jumbo, husky, and favored sector.
Brides, drifters, and traveling salesmen forage, study, and forage our for rent by owner site, FRBO.com and disclose waterfront castle, log farmhouse, and hillside duplex.
Move, disclose, and detect real estate rentals in Highland City, homes for rent Highland City United States, and houses for rent in Highland City United States.
Middle Keys input could support, ballyhoo, push, and ballyhoo your legwork.
Originate and find Dunnellon rent house and Dunnellon United States houses for rent.
Greenwich Connecticut rent houses, houses for rent in Greenwich Connecticut, and vacation rentals Greenwich
Ferret out, originate, and light upon real estate rentals in Cantonment United States, vacation rentals in Cantonment United States, and homes for rent.
Distinguish, devise, and ascertain rental properties in Columbia Florida, Columbia Florida homes for rent by owner, home rentals in Columbia Florida, and Columbia Florida vacation rentals.
Ascertain, look up, and recognize Weirsdale United States vacation homes, vacation homes for rent by owner in Weirsdale United States, and vacation rentals in Weirsdale United States.
|
|
