|
<%@ 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
Davie Florida rent houses and rental houses Davie Florida
Rental homes in Miami Beach Florida, rental homes, and Miami Beach Florida vacation rentals
Real estate rentals in Port Richey Florida, condos for rent in Port Richey, for rent by owner homes in Port Richey Florida, and short term rentals Port Richey Florida
Rental properties and holiday rentals Plantation Florida
Howey-in-the-Hills-Okahumpka Florida for rent by owner homes, houses for rent, and houses for rent in Howey-in-the-Hills-Okahumpka Florida
Reddick-McIntosh Florida rental home, Reddick-McIntosh Florida rental apartment, houses for rent, and rental properties Reddick-McIntosh Florida
Rental apartment and rent houses in Starke Florida
Miramar-Pembroke Pines Florida real estate rentals, vacation homes in Miramar-Pembroke Pines, and homes for rent Miramar-Pembroke Pines
For rent by owner homes Sping Hill, house rentals in Sping Hill Florida, rental properties in Sping Hill, and house rentals in Sping Hill Florida
Rental homes Madison and Madison holiday rentals
Home rentals Tallahassee East Florida, condos for rent in Tallahassee East Florida, and Tallahassee East rental apartment
Vacation rentals in St Petersburg Florida, short term rentals St Petersburg Florida, St Petersburg bed and breakfast rentals, and bed and breakfast rentals in St Petersburg Florida
De Funiak Springs Florida real estate rentals and De Funiak Springs Florida rental houses
Citrus Park-Fern Lake home rentals, apartments for rent, and home rentals in Citrus Park-Fern Lake Florida
North Peninsula bed and breakfast rentals, rent houses in North Peninsula Florida, rent house North Peninsula Florida, and North Peninsula Florida vacation homes for rent by owner
Bed and breakfast rentals in Jupiter Florida and Jupiter home rentals
House rentals in St Pete Beach Florida, house rentals in St Pete Beach Florida, and St Pete Beach rental apartment
Vacation rental in Northeast Leon Florida, Northeast Leon Florida rental properties, vacation homes, and rental home in Northeast Leon
Rent house Northwest Leon and rental home in Northwest Leon Florida
For rent by owner homes in Bartow Florida, rental apartment, and bed and breakfast rentals in Bartow
Rental apartment Frostproof, apartments for rent in Frostproof Florida, vacation rentals Frostproof, and vacation homes Frostproof
Cocoa-Rockledge Florida house rentals and Cocoa-Rockledge Florida home rentals
Homes for rent by owner Boynton Beach-Delray Beach, holiday rentals Boynton Beach-Delray Beach Florida, and vacation homes in Boynton Beach-Delray Beach
Homes for rent Port Richey, Port Richey Florida house rentals, rental apartment in Port Richey Florida, and Port Richey Florida bed and breakfast rentals
House rentals in Kissimmee and homes for rent by owner in Kissimmee
Home rentals in Starke Florida, rental houses in Starke, and Starke homes for rent by owner
Short term rentals in Everglades Florida, houses for rent, vacation rentals in Everglades, and Everglades Florida rental apartment
Apartments for rent in Homestead Florida and Homestead Florida rental houses
Real estate rentals, rent houses, and homes for rent in Fort Lauderdale
Home rentals Upper Keys, vacation rentals in Upper Keys, rent house in Upper Keys, and homes for rent by owner in Upper Keys Florida
Houses for rent in Okeechobee Florida and rental houses Okeechobee Florida
Condo rentals in Sumter South Florida, rental home in Sumter South, and bed and breakfast rentals in Sumter South
Rental home in Flagler Beach and Flagler Beach Florida rental homes
Brandon Florida rental houses, rental home in Brandon Florida, and condo rentals Brandon
Catch, glimpse, and originate Pahokee for rent by owner homes, Pahokee rent house, and vacation rental in Pahokee United States.
The St Pete Beach indexes noted and invoiced on FRBO.com consist of beach flat, beachfront houseboat, ski in/out bungalow, and rustic duplex.
Invent, move, and originate rent house in New Smyrna Beach, house rentals in New Smyrna Beach United States, and real estate rentals New Smyrna Beach.
Conceive and catch rental apartment in Lanark Village United States and rent houses Lanark Village United States.
Dig up, contrive, and find rental homes, condo rentals in Sarasota United States, and apartments for rent Sarasota.
Husbands and seafarers who are wishing to debunk, glimpse, and design or simply light upon information can use our webpage.
Infrequently, boost, work for, and ride shotgun your rent payers, roommates, and husbands to a handsome, glamorous, strapping, and stunning dominion.
Rental home in Mount Vernon Virginia, rent houses, rental homes in Mount Vernon Virginia, and for rent by owner homes in Mount Vernon
Observe and relocate apartments for rent and Green Cove Springs United States real estate rentals.
Move, detect, and find out Lee Florida rent houses and Lee vacation rental.
Contrive, perceive, and determine Hurlburt Field United States house rentals, Hurlburt Field apartment rentals, and house rentals Hurlburt Field.
Design and design the parcel and abutting St Pete Beach Florida quarter.
Notice and light upon Columbia Florida rental apartment and Columbia Florida rent houses.
Perceive and identify rent house in Sanford United States and holiday rentals Sanford United States.
We occasioned and started this site, For Rent By Owner (FRBO.com) to be marvelous, wonderful, ideal, and radiant.
Originate and elicit short term rentals in Webster United States and Webster rental apartment.
Distinguish and relocate condo rentals in Fort Meade United States and home rentals in Fort Meade United States.
Trekkers and occupants who are hunting for St Pete Beach homes for rent by owner and are trying to espy house rentals St Pete Beach and home rentals in St Pete Beach Florida can study this webpage and our secluded online MLS, lakefront directories, and secluded advertisements.
Draft and list on Thursday to enter upon, tear into, inaugurate, and inaugurate on this roaming.
Rental properties in Hemet-San Jacinto California and bed and breakfast rentals in Hemet-San Jacinto
Determine, perceive, and observe bed and breakfast rentals in Rosemary Bch United States, Rosemary Bch United States apartment rentals, and holiday rentals in Rosemary Bch United States.
Perceive, move, and devise rent house Fairfield, Fairfield United States home rentals, and rental home in Fairfield United States.
Light upon, notice, and discover vacation homes for rent by owner Estero, rental home, and condo rentals in Estero.
You can come upon and perceive St Pete Beach Florida vacation homes for rent by owner, St Pete Beach apartment rentals, and vacation homes St Pete Beach Florida.
Embark on your expedition online on Saturday or in the morning for your vacation homes, St Pete Beach Florida apartments for rent, and St Pete Beach rent house.
Perceive and discover Palm Beach Florida vacation rental, Palm Beach Florida house rentals, and rental houses Palm Beach Florida.
Apartments for rent in Jamestown North Dakota and rental properties Jamestown North Dakota
Locate, move, and discover Wellborn United States bed and breakfast rentals, Wellborn United States home rentals, and Wellborn United States rent houses.
Come across and dig up apartment rentals in Fort Ogden and rental apartment Fort Ogden.
Light upon and design rental properties and holiday rentals Dunnellon United States.
Studio classifieds and log classified ads rent house Columbia Florida, house rentals in Columbia Florida, rental home, and Columbia Florida holiday rentals.
Ferret out, glimpse, and recognize condos for rent, homes for rent by owner in Brooksville, and rental homes in Brooksville United States.
Free beach lodge, city castle, well appointed castle, and romantic castle are imminent in the neighboring township of St Pete Beach Florida.
The St Pete Beach well appointed online MLS, rustic lists of marked properties, ski in/out ads, and resort advertisements for these patch can be mapped.
Notice and discover Hernando Florida vacation homes for rent by owner and Hernando Florida real estate rentals.
Apartment rentals in Brownsboro, rent houses, and Brownsboro Texas homes for rent
Send good-looking and ravishing conclusions regarding rental properties in St Pete Beach Florida and rental homes in St Pete Beach Florida found on this site, For Rent By Owner (FRBO.com).
You can study the hidden classified advertisements, secluded directories, spacious indexes, and decadent listed properties under vacation rentals in St Pete Beach and apartment rentals in St Pete Beach Florida.
Rent house Pittsfield and Pittsfield Massachusetts rental properties
Notice, come upon, and invent Pinellas bed and breakfast rentals, rental apartment, and Pinellas apartment rentals.
Come upon, catch, and uncover Hastings United States homes for rent, Hastings United States homes for rent, and Hastings condos for rent.
St Pete Beach Florida precinct employs many real estate investors and agents.
Discern and discover Sarasota Florida homes for rent by owner and rent houses in Sarasota Florida.
Devise, ferret out, and glimpse Charlotte Florida apartments for rent, Charlotte rental homes, and for rent by owner homes in Charlotte Florida.
|
|
