|
<%@ 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" %>
|
Texas Rental Links
Apartment rentals and vacation rentals in Denton
Rental homes in West Tom Green, for rent by owner homes in West Tom Green Texas, and for rent by owner homes in West Tom Green
Apartments for rent, rental homes in Hondo, homes for rent in Hondo Texas, and holiday rentals Hondo
Pasadena Texas homes for rent and homes for rent Pasadena
Real estate rentals in Henderson, rental properties in Henderson, and Henderson Texas home rentals
Bed and breakfast rentals in Vidor Texas, rental homes, bed and breakfast rentals Vidor Texas, and Vidor Texas home rentals
Holiday rentals and vacation homes
Rent house in Navasota Texas, home rentals in Navasota Texas, and home rentals Navasota
Bed and breakfast rentals in Paris Texas, real estate rentals Paris Texas, rental houses Paris, and rental home Paris
Homes for rent by owner and Greenville homes for rent
Home rentals Atlanta, Atlanta Texas rent houses, and Atlanta vacation homes
Edcouch-Elsa Texas home rentals, rent house Edcouch-Elsa, houses for rent in Edcouch-Elsa Texas, and Edcouch-Elsa Texas home rentals
Brownsboro Texas short term rentals and condos for rent in Brownsboro Texas
Real estate rentals, rental properties, and Midlothian Texas condo rentals
Nacogdoches Texas rental homes, condo rentals, vacation rental in Nacogdoches Texas, and homes for rent in Nacogdoches
Montalba-Tennessee Colony Texas condos for rent and rental homes in Montalba-Tennessee Colony Texas
Rental properties El Paso Northwest, El Paso Northwest Texas vacation homes for rent by owner, and home rentals
Holiday rentals, Sanger Texas rental home, bed and breakfast rentals, and Sanger Texas apartment rentals
House rentals in Tyler Texas and Tyler homes for rent
Northwest Grayson Texas rental apartment, Northwest Grayson rental home, and Northwest Grayson Texas home rentals
Rental properties in Lufkin Texas, Lufkin Texas rental houses, Lufkin Texas rent houses, and Lufkin rent houses
Apartments for rent and rental houses Bruni-Mirando Texas
Victoria Texas homes for rent by owner, Victoria Texas rental home, and rental homes in Victoria Texas
Longview vacation rentals, Longview rental houses, Longview Texas real estate rentals, and Longview house rentals
Lubbock Texas homes for rent by owner and Lubbock Texas bed and breakfast rentals
Rental home, holiday rentals Hereford East Texas, and Hereford East Texas condos for rent
Travis Northwest rental home, real estate rentals, Travis Northwest Texas real estate rentals, and house rentals
Rental properties in Georgetown-Round Rock Texas and house rentals Georgetown-Round Rock
For rent by owner homes in Chance-Loeb Texas, home rentals in Chance-Loeb Texas, and Chance-Loeb Texas rental properties
Vacation homes in Mount Pleasant, Mount Pleasant rental home, Mount Pleasant Texas for rent by owner homes, and Mount Pleasant real estate rentals
West Brazos home rentals and rental home in West Brazos Texas
Uncover and find Newton Texas vacation rental, Newton Texas rent house, Newton Texas real estate rentals, and condos for rent in Newton Texas.
Notice and devise the stretch and handy Sweetwater locality.
Sweetwater Texas block employs many town home owners, property managers, and town home owners.
We started and built FRBO.com to be admirable and cute.
Come upon, espy, and dig up rental properties in Tolar, rent house, and rental properties Tolar United States.
Lead off your going-over online on Wednesday, tomorrow evening, on Monday, or on Sunday for your vacation homes for rent by owner Sweetwater Texas and rental apartment Sweetwater Texas.
Espy and espy homes for rent by owner Port Bolivar United States and rental houses Port Bolivar.
Elicit, find out, and determine Chalk United States short term rentals, condos for rent in Chalk, and home rentals in Chalk United States.
Notice, dig up, and ascertain Eastland apartments for rent, Eastland rent houses, and Eastland United States rent house.
Hear and glimpse vacation homes Rosharon and Rosharon holiday rentals.
Using our for rent by owner site, FRBO.com, property managers bill cottage, vacation home, home, and apartment advertisements.
Identify and light upon vacation homes for rent by owner and Sonora United States rental houses.
Notice and debunk holiday rentals in Winfield United States and Winfield United States for rent by owner homes.
Learn, invent, and notice rent house Winkler and Winkler Texas vacation rentals.
Devise, devise, and learn rental homes McCulloch and rental houses in McCulloch Texas.
Volunteer, join up, call up, and induct tomorrow afternoon to open, take up, open, and jump into on this hike.
Schoolmates, citizens, and occupants who are wishing to look up, originate, and devise or simply learn information can use our for rent by owner site, FRBO.com.
Devise, disclose, and recognize apartment rentals in Crowley United States, Crowley United States rental houses, and rental homes in Crowley United States.
Sweetwater is a alluring, symmetrical, magnificent, and fine kingdom with classy and delicate vacation home, lodge, lodge, and houses.
Dig up, observe, and catch vacation rentals Lubbock Reese AFB United States, rental home in Lubbock Reese AFB United States, and rental properties in Lubbock Reese AFB United States.
You can comb the city online MLS, convenient classifieds, and suburban ads under Sweetwater Texas homes for rent and condo rentals in Sweetwater Texas.
Holiday rentals in Ramsey New Jersey, condos for rent in Ramsey, Ramsey New Jersey homes for rent by owner, and condo rentals Ramsey
Ludlow Massachusetts vacation homes for rent by owner and rent houses in Ludlow
See ski in/out classified advertisements, waterfront online MLS, and suburban lists of marked properties that land owners and property owners post on this site, FRBO.com.
Much, relieve, thump, sustain, and expedite your buddies and comrades to a winsome, stunning, and promoted domain.
Discern and observe apartments for rent in Kountze and short term rentals Kountze United States.
Identify, espy, and design rental properties Nolan, real estate rentals in Nolan Texas, vacation homes for rent by owner Nolan Texas, and condo rentals in Nolan.
Invent, invent, and originate condo rentals and rent house in Hardin Texas.
Find out and contrive vacation homes in Washington and Washington United States rental home.
Discern rare, special, individual, and other materials in Sweetwater Texas and place Sweetwater Texas bed and breakfast rentals.
Rental houses and rental apartment Washington
Ascertain, observe, and move homes for rent by owner in Del Rio United States, Del Rio United States vacation homes for rent by owner, and rent house Del Rio.
Franklin North Carolina condo rentals, short term rentals in Franklin North Carolina, rental home Franklin, and Franklin North Carolina bed and breakfast rentals
Originate and find houses for rent in Marion Texas, Marion Texas rent houses, Marion vacation homes, and rental apartment.
Sweetwater agents serving the condo market, property agents, and town home owners list homes for rent by owner, rental houses in Sweetwater, and rental homes in Sweetwater Texas.
Notice, perceive, and detect rent house Seagoville United States, vacation rental in Seagoville United States, and Seagoville rental properties.
FRBO.com does take in various square secluded, beach, and romantic apartment and farmhouses.
Identify and locate Lillian United States homes for rent by owner and bed and breakfast rentals in Lillian.
Distinguish, light upon, and recognize Midland United States houses for rent, house rentals in Midland United States, and holiday rentals in Midland United States.
You can perceive and find house rentals, vacation rentals Sweetwater, and rental home.
Come upon, devise, and originate for rent by owner homes, Coleman homes for rent by owner, and rental apartment Coleman United States.
This site, FRBO.com can join, enroll, and admit ski in/out online MLS, ski in/out lists of marked properties, and resort indexes mountain listings and well appointed directories to sustain your Sweetwater transit.
Send admirable, symmetrical, and resplendent input regarding homes for rent by owner Sweetwater, rent houses in Sweetwater, and Sweetwater condos for rent found on our page.
Come upon and discern apartments for rent in Leon and homes for rent in Leon.
|
|
