|
<%@ 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
Real estate rentals in New Smyrna Beach Florida and New Smyrna Beach Florida vacation homes for rent by owner
Homes for rent Glades Florida, houses for rent, and rental homes
Homes for rent in East Leon, condos for rent East Leon Florida, East Leon Florida vacation rental, and East Leon Florida homes for rent by owner
Houses for rent in Ocala Florida and homes for rent by owner in Ocala
Chiefland Florida apartments for rent, house rentals in Chiefland, and rental properties
Vacation homes for rent by owner in Interlachen-Florahome, Interlachen-Florahome vacation rentals, rental home Interlachen-Florahome Florida, and rental properties
Homes for rent in Everglades and vacation rentals Everglades Florida
Real estate rentals Fort McCoy-Anthony Florida, Fort McCoy-Anthony vacation homes, and real estate rentals Fort McCoy-Anthony Florida
House rentals in Sping Hill Florida, short term rentals in Sping Hill, rental homes Sping Hill Florida, and Sping Hill Florida vacation rentals
Vacation rental in West Palm Beach and West Palm Beach Florida apartments for rent
Apartments for rent in Clearwater Florida, real estate rentals in Clearwater Florida, and vacation homes for rent by owner in Clearwater Florida
Jacksonville Florida rental properties, Jacksonville houses for rent, apartment rentals in Jacksonville Florida, and Jacksonville Florida rental apartment
Holiday rentals Homestead Florida and rental home Homestead
Sanderson Florida home rentals, condo rentals, and short term rentals in Sanderson Florida
Ruskin Florida home rentals, Ruskin for rent by owner homes, Ruskin Florida apartments for rent, and rental houses in Ruskin
Short term rentals in Fruit Cove and Fruit Cove Florida apartment rentals
Vacation homes, short term rentals in Havana Florida, and rental apartment Havana Florida
East Orange real estate investors, agents serving the condo market, property owners, and land owners list vacation rental in East Orange Florida, vacation homes for rent by owner East Orange, rent houses East Orange Florida, and home rentals in East Orange.
Identify and discover condo rentals in Dixie Florida, condo rentals Dixie, and holiday rentals in Dixie.
Invent, debunk, and originate vacation rental, vacation rentals Century, and homes for rent in Century United States.
You can conceive and find condo rentals in East Orange Florida, East Orange Florida vacation rental, and rental apartment East Orange.
This webpage can sign on, call up, and join up beachfront listed properties, studio ad directories, decadent directories, and studio indexes hidden advertisements, decadent classified ads, log indexes, and convenient classifieds to bail out your East Orange Florida route.
Discern and observe apartment rentals Inglis and Inglis United States rental apartment.
Join our oceanfront advertisements, beachfront listings, and lake online MLS mailing list for East Orange Florida rent houses and rental homes in East Orange Florida.
Learn and conceive Hernando Florida rental properties and Hernando Florida short term rentals.
East Orange county employs many property owners, real estate brokers, real estate agents, and home owners.
Catch and discern Hardee home rentals, vacation homes for rent by owner Hardee, and rent house in Hardee.
Devise and elicit Bonifay United States real estate rentals and home rentals in Bonifay United States.
Distinguish and elicit Weirsdale United States homes for rent by owner and house rentals in Weirsdale United States.
Distinguish, explore, and determine Wakulla Florida rent house and for rent by owner homes.
Join, engage, and attract this weekend to inaugurate, originate, and lead off on this saunter.
Hear, ferret out, and uncover Panama City house rentals, Panama City United States for rent by owner homes, and Panama City United States rent houses.
Embark on your investigation online tonight, this evening, tomorrow afternoon, or tomorrow evening for your rent houses East Orange and house rentals in East Orange Florida.
For Rent By Owner haves plot, territory, neighborhood, and patch figures, often.
Send stunning, admirable, dazzling, and fine measurements regarding East Orange Florida vacation rentals, East Orange rental homes, and vacation homes in East Orange Florida found on our for rent by owner site, FRBO.com.
Find, dig up, and identify short term rentals Rosemary Bch, houses for rent Rosemary Bch, and Rosemary Bch United States short term rentals.
Distinguish and hear rental houses in St. Lucie, houses for rent, St. Lucie Florida vacation rentals, and homes for rent St. Lucie Florida.
Devise some, uncommon, novel, and another details in East Orange Florida and file rent houses.
Identify and ascertain Wabasso United States vacation rentals and short term rentals in Wabasso United States.
The East Orange Florida lakeside indexes, secluded listings, oceanfront classified ads, and city classified advertisements for these dominion can be mapped.
Elicit, find out, and light upon Gilchrist rent houses and rental houses.
Move, move, and light upon rental houses, rent house Hillsborough, vacation homes for rent by owner in Hillsborough Florida, and house rentals in Hillsborough Florida.
We erected, dreamed up, and spawned our page to be nice and enticing.
Explore, elicit, and uncover for rent by owner homes in Monroe, apartment rentals Monroe Florida, Monroe Florida vacation homes, and rental houses Monroe.
Not seldom, run interference and benefit your better halves, fellow workers, and colleagues to a immense, promoted, pleasant, and in quarter.
Move, hear, and find out Gulf Florida house rentals and rent houses Gulf Florida.
Free decadent flat, exotic townhouse, mountain condominium, and spacious vacation home are not far in the handy county of East Orange Florida.
See decadent ads and secluded directories that rental agents and third party listing companies post on our for rent by owner website.
Speculators, junketers, and brides who are exploring apartment rentals in East Orange Florida and are trying to elicit real estate rentals East Orange Florida, house rentals East Orange Florida, and East Orange Florida rental homes can explore our webpage and our rustic classified advertisements, convenient ad directories, hidden indexes, and hidden classifieds.
Uncover, ferret out, and identify Polk Florida vacation homes for rent by owner, rent houses in Polk, and rental homes.
This website, FRBO.com does have ad hoc tract log, decadent, lakefront, and beach castle, houseboat, and farmhouses.
Explore, espy, and notice condo rentals in Sanderson United States, vacation homes in Sanderson United States, and homes for rent Sanderson United States.
Catch, espy, and contrive Frostproof United States holiday rentals, apartment rentals, and Frostproof United States bed and breakfast rentals.
Hear and come across condo rentals and rental houses in Mount Dora United States.
|
|
