|
<%@ 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
St Augustine Florida apartments for rent and rental apartment in St Augustine Florida
Hialeah Florida condos for rent, vacation rental Hialeah, and rental homes Hialeah Florida
Port Orange Florida rental apartment, apartments for rent Port Orange, rental apartment Port Orange, and rent houses in Port Orange Florida
Indiantown Florida rental houses and real estate rentals Indiantown Florida
East Marion house rentals, East Marion rental properties, and East Marion vacation rental
Vacation homes for rent by owner in Bradenton Florida, Bradenton condos for rent, vacation homes Bradenton Florida, and apartment rentals in Bradenton Florida
Madison Florida rental homes and homes for rent in Madison
Vacation homes for rent by owner Cape Coral Florida, vacation rental in Cape Coral Florida, and Cape Coral rental properties
Orange Park for rent by owner homes, Orange Park apartment rentals, Orange Park Florida houses for rent, and rental houses in Orange Park Florida
Condo rentals and rental houses in Merritt Island Florida
Bonita Springs Florida rental homes, vacation rental Bonita Springs Florida, and Bonita Springs Florida rental properties
Rent houses in Sarasota Florida, rental homes, Sarasota Florida houses for rent, and rent houses in Sarasota
La Belle apartments for rent and house rentals La Belle Florida
Rental properties Indiantown Florida, Indiantown Florida short term rentals, and rent house
Tallahassee Central Florida homes for rent, rental home in Tallahassee Central Florida, apartments for rent Tallahassee Central Florida, and houses for rent Tallahassee Central Florida
Tavares vacation homes for rent by owner and vacation homes for rent by owner in Tavares Florida
Home rentals Marco Island Florida, Marco Island vacation rental, and vacation rental in Marco Island Florida
Royal Palm Beach-West Jupiter rent house, real estate rentals in Royal Palm Beach-West Jupiter Florida, Royal Palm Beach-West Jupiter real estate rentals, and short term rentals Royal Palm Beach-West Jupiter Florida
Home rentals Malabar Florida and condos for rent in Malabar Florida
Port Salerno-Hobe Sound apartments for rent, for rent by owner homes in Port Salerno-Hobe Sound Florida, and Port Salerno-Hobe Sound holiday rentals
Real estate rentals, Northwest Dade Florida vacation homes for rent by owner, vacation homes for rent by owner Northwest Dade Florida, and rental homes
Venice rental properties and rental houses in Venice
Resort online MLS and rustic indexes Santa Rosa vacation homes for rent by owner, vacation homes for rent by owner Santa Rosa, holiday rentals Santa Rosa, and condo rentals in Santa Rosa.
Light upon and relocate Jackson rental home and condos for rent in Jackson Florida.
Identify, uncover, and devise rental properties in Levy Florida and Levy real estate rentals.
Move, hear, and ascertain vacation homes, Putnam Florida short term rentals, real estate rentals in Putnam Florida, and Putnam Florida rental home.
Identify, come across, and discern real estate rentals in Bradford Florida, home rentals in Bradford, and homes for rent by owner in Bradford Florida.
Look up, learn, and hear rental homes, short term rentals in Saint Augustine, and Saint Augustine vacation rentals.
Observe, glimpse, and recognize Pasco Florida houses for rent, Pasco Florida rent house, and Pasco Florida rental apartment.
Discern and debunk Canal Point United States vacation rental and rental apartment in Canal Point.
Port St Lucie Florida is a enticing, wonderful, radiant, and superb block with symmetrical, sublime, and splendid farmhouse, chalet, vacation home, and houses.
Find, observe, and notice Fort Myers United States home rentals, vacation rental Fort Myers United States, and short term rentals in Fort Myers.
Uncover and debunk rental properties Lee, vacation rentals Lee Florida, and homes for rent Lee.
Secure, join, and enter on Wednesday to inaugurate, kick off, and lead off on this route.
Invent, notice, and find out Taylor Florida rental properties and rent house Taylor.
You can dig up, look up, and hear houses for rent in Port St Lucie Florida and homes for rent Port St Lucie Florida.
See romantic classifieds, beach ads, hillside indexes, and ski in/out listings that rental property owners and property brokers post on our site, FRBO.com.
Explore and find out homes for rent in Lee Florida and Lee rental homes.
Enter upon your perquisition online day after tomorrow, tomorrow morning, or tomorrow afternoon for your house rentals Port St Lucie, rental apartment in Port St Lucie, and Port St Lucie house rentals.
Learn and find out vacation rental in Tavernier United States and holiday rentals Tavernier.
Find and detect rental properties in NASA Shuttle Facility and vacation homes for rent by owner.
Using our for rent by owner site, FRBO.com, land owners write down timeshare, cottage, condominium, and townhouse lists of marked properties.
Explore, dig up, and come upon Bronson United States homes for rent, vacation rentals in Bronson United States, and holiday rentals Bronson United States.
We instituted, effected, and actualize our for rent by owner website to be fascinating, sightly, radiant, and handsome.
Our for rent by owner site, FRBO.com subsumes zone and parcel knowledge, commonly.
Light upon and identify house rentals Howey in the Hills and real estate rentals Howey in the Hills.
Learn and disclose San Antonio condos for rent and San Antonio United States vacation homes for rent by owner.
Discover, recognize, and find out home rentals in Port Orange, rent houses Port Orange United States, and Port Orange United States homes for rent.
Detect, ascertain, and debunk rental apartment Lake Hamilton United States, Lake Hamilton for rent by owner homes, and Lake Hamilton United States real estate rentals.
Elicit and originate apartments for rent in Arcadia and rent houses.
Distinguish and invent Lee Florida home rentals and Lee Florida condo rentals.
|
|
