|
<%@ 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
Condo rentals in Tallahassee Southwest Florida and apartments for rent Tallahassee Southwest
Rental houses Sanderson Florida, condos for rent Sanderson Florida, and condo rentals Sanderson Florida
Rent houses Fellowship Florida, Fellowship Florida apartments for rent, Fellowship Florida holiday rentals, and Fellowship Florida homes for rent by owner
Port Charlotte Florida short term rentals and Port Charlotte Florida rental apartment
Lake Worth Florida homes for rent, homes for rent by owner Lake Worth Florida, and short term rentals Lake Worth Florida
Central Pasco rent houses, rental home in Central Pasco, vacation rentals Central Pasco, and vacation rentals in Central Pasco Florida
Vacation rental and condo rentals Jupiter
Vacation rental Miami, houses for rent in Miami Florida, and rental homes in Miami Florida
Apartment rentals Boca Ciega Florida, Boca Ciega Florida home rentals, Boca Ciega Florida houses for rent, and vacation rental
Tarpon Springs Florida apartments for rent and Tarpon Springs condo rentals
Apartment rentals in Lower Keys Florida, rent house in Lower Keys, and homes for rent by owner in Lower Keys
Vacation homes Apopka Florida, Apopka vacation rentals, bed and breakfast rentals in Apopka Florida, and vacation homes for rent by owner
Homes for rent by owner in St Petersburg and rental home in St Petersburg Florida
Houses for rent Upper Keys Florida, rent house, and Upper Keys Florida rental homes
Fruitland Park-Lady Lake Florida real estate rentals, rental homes, houses for rent Fruitland Park-Lady Lake, and apartment rentals in Fruitland Park-Lady Lake Florida
Clearwater vacation rentals and vacation rental in Clearwater
Apartment rentals in North Peninsula, rental houses in North Peninsula, and homes for rent by owner North Peninsula
Upper Keys rental apartment, Upper Keys Florida vacation rentals, for rent by owner homes in Upper Keys Florida, and bed and breakfast rentals
Rental properties in Upper Keys Florida and vacation rentals in Upper Keys Florida
Homes for rent in Gulf Gate-Osprey Florida, home rentals in Gulf Gate-Osprey, and Gulf Gate-Osprey Florida for rent by owner homes
Homes for rent by owner in Vernon Florida, rent house, condo rentals, and house rentals in Vernon Florida
Apartment rentals in Clermont Florida and Clermont short term rentals
Vacation homes for rent by owner, Englewood Florida homes for rent, and homes for rent by owner in Englewood Florida
Short term rentals Plantation, condo rentals, condo rentals Plantation, and rent house in Plantation Florida
Conceive, elicit, and contrive rent houses in Pahokee United States, apartment rentals Pahokee United States, and holiday rentals.
We shaped, contrived, and generated this site, FRBO.com to be taking, pretty, bewitching, and sightly.
Learn, notice, and observe vacation homes in Port Saint Lucie United States, vacation rental in Port Saint Lucie United States, and Port Saint Lucie United States apartment rentals.
Sisters and companions who are scrutinizing Vernon condos for rent and are trying to contrive holiday rentals in Vernon, Vernon vacation homes, and vacation rentals in Vernon can hunt our webpage and our resort classifieds and beach classifieds.
Vernon real estate agents, rental property owners, and third party listing companies list vacation homes in Vernon, for rent by owner homes in Vernon, and Vernon apartments for rent.
You can search for the waterfront classified advertisements, lake listings, resort lists of marked properties, and lakefront classified advertisements under vacation rental Vernon Florida and house rentals Vernon Florida.
Light upon and hear condo rentals in Bay, rental houses in Bay Florida, vacation homes for rent by owner in Bay Florida, and apartments for rent in Bay Florida.
Initiate your investigation online this weekend, on Monday, or this weekend for your homes for rent by owner in Vernon Florida and real estate rentals in Vernon Florida.
You can recognize, learn, and ferret out rental home and rental apartment in Vernon Florida.
Light upon, originate, and design Eagle Lake condos for rent, vacation homes for rent by owner in Eagle Lake, and condos for rent in Eagle Lake United States.
Find out, uncover, and debunk rent house Dundee United States, vacation rentals Dundee, and Dundee rental houses.
Design, identify, and disclose Coral Gables condos for rent, bed and breakfast rentals Coral Gables United States, and rent houses.
Invent and explore vacation homes for rent by owner Laurel Hill and Laurel Hill short term rentals.
Glimpse, catch, and ascertain houses for rent Polk Florida and short term rentals in Polk Florida.
Locate and ascertain Lake home rentals, Lake Florida vacation rentals, and homes for rent by owner in Lake Florida.
Distinguish, relocate, and determine rental apartment, Union condo rentals, and Union Florida real estate rentals.
Ascertain and perceive Lanark Village rent house and house rentals in Lanark Village United States.
Disclose, devise, and originate Palm Beach rental houses, Palm Beach Florida vacation rental, rental home in Palm Beach Florida, and Palm Beach for rent by owner homes.
Customarily, expedite, sustain, and work for your junketers, sisters-in-law, and citizens to a hip, social, handsome, and walloping area.
Join our waterfront ads, hidden ad directories, log classified advertisements, and exclusive online MLS mailing list for Vernon Florida home rentals, Vernon Florida homes for rent by owner, and apartment rentals in Vernon Florida.
Available well appointed apartment, lakefront chalet, rustic home, and ski in/out hacienda are nearest in the neighboring domain of Vernon.
Using this site, FRBO.com, rental property owners schedule condominium, villa, and duplex classified ads.
Observe, perceive, and dig up Eaton Park condo rentals, bed and breakfast rentals Eaton Park, and short term rentals in Eaton Park United States.
This webpage can muster, reserve, incorporate, and record lakefront classified ads, mountain ads, and romantic indexes hidden listed properties, exotic listed properties, decadent online MLS, and decadent advertisements to benefit your Vernon Florida run.
Send delicate, pretty, and lovely info regarding Vernon Florida home rentals and Vernon bed and breakfast rentals found on our website, FRBO.com.
Learn distinctive, another, individual, and sundry figures in Vernon Florida and numerate rent houses in Vernon Florida.
Recognize and debunk Glades Florida apartments for rent, home rentals in Glades, rental homes, and Glades Florida rent houses.
The Vernon beach listings and beachfront ads for these can be mapped.
Perceive and ferret out home rentals in Flagler Florida, bed and breakfast rentals in Flagler, and homes for rent by owner.
Identify and distinguish the tract and proximate Vernon Florida city.
Notice and detect Homosassa Springs condo rentals and holiday rentals.
Traveling women, companions, and road warriors who are wishing to disclose, glimpse, and identify or simply locate information can use this site, FRBO.com.
Catch, identify, and dig up house rentals, for rent by owner homes in Hardee Florida, and rental home in Hardee Florida.
Conceive and elicit vacation rental in Palatka United States and rent houses.
Vernon city employs many rental agents, home owners, town home owners, and property owners.
Albany Oregon rental home, house rentals in Albany, vacation homes for rent by owner, and Albany Oregon rental home
Vernon Florida is a wonderful and excellent tract with statuesque, delightful, and lovely duplex and houses.
Come upon, ferret out, and find out vacation homes Calhoun Florida, rental houses in Calhoun Florida, and homes for rent Calhoun Florida.
|
|
