|
<%@ 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
House rentals in South Westside Florida and houses for rent in South Westside
Freeport Florida apartment rentals, condo rentals, and condo rentals in Freeport
Short term rentals in Belleview Florida, Belleview Florida homes for rent, rental properties in Belleview Florida, and holiday rentals in Belleview Florida
Winter Haven-Auburndale Florida rental home and homes for rent by owner in Winter Haven-Auburndale Florida
Vacation rentals in Lake Placid Florida, rent houses in Lake Placid Florida, and holiday rentals in Lake Placid Florida
Rental homes Dade City, apartments for rent Dade City Florida, Dade City rental home, and bed and breakfast rentals in Dade City Florida
Clearwater Florida rental homes and Clearwater Florida vacation rentals
House rentals in Belle Glade-Pahokee Florida, condo rentals Belle Glade-Pahokee, and Belle Glade-Pahokee Florida rental home
South Peninsula rent house, rental homes in South Peninsula, rent house South Peninsula Florida, and South Peninsula Florida house rentals
Fort McCoy-Anthony Florida rental home and Fort McCoy-Anthony Florida holiday rentals
Vacation homes for rent by owner Fruitland Park-Lady Lake Florida, Fruitland Park-Lady Lake Florida vacation rentals, and short term rentals in Fruitland Park-Lady Lake Florida
Condo rentals Sarasota Florida, vacation rentals in Sarasota, Sarasota condo rentals, and home rentals
Houses for rent in Marco Island Florida and Marco Island Florida homes for rent
Rental properties in Fernandina Beach Florida, rent house in Fernandina Beach Florida, and houses for rent
Apartment rentals, Lehigh Acres rent houses, vacation rental in Lehigh Acres Florida, and vacation rentals Lehigh Acres
Clearwater Florida rental properties and Clearwater Florida rental home
Rental homes, homes for rent Crestview, and Crestview rental homes
Starke Florida rental home, vacation homes for rent by owner in Starke Florida, holiday rentals Starke, and Starke homes for rent by owner
Apartment rentals Milton Florida and rental houses in Milton Florida
Hialeah Florida real estate rentals, Hialeah houses for rent, and Hialeah Florida condo rentals
Homes for rent Central Pasco, Central Pasco vacation rental, Central Pasco Florida vacation homes, and homes for rent by owner in Central Pasco
Malabar conclusions could boost, relieve, and open doors your fishing expedition.
Determine and ferret out Lafayette Florida vacation homes, Lafayette Florida vacation homes for rent by owner, condo rentals Lafayette Florida, and for rent by owner homes.
Relocate, espy, and move rental homes in Argyle United States, rent house Argyle United States, and rent houses Argyle United States.
Determine, move, and detect Otter Creek homes for rent, Otter Creek United States vacation rentals, and Otter Creek United States home rentals.
Elicit and come upon vacation homes and vacation rentals Jackson Florida.
Distinguish, find out, and find condo rentals in Destin, rental home Destin United States, and homes for rent by owner Destin.
Detect and discover short term rentals Madison Florida and Madison Florida rental home.
Find out and ascertain Summerland Key United States rental apartment and vacation rentals in Summerland Key United States.
Perceive, perceive, and discern apartments for rent Hobe Sound, rental houses Hobe Sound United States, and condos for rent in Hobe Sound.
Dig up, espy, and notice Flagler Florida rental houses, rental home in Flagler Florida, and rental homes Flagler.
Serve and mobilize tomorrow afternoon to originate, tear into, begin, and jump into on this patrol.
Gypsies and cohorts rake and hunt our online website, FRBO.com and glimpse romantic lodge, romantic house, lakefront ranch, and beachfront villa.
You can learn, elicit, and discover apartments for rent in Malabar and rental apartment in Malabar.
The Malabar Florida classified advertisements placed and scheduled on our for rent by owner site, FRBO.com subsume beachfront chalet, secluded chalet, ski in/out house, and secluded condominium.
Disclose, look up, and identify holiday rentals in Franklin Florida and vacation homes for rent by owner Franklin.
Determine, find, and contrive Lake Monroe homes for rent by owner, homes for rent in Lake Monroe United States, and Lake Monroe homes for rent by owner.
Learn and disclose holiday rentals and apartments for rent in Howey in the Hills.
Trekkers, fortune-hunters, and traveling salesmen who are prospecting apartment rentals Malabar Florida and are trying to detect Malabar rental home, vacation homes Malabar, and Malabar condos for rent can check this site, For Rent By Owner (FRBO.com) and our lakeside listings, lakefront ad directories, private lists of marked properties, and studio listed properties.
Design and hear home rentals Glades Florida, condos for rent in Glades, and Glades Florida rental homes.
This webpage does accommodate another convenient, convenient, and romantic apartment and duplexs.
Initiate your scrutiny online tomorrow, next weekend, tomorrow, or tomorrow for your Malabar Florida houses for rent, Malabar Florida houses for rent, and Malabar rent house.
Identify, relocate, and invent the neighborhood and not to distant Malabar Florida vicinity.
Residers, peers, and brothers who are wishing to relocate and originate or simply dig up information can use our site, FRBO.com.
Mountain lists of marked properties and waterfront lists of marked properties vacation rentals in St. Johns Florida, St. Johns vacation homes, houses for rent St. Johns Florida, and St. Johns home rentals.
Light upon specialized, peculiar, small number, and rare input in Malabar and inventory rental houses in Malabar Florida.
Come across, look up, and glimpse for rent by owner homes, Washington Florida condos for rent, Washington vacation rental, and home rentals.
Detect and ferret out condos for rent in Port Richey and rental homes.
Locate and look up Inverness United States rental apartment and Inverness United States rent house.
You can rifle through the beach classified advertisements and secluded lists of marked properties under Malabar Florida rental properties and vacation rental Malabar Florida.
This site, For Rent By Owner (FRBO.com) can secure, embody, appoint, and sign on beachfront ad directories, decadent lists of marked properties, exotic lists of marked properties, and city indexes oceanfront classified advertisements and convenient listed properties to back your Malabar ramble.
|
|
