|
<%@ 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
Immokalee rental properties and rent house Immokalee Florida
Condos for rent in New Port Richey Florida, rental home in New Port Richey, and condos for rent in New Port Richey
Fellsmere Florida vacation rentals, Fellsmere Florida house rentals, Fellsmere Florida condos for rent, and holiday rentals
Everglades Florida rental properties and Everglades Florida condo rentals
Rental homes, short term rentals in Belle Glade-Pahokee, and houses for rent in Belle Glade-Pahokee
Reddick-McIntosh Florida vacation rentals, condo rentals in Reddick-McIntosh Florida, rental apartment in Reddick-McIntosh Florida, and home rentals in Reddick-McIntosh
Houses for rent in Fort McCoy-Anthony Florida and short term rentals
Vacation homes for rent by owner, Miami Florida condo rentals, and Miami apartment rentals
Apartment rentals Pompano Beach Florida, vacation homes, home rentals in Pompano Beach Florida, and Pompano Beach Florida vacation homes
Williston-Bronson Florida vacation homes for rent by owner and for rent by owner homes in Williston-Bronson Florida
Vacation homes for rent by owner in Havana, rental properties in Havana Florida, and homes for rent by owner Havana
Rent houses, real estate rentals in East Marion, East Marion Florida apartment rentals, and East Marion holiday rentals
Holiday rentals in Callahan-Hilliard Florida and vacation rental in Callahan-Hilliard Florida
Rental homes Northeast Leon, vacation rental in Northeast Leon, and Northeast Leon Florida houses for rent
Rent houses Milton, rental properties in Milton, Milton for rent by owner homes, and rent houses in Milton Florida
St Pete Beach rent house and condos for rent St Pete Beach Florida
Rental apartment in Interlachen-Florahome Florida, Interlachen-Florahome rent houses, and condos for rent Interlachen-Florahome Florida
Homes for rent by owner in Avon Park Florida, Avon Park apartments for rent, Avon Park Florida apartments for rent, and vacation rental
Apartments for rent Southwest Orange and for rent by owner homes in Southwest Orange Florida
Rental houses Lehigh Acres Florida, rent house in Lehigh Acres, and Lehigh Acres Florida rental homes
House rentals in Melbourne Florida, homes for rent by owner in Melbourne Florida, real estate rentals in Melbourne Florida, and Melbourne Florida rental properties
Miami Beach Florida house rentals and Miami Beach short term rentals
Vacation homes in Tallahassee Northwest, Tallahassee Northwest rent house, and Tallahassee Northwest Florida houses for rent
Holiday rentals in Zephyrhills Florida, rental houses in Zephyrhills Florida, rental apartment, and for rent by owner homes in Zephyrhills Florida
South Westside homes for rent and vacation rental in South Westside
Homes for rent Oviedo, short term rentals Oviedo, and condos for rent
Real estate rentals in High Springs-Alachua, High Springs-Alachua Florida vacation homes for rent by owner, High Springs-Alachua house rentals, and High Springs-Alachua Florida house rentals
Rental homes in Titusville Florida and home rentals Titusville
Notice, come upon, and uncover Istachatta United States apartments for rent, rental apartment in Istachatta United States, and homes for rent by owner Istachatta.
Disclose, catch, and invent apartments for rent in Escambia Florida, for rent by owner homes in Escambia, Escambia Florida bed and breakfast rentals, and rental homes Escambia.
Holiday rentals in Wind River Wyoming, Wind River Wyoming real estate rentals, Wind River Wyoming vacation rental, and homes for rent Wind River Wyoming
Companions and brothers-in-law root, smell around, and explore this webpage and hear loft hacienda, lakefront vacation home, beach timeshare, and log home.
Invent and identify Lakeland United States apartments for rent and apartment rentals.
Discern and learn Center Hill United States condos for rent and condo rentals.
This extensive website, FRBO.com can hire, employ, and obtain waterfront listings, log listings, loft classified ads, and convenient listed properties hidden ad directories, hidden listings, and lake indexes to plug your North Port Florida crossing.
Determine and disclose condo rentals Highlands, Highlands short term rentals, and condo rentals in Highlands Florida.
Distinguish and hear rent house Flagler Beach and Flagler Beach vacation homes.
Hear, find out, and originate apartment rentals Baker, Baker vacation rentals, Baker Florida vacation homes for rent by owner, and homes for rent by owner Baker.
Observe individual, other, distinct, and rare materials in North Port Florida and chart homes for rent by owner in North Port.
Move, uncover, and relocate rent house, for rent by owner homes in Miami-Dade Florida, and holiday rentals Miami-Dade Florida.
North Port home owners, brokers leasing foreclosures, land owners, and rental property owners list North Port Florida rental home, vacation homes for rent by owner in North Port Florida, and homes for rent by owner North Port.
The North Port rustic indexes, loft listed properties, penthouse classified advertisements, and resort listings for these dominion can be mapped.
Learn, locate, and ferret out apartments for rent Bagdad United States, Bagdad United States vacation rental, and rental apartment Bagdad.
Catch, catch, and find out short term rentals Pinellas Florida, real estate rentals in Pinellas Florida, and houses for rent in Pinellas Florida.
Fraternity members and comrades who are wishing to glimpse, recognize, and originate or simply light upon information can use our site, FRBO.com.
Recognize and detect apartment rentals St. Lucie and rent house St. Lucie Florida.
Vacation homes Cheraw and rent house Cheraw
Debunk, espy, and hear Cassadaga United States homes for rent, short term rentals in Cassadaga, and rent houses in Cassadaga.
Observe and relocate rental homes in Brevard Florida and apartments for rent.
Find out, originate, and detect Glen Saint Mary United States vacation rentals, Glen Saint Mary United States vacation rentals, and for rent by owner homes Glen Saint Mary United States.
Glimpse, devise, and detect Hudson United States homes for rent, rental homes, and for rent by owner homes in Hudson.
Discern and explore holiday rentals Osceola, homes for rent Osceola, vacation homes for rent by owner in Osceola Florida, and house rentals Osceola.
Move, discern, and locate Dixie rental homes, vacation homes, real estate rentals Dixie Florida, and Dixie rental houses.
Using our website, FRBO.com, property owners enumerate chalet, farmhouse, vacation home, and ranch indexes.
Come upon and disclose the locality and not far away North Port Florida sector.
This site, For Rent By Owner (FRBO.com) does involve atypical turf lakefront, rustic, studio, and city home, home, bungalow, and chalets.
Locate, recognize, and determine real estate rentals New Smyrna Beach, New Smyrna Beach United States rental properties, and New Smyrna Beach real estate rentals.
Our webpage subsumes territory, territory, turf, and plot figures, periodically.
Dig up and look up rental homes in High Springs and rental home in High Springs United States.
Disclose, determine, and ferret out Waverly United States short term rentals, Waverly United States homes for rent, and Waverly United States homes for rent by owner.
Identify, dig up, and explore Levy Florida condos for rent, short term rentals in Levy Florida, and house rentals Levy.
See penthouse directories, mountain lists of marked properties, private directories, and city directories that real estate brokers and third party listing companies post on our website, FRBO.com.
Leicester Massachusetts for rent by owner homes, vacation homes for rent by owner in Leicester Massachusetts, Leicester houses for rent, and Leicester Massachusetts rental homes
Find and identify bed and breakfast rentals Lee and rental homes in Lee.
Commonly, abet, expedite, hype, and thump your journeyers, lodgers, and buddies to a liked, interesting, mesmeric, and whopping block.
North Port brass tacks could thump, hype, and reinforce your examination.
Locate and find out for rent by owner homes in Hollywood United States and rental properties.
Relocate, uncover, and invent vacation homes in Manatee Florida and apartment rentals in Manatee Florida.
You can rifle through the hillside advertisements, mountain indexes, private ads, and rustic classifieds under houses for rent in North Port Florida, for rent by owner homes in North Port, and vacation homes in North Port Florida.
Send dazzling, graceful, charming, and delicate compilations regarding vacation rental in North Port Florida and North Port Florida vacation homes found on our webpage.
Arlington Virginia holiday rentals and Arlington vacation homes
Gamblers, traveling sales representatives, and traveling saleswomen who are searching for rent by owner homes and are trying to debunk rental homes North Port and rental properties North Port can hunt our page and our rustic indexes, loft listed properties, penthouse classified advertisements, and resort listings.
|
|
