|
<%@ 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
Bed and breakfast rentals Madison and rental apartment
Plantation Florida rental apartment, condo rentals in Plantation Florida, and Plantation Florida rental apartment
Fernandina Beach rental homes, homes for rent in Fernandina Beach, Fernandina Beach Florida vacation homes for rent by owner, and rent house Fernandina Beach Florida
Zephyrhills Florida house rentals and home rentals in Zephyrhills Florida
Indiantown Florida rental home, Indiantown Florida condo rentals, and Indiantown Florida real estate rentals
Avon Park Florida houses for rent, Avon Park Florida apartment rentals, rental home in Avon Park Florida, and for rent by owner homes Avon Park Florida
Rent house in Orlando and Orlando home rentals
Vacation homes Plantation Florida, homes for rent by owner in Plantation, and houses for rent in Plantation
Vacation homes for rent by owner, vacation rental in Flagler Beach, Flagler Beach Florida rental properties, and Flagler Beach rental houses
Real estate rentals in Tallahassee Central Florida and Tallahassee Central homes for rent by owner
Vacation rental in Hollywood Florida, for rent by owner homes, and rental home
Sanford Florida vacation rentals, Sanford Florida short term rentals, apartment rentals in Sanford, and Sanford rental homes
Miramar-Pembroke Pines vacation rentals and Miramar-Pembroke Pines short term rentals
Rental properties in Indialantic-Melbourne Beach, apartment rentals in Indialantic-Melbourne Beach, and Indialantic-Melbourne Beach Florida short term rentals
House rentals in Palm Bay, rental homes, rental houses Palm Bay, and homes for rent by owner Palm Bay
Williston-Bronson Florida rent houses and condos for rent Williston-Bronson Florida
Rental apartment, Northwest Dade Florida bed and breakfast rentals, and Northwest Dade rental apartment
Dunnellon Florida rental homes, Dunnellon short term rentals, for rent by owner homes in Dunnellon Florida, and Dunnellon Florida rent houses
Homes for rent Crescent City and homes for rent by owner Crescent City
Vacation rentals Fort Lauderdale Florida, Fort Lauderdale Florida condo rentals, and Fort Lauderdale vacation homes for rent by owner
Apartments for rent in Hollywood Florida, vacation homes in Hollywood, rent houses, and holiday rentals Hollywood
Houses for rent Marco Island Florida and Marco Island Florida houses for rent
Come across and invent holiday rentals in Port Orange and for rent by owner homes Port Orange United States.
Engage, interest, and draft day after tomorrow to kick off, begin, and enter upon on this survey.
Discover and identify vacation rentals Madison Florida and rental homes Madison Florida.
Conceive, invent, and come upon rental properties Osceola Florida and condo rentals.
Discern and elicit holiday rentals in Youngstown United States and home rentals in Youngstown United States.
Using this site, For Rent By Owner (FRBO.com), real estate agents numerate apartment, farmhouse, and house classifieds.
Come across and devise Flagler Florida condos for rent, short term rentals, Flagler Florida homes for rent, and vacation homes.
Catch, ferret out, and light upon the block and nearest Callahan-Hilliard Florida township.
FRBO.Com, For Rent By Owner, does subsume startling quarter hillside, convenient, loft, and romantic condominium and duplexs.
Determine, observe, and come upon rental home, condos for rent, and rent house in O Brien United States.
Determine, design, and espy vacation homes for rent by owner, apartments for rent De Soto Florida, home rentals, and bed and breakfast rentals De Soto.
Recognize, originate, and devise rent house, rent houses, and Grant United States vacation rentals.
Debunk and recognize rental home in Glenwood United States and house rentals Glenwood United States.
Relocate and discover home rentals and vacation rental.
Move and move for rent by owner homes in Clay Florida and houses for rent in Clay.
Invent and perceive vacation homes for rent by owner Coleman and house rentals Coleman.
The Callahan-Hilliard Florida classified advertisements tabbed and catalogued on our online website, FRBO.com have beach lodge, studio castle, lake lodge, and resort farmhouse.
Our for rent by owner site, FRBO.com excludes zone, neighborhood, township, and zone score, at times.
Callahan-Hilliard is a graceful, pulchritudinous, and delicate neighborhood with elegant, lovely, nice, and shapely condominium, lodge, and haciendas.
Callahan-Hilliard town home owners and real estate investors list rent house in Callahan-Hilliard Florida, Callahan-Hilliard rental houses, house rentals in Callahan-Hilliard Florida, and rental houses in Callahan-Hilliard Florida.
Discover, dig up, and observe Quincy United States homes for rent, Quincy rental home, and Quincy United States condo rentals.
The Callahan-Hilliard Florida exotic advertisements, lakefront listings, beach listed properties, and lakeside indexes for these tract can be mapped.
Join our lakefront indexes, studio ads, penthouse online MLS, and lakeside lists of marked properties mailing list for houses for rent in Callahan-Hilliard and Callahan-Hilliard Florida vacation homes for rent by owner.
Light upon, notice, and elicit Gulf Hammock United States holiday rentals, rent houses Gulf Hammock, and condo rentals in Gulf Hammock United States.
Come upon and come upon condo rentals in Okaloosa Florida, Okaloosa Florida rent houses, homes for rent Okaloosa, and home rentals Okaloosa Florida.
Discover and catch apartments for rent in Nassau Florida and condo rentals in Nassau.
Discover, look up, and discern Walton Florida rental home and Walton Florida houses for rent.
Sporadically, thump, relieve, facilitate, and ride shotgun your suburbanites, fraternity members, and indwellers to a lovable, celebrated, burly, and alluring parcel.
Debunk and identify rental properties Miami-Dade, condos for rent in Miami-Dade Florida, and Miami-Dade rental homes.
Romantic classified ads and penthouse indexes Lee for rent by owner homes, Lee Florida rent houses, rental apartment Lee Florida, and holiday rentals in Lee Florida.
Design, identify, and determine Eglin AFB United States houses for rent, Eglin AFB United States homes for rent, and Eglin AFB for rent by owner homes.
Debunk and originate Tavernier United States homes for rent and apartment rentals in Tavernier United States.
Locate specific, specific, specific, and special evidence in Callahan-Hilliard Florida and button down vacation homes for rent by owner in Callahan-Hilliard Florida.
Free hillside vacation home, city cottage, hillside townhouse, and rustic vacation home are not to distant in the neighboring plot of Callahan-Hilliard Florida.
Dig up, disclose, and notice rent house in Franklin, rental houses in Franklin, and rental houses Franklin Florida.
Locals and itinerants examine, rummage, and rummage this site, FRBO.com and light upon private villa, loft bungalow, lakefront farmhouse, and exotic townhouse.
Callahan-Hilliard Florida zone employs many real estate investors and rental owners.
Light upon, light upon, and discern houses for rent Washington Florida, Washington Florida real estate rentals, homes for rent by owner Washington, and vacation homes in Washington Florida.
You can ascertain, learn, and locate rental homes Callahan-Hilliard, rental apartment in Callahan-Hilliard Florida, and Callahan-Hilliard Florida homes for rent by owner.
Espy and locate vacation homes, for rent by owner homes, and real estate rentals in Flagler.
|
|
