Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-02T13:33:26.037' ,`MLSNumber` = '86528104' ,`ListAgentFullName` = 'Garry Bradford' ,`ListOfficeName` = 'Charles Michael Scherer' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.837923' ,`Longitude` = '-95.339231' ,`PhotoCount` = '7' ,`PostalCode` = '77093' ,`RoomCount` = '7' ,`ListPrice` = '329999.00' ,`Status` = 'Active' ,`StreetName` = 'Berry' ,`StreetNumber` = '3030' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1644' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'COMING FALL 2022.BEAUTIFUL 2 STORY SINGLE FAMILY HOME LIVING SPACE 1644SQ FT PLUS 2 CAR GARAGE FOR A TOTAL OF 2081 SQ.' ,`Acres` = '0.5383' ,`Area` = '9' ,`BuilderName` = 'bradford redelopment' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Space Heater' ,`HOAMandatory` = '0' ,`Legal` = 'TR 37 ABST 329 J T HARRELL' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '23450' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BERRY ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'KASHMERE HIGH SCHOOL' ,`SchoolMiddle` = 'PATRICK HENRY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Colonial' ,`Subdivision` = 'J T HARRELL SURV a-329' ,`TaxAmount` = '2849' ,`TaxRate` = '2.3994' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675086503' WHERE `Matrix_Unique_ID` = '202215993' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-02T13:11:10.010' ,`MLSNumber` = '16591470' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = 'Jerrice Bridges' ,`SellingOfficeName` = 'San Jacinto Properties' ,`Latitude` = '29.655882' ,`Longitude` = '-95.056279' ,`PhotoCount` = '17' ,`PostalCode` = '77571' ,`RoomCount` = '9' ,`ListPrice` = '363125.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Gonzalez Cove' ,`StreetNumber` = '2997' ,`StreetSuffix` = 'Drive' ,`City` = 'La Porte' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2207' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Settle into this lovely Beazer Home in Morgan’s Landing, boasting a brick façade, wood-look tile flooring, an open great room, and an extended covered patio. Whip up meals for guests in the kitchen, equipped with quartz countertops, mosaic backsplash, stainless steel appliances, pendant lighting, and under-counter lighting. Unwind in the tranquil primary suite featuring a walk-in closet, dual vanities, and a mud set shower. Located in La Porte, this community gives residents easy access to Kemah, the Houston Ship Channel, and Bay Area. Clear Lake and the Johnson Space Center are just minutes away! Morgan’s Landing’s amenities include a dog park, resort-style pool, pocket parks, lakes, and walking trails. Schools are zoned to La Porte ISD. Arrange your private showing today!' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 18 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'LOMAX ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Morgan\'s Landing' ,`TaxAmount` = '' ,`TaxRate` = '3.543251' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675086503' WHERE `Matrix_Unique_ID` = '208983254' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-02T13:04:15.173' ,`MLSNumber` = '60655380' ,`ListAgentFullName` = 'Bryan Roberts' ,`ListOfficeName` = 'Round Top Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.931123' ,`Longitude` = '-96.828511' ,`PhotoCount` = '33' ,`PostalCode` = '78945' ,`RoomCount` = '8' ,`ListPrice` = '1195000.00' ,`Status` = 'Active' ,`StreetName` = 'Forest Hill East' ,`StreetNumber` = '3555' ,`StreetSuffix` = 'Road' ,`City` = 'La Grange' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3499' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully landscaped, custom estate home located in the Forest Hills East Subdivision on 2.836 acres. Secluded outdoor spaces include a 50 ft x 10 ft covered porch, a waterfall which cascades into a koi pond, natural landscaping and an infinity edge pool. Constructed in 2009, the main house has almost 3,500 sf, with a garage apartment adding another 856 sf. The kitchen offers granite counter tops, a large island, upgraded appliances and walk-in pantry. Large windows in the kitchen/breakfast area allow outside views. Located off the breakfast room is an enormous screened-in porch with outdoor kitchen. The living/family room is expansive, fireplace and lighted built-ins. Two primary bedroom suites, each with a private walk-in closet and bathroom. An intimate bedroom/study/office with built-in desk, bookcases and cabinetry. The 1176 sf 3 car garage has storage galore. There is a self-contained apartment above the garage with kitchenette, desk area and full bath.' ,`Acres` = '2.836' ,`Area` = '69' ,`BuilderName` = 'Steven Kieschniek' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '0' ,`Legal` = 'FOREST HILLS EAST (637) LOT 5, 2.108 ACRES, HSE, GAR, POOL' ,`LotDesciption` = 'Corner,Subdivision Lot,Wooded' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '205 - La Grange' ,`SchoolElementary` = 'HERMES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA GRANGE HIGH SCHOOL' ,`SchoolMiddle` = 'LA GRANGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Forest Hills East 637' ,`TaxAmount` = '12406' ,`TaxRate` = '1.6209' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675086503' WHERE `Matrix_Unique_ID` = '211942941' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-02T13:24:18.227' ,`MLSNumber` = '34308863' ,`ListAgentFullName` = 'Claudia Cooper' ,`ListOfficeName` = 'City Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.113733' ,`Longitude` = '-95.085948' ,`PhotoCount` = '23' ,`PostalCode` = '77554' ,`RoomCount` = '8' ,`ListPrice` = '609900.00' ,`Status` = 'Active' ,`StreetName` = 'Sausalito' ,`StreetNumber` = '25115' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1386' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great views of the ocean from the front deck. 3 bedrooms, 3 full baths, sleeps 10. Cottage is well appointed with granite countertops and crown molding throughout. The patio area is equipped with a full bar, grill, big screen TV, private seating area, and more. Option: You can buy ALL of the contents on the property, including a 2021 Onward Club Car six passenger golf cart, for an additional amount. This option allows you to begin using or renting the property immediately. You can check out the property and reviews on VRBO - Connor\'s Cottage (property #2360443). Only received 5 stars reviews. Rental information available upon request.' ,`Acres` = '0.1413' ,`Area` = '33' ,`BuilderName` = 'Windward Homes, LLC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 HALL & JONES SUR LOT 8 BLK 2 LAGUNA SAN LUIS SUB' ,`LotDesciption` = 'Ravine,Subdivision Lot,Water View' ,`LotSize` = '6155' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Laguna San Luis 88' ,`TaxAmount` = '6197' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675086504' WHERE `Matrix_Unique_ID` = '212330621' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-02T14:31:42.517' ,`MLSNumber` = '75640171' ,`ListAgentFullName` = 'Jill Smith' ,`ListOfficeName` = 'Clark Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.216065' ,`Longitude` = '-95.315942' ,`PhotoCount` = '50' ,`PostalCode` = '77534' ,`RoomCount` = '9' ,`ListPrice` = '775900.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 210' ,`StreetNumber` = '15905' ,`StreetSuffix` = '' ,`City` = 'Danbury' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4580' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Extraordinary Custom Built 5 bdrm home on 3.74 acres with beautiful landscaping and palm tree lined drive.The stunning waterfall at the entrance will be a warm welcome as you arrive home to this amazing property.Open the doors to a grand dining area and elegant curved staircase. The well-equipped kitchen joins a large family room with a stunning view of the tree shaded back yard.The primary bedroom is a sanctuary all to it\'s own.Two walk-in closets, massive bath area with separate shower and jetted soaking tub. A first floor Guest Suite has full kitchen and bath.Upstairs boasts a huge media room, has 3 bdrs/2baths, kitchenette and balcony. Exterior features include a 40x50 barn/shop, fruit trees and patio and an almost 2 acre fully fenced backyard! The pond in back was designed with fishing and relaxing in mind. You\'ll enjoy spectacular sunrises and sunsets in this peaceful country setting. This magnificent home is just waiting for you to call it your own.' ,`Acres` = '3.749' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Danbury' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BAYOU OAKS (A0012 H AUSTIN ) BLK 2 LOT 10 ACRES 3.749' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '163306' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '15 - Danbury' ,`SchoolElementary` = 'DANBURY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DANBURY HIGH SCHOOL' ,`SchoolMiddle` = 'DANBURY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bayou Oaks' ,`TaxAmount` = '14529' ,`TaxRate` = '2.2192' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675086504' WHERE `Matrix_Unique_ID` = '213478441' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-02T14:25:23.700' ,`MLSNumber` = '92276717' ,`ListAgentFullName` = 'David Bridgwater' ,`ListOfficeName` = 'Joe Tramonte Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.294701' ,`Longitude` = '-94.792504' ,`PhotoCount` = '48' ,`PostalCode` = '77550' ,`RoomCount` = '11' ,`ListPrice` = '775000.00' ,`Status` = 'Active' ,`StreetName` = '25th' ,`StreetNumber` = '1512' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1716' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come add your family memories to the Alfred G. Youens House, circa 1904. This home has been lovingly cared for by the current owner and family since 1987. It has been the setting for numerous family reunions and weekend get-aways, and has been ground-zero for every Mardi Gras parade since owning the property. Rare side entrance accessed by the 7x21 front porch with matching balcony off the upstairs Primary Bedroom. Enter the Living Room overlooking the New Orleans-style courtyard with Boxwood-lined flowerbeds and view of historic Rosenberg St. The formal Dining Room will host all your holiday dinners and the spacious back yard will accommodate lawn parties for all occasions. Above the oversized 3-car garage is a lovely 2 bedroom renovated apartment (the original home) perfect for short-term or long-term income or for extended-stay overnight guests. This home is located in the Silk Stocking District of Galveston\'s Historic East End.' ,`Acres` = '0.1185' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR LOT 13 NW BLK 42 GALVESTON OUTLOTS S' ,`LotDesciption` = 'Other' ,`LotSize` = '5162' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Victorian' ,`Subdivision` = 'Galveston Outlots' ,`TaxAmount` = '9732' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1904' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675086504' WHERE `Matrix_Unique_ID` = '213580308' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-02T13:35:56.940' ,`MLSNumber` = '28378130' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Tri Pointe Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.719533' ,`Longitude` = '-95.871403' ,`PhotoCount` = '28' ,`PostalCode` = '77441' ,`RoomCount` = '5' ,`ListPrice` = '784415.00' ,`Status` = 'Active' ,`StreetName` = 'Windy' ,`StreetNumber` = '29006' ,`StreetSuffix` = 'Court' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3128' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Grandview floorplan - Gorgeous, one-story stone and brick open-concept home. Enter in from the porch and be greeted by the 8\' glass and mahogany front door. Create your perfect at-home office and enjoy the extra time at home. Entertain friends in the large great room with soaring vaulted ceilings and try out a new recipe in the gourmet kitchen with a central island. The kitchen features GE appliances, a double wall oven, 36\'\' built-in gas cooktop, white tile backsplash, and Silestone Quartz countertops. Easily flow your guests to the covered patio area and enjoy a refreshing drink. After a long day, unwind in the primary suite and soak in the garden-style tub, featuring two vanities, Silestone Quartz countertops, and large walk-in closets. This home showcases functionality with beautiful design finishes!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Tri Pointe Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '10/03/CT05' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '15015' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cross Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.33' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675086504' WHERE `Matrix_Unique_ID` = '214060019' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-02T13:30:34.893' ,`MLSNumber` = '94043348' ,`ListAgentFullName` = 'Juan Sanchez' ,`ListOfficeName` = 'Sendero Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.072393' ,`Longitude` = '-95.270219' ,`PhotoCount` = '50' ,`PostalCode` = '77365' ,`RoomCount` = '9' ,`ListPrice` = '345000.00' ,`Status` = 'Active' ,`StreetName` = 'Northpark Elm' ,`StreetNumber` = '19956' ,`StreetSuffix` = 'Lane' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2465' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Better than new, Modern farmhouse style new recently built home by Century Communities, plan 2466. Sought out floor plan with a great open concept living, light and bright, shows better than the model! Home sits on an oversized private lot with no rear neighbors, widened driveway built bold stylish with pavers, extended concrete backyard patio, built in generator, granite countertops throughout, tankless water heater, home automation powered by Google, and many more!' ,`Acres` = '0.2102' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S747100 - NORTHPARK WOODS 01, BLOCK 1, LOT 69' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '9157' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '660' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'BROOKWOOD FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WOODRIDGE FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Craftsman' ,`Subdivision` = 'Northpark Woods' ,`TaxAmount` = '9397' ,`TaxRate` = '3.6131' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675086505' WHERE `Matrix_Unique_ID` = '214537361' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-02T13:35:23.310' ,`MLSNumber` = '62872561' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Tri Pointe Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.719533' ,`Longitude` = '-95.871403' ,`PhotoCount` = '28' ,`PostalCode` = '77441' ,`RoomCount` = '9' ,`ListPrice` = '796308.00' ,`Status` = 'Active' ,`StreetName` = 'Ember Crest' ,`StreetNumber` = '28927' ,`StreetSuffix` = 'Lane' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3840' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this stunning two-story Bethel floorplan. Enter through the 42\'\' door into the foyer showcasing a grand staircase. The open concept floor plan is perfect for entertaining guests, with the kitchen overlooking the casual dining and great room. Relax in the primary suite with large walk-in closets, dual vanities, and a large freestanding tub. Luxury Vinyl Plank Flooring. Retreat upstairs to battle out a board game in the game room or watch your favorite movie in the cozy media room. Relax in the covered outdoor\r\nliving space and catch a sunset at your soon-to-be home!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Tri Pointe Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CT05/01/29' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11038' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cross Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.33' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675086505' WHERE `Matrix_Unique_ID` = '214655302' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-02T13:36:53.410' ,`MLSNumber` = '70477103' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Tri Pointe Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.719533' ,`Longitude` = '-95.871403' ,`PhotoCount` = '28' ,`PostalCode` = '77441' ,`RoomCount` = '5' ,`ListPrice` = '699246.00' ,`Status` = 'Active' ,`StreetName` = 'Creek Shore' ,`StreetNumber` = '4215' ,`StreetSuffix` = 'Lane' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3039' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Bartlett Floorplan - Welcome home to this stunning stucco and stone one-story floorplan with creek view. Enter from the covered porch into the foyer, with high ceilings. Save time on your commute and design your perfect at-home office space. Ideal for entertaining guests, head into the great room and gourmet kitchen and casual dining area. Try out a new recipe in your gourmet kitchen that features GE appliances, 36\" built-in gas cooktop, and Adamantium Gray cabinetry. Catch a beautiful sunrise or sunset under the extended outdoor patio at your brand new home. Make you way to the primary suite featuring dual canities and a large walk-in closet.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Tri Pointe Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '53/1/CT04' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8475' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cross Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.33' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675086505' WHERE `Matrix_Unique_ID` = '214948017' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-02T13:49:13.443' ,`MLSNumber` = '54187859' ,`ListAgentFullName` = 'Ingrid Philipson' ,`ListOfficeName` = 'Bellaire Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.743194' ,`Longitude` = '-95.612180' ,`PhotoCount` = '44' ,`PostalCode` = '77077' ,`RoomCount` = '9' ,`ListPrice` = '399456.00' ,`Status` = 'Active' ,`StreetName` = 'Paso Rello' ,`StreetNumber` = '2118' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2628' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning Home - A Side Front Porch Welcomes YOU to Spacious Elegant Foyer – Entryway w. Very High Ceilings w. Staircase leading to All Bedrooms Up - To the Right, Private Living Room w vaulted tray ceiling, 7 windows, Wood Oak Floor, Marble hearth by Gas Log Fireplace. – To the Left, Dining Room open to Den w Dramatic Stone Fireplace. - Open to Breakfast Room Open to Kitchen. – Kitchen w Stunning Granite Countertops & Stunning Slate Backsplash – Gas Stove – Double Oven – Truly the Kitchen for those who Love to cook & Entertain! - Large Master Suite w/2 sided Fireplace facing the Spacious Dramatic Master Bath w Super High Ceiling w Skylight above the Whirlpool - Travertine Shower – Antique cabinets sinks. – Three Bedrooms plus One Loft w. Closet – Extra Storage Space throughout & in Attic – Covered Back Patio – Storage Shed – Crape Myrtles – Jasmin - Sprinkler System – Come see this showcase home for yourself - Master Bedroom will have New flooring placed before closing. NEVER FLOODED.' ,`Acres` = '0.1148' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 27 BLK 1 BRIAR WOOD SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '552' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DAILY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Briar Wood Sec 01' ,`TaxAmount` = '6293' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675086505' WHERE `Matrix_Unique_ID` = '215079693' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215244552','1675086505','215244552','2022-12-02T13:44:09.953','29273963','Emily Wang','Intown Homes','','','29.665521','-95.400315','6','77045','4','540000.00','Active','Covent Garden','2027','Station','Houston','3','1','3','2788','Single-Family','*NEW CONSTRUCTION* -- Prime corner lot with direct WATER VIEW, facing a charming pond with fountain and open green space. This floorplan has Living / Kitchen / Dining on the 1st-floor, which is rare in the community! Large game room on top floor, which leads to a roof-terrace deck looking onto the water. Community amenities include manned-gated entrance, two ponds, swimming pool, walking paths, and pet stations. Home includes great energy efficient features - tankless water heater, radiant barrier, Trane A/C with separate zones per floor. Stainless-steel appliances with 5-burner cooktop (gas) and dedicated vent hood. Community is half-mile walk to MetroRail, which is very convenient for Homeowners who work in Medical Center or Downtown!','','18','InTown Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Medical Center Area','Central Gas,Zoned','1','Lot 13, Block 3','Corner,Subdivision Lot,Water View','','','','2880','1','To Be Built/Under Construction','2','Electric Oven','0','','','Gas Cooktop','','Composition','27 - Houston','HOBBY ELEMENTARY SCHOOL','MADISON HIGH SCHOOL (HOUSTON)','LAWSON MIDDLE SCHOOL','Appointment Required','Builder','3','Other Style','Fannin Station','','','Public Sewer,Public Water','2023','Builder'); --> New record created successfully