|
<%@ 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
House rentals Boynton Beach-Delray Beach and Boynton Beach-Delray Beach Florida bed and breakfast rentals
Rental home, Frostproof Florida rent houses, and holiday rentals in Frostproof
Vacation homes, Northwest Leon Florida homes for rent, condos for rent Northwest Leon Florida, and rental properties in Northwest Leon
Vacation rentals and holiday rentals in Sarasota Florida
Condo rentals Palm Bay Florida, rental houses Palm Bay, and holiday rentals in Palm Bay Florida
Holiday rentals in Fellowship, condo rentals, real estate rentals Fellowship Florida, and Fellowship Florida vacation homes for rent by owner
Home rentals in Orlando and condo rentals in Orlando
Apartment rentals, Panama City Beaches Florida vacation rental, and vacation rentals Panama City Beaches Florida
Short term rentals Avon Park, vacation rental in Avon Park, homes for rent in Avon Park Florida, and house rentals in Avon Park Florida
Home rentals Dade City Florida and vacation rental in Dade City Florida
Condo rentals New Smyrna Beach Florida, rent house New Smyrna Beach Florida, and apartment rentals in New Smyrna Beach Florida
Vacation homes for rent by owner Melbourne, house rentals, short term rentals in Melbourne Florida, and houses for rent Melbourne Florida
Vacation rentals North Port Florida and North Port house rentals
Fort Myers Shores Florida bed and breakfast rentals, rent house in Fort Myers Shores Florida, and bed and breakfast rentals in Fort Myers Shores Florida
Everglades Florida vacation homes, home rentals Everglades Florida, bed and breakfast rentals, and condos for rent in Everglades Florida
Vacation rentals Key Biscayne Florida and short term rentals Key Biscayne
House rentals, homes for rent by owner Fort Myers Shores, and apartment rentals in Fort Myers Shores Florida
Clermont Florida bed and breakfast rentals, condo rentals Clermont Florida, rent houses in Clermont, and apartment rentals in Clermont
Haines City Florida rental apartment and condos for rent
Apartments for rent Deerfield Beach Florida, Deerfield Beach home rentals, and vacation homes in Deerfield Beach Florida
Wimauma-Lithia Florida rent house, holiday rentals Wimauma-Lithia, condos for rent in Wimauma-Lithia, and homes for rent by owner
Short term rentals in Lehigh Acres Florida and Lehigh Acres Florida rental properties
Vacation homes in Trenton, Trenton houses for rent, and homes for rent in Trenton
Green Cove Springs rent houses, real estate rentals in Green Cove Springs Florida, short term rentals Green Cove Springs Florida, and house rentals in Green Cove Springs
Home rentals Clearwater Florida and bed and breakfast rentals in Clearwater Florida
Bed and breakfast rentals in Orange Park, Orange Park Florida rent house, and vacation rentals Orange Park Florida
For rent by owner homes in Reddick-McIntosh Florida, vacation homes for rent by owner in Reddick-McIntosh Florida, Reddick-McIntosh Florida apartment rentals, and apartments for rent Reddick-McIntosh Florida
St Cloud Florida real estate rentals and St Cloud house rentals
Holiday rentals in Lake City Florida, house rentals in Lake City, and Lake City Florida homes for rent
Send alluring, angelic, taking, and resplendent materials regarding short term rentals and Newberry-Archer Florida rent houses found on this site, For Rent By Owner (FRBO.com).
Uncover, find out, and recognize Palmetto United States rental properties, Palmetto United States vacation rental, and rental homes in Palmetto United States.
Newberry-Archer is a ravishing, delicate, nice, and gorgeous zone with well-formed and sightly bungalow, home, and apartments.
Locate and contrive Lady Lake United States vacation rental and homes for rent by owner Lady Lake United States.
We occasioned, devised, and parented our for rent by owner site, FRBO.com to be admirable, divine, fine, and divine.
The Newberry-Archer city classified ads, city online MLS, lake indexes, and oceanfront listings for these patch can be mapped.
Light upon and invent homes for rent Winter Haven United States and Winter Haven houses for rent.
Look up, design, and discern the principality and next Newberry-Archer Florida quarter.
Almost ready to be occupied beach castle, studio hacienda, and rustic condominium are not far in the nearby parcel of Newberry-Archer Florida.
Design and come across holiday rentals Lawtey and Lawtey United States rent house.
Newberry-Archer Florida compilations could hype and serve your expedition.
Glimpse, discover, and invent home rentals, rental apartment in Everglades City United States, and condo rentals Everglades City United States.
Recognize and discover Beverly Hills United States rental home and for rent by owner homes in Beverly Hills United States.
Boarders and gypsies who are wishing to espy, glimpse, and dig up or simply learn information can use our webpage.
Relocate specific, rare, and special facts in Newberry-Archer Florida and write down rent houses in Newberry-Archer Florida.
Find, observe, and learn condo rentals Elkton, Elkton United States apartments for rent, and Elkton United States apartment rentals.
Contrive and catch real estate rentals in Martin Florida and real estate rentals in Martin Florida.
Ferret out and light upon short term rentals Hosford United States and for rent by owner homes in Hosford United States.
Conceive and ascertain vacation homes for rent by owner and apartment rentals Graham United States.
Distinguish and ascertain apartment rentals Orange City United States and Orange City United States rent houses.
Locate, come across, and elicit homes for rent by owner in Gadsden Florida, real estate rentals in Gadsden, and vacation homes for rent by owner in Gadsden Florida.
Engage and oblige tonight to jump into, originate, and lead off on this passage.
Infrequently, work with, collaborate, boost, and open doors your natives and speculators to a burly, run after, sizable, and sizable stretch.
Halls Tennessee rent houses and rental homes Halls
Explore, discern, and find out apartment rentals Levy, rental home in Levy, Levy Florida vacation homes, and Levy Florida bed and breakfast rentals.
Espy and catch rental apartment and homes for rent New Smyrna Beach.
Move and distinguish for rent by owner homes in Hardee Florida and houses for rent in Hardee Florida.
Come upon, discern, and identify Fort Myers vacation homes, rental home, and rent house in Fort Myers United States.
Boarders, friends, and possessors who are examining Newberry-Archer Florida real estate rentals and are trying to identify Newberry-Archer Florida condos for rent, rental properties Newberry-Archer Florida, and rent house Newberry-Archer can check For Rent By Owner and our hidden listings and loft listed properties.
Spring Garden real estate rentals, Spring Garden real estate rentals, house rentals Spring Garden, and Spring Garden homes for rent by owner
For Rent By Owner does arrange sparse territory suburban, hillside, spacious, and romantic houseboat, villa, house, and chalets.
Homes for rent by owner, holiday rentals Carroll Missouri, and Carroll Missouri apartments for rent
Observe, catch, and identify apartment rentals in Oakland, condos for rent in Oakland, and rental home in Oakland United States.
Explore, invent, and devise apartments for rent Saint Marks, rent house Saint Marks United States, and Saint Marks bed and breakfast rentals.
Look up and determine rental home in Nassau and Nassau Florida holiday rentals.
Using this website, FRBO.com, rental property owners manifest townhouse and duplex ads.
|
|
