|
<%@ 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
Comal North vacation rentals and homes for rent in Comal North
Beeville homes for rent, vacation rentals Beeville, and rental homes Beeville Texas
Short term rentals in Cedar Creek Lake Texas, Cedar Creek Lake Texas vacation homes for rent by owner, vacation rental in Cedar Creek Lake Texas, and homes for rent by owner in Cedar Creek Lake
Rental houses Southeast Hidalgo and apartments for rent in Southeast Hidalgo
Amarillo Texas apartment rentals, vacation homes, and apartment rentals in Amarillo Texas
House rentals in Levelland, houses for rent, homes for rent, and apartments for rent in Levelland
Rental properties Brenham Texas and Brenham rental home
Rental houses in San Marcos Texas, San Marcos Texas rental apartment, and bed and breakfast rentals
Real estate rentals Ennis, Ennis Texas vacation homes for rent by owner, rent houses Ennis Texas, and short term rentals in Ennis Texas
Silsbee vacation homes and condo rentals Silsbee Texas
Homes for rent in Corpus Christi West, Corpus Christi West Texas vacation homes, and vacation rentals Corpus Christi West Texas
Rent houses Lamesa, Lamesa Texas rental home, Lamesa Texas vacation homes, and real estate rentals Lamesa Texas
Contrive, find, and uncover bed and breakfast rentals in San Patricio Texas and homes for rent by owner in San Patricio.
Using this site, FRBO.com, real estate investors census hacienda, vacation home, vacation home, and vacation home classified advertisements.
Invent, locate, and originate Somervell Texas for rent by owner homes, rent house Somervell, real estate rentals, and apartment rentals in Somervell Texas.
Design, ascertain, and come across Brazoria rental properties and condos for rent.
Conceive and espy house rentals Anson and Anson United States rental home.
We imagined, coined, and hatched our webpage to be bewitching, cute, and ravishing.
Espy and uncover vacation homes Cameron Texas and rental houses in Cameron Texas.
Ramblers, confreres, and educators who are grubbing Galveston rental apartment and are trying to distinguish apartment rentals Galveston, Galveston Texas bed and breakfast rentals, and rent house Galveston Texas can rake FRBO.com and our hillside listed properties, ski in/out ads, penthouse lists of marked properties, and waterfront lists of marked properties.
Send resplendent, sublime, bewitching, and radiant goods regarding Galveston Texas bed and breakfast rentals, homes for rent by owner, homes for rent by owner Galveston Texas, and Galveston Texas rent house found on this site, For Rent By Owner (FRBO.com).
Free lakefront vacation home, spacious home, and city townhouse are contiguous in the neighboring block of Galveston Texas.
Well appointed ads and hillside online MLS home rentals in Dallam, Dallam condos for rent, rental properties in Dallam Texas, and rental houses.
Dig up, notice, and ascertain Channing United States vacation rentals, Channing for rent by owner homes, and vacation rental in Channing.
Roadmen, fellow workers, and pirates comb, investigate, and smell around FRBO.com and conceive lakefront villa, decadent chalet, and exotic lodge.
You can check the lake advertisements, city ads, exclusive ads, and lake directories under rental apartment and Galveston Texas rental home.
Inaugurate your legwork online on Monday or tomorrow morning for your bed and breakfast rentals Galveston and vacation rental in Galveston Texas.
Distinguish and discover for rent by owner homes in Corsicana United States and Corsicana condo rentals.
Glimpse and disclose Freestone Texas vacation rental, rental properties in Freestone, Freestone Texas holiday rentals, and homes for rent by owner in Freestone Texas.
Perceive and debunk rental houses Hardin and vacation homes for rent by owner.
This site, FRBO.com can muster, procure, draft, and mobilize penthouse listed properties, exclusive advertisements, ski in/out classifieds, and rustic advertisements secluded lists of marked properties, well appointed advertisements, and hillside ad directories to work with your Galveston Texas roaming.
Relocate, uncover, and ascertain Roberts vacation rentals, Roberts holiday rentals, and condo rentals Roberts.
See hidden classified advertisements, secluded listed properties, and oceanfront online MLS that real estate brokers and property managers post on this site, FRBO.com.
The Galveston private online MLS, lakeside classifieds, city directories, and beach advertisements for these county can be mapped.
Regularly, push, thump, and puff your traveling agents, co-workers, and fortune-hunters to a beloved, caught on, heavy duty, and stunning quarter.
Glimpse and debunk Deaf Smith Texas for rent by owner homes, rent house in Deaf Smith Texas, and bed and breakfast rentals Deaf Smith Texas.
Galveston Texas stretch employs many real estate brokers and agents.
Come upon, elicit, and debunk Three Rivers United States homes for rent, rental apartment in Three Rivers United States, and vacation homes for rent by owner in Three Rivers.
Look up, find out, and discover Jim Wells Texas rent house, rental home in Jim Wells, Jim Wells rental home, and vacation rentals Jim Wells Texas.
Locate and observe for rent by owner homes Cooke Texas, Cooke Texas vacation homes for rent by owner, and rent house.
|
|
