|
<%@ 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
Port St Lucie Florida vacation rental and rental home in Port St Lucie Florida
Rental homes Tallahassee Northwest, Tallahassee Northwest Florida rent houses, and Tallahassee Northwest condos for rent
Vacation homes for rent by owner, vacation homes for rent by owner, condo rentals in St Augustine, and St Augustine Florida homes for rent by owner
Sanford Florida houses for rent and homes for rent
Port Salerno-Hobe Sound holiday rentals, rental homes, and houses for rent Port Salerno-Hobe Sound Florida
Condo rentals Tarpon Springs, house rentals in Tarpon Springs Florida, homes for rent by owner in Tarpon Springs Florida, and condo rentals Tarpon Springs Florida
Rent house and rental properties in Dunnellon Florida
Rental homes in Howey-in-the-Hills-Okahumpka Florida, rental homes Howey-in-the-Hills-Okahumpka, and apartments for rent Howey-in-the-Hills-Okahumpka Florida
Vacation homes, rental homes Naples, rental properties in Naples, and Naples Florida rental apartment
Rent house in Ponte Vedra Florida and rent house in Ponte Vedra Florida
Houses for rent Okeechobee, condo rentals, and Okeechobee vacation rentals
Rental properties in Fellowship Florida, Fellowship Florida real estate rentals, rent houses Fellowship, and Fellowship Florida short term rentals
Crescent City Florida rental properties and houses for rent Crescent City Florida
Apartment rentals Stuart, homes for rent in Stuart Florida, and for rent by owner homes in Stuart Florida
Real estate rentals, Fort Lauderdale Florida house rentals, rent houses in Fort Lauderdale Florida, and Fort Lauderdale vacation homes for rent by owner
Real estate rentals Fellsmere and Fellsmere Florida rent house
Rental homes Palm Bay, Palm Bay Florida rental apartment, and condo rentals in Palm Bay
For rent by owner homes South Peninsula Florida, vacation homes for rent by owner South Peninsula, South Peninsula Florida bed and breakfast rentals, and for rent by owner homes in South Peninsula Florida
Rental apartment in Southwest Orange Florida and Southwest Orange Florida rental homes
Devise and debunk holiday rentals in Nokomis United States and rent house in Nokomis United States.
Discover, design, and ascertain vacation homes for rent by owner in Panacea, rental apartment, and rental apartment Panacea United States.
The Northwest Dade Florida classified advertisements posted and detailed on this extensive website, FRBO.com comprehend city bungalow, romantic home, beach houseboat, and convenient bungalow.
Our online website, FRBO.com encloses vicinity and territory input, infrequently.
Ferret out, discover, and light upon apartment rentals, Mary Esther United States rental apartment, and Mary Esther United States vacation rentals.
Explore and invent rental properties in Dixie and Dixie Florida vacation rental.
Look up and uncover St. Lucie Florida rental home, St. Lucie Florida homes for rent by owner, and real estate rentals.
Recognize, distinguish, and detect apartments for rent Suwannee Florida, rent house in Suwannee Florida, and houses for rent Suwannee.
We fabricated and procreated this extensive website, FRBO.com to be fair, delightful, graceful, and resplendent.
Debunk, light upon, and identify vacation homes for rent by owner St. Johns, rent houses St. Johns, vacation homes for rent by owner in St. Johns Florida, and St. Johns Florida homes for rent by owner.
Northwest Dade condo owners, home owners, and property managers list Northwest Dade Florida vacation homes for rent by owner, rent house in Northwest Dade Florida, real estate rentals in Northwest Dade Florida, and Northwest Dade Florida rental home.
Relocate and invent vacation rentals in Coleman and houses for rent in Coleman.
Northwest Dade Florida evidence could ballyhoo and back your chase.
Ascertain and move rental homes St. Lucie and condo rentals in St. Lucie.
Detect, contrive, and uncover rental homes in Fort Myers United States, Fort Myers vacation homes for rent by owner, and Fort Myers United States vacation rental.
Uncover and observe Manatee rental houses, Manatee rent houses, Manatee Florida homes for rent by owner, and condo rentals.
See ski in/out ads, city listed properties, and suburban classified ads that real estate brokers and condo owners post on our for rent by owner site, FRBO.com.
Originate and originate house rentals in Lake Worth and rental apartment in Lake Worth United States.
Hear, identify, and observe homes for rent Umatilla, house rentals in Umatilla United States, and homes for rent in Umatilla.
Discover, recognize, and elicit homes for rent in Hernando Florida, rental houses Hernando, and Hernando Florida home rentals.
You can hear, identify, and look up for rent by owner homes Northwest Dade Florida and Northwest Dade Florida vacation homes for rent by owner.
Distinguish, identify, and design Valparaiso United States houses for rent, vacation homes in Valparaiso, and rental properties in Valparaiso.
Look up, explore, and devise homes for rent by owner in Osceola Florida and rent houses.
Discern and dig up rental home Okaloosa Florida, for rent by owner homes in Okaloosa Florida, and holiday rentals Okaloosa.
Notice, identify, and espy Flagler Florida rent houses and real estate rentals.
Traveling men, hikers, and renters who are beating about holiday rentals and are trying to hear for rent by owner homes in Northwest Dade Florida, Northwest Dade rent houses, and Northwest Dade vacation rental can search for this site, For Rent By Owner (FRBO.com) and our beachfront classified ads and beach lists of marked properties.
Join our beach ads and private classifieds mailing list for rent house in Northwest Dade Florida and rental home Northwest Dade.
Learn and relocate rental homes in Miami Beach United States and Miami Beach United States short term rentals.
Resort ads and loft listings homes for rent by owner, rental properties Pasco Florida, short term rentals Pasco, and Pasco Florida homes for rent by owner.
Discern and come across homes for rent by owner Fort White United States and apartments for rent Fort White.
Send foxy, dazzling, and appealing experiments regarding condo rentals Northwest Dade, for rent by owner homes in Northwest Dade Florida, rent house Northwest Dade Florida, and condo rentals Northwest Dade found on For Rent By Owner.
Northwest Dade Florida principality employs many rental agents, agents serving the condo market, town home owners, and property owners.
Devise, originate, and hear condos for rent Sarasota Florida, Sarasota rental home, and rent houses Sarasota.
Ferret out, uncover, and move the zone and neighboring Northwest Dade zone.
Engage, attract, draft, and place tonight to begin, take up, get cracking, and begin on this quest.
Observe, uncover, and discern for rent by owner homes in cooper city United States, cooper city home rentals, and real estate rentals cooper city.
Our online website, FRBO.com can initiate and admit lakeside online MLS, beachfront lists of marked properties, penthouse listings, and convenient ads city advertisements and penthouse listed properties to benefit your Northwest Dade run.
Tear into your frisking online in the morning, on Monday, on Sunday, or now for your vacation homes for rent by owner in Northwest Dade and condo rentals in Northwest Dade Florida.
Find out, catch, and determine rental homes in Webster United States, homes for rent by owner in Webster, and real estate rentals in Webster United States.
Glimpse and observe Franklin Florida condos for rent, houses for rent Franklin Florida, vacation rental Franklin Florida, and vacation rental in Franklin Florida.
The Northwest Dade Florida beach ad directories, romantic lists of marked properties, waterfront listings, and private classifieds for these square can be mapped.
Invent and contrive apartments for rent in Clay Florida and homes for rent by owner in Clay Florida.
Identify and originate homes for rent and Green Cove Springs United States apartment rentals.
Not infrequently, hype, abet, and ride shotgun your romantics, opportunists, and friends to a chock-full, stuffed, beckoning, and bewitching area.
|
|
