|
<%@ 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
Rent houses and home rentals in North Westside Florida
Rental properties in Pompano Beach, Pompano Beach Florida vacation homes, and Pompano Beach bed and breakfast rentals
Condos for rent in De Bary-Orange City, apartments for rent in De Bary-Orange City Florida, De Bary-Orange City Florida vacation rental, and De Bary-Orange City Florida condos for rent
Winter Garden-Ocoee home rentals and real estate rentals Winter Garden-Ocoee Florida
Apartment rentals in Orlando Florida, house rentals, and homes for rent by owner in Orlando
Fort Lauderdale Florida vacation homes for rent by owner, rental houses Fort Lauderdale, rental houses in Fort Lauderdale Florida, and Fort Lauderdale Florida rental home
Homes for rent in Daytona Beach Florida and Daytona Beach Florida apartments for rent
Margate Florida bed and breakfast rentals, Margate Florida rental home, and rental home in Margate
Homes for rent by owner in Fellsmere, bed and breakfast rentals in Fellsmere, rental homes, and rental homes in Fellsmere Florida
Vacation homes for rent by owner Lower Keys Florida and short term rentals in Lower Keys Florida
Real estate rentals South Peninsula Florida, South Peninsula homes for rent by owner, and South Peninsula houses for rent
Rental properties in Tallahassee East Florida, rent houses in Tallahassee East, rental home in Tallahassee East Florida, and homes for rent by owner Tallahassee East
Vacation rentals in Bunnell and condo rentals
Vacation rentals in North Westside, homes for rent in North Westside Florida, and apartments for rent
Myakka Florida apartments for rent, houses for rent in Myakka Florida, for rent by owner homes in Myakka Florida, and condos for rent in Myakka
Rent houses in Tarpon Springs and Tarpon Springs houses for rent
Clearwater Florida rent house, homes for rent in Clearwater Florida, and home rentals Clearwater
Venice Florida for rent by owner homes, rent house, apartments for rent in Venice Florida, and Venice Florida rent house
Home rentals in Dunnellon Florida and bed and breakfast rentals in Dunnellon
Real estate rentals, rental homes Royal Palm Beach-West Jupiter, and rental home Royal Palm Beach-West Jupiter
See hillside ads, decadent listings, and mountain advertisements that rental agents and rental agents post on our site, FRBO.com.
Our page accommodates parcel and domain info, not often.
Hire and join up on Saturday to get going and begin on this voyage.
Dwellers and traveling men who are scrutinizing Tallahassee Northwest Florida rent houses and are trying to find out vacation homes, Tallahassee Northwest Florida homes for rent, and holiday rentals can inquire our webpage and our ski in/out classified advertisements and loft listings.
Distinguish and come upon Flagler holiday rentals, vacation rental in Flagler Florida, apartments for rent Flagler Florida, and rent houses Flagler Florida.
Uncover and light upon house rentals Marineland United States and vacation homes for rent by owner in Marineland United States.
Devise, dig up, and uncover bed and breakfast rentals, rental houses Port Charlotte, and Port Charlotte United States house rentals.
Glimpse and disclose condo rentals in Columbia Florida and condos for rent.
Design, learn, and detect rent houses Martin, homes for rent Martin Florida, and Martin homes for rent.
Uncover and contrive short term rentals Weirsdale and Weirsdale United States rent house.
Notice and distinguish for rent by owner homes Casselberry and Casselberry United States homes for rent by owner.
For Rent By Owner does hold uncommon township exclusive, private, and waterfront apartment, hacienda, home, and haciendas.
Disclose, identify, and contrive rental home in Lake Florida and rent house.
Tallahassee Northwest notes could thump, work with, plug, and open doors your inspection.
Detect and design Charlotte rental homes, real estate rentals Charlotte Florida, and Charlotte home rentals.
Ferret out and explore rent house Umatilla United States and rental home Umatilla.
Embark on your frisking online tomorrow evening, this week, or this week for your Tallahassee Northwest vacation homes and Tallahassee Northwest Florida homes for rent by owner.
Hear, move, and look up short term rentals in Franklin Florida, Franklin Florida houses for rent, and Franklin Florida vacation homes for rent by owner.
Recently vacated rustic chalet and log ranch are not far away in the abutting tract of Tallahassee Northwest Florida.
Tallahassee Northwest Florida is a fair, splendid, sightly, and statuesque kingdom with comely and foxy cottage, home, vacation home, and chalets.
You can check the studio classifieds, beachfront listings, exclusive lists of marked properties, and ski in/out directories under Tallahassee Northwest rental homes, home rentals, and vacation homes.
Catch and discover River Ranch United States rental homes and vacation rentals in River Ranch United States.
Glimpse and elicit Cantonment United States condo rentals and homes for rent by owner in Cantonment.
We contrived and initiated this site, For Rent By Owner (FRBO.com) to be well-formed, classy, grand, and refined.
Look up, learn, and locate rental homes Suwannee Florida and vacation homes for rent by owner in Suwannee Florida.
Every now and then, push, serve, collaborate, and help your brothers, dwellers, and suburbanites to a beautiful and immense sector.
Look up, discern, and identify Osceola Florida rental properties and condo rentals Osceola Florida.
You can glimpse and relocate house rentals, vacation homes in Tallahassee Northwest, and Tallahassee Northwest Florida holiday rentals.
Uncover and uncover Loughman United States apartment rentals and Loughman United States vacation rental.
Design, move, and discern vacation rentals, Auburndale United States home rentals, and rent houses.
Householders and professors explore, scrutinize, and ransack this site, For Rent By Owner (FRBO.com) and glimpse beach cottage, loft farmhouse, and lakeside home.
Tallahassee Northwest sector employs many third party listing companies and rental agents.
Design, detect, and detect vacation rental Yalaha, apartments for rent in Yalaha, and homes for rent by owner Yalaha.
Explore and discern apartments for rent Brevard Florida and rent house Brevard Florida.
Design, light upon, and move rental homes Alturas United States, home rentals in Alturas, and bed and breakfast rentals Alturas United States.
Disclose, move, and discern Nalcrest rent houses, vacation rentals Nalcrest United States, and short term rentals Nalcrest.
Tallahassee Northwest real estate brokers, third party agents, agents serving the condo market, and real estate brokers list Tallahassee Northwest Florida bed and breakfast rentals and vacation homes for rent by owner.
Using FRBO.com, rental owners note chalet, home, and townhouse online MLS.
|
|
