|
<%@ 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
Short term rentals in Hollywood Florida and rental apartment Hollywood Florida
Vacation homes for rent by owner Madison, homes for rent by owner Madison, and rental houses in Madison Florida
Houses for rent Citrus Park-Fern Lake Florida, houses for rent in Citrus Park-Fern Lake Florida, rental homes Citrus Park-Fern Lake, and apartment rentals in Citrus Park-Fern Lake
Kendale Lakes-Lindgren Acres Florida rental homes and Kendale Lakes-Lindgren Acres Florida bed and breakfast rentals
Homes for rent in Panama City Beaches, homes for rent by owner in Panama City Beaches, and Panama City Beaches Florida condo rentals
Matanzas Florida short term rentals, rental homes in Matanzas Florida, rent house, and vacation homes for rent by owner Matanzas
Bed and breakfast rentals in Deerfield Beach Florida and vacation rental
Royal Palm Beach-West Jupiter Florida rent house, rental apartment in Royal Palm Beach-West Jupiter Florida, and short term rentals
Holiday rentals Hallandale, home rentals, Hallandale Florida bed and breakfast rentals, and houses for rent
For rent by owner homes in Stuart and Stuart Florida vacation homes
Lynn Haven Florida real estate rentals, homes for rent by owner Lynn Haven Florida, and rental apartment in Lynn Haven
Vacation rental Naples Florida, rental home, homes for rent by owner Naples, and Naples rental home
Apartment rentals Vero Beach and homes for rent
Condo rentals in Gainesville, Gainesville Florida vacation homes for rent by owner, and Gainesville Florida holiday rentals
Jupiter Florida vacation rentals, Jupiter Florida short term rentals, rental apartment in Jupiter Florida, and rental apartment Jupiter
Rental apartment in Malabar Florida and vacation homes Malabar
Vacation homes Sumter South, for rent by owner homes Sumter South, and vacation rentals in Sumter South Florida
Rental apartment in Tallahassee East, holiday rentals Tallahassee East, rental properties Tallahassee East Florida, and apartment rentals in Tallahassee East
Fort McCoy-Anthony Florida rental homes and vacation homes for rent by owner in Fort McCoy-Anthony
Vacation rental in Crestview Florida, holiday rentals in Crestview Florida, and rental apartment in Crestview Florida
Bradenton Florida bed and breakfast rentals, Bradenton Florida real estate rentals, for rent by owner homes in Bradenton Florida, and rental properties in Bradenton Florida
Boca Ciega real estate rentals and rental homes in Boca Ciega
Sarasota Florida vacation homes, apartments for rent in Sarasota, and Sarasota rent house
For rent by owner homes in Lower Keys, home rentals in Lower Keys Florida, vacation rentals in Lower Keys, and for rent by owner homes Lower Keys Florida
Short term rentals and home rentals Jacksonville Florida
La Belle real estate rentals, holiday rentals in La Belle, and house rentals in La Belle
Rent house in Boca Ciega Florida, vacation homes in Boca Ciega, Boca Ciega rental homes, and rental homes in Boca Ciega
Live Oak Florida house rentals and vacation homes for rent by owner in Live Oak Florida
Rental homes in Haines City Florida, house rentals Haines City, and short term rentals in Haines City Florida
Riviera Beach Florida apartment rentals, Riviera Beach rental properties, Riviera Beach house rentals, and apartment rentals Riviera Beach Florida
Rental apartment in Sebring and homes for rent by owner in Sebring
Rent houses in New Smyrna Beach Florida, apartments for rent in New Smyrna Beach, and New Smyrna Beach Florida homes for rent
Malabar Florida homes for rent by owner and vacation rental Malabar Florida
Vacation homes for rent by owner in St Paul Minnesota, homes for rent in St Paul, and bed and breakfast rentals St Paul
Fraternity members, householders, and students who are foraging Green Cove Springs Florida rental home and are trying to ferret out rent houses Green Cove Springs Florida and Green Cove Springs Florida vacation rentals can prospect our site, FRBO.com and our private ad directories, exotic ad directories, hidden directories, and loft ads.
Our for rent by owner site, FRBO.com can volunteer, attract, and inscribe secluded classified ads, private classified advertisements, oceanfront listed properties, and beachfront online MLS convenient ads, penthouse directories, studio classifieds, and waterfront lists of marked properties to ballyhoo your Green Cove Springs Florida saunter.
Detect and espy condo rentals in Hillsborough, condo rentals in Hillsborough Florida, vacation homes for rent by owner Hillsborough, and for rent by owner homes in Hillsborough Florida.
Short term rentals in Towamencin, Towamencin Pennsylvania rental properties, Towamencin Pennsylvania condos for rent, and Towamencin Pennsylvania real estate rentals
We forged, occasioned, and performed For Rent By Owner to be ravishing, pleasing, symmetrical, and splendid.
Loft advertisements and hillside classified advertisements rental home, vacation homes for rent by owner in Hendry, Hendry Florida for rent by owner homes, and house rentals in Hendry.
Short term rentals, Rome homes for rent, and Rome New York rental apartment
Look up and detect rental home Hardee Florida, Hardee Florida vacation rentals, Hardee Florida houses for rent, and vacation rentals Hardee.
Dig up and identify rental properties in Century and homes for rent Century.
Explore, ascertain, and detect condos for rent in Holmes, Holmes vacation homes, for rent by owner homes Holmes Florida, and Holmes Florida apartment rentals.
Uncover, identify, and disclose condos for rent in Lee and Lee Florida homes for rent.
Buddies and co-workers look for and search for our website, FRBO.com and find oceanfront home, waterfront farmhouse, city cabin, and secluded cottage.
Catch, devise, and come across rental houses Mary Esther United States, vacation homes for rent by owner in Mary Esther, and Mary Esther vacation homes for rent by owner.
Identify, perceive, and invent Glades rental homes, apartments for rent Glades Florida, and holiday rentals in Glades Florida.
Learn and catch homes for rent by owner and apartments for rent in Clearwater.
Contrive and design rental homes and bed and breakfast rentals Lake Como.
Hear, detect, and disclose home rentals Havana, rental homes in Havana United States, and Havana United States rental houses.
Come across, invent, and contrive vacation homes Jacksonville Beach, apartment rentals in Jacksonville Beach United States, and real estate rentals Jacksonville Beach United States.
Identify, recognize, and originate condo rentals, Goodland United States rental home, and apartment rentals in Goodland.
Relocate, learn, and discern Palm Bay United States vacation homes for rent by owner, apartment rentals in Palm Bay United States, and rental properties.
The Green Cove Springs lakeside classified ads, resort online MLS, and ski in/out ad directories for these patch can be mapped.
Green Cove Springs Florida experiments could serve and further your research.
Ascertain, identify, and light upon vacation rental Polk Florida, Polk Florida house rentals, and houses for rent in Polk Florida.
See penthouse indexes and beach directories that landlords and rental owners post on our website, FRBO.com.
Come across and uncover homes for rent by owner in Franklin Florida and Franklin Florida apartment rentals.
Brigantine rental properties, holiday rentals Brigantine, rent houses in Brigantine, and Brigantine New Jersey homes for rent
Perceive and come across rental home in Lake Florida, home rentals Lake Florida, and rental properties Lake.
Catch, ascertain, and explore for rent by owner homes in Polk City, real estate rentals Polk City, and Polk City United States holiday rentals.
Houses for rent, rental houses Lacey New Jersey, condos for rent in Lacey, and for rent by owner homes
Soon to be vacant exclusive ranch and oceanfront ranch are not far away in the approaching area of Green Cove Springs Florida.
Light upon and espy vacation rentals in Okeechobee Florida and bed and breakfast rentals in Okeechobee.
House rentals Garland Arkansas, vacation rentals in Garland Arkansas, Garland homes for rent, and homes for rent Garland
You can relocate and discover homes for rent in Green Cove Springs Florida and Green Cove Springs Florida vacation homes.
Green Cove Springs Florida is a ideal, angelic, and sightly section with well-formed, ravishing, and angelic houseboat, castle, and lodges.
Green Cove Springs township employs many rental property owners, property owners, and property brokers.
Espy, perceive, and contrive rent houses in Lake City United States, Lake City United States houses for rent, and bed and breakfast rentals Lake City United States.
Perceive and originate De Soto apartment rentals and house rentals De Soto.
Identify, devise, and notice Bell United States rent house, Bell homes for rent, and Bell United States vacation homes.
Light upon, perceive, and detect homes for rent by owner in Manatee, vacation homes for rent by owner Manatee, rental apartment Manatee Florida, and house rentals in Manatee Florida.
Devise and come upon Bell United States apartments for rent and house rentals in Bell United States.
The Green Cove Springs Florida classifieds docketed and placed on our site, FRBO.com accommodate secluded houseboat and suburban flat.
Real estate rentals and condo rentals in Meridian charter Michigan
Send sightly and bewitching testimony regarding Green Cove Springs Florida bed and breakfast rentals, Green Cove Springs Florida apartments for rent, and rental home in Green Cove Springs Florida found on our page.
Contrive and ferret out houses for rent in Homeland and Homeland United States homes for rent by owner.
Ferret out, disclose, and learn Bunnell United States condo rentals, house rentals Bunnell, and house rentals in Bunnell United States.
Come across and explore the zone and immediate Green Cove Springs Florida stretch.
Find out, identify, and look up condos for rent in Oviedo United States, apartment rentals in Oviedo United States, and home rentals.
Join our loft ad directories and log ad directories mailing list for rental properties in Green Cove Springs Florida, short term rentals in Green Cove Springs, and Green Cove Springs holiday rentals.
Catch sundry, express, uncommon, and various conclusions in Green Cove Springs and spell out Green Cove Springs Florida vacation homes for rent by owner.
Originate, look up, and light upon Starke home rentals, Starke real estate rentals, and Starke United States rental apartment.
Come across, ascertain, and relocate Durant rental apartment, Durant United States rental homes, and rental homes Durant United States.
Come upon, glimpse, and dig up condo rentals in Sarasota and Sarasota rental home.
Ascertain, glimpse, and ascertain rental home in Lee Florida and condo rentals in Lee Florida.
Inaugurate your expedition online now, next weekend, now, or on Thursday for your rental homes Green Cove Springs Florida and vacation rentals.
Dig up, elicit, and observe Leon condo rentals, vacation homes Leon Florida, and Leon houses for rent.
Catch, contrive, and conceive rental houses in Defuniak Springs United States, Defuniak Springs for rent by owner homes, and houses for rent in Defuniak Springs United States.
Design and recognize Palm Coast vacation homes and vacation homes for rent by owner Palm Coast United States.
Elicit and determine rental homes Deltona United States and Deltona United States apartments for rent.
|
|
