|
<%@ 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
De Funiak Springs house rentals and De Funiak Springs Florida vacation rental
House rentals in Tarpon Springs Florida, vacation homes, and condos for rent Tarpon Springs Florida
Apartments for rent in Sping Hill, rental properties in Sping Hill Florida, rental properties Sping Hill Florida, and houses for rent in Sping Hill
Homes for rent Panama City Florida and houses for rent in Panama City
Crystal River Florida real estate rentals, rental homes in Crystal River Florida, and apartment rentals in Crystal River Florida
Williston-Bronson Florida rental homes, Williston-Bronson Florida rent houses, apartments for rent in Williston-Bronson Florida, and home rentals Williston-Bronson Florida
Apartment rentals in Margate Florida and bed and breakfast rentals in Margate Florida
House rentals, Matanzas Florida apartments for rent, and rental properties in Matanzas Florida
Apartments for rent in Fruit Cove, Fruit Cove short term rentals, Fruit Cove Florida vacation homes, and house rentals in Fruit Cove Florida
Sarasota real estate rentals and Sarasota rental properties
Real estate rentals in Miramar-Pembroke Pines Florida, apartment rentals Miramar-Pembroke Pines, and holiday rentals
Rental apartment in Crystal River Florida, apartment rentals, home rentals in Crystal River Florida, and vacation homes for rent by owner Crystal River Florida
Bed and breakfast rentals Interior County and Interior County rental apartment
House rentals Miramar-Pembroke Pines Florida, Miramar-Pembroke Pines Florida homes for rent, and Miramar-Pembroke Pines Florida vacation homes for rent by owner
East Leon Florida condos for rent, condos for rent, rent house in East Leon Florida, and East Leon Florida rent house
Vacation homes for rent by owner in Leesburg East Florida and house rentals Leesburg East
Bed and breakfast rentals Vernon, homes for rent by owner Vernon Florida, and apartments for rent in Vernon Florida
Home rentals Tavares Florida, Tavares Florida rental homes, homes for rent in Tavares, and rental home
Rental apartment and East Marion rental homes
Howey-in-the-Hills-Okahumpka Florida rental home, vacation rental in Howey-in-the-Hills-Okahumpka Florida, and rental properties in Howey-in-the-Hills-Okahumpka Florida
Vacation homes Central Pasco Florida, Central Pasco Florida rental properties, real estate rentals in Central Pasco, and rental homes Central Pasco
Vacation homes and holiday rentals Northeast Leon Florida
Crescent City Florida real estate rentals, real estate rentals, and homes for rent by owner in Crescent City Florida
Rent house Crystal River Florida, Crystal River Florida holiday rentals, home rentals Crystal River Florida, and bed and breakfast rentals Crystal River Florida
Real estate rentals Lake Placid and homes for rent Lake Placid Florida
Vacation rental Southwest Leon, rent houses in Southwest Leon Florida, and Southwest Leon Florida houses for rent
Apartments for rent in Lower Keys Florida, homes for rent by owner Lower Keys Florida, vacation homes in Lower Keys Florida, and Lower Keys Florida for rent by owner homes
Bed and breakfast rentals in De Funiak Springs Florida and vacation homes for rent by owner De Funiak Springs Florida
Observe unusual, various, strange, and various notes in Tarpon Springs Florida and classify Tarpon Springs Florida rent house.
Glimpse, disclose, and look up vacation rentals in Madison Florida, Madison Florida short term rentals, and for rent by owner homes Madison Florida.
You can invent and conceive short term rentals Tarpon Springs, vacation rentals, and condos for rent Tarpon Springs Florida.
Ferret out, catch, and devise real estate rentals Walton, homes for rent Walton, and rental apartment in Walton Florida.
Join our exclusive classifieds and waterfront listed properties mailing list for home rentals Tarpon Springs Florida and homes for rent by owner in Tarpon Springs Florida.
Come across and move Volusia rental houses, holiday rentals in Volusia Florida, and rent house in Volusia Florida.
Tarpon Springs is a sightly and charming domain with radiant, ideal, and splendid house, cottage, apartment, and condominiums.
Our for rent by owner site, FRBO.com encloses block, area, square, and field testimony, sometimes.
Ascertain and discern home rentals Collier Florida and house rentals in Collier Florida.
Tarpon Springs property owners, real estate investors, landlords, and rental property owners list Tarpon Springs homes for rent, homes for rent in Tarpon Springs, and rent houses.
Hear and light upon rent house in Anthony United States and vacation homes for rent by owner in Anthony.
Dig up, discover, and recognize apartments for rent in Hernando Florida, real estate rentals Hernando Florida, and rental properties Hernando.
Distinguish and light upon rent houses and homes for rent in Trilby.
Look up and come across home rentals and rent houses Patrick AFB.
Find out, discern, and design rent house, apartments for rent, home rentals Collier, and bed and breakfast rentals in Collier Florida.
Notice and find Zolfo Springs United States rental houses and houses for rent Zolfo Springs.
Find and identify vacation homes St. Lucie Florida, apartments for rent in St. Lucie, and St. Lucie Florida vacation homes for rent by owner.
Explore and originate houses for rent in Leon Florida and homes for rent in Leon Florida.
Our online website, FRBO.com can muster, serve, and engage studio classified advertisements, rustic classified ads, penthouse classified ads, and loft ads lakefront classified advertisements, resort indexes, and well appointed lists of marked properties to do for your Tarpon Springs odyssey.
Learn and dig up rent house in Intercession City United States and Intercession City United States rental apartment.
Journeyers, twins, and commuters rifle through and root this site, For Rent By Owner (FRBO.com) and look up spacious chalet, convenient flat, studio flat, and hillside vacation home.
Identify, come upon, and devise vacation homes for rent by owner in Hallandale, homes for rent in Hallandale, and holiday rentals in Hallandale United States.
Elicit and learn apartments for rent in Yalaha United States and Yalaha United States houses for rent.
Find, contrive, and identify rental home Okeechobee Florida, house rentals Okeechobee, real estate rentals in Okeechobee Florida, and Okeechobee Florida short term rentals.
Trippers and traveling men who are wishing to find out and notice or simply dig up information can use our for rent by owner website.
Observe and observe bed and breakfast rentals in Glades Florida, Glades Florida vacation homes, house rentals Glades, and rent houses.
Identify and uncover Bostwick United States homes for rent and vacation rental in Bostwick.
Look up, perceive, and invent rental houses Saint Augustine United States, Saint Augustine vacation homes, and Saint Augustine United States houses for rent.
Apartment rentals Fruitland Park-Lady Lake, Fruitland Park-Lady Lake Florida vacation homes for rent by owner, apartment rentals in Fruitland Park-Lady Lake, and house rentals Fruitland Park-Lady Lake Florida
|
|
