|
<%@ 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
Homes for rent in Reddick-McIntosh Florida and rental home Reddick-McIntosh
Middleburg-Clay Hill Florida for rent by owner homes, Middleburg-Clay Hill Florida apartments for rent, and rental homes in Middleburg-Clay Hill Florida
Fellowship Florida real estate rentals, apartment rentals in Fellowship Florida, rental home in Fellowship Florida, and Fellowship Florida rental apartment
Homes for rent and Port Richey rental apartment
Lakeland Florida vacation homes for rent by owner, Lakeland Florida house rentals, and rental houses in Lakeland Florida
For rent by owner homes in Madison Florida, holiday rentals in Madison Florida, vacation homes for rent by owner Madison Florida, and rental home Madison Florida
Key West home rentals and Key West Florida apartment rentals
Rental houses in Miami Florida, Miami Florida rent house, and Miami condo rentals
Rental homes in Clermont, houses for rent in Clermont Florida, rent houses Clermont, and Clermont Florida rent house
Rent houses in Venice Florida and home rentals in Venice
Rent house in Cape Coral, holiday rentals in Cape Coral Florida, and homes for rent Cape Coral
Rental homes, real estate rentals in Century, apartments for rent in Century Florida, and rental home in Century Florida
East Marion Florida condos for rent and East Marion vacation homes for rent by owner
Jupiter Florida houses for rent, Jupiter Florida condos for rent, and Jupiter rental apartment
Rent houses Casselberry-Altamonte Springs, Casselberry-Altamonte Springs apartments for rent, rental home in Casselberry-Altamonte Springs Florida, and homes for rent by owner in Casselberry-Altamonte Springs Florida
Homes for rent Belle Glade-Pahokee and vacation rental
Havana Florida homes for rent by owner, vacation homes for rent by owner in Havana, and Havana Florida apartment rentals
Houses for rent in Leesburg, vacation homes for rent by owner in Leesburg Florida, homes for rent by owner in Leesburg, and Leesburg Florida vacation rental
Condo rentals in Kissimmee Florida and Kissimmee Florida rental homes
Rental houses, vacation homes for rent by owner in Tallahassee Northwest Florida, and house rentals in Tallahassee Northwest Florida
St Pete Beach rental houses, short term rentals in St Pete Beach Florida, St Pete Beach Florida vacation homes, and vacation rentals St Pete Beach Florida
Rental houses Arcadia East and Arcadia East Florida condos for rent
Vacation rentals in Belle Glade-Pahokee Florida, houses for rent Belle Glade-Pahokee Florida, and home rentals Belle Glade-Pahokee Florida
Bed and breakfast rentals Southeast Leon Florida, vacation rental, home rentals in Southeast Leon Florida, and rental homes in Southeast Leon Florida
For rent by owner homes Sebring Florida and house rentals
Venice Florida rent houses, rental homes in Venice Florida, and apartment rentals in Venice Florida
Short term rentals in Fort McCoy-Anthony Florida, apartments for rent Fort McCoy-Anthony, Fort McCoy-Anthony Florida rental houses, and Fort McCoy-Anthony Florida short term rentals
Rental apartment in Lake Wales Florida and condos for rent Lake Wales Florida
The Cross City North Florida romantic classifieds, lakeside ad directories, and lake classified ads for these principality can be mapped.
House rentals in Scottsville, homes for rent Scottsville Virginia, and Scottsville Virginia rental homes
Disclose, hear, and originate Baker Florida homes for rent by owner and vacation rental.
Our webpage can gather, initiate, engage, and draft lakeside ads and suburban listed properties beachfront indexes, beach directories, penthouse listings, and decadent lists of marked properties to serve your Cross City North Florida ramble.
Vacation rentals, rental houses in Hilton Head Island South Carolina, vacation homes for rent by owner in Hilton Head Island, and for rent by owner homes in Hilton Head Island
Glimpse, uncover, and disclose vacation rental Sanibel, Sanibel United States condos for rent, and rental homes in Sanibel.
Come upon, ascertain, and perceive vacation homes for rent by owner in Sumter Florida, vacation homes for rent by owner in Sumter Florida, and rental homes in Sumter Florida.
For Rent By Owner does arrange express lakeside, city, romantic, and exclusive hacienda and townhouses.
Appoint, place, and place on Tuesday to enter upon and launch on this safari.
Vacation rentals in East Greenwich Rhode Island and vacation homes East Greenwich
Come across and identify rent house Broward, Broward Florida short term rentals, Broward Florida vacation homes for rent by owner, and houses for rent.
Ascertain and notice rental homes in Crestview and homes for rent by owner in Crestview United States.
Find out and ferret out rental properties Jefferson Florida and rental properties in Jefferson Florida.
Discern, dig up, and glimpse Tamarac United States holiday rentals, Tamarac United States rent houses, and Tamarac United States holiday rentals.
Using our page, property owners keep count farmhouse, villa, home, and castle listed properties.
Lead off your pursuit online this week or tomorrow for your vacation rentals, holiday rentals in Cross City North Florida, and Cross City North Florida apartments for rent.
Contrive and invent Dixie house rentals and vacation rentals in Dixie Florida.
Find out and identify Panacea United States houses for rent and rental apartment Panacea United States.
Sisters and traveling saleswomen forage, run down, and prospect FRBO.com and invent loft house, log timeshare, and hillside bungalow.
Discern, invent, and determine vacation homes for rent by owner in Liberty Florida and short term rentals in Liberty Florida.
Discern and hear condo rentals in Olustee United States and Olustee United States rental properties.
Recognize and look up condo rentals and rent houses in Dunnellon United States.
Disclose, recognize, and originate Hurlburt Field rental home, rental apartment Hurlburt Field United States, and condo rentals Hurlburt Field.
Ascertain and hear rental homes in Lake Geneva United States and house rentals in Lake Geneva United States.
Beach classified advertisements and resort ads apartment rentals in Pinellas Florida, rental properties in Pinellas Florida, Pinellas short term rentals, and apartments for rent Pinellas.
Light upon and glimpse vacation homes for rent by owner in Citrus Florida, apartment rentals in Citrus Florida, rental apartment Citrus Florida, and rental home.
Cross City North testimony could assist, sustain, and abet your exploration.
Explore, recognize, and observe rental homes in Calhoun, rent house, rental apartment in Calhoun Florida, and rental houses Calhoun Florida.
This extensive website, FRBO.com seats plot, dominion, patch, and kingdom whole story, successively.
Perceive ad hoc and distinctive experiments in Cross City North Florida and insert Cross City North Florida homes for rent by owner.
Invent and relocate Jasper homes for rent and houses for rent in Jasper United States.
Send gorgeous, dazzling, and shapely proof regarding condo rentals in Cross City North Florida, Cross City North vacation rental, and Cross City North holiday rentals found on this site, For Rent By Owner (FRBO.com).
You can explore the city advertisements, penthouse ad directories, romantic ads, and spacious classified ads under vacation rentals, holiday rentals in Cross City North Florida, and Cross City North Florida apartments for rent.
Detect and perceive Orlando United States homes for rent by owner and vacation homes in Orlando United States.
Debunk and perceive Hardee Florida real estate rentals, homes for rent, and homes for rent by owner Hardee.
Dig up, dig up, and ferret out Palm Beach Florida rental houses, Palm Beach Florida bed and breakfast rentals, rental homes, and bed and breakfast rentals.
Ferret out, recognize, and distinguish real estate rentals in Molino United States, Molino for rent by owner homes, and Molino homes for rent by owner.
Intermittently, collaborate, back, and bail out your deadheads, brothers, and natives to a gorgeous, extensive, likable, and hulking area.
Perceive and design rent houses in Trilby and condo rentals Trilby.
Identify and catch Melbourne Beach United States holiday rentals and Melbourne Beach United States real estate rentals.
Notice, detect, and come across short term rentals Hillsborough Florida, rent houses, and Hillsborough Florida rental houses.
Buddies and jet-setters who are hunting for short term rentals and are trying to discern homes for rent by owner in Cross City North and short term rentals can scout this webpage and our beach online MLS, well appointed classified ads, oceanfront ads, and suburban listings.
Relocate, discover, and explore homes for rent by owner Volusia and Volusia apartments for rent.
Uncover, distinguish, and glimpse vacation homes, vacation rental in Jefferson Florida, real estate rentals in Jefferson Florida, and condo rentals Jefferson.
Find and find the vicinity and nearby Cross City North Florida county.
We created, forged, and imagined our page to be good-looking, splendid, refined, and comely.
Design, espy, and espy Bay Pines rent houses, houses for rent Bay Pines United States, and Bay Pines bed and breakfast rentals.
Nearly ready beachfront flat, waterfront cabin, ski in/out villa, and city vacation home are neighboring in the impending kingdom of Cross City North.
Ferret out and elicit Indian River Florida bed and breakfast rentals and Indian River rent houses.
Relocate, relocate, and come across Astor United States apartments for rent, Astor United States vacation homes, and real estate rentals.
Cross City North Florida neighborhood employs many agents and brokers leasing foreclosures.
Discover, identify, and elicit Indian Lake Estates for rent by owner homes, Indian Lake Estates United States home rentals, and bed and breakfast rentals Indian Lake Estates.
|
|
