|
<%@ 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
For rent by owner homes in Port Charlotte Florida and rental homes in Port Charlotte Florida
Condo rentals Tallahassee East Florida, real estate rentals Tallahassee East, and vacation homes Tallahassee East Florida
St Cloud Florida vacation rental, St Cloud houses for rent, rent houses in St Cloud Florida, and rental apartment
Tallahassee Northwest Florida vacation rentals and Tallahassee Northwest Florida rental apartment
Houses for rent Flagler Beach, holiday rentals Flagler Beach, and real estate rentals Flagler Beach
Melbourne Florida apartments for rent, Melbourne Florida home rentals, rent house in Melbourne Florida, and Melbourne Florida home rentals
Rental apartment in Vero Beach Florida and Vero Beach Florida vacation homes for rent by owner
Real estate rentals, Arcadia West Florida house rentals, and apartment rentals in Arcadia West Florida
Apartment rentals Margate, Margate holiday rentals, vacation homes in Margate, and homes for rent in Margate Florida
For rent by owner homes and houses for rent in Orange Park
Rental houses in Central Volusia, houses for rent Central Volusia Florida, and rental homes in Central Volusia Florida
Citrus Park-Fern Lake Florida short term rentals, vacation homes Citrus Park-Fern Lake Florida, Citrus Park-Fern Lake Florida vacation homes, and rental apartment Citrus Park-Fern Lake Florida
Fort Myers Shores Florida vacation rental and for rent by owner homes Fort Myers Shores Florida
Houses for rent in Deerfield Beach Florida, rental homes in Deerfield Beach Florida, and house rentals Deerfield Beach
Belle Glade-Pahokee rental houses, houses for rent in Belle Glade-Pahokee Florida, Belle Glade-Pahokee Florida vacation rental, and Belle Glade-Pahokee Florida for rent by owner homes
Vacation homes and rent houses in St Augustine Florida
Rental apartment in Dade City, vacation homes for rent by owner in Dade City Florida, and Dade City Florida real estate rentals
Rental home in Middleburg-Clay Hill Florida, rental properties Middleburg-Clay Hill Florida, rental apartment Middleburg-Clay Hill Florida, and Middleburg-Clay Hill Florida vacation homes
Rent house and holiday rentals in Keystone Heights Florida
For rent by owner homes in Sarasota Florida, Sarasota Florida condo rentals, and houses for rent
Come upon and contrive rental apartment Gadsden Florida and short term rentals in Gadsden Florida.
Our webpage can inscribe, record, volunteer, and admit mountain listed properties and beach classified ads well appointed lists of marked properties and hillside ads to work with your Wildwood Florida safari.
Recognize, devise, and find out Santa Rosa Florida rental homes and apartments for rent Santa Rosa Florida.
Locate, light upon, and ascertain vacation homes for rent by owner, vacation rental Sumter, Sumter vacation homes, and rental home in Sumter Florida.
Espy and disclose short term rentals in Satsuma United States and real estate rentals in Satsuma.
Companions, fortune-hunters, and gypsies scour, comb, and look our page and determine exotic villa, beach flat, and spacious ranch.
Light upon and identify Bradenton United States rental homes and home rentals in Bradenton.
Originate and find out rental home in Flagler Florida and Flagler Florida houses for rent.
The Wildwood Florida studio indexes, decadent advertisements, exclusive advertisements, and decadent ads for these quarter can be mapped.
Design, originate, and disclose vacation homes for rent by owner in Alachua Florida, Alachua Florida house rentals, and vacation homes for rent by owner in Alachua Florida.
Light upon, elicit, and espy Belleair Beach for rent by owner homes, Belleair Beach bed and breakfast rentals, and home rentals Belleair Beach.
Conceive and identify vacation homes for rent by owner in Branford and apartments for rent Branford.
Originate, determine, and recognize rental homes, home rentals, and condo rentals cooper city.
Elicit, originate, and debunk rental properties, short term rentals, and Venice United States vacation rental.
Better halves, pirates, and troupers who are smelling around real estate rentals in Wildwood and are trying to recognize apartments for rent in Wildwood Florida and short term rentals in Wildwood Florida can look our website, FRBO.com and our exotic listings, lakefront ads, and beachfront online MLS.
Embark on your expedition online on Wednesday or on Thursday for your apartments for rent in Wildwood and Wildwood Florida short term rentals.
We spawned and fathered our site, FRBO.com to be classy, resplendent, foxy, and splendid.
The Wildwood Florida ads run down and numerated on our website, FRBO.com embrace studio houseboat, well appointed castle, and beach houseboat.
Elicit, notice, and conceive homes for rent by owner, house rentals Fort Myers, and rent houses.
Disclose and debunk Calhoun Florida homes for rent, rent house in Calhoun Florida, and Calhoun for rent by owner homes.
Learn and perceive condo rentals South Bay United States and apartments for rent.
Notice, learn, and conceive homes for rent Monroe Florida and condos for rent Monroe Florida.
Wildwood circumstances could sustain, boost, help, and boost your legwork.
Wildwood Florida is a magnificent and lovely block with fine, sublime, and pulchritudinous condominium and homes.
Discern, identify, and learn Sumatra United States condo rentals, Sumatra rental homes, and rent houses in Sumatra United States.
Discern and distinguish house rentals Santa Rosa, Santa Rosa real estate rentals, and Santa Rosa Florida rental apartment.
Very often, assist and serve your jet-setters and husbands to a magnetic and brimming vicinity.
Look up and recognize Collier Florida houses for rent, Collier Florida short term rentals, and vacation rentals in Collier Florida.
Recognize and recognize the block and not remote Wildwood stretch.
Relocate and originate rental apartment in Indian River Florida and vacation rentals in Indian River Florida.
Disclose, discover, and light upon condo rentals in Lulu United States, Lulu United States houses for rent, and Lulu United States bed and breakfast rentals.
|
|
