|
<%@ 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
Rental houses in Northeast Tarrant and rental houses Northeast Tarrant Texas
Condo rentals in Burkburnett, vacation rentals, and home rentals in Burkburnett Texas
Bed and breakfast rentals, condo rentals Angleton-Rosharon, Angleton-Rosharon Texas for rent by owner homes, and Angleton-Rosharon Texas houses for rent
Georgetown-Round Rock Texas homes for rent and Georgetown-Round Rock Texas real estate rentals
Vacation homes in Springtown Texas, house rentals in Springtown Texas, and Springtown bed and breakfast rentals
West Brazos Texas house rentals, house rentals West Brazos Texas, West Brazos Texas rental properties, and rent house in West Brazos
Rental houses and Bryan-College Station Texas real estate rentals
Needville Texas apartments for rent, Needville Texas rental properties, and houses for rent Needville Texas
Holiday rentals, apartment rentals in El Paso Texas, El Paso Texas vacation homes for rent by owner, and rental apartment El Paso
Condos for rent Hebron Texas and vacation homes for rent by owner
Houses for rent in Waskom, vacation rental Waskom, and Waskom Texas short term rentals
For rent by owner homes in Justin-Roanoke, rental properties in Justin-Roanoke Texas, short term rentals in Justin-Roanoke Texas, and rent house in Justin-Roanoke Texas
Rent houses in Colony Texas and rental apartment
Homes for rent in New Braunfels Texas, rent houses New Braunfels, and rental apartment in New Braunfels Texas
Sweetwater house rentals, Sweetwater Texas rental houses, short term rentals Sweetwater, and vacation homes
Light upon and notice home rentals in Culberson and vacation rentals.
The Buna Texas listings docketed and manifested on our page have beach hacienda, exclusive house, rustic bungalow, and loft lodge.
See well appointed ads and log directories that third party agents and rental property owners post on FRBO.com.
Buna third party agents and rental owners list Buna Texas vacation homes for rent by owner, real estate rentals, and apartment rentals in Buna.
Design, uncover, and distinguish rental houses in Port Aransas, rent house in Port Aransas United States, and for rent by owner homes in Port Aransas United States.
Buna city employs many real estate investors, third party listing companies, brokers leasing foreclosures, and agents serving the condo market.
Discover and light upon Sterling City apartment rentals and Sterling City homes for rent by owner.
Detect and catch rent houses Cochran Texas and holiday rentals in Cochran Texas.
Originate and come upon rental apartment in Colmesneil United States and condos for rent Colmesneil United States.
Fraternity members and deadheads scour, look, and search for our webpage and identify romantic timeshare, spacious vacation home, and hidden lodge.
Using this webpage, real estate brokers manifest timeshare and villa classified advertisements.
Vacant lake flat, beach house, and log flat are nearly in the impending precinct of Buna Texas.
Catch, discover, and perceive apartment rentals Coleman Texas and home rentals Coleman Texas.
Observe and uncover bed and breakfast rentals in Fisher, Fisher Texas rent house, rental homes in Fisher Texas, and Fisher condos for rent.
Locate and explore apartments for rent Sterling and vacation rentals in Sterling Texas.
Espy various, diverse, strange, and uncommon scoop in Buna Texas and spell out Buna condos for rent.
Distinguish, locate, and devise Guadalupe Texas houses for rent, rental home, apartments for rent in Guadalupe Texas, and Guadalupe home rentals.
We phrased, discovered, and built our online website, FRBO.com to be fascinating, shapely, pretty, and classy.
Conceive, discover, and uncover homes for rent by owner Panna Maria, Panna Maria home rentals, and for rent by owner homes in Panna Maria United States.
Initiate, employ, and serve tomorrow morning to kick off, originate, and launch on this junket.
|
|
