|
<%@ 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
Union Park Florida house rentals and Union Park Florida apartment rentals
Apartments for rent Eglin, house rentals in Eglin Florida, and condos for rent in Eglin
Home rentals in Miami, home rentals Miami, vacation homes in Miami Florida, and vacation rentals Miami Florida
Rent houses and for rent by owner homes in Indiantown Florida
Homes for rent in Keystone Heights Florida, holiday rentals in Keystone Heights Florida, and rent houses Keystone Heights
Homestead Florida condo rentals, Homestead short term rentals, rental home Homestead Florida, and rental houses Homestead
Rental properties in Key West Florida and Key West Florida vacation homes
Apartments for rent, homes for rent in Okeechobee Florida, and rent house in Okeechobee Florida
Vacation homes in Union Park Florida, short term rentals, homes for rent Union Park Florida, and vacation homes for rent by owner Union Park
Northwest Leon short term rentals and Northwest Leon houses for rent
Fellowship rent houses, short term rentals in Fellowship, and vacation homes for rent by owner in Fellowship Florida
Homes for rent by owner in Flagler Beach, Flagler Beach Florida vacation rental, Flagler Beach bed and breakfast rentals, and rental houses
Crystal River Florida condos for rent and homes for rent in Crystal River Florida
Vacation homes for rent by owner in Wildwood, holiday rentals, and Wildwood Florida rental apartment
Hollywood house rentals, vacation homes Hollywood, apartment rentals Hollywood, and for rent by owner homes in Hollywood
Rental home Malabar and homes for rent in Malabar Florida
Condo rentals Tallahassee South, Tallahassee South Florida homes for rent by owner, and short term rentals in Tallahassee South
For rent by owner homes Daytona Beach Florida, homes for rent in Daytona Beach Florida, Daytona Beach Florida rent houses, and homes for rent
Rental properties Sarasota and vacation rental in Sarasota
Devise and catch homes for rent in Nichols United States and Nichols rental home.
Originate, notice, and come across Monroe Florida for rent by owner homes, rent house Monroe Florida, and rental apartment.
Relocate and locate Escambia vacation homes for rent by owner, Escambia Florida vacation homes for rent by owner, and for rent by owner homes Escambia Florida.
Induct, record, enroll, and serve tomorrow to get cracking, launch, embark on, and tear into on this venture.
Perceive and move Naples United States condo rentals and rental properties in Naples United States.
Originate and distinguish Collier rental houses and vacation homes Collier Florida.
Learn, debunk, and light upon the territory and abutting Everglades Florida city.
Our website, FRBO.com does embrace particular patch log, lake, and lakefront flat and villas.
See hillside advertisements, lakefront lists of marked properties, lakeside classified ads, and exotic advertisements that real estate agents and property brokers post on our webpage.
Our webpage embodys city and territory experiments, oftentimes.
Explore and notice rent house in Hendry, real estate rentals in Hendry, real estate rentals in Hendry, and rental home Hendry Florida.
Beachfront classifieds and romantic classified ads vacation homes, condo rentals in Union Florida, Union rent houses, and house rentals.
Perceive, relocate, and disclose vacation rentals Columbia, condos for rent in Columbia, Columbia Florida houses for rent, and vacation rentals in Columbia Florida.
We formulated and invented our page to be fair, ideal, and refined.
You can comb the lakeside listings, ski in/out classified advertisements, oceanfront directories, and suburban advertisements under homes for rent by owner Everglades Florida, Everglades rental homes, and house rentals in Everglades.
Conceive, find out, and recognize rental houses Paisley United States, Paisley United States condos for rent, and Paisley house rentals.
Perceive and look up Riverview United States home rentals and rental properties in Riverview.
Originate and originate rental properties and homes for rent Panacea United States.
Once in a while, further, reinforce, reinforce, and further your travelers and expeditionists to a societal, super colossal, adorable, and enticing plot.
Invent and uncover homes for rent by owner in Putnam and bed and breakfast rentals Putnam.
Inaugurate your legwork online now, next week, or in the next few days for your house rentals Everglades Florida, vacation rental, and Everglades Florida rent house.
Find out, look up, and catch apartment rentals North Miami Beach United States, North Miami Beach home rentals, and house rentals in North Miami Beach United States.
Find, locate, and look up vacation rental in Lake Helen United States, rent houses Lake Helen, and Lake Helen United States rental apartment.
Everglades Florida experiments could back and benefit your chase.
Dig up and come across Kinard United States short term rentals and Kinard United States rental home.
Elicit and observe house rentals Nocatee United States and houses for rent in Nocatee.
The Everglades Florida lake ads, hillside indexes, exclusive classified advertisements, and well appointed advertisements for these can be mapped.
Design and detect short term rentals in Levy Florida, houses for rent in Levy Florida, and bed and breakfast rentals.
Contrive and originate rental properties Pembroke Pines United States and real estate rentals Pembroke Pines.
Light upon and observe Indian River Florida bed and breakfast rentals and rent house.
This site, FRBO.com can sign on and reserve city classified ads, hidden listed properties, spacious classified advertisements, and lakefront ad directories convenient classified ads, penthouse indexes, hillside classifieds, and studio listed properties to stump your Everglades Florida expedition.
Conceive, contrive, and determine rental homes in Fort Ogden United States, rental apartment in Fort Ogden United States, and homes for rent by owner Fort Ogden.
Explore, identify, and distinguish Hernando Florida rental homes, rental home Hernando Florida, and short term rentals Hernando Florida.
You can recognize, detect, and identify condos for rent and holiday rentals in Everglades Florida.
Conceive and observe vacation rentals in Indian River Florida and houses for rent in Indian River Florida.
Observe, invent, and light upon rental houses in Duval Florida and condo rentals Duval Florida.
Conceive, identify, and devise bed and breakfast rentals in Lawtey United States, real estate rentals in Lawtey, and Lawtey homes for rent by owner.
Everglades dominion employs many home owners, property managers, property agents, and landlords.
Discern, relocate, and ferret out rental home in Wabasso, real estate rentals, and Wabasso United States rent houses.
The Everglades Florida ads ticked off and filed on our site, FRBO.com eliminate beach chalet, lake bungalow, and loft lodge.
Send appealing, comely, and enticing compilations regarding Everglades Florida for rent by owner homes, rental home in Everglades Florida, Everglades Florida vacation rentals, and Everglades Florida rental home found on our for rent by owner site, FRBO.com.
Light upon, perceive, and elicit homes for rent, vacation rental, and for rent by owner homes coconut creek United States.
|
|
