|
<%@ 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
Rental houses in St Cloud Florida and rental homes in St Cloud Florida
Myakka Florida vacation rental, rental home Myakka Florida, and Myakka rent house
Rent houses in Boca Ciega Florida, vacation rental in Boca Ciega Florida, apartments for rent in Boca Ciega Florida, and Boca Ciega condos for rent
Rental home in Frostproof Florida and home rentals
Bed and breakfast rentals Sping Hill Florida, Sping Hill Florida vacation rental, and short term rentals Sping Hill Florida
Real estate rentals in Tallahassee Central, vacation rental Tallahassee Central, homes for rent in Tallahassee Central Florida, and Tallahassee Central vacation rentals
For rent by owner homes and rental homes
Rental properties in Eustis Florida, vacation rentals Eustis, and for rent by owner homes in Eustis Florida
Flagler Beach Florida rental homes, rent houses Flagler Beach, vacation homes for rent by owner in Flagler Beach, and rental properties Flagler Beach
Vacation homes for rent by owner Merritt Island Florida and vacation rental
North Peninsula short term rentals, North Peninsula Florida holiday rentals, and apartments for rent in North Peninsula
Williston-Bronson Florida short term rentals, Williston-Bronson homes for rent by owner, condos for rent in Williston-Bronson, and vacation homes for rent by owner
Leesburg East Florida vacation rental and Leesburg East Florida vacation homes for rent by owner
Vacation homes for rent by owner, condo rentals Palm Bay, and vacation rentals in Palm Bay Florida
Bunnell holiday rentals, rent house Bunnell, homes for rent by owner in Bunnell, and rental homes Bunnell Florida
Macclenny Florida vacation rentals and homes for rent by owner Macclenny Florida
Rental homes Clewiston Florida, Clewiston short term rentals, and rental properties Clewiston Florida
Rental homes Fernandina Beach, Fernandina Beach Florida apartment rentals, rental home in Fernandina Beach, and vacation homes in Fernandina Beach Florida
Houses for rent Interlachen-Florahome Florida and condo rentals Interlachen-Florahome
Bunnell Florida real estate rentals, Bunnell Florida rental properties, and Bunnell Florida homes for rent by owner
St Petersburg short term rentals, vacation homes St Petersburg, real estate rentals St Petersburg Florida, and condos for rent St Petersburg Florida
Interior County Florida homes for rent and rent houses Interior County Florida
Rental homes, Pace condo rentals, and home rentals
Fort Myers Florida rental homes, vacation homes in Fort Myers Florida, holiday rentals in Fort Myers Florida, and Fort Myers for rent by owner homes
Vacation homes for rent by owner in Okeechobee Florida and Okeechobee Florida rent house
For rent by owner homes, house rentals Middle Keys, and homes for rent by owner in Middle Keys
Holiday rentals Hollywood, rent houses, rental home in Hollywood Florida, and Hollywood vacation homes for rent by owner
Fort Walton Beach Florida condos for rent and Fort Walton Beach Florida holiday rentals
Rental home in Clermont Florida, vacation homes Clermont, and rental home Clermont
Begin your pursuance online next weekend, day after tomorrow, on Sunday, or on Thursday for your Plant City Florida houses for rent and short term rentals Plant City Florida.
Identify, discover, and distinguish rental houses and rent house in Levy Florida.
Uncover, observe, and perceive short term rentals in Lehigh Acres United States, for rent by owner homes Lehigh Acres United States, and Lehigh Acres vacation rental.
Glimpse and recognize home rentals in Zellwood United States and condos for rent in Zellwood.
Hear and identify Odessa United States condos for rent and apartments for rent in Odessa.
Dig up, catch, and identify rental home in Otter Creek United States, Otter Creek United States rental homes, and homes for rent Otter Creek.
Hillside directories and hillside classified ads condos for rent in Santa Rosa Florida, bed and breakfast rentals, vacation rentals in Santa Rosa Florida, and for rent by owner homes.
Come across and conceive Winter Springs United States home rentals and vacation rental in Winter Springs United States.
Relocate and debunk house rentals Palm City and rental homes in Palm City.
Notice original, novel, and something else figures in Plant City and insert vacation rental in Plant City Florida.
Come across, uncover, and ferret out Okaloosa Florida rental properties, Okaloosa rental apartment, and homes for rent.
Originate, catch, and glimpse houses for rent in Gilchrist Florida, rental houses in Gilchrist Florida, rent house Gilchrist, and holiday rentals.
Auburn New York holiday rentals, apartments for rent Auburn New York, and real estate rentals Auburn
The Plant City rustic classified ads and mountain ads for these tract can be mapped.
Not infrequently, benefit, work with, and puff your inhabitants and traveling saleswomen to a well-liked, chock-full, and roomy tract.
Plant City Florida is a charming, wonderful, and handsome domain with pretty and handsome timeshare, bungalow, hacienda, and castles.
You can look over the exclusive lists of marked properties, hillside listings, and hidden lists of marked properties under Plant City Florida bed and breakfast rentals and for rent by owner homes in Plant City Florida.
Find out, contrive, and determine vacation rental in Brevard, Brevard Florida homes for rent by owner, and Brevard rent houses.
Dig up, espy, and find rent houses in Escambia Florida, vacation homes for rent by owner in Escambia, and Escambia bed and breakfast rentals.
Send pulchritudinous, pretty, and cute knowledge regarding real estate rentals in Plant City and real estate rentals in Plant City Florida found on our page.
Notice and contrive Lafayette Florida apartments for rent and homes for rent in Lafayette.
See rustic ads and rustic ad directories that property agents and property agents post on our site, FRBO.com.
Apartments for rent, rental home in Winfield Illinois, Winfield rental homes, and rental home Winfield
Ready to move in private hacienda, lakefront hacienda, log bungalow, and spacious chalet are impending in the adjoining patch of Plant City Florida.
Uncover, perceive, and glimpse home rentals Palm City United States, short term rentals Palm City, and for rent by owner homes Palm City.
For Rent By Owner does encompass another story studio and mountain flat, hacienda, farmhouse, and ranchs.
Detect and find out bed and breakfast rentals and vacation homes for rent by owner in Indiantown United States.
This site, For Rent By Owner (FRBO.com) comprises parcel, quarter, square, and county statistics, not seldom.
Plant City condo owners, property brokers, third party agents, and town home owners list rental homes Plant City and Plant City rental properties.
Secure, reserve, record, and register now to enter upon and lead off on this progress.
Devise and learn Highlands Florida house rentals and rental apartment.
Peers and roommates who are wishing to devise, detect, and disclose or simply identify information can use this site, FRBO.com.
|
|
