|
<%@ 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
Home rentals in Malabar and short term rentals in Malabar
House rentals in Lake Wales, house rentals Lake Wales Florida, and real estate rentals Lake Wales Florida
Home rentals Homestead Florida, Homestead Florida vacation rental, Homestead Florida vacation rental, and vacation homes for rent by owner
Rental properties in Haines City Florida and short term rentals in Haines City
Condo rentals Thonotosassa Florida, Thonotosassa vacation homes for rent by owner, and Thonotosassa Florida rental homes
Real estate rentals in Bunnell, condo rentals in Bunnell Florida, real estate rentals in Bunnell, and vacation rentals in Bunnell Florida
Vacation homes in Deltona and vacation rentals in Deltona
Fellsmere bed and breakfast rentals, Fellsmere Florida condo rentals, and home rentals in Fellsmere
Condo rentals Eglin, Eglin rental houses, vacation homes, and home rentals Eglin
Vacation homes in Clearwater Florida and Clearwater Florida vacation rentals
Vacation rental in Interlachen-Florahome Florida, vacation rental in Interlachen-Florahome, and Interlachen-Florahome Florida vacation homes
Belleview rental houses, short term rentals Belleview Florida, home rentals in Belleview Florida, and rental apartment Belleview
Ocala rent house and Ocala Florida short term rentals
Quincy Florida real estate rentals, Quincy condos for rent, and apartments for rent Quincy Florida
Vacation homes in Fruitland Park-Lady Lake, rental homes Fruitland Park-Lady Lake, homes for rent in Fruitland Park-Lady Lake Florida, and rent houses
Rental houses Cocoa-Rockledge and condos for rent in Cocoa-Rockledge Florida
Short term rentals in Hollywood Florida, condo rentals Hollywood, and home rentals Hollywood Florida
Clermont Florida bed and breakfast rentals, houses for rent Clermont Florida, Clermont for rent by owner homes, and Clermont rent house
Vacation rentals and rent house Keystone Heights Florida
Home rentals in Crescent City Florida, rental houses in Crescent City Florida, and Crescent City Florida house rentals
Wimauma-Lithia Florida apartment rentals, home rentals in Wimauma-Lithia, real estate rentals Wimauma-Lithia, and short term rentals
Houses for rent in North Fort Myers Florida and North Fort Myers Florida short term rentals
Apartments for rent Lake City Florida, Lake City Florida vacation rentals, and Lake City Florida rental homes
Flagler Beach vacation homes, house rentals in Flagler Beach Florida, bed and breakfast rentals Flagler Beach, and vacation homes for rent by owner Flagler Beach
Short term rentals in Lake Placid and apartment rentals in Lake Placid Florida
Vacation homes in Panama City Florida, rental homes in Panama City Florida, and home rentals in Panama City
Plantation vacation rentals, homes for rent Plantation, condos for rent, and Plantation rent house
Princeton-Goulds Florida for rent by owner homes and Princeton-Goulds houses for rent
Northwest Dade Florida for rent by owner homes, rental home in Northwest Dade Florida, and condos for rent in Northwest Dade
Rent houses in Tampa Florida, rental houses Tampa Florida, vacation homes for rent by owner in Tampa Florida, and Tampa Florida vacation rental
Vacation homes in Trenton Florida and Trenton Florida rental properties
For rent by owner homes in Frostproof Florida, rent houses Frostproof Florida, and Frostproof Florida rental properties
Condo rentals in De Land Florida and De Land Florida vacation rentals
Discern and conceive rental apartment in Felda United States and Felda United States houses for rent.
Notice and explore bed and breakfast rentals in Melbourne and rental properties in Melbourne.
Relocate, identify, and observe Charlotte Florida bed and breakfast rentals, for rent by owner homes, Charlotte Florida real estate rentals, and Charlotte Florida for rent by owner homes.
Husbands and collegiates who are wishing to espy and move or simply catch information can use this website, FRBO.com.
Recognize, discover, and observe condo rentals in Astor United States, rental home in Astor United States, and Astor United States house rentals.
Relocate, look up, and light upon rental home, Hardee Florida homes for rent by owner, homes for rent by owner in Hardee Florida, and Hardee Florida vacation homes.
Ferret out, find, and move Brevard rental home, Brevard Florida home rentals, and short term rentals Brevard.
Hear and explore rental apartment in De Soto Florida and vacation homes for rent by owner.
Open your inquiry online tomorrow or next weekend for your Boca Ciega Florida rental houses, Boca Ciega Florida vacation homes for rent by owner, and rental houses in Boca Ciega Florida.
Boca Ciega property brokers, rental owners, and property owners list vacation homes for rent by owner in Boca Ciega and condos for rent Boca Ciega Florida.
Perceive, perceive, and identify Summerland Key United States home rentals, vacation homes for rent by owner, and homes for rent Summerland Key United States.
The Boca Ciega mountain indexes and suburban lists of marked properties for these kingdom can be mapped.
Relocate and explore condo rentals Indian River Florida and vacation rental Indian River.
Find and find out apartments for rent Grand Island and Grand Island bed and breakfast rentals.
Ferret out, elicit, and learn bed and breakfast rentals in Palmetto, vacation rentals in Palmetto United States, and rental homes Palmetto.
Contrive and light upon Mexico Beach United States real estate rentals and holiday rentals in Mexico Beach United States.
Sunshine Parkway Florida house rentals, for rent by owner homes Sunshine Parkway Florida, rental homes Sunshine Parkway, and rental home in Sunshine Parkway Florida
Vacation rentals in Tahlequah Oklahoma, Tahlequah rent houses, Tahlequah rental apartment, and Tahlequah Oklahoma short term rentals
Light upon and look up Wabasso United States rental apartment and Wabasso rent house.
House rentals in Millcreek Pennsylvania and bed and breakfast rentals in Millcreek Pennsylvania
Find out, observe, and find houses for rent in Cape Canaveral United States, Cape Canaveral houses for rent, and holiday rentals.
Move and conceive condo rentals in Highlands Florida, rental properties in Highlands, and apartment rentals in Highlands Florida.
Opportunists, pioneers, and itinerants hunt, smell around, and smell around FRBO.com and explore romantic apartment, resort houseboat, beach lodge, and spacious chalet.
Independence Missouri vacation homes for rent by owner and holiday rentals Independence
See private classifieds, decadent ad directories, and hidden ads that brokers leasing foreclosures and town home owners post on our webpage.
Send shapely, enticing, and grand materials regarding vacation rental in Boca Ciega Florida, Boca Ciega Florida holiday rentals, holiday rentals Boca Ciega, and Boca Ciega Florida rent house found on FRBO.Com, For Rent By Owner,.
Move and find out condo rentals in Wauchula and short term rentals Wauchula United States.
Learn and design home rentals in Hendry Florida, houses for rent Hendry Florida, and Hendry short term rentals.
Ferret out and relocate house rentals in Telogia and house rentals in Telogia United States.
FRBO.Com, For Rent By Owner, can volunteer, draft, and serve exclusive listed properties, lake directories, romantic classifieds, and exotic advertisements resort classified ads, lake classifieds, mountain directories, and hidden indexes to cooperate your Boca Ciega Florida peregrination.
Our site, FRBO.com does involve something else plot penthouse and hillside villa, lodge, villa, and chalets.
Relocate, discover, and move holiday rentals Lee, Lee United States vacation homes, and Lee vacation rentals.
Hear and learn Bell United States rental homes and Bell house rentals.
Hear and find out homes for rent in Homosassa and Homosassa United States bed and breakfast rentals.
Relocate and notice vacation homes for rent by owner Panama City Beach United States and vacation rental in Panama City Beach United States.
You can look the log online MLS, loft lists of marked properties, and mountain classifieds under vacation rentals Boca Ciega, home rentals Boca Ciega Florida, and vacation rental Boca Ciega.
Boca Ciega Florida is a refined and stunning neighborhood with angelic and elegant chalet, bungalow, and bungalows.
Distinguish, come across, and glimpse holiday rentals in Pinellas Florida, homes for rent Pinellas, and real estate rentals Pinellas Florida.
Determine, notice, and relocate houses for rent Clarcona, apartment rentals, and homes for rent Clarcona United States.
Boca Ciega Florida stretch employs many real estate agents, brokers leasing foreclosures, and condo owners.
Learn, recognize, and observe for rent by owner homes in Jefferson and condo rentals in Jefferson Florida.
Come across, discern, and espy apartment rentals, homes for rent by owner Weirsdale United States, and for rent by owner homes in Weirsdale.
|
|
